834: -- START WITH catalog_group_id = cp_catalog_category_id
835: -- );
836: --
837: -- fix for bug 3681654
838: -- using mtl_item_catalog_groups_b instead of ego_catalog_groups_v
839: SELECT ic.item_catalog_group_id
840: FROM mtl_item_catalog_groups_b ic
841: WHERE EXISTS
842: (
836: --
837: -- fix for bug 3681654
838: -- using mtl_item_catalog_groups_b instead of ego_catalog_groups_v
839: SELECT ic.item_catalog_group_id
840: FROM mtl_item_catalog_groups_b ic
841: WHERE EXISTS
842: (
843: SELECT olc.object_classification_code CatalogId
844: FROM ego_obj_type_lifecycles olc, fnd_objects o