DBA Data[Home] [Help]

APPS.EGO_ITEM_AML_PUB dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 838: -- using mtl_item_catalog_groups_b instead of ego_catalog_groups_v

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: (

Line 840: FROM mtl_item_catalog_groups_b ic

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