View: OTA_VENDOR_ADDRESSES_V

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

View Text

SELECT ADR.ROWID
, ADR.VENDOR_ID
, ADR.VENDOR_SITE_ID
, ADR.ADDRESS_LINE1
, ADR.ADDRESS_LINE2
, ADR.ADDRESS_LINE3
, ADR.CITY
, ADR.STATE
, ADR.ZIP
, ADR.PROVINCE
, ADR.COUNTRY
, ADR.AREA_CODE
, RTRIM( REPLACE( REPLACE( REPLACE( ADR.ADDRESS_LINE1|| '
, '|| ADR.ADDRESS_LINE2 || '
, '||ADR.ADDRESS_LINE3 || '
, '||ADR.CITY || '
, '||ADR.PROVINCE || '
, '||ADR.ZIP || '
, '||ADR.AREA_CODE||'
, '
, '
,
, '
, '
, ')
, '
,
, '
, '
, ')
, '
,
, '
, '
, ')
, '
, ')
FROM PO_VENDOR_SITES_ALL ADR

Columns