VIEW: APPS.OKL_ITM_CAT_RV_PRCS_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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