Item Interface Program

ITEM CONVERSION: imports item and his item attributes along with revision details
I wrote a custom program that extracts item information from the legacy system to a flat file and used SQL* Loader to upload information into a temporary table.
Then I wrote pl sql program to insert item details into the interface tables MTL_SYSTEM_ITEM_INTERFACE table, and revision details MTL_ITEMS_REVISIONS_INTERFACE table.
After loading the items into interface tables, I run the Item Interface to import the data. The Item Interface assigns defaults, validates data e, and then imports the new items

INTERFACE TABLES:
MTL_SYSTEM_ITEMS_INTERFACE, MTL_ITEM_REVISIONS_INTERFACE
MTL_ITEM_CATEGORIES_INTERFACE(used internally by item interface)

BASE TABLES:
MTL_SYSTEM_ITEMS_B (Segment 1 stores Model # of Item) MTL_ITEM_ATTRIBUTES, MTL_ITEM_CATEGORIES, MTL_ITEM_LOCATIONS, MTL_ITEM_REVISIONS, MTL_ITEM_STATUS

INSERT INTO mtl_system_items_interface (segment1, description, organization_id,transaction_type, set_process_id, inventory_item_id)
VALUES('W800ii', 'sony_erricson',204,'CREATE',10001601, 343);

Run Import items program with parameters
all organizations,
validate items,
process items
Delete processed rows,
process set