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: ENI.ENI_DENORM_HRCHY_PARENTS

Object Details

Object Name:	ENI_DENORM_HRCHY_PARENTS
Object Type:	TABLE
Owner:	ENI
Subobject Name:
Status:	VALID

This table stores the Catalog categories with their descriptions. It also contains the concatenated descriptions of the entire parentage for each node.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ENI_DENORM_HRCHY_PARENTS_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	OBJECT_TYPE OBJECT_ID CATEGORY_ID LANGUAGE
ENI_DEN_HRCHY_PAR_IM1	DOMAIN	NONUNIQUE		CONCAT_CAT_PARENTAGE

Columns

Name	Datatype	Length	Comments
OBJECT_TYPE	VARCHAR2	(20)	The Object Type
OBJECT_ID	NUMBER		The Object Identifier for the Object Type
ATTRIBUTE_GROUP_ID	NUMBER		The Attribute Group Identifier
LANGUAGE	VARCHAR2	(3)	The Language Code Identifier
CATEGORY_ID	NUMBER		The Catalog Category Identifier
CATEGORY_LEVEL_NUM	NUMBER		The Level Number of the Catalog Category in the Hierarchy
CATEGORY_DESC	VARCHAR2	(240)	The Description Text of the Catalog Category
DISABLE_DATE	DATE		The Disable Date for the Catalog Category
CONCAT_CAT_PARENTAGE	VARCHAR2	(4000)	The Concatenated Value for all the Categories in the Hierarchy of the Catalog Category
CATEGORY_PARENT_ID	NUMBER		The Parent Catalog Category Identifier
CREATED_BY	NUMBER		The Identifier of the User who created the row
CREATION_DATE	DATE		The Creation Date of the row
LAST_UPDATED_BY	NUMBER		The uIdentifier of the user who last Updated the row
LAST_UPDATE_DATE	DATE		The Last Update Date of the row
LAST_UPDATE_LOGIN	NUMBER		The Unique Identifier of the User who was Logged in when the row got updated
REQUEST_ID	NUMBER		The Request Identifier of the Concurrent Program which generated the row
PROGRAM_APPLICATION_ID	NUMBER		The Application Identifier
PROGRAM_UPDATE_DATE	DATE		The Program Update Date
PROGRAM_ID	NUMBER		The Program Identifier

Query Text

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


SELECT OBJECT_TYPE
,      OBJECT_ID
,      ATTRIBUTE_GROUP_ID
,      LANGUAGE
,      CATEGORY_ID
,      CATEGORY_LEVEL_NUM
,      CATEGORY_DESC
,      DISABLE_DATE
,      CONCAT_CAT_PARENTAGE
,      CATEGORY_PARENT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      PROGRAM_ID
FROM ENI.ENI_DENORM_HRCHY_PARENTS;

Dependencies

[top of page]

ENI.ENI_DENORM_HRCHY_PARENTS does not reference any database object

ENI.ENI_DENORM_HRCHY_PARENTS is referenced by following:

APPS: ENI_DENORM_HRCHY_PARENTS