eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKL_CS_VENDOR_SEARCH_UV

Source

View Text - Preformatted


SELECT POV.VENDOR_NAME VENDOR_NAME , POVC.LAST_NAME LAST_NAME, POVC.FIRST_NAME FIRST_NAME, CNSLD.INVOICE_NUMBER INVOICE_NUMBER , CNSLD.VENDOR_INVOICE_NUMBER, POV.SEGMENT1 VENDOR_NUMBER, POVS.ADDRESS_LINE1 VENDOR_ADR1, POVS.CITY VENDOR_CITY, POVS.STATE VENDOR_STATE, POVS.COUNTRY VENDOR_COUNTRY, POVS.ZIP VENDOR_ZIP, POVS.AREA_CODE VENDOR_AREA_CODE, POVS.PHONE VENDOR_PHONE, POVS.CUSTOMER_NUM VENDOR_CUSTOMER_NUM, POV.VENDOR_ID FROM AP_SUPPLIER_SITES_ALL POVS,AP_SUPPLIERS POV,AP_SUPPLIER_CONTACTS POVC,OKL_CNSLD_AP_INVS_ALL CNSLD WHERE POVS.VENDOR_ID = POV.VENDOR_ID AND POVS.VENDOR_SITE_ID=POVC.VENDOR_SITE_ID(+) AND CNSLD.IPVS_ID = POVS.VENDOR_SITE_ID AND CNSLD.VENDOR_ID = POVS.VENDOR_ID

View Text - HTML Formatted

SELECT POV.VENDOR_NAME VENDOR_NAME
, POVC.LAST_NAME LAST_NAME
, POVC.FIRST_NAME FIRST_NAME
, CNSLD.INVOICE_NUMBER INVOICE_NUMBER
, CNSLD.VENDOR_INVOICE_NUMBER
, POV.SEGMENT1 VENDOR_NUMBER
, POVS.ADDRESS_LINE1 VENDOR_ADR1
, POVS.CITY VENDOR_CITY
, POVS.STATE VENDOR_STATE
, POVS.COUNTRY VENDOR_COUNTRY
, POVS.ZIP VENDOR_ZIP
, POVS.AREA_CODE VENDOR_AREA_CODE
, POVS.PHONE VENDOR_PHONE
, POVS.CUSTOMER_NUM VENDOR_CUSTOMER_NUM
, POV.VENDOR_ID
FROM AP_SUPPLIER_SITES_ALL POVS
, AP_SUPPLIERS POV
, AP_SUPPLIER_CONTACTS POVC
, OKL_CNSLD_AP_INVS_ALL CNSLD
WHERE POVS.VENDOR_ID = POV.VENDOR_ID
AND POVS.VENDOR_SITE_ID=POVC.VENDOR_SITE_ID(+)
AND CNSLD.IPVS_ID = POVS.VENDOR_SITE_ID
AND CNSLD.VENDOR_ID = POVS.VENDOR_ID