DBA Data[Home] [Help]

APPS.WMS_REPLENISHMENT_PVT dependencies on WSH_NEW_DELIVERIES

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 5880: FROM wsh_new_deliveries wnd, wsh_delivery_details wdd, wsh_delivery_assignments_v wda,

5876: SELECT MIN(NVL(wts.planned_departure_date, wdd.date_scheduled))
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