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_ITM_USR_ATTR_INTRFC

Object Details

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

Interface table for user attributes

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EGO_ITM_USR_ATTR_INTRFC_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	DATA_SET_ID ROW_IDENTIFIER ATTR_INT_NAME
EGO_ITM_USR_ATTR_INTRFC_U2	NORMAL	UNIQUE	APPS_TS_INTERFACE	INTERFACE_TABLE_UNIQUE_ID
EGO_ITM_USR_ATTR_INTRFC_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	DATA_SET_ID ATTR_GROUP_INT_NAME ATTR_INT_NAME INVENTORY_ITEM_ID ORGANIZATION_ID ATTR_GROUP_ID
EGO_ITM_USR_ATTR_INTRFC_N10	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BUNDLE_ID
EGO_ITM_USR_ATTR_INTRFC_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	DATA_SET_ID INVENTORY_ITEM_ID ORGANIZATION_ID ATTR_GROUP_INT_NAME
EGO_ITM_USR_ATTR_INTRFC_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	DATA_SET_ID PROCESS_STATUS ITEM_NUMBER#1
EGO_ITM_USR_ATTR_INTRFC_N4	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	TRANSACTION_ID
EGO_ITM_USR_ATTR_INTRFC_N5	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	DATA_SET_ID SOURCE_SYSTEM_REFERENCE SOURCE_SYSTEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER	(15)		A user-specified identifier (e.g., a spreadsheet row number) against which errors for each row will be logged
PROCESS_STATUS	NUMBER			Whether this row is to be processed, being processed, encountered an error, or was processed successfully
DATA_SET_ID	NUMBER	(15)	Yes	An identifier for the collection of rows to be processed together; this value should correspond to the parent object's data set ID
ORGANIZATION_CODE	VARCHAR2	(3)		An identifier for the Organization to which the Item belongs; populate this column if ORGANIZATION_ID \is unknown
REVISION	VARCHAR2	(3)		The Item Revision Code
ROW_IDENTIFIER	NUMBER	(38)	Yes	An identifier for the collection of rows that make up one logical Attribute Group Row
ATTR_GROUP_INT_NAME	VARCHAR2	(30)	Yes	The internal name for the Attribute Group
ATTR_INT_NAME	VARCHAR2	(30)	Yes	The internal name for the Attribute
ATTR_VALUE_STR	VARCHAR2	(1000)		The Attribute value, if its data type is String
ATTR_VALUE_NUM	NUMBER			The Attribute value, if its data type is Number
ATTR_VALUE_DATE	DATE			The Attribute value, if its data type is Date
ATTR_DISP_VALUE	VARCHAR2	(1000)		The Attribute value in its user-friendly form; used mainly for Attributes with Value Sets of validation type Independent or Table
TRANSACTION_TYPE	VARCHAR2	(10)		Whether this row is to be part of a CREATE, UPDATE, SYNC, or DELETE operation
ORGANIZATION_ID	NUMBER	(15)		Organization identifier.Foreign key to MTL_SYSTEM_ITEMS_B.If this column and ORGANIZATION_CODE are both populated, this columns value determines the Org
INVENTORY_ITEM_ID	NUMBER	(15)		The internal identifier for the Item (populate this value to speed up processing); if this column and ITEM_NUMBER are both populated, this column's value identifies the Item
ITEM_CATALOG_GROUP_ID	NUMBER	(15)		Item catalog group identifier.Foreign key to MTL_ITEM_CATALOG_GROUPS_B - used for search
REVISION_ID	NUMBER	(15)		Item Revision Id.Foreign key to MTL_ITEM_REVISIONS_B.If this column and REVISION_CODE are both populated, this columns value identifies the Revision
ATTR_GROUP_ID	NUMBER	(15)		Identifier for the Attribute Group, derived from ATTR_GROUP_INT_NAME (foreign key to EGO_FND_DSC_FLX_CTX_EXT)
REQUEST_ID	NUMBER	(15)		Identifier for the request that starts the concurrent program that processes the row
PROGRAM_APPLICATION_ID	NUMBER	(15)		Identifier for the application that owns the concurrent program that processes the row
PROGRAM_ID	NUMBER	(15)		Identifier for the concurrent program that processes the row
PROGRAM_UPDATE_DATE	DATE			Time when the row was last updated by a concurrent program
CREATED_BY	NUMBER	(15)		One of the five standard "WHO" columns
CREATION_DATE	DATE			One of the five standard "WHO" columns
LAST_UPDATED_BY	NUMBER	(15)		One of the five standard "WHO" columns
LAST_UPDATE_DATE	DATE			One of the five standard "WHO" columns
LAST_UPDATE_LOGIN	NUMBER	(15)		One of the five standard "WHO" columns
ATTR_GROUP_TYPE	VARCHAR2	(30)		Attribute Group Type of the attribute
CHANGE_ID	NUMBER			Unique identifier of change that is created for this row
CHANGE_LINE_ID	NUMBER			Unique identifier change type that is created for this row
SOURCE_SYSTEM_ID	NUMBER			Id of Source System.
SOURCE_SYSTEM_REFERENCE	VARCHAR2	(255)		Unique identifier of a record of Source System.
ATTR_UOM_DISP_VALUE	VARCHAR2	(25)		Display value of Unit Of Measure associated with attribute.
ATTR_VALUE_UOM	VARCHAR2	(3)		Internal value of Unit Of Measure associated with attribute.
INTERFACE_TABLE_UNIQUE_ID	NUMBER			Unique Identifier for this table
PROG_INT_CHAR1	VARCHAR2	(255)		Character column for storing intermediate values during bulkload
PROG_INT_CHAR2	VARCHAR2	(255)		Character column for storing intermediate values during bulkload
PROG_INT_NUM1	NUMBER			Number column for storing intermediate values during bulkload
PROG_INT_NUM2	NUMBER			Number column for storing intermediate values during bulkload
PROG_INT_NUM3	NUMBER			Number column for storing intermediate values during bulkload
PROG_INT_NUM4	NUMBER			Number column for storing intermediate values during bulkload
DATA_LEVEL_ID	NUMBER			Data Level Identifier, Uniquely identifies the Data Level Information.
DATA_LEVEL_NAME	VARCHAR2	(30)		Data Level Internal Name, for user identification of the data level.
PK1_VALUE	NUMBER			PK1 identifier for the data level.
PK2_VALUE	NUMBER			PK2 identifier for the data level.
PK3_VALUE	NUMBER			PK3 identifier for the data level.
PK4_VALUE	NUMBER			PK4 identifier for the data level.
PK5_VALUE	NUMBER			PK5 identifier for the data level.
USER_DATA_LEVEL_NAME	VARCHAR2	(240)		User Name for Data Level to be displayed to the end user.
BUNDLE_ID	NUMBER			Bundle Id.
ITEM_NUMBER#1	VARCHAR2	(820)

Query Text

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


SELECT TRANSACTION_ID
,      PROCESS_STATUS
,      DATA_SET_ID
,      ORGANIZATION_CODE
,      REVISION
,      ROW_IDENTIFIER
,      ATTR_GROUP_INT_NAME
,      ATTR_INT_NAME
,      ATTR_VALUE_STR
,      ATTR_VALUE_NUM
,      ATTR_VALUE_DATE
,      ATTR_DISP_VALUE
,      TRANSACTION_TYPE
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      ITEM_CATALOG_GROUP_ID
,      REVISION_ID
,      ATTR_GROUP_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTR_GROUP_TYPE
,      CHANGE_ID
,      CHANGE_LINE_ID
,      SOURCE_SYSTEM_ID
,      SOURCE_SYSTEM_REFERENCE
,      ATTR_UOM_DISP_VALUE
,      ATTR_VALUE_UOM
,      INTERFACE_TABLE_UNIQUE_ID
,      PROG_INT_CHAR1
,      PROG_INT_CHAR2
,      PROG_INT_NUM1
,      PROG_INT_NUM2
,      PROG_INT_NUM3
,      PROG_INT_NUM4
,      DATA_LEVEL_ID
,      DATA_LEVEL_NAME
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      USER_DATA_LEVEL_NAME
,      BUNDLE_ID
,      ITEM_NUMBER#1
FROM EGO.EGO_ITM_USR_ATTR_INTRFC;

Dependencies

[top of page]

EGO.EGO_ITM_USR_ATTR_INTRFC does not reference any database object

EGO.EGO_ITM_USR_ATTR_INTRFC is referenced by following:

EGO: EGO_ITM_USR_ATTR_INTRFC#