APPS.OE_AR_ACCEPTANCE_GRP dependencies on WSH_NEW_DELIVERIES

Line 184: FROM wsh_new_deliveries dl,

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

Line 208: FROM wsh_new_deliveries dl,

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

Line 232: FROM wsh_new_deliveries dl

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