SELECT cdl.project_id, ei.capital_event_id, cdl.line_type, sum(cdl.amount) cdl_amount, sum(cdl.burdened_cost) cdl_burdened_cost from pa_cost_distribution_lines_all cdl, pa_expenditure_items_all ei WHERE ei.expenditure_item_id = cdl.expenditure_item_id and ei.capital_event_id is not null group by cdl.project_id, ei.capital_event_id, cdl.line_type
SELECT CDL.PROJECT_ID
, EI.CAPITAL_EVENT_ID
, CDL.LINE_TYPE
, SUM(CDL.AMOUNT) CDL_AMOUNT
, SUM(CDL.BURDENED_COST) CDL_BURDENED_COST
FROM PA_COST_DISTRIBUTION_LINES_ALL CDL
, PA_EXPENDITURE_ITEMS_ALL EI
WHERE EI.EXPENDITURE_ITEM_ID = CDL.EXPENDITURE_ITEM_ID
AND EI.CAPITAL_EVENT_ID IS NOT NULL GROUP BY CDL.PROJECT_ID
, EI.CAPITAL_EVENT_ID
, CDL.LINE_TYPE
|
|
|