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: EGO.EGO_DATA_LEVEL_B

Object Details

Object Name:	EGO_DATA_LEVEL_B
Object Type:	TABLE
Owner:	EGO
FND Design Data:	EGO.EGO_DATA_LEVEL_B
Subobject Name:
Status:	VALID

Table EGO_DATA_LEVEL_B stores the data level information for the different objects/attributes in an application. Examples of data level names include ITEM_LEVEL, ITEM_REVISION_LEVEL, ITEM_ORG, CATALOG_LEVEL, CATEGORY_LEVEL, COMPONENTS_LEVEL and STRUCTURE_LEVEL among others. The unique index for this table is DATA_LEVEL_ID. ATTR_GROUP_NAME contains the name of the attribute group for which the data level is applicable.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EGO_DATA_LEVEL_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DATA_LEVEL_ID ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
DATA_LEVEL_ID	NUMBER		Yes	Unique identifier for each data level row
APPLICATION_ID	NUMBER		Yes	Refers to the ID of the application for which the data level applies.
ATTR_GROUP_TYPE	VARCHAR2	(40)	Yes	Refers to the attribute group type for which the data level applies (EGO_ITEMMGMT_GROUP, EGO_ITEM_GTIN_ATTRS, BOM_COMPONENTMGMT_GROUP, etc)
DATA_LEVEL_NAME	VARCHAR2	(30)	Yes	This is the name of the data level (e.g. ITEM_LEVEL, ITEM_ORG, COMPONENTS_LEVEL, etc)
PK1_COLUMN_NAME	VARCHAR2	(30)		This is the name of the primary key column one (PK1) for the data level
PK1_COLUMN_TYPE	VARCHAR2	(30)		This is the data type of the primary key column one (PK1) for the data level (e.g. NUMBER, VARCHAR, ETC.)
PK2_COLUMN_NAME	VARCHAR2	(30)		This is the name of the primary key column two (PK2) for the data level
PK2_COLUMN_TYPE	VARCHAR2	(30)		This is the data type of the primary key column two (PK2) for the data level (e.g. NUMBER, VARCHAR, ETC.)
PK3_COLUMN_NAME	VARCHAR2	(30)		This is the name of the primary key column three (PK3) for the data level
PK3_COLUMN_TYPE	VARCHAR2	(30)		This is the data type of the primary key column three (PK3) for the data level (e.g. NUMBER, VARCHAR, ETC.)
PK4_COLUMN_NAME	VARCHAR2	(30)		This is the name of the primary key column four (PK4) for the data level
PK4_COLUMN_TYPE	VARCHAR2	(30)		This is the data type of the primary key column four (PK4) for the data level (e.g. NUMBER, VARCHAR, ETC.)
PK5_COLUMN_NAME	VARCHAR2	(30)		This is the name of the primary key column five (PK5) for the data level
PK5_COLUMN_TYPE	VARCHAR2	(30)		This is the data type of the primary key column five (PK5) for the data level (e.g. NUMBER, VARCHAR, ETC.)
ENABLE_DEFAULTING	VARCHAR2	(1)		This is a flag that indicates if the defaulting option is enabled or not.
ENABLE_VIEW_PRIV	VARCHAR2	(1)		This is the priviledge required to view the data level
ENABLE_EDIT_PRIV	VARCHAR2	(1)		This is the priviledge required to edit the data level
ENABLE_PRE_EVENT	VARCHAR2	(1)		This is a flag that indicates if a business pre event needs to be raised
ENABLE_POST_EVENT	VARCHAR2	(1)		This is a flag that indicates if a business post event needs to be raised
CREATED_BY	NUMBER		Yes	One of the five standard "WHO" columns
CREATION_DATE	DATE		Yes	One of the five standard "WHO" columns
LAST_UPDATED_BY	NUMBER		Yes	One of the five standard "WHO" columns
LAST_UPDATE_DATE	DATE		Yes	One of the five standard "WHO" columns
LAST_UPDATE_LOGIN	NUMBER			One of the five standard "WHO" columns
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT DATA_LEVEL_ID
,      APPLICATION_ID
,      ATTR_GROUP_TYPE
,      DATA_LEVEL_NAME
,      PK1_COLUMN_NAME
,      PK1_COLUMN_TYPE
,      PK2_COLUMN_NAME
,      PK2_COLUMN_TYPE
,      PK3_COLUMN_NAME
,      PK3_COLUMN_TYPE
,      PK4_COLUMN_NAME
,      PK4_COLUMN_TYPE
,      PK5_COLUMN_NAME
,      PK5_COLUMN_TYPE
,      ENABLE_DEFAULTING
,      ENABLE_VIEW_PRIV
,      ENABLE_EDIT_PRIV
,      ENABLE_PRE_EVENT
,      ENABLE_POST_EVENT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ZD_EDITION_NAME
FROM EGO.EGO_DATA_LEVEL_B;

Dependencies

[top of page]

EGO.EGO_DATA_LEVEL_B does not reference any database object

EGO.EGO_DATA_LEVEL_B is referenced by following:

EGO: EGO_DATA_LEVEL_B#