APPS.WSH_PR_CRITERIA dependencies on WSH_PICK_SEQUENCE_RULES

Line 1493: FROM WSH_PICK_SEQUENCE_RULES

1489: NVL(SHIPMENT_PRI_PRIORITY, -1),
1490: DECODE(SHIPMENT_PRI_SORT, 'A', 'ASC', 'D', 'DESC', ''),
1491: NVL(TRIP_STOP_DATE_PRIORITY, -1),
1492: DECODE(TRIP_STOP_DATE_SORT, 'A', 'ASC', 'D', 'DESC', '')
1493: FROM WSH_PICK_SEQUENCE_RULES
1494: WHERE PICK_SEQUENCE_RULE_ID = v_psr_id
1495: AND SYSDATE BETWEEN TRUNC(NVL(START_DATE_ACTIVE, SYSDATE)) AND
1496: NVL(END_DATE_ACTIVE, TRUNC(SYSDATE)+1);
1497: