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 644: FROM OE_PRICE_ADJUSTMENTS P

640: DECODE(P.CREDIT_OR_CHARGE_FLAG,'C',-P.OPERAND,P.OPERAND), OE_ORDER_UTIL.G_Precision
641: )
642: )
643: INTO l_chgs_wo_line_id
644: FROM OE_PRICE_ADJUSTMENTS P
645: WHERE P.HEADER_ID = p_header_id
646: AND P.LINE_ID IS NULL
647: AND P.LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'
648: AND P.APPLIED_FLAG = 'Y'

Line 678: FROM OE_PRICE_ADJUSTMENTS P,

674: ,OE_ORDER_UTIL.G_Precision
675: )
676: )
677: INTO l_chgs_w_line_id
678: FROM OE_PRICE_ADJUSTMENTS P,
679: OE_ORDER_LINES_ALL L
680: WHERE P.HEADER_ID = p_header_id
681: AND P.LINE_ID = L.LINE_ID
682: AND P.LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'

Line 1401: FROM OE_PRICE_ADJUSTMENTS P,

1397: )
1398: ,OE_ORDER_UTIL.G_Precision)
1399: )
1400: INTO x_charges
1401: FROM OE_PRICE_ADJUSTMENTS P,
1402: OE_ORDER_LINES_ALL L
1403: WHERE P.HEADER_ID = p_header_id
1404: AND P.LINE_ID = L.LINE_ID
1405: AND nvl(L.CHARGE_PERIODICITY_CODE,'ONE') = l_code

Line 1484: FROM oe_price_adjustments

1480: ELSE
1481: IF p_header_id IS NULL THEN
1482: BEGIN
1483: SELECT header_id INTO l_header_id
1484: FROM oe_price_adjustments
1485: WHERE price_adjustment_id = p_price_adjustment_id;
1486:
1487: IF l_header_id IS NULL THEN
1488: RETURN;