View: PA_CAP_EVENTS_CDL_COST_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_CAP_EVENTS_CDL_COST_V

View Text

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

Columns