APPS.INV_ITEM_CATEGORY_OI dependencies on MTL_SYSTEM_ITEMS_INTERFACE_S

Line 473: SELECT mtl_system_items_interface_s.NEXTVAL

469: -- Also, assign transaction_id, request_id
470:
471: FOR cr IN miss_org_id_csr LOOP
472:
473: SELECT mtl_system_items_interface_s.NEXTVAL
474: INTO l_transaction_id
475: FROM dual;
476:
477: UPDATE mtl_item_categories_interface

Line 479: -- transaction_id = mtl_system_items_interface_s.NEXTVAL

475: FROM dual;
476:
477: UPDATE mtl_item_categories_interface
478: SET
479: -- transaction_id = mtl_system_items_interface_s.NEXTVAL
480: transaction_id = l_transaction_id
481: , request_id = g_request_id
482: , process_flag = 3
483: WHERE CURRENT OF miss_org_id_csr;

Line 550: SELECT mtl_system_items_interface_s.NEXTVAL

546: ELSE
547: l_process_flag := 1;
548: END IF;
549:
550: SELECT mtl_system_items_interface_s.NEXTVAL
551: INTO l_transaction_id
552: FROM dual;
553:
554: l_organization_id := icoi_rec.organization_id;