ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F29A3869E053B46B63588994Y select p.segment1 project_number_rl, pa.asset_name asset_name_rl, pa.asset_description description_rl, lkp.meaning retirement_cost_type, fa.asset_number target_asset, count(pal.project_asset_line_id) count_asset_line_rl, sum(pal.current_asset_cost) sum_asset_cost_rl from pa_project_assets pa, pa_project_asset_lines pal, pa_projects p, pa_lookups lkp, fa_additions fa where pal.request_id = nvl(:p_conc_request_id,0) AND pal.transfer_status_code ||'' = 'T' AND pal.LINE_TYPE = 'R' AND pa.project_asset_id = pal.project_asset_id AND pa.project_id = p.project_id AND lkp.lookup_type = 'RETIREMENT_COST_TYPE' AND lkp.lookup_code = pal.retirement_cost_type AND pa.ret_target_asset_id = fa.asset_id group by p.segment1, pa.asset_name, pa.asset_description, pa.request_id,lkp.meaning,fa.asset_number order by 1,2,3 PA PAXCPCAL_XML AR PA ربط الأصول بالأصول لأوراكل (بتنسيق XML) Application: المشروعات Source: PRC: ربط الأصول بالأصول لأوراكل (بتنسيق XML) Short Name: PAXCPCAL_XML DB package: PA_PAXCPCAL_XMLP_PKG D PA Anlagen in Oracle Anlagen übertragen Application: Projects Source: PA: Anlagen in Oracle Anlagen übertragen (XML) Short Name: PAXCPCAL_XML DB package: PA_PAXCPCAL_XMLP_PKG F PA Transférer des immobilisations vers Fixed Assets Application: Projects Source: PRC : Transférer des immobilisations vers Fixed Assets (XML) Short Name: PAXCPCAL_XML DB package: PA_PAXCPCAL_XMLP_PKG US PA Interface Assets to Oracle Assets Application: Projects Source: PRC: Interface Assets to Oracle Assets (XML) Short Name: PAXCPCAL_XML DB package: PA_PAXCPCAL_XMLP_PKG ZHS PA PRC：将资产传送至 Oracle Assets Application: 项目 Source: PRC：将资产传送至 Oracle Assets (XML) Short Name: PAXCPCAL_XML DB package: PA_PAXCPCAL_XMLP_PKG BI Publisher :c_company_name_header :c_dummy_data :c_error_buf :c_no_data_found :c_retcode :cp_dpis_through :curr_code :operating_unit :p_conc_request_id :p_debug_mode :p_dpis_through :p_from_project_number :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 AR تاريخ بدء الخدمة حتى D Bis Datum Inbetriebnahme F Date limite de mise en service US Date Placed In Service Through ZHS 启用截止日