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