eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PA_TODATE_BASE_ORIG_BUDGET_V

Source

View Text - Preformatted


SELECT V.PROJECT_ID , A.TASK_ID , V.BUDGET_TYPE_CODE , A.RESOURCE_LIST_MEMBER_ID , M.ALIAS , M.RESOURCE_LIST_ID , M.RESOURCE_ID , V.RESOURCE_ACCUMULATED_FLAG , decode(current_flag,'Y',NVL(L.RAW_COST,0),0) base_raw_cost , decode(current_flag,'Y',NVL(L.BURDENED_COST,0),0) base_burdened_cost , decode(current_flag,'Y',NVL(L.REVENUE,0),0) base_revenue , decode(current_flag,'Y',NVL(L.QUANTITY,0),0) base_quantity , decode(current_flag,'Y',TO_NUMBER(DECODE(A.TRACK_AS_LABOR_FLAG,'N',NULL,NVL(L.QUANTITY,0))),0) base_labor_quantity , decode(current_original_flag,'Y',NVL(L.RAW_COST,0),0) orig_raw_cost , decode(current_original_flag,'Y',NVL(L.BURDENED_COST,0),0) orig_burdened_cost , decode(current_original_flag,'Y',NVL(L.REVENUE,0),0) orig_revenue , decode(current_original_flag,'Y',NVL(L.QUANTITY,0),0) orig_quantity , decode(current_original_flag,'Y',TO_NUMBER(DECODE(A.TRACK_AS_LABOR_FLAG,'N',NULL,NVL(L.QUANTITY,0))),0) orig_labor_quantity , decode(current_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.RAW_COST, 'C'),0) RAW_COST_PTD_BASE , decode(current_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.BURDENED_COST, 'C'),0) BURDENED_COST_PTD_BASE , decode(current_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.REVENUE, 'C'),0) REVENUE_PTD_BASE , decode(current_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.QUANTITY, 'C'),0) QUANTITY_PTD_BASE , decode(current_flag,'Y',TO_NUMBER(DECODE(A.TRACK_AS_LABOR_FLAG, 'N', NULL, PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.QUANTITY,'C'))),0) LABOR_QUANTITY_PTD_BASE , decode(current_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.RAW_COST, 'P'),0) RAW_COST_PP_BASE , decode(current_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.BURDENED_COST, 'P'),0) BURDENED_COST_PP_BASE , decode(current_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.REVENUE, 'P'),0) REVENUE_PP_BASE , decode(current_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.QUANTITY, 'P'),0) QUANTITY_PP_BASE , decode(current_flag,'Y',TO_NUMBER(DECODE(A.TRACK_AS_LABOR_FLAG, 'N', NULL, PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.QUANTITY,'P'))),0) LABOR_QUANTITY_PP_BASE , decode(current_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.RAW_COST, 'Y'),0) RAW_COST_YTD_BASE , decode(current_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.BURDENED_COST, 'Y'),0) BURDENED_COST_YTD_BASE , decode(current_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.REVENUE, 'Y'),0) REVENUE_YTD_BASE , decode(current_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.QUANTITY, 'Y'),0) QUANTITY_YTD_BASE , decode(current_flag,'Y',TO_NUMBER(DECODE(A.TRACK_AS_LABOR_FLAG, 'N', NULL, PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.QUANTITY,'Y'))),0) LABOR_QUANTITY_YTD_BASE , decode(current_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.RAW_COST, 'I'),0) RAW_COST_ITD_BASE , decode(current_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.BURDENED_COST, 'I'),0) BURDENED_COST_ITD_BASE , decode(current_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.REVENUE, 'I'),0) REVENUE_ITD_BASE , decode(current_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.QUANTITY, 'I'),0) QUANTITY_ITD_BASE , decode(current_flag,'Y',TO_NUMBER(DECODE(A.TRACK_AS_LABOR_FLAG, 'N', NULL, PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.QUANTITY,'I'))),0) LABOR_QUANTITY_ITD_BASE , decode(current_original_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.RAW_COST, 'C'),0) RAW_COST_PTD_ORIG , decode(current_original_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.BURDENED_COST, 'C'),0) BURDENED_COST_PTD_ORIG , decode(current_original_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.REVENUE, 'C'),0) REVENUE_PTD_ORIG , decode(current_original_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.QUANTITY, 'C'),0) QUANTITY_PTD_ORIG , decode(current_original_flag,'Y',TO_NUMBER(DECODE(A.TRACK_AS_LABOR_FLAG, 'N', NULL, PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.QUANTITY,'C'))),0) LABOR_QUANTITY_PTD_ORIG , decode(current_original_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.RAW_COST, 'P'),0) RAW_COST_PP_ORIG , decode(current_original_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.BURDENED_COST, 'P'),0) BURDENED_COST_PP_ORIG , decode(current_original_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.REVENUE, 'P'),0) REVENUE_PP_ORIG , decode(current_original_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.QUANTITY, 'P'),0) QUANTITY_PP_ORIG , decode(current_original_flag,'Y',TO_NUMBER(DECODE(A.TRACK_AS_LABOR_FLAG, 'N', NULL, PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.QUANTITY,'P'))),0) LABOR_QUANTITY_PP_ORIG , decode(current_original_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.RAW_COST, 'Y'),0) RAW_COST_YTD_ORIG , decode(current_original_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.BURDENED_COST, 'Y'),0) BURDENED_COST_YTD_ORIG , decode(current_original_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.REVENUE, 'Y'),0) REVENUE_YTD_ORIG , decode(current_original_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.QUANTITY, 'Y'),0) QUANTITY_YTD_ORIG , decode(current_original_flag,'Y',TO_NUMBER(DECODE(A.TRACK_AS_LABOR_FLAG, 'N', NULL, PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.QUANTITY,'Y'))),0) LABOR_QUANTITY_YTD_ORIG , decode(current_original_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.RAW_COST, 'I'),0) RAW_COST_ITD_ORIG , decode(current_original_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.BURDENED_COST, 'I'),0) BURDENED_COST_ITD_ORIG , decode(current_original_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.REVENUE, 'I'),0) REVENUE_ITD_ORIG , decode(current_original_flag,'Y',PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.QUANTITY, 'I'),0) QUANTITY_ITD_ORIG , decode(current_original_flag,'Y',TO_NUMBER(DECODE(A.TRACK_AS_LABOR_FLAG, 'N', NULL, PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.QUANTITY,'I'))),0) LABOR_QUANTITY_ITD_ORIG , decode(current_flag,'Y',A.UNIT_OF_MEASURE,NULL) UNIT_OF_MEASURE_BASE , decode(current_original_flag,'Y',A.UNIT_OF_MEASURE,NULL) UNIT_OF_MEASURE_ORIG , v.fin_plan_type_id , v.version_type , v.approved_cost_plan_type_flag , v.approved_rev_plan_type_flag , a.track_as_labor_flag , a.resource_class_code , v.primary_cost_forecast_flag , v.primary_rev_forecast_flag 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' AND V.BUDGET_STATUS_CODE='B') OR V.CURRENT_FLAG = 'Y')

View Text - HTML Formatted

SELECT V.PROJECT_ID
, A.TASK_ID
, V.BUDGET_TYPE_CODE
, A.RESOURCE_LIST_MEMBER_ID
, M.ALIAS
, M.RESOURCE_LIST_ID
, M.RESOURCE_ID
, V.RESOURCE_ACCUMULATED_FLAG
, DECODE(CURRENT_FLAG
, 'Y'
, NVL(L.RAW_COST
, 0)
, 0) BASE_RAW_COST
, DECODE(CURRENT_FLAG
, 'Y'
, NVL(L.BURDENED_COST
, 0)
, 0) BASE_BURDENED_COST
, DECODE(CURRENT_FLAG
, 'Y'
, NVL(L.REVENUE
, 0)
, 0) BASE_REVENUE
, DECODE(CURRENT_FLAG
, 'Y'
, NVL(L.QUANTITY
, 0)
, 0) BASE_QUANTITY
, DECODE(CURRENT_FLAG
, 'Y'
, TO_NUMBER(DECODE(A.TRACK_AS_LABOR_FLAG
, 'N'
, NULL
, NVL(L.QUANTITY
, 0)))
, 0) BASE_LABOR_QUANTITY
, DECODE(CURRENT_ORIGINAL_FLAG
, 'Y'
, NVL(L.RAW_COST
, 0)
, 0) ORIG_RAW_COST
, DECODE(CURRENT_ORIGINAL_FLAG
, 'Y'
, NVL(L.BURDENED_COST
, 0)
, 0) ORIG_BURDENED_COST
, DECODE(CURRENT_ORIGINAL_FLAG
, 'Y'
, NVL(L.REVENUE
, 0)
, 0) ORIG_REVENUE
, DECODE(CURRENT_ORIGINAL_FLAG
, 'Y'
, NVL(L.QUANTITY
, 0)
, 0) ORIG_QUANTITY
, DECODE(CURRENT_ORIGINAL_FLAG
, 'Y'
, TO_NUMBER(DECODE(A.TRACK_AS_LABOR_FLAG
, 'N'
, NULL
, NVL(L.QUANTITY
, 0)))
, 0) ORIG_LABOR_QUANTITY
, DECODE(CURRENT_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.RAW_COST
, 'C')
, 0) RAW_COST_PTD_BASE
, DECODE(CURRENT_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.BURDENED_COST
, 'C')
, 0) BURDENED_COST_PTD_BASE
, DECODE(CURRENT_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.REVENUE
, 'C')
, 0) REVENUE_PTD_BASE
, DECODE(CURRENT_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.QUANTITY
, 'C')
, 0) QUANTITY_PTD_BASE
, DECODE(CURRENT_FLAG
, 'Y'
, TO_NUMBER(DECODE(A.TRACK_AS_LABOR_FLAG
, 'N'
, NULL
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.QUANTITY
, 'C')))
, 0) LABOR_QUANTITY_PTD_BASE
, DECODE(CURRENT_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.RAW_COST
, 'P')
, 0) RAW_COST_PP_BASE
, DECODE(CURRENT_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.BURDENED_COST
, 'P')
, 0) BURDENED_COST_PP_BASE
, DECODE(CURRENT_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.REVENUE
, 'P')
, 0) REVENUE_PP_BASE
, DECODE(CURRENT_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.QUANTITY
, 'P')
, 0) QUANTITY_PP_BASE
, DECODE(CURRENT_FLAG
, 'Y'
, TO_NUMBER(DECODE(A.TRACK_AS_LABOR_FLAG
, 'N'
, NULL
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.QUANTITY
, 'P')))
, 0) LABOR_QUANTITY_PP_BASE
, DECODE(CURRENT_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.RAW_COST
, 'Y')
, 0) RAW_COST_YTD_BASE
, DECODE(CURRENT_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.BURDENED_COST
, 'Y')
, 0) BURDENED_COST_YTD_BASE
, DECODE(CURRENT_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.REVENUE
, 'Y')
, 0) REVENUE_YTD_BASE
, DECODE(CURRENT_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.QUANTITY
, 'Y')
, 0) QUANTITY_YTD_BASE
, DECODE(CURRENT_FLAG
, 'Y'
, TO_NUMBER(DECODE(A.TRACK_AS_LABOR_FLAG
, 'N'
, NULL
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.QUANTITY
, 'Y')))
, 0) LABOR_QUANTITY_YTD_BASE
, DECODE(CURRENT_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.RAW_COST
, 'I')
, 0) RAW_COST_ITD_BASE
, DECODE(CURRENT_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.BURDENED_COST
, 'I')
, 0) BURDENED_COST_ITD_BASE
, DECODE(CURRENT_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.REVENUE
, 'I')
, 0) REVENUE_ITD_BASE
, DECODE(CURRENT_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.QUANTITY
, 'I')
, 0) QUANTITY_ITD_BASE
, DECODE(CURRENT_FLAG
, 'Y'
, TO_NUMBER(DECODE(A.TRACK_AS_LABOR_FLAG
, 'N'
, NULL
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.QUANTITY
, 'I')))
, 0) LABOR_QUANTITY_ITD_BASE
, DECODE(CURRENT_ORIGINAL_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.RAW_COST
, 'C')
, 0) RAW_COST_PTD_ORIG
, DECODE(CURRENT_ORIGINAL_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.BURDENED_COST
, 'C')
, 0) BURDENED_COST_PTD_ORIG
, DECODE(CURRENT_ORIGINAL_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.REVENUE
, 'C')
, 0) REVENUE_PTD_ORIG
, DECODE(CURRENT_ORIGINAL_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.QUANTITY
, 'C')
, 0) QUANTITY_PTD_ORIG
, DECODE(CURRENT_ORIGINAL_FLAG
, 'Y'
, TO_NUMBER(DECODE(A.TRACK_AS_LABOR_FLAG
, 'N'
, NULL
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.QUANTITY
, 'C')))
, 0) LABOR_QUANTITY_PTD_ORIG
, DECODE(CURRENT_ORIGINAL_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.RAW_COST
, 'P')
, 0) RAW_COST_PP_ORIG
, DECODE(CURRENT_ORIGINAL_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.BURDENED_COST
, 'P')
, 0) BURDENED_COST_PP_ORIG
, DECODE(CURRENT_ORIGINAL_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.REVENUE
, 'P')
, 0) REVENUE_PP_ORIG
, DECODE(CURRENT_ORIGINAL_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.QUANTITY
, 'P')
, 0) QUANTITY_PP_ORIG
, DECODE(CURRENT_ORIGINAL_FLAG
, 'Y'
, TO_NUMBER(DECODE(A.TRACK_AS_LABOR_FLAG
, 'N'
, NULL
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.QUANTITY
, 'P')))
, 0) LABOR_QUANTITY_PP_ORIG
, DECODE(CURRENT_ORIGINAL_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.RAW_COST
, 'Y')
, 0) RAW_COST_YTD_ORIG
, DECODE(CURRENT_ORIGINAL_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.BURDENED_COST
, 'Y')
, 0) BURDENED_COST_YTD_ORIG
, DECODE(CURRENT_ORIGINAL_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.REVENUE
, 'Y')
, 0) REVENUE_YTD_ORIG
, DECODE(CURRENT_ORIGINAL_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.QUANTITY
, 'Y')
, 0) QUANTITY_YTD_ORIG
, DECODE(CURRENT_ORIGINAL_FLAG
, 'Y'
, TO_NUMBER(DECODE(A.TRACK_AS_LABOR_FLAG
, 'N'
, NULL
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.QUANTITY
, 'Y')))
, 0) LABOR_QUANTITY_YTD_ORIG
, DECODE(CURRENT_ORIGINAL_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.RAW_COST
, 'I')
, 0) RAW_COST_ITD_ORIG
, DECODE(CURRENT_ORIGINAL_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.BURDENED_COST
, 'I')
, 0) BURDENED_COST_ITD_ORIG
, DECODE(CURRENT_ORIGINAL_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.REVENUE
, 'I')
, 0) REVENUE_ITD_ORIG
, DECODE(CURRENT_ORIGINAL_FLAG
, 'Y'
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.QUANTITY
, 'I')
, 0) QUANTITY_ITD_ORIG
, DECODE(CURRENT_ORIGINAL_FLAG
, 'Y'
, TO_NUMBER(DECODE(A.TRACK_AS_LABOR_FLAG
, 'N'
, NULL
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.QUANTITY
, 'I')))
, 0) LABOR_QUANTITY_ITD_ORIG
, DECODE(CURRENT_FLAG
, 'Y'
, A.UNIT_OF_MEASURE
, NULL) UNIT_OF_MEASURE_BASE
, DECODE(CURRENT_ORIGINAL_FLAG
, 'Y'
, A.UNIT_OF_MEASURE
, NULL) UNIT_OF_MEASURE_ORIG
, V.FIN_PLAN_TYPE_ID
, V.VERSION_TYPE
, V.APPROVED_COST_PLAN_TYPE_FLAG
, V.APPROVED_REV_PLAN_TYPE_FLAG
, A.TRACK_AS_LABOR_FLAG
, A.RESOURCE_CLASS_CODE
, V.PRIMARY_COST_FORECAST_FLAG
, V.PRIMARY_REV_FORECAST_FLAG
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'
AND V.BUDGET_STATUS_CODE='B') OR V.CURRENT_FLAG = 'Y')