View: PA_STATUS_TASK_BGT_REV_HIGH_V

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

View Text

SELECT STBR.PROJECT_ID
, STBR.TASK_ID
, STBR.BUDGET_TYPE_CODE
, SUM(NVL(STBR.BASELINE_REVENUE_ITD
, 0))
, SUM(NVL(STBR.BASELINE_REVENUE_YTD
, 0))
, SUM(NVL(STBR.BASELINE_REVENUE_PP
, 0))
, SUM(NVL(STBR.BASELINE_REVENUE_PTD
, 0))
, SUM(NVL(STBR.ORIGINAL_REVENUE_ITD
, 0))
, SUM(NVL(STBR.ORIGINAL_REVENUE_YTD
, 0))
, SUM(NVL(STBR.ORIGINAL_REVENUE_PP
, 0))
, SUM(NVL(STBR.ORIGINAL_REVENUE_PTD
, 0))
, SUM(NVL(STBR.ORIGINAL_LABOR_HOURS_ITD
, 0))
, SUM(NVL(STBR.ORIGINAL_LABOR_HOURS_YTD
, 0))
, SUM(NVL(STBR.ORIGINAL_LABOR_HOURS_PP
, 0))
, SUM(NVL(STBR.ORIGINAL_LABOR_HOURS_PTD
, 0))
, SUM(NVL(STBR.BASELINE_LABOR_HOURS_ITD
, 0))
, SUM(NVL(STBR.BASELINE_LABOR_HOURS_YTD
, 0))
, SUM(NVL(STBR.BASELINE_LABOR_HOURS_PP
, 0))
, SUM(NVL(STBR.BASELINE_LABOR_HOURS_PTD
, 0))
, SUM(NVL(STBR.BASELINE_REVENUE_TOT
, 0))
, SUM(NVL(STBR.ORIGINAL_REVENUE_TOT
, 0))
, SUM(NVL(ORIGINAL_LABOR_HOURS_TOT
, 0))
, SUM(NVL(BASELINE_LABOR_HOURS_TOT
, 0))
FROM PA_STATUS_TASK_BGT_REV_LOW_V STBR GROUP BY STBR.PROJECT_ID
, STBR.TASK_ID
, STBR.BUDGET_TYPE_CODE

Columns