APPS.EGO_ITEM_PUB dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 3672: FROM mtl_item_catalog_groups_b b

3668: l_sql VARCHAR2(15000);
3669: BEGIN
3670: l_str_cat_id := null;
3671: FOR i IN (SELECT item_catalog_group_id
3672: FROM mtl_item_catalog_groups_b b
3673: CONNECT BY PRIOR item_catalog_group_id = parent_catalog_group_id
3674: START WITH b.item_catalog_group_id = p_catalog_group_id)
3675: LOOP
3676: IF l_str_cat_id IS NULL THEN

Line 3859: -- using mtl_item_catalog_groups_b instead of ego_catalog_groups_v

3855: -- START WITH catalog_group_id = cp_catalog_category_id
3856: -- );
3857: --
3858: -- fix for bug 3681654
3859: -- using mtl_item_catalog_groups_b instead of ego_catalog_groups_v
3860: SELECT ic.item_catalog_group_id
3861: FROM mtl_item_catalog_groups_b ic
3862: WHERE EXISTS
3863: (

Line 3861: FROM mtl_item_catalog_groups_b ic

3857: --
3858: -- fix for bug 3681654
3859: -- using mtl_item_catalog_groups_b instead of ego_catalog_groups_v
3860: SELECT ic.item_catalog_group_id
3861: FROM mtl_item_catalog_groups_b ic
3862: WHERE EXISTS
3863: (
3864: SELECT olc.object_classification_code CatalogId
3865: FROM ego_obj_type_lifecycles olc, fnd_objects o