APPS.INV_ITEM_CATEGORY_OI dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 210: FROM mtl_system_items_interface

206: cp_organization_id IN NUMBER,
207: cp_xset_id IN NUMBER)
208: IS
209: SELECT inventory_item_id
210: FROM mtl_system_items_interface
211: WHERE item_number = cp_item_number
212: AND organization_id = cp_organization_id
213: AND set_process_id = cp_xset_id
214: AND process_flag IN (1,2,4);

Line 466: SELECT mtl_system_items_interface_s.NEXTVAL

462: -- Also, assign transaction_id, request_id
463:
464: FOR cr IN miss_org_id_csr LOOP
465:
466: SELECT mtl_system_items_interface_s.NEXTVAL
467: INTO l_transaction_id
468: FROM dual;
469:
470: UPDATE mtl_item_categories_interface

Line 472: -- transaction_id = mtl_system_items_interface_s.NEXTVAL

468: FROM dual;
469:
470: UPDATE mtl_item_categories_interface
471: SET
472: -- transaction_id = mtl_system_items_interface_s.NEXTVAL
473: transaction_id = l_transaction_id
474: , request_id = g_request_id
475: , process_flag = 3
476: WHERE CURRENT OF miss_org_id_csr;

Line 543: SELECT mtl_system_items_interface_s.NEXTVAL

539: ELSE
540: l_process_flag := 1;
541: END IF;
542:
543: SELECT mtl_system_items_interface_s.NEXTVAL
544: INTO l_transaction_id
545: FROM dual;
546:
547: l_organization_id := icoi_rec.organization_id;