eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_RFID_DEVICE_PUB dependencies on WSH_DELIVERY_DETAILS

Line 336: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wms_license_plate_numbers lpn,

332: --get the delivery_id
333: -- After staging and before Truck Load, there might not be any delivery attached to the LPN
334: begin
335: select distinct wda.delivery_id INTO l_delivery_id
336: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wms_license_plate_numbers lpn,
337: wsh_delivery_details wdd2
338: where lpn.outermost_lpn_id = p_lpn_id
339: and wdd2.lpn_id = lpn.lpn_id
340: and wdd2.lpn_id is not null

Line 337: wsh_delivery_details wdd2

333: -- After staging and before Truck Load, there might not be any delivery attached to the LPN
334: begin
335: select distinct wda.delivery_id INTO l_delivery_id
336: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wms_license_plate_numbers lpn,
337: wsh_delivery_details wdd2
338: where lpn.outermost_lpn_id = p_lpn_id
339: and wdd2.lpn_id = lpn.lpn_id
340: and wdd2.lpn_id is not null
341: and wdd2.delivery_detail_id = wda.parent_delivery_detail_id

Line 385: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wms_license_plate_numbers lpn,

381: --check whether all the lines in the delivery are loaded
382: begin
383: SELECT -1 INTO x_is_last_lpn FROM dual WHERE exists
384: ( select wlpn.license_plate_number --distinct wlpn.license_plate_number
385: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wms_license_plate_numbers lpn,
386: wsh_delivery_details wdd2,wms_license_plate_numbers wlpn
387: where wdd2.delivery_detail_id = wda.parent_delivery_detail_id
388: and wdd.delivery_detail_id = wda.delivery_detail_id
389: and wdd2.lpn_id is not null

Line 386: wsh_delivery_details wdd2,wms_license_plate_numbers wlpn

382: begin
383: SELECT -1 INTO x_is_last_lpn FROM dual WHERE exists
384: ( select wlpn.license_plate_number --distinct wlpn.license_plate_number
385: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wms_license_plate_numbers lpn,
386: wsh_delivery_details wdd2,wms_license_plate_numbers wlpn
387: where wdd2.delivery_detail_id = wda.parent_delivery_detail_id
388: and wdd.delivery_detail_id = wda.delivery_detail_id
389: and wdd2.lpn_id is not null
390: and wdd2.lpn_id = lpn.lpn_id

Line 427: wsh_delivery_details wdd,

423: wms_license_plate_numbers lpn,
424: wms_license_plate_numbers wlpn,
425: wsh_new_deliveries wnd,
426: wsh_delivery_legs wdl,
427: wsh_delivery_details wdd,
428: wsh_delivery_assignments_v wda,
429: wsh_delivery_details wdd2,
430: wsh_trip_stops pickup_stop,
431: wsh_trip_stops dropoff_stop

Line 429: wsh_delivery_details wdd2,

425: wsh_new_deliveries wnd,
426: wsh_delivery_legs wdl,
427: wsh_delivery_details wdd,
428: wsh_delivery_assignments_v wda,
429: wsh_delivery_details wdd2,
430: wsh_trip_stops pickup_stop,
431: wsh_trip_stops dropoff_stop
432: where pickup_stop.trip_id = l_trip_id
433: and wdl.pick_up_stop_id = pickup_stop.stop_id