[Home] [Help]
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
Name |
ROW_ID |
INVENTORY_ITEM_ID |
RELATED_ITEM_ID |
RELATIONSHIP_TYPE_ID |
RECIPROCAL_FLAG |
ORGANIZATION_ID |
START_DATE |
END_DATE |
PLANNING_ENABLED_FLAG |