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 1261: UPDATE mtl_item_categories

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

Line 1278: DELETE FROM mtl_item_categories_interface

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

Line 1313: FROM mtl_item_categories_interface

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