APPS.EGO_INV_ITEM_CATALOG_PVT dependencies on EGO_MTL_SY_ITEMS_EXT_B

Line 788: DELETE ego_mtl_sy_items_ext_b ext

784: -- FOR catalog_record IN c_lost_catalogs(p_catalog_group_id,p_new_catalog_group_id)
785: -- LOOP
786:
787: --Delete AG which doesnt fall under new catalog hierarchy.
788: DELETE ego_mtl_sy_items_ext_b ext
789: WHERE inventory_item_id = p_inventory_item_id
790: AND EXISTS (SELECT NULL
791: FROM ego_obj_attr_grp_assocs_v
792: WHERE attr_group_id = ext.attr_group_id

Line 827: UPDATE ego_mtl_sy_items_ext_b

823: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
824: START WITH item_catalog_group_id = p_new_catalog_group_id));
825:
826: --Update valid AG to point to new catalog group
827: UPDATE ego_mtl_sy_items_ext_b
828: SET item_catalog_group_id = p_new_catalog_group_id
829: WHERE inventory_item_id = p_inventory_item_id;
830:
831: UPDATE ego_mtl_sy_items_ext_tl