View: ICX_REQ_SUPPLIERS_V

Product:	ICX - Oracle iProcurement
Description:	Web Requisitions Suppliers LOV View
Implementation/DBA Data:	APPS.ICX_REQ_SUPPLIERS_V

View Text

SELECT PSV.VENDOR_NAME
, PSCV.CONTACT
, PSSV.ADDRESS_LINE1
, PSSV.ADDRESS_LINE2
, PSSV.ADDRESS_LINE3
, PSSV.CITY
, PSSV.STATE
, PSSV.ZIP
, PSSV.COUNTRY
, PSCV.TELEPHONE
, PSSV.VENDOR_SITE_CODE
FROM PO_SUPPLIERS_VAL_V PSV
, PO_SUPPLIER_CONTACTS_VAL_V PSCV
, PO_SUPPLIER_SITES_VAL_V PSSV
WHERE PSV.VENDOR_ID = PSSV.VENDOR_ID(+)
AND PSSV.VENDOR_SITE_ID = PSCV.VENDOR_SITE_ID(+)
AND NVL(PSCV.VENDOR_CONTACT_ID
, -999) = (SELECT NVL(MIN(VENDOR_CONTACT_ID)
, -999)
FROM PO_SUPPLIER_CONTACTS_VAL_V PSCV2
WHERE PSSV.VENDOR_SITE_ID = PSCV2.VENDOR_SITE_ID)

Columns