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_RELATED_ITEMS_INTERFACE

Object Details

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

MTL_RELATED_ITEMS_INTERFACE temporarily stores the relationship
between two items 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 default column values you do not enter, after
performing the proper validation. For example, if you enter the
ITEM_NUMBER, Oracle Inventory will fill in the corresponding
INVENTORY_ITEM_ID for you.
This table is not currently used.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
INVENTORY_ITEM_ID	NUMBER		Inventory item identifier
RELATED_ITEM_ID	NUMBER		Related inventory item identifier
RELATIONSHIP_TYPE_ID	NUMBER		Relationship type identifier
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
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
RECIPROCAL_FLAG	VARCHAR2	(1)	Flag to indicate whether relationship is reciprocal
ORGANIZATION_ID	NUMBER		Organization identifier
TRANSACTION_ID	NUMBER		Interface record identifier
PROCESS_FLAG	NUMBER		Interface record processing status
ORGANIZATION_CODE	VARCHAR2	(3)	Abbreviated organization name
ITEM_NUMBER	VARCHAR2	(81)	Concatenated item segments
RELATED_ITEM_NUMBER	VARCHAR2	(81)	Concatenated item segments of related item
START_DATE	DATE		for effectivity
END_DATE	DATE		for effectivity
PLANNING_ENABLED_FLAG	VARCHAR2	(1)	Planning Enabled Flag

Query Text

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


SELECT INVENTORY_ITEM_ID
,      RELATED_ITEM_ID
,      RELATIONSHIP_TYPE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      RECIPROCAL_FLAG
,      ORGANIZATION_ID
,      TRANSACTION_ID
,      PROCESS_FLAG
,      ORGANIZATION_CODE
,      ITEM_NUMBER
,      RELATED_ITEM_NUMBER
,      START_DATE
,      END_DATE
,      PLANNING_ENABLED_FLAG
FROM INV.MTL_RELATED_ITEMS_INTERFACE;

Dependencies

[top of page]

INV.MTL_RELATED_ITEMS_INTERFACE does not reference any database object

INV.MTL_RELATED_ITEMS_INTERFACE is referenced by following:

APPS: MTL_RELATED_ITEMS_INTERFACE