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

VIEW: INV.MTL_RELATED_ITEMS#

Object Details
Object Name: MTL_RELATED_ITEMS#
Object Type: VIEW
Owner: INV
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
RELATED_ITEM_ID NUMBER
Yes
RELATIONSHIP_TYPE_ID NUMBER
Yes
RECIPROCAL_FLAG VARCHAR2 (1) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

OBJECT_VERSION_NUMBER NUMBER (9)
START_DATE DATE

END_DATE DATE

ATTR_CONTEXT VARCHAR2 (30)
ATTR_CHAR1 VARCHAR2 (150)
ATTR_CHAR2 VARCHAR2 (150)
ATTR_CHAR3 VARCHAR2 (150)
ATTR_CHAR4 VARCHAR2 (150)
ATTR_CHAR5 VARCHAR2 (150)
ATTR_CHAR6 VARCHAR2 (150)
ATTR_CHAR7 VARCHAR2 (150)
ATTR_CHAR8 VARCHAR2 (150)
ATTR_CHAR9 VARCHAR2 (150)
ATTR_CHAR10 VARCHAR2 (150)
ATTR_NUM1 VARCHAR2 (150)
ATTR_NUM2 VARCHAR2 (150)
ATTR_NUM3 VARCHAR2 (150)
ATTR_NUM4 VARCHAR2 (150)
ATTR_NUM5 VARCHAR2 (150)
ATTR_NUM6 VARCHAR2 (150)
ATTR_NUM7 VARCHAR2 (150)
ATTR_NUM8 VARCHAR2 (150)
ATTR_NUM9 VARCHAR2 (150)
ATTR_NUM10 VARCHAR2 (150)
ATTR_DATE1 VARCHAR2 (150)
ATTR_DATE2 VARCHAR2 (150)
ATTR_DATE3 VARCHAR2 (150)
ATTR_DATE4 VARCHAR2 (150)
ATTR_DATE5 VARCHAR2 (150)
ATTR_DATE6 VARCHAR2 (150)
ATTR_DATE7 VARCHAR2 (150)
ATTR_DATE8 VARCHAR2 (150)
ATTR_DATE9 VARCHAR2 (150)
ATTR_DATE10 VARCHAR2 (150)
PLANNING_ENABLED_FLAG VARCHAR2 (1)
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# references the following:

SchemaINV
TableMTL_RELATED_ITEMS
INV.MTL_RELATED_ITEMS# is referenced by following:

SchemaAPPS
SynonymMTL_RELATED_ITEMS