VIEW: APPS.OKL_ST_MAP_ASSETS_V

Source

View Text - Preformatted

SELECT TRANSACTION_NUMBER, OKL_SIF_LINES.SIF_ID SIF_ID, KLE_ID, INDEX_NUMBER, DESCRIPTION, ASSET_COST, OKL_SIF_LINES.DATE_DELIVERY, DATE_FUNDING, RESIDUAL_AMOUNT, RESIDUAL_GUARANTEE_AMOUNT, RESIDUAL_GUARANTEE_METHOD, FED_DEPRE_METHOD, DATE_FED_DEPRE, FED_DEPRE_BASIS_PERCENT, FED_DEPRE_TERM, FED_DEPRE_DMNSHING_VALUE_RATE, FED_DEPRE_SALVAGE, FED_DEPRE_ADR_CONVE, STATE_DEPRE_METHOD, DATE_STATE_DEPRE, STATE_DEPRE_BASIS_PERCENT, STATE_DEPRE_TERM, STATE_DEPRE_DMNSHING_VALUE_RT, STATE_DEPRE_SALVAGE, STATE_DEPRE_ADR_CONVENT, BOOK_METHOD, DATE_BOOK, BOOK_BASIS_PERCENT, BOOK_TERM, BOOK_DEPRE_DMNSHING_VALUE_RT, BOOK_SALVAGE, BOOK_ADR_CONVENTION, PURCHASE_OPTION, DATE_START, DATE_LENDING, PURCHASE_OPTION_AMOUNT, RESIDUAL_GUARANTEE_TYPE, OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE01 , OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE02 , OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE03 , OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE04 , OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE05 , OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE06 , OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE07 , OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE08 , OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE09 , OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE10 , OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE11 , OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE12 , OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE13 , OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE14 , OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE15 , OKL_SIF_LINES.Residual_Date , OKL_SIF_LINES.DOWN_PAYMENT_AMOUNT , OKL_SIF_LINES.CAPITALIZE_DOWN_PAYMENT_YN, okl_sif_lines.orig_contract_line_id FROM OKL_SIF_LINES ,OKL_STREAM_INTERFACES WHERE OKL_SIF_LINES.SIF_ID = OKL_STREAM_INTERFACES.ID AND SIL_TYPE = 'SGA' ORDER BY OKL_SIF_LINES.INDEX_NUMBER

View Text - HTML Formatted

SELECT TRANSACTION_NUMBER
, OKL_SIF_LINES.SIF_ID SIF_ID
, KLE_ID
, INDEX_NUMBER
, DESCRIPTION
, ASSET_COST
, OKL_SIF_LINES.DATE_DELIVERY
, DATE_FUNDING
, RESIDUAL_AMOUNT
, RESIDUAL_GUARANTEE_AMOUNT
, RESIDUAL_GUARANTEE_METHOD
, FED_DEPRE_METHOD
, DATE_FED_DEPRE
, FED_DEPRE_BASIS_PERCENT
, FED_DEPRE_TERM
, FED_DEPRE_DMNSHING_VALUE_RATE
, FED_DEPRE_SALVAGE
, FED_DEPRE_ADR_CONVE
, STATE_DEPRE_METHOD
, DATE_STATE_DEPRE
, STATE_DEPRE_BASIS_PERCENT
, STATE_DEPRE_TERM
, STATE_DEPRE_DMNSHING_VALUE_RT
, STATE_DEPRE_SALVAGE
, STATE_DEPRE_ADR_CONVENT
, BOOK_METHOD
, DATE_BOOK
, BOOK_BASIS_PERCENT
, BOOK_TERM
, BOOK_DEPRE_DMNSHING_VALUE_RT
, BOOK_SALVAGE
, BOOK_ADR_CONVENTION
, PURCHASE_OPTION
, DATE_START
, DATE_LENDING
, PURCHASE_OPTION_AMOUNT
, RESIDUAL_GUARANTEE_TYPE
, OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE01
, OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE02
, OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE03
, OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE04
, OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE05
, OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE06
, OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE07
, OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE08
, OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE09
, OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE10
, OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE11
, OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE12
, OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE13
, OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE14
, OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE15
, OKL_SIF_LINES.RESIDUAL_DATE
, OKL_SIF_LINES.DOWN_PAYMENT_AMOUNT
, OKL_SIF_LINES.CAPITALIZE_DOWN_PAYMENT_YN
, OKL_SIF_LINES.ORIG_CONTRACT_LINE_ID
FROM OKL_SIF_LINES
, OKL_STREAM_INTERFACES
WHERE OKL_SIF_LINES.SIF_ID = OKL_STREAM_INTERFACES.ID
AND SIL_TYPE = 'SGA' ORDER BY OKL_SIF_LINES.INDEX_NUMBER