APPS.GME_PICKING_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 566: FROM mtl_material_transactions_temp

562: CURSOR cur_detailed_qty (v_move_order_line_id NUMBER)
563: IS
564: SELECT SUM (transaction_quantity) qty_detailed
565: ,SUM (secondary_transaction_quantity) sec_qty_detailed
566: FROM mtl_material_transactions_temp
567: WHERE move_order_line_id = v_move_order_line_id;
568:
569: CURSOR cur_mmtt (v_move_order_line_id NUMBER)
570: IS

Line 572: FROM mtl_material_transactions_temp

568:
569: CURSOR cur_mmtt (v_move_order_line_id NUMBER)
570: IS
571: SELECT *
572: FROM mtl_material_transactions_temp
573: WHERE move_order_line_id = v_move_order_line_id;
574:
575: l_count NUMBER := 0;
576: l_msg_count NUMBER;

Line 840: UPDATE mtl_material_transactions_temp

836: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
837: RAISE get_pick_slip_err;
838: END IF;
839:
840: UPDATE mtl_material_transactions_temp
841: SET pick_slip_number = l_pick_slip_number,
842: wip_entity_type = gme_common_pvt.g_wip_entity_type_batch
843: WHERE transaction_temp_id = get_mmtt.transaction_temp_id;
844: ELSE

Line 845: UPDATE mtl_material_transactions_temp

841: SET pick_slip_number = l_pick_slip_number,
842: wip_entity_type = gme_common_pvt.g_wip_entity_type_batch
843: WHERE transaction_temp_id = get_mmtt.transaction_temp_id;
844: ELSE
845: UPDATE mtl_material_transactions_temp
846: SET wip_entity_type = gme_common_pvt.g_wip_entity_type_batch
847: WHERE transaction_temp_id = get_mmtt.transaction_temp_id;
848: END IF;
849: END LOOP;