View: POR_SUPPLIER_LOV_V

Product:	ICX - Oracle iProcurement
Description:	List of Values for Suppliers
Implementation/DBA Data:	APPS.POR_SUPPLIER_LOV_V

View Text

SELECT PSV.VENDOR_ID
, PSSV.VENDOR_SITE_ID
, PSCV.VENDOR_CONTACT_ID
, PSV.VENDOR_NAME
, (DECODE (PSCV.FIRST_NAME
, NULL
, PSCV.LAST_NAME
, PSCV.LAST_NAME||'
, '||PSCV.FIRST_NAME) )
, PSSV.ADDRESS_LINE1
, PSSV.ADDRESS_LINE2
, PSSV.ADDRESS_LINE3
, PSSV.CITY
, PSSV.STATE
, PSSV.ZIP
, PSSV.COUNTRY
, (PSCV.AREA_CODE||' '||PSCV.PHONE) TELEPHONE
, PSSV.VENDOR_SITE_CODE
FROM PO_VENDORS PSV
, PO_VENDOR_CONTACTS PSCV
, PO_VENDOR_SITES PSSV
WHERE NVL(PSV.ENABLED_FLAG
, 'Y') = 'Y'
AND PSV.VENDOR_ID = PSSV.VENDOR_ID(+)
AND (PSV.VENDOR_TYPE_LOOKUP_CODE IS NULL OR PSV.VENDOR_TYPE_LOOKUP_CODE <> 'EMPLOYEE')
AND (SYSDATE BETWEEN NVL(PSV.START_DATE_ACTIVE
, SYSDATE-1)
AND NVL(PSV.END_DATE_ACTIVE
, SYSDATE+1))
AND (PSSV.PURCHASING_SITE_FLAG = 'Y' OR PSSV.RFQ_ONLY_SITE_FLAG = 'Y')
AND SYSDATE < NVL(PSCV.INACTIVE_DATE
, SYSDATE + 1)
AND SYSDATE < NVL(PSSV.INACTIVE_DATE
, SYSDATE + 1)
AND PSSV.VENDOR_SITE_ID = PSCV.VENDOR_SITE_ID(+)
AND NVL(PSCV.VENDOR_CONTACT_ID
, -9999) = ( SELECT /*+ NO_UNNEST */ NVL(MIN(VENDOR_CONTACT_ID)
, -9999)
FROM PO_SUPPLIER_CONTACTS_VAL_V PSCV2
WHERE PSSV.VENDOR_SITE_ID = PSCV2.VENDOR_SITE_ID)

Columns