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