Skip to content
[Home] [Help]
View: PO_SUPPLIER_SITES_ALL_V
View Text
SELECT VENDOR_ID
, VENDOR_SITE_CODE
, ADDRESS_LINE1
, CITY
, STATE
, VENDOR_SITE_ID
, VENDOR_ID SHIP_TO_LOCATION_ID
, BILL_TO_LOCATION_ID
, SHIP_VIA_LOOKUP_CODE
, FOB_LOOKUP_CODE
, FREIGHT_TERMS_LOOKUP_CODE
, ADDRESS_LINE2
, ADDRESS_LINE3
, ZIP
, COUNTRY
, '('||AREA_CODE||') '||PHONE TELEPHONE
, '('||FAX_AREA_CODE||') '||FAX FAX
FROM PO_VENDOR_SITES
Columns
| Name |
| VENDOR_ID |
| VENDOR_SITE_CODE |
| ADDRESS_LINE1 |
| CITY |
| STATE |
| VENDOR_SITE_ID |
| SHIP_TO_LOCATION_ID |
| BILL_TO_LOCATION_ID |
| SHIP_VIA_LOOKUP_CODE |
| FOB_LOOKUP_CODE |
| FREIGHT_TERMS_LOOKUP_CODE |
| ADDRESS_LINE2 |
| ADDRESS_LINE3 |
| ZIP |
| COUNTRY |
| TELEPHONE |
| FAX |