VIEW: APPS.HRFV_MANPOWER_BUDGETS

Source

View Text - Preformatted

SELECT bgrT.name business_group_name ,bud.name budget_name ,hr_bis.bis_decode_lookup('BUDGET_MEASUREMENT_TYPE',bud.unit) budget_measurement_type ,bud.unit budget_measurement_code ,cal.actual_period_type budget_frequency ,bver.version_number budget_version_number ,bver.date_from budget_version_start_date ,bver.date_to budget_version_end_date ,ptp.period_name budget_period_name ,ptp.start_date budget_period_start_date ,ptp.end_date budget_period_end_date ,bval.value planned_value ,hr_discoverer.get_actual_budget_values (bud.unit ,bgrT.organization_id ,orgT.organization_id ,jbt.job_id ,pft.position_id ,gdt.grade_id ,ptp.start_date ,ptp.end_date ,bval.value ) actual_value ,orgT.name organization_name ,jbt.name job_name ,pft.name position_name ,gdt.name grade_name ,'_DF:PER:PER_BUDGETS:bud' ,'_DF:PER:PER_BUDGET_VERSIONS:bver' ,bver.budget_id budget_id ,bval.time_period_id budget_period_id ,bgrT.organization_id business_group_id ,gdt.grade_id grade_id ,jbt.job_id job_id ,orgT.organization_id organization_id ,pft.position_id position_id FROM hr_all_organization_units_tl bgrT ,hr_all_organization_units_tl orgT ,per_jobs_tl jbt ,hr_all_positions_f_tl pft ,per_grades_tl gdt ,pay_calendars cal ,per_time_periods ptp ,per_budgets bud ,per_budget_versions bver ,per_budget_elements bele ,per_budget_values bval WHERE bval.budget_element_id = bele.budget_element_id AND bele.organization_id = orgT.organization_id (+) AND orgT.language (+) = userenv('LANG') AND bele.job_id = jbt.job_id (+) AND jbt.language (+) = userenv('LANG') AND bele.position_id = pft.position_id (+) AND pft.language (+) = userenv('LANG') AND bele.grade_id = gdt.grade_id (+) AND gdt.language (+) = userenv('LANG') AND bele.budget_version_id = bver.budget_version_id AND bver.budget_id = bud.budget_id AND bud.period_set_name = cal.period_set_name AND bval.time_period_id = ptp.time_period_id AND bval.business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND bval.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, bval.business_group_id) WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, BUD.NAME BUDGET_NAME
, HR_BIS.BIS_DECODE_LOOKUP('BUDGET_MEASUREMENT_TYPE'
, BUD.UNIT) BUDGET_MEASUREMENT_TYPE
, BUD.UNIT BUDGET_MEASUREMENT_CODE
, CAL.ACTUAL_PERIOD_TYPE BUDGET_FREQUENCY
, BVER.VERSION_NUMBER BUDGET_VERSION_NUMBER
, BVER.DATE_FROM BUDGET_VERSION_START_DATE
, BVER.DATE_TO BUDGET_VERSION_END_DATE
, PTP.PERIOD_NAME BUDGET_PERIOD_NAME
, PTP.START_DATE BUDGET_PERIOD_START_DATE
, PTP.END_DATE BUDGET_PERIOD_END_DATE
, BVAL.VALUE PLANNED_VALUE
, HR_DISCOVERER.GET_ACTUAL_BUDGET_VALUES (BUD.UNIT
, BGRT.ORGANIZATION_ID
, ORGT.ORGANIZATION_ID
, JBT.JOB_ID
, PFT.POSITION_ID
, GDT.GRADE_ID
, PTP.START_DATE
, PTP.END_DATE
, BVAL.VALUE ) ACTUAL_VALUE
, ORGT.NAME ORGANIZATION_NAME
, JBT.NAME JOB_NAME
, PFT.NAME POSITION_NAME
, GDT.NAME GRADE_NAME
, '_DF:PER:PER_BUDGETS:BUD'
, '_DF:PER:PER_BUDGET_VERSIONS:BVER'
, BVER.BUDGET_ID BUDGET_ID
, BVAL.TIME_PERIOD_ID BUDGET_PERIOD_ID
, BGRT.ORGANIZATION_ID BUSINESS_GROUP_ID
, GDT.GRADE_ID GRADE_ID
, JBT.JOB_ID JOB_ID
, ORGT.ORGANIZATION_ID ORGANIZATION_ID
, PFT.POSITION_ID POSITION_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, PER_JOBS_TL JBT
, HR_ALL_POSITIONS_F_TL PFT
, PER_GRADES_TL GDT
, PAY_CALENDARS CAL
, PER_TIME_PERIODS PTP
, PER_BUDGETS BUD
, PER_BUDGET_VERSIONS BVER
, PER_BUDGET_ELEMENTS BELE
, PER_BUDGET_VALUES BVAL
WHERE BVAL.BUDGET_ELEMENT_ID = BELE.BUDGET_ELEMENT_ID
AND BELE.ORGANIZATION_ID = ORGT.ORGANIZATION_ID (+)
AND ORGT.LANGUAGE (+) = USERENV('LANG')
AND BELE.JOB_ID = JBT.JOB_ID (+)
AND JBT.LANGUAGE (+) = USERENV('LANG')
AND BELE.POSITION_ID = PFT.POSITION_ID (+)
AND PFT.LANGUAGE (+) = USERENV('LANG')
AND BELE.GRADE_ID = GDT.GRADE_ID (+)
AND GDT.LANGUAGE (+) = USERENV('LANG')
AND BELE.BUDGET_VERSION_ID = BVER.BUDGET_VERSION_ID
AND BVER.BUDGET_ID = BUD.BUDGET_ID
AND BUD.PERIOD_SET_NAME = CAL.PERIOD_SET_NAME
AND BVAL.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID
AND BVAL.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND BVAL.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, BVAL.BUSINESS_GROUP_ID) WITH READ ONLY