[Home] [Help]
View: QPBV_PRICE_LIST_LINES
Product: | QP - Advanced Pricing |
Description: | This view gives information about Price List lines. |
Implementation/DBA Data: |
APPS.QPBV_PRICE_LIST_LINES
|
View Text
SELECT LL.LIST_HEADER_ID
, LL.PRICE_BY_FORMULA_ID
, LL.GENERATE_USING_FORMULA_ID
, LL.ARITHMETIC_OPERATOR
, LL.OPERAND
, LL.START_DATE_ACTIVE
, LL.END_DATE_ACTIVE
, LL.PRODUCT_PRECEDENCE
, LL.LIST_LINE_TYPE_CODE
, LL.PRICE_BREAK_TYPE_CODE
, LL.LIST_LINE_ID
, LL.CREATION_DATE
, LL.CREATED_BY
, LL.LAST_UPDATE_DATE
, LL.LAST_UPDATED_BY
FROM QP_LIST_LINES LL
WHERE LL.LIST_LINE_TYPE_CODE = 'PLL'
AND NOT EXISTS ( SELECT 'X'
FROM QP_RLTD_MODIFIERS RLTD WHERE LL.LIST_LINE_ID = RLTD.TO_RLTD_MODIFIER_ID)
Columns
Name |
LIST_HEADER_ID |
PRICE_BY_FORMULA_ID |
GENERATE_USING_FORMULA_ID |
ARITHMETIC_OPERATOR |
OPERAND |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
PRODUCT_PRECEDENCE |
LIST_LINE_TYPE_CODE |
PRICE_BREAK_TYPE_CODE |
LIST_LINE_ID |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |