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
SET_PROCESS_ID	NUMBER		Set process id for interface program
ATTR_CONTEXT	VARCHAR2	(30)	Attribute Context
TRANSACTION_TYPE	VARCHAR2	(10)	Transaction Type
ATTR_CHAR1	VARCHAR2	(150)	Descriptive flex field segment
ATTR_CHAR2	VARCHAR2	(150)	Descriptive flex field segment
ATTR_CHAR3	VARCHAR2	(150)	Descriptive flex field segment
ATTR_CHAR4	VARCHAR2	(150)	Descriptive flex field segment
ATTR_CHAR5	VARCHAR2	(150)	Descriptive flex field segment
ATTR_CHAR6	VARCHAR2	(150)	Descriptive flex field segment
ATTR_CHAR7	VARCHAR2	(150)	Descriptive flex field segment
ATTR_CHAR8	VARCHAR2	(150)	Descriptive flex field segment
ATTR_CHAR9	VARCHAR2	(150)	Descriptive flex field segment
ATTR_CHAR10	VARCHAR2	(150)	Descriptive flex field segment
ATTR_NUM1	VARCHAR2	(150)	Descriptive flex field segment
ATTR_NUM2	VARCHAR2	(150)	Descriptive flex field segment
ATTR_NUM3	VARCHAR2	(150)	Descriptive flex field segment
ATTR_NUM4	VARCHAR2	(150)	Descriptive flex field segment
ATTR_NUM5	VARCHAR2	(150)	Descriptive flex field segment
ATTR_NUM6	VARCHAR2	(150)	Descriptive flex field segment
ATTR_NUM7	VARCHAR2	(150)	Descriptive flex field segment
ATTR_NUM8	VARCHAR2	(150)	Descriptive flex field segment
ATTR_NUM9	VARCHAR2	(150)	Descriptive flex field segment
ATTR_NUM10	VARCHAR2	(150)	Descriptive flex field segment
ATTR_DATE1	VARCHAR2	(150)	Descriptive flex field segment
ATTR_DATE2	VARCHAR2	(150)	Descriptive flex field segment
ATTR_DATE3	VARCHAR2	(150)	Descriptive flex field segment
ATTR_DATE4	VARCHAR2	(150)	Descriptive flex field segment
ATTR_DATE5	VARCHAR2	(150)	Descriptive flex field segment
ATTR_DATE6	VARCHAR2	(150)	Descriptive flex field segment
ATTR_DATE7	VARCHAR2	(150)	Descriptive flex field segment
ATTR_DATE8	VARCHAR2	(150)	Descriptive flex field segment
ATTR_DATE9	VARCHAR2	(150)	Descriptive flex field segment
ATTR_DATE10	VARCHAR2	(150)	Descriptive flex field segment
RELATIONSHIP_TYPE_ID_UPD_VAL	NUMBER		Relationship type identifier for update
RELATED_ITEM_ID_UPD_VAL	NUMBER		Related inventory item identifier for update

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
,      SET_PROCESS_ID
,      ATTR_CONTEXT
,      TRANSACTION_TYPE
,      ATTR_CHAR1
,      ATTR_CHAR2
,      ATTR_CHAR3
,      ATTR_CHAR4
,      ATTR_CHAR5
,      ATTR_CHAR6
,      ATTR_CHAR7
,      ATTR_CHAR8
,      ATTR_CHAR9
,      ATTR_CHAR10
,      ATTR_NUM1
,      ATTR_NUM2
,      ATTR_NUM3
,      ATTR_NUM4
,      ATTR_NUM5
,      ATTR_NUM6
,      ATTR_NUM7
,      ATTR_NUM8
,      ATTR_NUM9
,      ATTR_NUM10
,      ATTR_DATE1
,      ATTR_DATE2
,      ATTR_DATE3
,      ATTR_DATE4
,      ATTR_DATE5
,      ATTR_DATE6
,      ATTR_DATE7
,      ATTR_DATE8
,      ATTR_DATE9
,      ATTR_DATE10
,      RELATIONSHIP_TYPE_ID_UPD_VAL
,      RELATED_ITEM_ID_UPD_VAL
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:

INV: MTL_RELATED_ITEMS_INTERFACE#