VIEW: APPS.OE_MULTIORG_ITEMS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'