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.WMS_TXNRSN_ACTIONS_PUB dependencies on MTL_TXN_REQUEST_LINES

Line 137: FROM mtl_txn_request_lines

133:
134: -- Get UOM from MO Line which is the same as transaction_uom in MMTT
135: SELECT uom_code
136: INTO l_trans_uom
137: FROM mtl_txn_request_lines
138: WHERE line_id = l_line_num;
139: IF (l_debug = 1) THEN
140: mdebug('uom_code '|| l_trans_uom);
141: END IF;

Line 156: UPDATE mtl_txn_request_lines

152:
153: IF (l_debug = 1) THEN
154: mdebug('before update mo line');
155: END IF;
156: UPDATE mtl_txn_request_lines
157: SET quantity_detailed = quantity_detailed-l_qty_diff_txn
158: WHERE line_id = l_line_num;
159:
160: IF (l_debug = 1) THEN

Line 387: l_test mtl_txn_request_lines%ROWTYPE;

383: l_order_count NUMBER := 1; /* total number of lines */
384:
385: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
386: l_trolin_rec INV_Move_Order_PUB.trolin_rec_type;
387: l_test mtl_txn_request_lines%ROWTYPE;
388:
389: l_det_cnt NUMBER;
390: l_next_task_id NUMBER;
391: l_print_mode VARCHAR2(1):='E';

Line 1193: from mtl_txn_request_lines

1189: ,nvl(quantity_delivered,0)
1190: into l_old_quantity_detailed
1191: ,l_line_status
1192: ,l_quantity_delivered
1193: from mtl_txn_request_lines
1194: where line_id = l_line_num;
1195:
1196: mdebug('l_quantity_delivered:'||l_quantity_delivered);
1197: mdebug('l_line_status:'||l_line_status);

Line 1243: UPDATE mtl_txn_request_lines

1239: -- Bug 3278170 fix is below patchset 'J' level
1240: IF (inv_control.g_current_release_level >= inv_release.g_j_release_level)
1241: THEN
1242: -- For patchset 'J'
1243: UPDATE mtl_txn_request_lines
1244: SET quantity_detailed = quantity_detailed - l_mol_delta_qty
1245: , last_update_date = SYSDATE
1246: , last_updated_by = l_user_id
1247: WHERE organization_id = l_organization_id

Line 1253: UPDATE mtl_txn_request_lines

1249: mdebug('In J patchset update move order line');
1250:
1251: ELSE
1252: -- fix for bug 3278170
1253: UPDATE mtl_txn_request_lines
1254: SET quantity_detailed = (nvl(quantity_detailed,0) -nvl(l_quantity_delivered,0)) - l_mol_delta_qty --bug3278170
1255: , last_update_date = SYSDATE
1256: , last_updated_by = l_user_id
1257: , quantity_delivered = 0 --bug3278170

Line 1307: from mtl_txn_request_lines

1303: select quantity_detailed,
1304: to_account_id --BUG#3048061
1305: into l_old_quantity_detailed,
1306: l_to_account_id --BUG#3048061
1307: from mtl_txn_request_lines
1308: where line_id = l_line_num;
1309:
1310: mdebug('after update mol, the quantity_detailed :' || l_old_quantity_detailed);
1311:

Line 1358: update mtl_txn_request_lines

1354: mdebug('After calling pick release: number_of_rows:'|| l_num_of_rows);
1355: mdebug(' v_transaction_temp_id: '|| v_transaction_temp_id);
1356:
1357: if (l_move_order_type <> 3 ) then
1358: update mtl_txn_request_lines
1359: set quantity_detailed = l_detailed_qty + l_quantity_delivered
1360: where line_id = l_line_num
1361: and organization_id = l_organization_id;
1362:

Line 1365: -- from to_account_id of mtl_txn_request_lines

1361: and organization_id = l_organization_id;
1362:
1363: -- Bug#3048061
1364: -- Update the distribution_account_id of MMTT
1365: -- from to_account_id of mtl_txn_request_lines
1366: -- Since, MOs allocated using MO Pick Slip Report too,
1367: -- along with manually allocated MO will populate
1368: -- the distribution_account_id of MMTT.
1369:

Line 1387: UPDATE mtl_txn_request_lines

1383: INTO l_new_mmtt_qty
1384: FROM mtl_material_transactions_temp
1385: WHERE move_order_line_id = l_line_num;
1386:
1387: UPDATE mtl_txn_request_lines
1388: SET quantity = nvl(l_new_mmtt_qty,0) + l_quantity_delivered ,
1389: quantity_detailed = nvl(l_new_mmtt_qty,0) + l_quantity_delivered ,
1390: quantity_delivered = l_quantity_delivered
1391: WHERE organization_id = l_organization_id

Line 1813: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl

1809: , mtrl.reference_id
1810: , mtrl.quantity
1811: , mtrl.uom_code
1812: , mtrl.quantity_delivered
1813: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl
1814: WHERE mtrl.line_id = l_mo_line_id
1815: AND mtrh.header_id = mtrl.header_id;
1816:
1817: CURSOR c_get_other_mmtt IS

Line 2117: UPDATE mtl_txn_request_lines

2113: l_progress := '300';
2114: IF (l_debug = 1) THEN
2115: mdebug ('l_progress: ' || l_progress );
2116: END IF;
2117: UPDATE mtl_txn_request_lines
2118: SET quantity_detailed = quantity_detailed - l_txn_qty
2119: , last_update_date = SYSDATE
2120: , last_updated_by = p_user_id
2121: WHERE line_id = l_mo_line_id;

Line 2163: UPDATE mtl_txn_request_lines

2159:
2160: ELSIF l_mo_type IN (INV_GLOBALS.G_MOVE_ORDER_REQUISITION, INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT) THEN
2161: l_progress := '370';
2162: IF (l_debug = 1) THEN mdebug ('l_progress: ' || l_progress ); END IF;
2163: UPDATE mtl_txn_request_lines
2164: SET quantity_detailed = quantity_delivered
2165: , last_update_date = SYSDATE
2166: , last_updated_by = p_user_id
2167: WHERE line_id = l_mo_line_id;

Line 2212: UPDATE mtl_txn_request_lines

2208:
2209: l_progress := '380';
2210: IF (l_debug = 1) THEN mdebug ('l_progress: ' || l_progress ); END IF;
2211: IF (l_wf <= 0) or (p_qty_rsn_id <= 0) then
2212: UPDATE mtl_txn_request_lines
2213: SET quantity_detailed = quantity_delivered
2214: , last_update_date = SYSDATE
2215: , last_updated_by = p_user_id
2216: WHERE line_id = l_mo_line_id;