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_DISBURSEMENTS_COUNT_UV

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

View Text

SELECT POV.SEGMENT1 VENDOR_NUMBER
, CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, COUNT(*) DISBURSEMENTS_COUNT
, SUM(TAP.AMOUNT) TOTAL_DISBURSEMENTS
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 GROUP BY POV.SEGMENT1
, CONTRACT_NUMBER

Columns

Name
VENDOR_NUMBER
CONTRACT_NUMBER
DISBURSEMENTS_COUNT
TOTAL_DISBURSEMENTS