VIEW: APPS.QP_LINES_SUMMARY_V

Source

View Text - Preformatted

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.list_header_id, 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)

View Text - HTML Formatted

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.LIST_HEADER_ID
, 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)