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_INT_RLTD_LINES_T

Object Details

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

Permanent table for holding the relationships between request lines and between request lines and request line details. Types of relationships are as follows:
1. PBH_LINE: Relates a price break header to modifier price break lines.
2. SERVICE_LINE: Relates an order line for a service item and its parent, the serviceable item. The pricing engine needs to know this relationship when it must price service items based on a percent of the serviceable item price.
3. GENERATED_LINE: Indicates the lines - both request and detail that a pricing request line or pricing request detail line created.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QP_RLTD_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID LINE_INDEX

Columns

Name	Datatype	Length	Mandatory	Comments
REQUEST_TYPE_CODE	VARCHAR2	(30)		Identifies the transaction system making the pricing request.
LINE_INDEX	NUMBER			Identifier of the request line.
LINE_DETAIL_INDEX	NUMBER			Identifier of the detail line.
RELATIONSHIP_TYPE_CODE	VARCHAR2	(30)		Internal Purposes.
RELATED_LINE_INDEX	NUMBER			Identifier of the parent request line.
RELATED_LINE_DETAIL_INDEX	NUMBER			Identifier of the related request line on QP_PREQ_LDETS_TMP_T.
PRICING_STATUS_CODE	VARCHAR2	(30)		Returned pricing status.
PRICING_STATUS_TEXT	VARCHAR2	(240)		Returned pricing message.
LIST_LINE_ID	NUMBER			Identifier of the list line used to create the pricing line.
RELATED_LIST_LINE_ID	NUMBER			Identifier of the related list line.
RELATED_LIST_LINE_TYPE	VARCHAR2	(30)		Type of related list line.
OPERAND_CALCULATION_CODE	VARCHAR2	(30)		Type of operand. Allowable values are:1. Adjustment percent (for discounts)2. Adjustment amount (for discounts)3. Adjustment New Price (for discounts)4. UNIT_PRICE(for price lists)5. PERCENT_PRICE(for price lists)
OPERAND	NUMBER			Value of pricing request detail line, for example, 10 currency unit list price with 3% discount
PRICING_GROUP_SEQUENCE	NUMBER			Indicates the pricing bucket in which the pricing engine applied this list line.
RELATIONSHIP_TYPE_DETAIL	VARCHAR2	(30)		Relationship type of the detail line.
SETUP_VALUE_FROM	NUMBER			Setup value for product or pricing attribute.
SETUP_VALUE_TO	NUMBER			Return value for Pricing attribute. Populated when the pricing engine returns details of a volume break.
QUALIFIER_VALUE	NUMBER			Internal Purposes.
ADJUSTMENT_AMOUNT	NUMBER			It holds the value of the bucketed adjusted amount for line types like PLL, DIS, SUR etc. For price break (PBH) child lines, the field is populated if the pricing engine derived the value of the request line or request line detail from a price break.
SATISFIED_RANGE_VALUE	NUMBER			Indicates the range for Range breaks.
REQUEST_ID	NUMBER		Yes	Request line identifier distinguishes between any two pricing engine calls.
CREATED_BY	NUMBER	(15)		Standard WHO column
CREATION_DATE	DATE			Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)		Standard WHO column
LAST_UPDATE_DATE	DATE			Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column

Query Text

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


SELECT REQUEST_TYPE_CODE
,      LINE_INDEX
,      LINE_DETAIL_INDEX
,      RELATIONSHIP_TYPE_CODE
,      RELATED_LINE_INDEX
,      RELATED_LINE_DETAIL_INDEX
,      PRICING_STATUS_CODE
,      PRICING_STATUS_TEXT
,      LIST_LINE_ID
,      RELATED_LIST_LINE_ID
,      RELATED_LIST_LINE_TYPE
,      OPERAND_CALCULATION_CODE
,      OPERAND
,      PRICING_GROUP_SEQUENCE
,      RELATIONSHIP_TYPE_DETAIL
,      SETUP_VALUE_FROM
,      SETUP_VALUE_TO
,      QUALIFIER_VALUE
,      ADJUSTMENT_AMOUNT
,      SATISFIED_RANGE_VALUE
,      REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM QP.QP_INT_RLTD_LINES_T;

Dependencies

[top of page]

QP.QP_INT_RLTD_LINES_T does not reference any database object

QP.QP_INT_RLTD_LINES_T is referenced by following:

APPS: QP_INT_RLTD_LINES_T