View: PA_TASK_BUDGETS_V

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

View Text

SELECT BUDGET_VERSION_ID
, PROJECT_ID
, BUDGET_TYPE_CODE
, VERSION_NUMBER
, BUDGET_STATUS_CODE
, TASK_ID
, TASK_NUMBER
, TASK_NAME
, PARENT_TASK_ID
, PA_TASK_UTILS.SORT_ORDER_TREE_WALK(PARENT_TASK_ID
, TASK_NUMBER) SORT_ORDER
, SUM( RAW_COST_TOTAL) RAW_COST_TOTAL
, SUM( BURDENED_COST_TOTAL) BURDENED_COST_TOTAL
, SUM( REVENUE_TOTAL) REVENUE_TOTAL
, SUM( QUANTITY_TOTAL) QUANTITY_TOTAL
FROM PA_TASK_BUDGETS2_V GROUP BY BUDGET_VERSION_ID
, PROJECT_ID
, BUDGET_TYPE_CODE
, VERSION_NUMBER
, BUDGET_STATUS_CODE
, TASK_ID
, TASK_NUMBER
, TASK_NAME
, PARENT_TASK_ID

Columns