DBA Data[Home] [Help] [Dependency Information]


TABLE: INV.MTL_RELATED_ITEMS

Object Details
Object Name: MTL_RELATED_ITEMS
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.MTL_RELATED_ITEMS
Subobject Name:
Status: VALID


MTL_RELATED_ITEMS stores the relationships between items. All
relationships are defined within the item master organization. Item
relationships may be used to search for related and substitute items.
Items defined with a substitute relationship to a given item may be
received in place of the ordered item when substitutes are allowed.
.
RELATIONSHIP_TYPE_ID indicates whether the relationship is a
'Substitute' or 'Related' relationship.
.
RECIPROCAL_FLAG indicates whether the relationship is reciprocal.
Defining the relationship as reciprocal has the same effect as
defining two separate relationships.
.
The view, MTL_RELATED_ITEMS_VIEW, explodes the reciprocal
relationships and may be used to view all item relationships
regardless of how they are defined.
.
Added New columns START_DATE,END_DATE for effectivity
and SUBSTITUTION_SET,PARTIAL_FULFILLMENT_FLAG and ALL_CUSTOMERS_FLAG
is used for the SUBSTITUTION type relationship.
Also added new ATTR.. columns for descriptive flexfield.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_RELATED_ITEMS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVENTORY_ITEM_ID
ColumnRELATED_ITEM_ID
ColumnRELATIONSHIP_TYPE_ID
ColumnORGANIZATION_ID
MTL_RELATED_ITEMS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRELATIONSHIP_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
RELATED_ITEM_ID NUMBER
Yes Related inventory item identifier
RELATIONSHIP_TYPE_ID NUMBER
Yes Relationship type identifier
RECIPROCAL_FLAG VARCHAR2 (1) Yes Flag to indicate whether relationship is reciprocal
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
OBJECT_VERSION_NUMBER NUMBER (9)
Object version number for locking
START_DATE DATE

For date effectivity
END_DATE DATE

For Date Effectivity
ATTR_CONTEXT VARCHAR2 (30)
Descriptive flexfield structure defining column
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
PLANNING_ENABLED_FLAG VARCHAR2 (1)
Flag to indicate whether planning details is enabled or not
Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      RELATED_ITEM_ID
,      RELATIONSHIP_TYPE_ID
,      RECIPROCAL_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      START_DATE
,      END_DATE
,      ATTR_CONTEXT
,      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
,      PLANNING_ENABLED_FLAG
FROM INV.MTL_RELATED_ITEMS;

Dependencies

[top of page]

INV.MTL_RELATED_ITEMS does not reference any database object

INV.MTL_RELATED_ITEMS is referenced by following:

SchemaAPPS
SynonymMTL_RELATED_ITEMS