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