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_GRPS_ASSOC_INTERFACE

Object Details

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

Interface Table for associating Attribute Group to an ICC

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
ITEM_CATALOG_GROUP_ID	NUMBER		Identifier for the Item Catalog Group id ( foreign key to MTL_ITEM_CATALOG_GROUPS_B)
ITEM_CATALOG_NAME	VARCHAR2	(819)	Identifier for the Item Catalog Group name
DATA_LEVEL	VARCHAR2	(240)	Lookup indicating the level of granularity at which the Attribute Group is to be associated to the Object. Column not used currently.
DATA_LEVEL_ID	NUMBER		Data Level identifier.
ATTR_GROUP_NAME	VARCHAR2	(30)	Attribute Group to be associated to the Object
ATTR_GROUP_ID	NUMBER	(10)	Identifier for the Attribute Group to be associated to the Object (foreign key to EGO_FND_DSC_FLX_CTX_EXT)
SET_PROCESS_ID	NUMBER	(15)	Batch identifier in this table
TRANSACTION_ID	NUMBER	(15)	ID column used to tie back the record from mtl_interface_errors table
PROCESS_STATUS	NUMBER	(15)	Initial(1) , Error ( 3), Success (7)
TRANSACTION_TYPE	VARCHAR2	(10)	Identifies whether the record is for CREATE,UPDATE, OR SYNC
REQUEST_ID	NUMBER	(15)	Standard concurrent request id
PROGRAM_APPLICATION_ID	NUMBER	(15)	Standard program application id
PROGRAM_ID	NUMBER	(15)	Standard program id
PROGRAM_UPDATE_DATE	DATE		Standard program update date
CREATED_BY	NUMBER	(15)	Standard "WHO" column
CREATION_DATE	DATE		Standard "WHO" column
LAST_UPDATED_BY	NUMBER	(15)	Standard "WHO" column
LAST_UPDATE_DATE	DATE		Standard "WHO" column
LAST_UPDATE_LOGIN	NUMBER	(15)	Standard "WHO" column
ASSOCIATION_ID	NUMBER		Identifier for the Attribute Group to be associated to the Object (foreign key to EGO_FND_DSC_FLX_CTX_EXT)

Query Text

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


SELECT ITEM_CATALOG_GROUP_ID
,      ITEM_CATALOG_NAME
,      DATA_LEVEL
,      DATA_LEVEL_ID
,      ATTR_GROUP_NAME
,      ATTR_GROUP_ID
,      SET_PROCESS_ID
,      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
,      ASSOCIATION_ID
FROM EGO.EGO_ATTR_GRPS_ASSOC_INTERFACE;

Dependencies

[top of page]

EGO.EGO_ATTR_GRPS_ASSOC_INTERFACE does not reference any database object

EGO.EGO_ATTR_GRPS_ASSOC_INTERFACE is referenced by following:

EGO: EGO_ATTR_GRPS_ASSOC_INTERFACE#