Roles/access required to fetch the deletion group data
we are using the below query to fetch the deletion group detailsSELECT edg.DELETE_GROUP_NAME, esi.ITEM_NUMBER, iop.ORGANIZATION_codeFROM EGP_DELETE_GROUPS edg, EGP_DELETE_ENTITIES ede, EGP_SYSTEM_ITEMS_B esi , INV_ORG_PARAMETERS iop WHERE 1=1and edg.DELETE_GROUP_SEQUENCE_ID = ede.DELETE_GROUP_SEQUENCE_IDand ede.PK1_VALUE = esi.INVENTORY_ITEM_ID(+)and esi.ORGANIZATION_ID = iop.ORGANIZATION_IDand iop.ORGANIZATION_code = '24719'--and esi.ITEM_NUMBER = '10002'--and edg.DELETE_GROUP_NAME = 'TEST_DEL_11';