APPS.WSH_OE_CONSTRAINTS dependencies on WSH_DELIVERY_DETAILS

Line 23: FROM wsh_delivery_details

19: -- Find out if we have delivery details
20: -- that require checking the reservations.
21: CURSOR c_details(x_line_id IN NUMBER) IS
22: SELECT released_status
23: FROM wsh_delivery_details
24: WHERE source_code = 'OE'
25: AND source_line_id = x_line_id
26: AND released_status IN ('S', 'Y', 'X')
27: AND rownum = 1;

Line 217: FROM wsh_delivery_details

213: -- Find out if we have delivery details
214: -- that require checking the reservations.
215: CURSOR c_details(x_line_id IN NUMBER) IS
216: SELECT released_status
217: FROM wsh_delivery_details
218: WHERE source_code = 'OE'
219: AND source_line_id = x_line_id
220: AND released_status IN ('S', 'Y', 'C')
221: AND rownum = 1;