APPS.OE_OE_FORM_LINE dependencies on OE_ORDER_LINES_ALL

Line 3741: oe_order_lines_all l

3737: x_line_val_rec.ref_shipment_number,
3738: x_line_val_rec.ref_option_number,
3739: x_line_val_rec.ref_component_number
3740: from oe_order_headers_all h,
3741: oe_order_lines_all l
3742: where l.line_id=p_line_rec.reference_line_id
3743: and h.header_id=l.header_id;
3744: EXCEPTION
3745: WHEN NO_DATA_FOUND THEN

Line 5119: FROM oe_order_lines_all

5115: retrobill_request_id IS NOT NULL;
5116:
5117: SELECT unit_selling_price
5118: INTO l_unit_selling_price
5119: FROM oe_order_lines_all
5120: WHERE line_id=p_line_rec.line_id;
5121:
5122: IF(l_retrobilled_price_diff IS NOT NULL AND l_unit_selling_price IS NOT NULL) THEN
5123: x_line_val_rec.retrobilled_price := l_unit_selling_price+l_retrobilled_price_diff;

Line 5143: oe_order_lines_all orig_lin

5139: x_line_val_rec.Retro_Option_Number,
5140: x_line_val_rec.Retro_Component_Number,
5141: x_line_val_rec.Retro_Service_Number
5142: FROM oe_order_headers_all orig_head,
5143: oe_order_lines_all orig_lin
5144: WHERE line_id =
5145: (
5146: SELECT orig_sys_line_ref
5147: FROM oe_order_lines_all

Line 5147: FROM oe_order_lines_all

5143: oe_order_lines_all orig_lin
5144: WHERE line_id =
5145: (
5146: SELECT orig_sys_line_ref
5147: FROM oe_order_lines_all
5148: WHERE line_id=p_line_rec.line_id
5149: and order_source_id=27) AND
5150: orig_head.header_id=orig_lin.header_id;
5151: END IF;

Line 6304: --check whether Order line exists in oe_order_lines_all or not.If it does

6300: --Calling procedure to remove fulfillment set info for the record
6301:
6302: --bug # 6059554--
6303: --Before calling procedure OE_Set_Util.Remove_From_Fulfilment to remove the fulfillment information,
6304: --check whether Order line exists in oe_order_lines_all or not.If it does
6305: --not exists then only Call OE_Set_Util.Remove_From_Fulfilment to remove the fulfillment set information for the
6306: --line otherwise we will not remove the fulfillment information from line.
6307:
6308: select count(1) into l_count_to_keep

Line 6309: from oe_order_lines_all

6305: --not exists then only Call OE_Set_Util.Remove_From_Fulfilment to remove the fulfillment set information for the
6306: --line otherwise we will not remove the fulfillment information from line.
6307:
6308: select count(1) into l_count_to_keep
6309: from oe_order_lines_all
6310: where line_id=p_line_id;
6311:
6312: if l_count_to_keep = 0 then
6313:

Line 6476: FROM OE_ORDER_LINES_ALL

6472: FROM DUAL;
6473:
6474: SELECT NVL(MAX(LINE_NUMBER)+1,1)
6475: INTO x_line_number
6476: FROM OE_ORDER_LINES_ALL
6477: WHERE HEADER_ID = p_header_id;
6478: l_line_number:=x_line_number;
6479: IF x_line_number IS NOT NULL THEN
6480: SELECT NVL(MAX(SHIPMENT_NUMBER)+1,1)