VIEW: APPS.POFV_SUPPLIER_CONTACTS

Source

View Text - Preformatted

SELECT DISTINCT VC.VENDOR_CONTACT_ID, VC.LAST_NAME, VC.FIRST_NAME, VC.MIDDLE_NAME, VC.PREFIX, VC.TITLE, VC.AREA_CODE, VC.PHONE, VC.MAIL_STOP, VC.INACTIVE_DATE, '_DF:PO:PO_VENDOR_CONTACTS:vc', VC.VENDOR_SITE_ID, VS.VENDOR_SITE_CODE, VC.CREATION_DATE, VC.CREATED_BY, VC.LAST_UPDATE_DATE, VC.LAST_UPDATED_BY, VC.CONTACT_NAME_ALT, VC.FIRST_NAME_ALT, VC.LAST_NAME_ALT, VC.DEPARTMENT, VC.EMAIL_ADDRESS, VC.URL, VC.ALT_AREA_CODE, VC.ALT_PHONE, VC.FAX_AREA_CODE, VC.FAX FROM PO_VENDOR_CONTACTS VC, PO_VENDOR_SITES_ALL VS WHERE VC.VENDOR_SITE_ID = VS.VENDOR_SITE_ID WITH READ ONLY

View Text - HTML Formatted

SELECT DISTINCT VC.VENDOR_CONTACT_ID
, VC.LAST_NAME
, VC.FIRST_NAME
, VC.MIDDLE_NAME
, VC.PREFIX
, VC.TITLE
, VC.AREA_CODE
, VC.PHONE
, VC.MAIL_STOP
, VC.INACTIVE_DATE
, '_DF:PO:PO_VENDOR_CONTACTS:VC'
, VC.VENDOR_SITE_ID
, VS.VENDOR_SITE_CODE
, VC.CREATION_DATE
, VC.CREATED_BY
, VC.LAST_UPDATE_DATE
, VC.LAST_UPDATED_BY
, VC.CONTACT_NAME_ALT
, VC.FIRST_NAME_ALT
, VC.LAST_NAME_ALT
, VC.DEPARTMENT
, VC.EMAIL_ADDRESS
, VC.URL
, VC.ALT_AREA_CODE
, VC.ALT_PHONE
, VC.FAX_AREA_CODE
, VC.FAX
FROM PO_VENDOR_CONTACTS VC
, PO_VENDOR_SITES_ALL VS
WHERE VC.VENDOR_SITE_ID = VS.VENDOR_SITE_ID WITH READ ONLY