eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: POFV_SUPPLIER_CONTACTS

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.POFV_SUPPLIER_CONTACTS

View Text

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

Columns

Name
SUPPLIER_CONTACT_ID
LAST_NAME
FIRST_NAME
MIDDLE_NAME
PREFIX
TITLE
AREA_CODE
PHONE
MAIL_STOP
INACTIVE_DATE
"_DF"
SUPPLIER_SITE_ID
SUPPLIER_SITE
CREATED_DATE
CREATED_BY
LAST_UPDATED_DATE
LAST_UPDATED_BY
CONTACT_NAME_ALT
FIRST_NAME_ALT
LAST_NAME_ALT
DEPARTMENT
EMAIL_ADDRESS
URL
ALT_AREA_CODE
ALT_PHONE
FAX_AREA_CODE
FAX