To see List of Object
1. List of Object Not-Checked Out and No- Token
SELECT FROM SY920.F98222 WHERE POOMWCHS='0' AND 'POOOMWOST='02' AND POOMWPOS1='0' AND POOMWPON1=0 AND POOMWPRJID='Project Name'
2. List of Object Not-Checked Out but have Token
SELECT FROM SY920.F98222 WHERE POOMWCHS='0' AND 'POOOMWOST='02' AND POOMWPOS1='1' AND POOMWPRJID='Project Name'
3. List of Object Checked Out and have Token
SELECT FROM SY920.F98222 WHERE POOMWCHS='1' AND 'POOOMWOST='03' AND POOMWPOS1='1' AND POOMWPRJID='Project Name'
4. JDE OMW Token Release using SQL
UPDATE SY920.F98222 SET POOMWPOS1='0',POOMWPON1=0 WHERE POOMWOST='02' AND POOMWPOS1='1' AND POOMWPRJID LIKE '%2022%'
