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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: QP.QP_DISCOUNT_MAPPING

Object Details

Object Name:	QP_DISCOUNT_MAPPING
Object Type:	TABLE
Owner:	QP
FND Design Data:	QP.QP_DISCOUNT_MAPPING
Subobject Name:
Status:	VALID

Used for upgrade purposes. QP_DISCOUNT_MAPPING table stores mapping information between the obsolete Order Entry pricing tables and the new pricing tables.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QP_DISCOUNT_MAPPING_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OLD_DISCOUNT_ID OLD_DISCOUNT_LINE_ID

Columns

Name	Datatype	Length	Comments
OLD_DISCOUNT_ID	NUMBER		Identifier for discount in SO_DISCOUNTS
OLD_DISCOUNT_LINE_ID	NUMBER		Identifier for discount line in SO_DISCOUNT_LINES
NEW_LIST_HEADER_ID	NUMBER		Identifier for List Header ID in QP_LIST_HEADERS_B
NEW_LIST_LINE_ID	NUMBER		Identifier for List Line in QP_LIST_LINES
OLD_PRICE_BREAK_LINES_LOW	NUMBER		Low value for price break from so_price_break_lines
OLD_PRICE_BREAK_LINES_HIGH	NUMBER		High value for price break from so_price_break_lines
OLD_METHOD_TYPE_CODE	VARCHAR2	(30)	Method Type Code from SO_PRICE_BREAK_LINES
OLD_PRICE_BREAK_PERCENT	NUMBER		Price Break Percent from SO_PRICE_BREAK_LINES
OLD_PRICE_BREAK_PRICE	NUMBER		Price Break Price from SO_PRICE_BREAK_LINES
OLD_PRICE_BREAK_AMOUNT	NUMBER		Price Break Amount from SO_PRICE_BREAK_LINES
NEW_TYPE	VARCHAR2	(1)	New Type which indicates whether it is an Order, Line or Price Break
PRICING_CONTEXT	VARCHAR2	(30)	Context in the Pricing descriptive flexfield

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

QP.QP_DISCOUNT_MAPPING does not reference any database object

QP.QP_DISCOUNT_MAPPING is referenced by following:

QP: QP_DISCOUNT_MAPPING#