CE Cleared Transactions - draft

Description
Categories: BI Publisher
Columns: Bank Account Name, Bank Account Num, Bank Name, Bank Branch Name, Type, Break Type, Type Dsp, Supplier Customer, Trx Date, Maturity Date ...
Application: Cash Management
Source: Cleared Transactions Report (XML) - Not Supported: Reserved For Future Use
Short Name: CEXCLEAR_XML
DB package: CE_CEXCLEAR_XMLP_PKG
SELECT aba.bank_account_name bank_account_name,
aba.bank_account_num bank_account_num,
BankParty.PARTY_NAME bank_name,
BranchParty.PARTY_NAME bank_branch_name,
/*abb.bank_name bank_name,
abb.bank_branch_name bank_branch_name,*/
'PAYMENT' type,
'PAYMENT' break_type,
'Payment' type_dsp,
c.vendor_name supplier_customer,
c.check_date trx_date,
c.future_pay_due_date maturity_date,
c.amount bank_account_amount,
to_char(c.check_number) trx_number,
lk.payment_method_name payment_method,
c.currency_code currenc