View: PJI_ACCUM_WBS_ACT_V

Product:	PJI - Project Intelligence(Obsolete)
Description:
Implementation/DBA Data:	APPS.PJI_ACCUM_WBS_ACT_V

View Text

SELECT ACT.PROJECT_ID
, ACT.TASK_ID TASK_ID
, ACT.RAW_COST_ITD RAW_COST
, ACT.BURDENED_COST_ITD BURDENED_COST
, ACT.REVENUE_ITD REVENUE
FROM PA_ACCUM_WBS_ACT_V ACT
, PA_PROJECTS_ALL PRJ
WHERE ACT.PROJECT_ID=PRJ.PROJECT_ID
AND PJI_SOURCE_FLAG IS NULL UNION ALL SELECT TMP.PROJECT_ID
, TMP.PROJECT_ELEMENT_ID TASK_ID
, TMP.POU_RAW_COST RAW_COST
, TMP.POU_BRDN_COST BURDENED_COST
, TMP.POU_REVENUE REVENUE
FROM PJI_FM_XBS_ACCUM_TMP1 TMP
, PA_PROJECTS_ALL PRJ
WHERE TMP.PROJECT_ID=PRJ.PROJECT_ID
AND PJI_SOURCE_FLAG = 'Y'

Columns