XTR Program - Update Settlement Bank Account Execution

➜ Back to Library
Description
Categories: BI Publisher
Application: Treasury
Source: Program - Update Settlement Bank Account Execution Report (XML)
Short Name: XTRUPREP_XML
DB package: XTR_XTRUPREP_XMLP_PKG
Run XTR Program - Update Settlement Bank Account Execution and other Oracle EBS reports with Blitz Report™ on our demo environment
select cfur.amount_date, xat.amount_name, cfur.cashflow_amount, xdt.user_deal_type, cfur.deal_number, cfur.transaction_number, cfur.message_name, 
decode(cfur.updated_flag, 'N', nvl(:P_MESSAGE_CODE_FOR_ERROR,rpad(' ',4000,' ')), nvl(:P_MESSAGE_CODE_FOR_UPDATE,rpad(' ',4000,' '))) upd_rec
from xtr_cflow_updated_records cfur, xtr_deal_types xdt, xtr_amount_types xat
where cfur.cashflow_request_details_id = :P_CFLOW_REQUEST_DETAILS_ID
and xdt.deal_type = cfur.deal_type
and xat.amount_type = cfur.amount_type
and xat.deal_type = cfur.deal_type
and :P_NO_RECORDS_UPDATED = 'N'
ORDER BY 8 desc
Parameter Name SQL text Validation
Request Number 
 
 LOV Oracle
Download
Related Blitz Reports
XTR Settlements - Status XTR Admin - Cancelled Transactions Summary XTR Term Money - Retail Term Money Statements XTR Positions - Maturities by Counterparty XTR Positions - Maturities by Date XTR Positions - Outstanding Hedge Instruments XTR Positions - Treasury Cashflows by Account XTR Positions - Interest Rate Hedges XTR Positions - Treasury Consolidated Cashflows
Blitz Report™

Blitz Report™ provides multiple benefits: