--Get the Batch ID for Specific Batch---
select * from apps.gl_je_batches
where
name like '%FA-31-MSI-HT-MAR-23-02 Spreadsheet A 4791187 254572724%'
;
--Get the Item Key & Item Type for the specific GL Bach--
SELECT WF_PROCESS.PROCESS_NAME,
WF_IT_ACT_STATUS.*
FROM apps.WF_ITEM_ACTIVITY_STATUSES WF_IT_ACT_STATUS,
apps.WF_PROCESS_ACTIVITIES WF_PROCESS
WHERE 1=1
AND ITEM_KEY LIKE '%4662825%'-- Pass the Bactch ID Here
AND WF_IT_ACT_STATUS.ITEM_TYPE = 'GLBATCH'
AND WF_PROCESS.INSTANCE_ID = WF_IT_ACT_STATUS.PROCESS_
ORDER BY BEGIN_DATE, END_DATE
;
