[Home] [Help]
View: POBV_SUPPLIER_CONTACTS
View Text
SELECT 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
, VC.VENDOR_SITE_ID
, 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 WITH READ ONLY
Columns
Name |
SUPPLIER_CONTACT_ID |
LAST_NAME |
FIRST_NAME |
MIDDLE_NAME |
PREFIX |
TITLE |
AREA_CODE |
PHONE |
MAIL_STOP |
INACTIVE_DATE |
SUPPLIER_SITE_ID |
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 |