APPS.WIP_UTILITIES dependencies on MTL_OBJECT_GENEALOGY

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

1009: AND serial_number = p_serial_number
1010: AND inventory_item_id = nvl(l_item_id, inventory_item_id);
1011:
1012: -- For completed serial number, wip_entity_id in mtl_serial_numbers will
1013: -- be null. Link mtl_object_genealogy to get wip_entity_id
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,

Line 1019: mtl_object_genealogy mog

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
1023: mog.object_id = msn.gen_object_id)