Product: | XNC - Sales for Communications (Obsolete) |
---|---|
Description: | XNC_ASO_PRICEADJ_V retrieves price adjustments available to a quote or quote line. |
Implementation/DBA Data: | Not implemented in this database |
SELECT ASO.ROW_ID
, ASO.PRICE_ADJUSTMENT_ID
, ASO.QUOTE_HEADER_ID
, ASO.QUOTE_LINE_ID
, ASO.MODIFIER_HEADER_ID
, ASO.MODIFIER_LINE_ID
, ASO.AUTOMATIC_FLAG
, ASO.MODIFIER_NAME
, ASO.MODIFIER_DESCRIPTION
, ASO.MODIFIER_LINE_TYPE_CODE
, ASO.UPDATE_ALLOWABLE_FLAG
, ASO.OPERAND
, ASO.ARITHMETIC_OPERATOR
FROM ASO_PRICE_ADJUSTMENTS_V ASO
WHERE APPLIED_FLAG = 'Y'
AND MODIFIER_LINE_TYPE_CODE = 'DIS'