VIEW: APPS.PA_STATUS_TASK_ACT_V

Source

View Text - Preformatted

SELECT PAH.PROJECT_ID , PAH.TASK_ID , 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_PROJECT_ACCUM_HEADERS PAH , PA_PROJECT_ACCUM_ACTUALS PAA WHERE PAH.TASK_ID > 0 AND PAH.PROJECT_ID = PA_STATUS.GETPROJID AND PAH.RESOURCE_LIST_ID = 0 AND PAH.PROJECT_ACCUM_ID = PAA.PROJECT_ACCUM_ID

View Text - HTML Formatted

SELECT PAH.PROJECT_ID
, PAH.TASK_ID
, 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_PROJECT_ACCUM_HEADERS PAH
, PA_PROJECT_ACCUM_ACTUALS PAA
WHERE PAH.TASK_ID > 0
AND PAH.PROJECT_ID = PA_STATUS.GETPROJID
AND PAH.RESOURCE_LIST_ID = 0
AND PAH.PROJECT_ACCUM_ID = PAA.PROJECT_ACCUM_ID