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.

[Home] [Help]

View: OKL_CS_VENDOR_SEARCH_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_CS_VENDOR_SEARCH_UV

View Text

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

Columns

Name
VENDOR_NAME
LAST_NAME
FIRST_NAME
INVOICE_NUMBER
VENDOR_INVOICE_NUMBER
VENDOR_NUMBER
VENDOR_ADR1
VENDOR_CITY
VENDOR_STATE
VENDOR_COUNTRY
VENDOR_ZIP
VENDOR_AREA_CODE
VENDOR_PHONE
VENDOR_CUSTOMER_NUM
VENDOR_ID