APPS.EAM_ASSET_NUMBER_PVT dependencies on MTL_OBJECT_GENEALOGY
Line 1904: (select object_id from mtl_object_genealogy
1900: end;
1901:
1902: begin
1903: insert into EAM_ASSET_RESULTS_GTT (gen_object_id) 1904: (select object_id from mtl_object_genealogy 1905: where genealogy_type = 5
1906: and (sysdate between NVL(start_date_active,sysdate-1) and NVL(end_date_active,sysdate+1))
1907: start with parent_object_id = asset.gen_object_id
1908: connect by parent_object_id = prior object_id