View: OKL_CS_VENDOR_CONTACTS_UV

Product:	OKL - Lease and Finance Management
Description:	List of Vendor Contacts
Implementation/DBA Data:	APPS.OKL_CS_VENDOR_CONTACTS_UV

View Text

SELECT POC.PREFIX || ' ' ||POC.FIRST_NAME ||' ' ||POC.MIDDLE_NAME || ' ' ||POC.LAST_NAME CONTACT_NAME
, POC.MAIL_STOP MAIL_STOP
, POC.AREA_CODE || '-' || POC.PHONE PHONE
, POC.TITLE ||'-'|| POC.PHONE DESCRIPTION
, POC.VENDOR_CONTACT_ID VENDOR_CONTACT_ID
, POV.VENDOR_ID VENDOR_ID
, POS.VENDOR_SITE_ID VENDOR_SITE_ID
FROM PO_VENDOR_CONTACTS POC
, PO_VENDOR_SITES_ALL POS
, PO_VENDORS POV
WHERE POV.VENDOR_ID = POS.VENDOR_ID
AND POS.VENDOR_SITE_ID = POC.VENDOR_SITE_ID

Columns