View: OE_MULTIORG_ITEMS_V

Product:	ONT - Order Management
Description:	This view is used for the ValueSet OM: MultiOrg Items
Implementation/DBA Data:	APPS.OE_MULTIORG_ITEMS_V

View Text

SELECT DISTINCT MTL.INVENTORY_ITEM_ID
, MTL.CONCATENATED_SEGMENTS
FROM MTL_SYSTEM_ITEMS_B_KFV MTL
, OE_SYS_PARAMETERS_ALL SYS
WHERE SYS.PARAMETER_VALUE = MTL.ORGANIZATION_ID
AND SYS.PARAMETER_CODE = 'MASTER_ORGANIZATION_ID'

Columns