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_ALL_DISBURSEMENTS_UV

Product:	OKL - Leasing and Finance Management
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT DISTINCT POV.VENDOR_NAME VENDOR_NAME
, POV.SEGMENT1 VENDOR_NUMBER
, POVS.ADDRESS_LINE1 ADDRESS
, TAP.KHR_ID KHR_ID
, CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, CHR.ID CHR_ID
FROM PO_VENDOR_SITES_ALL POVS
, PO_VENDORS POV
, OKC_K_HEADERS_B CHR
, OKL_STRM_TYPE_B STY
, OKL_TXL_AP_INV_LNS_B TPL
, OKL_TRX_AP_INVOICES_B TAP
WHERE TAP.ID = TPL.TAP_ID
AND TPL.STY_ID = STY.ID
AND TAP.IPVS_ID = POVS.VENDOR_SITE_ID
AND POVS.VENDOR_ID = POV.VENDOR_ID
AND TAP.KHR_ID = CHR.ID

Columns

Name
VENDOR_NAME
VENDOR_NUMBER
ADDRESS
KHR_ID
CONTRACT_NUMBER
CHR_ID