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 117: From OE_ORDER_LINES

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

Line 271: Update Oe_Order_Lines

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

Line 1034: FROM OE_ORDER_LINES_ALL

1030: source_document_line_id, orig_sys_shipment_ref
1031: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1032: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
1033: l_source_document_line_id, l_orig_sys_shipment_ref
1034: FROM OE_ORDER_LINES_ALL
1035: WHERE line_id = l_line_adj_rec.line_id;
1036: EXCEPTION
1037: WHEN NO_DATA_FOUND THEN
1038: l_order_source_id := null;

Line 1086: FROM OE_ORDER_LINES_ALL

1082: source_document_line_id, orig_sys_shipment_ref
1083: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1084: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
1085: l_source_document_line_id, l_orig_sys_shipment_ref
1086: FROM OE_ORDER_LINES_ALL
1087: WHERE line_id = l_old_line_adj_rec.line_id;
1088: EXCEPTION
1089: WHEN NO_DATA_FOUND THEN
1090: l_order_source_id := null;

Line 2903: FROM OE_ORDER_LINES_ALL

2899: source_document_line_id, orig_sys_shipment_ref
2900: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
2901: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
2902: l_source_document_line_id, l_orig_sys_shipment_ref
2903: FROM OE_ORDER_LINES_ALL
2904: WHERE line_id = l_Line_price_att_rec.Line_Id;
2905: EXCEPTION
2906: WHEN NO_DATA_FOUND THEN
2907: l_order_source_id := null;

Line 2955: FROM OE_ORDER_LINES_ALL

2951: source_document_line_id, orig_sys_shipment_ref
2952: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
2953: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
2954: l_source_document_line_id, l_orig_sys_shipment_ref
2955: FROM OE_ORDER_LINES_ALL
2956: WHERE line_id = l_old_Line_price_att_rec.Line_Id;
2957: EXCEPTION
2958: WHEN NO_DATA_FOUND THEN
2959: l_order_source_id := null;

Line 3220: From OE_Order_lines where

3216: */
3217: Begin
3218: Select booked_flag,Shipped_quantity into
3219: l_booked_flag,l_Shipped_quantity
3220: From OE_Order_lines where
3221: Line_id = l_Line_Price_Att_rec.Line_Id;
3222: Exception when no_data_found then
3223: Null;
3224: End;

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

4278: If p_Line_rec.unit_list_price_per_pqty <> FND_API.G_MISS_NUM Then
4279: px_req_line_tbl(l_line_index).UNIT_PRICE := p_Line_rec.unit_list_price_per_pqty;
4280:
4281: -- Fix for bug 1834409
4282: -- Patch 1766558 introduced two new columns in oe_order_lines_all
4283: -- namely, unit_list_price_per_pqty and unit_selling_price_per_pqty
4284: -- So, when adding new order lines to upgraded sales orders,
4285: -- pass the values of unit_list_price and unit_selling_price
4286: -- to pricing engine for the old order lines

Line 6164: exists(select 'x' from oe_order_lines

6160: BEGIN
6161:
6162: Select 'x' into l_dummy
6163: from dual where
6164: exists(select 'x' from oe_order_lines
6165: Where header_id = l_header_id
6166: and calculate_price_flag in ('Y','P')
6167: and item_type_code not in ('CONFIG', 'INCLUDED'));
6168:

Line 6183: exists (select 'x' from oe_order_lines

6179: IF l_completely_frozen = FALSE THEN
6180:
6181: Select 'p' into l_dummy
6182: from dual where
6183: exists (select 'x' from oe_order_lines
6184: where header_id = l_header_id
6185: and calculate_price_flag in ('N', 'P')
6186: and cancelled_flag = 'N'
6187: and item_type_code not in ('CONFIG', 'INCLUDED') );

Line 7343: from oe_price_adjustments opa,oe_order_lines_all ola

7339: Rownum < 2;
7340: */
7341:
7342: Select inventory_item_id into l_inventory_item_id
7343: from oe_price_adjustments opa,oe_order_lines_all ola
7344: where opa.line_id=ola.line_id and
7345: opa.price_adjustment_id=p_price_Adjustment_Id;
7346:
7347: Exception when no_data_found then

Line 7395: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;

7391: i Pls_Integer;
7392: j Pls_Integer;
7393: -- Including variables for bug 1820961 begin
7394: l_first pls_integer;
7395: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
7396: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE;
7397: -- Including variables for bug 1820961 end
7398: l_found_discount_line boolean:=FALSE;
7399: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.

Line 7396: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE;

7392: j Pls_Integer;
7393: -- Including variables for bug 1820961 begin
7394: l_first pls_integer;
7395: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
7396: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE;
7397: -- Including variables for bug 1820961 end
7398: l_found_discount_line boolean:=FALSE;
7399: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
7400: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

Line 7538: from oe_order_lines

7534: if l_first = i then
7535: begin
7536: select nvl(sum(ordered_quantity),0),nvl(sum(pricing_quantity),0)
7537: into l_tot_qty,l_tot_price_qty
7538: from oe_order_lines
7539: where split_from_line_id = l_line_rec.line_id
7540: and header_id = l_line_rec.header_id;
7541: exception
7542: when others then

Line 9292: Update Oe_Order_Lines

9288: --Fix bug 1650637
9289: --If l_line_rec.unit_selling_price Is Not Null or
9290: --l_line_rec.unit_list_price Is Not Null Then
9291: /* Begin
9292: Update Oe_Order_Lines
9293: set Unit_Selling_Price = Null,Unit_list_price = Null
9294: where line_id = l_line_rec.line_id;
9295:
9296: oe_line_adj_util.delete_row(p_line_id => l_line_rec.line_id);

Line 9621: FROM OE_ORDER_LINES_ALL

9617: source_document_line_id, orig_sys_shipment_ref
9618: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
9619: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
9620: l_source_document_line_id, l_orig_sys_shipment_ref
9621: FROM OE_ORDER_LINES_ALL
9622: WHERE line_id = p_req_line_tbl(i).line_id;
9623: EXCEPTION
9624: WHEN NO_DATA_FOUND THEN
9625: l_order_source_id := null;

Line 9986: FROM OE_ORDER_LINES_ALL

9982: source_document_line_id, orig_sys_shipment_ref
9983: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
9984: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
9985: l_source_document_line_id, l_orig_sys_shipment_ref
9986: FROM OE_ORDER_LINES_ALL
9987: WHERE line_id = p_req_line_tbl(p_req_line_detail_tbl(j).line_index).line_id;
9988: EXCEPTION
9989: WHEN NO_DATA_FOUND THEN
9990: l_order_source_id := null;

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

11068:
11069: l_multiple_events VARCHAR2(1);
11070: cursor unfrozen_lines is
11071: select 'x' from dual where
11072: exists (select 'x' from oe_order_lines where header_id = p_header_id
11073: and calculate_price_flag in ('Y','P'));
11074: begin
11075: x_return_status := FND_API.G_RET_STS_SUCCESS;
11076:

Line 11638: From OE_PRICE_ADJUSTMENTS a, OE_ORDER_LINES_ALL b

11634: l_locked_header_rec OE_ORDER_PUB.Header_Rec_Type; --13727700
11635:
11636: cursor has_prg_lines(p_line_id IN NUMBER) is
11637: Select 'Y'
11638: From OE_PRICE_ADJUSTMENTS a, OE_ORDER_LINES_ALL b
11639: Where b.line_id = p_line_id
11640: AND b.header_id = a.header_id
11641: And a.list_line_type_code = 'PRG';
11642:

Line 12036: From OE_PRICE_ADJUSTMENTS a, OE_ORDER_LINES_ALL b

12032: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
12033:
12034: cursor has_prg_lines(p_line_id IN NUMBER) is
12035: Select 'Y'
12036: From OE_PRICE_ADJUSTMENTS a, OE_ORDER_LINES_ALL b
12037: Where b.line_id = p_line_id
12038: AND b.header_id = a.header_id
12039: And a.list_line_type_code = 'PRG';
12040: