Bank Statement

• Oracle Interface Tables — Oracle provides the following Interface Table for Requisitions:

  • ce_statement_headers_int_all

  • ce_statement_lines_interface

• Sun Staging Tables — The Oracle Applications Adapter sets up the following staging table, corresponding to the Oracle Open Interface Table listed above:

  • sb_ce_statement_headers_int_all

  • sb_ce_statement_lines_interface

• Pre-Validation Scripts — The scripts corresponding to the Sun Staging Tables listed above are packaged within the following files:

  • sb_validate_stmt_headers_pkg.sql

  • sb_validate_stmt_lines_pkg.sql

  These files are controlled by the following master validation file:

  sb_validate_bank_stmt_pkg.sql