APPS.INV_PICK_RELEASE_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 118: UPDATE mtl_material_transactions_temp

114:
115:
116: PROCEDURE release_mo_tasks (p_header_id NUMBER) IS
117: BEGIN
118: UPDATE mtl_material_transactions_temp
119: SET wms_task_status = 1
120: WHERE move_order_header_id = p_header_id;
121: END;
122:

Line 2063: FROM mtl_material_transactions_temp

2059: , project_id
2060: , task_id
2061: , transfer_to_location
2062: , revision
2063: FROM mtl_material_transactions_temp
2064: WHERE move_order_line_id = p_mo_line_id
2065: AND pick_slip_number IS NULL;
2066:
2067: /*Bug 3229204:Adding variable to specify to be passed to process_prj_dynamic_locators*/

Line 2472: FROM mtl_material_transactions_temp

2468: INTO l_quantity_detailed
2469: ,l_quantity_detailed_conv
2470: ,l_sec_quantity_detailed
2471: ,l_num_detail_recs
2472: FROM mtl_material_transactions_temp
2473: WHERE move_order_line_id = p_mo_line_rec.line_id;
2474:
2475: IF (is_debug) THEN
2476: print_debug('l_quantity detailed is '|| l_quantity_detailed, 'Inv_Pick_Release_PVT.Process_Line');

Line 2762: FROM mtl_material_transactions_temp

2758:
2759: BEGIN
2760: SELECT NVL(SUM(ABS(primary_quantity)), 0)
2761: INTO l_reservation_detailed_qty
2762: FROM mtl_material_transactions_temp
2763: WHERE organization_id = p_mo_line_rec.organization_id
2764: AND reservation_id = l_demand_rsvs_ordered(l_res_ordered_index).reservation_id;
2765:
2766: IF l_reduce_rsv_qty > (l_demand_rsvs_ordered(l_res_ordered_index).primary_reservation_quantity - nvl(l_reservation_detailed_qty,0)) THEN

Line 2948: FROM mtl_material_transactions_temp

2944: SELECT NVL(SUM(ABS(primary_quantity)), 0)
2945: , NVL(SUM(ABS(secondary_transaction_quantity)), 0)
2946: INTO l_reservation_detailed_qty
2947: , l_rsv_detailed_qty2
2948: FROM mtl_material_transactions_temp
2949: WHERE organization_id = p_mo_line_rec.organization_id
2950: AND reservation_id = l_reservation_id;
2951: EXCEPTION
2952: WHEN NO_DATA_FOUND THEN

Line 3181: -- Assign the pick slip number to the record in MTL_MATERIAL_TRANSACTIONS_TEMP

3177: END IF;
3178: RAISE fnd_api.g_exc_unexpected_error;
3179: END IF;
3180: END IF ;
3181: -- Assign the pick slip number to the record in MTL_MATERIAL_TRANSACTIONS_TEMP
3182: UPDATE mtl_material_transactions_temp
3183: SET pick_slip_number = l_pick_slip_number
3184: , transaction_source_id = l_mso_header_id
3185: , trx_source_line_id = l_demand_info.oe_line_id

Line 3182: UPDATE mtl_material_transactions_temp

3178: RAISE fnd_api.g_exc_unexpected_error;
3179: END IF;
3180: END IF ;
3181: -- Assign the pick slip number to the record in MTL_MATERIAL_TRANSACTIONS_TEMP
3182: UPDATE mtl_material_transactions_temp
3183: SET pick_slip_number = l_pick_slip_number
3184: , transaction_source_id = l_mso_header_id
3185: , trx_source_line_id = l_demand_info.oe_line_id
3186: , demand_source_header_id = l_mso_header_id