View: PA_ACCUM_WBS_ACT_V

Product:	PA - Projects
Description:	A reporting view that shows actual cost and revenue totals for projects and tasks
Implementation/DBA Data:	APPS.PA_ACCUM_WBS_ACT_V

View Text

SELECT PAH.PROJECT_ID
, P.SEGMENT1
, P.NAME
, PAH.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, LPAD(' '
, 2 * (T.WBS_LEVEL - 1))||T.TASK_NUMBER
, LPAD(' '
, 2 * (T.WBS_LEVEL - 1))||T.TASK_NAME
, T.WBS_LEVEL
, T.START_DATE
, T.COMPLETION_DATE
, T.TASK_MANAGER_PERSON_ID
, PER.FULL_NAME
, NVL(PAA.RAW_COST_ITD
, 0)
, NVL(PAA.RAW_COST_YTD
, 0)
, NVL(PAA.RAW_COST_PP
, 0)
, NVL(PAA.RAW_COST_PTD
, 0)
, NVL(PAA.BILLABLE_RAW_COST_ITD
, 0)
, NVL(PAA.BILLABLE_RAW_COST_YTD
, 0)
, NVL(PAA.BILLABLE_RAW_COST_PP
, 0)
, NVL(PAA.BILLABLE_RAW_COST_PTD
, 0)
, NVL(PAA.BURDENED_COST_ITD
, 0)
, NVL(PAA.BURDENED_COST_YTD
, 0)
, NVL(PAA.BURDENED_COST_PP
, 0)
, NVL(PAA.BURDENED_COST_PTD
, 0)
, NVL(PAA.BILLABLE_BURDENED_COST_ITD
, 0)
, NVL(PAA.BILLABLE_BURDENED_COST_YTD
, 0)
, NVL(PAA.BILLABLE_BURDENED_COST_PP
, 0)
, NVL(PAA.BILLABLE_BURDENED_COST_PTD
, 0)
, NVL(PAA.LABOR_HOURS_ITD
, 0)
, NVL(PAA.LABOR_HOURS_YTD
, 0)
, NVL(PAA.LABOR_HOURS_PP
, 0)
, NVL(PAA.LABOR_HOURS_PTD
, 0)
, NVL(PAA.BILLABLE_LABOR_HOURS_ITD
, 0)
, NVL(PAA.BILLABLE_LABOR_HOURS_YTD
, 0)
, NVL(PAA.BILLABLE_LABOR_HOURS_PP
, 0)
, NVL(PAA.BILLABLE_LABOR_HOURS_PTD
, 0)
, NVL(PAA.REVENUE_ITD
, 0)
, NVL(PAA.REVENUE_YTD
, 0)
, NVL(PAA.REVENUE_PP
, 0)
, NVL(PAA.REVENUE_PTD
, 0)
FROM PA_PROJECTS P
, PA_TASKS T
, PER_PEOPLE_F PER
, PA_PROJECT_ACCUM_HEADERS PAH
, PA_PROJECT_ACCUM_ACTUALS PAA
WHERE P.PROJECT_ID = PAH.PROJECT_ID
AND PAH.TASK_ID >= 0
AND PAH.RESOURCE_LIST_ID = 0
AND PAH.PROJECT_ACCUM_ID = PAA.PROJECT_ACCUM_ID
AND PAH.TASK_ID = T.TASK_ID (+)
AND T.TASK_MANAGER_PERSON_ID = PER.PERSON_ID (+)
AND TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE (+)
AND PER.EFFECTIVE_END_DATE (+)

Columns