QP Modifier Details

Description
Categories: BI Publisher
Columns: List Line Id, List Header Id2, List Line Type Code, List Line Type, Start Date Active, End Date Active, Automatic Flag, Modifier Level, Price Break Type, Arithmetic Operator Type ...
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
Modifier Number From
 
LOV Oracle
Modifier Number To
 
LOV Oracle
Modifier Name From
 
LOV Oracle
Modifier Name To
 
LOV Oracle
Modifier Version From
 
LOV Oracle
Modifier Version To
 
LOV Oracle
Start Date Active
 
Date
End Date Active
 
Date
Active Modifier Only
 
LOV Oracle
Active Modifier Lines Only
 
LOV Oracle
Qualifier Context
 
LOV Oracle
Qualifier Attibute Value From
 
LOV Oracle
Qualifier Attibute Value To
 
LOV Oracle
Item Name
 
LOV Oracle
Item Category
 
LOV Oracle
Customer Name
 
LOV Oracle
Customer Class
 
LOV Oracle
Price List
 
LOV Oracle
User Name
 
Responsibility Id
 
Number