VIEW: APPS.PA_BUDGET_BY_RESOURCE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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