[Home] [Help]
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
Name |
VENDOR_ID |
VENDOR_NAME |
VENDOR_SITE_ID |
COUNTRY |
ADDRESS |
ADDRESS_LINE1 |
ADDRESS_LINE2 |
ADDRESS_LINE3 |
CITY |
PROVINCE |
COUNTY |
STATE |
ZIP |
VENDOR_CONTACT_ID |
NAME |
LAST_NAME |
FIRST_NAME |
MAIL_STOP |
PHONE |
ORG_ID |