[Home] [Help]
497: -- following cursors added for patchset J bulk picking ---------------
498:
499: CURSOR c11_bulk_all_fast(p_organization_id NUMBER) IS
500: SELECT mmtt.* FROM
501: mtl_material_transactions_temp mmtt,mtl_allocations_gtmp mag
502: WHERE mmtt.wms_task_status = 8 -- unreleased
503: And mmtt.cartonization_id IS null -- not cartonized
504: And mmtt.organization_id = p_organization_id
505: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation
518: for update of mmtt.transaction_temp_id; -- to lock the records
519:
520: CURSOR c11_bulk_only_sub_item_fast(p_organization_id NUMBER) IS
521: SELECT mmtt.* FROM
522: mtl_material_transactions_temp mmtt,mtl_allocations_gtmp mag
523: WHERE mmtt.wms_task_status = 8 -- unreleased
524: And mmtt.cartonization_id IS null -- not cartonized
525: And mmtt.organization_id = p_organization_id
526: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation
733: if (g_trace_on = 1) then log_event(' organization_id '||l_organization_id); end if;
734:
735: -- make sure the temp table is empty, the following is to improve performance
736: -- when move order number or creation dates are entered
737: delete mtl_allocations_gtmp;
738: l_fast_possible := false;
739: if p_input_for_bulk.start_mo_request_number is not null
740: or p_input_for_bulk.start_release_date is not null then -- select the move_order_headers
741: l_fast_possible := true;
738: l_fast_possible := false;
739: if p_input_for_bulk.start_mo_request_number is not null
740: or p_input_for_bulk.start_release_date is not null then -- select the move_order_headers
741: l_fast_possible := true;
742: insert into mtl_allocations_gtmp
743: (move_order_header_id)
744: select moh.header_id
745: from mtl_txn_request_headers moh,
746: wsh_pick_grouping_rules spg