VIEW: APPS.PQH_BUDGET_DETAILS_V

Source

View Text - Preformatted

SELECT bgt.BUDGET_NAME BUDGET_NAME , bgt.BUDGET_ID BUDGET_ID , bgt.PERIOD_SET_NAME BUDGET_CALENDAR_NAME , bgt.PERIOD_TYPE BUDGET_CALENDAR_FREQUENCY , bgt.BUDGET_START_DATE BUDGET_START_DATE , bgt.BUDGET_END_DATE BUDGET_END_DATE , bgt.BUDGETED_ENTITY BUDGETED_ENTITY , bgt.BUDGET_STYLE BUDGET_STYLE , bgt.ORG_STRUCTURE ORGANIZATION_HIERARCHY_NAME , bgt.VERSION ORGANIZATION_HIERARCHY_VERSION , bgt.START_ORGANIZATION STARTING_ORGANIZATION_NAME , bgt.BUDGET_UNIT1 BUDGET_MEASUREMENT_TYPE , bgt.BUDGET_UNIT1_ID BUDGET_UNIT_ID , bgt.BUDGET_UNIT1_AGGREGATE_DESC BUDGET_UNIT_AGGREGATE_DESC , bgt.BUDGET_UNIT1_AGGREGATE BUDGET_UNIT_AGGREGATE , hr_general.decode_organization(bgt.BUSINESS_GROUP_ID) BUSINESS_GROUP_NAME , bgt.BUSINESS_GROUP_ID BUSINESS_GROUP_ID , bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID , bvr.VERSION_NUMBER BUDGET_VERSION_NUMBER , bvr.DATE_FROM BUDGET_VERSION_START_DATE , bvr.DATE_TO BUDGET_VERSION_END_DATE , bdt.BUDGET_DETAIL_ID BUDGET_DETAIL_ID , bdt.BUDGET_UNIT1_VALUE BUDGET_DETAIL_BUDGETED_VALUE , pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( bvr.BUDGET_VERSION_ID , bdt.POSITION_ID , bgt.BUDGET_START_DATE , bgt.BUDGET_END_DATE , bgt.BUDGET_UNIT1_ID , 'C' , bgt.currency_code ) BUDGET_DETAIL_CMMTMNT_VALUE , pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( bvr.BUDGET_VERSION_ID , bdt.POSITION_ID , bgt.BUDGET_START_DATE , bgt.BUDGET_END_DATE , bgt.BUDGET_UNIT1_ID , 'A' , bgt.currency_code ) BUDGET_DETAIL_ACTUAL_VALUE , hr_general.decode_position_latest_name(bdt.POSITION_ID) position_name , bdt.POSITION_ID POSITION_ID , bpr.BUDGET_PERIOD_ID BUDGET_PERIOD_ID , to_char(ptps.start_date, 'DD-MON-YYYY')||' - '||to_char(ptpe.end_date, 'DD-MON-YYYY') BUDGET_PERIOD_NAME , bpr.BUDGET_UNIT1_VALUE BUDGET_PERIOD_BUDGETED_VALUE , pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( bvr.BUDGET_VERSION_ID , bdt.POSITION_ID , ptps.start_date , ptpe.end_date , bgt.BUDGET_UNIT1_ID ,'C' ,bgt.currency_code ) BUDGET_PERIOD_CMMTMNT_VALUE , pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( bvr.BUDGET_VERSION_ID , bdt.POSITION_ID , ptps.start_date , ptpe.end_date , bgt.BUDGET_UNIT1_ID ,'A' , bgt.currency_code ) BUDGET_PERIOD_ACTUAL_VALUE FROM pqh_budgets_v bgt , pqh_budget_versions bvr , pqh_budget_details bdt , pqh_budget_periods bpr , per_time_periods ptps , per_time_periods ptpe WHERE bgt.business_group_id = NVL(hr_general.get_business_group_id,bgt.business_group_id ) AND bgt.budget_id = bvr.budget_id AND bvr.budget_version_id = bdt.budget_version_id AND bdt.position_id is not null AND bdt.budget_detail_id = bpr.budget_detail_id AND ptps.time_period_id = bpr.start_time_period_id AND ptpe.time_period_id = bpr.end_time_period_id UNION ALL SELECT bgt.BUDGET_NAME BUDGET_NAME , bgt.BUDGET_ID BUDGET_ID , bgt.PERIOD_SET_NAME BUDGET_CALENDAR_NAME , bgt.PERIOD_TYPE BUDGET_CALENDAR_FREQUENCY , bgt.BUDGET_START_DATE BUDGET_START_DATE , bgt.BUDGET_END_DATE BUDGET_END_DATE , bgt.BUDGETED_ENTITY BUDGETED_ENTITY , bgt.BUDGET_STYLE BUDGET_STYLE , bgt.ORG_STRUCTURE ORGANIZATION_HIERARCHY_NAME , bgt.VERSION ORGANIZATION_HIERARCHY_VERSION , bgt.START_ORGANIZATION STARTING_ORGANIZATION_NAME , bgt.BUDGET_UNIT2 BUDGET_MEASUREMENT_TYPE , bgt.BUDGET_UNIT2_ID BUDGET_UNIT_ID , bgt.BUDGET_UNIT2_AGGREGATE_DESC BUDGET_UNIT_AGGREGATE_DESC , bgt.BUDGET_UNIT2_AGGREGATE BUDGET_UNIT_AGGREGATE , hr_general.decode_organization(bgt.BUSINESS_GROUP_ID) BUSINESS_GROUP_NAME , bgt.BUSINESS_GROUP_ID BUSINESS_GROUP_ID , bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID , bvr.VERSION_NUMBER BUDGET_VERSION_NUMBER , bvr.DATE_FROM BUDGET_VERSION_START_DATE , bvr.DATE_TO BUDGET_VERSION_END_DATE , bdt.BUDGET_DETAIL_ID BUDGET_DETAIL_ID , bdt.BUDGET_UNIT2_VALUE BUDGET_DETAIL_BUDGETED_VALUE , pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( bvr.BUDGET_VERSION_ID , bdt.POSITION_ID , bgt.BUDGET_START_DATE , bgt.BUDGET_END_DATE , bgt.BUDGET_UNIT2_ID ,'C' ,bgt.currency_code ) BUDGET_DETAIL_CMMTMNT_VALUE , pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( bvr.BUDGET_VERSION_ID , bdt.POSITION_ID , bgt.BUDGET_START_DATE , bgt.BUDGET_END_DATE , bgt.BUDGET_UNIT2_ID , 'A' , bgt.currency_code ) BUDGET_DETAIL_ACTUAL_VALUE , hr_general.decode_position_latest_name(bdt.POSITION_ID) position_name , bdt.POSITION_ID POSITION_ID , bpr.BUDGET_PERIOD_ID BUDGET_PERIOD_ID , to_char(ptps.start_date,'DD-MON-YYYY')||' - '||to_char(ptpe.end_date,'DD-MON-YYYY') BUDGET_PERIOD_NAME , bpr.BUDGET_UNIT2_VALUE BUDGET_PERIOD_BUDGETED_VALUE , pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( bvr.BUDGET_VERSION_ID , bdt.POSITION_ID , ptps.start_date , ptpe.end_date , bgt.BUDGET_UNIT2_ID , 'C' , bgt.currency_code ) BUDGET_PERIOD_CMMTMNT_VALUE , pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( bvr.BUDGET_VERSION_ID , bdt.POSITION_ID , ptps.start_date , ptpe.end_date , bgt.BUDGET_UNIT2_ID , 'A' , bgt.currency_code ) BUDGET_PERIOD_ACTUAL_VALUE FROM pqh_budgets_v bgt , pqh_budget_versions bvr , pqh_budget_details bdt , pqh_budget_periods bpr , per_time_periods ptps , per_time_periods ptpe WHERE bgt.business_group_id = NVL(hr_general.get_business_group_id,bgt.business_group_id ) AND bgt.budget_id = bvr.budget_id AND bgt.BUDGET_UNIT2 IS NOT NULL AND bvr.budget_version_id = bdt.budget_version_id AND bdt.position_id is not null AND bdt.budget_detail_id = bpr.budget_detail_id AND ptps.time_period_id = bpr.start_time_period_id AND ptpe.time_period_id = bpr.end_time_period_id UNION ALL SELECT bgt.BUDGET_NAME BUDGET_NAME , bgt.BUDGET_ID BUDGET_ID , bgt.PERIOD_SET_NAME BUDGET_CALENDAR_NAME , bgt.PERIOD_TYPE BUDGET_CALENDAR_FREQUENCY , bgt.BUDGET_START_DATE BUDGET_START_DATE , bgt.BUDGET_END_DATE BUDGET_END_DATE , bgt.BUDGETED_ENTITY BUDGETED_ENTITY , bgt.BUDGET_STYLE BUDGET_STYLE , bgt.ORG_STRUCTURE ORGANIZATION_HIERARCHY_NAME , bgt.VERSION ORGANIZATION_HIERARCHY_VERSION , bgt.START_ORGANIZATION STARTING_ORGANIZATION_NAME , bgt.BUDGET_UNIT3 BUDGET_MEASUREMENT_TYPE , bgt.BUDGET_UNIT3_ID BUDGET_UNIT_ID , bgt.BUDGET_UNIT3_AGGREGATE_DESC BUDGET_UNIT_AGGREGATE_DESC , bgt.BUDGET_UNIT3_AGGREGATE BUDGET_UNIT_AGGREGATE , hr_general.decode_organization(bgt.BUSINESS_GROUP_ID) BUSINESS_GROUP_NAME , bgt.BUSINESS_GROUP_ID BUSINESS_GROUP_ID , bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID , bvr.VERSION_NUMBER BUDGET_VERSION_NUMBER , bvr.DATE_FROM BUDGET_VERSION_START_DATE , bvr.DATE_TO BUDGET_VERSION_END_DATE , bdt.BUDGET_DETAIL_ID BUDGET_DETAIL_ID , bdt.BUDGET_UNIT3_VALUE BUDGET_DETAIL_BUDGETED_VALUE , pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( bvr.BUDGET_VERSION_ID , bdt.POSITION_ID , bgt.BUDGET_START_DATE , bgt.BUDGET_END_DATE , bgt.BUDGET_UNIT3_ID , 'C' , bgt.currency_code ) BUDGET_DETAIL_CMMTMNT_VALUE , pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( bvr.BUDGET_VERSION_ID , bdt.POSITION_ID , bgt.BUDGET_START_DATE , bgt.BUDGET_END_DATE , bgt.BUDGET_UNIT3_ID , 'A' , bgt.currency_code ) BUDGET_DETAIL_ACTUAL_VALUE , hr_general.decode_position_latest_name(bdt.POSITION_ID) position_name , bdt.POSITION_ID POSITION_ID , bpr.BUDGET_PERIOD_ID BUDGET_PERIOD_ID , to_char(ptps.start_date, 'DD-MON-YYYY')||' - '||to_char(ptpe.end_date, 'DD-MON-YYYY') BUDGET_PERIOD_NAME , bpr.BUDGET_UNIT3_VALUE BUDGET_PERIOD_BUDGETED_VALUE , pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( bvr.BUDGET_VERSION_ID , bdt.POSITION_ID , ptps.start_date , ptpe.end_date , bgt.BUDGET_UNIT3_ID , 'C' , bgt.currency_code ) BUDGET_PERIOD_CMMTMNT_VALUE , pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( bvr.BUDGET_VERSION_ID , bdt.POSITION_ID , ptps.start_date , ptpe.end_date , bgt.BUDGET_UNIT3_ID , 'A', bgt.currency_code ) BUDGET_PERIOD_ACTUAL_VALUE FROM pqh_budgets_v bgt , pqh_budget_versions bvr , pqh_budget_details bdt , pqh_budget_periods bpr , per_time_periods ptps , per_time_periods ptpe WHERE bgt.business_group_id = NVL(hr_general.get_business_group_id,bgt.business_group_id ) AND bgt.budget_id = bvr.budget_id AND bgt.budget_unit3 is not null AND bvr.budget_version_id = bdt.budget_version_id AND bdt.position_id is not null AND bdt.budget_detail_id = bpr.budget_detail_id AND ptps.time_period_id = bpr.start_time_period_id AND ptpe.time_period_id = bpr.end_time_period_id

View Text - HTML Formatted

SELECT BGT.BUDGET_NAME BUDGET_NAME
, BGT.BUDGET_ID BUDGET_ID
, BGT.PERIOD_SET_NAME BUDGET_CALENDAR_NAME
, BGT.PERIOD_TYPE BUDGET_CALENDAR_FREQUENCY
, BGT.BUDGET_START_DATE BUDGET_START_DATE
, BGT.BUDGET_END_DATE BUDGET_END_DATE
, BGT.BUDGETED_ENTITY BUDGETED_ENTITY
, BGT.BUDGET_STYLE BUDGET_STYLE
, BGT.ORG_STRUCTURE ORGANIZATION_HIERARCHY_NAME
, BGT.VERSION ORGANIZATION_HIERARCHY_VERSION
, BGT.START_ORGANIZATION STARTING_ORGANIZATION_NAME
, BGT.BUDGET_UNIT1 BUDGET_MEASUREMENT_TYPE
, BGT.BUDGET_UNIT1_ID BUDGET_UNIT_ID
, BGT.BUDGET_UNIT1_AGGREGATE_DESC BUDGET_UNIT_AGGREGATE_DESC
, BGT.BUDGET_UNIT1_AGGREGATE BUDGET_UNIT_AGGREGATE
, HR_GENERAL.DECODE_ORGANIZATION(BGT.BUSINESS_GROUP_ID) BUSINESS_GROUP_NAME
, BGT.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, BVR.BUDGET_VERSION_ID BUDGET_VERSION_ID
, BVR.VERSION_NUMBER BUDGET_VERSION_NUMBER
, BVR.DATE_FROM BUDGET_VERSION_START_DATE
, BVR.DATE_TO BUDGET_VERSION_END_DATE
, BDT.BUDGET_DETAIL_ID BUDGET_DETAIL_ID
, BDT.BUDGET_UNIT1_VALUE BUDGET_DETAIL_BUDGETED_VALUE
, PQH_MGMT_RPT_PKG.GET_POSITION_ACTUAL_CMMTMNTS ( BVR.BUDGET_VERSION_ID
, BDT.POSITION_ID
, BGT.BUDGET_START_DATE
, BGT.BUDGET_END_DATE
, BGT.BUDGET_UNIT1_ID
, 'C'
, BGT.CURRENCY_CODE ) BUDGET_DETAIL_CMMTMNT_VALUE
, PQH_MGMT_RPT_PKG.GET_POSITION_ACTUAL_CMMTMNTS ( BVR.BUDGET_VERSION_ID
, BDT.POSITION_ID
, BGT.BUDGET_START_DATE
, BGT.BUDGET_END_DATE
, BGT.BUDGET_UNIT1_ID
, 'A'
, BGT.CURRENCY_CODE ) BUDGET_DETAIL_ACTUAL_VALUE
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(BDT.POSITION_ID) POSITION_NAME
, BDT.POSITION_ID POSITION_ID
, BPR.BUDGET_PERIOD_ID BUDGET_PERIOD_ID
, TO_CHAR(PTPS.START_DATE
, 'DD-MON-YYYY')||' - '||TO_CHAR(PTPE.END_DATE
, 'DD-MON-YYYY') BUDGET_PERIOD_NAME
, BPR.BUDGET_UNIT1_VALUE BUDGET_PERIOD_BUDGETED_VALUE
, PQH_MGMT_RPT_PKG.GET_POSITION_ACTUAL_CMMTMNTS ( BVR.BUDGET_VERSION_ID
, BDT.POSITION_ID
, PTPS.START_DATE
, PTPE.END_DATE
, BGT.BUDGET_UNIT1_ID
, 'C'
, BGT.CURRENCY_CODE ) BUDGET_PERIOD_CMMTMNT_VALUE
, PQH_MGMT_RPT_PKG.GET_POSITION_ACTUAL_CMMTMNTS ( BVR.BUDGET_VERSION_ID
, BDT.POSITION_ID
, PTPS.START_DATE
, PTPE.END_DATE
, BGT.BUDGET_UNIT1_ID
, 'A'
, BGT.CURRENCY_CODE ) BUDGET_PERIOD_ACTUAL_VALUE
FROM PQH_BUDGETS_V BGT
, PQH_BUDGET_VERSIONS BVR
, PQH_BUDGET_DETAILS BDT
, PQH_BUDGET_PERIODS BPR
, PER_TIME_PERIODS PTPS
, PER_TIME_PERIODS PTPE
WHERE BGT.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, BGT.BUSINESS_GROUP_ID )
AND BGT.BUDGET_ID = BVR.BUDGET_ID
AND BVR.BUDGET_VERSION_ID = BDT.BUDGET_VERSION_ID
AND BDT.POSITION_ID IS NOT NULL
AND BDT.BUDGET_DETAIL_ID = BPR.BUDGET_DETAIL_ID
AND PTPS.TIME_PERIOD_ID = BPR.START_TIME_PERIOD_ID
AND PTPE.TIME_PERIOD_ID = BPR.END_TIME_PERIOD_ID UNION ALL SELECT BGT.BUDGET_NAME BUDGET_NAME
, BGT.BUDGET_ID BUDGET_ID
, BGT.PERIOD_SET_NAME BUDGET_CALENDAR_NAME
, BGT.PERIOD_TYPE BUDGET_CALENDAR_FREQUENCY
, BGT.BUDGET_START_DATE BUDGET_START_DATE
, BGT.BUDGET_END_DATE BUDGET_END_DATE
, BGT.BUDGETED_ENTITY BUDGETED_ENTITY
, BGT.BUDGET_STYLE BUDGET_STYLE
, BGT.ORG_STRUCTURE ORGANIZATION_HIERARCHY_NAME
, BGT.VERSION ORGANIZATION_HIERARCHY_VERSION
, BGT.START_ORGANIZATION STARTING_ORGANIZATION_NAME
, BGT.BUDGET_UNIT2 BUDGET_MEASUREMENT_TYPE
, BGT.BUDGET_UNIT2_ID BUDGET_UNIT_ID
, BGT.BUDGET_UNIT2_AGGREGATE_DESC BUDGET_UNIT_AGGREGATE_DESC
, BGT.BUDGET_UNIT2_AGGREGATE BUDGET_UNIT_AGGREGATE
, HR_GENERAL.DECODE_ORGANIZATION(BGT.BUSINESS_GROUP_ID) BUSINESS_GROUP_NAME
, BGT.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, BVR.BUDGET_VERSION_ID BUDGET_VERSION_ID
, BVR.VERSION_NUMBER BUDGET_VERSION_NUMBER
, BVR.DATE_FROM BUDGET_VERSION_START_DATE
, BVR.DATE_TO BUDGET_VERSION_END_DATE
, BDT.BUDGET_DETAIL_ID BUDGET_DETAIL_ID
, BDT.BUDGET_UNIT2_VALUE BUDGET_DETAIL_BUDGETED_VALUE
, PQH_MGMT_RPT_PKG.GET_POSITION_ACTUAL_CMMTMNTS ( BVR.BUDGET_VERSION_ID
, BDT.POSITION_ID
, BGT.BUDGET_START_DATE
, BGT.BUDGET_END_DATE
, BGT.BUDGET_UNIT2_ID
, 'C'
, BGT.CURRENCY_CODE ) BUDGET_DETAIL_CMMTMNT_VALUE
, PQH_MGMT_RPT_PKG.GET_POSITION_ACTUAL_CMMTMNTS ( BVR.BUDGET_VERSION_ID
, BDT.POSITION_ID
, BGT.BUDGET_START_DATE
, BGT.BUDGET_END_DATE
, BGT.BUDGET_UNIT2_ID
, 'A'
, BGT.CURRENCY_CODE ) BUDGET_DETAIL_ACTUAL_VALUE
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(BDT.POSITION_ID) POSITION_NAME
, BDT.POSITION_ID POSITION_ID
, BPR.BUDGET_PERIOD_ID BUDGET_PERIOD_ID
, TO_CHAR(PTPS.START_DATE
, 'DD-MON-YYYY')||' - '||TO_CHAR(PTPE.END_DATE
, 'DD-MON-YYYY') BUDGET_PERIOD_NAME
, BPR.BUDGET_UNIT2_VALUE BUDGET_PERIOD_BUDGETED_VALUE
, PQH_MGMT_RPT_PKG.GET_POSITION_ACTUAL_CMMTMNTS ( BVR.BUDGET_VERSION_ID
, BDT.POSITION_ID
, PTPS.START_DATE
, PTPE.END_DATE
, BGT.BUDGET_UNIT2_ID
, 'C'
, BGT.CURRENCY_CODE ) BUDGET_PERIOD_CMMTMNT_VALUE
, PQH_MGMT_RPT_PKG.GET_POSITION_ACTUAL_CMMTMNTS ( BVR.BUDGET_VERSION_ID
, BDT.POSITION_ID
, PTPS.START_DATE
, PTPE.END_DATE
, BGT.BUDGET_UNIT2_ID
, 'A'
, BGT.CURRENCY_CODE ) BUDGET_PERIOD_ACTUAL_VALUE
FROM PQH_BUDGETS_V BGT
, PQH_BUDGET_VERSIONS BVR
, PQH_BUDGET_DETAILS BDT
, PQH_BUDGET_PERIODS BPR
, PER_TIME_PERIODS PTPS
, PER_TIME_PERIODS PTPE
WHERE BGT.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, BGT.BUSINESS_GROUP_ID )
AND BGT.BUDGET_ID = BVR.BUDGET_ID
AND BGT.BUDGET_UNIT2 IS NOT NULL
AND BVR.BUDGET_VERSION_ID = BDT.BUDGET_VERSION_ID
AND BDT.POSITION_ID IS NOT NULL
AND BDT.BUDGET_DETAIL_ID = BPR.BUDGET_DETAIL_ID
AND PTPS.TIME_PERIOD_ID = BPR.START_TIME_PERIOD_ID
AND PTPE.TIME_PERIOD_ID = BPR.END_TIME_PERIOD_ID UNION ALL SELECT BGT.BUDGET_NAME BUDGET_NAME
, BGT.BUDGET_ID BUDGET_ID
, BGT.PERIOD_SET_NAME BUDGET_CALENDAR_NAME
, BGT.PERIOD_TYPE BUDGET_CALENDAR_FREQUENCY
, BGT.BUDGET_START_DATE BUDGET_START_DATE
, BGT.BUDGET_END_DATE BUDGET_END_DATE
, BGT.BUDGETED_ENTITY BUDGETED_ENTITY
, BGT.BUDGET_STYLE BUDGET_STYLE
, BGT.ORG_STRUCTURE ORGANIZATION_HIERARCHY_NAME
, BGT.VERSION ORGANIZATION_HIERARCHY_VERSION
, BGT.START_ORGANIZATION STARTING_ORGANIZATION_NAME
, BGT.BUDGET_UNIT3 BUDGET_MEASUREMENT_TYPE
, BGT.BUDGET_UNIT3_ID BUDGET_UNIT_ID
, BGT.BUDGET_UNIT3_AGGREGATE_DESC BUDGET_UNIT_AGGREGATE_DESC
, BGT.BUDGET_UNIT3_AGGREGATE BUDGET_UNIT_AGGREGATE
, HR_GENERAL.DECODE_ORGANIZATION(BGT.BUSINESS_GROUP_ID) BUSINESS_GROUP_NAME
, BGT.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, BVR.BUDGET_VERSION_ID BUDGET_VERSION_ID
, BVR.VERSION_NUMBER BUDGET_VERSION_NUMBER
, BVR.DATE_FROM BUDGET_VERSION_START_DATE
, BVR.DATE_TO BUDGET_VERSION_END_DATE
, BDT.BUDGET_DETAIL_ID BUDGET_DETAIL_ID
, BDT.BUDGET_UNIT3_VALUE BUDGET_DETAIL_BUDGETED_VALUE
, PQH_MGMT_RPT_PKG.GET_POSITION_ACTUAL_CMMTMNTS ( BVR.BUDGET_VERSION_ID
, BDT.POSITION_ID
, BGT.BUDGET_START_DATE
, BGT.BUDGET_END_DATE
, BGT.BUDGET_UNIT3_ID
, 'C'
, BGT.CURRENCY_CODE ) BUDGET_DETAIL_CMMTMNT_VALUE
, PQH_MGMT_RPT_PKG.GET_POSITION_ACTUAL_CMMTMNTS ( BVR.BUDGET_VERSION_ID
, BDT.POSITION_ID
, BGT.BUDGET_START_DATE
, BGT.BUDGET_END_DATE
, BGT.BUDGET_UNIT3_ID
, 'A'
, BGT.CURRENCY_CODE ) BUDGET_DETAIL_ACTUAL_VALUE
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(BDT.POSITION_ID) POSITION_NAME
, BDT.POSITION_ID POSITION_ID
, BPR.BUDGET_PERIOD_ID BUDGET_PERIOD_ID
, TO_CHAR(PTPS.START_DATE
, 'DD-MON-YYYY')||' - '||TO_CHAR(PTPE.END_DATE
, 'DD-MON-YYYY') BUDGET_PERIOD_NAME
, BPR.BUDGET_UNIT3_VALUE BUDGET_PERIOD_BUDGETED_VALUE
, PQH_MGMT_RPT_PKG.GET_POSITION_ACTUAL_CMMTMNTS ( BVR.BUDGET_VERSION_ID
, BDT.POSITION_ID
, PTPS.START_DATE
, PTPE.END_DATE
, BGT.BUDGET_UNIT3_ID
, 'C'
, BGT.CURRENCY_CODE ) BUDGET_PERIOD_CMMTMNT_VALUE
, PQH_MGMT_RPT_PKG.GET_POSITION_ACTUAL_CMMTMNTS ( BVR.BUDGET_VERSION_ID
, BDT.POSITION_ID
, PTPS.START_DATE
, PTPE.END_DATE
, BGT.BUDGET_UNIT3_ID
, 'A'
, BGT.CURRENCY_CODE ) BUDGET_PERIOD_ACTUAL_VALUE
FROM PQH_BUDGETS_V BGT
, PQH_BUDGET_VERSIONS BVR
, PQH_BUDGET_DETAILS BDT
, PQH_BUDGET_PERIODS BPR
, PER_TIME_PERIODS PTPS
, PER_TIME_PERIODS PTPE
WHERE BGT.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, BGT.BUSINESS_GROUP_ID )
AND BGT.BUDGET_ID = BVR.BUDGET_ID
AND BGT.BUDGET_UNIT3 IS NOT NULL
AND BVR.BUDGET_VERSION_ID = BDT.BUDGET_VERSION_ID
AND BDT.POSITION_ID IS NOT NULL
AND BDT.BUDGET_DETAIL_ID = BPR.BUDGET_DETAIL_ID
AND PTPS.TIME_PERIOD_ID = BPR.START_TIME_PERIOD_ID
AND PTPE.TIME_PERIOD_ID = BPR.END_TIME_PERIOD_ID