View: PA_TASK_BUDGETS2_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_TASK_BUDGETS2_V

View Text

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

Columns