APPS.WIP_UTILITIES dependencies on MTL_OBJECT_GENEALOGY

Line 955: -- be null. Link mtl_object_genealogy to get wip_entity_id

951: AND serial_number = p_serial_number
952: AND inventory_item_id = nvl(l_item_id, inventory_item_id);
953:
954: -- For completed serial number, wip_entity_id in mtl_serial_numbers will
955: -- be null. Link mtl_object_genealogy to get wip_entity_id
956: if(l_wip_entity_id is null) then
957: SELECT we.wip_entity_id
958: INTO l_wip_entity_id
959: FROM mtl_serial_numbers msn,

Line 961: mtl_object_genealogy mog

957: SELECT we.wip_entity_id
958: INTO l_wip_entity_id
959: FROM mtl_serial_numbers msn,
960: wip_entities we,
961: mtl_object_genealogy mog
962: WHERE
963: ((mog.genealogy_origin = 1 and
964: mog.parent_object_id = we.gen_object_id and
965: mog.object_id = msn.gen_object_id)