VIEW: APPS.OKL_SIF_LINES_V

Source

View Text - Preformatted

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 ,silb.orig_contract_line_id orig_contract_line_id FROM OKL_SIF_LINES SILB

View Text - HTML Formatted

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
, SILB.ORIG_CONTRACT_LINE_ID ORIG_CONTRACT_LINE_ID
FROM OKL_SIF_LINES SILB