View: OTA_VENDOR_CONTACTS_V

Product:	OTA - Learning Management
Description:	View to list all Contacts for a Supplier.
Implementation/DBA Data:	APPS.OTA_VENDOR_CONTACTS_V

View Text

SELECT VEN.ROWID
, VEN.VENDOR_ID
, VEN.VENDOR_NAME
, CON.VENDOR_CONTACT_ID
, CON.FIRST_NAME
, CON.LAST_NAME
, CON.LAST_NAME||'
, '||INITCAP(CON.TITLE)||' '||CON.FIRST_NAME
, CON.VENDOR_SITE_ID
, RTRIM( REPLACE( REPLACE( REPLACE( SIT.ADDRESS_LINE1|| '
, '|| SIT.ADDRESS_LINE2 || '
, '||SIT.ADDRESS_LINE3 || '
, '||SIT.CITY || '
, '||SIT.PROVINCE || '
, '||SIT.ZIP || '
, '||SIT.AREA_CODE||'
, '
, '
,
, '
, '
, ')
, '
,
, '
, '
, ')
, '
,
, '
, '
, ')
, '
, ')
, CON.TITLE
, CON.LAST_NAME_ALT
, CON.FIRST_NAME_ALT
FROM PO_VENDORS VEN
, PO_VENDOR_SITES_ALL SIT
, PO_VENDOR_CONTACTS CON
WHERE CON.VENDOR_SITE_ID = SIT.VENDOR_SITE_ID
AND SIT.VENDOR_ID = VEN.VENDOR_ID

Columns