[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EGO_DATA_LEVEL_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | DATA_LEVEL_ID |
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 |
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
FROM EGO.EGO_DATA_LEVEL_B;
EGO.EGO_DATA_LEVEL_B does not reference any database object
EGO.EGO_DATA_LEVEL_B is referenced by following:
|
|
|