eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PABV_PRJ_RESOURCE_BGT_SUMMARY

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

View Text

SELECT PAH.PROJECT_ACCUM_ID
, PAB.BUDGET_TYPE_CODE
, PAPS.ACCUM_PERIOD
, PAB.BASE_RAW_COST_ITD
, PAB.BASE_RAW_COST_YTD
, PAB.BASE_RAW_COST_PP
, PAB.BASE_RAW_COST_PTD
, PAB.BASE_BURDENED_COST_ITD
, PAB.BASE_BURDENED_COST_YTD
, PAB.BASE_BURDENED_COST_PP
, PAB.BASE_BURDENED_COST_PTD
, PAB.ORIG_RAW_COST_ITD
, PAB.ORIG_RAW_COST_YTD
, PAB.ORIG_RAW_COST_PP
, PAB.ORIG_RAW_COST_PTD
, PAB.ORIG_BURDENED_COST_ITD
, PAB.ORIG_BURDENED_COST_YTD
, PAB.ORIG_BURDENED_COST_PP
, PAB.ORIG_BURDENED_COST_PTD
, PAB.BASE_REVENUE_ITD
, PAB.BASE_REVENUE_YTD
, PAB.BASE_REVENUE_PP
, PAB.BASE_REVENUE_PTD
, PAB.ORIG_REVENUE_ITD
, PAB.ORIG_REVENUE_YTD
, PAB.ORIG_REVENUE_PP
, PAB.ORIG_REVENUE_PTD
, PAB.ORIG_LABOR_HOURS_ITD
, PAB.ORIG_LABOR_HOURS_YTD
, PAB.ORIG_LABOR_HOURS_PP
, PAB.ORIG_LABOR_HOURS_PTD
, PAB.BASE_LABOR_HOURS_ITD
, PAB.BASE_LABOR_HOURS_YTD
, PAB.BASE_LABOR_HOURS_PP
, PAB.BASE_LABOR_HOURS_PTD
, PAB.ORIG_QUANTITY_YTD
, PAB.ORIG_QUANTITY_ITD
, PAB.ORIG_QUANTITY_PP
, PAB.ORIG_QUANTITY_PTD
, PAB.BASE_QUANTITY_YTD
, PAB.BASE_QUANTITY_ITD
, PAB.BASE_QUANTITY_PP
, PAB.BASE_QUANTITY_PTD
, PAB.ORIG_LABOR_HOURS_TOT
, PAB.BASE_LABOR_HOURS_TOT
, PAB.ORIG_QUANTITY_TOT
, PAB.BASE_QUANTITY_TOT
, PAB.BASE_RAW_COST_TOT
, PAB.BASE_BURDENED_COST_TOT
, PAB.ORIG_RAW_COST_TOT
, PAB.ORIG_BURDENED_COST_TOT
, PAB.BASE_REVENUE_TOT
, PAB.ORIG_REVENUE_TOT
, '_LA:PAB.BASE_UNIT_OF_MEASURE:PA_LOOKUPS:UNIT:MEANING'
, '_LA:PAB.ORIG_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
, PAB.LAST_UPDATE_DATE
, PAB.LAST_UPDATED_BY
, PAB.CREATION_DATE
, PAB.CREATED_BY
FROM PA_PROJECT_ACCUM_BUDGETS PAB
, PA_PROJECT_ACCUM_HEADERS PAH
, PA_PRJ_ACCUM_PERIODS_V PAPS
, PA_PROJECTS_ALL PPA
WHERE PAB.PROJECT_ACCUM_ID = PAH.PROJECT_ACCUM_ID AND PAH.PROJECT_ID = PAPS.PROJECT_ID
AND PAH.PROJECT_ID = PPA.PROJECT_ID AND PAH.TASK_ID = 0
AND PAH.RESOURCE_LIST_MEMBER_ID > 0
AND '_SEC:PPA.ORG_ID' IS NOT NULL WITH READ ONLY

Columns

Name
PROJECT_ACCUM_ID
BUDGET_TYPE_CODE
ACCUM_PERIOD
BASE_RAW_COST_ITD
BASE_RAW_COST_YTD
BASE_RAW_COST_PP
BASE_RAW_COST_PTD
BASE_BURDENED_COST_ITD
BASE_BURDENED_COST_YTD
BASE_BURDENED_COST_PP
BASE_BURDENED_COST_PTD
ORIG_RAW_COST_ITD
ORIG_RAW_COST_YTD
ORIG_RAW_COST_PP
ORIG_RAW_COST_PTD
ORIG_BURDENED_COST_ITD
ORIG_BURDENED_COST_YTD
ORIG_BURDENED_COST_PP
ORIG_BURDENED_COST_PTD
BASE_REVENUE_ITD
BASE_REVENUE_YTD
BASE_REVENUE_PP
BASE_REVENUE_PTD
ORIG_REVENUE_ITD
ORIG_REVENUE_YTD
ORIG_REVENUE_PP
ORIG_REVENUE_PTD
ORIG_LABOR_HOURS_ITD
ORIG_LABOR_HOURS_YTD
ORIG_LABOR_HOURS_PP
ORIG_LABOR_HOURS_PTD
BASE_LABOR_HOURS_ITD
BASE_LABOR_HOURS_YTD
BASE_LABOR_HOURS_PP
BASE_LABOR_HOURS_PTD
ORIG_QUANTITY_YTD
ORIG_QUANTITY_ITD
ORIG_QUANTITY_PP
ORIG_QUANTITY_PTD
BASE_QUANTITY_YTD
BASE_QUANTITY_ITD
BASE_QUANTITY_PP
BASE_QUANTITY_PTD
ORIG_LABOR_HOURS_TOT
BASE_LABOR_HOURS_TOT
ORIG_QUANTITY_TOT
BASE_QUANTITY_TOT
BASE_RAW_COST_TOT
BASE_BURDENED_COST_TOT
ORIG_RAW_COST_TOT
ORIG_BURDENED_COST_TOT
BASE_REVENUE_TOT
ORIG_REVENUE_TOT
"_LA:BASE_UNIT_OF_MEASURE"
"_LA:ORIG_UNIT_OF_MEASURE"
PROJECT_ID
RESOURCE_LIST_ID
RESOURCE_LIST_ASSIGNMENT_ID
RESOURCE_LIST_MEMBER_ID
RESOURCE_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY