[Home] [Help]
View: POS_ACK_SITE_LOV_V
View Text
SELECT VENDOR_ID
, VENDOR_SITE_ID
, VENDOR_ID
, VENDOR_SITE_ID
, VENDOR_SITE_CODE
, ADDRESS_LINE1 || ' ' || ADDRESS_LINE2 || ' ' || ADDRESS_LINE3 || ' ' || CITY || '
, ' || STATE || ' ' || ZIP || '
, ' || COUNTRY || '.'
FROM PO_VENDOR_SITES
Columns
Name |
SUPPLIER_ID |
SUPPLIER_SITE_ID |
SUPPLIER_ID2 |
SUPPLIER_SITE_ID2 |
SUPPLIER_SITE_CODE |
SITE_ADDRESS |