APPS.INV_WIP_PICKING_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1037: FROM mtl_material_transactions_temp

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
1037: FROM mtl_material_transactions_temp
1038: WHERE move_order_line_id = l_mo_line.line_id;
1039:
1040: -- If the total allocated quantity is less than the requested
1041: -- quantity update the move order line to change the

Line 1519: FROM mtl_material_transactions_temp

1515:
1516: -- Update the detailed quantity (and if possible, the sourcing information)
1517: SELECT NVL(SUM(primary_quantity), 0), COUNT(*)
1518: INTO l_quantity_detailed, l_num_detail_recs
1519: FROM mtl_material_transactions_temp
1520: WHERE move_order_line_id = p_mo_line_rec.line_id;
1521:
1522: IF (l_debug = 1) THEN
1523: print_debug('Qty detailed = '|| l_quantity_detailed || ' : Num of Details = ' || l_num_detail_recs, 'PROCESS_LINE');

Line 1665: UPDATE mtl_material_transactions_temp mmtt

1661: x_return_status := fnd_api.g_ret_sts_error;
1662: RETURN;
1663: END IF;
1664:
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

Line 1695: FROM mtl_material_transactions_temp

1691: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1692:
1693: CURSOR c_mmtt IS
1694: SELECT transaction_temp_id, revision, subinventory_code, locator_id, transfer_subinventory, transfer_to_location, pick_slip_number
1695: FROM mtl_material_transactions_temp
1696: WHERE move_order_line_id = p_mo_line_rec.line_id;
1697: BEGIN
1698: get_wip_attributes(
1699: x_return_status => x_return_status

Line 1770: UPDATE mtl_material_transactions_temp

1766: l_pick_slip_number := c_mmtt_rec.pick_slip_number;
1767: END IF;
1768:
1769: IF p_mo_line_rec.transaction_type_id = INV_GLOBALS.G_TYPE_XFER_ORDER_WIP_ISSUE THEN
1770: UPDATE mtl_material_transactions_temp
1771: SET transaction_source_id = p_mo_line_rec.txn_source_id
1772: , trx_source_line_id = p_mo_line_rec.txn_source_line_id
1773: , demand_source_header_id = p_mo_line_rec.txn_source_id
1774: , demand_source_line = p_mo_line_rec.txn_source_line_id

Line 1791: UPDATE mtl_material_transactions_temp

1787: , required_flag = '1'
1788: , pick_slip_number = l_pick_slip_number
1789: WHERE transaction_temp_id = c_mmtt_rec.transaction_temp_id;
1790: ELSIF p_mo_line_rec.transaction_type_id = INV_GLOBALS.G_TYPE_XFER_ORDER_REPL_SUBXFR THEN
1791: UPDATE mtl_material_transactions_temp
1792: SET transaction_source_id = p_mo_line_rec.txn_source_id
1793: , trx_source_line_id = p_mo_line_rec.txn_source_line_id
1794: , demand_source_header_id = p_mo_line_rec.txn_source_id
1795: , demand_source_line = p_mo_line_rec.txn_source_line_id