View: QP_LINES_SUMMARY_V

Product:	QP - Advanced Pricing
Description:	This view is used to display the Modifier Lines summary for a given query criteria in the Pricing Organizer.
Implementation/DBA Data:	APPS.QP_LINES_SUMMARY_V

View Text

SELECT /*+ INDEX(TL QP_LIST_HEADERS_TL_PK) USE_NL(TL
, QL
, QPA) */ TL.NAME
, TL.DESCRIPTION
, QL. LIST_LINE_ID
, QL.CREATION_DATE
, QL.CREATED_BY
, QL.LAST_UPDATE_DATE
, QL.LAST_UPDATED_BY
, QL.LAST_UPDATE_LOGIN
, QL.LIST_HEADER_ID
, QL.LIST_LINE_TYPE_CODE
, QL.START_DATE_ACTIVE
, QL.END_DATE_ACTIVE
, QL.AUTOMATIC_FLAG
, QL.MODIFIER_LEVEL_CODE
, QL.PRICE_BY_FORMULA_ID
, 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.PRICE_BREAK_TYPE_CODE
, QL.NUMBER_EFFECTIVE_PERIODS
, QL.EFFECTIVE_PERIOD_UOM
, QL.ARITHMETIC_OPERATOR
, QL.OPERAND
, QL.OVERRIDE_FLAG
, QL.PRINT_ON_INVOICE_FLAG
, QL.REBATE_TRANSACTION_TYPE_CODE
, QL.BASE_QTY
, QL.BASE_UOM_CODE
, QL.ACCRUAL_QTY
, QL.ACCRUAL_UOM_CODE
, QL.ESTIM_ACCRUAL_RATE
, QL.COMMENTS
, QL.GENERATE_USING_FORMULA_ID
, QL.LIST_LINE_NO
, QL.ESTIM_GL_VALUE
, QL.BENEFIT_PRICE_LIST_LINE_ID
, QL.EXPIRATION_PERIOD_START_DATE
, QL.NUMBER_EXPIRATION_PERIODS
, QL.EXPIRATION_PERIOD_UOM
, QL.EXPIRATION_DATE
, QL.ACCRUAL_FLAG
, QL.PRICING_PHASE_ID
, QL.PRICING_GROUP_SEQUENCE
, QL.INCOMPATIBILITY_GRP_CODE
, QL.PRODUCT_PRECEDENCE
, QL.PRORATION_TYPE_CODE
, QL.ACCRUAL_CONVERSION_RATE
, QL.BENEFIT_QTY
, QL.BENEFIT_UOM_CODE
, QL.RECURRING_FLAG
, QL.BENEFIT_LIMIT
, QL.CHARGE_TYPE_CODE
, QL.CHARGE_SUBTYPE_CODE
, QL.INCLUDE_ON_RETURNS_FLAG
, QL.QUALIFICATION_IND
, QPA.EXCLUDER_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.COMPARISON_OPERATOR_CODE
, QP_QP_FORM_PRICING_ATTR.GET_MEANING(QL.MODIFIER_LEVEL_CODE
, 'MODIFIER_LEVEL_CODE')
, QP_QP_FORM_PRICING_ATTR.GET_MEANING(QL.LIST_LINE_TYPE_CODE
, 'LIST_LINE_TYPE_CODE')
, QP_QP_FORM_PRICING_ATTR.GET_PRICING_PHASE(QL.PRICING_PHASE_ID)
, QP_QP_FORM_PRICING_ATTR.GET_MEANING(QL.INCOMPATIBILITY_GRP_CODE
, 'INCOMPATIBILITY_GROUPS')
, QP_QP_FORM_PRICING_ATTR.GET_MEANING(QL.PRICE_BREAK_TYPE_CODE
, 'PRICE_BREAK_TYPE_CODE')
, QP_QP_FORM_PRICING_ATTR.GET_CHARGE_NAME(QL.CHARGE_TYPE_CODE
, QL.CHARGE_SUBTYPE_CODE
, QL.LIST_LINE_TYPE_CODE)
, QP_QP_FORM_PRICING_ATTR.GET_FORMULA(QL.PRICE_BY_FORMULA_ID)
, QP_QP_FORM_PRICING_ATTR.GET_MEANING(QL.ARITHMETIC_OPERATOR
, 'ARITHMETIC_OPERATOR')
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE('QP_ATTR_DEFNS_QUALIFIER'
, QL.SUBSTITUTION_CONTEXT
, QL.SUBSTITUTION_ATTRIBUTE)
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE_VALUE('QP_ATTR_DEFNS_QUALIFIER'
, QL.SUBSTITUTION_CONTEXT
, QL.SUBSTITUTION_ATTRIBUTE
, QL.SUBSTITUTION_VALUE)
, QP_PRICE_LIST_LINE_UTIL.GET_PRODUCT_VALUE('QP_ATTR_DEFNS_PRICING'
, 'ITEM'
, 'PRICING_ATTRIBUTE1'
, QL.RELATED_ITEM_ID)
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE('QP_ATTR_DEFNS_PRICING'
, QPA.PRODUCT_ATTRIBUTE_CONTEXT
, QPA.PRODUCT_ATTRIBUTE)
, QP_PRICE_LIST_LINE_UTIL.GET_PRODUCT_VALUE('QP_ATTR_DEFNS_PRICING'
, QPA.PRODUCT_ATTRIBUTE_CONTEXT
, QPA.PRODUCT_ATTRIBUTE
, QPA.PRODUCT_ATTR_VALUE)
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE('QP_ATTR_DEFNS_PRICING'
, QPA.PRICING_ATTRIBUTE_CONTEXT
, QPA.PRICING_ATTRIBUTE)
, FND_USER_AP_PKG.GET_USER_NAME(QL.LAST_UPDATED_BY)
FROM QP_LIST_HEADERS_TL TL
, QP_LIST_LINES QL
, QP_PRICING_ATTRIBUTES QPA
WHERE TL.LIST_HEADER_ID = QL.LIST_HEADER_ID
AND TL.LANGUAGE = USERENV('LANG')
AND QL.PRICING_PHASE_ID > 1
AND QL.QUALIFICATION_IND IN (0
, 2
, 4
, 6
, 8
, 10
, 12
, 14
, 16
, 18
, 20
, 22
, 24
, 26
, 28
, 30
, 32)
AND QL.LIST_LINE_ID = QPA.LIST_LINE_ID(+)
AND (QPA.PRICING_ATTRIBUTE_CONTEXT = 'VOLUME' OR QPA.PRICING_ATTRIBUTE_CONTEXT IS NULL)

Columns