eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_SHIP_CONFIRM_ACTIONS dependencies on OE_ORDER_LINES_ALL

Line 2972: FROM oe_order_lines_all

2968:
2969:
2970: CURSOR c_order_line_info(c_order_line_id number) is
2971: SELECT source_document_type_id, source_document_id, source_document_line_id
2972: FROM oe_order_lines_all
2973: WHERE line_id = c_order_line_id;
2974: l_order_line_info c_order_line_info%ROWTYPE;
2975:
2976: /* Bug 1248431 added po_req_distributions.distribution_id */

Line 5637: from oe_order_Lines_all

5633: --Bug#9437761
5634: CURSOR c_order_line_details(c_source_line_id NUMBER) IS
5635: Select order_quantity_uom,
5636: ordered_quantity_uom2
5637: from oe_order_Lines_all
5638: where line_id = c_source_line_id ;
5639:
5640: l_order_quantity_uom VARCHAR2(3) ;
5641: l_ordered_quantity_uom2 VARCHAR2(3) ;

Line 5929: FROM oe_order_lines_all ol

5925: SELECT SUM(WSH_WV_UTILS.CONVERT_UOM(ol.order_quantity_uom, p_oe_interface_rec.requested_quantity_uom, ol.ordered_quantity, ol.inventory_item_id)) order_line_quantity,
5926: -- muom
5927: SUM(ol.ordered_quantity2) order_line_quantity2
5928: INTO l_tot_ord_qty, l_tot_ord_qty2
5929: FROM oe_order_lines_all ol
5930: WHERE ol.header_id = p_oe_interface_rec.source_header_id
5931: AND ol.line_set_id = p_oe_interface_rec.source_line_set_id;
5932:
5933: IF l_debug_on THEN

Line 7873: oe_order_lines_all ol

7869: FROM wsh_delivery_assignments_v da ,
7870: wsh_delivery_legs dg,
7871: wsh_new_deliveries dl,
7872: wsh_trip_stops st,
7873: oe_order_lines_all ol
7874: where da.delivery_detail_id = dd.delivery_detail_id AND
7875: dl.delivery_id = da.delivery_id AND
7876: da.delivery_id IS NOT NULL AND
7877: st.stop_id = dg.pick_up_stop_id AND

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

8341: --wrudge
8342: -- OM bug 2022029: added ato_line_id, sum(dd.requested_quantity2)
8343: -- and requested_quantity2
8344:
8345: --Bug 2177678 ,removed the use of oe_order_lines_all
8346: --Now OM locks oe_order_lines_all table for the associated lines
8347: CURSOR lock_delivery_line(p_batch_id NUMBER,c_source_header_id NUMBER,c_source_line_id NUMBER) IS
8348: SELECT dd.source_line_id
8349: FROM wsh_delivery_Details dd,

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

8342: -- OM bug 2022029: added ato_line_id, sum(dd.requested_quantity2)
8343: -- and requested_quantity2
8344:
8345: --Bug 2177678 ,removed the use of oe_order_lines_all
8346: --Now OM locks oe_order_lines_all table for the associated lines
8347: CURSOR lock_delivery_line(p_batch_id NUMBER,c_source_header_id NUMBER,c_source_line_id NUMBER) IS
8348: SELECT dd.source_line_id
8349: FROM wsh_delivery_Details dd,
8350: wsh_delivery_assignments_v da ,

Line 8622: oe_order_lines_all ol

8618: wsh_delivery_assignments_v da ,
8619: wsh_delivery_legs dg,
8620: wsh_new_deliveries dl,
8621: wsh_trip_stops st,
8622: oe_order_lines_all ol
8623: WHERE st.stop_id = dg.pick_up_stop_id AND
8624: st.batch_id = cp_batch_id AND
8625: st.stop_location_id = dl.initial_pickup_location_id AND
8626: dg.delivery_id = dl.delivery_id AND

Line 8703: oe_order_lines_all ol

8699: wsh_delivery_assignments_v da ,
8700: wsh_delivery_legs dg,
8701: wsh_new_deliveries dl,
8702: wsh_trip_stops st,
8703: oe_order_lines_all ol
8704: WHERE st.stop_id = dg.pick_up_stop_id AND
8705: st.batch_id = cp_batch_id AND
8706: st.stop_location_id = dl.initial_pickup_location_id AND
8707: dg.delivery_id = dl.delivery_id AND

Line 9975: FROM OE_ORDER_LINES_ALL

9971:
9972: IF l_detail_rec.org_id IS NULL THEN
9973: SELECT ORG_ID
9974: INTO l_detail_rec.org_id
9975: FROM OE_ORDER_LINES_ALL
9976: WHERE LINE_ID = l_detail_rec.SOURCE_LINE_ID;
9977: IF l_debug_on THEN
9978: WSH_DEBUG_SV.log(l_module_name,'derived org_id', l_detail_rec.org_id);
9979: END IF;

Line 10620: oe_order_lines_all ol

10616: NULL total_shipped_quantity2,
10617: -- muom
10618: NULL total_om_shipped_quantity
10619: FROM wsh_delivery_Details dd ,
10620: oe_order_lines_all ol
10621: WHERE dd.source_line_id = ol.line_id
10622: AND dd.released_status = 'C'
10623: AND dd.source_code = 'OE'
10624: AND ol.shipped_quantity IS NULL

Line 10840: oe_order_lines_all ol

10836: ol.flow_status_code ,
10837: SUM( dd.requested_quantity ) total_requested_quantity ,
10838: SUM( NVL(dd.shipped_quantity, 0 )) total_shipped_quantity
10839: FROM wsh_delivery_Details dd ,
10840: oe_order_lines_all ol
10841: WHERE dd.source_line_id = ol.line_id
10842: AND dd.released_status = 'C'
10843: AND dd.source_line_id = c_line_id
10844: AND dd.source_code = 'OE'