APPS.WSH_INV_INTEGRATION_GRP dependencies on WSH_TRIP_STOPS

Line 216: wsh_trip_stops st

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
219: AND mtf.transaction_header_id = p_txn_header_id
220: AND nvl(mtf.transaction_batch_id,-1) = nvl(nvl(p_txn_batch_id,mtf.transaction_batch_id),-1)

Line 250: FROM wsh_trip_stops wts,

246:
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')

Line 372: FROM WSH_TRIP_STOPS

368: BEGIN
369: l_stop_cache(l_det_rec.stop_id(l_index))
370: := l_det_rec.stop_id(l_index);
371: SELECT 'X' INTO l_temp
372: FROM WSH_TRIP_STOPS
373: WHERE stop_id = l_det_rec.stop_id(l_index)
374: FOR UPDATE NOWAIT;
375:
376: OPEN c_lines_not_interfaced(l_det_rec.stop_id(l_index));

Line 384: UPDATE wsh_trip_stops

380: IF l_debug_on THEN
381: WSH_DEBUG_SV.log(l_module_name,'All lines are Interface to INV and OM',l_temp_id);
382: END IF;
383:
384: UPDATE wsh_trip_stops
385: SET pending_interface_flag = NULL
386: WHERE stop_id = l_det_rec.stop_id(l_index);
387:
388: l_row_count := SQL%ROWCOUNT;