[Home] [Help]
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
Name |
VENDOR_ID |
VENDOR_SITE_ID |
VENDOR_CONTACT_ID |
VENDOR_NAME |
CONTACT |
ADDRESS_LINE1 |
ADDRESS_LINE2 |
ADDRESS_LINE3 |
CITY |
STATE |
ZIP |
COUNTRY |
TELEPHONE |
VENDOR_SITE_CODE |