APPS.GME_PICKING_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 732: FROM mtl_material_transactions_temp

728: CURSOR cur_detailed_qty (v_move_order_line_id NUMBER)
729: IS
730: SELECT SUM (transaction_quantity) qty_detailed
731: ,SUM (secondary_transaction_quantity) sec_qty_detailed
732: FROM mtl_material_transactions_temp
733: WHERE move_order_line_id = v_move_order_line_id;
734:
735: CURSOR cur_mmtt (v_move_order_line_id NUMBER)
736: IS

Line 738: FROM mtl_material_transactions_temp

734:
735: CURSOR cur_mmtt (v_move_order_line_id NUMBER)
736: IS
737: SELECT *
738: FROM mtl_material_transactions_temp
739: WHERE move_order_line_id = v_move_order_line_id;
740:
741: l_count NUMBER := 0;
742: l_msg_count NUMBER;

Line 959: FROM mtl_material_transactions_temp

955: SELECT NVL(SUM(ABS(primary_quantity)), 0)
956: , NVL(SUM(ABS(secondary_transaction_quantity)), 0)
957: INTO l_reservation_detailed_qty
958: , l_rsv_detailed_qty2
959: FROM mtl_material_transactions_temp
960: WHERE organization_id = p_mo_line_rec.organization_id
961: AND reservation_id = l_reservation_id;
962: EXCEPTION
963: WHEN NO_DATA_FOUND THEN

Line 1142: UPDATE mtl_material_transactions_temp

1138: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1139: RAISE get_pick_slip_err;
1140: END IF;
1141:
1142: UPDATE mtl_material_transactions_temp
1143: SET pick_slip_number = l_pick_slip_number,
1144: wip_entity_type = gme_common_pvt.g_wip_entity_type_batch
1145: WHERE transaction_temp_id = get_mmtt.transaction_temp_id;
1146: ELSE

Line 1147: UPDATE mtl_material_transactions_temp

1143: SET pick_slip_number = l_pick_slip_number,
1144: wip_entity_type = gme_common_pvt.g_wip_entity_type_batch
1145: WHERE transaction_temp_id = get_mmtt.transaction_temp_id;
1146: ELSE
1147: UPDATE mtl_material_transactions_temp
1148: SET wip_entity_type = gme_common_pvt.g_wip_entity_type_batch
1149: WHERE transaction_temp_id = get_mmtt.transaction_temp_id;
1150: END IF;
1151: END LOOP;