eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_PDOI_ITEM_PROCESS_PVT dependencies on MTL_ITEM_CATEGORIES

Line 1260: UPDATE mtl_item_categories

1256: d_position := 50;
1257:
1258: -- update category table
1259: FORALL i IN INDICES OF l_category_id_tbl
1260: UPDATE mtl_item_categories
1261: SET category_id = l_category_id_tbl(i)
1262: WHERE inventory_item_id = l_item_id_tbl(i)
1263: AND organization_id = l_org_id_tbl(i)
1264: AND category_set_id = PO_PDOI_PARAMS.g_sys.def_cat_set_id;

Line 1277: DELETE FROM mtl_item_categories_interface

1273:
1274: d_position := 70;
1275:
1276: FORALL i IN 1..l_index_tbl.COUNT
1277: DELETE FROM mtl_item_categories_interface
1278: WHERE inventory_item_id = l_item_id_tbl(i)
1279: AND organization_id = l_org_id_tbl(i);
1280:
1281: d_position := 80;

Line 1312: FROM mtl_item_categories_interface

1308: FROM mtl_interface_errors
1309: WHERE transaction_id = l_transaction_id_tbl(i)
1310: OR transaction_id = (
1311: SELECT transaction_id
1312: FROM mtl_item_categories_interface
1313: WHERE organization_id = l_org_id_tbl(i)
1314: AND inventory_item_id = l_item_id_tbl(i))
1315: OR transaction_id = (
1316: SELECT transaction_id