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: PA_STATUS_PROJ_BGT_REV_V

Product:	PA - Projects
Description:	10SC Only
Implementation/DBA Data:	APPS.PA_STATUS_PROJ_BGT_REV_V

View Text

SELECT PAH.PROJECT_ID
, PA_STATUS.GETREVBGTCODE
, NVL(PAB.BASE_REVENUE_ITD
, 0)
, NVL(PAB.BASE_REVENUE_YTD
, 0)
, NVL(PAB.BASE_REVENUE_PP
, 0)
, NVL(PAB.BASE_REVENUE_PTD
, 0)
, NVL(PAB.ORIG_REVENUE_ITD
, 0)
, NVL(PAB.ORIG_REVENUE_YTD
, 0)
, NVL(PAB.ORIG_REVENUE_PP
, 0)
, NVL(PAB.ORIG_REVENUE_PTD
, 0)
, NVL(PAB.ORIG_LABOR_HOURS_ITD
, 0)
, NVL(PAB.ORIG_LABOR_HOURS_YTD
, 0)
, NVL(PAB.ORIG_LABOR_HOURS_PP
, 0)
, NVL(PAB.ORIG_LABOR_HOURS_PTD
, 0)
, NVL(PAB.BASE_LABOR_HOURS_ITD
, 0)
, NVL(PAB.BASE_LABOR_HOURS_YTD
, 0)
, NVL(PAB.BASE_LABOR_HOURS_PP
, 0)
, NVL(PAB.BASE_LABOR_HOURS_PTD
, 0)
, NVL(PAB.BASE_REVENUE_TOT
, 0)
, NVL(PAB.ORIG_REVENUE_TOT
, 0)
, NVL(PAB.ORIG_LABOR_HOURS_TOT
, 0)
, NVL(PAB.BASE_LABOR_HOURS_TOT
, 0)
FROM PA_PROJECT_ACCUM_BUDGETS PAB
, PA_PROJECT_ACCUM_HEADERS PAH
, PA_PROJECTS P
WHERE P.PROJECT_ID = PAH.PROJECT_ID
AND PAH.TASK_ID = 0
AND PAH.RESOURCE_LIST_ID = 0
AND PAH.PROJECT_ACCUM_ID = PAB.PROJECT_ACCUM_ID (+)
AND PAB.BUDGET_TYPE_CODE (+) = PA_STATUS.GETREVBGTCODE

Columns

Name
PROJECT_ID
BUDGET_TYPE_CODE
BASELINE_REVENUE_ITD
BASELINE_REVENUE_YTD
BASELINE_REVENUE_PP
BASELINE_REVENUE_PTD
ORIGINAL_REVENUE_ITD
ORIGINAL_REVENUE_YTD
ORIGINAL_REVENUE_PP
ORIGINAL_REVENUE_PTD
ORIGINAL_LABOR_HOURS_ITD
ORIGINAL_LABOR_HOURS_YTD
ORIGINAL_LABOR_HOURS_PP
ORIGINAL_LABOR_HOURS_PTD
BASELINE_LABOR_HOURS_ITD
BASELINE_LABOR_HOURS_YTD
BASELINE_LABOR_HOURS_PP
BASELINE_LABOR_HOURS_PTD
BASELINE_REVENUE_TOT
ORIGINAL_REVENUE_TOT
ORIGINAL_LABOR_HOURS_TOT
BASELINE_LABOR_HOURS_TOT