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 4121: From OE_Order_lines where

4117:
4118: /* Begin
4119: Select booked_flag,shipping_quantity into
4120: l_booked_flag,l_shipping_quantity
4121: From OE_Order_lines where
4122: Line_id = p_x_Line_Price_Att_rec.Line_Id;
4123: Exception when no_data_found then
4124: Null;
4125: End;

Line 4583: FROM oe_order_lines

4579:
4580: CURSOR Get_Option_Lines(p_model_line_id IN NUMBER)
4581: IS
4582: SELECT header_id, line_id
4583: FROM oe_order_lines
4584: WHERE top_model_line_id = p_model_line_id
4585: AND (item_type_code = OE_GLOBALS.G_ITEM_OPTION
4586: OR item_type_code = OE_GLOBALS.G_ITEM_CLASS
4587: OR item_type_code = OE_GLOBALS.G_ITEM_KIT);

Line 4601: FROM oe_order_lines

4597: oe_debug_pub.add('Entering OE_Line_PAttr_Util.copy_model_pattr.', 1);
4598:
4599: SELECT top_model_line_id, header_id
4600: INTO l_top_model_line_id, l_from_header_id
4601: FROM oe_order_lines
4602: WHERE line_id = p_to_line_id;
4603:
4604: /* -- not needed, fixed bug 1857538
4605: