View: ICX_INTERNAL_CONTACT_LOV

Product:	ICX - Oracle iProcurement
Description:	Internal Contact LOV View
Implementation/DBA Data:	APPS.ICX_INTERNAL_CONTACT_LOV

View Text

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(+)

Columns