ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F29F3869E053B46B63588994Y SELECT p.project_id PROJECT_ID1, p.name project_name, p.segment1 project_num, emp.full_name Employee, substr(o.name,1,60) Organization, ei.expenditure_item_date Item_Date, ei.expenditure_type Type, t.task_number, ei.non_labor_resource , to_char( eia.activity_date, 'DD-MON-RR' ) adjustment_date, l.meaning adjustment_activity, emp2.full_name Adjusted_By FROM pa_projects p , pa_tasks t , pa_expenditure_items_all ei , pa_expenditures_all e , pa_expend_item_adj_activities eia , per_people_f emp , per_people_f emp2 , fnd_user u , hr_organization_units o , pa_lookups l WHERE p.project_id = :project_id and eia.expenditure_item_id = ei.expenditure_item_id and ei.expenditure_id = e.expenditure_id and ei.org_id = e.org_id and e.incurred_by_person_id = emp.person_id (+) and ( :person_id IS NULL OR e.incurred_by_person_id = :person_id ) and sysdate between emp.effective_start_date (+) and nvl(emp.effective_end_date (+) ,sysdate + 1) and nvl( ei.override_to_organization_id, e.incurred_by_organization_id ) = o.organization_id and ei.task_id = t.task_id and ( :task_id IS NULL OR t.task_id = :task_id ) and t.project_id = p.project_id and eia.created_by = u.user_id and u.employee_id = emp2.person_id and sysdate between emp2.effective_start_date and nvl(emp2.effective_end_date,sysdate + 1) and ( emp2.employee_number IS NOT NULL OR emp2.npw_number is not null ) and trunc(eia.activity_date) BETWEEN nvl( :start_activity_date,trunc(eia.activity_date)) AND nvl(:end_activity_date, trunc(eia.activity_date)) and eia.exception_activity_code = l.lookup_code and l.lookup_type = decode(nvl(emp2.employee_number, emp2.npw_number), NULL, 'EXCEPTION ACTIVITY', 'EXCEPTION ACTIVITY') GROUP BY p.project_id , p.segment1 , p.name , emp.full_name , o.name , ei.expenditure_item_date , ei.expenditure_type , t.task_number , ei.non_labor_resource , eia.activity_date , l.meaning , eia.created_by , emp2.full_name , eia.expenditure_item_id ORDER BY 1 ASC,3 ASC,2 ASC,4 ASC,5 ASC,6 ASC,7 ASC,8 ASC,9 ASC PA PAXEXADJ_XML AR PA نشاط تعديل مصروفات المشروع (بتنسيق XML) Application: المشروعات Source: AUD: نشاط تعديل مصروفات المشروع (بتنسيق XML) Short Name: PAXEXADJ_XML DB package: PA_PAXEXADJ_XMLP_PKG D PA Projekt Aufwandskorrekturen Application: Projects Source: PA: Projekt Aufwandskorrekturen (XML) Short Name: PAXEXADJ_XML DB package: PA_PAXEXADJ_XMLP_PKG F PA Ajustement des dépenses d'un projet Application: Projects Source: AUD : Ajustement des dépenses d'un projet (XML) Short Name: PAXEXADJ_XML DB package: PA_PAXEXADJ_XMLP_PKG US PA Project Expenditure Adjustment Activity Application: Projects Source: AUD: Project Expenditure Adjustment Activity (XML) Short Name: PAXEXADJ_XML DB package: PA_PAXEXADJ_XMLP_PKG ZHS PA AUD：项目支出调整活动 Application: 项目 Source: AUD：项目支出调整活动 (XML) Short Name: PAXEXADJ_XML DB package: PA_PAXEXADJ_XMLP_PKG BI Publisher :c_company_name_header :c_employee_name :c_end_activity_date :c_no_data_found :c_person_id :c_project_id :c_project_number :c_start_activity_date :c_task_id :c_task_number :end_activity_date :operating_unit :p_conc_request_id :p_debug_mode :p_rule_optimizer :person_id :project_id :start_activity_date :task_id 1 10 :project_id LOV Oracle PA_SRS_PROJECT_ID Y Y select project_id id, project_number value, project_name description from pa_projects_basic_v where template_flag!='Y' order by project_number_sort_order Y AR رقم المشروع D Projektnummer F Numéro de projet US Project Number ZHS 项目编号 2 20 :task_id LOV Oracle PA_SRS_TASKS Y select task_id id, task_number value, task_name description from pa_tasks_all_v where :$flex$.pa_srs_project_id=project_id order by task_number AR رقم المهمة D Teilprojektnummer F Numéro de tâche US Task Number ZHS 任务编号 3 30 :person_id LOV Oracle PA_SRS_EMPLOYEE_LOV Y Y select person_id id, full_name value, employee_number description from pa_employees order by full_name AR اسم الموظف D Mitarbeitername F Nom de l'employé US Employee Name ZHS 员工姓名 4 40 :start_activity_date Date AR من تاريخ التعديل D Von Korrekturdatum F Date d'ajustement - Du US From Adjustment Date ZHS 自调整日期 5 50 :end_activity_date Date AR إلى تاريخ التعديل D Bis Korrekturdatum F Date d'ajustement - Au US To Adjustment Date ZHS 至调整日期