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.QPFV_MODIFIER_LINES |
SELECT LL.LIST_HEADER_ID
, LL.PRICE_BY_FORMULA_ID
, 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.EXPIRATION_PERIOD_START_DATE
, LL.NUMBER_EXPIRATION_PERIODS
, LL.EXPIRATION_DATE
, LL.ACCRUAL_FLAG
, LL.ESTIM_ACCRUAL_RATE
, LL.ACCRUAL_CONVERSION_RATE
, LL.BENEFIT_QTY
, LL.BENEFIT_UOM_CODE
, MTL1.UNIT_OF_MEASURE
, LL.PRICING_GROUP_SEQUENCE
, '_LA:LL.PRICING_GROUP_SEQUENCE:QP_LOOKUPS:PRICING_GROUP_SEQUENCE:MEANING'
, LL.ARITHMETIC_OPERATOR
, '_LA:LL.ARITHMETIC_OPERATOR:QP_LOOKUPS:ARITHMETIC_OPERATOR:MEANING'
, LL.EXPIRATION_PERIOD_UOM
, MTL2.UNIT_OF_MEASURE
, LL.REBATE_TRANSACTION_TYPE_CODE
, '_LA:LL.REBATE_TRANSACTION_TYPE_CODE:QP_LOOKUPS:REBATE_TRANSACTION_TYPE_CODE:MEANING'
, LL.CHARGE_TYPE_CODE
, '_LA:LL.CHARGE_TYPE_CODE:QP_LOOKUPS:FREIGHT_CHARGES_TYPE:MEANING'
, LL.CHARGE_SUBTYPE_CODE
, LL.INCOMPATIBILITY_GRP_CODE
, '_LA:LL.INCOMPATIBILITY_GRP_CODE:QP_LOOKUPS:INCOMPATIBILITY_GROUPS:MEANING'
, LL.LIST_LINE_TYPE_CODE
, '_LA:LL.LIST_LINE_TYPE_CODE:QP_LOOKUPS:LIST_LINE_TYPE_CODE:MEANING'
, LL.PRICE_BREAK_TYPE_CODE
, '_LA:LL.PRICE_BREAK_TYPE_CODE:QP_LOOKUPS:PRICE_BREAK_TYPE_CODE:MEANING'
, LL.MODIFIER_LEVEL_CODE
, '_LA:LL.MODIFIER_LEVEL_CODE:QP_LOOKUPS:MODIFIER_LEVEL_CODE:MEANING'
, LL.LIST_LINE_ID
, LL.CREATION_DATE
, LL.CREATED_BY
, LL.LAST_UPDATE_DATE
, LL.LAST_UPDATED_BY
, '_DF:QP:QP_LIST_LINES:LL'
FROM QP_LIST_LINES LL
, MTL_UNITS_OF_MEASURE MTL1
, MTL_UNITS_OF_MEASURE MTL2
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 )
AND LL.BENEFIT_UOM_CODE = MTL1.UOM_CODE (+)
AND LL.EXPIRATION_PERIOD_UOM = MTL2.UOM_CODE (+) WITH READ ONLY