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_CODE_DENORM

Object Details

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

The HZ_CLASS_CODE_DENORM table stores the classification code hierarchal structure that is denormalized from HZ_CLASS_CATEGORIES, HZ_CLASS_CATEGORY_USES, HZ_CLASS_CODE_RELATIONS, FND_LOOKUP_TYPES_TL and FND_LOOKUP_VALUES tables. This table captures the information that identifies the levels of the classification codes and provides search capability to retrieve classification hierarchy. For example, High Tech/Hardware/Hard Drives.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HZ_CLASS_CODE_DENORM_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	CLASS_CATEGORY CLASS_CODE LANGUAGE CONCAT_CLASS_CODE
HZ_CLASS_CODE_DENORM_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	CLASS_CATEGORY LANGUAGE SELECTABLE_FLAG START_DATE_ACTIVE END_DATE_ACTIVE ENABLED_FLAG
HZ_CLASS_CODE_DENORM_T1	DOMAIN	NONUNIQUE		CONCAT_CLASS_CODE_MEANING

Columns

Name	Datatype	Length	Mandatory	Comments
CLASS_CATEGORY	VARCHAR2	(30)	Yes	The name of the classification category that identifies the category. Derived from the HZ_CLASS_CATEGORIES table.
CLASS_CODE	VARCHAR2	(30)	Yes	Classification code
CLASS_CODE_MEANING	VARCHAR2	(80)	Yes	Classification code meaning
CLASS_CODE_DESCRIPTION	VARCHAR2	(240)		Classification code description
LANGUAGE	VARCHAR2	(30)	Yes	Language used for class code meaning and description
CONCAT_CLASS_CODE	VARCHAR2	(500)	Yes	oncatenated classification code
CONCAT_CLASS_CODE_MEANING	VARCHAR2	(2000)	Yes	oncatenated classification code meaning
CODE_LEVEL	NUMBER		Yes	Depth of the code hierarchy
START_DATE_ACTIVE	DATE			The date when the class code relationship became effective. Derived from FND_LOOKUP_VALUES.
END_DATE_ACTIVE	DATE			The date when the class code relationship is no longer applied. Derived from FND_LOOKUP_VALUES.
ENABLED_FLAG	VARCHAR2	(1)		Indicates if denormalized customer classification is enabled. Y if it is enabled, N if it is not enabled.Derived from FND_LOOKUP VALUES.
SELECTABLE_FLAG	VARCHAR2	(1)	Yes	Indicates if the classification code can be selected. Y if it is enabled, N if it is not enabled.Derived from the ALLOW_LEAF_NODE_ONLY flag.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
SECURITY_GROUP_ID	NUMBER	(15)		Security group id

Query Text

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


SELECT CLASS_CATEGORY
,      CLASS_CODE
,      CLASS_CODE_MEANING
,      CLASS_CODE_DESCRIPTION
,      LANGUAGE
,      CONCAT_CLASS_CODE
,      CONCAT_CLASS_CODE_MEANING
,      CODE_LEVEL
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ENABLED_FLAG
,      SELECTABLE_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      SECURITY_GROUP_ID
FROM AR.HZ_CLASS_CODE_DENORM;

Dependencies

[top of page]

AR.HZ_CLASS_CODE_DENORM does not reference any database object

AR.HZ_CLASS_CODE_DENORM is referenced by following:

AR: HZ_CLASS_CODE_DENORM#