VIEW: APPS.ICX_SUPPLIER_CONTACT_LOV

Source

View Text - Preformatted

SELECT A.FIRST_NAME , A.LAST_NAME , A.LAST_NAME||', '||A.FIRST_NAME , A.VENDOR_CONTACT_ID , C.VENDOR_NAME , B.VENDOR_SITE_CODE , B.CITY||' '||B.STATE FROM PO_VENDORS C, PO_VENDOR_SITES_ALL B, PO_VENDOR_CONTACTS A WHERE A.VENDOR_SITE_ID = B.VENDOR_SITE_ID AND B.VENDOR_ID = C.VENDOR_ID

View Text - HTML Formatted

SELECT A.FIRST_NAME
, A.LAST_NAME
, A.LAST_NAME||'
, '||A.FIRST_NAME
, A.VENDOR_CONTACT_ID
, C.VENDOR_NAME
, B.VENDOR_SITE_CODE
, B.CITY||' '||B.STATE
FROM PO_VENDORS C
, PO_VENDOR_SITES_ALL B
, PO_VENDOR_CONTACTS A
WHERE A.VENDOR_SITE_ID = B.VENDOR_SITE_ID
AND B.VENDOR_ID = C.VENDOR_ID