VIEW: APPS.OKL_CS_VENDOR_CONTACTS_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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