APPS.INV_WIP_PICKING_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1032: FROM mtl_material_transactions_temp

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
1032: FROM mtl_material_transactions_temp
1033: WHERE move_order_line_id = l_mo_line.line_id;
1034:
1035: -- If the total allocated quantity is less than the requested
1036: -- quantity update the move order line to change the

Line 1473: FROM mtl_material_transactions_temp

1469:
1470: -- Update the detailed quantity (and if possible, the sourcing information)
1471: SELECT NVL(SUM(primary_quantity), 0), COUNT(*)
1472: INTO l_quantity_detailed, l_num_detail_recs
1473: FROM mtl_material_transactions_temp
1474: WHERE move_order_line_id = p_mo_line_rec.line_id;
1475:
1476: IF (l_debug = 1) THEN
1477: print_debug('Qty detailed = '|| l_quantity_detailed || ' : Num of Details = ' || l_num_detail_recs, 'PROCESS_LINE');

Line 1617: UPDATE mtl_material_transactions_temp mmtt

1613: x_return_status := fnd_api.g_ret_sts_error;
1614: RETURN;
1615: END IF;
1616:
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

Line 1647: FROM mtl_material_transactions_temp

1643: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1644:
1645: CURSOR c_mmtt IS
1646: SELECT transaction_temp_id, revision, subinventory_code, locator_id, transfer_subinventory, transfer_to_location, pick_slip_number
1647: FROM mtl_material_transactions_temp
1648: WHERE move_order_line_id = p_mo_line_rec.line_id;
1649: BEGIN
1650: get_wip_attributes(
1651: x_return_status => x_return_status

Line 1722: UPDATE mtl_material_transactions_temp

1718: l_pick_slip_number := c_mmtt_rec.pick_slip_number;
1719: END IF;
1720:
1721: IF p_mo_line_rec.transaction_type_id = INV_GLOBALS.G_TYPE_XFER_ORDER_WIP_ISSUE THEN
1722: UPDATE mtl_material_transactions_temp
1723: SET transaction_source_id = p_mo_line_rec.txn_source_id
1724: , trx_source_line_id = p_mo_line_rec.txn_source_line_id
1725: , demand_source_header_id = p_mo_line_rec.txn_source_id
1726: , demand_source_line = p_mo_line_rec.txn_source_line_id

Line 1743: UPDATE mtl_material_transactions_temp

1739: , required_flag = '1'
1740: , pick_slip_number = l_pick_slip_number
1741: WHERE transaction_temp_id = c_mmtt_rec.transaction_temp_id;
1742: ELSIF p_mo_line_rec.transaction_type_id = INV_GLOBALS.G_TYPE_XFER_ORDER_REPL_SUBXFR THEN
1743: UPDATE mtl_material_transactions_temp
1744: SET transaction_source_id = p_mo_line_rec.txn_source_id
1745: , trx_source_line_id = p_mo_line_rec.txn_source_line_id
1746: , demand_source_header_id = p_mo_line_rec.txn_source_id
1747: , demand_source_line = p_mo_line_rec.txn_source_line_id