[Home] [Help]
View: QPBV_FORMULA_HEADERS
Product: | QP - Advanced Pricing |
Description: | This gives information about formula headers |
Implementation/DBA Data: |
APPS.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 |