VIEW: APPS.QP_FORMULA_STEP_VALUES_TMP

Source

View Text - Preformatted

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 QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N' and REQUEST_ID = nvl(SYS_CONTEXT('QP_CONTEXT','REQUEST_ID'),1) UNION ALL 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_INT_FML_STEP_VALS_T QFT WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y' and REQUEST_ID = nvl(SYS_CONTEXT('QP_CONTEXT','REQUEST_ID'), -9999)

View Text - HTML Formatted

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 QP_JAVA_ENGINE_UTIL_PUB.JAVA_ENGINE_RUNNING = 'N'
AND REQUEST_ID = NVL(SYS_CONTEXT('QP_CONTEXT'
, 'REQUEST_ID')
, 1) UNION ALL 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_INT_FML_STEP_VALS_T QFT
WHERE QP_JAVA_ENGINE_UTIL_PUB.JAVA_ENGINE_RUNNING = 'Y'
AND REQUEST_ID = NVL(SYS_CONTEXT('QP_CONTEXT'
, 'REQUEST_ID')
, -9999)