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_REPLENISHMENT_PVT dependencies on WSH_DELIVERY_LEGS

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

5805: SELECT NVL(wts.planned_departure_date,
5806: NVL(wdd.date_scheduled,
5807: NVL(ool.schedule_ship_date, ool.promise_date))) AS expected_ship_date
5808: FROM wsh_delivery_details wdd, oe_order_lines_all ool,
5809: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
5810: wsh_trip_stops wts, wsh_trips wt
5811: WHERE wdd.delivery_detail_id = p_delivery_line_id
5812: AND ool.line_id = p_source_line_id
5813: AND wdd.source_line_id = ool.line_id

Line 5820: FROM wsh_delivery_legs wdl_first_leg

5816: AND wda.delivery_id = wnd.delivery_id (+)
5817: AND wnd.delivery_id = wdl.delivery_id (+)
5818: AND (wdl.sequence_number IS NULL OR
5819: wdl.sequence_number = (SELECT MIN(sequence_number)
5820: FROM wsh_delivery_legs wdl_first_leg
5821: WHERE wdl_first_leg.delivery_id = wdl.delivery_id))
5822: AND wdl.pick_up_stop_id = wts.stop_id (+)
5823: AND wts.trip_id = wt.trip_id (+);
5824:

Line 5881: wsh_delivery_legs wdl, wsh_trip_stops wts

5877: -- MIN(NVL(wts.planned_departure_date,
5878: -- NVL(wdd.date_scheduled,
5879: -- NVL(ool.schedule_ship_date, ool.promise_date)))) AS min_expected_ship_date,
5880: FROM wsh_new_deliveries wnd, wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
5881: wsh_delivery_legs wdl, wsh_trip_stops wts
5882: -- oe_order_lines_all ool
5883:
5884: WHERE wdd.delivery_detail_id = p_delivery_detail_id
5885: -- AND wdd.source_line_id = ool.line_id (+)

Line 5892: FROM wsh_delivery_legs wdl_first_leg

5888: AND wda.delivery_detail_id = wdd.delivery_detail_id (+)
5889: AND wnd.delivery_id = wdl.delivery_id (+)
5890: AND (wdl.sequence_number IS NULL OR
5891: wdl.sequence_number = (SELECT MIN(sequence_number)
5892: FROM wsh_delivery_legs wdl_first_leg
5893: WHERE wdl_first_leg.delivery_id = wdl.delivery_id))
5894: AND wdl.pick_up_stop_id = wts.stop_id (+)
5895: GROUP BY wnd.organization_id, wnd.delivery_id, wts.stop_id;
5896: