APPS.OE_OE_FORM_LINE dependencies on OE_ORDER_LINES_ALL

Line 3642: oe_order_lines_all l

3638: x_line_val_rec.ref_shipment_number,
3639: x_line_val_rec.ref_option_number,
3640: x_line_val_rec.ref_component_number
3641: from oe_order_headers_all h,
3642: oe_order_lines_all l
3643: where l.line_id=p_line_rec.reference_line_id
3644: and h.header_id=l.header_id;
3645: EXCEPTION
3646: WHEN NO_DATA_FOUND THEN

Line 4841: FROM oe_order_lines_all

4837: retrobill_request_id IS NOT NULL;
4838:
4839: SELECT unit_selling_price
4840: INTO l_unit_selling_price
4841: FROM oe_order_lines_all
4842: WHERE line_id=p_line_rec.line_id;
4843:
4844: IF(l_retrobilled_price_diff IS NOT NULL AND l_unit_selling_price IS NOT NULL) THEN
4845: x_line_val_rec.retrobilled_price := l_unit_selling_price+l_retrobilled_price_diff;

Line 4865: oe_order_lines_all orig_lin

4861: x_line_val_rec.Retro_Option_Number,
4862: x_line_val_rec.Retro_Component_Number,
4863: x_line_val_rec.Retro_Service_Number
4864: FROM oe_order_headers_all orig_head,
4865: oe_order_lines_all orig_lin
4866: WHERE line_id =
4867: (
4868: SELECT orig_sys_line_ref
4869: FROM oe_order_lines_all

Line 4869: FROM oe_order_lines_all

4865: oe_order_lines_all orig_lin
4866: WHERE line_id =
4867: (
4868: SELECT orig_sys_line_ref
4869: FROM oe_order_lines_all
4870: WHERE line_id=p_line_rec.line_id
4871: and order_source_id=27) AND
4872: orig_head.header_id=orig_lin.header_id;
4873: END IF;

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

5952: --Calling procedure to remove fulfillment set info for the record
5953:
5954: --bug # 6059554--
5955: --Before calling procedure OE_Set_Util.Remove_From_Fulfilment to remove the fulfillment information,
5956: --check whether Order line exists in oe_order_lines_all or not.If it does
5957: --not exists then only Call OE_Set_Util.Remove_From_Fulfilment to remove the fulfillment set information for the
5958: --line otherwise we will not remove the fulfillment information from line.
5959:
5960: select count(1) into l_count_to_keep

Line 5961: from oe_order_lines_all

5957: --not exists then only Call OE_Set_Util.Remove_From_Fulfilment to remove the fulfillment set information for the
5958: --line otherwise we will not remove the fulfillment information from line.
5959:
5960: select count(1) into l_count_to_keep
5961: from oe_order_lines_all
5962: where line_id=p_line_id;
5963:
5964: if l_count_to_keep = 0 then
5965:

Line 6109: FROM OE_ORDER_LINES_ALL

6105: FROM DUAL;
6106:
6107: SELECT NVL(MAX(LINE_NUMBER)+1,1)
6108: INTO x_line_number
6109: FROM OE_ORDER_LINES_ALL
6110: WHERE HEADER_ID = p_header_id;
6111: l_line_number:=x_line_number;
6112: IF x_line_number IS NOT NULL THEN
6113: SELECT NVL(MAX(SHIPMENT_NUMBER)+1,1)