View: PA_BASE_FINPLAN_BY_GL_PERIOD_V

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

View Text

SELECT PBV.BUDGET_VERSION_ID
, PBV.PROJECT_ID
, PRA.TASK_ID
, PBV.BUDGET_TYPE_CODE
, PBV.FIN_PLAN_TYPE_ID
, PBV.VERSION_TYPE
, GPS.PERIOD_NAME
, GPS.PERIOD_YEAR
, GPS.START_DATE
, GPS.END_DATE
, PRA.RESOURCE_LIST_MEMBER_ID
, PRLM.ALIAS
, PRLM.RESOURCE_LIST_ID
, PRLM.RESOURCE_ID
, PBV.RESOURCE_ACCUMULATED_FLAG
, DECODE (PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(PBV.BUDGET_VERSION_ID)
, 'G'
, PBL.RAW_COST
, PA_MISC.SPREAD_AMOUNT('L'
, PBL.START_DATE
, PBL.END_DATE
, GPS.START_DATE
, GPS.END_DATE
, PBL.RAW_COST))
, DECODE (PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(PBV.BUDGET_VERSION_ID)
, 'G'
, PBL.BURDENED_COST
, PA_MISC.SPREAD_AMOUNT('L'
, PBL.START_DATE
, PBL.END_DATE
, GPS.START_DATE
, GPS.END_DATE
, PBL.BURDENED_COST))
, DECODE (PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(PBV.BUDGET_VERSION_ID )
, 'G'
, PBL.REVENUE
, PA_MISC.SPREAD_AMOUNT('L'
, PBL.START_DATE
, PBL.END_DATE
, GPS.START_DATE
, GPS.END_DATE
, PBL.REVENUE))
, DECODE (PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(PBV.BUDGET_VERSION_ID)
, 'G'
, PBL.QUANTITY
, PA_MISC.SPREAD_AMOUNT('L'
, PBL.START_DATE
, PBL.END_DATE
, GPS.START_DATE
, GPS.END_DATE
, PBL.QUANTITY))
, DECODE(PRA.RATE_BASED_FLAG
, 'Y'
, DECODE( PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(PBV.BUDGET_VERSION_ID)
, 'G'
, PBL.DISPLAY_QUANTITY
, PA_MISC.SPREAD_AMOUNT('L'
, PBL.START_DATE
, PBL.END_DATE
, GPS.START_DATE
, GPS.END_DATE
, PBL.DISPLAY_QUANTITY))
, NULL)
, TO_NUMBER(DECODE(PRA.TRACK_AS_LABOR_FLAG
, 'N'
, NULL
, DECODE (PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(PBV.BUDGET_VERSION_ID)
, 'G'
, PBL.QUANTITY
, PA_MISC.SPREAD_AMOUNT('L'
, PBL.START_DATE
, PBL.END_DATE
, GPS.START_DATE
, GPS.END_DATE
, PBL.QUANTITY))))
, PRA.UNIT_OF_MEASURE
, PRLM.UNIT_OF_MEASURE
, PBV.APPROVED_COST_PLAN_TYPE_FLAG
, PBV.APPROVED_REV_PLAN_TYPE_FLAG
, (SELECT RBS.RBS_VERSION_ID
FROM PA_PROJ_FP_OPTIONS RBS
WHERE RBS.PROJECT_ID = PBV.PROJECT_ID
AND RBS.FIN_PLAN_TYPE_ID = PBV.FIN_PLAN_TYPE_ID
AND RBS.FIN_PLAN_VERSION_ID = PBV.BUDGET_VERSION_ID
AND ROWNUM = 1)
, PRA.RBS_ELEMENT_ID
, PBV.PRIMARY_COST_FORECAST_FLAG
, PBV.PRIMARY_REV_FORECAST_FLAG
, PI.ORG_ID
FROM PA_RESOURCE_LIST_MEMBERS PRLM
, PA_IMPLEMENTATIONS PI
, GL_PERIOD_STATUSES GPS
, PA_BUDGET_LINES PBL
, PA_RESOURCE_ASSIGNMENTS PRA
, PA_BUDGET_VERSIONS PBV
WHERE PRLM.RESOURCE_LIST_MEMBER_ID = PRA.RESOURCE_LIST_MEMBER_ID
AND PBL.RESOURCE_ASSIGNMENT_ID = PRA.RESOURCE_ASSIGNMENT_ID
AND PRA.BUDGET_VERSION_ID = PBV.BUDGET_VERSION_ID
AND PBV.CURRENT_FLAG = 'Y'
AND ((GPS.START_DATE <= PBL.END_DATE)
AND (GPS.END_DATE >= PBL.START_DATE))
AND PI.SET_OF_BOOKS_ID =GPS.SET_OF_BOOKS_ID
AND GPS.ADJUSTMENT_PERIOD_FLAG = 'N'
AND GPS.APPLICATION_ID = PA_PERIOD_PROCESS_PKG.APPLICATION_ID

Columns