ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4603869E053B46B63588994 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 Y QP QPXPRQFS_XML AR QP تجميع المعايير Application: التسعير المتقدم Source: تجميع المعايير (XML) Short Name: QPXPRQFS_XML DB package: QP_QPXPRQFS_XMLP_PKG D QP Kriteriengruppen Application: Advanced Pricing Source: Kriteriengruppen (XML) Short Name: QPXPRQFS_XML DB package: QP_QPXPRQFS_XMLP_PKG F QP Regroupement des qualificatifs Application: Advanced Pricing Source: Regroupement des qualificatifs (XML) Short Name: QPXPRQFS_XML DB package: QP_QPXPRQFS_XMLP_PKG US QP Qualifier Grouping Application: Advanced Pricing Source: Qualifier Grouping (XML) Short Name: QPXPRQFS_XML DB package: QP_QPXPRQFS_XMLP_PKG ZHS QP 限定词分组 Application: 高级定价 Source: 限定词分组 (XML) Short Name: QPXPRQFS_XML DB package: QP_QPXPRQFS_XMLP_PKG BI Publisher &lp_qualifier_attr_value_from &lp_qualifier_attr_value_to :lp_end_date_active :lp_qualifier_attr_value_from :lp_qualifier_attr_value_to :lp_start_date_active :p_conc_request_id :p_end_date_active :p_qualifier_attr_value_from :p_qualifier_attr_value_to :p_qualifier_context :p_sob_id :p_start_date_active :qualifier_rule_id2 :rp_company_name :rp_report_name 1 10 :p_qualifier_context LOV Oracle QP_QUALIFIER_CONTEXT Y select context id, context value, description description from qp_qualifier_context_v order by value,description AR سياق المعيار D Kriterienkontext F Contexte du qualificatif US Qualifier Context ZHS 限定词上下文 2 20 :p_qualifier_attr_value_from LOV Oracle QP_QUALIFIER_ATTRIBUTE_FROM Y select qualifier_attr_value id, qualifier_attr_value value, null description from qp_qualifiers_v where qualifier_context=:$flex$.qp_qualifier_context and rowid in (select max(rowid) from qp_qualifiers_v group by qualifier_attr_value) order by value,description AR قيمة سمة المعيار من D Von Kriterienattributwert F Valeur de l'attribut du qualificatif - De US Qualifier Attribute Value From ZHS 限定词属性值自 3 30 :p_qualifier_attr_value_to LOV Oracle QP_QUALIFIER_ATTRIBUTE_TO Y select qualifier_attr_value id, qualifier_attr_value value, null description from qp_qualifiers_v where qualifier_context=:$flex$.qp_qualifier_context and rowid in (select max(rowid) from qp_qualifiers_v group by qualifier_attr_value) order by value,description AR قيمة سمة المعيار إلى D Bis Kriterienattributwert F Valeur de l'attribut du qualificatif - A US Qualifier Attribute Value To ZHS 限定词属性值至 4 40 :p_start_date_active Date AR تاريخ بداية الفعالية D Gültig von F Date de début de validité US Start Date Active ZHS 有效起始日期 5 50 :p_end_date_active Date select fnd_date.date_to_chardate(fnd_date.canonical_to_date(:$FLEX$.Start_Date_Active),0) from sys.dual AR تاريخ نهاية الفعالية D Gültig bis F Date de fin de validité US End Date Active ZHS 有效终止日期 :$FLEX$.Start_Date_Active Start Date Active Y End Date Active :$flex$.qp_qualifier_context Qualifier Context Qualifier Attribute Value From :$flex$.qp_qualifier_context Qualifier Context Qualifier Attribute Value To