QP Modifier Details

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Modifier Details Report for QP
Application: Advanced Pricing
Source: Modifier Details (XML)
Short Name: QPXPRMLS_XML
DB package: QP_QPXPRMLS_XMLP_PKG
Run QP Modifier Details and other Oracle EBS reports with Blitz Report™ on our demo environment
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