APPS.WSH_USA_INV_PVT dependencies on OE_ORDER_LINES_ALL

Line 630: FROM oe_order_lines_all oelines, wsh_delivery_details wdd

626: CURSOR get_pref_grade(wdd_id NUMBER) IS
627: SELECT oelines.preferred_grade,
628: wdd.organization_id, -- LPN CONV. rv
629: nvl(wdd.line_direction,'O') -- LPN CONV. rv
630: FROM oe_order_lines_all oelines, wsh_delivery_details wdd
631: WHERE wdd.delivery_detail_id = wdd_id
632: AND wdd.source_code = 'OE'
633: AND wdd.source_line_id = oelines.line_id;
634:

Line 4659: FROM oe_order_lines_all

4655: END IF;
4656: IF g_ship_model_id IS NOT NULL THEN
4657: SELECT inventory_item_id
4658: INTO l_top_model_item_id
4659: FROM oe_order_lines_all
4660: WHERE line_id = g_ship_model_id;
4661: END IF;
4662: --
4663: IF l_debug_on THEN

Line 5725: FROM oe_order_lines_all

5721: SELECT ordered_quantity,
5722: order_quantity_uom,
5723: ordered_quantity2,
5724: ordered_quantity_uom2
5725: FROM oe_order_lines_all
5726: WHERE line_id = x_source_line_id
5727: AND x_source_code = 'OE';
5728:
5729: l_detail_info c_detail_info%ROWTYPE;