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: QP.QP_DISCOUNT_MAPPING#

Source

View Text - Preformatted


select OLD_DISCOUNT_ID OLD_DISCOUNT_ID, OLD_DISCOUNT_LINE_ID OLD_DISCOUNT_LINE_ID, NEW_LIST_HEADER_ID NEW_LIST_HEADER_ID, NEW_LIST_LINE_ID NEW_LIST_LINE_ID, OLD_PRICE_BREAK_LINES_LOW OLD_PRICE_BREAK_LINES_LOW, OLD_PRICE_BREAK_LINES_HIGH OLD_PRICE_BREAK_LINES_HIGH, OLD_METHOD_TYPE_CODE OLD_METHOD_TYPE_CODE, OLD_PRICE_BREAK_PERCENT OLD_PRICE_BREAK_PERCENT, OLD_PRICE_BREAK_PRICE OLD_PRICE_BREAK_PRICE, OLD_PRICE_BREAK_AMOUNT OLD_PRICE_BREAK_AMOUNT, NEW_TYPE NEW_TYPE, PRICING_CONTEXT PRICING_CONTEXT from "QP"."QP_DISCOUNT_MAPPING"

View Text - HTML Formatted

SELECT OLD_DISCOUNT_ID OLD_DISCOUNT_ID
, OLD_DISCOUNT_LINE_ID OLD_DISCOUNT_LINE_ID
, NEW_LIST_HEADER_ID NEW_LIST_HEADER_ID
, NEW_LIST_LINE_ID NEW_LIST_LINE_ID
, OLD_PRICE_BREAK_LINES_LOW OLD_PRICE_BREAK_LINES_LOW
, OLD_PRICE_BREAK_LINES_HIGH OLD_PRICE_BREAK_LINES_HIGH
, OLD_METHOD_TYPE_CODE OLD_METHOD_TYPE_CODE
, OLD_PRICE_BREAK_PERCENT OLD_PRICE_BREAK_PERCENT
, OLD_PRICE_BREAK_PRICE OLD_PRICE_BREAK_PRICE
, OLD_PRICE_BREAK_AMOUNT OLD_PRICE_BREAK_AMOUNT
, NEW_TYPE NEW_TYPE
, PRICING_CONTEXT PRICING_CONTEXT
FROM "QP"."QP_DISCOUNT_MAPPING"