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