View: PA_PROJ_CCREV_COST_V

Product:	PA - Projects
Description:	PA_PROJ_CCREV_COST_V is a view that summarizes the burdened cost for use in cost-to-cost revenue calculation.
Implementation/DBA Data:	APPS.PA_PROJ_CCREV_COST_V

View Text

SELECT TA.PROJECT_ID PROJECT_ID
, T.TOP_TASK_ID TASK_ID
, NVL(TA.TOT_BURDENED_COST
, NVL(TA.TOT_RAW_COST
, 0)) + NVL(TA.I_TOT_BURDENED_COST
, NVL(I_TOT_RAW_COST
, 0)) BURDENED_COST
, PP.START_DATE PA_START_DATE
, PP.END_DATE PA_END_DATE
FROM PA_TXN_ACCUM TA
, PA_TASKS T
, PA_PERIODS PP
WHERE TA.TASK_ID = T.TASK_ID
AND PP.PERIOD_NAME = TA.PA_PERIOD UNION ALL SELECT T.PROJECT_ID PROJECT_ID
, T.TOP_TASK_ID TASK_ID
, (NVL((CDL.BURDENED_COST + NVL(PROJECT_BURDENED_CHANGE
, 0))
, NVL(CDL.AMOUNT
, 0))) BURDENED_COST
, PP.START_DATE PA_START_DATE
, PP.END_DATE PA_END_DATE
FROM PA_COST_DISTRIBUTION_LINES_ALL CDL
, PA_TASKS T
, PA_PERIODS PP
WHERE CDL.PROJECT_ID = T.PROJECT_ID
AND CDL.TASK_ID = T.TASK_ID
AND CDL.PA_DATE BETWEEN PP.START_DATE
AND PP.END_DATE
AND CDL.RESOURCE_ACCUMULATED_FLAG = 'N'
AND CDL.LINE_TYPE = 'R'

Columns