Line 87: FROM ego_obj_type_lifecycles olc, fnd_objects o
83: SELECT ic.item_catalog_group_id
84: FROM MTL_ITEM_CATALOG_GROUPS_B ic
85: WHERE EXISTS (
86: SELECT olc.object_classification_code CatalogId 87: FROM ego_obj_type_lifecycles olc, fnd_objects o 88: WHERE o.obj_name = 'EGO_ITEM'
89: AND olc.object_id = o.object_id
90: AND olc.lifecycle_id = cp_lifecycle_id
91: AND olc.object_classification_code = item_catalog_group_id