APPS.OE_LINE_PATTR_UTIL dependencies on OE_ORDER_LINES

Line 3417: FROM oe_order_lines_all

3413: IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN
3414: BEGIN
3415: SELECT order_quantity_uom
3416: INTO l_order_quantity_uom
3417: FROM oe_order_lines_all
3418: WHERE line_id = p_x_Line_Price_Att_rec.line_id;
3419:
3420: EXCEPTION WHEN NO_DATA_FOUND THEN
3421: null;

Line 4038: From OE_Order_lines where

4034: --2442012
4035: Begin
4036: Select booked_flag,shipping_quantity into
4037: l_booked_flag,l_shipping_quantity
4038: From OE_Order_lines where
4039: Line_id = p_x_Line_Price_Att_rec.Line_Id;
4040: Exception when no_data_found then
4041: Null;
4042: End;

Line 4162: From OE_Order_lines where

4158:
4159: /* Begin
4160: Select booked_flag,shipping_quantity into
4161: l_booked_flag,l_shipping_quantity
4162: From OE_Order_lines where
4163: Line_id = p_x_Line_Price_Att_rec.Line_Id;
4164: Exception when no_data_found then
4165: Null;
4166: End;

Line 4624: FROM oe_order_lines

4620:
4621: CURSOR Get_Option_Lines(p_model_line_id IN NUMBER)
4622: IS
4623: SELECT header_id, line_id
4624: FROM oe_order_lines
4625: WHERE top_model_line_id = p_model_line_id
4626: AND (item_type_code = OE_GLOBALS.G_ITEM_OPTION
4627: OR item_type_code = OE_GLOBALS.G_ITEM_CLASS
4628: OR item_type_code = OE_GLOBALS.G_ITEM_KIT);

Line 4642: FROM oe_order_lines

4638: oe_debug_pub.add('Entering OE_Line_PAttr_Util.copy_model_pattr.', 1);
4639:
4640: SELECT top_model_line_id, header_id
4641: INTO l_top_model_line_id, l_from_header_id
4642: FROM oe_order_lines
4643: WHERE line_id = p_to_line_id;
4644:
4645: /* -- not needed, fixed bug 1857538
4646: