QP Qualifier Grouping

Description
Categories: BI Publisher
Application: Advanced Pricing
Source: Qualifier Grouping (XML)
Short Name: QPXPRQFS_XML
DB package: QP_QPXPRQFS_XMLP_PKG
Run QP Qualifier Grouping and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT qualifier_rule_id qualifier_rule_id1,qualifier_grouping_no,qualifier_context,qualifier_attribute,
                          comparision_operator_code,qualifier_attr_value,qualifier_attr_value_to,
                          start_date_active,end_date_active,
                QP_QPXPRQFS_XMLP_PKG.cf_qualifier_contextformula(qualifier_context, qualifier_attribute) CF_qualifier_context,
                QP_QPXPRQFS_XMLP_PKG.cf_qualifier_attr_valueformula(qualifier_context, qualifier_attribute, qualifier_attr_value) CF_qualifier_attr_value,
                QP_QPXPRQFS_XMLP_PKG.cf_qualifier_attr_value_toform(qualifier_context, qualifier_attribute, qualifier_attr_value_to) CF_qualifier_attr_value_to
            FROM    qp_qualifiers_v b
            WHERE  (:P_qualifier_context IS NULL OR
                           b.qualifier_context = :P_qualifier_context)
                AND  (:P_start_date_active IS NULL OR
                           b.start_date_active = :LP_start_date_active)
                AND   (:P_end_date_active IS NULL OR
                           b.end_date_active = :LP_end_date_active)
            &LP_QUALIFIER_ATTR_VALUE_FROM
            &LP_QUALIFIER_ATTR_VALUE_TO
             and qualifier_rule_id=:qualifier_rule_id2
            ORDER BY qualifier_grouping_no,qualifier_context
Parameter Name SQL text Validation
Qualifier Context
 
LOV Oracle
Qualifier Attribute Value From
 
LOV Oracle
Qualifier Attribute Value To
 
LOV Oracle
Start Date Active
 
Date
End Date Active
 
Date
Blitz Report™