JPM-ClaimsManager-Queries for checking payment details

SELECT MRTID,MRTCMJREF,MRTTIMESTAMP,MRTNLINES,
MRTPOSTTYPE,MRTPOSTID,MRTPOSTINF,MRTORDER,MRTEXTRVSJTEXT,
MRTPOSTCAT,MRTRLSTIMESTAMP,MRT_LASTUPDATE FROM MRT_SNCLAIMSJOURNAL
WHERE MRTTIMESTAMP='20220804:07551734:E865696'
SELECT * FROM MRT_SNCLAIMSPAYADV WHERE MRT_KEY IN ('PA20220804:07551734:E865696');
SELECT MRT_KEY,MRT_CLOSEDATE,MRT_CLOSED,MRTID,MRTASCLMFLAGS,MRTCLMFLAGS,MRTNUMSETTS,
MRT_FLAGS,MRTLASTSETTDATE,MRTMSF_P_STATUS,MRT_NARRATIVE,MRTMSF_P_NARRATIVE,MRT_CLOSEDFLD,
MRTAMOUNT,MRTALREADYPAID,MRTALREADYPAIDTBU,MRTPAIDBY,MRTSETTBY,MRTUNIQUEREF,
MRT_IMPORTDATE,MRT_LASTUPDATE,MRTPAIDSTATUS
FROM MRT_SNCLAIMS
WHERE MRT_KEY IN
(SELECT MRTCMJREF FROM MRT_SNCLAIMSJOURNAL WHERE MRTTIMESTAMP IN ('20220804:07551734:E865696'));