VIEW: APPS.IRCFV_VACANCY_COMP_RQRMNTS

Source

View Text - Preformatted

SELECT vac.NAME vacancy_name ,bgrT.NAME business_group_name ,cmp.NAME competence_name ,rlv_min.NAME min_rating_level_name ,rlv_min.step_value min_level_step_value ,rlv_max.NAME max_rating_level_name ,rlv_max.step_value max_level_step_value ,hr_bis.bis_decode_lookup('YES_NO', cel.mandatory) essential ,vac.business_group_id business_group_id ,vac.organization_id organization_id ,vac.job_id job_id ,vac.position_id position_id ,vac.grade_id grade_id ,cel.competence_element_id competence_element_id ,cel.competence_id competence_id ,cel.enterprise_id enterprise_id ,cel.object_id vacancy_id ,cel.proficiency_level_id min_level_id ,cel.high_proficiency_level_id max_level_id FROM per_all_vacancies vac ,per_competences cmp ,per_competence_elements cel ,per_rating_levels rlv_min ,per_rating_levels rlv_max ,hr_all_organization_units_tl bgrT WHERE cel.competence_id = cmp.competence_id AND cel.proficiency_level_id = rlv_min.rating_level_id (+) AND cel.high_proficiency_level_id = rlv_max.rating_level_id (+) AND cel.type = 'REQUIREMENT' AND bgrT.organization_id = vac.business_group_id AND bgrt.LANGUAGE = USERENV('LANG') AND vac.vacancy_id = cel.object_id AND cel.object_name = 'VACANCY' WITH READ ONLY

View Text - HTML Formatted

SELECT VAC.NAME VACANCY_NAME
, BGRT.NAME BUSINESS_GROUP_NAME
, CMP.NAME COMPETENCE_NAME
, RLV_MIN.NAME MIN_RATING_LEVEL_NAME
, RLV_MIN.STEP_VALUE MIN_LEVEL_STEP_VALUE
, RLV_MAX.NAME MAX_RATING_LEVEL_NAME
, RLV_MAX.STEP_VALUE MAX_LEVEL_STEP_VALUE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CEL.MANDATORY) ESSENTIAL
, VAC.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, VAC.ORGANIZATION_ID ORGANIZATION_ID
, VAC.JOB_ID JOB_ID
, VAC.POSITION_ID POSITION_ID
, VAC.GRADE_ID GRADE_ID
, CEL.COMPETENCE_ELEMENT_ID COMPETENCE_ELEMENT_ID
, CEL.COMPETENCE_ID COMPETENCE_ID
, CEL.ENTERPRISE_ID ENTERPRISE_ID
, CEL.OBJECT_ID VACANCY_ID
, CEL.PROFICIENCY_LEVEL_ID MIN_LEVEL_ID
, CEL.HIGH_PROFICIENCY_LEVEL_ID MAX_LEVEL_ID
FROM PER_ALL_VACANCIES VAC
, PER_COMPETENCES CMP
, PER_COMPETENCE_ELEMENTS CEL
, PER_RATING_LEVELS RLV_MIN
, PER_RATING_LEVELS RLV_MAX
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
WHERE CEL.COMPETENCE_ID = CMP.COMPETENCE_ID
AND CEL.PROFICIENCY_LEVEL_ID = RLV_MIN.RATING_LEVEL_ID (+)
AND CEL.HIGH_PROFICIENCY_LEVEL_ID = RLV_MAX.RATING_LEVEL_ID (+)
AND CEL.TYPE = 'REQUIREMENT'
AND BGRT.ORGANIZATION_ID = VAC.BUSINESS_GROUP_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND VAC.VACANCY_ID = CEL.OBJECT_ID
AND CEL.OBJECT_NAME = 'VACANCY' WITH READ ONLY