1014: if(l_wip_entity_id is null) then
1015: SELECT we.wip_entity_id
1016: INTO l_wip_entity_id
1017: FROM mtl_serial_numbers msn, 1018: wip_entities we, 1019: mtl_object_genealogy mog
1020: WHERE
1021: ((mog.genealogy_origin = 1 and
1022: mog.parent_object_id = we.gen_object_id and