ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2B53869E053B46B63588994 select org.organization_id, substr(p.organization_name,1,60) project_organization, p.member_name project_member2, i.invoice_status, i.project_id||i.draft_invoice_num invoice, i.invoice_currency_code, i.project_id proj_id, i.draft_invoice_num draft_num -- PA_PAXPCIFS_XMLP_PKG.c_inv_amountformula(:C_inv_amount1, :C_inv_amount2, :C_inv_amount3) C_inv_amount, -- PA_PAXPCIFS_XMLP_PKG.c_inv_countformula(:C_inv_count1, :C_inv_count2, :C_inv_count3) C_inv_count, -- PA_PAXPCIFS_XMLP_PKG.c_amountformula(:C_amount1, :C_amount2, :C_amount3) C_amount, -- PA_PAXPCIFS_XMLP_PKG.c_countformula(:C_count1, :C_count2, :C_count3) C_count from pa_org_reporting_view org, pa_proj_members_view p, pa_proj_invoices_view i where p.organization_id = org.organization_id and p.project_id = i.project_id and p.member_person_id = nvl(:project_member,p.member_person_id) and p.project_role_type = nvl(:PROJECT_ROLE_TYPE,'PROJECT MANAGER') and nvl(trunc(i.creation_date),sysdate) between nvl(:CREATION_DATE_FROM, nvl(trunc(i.creation_date),sysdate-1)) and nvl(:CREATION_DATE_TO, nvl(trunc(i.creation_date),sysdate+1)) and :c_enter is null ORDER BY 2 ASC,1 ASC,3 ASC,4 ASC,7 ASC,8 ASC,6 ASC,5 ASC Y PA PAXPCIFS_XML AR PA إجمالي تدفق الفاتورة (بتنسيق XML) Application: المشروعات Source: FLW: إجمالي تدفق الفاتورة (بتنسيق XML) Short Name: PAXPCIFS_XML DB package: PA_PAXPCIFS_XMLP_PKG D PA Rechnungsfluss - Übersicht Application: Projects Source: ADF: Rechnungsfluss - Übersicht (XML) Short Name: PAXPCIFS_XML DB package: PA_PAXPCIFS_XMLP_PKG F PA Synthèse du flux des factures Application: Projects Source: FLW : Synthèse du flux des factures (XML) Short Name: PAXPCIFS_XML DB package: PA_PAXPCIFS_XMLP_PKG US PA Invoice Flow Summary Application: Projects Source: FLW: Invoice Flow Summary (XML) Short Name: PAXPCIFS_XML DB package: PA_PAXPCIFS_XMLP_PKG ZHS PA FLW：发票流程汇总 Application: 项目 Source: FLW：发票流程汇总 (XML) Short Name: PAXPCIFS_XML DB package: PA_PAXPCIFS_XMLP_PKG BI Publisher :bucket1_high :bucket1_low :bucket2_high :bucket2_low :bucket3_high :bucket3_low :c_company_name_header :c_currency :c_dummy_data :c_enter :c_no_data_found :c_project_member :c_role_type :c_start_org :creation_date_from :creation_date_from_1 :creation_date_to :creation_date_to_1 :operating_unit :p_conc_request_id :p_debug_mode :p_rule_optimizer :p_start_organization_id :project_member :project_role_type 1 10 :p_start_organization_id LOV Oracle PA_SRS_REPORTING_ORGANIZATION Y select organization_id id, name value, null description from pa_organizations_v where organization_id in (select se.organization_id_child from per_org_structure_elements se where org_structure_version_id= pa_org_utils.get_org_version_id('REPORTING') connect by prior se.organization_id_child =se.organization_id_parent and org_structure_version_id= pa_org_utils.get_org_version_id('REPORTING') start with se.organization_id_parent= pa_org_utils.get_start_org_id('REPORTING') and org_structure_version_id= pa_org_utils.get_org_version_id('REPORTING') union select pa_org_utils.get_start_org_id('REPORTING') from sys.dual ) order by value,description AR تنظيم البداية D Startorganisation F Organisation de départ US Start Organization ZHS 起始组织 2 20 :project_member 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 Projektmitarbeiter F Intervenant sur le projet US Project Member ZHS 项目成员 3 30 :project_role_type LOV Oracle PA_SRS_PROJECT_ROLE_TYPE Y select project_role_type id, project_role_type value, meaning description from pa_project_role_types order by meaning select project_role_type from pa_project_role_types where project_role_type = 'PROJECT MANAGER' AR نوع دور المشروع D Projektfunktion F Type de rôle dans le projet US Project Role Type ZHS 项目职责类型 4 40 :creation_date_from Date AR تاريخ التكوين من D Von Erstellungsdatum F Date de création - Du US Creation Date From ZHS 创建日期自 5 50 :creation_date_to Date AR تاريخ التكوين إلى D Bis Erstellungsdatum F Date de création - Au US Creation Date To ZHS 创建日期至