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:
1901: OR ss.end_date_active IS NULL
1902: )
1903: )
1904: OR EXISTS(SELECT 1
1905: FROM mtl_system_items_kfv msi
1906: WHERE msi.inventory_item_id = ts.skill_id)
1907: )
1908: GROUP BY rs.resource_id, rs.resource_type) rs
1909: , (SELECT COUNT(*) amount