2176: , mil.concatenated_segments
2177: , msn.revision
2178: , msn.cost_group_id
2179: , ccg.cost_group
2180: FROM mtl_item_locations_kfv mil, mtl_serial_numbers msn, cst_cost_groups ccg, mtl_material_statuses_tl mms
2181: WHERE (group_mark_id IS NULL
2182: OR group_mark_id = -1
2183: )
2184: AND mms.status_id(+) = msn.status_id
2214: , mil.concatenated_segments
2215: , msn.revision
2216: , msn.cost_group_id
2217: , ccg.cost_group
2218: FROM mtl_item_locations_kfv mil, mtl_serial_numbers msn, cst_cost_groups ccg, mtl_material_statuses_tl mms
2219: WHERE (group_mark_id IS NULL
2220: OR group_mark_id = -1
2221: )
2222: AND mms.status_id(+) = msn.status_id
2718: , inv_project.get_task_id
2719: , inv_project.get_task_number
2720: FROM mtl_serial_numbers msn
2721: , mtl_system_items_vl msiv
2722: , mtl_item_locations_kfv milv
2723: , mtl_secondary_inventories msi
2724: WHERE msn.current_organization_id = p_current_organization_id
2725: AND msn.lpn_id IS NULL
2726: AND (msn.group_mark_id IS NULL