APPS.WMS_CARTNZN_PUB dependencies on WSH_PICK_GROUPING_RULES

Line 555: wsh_pick_grouping_rules spg

551:
552: CURSOR c11_bulk_all(p_organization_id NUMBER) IS
553: SELECT mmtt.* FROM
554: mtl_material_transactions_temp mmtt,mtl_txn_request_headers moh,
555: wsh_pick_grouping_rules spg
556: WHERE mmtt.wms_task_status = 8 -- unreleased
557: And mmtt.cartonization_id IS null -- not cartonized
558: And mmtt.organization_id = p_organization_id
559: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation

Line 584: wsh_pick_grouping_rules spg

580:
581: CURSOR c11_bulk_only_sub_item(p_organization_id NUMBER) IS
582: SELECT mmtt.* FROM
583: mtl_material_transactions_temp mmtt,mtl_txn_request_headers moh,
584: wsh_pick_grouping_rules spg
585: WHERE mmtt.wms_task_status = 8 -- unreleased
586: And mmtt.cartonization_id IS null -- not cartonized
587: And mmtt.organization_id = p_organization_id
588: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation

Line 625: wsh_pick_grouping_rules spg

621: CURSOR c11_bulk_trip(p_organization_id NUMBER) IS
622: select mmtt.*
623: from wsh_delivery_legs wdl,wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
624: wsh_trip_stops wts, mtl_material_transactions_temp mmtt,mtl_txn_request_headers moh,
625: wsh_pick_grouping_rules spg
626: where wts.trip_id = p_input_for_bulk.trip_id
627: and wdl.pick_up_stop_id = wts.stop_id
628: and wdl.delivery_id = wda.delivery_id
629: and wda.delivery_detail_id = wdd.delivery_detail_id

Line 661: wsh_pick_grouping_rules spg

657: CURSOR c11_bulk_trip_sub_item(p_organization_id NUMBER) IS
658: select mmtt.*
659: from wsh_delivery_legs wdl,wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
660: wsh_trip_stops wts, mtl_material_transactions_temp mmtt,mtl_txn_request_headers moh,
661: wsh_pick_grouping_rules spg
662: where wts.trip_id = p_input_for_bulk.trip_id
663: and wdl.pick_up_stop_id = wts.stop_id
664: and wdl.delivery_id = wda.delivery_id
665: and wda.delivery_detail_id = wdd.delivery_detail_id

Line 746: wsh_pick_grouping_rules spg

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