VIEW: APPS.PA_ORIG_BUDGET_BY_RESOURCE_V

Source

View Text - Preformatted

SELECT V.BUDGET_VERSION_ID , V.PROJECT_ID , A.TASK_ID , V.BUDGET_TYPE_CODE , A.RESOURCE_LIST_MEMBER_ID , M.RESOURCE_LIST_ID , M.RESOURCE_ID , V.RESOURCE_ACCUMULATED_FLAG , SUM(NVL(L.RAW_COST,0)) , SUM(NVL(L.BURDENED_COST,0)) , SUM(NVL(L.REVENUE,0)) , SUM(NVL(L.QUANTITY,0)) , TO_NUMBER(DECODE(A.TRACK_AS_LABOR_FLAG, 'N', NULL, SUM(NVL(L.QUANTITY,0)))) , A.UNIT_OF_MEASURE FROM PA_RESOURCE_LIST_MEMBERS M, PA_BUDGET_LINES L, PA_RESOURCE_ASSIGNMENTS A, PA_BUDGET_VERSIONS V WHERE M.RESOURCE_LIST_MEMBER_ID = A.RESOURCE_LIST_MEMBER_ID AND L.RESOURCE_ASSIGNMENT_ID = A.RESOURCE_ASSIGNMENT_ID and nvl(m.migration_code, '-99') <> 'N' AND A.BUDGET_VERSION_ID = V.BUDGET_VERSION_ID AND V.CURRENT_ORIGINAL_FLAG = 'Y' GROUP BY V.BUDGET_VERSION_ID, V.PROJECT_ID, A.TASK_ID, V.BUDGET_TYPE_CODE, A.RESOURCE_LIST_MEMBER_ID, M.RESOURCE_LIST_ID, M.RESOURCE_ID, V.RESOURCE_ACCUMULATED_FLAG, A.TRACK_AS_LABOR_FLAG, A.UNIT_OF_MEASURE

View Text - HTML Formatted

SELECT V.BUDGET_VERSION_ID
, V.PROJECT_ID
, A.TASK_ID
, V.BUDGET_TYPE_CODE
, A.RESOURCE_LIST_MEMBER_ID
, M.RESOURCE_LIST_ID
, M.RESOURCE_ID
, V.RESOURCE_ACCUMULATED_FLAG
, SUM(NVL(L.RAW_COST
, 0))
, SUM(NVL(L.BURDENED_COST
, 0))
, SUM(NVL(L.REVENUE
, 0))
, SUM(NVL(L.QUANTITY
, 0))
, TO_NUMBER(DECODE(A.TRACK_AS_LABOR_FLAG
, 'N'
, NULL
, SUM(NVL(L.QUANTITY
, 0))))
, A.UNIT_OF_MEASURE
FROM PA_RESOURCE_LIST_MEMBERS M
, PA_BUDGET_LINES L
, PA_RESOURCE_ASSIGNMENTS A
, PA_BUDGET_VERSIONS V
WHERE M.RESOURCE_LIST_MEMBER_ID = A.RESOURCE_LIST_MEMBER_ID
AND L.RESOURCE_ASSIGNMENT_ID = A.RESOURCE_ASSIGNMENT_ID
AND NVL(M.MIGRATION_CODE
, '-99') <> 'N'
AND A.BUDGET_VERSION_ID = V.BUDGET_VERSION_ID
AND V.CURRENT_ORIGINAL_FLAG = 'Y' GROUP BY V.BUDGET_VERSION_ID
, V.PROJECT_ID
, A.TASK_ID
, V.BUDGET_TYPE_CODE
, A.RESOURCE_LIST_MEMBER_ID
, M.RESOURCE_LIST_ID
, M.RESOURCE_ID
, V.RESOURCE_ACCUMULATED_FLAG
, A.TRACK_AS_LABOR_FLAG
, A.UNIT_OF_MEASURE