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: INV.MTL_ITEM_REVISIONS_INTERFACE

Object Details

Object Name:	MTL_ITEM_REVISIONS_INTERFACE
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.MTL_ITEM_REVISIONS_INTERFACE
Subobject Name:
Status:	VALID

MTL_ITEM_REVISIONS_INTERFACE temporarily stores revision levels for an
inventory item before loading this information into Oracle Inventory.
This table contains user friendly columns which allow you to easily
enter your data as well as the corresponding foreign keys. Oracle
Inventory will derive column values you do not enter, after
performing the proper validation. For example, if you enter the
ORGANIZATION_CODE, Oracle Inventory will fill in the corresponding
ORGANIZATION_ID. You will need to specify the ITEM_NUMBER
column, which is the concatenation of the sytem item segments with
the correct delimiter in between. This table is used by the item
interface program in conjunction with the MTL_SYSTEM_ITEMS_INTERFACE
table.
.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_ITEM_REVS_INTERFACE_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	INTERFACE_TABLE_UNIQUE_ID
MTL_ITEM_REVS_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	TRANSACTION_ID
MTL_ITEM_REVS_INTERFACE_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ORGANIZATION_ID INVENTORY_ITEM_ID REVISION
MTL_ITEM_REVS_INTERFACE_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	SET_PROCESS_ID PROCESS_FLAG REVISION
MTL_ITEM_REVS_INTERFACE_N4	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ITEM_NUMBER
MTL_ITEM_REVS_INTERFACE_N5	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	SET_PROCESS_ID PROCESS_FLAG SOURCE_SYSTEM_ID SOURCE_SYSTEM_REFERENCE

Columns

Name	Datatype	Length	Mandatory	Comments
INVENTORY_ITEM_ID	NUMBER			Inventory item identifier
ORGANIZATION_ID	NUMBER			Organization identifier
REVISION	VARCHAR2	(3)		Item revision code
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER			Standard Who column
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER			Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
CHANGE_NOTICE	VARCHAR2	(10)		Engineering change order number
ECN_INITIATION_DATE	DATE			ECO initiation date
IMPLEMENTATION_DATE	DATE			ECO implementation date
IMPLEMENTED_SERIAL_NUMBER	VARCHAR2	(30)		(No longer used)
EFFECTIVITY_DATE	DATE			Revision effectivity date
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
REQUEST_ID	NUMBER			Concurrent who column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent who column
PROGRAM_ID	NUMBER			Concurrent who column
PROGRAM_UPDATE_DATE	DATE			Concurrent who column
REVISED_ITEM_SEQUENCE_ID	NUMBER			Revised item unique identifier
DESCRIPTION	VARCHAR2	(240)		Item revision description
ITEM_NUMBER	VARCHAR2	(700)		Item Number (concatenated item flexfield segments)
ORGANIZATION_CODE	VARCHAR2	(3)		Organization code (abbreviated name)
TRANSACTION_ID	NUMBER			Transaction identifier
PROCESS_FLAG	NUMBER			Processed interface row status
TRANSACTION_TYPE	VARCHAR2	(10)		Specifies the mode in which item open interface is working (e.g.: CREATE, UPDATE)
SET_PROCESS_ID	NUMBER		Yes	Used when multiple Item Open Interface processes are run in parallel.
REVISION_ID	NUMBER			Revision Identifier
REVISION_LABEL	VARCHAR2	(80)		Item revision label
REVISION_REASON	VARCHAR2	(30)		Revision Reason
LIFECYCLE_ID	NUMBER			Lifecycle Id
CURRENT_PHASE_ID	NUMBER			Current Phase Id
SOURCE_SYSTEM_ID	NUMBER			Source System Identifier(PIM)
SOURCE_SYSTEM_REFERENCE	VARCHAR2	(255)		Source System Reference (PIM)
CHANGE_ID	NUMBER			Change Identifier(PIM)
INTERFACE_TABLE_UNIQUE_ID	NUMBER			Unique Identifier (PIM)
TEMPLATE_ID	NUMBER			ItemTemplate Identifier
TEMPLATE_NAME	VARCHAR2	(30)		Item Template Name

Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      REVISION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CHANGE_NOTICE
,      ECN_INITIATION_DATE
,      IMPLEMENTATION_DATE
,      IMPLEMENTED_SERIAL_NUMBER
,      EFFECTIVITY_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REVISED_ITEM_SEQUENCE_ID
,      DESCRIPTION
,      ITEM_NUMBER
,      ORGANIZATION_CODE
,      TRANSACTION_ID
,      PROCESS_FLAG
,      TRANSACTION_TYPE
,      SET_PROCESS_ID
,      REVISION_ID
,      REVISION_LABEL
,      REVISION_REASON
,      LIFECYCLE_ID
,      CURRENT_PHASE_ID
,      SOURCE_SYSTEM_ID
,      SOURCE_SYSTEM_REFERENCE
,      CHANGE_ID
,      INTERFACE_TABLE_UNIQUE_ID
,      TEMPLATE_ID
,      TEMPLATE_NAME
FROM INV.MTL_ITEM_REVISIONS_INTERFACE;

Dependencies

[top of page]

INV.MTL_ITEM_REVISIONS_INTERFACE does not reference any database object

INV.MTL_ITEM_REVISIONS_INTERFACE is referenced by following:

APPS: EGO_MIRI_UNIQUE_ID_T; MTL_ITEM_REVISIONS_INTERFACE