View: HRFV_WORKFORCE_BUDGETS

Product:	PER - Human Resources
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.HRFV_WORKFORCE_BUDGETS

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, BGT.BUDGET_NAME BUDGET_NAME
, BGT.PERIOD_SET_NAME BUDGET_CALENDAR_NAME
, PC.ACTUAL_PERIOD_TYPE BUDGET_CALENDAR_FREQUENCY
, BGT.BUDGET_START_DATE BUDGET_START_DATE
, BGT.BUDGET_END_DATE BUDGET_END_DATE
, HR_BIS.BIS_DECODE_LOOKUP('PQH_BUDGET_ENTITY'
, BGT.BUDGETED_ENTITY_CD) BUDGETED_ENTITY
, BGT.BUDGETED_ENTITY_CD BUDGETED_ENTITY_CD
, HR_BIS.BIS_DECODE_LOOKUP('PQH_BUDGET_STYLE'
, BGT.BUDGET_STYLE_CD) BUDGET_STYLE
, BGT.BUDGET_STYLE_CD BUDGET_STYLE_CD
, OS.NAME ORGANIZATION_HIERARCHY_NAME
, OV.VERSION_NUMBER ORGANIZATION_HIERARCHY_VERSION
, HR_GENERAL.DECODE_ORGANIZATION(BGT.START_ORGANIZATION_ID) STARTING_ORGANIZATION_NAME
, PST.SHARED_TYPE_NAME BUDGET_MEASUREMENT_TYPE
, PST.SYSTEM_TYPE_CD BUDGET_UNIT_CD
, HR_BIS.BIS_DECODE_LOOKUP('PQH_BGT_UOM_AGGREGATE'
, BGT.BUDGET_UNIT1_AGGREGATE) BUDGET_UNIT_AGGREGATE_DESC
, BGT.BUDGET_UNIT1_AGGREGATE BUDGET_UNIT_AGGREGATE
, BVR.VERSION_NUMBER BUDGET_VERSION_NUMBER
, BVR.DATE_FROM BUDGET_VERSION_START_DATE
, BVR.DATE_TO BUDGET_VERSION_END_DATE
, BDT.BUDGET_UNIT1_VALUE BUDGET_DETAIL_BUDGETED_VALUE
, ORGT.NAME ORGANIZATION_NAME
, JOB.NAME JOB_NAME
, POS.NAME POSITION_NAME
, GRD.NAME GRADE_NAME
, PTPS.START_DATE||' - '||PTPE.END_DATE BUDGET_PERIOD_NAME
, PTPS.START_DATE BUDGET_PERIOD_START_DATE
, PTPE.END_DATE BUDGET_PERIOD_END_DATE
, BPR.BUDGET_UNIT1_VALUE BUDGET_PERIOD_BUDGETED_VALUE
, HR_DISCOVERER.GET_ACTUAL_BUDGET_VALUES( PST.SYSTEM_TYPE_CD
, BGT.BUSINESS_GROUP_ID
, ORGT.ORGANIZATION_ID
, JOB.JOB_ID
, POS.POSITION_ID
, GRD.GRADE_ID
, PTPS.START_DATE
, PTPE.END_DATE
, BDT.BUDGET_UNIT1_VALUE) BUDGET_PERIOD_ACTUAL_VALUE
, HR_DISC_CALCULATIONS.GET_FF_ACTUAL_VALUE_PQH( BGT.BUDGET_ID
, BGT.BUSINESS_GROUP_ID
, GRD.GRADE_ID
, JOB.JOB_ID
, ORGT.ORGANIZATION_ID
, BDT.POSITION_ID
, BPR.BUDGET_PERIOD_ID
, PST.SYSTEM_TYPE_CD) CALC_PERIOD_ACTUAL_VAULE
, BGT.BUDGET_ID BUDGET_ID
, BGT.BUDGET_UNIT1_ID BUDGET_UNIT_ID
, BGT.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, BVR.BUDGET_VERSION_ID BUDGET_VERSION_ID
, BDT.BUDGET_DETAIL_ID BUDGET_DETAIL_ID
, POS.POSITION_ID POSITION_ID
, BPR.BUDGET_PERIOD_ID BUDGET_PERIOD_ID
, GRD.GRADE_ID GRADE_ID
, JOB.JOB_ID JOB_ID
, ORGT.ORGANIZATION_ID ORGANIZATION_ID
FROM PQH_BUDGETS BGT
, PER_SHARED_TYPES_VL PST
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, PER_JOBS JOB
, PER_GRADES GRD
, PQH_BUDGET_VERSIONS BVR
, PQH_BUDGET_DETAILS BDT
, PER_ALL_POSITIONS POS
, PQH_BUDGET_PERIODS BPR
, PER_TIME_PERIODS PTPS
, PER_TIME_PERIODS PTPE
, PER_ORGANIZATION_STRUCTURES OS
, PER_ORG_STRUCTURE_VERSIONS OV
, PAY_CALENDARS PC
WHERE BGT.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND BGT.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, BGT.BUSINESS_GROUP_ID )
AND BGT.BUDGET_UNIT1_ID = PST.SHARED_TYPE_ID
AND BGT.BUDGET_ID = BVR.BUDGET_ID
AND BVR.BUDGET_UNIT1_VALUE IS NOT NULL
AND BVR.BUDGET_VERSION_ID = BDT.BUDGET_VERSION_ID
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
AND BDT.ORGANIZATION_ID = ORGT.ORGANIZATION_ID (+)
AND ORGT.LANGUAGE (+) = USERENV('LANG')
AND BDT.JOB_ID = JOB.JOB_ID (+)
AND BDT.POSITION_ID = POS.POSITION_ID (+)
AND BDT.GRADE_ID = GRD.GRADE_ID (+)
AND OS.ORGANIZATION_STRUCTURE_ID (+) = OV.ORGANIZATION_STRUCTURE_ID
AND OV.ORG_STRUCTURE_VERSION_ID(+) = BGT.ORG_STRUCTURE_VERSION_ID
AND BGT.PERIOD_SET_NAME = PC.PERIOD_SET_NAME UNION ALL SELECT BGRT.NAME BUSINESS_GROUP_NAME
, BGT.BUDGET_NAME BUDGET_NAME
, BGT.PERIOD_SET_NAME BUDGET_CALENDAR_NAME
, PC.ACTUAL_PERIOD_TYPE BUDGET_CALENDAR_FREQUENCY
, BGT.BUDGET_START_DATE BUDGET_START_DATE
, BGT.BUDGET_END_DATE BUDGET_END_DATE
, HR_BIS.BIS_DECODE_LOOKUP('PQH_BUDGET_ENTITY'
, BGT.BUDGETED_ENTITY_CD) BUDGETED_ENTITY
, BGT.BUDGETED_ENTITY_CD BUDGETED_ENTITY_CD
, HR_BIS.BIS_DECODE_LOOKUP('PQH_BUDGET_STYLE'
, BGT.BUDGET_STYLE_CD) BUDGET_STYLE
, BGT.BUDGET_STYLE_CD BUDGET_STYLE_CD
, OS.NAME ORGANIZATION_HIERARCHY_NAME
, OV.VERSION_NUMBER ORGANIZATION_HIERARCHY_VERSION
, HR_GENERAL.DECODE_ORGANIZATION(BGT.START_ORGANIZATION_ID) STARTING_ORGANIZATION_NAME
, PST.SHARED_TYPE_NAME BUDGET_MEASUREMENT_TYPE
, PST.SYSTEM_TYPE_CD BUDGET_UNIT_CD
, HR_BIS.BIS_DECODE_LOOKUP('PQH_BGT_UOM_AGGREGATE'
, BGT.BUDGET_UNIT2_AGGREGATE) BUDGET_UNIT_AGGREGATE_DESC
, BGT.BUDGET_UNIT2_AGGREGATE BUDGET_UNIT_AGGREGATE
, BVR.VERSION_NUMBER BUDGET_VERSION_NUMBER
, BVR.DATE_FROM BUDGET_VERSION_START_DATE
, BVR.DATE_TO BUDGET_VERSION_END_DATE
, BDT.BUDGET_UNIT2_VALUE BUDGET_DETAIL_BUDGETED_VALUE
, ORGT.NAME ORGANIZATION_NAME
, JOB.NAME JOB_NAME
, POS.NAME POSITION_NAME
, GRD.NAME GRADE_NAME
, PTPS.START_DATE||' - '||PTPE.END_DATE BUDGET_PERIOD_NAME
, PTPS.START_DATE BUDGET_PERIOD_START_DATE
, PTPE.END_DATE BUDGET_PERIOD_END_DATE
, BPR.BUDGET_UNIT2_VALUE BUDGET_PERIOD_BUDGETED_VALUE
, HR_DISCOVERER.GET_ACTUAL_BUDGET_VALUES( PST.SYSTEM_TYPE_CD
, BGT.BUSINESS_GROUP_ID
, ORGT.ORGANIZATION_ID
, JOB.JOB_ID
, POS.POSITION_ID
, GRD.GRADE_ID
, PTPS.START_DATE
, PTPE.END_DATE
, BDT.BUDGET_UNIT2_VALUE) BUDGET_PERIOD_ACTUAL_VALUE
, HR_DISC_CALCULATIONS.GET_FF_ACTUAL_VALUE_PQH( BGT.BUDGET_ID
, BGT.BUSINESS_GROUP_ID
, GRD.GRADE_ID
, JOB.JOB_ID
, ORGT.ORGANIZATION_ID
, BDT.POSITION_ID
, BPR.BUDGET_PERIOD_ID
, PST.SYSTEM_TYPE_CD) CALC_PERIOD_ACTUAL_VAULE
, BGT.BUDGET_ID BUDGET_ID
, BGT.BUDGET_UNIT2_ID BUDGET_UNIT_ID
, BGT.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, BVR.BUDGET_VERSION_ID BUDGET_VERSION_ID
, BDT.BUDGET_DETAIL_ID BUDGET_DETAIL_ID
, POS.POSITION_ID POSITION_ID
, BPR.BUDGET_PERIOD_ID BUDGET_PERIOD_ID
, GRD.GRADE_ID GRADE_ID
, JOB.JOB_ID JOB_ID
, ORGT.ORGANIZATION_ID ORGANIZATION_ID
FROM PQH_BUDGETS_V BGT
, PER_SHARED_TYPES_VL PST
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, PER_JOBS JOB
, PER_GRADES GRD
, PQH_BUDGET_VERSIONS BVR
, PQH_BUDGET_DETAILS BDT
, PER_ALL_POSITIONS POS
, PQH_BUDGET_PERIODS BPR
, PER_TIME_PERIODS PTPS
, PER_TIME_PERIODS PTPE
, PER_ORGANIZATION_STRUCTURES OS
, PER_ORG_STRUCTURE_VERSIONS OV
, PAY_CALENDARS PC
WHERE BGT.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND BGT.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, BGT.BUSINESS_GROUP_ID )
AND BGT.BUDGET_UNIT2_ID = PST.SHARED_TYPE_ID
AND BGT.BUDGET_ID = BVR.BUDGET_ID
AND BGT.BUDGET_UNIT2 IS NOT NULL
AND BVR.BUDGET_UNIT2_VALUE IS NOT NULL
AND BVR.BUDGET_VERSION_ID = BDT.BUDGET_VERSION_ID
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
AND BDT.ORGANIZATION_ID = ORGT.ORGANIZATION_ID (+)
AND ORGT.LANGUAGE (+) = USERENV('LANG')
AND BDT.JOB_ID = JOB.JOB_ID (+)
AND BDT.POSITION_ID = POS.POSITION_ID (+)
AND BDT.GRADE_ID = GRD.GRADE_ID (+)
AND OS.ORGANIZATION_STRUCTURE_ID (+) = OV.ORGANIZATION_STRUCTURE_ID
AND OV.ORG_STRUCTURE_VERSION_ID(+) = BGT.ORG_STRUCTURE_VERSION_ID
AND BGT.PERIOD_SET_NAME = PC.PERIOD_SET_NAME UNION ALL SELECT BGRT.NAME BUSINESS_GROUP_NAME
, BGT.BUDGET_NAME BUDGET_NAME
, BGT.PERIOD_SET_NAME BUDGET_CALENDAR_NAME
, PC.ACTUAL_PERIOD_TYPE BUDGET_CALENDAR_FREQUENCY
, BGT.BUDGET_START_DATE BUDGET_START_DATE
, BGT.BUDGET_END_DATE BUDGET_END_DATE
, HR_BIS.BIS_DECODE_LOOKUP('PQH_BUDGET_ENTITY'
, BGT.BUDGETED_ENTITY_CD) BUDGETED_ENTITY
, BGT.BUDGETED_ENTITY_CD BUDGETED_ENTITY_CD
, HR_BIS.BIS_DECODE_LOOKUP('PQH_BUDGET_STYLE'
, BGT.BUDGET_STYLE_CD) BUDGET_STYLE
, BGT.BUDGET_STYLE_CD BUDGET_STYLE_CD
, OS.NAME ORGANIZATION_HIERARCHY_NAME
, OV.VERSION_NUMBER ORGANIZATION_HIERARCHY_VERSION
, HR_GENERAL.DECODE_ORGANIZATION(BGT.START_ORGANIZATION_ID) STARTING_ORGANIZATION_NAME
, PST.SHARED_TYPE_NAME BUDGET_MEASUREMENT_TYPE
, PST.SYSTEM_TYPE_CD BUDGET_UNIT_CD
, HR_BIS.BIS_DECODE_LOOKUP('PQH_BGT_UOM_AGGREGATE'
, BGT.BUDGET_UNIT3_AGGREGATE) BUDGET_UNIT_AGGREGATE_DESC
, BGT.BUDGET_UNIT3_AGGREGATE BUDGET_UNIT_AGGREGATE
, BVR.VERSION_NUMBER BUDGET_VERSION_NUMBER
, BVR.DATE_FROM BUDGET_VERSION_START_DATE
, BVR.DATE_TO BUDGET_VERSION_END_DATE
, BDT.BUDGET_UNIT3_VALUE BUDGET_DETAIL_BUDGETED_VALUE
, ORGT.NAME ORGANIZATION_NAME
, JOB.NAME JOB_NAME
, POS.NAME POSITION_NAME
, GRD.NAME GRADE_NAME
, PTPS.START_DATE||' - '||PTPE.END_DATE BUDGET_PERIOD_NAME
, PTPS.START_DATE BUDGET_PERIOD_START_DATE
, PTPE.END_DATE BUDGET_PERIOD_END_DATE
, BPR.BUDGET_UNIT3_VALUE BUDGET_PERIOD_BUDGETED_VALUE
, HR_DISCOVERER.GET_ACTUAL_BUDGET_VALUES( PST.SYSTEM_TYPE_CD
, BGT.BUSINESS_GROUP_ID
, ORGT.ORGANIZATION_ID
, JOB.JOB_ID
, POS.POSITION_ID
, GRD.GRADE_ID
, PTPS.START_DATE
, PTPE.END_DATE
, BDT.BUDGET_UNIT3_VALUE) BUDGET_PERIOD_ACTUAL_VALUE
, HR_DISC_CALCULATIONS.GET_FF_ACTUAL_VALUE_PQH( BGT.BUDGET_ID
, BGT.BUSINESS_GROUP_ID
, GRD.GRADE_ID
, JOB.JOB_ID
, ORGT.ORGANIZATION_ID
, BDT.POSITION_ID
, BPR.BUDGET_PERIOD_ID
, PST.SYSTEM_TYPE_CD) CALC_PERIOD_ACTUAL_VAULE
, BGT.BUDGET_ID BUDGET_ID
, BGT.BUDGET_UNIT3_ID BUDGET_UNIT_ID
, BGT.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, BVR.BUDGET_VERSION_ID BUDGET_VERSION_ID
, BDT.BUDGET_DETAIL_ID BUDGET_DETAIL_ID
, POS.POSITION_ID POSITION_ID
, BPR.BUDGET_PERIOD_ID BUDGET_PERIOD_ID
, GRD.GRADE_ID GRADE_ID
, JOB.JOB_ID JOB_ID
, ORGT.ORGANIZATION_ID ORGANIZATION_ID
FROM PQH_BUDGETS_V BGT
, PER_SHARED_TYPES_VL PST
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, PER_JOBS JOB
, PER_GRADES GRD
, PQH_BUDGET_VERSIONS BVR
, PQH_BUDGET_DETAILS BDT
, PER_ALL_POSITIONS POS
, PQH_BUDGET_PERIODS BPR
, PER_TIME_PERIODS PTPS
, PER_TIME_PERIODS PTPE
, PER_ORGANIZATION_STRUCTURES OS
, PER_ORG_STRUCTURE_VERSIONS OV
, PAY_CALENDARS PC
WHERE BGT.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND BGT.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, BGT.BUSINESS_GROUP_ID )
AND BGT.BUDGET_UNIT3_ID = PST.SHARED_TYPE_ID
AND BGT.BUDGET_ID = BVR.BUDGET_ID
AND BGT.BUDGET_UNIT3 IS NOT NULL
AND BVR.BUDGET_UNIT3_VALUE IS NOT NULL
AND BVR.BUDGET_VERSION_ID = BDT.BUDGET_VERSION_ID
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
AND BDT.ORGANIZATION_ID = ORGT.ORGANIZATION_ID (+)
AND ORGT.LANGUAGE (+) = USERENV('LANG')
AND BDT.JOB_ID = JOB.JOB_ID (+)
AND BDT.POSITION_ID = POS.POSITION_ID (+)
AND BDT.GRADE_ID = GRD.GRADE_ID (+)
AND OS.ORGANIZATION_STRUCTURE_ID(+) = OV.ORGANIZATION_STRUCTURE_ID
AND OV.ORG_STRUCTURE_VERSION_ID(+) = BGT.ORG_STRUCTURE_VERSION_ID
AND BGT.PERIOD_SET_NAME = PC.PERIOD_SET_NAME WITH READ ONLY

Columns