ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F03A3869E053B46B63588994 select distinct decode(di.igi_sap_flag, 'Y', :p_status_1,:p_status_2) " Status" , gr.group_name "Group" , di.batch_name "Batch No" , SUBSTR(di.vendor_name,1,22) "Vendor Name" , di.invoice_num "Invoice Number" , di.invoice_date " Invoice Date" , di.invoice_amount amount , di.entered_by "Entered By" , DECODE(di.igi_sap_flag, 'Y',fu2.user_name,fu3.user_name) "Authorised by" from fnd_user fu1, fnd_user fu2, fnd_user fu3, igi_ap_inv_distributions_v di, igi_sap_invoice_clerk cl, igi_sap_department_approvers ap, igi_sap_group gr, ap_invoices_v ai, ap_invoice_distributions_v aid, ap_holds_v ahv where di.approver_id = nvl(:p_approver_id,di.approver_id) and di.created_by = cl.clerk_id and cl.group_id = gr.group_id and gr.group_id = ap.group_id and ap.approver_id = di.approver_id and gr.group_id = nvl(:p_group_id,gr.group_id) AND decode(:p_batch_id,NULL, nvl(di.batch_id,-99999), di.batch_id) = decode(:p_batch_id,NULL, nvl(di.batch_id,-99999), :p_batch_id) and di.vendor_id = nvl(:p_vendor_id,di.vendor_id) and di.invoice_id = nvl(:p_invoice_id,di.invoice_id) and di.created_by = fu1.user_id and di.invoice_date between nvl(:p_start_date,di.invoice_date) and nvl(:p_end_date,di.invoice_date) and di.last_updated_by = fu2.user_id and di.approver_id = fu3.user_id and di.invoice_id = aid.invoice_id and di.dist_rowid = aid.row_id and di.invoice_id = ahv.invoice_id and aid.invoice_id = ai.invoice_id and aid.awt_invoice_id IS NULL and ai.cancelled_date IS NULL and ai.cancelled_by IS NULL and di.igi_sap_flag = decode(nvl(:p_release_lookup_code_1,'x'),'x', di.igi_sap_flag,'AUTHORISED','Y','PENDING','N') and nvl(ahv.release_reason,'x') != 'INVOICE MODIFIED' group by decode(di.igi_sap_flag,'Y',:p_status_1,:p_status_2) , gr.group_name , di.batch_name , SUBSTR(di.vendor_name,1,22) , di.invoice_num , di.invoice_date , di.entered_by , di.invoice_amount , DECODE(di.igi_sap_flag, 'Y',fu2.user_name,fu3.user_name) Y IGI IGIPSAPR_XML AR IGI اعتماد الفاتورة الثانوي: الاعتماد الثانوي للفواتير (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الماليات الدولية للقطاع العام Source: اعتماد الفاتورة الثانوي: الاعتماد الثانوي للفواتير (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: IGIPSAPR_XML DB package: IGI_IGIPSAPR_XMLP_PKG D IGI Mehrfache Rechnungsprüfung: Mehrfache Rechnungsprüfung- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Public Sector Financials International Source: Mehrfache Rechnungsprüfung: Mehrfache Rechnungsprüfung (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: IGIPSAPR_XML DB package: IGI_IGIPSAPR_XMLP_PKG F IGI Approbation secondaire des factures : Approbation secondaire de factures- Non pris en charge : réservé pour une utilisation ultérieure Application: Public Sector Financials International Source: Approbation secondaire des factures : Approbation secondaire de factures (XML) - Non pris en charge : réservé pour une utilisation ultérieure Short Name: IGIPSAPR_XML DB package: IGI_IGIPSAPR_XMLP_PKG US IGI Secondary Invoice Approval : Secondary Approval of Invoices - draft Application: Public Sector Financials International Source: Secondary Invoice Approval : Secondary Approval of Invoices (XML) - Not Supported: Reserved For Future Use Short Name: IGIPSAPR_XML DB package: IGI_IGIPSAPR_XMLP_PKG ZHS IGI 辅助发票审批：辅助发票审批- 不支持：已保留供将来使用 Application: Public Sector Financials International Source: 辅助发票审批：辅助发票审批 (XML) - 不支持：已保留供将来使用 Short Name: IGIPSAPR_XML DB package: IGI_IGIPSAPR_XMLP_PKG BI Publisher :operating_unit :p_approver_id :p_batch_id :p_conc_request_id :p_debug_switch :p_end_date :p_group_id :p_invoice_id :p_release_code :p_release_lookup_code :p_release_lookup_code_1 :p_start_date :p_status_1 :p_status_2 :p_vendor_id :p_vendor_name 1 10 :p_release_lookup_code LOV Oracle IGI_SIA_AUTH_PEND Y select meaning id, meaning value, null description from igi_lookups where lookup_type='REPORTS' and lookup_code in ('AUTHORISED','PENDING') order by value,description AR الموقف F Statut US Status ZHS 状态 2 20 :p_group_id LOV Oracle IGI_SIA_GROUPS Y select group_id id, group_name value, null description from igi_sap_group order by group_name AR اسم المجموعة D Gruppe F Nom de groupe US Group Name ZHS 组名 3 30 :p_approver_id LOV Oracle IGI_SIA_APPROVERS Y select user_id id, user_name value, null description from fnd_user where user_id in (select approver_id from igi_sap_department_approvers where group_id=nvl(:$flex$.igi_sia_groups,group_id) ) order by value,description AR اسم مستخدم المعتمد D Benutzername Genehmigungsberechtigter F Nom utilisateur du responsable hiérarchique US Approver User Name ZHS 审批人用户名 4 40 :p_vendor_id LOV Oracle IGI_SIA_VENDORS Y select vendor_id id, vendor_name value, null description from po_vendors order by vendor_name AR اسم المورِّد D Lieferantenname F Nom fournisseur US Vendor Name ZHS 供应商名称 5 50 :p_batch_id LOV Oracle IGI_SIA_BATCH_NAMES Y select batch_id id, batch_name value, null description from ap_batches_all order by value,description AR اسم المجموعة D Stapel F Nom du lot US Batch Name ZHS 批名 6 60 :p_invoice_id LOV Oracle IGI_SIA_INVOICE_NUMS Y select invoice_id id, invoice_num value, null description from ap_invoices_all where vendor_id=nvl(:$flex$.igi_sia_vendors,vendor_id) order by value,description AR رقم الفاتورة D Rechnungs-Nr. F Numéro facture US Invoice Number ZHS 发票编号 7 70 :p_start_date Date AR تاريخ بداية الفاتورة D Startdatum Rechnung F Date début facture US Invoice Start Date ZHS 发票起始日期 8 80 :p_end_date Date AR تاريخ نهاية الفاتورة D Enddatum Rechnung F Date fin facture US Invoice End Date ZHS 发票终止日期