[Home] [Help]
324: then
325: l_main_query := ' Select gen_object_id object_id'
326: ||' , 1 object_type'
327: ||' , lot_number lot_number'
328: ||' From mtl_lot_numbers'
329: ||' Where inventory_item_id = '||g_inventory_item_id
330: ||' and organization_id = '||g_organization_id
331: ||' and lot_number not in (Select lot_number '
332: ||' from mtl_serial_numbers'
362: ||' Union all '
363: ||' Select gen_object_id object_id'
364: ||' , 1 object_type'
365: ||' , lot_number lot_number'
366: ||' From mtl_lot_numbers'
367: ||' Where inventory_item_id = '||g_inventory_item_id
368: ||' and organization_id = '||g_organization_id
369: ||' and lot_number = '||''''||p_lot_number||''''
370: ||' and lot_number not in (Select lot_number'
406: l_main_query := ' Select we.gen_object_id object_id'
407: ||' , 5 object_type'
408: ||' , mln.lot_number lot_number'
409: ||' From wip_entities we'
410: ||' , mtl_lot_numbers mln'
411: ||' Where we.primary_item_id = '||g_inventory_item_id
412: ||' and we.organization_id = '||g_organization_id
413: ||' and we.organization_id = mln.organization_id'
414: ||' and mln.inventory_item_id = we.primary_item_id'
456: Select gen_object_id
457: , 1
458: Into l_object_id2
459: , l_object_type2
460: From mtl_lot_numbers
461: Where lot_number = l_current_lot_number
462: and organization_id = g_organization_id
463: and inventory_item_id = g_inventory_item_id;
464: end if;
682: , l_current_org_desc
683: , l_current_org_id
684: FROM mtl_parameters mp
685: , hr_organization_units hou
686: , mtl_lot_numbers mln
687: WHERE mln.gen_object_id = l_object_id
688: AND mp.organization_id = mln.organization_id
689: AND hou.organization_id = mln.organization_id;
690: ELSIF l_object_type = 2 THEN
992: , hold_date
993: , vendor_name
994: , origination_date
995: , sampling_event_id
996: From mtl_lot_numbers
997: where lot_number = p_lot_attributes_rec.lot_number
998: and organization_id = p_lot_attributes_rec.organization_id
999: and inventory_item_id = p_lot_attributes_rec.inventory_item_id;
1000: