FND Design Data [Home] [Help]

View: PO_SUPPLIER_SITES_ALL_V

Product: PO - Purchasing
Description: 10SC ONLY - Retrofitted
Implementation/DBA Data: ViewAPPS.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