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_TASK_V

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

View Text

SELECT T.PROJECT_ID
, T.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, T.PARENT_TASK_ID
, T.WBS_LEVEL
, STBC.BUDGET_TYPE_CODE
, STBR.BUDGET_TYPE_CODE
, NVL(STA.RAW_COST_ITD
, 0)
, NVL(STA.RAW_COST_YTD
, 0)
, NVL(STA.RAW_COST_PP
, 0)
, NVL(STA.RAW_COST_PTD
, 0)
, NVL(STA.BILLABLE_RAW_COST_ITD
, 0)
, NVL(STA.BILLABLE_RAW_COST_YTD
, 0)
, NVL(STA.BILLABLE_RAW_COST_PP
, 0)
, NVL(STA.BILLABLE_RAW_COST_PTD
, 0)
, NVL(STA.BILLABLE_RAW_COST_ITD
, 0)
, NVL(STA.BILLABLE_RAW_COST_YTD
, 0)
, NVL(STA.BILLABLE_RAW_COST_PP
, 0)
, NVL(STA.BILLABLE_RAW_COST_PTD
, 0)
, NVL(STA.BURDENED_COST_ITD
, 0)
, NVL(STA.BURDENED_COST_YTD
, 0)
, NVL(STA.BURDENED_COST_PP
, 0)
, NVL(STA.BURDENED_COST_PTD
, 0)
, NVL(STA.BILLABLE_BURDENED_COST_ITD
, 0)
, NVL(STA.BILLABLE_BURDENED_COST_YTD
, 0)
, NVL(STA.BILLABLE_BURDENED_COST_PP
, 0)
, NVL(STA.BILLABLE_BURDENED_COST_PTD
, 0)
, NVL(STA.BILLABLE_BURDENED_COST_ITD
, 0)
, NVL(STA.BILLABLE_BURDENED_COST_YTD
, 0)
, NVL(STA.BILLABLE_BURDENED_COST_PP
, 0)
, NVL(STA.BILLABLE_BURDENED_COST_PTD
, 0)
, NVL(STA.ACTUALS_LABOR_HOURS_ITD
, 0)
, NVL(STA.ACTUALS_LABOR_HOURS_YTD
, 0)
, NVL(STA.ACTUALS_LABOR_HOURS_PP
, 0)
, NVL(STA.ACTUALS_LABOR_HOURS_PTD
, 0)
, NVL(STA.BILLABLE_LABOR_HOURS_ITD
, 0)
, NVL(STA.BILLABLE_LABOR_HOURS_YTD
, 0)
, NVL(STA.BILLABLE_LABOR_HOURS_PP
, 0)
, NVL(STA.BILLABLE_LABOR_HOURS_PTD
, 0)
, NVL(STA.REVENUE_ITD
, 0)
, NVL(STA.REVENUE_YTD
, 0)
, NVL(STA.REVENUE_PP
, 0)
, NVL(STA.REVENUE_PTD
, 0)
, NVL(STC.CMT_RAW_COST_ITD
, 0)
, NVL(STC.CMT_RAW_COST_YTD
, 0)
, NVL(STC.CMT_RAW_COST_PP
, 0)
, NVL(STC.CMT_RAW_COST_PTD
, 0)
, NVL(STC.CMT_BURDENED_COST_ITD
, 0)
, NVL(STC.CMT_BURDENED_COST_YTD
, 0)
, NVL(STC.CMT_BURDENED_COST_PP
, 0)
, NVL(STC.CMT_BURDENED_COST_PTD
, 0)
, NVL(STBC.BASELINE_RAW_COST_ITD
, 0)
, NVL(STBC.BASELINE_RAW_COST_YTD
, 0)
, NVL(STBC.BASELINE_RAW_COST_PP
, 0)
, NVL(STBC.BASELINE_RAW_COST_PTD
, 0)
, NVL(STBC.BASELINE_BURDENED_COST_ITD
, 0)
, NVL(STBC.BASELINE_BURDENED_COST_YTD
, 0)
, NVL(STBC.BASELINE_BURDENED_COST_PP
, 0)
, NVL(STBC.BASELINE_BURDENED_COST_PTD
, 0)
, NVL(STBC.ORIGINAL_RAW_COST_ITD
, 0)
, NVL(STBC.ORIGINAL_RAW_COST_YTD
, 0)
, NVL(STBC.ORIGINAL_RAW_COST_PP
, 0)
, NVL(STBC.ORIGINAL_RAW_COST_PTD
, 0)
, NVL(STBC.ORIGINAL_BURDENED_COST_ITD
, 0)
, NVL(STBC.ORIGINAL_BURDENED_COST_YTD
, 0)
, NVL(STBC.ORIGINAL_BURDENED_COST_PP
, 0)
, NVL(STBC.ORIGINAL_BURDENED_COST_PTD
, 0)
, NVL(STBC.ORIGINAL_LABOR_HOURS_ITD
, 0)
, NVL(STBC.ORIGINAL_LABOR_HOURS_YTD
, 0)
, NVL(STBC.ORIGINAL_LABOR_HOURS_PP
, 0)
, NVL(STBC.ORIGINAL_LABOR_HOURS_PTD
, 0)
, NVL(STBC.BASELINE_LABOR_HOURS_ITD
, 0)
, NVL(STBC.BASELINE_LABOR_HOURS_YTD
, 0)
, NVL(STBC.BASELINE_LABOR_HOURS_PP
, 0)
, NVL(STBC.BASELINE_LABOR_HOURS_PTD
, 0)
, NVL(STBC.BASELINE_RAW_COST_TOT
, 0)
, NVL(STBC.BASELINE_BURDENED_COST_TOT
, 0)
, NVL(STBC.ORIGINAL_RAW_COST_TOT
, 0)
, NVL(STBC.ORIGINAL_BURDENED_COST_TOT
, 0)
, NVL(STBC.ORIGINAL_LABOR_HOURS_TOT
, 0)
, NVL(STBC.BASELINE_LABOR_HOURS_TOT
, 0)
, NVL(STBR.BASELINE_REVENUE_ITD
, 0)
, NVL(STBR.BASELINE_REVENUE_YTD
, 0)
, NVL(STBR.BASELINE_REVENUE_PP
, 0)
, NVL(STBR.BASELINE_REVENUE_PTD
, 0)
, NVL(STBR.ORIGINAL_REVENUE_ITD
, 0)
, NVL(STBR.ORIGINAL_REVENUE_YTD
, 0)
, NVL(STBR.ORIGINAL_REVENUE_PP
, 0)
, NVL(STBR.ORIGINAL_REVENUE_PTD
, 0)
, NVL(STBR.ORIGINAL_LABOR_HOURS_ITD
, 0)
, NVL(STBR.ORIGINAL_LABOR_HOURS_YTD
, 0)
, NVL(STBR.ORIGINAL_LABOR_HOURS_PP
, 0)
, NVL(STBR.ORIGINAL_LABOR_HOURS_PTD
, 0)
, NVL(STBR.BASELINE_LABOR_HOURS_ITD
, 0)
, NVL(STBR.BASELINE_LABOR_HOURS_YTD
, 0)
, NVL(STBR.BASELINE_LABOR_HOURS_PP
, 0)
, NVL(STBR.BASELINE_LABOR_HOURS_PTD
, 0)
, NVL(STBR.BASELINE_REVENUE_TOT
, 0)
, NVL(STBR.ORIGINAL_REVENUE_TOT
, 0)
, NVL(STBC.ORIGINAL_LABOR_HOURS_TOT
, 0)
, NVL(STBC.BASELINE_LABOR_HOURS_TOT
, 0)
FROM PA_TASKS T
, PA_STATUS_TASK_ACT_V STA
, PA_STATUS_TASK_CMT_V STC
, PA_STATUS_TASK_BGT_COST_HIGH_V STBC
, PA_STATUS_TASK_BGT_REV_HIGH_V STBR
WHERE T.PROJECT_ID = PA_STATUS.GETPROJID
AND T.TASK_ID = STA.TASK_ID (+)
AND T.TASK_ID = STC.TASK_ID (+)
AND T.TASK_ID = STBC.TASK_ID (+)
AND T.TASK_ID = STBR.TASK_ID (+)

Columns

Name
PROJECT_ID
TASK_ID
TASK_NUMBER
TASK_NAME
PARENT_TASK_ID
WBS_LEVEL
COST_BUDGET_TYPE_CODE
REV_BUDGET_TYPE_CODE
RAW_COST_ITD
RAW_COST_YTD
RAW_COST_PP
RAW_COST_PTD
BILLABLE_RAW_COST_ITD
BILLABLE_RAW_COST_YTD
BILLABLE_RAW_COST_PP
BILLABLE_RAW_COST_PTD
CAPITAL_RAW_COST_ITD
CAPITAL_RAW_COST_YTD
CAPITAL_RAW_COST_PP
CAPITAL_RAW_COST_PTD
BURDENED_COST_ITD
BURDENED_COST_YTD
BURDENED_COST_PP
BURDENED_COST_PTD
BILLABLE_BURDENED_COST_ITD
BILLABLE_BURDENED_COST_YTD
BILLABLE_BURDENED_COST_PP
BILLABLE_BURDENED_COST_PTD
CAPITAL_BURDENED_COST_ITD
CAPITAL_BURDENED_COST_YTD
CAPITAL_BURDENED_COST_PP
CAPITAL_BURDENED_COST_PTD
ACTUALS_LABOR_HOURS_ITD
ACTUALS_LABOR_HOURS_YTD
ACTUALS_LABOR_HOURS_PP
ACTUALS_LABOR_HOURS_PTD
BILLABLE_LABOR_HOURS_ITD
BILLABLE_LABOR_HOURS_YTD
BILLABLE_LABOR_HOURS_PP
BILLABLE_LABOR_HOURS_PTD
REVENUE_ITD
REVENUE_YTD
REVENUE_PP
REVENUE_PTD
CMT_RAW_COST_ITD
CMT_RAW_COST_YTD
CMT_RAW_COST_PP
CMT_RAW_COST_PTD
CMT_BURDENED_COST_ITD
CMT_BURDENED_COST_YTD
CMT_BURDENED_COST_PP
CMT_BURDENED_COST_PTD
BASELINE_RAW_COST_ITD
BASELINE_RAW_COST_YTD
BASELINE_RAW_COST_PP
BASELINE_RAW_COST_PTD
BASELINE_BURDENED_COST_ITD
BASELINE_BURDENED_COST_YTD
BASELINE_BURDENED_COST_PP
BASELINE_BURDENED_COST_PTD
ORIGINAL_RAW_COST_ITD
ORIGINAL_RAW_COST_YTD
ORIGINAL_RAW_COST_PP
ORIGINAL_RAW_COST_PTD
ORIGINAL_BURDENED_COST_ITD
ORIGINAL_BURDENED_COST_YTD
ORIGINAL_BURDENED_COST_PP
ORIGINAL_BURDENED_COST_PTD
ORIGINAL_COST_LABOR_HOURS_ITD
ORIGINAL_COST_LABOR_HOURS_YTD
ORIGINAL_COST_LABOR_HOURS_PP
ORIGINAL_COST_LABOR_HOURS_PTD
BASELINE_COST_LABOR_HOURS_ITD
BASELINE_COST_LABOR_HOURS_YTD
BASELINE_COST_LABOR_HOURS_PP
BASELINE_COST_LABOR_HOURS_PTD
BASELINE_RAW_COST_TOT
BASELINE_BURDENED_COST_TOT
ORIGINAL_RAW_COST_TOT
ORIGINAL_BURDENED_COST_TOT
ORIGINAL_COST_LABOR_HOURS_TOT
BASELINE_COST_LABOR_HOURS_TOT
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_REV_LABOR_HOURS_ITD
ORIGINAL_REV_LABOR_HOURS_YTD
ORIGINAL_REV_LABOR_HOURS_PP
ORIGINAL_REV_LABOR_HOURS_PTD
BASELINE_REV_LABOR_HOURS_ITD
BASELINE_REV_LABOR_HOURS_YTD
BASELINE_REV_LABOR_HOURS_PP
BASELINE_REV_LABOR_HOURS_PTD
BASELINE_REVENUE_TOT
ORIGINAL_REVENUE_TOT
ORIGINAL_REV_LABOR_HOURS_TOT
BASELINE_REV_LABOR_HOURS_TOT