VIEW: APPS.OTA_VENDOR_CONTACTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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