FND Design Data [Home] [Help]

View: QPBV_FORMULA_HEADERS

Product: QP - Advanced Pricing
Description: This gives information about formula headers
Implementation/DBA Data: ViewAPPS.QPBV_FORMULA_HEADERS
View Text

SELECT TL.NAME
, TL.DESCRIPTION
, FR.FORMULA
, FR.START_DATE_ACTIVE
, FR.END_DATE_ACTIVE
, FR.PRICE_FORMULA_ID
, FR.CREATION_DATE
, FR.CREATED_BY
, FR.LAST_UPDATE_DATE
, FR.LAST_UPDATED_BY
FROM QP_PRICE_FORMULAS_B FR
, QP_PRICE_FORMULAS_TL TL
WHERE FR.PRICE_FORMULA_ID = TL.PRICE_FORMULA_ID
AND TL.LANGUAGE = USERENV('LANG')

Columns

Name
NAME
DESCRIPTION
FORMULA
START_DATE_ACTIVE
END_DATE_ACTIVE
PRICE_FORMULA_ID
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY