320: then
321: l_main_query := ' Select gen_object_id object_id'
322: ||' , 1 object_type'
323: ||' , lot_number lot_number'
324: ||' From mtl_lot_numbers'
325: ||' Where inventory_item_id = '||g_inventory_item_id
326: ||' and organization_id = '||g_organization_id
327: ||' and lot_number not in (Select lot_number '
328: ||' from mtl_serial_numbers'
358: ||' Union all '
359: ||' Select gen_object_id object_id'
360: ||' , 1 object_type'
361: ||' , lot_number lot_number'
362: ||' From mtl_lot_numbers'
363: ||' Where inventory_item_id = '||g_inventory_item_id
364: ||' and organization_id = '||g_organization_id
365: ||' and lot_number = '||''''||p_lot_number||''''
366: ||' and lot_number not in (Select lot_number'
402: l_main_query := ' Select we.gen_object_id object_id'
403: ||' , 5 object_type'
404: ||' , mln.lot_number lot_number'
405: ||' From wip_entities we'
406: ||' , mtl_lot_numbers mln'
407: ||' Where we.primary_item_id = '||g_inventory_item_id
408: ||' and we.organization_id = '||g_organization_id
409: ||' and we.organization_id = mln.organization_id'
410: ||' and mln.inventory_item_id = we.primary_item_id'
452: Select gen_object_id
453: , 1
454: Into l_object_id2
455: , l_object_type2
456: From mtl_lot_numbers
457: Where lot_number = l_current_lot_number
458: and organization_id = g_organization_id
459: and inventory_item_id = g_inventory_item_id;
460: end if;
678: , l_current_org_desc
679: , l_current_org_id
680: FROM mtl_parameters mp
681: , hr_organization_units hou
682: , mtl_lot_numbers mln
683: WHERE mln.gen_object_id = l_object_id
684: AND mp.organization_id = mln.organization_id
685: AND hou.organization_id = mln.organization_id;
686: ELSIF l_object_type = 2 THEN
988: , hold_date
989: , vendor_name
990: , origination_date
991: , sampling_event_id
992: From mtl_lot_numbers
993: where lot_number = p_lot_attributes_rec.lot_number
994: and organization_id = p_lot_attributes_rec.organization_id
995: and inventory_item_id = p_lot_attributes_rec.inventory_item_id;
996: