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: OSM.AS_HZ_CLASS_CODE_DENORM

Object Details

Object Name:	AS_HZ_CLASS_CODE_DENORM
Object Type:	TABLE
Owner:	OSM
FND Design Data:	AS.AS_HZ_CLASS_CODE_DENORM
Subobject Name:
Status:	VALID

Denormalized table to store customer classification code relations data denormalized from HZ_CLASS_CATEGORIES, HZ_CLASS_CATEGORY_USES, HZ_CLASS_CODE_RELATIONS, FND_LOOKUP_TYPES_TL and FND_LOOKUP_VALUES.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AS_HZ_CLASS_CODE_DENORM_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CLASS_CATEGORY CLASS_CODE ANCESTOR_CODE LANGUAGE
AS_HZ_CLASS_CODE_DENORM_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ANCESTOR_MEANING CONCAT_CLASS_CODE_MEANING SELECTABLE_FLAG
AS_HZ_CLASS_CODE_DENORM_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ANCESTOR_MEANING START_DATE_ACTIVE END_DATE_ACTIVE ENABLED_FLAG SELECTABLE_FLAG CONCAT_CLASS_CODE_MEANING
AS_HZ_CLASS_CODE_DENORM_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CLASS_CODE
AS_HZ_CLASS_CODE_DENORM_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ANCESTOR_CODE
AS_HZ_CLASS_CODE_DENORM_N99	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_DATA	UPPER("ANCESTOR_MEANING") UPPER("CONCAT_CLASS_CODE_MEANING")

Columns

Name	Datatype	Length	Mandatory	Comments
CLASS_CATEGORY	VARCHAR2	(30)	Yes	The name of the classification which identifies the category
CLASS_CATEGORY_MEANING	VARCHAR2	(80)	Yes	Meaning of the class category
CLASS_CODE	VARCHAR2	(30)	Yes	Classification code
CLASS_CODE_MEANING	VARCHAR2	(80)	Yes	The meaning of classfication code
CLASS_CODE_DESCRIPTION	VARCHAR2	(240)		The description of classification code
ANCESTOR_CODE	VARCHAR2	(30)	Yes	Ancestor code for class code including class code itself
ANCESTOR_MEANING	VARCHAR2	(80)	Yes	The meaning of the ancestor code
LANGUAGE	VARCHAR2	(30)	Yes	Language for the meaning and description
CONCAT_CLASS_CODE	VARCHAR2	(500)	Yes	Class code concatenation
CONCAT_CLASS_CODE_MEANING	VARCHAR2	(2000)	Yes	Class code meaning concatenation
CODE_LEVEL	NUMBER		Yes	Depth of the code hierarchy
START_DATE_ACTIVE	DATE			Start date for class code in fnd_lookup_values
END_DATE_ACTIVE	DATE			End date for class code in fnd_lookup_values
ENABLED_FLAG	VARCHAR2	(1)		Enabled flag for class code in fnd_lookup_values
SELECTABLE_FLAG	VARCHAR2	(1)	Yes	Yes/No, based on allow_leaf_node_only_flag in hz_class_categories
SEGMENT1	VARCHAR2	(30)	Yes	class_code where code_level is 1
SEGMENT2	VARCHAR2	(30)		class_code where code_level is 2
SEGMENT3	VARCHAR2	(30)		class_code where code_level is 3
SEGMENT4	VARCHAR2	(30)		class_code where code_level is 4
SEGMENT5	VARCHAR2	(30)		Not used
SEGMENT6	VARCHAR2	(30)		Not used
SEGMENT7	VARCHAR2	(30)		Not used
SEGMENT8	VARCHAR2	(30)		Not used
SEGMENT9	VARCHAR2	(30)		Not used
SEGMENT10	VARCHAR2	(30)		Not used
SEGMENT1_MEANING	VARCHAR2	(80)	Yes	class_code_meaning where code_level is 1
SEGMENT2_MEANING	VARCHAR2	(80)		class_code_meaning where code_level is 2
SEGMENT3_MEANING	VARCHAR2	(80)		class_code_meaning where code_level is 3
SEGMENT4_MEANING	VARCHAR2	(80)		class_code_meaning where code_level is 4
SEGMENT5_MEANING	VARCHAR2	(80)		Not used
SEGMENT6_MEANING	VARCHAR2	(80)		Not used
SEGMENT7_MEANING	VARCHAR2	(80)		Not used
SEGMENT8_MEANING	VARCHAR2	(80)		Not used
SEGMENT9_MEANING	VARCHAR2	(80)		Not used
SEGMENT10_MEANING	VARCHAR2	(80)		Not used
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
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
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
REQUEST_ID	NUMBER			Application who column
PROGRAM_ID	NUMBER			Application who column
PROGRAM_APPLICATION_ID	NUMBER			Application who column
PROGRAM_UPDATE_DATE	DATE			Application who column
SECURITY_GROUP_ID	NUMBER			Security group id
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number

Query Text

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


SELECT CLASS_CATEGORY
,      CLASS_CATEGORY_MEANING
,      CLASS_CODE
,      CLASS_CODE_MEANING
,      CLASS_CODE_DESCRIPTION
,      ANCESTOR_CODE
,      ANCESTOR_MEANING
,      LANGUAGE
,      CONCAT_CLASS_CODE
,      CONCAT_CLASS_CODE_MEANING
,      CODE_LEVEL
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ENABLED_FLAG
,      SELECTABLE_FLAG
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT1_MEANING
,      SEGMENT2_MEANING
,      SEGMENT3_MEANING
,      SEGMENT4_MEANING
,      SEGMENT5_MEANING
,      SEGMENT6_MEANING
,      SEGMENT7_MEANING
,      SEGMENT8_MEANING
,      SEGMENT9_MEANING
,      SEGMENT10_MEANING
,      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
,      OBJECT_VERSION_NUMBER
FROM OSM.AS_HZ_CLASS_CODE_DENORM;

Dependencies

[top of page]

OSM.AS_HZ_CLASS_CODE_DENORM does not reference any database object

OSM.AS_HZ_CLASS_CODE_DENORM is referenced by following:

OSM: AS_HZ_CLASS_CODE_DENORM#