View: PO_SUPPLIER_SITES_VAL_V

Product:	PO - Purchasing
Description:	10SC ONLY - Retrofitted
Implementation/DBA Data:	APPS.PO_SUPPLIER_SITES_VAL_V

View Text

SELECT 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
, INVOICE_CURRENCY_CODE
, RFQ_ONLY_SITE_FLAG
, PCARD_SITE_FLAG
, ORG_ID
FROM PO_VENDOR_SITES
WHERE (PURCHASING_SITE_FLAG = 'Y' OR RFQ_ONLY_SITE_FLAG = 'Y')
AND SYSDATE < NVL(INACTIVE_DATE
, SYSDATE + 1)

Columns