[Home] [Help]
View: ICX_PO_SUPPLIER_INFO_V
View Text
SELECT PV.VENDOR_NAME
, PV.SEGMENT1
, PV.VENDOR_ID
, VS.VENDOR_SITE_ID
, VS.VENDOR_SITE_CODE
, VS.ADDRESS_LINE1
, VS.ADDRESS_LINE2
, VS.ADDRESS_LINE3
, (VS.CITY ||'
, '|| DECODE(VS.STATE
, NULL
, DECODE(VS.PROVINCE
, NULL
, VS.COUNTY
, VS.PROVINCE)
, VS.STATE) ||'
, '||ZIP)
, VS.COUNTRY
, VS.AREA_CODE ||' '||VS.PHONE
, VS.FAX_AREA_CODE ||' '||VS.FAX
, PV.ATTRIBUTE14
FROM PO_VENDORS PV
, PO_VENDOR_SITES VS
WHERE PV.VENDOR_ID = VS.VENDOR_ID
Columns
Name |
VENDOR_NAME |
VENDOR_NUM |
VENDOR_ID |
VENDOR_SITE_ID |
VENDOR_SITE_CODE |
ADDRESS_LINE1 |
ADDRESS_LINE2 |
ADDRESS_LINE3 |
CITY_STATE_ZIP |
COUNTRY |
PHONE |
FAX |
SUPPLIER_URL |