Oracle Applications Manufacturing Module

The Manufacturing module is divided into the following sub-modules:

• Inventory Module.

• Purchase Order Import Module.

• Oracle Interface Tables.

Inventory Module

The Oracle Inventory module works with other Oracle Manufacturing modules to provide a complete set of transactions and reports for maintaining inventory control.

Customer Items

• 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

Customer Items Cross-Reference

• 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

Cycle Count Entries

• 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

Items and Item Revisions

• 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

Replenishment

• 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

Transactions

• 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

Purchase Order Import Module

The Oracle Purchase Order Import module works with other Oracle Manufacturing modules to provide a complete set of transactions and reports for maintaining inventory control.

Purchase Order Import

• Oracle Interface Tables — Oracle provides the following Interface Tables for Purchase Order Import:

  • po_headers_interface

  • po_lines_interface

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

  • sb_po_headers_interface

  • sb_po_lines_interface

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

  • sb_validate_poi_hdrs_pkg.sql

  • sb_validate_poi_lines_pkg.sql

  These files are controlled by the following master validation file:

  sb_validate_poi_pkg.sql

Purchase Order Receiving

• Oracle Interface Tables — Oracle provides the following Interface Tables for Receiving:

  • rcv_headers_interface

  • rcv_transactions_interface

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

  • sb_rcv_headers_interface

  • sb_rcv_transactions_interface

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

  • sb_validate_rcv_hdr_pkg.sql

  • sb_validate_rcv_trans_pkg.sql

  These files are controlled by the following master validation file:

  sb_validate_rcv_pkg.sql

Purchase Order Requisitions

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

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

• Pre-Validation Script — The scripts corresponding to the Sun Staging Table listed above are packaged within the following file: sb_validate_por_req_pkg.sql

Order Entry Module

The Oracle Order Entry module works with other Oracle Manufacturing modules to provide a complete set of transactions and reports for maintaining order entry control.

Oracle Interface Tables

Oracle provides the following Interface Table for Order Entry:

• oe_headers_interface

• oe_lines_interface

• oe_actions_interface

• oe_credits_interface

• oe_price_adjs_interface

• oe_lotserials_interface

• oe_reservtns_interface

Sun Staging Tables

• sb_oe_headers_interface

• sb_oe_lines_interface

• sb_oe_actions_interface

• sb_oe_credits_interface

• sb_oe_price_adjs_interface

• sb_oe_lotserials_interface

• sb_oe_reservtns_interface

Pre-Validation Scripts

The scripts corresponding to the Sun Staging Tables listed above are packaged within the following file:

sb_validate_oe_pkg.sql

This file is controlled by the following master validation file:

sb_validate_oi_pkg.sql