View: HRFV_PHONES

Product:	PER - Human Resources
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.HRFV_PHONES

View Text

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
, 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
, '_DF:PER:PER_PHONES:PHO'
, PEO.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PHO.PARENT_ID PERSON_ID
, PT.PERSON_TYPE_ID PERSON_TYPE_ID
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

Columns