APPS.EGO_INV_ITEM_CATALOG_PVT dependencies on EGO_OBJ_ATTR_GRP_ASSOCS_V

Line 791: FROM ego_obj_attr_grp_assocs_v

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
793: AND classification_code IN
794: (SELECT to_char(item_catalog_group_id)
795: FROM mtl_item_catalog_groups_b

Line 799: FROM ego_obj_attr_grp_assocs_v

795: FROM mtl_item_catalog_groups_b
796: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
797: START WITH item_catalog_group_id = p_catalog_group_id))
798: AND NOT EXISTS (SELECT NULL
799: FROM ego_obj_attr_grp_assocs_v
800: WHERE attr_group_id = ext.attr_group_id
801: AND classification_code IN
802: (SELECT to_char(item_catalog_group_id)
803: FROM mtl_item_catalog_groups_b

Line 810: FROM ego_obj_attr_grp_assocs_v

806:
807: DELETE ego_mtl_sy_items_ext_tl extl
808: WHERE inventory_item_id = p_inventory_item_id
809: AND EXISTS (SELECT NULL
810: FROM ego_obj_attr_grp_assocs_v
811: WHERE attr_group_id = extl.attr_group_id
812: AND classification_code IN
813: (SELECT to_char(item_catalog_group_id)
814: FROM mtl_item_catalog_groups_b

Line 818: FROM ego_obj_attr_grp_assocs_v

814: FROM mtl_item_catalog_groups_b
815: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
816: START WITH item_catalog_group_id = p_catalog_group_id))
817: AND NOT EXISTS (SELECT NULL
818: FROM ego_obj_attr_grp_assocs_v
819: WHERE attr_group_id = extl.attr_group_id
820: AND classification_code IN
821: (SELECT to_char(item_catalog_group_id)
822: FROM mtl_item_catalog_groups_b