The Oracle Inventory module works with other Oracle Manufacturing modules to provide a complete set of transactions and reports for maintaining inventory control.
Oracle Interface Table — Oracle provides the following Interface Table for Customer Items: mtl_ci_interface
Sun Staging Table — The Oracle Applications Adapter sets up the following staging table, corresponding to the Oracle Open Interface Tables listed above: sb_mtl_ci_interface
Pre-Validation Script — The scripts corresponding to the Sun Staging Tables listed above are packaged within the following file: sb_validate_cust_items_pkg.sql
Oracle Interface Table — Oracle provides the following Interface Table for Customer Item Cross-References: mtl_ci_xrefs_interface
Sun Staging Table — The Oracle Applications Adapter sets up the following staging table, corresponding to the Oracle Open Interface Tables listed above:sb_mtl_ci_xrefs_interface
Pre-Validation Script — The scripts corresponding to the Sun Staging Tables listed above are packaged within the following file: sb_validate_ci_xrefs_pkg.sql
Oracle Interface Table — Oracle provides the following Interface Table for Cycle Count Entries: mtl_cc_entries_interface
Sun Staging Table— The Oracle Applications Adapter sets up the following staging table, corresponding to the Oracle Open Interface Table listed above: sb_mtl_cc_entries_interface
Pre-Validation Script— The scripts corresponding to the Sun Staging Table listed above are packaged within the following file: sb_validate_cc_entries_pkg.sql
Oracle Interface Tables— Oracle provides the following Interface Tables for items: mtl_system_items_interface and mtl_item_revisions_interface
Sun Staging Tables— The Oracle Applications Adapter sets up the following staging tables, corresponding to the Oracle Open Interface Tables listed above: sb_mtl_system_items_interface and
sb_mtl_item_revisions_int
Pre-Validation Scripts — The scripts corresponding to the Sun Staging Tables listed above are packaged within the following files: sb_validate_items_pkg.sql and sb_validate_invrev_pkg.sql
Oracle Interface Tables — Oracle provides the following Interface Tables for Item Replenishment: mtl_replenish_headers_int and mtl_replenish_lines_int
Sun Staging Tables — The Oracle Applications Adapter sets up the following staging tables, corresponding to the Oracle Open Interface Tables listed above: sb_mtl_replenish_headers_int and
sb_mtl_replenish_lines_int
Pre-Validation Scripts — The scripts corresponding to the Sun Staging Tables listed above are packaged within the following files: sb_validate_rep_headers_pkg.sql and sb_validate_rep_lines_pkg.sql
These files are controlled by the following master validation file:
sb_validate_rep_pkg.sql
Oracle Interface Tables — Oracle provides the following Interface Tables for Transactions:
mtl_transactions_interface
mtl_transaction_lots_interface
mtl_serial_numbers_interface
Sun Staging Tables — The Oracle Applications Adapter sets up the following staging tables, corresponding to the Oracle Open Interface Tables listed above:
sb_mtl_transactions_interface
sb_mtl_transaction_lots_inter
sb_mtl_serial_numbers_interface
Pre-Validation Scripts — The scripts corresponding to the Sun Staging Tables listed above are packaged within the following files:
sb_validate_trans_pkg.sql
sb_validate_trans_lots_pkg.sql
sb_validate_serial_nos_pkg.sql
These files are controlled by the following master validation file:
sb_validate_tran_all_pkg.sql