APPS.GMI_PICK_WAVE_CONFIRM_PVT dependencies on OE_ORDER_LINES_ALL

Line 850: FROM oe_order_lines_all b

846: INTO l_delivery_detail_id
847: , l_source_header_id
848: , l_source_line_id
849: , l_order_quantity_uom
850: FROM oe_order_lines_all b
851: , wsh_inv_delivery_details_v a
852: WHERE a.move_order_line_id = l_mo_line_rec.line_id
853: AND a.move_order_line_id IS NOT NULL
854: AND a.oe_line_id = b.line_id

Line 1871: FROM oe_order_lines_all

1867: x_primary_uom,
1868: ordered_quantity,
1869: x_item_id) quantity ,
1870: order_quantity_uom
1871: FROM oe_order_lines_all
1872: WHERE line_id = x_source_line_id;
1873:
1874:
1875: -- HW OPM cursor for OPM

Line 1882: FROM oe_order_lines_all

1878: SELECT ordered_quantity,
1879: order_quantity_uom,
1880: ordered_quantity2,
1881: ordered_quantity_uom2
1882: FROM oe_order_lines_all
1883: WHERE line_id = x_source_line_id;
1884:
1885: l_found_flag BOOLEAN;
1886: l_detail_info c_detail_info%ROWTYPE;

Line 2227: FROM OE_ORDER_LINES_ALL

2223: l_ordered_quantity2,
2224: l_shipped_quantity2,
2225: l_top_model_line_id,
2226: l_ato_line_id
2227: FROM OE_ORDER_LINES_ALL
2228: WHERE line_id = p_line_id;
2229:
2230: IF nvl(l_top_model_line_id,-1) = nvl(l_ato_line_id,-1) AND
2231: l_top_model_line_id IS NOT NULL THEN

Line 2237: FROM OE_ORDER_LINES_ALL

2233: gmi_reservation_util.println('It is a ATO MODEL ');
2234:
2235: SELECT line_set_id
2236: INTO l_line_set_id
2237: FROM OE_ORDER_LINES_ALL
2238: WHERE line_id = l_top_model_line_id;
2239:
2240: gmi_reservation_util.println('Line set id : '||l_line_set_id);
2241:

Line 2259: FROM oe_order_lines_all

2255: , l_shipping_quantity
2256: , l_ordered_quantity2
2257: , l_shipped_quantity2
2258: , l_shipping_quantity2
2259: FROM oe_order_lines_all
2260: WHERE line_set_id = l_line_set_id;
2261:
2262: END IF;
2263: