210: SELECT st.stop_id, wdd.delivery_detail_id
211: FROM wsh_delivery_details wdd,
212: mtl_transactions_interface mtf,
213: wsh_delivery_assignments_v da ,
214: wsh_delivery_legs dg,
215: wsh_new_deliveries dl,
216: wsh_trip_stops st
217: WHERE wdd.delivery_detail_id = mtf.picking_line_id
218: AND mtf.error_code IS NULL
247: -- Cursor to verify that OM and INV interface is complete for trip stop.
248: CURSOR c_lines_not_interfaced(p_stop_id NUMBER) IS
249: SELECT wdd.delivery_detail_id
250: FROM wsh_trip_stops wts,
251: wsh_delivery_legs wdl,
252: wsh_delivery_assignments_v wda,
253: wsh_delivery_details wdd
254: WHERE (wdd.inv_interfaced_flag IN ('N', 'P') OR wdd.oe_interfaced_flag <> 'Y')
255: AND wts.stop_id = p_stop_id