2594: , msn.lot_number
2595: , 0
2596: , msn.current_status
2597: , mms.status_code
2598: FROM wms_allocations_gtmp mag, mtl_serial_numbers msn, mtl_material_statuses_tl mms
2599: WHERE msn.inventory_item_id = p_item_id
2600: AND msn.current_organization_id = p_organization_id
2601: AND msn.current_status = 3
2602: AND msn.current_subinventory_code = p_subinv_code
2620: , msn.lot_number
2621: , 0
2622: , msn.current_status
2623: , mms.status_code
2624: FROM wms_allocations_gtmp mag, mtl_serial_numbers msn, mtl_material_statuses_tl mms
2625: WHERE msn.inventory_item_id = p_item_id
2626: AND msn.current_organization_id = p_organization_id
2627: AND msn.current_status = 3
2628: AND msn.current_subinventory_code = p_subinv_code