[Home] [Help] [Dependency Information]
Object Name: | QP_DEBUG_FORMULA_STEP_VALUES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | QP.QP_DEBUG_FORMULA_STEP_VALUES_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Internal row identifier. | |
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. | ||
FORMULA | VARCHAR2 | (2000) | Yes | Stores the mathematical formula for a rule. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, 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
, FORMULA
FROM APPS.QP_DEBUG_FORMULA_STEP_VALUES_V;
APPS.QP_DEBUG_FORMULA_STEP_VALUES_V is not referenced by any database object
|
|
|