Oracle r12 bank statement interface tables : CE bank statement interface

Oracle r12 bank statement interface tables : CE bank statement interface

 

In this post, We will discuss about Oracle r12 bank statement interface tables. Oracle r12 bank statement interface tables 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 Oracle r12 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 Oracle r12 bank statement interface tables.

 

 

 Oracle r12 bank statement interface tables

 

 

Oracle r12 bank statement interface tables : CE bank statement interface

 

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