CE Transactions Available for Reconciliation - 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: Transactions Available for Reconciliation Report (XML) - Not Supported: Reserved For Future Use
Short Name: CEXAVTRX_XML
DB package: CE_CEXAVTRX_XMLP_PKG
SELECT 	CE_AVAILABLE_TRANSACTIONS_V.bank_account_name	bank_account_name,
	CE_AVAILABLE_TRANSACTIONS_V.bank_account_num	bank_account_num,
	bank_name				bank_name,
	bank_branch_name				bank_branch_name,
	DECODE(clearing_trx_type,'MISC','CASH',
	         'PAY', 'PAYROLL',
 	         'PAY_EFT', 'PAYROLL',
                           'XTR_LINE', DECODE(trx_type, 'PAYMENT', 'ROI-P',
			   'CASH', 'ROI-R'