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_RLTD_MODIFIERS

Object Details

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

QP_RLTD_MODIFIERS stores the relationship between modifier lines. There are different types of relationships defined between modifier lines based on lookup type RLTD_MODIFIER_GRP_TYPE :
.
QUALIFIER : a qualifying group. Groups modifier lines where any conditions defined by the pricing or qualifier attributes must be met before the benefit or charge can be given.
.
BENEFIT : a benefit group. Groups modifier lines where multiple benefits can be given once the qualifying conditions are met.
.
PRICE BREAK: defines a price break. Groups price or modifier lines that make up a price break and relates them to the parent record, i.e. modifer of type Price Break Header.
.
COUPON: relates a coupon issue modifier to the modifier line which defines the coupon benefit.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QP_RLTD_MODIFIERS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	RLTD_MODIFIER_ID
QP_RLTD_MODIFIERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FROM_RLTD_MODIFIER_ID RLTD_MODIFIER_GRP_TYPE
QP_RLTD_MODIFIERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TO_RLTD_MODIFIER_ID
QP_RLTD_MODIFIERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FROM_RLTD_MODIFIER_ID TO_RLTD_MODIFIER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RLTD_MODIFIER_ID	NUMBER		Yes	Identifies the modifier relationship.
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
RLTD_MODIFIER_GRP_NO	NUMBER		Yes	This defines the 'AND' / 'OR' condition in a qualifier or benefit modifier group. The same group number gives an 'AND' condition. A different grouping number gives an 'OR' condition.
FROM_RLTD_MODIFIER_ID	NUMBER		Yes	Identifies the modifier that the relationship is from.
TO_RLTD_MODIFIER_ID	NUMBER		Yes	Identifies the list line that the relationship is to.
RLTD_MODIFIER_GRP_TYPE	VARCHAR2	(30)		The type of relationship, based on lookup type RLTD_MODIFIER_GRP_TYPE.
CONTEXT	VARCHAR2	(30)		Descriptive Flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive Flexfield segment

Query Text

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


SELECT RLTD_MODIFIER_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      RLTD_MODIFIER_GRP_NO
,      FROM_RLTD_MODIFIER_ID
,      TO_RLTD_MODIFIER_ID
,      RLTD_MODIFIER_GRP_TYPE
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM QP.QP_RLTD_MODIFIERS;

Dependencies

[top of page]

QP.QP_RLTD_MODIFIERS does not reference any database object

QP.QP_RLTD_MODIFIERS is referenced by following:

APPS: QP_RLTD_MODIFIERS