OPM - GME_BATCH_HEADER Statuses Information

select * from all_objects
where object_name like 'GME%BATCH%'
and object_type = 'TABLE'
------------------------------------------------------------

SELECT o.ORGANIZATION_CODE, o.ORGANIZATION_NAME, o.ORGANIZATION_ID,
gbh.BATCH_NO,decode(gbh.BATCH_STATUS,3,'Completed',4,'Closed',2,'WIP',
'Just Created') Batch_Status,to_char(gbh.creation_date,'DD-MON-YYYY HH24:MI:SS AM')
FROM GME_BATCH_HEADER gbh,
ORG_ORGANIZATION_DEFINITIONS o
WHERE CREATION_DATE >=TO_DATE('01/05/2015','dd-mm-yy')
AND gbh.ORGANIZATION_ID=o.ORGANIZATION_ID
ORDER BY gbh.creation_date desc

--------------------------------------------------------------
select * from gme_batch_header
where batch_no = '1710000426'

BATCH_STATUS = 2 (WIP-Work In Process)
BATCH_STATUS = 1 (Pending)
BATCH_STATUS = 3 (Completed)
BATCH_STATUS = 4 (Closed)
BATCH_STATUS = -1 (Cancelled)
-------------------------------------------------------------------