ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F27B3869E053B46B63588994Y SELECT DISTINCT prj.segment1 project_number , prj.name , ap.invoice_num , pov.vendor_name contractor , poh.segment1 contract , ap.invoice_currency_code , ap.invoice_amount , rep.exception FROM AP_INVOICES ap , AP_INVOICE_LINES apl , po_vendors pov , PO_headers poh , PA_PWP_RELEASE_REPORT rep , pa_projects prj WHERE prj.project_id = rep.project_id AND ap.invoice_id = rep.ap_invoice_id AND ap.invoice_id = apl.invoice_id AND pov.vendor_id = ap.vendor_id AND apl.po_header_id = poh.po_header_id(+) AND rep.request_id = :P_REQUEST_ID AND rep.EXCEPTION IS NOT NULL PA PAPWPRIREP AR PA تدقيق حل الدفع عند الاستحقاق Application: المشروعات Source: AUD: تدقيق حل الدفع عند الاستحقاق Short Name: PAPWPRIREP DB package: PA_PAPWPRIREP_XMLP_PKG D PA Pay-When-Paid-Freigabeprotokoll Application: Projects Source: PA: Pay-When-Paid-Freigabeprotokoll Short Name: PAPWPRIREP DB package: PA_PAPWPRIREP_XMLP_PKG F PA Audit des déblocages des paiements à réception du règlement Application: Projects Source: AUD : Audit des déblocages des paiements à réception du règlement Short Name: PAPWPRIREP DB package: PA_PAPWPRIREP_XMLP_PKG US PA Pay When Paid Release Audit Application: Projects Source: AUD: Pay When Paid Release Audit Short Name: PAPWPRIREP DB package: PA_PAPWPRIREP_XMLP_PKG ZHS PA AUD：“背靠背付款”释放审核 Application: 项目 Source: AUD：“背靠背付款”释放审核 Short Name: PAPWPRIREP DB package: PA_PAPWPRIREP_XMLP_PKG BI Publisher :c_company_name_header :c_dummy_data :c_no_data_found :c_retcode :g_org_id :operating_unit :p_customer_name :p_customer_number :p_debug_mode :p_from_project_number :p_from_rec_date :p_mode :p_process_number :p_project_number :p_project_type :p_request_id :p_sort_by :p_to_project_number :p_to_rec_date 1 10 :p_request_id Number US REQUEST_ID 2 20 :p_mode LOV Oracle PA_SRS_PWP_MODE Y select meaning id, meaning value, description description from pa_lookups where lookup_type='PA_PWP_INV_REL_MODE' order by meaning AR الطور D Modus US Mode ZHS 模式 3 30 :p_project_type LOV Oracle PA_SRS_PROJECT_TYPE_PWP Y select project_type id, project_type value, description description from pa_project_types where project_type_class_code='CONTRACT' order by project_type AR نوع المشروع D Projektart F Type de projet US Project Type ZHS 项目类型 4 40 :p_project_number LOV Oracle PA_SRS_PWP_PROJECT_NUMBER Y select segment1 id, segment1 value, name description from pa_projects where template_flag!='Y' and project_type=nvl(:$flex$.pa_srs_project_type_pwp,project_type) order by segment1 AR رقم المشروع D Projektnummer F Numéro de projet US Project Number ZHS 项目编号 5 50 :p_from_project_number Char AR من رقم المشروع D Von Projektnummer F Du numéro de projet US From Project Number ZHS 自项目编号 6 60 :p_to_project_number Char AR من رقم المشروع D Von Projektnummer F Du numéro de projet US From Project Number ZHS 自项目编号 7 70 :p_customer_name LOV Oracle PA_SRS_CUST_NAME Y Y select customer_name id, customer_name value, customer_name description from pa_customer_name_v order by value,description AR اسم العميل D Kundenname F Nom du client US Customer Name ZHS 客户名称 8 80 :p_customer_number LOV Oracle PA_SRS_CUST_NUM_ID Y select customer_id id, cust_name_and_number value, cust_name_and_number description from pa_customer_lov_v where status='A' and customer_name=:$flex$.pa_srs_cust_name and (nvl(pa_customer_lov_v.site_use_code,'BILL_TO')<>'SHIP_TO' or not exists (select null from pa_customer_lov_v pc1 where pc1.customer_id=pa_customer_lov_v.customer_id and nvl(pc1.site_use_code,'BILL_TO')<>'SHIP_TO')) order by customer_name AR رقم العميل D Kundennummer F Numéro de client US Customer Number ZHS 客户编号 9 90 :p_from_rec_date Date AR من تاريخ استلام العميل D Von Kundenzahlungsdatum F Date de règlement client - Du US From Customer Receipt Date ZHS 自客户接收日期 10 100 :p_to_rec_date Date AR إلى تاريخ استلام العميل D Bis Kundenzahlungsdatum F Date de règlement client - Au US To Customer Receipt Date ZHS 至客户接收日期 11 110 :p_sort_by LOV Oracle PA_SRS_PWP_SORT Y select lookup_code id, meaning value, description description from pa_lookups where lookup_type='PA_PWP_REP_SORT_OPTIONS' order by meaning AR فرز حسب D Sortieren nach F Tri par US Sort By ZHS 排序依据