View: PQH_BUDGET_DETAILS_V

Product:	PQH - Public Sector HR
Description:	Budgets Details View
Implementation/DBA Data:	APPS.PQH_BUDGET_DETAILS_V

View Text

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 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 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

Columns