VIEW: APPS.ICX_INTERNAL_CONTACT_LOV

Source

View Text - Preformatted

SELECT A.FIRST_NAME , A.LAST_NAME , A.FULL_NAME , A.EMAIL_ADDRESS , A.PERSON_ID , C.NAME , B.LOCATION_CODE , B.TOWN_OR_CITY FROM HR_LOCATIONS B, HR_ORGANIZATION_UNITS C, PER_ASSIGNMENTS_X D, PER_PEOPLE_X A WHERE A.PERSON_ID = D.PERSON_ID AND D.PRIMARY_FLAG = 'Y' AND D.ORGANIZATION_ID = C.ORGANIZATION_ID AND D.LOCATION_ID = B.LOCATION_ID(+)

View Text - HTML Formatted

SELECT A.FIRST_NAME
, A.LAST_NAME
, A.FULL_NAME
, A.EMAIL_ADDRESS
, A.PERSON_ID
, C.NAME
, B.LOCATION_CODE
, B.TOWN_OR_CITY
FROM HR_LOCATIONS B
, HR_ORGANIZATION_UNITS C
, PER_ASSIGNMENTS_X D
, PER_PEOPLE_X A
WHERE A.PERSON_ID = D.PERSON_ID
AND D.PRIMARY_FLAG = 'Y'
AND D.ORGANIZATION_ID = C.ORGANIZATION_ID
AND D.LOCATION_ID = B.LOCATION_ID(+)