FND Design Data [Home] [Help]

View: OKL_ITM_CAT_RV_PRCS_V

Product: OKL - Lease and Finance Management
Description: Wrapper view over table OKL_ITM_CAT_RV_PRCS
Implementation/DBA Data: ViewAPPS.OKL_ITM_CAT_RV_PRCS_V
View Text

SELECT ICP.ROWID
, ICP.ID ID
, ICP.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TO_NUMBER(NULL) CAT_ID1
, NULL CAT_ID2
, TO_NUMBER(NULL) TERM_IN_MONTHS
, TO_NUMBER(NULL) RESIDUAL_VALUE_PERCENT
, ICP.ITEM_RESIDUAL_ID ITEM_RESIDUAL_ID
, ICP.STS_CODE STS_CODE
, ICP.VERSION_NUMBER VERSION_NUMBER
, ICP.START_DATE START_DATE
, ICP.END_DATE END_DATE
, ICP.CREATED_BY CREATED_BY
, ICP.CREATION_DATE CREATION_DATE
, ICP.LAST_UPDATED_BY LAST_UPDATED_BY
, ICP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ICP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ICP.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ICP.ATTRIBUTE1 ATTRIBUTE1
, ICP.ATTRIBUTE2 ATTRIBUTE2
, ICP.ATTRIBUTE3 ATTRIBUTE3
, ICP.ATTRIBUTE4 ATTRIBUTE4
, ICP.ATTRIBUTE5 ATTRIBUTE5
, ICP.ATTRIBUTE6 ATTRIBUTE6
, ICP.ATTRIBUTE7 ATTRIBUTE7
, ICP.ATTRIBUTE8 ATTRIBUTE8
, ICP.ATTRIBUTE9 ATTRIBUTE9
, ICP.ATTRIBUTE10 ATTRIBUTE10
, ICP.ATTRIBUTE11 ATTRIBUTE11
, ICP.ATTRIBUTE12 ATTRIBUTE12
, ICP.ATTRIBUTE13 ATTRIBUTE13
, ICP.ATTRIBUTE14 ATTRIBUTE14
, ICP.ATTRIBUTE15 ATTRIBUTE15
FROM OKL_ITM_CAT_RV_PRCS ICP

Columns

Name
ROW_ID
ID
OBJECT_VERSION_NUMBER
CAT_ID1
CAT_ID2
TERM_IN_MONTHS
RESIDUAL_VALUE_PERCENT
ITEM_RESIDUAL_ID
STS_CODE
VERSION_NUMBER
START_DATE
END_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15