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_ATTR_GROUPS_INTERFACE

Object Details

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

EGO_ATTR_GROUPS_INTERFACE temporarily stores the definitions for
attribute groups 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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	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)
ATTR_GROUP_DISP_NAME	VARCHAR2	(40)	AG display name. (Foreign key to FND_DESCR_FLEX_CONTEXTS_TL)
DESCRIPTION	VARCHAR2	(240)	Description
MULTI_ROW	VARCHAR2	(1)	Defines if the Attribute Group is Multi-Row.
VARIANT	VARCHAR2	(1)	Variant Flag identifying if the Attribute Group is variant
NUM_OF_ROWS	NUMBER		Holds the Number of Rows shown in the table for each page for a multi-Row Attribute Group
NUM_OF_COLS	NUMBER		Holds the Number of columns shown in pagelayout for single-Row AG or Number of columns in the table for multi-Row AG
OWNING_PARTY_ID	NUMBER		Not currently used (would be a foreign key to HZ_PARTIES reflecting the Company that owns the Attribute Group, if the column were used)
OWNING_PARTY	VARCHAR2	(40)	Not currently used (would be a foreign key to HZ_PARTIES reflecting the Company that owns the Attribute Group, if the column were used)
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		Indicates the status of the line. Valid values are : 1 (To be processed), 3 (Error), 7 (Success).
TRANSACTION_TYPE	VARCHAR2	(20)	Transaction type
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
,      ATTR_GROUP_DISP_NAME
,      DESCRIPTION
,      MULTI_ROW
,      VARIANT
,      NUM_OF_ROWS
,      NUM_OF_COLS
,      OWNING_PARTY_ID
,      OWNING_PARTY
,      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_INTERFACE;

Dependencies

[top of page]

EGO.EGO_ATTR_GROUPS_INTERFACE does not reference any database object

EGO.EGO_ATTR_GROUPS_INTERFACE is referenced by following:

EGO: EGO_ATTR_GROUPS_INTERFACE#