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_NEW_DELIVERIES

Line 9725: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,

9721: NVL(wts.planned_departure_date,
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

Line 9767: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,

9763: wc_poll.carrier_id))) AS carrier_id,
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

Line 9816: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,

9812: NVL(NVL(rsh.expected_receipt_date, rsh.shipped_date),
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

Line 9881: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,

9877: NVL(NVL(rsh.expected_receipt_date, rsh.shipped_date),
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

Line 10497: FROM wsh_new_deliveries wnd, wsh_delivery_details wdd, wsh_delivery_assignments_v wda,

10493: NVL(ool.schedule_ship_date, ool.promise_date)))) AS min_expected_ship_date,
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