SELECT a.organization_id,
       a.concatenated_segments,
       a.inventory_item_status_code
FROM   mtl_system_items_kfv a
WHERE  EXISTS(SELECT 1
              FROM   org_organization_definitions b
              WHERE  a.organization_id = b.organization_id)
       AND inventory_item_status_code = 'Active'
        OR inventory_item_status_code = 'Inactive'
           AND concatenated_segments = Nvl(:CONCATENATED_SEGMENTS, 0)