DBA Data[Home] [Help]

APPS.OE_PARTY_TOTALS dependencies on OE_PRICE_ADJUSTMENTS

Line 81: FROM oe_price_adjustments p,

77: DECODE(P.ARITHMETIC_OPERATOR, 'LUMPSUM',
78: P.OPERAND,
79: (L.ORDERED_QUANTITY*P.ADJUSTED_AMOUNT))
80: )))
81: FROM oe_price_adjustments p,
82: oe_order_lines_all l
83: WHERE p.header_id = p_header_id
84: AND p.list_line_type_code = 'FREIGHT_CHARGE'
85: AND p.applied_flag = 'Y'