APPS.WSH_SHIP_CONFIRM_ACTIONS dependencies on OE_ORDER_LINES_ALL

Line 2483: FROM oe_order_lines_all

2479:
2480:
2481: CURSOR c_order_line_info(c_order_line_id number) is
2482: SELECT source_document_type_id, source_document_id, source_document_line_id
2483: FROM oe_order_lines_all
2484: WHERE line_id = c_order_line_id;
2485: l_order_line_info c_order_line_info%ROWTYPE;
2486:
2487: /* Bug 1248431 added po_req_distributions.distribution_id */

Line 6338: oe_order_lines_all ol

6334: FROM wsh_delivery_assignments_v da ,
6335: wsh_delivery_legs dg,
6336: wsh_new_deliveries dl,
6337: wsh_trip_stops st,
6338: oe_order_lines_all ol
6339: where da.delivery_detail_id = dd.delivery_detail_id AND
6340: dl.delivery_id = da.delivery_id AND
6341: da.delivery_id IS NOT NULL AND
6342: st.stop_id = dg.pick_up_stop_id AND

Line 6800: --Bug 2177678 ,removed the use of oe_order_lines_all

6796: --wrudge
6797: -- OM bug 2022029: added ato_line_id, sum(dd.requested_quantity2)
6798: -- and requested_quantity2
6799:
6800: --Bug 2177678 ,removed the use of oe_order_lines_all
6801: --Now OM locks oe_order_lines_all table for the associated lines
6802: CURSOR lock_delivery_line(p_batch_id NUMBER,c_source_header_id NUMBER,c_source_line_id NUMBER) IS
6803: SELECT dd.source_line_id
6804: FROM wsh_delivery_Details dd,

Line 6801: --Now OM locks oe_order_lines_all table for the associated lines

6797: -- OM bug 2022029: added ato_line_id, sum(dd.requested_quantity2)
6798: -- and requested_quantity2
6799:
6800: --Bug 2177678 ,removed the use of oe_order_lines_all
6801: --Now OM locks oe_order_lines_all table for the associated lines
6802: CURSOR lock_delivery_line(p_batch_id NUMBER,c_source_header_id NUMBER,c_source_line_id NUMBER) IS
6803: SELECT dd.source_line_id
6804: FROM wsh_delivery_Details dd,
6805: wsh_delivery_assignments_v da ,

Line 7061: oe_order_lines_all ol

7057: wsh_delivery_assignments_v da ,
7058: wsh_delivery_legs dg,
7059: wsh_new_deliveries dl,
7060: wsh_trip_stops st,
7061: oe_order_lines_all ol
7062: WHERE st.stop_id = dg.pick_up_stop_id AND
7063: st.batch_id = cp_batch_id AND
7064: st.stop_location_id = dl.initial_pickup_location_id AND
7065: dg.delivery_id = dl.delivery_id AND

Line 7127: oe_order_lines_all ol

7123: wsh_delivery_assignments_v da ,
7124: wsh_delivery_legs dg,
7125: wsh_new_deliveries dl,
7126: wsh_trip_stops st,
7127: oe_order_lines_all ol
7128: WHERE st.stop_id = dg.pick_up_stop_id AND
7129: st.batch_id = cp_batch_id AND
7130: st.stop_location_id = dl.initial_pickup_location_id AND
7131: dg.delivery_id = dl.delivery_id AND

Line 7619: FROM oe_order_lines_all ol

7615: oe_interface_rec.requested_quantity_uom,
7616: ol.ordered_quantity,
7617: ol.inventory_item_id)) order_line_quantity
7618: INTO l_tot_ord_qty
7619: FROM oe_order_lines_all ol
7620: WHERE ol.header_id = oe_interface_rec.source_header_id
7621: AND ol.line_set_id = oe_interface_rec.source_line_set_id;
7622:
7623: IF l_debug_on THEN

Line 8590: FROM OE_ORDER_LINES_ALL

8586:
8587: IF l_detail_rec.org_id IS NULL THEN
8588: SELECT ORG_ID
8589: INTO l_detail_rec.org_id
8590: FROM OE_ORDER_LINES_ALL
8591: WHERE LINE_ID = l_detail_rec.SOURCE_LINE_ID;
8592: IF l_debug_on THEN
8593: WSH_DEBUG_SV.log(l_module_name,'derived org_id', l_detail_rec.org_id);
8594: END IF;