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:
122: -- 8249710

Line 124: UPDATE mtl_material_transactions_temp

120: WHERE move_order_header_id = p_header_id;
121:
122: -- 8249710
123: -- the following query updates the wms_task_status of parent records if exist
124: UPDATE mtl_material_transactions_temp
125: SET wms_task_status = 1
126: WHERE transaction_temp_id IN
127: ( SELECT DISTINCT mmtt2.parent_line_id
128: FROM mtl_material_transactions_temp mmtt2

Line 128: FROM mtl_material_transactions_temp mmtt2

124: UPDATE mtl_material_transactions_temp
125: SET wms_task_status = 1
126: WHERE transaction_temp_id IN
127: ( SELECT DISTINCT mmtt2.parent_line_id
128: FROM mtl_material_transactions_temp mmtt2
129: WHERE move_order_header_id = p_header_id
130: AND parent_line_id IS NOT NULL
131: );
132:

Line 2370: FROM mtl_material_transactions_temp

2366: , project_id
2367: , task_id
2368: , transfer_to_location
2369: , revision
2370: FROM mtl_material_transactions_temp
2371: WHERE move_order_line_id = p_mo_line_id
2372: AND pick_slip_number IS NULL;
2373:
2374: /*Bug 3229204:Adding variable to specify to be passed to process_prj_dynamic_locators*/

Line 2802: FROM mtl_material_transactions_temp

2798: INTO l_quantity_detailed
2799: ,l_quantity_detailed_conv
2800: ,l_sec_quantity_detailed
2801: ,l_num_detail_recs
2802: FROM mtl_material_transactions_temp
2803: WHERE move_order_line_id = p_mo_line_rec.line_id;
2804: -- Bug 6989438
2805: IF (is_debug) THEN
2806: print_debug('l_quantity detailed is '|| l_quantity_detailed, 'Inv_Pick_Release_PVT.Process_Line');

Line 3179: FROM mtl_material_transactions_temp

3175: SELECT NVL(SUM(ABS(primary_quantity)), 0),
3176: NVL(SUM(ABS(secondary_transaction_quantity)), 0) -- Pushkar
3177: INTO l_reservation_detailed_qty,
3178: l_rsv_detailed_qty2
3179: FROM mtl_material_transactions_temp
3180: WHERE organization_id = p_mo_line_rec.organization_id
3181: AND reservation_id = l_demand_rsvs_ordered(l_res_ordered_index).reservation_id;
3182:
3183: IF l_reduce_rsv_qty > (l_demand_rsvs_ordered(l_res_ordered_index).primary_reservation_quantity - nvl(l_reservation_detailed_qty,0)) THEN

Line 3399: FROM mtl_material_transactions_temp

3395: SELECT NVL(SUM(ABS(primary_quantity)), 0)
3396: , NVL(SUM(ABS(secondary_transaction_quantity)), 0)
3397: INTO l_reservation_detailed_qty
3398: , l_rsv_detailed_qty2
3399: FROM mtl_material_transactions_temp
3400: WHERE organization_id = p_mo_line_rec.organization_id
3401: AND reservation_id = l_reservation_id;
3402: EXCEPTION
3403: WHEN NO_DATA_FOUND THEN

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

3663: END IF;
3664: RAISE fnd_api.g_exc_unexpected_error;
3665: END IF;
3666: END IF ;
3667: -- Assign the pick slip number to the record in MTL_MATERIAL_TRANSACTIONS_TEMP
3668: UPDATE mtl_material_transactions_temp
3669: SET pick_slip_number = l_pick_slip_number
3670: , transaction_source_id = l_mso_header_id
3671: , trx_source_line_id = l_demand_info.oe_line_id

Line 3668: UPDATE mtl_material_transactions_temp

3664: RAISE fnd_api.g_exc_unexpected_error;
3665: END IF;
3666: END IF ;
3667: -- Assign the pick slip number to the record in MTL_MATERIAL_TRANSACTIONS_TEMP
3668: UPDATE mtl_material_transactions_temp
3669: SET pick_slip_number = l_pick_slip_number
3670: , transaction_source_id = l_mso_header_id
3671: , trx_source_line_id = l_demand_info.oe_line_id
3672: , demand_source_header_id = l_mso_header_id