DBA Data[Home] [Help]

APPS.WMS_WAVE_PLANNING_PVT dependencies on WSH_PICK_SEQUENCE_RULES

Line 11942: FROM WSH_PICK_SEQUENCE_RULES

11938: NVL(SHIPMENT_PRI_PRIORITY, -1),
11939: DECODE(SHIPMENT_PRI_SORT, 'A', 'ASC', 'D', 'DESC', ''),
11940: NVL(TRIP_STOP_DATE_PRIORITY, -1),
11941: DECODE(TRIP_STOP_DATE_SORT, 'A', 'ASC', 'D', 'DESC', '')
11942: FROM WSH_PICK_SEQUENCE_RULES
11943: WHERE PICK_SEQUENCE_RULE_ID = v_psr_id
11944: AND SYSDATE BETWEEN TRUNC(NVL(START_DATE_ACTIVE, SYSDATE)) AND
11945: NVL(END_DATE_ACTIVE, TRUNC(SYSDATE) + 1);
11946: