APPS.WMS_POSTALLOC_PVT dependencies on WSH_PICK_GROUPING_RULES

Line 3858: FROM wsh_pick_grouping_rules spg

3854: END IF;
3855:
3856: SELECT spg.bulk_pick_control
3857: INTO l_bulk_pick_control
3858: FROM wsh_pick_grouping_rules spg
3859: WHERE spg.pick_grouping_rule_id = INV_CACHE.mtrh_rec.grouping_rule_id;
3860:
3861: -- If bulk picking is not enabled then RETURN
3862: IF l_bulk_pick_control IS NULL THEN

Line 3884: FROM WSH_PICK_GROUPING_RULES

3880: END IF;
3881:
3882: SELECT DELIVERY_FLAG
3883: INTO l_delivery_flag
3884: FROM WSH_PICK_GROUPING_RULES
3885: WHERE pick_method=WMS_GLOBALS.PICK_METHOD_BULK
3886: AND user_defined_flag = 'N' -- bulk picking default rule
3887: AND ROWNUM < 2; -- In case of pseudo translation, multiple records are inserted for the seeded rule
3888:

Line 6668: FROM wsh_pick_grouping_rules

6664: , NVL(item_flag, 'N')
6665: , NVL(revision_flag, 'N')
6666: , NVL(lot_flag, 'N')
6667: , NVL(pick_method, '-99')
6668: FROM wsh_pick_grouping_rules
6669: WHERE pick_grouping_rule_id = p_pgr_id;
6670:
6671: CURSOR c_mold IS
6672: SELECT mmtt.transaction_temp_id