DBA Data[Home] [Help]

APPS.EGO_IMPORT_BATCH_COMPARE_PVT dependencies on FND_OBJECTS

Line 879: WHERE olc.object_id = (select object_id from fnd_objects where obj_name = 'EGO_ITEM')

875: FROM mtl_item_catalog_groups_b ic
876: WHERE EXISTS
877: (SELECT olc.object_classification_code CatalogId
878: FROM ego_obj_type_lifecycles olc
879: WHERE olc.object_id = (select object_id from fnd_objects where obj_name = 'EGO_ITEM')
880: AND olc.lifecycle_id = l_lifecycle_id
881: AND olc.object_classification_code = ic.item_catalog_group_id
882: )
883: AND ROWNUM = 1