SELECT parent_COST_CENTER_ID,COST_CENTER_ID,sum(parent_price) parent_price,lVL
FROM(
SELECT parent_COST_CENTER_ID,COST_CENTER_ID,
(TOTAL_ACTUAL_DEBIT) parent_price,lVL
FROM COST_JOURNALTREES
WHERE BRANCH_ID = 216
) t
GROUP BY parent_COST_CENTER_ID,COST_CENTER_ID,LVL
/
FROM(
SELECT parent_COST_CENTER_ID,COST_CENTER_ID,
(TOTAL_ACTUAL_DEBIT) parent_price,lVL
FROM COST_JOURNALTREES
WHERE BRANCH_ID = 216
) t
GROUP BY parent_COST_CENTER_ID,COST_CENTER_ID,LVL
/
select DISTINCT
connect_by_root parent_COST_CENTER_ID rootParent,
PARENT_SUM,
COST_CENTER_ID,
TOTAL_ACTUAL_DEBIT,
prior TOTAL_ACTUAL_DEBIT prior_TOTAL_ACTUAL_DEBIT,
level lvl
FROM
COST_JOURNALTREES
WHERE BRANCH_ID = 216 --AND cost_center_id = 407--IN (427,409,407)
START WITH PARENT_COST_CENTER_ID IS NOT NULL
connect by prior COST_CENTER_ID = parent_COST_CENTER_ID
/
No comments:
Post a Comment