XTR Program - Update Settlement Bank Account Execution

Description
Categories: BI Publisher
Columns: Amount Date, Amount Name, Cashflow Amount, User Deal Type, Deal Number, Transaction Number, Message Name, Upd Rec ...
Application: Treasury
Source: Program - Update Settlement Bank Account Execution Report (XML)
Short Name: XTRUPREP_XML
DB package: XTR_XTRUPREP_XMLP_PKG
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