DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.QP_DEBUG_FORMULA_STEP_VALUES_V

Object Details
Object Name: QP_DEBUG_FORMULA_STEP_VALUES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewQP.QP_DEBUG_FORMULA_STEP_VALUES_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 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.
Query Text

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;

Dependencies

[top of page]

APPS.QP_DEBUG_FORMULA_STEP_VALUES_V references the following:

SchemaAPPS
SynonymQP_DEBUG_FORMULA_STEP_VALUES
SynonymQP_PRICE_FORMULAS_B

APPS.QP_DEBUG_FORMULA_STEP_VALUES_V is not referenced by any database object