[Home] [Help]
View: QP_FORMULA_STEP_VALUES_TMP
Product: | QP - Advanced Pricing |
Description: | Based on QP_FORMULA_STEP_VALUES_TMP_T. This view has the information pertaining to the current pricing engine call. |
Implementation/DBA Data: |
APPS.QP_FORMULA_STEP_VALUES_TMP
|
View Text
SELECT QFT.PRICE_FORMULA_ID
, QFT.STEP_NUMBER
, QFT.COMPONENT_VALUE
, QFT.PRICE_FORMULA_LINE_TYPE_CODE
, QFT.LINE_INDEX
, QFT.LIST_LINE_TYPE_CODE
, QFT.LIST_HEADER_ID
, QFT.LIST_LINE_ID
, QFT.REQUEST_ID
FROM QP_FORMULA_STEP_VALUES_TMP_T QFT
WHERE REQUEST_ID = NVL(SYS_CONTEXT('QP_CONTEXT'
, 'REQUEST_ID')
, 1)
Columns
Name |
PRICE_FORMULA_ID |
STEP_NUMBER |
COMPONENT_VALUE |
PRICE_FORMULA_LINE_TYPE_CODE |
LINE_INDEX |
LIST_LINE_TYPE_CODE |
LIST_HEADER_ID |
LIST_LINE_ID |
REQUEST_ID |