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_CURE_HISTORY_UV

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

View Text

SELECT CRHB.CURE_HISTORY_ID ID
, LV.DESCRIPTION DESCRIPTION
, CRHT.STATUS STATUS
, CRHT.ACTION ACTION
, CRHB.REFERENCE_NUMBER REFERENCE_NUMBER
, CRHB.AMOUNT AMOUNT
, CRHB.ACTION_DATE ACTION_DATE
, CRHT.COMMENTS COMMENTS
, CRHB.CHR_ID CHR_ID
FROM OKL_CURE_HISTORYS_B CRHB
, OKL_CURE_HISTORYS_TL CRHT
, FND_LOOKUP_VALUES LV
WHERE CRHB.CURE_HISTORY_ID = CRHT.CURE_HISTORY_ID
AND CRHT.LANGUAGE = USERENV('LANG')
AND LV.LOOKUP_TYPE = 'OKL_CURE_ACTIONS'
AND CRHT.ACTION = LV.LOOKUP_CODE
AND LV.LANGUAGE = USERENV('LANG')
AND LV.VIEW_APPLICATION_ID = 0
AND LV.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(LV.LOOKUP_TYPE
, LV.VIEW_APPLICATION_ID)
AND NVL(LV.END_DATE_ACTIVE
, SYSDATE+1) > SYSDATE

Columns

Name
ID
DESCRIPTION
STATUS
ACTION
REFERENCE_NUMBER
AMOUNT
ACTION_DATE
COMMENTS
CHR_ID