DBA Data[Home] [Help]

APPS.OE_ORDER_ADJ_PVT dependencies on OE_ORDER_LINES_ALL

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 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 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 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 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: