View: MTL_RELATED_ITEMS_VIEW

Product:	INV - Inventory
Description:	View of MTL_RELATED_ITEMS with reciprocal item relationships appearing twice
Implementation/DBA Data:	APPS.MTL_RELATED_ITEMS_VIEW

View Text

SELECT ROWID ROW_ID
, INVENTORY_ITEM_ID
, RELATED_ITEM_ID
, RELATIONSHIP_TYPE_ID
, RECIPROCAL_FLAG
, ORGANIZATION_ID
, START_DATE
, END_DATE
, PLANNING_ENABLED_FLAG
FROM MTL_RELATED_ITEMS UNION ALL SELECT ROWID ROW_ID
, RELATED_ITEM_ID INVENTORY_ITEM_ID
, INVENTORY_ITEM_ID RELATED_ITEM_ID
, RELATIONSHIP_TYPE_ID
, RECIPROCAL_FLAG
, ORGANIZATION_ID
, START_DATE
, END_DATE
, PLANNING_ENABLED_FLAG
FROM MTL_RELATED_ITEMS
WHERE RECIPROCAL_FLAG = 'Y'

Columns