Product: | QP - Advanced Pricing |
---|---|
Description: | Price or Modifier Break lines information. Used by Price List and Modifiers form. |
Implementation/DBA Data: | APPS.QP_PRICE_BREAKS_V |
SELECT QPA.ROWID
, QPA.PRICING_ATTRIBUTE_ID
, QPA.CREATION_DATE
, QPA.CREATED_BY
, QPA.LAST_UPDATE_DATE
, QPA.LAST_UPDATED_BY
, QPA.LAST_UPDATE_LOGIN
, QPA.PROGRAM_APPLICATION_ID
, QPA.PROGRAM_ID PROGRAM_ID
, QPA.PROGRAM_UPDATE_DATE
, QPA.REQUEST_ID
, QPA.LIST_LINE_ID
, QPA.EXCLUDER_FLAG
, QPA.ACCUMULATE_FLAG
, QPA.PRODUCT_ATTRIBUTE_CONTEXT
, QPA.PRODUCT_ATTRIBUTE
, QPA.PRODUCT_ATTR_VALUE
, QPA.PRODUCT_UOM_CODE
, QPA.PRICING_ATTRIBUTE_CONTEXT
, QPA.PRICING_ATTRIBUTE
, QPA.PRICING_ATTR_VALUE_FROM
, QPA.PRICING_ATTR_VALUE_TO
, QPA.ATTRIBUTE_GROUPING_NO
, QL.ARITHMETIC_OPERATOR
, QL.OPERAND
, QL.PRICE_BY_FORMULA_ID
, QL.REBATE_TRANSACTION_TYPE_CODE
, QL.ACCRUAL_QTY
, QL.ACCRUAL_UOM_CODE
, QL.ESTIM_ACCRUAL_RATE
, QL.INVENTORY_ITEM_ID
, QL.ORGANIZATION_ID
, QL.RELATED_ITEM_ID
, QL.RELATIONSHIP_TYPE_ID
, QL.SUBSTITUTION_CONTEXT
, QL.SUBSTITUTION_ATTRIBUTE
, QL.SUBSTITUTION_VALUE
, QL.CONTEXT
, QL.ATTRIBUTE1
, QL.ATTRIBUTE2
, QL.ATTRIBUTE3
, QL.ATTRIBUTE4
, QL.ATTRIBUTE5
, QL.ATTRIBUTE6
, QL.ATTRIBUTE7
, QL.ATTRIBUTE8
, QL.ATTRIBUTE9
, QL.ATTRIBUTE10
, QL.ATTRIBUTE11
, QL.ATTRIBUTE12
, QL.ATTRIBUTE13
, QL.ATTRIBUTE14
, QL.ATTRIBUTE15
, QRM.FROM_RLTD_MODIFIER_ID
, QL.LIST_LINE_TYPE_CODE
, QL.LIST_PRICE
, QL.PRICE_BREAK_TYPE_CODE
, QL.LIST_HEADER_ID
, QL.AUTOMATIC_FLAG
, QL.MODIFIER_LEVEL_CODE
, QL.PRICING_GROUP_SEQUENCE
, QL.START_DATE_ACTIVE
, QL.END_DATE_ACTIVE
, QL.PRODUCT_PRECEDENCE
, QL.LIST_LINE_NO
, QL.OVERRIDE_FLAG
, QL.ACCRUAL_FLAG
, QL.ACCRUAL_CONVERSION_RATE
, QL.PRORATION_TYPE_CODE
, QL.PRICING_PHASE_ID
, QL.BENEFIT_QTY
, QL.BENEFIT_UOM_CODE
, QL.BENEFIT_LIMIT
, QL.INCOMPATIBILITY_GRP_CODE
, QL.PRINT_ON_INVOICE_FLAG
, QL.EXPIRATION_PERIOD_START_DATE
, QL.EXPIRATION_PERIOD_UOM
, QL.NUMBER_EXPIRATION_PERIODS
, QL.EXPIRATION_DATE
, QPA.COMPARISON_OPERATOR_CODE
, QPA.PRODUCT_ATTRIBUTE_DATATYPE
, QPA.PRICING_ATTRIBUTE_DATATYPE
, QL.REVISION_DATE
, QPA.CREATION_DATE
, QPA.CREATED_BY
, QPA.LAST_UPDATE_DATE
, QPA.LAST_UPDATED_BY
, QPA.LAST_UPDATE_LOGIN
, QPA.PROGRAM_APPLICATION_ID
, QPA.PROGRAM_ID
, QPA.PROGRAM_UPDATE_DATE
, QPA.REQUEST_ID
, QPA.CONTEXT
, QPA.ATTRIBUTE1
, QPA.ATTRIBUTE2
, QPA.ATTRIBUTE3
, QPA.ATTRIBUTE4
, QPA.ATTRIBUTE5
, QPA.ATTRIBUTE6
, QPA.ATTRIBUTE7
, QPA.ATTRIBUTE8
, QPA.ATTRIBUTE9
, QPA.ATTRIBUTE10
, QPA.ATTRIBUTE11
, QPA.ATTRIBUTE12
, QPA.ATTRIBUTE13
, QPA.ATTRIBUTE14
, QPA.ATTRIBUTE15
, QL.RECURRING_VALUE
FROM QP_LIST_LINES QL
, QP_PRICING_ATTRIBUTES QPA
, QP_RLTD_MODIFIERS QRM
WHERE QL.LIST_LINE_ID = QPA.LIST_LINE_ID
AND QL.LIST_LINE_TYPE_CODE IN ('SUR'
, 'DIS'
, 'PLL')
AND QRM.TO_RLTD_MODIFIER_ID = QL.LIST_LINE_ID
AND QRM.RLTD_MODIFIER_GRP_TYPE = 'PRICE BREAK'