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:
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