[Home] [Help]
396: -- following cursors added for patchset J bulk picking ---------------
397:
398: CURSOR c11_bulk_all_fast(p_organization_id NUMBER) IS
399: SELECT mmtt.* FROM
400: mtl_material_transactions_temp mmtt,mtl_allocations_gtmp mag
401: WHERE mmtt.wms_task_status = 8 -- unreleased
402: And nvl(mmtt.lock_flag,'$') <> 'Y' --Bug#8546026
403: And mmtt.cartonization_id IS null -- not cartonized
404: And mmtt.organization_id = p_organization_id
418: for update of mmtt.transaction_temp_id; -- to lock the records
419:
420: CURSOR c11_bulk_only_sub_item_fast(p_organization_id NUMBER) IS
421: SELECT mmtt.* FROM
422: mtl_material_transactions_temp mmtt,mtl_allocations_gtmp mag
423: WHERE mmtt.wms_task_status = 8 -- unreleased
424: And nvl(mmtt.lock_flag,'$') <> 'Y' --Bug#8546026
425: And mmtt.cartonization_id IS null -- not cartonized
426: And mmtt.organization_id = p_organization_id
638: if (g_trace_on = 1) then log_event(' organization_id '||l_organization_id); end if;
639:
640: -- make sure the temp table is empty, the following is to improve performance
641: -- when move order number or creation dates are entered
642: delete mtl_allocations_gtmp;
643: l_fast_possible := false;
644: if p_input_for_bulk.start_mo_request_number is not null
645: or p_input_for_bulk.start_release_date is not null then -- select the move_order_headers
646: l_fast_possible := true;
643: l_fast_possible := false;
644: if p_input_for_bulk.start_mo_request_number is not null
645: or p_input_for_bulk.start_release_date is not null then -- select the move_order_headers
646: l_fast_possible := true;
647: insert into mtl_allocations_gtmp
648: (move_order_header_id)
649: select moh.header_id
650: from mtl_txn_request_headers moh,
651: wsh_pick_grouping_rules spg