View: PA_BUDGET_BY_RESOURCE_V

Product:	PA - Projects
Description:	10Sc Only
Implementation/DBA Data:	APPS.PA_BUDGET_BY_RESOURCE_V

View Text

SELECT PROJECT_ID
, TASK_ID
, BUDGET_TYPE_CODE
, RESOURCE_LIST_MEMBER_ID
, RESOURCE_LIST_ID
, RESOURCE_ID
, RESOURCE_ACCUMULATED_FLAG
, SUM(BASE_RAW_COST)
, SUM(BASE_BURDENED_COST)
, SUM(BASE_REVENUE)
, SUM(BASE_QUANTITY)
, SUM(BASE_LABOR_QUANTITY)
, DECODE(MAX(NVL(UNIT_OF_MEASURE
, '0'))
, '0'
, NULL
, MAX(NVL(UNIT_OF_MEASURE
, '0')))
, SUM(ORIG_RAW_COST)
, SUM(ORIG_BURDENED_COST)
, SUM(ORIG_REVENUE)
, SUM(ORIG_QUANTITY)
, SUM(ORIG_LABOR_QUANTITY)
FROM PA_NG_BUDGET_BY_RESOURCE_V GROUP BY PROJECT_ID
, TASK_ID
, BUDGET_TYPE_CODE
, RESOURCE_LIST_MEMBER_ID
, RESOURCE_LIST_ID
, RESOURCE_ID
, RESOURCE_ACCUMULATED_FLAG

Columns