APPS.WMS_REPLENISHMENT_PVT dependencies on WSH_PICK_SEQUENCE_RULES

Line 121: FROM WSH_PICK_SEQUENCE_RULES

117: NVL(SHIPMENT_PRI_PRIORITY, 999999999),
118: DECODE(SHIPMENT_PRI_SORT, 'A', 'ASC', 'D', 'DESC', ''),
119: NVL(TRIP_STOP_DATE_PRIORITY, 999999999),
120: DECODE(TRIP_STOP_DATE_SORT, 'A', 'ASC', 'D', 'DESC', '')
121: FROM WSH_PICK_SEQUENCE_RULES
122: WHERE PICK_SEQUENCE_RULE_ID = v_psr_id
123: AND SYSDATE BETWEEN TRUNC(NVL(START_DATE_ACTIVE, SYSDATE)) AND
124: NVL(END_DATE_ACTIVE, TRUNC(SYSDATE) + 1);
125:

Line 1914: -- For order clause by select column values for WSH_PICK_SEQUENCE_RULES

1910: WDD.date_scheduled)) as expected_ship_date,
1911: wdd.replenishment_status,
1912: wdd.released_status,
1913:
1914: -- For order clause by select column values for WSH_PICK_SEQUENCE_RULES
1915: -- get for sort_attribute1
1916: To_number(DECODE(p_Release_Sequence_Rule_Id,
1917: null,
1918: null,