VIEW: APPS.HRFV_PHONES

Source

View Text - Preformatted

SELECT bgrT.name business_group_name ,peo.full_name person_name ,hr_bis.bis_decode_lookup('PHONE_TYPE',pho.phone_type) phone_type ,pho.phone_number phone_number ,pho.date_from date_from ,pho.date_to date_to ,NVL(pho.date_to, hr_general.end_of_time) date_to_nn ,peo.employee_number employee_number ,hr_bis.bis_decode_lookup('YES_NO', NVL(peo.current_employee_flag,'N')) current_employee_flag ,hr_bis.bis_decode_lookup('YES_NO', NVL(peo.current_applicant_flag,'N')) current_applicant_flag ,ptT.user_person_type person_type ,HRI_BPL_PERSON_TYPE.get_emp_user_person_type (peo.effective_start_date ,peo.person_id) employee_person_type ,HRI_BPL_PERSON_TYPE.get_apl_user_person_type (peo.effective_start_date ,peo.person_id) applicant_person_type ,HRI_BPL_PERSON_TYPE.get_concat_user_person_type (peo.effective_start_date ,peo.person_id) user_concat_person_type ,'_DF:PER:PER_PHONES:pho' ,pho.phone_type phone_type_code ,peo.current_employee_flag current_employee_flag_code ,peo.current_applicant_flag current_applicant_flag_code ,pt.system_person_type system_person_type_code ,peo.business_group_id business_group_id ,pho.parent_id person_id ,pt.person_type_id person_type_id ,pho.last_update_date phn_last_update_date ,peo.last_update_date peo_last_update_date FROM hr_all_organization_units_tl bgrT ,per_person_types pt ,per_person_types_tl ptT ,per_phones pho ,per_people_x peo WHERE peo.person_id = pho.parent_id AND pho.parent_table = 'PER_ALL_PEOPLE_F' AND peo.person_type_id = pt.person_type_id AND pt.person_type_id = ptT.person_type_id AND ptT.language = userenv('LANG') AND peo.business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND peo.business_group_id = NVL(hr_bis.get_sec_profile_bg_id,peo.business_group_id) WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, HR_BIS.BIS_DECODE_LOOKUP('PHONE_TYPE'
, PHO.PHONE_TYPE) PHONE_TYPE
, PHO.PHONE_NUMBER PHONE_NUMBER
, PHO.DATE_FROM DATE_FROM
, PHO.DATE_TO DATE_TO
, NVL(PHO.DATE_TO
, HR_GENERAL.END_OF_TIME) DATE_TO_NN
, PEO.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, NVL(PEO.CURRENT_EMPLOYEE_FLAG
, 'N')) CURRENT_EMPLOYEE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, NVL(PEO.CURRENT_APPLICANT_FLAG
, 'N')) CURRENT_APPLICANT_FLAG
, PTT.USER_PERSON_TYPE PERSON_TYPE
, HRI_BPL_PERSON_TYPE.GET_EMP_USER_PERSON_TYPE (PEO.EFFECTIVE_START_DATE
, PEO.PERSON_ID) EMPLOYEE_PERSON_TYPE
, HRI_BPL_PERSON_TYPE.GET_APL_USER_PERSON_TYPE (PEO.EFFECTIVE_START_DATE
, PEO.PERSON_ID) APPLICANT_PERSON_TYPE
, HRI_BPL_PERSON_TYPE.GET_CONCAT_USER_PERSON_TYPE (PEO.EFFECTIVE_START_DATE
, PEO.PERSON_ID) USER_CONCAT_PERSON_TYPE
, '_DF:PER:PER_PHONES:PHO'
, PHO.PHONE_TYPE PHONE_TYPE_CODE
, PEO.CURRENT_EMPLOYEE_FLAG CURRENT_EMPLOYEE_FLAG_CODE
, PEO.CURRENT_APPLICANT_FLAG CURRENT_APPLICANT_FLAG_CODE
, PT.SYSTEM_PERSON_TYPE SYSTEM_PERSON_TYPE_CODE
, PEO.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PHO.PARENT_ID PERSON_ID
, PT.PERSON_TYPE_ID PERSON_TYPE_ID
, PHO.LAST_UPDATE_DATE PHN_LAST_UPDATE_DATE
, PEO.LAST_UPDATE_DATE PEO_LAST_UPDATE_DATE
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_PERSON_TYPES PT
, PER_PERSON_TYPES_TL PTT
, PER_PHONES PHO
, PER_PEOPLE_X PEO
WHERE PEO.PERSON_ID = PHO.PARENT_ID
AND PHO.PARENT_TABLE = 'PER_ALL_PEOPLE_F'
AND PEO.PERSON_TYPE_ID = PT.PERSON_TYPE_ID
AND PT.PERSON_TYPE_ID = PTT.PERSON_TYPE_ID
AND PTT.LANGUAGE = USERENV('LANG')
AND PEO.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND PEO.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PEO.BUSINESS_GROUP_ID) WITH READ ONLY