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_ASST_CATGRS_V

Object Details

Object Name:	OKX_ASST_CATGRS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKX.OKX_ASST_CATGRS_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	(15)	Yes	Primary ket column. Unique identifier for asset category
ID2	CHAR	(1)		Primary key column
NAME	VARCHAR2	(216)		Concatenated segments of asset category key flexfield
DESCRIPTION	VARCHAR2	(40)		Asset category description
CATEGORY_ID	NUMBER	(15)	Yes	Unique identifier for asset category
SUMMARY_FLAG	VARCHAR2	(1)	Yes	Internal use column
ENABLED_FLAG	VARCHAR2	(1)	Yes	Indicates whether this category is still valid
OWNED_LEASED	VARCHAR2	(6)	Yes	Indicates whether the assets in this category are owned or leased
CATEGORY_TYPE	VARCHAR2	(30)	Yes	Indicates the category type Oracle Assets uses to classify the assets in this category
CAPITALIZE_FLAG	VARCHAR2	(3)	Yes	Indicates whether the assets in this category are capitalized
SEGMENT1	VARCHAR2	(30)		Asset category key flexfield segment column
SEGMENT2	VARCHAR2	(30)		Asset category key flexfield segment column
SEGMENT3	VARCHAR2	(30)		Asset category key flexfield segment column
SEGMENT4	VARCHAR2	(30)		Asset category key flexfield segment column
SEGMENT5	VARCHAR2	(30)		Asset category key flexfield segment column
SEGMENT6	VARCHAR2	(30)		Asset category key flexfield segment column
SEGMENT7	VARCHAR2	(30)		Asset category key flexfield segment column
START_DATE_ACTIVE	DATE			Effective from date
END_DATE_ACTIVE	DATE			Effective to date
STATUS	VARCHAR2	(1)		Indicates whether the asset category is active or inactive
PRIMARY_UOM_CODE	VARCHAR2	(0)		Primary unit of measure code
PROPERTY_TYPE_CODE	VARCHAR2	(10)		Inkdicates the property type you assigned to an asset category
PROPERTY_1245_1250_CODE	VARCHAR2	(4)		Indicates whether the assets in this category are 1245 property class or 1250 property class
DATE_INEFFECTIVE	DATE			Not used
PRODUCTION_CAPACITY	NUMBER			Production capacity of assets that use a unit of production depreciation method
INVENTORIAL	VARCHAR2	(3)		Indicates whether the asset should be included in physical inventory

Query Text

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


SELECT ID1
,      ID2
,      NAME
,      DESCRIPTION
,      CATEGORY_ID
,      SUMMARY_FLAG
,      ENABLED_FLAG
,      OWNED_LEASED
,      CATEGORY_TYPE
,      CAPITALIZE_FLAG
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      STATUS
,      PRIMARY_UOM_CODE
,      PROPERTY_TYPE_CODE
,      PROPERTY_1245_1250_CODE
,      DATE_INEFFECTIVE
,      PRODUCTION_CAPACITY
,      INVENTORIAL
FROM APPS.OKX_ASST_CATGRS_V;

Dependencies

[top of page]

APPS.OKX_ASST_CATGRS_V references the following:

APPS: FA_CATEGORIES_B; FA_CATEGORIES_TL

APPS.OKX_ASST_CATGRS_V is referenced by following:

APPS: OKL_AMH_PVT - show dependent code; OKL_ICG_PVT - show dependent code; OKL_IEN_PVT - show dependent code; OKL_INS_CLASSCATS_UV; OKL_INS_EXCLUSIONS_UV; OKL_INS_POLICY_ASSETS_UV; OKL_INS_QUOTE_PVT - show dependent code; OKL_IPY_ASSETS_UV; OKL_K_ASSETS_UV; OKL_LA_BOOK_DEPRN_UV; OKL_QA_DATA_INTEGRITY - show dependent code; OKL_QUOTE_TO_CONTRACT_PVT - show dependent code; OKL_TAL_PVT - show dependent code