Roles/access required to fetch the deletion group data — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Roles/access required to fetch the deletion group data

edited Jul 30, 2025 3:14PM in Inventory Management 1 comment

we are using the below query to fetch the deletion group details SELECT edg.DELETE_GROUP_NAME, esi.ITEM_NUMBER, iop.ORGANIZATION_code FROM EGP_DELETE_GROUPS edg, EGP_DELETE_ENTITIES ede, EGP_SYSTEM_ITEMS_B esi , INV_ORG_PARAMETERS iop WHERE 1=1 and edg.DELETE_GROUP_SEQUENCE_ID = ede.DELETE_GROUP_SEQUENCE_ID and ede.PK1_VALUE = esi.INVENTORY_ITEM_ID( ) and esi.ORGANIZATION_ID = iop.ORGANIZATION_ID and iop.ORGANIZATION_code = '24719' --and esi.ITEM_NUMBER = '10002' --and edg.DELETE_GROUP_NAME = 'TEST_DEL_11'; there are some deletion groups are created in application but from above query we are not able to fetch it...pls check and update what roles/access

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!