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_RECONCILE_UV

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

View Text

SELECT V1.VENDOR_PROGRAM
, V1.NAME
, V1.CONTRACT_NUMBER
, V1.ELIGIBLE_CURE_AMOUNT
, V1.CLAIMED_CURE_AMOUNT
, V2.CURES_IN_POSSESSION
, NULL
, V2.AMOUNT_RECEIVED
, V1.REPURCHASE_AMOUNT
, V2.CURED_FLAG
, V1.REPORT_DATE
, V1.REPORT_NUMBER
, V1.REPORT_ID
, V1.CHR_ID
FROM OKL_RECONCILE_CURES_UV V2
, OKL_RECONCILE_DISPLAY_UV V1
WHERE V1.CHR_ID = V2. CHR_ID(+)

Columns

Name
VENDOR_PROGRAM
NAME
CONTRACT_NUMBER
ELIGIBLE_CURE_AMOUNT
CLAIMED_CURE_AMOUNT
CURES_IN_POSSESSION
CHOICE
AMOUNT_RECEIVED
REPURCHASE_AMOUNT
CURED_FLAG
REPORT_DATE
REPORT_NUMBER
REPORT_ID
CHR_ID