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: ViewOKX.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:

SchemaAPPS
SynonymFA_CATEGORIES_B
SynonymFA_CATEGORIES_TL
APPS.OKX_ASST_CATGRS_V is referenced by following:

SchemaAPPS
Package BodyOKL_AMH_PVT - show dependent code
Package BodyOKL_ICG_PVT - show dependent code
Package BodyOKL_IEN_PVT - show dependent code
ViewOKL_INS_CLASSCATS_UV
ViewOKL_INS_EXCLUSIONS_UV
ViewOKL_INS_POLICY_ASSETS_UV
Package BodyOKL_INS_QUOTE_PVT - show dependent code
ViewOKL_IPY_ASSETS_UV
ViewOKL_K_ASSETS_UV
ViewOKL_LA_BOOK_DEPRN_UV
Package BodyOKL_QA_DATA_INTEGRITY - show dependent code
Package BodyOKL_QUOTE_TO_CONTRACT_PVT - show dependent code
Package BodyOKL_TAL_PVT - show dependent code