Product: | XNC - Sales for Communications (Obsolete) |
---|---|
Description: | XNC_PRICE_ADJ_V retrieves price adjustments applied to an order line. |
Implementation/DBA Data: | Not implemented in this database |
SELECT OE.ROW_ID
, OE.PRICE_ADJUSTMENT_ID
, OE.HEADER_ID ORDER_HEADER_ID
, OE.LINE_ID ORDER_LINE_ID
, OE.AUTOMATIC_FLAG
, OE.LIST_HEADER_ID
, OE.LIST_LINE_ID
, OE.ADJUSTMENT_NAME MODIFIER_NAME
, OE.ADJUSTMENT_DESCRIPTION MODIFIER_DESCRIPTION
, OE.ADJUSTMENT_TYPE_CODE MODIFIER_TYPE_CODE
, OE.OVERRIDE_ALLOWED_FLAG
, OE.OPERAND AMOUNT
, OE.ARITHMETIC_OPERATOR OPERATOR
, OE.ADJUSTED_AMOUNT
FROM OE_PRICE_ADJUSTMENTS_V OE
WHERE OE.APPLIED_FLAG = 'Y'
AND OE.ADJUSTMENT_TYPE_CODE = 'DIS'