ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2903869E053B46B63588994Y SELECT proj.name, proj.segment1, decode(ppj.archive_summary_flag, 'Y',:C_YES, :C_NO), decode(ppj.purge_summary_flag,'Y',:C_YES, :C_NO), decode(ppj.archive_capital_flag,'Y',:C_YES, :C_NO), decode(ppj.purge_capital_flag,'Y',:C_YES, :C_NO), decode(ppj.archive_budgets_flag,'Y',:C_YES, :C_NO), decode(ppj.purge_budgets_flag,'Y',:C_YES, :C_NO), decode(ppj.archive_actuals_flag,'Y',:C_YES, :C_NO), decode(ppj.purge_actuals_flag,'Y',:C_YES, :C_NO), ppj.project_id, projd.table_name, projd.num_recs_purged recs_purged, projd.num_recs_archived recs_archived FROM pa_purge_prj_details projd, pa_purge_projects ppj, pa_projects_all proj WHERE ppj.project_id = proj.project_id AND ppj.project_id = projd.project_id (+) AND ppj.purge_batch_id = projd.purge_batch_id (+) AND ppj.purge_batch_id = :P_Purge_batch_id order by ppj.project_id,proj.segment1 PA PAXARPPR_XML AR PA شطب بيانات المشروع (بتنسيق XML) Application: المشروعات Source: ADM: شطب بيانات المشروع (بتنسيق XML) Short Name: PAXARPPR_XML DB package: PA_PAXARPPR_XMLP_PKG D PA Projektdaten löschen Application: Projects Source: ADM: Projektdaten löschen (XML) Short Name: PAXARPPR_XML DB package: PA_PAXARPPR_XMLP_PKG F PA Purger les données de projet Application: Projects Source: ADM : Purger les données de projet (XML) Short Name: PAXARPPR_XML DB package: PA_PAXARPPR_XMLP_PKG US PA Purge Project Data Application: Projects Source: ADM: Purge Project Data (XML) Short Name: PAXARPPR_XML DB package: PA_PAXARPPR_XMLP_PKG ZHS PA ADM：清除项目数据 Application: 项目 Source: ADM：清除项目数据 (XML) Short Name: PAXARPPR_XML DB package: PA_PAXARPPR_XMLP_PKG BI Publisher :c_batch_active_closed :c_batch_description :c_batch_name :c_batch_purged_date :c_batch_status :c_batch_status_meaning :c_commit_size :c_company_name_header :c_dummy_data :c_no :c_no_data_found :c_run_purge :c_through_date :c_yes :operating_unit :p_commit_size :p_conc_request_id :p_debug_mode :p_purge_batch_id :p_rule_optimizer :p_run_purge :pa_purge_error_buff :pa_purge_error_code 1 10 :p_purge_batch_id LOV Oracle PA_SRS_RELEASED_BATCHES Y select purge_batch_id id, batch_name value, null description from pa_purge_batches where batch_status_code in ('R','P','C') order by batch_name Y AR اسم المجموعة D Stapelbezeichnung F Nom du lot US Batch Name ZHS 批名 2 20 :p_run_purge 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' Y AR تشغيل الشطب D Löschvorgang starten F Exécuter la purge US Run Purge ZHS 运行清除 3 30 :p_commit_size Number select fnd_profile.value('PA_ARPUR_COMMIT_SIZE') from dual Y AR حجم التثبيت D Speichergröße F Taille de validation US Commit Size ZHS 提交大小