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_LIKE_KIND_EXCHANGE_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ASSET_ID	NUMBER	(15)	Yes	Unique identifier for asset.
ASSET_NUMBER	VARCHAR2	(15)	Yes	User defined asset number
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes	Asset book code
BOOK_CLASS	VARCHAR2	(15)	Yes	Asset book class. A book can be of class 'Corporate' , 'Tax' or 'Budget'.
ORG_ID	NUMBER	(15)		Operating Unit identifier
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Accounting books defining column
DATE_PLACED_IN_SERVICE	DATE		Yes	In service date for the asset
DESCRIPTION	VARCHAR2	(80)		User entered description
TAG_NUMBER	VARCHAR2	(15)		Tag number of the asset.
SERIAL_NUMBER	VARCHAR2	(35)		Serial number of the asset.
ASSET_KEY_CCID	NUMBER	(15)		Identifies an asset key flexfield combination for an asset
PARENT_ASSET_ID	NUMBER	(15)		Identifies the parent asset for sub-components
MANUFACTURER_NAME	VARCHAR2	(360)		Name of the manufacturer
MODEL_NUMBER	VARCHAR2	(40)
LEASE_ID	NUMBER	(15)		Unique identifier for Lease Contract involved in like kind exchange
IN_USE_FLAG	VARCHAR2	(3)	Yes	Indicates whether the asset is in use or not
INVENTORIAL	VARCHAR2	(3)		Indicates whether the asset should be included in physical inventory
PROPERTY_TYPE_CODE	VARCHAR2	(10)		Indicates property type
PROPERTY_1245_1250_CODE	VARCHAR2	(4)		Indicates whether property class is 1250(personal) or 1245(real)
OWNED_LEASED	VARCHAR2	(15)	Yes	Indicates whether asset is owned or leased
NEW_USED	VARCHAR2	(4)	Yes	Indicates whether asset is new or used
CURRENT_UNITS	NUMBER		Yes	Current number of units for the asset
ASSET_TYPE	VARCHAR2	(11)	Yes	Indicates whether asset is CIP, capitalized or expensed
ASSET_CATEGORY_ID	NUMBER	(15)	Yes	Identifies category to which the asset belongs
DEPRN_METHOD_CODE	VARCHAR2	(12)	Yes	Name of the depreciation method for the asset
LIFE_IN_MONTHS	NUMBER	(4)		Life of the asset in total months
COST	NUMBER		Yes	Current cost of the asset
ADJUSTED_COST	NUMBER		Yes	Recoverable cost less depreciation reserve. Reset when you perform an amortized adjustment or revaluation
ORIGINAL_COST	NUMBER		Yes	Original cost of the asset
RECOVERABLE_COST	NUMBER		Yes	Cost minus salvage value or depreciation ceiling whichever is lower
SALVAGE_VALUE	NUMBER		Yes	Asset salvage value
PERCENT_SALVAGE_VALUE	NUMBER			Salvage value percentage
PRORATE_CONVENTION_CODE	VARCHAR2	(10)	Yes	Depreciation prorate convention
DEPRECIATE_FLAG	VARCHAR2	(3)	Yes	Indicates whether the asset is depreciating or not
ITC_AMOUNT_ID	NUMBER	(15)		Identifies the ITC rate
BASIC_RATE	NUMBER			Base rate used to calculate depreciation for flat rate methods
ADJUSTED_RATE	NUMBER			Actual rate used to calculate depreciation for flat-rate methods
BONUS_RULE	VARCHAR2	(30)		Identifies the bonus rule to use in calculating depreciation for flat rate methods
CEILING_NAME	VARCHAR2	(30)		Identifies depreciation ceiling to use in calculating depreciation
PRODUCTION_CAPACITY	NUMBER			Capacity of a units of production asset
UNIT_OF_MEASURE	VARCHAR2	(25)		Unit of measure of a units of production asset
REVAL_CEILING	NUMBER			Upper limit of revaluating asset cost
UNREVALUED_COST	NUMBER		Yes	Cost without regard to any revaluations
SHORT_FISCAL_YEAR_FLAG	VARCHAR2	(3)		Indicates whether the asset has been added in a short fiscal year
CONVERSION_DATE	DATE			Date short tax year assed added to the acquiring company
ORIGINAL_DEPRN_START_DATE	DATE			Date short tax year asset started depreciating in acquiring company's books
GROUP_ASSET_ID	NUMBER	(15)		Not used
COST_RETIRED	NUMBER		Yes	Cost retired
UNITS	NUMBER			Number of units retired
NBV_RETIRED	NUMBER			Net book value retired
GAIN_LOSS_AMOUNT	NUMBER			Gain or loss from retirement
PROCEEDS_OF_SALE	NUMBER			Proceeds from sale of the asset
DATE_RETIRED	DATE		Yes	Date on which the retirement occured
KLE_ID	NUMBER		Yes	Foreign key to view OKL_K_LINES_V

Query Text

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


SELECT ASSET_ID
,      ASSET_NUMBER
,      BOOK_TYPE_CODE
,      BOOK_CLASS
,      ORG_ID
,      SET_OF_BOOKS_ID
,      DATE_PLACED_IN_SERVICE
,      DESCRIPTION
,      TAG_NUMBER
,      SERIAL_NUMBER
,      ASSET_KEY_CCID
,      PARENT_ASSET_ID
,      MANUFACTURER_NAME
,      MODEL_NUMBER
,      LEASE_ID
,      IN_USE_FLAG
,      INVENTORIAL
,      PROPERTY_TYPE_CODE
,      PROPERTY_1245_1250_CODE
,      OWNED_LEASED
,      NEW_USED
,      CURRENT_UNITS
,      ASSET_TYPE
,      ASSET_CATEGORY_ID
,      DEPRN_METHOD_CODE
,      LIFE_IN_MONTHS
,      COST
,      ADJUSTED_COST
,      ORIGINAL_COST
,      RECOVERABLE_COST
,      SALVAGE_VALUE
,      PERCENT_SALVAGE_VALUE
,      PRORATE_CONVENTION_CODE
,      DEPRECIATE_FLAG
,      ITC_AMOUNT_ID
,      BASIC_RATE
,      ADJUSTED_RATE
,      BONUS_RULE
,      CEILING_NAME
,      PRODUCTION_CAPACITY
,      UNIT_OF_MEASURE
,      REVAL_CEILING
,      UNREVALUED_COST
,      SHORT_FISCAL_YEAR_FLAG
,      CONVERSION_DATE
,      ORIGINAL_DEPRN_START_DATE
,      GROUP_ASSET_ID
,      COST_RETIRED
,      UNITS
,      NBV_RETIRED
,      GAIN_LOSS_AMOUNT
,      PROCEEDS_OF_SALE
,      DATE_RETIRED
,      KLE_ID
FROM APPS.OKL_LIKE_KIND_EXCHANGE_V;

Dependencies

[top of page]

APPS.OKL_LIKE_KIND_EXCHANGE_V references the following:

APPS: FA_ADDITIONS_B; FA_ADDITIONS_TL; FA_BOOKS; FA_BOOK_CONTROLS; FA_RETIREMENTS; OKC_K_ITEMS; OKC_K_LINES_B; OKC_LINE_STYLES_B; OKL_ASSET_RETURNS_ALL_B; OKL_SYS_ACCT_OPTS

APPS.OKL_LIKE_KIND_EXCHANGE_V is referenced by following:

APPS: OKL_LIKE_KIND_EXCHANGE_PVT - show dependent code; OKL_LIKE_KIND_EXCHANGE_PVT - show dependent code; OKL_TRX_ASSETS_LKE_UV