APPS.WMS_UT_PKG dependencies on MTL_TXN_REQUEST_LINES

Line 1383: UPDATE mtl_txn_request_lines

1379: g_demand_tbl(l_dem_indx).demand_source_header_id := l_trolin_tbl(l_ix).header_id;
1380: g_demand_tbl(l_dem_indx).demand_source_line_id := l_trolin_tbl(l_ix).line_id;
1381: g_demand_tbl(l_dem_indx).demand_source_name := NULL;
1382: g_demand_tbl(l_dem_indx).demand_source_delivery := NULL;
1383: UPDATE mtl_txn_request_lines
1384: SET txn_source_line_id = l_trolin_tbl(l_ix).line_id
1385: WHERE line_id = l_trolin_tbl(l_ix).line_id;
1386:
1387: IF l_mo_orders(l_ix)(1) IS NOT NULL THEN

Line 2587: FROM MTL_TXN_REQUEST_LINES

2583: p_test_id IN NUMBER)
2584: IS
2585: CURSOR c_mol (p_item_id NUMBER) IS
2586: SELECT line_id
2587: FROM MTL_TXN_REQUEST_LINES
2588: WHERE organization_id = p_org_id
2589: AND inventory_item_id = p_item_id;
2590:
2591: CURSOR c_mmtt (p_item_id NUMBER) IS

Line 2653: DELETE FROM mtl_txn_request_lines

2649:
2650: -- INV_MO_ADMIN_PUB.cancel_line(1.0,'F','F',FND_API.G_VALID_LEVEL_FULL,c_rec.line_id,l_msg_count,l_msg_data,l_return_status);
2651: END LOOP;
2652:
2653: DELETE FROM mtl_txn_request_lines
2654: WHERE organization_id = p_org_id
2655: AND inventory_item_id = l_item_id;
2656: print_debug('Deleted All MOLs');
2657: FOR c_rec in c_mmtt(l_item_id) LOOP