APPS.INV_PR_PICK_SLIP_NUMBER dependencies on WSH_PICK_GROUPING_RULES

Line 357: FROM wsh_pick_grouping_rules

353: , NVL(item_flag, 'N')
354: , NVL(revision_flag, 'N')
355: , NVL(lot_flag, 'N')
356: , NVL(pick_method, '-99')
357: FROM wsh_pick_grouping_rules
358: WHERE pick_grouping_rule_id = v_pgr_id;
359:
360: -- cursor to get number of times called before printer
361: CURSOR get_limit(v_org_id IN NUMBER) IS

Line 818: FROM wsh_pick_grouping_rules

814: , NVL(item_flag, 'N')
815: , NVL(revision_flag, 'N')
816: , NVL(lot_flag, 'N')
817: , NVL(pick_method, '-99')
818: FROM wsh_pick_grouping_rules
819: WHERE pick_grouping_rule_id = v_pgr_id;
820:
821: l_insert_key_rec wipkeyrectyp;
822: l_hash_value NUMBER;

Line 1449: FROM wsh_pick_grouping_rules

1445: , NVL(item_flag, 'N')
1446: , NVL(revision_flag, 'N')
1447: , NVL(lot_flag, 'N')
1448: , NVL(pick_method, '-99')
1449: FROM wsh_pick_grouping_rules
1450: WHERE pick_grouping_rule_id = v_pgr_id;
1451: -- cursor to get number of times called before printer
1452: CURSOR get_limit(v_org_id IN NUMBER) IS
1453: SELECT NVL(pick_slip_lines, -1)