View: QPBV_MODIFIER_LINES

Product:	QP - Advanced Pricing
Description:	This view gives information about Discount, Surcharge, Freight and Special Charge, Price Break Header, Other item discount and Promotional goods type of modifier summary lines. These are only 'header' line for a Price Break and 'Buy' line f
Implementation/DBA Data:	APPS.QPBV_MODIFIER_LINES

View Text

SELECT LL.LIST_HEADER_ID
, LL.PRICE_BY_FORMULA_ID
, LL.ARITHMETIC_OPERATOR
, LL.OPERAND
, LL.OVERRIDE_FLAG
, LL.LIST_LINE_NO
, LL.START_DATE_ACTIVE
, LL.END_DATE_ACTIVE
, LL.PRODUCT_PRECEDENCE
, LL.PRIMARY_UOM_FLAG
, LL.PRICING_PHASE_ID
, LL.PRICING_GROUP_SEQUENCE
, LL.INCLUDE_ON_RETURNS_FLAG
, LL.EXPIRATION_PERIOD_START_DATE
, LL.NUMBER_EXPIRATION_PERIODS
, LL.EXPIRATION_PERIOD_UOM
, LL.EXPIRATION_DATE
, LL.ACCRUAL_FLAG
, LL.ESTIM_ACCRUAL_RATE
, LL.REBATE_TRANSACTION_TYPE_CODE
, LL.ACCRUAL_CONVERSION_RATE
, LL.BENEFIT_QTY
, LL.BENEFIT_UOM_CODE
, LL.CHARGE_TYPE_CODE
, LL.CHARGE_SUBTYPE_CODE
, LL.INCOMPATIBILITY_GRP_CODE
, LL.LIST_LINE_TYPE_CODE
, LL.PRICE_BREAK_TYPE_CODE
, LL.MODIFIER_LEVEL_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 IN ('DIS'
, 'SUR'
, 'FREIGHT_CHARGE'
, 'PBH'
, 'OID'
, 'PRG')
AND NOT EXISTS ( SELECT 'X'
FROM QP_RLTD_MODIFIERS RLTD
WHERE LL.LIST_LINE_ID = RLTD.TO_RLTD_MODIFIER_ID ) WITH READ ONLY

Columns