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

VIEW: APPS.MTL_RELATED_ITEMS_VIEW

Object Details
Object Name: MTL_RELATED_ITEMS_VIEW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.MTL_RELATED_ITEMS_VIEW
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
INVENTORY_ITEM_ID NUMBER

Inventory item identifier
RELATED_ITEM_ID NUMBER

Related inventory item identifier
RELATIONSHIP_TYPE_ID NUMBER

Relationship type identifier
RECIPROCAL_FLAG VARCHAR2 (1)
Flag to indicate whether relationship is reciprocal
ORGANIZATION_ID NUMBER

Organization identifier
START_DATE DATE

for Effectivity
END_DATE DATE

for effecitivity
PLANNING_ENABLED_FLAG VARCHAR2 (1)
Query Text

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


SELECT ROW_ID
,      INVENTORY_ITEM_ID
,      RELATED_ITEM_ID
,      RELATIONSHIP_TYPE_ID
,      RECIPROCAL_FLAG
,      ORGANIZATION_ID
,      START_DATE
,      END_DATE
,      PLANNING_ENABLED_FLAG
FROM APPS.MTL_RELATED_ITEMS_VIEW;

Dependencies

[top of page]

APPS.MTL_RELATED_ITEMS_VIEW references the following:

SchemaAPPS
SynonymMTL_RELATED_ITEMS
APPS.MTL_RELATED_ITEMS_VIEW is referenced by following:

SchemaAPPS
ViewASO_I_RELATED_ITEMS_V
ViewASO_PVT_RELATED_ITEMS_BALI_V
Package BodyCSP_PARTS_REPAIR - show dependent code
Package BodyCSP_PLANNER_NOTIFICATIONS - show dependent code
Package BodyCSP_PROD_TASK_PARTS_HISTORY - show dependent code
Package BodyCSP_SCH_INT_PVT - show dependent code
ViewOE_RELATED_ITEMS_MV
ViewOE_RELATED_ITEMS_V