APPS.INV_WIP_PICKING_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 1032: FROM mtl_txn_request_lines

1028: g_mo_line_stat_tbl(l_mo_line.line_id) := l_api_return_status;
1029:
1030: SELECT quantity, NVL(quantity_detailed,0), line_status -- added for bug 9895550
1031: INTO l_quantity, l_detail_quantity, l_line_status -- added for bug 9895550
1032: FROM mtl_txn_request_lines
1033: WHERE line_id = l_mo_line.line_id;
1034:
1035: SELECT NVL(SUM(transaction_quantity), 0), NVL(SUM(primary_quantity), 0)
1036: INTO l_transaction_quantity, l_primary_quantity

Line 1100: UPDATE mtl_txn_request_lines

1096: l_qtree_backup_tbl.DELETE(l_mo_line.inventory_item_id);
1097: END IF;
1098:
1099: -- close the move order line
1100: UPDATE mtl_txn_request_lines
1101: SET quantity = 0, quantity_detailed = 0, line_status = 5 ,status_date =sysdate --BUG 6932648
1102: WHERE line_id = l_mo_line.line_id;
1103:
1104: -- Exit if there are no more move order lines to detail

Line 1139: UPDATE mtl_txn_request_lines

1135: IF (l_debug = 1) THEN
1136: print_debug('Finished rolling back all lines in shipset', 'PICK_RELEASE');
1137: END IF;
1138: ELSE
1139: UPDATE mtl_txn_request_lines
1140: SET quantity = l_transaction_quantity,
1141: primary_quantity = l_primary_quantity -- added for bug 9895550
1142: WHERE line_id = l_mo_line.line_id;
1143:

Line 1164: UPDATE mtl_txn_request_lines

1160: END IF;
1161:
1162:
1163: IF (l_transaction_quantity = 0) THEN
1164: UPDATE mtl_txn_request_lines
1165: SET line_status = 5 ,status_date =sysdate --BUG 6932648
1166: WHERE line_id = l_mo_line.line_id;
1167: END IF;
1168: END IF; -- cur ship set id

Line 1225: DELETE FROM mtl_txn_request_lines mtrl

1221: IF (l_debug = 1) THEN
1222: print_debug('Deleting closed MOLs..','PICK_RELEASE');
1223: END IF;
1224: FORALL ii IN l_mol_id_tbl.FIRST..l_mol_id_tbl.LAST
1225: DELETE FROM mtl_txn_request_lines mtrl
1226: WHERE line_status = 5
1227: AND line_id = l_mol_id_tbl(ii);
1228: EXCEPTION
1229: WHEN OTHERS THEN

Line 1498: FROM mtl_txn_request_lines_v

1494:
1495: BEGIN
1496: SELECT request_number
1497: INTO l_request_number
1498: FROM mtl_txn_request_lines_v
1499: WHERE line_id = p_mo_line_rec.line_id;
1500: EXCEPTION
1501: WHEN NO_DATA_FOUND THEN
1502: RAISE fnd_api.g_exc_unexpected_error;

Line 1649: UPDATE mtl_txn_request_lines mol

1645: print_debug('p_move_order_line_id => '|| p_move_order_line_id, 'update_mol_for_wip');
1646: print_debug('p_op_seq_num => '|| p_op_seq_num, 'update_mol_for_wip');
1647: END IF;
1648:
1649: UPDATE mtl_txn_request_lines mol
1650: SET mol.txn_source_line_id = p_op_seq_num
1651: WHERE mol.line_id = p_move_order_line_id
1652: AND EXISTS( SELECT ''
1653: FROM mtl_txn_request_headers moh

Line 1669: FROM mtl_txn_request_headers moh, mtl_txn_request_lines mol

1665: UPDATE mtl_material_transactions_temp mmtt
1666: SET mmtt.trx_source_line_id = p_op_seq_num
1667: WHERE mmtt.move_order_line_id = p_move_order_line_id
1668: AND EXISTS( SELECT ''
1669: FROM mtl_txn_request_headers moh, mtl_txn_request_lines mol
1670: WHERE mol.line_id = mmtt.move_order_line_id
1671: AND mol.header_id = moh.header_id
1672: AND move_order_type = 5);
1673: EXCEPTION