eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_OE_FORM_LINE dependencies on OE_ORDER_LINES

Line 1158: l_orig_ship_from_org_id OE_Order_LINES.ship_from_org_id%TYPE;

1154: l_control_rec OE_GLOBALS.Control_Rec_Type;
1155: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1156: l_date_format_mask VARCHAR2(30) := p_date_format_mask;
1157: l_order_date_type_code VARCHAR2(30) := null;
1158: l_orig_ship_from_org_id OE_Order_LINES.ship_from_org_id%TYPE;
1159: l_x_item_rec_type OE_ORDER_CACHE.item_rec_type; -- OPM 2/JUN/00
1160: file_name varchar2(100);
1161: i pls_Integer;
1162: L_PRICE_CONTROL_REC QP_PREQ_GRP.control_record_type;

Line 3380: FROM oe_order_lines

3376: , top_model_line_id
3377: , nvl(ship_model_complete_flag, 'N') smc_flag
3378: , item_type_code
3379: , link_to_line_id
3380: FROM oe_order_lines
3381: WHERE line_id = c_line_id;
3382:
3383: CURSOR ato_lines_on_hold(c_ato_line_id NUMBER, c_top_model_line_id NUMBER) IS
3384: SELECT 'Y' hold_exists

Line 3385: FROM oe_order_holds ooh, oe_order_lines ool

3381: WHERE line_id = c_line_id;
3382:
3383: CURSOR ato_lines_on_hold(c_ato_line_id NUMBER, c_top_model_line_id NUMBER) IS
3384: SELECT 'Y' hold_exists
3385: FROM oe_order_holds ooh, oe_order_lines ool
3386: where ool.ato_line_id = c_ato_line_id
3387: and ool.top_model_line_id = c_top_model_line_id
3388: and ooh.line_id = ool.line_id
3389: and ooh.released_flag = 'N';

Line 3393: FROM oe_order_holds ooh, oe_order_lines ool

3389: and ooh.released_flag = 'N';
3390:
3391: CURSOR smc_lines_on_hold(c_top_model_line_id NUMBER) IS
3392: SELECT 'Y' hold_exists
3393: FROM oe_order_holds ooh, oe_order_lines ool
3394: where ool.top_model_line_id = c_top_model_line_id
3395: and ooh.line_id = ool.line_id
3396: and ooh.released_flag = 'N';
3397:

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 4723: from oe_order_lines

4719: from oe_order_headers
4720: where header_id=p_line_rec.source_document_id;
4721:
4722: Select line_number into x_line_val_rec.order_source_line_ref
4723: from oe_order_lines
4724: where line_id=p_line_rec.source_document_line_id;
4725: Exception
4726: when no_data_found then
4727: null;

Line 4833: FROM oe_order_lines

4829: IF (p_line_rec.line_id IS NOT NULL AND oe_sys_parameters.value('ENABLE_RETROBILLING',p_line_rec.org_id) = 'Y') THEN
4830: BEGIN
4831: SELECT sum(decode(line_category_code,'RETURN',-1*nvl(unit_selling_price,0),nvl(unit_selling_price,0)))
4832: INTO l_retrobilled_price_diff
4833: FROM oe_order_lines
4834: WHERE order_source_id=27 AND
4835: orig_sys_document_ref=to_char(p_line_rec.header_id) AND
4836: orig_sys_line_ref = to_char(p_line_rec.line_id) AND
4837: retrobill_request_id IS NOT NULL;

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 6103: SELECT OE_ORDER_LINES_S.NEXTVAL

6099: --
6100: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6101: --
6102: BEGIN
6103: SELECT OE_ORDER_LINES_S.NEXTVAL
6104: INTO x_line_id
6105: FROM DUAL;
6106:
6107: SELECT NVL(MAX(LINE_NUMBER)+1,1)

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)

Line 6115: FROM OE_ORDER_LINES

6111: l_line_number:=x_line_number;
6112: IF x_line_number IS NOT NULL THEN
6113: SELECT NVL(MAX(SHIPMENT_NUMBER)+1,1)
6114: INTO x_shipment_number
6115: FROM OE_ORDER_LINES
6116: WHERE HEADER_ID = p_header_id
6117: AND LINE_NUMBER = l_line_number;
6118: END IF;
6119: