ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F29C3869E053B46B63588994Y SELECT pe.project_id aex_project_id, pe.project_number aex_project_number, pl2.meaning aex_asset_allocation_method, pe.asset_or_project_error aex_error_type, pe.project_asset_line_id aex_asset_line_id, pt.task_number aex_task_number, ppa.asset_name aex_asset_name, pe.project_asset_id aex_asset_id, pe.capital_event_id aex_cap_event_id, pe.capital_event_number aex_event_number, pe.event_name aex_eventname, pl.lookup_code aex_error_code, pl.meaning aex_error_message FROM pa_asset_alloc_exceptions_v pe, pa_project_assets ppa, pa_tasks pt, pa_lookups pl, pa_lookups pl2 WHERE ppa.project_asset_id(+) = pe.project_asset_id AND pe.request_id = :p_conc_request_id AND pt.task_id = pe.task_id AND pl.lookup_type = 'ASSET_ALLOCATION_EXCEPTIONS' AND pl.lookup_code = pe.error_code AND pl2.lookup_type = 'ASSET_ALLOCATION_METHOD' AND pl2.lookup_code = pe.asset_allocation_method AND (pe.event_name IS NULL OR pe.event_name = nvl(:p_event_name,pe.event_name)) UNION ALL SELECT pe.project_id aex_project_id, pe.project_number aex_project_number, pl2.meaning aex_asset_allocation_method, pe.asset_or_project_error aex_error_type, pe.project_asset_line_id aex_asset_line_id, NULL, ppa.asset_name aex_asset_name, pe.project_asset_id aex_asset_id, pe.capital_event_id aex_cap_event_id, pe.capital_event_number aex_event_number, pe.event_name aex_eventname, pl.lookup_code aex_error_code, pl.meaning aex_error_message FROM pa_asset_alloc_exceptions_v pe, pa_project_assets ppa, pa_lookups pl, pa_lookups pl2 WHERE ppa.project_asset_id(+) = pe.project_asset_id AND pe.request_id = :p_conc_request_id AND pe.task_id = 0 AND pl.lookup_type = 'ASSET_ALLOCATION_EXCEPTIONS' AND pl.lookup_code = pe.error_code AND pl2.lookup_type = 'ASSET_ALLOCATION_METHOD' AND pl2.lookup_code = pe.asset_allocation_method AND (pe.event_name IS NULL OR pe.event_name = nvl(:p_event_name,pe.event_name)) PA PAXCPGAL_XML AR PA تكوين سطور الأصول لمدى من المشروعات (بتنسيق XML) Application: المشروعات Source: PRC: تكوين سطور الأصول لمدى من المشروعات (بتنسيق XML) Short Name: PAXCPGAL_XML DB package: PA_PAXCPGAL_XMLP_PKG D PA Anlagenpositionen für mehrere Projekte generieren Application: Projects Source: PA: Anlagenpositionen für mehrere Projekte generieren (XML) Short Name: PAXCPGAL_XML DB package: PA_PAXCPGAL_XMLP_PKG F PA Générer des lignes d'immobilisation pour une fourchette de projets Application: Projects Source: PRC : Générer des lignes d'immobilisation pour une fourchette de projets (XML) Short Name: PAXCPGAL_XML DB package: PA_PAXCPGAL_XMLP_PKG US PA Generate Asset Lines for a Range of Projects Application: Projects Source: PRC: Generate Asset Lines for a Range of Projects (XML) Short Name: PAXCPGAL_XML DB package: PA_PAXCPGAL_XMLP_PKG ZHS PA PRC：为一组项目生成资产行 Application: 项目 Source: PRC：为一组项目生成资产行 (XML) Short Name: PAXCPGAL_XML DB package: PA_PAXCPGAL_XMLP_PKG BI Publisher :c_company_name_header :c_dummy_data :c_no_data_found :c_retcode :curr_code :lp_dpis_through :lp_pa_through_date :operating_unit :p_capital_event_id :p_capital_event_number :p_conc_request_id :p_debug_mode :p_dpis_through :p_event_name :p_from_project_number :p_include_common_tasks :p_pa_through_date :p_rule_optimizer :p_to_project_number 1 10 :p_from_project_number Char Y AR من رقم المشروع D Von Projektnummer F Du numéro de projet US From Project Number ZHS 自项目编号 2 20 :p_to_project_number Char Y AR إلى رقم المشروع D Bis Projektnummer F Au numéro de projet US To Project Number ZHS 至项目编号 3 30 :p_dpis_through Date Select fnd_date.date_to_displaydate(sysdate) from dual Y AR تاريخ بدء الخدمة حتى D Bis Datum Inbetriebnahme F Date limite de mise en service US Date Placed In Service Through ZHS 启用截止日 4 40 :p_include_common_tasks LOV Oracle PA_SRS_YES_NO_LOV Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by meaning select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'N' AR هل تريد تضمين المهام العامة؟ D Mit gemeinsamen Teilprojekten? F Inclure les tâches communes ? US Include Common Tasks? ZHS 是否包括公用任务？ 5 50 :p_pa_through_date Date Select fnd_date.date_to_displaydate(sysdate) from dual Y AR محاسبة المشروعات خلال التاريخ D Bis PA-Datum F Date limite PA US PA Through Date ZHS PA 截止日