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]

VIEW: APPS.OKL_ST_MAP_ASSETS_V

Object Details

Object Name:	OKL_ST_MAP_ASSETS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_ST_MAP_ASSETS_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_NUMBER	NUMBER		Yes	order or sequence within "parent"
SIF_ID	NUMBER		Yes	Foreign key to view OKL_STREAM_INTERFACES_V
KLE_ID	NUMBER		Yes	Foreign key to view OKL_K_LINES_V
INDEX_NUMBER	NUMBER		Yes	Index to determine relationship with Contract
DESCRIPTION	VARCHAR2	(1995)		Description
ASSET_COST	NUMBER	(14)		OEC
DATE_DELIVERY	DATE			Delivery Date
DATE_FUNDING	DATE			Date A/P payment
RESIDUAL_AMOUNT	NUMBER	(14)		Residual value
RESIDUAL_GUARANTEE_AMOUNT	NUMBER	(14)		Amount of the RV guaranteed
RESIDUAL_GUARANTEE_METHOD	VARCHAR2	(30)		RV guaranteed by lessee or 3rd party
FED_DEPRE_METHOD	VARCHAR2	(80)		Tax depreciation method from FA
DATE_FED_DEPRE	DATE			Date in-service or delivery date
FED_DEPRE_BASIS_PERCENT	NUMBER			Depreciable amount per asset cost
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_SALVAGE	NUMBER			From FA Category value to depreciate to (usually zero)
FED_DEPRE_ADR_CONVE	VARCHAR2	(80)		From FA Category tax handling method for partial year
STATE_DEPRE_METHOD	VARCHAR2	(80)		Tax depreciation method from FA
DATE_STATE_DEPRE	DATE			Same as Fed
STATE_DEPRE_BASIS_PERCENT	NUMBER			Depreciable amount per asset cost
STATE_DEPRE_TERM	NUMBER	(4)		From FA Category pre-set depreciable term
STATE_DEPRE_DMNSHING_VALUE_RT	NUMBER	(5)		From FA Category rate for tax methods that decline over the term
STATE_DEPRE_SALVAGE	NUMBER			From FA Category value to depreciate to (usually zero)
STATE_DEPRE_ADR_CONVENT	VARCHAR2	(80)		From FA Category tax handling method for partial year
BOOK_METHOD	VARCHAR2	(80)		From FA (method of depreciation)
DATE_BOOK	DATE			From FA (date depreciation starts)
BOOK_BASIS_PERCENT	NUMBER			From FA (percent of cost to depreciate)
BOOK_TERM	NUMBER	(4)		From FA (term to depreciate over)
BOOK_DEPRE_DMNSHING_VALUE_RT	NUMBER	(5)		From FA (rate for methods that decline over the term)
BOOK_SALVAGE	NUMBER			From FA (value to depreciate to)
BOOK_ADR_CONVENTION	VARCHAR2	(80)		From FA (handling of partial year depreciation)
PURCHASE_OPTION	VARCHAR2	(30)		Option available to lessee
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
RESIDUAL_GUARANTEE_TYPE	VARCHAR2	(200)
STREAM_INTERFACE_ATTRIBUTE01	VARCHAR2	(450)
STREAM_INTERFACE_ATTRIBUTE02	VARCHAR2	(450)
STREAM_INTERFACE_ATTRIBUTE03	VARCHAR2	(450)
STREAM_INTERFACE_ATTRIBUTE04	VARCHAR2	(450)
STREAM_INTERFACE_ATTRIBUTE05	VARCHAR2	(450)
STREAM_INTERFACE_ATTRIBUTE06	VARCHAR2	(450)
STREAM_INTERFACE_ATTRIBUTE07	VARCHAR2	(450)
STREAM_INTERFACE_ATTRIBUTE08	VARCHAR2	(450)
STREAM_INTERFACE_ATTRIBUTE09	VARCHAR2	(450)
STREAM_INTERFACE_ATTRIBUTE10	VARCHAR2	(450)
STREAM_INTERFACE_ATTRIBUTE11	VARCHAR2	(450)
STREAM_INTERFACE_ATTRIBUTE12	VARCHAR2	(450)
STREAM_INTERFACE_ATTRIBUTE13	VARCHAR2	(450)
STREAM_INTERFACE_ATTRIBUTE14	VARCHAR2	(450)
STREAM_INTERFACE_ATTRIBUTE15	VARCHAR2	(450)
RESIDUAL_DATE	DATE			Residual Date
DOWN_PAYMENT_AMOUNT	NUMBER			Down Payment Amount
CAPITALIZE_DOWN_PAYMENT_YN	VARCHAR2	(30)		Flag to indicate if the down payment is capitalized or not

Query Text

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


SELECT TRANSACTION_NUMBER
,      SIF_ID
,      KLE_ID
,      INDEX_NUMBER
,      DESCRIPTION
,      ASSET_COST
,      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
,      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_DATE
,      DOWN_PAYMENT_AMOUNT
,      CAPITALIZE_DOWN_PAYMENT_YN
FROM APPS.OKL_ST_MAP_ASSETS_V;

Dependencies

[top of page]

APPS.OKL_ST_MAP_ASSETS_V references the following:

APPS: OKL_SIF_LINES; OKL_STREAM_INTERFACES

APPS.OKL_ST_MAP_ASSETS_V is not referenced by any database object