VIEW: APPS.PA_STATUS_TASK_BGT_REV_LOW_V

Source

View Text - Preformatted

SELECT PAH.PROJECT_ID , PAH.TASK_ID , PAB.BUDGET_TYPE_CODE , 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_HEADERS PAH , PA_PROJECT_ACCUM_BUDGETS PAB WHERE PAH.TASK_ID > 0 AND PAH.PROJECT_ID = PA_STATUS.GETPROJID AND PAH.RESOURCE_LIST_ID = 0 AND PAH.PROJECT_ACCUM_ID = PAB.PROJECT_ACCUM_ID AND PAB.BUDGET_TYPE_CODE = PA_STATUS.GETREVBGTCODE UNION SELECT T.PROJECT_ID , T.TASK_ID , BT.BUDGET_TYPE_CODE , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 FROM PA_TASKS T , PA_BUDGET_TYPES BT WHERE BT.BUDGET_TYPE_CODE = PA_STATUS.GETREVBGTCODE AND T.PROJECT_ID = PA_STATUS.GETPROJID

View Text - HTML Formatted

SELECT PAH.PROJECT_ID
, PAH.TASK_ID
, PAB.BUDGET_TYPE_CODE
, 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_HEADERS PAH
, PA_PROJECT_ACCUM_BUDGETS PAB
WHERE PAH.TASK_ID > 0
AND PAH.PROJECT_ID = PA_STATUS.GETPROJID
AND PAH.RESOURCE_LIST_ID = 0
AND PAH.PROJECT_ACCUM_ID = PAB.PROJECT_ACCUM_ID
AND PAB.BUDGET_TYPE_CODE = PA_STATUS.GETREVBGTCODE UNION SELECT T.PROJECT_ID
, T.TASK_ID
, BT.BUDGET_TYPE_CODE
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
FROM PA_TASKS T
, PA_BUDGET_TYPES BT
WHERE BT.BUDGET_TYPE_CODE = PA_STATUS.GETREVBGTCODE
AND T.PROJECT_ID = PA_STATUS.GETPROJID