--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