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]

VIEW: APPS.QP_DEBUG_REQ_RLTD_LINES_V

Object Details

Object Name:	QP_DEBUG_REQ_RLTD_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	QP.QP_DEBUG_REQ_RLTD_LINES_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
REQUEST_ID	NUMBER		Request Id is the sequence number to uniquely identify the Debug Requests.
REQUEST_TYPE_CODE	VARCHAR2	(30)	Identifies the transaction system making the pricing request.
LINE_INDEX	NUMBER		PL/SQL unique identifier for request line.
LINE_DETAIL_INDEX	NUMBER		PL/SQL unique identifier. Unique identifier of 'request line detail' in calling application.
RELATIONSHIP_TYPE_CODE	VARCHAR2	(30)	Type of relationship between pricing lines. Allowable values are:BUY, GET, PBH_LINE, SERVICE_LINE, GENERATED_LINE, LINE_TO_LINE, LINE_TO_DETAIL,DETAIL_TO_DETAIL, ORDER_TO_LINE, RELATED_ITEM_PRICE.
LIST_HEADER_ID	NUMBER		Identifies the List Header.
LIST_TYPE_CODE	VARCHAR2	(30)	List type of the line used.
LIST_LINE_ID	NUMBER		Identifies the List Line.
LIST_LINE_TYPE_CODE	VARCHAR2	(30)	Line type of the list line used to update the pricing line.
ARITHMETIC_OPERATOR	VARCHAR2	(30)	Type of operand. Allowable values are: Adjustment percent (for discounts), Adjustment amount (for discounts), Adjustment NewPrice (for discounts), UNIT_PRICE (for price lists), PERCENT_PRICE (for price lists), LUMPSUM
OPERAND_VALUE	NUMBER		Value of pricing request detail line, for example, 10 currency unit list price with 3% discount.

Query Text

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


SELECT REQUEST_ID
,      REQUEST_TYPE_CODE
,      LINE_INDEX
,      LINE_DETAIL_INDEX
,      RELATIONSHIP_TYPE_CODE
,      LIST_HEADER_ID
,      LIST_TYPE_CODE
,      LIST_LINE_ID
,      LIST_LINE_TYPE_CODE
,      ARITHMETIC_OPERATOR
,      OPERAND_VALUE
FROM APPS.QP_DEBUG_REQ_RLTD_LINES_V;

Dependencies

[top of page]

APPS.QP_DEBUG_REQ_RLTD_LINES_V references the following:

APPS: QP_DEBUG_REQ_LDETS; QP_DEBUG_REQ_RLTD_LINES

APPS.QP_DEBUG_REQ_RLTD_LINES_V is not referenced by any database object