VIEW: APPS.PA_ORIG_FINPLAN_BY_GL_PERIOD_V

Source

View Text - Preformatted

SELECT V.BUDGET_VERSION_ID , V.PROJECT_ID , A.TASK_ID , V.BUDGET_TYPE_CODE , V.FIN_PLAN_TYPE_ID , v.version_type , G.PERIOD_NAME , G.PERIOD_YEAR , G.START_DATE , G.END_DATE , A.RESOURCE_LIST_MEMBER_ID , M.ALIAS , M.RESOURCE_LIST_ID , M.RESOURCE_ID , V.RESOURCE_ACCUMULATED_FLAG , DECODE ( PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(v.budget_version_id),'G',L.RAW_COST, PA_MISC.SPREAD_AMOUNT('L', L.START_DATE, L.END_DATE, G.START_DATE, G.END_DATE, L.RAW_COST)) , DECODE ( PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(v.budget_version_id),'G',L.BURDENED_COST, PA_MISC.SPREAD_AMOUNT('L', L.START_DATE, L.END_DATE, G.START_DATE, G.END_DATE, L.BURDENED_COST)) , DECODE ( PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(v.budget_version_id),'G',L.REVENUE, PA_MISC.SPREAD_AMOUNT('L', L.START_DATE, L.END_DATE, G.START_DATE, G.END_DATE, L.REVENUE)) , DECODE ( PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(v.budget_version_id),'G',L.QUANTITY, PA_MISC.SPREAD_AMOUNT('L', L.START_DATE, L.END_DATE, G.START_DATE, G.END_DATE, L.QUANTITY)) , DECODE(A.RATE_BASED_FLAG ,'Y',DECODE( PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(v.budget_version_id) ,'G',L.DISPLAY_QUANTITY, PA_MISC.SPREAD_AMOUNT('L', L.START_DATE, L.END_DATE, G.START_DATE, G.END_DATE, L.DISPLAY_QUANTITY)) ,NULL) , TO_NUMBER(DECODE(A.TRACK_AS_LABOR_FLAG, 'N', NULL, DECODE ( PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(v.budget_version_id),'G',L.QUANTITY, PA_MISC.SPREAD_AMOUNT('L', L.START_DATE, L.END_DATE, G.START_DATE, G.END_DATE, L.QUANTITY)))) , A.UNIT_OF_MEASURE , M.UNIT_OF_MEASURE ,V.APPROVED_COST_PLAN_TYPE_FLAG ,V.APPROVED_REV_PLAN_TYPE_FLAG ,V.PRIMARY_COST_FORECAST_FLAG /*Patchset M: B and F impact changes : AMG*/ ,V.PRIMARY_REV_FORECAST_FLAG /*Patchset M: B and F impact changes : AMG*/ ,I.ORG_ID FROM PA_RESOURCE_LIST_MEMBERS M, PA_IMPLEMENTATIONS I, GL_PERIOD_STATUSES G, 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 A.BUDGET_VERSION_ID = V.BUDGET_VERSION_ID AND V.CURRENT_ORIGINAL_FLAG = 'Y' AND ((G.START_DATE <= L.END_DATE) AND (G.END_DATE >= L.START_DATE)) AND I.SET_OF_BOOKS_ID =G.SET_OF_BOOKS_ID AND G.ADJUSTMENT_PERIOD_FLAG = 'N' AND G.APPLICATION_ID = pa_period_process_pkg.application_id

View Text - HTML Formatted

SELECT V.BUDGET_VERSION_ID
, V.PROJECT_ID
, A.TASK_ID
, V.BUDGET_TYPE_CODE
, V.FIN_PLAN_TYPE_ID
, V.VERSION_TYPE
, G.PERIOD_NAME
, G.PERIOD_YEAR
, G.START_DATE
, G.END_DATE
, A.RESOURCE_LIST_MEMBER_ID
, M.ALIAS
, M.RESOURCE_LIST_ID
, M.RESOURCE_ID
, V.RESOURCE_ACCUMULATED_FLAG
, DECODE ( PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(V.BUDGET_VERSION_ID)
, 'G'
, L.RAW_COST
, PA_MISC.SPREAD_AMOUNT('L'
, L.START_DATE
, L.END_DATE
, G.START_DATE
, G.END_DATE
, L.RAW_COST))
, DECODE ( PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(V.BUDGET_VERSION_ID)
, 'G'
, L.BURDENED_COST
, PA_MISC.SPREAD_AMOUNT('L'
, L.START_DATE
, L.END_DATE
, G.START_DATE
, G.END_DATE
, L.BURDENED_COST))
, DECODE ( PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(V.BUDGET_VERSION_ID)
, 'G'
, L.REVENUE
, PA_MISC.SPREAD_AMOUNT('L'
, L.START_DATE
, L.END_DATE
, G.START_DATE
, G.END_DATE
, L.REVENUE))
, DECODE ( PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(V.BUDGET_VERSION_ID)
, 'G'
, L.QUANTITY
, PA_MISC.SPREAD_AMOUNT('L'
, L.START_DATE
, L.END_DATE
, G.START_DATE
, G.END_DATE
, L.QUANTITY))
, DECODE(A.RATE_BASED_FLAG
, 'Y'
, DECODE( PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(V.BUDGET_VERSION_ID)
, 'G'
, L.DISPLAY_QUANTITY
, PA_MISC.SPREAD_AMOUNT('L'
, L.START_DATE
, L.END_DATE
, G.START_DATE
, G.END_DATE
, L.DISPLAY_QUANTITY))
, NULL)
, TO_NUMBER(DECODE(A.TRACK_AS_LABOR_FLAG
, 'N'
, NULL
, DECODE ( PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(V.BUDGET_VERSION_ID)
, 'G'
, L.QUANTITY
, PA_MISC.SPREAD_AMOUNT('L'
, L.START_DATE
, L.END_DATE
, G.START_DATE
, G.END_DATE
, L.QUANTITY))))
, A.UNIT_OF_MEASURE
, M.UNIT_OF_MEASURE
, V.APPROVED_COST_PLAN_TYPE_FLAG
, V.APPROVED_REV_PLAN_TYPE_FLAG
, V.PRIMARY_COST_FORECAST_FLAG /*PATCHSET M: B
AND F IMPACT CHANGES : AMG*/
, V.PRIMARY_REV_FORECAST_FLAG /*PATCHSET M: B
AND F IMPACT CHANGES : AMG*/
, I.ORG_ID
FROM PA_RESOURCE_LIST_MEMBERS M
, PA_IMPLEMENTATIONS I
, GL_PERIOD_STATUSES G
, 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 A.BUDGET_VERSION_ID = V.BUDGET_VERSION_ID
AND V.CURRENT_ORIGINAL_FLAG = 'Y'
AND ((G.START_DATE <= L.END_DATE)
AND (G.END_DATE >= L.START_DATE))
AND I.SET_OF_BOOKS_ID =G.SET_OF_BOOKS_ID
AND G.ADJUSTMENT_PERIOD_FLAG = 'N'
AND G.APPLICATION_ID = PA_PERIOD_PROCESS_PKG.APPLICATION_ID