QP Qualifier Grouping
Description
Categories: BI Publisher
Application: Advanced Pricing
Source: Qualifier Grouping (XML)
Short Name: QPXPRQFS_XML
DB package: QP_QPXPRQFS_XMLP_PKG
Source: Qualifier Grouping (XML)
Short Name: QPXPRQFS_XML
DB package: QP_QPXPRQFS_XMLP_PKG
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 |