ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2713869E053B46B63588994 select pev.project_id,pev.project_number,pev.project_name, max(pev.expenditure_item_date) last_activity_date, add_months(max(pev.expenditure_item_date),:p_periods) suspension_date from pa_expend_items_adjust2_v pev where pev.project_number between NVL(:p_from_proj_num,pev.project_number) and NVL(:p_to_proj_num,pev.project_number) and pev.project_type_class_code = 'CAPITAL' and nvl(pev.transaction_source,'X') <> 'Capitalized Interest' group by pev.project_id, pev.project_number,pev.project_name having months_between(sysdate,max(pev.expenditure_item_date)) > :p_periods Y PA PACINTAR_XML AR PA تقرير المشروعات الرأسمالية غير السارية (بتنسيق XML) Application: المشروعات Source: MGT: تقرير المشروعات الرأسمالية غير السارية (بتنسيق XML) Short Name: PACINTAR_XML DB package: PA_PACINTAR_XMLP_PKG D PA Ungültige Investitionsprojekte Application: Projects Source: PA: Ungültige Investitionsprojekte (XML) Short Name: PACINTAR_XML DB package: PA_PACINTAR_XMLP_PKG F PA Etat Projets d'investissement inactifs Application: Projects Source: MGT : Etat Projets d'investissement inactifs (XML) Short Name: PACINTAR_XML DB package: PA_PACINTAR_XMLP_PKG US PA Inactive Capital Projects Application: Projects Source: MGT: Inactive Capital Projects Report (XML) Short Name: PACINTAR_XML DB package: PA_PACINTAR_XMLP_PKG ZHS PA MGT：无效的资本项目报表 Application: 项目 Source: MGT：无效的资本项目报表 (XML) Short Name: PACINTAR_XML DB package: PA_PACINTAR_XMLP_PKG BI Publisher :p_conc_request_id :p_from_proj_num :p_periods :p_to_proj_num :p_user_id 1 10 :p_from_proj_num LOV Oracle PA_SRS_PROJECT_NUMBER_CAPITAL Y Y select project_number id, project_number value, project_name description from pa_projects_basic_v where template_flag!='Y' and project_type_class_code='CAPITAL' order by project_number_sort_order AR من رقم المشروع D Von Projektnummer F Du numéro de projet US From Project Number ZHS 自项目编号 2 20 :p_to_proj_num LOV Oracle PA_SRS_PROJECT_NUMBER_CAPITAL Y Y select project_number id, project_number value, project_name description from pa_projects_basic_v where template_flag!='Y' and project_type_class_code='CAPITAL' order by project_number_sort_order AR إلى رقم المشروع D Bis Projektnummer F Au numéro de projet US To Project Number ZHS 至项目编号 3 30 :p_periods Number Y AR عدد الفترات غير السارية D Anzahl der gültigen Perioden F Nombre de périodes d'inactivité US Number of Inactive Periods ZHS 无效期间数