APPS.WMS_REPLENISHMENT_PVT dependencies on WSH_PICK_SEQUENCE_RULES

Line 118: FROM WSH_PICK_SEQUENCE_RULES

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

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

1971: WDD.date_scheduled)) as expected_ship_date,
1972: wdd.replenishment_status,
1973: wdd.released_status,
1974:
1975: -- For order clause by select column values for WSH_PICK_SEQUENCE_RULES
1976: -- get for sort_attribute1
1977: To_number(DECODE(p_Release_Sequence_Rule_Id,
1978: null,
1979: null,