VIEW: APPS.HRFV_POSITIONS

Source

View Text - Preformatted

SELECT bgrT.name business_group_name ,posT.name position_name ,'_KF:PER:POS:pdef' ,pos.date_effective date_from ,pos.date_end date_to ,pos.working_hours working_hours_amount ,hr_bis.bis_decode_lookup('FREQUENCY',pos.frequency) working_hours_frequency ,pos.probation_period probation_period ,hr_bis.bis_decode_lookup('FREQUENCY',pos.probation_period_units) probation_units ,pos.time_normal_start normal_start_time ,pos.time_normal_finish normal_end_time ,pos.comments comments ,pft.name replacement_position_name ,orgT.name organization_name ,jbt.name job_name ,locT.location_code location_name ,'_DF:PER:PER_POSITIONS:pos' ,pos.business_group_id business_group_id ,pos.job_id job_id ,pos.location_id location_id ,pos.organization_id organization_id ,pos.position_id position_id ,pdef.position_definition_id position_definition_id ,pos.relief_position_id relief_position_id FROM per_position_definitions pdef ,hr_all_organization_units_tl orgT ,hr_all_organization_units_tl bgrT ,per_jobs_tl jbt ,hr_locations_all_tl locT ,hr_all_positions_f_tl pft ,hr_all_positions_f_tl posT ,per_all_positions pos WHERE pdef.position_definition_id = pos.position_definition_id AND pdef.enabled_flag = 'Y' AND pos.relief_position_id = pft.position_id(+) AND pft.language (+) = userenv('LANG') AND pos.organization_id = orgT.organization_id AND orgT.language = userenv('LANG') AND pos.job_id = jbt.job_id AND jbt.language (+) = userenv('LANG') AND pos.location_id = locT.location_id(+) AND locT.language (+) = userenv('LANG') AND pos.business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND pos.position_id = posT.position_id AND posT.language = userenv('LANG') AND pos.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, pos.business_group_id) WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, POST.NAME POSITION_NAME
, '_KF:PER:POS:PDEF'
, POS.DATE_EFFECTIVE DATE_FROM
, POS.DATE_END DATE_TO
, POS.WORKING_HOURS WORKING_HOURS_AMOUNT
, HR_BIS.BIS_DECODE_LOOKUP('FREQUENCY'
, POS.FREQUENCY) WORKING_HOURS_FREQUENCY
, POS.PROBATION_PERIOD PROBATION_PERIOD
, HR_BIS.BIS_DECODE_LOOKUP('FREQUENCY'
, POS.PROBATION_PERIOD_UNITS) PROBATION_UNITS
, POS.TIME_NORMAL_START NORMAL_START_TIME
, POS.TIME_NORMAL_FINISH NORMAL_END_TIME
, POS.COMMENTS COMMENTS
, PFT.NAME REPLACEMENT_POSITION_NAME
, ORGT.NAME ORGANIZATION_NAME
, JBT.NAME JOB_NAME
, LOCT.LOCATION_CODE LOCATION_NAME
, '_DF:PER:PER_POSITIONS:POS'
, POS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, POS.JOB_ID JOB_ID
, POS.LOCATION_ID LOCATION_ID
, POS.ORGANIZATION_ID ORGANIZATION_ID
, POS.POSITION_ID POSITION_ID
, PDEF.POSITION_DEFINITION_ID POSITION_DEFINITION_ID
, POS.RELIEF_POSITION_ID RELIEF_POSITION_ID
FROM PER_POSITION_DEFINITIONS PDEF
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_JOBS_TL JBT
, HR_LOCATIONS_ALL_TL LOCT
, HR_ALL_POSITIONS_F_TL PFT
, HR_ALL_POSITIONS_F_TL POST
, PER_ALL_POSITIONS POS
WHERE PDEF.POSITION_DEFINITION_ID = POS.POSITION_DEFINITION_ID
AND PDEF.ENABLED_FLAG = 'Y'
AND POS.RELIEF_POSITION_ID = PFT.POSITION_ID(+)
AND PFT.LANGUAGE (+) = USERENV('LANG')
AND POS.ORGANIZATION_ID = ORGT.ORGANIZATION_ID
AND ORGT.LANGUAGE = USERENV('LANG')
AND POS.JOB_ID = JBT.JOB_ID
AND JBT.LANGUAGE (+) = USERENV('LANG')
AND POS.LOCATION_ID = LOCT.LOCATION_ID(+)
AND LOCT.LANGUAGE (+) = USERENV('LANG')
AND POS.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND POS.POSITION_ID = POST.POSITION_ID
AND POST.LANGUAGE = USERENV('LANG')
AND POS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, POS.BUSINESS_GROUP_ID) WITH READ ONLY