eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: XNC_PRICE_ADJ_V

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

View Text

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'

Columns

Name
ROW_ID
PRICE_ADJUSTMENT_ID
ORDER_HEADER_ID
ORDER_LINE_ID
AUTOMATIC_FLAG
LIST_HEADER_ID
LIST_LINE_ID
MODIFIER_NAME
MODIFIER_DESCRIPTION
MODIFIER_TYPE_CODE
OVERRIDE_ALLOWED_FLAG
AMOUNT
OPERATOR
ADJUSTED_AMOUNT