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]

TABLE: AR.HZ_CLASS_CATEGORIES

Object Details

Object Name:	HZ_CLASS_CATEGORIES
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.HZ_CLASS_CATEGORIES
Subobject Name:
Status:	VALID

The HZ_CLASS_CATEGORIES table stores the information about categories that is used to classify parties and related entities. The possible values for class categories include NAICS, SIC 1987, and Customer Category. You should define a record in the FND_LOOKUP_TYPES table before you enter any code in this table. You can define any custom category definition in the
FND_LOOKUP_TYPES table.
.
The primary key for this table is CLASS_CATEGORY.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HZ_CLASS_CATEGORIES_U1	NORMAL	UNIQUE	APPS_TS_SEED	CLASS_CATEGORY

Columns

Name	Datatype	Length	Mandatory	Comments
CLASS_CATEGORY	VARCHAR2	(30)	Yes	Class category that belongs to the group
ALLOW_MULTI_PARENT_FLAG	VARCHAR2	(1)	Yes	Y or N indicates whether codes under this category can have multiple parent codes or not
ALLOW_MULTI_ASSIGN_FLAG	VARCHAR2	(1)	Yes	Y or N indicates whether codes under this category can be assigned to an object more than once or not
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
ALLOW_LEAF_NODE_ONLY_FLAG	VARCHAR2	(1)		Y or N indicates whether or not the instances of those entities associated with this particular CLASS_CATEGORY can only be assigned to leaf node class codes of that particular CLASS_CATEGORY
OBJECT_VERSION_NUMBER	NUMBER			Used for locking purposes
CREATED_BY_MODULE	VARCHAR2	(150)		TCA Who column
APPLICATION_ID	NUMBER			TCA Who column
DELIMITER	VARCHAR2	(1)		Used for concatenated class code in the HZ_CLASS_CODE_DENORM table
FROZEN_FLAG	VARCHAR2	(1)		Y or N indicates whether the data in the HZ_CLASS_CODE_DENORM table for this class category is valid or not. The Refresh of Classification Denormalization program refreshes the data
CLASS_OWNER_ID	NUMBER			Identifies the owner of the class category.

Query Text

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


SELECT CLASS_CATEGORY
,      ALLOW_MULTI_PARENT_FLAG
,      ALLOW_MULTI_ASSIGN_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      ALLOW_LEAF_NODE_ONLY_FLAG
,      OBJECT_VERSION_NUMBER
,      CREATED_BY_MODULE
,      APPLICATION_ID
,      DELIMITER
,      FROZEN_FLAG
,      CLASS_OWNER_ID
FROM AR.HZ_CLASS_CATEGORIES;

Dependencies

[top of page]

AR.HZ_CLASS_CATEGORIES does not reference any database object

AR.HZ_CLASS_CATEGORIES is referenced by following:

APPS: HZ_CLASS_CATEGORIES