You can pull PPR and source XML details , which got formatted today, with the source XML
SELECT trxnmid, EXTRACTVALUE ( XMLType (document), '/OutboundPaymentInstruction/PaymentInstructionInfo/UserAssignedRefCode') ppr_name, EXTRACTVALUE ( XMLType (document), '/OutboundPaymentInstruction/PaymentInstructionInfo/FormatProgramRequestID') fmt_request_id, EXTRACTVALUE ( XMLType (document), '/OutboundPaymentInstruction/PaymentProcessProfile/PaymentProcessProfileName') ppp_name, EXTRACTVALUE ( XMLType (document), '/OutboundPaymentInstruction/CheckFormatInfo/PaymentDocumentName') pmt_doc_name, EXTRACTVALUE ( XMLType (document), '/OutboundPaymentInstruction/InstructionTotals/PaymentCount') pmt_cnt, document raw_xml FROM iby_trxn_documents itd WHERE 1 = 1 AND itd.creation_date > TRUNC (SYSDATE);