DB-Interestclaims-Queries to check Payment Details

SELECT * FROM MRT_DBCLAIMSJOURNAL
WHERE MRTTIMESTAMP IN ('20210824:10414804:sangmrua',
'20210824:08283204:sangmrua',
'20210824:11344504:sangmrua',
'20210824:11400504:sangmrua',
'20210824:11482704:sangmrua');
SELECT * FROM MRT_DBCLAIMSPAYADV
WHERE MRT_KEY IN ('PL20210824:10414804:sangmrua',
'PL20210824:08283204:sangmrua',
'PL20210824:11344504:sangmrua',
'PL20210824:11400504:sangmrua',
'PL20210824:11482704:sangmrua');
SELECT MRT_KEY,MRT_CLOSEDATE,MRT_CLOSED,MRTID,MRTASCLMFLAGS,MRTCLMFLAGS,MRTNUMSETTS,
MRT_FLAGS,MRTMSF_P_STATUS,MRT_NARRATIVE,MRTMSF_P_NARRATIVE,MRT_CLOSEDFLD,
MRTAMOUNT,MRTALREADYPAID,MRTPAIDBY,MRTSETTBY,MRT_VALUEDATE,MRTUNIQUEREFERENCE,
MRT_IMPORTDATE,MRT_LASTUPDATE
FROM MRT_DBCLAIMS
WHERE MRT_KEY IN (SELECT MRTCMJREF FROM MRT_DBCLAIMSJOURNAL
WHERE MRTTIMESTAMP IN ('20210824:10414804:sangmrua',
'20210824:08283204:sangmrua',
'20210824:11344504:sangmrua',
'20210824:11400504:sangmrua',
'20210824:11482704:sangmrua'));