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

VIEW: APPS.OKL_SIF_LINES_V

Object Details
Object Name: OKL_SIF_LINES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_SIF_LINES_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


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.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Auto-generated by Headstart Utilities
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)
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.
RESIDUAL_GUARANTEE_TYPE VARCHAR2 (200)
Residual guarantee type for an asset line.
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
INDEX_NUMBER NUMBER
Yes Index to determine relationship with Contract
SIF_ID NUMBER
Yes Foreign key to table OKL_STREAM_INTERFACES
OBJECT_VERSION_NUMBER NUMBER (9) Yes Column used for locking records during updates
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.
DESCRIPTION VARCHAR2 (1995)
User entered description
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
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

This columns stores the down payment made on the asset line
CAPITALIZE_DOWN_PAYMENT_YN VARCHAR2 (30)
This column indicates if the down payment on the asset line needs to be capitalized or not
Query Text

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


SELECT 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
FROM APPS.OKL_SIF_LINES_V;

Dependencies

[top of page]

APPS.OKL_SIF_LINES_V references the following:

SchemaAPPS
SynonymOKL_SIF_LINES
APPS.OKL_SIF_LINES_V is referenced by following:

SchemaAPPS
PL/SQL PackageOKL_CREATE_STREAMS_PVT - show dependent code
Package BodyOKL_CREATE_STREAMS_PVT - show dependent code
Package BodyOKL_SFE_PVT - show dependent code
Package BodyOKL_SIL_PVT - show dependent code
PL/SQL PackageOKL_SIL_PVT - show dependent code
Package BodyOKL_SIT_PVT - show dependent code
Package BodyOKL_ST_CODE_CONVERSIONS - show dependent code