APPS.WSH_USA_INV_PVT dependencies on OE_ORDER_LINES_ALL

Line 637: FROM oe_order_lines_all oelines, wsh_delivery_details wdd

633: CURSOR get_pref_grade(wdd_id NUMBER) IS
634: SELECT oelines.preferred_grade,
635: wdd.organization_id, -- LPN CONV. rv
636: nvl(wdd.line_direction,'O') -- LPN CONV. rv
637: FROM oe_order_lines_all oelines, wsh_delivery_details wdd
638: WHERE wdd.delivery_detail_id = wdd_id
639: AND wdd.source_code = 'OE'
640: AND wdd.source_line_id = oelines.line_id;
641:

Line 5195: FROM oe_order_lines_all

5191: END IF;
5192: IF g_ship_model_id IS NOT NULL THEN
5193: SELECT inventory_item_id
5194: INTO l_top_model_item_id
5195: FROM oe_order_lines_all
5196: WHERE line_id = g_ship_model_id;
5197: END IF;
5198: --
5199: IF l_debug_on THEN

Line 6295: FROM oe_order_lines_all

6291: SELECT ordered_quantity,
6292: order_quantity_uom,
6293: ordered_quantity2,
6294: ordered_quantity_uom2
6295: FROM oe_order_lines_all
6296: WHERE line_id = x_source_line_id
6297: AND x_source_code = 'OE';
6298:
6299: l_detail_info c_detail_info%ROWTYPE;