SELECT BATCH_JOB_ID,BATCH_START_DTTM
FROM CI_BATCH_JOB A
WHERE TRIM(A.BATCH_CD) = 'INSERT_BATCH_CODE'
AND A.BATCH_START_DTTM = (SELECT MAX(B.BATCH_START_DTTM)
FROM CI_BATCH_JOB B
WHERE
B.BATCH_CD = A.BATCH_CD
)
uploaded by Nuno Rodrigues