View: MTL_SYSTEM_ITEMS_ER3_V

Product:	INV - Inventory
Description:	ERES : View to support ERES framework for Items Catalog Group Assignment(Summary View)
Implementation/DBA Data:	APPS.MTL_SYSTEM_ITEMS_ER3_V

View Text

SELECT DISTINCT C.CONCATENATED_SEGMENTS
, B.CONCATENATED_SEGMENTS
, T.DESCRIPTION
, B.INVENTORY_ITEM_ID
FROM MTL_SYSTEM_ITEMS_TL T
, MTL_SYSTEM_ITEMS_B_KFV B
, MTL_ITEM_CATALOG_GROUPS_KFV C
WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
AND T.LANGUAGE = USERENV('LANG')
AND B.ITEM_CATALOG_GROUP_ID = C.ITEM_CATALOG_GROUP_ID (+)

Columns