CE Bank Transaction Codes Listing - draft

Description
Categories: BI Publisher, Financials
Application: Cash Management
Source: Bank Transaction Codes Listing (XML) - Not Supported: Reserved For Future Use
Short Name: CEXTRXCD_XML
DB package: CE_CEXTRXCD_XMLP_PKG
SELECT     TC.bank_account_name			BANK_ACCOUNT_NAME,
	TC.bank_account_num				BANK_ACCOUNT_NUM,
	TC.bank_account_currency_code			BANK_ACCOUNT_CURRENCY_CODE,
	TC.bank_branch_name				BANK_BRANCH_NAME,
	TC.bank_name				BANK_NAME, 	
	TC.type_dsp					TYPE_DSP,
	TC.trx_code					TRX_CODE,
	TC.create_misc_trx_flag_dsp			CREATE_MISC_TRX_FLAG_DSP,
	TC.reconciliation_sequence			RECONCILIATION_SEQUENCE,
	TC.receivables_activity				RECEIVABLES_ACTIVITY,
	TC.payment_method				PAYMENT_METHOD,
              	TC.reconcile_flag_dsp
RECONCILE_FLAG_DSP,
	TC.description				DESCRIPTION,
	TC.start_date
START_DATE,
	TC.end_date
END_DATE,
	L1.meaning
Correction_method_dsp,
	L2.meaning
Matching_against_dsp, tc.payroll_payment_format_dsp, tc.payroll_matching_order
FROM 	CE_TRANSACTION_CODES_V		TC
,	CE_LOOKUPS 	L1
,	CE_LOOKUPS 	L2
WHERE	bank_account_id = 
	NVL(:P_BANK_ACCOUNT_ID,bank_account_id)
AND	L1.LOOKUP_CODE(+) = TC.Correction_Method
AND	L1.LOOKUP_TYPE(+) = 'CORRECTION_METHOD'
AND	L2.LOOKUP_CODE(+) = TC.Matching_Against
AND	L2.LOOKUP_TYPE(+) = 'CORRECTION_MATCHING'
ORDER BY  BANK_BRANCH_NAME,BANK_NAME, BANK_ACCOUNT_NAME,BANK_ACCOUNT_NUM,BANK_ACCOUNT_CURRENCY_CODE,RECONCILIATION_SEQUENCE,
PAYROLL_PAYMENT_FORMAT_DSP,PAYROLL_MATCHING_ORDER,TYPE_DSP, TRX_CODE,CREATE_MISC_TRX_FLAG_DSP,
RECEIVABLES_ACTIVITY,PAYMENT_METHOD,RECONCILE_FLAG_DSP,DESCRIPTION,CORRECTION_METHOD_DSP,MATCHING_AGAINST_DSP,START_DATE,END_DATE
Parameter Name SQL text Validation
Bank Account Number
 
LOV Oracle