View: GR_RELATED_ITEMS_XML

Product:	GR - Process Manufacturing Regulatory Management
Description:	View for Master Item Associations + Inventory Item and its associated Inventory Items details
Implementation/DBA Data:	APPS.GR_RELATED_ITEMS_XML

View Text

SELECT R.ORGANIZATION_ID ORGNID
, R.INVENTORY_ITEM_ID ITEMID
, G.CONCATENATED_SEGMENTS ITEMCODE
, M.CONCATENATED_SEGMENTS CODE
, M.DESCRIPTION NAME
FROM MTL_RELATED_ITEMS R
, MTL_SYSTEM_ITEMS_KFV G
, MTL_SYSTEM_ITEMS_KFV M
WHERE R.INVENTORY_ITEM_ID = G.INVENTORY_ITEM_ID
AND R.ORGANIZATION_ID = G.ORGANIZATION_ID
AND R.RELATED_ITEM_ID = M.INVENTORY_ITEM_ID
AND R.ORGANIZATION_ID = M.ORGANIZATION_ID
AND R.RELATIONSHIP_TYPE_ID = 19

Columns