ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 C6E085D4723451A9E05362FB09050512 select rsh.receipt_num receipt_number, trunc(rsh.creation_date) receipt_creation_date, trunc(rsh.last_update_date) receipt_last_modified, pv.vendor_name supplier, pvs.vendor_site_code supplier_site, rsl.line_num receipt_line_num, rsl.quantity_received received_qty, rct1.primary_quantity adjustment_qty, trunc(rct1.creation_date) adjustment_date, po.segment1 po_number, ai.invoice_num invoice_number, alc.displayed_field invoice_status, ail.line_number invoice_line_number, ail.quantity_invoiced billed_qty, trunc(ail.creation_date) invoice_line_creation_date, haouv.name operating_unit, rct1.transaction_id adjutment_transaction_id from ap_invoices_all ai, ap_invoice_lines_all ail, po_vendors pv, po_vendor_sites_all pvs, po_headers_all po, rcv_shipment_headers rsh, rcv_shipment_lines rsl, rcv_transactions rct, rcv_transactions rct1, ap_lookup_codes alc, hr_all_organization_units_vl haouv where 1=1 and ai.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) and ai.invoice_id=ail.invoice_id and rct.transaction_id = ail.rcv_transaction_id and pv.vendor_id = ai.vendor_id and pvs.vendor_site_id = ai.vendor_site_id and po.po_header_id = rsl.po_header_id and rsl.shipment_line_id = rct.shipment_line_id and rct.shipment_header_id = rsh.shipment_header_id and rct1.shipment_header_id = rct.shipment_header_id and rct1.shipment_line_id = rct.shipment_line_id and rct1.transaction_type in ('CORRECT','RETURN TO VENDOR','REJECT','RETURN TO RECEIVING','ACCEPT') and rct1.creation_date > ail.creation_date and alc.lookup_type(+) ='NLS TRANSLATION' and alc.lookup_code = nvl(:p_approval_status,ap_invoices_pkg.get_approval_status(ai.invoice_id,ai.invoice_amount,ai.payment_status_flag,ai.invoice_type_lookup_code)) and ai.org_id = haouv.organization_id and (:p_approval_status is null or (upper(:p_approval_status) = 'PAID' and ai.payment_status_flag in ('Y','P')) or (upper(:p_approval_status) != 'PAID' and ap_invoices_pkg.get_approval_status(ai.invoice_id,ai.invoice_amount,ai.payment_status_flag,ai.invoice_type_lookup_code) = :p_approval_status) ) order by pv.vendor_name, pvs.vendor_site_code, rsh.receipt_num, rsl.line_num, rct1.transaction_id, ai.invoice_num, ail.line_number SQLAP AR AP تقرير الإيصالات المعدَّلة والمطابقة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: تقرير الإيصالات المعدلة والمطابقة Application: المدفوعات Source: تقرير الإيصالات المعدَّلة والمطابقة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: APXMTMRR_XML DB package: AP_APXMTMRR_XMLP_PKG D AP Abgeglichene und geänderte Wareneingänge- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Abgeglichene und geänderte Wareneingänge Application: Kreditoren Source: Abgeglichene und geänderte Wareneingänge (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: APXMTMRR_XML DB package: AP_APXMTMRR_XMLP_PKG E AP Informe Recepciones Confrontadas y Modificadas: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Informe de recepciones confrontadas y modificadas Application: Payables Source: Informe Recepciones Confrontadas y Modificadas (XML): No Admitido, Reservado para Uso Futuro Short Name: APXMTMRR_XML DB package: AP_APXMTMRR_XMLP_PKG F AP Etat des réceptions rapprochées et modifiées- Non pris en charge : réservé pour une utilisation future Imported from BI Publisher Description: Etat des réceptions rapprochées et modifiées Application: Payables Source: Etat des réceptions rapprochées et modifiées (XML) - Non pris en charge : réservé pour une utilisation future Short Name: APXMTMRR_XML DB package: AP_APXMTMRR_XMLP_PKG I AP Rapporto Incassi confrontati e modificati- non supportato: riservato per usi futuri Imported from BI Publisher Description: Rapporto Incassi confrontati e modificati Application: Payables Source: Rapporto Incassi confrontati e modificati (XML) - non supportato: riservato per usi futuri Short Name: APXMTMRR_XML DB package: AP_APXMTMRR_XMLP_PKG JA AP 照合済み受入と変更済み受入のレポート- 未サポート: 将来の使用のために予約 Imported from BI Publisher Description: 照合および修正受入レポート Application: Payables Source: 照合済み受入と変更済み受入のレポート(XML) - 未サポート: 将来の使用のために予約 Short Name: APXMTMRR_XML DB package: AP_APXMTMRR_XMLP_PKG KO AP 대응 및 수정된 수금 보고서- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 대응 및 수정된 수금 보고서 Application: Payables Source: 대응 및 수정된 수금 보고서(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: APXMTMRR_XML DB package: AP_APXMTMRR_XMLP_PKG PTB AP Relatório de Recebimentos Vinculados e Modificados- Não Suportado: Reservado Para Uso Futuro Imported from BI Publisher Description: Relat. de Receitas Modific. e Corresp. Application: Payables Source: Relatório de Recebimentos Vinculados e Modificados (XML) - Não Suportado: Reservado Para Uso Futuro Short Name: APXMTMRR_XML DB package: AP_APXMTMRR_XMLP_PKG RU AP Отчет о согласованных и измененных поступлениях- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Отчет о согласованных и измененных поступлениях Application: Кредиторы Source: Отчет о согласованных и измененных поступлениях (XML) - не поддерживается: зарезервировано для будущего использования Short Name: APXMTMRR_XML DB package: AP_APXMTMRR_XMLP_PKG S AP Matchade och ändrade inbetalningar - rapport- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Matchade och ändrade inbetalningar - rapport Application: Payables Source: Matchade och ändrade inbetalningar - rapport (XML) - Stöds inte: Reserverad för framtida bruk Short Name: APXMTMRR_XML DB package: AP_APXMTMRR_XMLP_PKG TR AP Eşleşen ve Değiştirilmiş Alınan Ödemeler Raporu- Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Imported from BI Publisher Description: Eşleşen ve Değiştirilmiş Alınan Ödemeler Raporu Application: Borçlar Muhasebesi Source: Eşleşen ve Değiştirilmiş Alınan Ödemeler Raporu (XML) - Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Short Name: APXMTMRR_XML DB package: AP_APXMTMRR_XMLP_PKG US AP Matched and Modified Receipts Imported from BI Publisher Description: Matched and Modified Receipts Report Application: Payables Source: Matched and Modified Receipts Report (XML) - Not Supported: Reserved For Future Use Short Name: APXMTMRR_XML DB package: AP_APXMTMRR_XMLP_PKG ZHS AP 匹配并修改的接收报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 匹配并修改的接收报表 Application: 应付帐款 Source: 匹配并修改的接收报表 (XML) - 不支持：已保留供将来使用 Short Name: APXMTMRR_XML DB package: AP_APXMTMRR_XMLP_PKG Enginatics 1=1 :operating_unit :p_approval_status 1 10 1=1 haouv.name=:p_operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) US Operating Unit Operating Unit. Leave null to report across all accessible Operating Units 2 20 1=1 pv.vendor_id=:p_vendor_id LOV Oracle AP_SRS_VENDOR_NAME Y select vendor_id id, vendor_name value, null description from po_vendors order by value,description AR اسم المورد اسم المورد D Lieferantenname Lieferantenname E Nombre de Proveedor Nombre de Proveedor F Nom du fournisseur Nom du fournisseur I Nome fornitore Nome del fornitore JA 仕入先名 仕入先名 KO 공급자명 공급자명 PTB Nome do Fornecedor Nome do Fornecedor RU Имя поставщика Имя поставщика S Leverantör Leverantör TR Tedarikçi Adı Tedarikçi Adı US Supplier Name Vendor Name ZHS 供应商名称 供应商名称 3 30 1=1 pvs.vendor_site_code=:p_vendor_site LOV Oracle AP_SRS_APXINHIS_VENDOR_SITE Y select pvs.vendor_site_code id, pvs.vendor_site_code value, null description from po_vendor_sites pvs,po_vendors pv where pvs.vendor_id=pv.vendor_id and pv.vendor_id=:$flex$.ap_srs_vendor_name order by vendor_site_code AR موقع المورد موقع المورد D Lieferantenadresse Lieferantenadresse E Dirección del Proveedor Dirección del Proveedor F Site fournisseur Site fournisseur I Sede fornitore Sede fornitore JA 仕入先サイト 仕入先サイト KO 공급자 지점 공급자 지점 PTB Local do Fornecedor Site do Fornecedor RU Отделение поставщика Отделение поставщика S Leverantörsplats Leverantörsplats TR Tedarikçi İşletme Birimi Tedarikçi İşletme Birimi US Supplier Site Vendor Site ZHS 供应商地点 供应商地点 4 40 1=1 rct1.creation_date>=:p_modify_from_date Date AR تاريخ تعديل الإيصال من تاريخ تعديل الإيصال من D Von Änderungsdatum Wareneingang Von Änderungsdatum Wareneingang E De Fecha de Modificación de Recepción De Fecha de Modificación de Recepción F Date de modification de réception - Du Date de modification de réception - Du I Data modifica ricezione - Da Data modifica ricezione - Da JA 受入修正日:自 受入修正日:自 KO 수금 수정 일자: 부터 수금 수정 일자: 부터 PTB Data Modific. Receita - De Data Modific. Receita - De RU Дата изменения поступления с Дата изменения поступления с S Ändra inbetalningsdatum från Ändra inbetalningsdatum från TR Alınan Ödeme Değişiklik Tarihi, İlk Alınan Ödeme Değişiklik Tarihi, İlk US Receipt Modify Date From Receipt Modify Date From ZHS 接收修改日期自 接收修改日期自 5 50 1=1 rct1.creation_date<:p_modify_to_date+1 Date last_day(:$flex$.receipt_modify_date_from) AR تاريخ تعديل الإيصال إلى تاريخ تعديل الإيصال إلى D Bis Änderungsdatum Wareneingang Bis Änderungsdatum Wareneingang E A Fecha de Modificación de Recepción A Fecha de Modificación de Recepción F Date de modification de réception - Au Date de modification de réception - Au I Data modifica incasso - A Data modifica incasso - A JA 受入修正日:至 受入修正日:至 KO 수금 수정 일자: 까지 수금 수정 일자: 까지 PTB Data Modific. Receita - Até Data Modific. Receita - Até RU Дата изменения поступления по Дата изменения поступления по S Ändra inbetalningsdatum till Ändra inbetalningsdatum till TR Alınan Ödeme Değişiklik Tarihi, Son Alınan Ödeme Değişiklik Tarihi, Son US Receipt Modify Date To Receipt Modify Date To ZHS 接收修改终止日期 接收修改终止日期 6 60 :p_approval_status LOV Oracle AP_SRS_APPROVAL_CODES Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where(lookup_type like 'NLS TRANSLATION' and lookup_code in ('APPROVED','NEVER APPROVED','PAID','NEEDS REAPPROVAL')) or (lookup_type='INVOICE STATUS' and lookup_code='PAID') order by value,description AR موقف الفاتورة موقف الفاتورة D Rechnungsstatus Rechnungsstatus E Estado de Factura Estado de Factura F Statut de la facture Statut de la facture I Stato fattura Stato fattura JA 請求書ステータス 請求書ステータス KO 송장 상태 송장 상태 PTB Status da NFF Status da NFF RU Статус СФ Статус СФ S Fakturastatus Fakturastatus TR Fatura Statüsü Fatura Statüsü US Invoice Status Invoice Status ZHS 发票状态 发票状态 :$flex$.ap_srs_vendor_name Supplier Name Supplier Site :$flex$.receipt_modify_date_from Receipt Modify Date From Y Receipt Modify Date To