APPS.WMS_TASK_DISPATCH_ENGINE dependencies on WSH_PICK_GROUPING_RULES

Line 11600: FROM mtl_txn_request_headers moh, wsh_pick_grouping_rules spg

11596: AND mol.header_id = p_move_order_header_id
11597: AND mmtt.wms_task_type NOT IN(5, 6)
11598: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation
11599: AND( EXISTS(SELECT 1
11600: FROM mtl_txn_request_headers moh, wsh_pick_grouping_rules spg
11601: WHERE spg.pick_grouping_rule_id = moh.grouping_rule_id
11602: AND spg.pick_method = '4'
11603: AND moh.header_id = mol.header_id)
11604: OR EXISTS(SELECT 1

Line 11700: FROM mtl_txn_request_headers moh, wsh_pick_grouping_rules spg

11696: AND mol.header_id = p_move_order_header_id
11697: AND mmtt.wms_task_type NOT IN(5, 6)
11698: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation
11699: AND( EXISTS(SELECT 1
11700: FROM mtl_txn_request_headers moh, wsh_pick_grouping_rules spg
11701: WHERE spg.pick_grouping_rule_id = moh.grouping_rule_id
11702: AND spg.pick_method = '4'
11703: AND moh.header_id = mol.header_id)
11704: OR EXISTS(SELECT 1

Line 12455: From WSH_PICK_GROUPING_RULES

12451: END IF;
12452:
12453: Select DELIVERY_FLAG
12454: Into l_delivery_flag
12455: From WSH_PICK_GROUPING_RULES
12456: Where pick_method=WMS_GLOBALS.PICK_METHOD_BULK
12457: and user_defined_flag = 'N' -- bulk picking default rule
12458: and rownum <2; -- in case of psudo translation, multiple records are inserted for the seeded rule
12459:

Line 12463: FROM wsh_pick_grouping_rules spg

12459:
12460: -- check to see if the picking methodology is bulk picking disabled (including order picking)---
12461: SELECT spg.bulk_pick_control
12462: into l_bulk_pick_control
12463: FROM wsh_pick_grouping_rules spg
12464: WHERE spg.pick_grouping_rule_id = INV_CACHE.mtrh_rec.grouping_rule_id;
12465:
12466: g_move_order_header_id := p_move_order_header_id;
12467: g_delivery_flag := l_delivery_flag;

Line 12493: From WSH_PICK_GROUPING_RULES

12489: END IF;
12490: ELSE -- calling from the concurrent program, always query
12491: Select DELIVERY_FLAG
12492: Into l_delivery_flag
12493: From WSH_PICK_GROUPING_RULES
12494: Where pick_method=WMS_GLOBALS.PICK_METHOD_BULK
12495: and user_defined_flag = 'N' -- default rule
12496: and rownum <2; -- in case of psudo translation, multiple records are inserted for the seeded rule
12497: END IF;