APPS.OE_AR_ACCEPTANCE_GRP dependencies on WSH_NEW_DELIVERIES

Line 186: FROM wsh_new_deliveries dl,

182: END IF;
183: BEGIN
184: SELECT min(dl.delivery_id)
185: INTO l_delivery_line_id
186: FROM wsh_new_deliveries dl,
187: wsh_delivery_assignments da,
188: wsh_delivery_details dd
189: WHERE dd.delivery_detail_id = da.delivery_detail_id
190: AND da.delivery_id = dl.delivery_id

Line 210: FROM wsh_new_deliveries dl,

206: END IF;
207: BEGIN
208: SELECT min(dl.delivery_id)
209: INTO l_delivery_line_id
210: FROM wsh_new_deliveries dl,
211: wsh_delivery_assignments da,
212: wsh_delivery_details dd
213: WHERE dd.delivery_detail_id = da.delivery_detail_id
214: AND da.delivery_id = dl.delivery_id

Line 234: FROM wsh_new_deliveries dl

230: SELECT NVL(SUBSTR(dl.name, 1, 30), '0')
231: ,NVL(SUBSTR(dl.waybill, 1, 30), '0')
232: INTO x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE3
233: ,x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE4
234: FROM wsh_new_deliveries dl
235: WHERE dl.delivery_id = l_delivery_line_id;
236:
237: IF l_debug_level > 0 THEN
238: oe_debug_pub.add('Get_Interface_Attributes:DELIVERY NUM:'||X_LINE_FLEX_REC.INTERFACE_LINE_ATTRIBUTE3,5);