eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: OKL.OKL_SIF_LINES

Object Details

Object Name:	OKL_SIF_LINES
Object Type:	TABLE
Owner:	OKL
FND Design Data:	OKL.OKL_SIF_LINES
Subobject Name:
Status:	VALID

This is an interface table which holds details about asset lines. This information is used for external
pricing. References to contract line and stream interface header are also stored here.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKL_SIL_UK1	NORMAL	UNIQUE	APPS_TS_NOLOGGING	ID
OKL_SIF_SIF_ID_FK_I	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	SIF_ID
SIF_KLE_FK_1	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	KLE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Primary key column
STATE_DEPRE_DMNSHING_VALUE_RT	NUMBER	(5)		From FA Category rate for tax methods that decline over the term
BOOK_DEPRE_DMNSHING_VALUE_RT	NUMBER	(5)		From FA (rate for methods that decline over the term)
RESIDUAL_GUARANTEE_METHOD	VARCHAR2	(30)		RV guaranteed by lessee or 3rd party
FED_DEPRE_TERM	NUMBER	(4)		From FA Category pre-set depreciable term
FED_DEPRE_DMNSHING_VALUE_RATE	NUMBER	(5)		From FA Category rate for tax methods that decline over the term
FED_DEPRE_ADR_CONVE	VARCHAR2	(80)		From FA Category tax handling method for partial year
STATE_DEPRE_BASIS_PERCENT	NUMBER			Depreciable amount per asset cost
STATE_DEPRE_METHOD	VARCHAR2	(80)		Tax depreciation method from FA
PURCHASE_OPTION	VARCHAR2	(30)		Option available to lessee
ASSET_COST	NUMBER	(14)		Asset Cost
STATE_DEPRE_TERM	NUMBER	(4)		From FA Category pre-set depreciable term
STATE_DEPRE_ADR_CONVENT	VARCHAR2	(80)		From FA Category tax handling method for partial year
FED_DEPRE_METHOD	VARCHAR2	(80)		Tax depreciation method from FA
RESIDUAL_AMOUNT	NUMBER	(14)		Residual value
FED_DEPRE_SALVAGE	NUMBER			From FA Category value to depreciate to (usually zero)
DATE_FED_DEPRE	DATE			Date in-service or delivery date
BOOK_SALVAGE	NUMBER			From FA (value to depreciate to)
BOOK_ADR_CONVENTION	VARCHAR2	(80)		From FA (handling of partial year depreciation)
STATE_DEPRE_SALVAGE	NUMBER			From FA Category value to depreciate to (usually zero)
FED_DEPRE_BASIS_PERCENT	NUMBER			Depreciable amount per asset cost
BOOK_BASIS_PERCENT	NUMBER			From FA (percent of cost to depreciate)
DATE_DELIVERY	DATE			Delivery Date
BOOK_TERM	NUMBER	(4)		From FA (term to depreciate over)
RESIDUAL_GUARANTEE_AMOUNT	NUMBER	(14)		Amount of the RV guaranteed
DATE_FUNDING	DATE			Date A/P payment
DATE_BOOK	DATE			From FA (date depreciation starts)
DATE_STATE_DEPRE	DATE			Same as Fed
BOOK_METHOD	VARCHAR2	(80)		From FA (method of depreciation)
INDEX_NUMBER	NUMBER		Yes	Index to determine relationship with Contract
DESCRIPTION	VARCHAR2	(1995)		User entered description
DATE_START	DATE			Start date for contract
DATE_LENDING	DATE			Funding date of a loan
PURCHASE_OPTION_AMOUNT	NUMBER	(14)		Interest rate for a loan
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Column used for locking records during updates
SIF_ID	NUMBER		Yes	Foreign key to table OKL_STREAM_INTERFACES
KLE_ID	NUMBER		Yes	Foreign key to table OKL_K_LINES
SIL_TYPE	VARCHAR2	(10)	Yes	Lookup code for the interface line type. Valid values are SGA and SGN.
RESIDUAL_GUARANTEE_TYPE	VARCHAR2	(200)		Residual guarantee type for an asset line.
STREAM_INTERFACE_ATTRIBUTE01	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE02	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE03	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE04	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE05	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE06	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE07	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE08	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE09	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE10	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE11	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE12	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE13	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE14	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE15	VARCHAR2	(450)		Generic attribute for extensions.
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
RESIDUAL_DATE	DATE			Residual Date
DOWN_PAYMENT_AMOUNT	NUMBER			Column that captures the down payment amount on the asset
CAPITALIZE_DOWN_PAYMENT_YN	VARCHAR2	(30)		This column indicates if the down payment on the asset is capitalized or not
ORIG_CONTRACT_LINE_ID	NUMBER			Foreign key to table okc_k_lines_b

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
,      INDEX_NUMBER
,      DESCRIPTION
,      DATE_START
,      DATE_LENDING
,      PURCHASE_OPTION_AMOUNT
,      OBJECT_VERSION_NUMBER
,      SIF_ID
,      KLE_ID
,      SIL_TYPE
,      RESIDUAL_GUARANTEE_TYPE
,      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
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      RESIDUAL_DATE
,      DOWN_PAYMENT_AMOUNT
,      CAPITALIZE_DOWN_PAYMENT_YN
,      ORIG_CONTRACT_LINE_ID
FROM OKL.OKL_SIF_LINES;

Dependencies

[top of page]

OKL.OKL_SIF_LINES does not reference any database object

OKL.OKL_SIF_LINES is referenced by following:

OKL: OKL_SIF_LINES#