APPS.WSH_PR_CRITERIA dependencies on WSH_PICK_SEQUENCE_RULES

Line 1554: FROM WSH_PICK_SEQUENCE_RULES

1550: NVL(SHIPMENT_PRI_PRIORITY, -1),
1551: DECODE(SHIPMENT_PRI_SORT, 'A', 'ASC', 'D', 'DESC', ''),
1552: NVL(TRIP_STOP_DATE_PRIORITY, -1),
1553: DECODE(TRIP_STOP_DATE_SORT, 'A', 'ASC', 'D', 'DESC', '')
1554: FROM WSH_PICK_SEQUENCE_RULES
1555: WHERE PICK_SEQUENCE_RULE_ID = v_psr_id
1556: AND SYSDATE BETWEEN TRUNC(NVL(START_DATE_ACTIVE, SYSDATE)) AND
1557: NVL(END_DATE_ACTIVE, TRUNC(SYSDATE)+1);
1558: