APPS.OE_LINE_ADJ_UTIL dependencies on OE_ORDER_LINES_ALL

Line 1953: FROM oe_order_lines_all

1949: IF NVL(l_credit_check_rule_rec.incl_freight_charges_flag,'N') = 'Y' THEN
1950: BEGIN
1951: SELECT line_category_code
1952: INTO l_line_category_code
1953: FROM oe_order_lines_all
1954: WHERE line_id = p_x_line_adj_rec.line_id;
1955: EXCEPTION WHEN NO_DATA_FOUND THEN
1956: null;
1957: END;

Line 1973: FROM oe_order_lines_all

1969: ELSIF OE_VERIFY_PAYMENT_PUB.Get_CC_Rev_Reauth_Code( p_x_line_adj_rec.header_id) IS NOT NULL THEN
1970: BEGIN
1971: SELECT line_category_code
1972: INTO l_line_category_code
1973: FROM oe_order_lines_all
1974: WHERE line_id = p_x_line_adj_rec.line_id;
1975: EXCEPTION WHEN NO_DATA_FOUND THEN
1976: null;
1977: END;

Line 2004: FROM oe_order_lines_all

2000: END IF;
2001: BEGIN
2002: SELECT line_category_code
2003: INTO l_line_category_code
2004: FROM oe_order_lines_all
2005: WHERE line_id = p_x_line_adj_rec.line_id;
2006: EXCEPTION WHEN NO_DATA_FOUND THEN
2007: null;
2008: END;

Line 4939: FROM oe_order_lines_all

4935: -- First correct the copy_from line adj record
4936: SELECT ordered_quantity,pricing_quantity
4937: INTO l_ordered_quantity,
4938: l_pricing_quantity
4939: FROM oe_order_lines_all
4940: WHERE line_id = px_line_adj_rec.line_id;
4941:
4942: If (round(abs(px_line_adj_rec.operand) -
4943: abs(l_ordered_quantity * px_line_adj_rec.adjusted_amount/ px_line_adj_rec.operand),20))

Line 4974: FROM oe_order_lines_all

4970:
4971: -- Then correct the copy_to line adj record
4972: SELECT ordered_quantity
4973: INTO l_ordered_quantity
4974: FROM oe_order_lines_all
4975: WHERE line_id = p_to_line_id;
4976:
4977: IF (round(abs(px_line_adj_rec.operand) -
4978: abs(l_ordered_quantity * px_line_adj_rec.adjusted_amount/ px_line_adj_rec.operand),20))

Line 5044: FROM OE_ORDER_LINES_ALL

5040: --RT{
5041: l_ulp NUMBER;
5042: cursor get_ulp(p_line_id IN NUMBER) IS
5043: SELECT UNIT_LIST_PRICE
5044: FROM OE_ORDER_LINES_ALL
5045: WHERE LINE_ID = p_line_id;
5046: l_sign PLS_INTEGER:=1;
5047: l_line_id NUMBER;
5048: l_header_id NUMBER;

Line 5159: FROM oe_price_adjustments prg, oe_order_lines_all l,

5155: oe_debug_pub.ADD('p_line_id :'||p_line_id,1);
5156:
5157: SELECT 'Y'
5158: INTO l_prg_exist
5159: FROM oe_price_adjustments prg, oe_order_lines_all l,
5160: oe_price_adj_assocs a,oe_price_adjustments p
5161: WHERE prg.line_id = p_line_id
5162: AND prg.list_line_type_code = 'PRG'
5163: AND prg.price_adjustment_id = a.price_adjustment_id

Line 5285: from oe_order_lines_all

5281: -- Commented for 7683779 Start
5282: /*
5283: --Added for bug 7328969 Start
5284: select line_category_code into l_from_line_category
5285: from oe_order_lines_all
5286: where line_id = p_line_id ;
5287:
5288: oe_debug_pub.add('p_line_category_code :'||p_line_category_code);
5289: oe_debug_pub.add('l_from_line_category :'||l_from_line_category);

Line 5300: from oe_order_lines_all

5296: If l_Line_Adj_Tbl(i).list_line_type_code ='FREIGHT_CHARGE'
5297: THEN
5298: --Added for bug 7683779 Start
5299: select line_category_code into l_from_line_category
5300: from oe_order_lines_all
5301: where line_id = p_line_id ;
5302:
5303: IF l_debug_level > 0 THEN
5304: oe_debug_pub.add('p_line_category_code :'||p_line_category_code);

Line 5342: from oe_order_lines_all

5338:
5339: /* Added the following code to fix the bug 2888990 */
5340: --Commented for bug 7328969 Start
5341: /*select line_category_code into l_from_line_category
5342: from oe_order_lines_all
5343: where line_id = p_line_id ;*/
5344: --Commented for bug 7328969 End
5345:
5346: if l_from_line_category = 'RETURN' and p_line_category_code = 'ORDER' THEN

Line 5905: oe_order_lines_all line

5901: select adj1.line_id, assoc.rltd_price_adj_id
5902: from oe_price_adjustments adj1,
5903: oe_price_adj_assocs assoc,
5904: oe_price_adjustments adj2,
5905: oe_order_lines_all line
5906: where adj1.price_adjustment_id = assoc.rltd_price_adj_id AND
5907: assoc.price_adjustment_id = adj2.price_adjustment_id AND
5908: adj2.list_line_type_code = 'PRG' AND
5909: adj1.line_id = line.line_id AND /*Added for bug 4018279*/

Line 6789: From oe_order_lines_all

6785: x_line_id_tbl OUT NOCOPY OE_ORDER_ADJ_PVT.Index_TBL_TYPE) IS
6786: Cursor get_service_cur IS
6787: Select line_id,
6788: service_reference_line_id
6789: From oe_order_lines_all
6790: Where header_id = p_header_id
6791: And service_reference_line_id IS NOT NULL;
6792:
6793: Begin

Line 6858: From OE_ORDER_LINES_ALL

6854: l_dummy NUMBER;
6855: Begin
6856: Select line_id
6857: INTO l_dummy
6858: From OE_ORDER_LINES_ALL
6859: Where header_id = p_header_id
6860: AND service_reference_line_id IS NOT NULL
6861: AND rownum = 1;
6862: