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.

[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