View: PA_BASE_FINPLAN_BY_PA_PERIOD_V

Product:	PA - Projects
Description:	This view displays budget lines by PA period, for a baselined financial plan
Implementation/DBA Data:	APPS.PA_BASE_FINPLAN_BY_PA_PERIOD_V

View Text

SELECT V.BUDGET_VERSION_ID
, V.PROJECT_ID
, A.TASK_ID
, V.BUDGET_TYPE_CODE
, V.FIN_PLAN_TYPE_ID
, V.VERSION_TYPE
, P.PERIOD_NAME
, G.PERIOD_NAME
, G.PERIOD_YEAR
, P.START_DATE
, P.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)
, 'P'
, L.RAW_COST
, PA_MISC.SPREAD_AMOUNT('L'
, L.START_DATE
, L.END_DATE
, P.START_DATE
, P.END_DATE
, L.RAW_COST))
, DECODE (PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(V.BUDGET_VERSION_ID)
, 'P'
, L.BURDENED_COST
, PA_MISC.SPREAD_AMOUNT('L'
, L.START_DATE
, L.END_DATE
, P.START_DATE
, P.END_DATE
, L.BURDENED_COST))
, DECODE (PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(V.BUDGET_VERSION_ID)
, 'P'
, L.REVENUE
, PA_MISC.SPREAD_AMOUNT('L'
, L.START_DATE
, L.END_DATE
, P.START_DATE
, P.END_DATE
, L.REVENUE))
, DECODE (PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(V.BUDGET_VERSION_ID)
, 'P'
, L.QUANTITY
, PA_MISC.SPREAD_AMOUNT('L'
, L.START_DATE
, L.END_DATE
, P.START_DATE
, P.END_DATE
, L.QUANTITY))
, DECODE(A.RATE_BASED_FLAG
, 'Y'
, DECODE( PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(V.BUDGET_VERSION_ID)
, 'P'
, L.DISPLAY_QUANTITY
, PA_MISC.SPREAD_AMOUNT('L'
, L.START_DATE
, L.END_DATE
, P.START_DATE
, P.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)
, 'P'
, L.QUANTITY
, PA_MISC.SPREAD_AMOUNT('L'
, L.START_DATE
, L.END_DATE
, P.START_DATE
, P.END_DATE
, L.QUANTITY))))
, A.UNIT_OF_MEASURE
, M.UNIT_OF_MEASURE
, V.APPROVED_COST_PLAN_TYPE_FLAG
, V.APPROVED_REV_PLAN_TYPE_FLAG
, (SELECT RBS.RBS_VERSION_ID
FROM PA_PROJ_FP_OPTIONS RBS
WHERE RBS.PROJECT_ID = V.PROJECT_ID
AND RBS.FIN_PLAN_TYPE_ID = V.FIN_PLAN_TYPE_ID
AND RBS.FIN_PLAN_VERSION_ID = V.BUDGET_VERSION_ID
AND ROWNUM = 1)
, A.RBS_ELEMENT_ID
, V.PRIMARY_COST_FORECAST_FLAG
, V.PRIMARY_REV_FORECAST_FLAG
, I.ORG_ID
FROM PA_RESOURCE_LIST_MEMBERS M
, PA_IMPLEMENTATIONS I
, GL_SETS_OF_BOOKS SOB
, GL_PERIODS G
, PA_PERIODS_ALL P
, 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_FLAG = 'Y'
AND ((P.START_DATE <= L.END_DATE)
AND (P.END_DATE >= L.START_DATE))
AND P.GL_PERIOD_NAME = G.PERIOD_NAME
AND G.PERIOD_SET_NAME||'' = SOB.PERIOD_SET_NAME
AND I.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
AND G.ADJUSTMENT_PERIOD_FLAG = 'N'
AND P.ORG_ID = I.ORG_ID

Columns