View: PA_STATUS_TASK_CMT_V

Product:	PA - Projects
Description:	10SC Only
Implementation/DBA Data:	APPS.PA_STATUS_TASK_CMT_V

View Text

SELECT PAH.PROJECT_ID
, PAH.TASK_ID
, NVL(PAC.CMT_RAW_COST_ITD
, 0)
, NVL(PAC.CMT_RAW_COST_YTD
, 0)
, NVL(PAC.CMT_RAW_COST_PP
, 0)
, NVL(PAC.CMT_RAW_COST_PTD
, 0)
, NVL(PAC.CMT_BURDENED_COST_ITD
, 0)
, NVL(PAC.CMT_BURDENED_COST_YTD
, 0)
, NVL(PAC.CMT_BURDENED_COST_PP
, 0)
, NVL(PAC.CMT_BURDENED_COST_PTD
, 0)
, NVL(PAC.CMT_QUANTITY_ITD
, 0)
, NVL(PAC.CMT_QUANTITY_YTD
, 0)
, NVL(PAC.CMT_QUANTITY_PP
, 0)
, NVL(PAC.CMT_QUANTITY_PTD
, 0)
FROM PA_PROJECT_ACCUM_HEADERS PAH
, PA_PROJECT_ACCUM_COMMITMENTS PAC
WHERE PAH.TASK_ID > 0
AND PAH.PROJECT_ID = PA_STATUS.GETPROJID
AND PAH.RESOURCE_LIST_ID = 0
AND PAH.PROJECT_ACCUM_ID = PAC.PROJECT_ACCUM_ID

Columns