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_DEBUG_FORMULA_STEP_VALUES

Object Details

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

This table contains information about the formula step values which are inserted into the table QP_FORMULA_STEP_VALUES. The step values are inserted into the table during the evaluation of formula attached to the price lists.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QP_DEBUG_FORM_STEP_VALUES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID LINE_INDEX

Columns

Name	Datatype	Length	Mandatory	Comments
REQUEST_ID	NUMBER		Yes	Request Id is the sequence number to uniquely identify the Debug Requests.
PRICE_FORMULA_ID	NUMBER			Unique Identifier for the Pricing Formula.
STEP_NUMBER	NUMBER			Step number corresponding to a formula line.
COMPONENT_VALUE	NUMBER			Evaluated value of a formula step.
PRICE_FORMULA_LINE_TYPE_CODE	VARCHAR2	(10)		Type of the formula line. Possible values are: FUNC - Function, LP - List Price, ML - Factor List, MV - Modifier Value, NUM - Numeric Constant, PLL - Price List Line, PRA - Pricing Attribute
LINE_INDEX	NUMBER			PL/SQL unique identifier for request line.
LIST_LINE_TYPE_CODE	VARCHAR2	(30)		Line type of the list line used to update the pricing line.
LIST_HEADER_ID	NUMBER			Identifies the List Header.
LIST_LINE_ID	NUMBER			Identifies the List Line.

Query Text

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


SELECT REQUEST_ID
,      PRICE_FORMULA_ID
,      STEP_NUMBER
,      COMPONENT_VALUE
,      PRICE_FORMULA_LINE_TYPE_CODE
,      LINE_INDEX
,      LIST_LINE_TYPE_CODE
,      LIST_HEADER_ID
,      LIST_LINE_ID
FROM QP.QP_DEBUG_FORMULA_STEP_VALUES;

Dependencies

[top of page]

QP.QP_DEBUG_FORMULA_STEP_VALUES does not reference any database object

QP.QP_DEBUG_FORMULA_STEP_VALUES is referenced by following:

QP: QP_DEBUG_FORMULA_STEP_VALUES#