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.

VIEW: APPS.PA_TASK_BUDGETS2_V

Source

View Text - Preformatted


SELECT V.BUDGET_VERSION_ID , V.PROJECT_ID , V.BUDGET_TYPE_CODE , V.VERSION_NUMBER , V.BUDGET_STATUS_CODE , T.TASK_ID , T.TASK_NUMBER , T.TASK_NAME , T.PARENT_TASK_ID , 0 , 0 , 0 , 0 FROM PA_TASKS T, PA_BUDGET_VERSIONS V WHERE V.PROJECT_ID = T.PROJECT_ID AND PA_BUDGET_UTILS.GET_ENTRY_LEVEL_CODE <> 'P' UNION ALL SELECT V.BUDGET_VERSION_ID, V.PROJECT_ID, V.BUDGET_TYPE_CODE, V.VERSION_NUMBER, V.BUDGET_STATUS_CODE, 0 TASK_ID, NULL TASK_NUMBER, NULL TASK_NAME, 0, 0, 0, 0, 0 FROM PA_BUDGET_VERSIONS V WHERE PA_BUDGET_UTILS.GET_ENTRY_LEVEL_CODE = 'P' UNION ALL SELECT V.BUDGET_VERSION_ID, V.PROJECT_ID, V.BUDGET_TYPE_CODE, V.VERSION_NUMBER, V.BUDGET_STATUS_CODE, T.TASK_ID, T.TASK_NUMBER, T.TASK_NAME, T.PARENT_TASK_ID, SUM(NVL(L.RAW_COST,0)), SUM(NVL(L.BURDENED_COST,0)), SUM(NVL(L.REVENUE,0)), SUM(DECODE(A.TRACK_AS_LABOR_FLAG,'Y',NVL(L.QUANTITY,0),0)) FROM PA_BUDGET_LINES L, PA_TASKS T, PA_RESOURCE_ASSIGNMENTS A, PA_BUDGET_VERSIONS V WHERE V.BUDGET_VERSION_ID = A.BUDGET_VERSION_ID AND A.TASK_ID = T.TASK_ID AND A.RESOURCE_ASSIGNMENT_ID = L.RESOURCE_ASSIGNMENT_ID AND PA_BUDGET_UTILS.GET_ENTRY_LEVEL_CODE <> 'P' GROUP BY V.BUDGET_VERSION_ID, V.PROJECT_ID, V.BUDGET_TYPE_CODE, V.VERSION_NUMBER, V.BUDGET_STATUS_CODE, T.TASK_ID, T.TASK_NUMBER, T.TASK_NAME, T.PARENT_TASK_ID UNION ALL SELECT V.BUDGET_VERSION_ID, V.PROJECT_ID, V.BUDGET_TYPE_CODE, V.VERSION_NUMBER, V.BUDGET_STATUS_CODE, T1.TOP_TASK_ID, T1.TASK_NUMBER, T1.TASK_NAME, T1.PARENT_TASK_ID, SUM(NVL(L.RAW_COST,0)), SUM(NVL(L.BURDENED_COST,0)), SUM(NVL(L.REVENUE,0)), SUM(DECODE(A.TRACK_AS_LABOR_FLAG,'Y',NVL(L.QUANTITY,0),0)) FROM PA_BUDGET_LINES L, PA_TASKS T, PA_TASKS T1, PA_RESOURCE_ASSIGNMENTS A, PA_BUDGET_VERSIONS V WHERE V.BUDGET_VERSION_ID = A.BUDGET_VERSION_ID AND A.TASK_ID = T.TASK_ID AND T.PROJECT_ID = T1.PROJECT_ID AND T.TASK_ID <> T1.TOP_TASK_ID AND T.TOP_TASK_ID = T1.TASK_ID AND T1.PARENT_TASK_ID IS NULL AND A.RESOURCE_ASSIGNMENT_ID = L.RESOURCE_ASSIGNMENT_ID AND PA_BUDGET_UTILS.GET_ENTRY_LEVEL_CODE = 'M' GROUP BY V.BUDGET_VERSION_ID, V.PROJECT_ID, V.BUDGET_TYPE_CODE, V.VERSION_NUMBER, V.BUDGET_STATUS_CODE, T1.TOP_TASK_ID, T1.TASK_NUMBER, T1.TASK_NAME, T1.PARENT_TASK_ID UNION ALL SELECT V.BUDGET_VERSION_ID, V.PROJECT_ID, V.BUDGET_TYPE_CODE, V.VERSION_NUMBER, V.BUDGET_STATUS_CODE, T.TASK_ID, T.TASK_NUMBER, T.TASK_NAME, T.PARENT_TASK_ID, SUM(NVL(L.RAW_COST,0)), SUM(NVL(L.BURDENED_COST,0)), SUM(NVL(L.REVENUE,0)), SUM(DECODE(A.TRACK_AS_LABOR_FLAG,'Y',NVL(L.QUANTITY,0),0)) FROM PA_BUDGET_LINES L, PA_TASKS T, PA_RESOURCE_ASSIGNMENTS A, PA_BUDGET_VERSIONS V WHERE V.BUDGET_VERSION_ID = A.BUDGET_VERSION_ID AND A.RESOURCE_ASSIGNMENT_ID = L.RESOURCE_ASSIGNMENT_ID AND T.PROJECT_ID = V.PROJECT_ID AND T.PARENT_TASK_ID IS NOT NULL AND T.TASK_ID <> A.TASK_ID AND T.TASK_ID IN (SELECT TASK_ID FROM PA_TASKS PT START WITH PT.TASK_ID = A.TASK_ID CONNECT BY PRIOR PT.PARENT_TASK_ID = PT.TASK_ID ) AND PA_BUDGET_UTILS.GET_ENTRY_LEVEL_CODE = 'M' GROUP BY V.BUDGET_VERSION_ID, V.PROJECT_ID, V.BUDGET_TYPE_CODE, V.VERSION_NUMBER, V.BUDGET_STATUS_CODE, T.TASK_ID, T.TASK_NUMBER, T.TASK_NAME, T.PARENT_TASK_ID UNION ALL SELECT V.BUDGET_VERSION_ID, V.PROJECT_ID, V.BUDGET_TYPE_CODE, V.VERSION_NUMBER, V.BUDGET_STATUS_CODE, 0, NULL, NULL, 0, SUM(NVL(L.RAW_COST,0)), SUM(NVL(L.BURDENED_COST,0)), SUM(NVL(L.REVENUE,0)), SUM(DECODE(A.TRACK_AS_LABOR_FLAG,'Y',NVL(L.QUANTITY,0),0)) FROM PA_BUDGET_LINES L, PA_RESOURCE_ASSIGNMENTS A, PA_BUDGET_VERSIONS V WHERE V.BUDGET_VERSION_ID = A.BUDGET_VERSION_ID AND A.TASK_ID = 0 AND A.RESOURCE_ASSIGNMENT_ID = L.RESOURCE_ASSIGNMENT_ID AND PA_BUDGET_UTILS.GET_ENTRY_LEVEL_CODE = 'P' GROUP BY V.BUDGET_VERSION_ID, V.PROJECT_ID, V.BUDGET_TYPE_CODE, V.VERSION_NUMBER, V.BUDGET_STATUS_CODE

View Text - HTML Formatted

SELECT V.BUDGET_VERSION_ID
, V.PROJECT_ID
, V.BUDGET_TYPE_CODE
, V.VERSION_NUMBER
, V.BUDGET_STATUS_CODE
, T.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, T.PARENT_TASK_ID
, 0
, 0
, 0
, 0
FROM PA_TASKS T
, PA_BUDGET_VERSIONS V
WHERE V.PROJECT_ID = T.PROJECT_ID
AND PA_BUDGET_UTILS.GET_ENTRY_LEVEL_CODE <> 'P' UNION ALL SELECT V.BUDGET_VERSION_ID
, V.PROJECT_ID
, V.BUDGET_TYPE_CODE
, V.VERSION_NUMBER
, V.BUDGET_STATUS_CODE
, 0 TASK_ID
, NULL TASK_NUMBER
, NULL TASK_NAME
, 0
, 0
, 0
, 0
, 0
FROM PA_BUDGET_VERSIONS V
WHERE PA_BUDGET_UTILS.GET_ENTRY_LEVEL_CODE = 'P' UNION ALL SELECT V.BUDGET_VERSION_ID
, V.PROJECT_ID
, V.BUDGET_TYPE_CODE
, V.VERSION_NUMBER
, V.BUDGET_STATUS_CODE
, T.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, T.PARENT_TASK_ID
, SUM(NVL(L.RAW_COST
, 0))
, SUM(NVL(L.BURDENED_COST
, 0))
, SUM(NVL(L.REVENUE
, 0))
, SUM(DECODE(A.TRACK_AS_LABOR_FLAG
, 'Y'
, NVL(L.QUANTITY
, 0)
, 0))
FROM PA_BUDGET_LINES L
, PA_TASKS T
, PA_RESOURCE_ASSIGNMENTS A
, PA_BUDGET_VERSIONS V
WHERE V.BUDGET_VERSION_ID = A.BUDGET_VERSION_ID
AND A.TASK_ID = T.TASK_ID
AND A.RESOURCE_ASSIGNMENT_ID = L.RESOURCE_ASSIGNMENT_ID
AND PA_BUDGET_UTILS.GET_ENTRY_LEVEL_CODE <> 'P' GROUP BY V.BUDGET_VERSION_ID
, V.PROJECT_ID
, V.BUDGET_TYPE_CODE
, V.VERSION_NUMBER
, V.BUDGET_STATUS_CODE
, T.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, T.PARENT_TASK_ID UNION ALL SELECT V.BUDGET_VERSION_ID
, V.PROJECT_ID
, V.BUDGET_TYPE_CODE
, V.VERSION_NUMBER
, V.BUDGET_STATUS_CODE
, T1.TOP_TASK_ID
, T1.TASK_NUMBER
, T1.TASK_NAME
, T1.PARENT_TASK_ID
, SUM(NVL(L.RAW_COST
, 0))
, SUM(NVL(L.BURDENED_COST
, 0))
, SUM(NVL(L.REVENUE
, 0))
, SUM(DECODE(A.TRACK_AS_LABOR_FLAG
, 'Y'
, NVL(L.QUANTITY
, 0)
, 0))
FROM PA_BUDGET_LINES L
, PA_TASKS T
, PA_TASKS T1
, PA_RESOURCE_ASSIGNMENTS A
, PA_BUDGET_VERSIONS V
WHERE V.BUDGET_VERSION_ID = A.BUDGET_VERSION_ID
AND A.TASK_ID = T.TASK_ID
AND T.PROJECT_ID = T1.PROJECT_ID
AND T.TASK_ID <> T1.TOP_TASK_ID
AND T.TOP_TASK_ID = T1.TASK_ID
AND T1.PARENT_TASK_ID IS NULL
AND A.RESOURCE_ASSIGNMENT_ID = L.RESOURCE_ASSIGNMENT_ID
AND PA_BUDGET_UTILS.GET_ENTRY_LEVEL_CODE = 'M' GROUP BY V.BUDGET_VERSION_ID
, V.PROJECT_ID
, V.BUDGET_TYPE_CODE
, V.VERSION_NUMBER
, V.BUDGET_STATUS_CODE
, T1.TOP_TASK_ID
, T1.TASK_NUMBER
, T1.TASK_NAME
, T1.PARENT_TASK_ID UNION ALL SELECT V.BUDGET_VERSION_ID
, V.PROJECT_ID
, V.BUDGET_TYPE_CODE
, V.VERSION_NUMBER
, V.BUDGET_STATUS_CODE
, T.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, T.PARENT_TASK_ID
, SUM(NVL(L.RAW_COST
, 0))
, SUM(NVL(L.BURDENED_COST
, 0))
, SUM(NVL(L.REVENUE
, 0))
, SUM(DECODE(A.TRACK_AS_LABOR_FLAG
, 'Y'
, NVL(L.QUANTITY
, 0)
, 0))
FROM PA_BUDGET_LINES L
, PA_TASKS T
, PA_RESOURCE_ASSIGNMENTS A
, PA_BUDGET_VERSIONS V
WHERE V.BUDGET_VERSION_ID = A.BUDGET_VERSION_ID
AND A.RESOURCE_ASSIGNMENT_ID = L.RESOURCE_ASSIGNMENT_ID
AND T.PROJECT_ID = V.PROJECT_ID
AND T.PARENT_TASK_ID IS NOT NULL
AND T.TASK_ID <> A.TASK_ID
AND T.TASK_ID IN (SELECT TASK_ID
FROM PA_TASKS PT START WITH PT.TASK_ID = A.TASK_ID CONNECT BY PRIOR PT.PARENT_TASK_ID = PT.TASK_ID )
AND PA_BUDGET_UTILS.GET_ENTRY_LEVEL_CODE = 'M' GROUP BY V.BUDGET_VERSION_ID
, V.PROJECT_ID
, V.BUDGET_TYPE_CODE
, V.VERSION_NUMBER
, V.BUDGET_STATUS_CODE
, T.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, T.PARENT_TASK_ID UNION ALL SELECT V.BUDGET_VERSION_ID
, V.PROJECT_ID
, V.BUDGET_TYPE_CODE
, V.VERSION_NUMBER
, V.BUDGET_STATUS_CODE
, 0
, NULL
, NULL
, 0
, SUM(NVL(L.RAW_COST
, 0))
, SUM(NVL(L.BURDENED_COST
, 0))
, SUM(NVL(L.REVENUE
, 0))
, SUM(DECODE(A.TRACK_AS_LABOR_FLAG
, 'Y'
, NVL(L.QUANTITY
, 0)
, 0))
FROM PA_BUDGET_LINES L
, PA_RESOURCE_ASSIGNMENTS A
, PA_BUDGET_VERSIONS V
WHERE V.BUDGET_VERSION_ID = A.BUDGET_VERSION_ID
AND A.TASK_ID = 0
AND A.RESOURCE_ASSIGNMENT_ID = L.RESOURCE_ASSIGNMENT_ID
AND PA_BUDGET_UTILS.GET_ENTRY_LEVEL_CODE = 'P' GROUP BY V.BUDGET_VERSION_ID
, V.PROJECT_ID
, V.BUDGET_TYPE_CODE
, V.VERSION_NUMBER
, V.BUDGET_STATUS_CODE