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 9921: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,

9917: NVL(wdd.date_scheduled,
9918: NVL(ool.schedule_ship_date, ool.promise_date))) AS expected_ship_date
9919: FROM wsh_delivery_details wdd, oe_order_lines_all ool,
9920: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
9921: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,
9922: wsh_carrier_services wcs_wdd, wsh_carrier_services wcs_ool, wsh_carriers wc_ool
9923: WHERE wdd.delivery_detail_id = p_source_line_detail_id
9924: AND ool.line_id = p_source_line_id
9925: AND wdd.source_line_id = ool.line_id

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

9959: NVL(wts.planned_arrival_date,
9960: NVL(poll.promised_date, poll.need_by_date)) AS expected_receipt_date
9961: FROM po_line_locations_all poll, wsh_delivery_details wdd,
9962: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
9963: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,
9964: wsh_carrier_services wcs_wdd, wsh_carriers wc_poll
9965: WHERE poll.po_header_id = p_source_header_id
9966: AND poll.line_location_id = p_source_line_id
9967: AND poll.po_header_id = wdd.source_header_id (+)

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

10008: NVL(poll.promised_date, poll.need_by_date))) AS expected_receipt_date
10009: FROM po_line_locations_all poll, wsh_delivery_details wdd,
10010: rcv_shipment_headers rsh, rcv_shipment_lines rsl,
10011: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
10012: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,
10013: wsh_carrier_services wcs_wdd, wsh_carriers wc_poll, wsh_carriers wc_rsh
10014: WHERE rsl.po_header_id = p_source_header_id
10015: AND rsl.po_line_location_id = p_source_line_id
10016: AND rsl.shipment_line_id = p_source_line_detail_id

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

10073: prl.need_by_date)) AS expected_receipt_date
10074: FROM po_requisition_lines_all prl, rcv_shipment_lines rsl, rcv_shipment_headers rsh,
10075: oe_order_lines_all ool, wsh_delivery_details wdd,
10076: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
10077: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,
10078: wsh_carrier_services wcs_wdd, wsh_carrier_services wcs_ool,
10079: wsh_carriers wc_ool, wsh_carriers wc_rsh, wsh_carrier_services wcs_prl
10080: WHERE prl.requisition_header_id = p_source_header_id
10081: AND prl.requisition_line_id = p_source_line_id

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

10689: MAX(NVL(wts.planned_departure_date,
10690: NVL(wdd.date_scheduled,
10691: NVL(ool.schedule_ship_date, ool.promise_date)))) AS max_expected_ship_date
10692: FROM wsh_new_deliveries wnd, wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
10693: wsh_delivery_legs wdl, wsh_trip_stops wts, wsh_trips wt, oe_order_lines_all ool,
10694: wsh_carrier_services wcs_wnd, wsh_carrier_services wcs_wdd,
10695: wsh_carrier_services wcs_ool, wsh_carriers wc_ool
10696: WHERE wnd.delivery_id = p_delivery_id
10697: AND wnd.shipment_direction = 'O'