APPS.EGO_ITEM_PUB dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 3924: FROM mtl_item_catalog_groups_b b

3920: l_total_count NUMBER :=0;
3921: l_cat_count NUMBER := 0;
3922: BEGIN
3923: SELECT COUNT(1) INTO l_cat_count
3924: FROM mtl_item_catalog_groups_b b
3925: CONNECT BY PRIOR item_catalog_group_id = parent_catalog_group_id
3926: START WITH b.item_catalog_group_id = p_catalog_group_id;
3927:
3928: IF l_cat_count = 0 THEN

Line 3936: FROM mtl_item_catalog_groups_b b

3932: ELSE
3933: SELECT COUNT(1) into l_total_count FROM mtl_system_items_b a
3934: WHERE a.organization_id = p_organization_id
3935: AND item_catalog_group_id in (SELECT item_catalog_group_id
3936: FROM mtl_item_catalog_groups_b b
3937: CONNECT BY PRIOR item_catalog_group_id = parent_catalog_group_id
3938: START WITH b.item_catalog_group_id = p_catalog_group_id );
3939: END IF;
3940:

Line 4107: -- using mtl_item_catalog_groups_b instead of ego_catalog_groups_v

4103: -- START WITH catalog_group_id = cp_catalog_category_id
4104: -- );
4105: --
4106: -- fix for bug 3681654
4107: -- using mtl_item_catalog_groups_b instead of ego_catalog_groups_v
4108: SELECT ic.item_catalog_group_id
4109: FROM mtl_item_catalog_groups_b ic
4110: WHERE EXISTS
4111: (

Line 4109: FROM mtl_item_catalog_groups_b ic

4105: --
4106: -- fix for bug 3681654
4107: -- using mtl_item_catalog_groups_b instead of ego_catalog_groups_v
4108: SELECT ic.item_catalog_group_id
4109: FROM mtl_item_catalog_groups_b ic
4110: WHERE EXISTS
4111: (
4112: SELECT olc.object_classification_code CatalogId
4113: FROM ego_obj_type_lifecycles olc, fnd_objects o