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.OKX_ASSET_LINES_V

Object Details

Object Name:	OKX_ASSET_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKX.OKX_ASSET_LINES_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
ID1	NUMBER		Yes	Primary key column. System generated unique identifier for fixed asset line
ID2	CHAR	(1)		Primary key column
NAME	VARCHAR2	(15)	Yes	User defined name of the Lease financial asset
DESCRIPTION	VARCHAR2	(80)		User defined description of the Lease financial asset
ITEM_DESCRIPTION	VARCHAR2	(1995)		User defined item description of the Lease fianancial asset
COMMENTS	VARCHAR2	(1995)		Comments
CHR_ID	NUMBER			System generated unique identifier for the contract
DNZ_CHR_ID	NUMBER		Yes	System generated denormalized unique identifier for the contract
LTY_CODE	VARCHAR2	(30)	Yes	Line type code
LSE_TYPE	VARCHAR2	(10)	Yes	Indicates whetehr thecontract line is a top line or sub line
LSE_PARENT_ID	NUMBER			System generated parent line style identifier
PARENT_LINE_ID	NUMBER			System generated unique identifier for the parent line
LINE_NUMBER	VARCHAR2	(150)	Yes	Asset line number
DATE_TERMINATED	DATE			Date on which asset line was terminated
START_DATE_ACTIVE	DATE			Effective from date
END_DATE_ACTIVE	DATE			Effective to date
STATUS	VARCHAR2	(1)		Indiactes where the asset line is active or inactive
ASSET_ID	NUMBER	(15)	Yes	Unique identifier for fixed asset
QUANTITY	NUMBER		Yes	Quantity of te asset
UNIT_OF_MEASURE_CODE	VARCHAR2	(3)		Unis of measure code
ASSET_NUMBER	VARCHAR2	(15)	Yes	User assigned number of the asset
CORPORATE_BOOK	VARCHAR2	(15)	Yes	Corporate book for the asset
LIFE_IN_MONTHS	NUMBER	(4)		Life of the asset in complete months
ORIGINAL_COST	NUMBER			Original cost of the asset
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
TAG_NUMBER	VARCHAR2	(15)		Tag number of the asset
CURRENT_UNITS	NUMBER		Yes	Current units of the assets
SERIAL_NUMBER	VARCHAR2	(35)		Serial number of the asset
REVAL_CEILING	NUMBER			Upper limit for revaluing asset cost
NEW_USED	VARCHAR2	(4)	Yes	Indicates whether the asset is new or used
IN_SERVICE_DATE	DATE		Yes	Date the asset was placed in service
MANUFACTURER_NAME	VARCHAR2	(360)		Manufacturer name
MODEL_NUMBER	VARCHAR2	(40)		Model number of the asset
ASSET_TYPE	VARCHAR2	(11)	Yes	Indicates whether the asset is CIP, capitalized or expensed
SALVAGE_VALUE	NUMBER		Yes	Salvage value of the asset
PERCENT_SALVAGE_VALUE	NUMBER			Percentage salvage value
DEPRECIATION_CATEGORY	NUMBER	(15)	Yes	Unique identifier for asset category
DEPRN_START_DATE	DATE		Yes	Date the asset started to depreciate
DEPRN_METHOD_CODE	VARCHAR2	(12)	Yes	Name of the depreciation method for the asset
RATE_ADJUSTMENT_FACTOR	NUMBER		Yes	Percent of remaining depreciation after revaluation or an amortized change, or 1
BASIC_RATE	NUMBER			Base rate used to calculate depreciation amount for flat-rate methods
ADJUSTED_RATE	NUMBER			Actual rate used to calculate depreciation amount for flat-rate methods
RECOVERABLE_COST	NUMBER		Yes	Cost minus salvage value or depreciation ceiling , whichever is lower
ORG_ID	NUMBER	(15)		Unique identifier for operating unit
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Unique identifier for accounting set of books
PROPERTY_TYPE_CODE	VARCHAR2	(10)		Indicates property type
PROPERTY_1245_1250_CODE	VARCHAR2	(4)		Indicate whether property class is 1245 (personal) or 1250 (real)
IN_USE_FLAG	VARCHAR2	(3)	Yes	Indicates whether the asset is in use or not
OWNED_LEASED	VARCHAR2	(15)	Yes	Indicates whether the asset is owned or leased
INVENTORIAL	VARCHAR2	(3)		Indicates whether the asset should be included in physical inventory
LINE_STATUS	VARCHAR2	(30)	Yes	Status of the fixed asset line
YEAR_BUILT	NUMBER	(4)		Year of manufacture or construction of the asset

Query Text

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


SELECT ID1
,      ID2
,      NAME
,      DESCRIPTION
,      ITEM_DESCRIPTION
,      COMMENTS
,      CHR_ID
,      DNZ_CHR_ID
,      LTY_CODE
,      LSE_TYPE
,      LSE_PARENT_ID
,      PARENT_LINE_ID
,      LINE_NUMBER
,      DATE_TERMINATED
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      STATUS
,      ASSET_ID
,      QUANTITY
,      UNIT_OF_MEASURE_CODE
,      ASSET_NUMBER
,      CORPORATE_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
,      RECOVERABLE_COST
,      ORG_ID
,      SET_OF_BOOKS_ID
,      PROPERTY_TYPE_CODE
,      PROPERTY_1245_1250_CODE
,      IN_USE_FLAG
,      OWNED_LEASED
,      INVENTORIAL
,      LINE_STATUS
,      YEAR_BUILT
FROM APPS.OKX_ASSET_LINES_V;

Dependencies

[top of page]

APPS.OKX_ASSET_LINES_V references the following:

APPS: OKC_K_ITEMS; OKC_K_LINES_B; OKC_K_LINES_TL; OKC_LINE_STYLES_B; OKL_K_HEADERS; OKL_K_LINES; OKX_ASSETS_V

APPS.OKX_ASSET_LINES_V is referenced by following:

APPS: IEX_ASSIGNED_ASSETS_V; IEX_AVAILABLE_ASSETS_V; IEX_REPOSSESS_PVT - show dependent code; IEX_REPOS_AVAIL_ASSETS_UV; IEX_REPOS_AVAIL_ASSETS_UV2; IEX_REPOS_OBJECTS_UV; IEX_REP_PVT - show dependent code; OKL_ACC_CALL_PVT - show dependent code; OKL_AM_AMORTIZE_PVT - show dependent code; OKL_AM_ASSET_DETAILS_CHR_UV; OKL_AM_ASSET_DETAILS_UV; OKL_AM_ASSET_DISPOSE_PVT - show dependent code; OKL_AM_ASSET_RETURN_WF - show dependent code; OKL_AM_FIXED_ASSET_LOCATION_UV; OKL_AM_LEASE_TRMNT_PVT - show dependent code; OKL_AM_PROCESS_ASSET_TRX_PVT - show dependent code; OKL_AM_QUOTES_WF - show dependent code; OKL_AM_SV_WRITEDOWN_PVT - show dependent code; OKL_AM_TERMNT_QUOTE_PVT - show dependent code; OKL_AM_UTIL_PVT - show dependent code; OKL_AM_VENDOR_RES_SHARE_PVT - show dependent code; OKL_CONS_BILL - show dependent code; OKL_COPY_ASSET_PVT - show dependent code; OKL_COPY_CONTRACT_PVT - show dependent code; OKL_CREATE_KLE_PVT - show dependent code; OKL_CS_AST_ADDONS_UV; OKL_EQUIPMENT_EXCHANGE_PVT - show dependent code; OKL_LA_STREAM_PVT - show dependent code; OKL_LOSS_PROV_PVT - show dependent code; OKL_PRINT_CONS_BILL - show dependent code; OKL_PROPERTY_TAX_STATEMENT_PVT - show dependent code; OKL_PROP_TAX_ADJ_PVT - show dependent code; OKL_RELEASE_PVT - show dependent code; OKL_SEEDED_FUNCTIONS_PVT - show dependent code; OKL_SPLIT_ASSET_PVT - show dependent code; OKL_SPLIT_ASSET_PVT - show dependent code