[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 |