DBA Data[Home] [Help]

VIEW: APPS.QP_DEBUG_FORMULA_STEP_VALUES_V

Source

View Text - Preformatted

SELECT a.ROWID ROW_ID, a.REQUEST_ID, a.PRICE_FORMULA_ID, a.STEP_NUMBER, a.COMPONENT_VALUE, a.PRICE_FORMULA_LINE_TYPE_CODE, a.LINE_INDEX, a.LIST_LINE_TYPE_CODE, a.LIST_HEADER_ID, a.LIST_LINE_ID, b.FORMULA FROM QP_DEBUG_FORMULA_STEP_VALUES a, QP_PRICE_FORMULAS_B b WHERE a.PRICE_FORMULA_ID = b.PRICE_FORMULA_ID
View Text - HTML Formatted

SELECT A.ROWID ROW_ID
, A.REQUEST_ID
, A.PRICE_FORMULA_ID
, A.STEP_NUMBER
, A.COMPONENT_VALUE
, A.PRICE_FORMULA_LINE_TYPE_CODE
, A.LINE_INDEX
, A.LIST_LINE_TYPE_CODE
, A.LIST_HEADER_ID
, A.LIST_LINE_ID
, B.FORMULA
FROM QP_DEBUG_FORMULA_STEP_VALUES A
, QP_PRICE_FORMULAS_B B
WHERE A.PRICE_FORMULA_ID = B.PRICE_FORMULA_ID