Bank statement tables in oracle apps r12

Bank statement tables in oracle apps r12

In this post, We will discuss about Bank Statement Tables in Oracle apps R12. Bank Statement Table stores the MT940 bank statement information's which we got from bank in the form of files and we put these files in the Oracle server and our Bank Statement Loader Program process this MT940 file and insert the bank statement data in the Bank Statement interface tables and then imports in the Bank Statement Tables. We have two important Bank statement tables in oracle apps r12. Here below I will share the complete information's about Bank statement tables in oracle apps r12.

 

 

 

 

2 Important Bank statement tables in oracle apps r12

 

 

Bank statement Interface tables in oracle apps r12

 

CE_STATEMENT_HEADERS_INTERFACE

CE_STATEMENT_LINES_INTERFACE

  

 

Bank statement Base tables in oracle apps r12

 

 

CE_STATEMENT_HEADERS

CE_STATEMENT_LINES

 

SELECT trx_date, amount, status, creation_date, bank_trx_number,

       effective_date

  FROM apps.ce_statement_headers a1, apps.ce_statement_lines a2

 WHERE a1.statement_header_id = a2.statement_header_id