APPS.WMS_TASK_DISPATCH_ENGINE dependencies on WSH_PICK_GROUPING_RULES

Line 11185: FROM mtl_txn_request_headers moh, wsh_pick_grouping_rules spg

11181: AND mol.header_id = p_move_order_header_id
11182: AND mmtt.wms_task_type NOT IN(5, 6)
11183: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation
11184: AND( EXISTS(SELECT 1
11185: FROM mtl_txn_request_headers moh, wsh_pick_grouping_rules spg
11186: WHERE spg.pick_grouping_rule_id = moh.grouping_rule_id
11187: AND spg.pick_method = '4'
11188: AND moh.header_id = mol.header_id)
11189: OR EXISTS(SELECT 1

Line 11280: FROM mtl_txn_request_headers moh, wsh_pick_grouping_rules spg

11276: AND mol.header_id = p_move_order_header_id
11277: AND mmtt.wms_task_type NOT IN(5, 6)
11278: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation
11279: AND( EXISTS(SELECT 1
11280: FROM mtl_txn_request_headers moh, wsh_pick_grouping_rules spg
11281: WHERE spg.pick_grouping_rule_id = moh.grouping_rule_id
11282: AND spg.pick_method = '4'
11283: AND moh.header_id = mol.header_id)
11284: OR EXISTS(SELECT 1

Line 11979: From WSH_PICK_GROUPING_RULES

11975: END IF;
11976:
11977: Select DELIVERY_FLAG
11978: Into l_delivery_flag
11979: From WSH_PICK_GROUPING_RULES
11980: Where pick_method=WMS_GLOBALS.PICK_METHOD_BULK
11981: and user_defined_flag = 'N' -- bulk picking default rule
11982: and rownum <2; -- in case of psudo translation, multiple records are inserted for the seeded rule
11983:

Line 11987: FROM wsh_pick_grouping_rules spg

11983:
11984: -- check to see if the picking methodology is bulk picking disabled (including order picking)---
11985: SELECT spg.bulk_pick_control
11986: into l_bulk_pick_control
11987: FROM wsh_pick_grouping_rules spg
11988: WHERE spg.pick_grouping_rule_id = INV_CACHE.mtrh_rec.grouping_rule_id;
11989:
11990: g_move_order_header_id := p_move_order_header_id;
11991: g_delivery_flag := l_delivery_flag;

Line 12017: From WSH_PICK_GROUPING_RULES

12013: END IF;
12014: ELSE -- calling from the concurrent program, always query
12015: Select DELIVERY_FLAG
12016: Into l_delivery_flag
12017: From WSH_PICK_GROUPING_RULES
12018: Where pick_method=WMS_GLOBALS.PICK_METHOD_BULK
12019: and user_defined_flag = 'N' -- default rule
12020: and rownum <2; -- in case of psudo translation, multiple records are inserted for the seeded rule
12021: END IF;