QP Qualifier Grouping

Description
Categories: BI Publisher
Application: Advanced Pricing
Source: Qualifier Grouping (XML)
Short Name: QPXPRQFS_XML
DB package: QP_QPXPRQFS_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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