APPS.OE_SET_UTIL dependencies on WSH_DELIVERY_DETAILS

Line 146: FROM Wsh_Delivery_Details

142: -- Select statement to check whether the set is pick released.
143: /*
144: SELECT count(*)
145: INTO l_ship_set
146: FROM Wsh_Delivery_Details
147: WHERE Ship_Set_Id = p_line_rec.ship_set_id
148: AND Source_Code = 'OE'
149: AND Source_Header_Id = p_line_rec.header_id
150: AND Released_Status In ('S','Y','C')

Line 156: FROM wsh_delivery_details wdd

152: */
153:
154: SELECT count(*)
155: INTO l_ship_set
156: FROM wsh_delivery_details wdd
157: WHERE wdd.ship_set_id = p_line_rec.ship_set_id
158: AND wdd.source_code = 'OE'
159: AND wdd.source_header_id = p_line_rec.header_id
160: AND ((wdd.released_status = 'C')