ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2B43869E053B46B63588994 select substr(p.organization_name,1,60) project_organization, p.member_name, p.project_role, p.project_number, p.project_name, i.invoice_status, i.draft_invoice_num invoice_number, i.draft_invoice_num_credited credit_of, i.bill_through_date bill_thru_date, i.creation_date, i.approved_date, i.released_date, i.days_awaiting_approval awaiting_approval, i.invoice_amount amount, i.invoice_curr_amount inv_amount, i.invoice_currency_code from pa_proj_members_view p, pa_org_reporting_view vw, pa_proj_invoices_view i, pa_lookups lk where p.organization_id = vw.organization_id and nvl(:project_role_type ,'PROJECT MANAGER') = p.project_role_type and nvl(:project_member,p.member_person_id) = p.member_person_id and p.project_id =i.project_id and i.invoice_amount between :low_range and :high_range and decode(:invoice_status, null,lk.lookup_code, 'ALL',lk.lookup_code, :invoice_status)= lk.lookup_code and lk.lookup_type='INVOICE STATUS' and lk.meaning(+)=i.invoice_status 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 decode(:include_released_status,'N',released_date,null) is null order by p.organization_name,p.member_name, i.invoice_status,p.project_number,i.draft_invoice_num Y PA PAXPCIDF_XML AR PA تفاصيل تدفق الفاتورة (بتنسيق XML) Application: المشروعات Source: FLW: تفاصيل تدفق الفاتورة (بتنسيق XML) Short Name: PAXPCIDF_XML DB package: PA_PAXPCIDF_XMLP_PKG D PA Rechnungsfluss - Details Application: Projects Source: ADF: Rechnungsfluss - Details (XML) Short Name: PAXPCIDF_XML DB package: PA_PAXPCIDF_XMLP_PKG F PA Détail du flux des factures Application: Projects Source: FLW : Détail du flux des factures (XML) Short Name: PAXPCIDF_XML DB package: PA_PAXPCIDF_XMLP_PKG US PA Invoice Flow Detail Application: Projects Source: FLW: Invoice Flow Detail (XML) Short Name: PAXPCIDF_XML DB package: PA_PAXPCIDF_XMLP_PKG ZHS PA FLW：发票流程明细 Application: 项目 Source: FLW：发票流程明细 (XML) Short Name: PAXPCIDF_XML DB package: PA_PAXPCIDF_XMLP_PKG BI Publisher :c_company_name_header :c_dummy_data :c_enter :c_invoice_stat :c_no_data_found :c_project_member :c_released :c_role_type :c_start_org :creation_date_from :creation_date_to :high_range :include_released_status :invoice_amount_range :invoice_status :lcreation_date_from :lcreation_date_to :low_range :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 创建日期至 6 60 :include_released_status 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 Mit freigegebenen Rechnungen F Inclure les factures débloquées US Include Released Invoices ZHS 包括已释放的发票 7 70 :invoice_amount_range LOV Oracle PA_SRS_INVOICE_AMOUNT_RANGE Y select lookup_code id, meaning value, null description from pa_lookups where lookup_type='INVOICE_AMOUNT_RANGE' order by meaning select meaning from PA_lookups where lookup_type = 'INVOICE_AMOUNT_RANGE' and lookup_code = 'All' Y AR مدى قيم الفاتورة D Bereiche von Rechnungsbeträgen F Fourchette de montants de factures US Invoice Amount Ranges ZHS 发票额范围 8 80 :invoice_status LOV Oracle PA_SRS_INVOICE_REVENUE_STATUS Y select lookup_code id, meaning value, null description from pa_lookups where lookup_type='INVOICE_REVENUE_STATUS' order by meaning select meaning from PA_lookups where lookup_type = 'INVOICE_REVENUE_STATUS' and lookup_code = 'ALL' AR موقف الفاتورة D Rechnungsstatus F Statut de facture US Invoice Status ZHS 发票状态