DBA Data[Home] [Help]

APPS.WMS_REPLENISHMENT_PVT dependencies on OE_ORDER_LINES_ALL

Line 2166: FROM oe_order_lines_all oel,

2162: GET_SORT_TRIP_STOP_DATE(wdd.delivery_detail_id,
2163: L_TRIP_STOP_DATE_SORT),
2164: NULL))) as sort_attribute5
2165:
2166: FROM oe_order_lines_all oel,
2167: wsh_delivery_details wdd
2168: WHERE wdd.organization_id = p_organization_id
2169: AND wdd.source_code = 'OE'
2170: AND oel.booked_flag = 'Y'

Line 5978: FROM wsh_delivery_details wdd, oe_order_lines_all ool,

5974: CURSOR wdd_rec_cursor IS
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

Line 6052: -- oe_order_lines_all ool

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
6055: -- AND wdd.source_line_id = ool.line_id (+)
6056: AND wnd.shipment_direction = 'O'