[Home] [Help]
View: POS_ASN_SITE_LOV_V
View Text
SELECT VS.VENDOR_ID
, VE.VENDOR_NAME
, VS.VENDOR_SITE_ID
, VS.VENDOR_SITE_CODE
, VS.ADDRESS_LINE1 || ' ' || VS.ADDRESS_LINE2 || ' ' || VS.ADDRESS_LINE3 || ' ' || VS.CITY || '
, ' || VS.STATE || ' ' || VS.ZIP || ' ' || VS.COUNTRY
, VS.VENDOR_ID
, VS.VENDOR_SITE_ID
FROM PO_VENDOR_SITES VS
, PO_VENDORS VE
WHERE VS.VENDOR_ID = VE.VENDOR_ID
Columns
Name |
SUPPLIER_ID |
SUPPLIER_NAME |
SUPPLIER_SITE_ID |
SUPPLIER_SITE_CODE |
SUPPLIER_SITE_ADDRESS |
SEC_SUPPLIER_ID |
SEC_SUPPLIER_SITE_ID |