968: -- Insert into Categories interface table
969: -- ===========================================================
970:
971:
972: INSERT INTO mtl_item_categories_interface
973: ( inventory_item_id
974: , organization_id
975: , CATEGORY_SET_ID
976: , CATEGORY_ID
1005: ,FND_GLOBAL.conc_program_id
1006: ,SYSDATE
1007: FROM mtl_category_sets_b mcs
1008: ,mtl_system_items_interface msi
1009: ,mtl_item_categories mic
1010: WHERE msi.inventory_item_id = mic.inventory_item_id
1011: AND msi.organization_id = p_target_org_id
1012: AND mic.organization_id = p_source_org_id
1013: AND msi.set_process_id = l_set_process_id