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_TAX_BK_ASSETS_V

Object Details

Object Name:	OKL_TAX_BK_ASSETS_V
Object Type:	VIEW
Owner:	APPS
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
ID1	VARCHAR2	(40)		Id1
ID2	CHAR	(1)		Id2
NAME	VARCHAR2	(15)	Yes	Name
DESCRIPTION	VARCHAR2	(80)		Description
ASSET_ID	NUMBER	(15)	Yes	Asset Id
ASSET_NUMBER	VARCHAR2	(15)	Yes	Asset Number
TAX_BOOK	VARCHAR2	(15)	Yes	Tax Book
LIFE_IN_MONTHS	NUMBER	(4)		Life In Months
ORIGINAL_COST	NUMBER		Yes	Original Cost
COST	NUMBER		Yes	Cost
ADJUSTED_COST	NUMBER		Yes	Adjusted Cost
TAG_NUMBER	VARCHAR2	(15)		Tag Number
CURRENT_UNITS	NUMBER		Yes	Current Units
SERIAL_NUMBER	VARCHAR2	(35)		Serial Number
REVAL_CEILING	NUMBER			Reval Ceiling
NEW_USED	VARCHAR2	(4)	Yes	New Used
IN_SERVICE_DATE	DATE		Yes	In Service Date
MANUFACTURER_NAME	VARCHAR2	(360)		Manufacturer Name
MODEL_NUMBER	VARCHAR2	(40)		Model Number
ASSET_TYPE	VARCHAR2	(11)	Yes	Asset Type
SALVAGE_VALUE	NUMBER		Yes	Salvage Value
PERCENT_SALVAGE_VALUE	NUMBER			Percent Salvage Value
DEPRECIATION_CATEGORY	NUMBER	(15)	Yes	Depreciation Category
DEPRN_START_DATE	DATE		Yes	Depreciation Start Date
DEPRN_METHOD_CODE	VARCHAR2	(12)	Yes	Depreciation Mehtod Code
RATE_ADJUSTMENT_FACTOR	NUMBER		Yes	Rate Adjustment Facor
BASIC_RATE	NUMBER			Basic Rate
ADJUSTED_RATE	NUMBER			Adjusted Rate
START_DATE_ACTIVE	DATE		Yes	Start Date Active
END_DATE_ACTIVE	DATE			End Date Active
STATUS	VARCHAR2	(2)		Status
PRIMARY_UOM_CODE	VARCHAR2	(0)		Primary Unit of Measure Code
RECOVERABLE_COST	NUMBER		Yes	Recoverable Coast
ORG_ID	NUMBER	(15)		Organization Id
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books Id
PROPERTY_1245_1250_CODE	VARCHAR2	(10)		Property 1245 1250 Code
PROPERTY_TYPE_CODE	VARCHAR2	(4)		Property Type Code
IN_USE_FLAG	VARCHAR2	(3)	Yes	In Use Flag
OWNED_LEASED	VARCHAR2	(15)	Yes
INVENTORIAL	VARCHAR2	(3)		Inventorial

Query Text

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


SELECT ID1
,      ID2
,      NAME
,      DESCRIPTION
,      ASSET_ID
,      ASSET_NUMBER
,      TAX_BOOK
,      LIFE_IN_MONTHS
,      ORIGINAL_COST
,      COST
,      ADJUSTED_COST
,      TAG_NUMBER
,      CURRENT_UNITS
,      SERIAL_NUMBER
,      REVAL_CEILING
,      NEW_USED
,      IN_SERVICE_DATE
,      MANUFACTURER_NAME
,      MODEL_NUMBER
,      ASSET_TYPE
,      SALVAGE_VALUE
,      PERCENT_SALVAGE_VALUE
,      DEPRECIATION_CATEGORY
,      DEPRN_START_DATE
,      DEPRN_METHOD_CODE
,      RATE_ADJUSTMENT_FACTOR
,      BASIC_RATE
,      ADJUSTED_RATE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      STATUS
,      PRIMARY_UOM_CODE
,      RECOVERABLE_COST
,      ORG_ID
,      SET_OF_BOOKS_ID
,      PROPERTY_1245_1250_CODE
,      PROPERTY_TYPE_CODE
,      IN_USE_FLAG
,      OWNED_LEASED
,      INVENTORIAL
FROM APPS.OKL_TAX_BK_ASSETS_V;

Dependencies

[top of page]

APPS.OKL_TAX_BK_ASSETS_V references the following:

APPS: FA_ADDITIONS_B; FA_ADDITIONS_TL; FA_BOOKS; FA_BOOK_CONTROLS

APPS.OKL_TAX_BK_ASSETS_V is referenced by following:

APPS: OKL_TAX_BK_TRX_ASSTS_V