Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_ITM_CAT_RV_PRCS_UV |
SELECT RV.ID ID
, RV.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TO_NUMBER(NULL) CAT_ID1
, NULL CAT_ID2
, ITM.DESCRIPTION NAME
, TO_NUMBER(NULL) TERM_IN_MONTHS
, TO_NUMBER(NULL) RESIDUAL_VALUE_PERCENT
, RV.ITEM_RESIDUAL_ID ITEM_RESIDUAL_ID
, RV.STS_CODE STS_CODE
, RV.VERSION_NUMBER VERSION_NUMBER
, RV.START_DATE START_DATE
, RV.END_DATE END_DATE
, DECODE(SIGN(NVL(RV.START_DATE
, SYSDATE) - SYSDATE)
, 0
, 'I'
, DECODE(SIGN(NVL(RV.END_DATE
, SYSDATE) - SYSDATE)
, -1
, 'I'
, DECODE(SIGN(NVL(RV.START_DATE
, SYSDATE) - SYSDATE)
, 1
, 'I'
, 'A'))) STATUS
, RV.CREATED_BY CREATED_BY
, RV.CREATION_DATE CREATION_DATE
, RV.LAST_UPDATED_BY LAST_UPDATED_BY
, RV.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_ITM_CAT_RV_PRCS RV
, OKL_SYSTEM_ITEMS_UV ITM
WHERE RV.CAT_ID1 = ITM.ID1
AND RV.CAT_ID2 = ITM.ID2