[Home] [Help]
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