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_ORDER_ADJ_PVT dependencies on OE_ORDER_LINES

Line 116: From OE_ORDER_LINES

112: header_id,
113: line_category_code,
114: commitment_id,
115: transaction_phase_code --for bug 3108881
116: From OE_ORDER_LINES
117: Where Line_Id = p_line_id;
118:
119: l_qp_unit_price Number;
120: l_qp_adjusted_unit_price Number;

Line 270: Update Oe_Order_Lines

266: END LOOP; -- End of loop to fetch line fields
267:
268: END IF; -- End of check for code release level
269:
270: Update Oe_Order_Lines
271: Set Unit_Selling_Price= l_selling_price,
272: Unit_List_Price = l_unit_price,
273: unit_selling_price_per_pqty = l_qp_adjusted_unit_price,
274: unit_list_price_per_pqty = l_qp_unit_price,

Line 999: FROM OE_ORDER_LINES_ALL

995: source_document_line_id, orig_sys_shipment_ref
996: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
997: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
998: l_source_document_line_id, l_orig_sys_shipment_ref
999: FROM OE_ORDER_LINES_ALL
1000: WHERE line_id = l_line_adj_rec.line_id;
1001: EXCEPTION
1002: WHEN NO_DATA_FOUND THEN
1003: l_order_source_id := null;

Line 1051: FROM OE_ORDER_LINES_ALL

1047: source_document_line_id, orig_sys_shipment_ref
1048: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1049: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
1050: l_source_document_line_id, l_orig_sys_shipment_ref
1051: FROM OE_ORDER_LINES_ALL
1052: WHERE line_id = l_old_line_adj_rec.line_id;
1053: EXCEPTION
1054: WHEN NO_DATA_FOUND THEN
1055: l_order_source_id := null;

Line 2820: FROM OE_ORDER_LINES_ALL

2816: source_document_line_id, orig_sys_shipment_ref
2817: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
2818: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
2819: l_source_document_line_id, l_orig_sys_shipment_ref
2820: FROM OE_ORDER_LINES_ALL
2821: WHERE line_id = l_Line_price_att_rec.Line_Id;
2822: EXCEPTION
2823: WHEN NO_DATA_FOUND THEN
2824: l_order_source_id := null;

Line 2872: FROM OE_ORDER_LINES_ALL

2868: source_document_line_id, orig_sys_shipment_ref
2869: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
2870: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
2871: l_source_document_line_id, l_orig_sys_shipment_ref
2872: FROM OE_ORDER_LINES_ALL
2873: WHERE line_id = l_old_Line_price_att_rec.Line_Id;
2874: EXCEPTION
2875: WHEN NO_DATA_FOUND THEN
2876: l_order_source_id := null;

Line 3137: From OE_Order_lines where

3133: */
3134: Begin
3135: Select booked_flag,Shipped_quantity into
3136: l_booked_flag,l_Shipped_quantity
3137: From OE_Order_lines where
3138: Line_id = l_Line_Price_Att_rec.Line_Id;
3139: Exception when no_data_found then
3140: Null;
3141: End;

Line 4199: -- Patch 1766558 introduced two new columns in oe_order_lines_all

4195: If p_Line_rec.unit_list_price_per_pqty <> FND_API.G_MISS_NUM Then
4196: px_req_line_tbl(l_line_index).UNIT_PRICE := p_Line_rec.unit_list_price_per_pqty;
4197:
4198: -- Fix for bug 1834409
4199: -- Patch 1766558 introduced two new columns in oe_order_lines_all
4200: -- namely, unit_list_price_per_pqty and unit_selling_price_per_pqty
4201: -- So, when adding new order lines to upgraded sales orders,
4202: -- pass the values of unit_list_price and unit_selling_price
4203: -- to pricing engine for the old order lines

Line 6073: exists(select 'x' from oe_order_lines

6069: BEGIN
6070:
6071: Select 'x' into l_dummy
6072: from dual where
6073: exists(select 'x' from oe_order_lines
6074: Where header_id = l_header_id
6075: and calculate_price_flag in ('Y','P')
6076: and item_type_code not in ('CONFIG', 'INCLUDED'));
6077:

Line 6092: exists (select 'x' from oe_order_lines

6088: IF l_completely_frozen = FALSE THEN
6089:
6090: Select 'p' into l_dummy
6091: from dual where
6092: exists (select 'x' from oe_order_lines
6093: where header_id = l_header_id
6094: and calculate_price_flag in ('N', 'P')
6095: and cancelled_flag = 'N'
6096: and item_type_code not in ('CONFIG', 'INCLUDED') );

Line 7251: from oe_price_adjustments opa,oe_order_lines_all ola

7247: Rownum < 2;
7248: */
7249:
7250: Select inventory_item_id into l_inventory_item_id
7251: from oe_price_adjustments opa,oe_order_lines_all ola
7252: where opa.line_id=ola.line_id and
7253: opa.price_adjustment_id=p_price_Adjustment_Id;
7254:
7255: Exception when no_data_found then

Line 7303: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;

7299: i Pls_Integer;
7300: j Pls_Integer;
7301: -- Including variables for bug 1820961 begin
7302: l_first pls_integer;
7303: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
7304: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE;
7305: -- Including variables for bug 1820961 end
7306: l_found_discount_line boolean:=FALSE;
7307: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.

Line 7304: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE;

7300: j Pls_Integer;
7301: -- Including variables for bug 1820961 begin
7302: l_first pls_integer;
7303: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
7304: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE;
7305: -- Including variables for bug 1820961 end
7306: l_found_discount_line boolean:=FALSE;
7307: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
7308: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

Line 7446: from oe_order_lines

7442: if l_first = i then
7443: begin
7444: select nvl(sum(ordered_quantity),0),nvl(sum(pricing_quantity),0)
7445: into l_tot_qty,l_tot_price_qty
7446: from oe_order_lines
7447: where split_from_line_id = l_line_rec.line_id
7448: and header_id = l_line_rec.header_id;
7449: exception
7450: when others then

Line 9201: Update Oe_Order_Lines

9197: --Fix bug 1650637
9198: --If l_line_rec.unit_selling_price Is Not Null or
9199: --l_line_rec.unit_list_price Is Not Null Then
9200: /* Begin
9201: Update Oe_Order_Lines
9202: set Unit_Selling_Price = Null,Unit_list_price = Null
9203: where line_id = l_line_rec.line_id;
9204:
9205: oe_line_adj_util.delete_row(p_line_id => l_line_rec.line_id);

Line 9530: FROM OE_ORDER_LINES_ALL

9526: source_document_line_id, orig_sys_shipment_ref
9527: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
9528: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
9529: l_source_document_line_id, l_orig_sys_shipment_ref
9530: FROM OE_ORDER_LINES_ALL
9531: WHERE line_id = p_req_line_tbl(i).line_id;
9532: EXCEPTION
9533: WHEN NO_DATA_FOUND THEN
9534: l_order_source_id := null;

Line 9895: FROM OE_ORDER_LINES_ALL

9891: source_document_line_id, orig_sys_shipment_ref
9892: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
9893: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
9894: l_source_document_line_id, l_orig_sys_shipment_ref
9895: FROM OE_ORDER_LINES_ALL
9896: WHERE line_id = p_req_line_tbl(p_req_line_detail_tbl(j).line_index).line_id;
9897: EXCEPTION
9898: WHEN NO_DATA_FOUND THEN
9899: l_order_source_id := null;

Line 10964: exists (select 'x' from oe_order_lines where header_id = p_header_id

10960:
10961: l_multiple_events VARCHAR2(1);
10962: cursor unfrozen_lines is
10963: select 'x' from dual where
10964: exists (select 'x' from oe_order_lines where header_id = p_header_id
10965: and calculate_price_flag in ('Y','P'));
10966: begin
10967: x_return_status := FND_API.G_RET_STS_SUCCESS;
10968:

Line 11529: From OE_PRICE_ADJUSTMENTS a, OE_ORDER_LINES_ALL b

11525: l_prev_line_hdr_id Number;
11526:
11527: cursor has_prg_lines(p_line_id IN NUMBER) is
11528: Select 'Y'
11529: From OE_PRICE_ADJUSTMENTS a, OE_ORDER_LINES_ALL b
11530: Where b.line_id = p_line_id
11531: AND b.header_id = a.header_id
11532: And a.list_line_type_code = 'PRG';
11533:

Line 11896: From OE_PRICE_ADJUSTMENTS a, OE_ORDER_LINES_ALL b

11892: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
11893:
11894: cursor has_prg_lines(p_line_id IN NUMBER) is
11895: Select 'Y'
11896: From OE_PRICE_ADJUSTMENTS a, OE_ORDER_LINES_ALL b
11897: Where b.line_id = p_line_id
11898: AND b.header_id = a.header_id
11899: And a.list_line_type_code = 'PRG';
11900: