ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F45C3869E053B46B63588994 SELECT a.name,a.description,a.currency_code,a.start_date_active,a.end_date_active,a.comments, a.version_no,a.list_type_code,a.automatic_flag,a.active_flag,a.start_date_active_first, a.end_date_active_first,a.active_date_first_type,a.active_date_second_type, a.start_date_active_second,a.end_date_active_second, a.list_header_id list_header_id, a.ask_for_flag,a.gsa_indicator,a.parent_list_header_id, QP_QPXPACRL_XMLP_PKG.cf_parent_numberformula(a.parent_list_header_id) CF_parent_number, QP_QPXPACRL_XMLP_PKG.cf_parent_versionformula(a.parent_list_header_id) CF_parent_version, QP_QPXPACRL_XMLP_PKG.cf_list_type_codeformula(a.list_type_code) CF_list_type_code FROM qp_list_headers_vl a WHERE (:P_modifier_name_from IS NULL OR a.description >= :P_modifier_name_from) AND (:P_modifier_name_to IS NULL OR a.description <= :P_modifier_name_to) AND (:P_start_date_active IS NULL OR a.start_date_active = :P_start_date_active) AND (:P_end_date_active IS NULL OR a.end_date_active = :P_end_date_active) AND ( (:P_qualifier_context IS NULL and :P_qualifier_attribute_from IS NULL and :P_qualifier_attribute_to IS NULL) OR a.list_header_id IN (SELECT list_header_id FROM qp_qualifiers_v b WHERE (:P_qualifier_context IS NULL OR b.qualifier_context = :P_qualifier_context) AND (:P_qualifier_attribute_from IS NULL OR b.qualifier_attr_value = :P_qualifier_attribute_from) AND (:P_qualifier_attribute_to IS NULL OR b.qualifier_attr_value_to = :P_qualifier_attribute_to)) ) AND exists (select 'X' from qp_list_lines qpl where a.list_header_id = qpl.list_header_id and qpl.accrual_flag = 'Y') ORDER BY 1 Y QP QPXPACRL_XML AR QP تفاصيل الاستحقاق Application: التسعير المتقدم Source: تفاصيل الاستحقاق (XML) Short Name: QPXPACRL_XML DB package: QP_QPXPACRL_XMLP_PKG D QP Ansprüche - Details Application: Advanced Pricing Source: Ansprüche - Details (XML) Short Name: QPXPACRL_XML DB package: QP_QPXPACRL_XMLP_PKG F QP Détails cumul Application: Advanced Pricing Source: Détails cumul (XML) Short Name: QPXPACRL_XML DB package: QP_QPXPACRL_XMLP_PKG US QP Accrual Details Application: Advanced Pricing Source: Accrual Details (XML) Short Name: QPXPACRL_XML DB package: QP_QPXPACRL_XMLP_PKG ZHS QP 应计明细 Application: 高级定价 Source: 应计明细 (XML) Short Name: QPXPACRL_XML DB package: QP_QPXPACRL_XMLP_PKG BI Publisher :p_conc_request_id :p_end_date_active :p_modifier_name_from :p_modifier_name_to :p_qualifier_attribute_from :p_qualifier_attribute_to :p_qualifier_context :p_sob_id :p_start_date_active :rp_company_name :rp_report_name 1 10 :p_modifier_name_from LOV Oracle QP_MODIFIER_NAME Y select description id, description value, null description from qp_secu_list_headers_vl d where list_type_code not in ('PRL','AGR','PML') and view_flag='Y' and nvl(pte_code,'ORDFUL')<>'LOGSTX' order by d.description Y AR اسم المعامل من D Von Modifikator F Nom des conditions commerciales - De US Modifier Name From ZHS 修改量名称自 2 20 :p_modifier_name_to LOV Oracle QP_MODIFIER_NAME Y select description id, description value, null description from qp_secu_list_headers_vl d where list_type_code not in ('PRL','AGR','PML') and view_flag='Y' and nvl(pte_code,'ORDFUL')<>'LOGSTX' order by d.description Y AR اسم المعامل إلى D Bis Modifikator F Nom des conditions commerciales - A US Modifier Name To ZHS 修改量名称至 3 30 :p_start_date_active Date AR تاريخ بداية الفعالية D Gültig von F Date de début de validité US Start Date Active ZHS 有效起始日期 4 40 :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 有效终止日期 5 50 :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 限定词上下文 6 60 :p_qualifier_attribute_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 限定词属性值自 7 70 :p_qualifier_attribute_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 限定词属性值至 :$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