[Home] [Help]
View: POS_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.ADDRESS_STYLE
, 'US'
, VS.STATE
, VS.PROVINCE) ||'
, '||ZIP)
, VS.COUNTRY
, VS.AREA_CODE ||' '||VS.PHONE
, VS.FAX_AREA_CODE ||' '||VS.FAX
, PV.ATTRIBUTE14
FROM PO_VENDORS PV
, PO_VENDOR_SITES_ALL 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 |
APPS.POS_PO_SUPPLIER_INFO_V