APPS.EGO_INV_ITEM_CATALOG_PVT dependencies on EGO_OBJ_ATTR_GRP_ASSOCS_V

Line 831: FROM ego_obj_attr_grp_assocs_v

827: DELETE ego_mtl_sy_items_ext_b ext
828: WHERE inventory_item_id = p_inventory_item_id
829: AND organization_id IN (SELECT organization_id FROM mtl_parameters WHERE master_organization_id=p_organization_id) /* Changed WHERE clause for the Bug 9094912 */
830: AND EXISTS (SELECT NULL
831: FROM ego_obj_attr_grp_assocs_v
832: WHERE attr_group_id = ext.attr_group_id
833: AND classification_code IN
834: (SELECT to_char(item_catalog_group_id)
835: FROM mtl_item_catalog_groups_b

Line 839: FROM ego_obj_attr_grp_assocs_v

835: FROM mtl_item_catalog_groups_b
836: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
837: START WITH item_catalog_group_id = p_catalog_group_id))
838: AND NOT EXISTS (SELECT NULL
839: FROM ego_obj_attr_grp_assocs_v
840: WHERE attr_group_id = ext.attr_group_id
841: AND classification_code IN
842: (SELECT to_char(item_catalog_group_id)
843: FROM mtl_item_catalog_groups_b

Line 854: FROM ego_obj_attr_grp_assocs_v

850: DELETE ego_mtl_sy_items_ext_tl extl
851: WHERE inventory_item_id = p_inventory_item_id
852: AND organization_id IN (SELECT organization_id FROM mtl_parameters WHERE master_organization_id=p_organization_id) /* Changed WHERE clause for the Bug 9094912 */
853: AND EXISTS (SELECT NULL
854: FROM ego_obj_attr_grp_assocs_v
855: WHERE attr_group_id = extl.attr_group_id
856: AND classification_code IN
857: (SELECT to_char(item_catalog_group_id)
858: FROM mtl_item_catalog_groups_b

Line 862: FROM ego_obj_attr_grp_assocs_v

858: FROM mtl_item_catalog_groups_b
859: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
860: START WITH item_catalog_group_id = p_catalog_group_id))
861: AND NOT EXISTS (SELECT NULL
862: FROM ego_obj_attr_grp_assocs_v
863: WHERE attr_group_id = extl.attr_group_id
864: AND classification_code IN
865: (SELECT to_char(item_catalog_group_id)
866: FROM mtl_item_catalog_groups_b