APPS.WMS_REPLENISHMENT_PVT dependencies on OE_ORDER_LINES_ALL

Line 2105: FROM oe_order_lines_all oel,

2101: GET_SORT_TRIP_STOP_DATE(wdd.delivery_detail_id,
2102: L_TRIP_STOP_DATE_SORT),
2103: NULL))) as sort_attribute5
2104:
2105: FROM oe_order_lines_all oel,
2106: wsh_delivery_details wdd,
2107: MTL_ABC_ASSIGNMENTS MAA
2108: WHERE wdd.organization_id = p_organization_id
2109: AND wdd.source_code = 'OE'

Line 5808: FROM wsh_delivery_details wdd, oe_order_lines_all ool,

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

Line 5882: -- oe_order_lines_all ool

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 (+)
5886: AND wnd.shipment_direction = 'O'