View: MTL_SUPPLIER_SITES_V

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.MTL_SUPPLIER_SITES_V

View Text

SELECT ORG.ORGANIZATION_ID
, ORG.OPERATING_UNIT
, 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
FROM PO_VENDOR_SITES_ALL PO
, ORG_ORGANIZATION_DEFINITIONS ORG
WHERE NVL(PO.ORG_ID
, -99) =NVL( ORG.OPERATING_UNIT
, -99)
AND PO.PURCHASING_SITE_FLAG = 'Y'
AND SYSDATE < NVL(PO.INACTIVE_DATE
, SYSDATE + 1)

Columns