DBA Data[Home] [Help]

APPS.OE_ORDER_ADJ_PVT dependencies on OE_ORDER_LINES_ALL

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