ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2B33869E053B46B63588994 SELECT substr(o.name,1,60) org_name , l.meaning status , sl.meaning linkage , emp.full_name entered_by , substr(e.expenditure_group,1,20) expenditure_group , avg( nvl( eg.control_total_amount, 0 )) control_tot , sum( nvl( ei.quantity, 0 )) qty FROM pa_lookups l , pa_org_reporting_view orv , hr_organization_units o , per_assignments_f a , per_people_f emp , fnd_user u , pa_system_linkages sl , pa_expenditure_groups eg , pa_expenditures_all e , pa_expenditure_items_all ei WHERE orv.organization_id = o.organization_id AND o.organization_id = a.organization_id AND a.primary_flag = 'Y' AND a.assignment_type IN ( 'E' , 'C') AND a.person_id = emp.person_id AND sysdate between emp.effective_start_date and nvl(emp.effective_end_date,sysdate + 1) AND ( emp.employee_number IS NOT NULL OR emp.npw_number IS NOT NULL ) AND emp.person_id = u.employee_id AND u.user_id = eg.created_by AND eg.creation_date BETWEEN a.effective_start_date AND a.effective_end_date AND eg.expenditure_group = e.expenditure_group AND e.expenditure_id = ei.expenditure_id (+) AND eg.system_linkage_function = sl.function AND ( :linkage IS NULL OR sl.function = :linkage ) AND ( :ending_date IS NULL OR eg.expenditure_ending_date = :ending_date ) AND eg.expenditure_group_status_code = l.lookup_code AND l.lookup_type = 'EXP GROUP REPORTING STATUS' AND ( :status IS NULL OR l.lookup_code = :status ) AND ( :display_released_group = 'Y' OR l.lookup_code != 'RELEASED' ) GROUP BY a.organization_id , o.name , l.meaning , sl.meaning , emp.full_name , e.expenditure_group order by org_name,status,linkage,entered_by Y PA PAXPCEGS_XML AR PA موقف مجموعة المصروفات (بتنسيق XML) Application: المشروعات Source: AUD: موقف مجموعة المصروفات (بتنسيق XML) Short Name: PAXPCEGS_XML DB package: PA_PAXPCEGS_XMLP_PKG D PA Status Aufwandsstapel Application: Projects Source: PA: Status Aufwandsstapel (XML) Short Name: PAXPCEGS_XML DB package: PA_PAXPCEGS_XMLP_PKG F PA Statut de lots de dépenses Application: Projects Source: AUD : Statut de lots de dépenses (XML) Short Name: PAXPCEGS_XML DB package: PA_PAXPCEGS_XMLP_PKG US PA AUD: Expenditure Batch Status Application: Projects Source: AUD: Expenditure Batch Status (XML) Short Name: PAXPCEGS_XML DB package: PA_PAXPCEGS_XMLP_PKG ZHS PA AUD：支出批状态 Application: 项目 Source: AUD：支出批状态 (XML) Short Name: PAXPCEGS_XML DB package: PA_PAXPCEGS_XMLP_PKG BI Publisher :c_company_name_header :display_released_group :ending_date :ending_date_1 :linkage :operating_unit :p_conc_request_id :p_debug_mode :p_rule_optimizer :p_start_organization_id :start_organization :status 1 10 :p_start_organization_id LOV Oracle PA_SRS_EXPENDITURE_ORGANIZATION Y Y select organization_id id, name value, null description from pa_organizations_exp_all_bg_v order by name Y AR اسم التنظيم D Organisationsbezeichnung F Nom de l'organisation US Organization Name ZHS 组织名 2 20 :ending_date Date AR تاريخ نهاية المصروفات D Aufwand/KW Ende F Date de fin des dépenses US Expenditure Ending Date ZHS 支出终止日期 3 30 :linkage LOV Oracle PA_SRS_SYSTEM_LINKAGE_FUNC Y select function id, meaning value, null description from pa_system_linkages order by meaning AR طبقة نوع المصروفات D Aufwandsartklasse F Classe de type de dépense US Expenditure Type Class ZHS 支出类型分类 4 40 :status LOV Oracle PA_SRS_EXPEND_GROUP_STATUS Y select lookup_code id, meaning value, null description from pa_lookups where lookup_type='EXP GROUP REPORTING STATUS' order by meaning AR موقف مجموعة المصروفات D Status Aufwandsstapel F Statut de lots de dépenses US Expenditure Batch Status ZHS 支出批状态 5 50 :display_released_group 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 Freigegebenen Stapel anzeigen? F Afficher les lots lancés ? US Display Released Batch? ZHS 是否显示已释放的批？