APPS.INV_WIP_PICKING_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 1027: FROM mtl_txn_request_lines

1023: g_mo_line_stat_tbl(l_mo_line.line_id) := l_api_return_status;
1024:
1025: SELECT quantity, line_status
1026: INTO l_quantity, l_line_status
1027: FROM mtl_txn_request_lines
1028: WHERE line_id = l_mo_line.line_id;
1029:
1030: SELECT NVL(SUM(transaction_quantity), 0), NVL(SUM(primary_quantity), 0)
1031: INTO l_transaction_quantity, l_primary_quantity

Line 1090: UPDATE mtl_txn_request_lines

1086: l_qtree_backup_tbl.DELETE(l_mo_line.inventory_item_id);
1087: END IF;
1088:
1089: -- close the move order line
1090: UPDATE mtl_txn_request_lines
1091: SET quantity = 0, quantity_detailed = 0, line_status = 5
1092: WHERE line_id = l_mo_line.line_id;
1093:
1094: -- Exit if there are no more move order lines to detail

Line 1129: UPDATE mtl_txn_request_lines

1125: IF (l_debug = 1) THEN
1126: print_debug('Finished rolling back all lines in shipset', 'PICK_RELEASE');
1127: END IF;
1128: ELSE
1129: UPDATE mtl_txn_request_lines
1130: SET quantity = l_transaction_quantity
1131: WHERE line_id = l_mo_line.line_id;
1132:
1133: IF (l_transaction_quantity = 0) THEN

Line 1134: UPDATE mtl_txn_request_lines

1130: SET quantity = l_transaction_quantity
1131: WHERE line_id = l_mo_line.line_id;
1132:
1133: IF (l_transaction_quantity = 0) THEN
1134: UPDATE mtl_txn_request_lines
1135: SET line_status = 5
1136: WHERE line_id = l_mo_line.line_id;
1137: END IF;
1138: END IF; -- cur ship set id

Line 1195: DELETE FROM mtl_txn_request_lines mtrl

1191: IF (l_debug = 1) THEN
1192: print_debug('Deleting closed MOLs..','PICK_RELEASE');
1193: END IF;
1194: FORALL ii IN l_mol_id_tbl.FIRST..l_mol_id_tbl.LAST
1195: DELETE FROM mtl_txn_request_lines mtrl
1196: WHERE line_status = 5
1197: AND line_id = l_mol_id_tbl(ii);
1198: EXCEPTION
1199: WHEN OTHERS THEN

Line 1452: FROM mtl_txn_request_lines_v

1448:
1449: BEGIN
1450: SELECT request_number
1451: INTO l_request_number
1452: FROM mtl_txn_request_lines_v
1453: WHERE line_id = p_mo_line_rec.line_id;
1454: EXCEPTION
1455: WHEN NO_DATA_FOUND THEN
1456: RAISE fnd_api.g_exc_unexpected_error;

Line 1601: UPDATE mtl_txn_request_lines mol

1597: print_debug('p_move_order_line_id => '|| p_move_order_line_id, 'update_mol_for_wip');
1598: print_debug('p_op_seq_num => '|| p_op_seq_num, 'update_mol_for_wip');
1599: END IF;
1600:
1601: UPDATE mtl_txn_request_lines mol
1602: SET mol.txn_source_line_id = p_op_seq_num
1603: WHERE mol.line_id = p_move_order_line_id
1604: AND EXISTS( SELECT ''
1605: FROM mtl_txn_request_headers moh

Line 1621: FROM mtl_txn_request_headers moh, mtl_txn_request_lines mol

1617: UPDATE mtl_material_transactions_temp mmtt
1618: SET mmtt.trx_source_line_id = p_op_seq_num
1619: WHERE mmtt.move_order_line_id = p_move_order_line_id
1620: AND EXISTS( SELECT ''
1621: FROM mtl_txn_request_headers moh, mtl_txn_request_lines mol
1622: WHERE mol.line_id = mmtt.move_order_line_id
1623: AND mol.header_id = moh.header_id
1624: AND move_order_type = 5);
1625: EXCEPTION