FND Design Data [Home] [Help]

View: OKL_SIF_RET_LEVELS_V

Product: OKL - Lease and Finance Management
Description: Holds the payment levels returned from the external pricing engine.
Implementation/DBA Data: ViewAPPS.OKL_SIF_RET_LEVELS_V
View Text

SELECT SRLB.ROWID
, SRLB.ID
, SRLB.LEVEL_INDEX_NUMBER
, SRLB.NUMBER_OF_PERIODS
, SRLB.SIR_ID
, SRLB.INDEX_NUMBER
, SRLB.LEVEL_TYPE
, SRLB.AMOUNT
, SRLB.ADVANCE_OR_ARREARS
, SRLB.PERIOD
, SRLB.LOCK_LEVEL_STEP
, SRLB.DAYS_IN_PERIOD
, SRLB.FIRST_PAYMENT_DATE
, SRLB.OBJECT_VERSION_NUMBER
, SRLB.STREAM_INTERFACE_ATTRIBUTE1
, SRLB.STREAM_INTERFACE_ATTRIBUTE2
, SRLB.STREAM_INTERFACE_ATTRIBUTE3
, SRLB.STREAM_INTERFACE_ATTRIBUTE4
, SRLB.STREAM_INTERFACE_ATTRIBUTE5
, SRLB.STREAM_INTERFACE_ATTRIBUTE6
, SRLB.STREAM_INTERFACE_ATTRIBUTE7
, SRLB.STREAM_INTERFACE_ATTRIBUTE8
, SRLB.STREAM_INTERFACE_ATTRIBUTE9
, SRLB.STREAM_INTERFACE_ATTRIBUTE10
, SRLB.STREAM_INTERFACE_ATTRIBUTE11
, SRLB.STREAM_INTERFACE_ATTRIBUTE12
, SRLB.STREAM_INTERFACE_ATTRIBUTE13
, SRLB.STREAM_INTERFACE_ATTRIBUTE14
, SRLB.STREAM_INTERFACE_ATTRIBUTE15
, SRLB.CREATION_DATE
, SRLB.CREATED_BY
, SRLB.LAST_UPDATE_DATE
, SRLB.LAST_UPDATED_BY
, SRLB.LAST_UPDATE_LOGIN
, SRLB.RATE
FROM OKL_SIF_RET_LEVELS SRLB

Columns

Name
ROW_ID
ID
LEVEL_INDEX_NUMBER
NUMBER_OF_PERIODS
SIR_ID
INDEX_NUMBER
LEVEL_TYPE
AMOUNT
ADVANCE_OR_ARREARS
PERIOD
LOCK_LEVEL_STEP
DAYS_IN_PERIOD
FIRST_PAYMENT_DATE
OBJECT_VERSION_NUMBER
STREAM_INTERFACE_ATTRIBUTE1
STREAM_INTERFACE_ATTRIBUTE2
STREAM_INTERFACE_ATTRIBUTE3
STREAM_INTERFACE_ATTRIBUTE4
STREAM_INTERFACE_ATTRIBUTE5
STREAM_INTERFACE_ATTRIBUTE6
STREAM_INTERFACE_ATTRIBUTE7
STREAM_INTERFACE_ATTRIBUTE8
STREAM_INTERFACE_ATTRIBUTE9
STREAM_INTERFACE_ATTRIBUTE10
STREAM_INTERFACE_ATTRIBUTE11
STREAM_INTERFACE_ATTRIBUTE12
STREAM_INTERFACE_ATTRIBUTE13
STREAM_INTERFACE_ATTRIBUTE14
STREAM_INTERFACE_ATTRIBUTE15
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
RATE