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:13PM in Inventory Management 1 comment

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';

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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