View: PABV_PRJ_RESOURCE_ACT_SUMMARY

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PABV_PRJ_RESOURCE_ACT_SUMMARY

View Text

SELECT PAH.PROJECT_ACCUM_ID
, PAPS.ACCUM_PERIOD
, PAA.RAW_COST_ITD
, PAA.RAW_COST_YTD
, PAA.RAW_COST_PP
, PAA.RAW_COST_PTD
, PAA.BILLABLE_RAW_COST_ITD
, PAA.BILLABLE_RAW_COST_YTD
, PAA.BILLABLE_RAW_COST_PP
, PAA.BILLABLE_RAW_COST_PTD
, PAA.BURDENED_COST_ITD
, PAA.BURDENED_COST_YTD
, PAA.BURDENED_COST_PP
, PAA.BURDENED_COST_PTD
, PAA.BILLABLE_BURDENED_COST_ITD
, PAA.BILLABLE_BURDENED_COST_YTD
, PAA.BILLABLE_BURDENED_COST_PP
, PAA.BILLABLE_BURDENED_COST_PTD
, PAA.QUANTITY_ITD
, PAA.QUANTITY_YTD
, PAA.QUANTITY_PP
, PAA.QUANTITY_PTD
, PAA.LABOR_HOURS_ITD
, PAA.LABOR_HOURS_YTD
, PAA.LABOR_HOURS_PP
, PAA.LABOR_HOURS_PTD
, PAA.BILLABLE_QUANTITY_ITD
, PAA.BILLABLE_QUANTITY_YTD
, PAA.BILLABLE_QUANTITY_PP
, PAA.BILLABLE_QUANTITY_PTD
, PAA.BILLABLE_LABOR_HOURS_ITD
, PAA.BILLABLE_LABOR_HOURS_YTD
, PAA.BILLABLE_LABOR_HOURS_PP
, PAA.BILLABLE_LABOR_HOURS_PTD
, PAA.REVENUE_ITD
, PAA.REVENUE_YTD
, PAA.REVENUE_PP
, PAA.REVENUE_PTD
, '_LA:PAA.TXN_UNIT_OF_MEASURE:PA_LOOKUPS:UNIT:MEANING'
, PAH.PROJECT_ID
, PAH.RESOURCE_LIST_ID
, PAH.RESOURCE_LIST_ASSIGNMENT_ID
, PAH.RESOURCE_LIST_MEMBER_ID
, PAH.RESOURCE_ID
, PAA.LAST_UPDATE_DATE
, PAA.LAST_UPDATED_BY
, PAA.CREATION_DATE
, PAA.CREATED_BY
FROM PA_PROJECT_ACCUM_ACTUALS PAA
, PA_PROJECT_ACCUM_HEADERS PAH
, PA_PRJ_ACCUM_PERIODS_V PAPS
, PA_PROJECTS_ALL PPA
WHERE PAA.PROJECT_ACCUM_ID = PAH.PROJECT_ACCUM_ID AND PAH.TASK_ID = 0
AND PAH.RESOURCE_LIST_MEMBER_ID > 0 AND PAH.PROJECT_ID = PAPS.PROJECT_ID
AND PAH.PROJECT_ID = PPA.PROJECT_ID
AND '_SEC:PPA.ORG_ID' IS NOT NULL WITH READ ONLY

Columns