290: SELECT /*+ ORDERED USE_NL */
291: i.customer_product_id
292: , i.current_serial_number
293: , si.concatenated_segments product_name
294: FROM cs_incidents_all_b i, mtl_system_items_kfv si
295: WHERE si.inventory_item_id(+) = i.inventory_item_id
296: AND si.organization_id(+) = i.inv_organization_id
297: AND i.incident_id = b_incident_id;
298:
875: SELECT /*+ ORDERED USE_NL */
876: i.customer_product_id
877: , i.current_serial_number
878: , si.concatenated_segments product_name
879: FROM cs_incidents_all_b i, mtl_system_items_kfv si
880: WHERE si.inventory_item_id(+) = i.inventory_item_id
881: AND si.organization_id(+) = i.inv_organization_id
882: AND i.incident_id = b_incident_id;
883: