APPS.WMS_CARTNZN_PUB dependencies on WSH_PICK_GROUPING_RULES

Line 456: wsh_pick_grouping_rules spg

452:
453: CURSOR c11_bulk_all(p_organization_id NUMBER) IS
454: SELECT mmtt.* FROM
455: mtl_material_transactions_temp mmtt,mtl_txn_request_headers moh,
456: wsh_pick_grouping_rules spg
457: WHERE mmtt.wms_task_status = 8 -- unreleased
458: And nvl(mmtt.lock_flag,'$') <> 'Y' --Bug#8546026
459: And mmtt.cartonization_id IS null -- not cartonized
460: And mmtt.organization_id = p_organization_id

Line 486: wsh_pick_grouping_rules spg

482:
483: CURSOR c11_bulk_only_sub_item(p_organization_id NUMBER) IS
484: SELECT mmtt.* FROM
485: mtl_material_transactions_temp mmtt,mtl_txn_request_headers moh,
486: wsh_pick_grouping_rules spg
487: WHERE mmtt.wms_task_status = 8 -- unreleased
488: And nvl(mmtt.lock_flag,'$') <> 'Y' --Bug#8546026
489: And mmtt.cartonization_id IS null -- not cartonized
490: And mmtt.organization_id = p_organization_id

Line 528: wsh_pick_grouping_rules spg

524: CURSOR c11_bulk_trip(p_organization_id NUMBER) IS
525: select mmtt.*
526: from wsh_delivery_legs wdl,wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
527: wsh_trip_stops wts, mtl_material_transactions_temp mmtt,mtl_txn_request_headers moh,
528: wsh_pick_grouping_rules spg
529: where wts.trip_id = p_input_for_bulk.trip_id
530: and wdl.pick_up_stop_id = wts.stop_id
531: and wdl.delivery_id = wda.delivery_id
532: and wda.delivery_detail_id = wdd.delivery_detail_id

Line 565: wsh_pick_grouping_rules spg

561: CURSOR c11_bulk_trip_sub_item(p_organization_id NUMBER) IS
562: select mmtt.*
563: from wsh_delivery_legs wdl,wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
564: wsh_trip_stops wts, mtl_material_transactions_temp mmtt,mtl_txn_request_headers moh,
565: wsh_pick_grouping_rules spg
566: where wts.trip_id = p_input_for_bulk.trip_id
567: and wdl.pick_up_stop_id = wts.stop_id
568: and wdl.delivery_id = wda.delivery_id
569: and wda.delivery_detail_id = wdd.delivery_detail_id

Line 651: wsh_pick_grouping_rules spg

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
652: where spg.pick_grouping_rule_id = moh.grouping_rule_id
653: AND spg.pick_method <>WMS_GLOBALS.PICK_METHOD_ORDER -- not order pciking
654: AND moh.move_order_type = INV_GLOBALS.g_move_order_pick_wave -- pick wave move order only
655: AND moh.request_number between nvl(p_input_for_bulk.start_mo_request_number,moh.request_number) and