Item Open Interface

Oracle Base tables related to Item setup

mtl_system_items_b
mtl_item_categories mic
mtl_category_sets_tl mcst
mtl_category_sets_b mcs
mtl_descriptive_elements -- Catalog Element Names
mtl_descr_element_values -- Contains Catalog Element Values for Item
apps.mtl_categories_kfv -- View for cat KFF contains concatenated_segments

Learning : Categories controlled at master org level can not be changed at individual org level.
Error Message : Cannot Create/Delete Item Controlled category set from Organization Items

Tables to be populated as part of interface
mtl_system_items_interface
mtl_item_categories_interface

Notes: We can have one record for each org in main interface table.
Transaction type to be used is CREATE

• Item Catalog API to populate catalog element values for item

p_item_desc_element_table APPS.INV_ITEM_CATALOG_ELEM_PUB.ITEM_DESC_ELEMENT_TABLE;

INV_ITEM_CATALOG_ELEM_PUB.PROCESS_ITEM_DESCR_ELEMENTS( p_api_version => p_api_version, p_init_msg_list => p_init_msg_list, p_commit_flag => p_commit_flag, p_validation_level => p_validation_level, p_inventory_item_id => p_inventory_item_id, p_item_number => p_item_number, p_item_desc_element_table => p_item_desc_element_table, x_generated_descr => x_generated_descr, x_return_status => x_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data );