DBA Data[Home] [Help] [Dependency Information]

TABLE: EGO.EGO_ATTR_GROUPS_DL_INTERFACE

Object Details
Object Name: EGO_ATTR_GROUPS_DL_INTERFACE
Object Type: TABLE
Owner: EGO
FND Design Data: TableEGO.EGO_ATTR_GROUPS_DL_INTERFACE
Subobject Name:
Status: VALID

EGO_ATTR_GROUPS_DL_INTERFACE temporarily stores the definitions for
attribute group data level before loading this information into Oracle Advanced
Product Catalog.
This table contains user friendly columns which allow you to easily
enter your data as well as their corresponding foreign keys. Oracle
Advanced Product Catalog will default column values you do not enter, after
performing the proper validation. For example, you enter the
ATTR_GROUP_NAME, and Oracle Advanced Product Catalog will fill in the corresponding
ATTR_GROUP_ID for you.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SET_PROCESS_ID NUMBER

Unique identifier for the subset of data. Each of the lines that are newly uploaded in the interface table, need to be given a unique ID, that will be used during the Concurrent program request submission. It is suggested to retrieve the values from EGO_IPI_DATASET_ID_S.
ATTR_GROUP_ID NUMBER

Identifier for the Attribute Group
APPLICATION_ID NUMBER

Identifier for the application to which the Attribute Group belongs (part of the foreign key to FND_DESCR_FLEX_CONTEXTS) Eg. 431
ATTR_GROUP_TYPE VARCHAR2 (40)
Attribute Group Type to which the Attribute Group belongs (part of the foreign key to FND_DESCR_FLEX_CONTEXTS). Eg. EGO_ITEMMGMT_GROUP
ATTR_GROUP_NAME VARCHAR2 (30)
Internal name of the Attribute Group (part of the foreign key to FND_DESCR_FLEX_CONTEXTS)
DATA_LEVEL_ID NUMBER

Data Level Identifier, Foreign key to EGO_DATA_LEVEL_B.DATA_LEVEL_ID.
DATA_LEVEL_NAME VARCHAR2 (30)
This is the name of the data level (e.g. ITEM_LEVEL, ITEM_ORG, COMPONENTS_LEVEL, etc)
DEFAULTING VARCHAR2 (1)
Indicates the behavior of the Data Level across Style and SKU Items. (Takes values , D, I or NULL
DEFAULTING_NAME VARCHAR2 (80)
SKU Style name
VIEW_PRIVILEGE_ID NUMBER

Name of the Data Security privilege necessary to view the attribute group value(foreign key to FND_FORM_FUNCTIONS)
VIEW_PRIVILEGE_NAME VARCHAR2 (60)
Privilege name. FK to FND_FORM_FUNCTIONS
USER_VIEW_PRIV_NAME VARCHAR2 (80)
User Privilege Name
EDIT_PRIVILEGE_ID NUMBER

Name of the Data Security privilege necessary to edit the attribute group value(foreign key to FND_FORM_FUNCTIONS)
EDIT_PRIVILEGE_NAME VARCHAR2 (60)
Privilege name. FK to FND_FORM_FUNCTIONS
USER_EDIT_PRIV_NAME VARCHAR2 (80)
User Privilege Name
PRE_BUSINESS_EVENT_FLAG VARCHAR2 (1)
Depicts if pre Business event is raised on change of Attribute group data or not
BUSINESS_EVENT_FLAG VARCHAR2 (1)
Depicts if post Business event is raised on change of Attribute group data or not
TRANSACTION_ID NUMBER

Unique identifier for the line. It is suggested to retrieve the value for this from mtl_system_items_interface_s.
PROCESS_STATUS NUMBER

TRANSACTION_TYPE VARCHAR2 (10)
REQUEST_ID NUMBER

Concurrent Program Submission Request ID.
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program Application ID.
PROGRAM_ID NUMBER

Concurrent Program ID.
PROGRAM_UPDATE_DATE DATE

Concurrent Program update date. When the concurrent program finishes processing this line, the SYSDATE at that time can be set to this column.
CREATED_BY NUMBER

standard "WHO" column.
CREATION_DATE DATE

standard "WHO" column.
LAST_UPDATED_BY NUMBER

standard "WHO" column.
LAST_UPDATE_DATE DATE

standard "WHO" column.
LAST_UPDATE_LOGIN NUMBER

standard "WHO" column.
Query Text

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


SELECT SET_PROCESS_ID
,      ATTR_GROUP_ID
,      APPLICATION_ID
,      ATTR_GROUP_TYPE
,      ATTR_GROUP_NAME
,      DATA_LEVEL_ID
,      DATA_LEVEL_NAME
,      DEFAULTING
,      DEFAULTING_NAME
,      VIEW_PRIVILEGE_ID
,      VIEW_PRIVILEGE_NAME
,      USER_VIEW_PRIV_NAME
,      EDIT_PRIVILEGE_ID
,      EDIT_PRIVILEGE_NAME
,      USER_EDIT_PRIV_NAME
,      PRE_BUSINESS_EVENT_FLAG
,      BUSINESS_EVENT_FLAG
,      TRANSACTION_ID
,      PROCESS_STATUS
,      TRANSACTION_TYPE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM EGO.EGO_ATTR_GROUPS_DL_INTERFACE;

Dependencies

[top of page]

EGO.EGO_ATTR_GROUPS_DL_INTERFACE does not reference any database object

EGO.EGO_ATTR_GROUPS_DL_INTERFACE is referenced by following:

SchemaEGO
ViewEGO_ATTR_GROUPS_DL_INTERFACE#