物料类别导入 Inventory Item Categories Migration

--INV Item Categories

--Concurrent programs:N: INV/Items/Import/Item Category Assignment Open Interface

SELECT *
  FROM mtl_item_categories_interface mici
 WHERE TRUNC (creation_date) = TRUNC (SYSDATE);

--Delete

DELETE FROM mtl_item_categories_interface
      WHERE TRUNC (creation_date) = TRUNC (SYSDATE);

--******************************************************************************

SELECT *
  FROM mtl_item_categories
 WHERE TRUNC (creation_date) = TRUNC (SYSDATE);

--******************************************************************************

DECLARE
   l_iface_rec        mtl_item_categories_interface%ROWTYPE;
   l_cur_mfg_org_id   NUMBER                                  := 204;
   --Current Inv Organization
   l_user_id          NUMBER                                  := 1318;
--User ID, Sysadmin here
BEGIN
   l_iface_rec.la