APPS.OE_OE_TOTALS_SUMMARY dependencies on OE_PRICE_ADJUSTMENTS

Line 51: FROM oe_price_adjustments opa

47: '%', opa.operand*ool.unit_list_price/100,
48: 'AMT',opa.operand,
49: 'NEWPRICE',ool.unit_list_price - opa.operand)
50: INTO adj_line_total_order_modifier
51: FROM oe_price_adjustments opa
52: , oe_order_lines_all ool
53: WHERE opa.HEADER_ID = x_header_id
54: and opa.line_id is null
55: and ool.line_id = x_line_id

Line 90: FROM oe_price_adjustments opa

86: '%', opa.operand*ool.unit_list_price/100,
87: 'AMT',opa.operand,
88: 'NEWPRICE',ool.unit_list_price - opa.operand) * NVL(ool.ordered_quantity,0)
89: INTO ext_line_tot_order_modifier
90: FROM oe_price_adjustments opa
91: , oe_order_lines_all ool
92: WHERE opa.HEADER_ID = x_header_id
93: and opa.line_id is null
94: and ool.line_id = x_line_id

Line 383: FROM oe_price_adjustments

379:
380: --TaxER start
381: SELECT Sum(Nvl(ROUND(adjusted_amount,OE_ORDER_UTIL.G_Precision),0))
382: INTO l_tax_hdr_chg
383: FROM oe_price_adjustments
384: WHERE header_id=p_header_id
385: AND line_id IS NULL
386: AND list_line_type_code = 'TAX'
387: and applied_flag = 'N' -- added for bug12895421

Line 667: FROM OE_PRICE_ADJUSTMENTS P

663: DECODE(P.CREDIT_OR_CHARGE_FLAG,'C',-P.OPERAND,P.OPERAND), OE_ORDER_UTIL.G_Precision
664: )
665: )
666: INTO l_chgs_wo_line_id
667: FROM OE_PRICE_ADJUSTMENTS P
668: WHERE P.HEADER_ID = p_header_id
669: AND P.LINE_ID IS NULL
670: AND P.LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'
671: AND P.APPLIED_FLAG = 'Y'

Line 701: FROM OE_PRICE_ADJUSTMENTS P,

697: ,OE_ORDER_UTIL.G_Precision
698: )
699: )
700: INTO l_chgs_w_line_id
701: FROM OE_PRICE_ADJUSTMENTS P,
702: OE_ORDER_LINES_ALL L
703: WHERE P.HEADER_ID = p_header_id
704: AND P.LINE_ID = L.LINE_ID
705: AND NVL(L.SERVICE_BILL_OPTION_CODE,'FBOM') = 'FBOM' -- sol_ord_er #16014165

Line 1425: FROM OE_PRICE_ADJUSTMENTS P,

1421: )
1422: ,OE_ORDER_UTIL.G_Precision)
1423: )
1424: INTO x_charges
1425: FROM OE_PRICE_ADJUSTMENTS P,
1426: OE_ORDER_LINES_ALL L
1427: WHERE P.HEADER_ID = p_header_id
1428: AND P.LINE_ID = L.LINE_ID
1429: AND nvl(L.CHARGE_PERIODICITY_CODE,'ONE') = l_code

Line 1508: FROM oe_price_adjustments

1504: ELSE
1505: IF p_header_id IS NULL THEN
1506: BEGIN
1507: SELECT header_id INTO l_header_id
1508: FROM oe_price_adjustments
1509: WHERE price_adjustment_id = p_price_adjustment_id;
1510:
1511: IF l_header_id IS NULL THEN
1512: RETURN;