DBA Data[Home] [Help]

APPS.WMS_REPLENISHMENT_PVT dependencies on WSH_NEW_DELIVERIES

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

5975: SELECT NVL(wts.planned_departure_date,
5976: NVL(wdd.date_scheduled,
5977: NVL(ool.schedule_ship_date, ool.promise_date))) AS expected_ship_date
5978: FROM wsh_delivery_details wdd, oe_order_lines_all ool,
5979: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
5980: wsh_trip_stops wts, wsh_trips wt
5981: WHERE wdd.delivery_detail_id = p_delivery_line_id
5982: AND ool.line_id = p_source_line_id
5983: AND wdd.source_line_id = ool.line_id

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

6046: SELECT MIN(NVL(wts.planned_departure_date, wdd.date_scheduled))
6047: -- MIN(NVL(wts.planned_departure_date,
6048: -- NVL(wdd.date_scheduled,
6049: -- NVL(ool.schedule_ship_date, ool.promise_date)))) AS min_expected_ship_date,
6050: FROM wsh_new_deliveries wnd, wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
6051: wsh_delivery_legs wdl, wsh_trip_stops wts
6052: -- oe_order_lines_all ool
6053:
6054: WHERE wdd.delivery_detail_id = p_delivery_detail_id