Product: | OKL - Lease and Finance Management |
---|---|
Description: | View on OKL_SIF_LINES & OKL_STREAM_INTERFACES. |
Implementation/DBA Data: | APPS.OKL_ST_MAP_ASSETS_V |
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
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