APPS.OE_LINE_ADJ_UTIL dependencies on OE_ORDER_LINES_ALL

Line 1932: FROM oe_order_lines_all

1928: IF NVL(l_credit_check_rule_rec.incl_freight_charges_flag,'N') = 'Y' THEN
1929: BEGIN
1930: SELECT line_category_code
1931: INTO l_line_category_code
1932: FROM oe_order_lines_all
1933: WHERE line_id = p_x_line_adj_rec.line_id;
1934: EXCEPTION WHEN NO_DATA_FOUND THEN
1935: null;
1936: END;

Line 4861: FROM oe_order_lines_all

4857: -- First correct the copy_from line adj record
4858: SELECT ordered_quantity,pricing_quantity
4859: INTO l_ordered_quantity,
4860: l_pricing_quantity
4861: FROM oe_order_lines_all
4862: WHERE line_id = px_line_adj_rec.line_id;
4863:
4864: If (round(abs(px_line_adj_rec.operand) -
4865: abs(l_ordered_quantity * px_line_adj_rec.adjusted_amount/ px_line_adj_rec.operand),20))

Line 4896: FROM oe_order_lines_all

4892:
4893: -- Then correct the copy_to line adj record
4894: SELECT ordered_quantity
4895: INTO l_ordered_quantity
4896: FROM oe_order_lines_all
4897: WHERE line_id = p_to_line_id;
4898:
4899: IF (round(abs(px_line_adj_rec.operand) -
4900: abs(l_ordered_quantity * px_line_adj_rec.adjusted_amount/ px_line_adj_rec.operand),20))

Line 4966: FROM OE_ORDER_LINES_ALL

4962: --RT{
4963: l_ulp NUMBER;
4964: cursor get_ulp(p_line_id IN NUMBER) IS
4965: SELECT UNIT_LIST_PRICE
4966: FROM OE_ORDER_LINES_ALL
4967: WHERE LINE_ID = p_line_id;
4968: l_sign PLS_INTEGER:=1;
4969: l_line_id NUMBER;
4970: l_header_id NUMBER;

Line 5180: from oe_order_lines_all

5176: -- Commented for 7683779 Start
5177: /*
5178: --Added for bug 7328969 Start
5179: select line_category_code into l_from_line_category
5180: from oe_order_lines_all
5181: where line_id = p_line_id ;
5182:
5183: oe_debug_pub.add('p_line_category_code :'||p_line_category_code);
5184: oe_debug_pub.add('l_from_line_category :'||l_from_line_category);

Line 5195: from oe_order_lines_all

5191: If l_Line_Adj_Tbl(i).list_line_type_code ='FREIGHT_CHARGE'
5192: THEN
5193: --Added for bug 7683779 Start
5194: select line_category_code into l_from_line_category
5195: from oe_order_lines_all
5196: where line_id = p_line_id ;
5197:
5198: IF l_debug_level > 0 THEN
5199: oe_debug_pub.add('p_line_category_code :'||p_line_category_code);

Line 5237: from oe_order_lines_all

5233:
5234: /* Added the following code to fix the bug 2888990 */
5235: --Commented for bug 7328969 Start
5236: /*select line_category_code into l_from_line_category
5237: from oe_order_lines_all
5238: where line_id = p_line_id ;*/
5239: --Commented for bug 7328969 End
5240:
5241: if l_from_line_category = 'RETURN' and p_line_category_code = 'ORDER' THEN

Line 5697: oe_order_lines_all line

5693: select adj1.line_id, assoc.rltd_price_adj_id
5694: from oe_price_adjustments adj1,
5695: oe_price_adj_assocs assoc,
5696: oe_price_adjustments adj2,
5697: oe_order_lines_all line
5698: where adj1.price_adjustment_id = assoc.rltd_price_adj_id AND
5699: assoc.price_adjustment_id = adj2.price_adjustment_id AND
5700: adj2.list_line_type_code = 'PRG' AND
5701: adj1.line_id = line.line_id AND /*Added for bug 4018279*/

Line 6526: From oe_order_lines_all

6522: x_line_id_tbl OUT NOCOPY OE_ORDER_ADJ_PVT.Index_TBL_TYPE) IS
6523: Cursor get_service_cur IS
6524: Select line_id,
6525: service_reference_line_id
6526: From oe_order_lines_all
6527: Where header_id = p_header_id
6528: And service_reference_line_id IS NOT NULL;
6529:
6530: Begin

Line 6587: From OE_ORDER_LINES_ALL

6583: l_dummy NUMBER;
6584: Begin
6585: Select line_id
6586: INTO l_dummy
6587: From OE_ORDER_LINES_ALL
6588: Where header_id = p_header_id
6589: AND service_reference_line_id IS NOT NULL
6590: AND rownum = 1;
6591: