DBA Data[Home] [Help]

APPS.EAM_ASSET_MOVE_PUB dependencies on MTL_OBJECT_GENEALOGY

Line 250: mtl_object_genealogy mog,

246: cii.maintainable_flag ,
247: msi.eam_item_type ,
248: mp.MAINT_ORGANIZATION_ID
249: FROM mtl_serial_numbers msn ,
250: mtl_object_genealogy mog,
251: mtl_system_items_b msi ,
252: csi_item_instances cii ,
253: mtl_parameters mp
254: WHERE mog.object_id = msn.gen_object_id

Line 478: FROM mtl_object_genealogy

474:
475:
476: SELECT parent_object_id
477: INTO l_parent_object_id
478: FROM mtl_object_genealogy
479: WHERE object_id =child_parent_rec.gen_object_id
480: AND START_DATE_ACTIVE<=SYSDATE
481: AND Nvl(end_DATE_ACTIVE,SYSDATE+1)>=sysdate
482: AND PARENT_OBJECT_TYPE = 2; --Added for the bug 7721062