View: ICX_SUPPLIER_ACCOUNT_V

Product:	ICX - Oracle iProcurement
Description:	Supplier Site Address and Contact View
Implementation/DBA Data:	APPS.ICX_SUPPLIER_ACCOUNT_V

View Text

SELECT SUPP.VENDOR_ID
, SUPP.VENDOR_NAME
, SUPP_ADDR.VENDOR_SITE_ID
, SUPP_ADDR.COUNTRY
, SUPP_ADDR.ADDRESS_LINE1||DECODE(SUPP_ADDR.ADDRESS_LINE2
, NULL
, NULL
, '
')||SUPP_ADDR.ADDRESS_LINE2||DECODE(SUPP_ADDR.ADDRESS_LINE3
, NULL
, NULL
, '
')||SUPP_ADDR.ADDRESS_LINE3 ADDRESS
, SUPP_ADDR.ADDRESS_LINE1
, SUPP_ADDR.ADDRESS_LINE2
, SUPP_ADDR.ADDRESS_LINE3
, SUPP_ADDR.CITY
, SUPP_ADDR.PROVINCE
, SUPP_ADDR.COUNTY
, SUPP_ADDR.STATE
, SUPP_ADDR.ZIP
, CONT.VENDOR_CONTACT_ID
, CONT.FIRST_NAME||' '||CONT.LAST_NAME NAME
, CONT.LAST_NAME
, CONT.FIRST_NAME
, CONT.MAIL_STOP
, CONT.PHONE
, SUPP_ADDR.ORG_ID
FROM PO_VENDORS SUPP
, PO_VENDOR_SITES_ALL SUPP_ADDR
, PO_VENDOR_CONTACTS CONT
WHERE CONT.VENDOR_SITE_ID = SUPP_ADDR.VENDOR_SITE_ID
AND SUPP_ADDR.VENDOR_ID = SUPP.VENDOR_ID

Columns