DBA Data[Home] [Help]

APPS.EAM_ASSET_MOVE_PUB dependencies on MTL_OBJECT_GENEALOGY

Line 242: mtl_object_genealogy mog,

238: cii.maintainable_flag ,
239: msi.eam_item_type ,
240: mp.MAINT_ORGANIZATION_ID
241: FROM mtl_serial_numbers msn ,
242: mtl_object_genealogy mog,
243: mtl_system_items_b msi ,
244: csi_item_instances cii ,
245: mtl_parameters mp
246: WHERE mog.object_id = msn.gen_object_id

Line 465: FROM mtl_object_genealogy

461:
462:
463: SELECT parent_object_id
464: INTO l_parent_object_id
465: FROM mtl_object_genealogy
466: WHERE object_id =child_parent_rec.gen_object_id
467: AND START_DATE_ACTIVE<=SYSDATE
468: AND Nvl(end_DATE_ACTIVE,SYSDATE+1)>=sysdate
469: AND PARENT_OBJECT_TYPE = 2; --Added for the bug 7721062