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_XDOCK_PEGGING_PUB dependencies on WSH_TRIP_STOPS

Line 9726: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,

9722: NVL(wdd.date_scheduled,
9723: NVL(ool.schedule_ship_date, ool.promise_date))) AS expected_ship_date
9724: FROM wsh_delivery_details wdd, oe_order_lines_all ool,
9725: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
9726: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,
9727: wsh_carrier_services wcs_wdd, wsh_carrier_services wcs_ool, wsh_carriers wc_ool
9728: WHERE wdd.delivery_detail_id = p_source_line_detail_id
9729: AND ool.line_id = p_source_line_id
9730: AND wdd.source_line_id = ool.line_id

Line 9768: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,

9764: NVL(wts.planned_arrival_date,
9765: NVL(poll.promised_date, poll.need_by_date)) AS expected_receipt_date
9766: FROM po_line_locations_all poll, wsh_delivery_details wdd,
9767: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
9768: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,
9769: wsh_carrier_services wcs_wdd, wsh_carriers wc_poll
9770: WHERE poll.po_header_id = p_source_header_id
9771: AND poll.line_location_id = p_source_line_id
9772: AND poll.po_header_id = wdd.source_header_id (+)

Line 9817: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,

9813: NVL(poll.promised_date, poll.need_by_date))) AS expected_receipt_date
9814: FROM po_line_locations_all poll, wsh_delivery_details wdd,
9815: rcv_shipment_headers rsh, rcv_shipment_lines rsl,
9816: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
9817: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,
9818: wsh_carrier_services wcs_wdd, wsh_carriers wc_poll, wsh_carriers wc_rsh
9819: WHERE rsl.po_header_id = p_source_header_id
9820: AND rsl.po_line_location_id = p_source_line_id
9821: AND rsl.shipment_line_id = p_source_line_detail_id

Line 9882: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,

9878: prl.need_by_date)) AS expected_receipt_date
9879: FROM po_requisition_lines_all prl, rcv_shipment_lines rsl, rcv_shipment_headers rsh,
9880: oe_order_lines_all ool, wsh_delivery_details wdd,
9881: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
9882: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,
9883: wsh_carrier_services wcs_wdd, wsh_carrier_services wcs_ool,
9884: wsh_carriers wc_ool, wsh_carriers wc_rsh, wsh_carrier_services wcs_prl
9885: WHERE prl.requisition_header_id = p_source_header_id
9886: AND prl.requisition_line_id = p_source_line_id

Line 10498: wsh_delivery_legs wdl, wsh_trip_stops wts, wsh_trips wt, oe_order_lines_all ool,

10494: MAX(NVL(wts.planned_departure_date,
10495: NVL(wdd.date_scheduled,
10496: NVL(ool.schedule_ship_date, ool.promise_date)))) AS max_expected_ship_date
10497: FROM wsh_new_deliveries wnd, wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
10498: wsh_delivery_legs wdl, wsh_trip_stops wts, wsh_trips wt, oe_order_lines_all ool,
10499: wsh_carrier_services wcs_wnd, wsh_carrier_services wcs_wdd,
10500: wsh_carrier_services wcs_ool, wsh_carriers wc_ool
10501: WHERE wnd.delivery_id = p_delivery_id
10502: AND wnd.shipment_direction = 'O'