VIEW: APPS.HRFV_JOB_AND_POS_REQUIREMENTS

Source

View Text - Preformatted

SELECT bgrT.name business_group_name ,jbt.name job_name ,pft.name position_name ,pjr.comments comments ,hr_bis.bis_decode_lookup('YES_NO',pjr.essential) essential ,flex.id_flex_structure_name information_type ,'_DF:PER:PER_JOB_REQUIREMENTS:pjr' ,'_KF:PER:PEA:pac' ,pjr.job_id job_id ,pjr.position_id position_id FROM per_job_requirements pjr ,hr_all_organization_units_tl bgrT ,per_jobs_tl jbt ,hr_all_positions_f_tl pft ,per_analysis_criteria pac ,fnd_id_flex_structures_vl flex WHERE pjr.job_id = jbt.job_id (+) AND jbt.language(+) = userenv('LANG') AND pjr.position_id = pft.position_id (+) AND pft.language(+) = userenv('LANG') AND pjr.analysis_criteria_id = pac.analysis_criteria_id AND pjr.business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND pac.id_flex_num = flex.id_flex_num AND pjr.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, pjr.business_group_id) WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, JBT.NAME JOB_NAME
, PFT.NAME POSITION_NAME
, PJR.COMMENTS COMMENTS
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PJR.ESSENTIAL) ESSENTIAL
, FLEX.ID_FLEX_STRUCTURE_NAME INFORMATION_TYPE
, '_DF:PER:PER_JOB_REQUIREMENTS:PJR'
, '_KF:PER:PEA:PAC'
, PJR.JOB_ID JOB_ID
, PJR.POSITION_ID POSITION_ID
FROM PER_JOB_REQUIREMENTS PJR
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_JOBS_TL JBT
, HR_ALL_POSITIONS_F_TL PFT
, PER_ANALYSIS_CRITERIA PAC
, FND_ID_FLEX_STRUCTURES_VL FLEX
WHERE PJR.JOB_ID = JBT.JOB_ID (+)
AND JBT.LANGUAGE(+) = USERENV('LANG')
AND PJR.POSITION_ID = PFT.POSITION_ID (+)
AND PFT.LANGUAGE(+) = USERENV('LANG')
AND PJR.ANALYSIS_CRITERIA_ID = PAC.ANALYSIS_CRITERIA_ID
AND PJR.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND PAC.ID_FLEX_NUM = FLEX.ID_FLEX_NUM
AND PJR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PJR.BUSINESS_GROUP_ID) WITH READ ONLY