VIEW: APPS.PA_BASE_FINPLAN_BY_GL_PERIOD_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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