QP Modifier Details

Description
Categories: BI Publisher, Sales
Application: Advanced Pricing
Source: Modifier Details (XML)
Short Name: QPXPRMLS_XML
DB package: QP_QPXPRMLS_XMLP_PKG
SELECT a.list_line_id,a.list_header_id list_header_id2,a.list_line_type_code,a.list_line_type,a.start_date_active,a.end_date_active,
                          a.automatic_flag,a.modifier_level,a.price_break_type,a.arithmetic_operator_type,
                          a.override_flag,a.print_on_invoice_flag,a.formula,a.incompatibility_grp,
                          a.list_line_no,a.pricing_phase,a.estim_gl_value,a.proration_type,
                          a.pricing_group_sequence,a.operand,a.accrual_flag,a.charge_name,a.include_on_returns_flag,
                          a.related_item,a.substitution_attribute,a.substitution_value,a.charge_subtype_code,
                          a.expiration_date,a.expiration_period_start_date,a.number_expiration_periods,
                          a.expiration_period_uom,a.benefit_qty,a.benefit_uom_code,a.estim_accrual_rate,
                          a.accrual_conversion_rate,a.product_precedence,product_attribute_type,product_attr_value,
                          a.pricing_attr_value_from,a.pricing_attr_value_to,a.pricing_attribute,a.product_uom_code,
                          a.comparison_operator_code ,a.net_amount_flag, a.accum_attribute,
                QP_QPXPRMLS_XMLP_PKG.cf_net_amount_calcformula(a.net_amount_flag) CF_NET_AMOUNT_CALC,
                QP_QPXPRMLS_XMLP_PKG.cf_coup_list_lineformula(a.list_line_id) CF_coup_list_line
            FROM   qp_modifier_summary_v a
            WHERE a.list_line_type_code IN ('DIS', 'OID', 'TSN', 'CIE', 'PBH', 'IUE', 'SUR', 'FREIGHT_CHARGE', 'PRG') AND      NOT EXISTS (SELECT NULL
                                                  FROM qp_rltd_modifiers q
                                                 WHERE a.list_line_id  = q.to_rltd_modifier_id
                                                  )
            &LP_ACTIVE_MODIFIER_LINES_ONLY
             and a.list_header_id = :list_header_id10
            ORDER BY a.list_line_no
Parameter Name SQL text Validation
Responsibility Id
 
Number
User Name
 
Price List
 
LOV Oracle
Customer Class
 
LOV Oracle
Customer Name
 
LOV Oracle
Item Category
 
LOV Oracle
Item Name
 
LOV Oracle
Qualifier Attibute Value To
 
LOV Oracle
Qualifier Attibute Value From
 
LOV Oracle
Qualifier Context
 
LOV Oracle
Active Modifier Lines Only
 
LOV Oracle
Active Modifier Only
 
LOV Oracle
End Date Active
 
Date
Start Date Active
 
Date
Modifier Version To
 
LOV Oracle
Modifier Version From
 
LOV Oracle
Modifier Name To
 
LOV Oracle
Modifier Name From
 
LOV Oracle
Modifier Number To
 
LOV Oracle
Modifier Number From
 
LOV Oracle