VIEW: APPS.PA_TODATE_BASE_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 , L.START_DATE , L.END_DATE , V.RESOURCE_ACCUMULATED_FLAG , NVL(L.RAW_COST,0) , NVL(L.BURDENED_COST,0) , NVL(L.REVENUE,0) , NVL(L.QUANTITY,0) , TO_NUMBER(DECODE(A.TRACK_AS_LABOR_FLAG,'N',NULL,NVL(L.QUANTITY,0))) , PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.RAW_COST, 'C') RAW_COST_PTD_BASE , PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.BURDENED_COST, 'C') BURDENED_COST_PTD_BASE , PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.REVENUE, 'C') REVENUE_PTD_BASE , PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.QUANTITY, 'C') QUANTITY_PTD_BASE , 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'))) LABOR_QUANTITY_PTD_BASE , PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.RAW_COST, 'P') RAW_COST_PP_BASE , PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.BURDENED_COST, 'P') BURDENED_COST_PP_BASE , PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.REVENUE, 'P') REVENUE_PP_BASE , PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.QUANTITY, 'P') QUANTITY_PP_BASE , 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'))) LABOR_QUANTITY_PP_BASE , PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.RAW_COST, 'Y') RAW_COST_YTD_BASE , PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.BURDENED_COST, 'Y') BURDENED_COST_YTD_BASE , PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.REVENUE, 'Y') REVENUE_YTD_BASE , PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.QUANTITY, 'Y') QUANTITY_YTD_BASE , 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'))) LABOR_QUANTITY_YTD_BASE , PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.RAW_COST, 'I') RAW_COST_ITD_BASE , PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.BURDENED_COST, 'I') BURDENED_COST_ITD_BASE , PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.REVENUE, 'I') REVENUE_ITD_BASE , PA_ACCUM_UTILS.get_spread_amount_val (L.START_DATE, L.END_DATE, L.QUANTITY, 'I') QUANTITY_ITD_BASE , 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'))) LABOR_QUANTITY_ITD_BASE , A.UNIT_OF_MEASURE UNIT_OF_MEASURE_BASE 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_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
, L.START_DATE
, L.END_DATE
, V.RESOURCE_ACCUMULATED_FLAG
, NVL(L.RAW_COST
, 0)
, NVL(L.BURDENED_COST
, 0)
, NVL(L.REVENUE
, 0)
, NVL(L.QUANTITY
, 0)
, TO_NUMBER(DECODE(A.TRACK_AS_LABOR_FLAG
, 'N'
, NULL
, NVL(L.QUANTITY
, 0)))
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.RAW_COST
, 'C') RAW_COST_PTD_BASE
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.BURDENED_COST
, 'C') BURDENED_COST_PTD_BASE
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.REVENUE
, 'C') REVENUE_PTD_BASE
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.QUANTITY
, 'C') QUANTITY_PTD_BASE
, 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'))) LABOR_QUANTITY_PTD_BASE
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.RAW_COST
, 'P') RAW_COST_PP_BASE
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.BURDENED_COST
, 'P') BURDENED_COST_PP_BASE
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.REVENUE
, 'P') REVENUE_PP_BASE
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.QUANTITY
, 'P') QUANTITY_PP_BASE
, 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'))) LABOR_QUANTITY_PP_BASE
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.RAW_COST
, 'Y') RAW_COST_YTD_BASE
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.BURDENED_COST
, 'Y') BURDENED_COST_YTD_BASE
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.REVENUE
, 'Y') REVENUE_YTD_BASE
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.QUANTITY
, 'Y') QUANTITY_YTD_BASE
, 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'))) LABOR_QUANTITY_YTD_BASE
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.RAW_COST
, 'I') RAW_COST_ITD_BASE
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.BURDENED_COST
, 'I') BURDENED_COST_ITD_BASE
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.REVENUE
, 'I') REVENUE_ITD_BASE
, PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL (L.START_DATE
, L.END_DATE
, L.QUANTITY
, 'I') QUANTITY_ITD_BASE
, 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'))) LABOR_QUANTITY_ITD_BASE
, A.UNIT_OF_MEASURE UNIT_OF_MEASURE_BASE
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_FLAG='Y'