FND Design Data [Home] [Help]

View: OKL_SIF_LINES_V

Product: OKL - Lease and Finance Management
Description: Holds the asset line details used for external pricing.
Implementation/DBA Data: ViewAPPS.OKL_SIF_LINES_V
View Text

SELECT SILB.ROWID ROW_ID
, SILB.ID ID
, SILB.STATE_DEPRE_DMNSHING_VALUE_RT STATE_DEPRE_DMNSHING_VALUE_RT
, SILB.BOOK_DEPRE_DMNSHING_VALUE_RT BOOK_DEPRE_DMNSHING_VALUE_RT
, SILB.RESIDUAL_GUARANTEE_METHOD RESIDUAL_GUARANTEE_METHOD
, SILB.FED_DEPRE_TERM FED_DEPRE_TERM
, SILB.FED_DEPRE_DMNSHING_VALUE_RATE FED_DEPRE_DMNSHING_VALUE_RATE
, SILB.FED_DEPRE_ADR_CONVE FED_DEPRE_ADR_CONVE
, SILB.STATE_DEPRE_BASIS_PERCENT STATE_DEPRE_BASIS_PERCENT
, SILB.STATE_DEPRE_METHOD STATE_DEPRE_METHOD
, SILB.PURCHASE_OPTION PURCHASE_OPTION
, SILB.ASSET_COST ASSET_COST
, SILB.STATE_DEPRE_TERM STATE_DEPRE_TERM
, SILB.STATE_DEPRE_ADR_CONVENT STATE_DEPRE_ADR_CONVENT
, SILB.FED_DEPRE_METHOD FED_DEPRE_METHOD
, SILB.RESIDUAL_AMOUNT RESIDUAL_AMOUNT
, SILB.FED_DEPRE_SALVAGE FED_DEPRE_SALVAGE
, SILB.DATE_FED_DEPRE DATE_FED_DEPRE
, SILB.BOOK_SALVAGE BOOK_SALVAGE
, SILB.BOOK_ADR_CONVENTION BOOK_ADR_CONVENTION
, SILB.STATE_DEPRE_SALVAGE STATE_DEPRE_SALVAGE
, SILB.FED_DEPRE_BASIS_PERCENT FED_DEPRE_BASIS_PERCENT
, SILB.BOOK_BASIS_PERCENT BOOK_BASIS_PERCENT
, SILB.DATE_DELIVERY DATE_DELIVERY
, SILB.BOOK_TERM BOOK_TERM
, SILB.RESIDUAL_GUARANTEE_AMOUNT RESIDUAL_GUARANTEE_AMOUNT
, SILB.DATE_FUNDING DATE_FUNDING
, SILB.DATE_BOOK DATE_BOOK
, SILB.DATE_STATE_DEPRE DATE_STATE_DEPRE
, SILB.BOOK_METHOD BOOK_METHOD
, SILB.STREAM_INTERFACE_ATTRIBUTE01 STREAM_INTERFACE_ATTRIBUTE01
, SILB.STREAM_INTERFACE_ATTRIBUTE02 STREAM_INTERFACE_ATTRIBUTE02
, SILB.STREAM_INTERFACE_ATTRIBUTE03 STREAM_INTERFACE_ATTRIBUTE03
, SILB.STREAM_INTERFACE_ATTRIBUTE04 STREAM_INTERFACE_ATTRIBUTE04
, SILB.STREAM_INTERFACE_ATTRIBUTE05 STREAM_INTERFACE_ATTRIBUTE05
, SILB.STREAM_INTERFACE_ATTRIBUTE06 STREAM_INTERFACE_ATTRIBUTE06
, SILB.STREAM_INTERFACE_ATTRIBUTE07 STREAM_INTERFACE_ATTRIBUTE07
, SILB.STREAM_INTERFACE_ATTRIBUTE08 STREAM_INTERFACE_ATTRIBUTE08
, SILB.STREAM_INTERFACE_ATTRIBUTE09 STREAM_INTERFACE_ATTRIBUTE09
, SILB.STREAM_INTERFACE_ATTRIBUTE10 STREAM_INTERFACE_ATTRIBUTE10
, SILB.STREAM_INTERFACE_ATTRIBUTE11 STREAM_INTERFACE_ATTRIBUTE11
, SILB.STREAM_INTERFACE_ATTRIBUTE12 STREAM_INTERFACE_ATTRIBUTE12
, SILB.STREAM_INTERFACE_ATTRIBUTE13 STREAM_INTERFACE_ATTRIBUTE13
, SILB.STREAM_INTERFACE_ATTRIBUTE14 STREAM_INTERFACE_ATTRIBUTE14
, SILB.STREAM_INTERFACE_ATTRIBUTE15 STREAM_INTERFACE_ATTRIBUTE15
, SILB.RESIDUAL_GUARANTEE_TYPE
, SILB.DATE_START DATE_START
, SILB.DATE_LENDING DATE_LENDING
, SILB.PURCHASE_OPTION_AMOUNT PURCHASE_OPTION_AMOUNT
, SILB.INDEX_NUMBER INDEX_NUMBER
, SILB.SIF_ID SIF_ID
, SILB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SILB.KLE_ID KLE_ID
, SILB.SIL_TYPE SIL_TYPE
, SILB.DESCRIPTION DESCRIPTION
, SILB.CREATED_BY CREATED_BY
, SILB.LAST_UPDATED_BY LAST_UPDATED_BY
, SILB.CREATION_DATE CREATION_DATE
, SILB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SILB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SILB.RESIDUAL_DATE RESIDUAL_DATE
, SILB.DOWN_PAYMENT_AMOUNT
, SILB.CAPITALIZE_DOWN_PAYMENT_YN
FROM OKL_SIF_LINES SILB

Columns

Name
ROW_ID
ID
STATE_DEPRE_DMNSHING_VALUE_RT
BOOK_DEPRE_DMNSHING_VALUE_RT
RESIDUAL_GUARANTEE_METHOD
FED_DEPRE_TERM
FED_DEPRE_DMNSHING_VALUE_RATE
FED_DEPRE_ADR_CONVE
STATE_DEPRE_BASIS_PERCENT
STATE_DEPRE_METHOD
PURCHASE_OPTION
ASSET_COST
STATE_DEPRE_TERM
STATE_DEPRE_ADR_CONVENT
FED_DEPRE_METHOD
RESIDUAL_AMOUNT
FED_DEPRE_SALVAGE
DATE_FED_DEPRE
BOOK_SALVAGE
BOOK_ADR_CONVENTION
STATE_DEPRE_SALVAGE
FED_DEPRE_BASIS_PERCENT
BOOK_BASIS_PERCENT
DATE_DELIVERY
BOOK_TERM
RESIDUAL_GUARANTEE_AMOUNT
DATE_FUNDING
DATE_BOOK
DATE_STATE_DEPRE
BOOK_METHOD
STREAM_INTERFACE_ATTRIBUTE01
STREAM_INTERFACE_ATTRIBUTE02
STREAM_INTERFACE_ATTRIBUTE03
STREAM_INTERFACE_ATTRIBUTE04
STREAM_INTERFACE_ATTRIBUTE05
STREAM_INTERFACE_ATTRIBUTE06
STREAM_INTERFACE_ATTRIBUTE07
STREAM_INTERFACE_ATTRIBUTE08
STREAM_INTERFACE_ATTRIBUTE09
STREAM_INTERFACE_ATTRIBUTE10
STREAM_INTERFACE_ATTRIBUTE11
STREAM_INTERFACE_ATTRIBUTE12
STREAM_INTERFACE_ATTRIBUTE13
STREAM_INTERFACE_ATTRIBUTE14
STREAM_INTERFACE_ATTRIBUTE15
RESIDUAL_GUARANTEE_TYPE
DATE_START
DATE_LENDING
PURCHASE_OPTION_AMOUNT
INDEX_NUMBER
SIF_ID
OBJECT_VERSION_NUMBER
KLE_ID
SIL_TYPE
DESCRIPTION
CREATED_BY
LAST_UPDATED_BY
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
RESIDUAL_DATE
DOWN_PAYMENT_AMOUNT
CAPITALIZE_DOWN_PAYMENT_YN