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）限制的操作单元。 41DAA5797A86CF93E06362FB0905DD8AY SELECT APC.bank_account_name bank_account_name ,APC.check_number ||'/'||&GC_ATTRIBUTE_COL check_number ,APC.check_date check_date ,APC.future_pay_due_date due_date ,APC.amount amount ,APC.vendor_name vendor_name ,APLC.displayed_field status ,APC.cleared_date cleared_date ,APC.cleared_amount cleared_amount ,SUM(APC.amount) over () general_total ,SYSDATE+ROUND((SUM((APC.future_pay_due_date-SYSDATE) *APC.amount) over ())/(SUM(APC.amount) over ()) ) avg_mat_date FROM ap_checks APC ,ap_lookup_codes APLC ,ap_suppliers APS WHERE &GC_WHERE AND APC.future_pay_due_date IS NOT NULL AND APC.payment_method_code = 'CHECK' AND APLC.lookup_type='CHECK STATE' AND APC.status_lookup_code = APLC.lookup_code AND APC.vendor_id= APS.vendor_id(+) ORDER BY APC.future_pay_due_date SQLAP APCHECKPAYSUPRPT AR AP حساب المدفوعات - مدفوعات الشيك إلى الموردين (2) Imported from BI Publisher Application: المدفوعات Source: حساب المدفوعات - مدفوعات الشيك إلى الموردين Short Name: APCHECKPAYSUPRPT DB package: AP_CHECK_PAYMT_SUPP_RPT_PKG D AP KR Scheckzahlungen an Lieferanten (2) Imported from BI Publisher Application: Kreditoren Source: KR Scheckzahlungen an Lieferanten Short Name: APCHECKPAYSUPRPT DB package: AP_CHECK_PAYMT_SUPP_RPT_PKG E AP Pagos con Cheques a Proveedores (1) Imported from BI Publisher Application: Payables Source: AP: Pagos con Cheques a Proveedores Short Name: APCHECKPAYSUPRPT DB package: AP_CHECK_PAYMT_SUPP_RPT_PKG F AP Règlements par chèque AP aux fournisseurs (2) Imported from BI Publisher Application: Payables Source: Règlements par chèque AP aux fournisseurs Short Name: APCHECKPAYSUPRPT DB package: AP_CHECK_PAYMT_SUPP_RPT_PKG I AP Pagamenti con assegno a fornitori AP (1) Imported from BI Publisher Application: Payables Source: Pagamenti con assegno a fornitori AP Short Name: APCHECKPAYSUPRPT DB package: AP_CHECK_PAYMT_SUPP_RPT_PKG JA AP 仕入先へのAP小切手支払 (1) Imported from BI Publisher Application: Payables Source: 仕入先へのAP小切手支払 Short Name: APCHECKPAYSUPRPT DB package: AP_CHECK_PAYMT_SUPP_RPT_PKG KO AP 공급자에게 AP 수표 지급 (1) Imported from BI Publisher Application: Payables Source: 공급자에게 AP 수표 지급 Short Name: APCHECKPAYSUPRPT DB package: AP_CHECK_PAYMT_SUPP_RPT_PKG PTB AP - Verificar Pagamentos para Fornecedores (1) Imported from BI Publisher Application: Payables Source: AP - Verificar Pagamentos para Fornecedores Short Name: APCHECKPAYSUPRPT DB package: AP_CHECK_PAYMT_SUPP_RPT_PKG RU AP Платеж чеком КР поставщикам (1) Imported from BI Publisher Application: Кредиторы Source: Платеж чеком КР поставщикам Short Name: APCHECKPAYSUPRPT DB package: AP_CHECK_PAYMT_SUPP_RPT_PKG S AP Checkbetalningar till leverantörer (1) Imported from BI Publisher Application: Payables Source: AP: Checkbetalningar till leverantörer Short Name: APCHECKPAYSUPRPT DB package: AP_CHECK_PAYMT_SUPP_RPT_PKG TR AP Tedarikçilere AP Çek Ödemeleri (1) Imported from BI Publisher Application: Borçlar Muhasebesi Source: Tedarikçilere AP Çek Ödemeleri Short Name: APCHECKPAYSUPRPT DB package: AP_CHECK_PAYMT_SUPP_RPT_PKG US AP Check Payments to Suppliers (2) Imported from BI Publisher Application: Payables Source: AP Check Payments to Suppliers Short Name: APCHECKPAYSUPRPT DB package: AP_CHECK_PAYMT_SUPP_RPT_PKG ZHS AP 用支票向供应商付款 (2) Imported from BI Publisher Application: 应付帐款 Source: AP 用支票向供应商付款 Short Name: APCHECKPAYSUPRPT DB package: AP_CHECK_PAYMT_SUPP_RPT_PKG BI Publisher 1=1 :gc_attribute :gc_attribute_col :gc_where :operating_unit :p_check_date_from :p_check_date_to :p_check_due_date_from :p_check_due_date_to :p_check_stat :p_currency :p_vndr_number_from :p_vndr_number_to 1 0 :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) Y US Operating Unit Required Operating Unit restriction for reports working in single operating unit mode only 2 10 :p_vndr_number_from LOV Oracle AP_SRS_VENDOR_NUMBER Y select segment1 id, segment1 value, null description from po_vendors order by segment1 AR رقم المورد من رقم المورد من D Von Lieferantennummer Von Lieferantennummer E De Número de Proveedor De Número de Proveedor F Numéro fournisseur - De Numéro fournisseur - De I Numero fornitore - Da Numero del fornitore - Da JA 仕入先番号: 自 仕入先番号: 自 KO 공급자 번호: 부터 공급자 번호: 부터 PTB Número do Fornecedor - De Número do Fornecedor - De RU Начальный номер поставщика Начальный номер поставщика S Från leverantörsnummer Från leverantörsnummer TR İlk Tedarikçi Numarası İlk Tedarikçi Numarası US Vendor Number From Vendor Number From ZHS 供应商编号自 供应商编号自 3 20 :p_vndr_number_to LOV Oracle AP_SRS_VENDOR_NUMBER Y select segment1 id, segment1 value, null description from po_vendors order by segment1 AR رقم المورد إلى رقم المورد إلى D Bis Lieferantennummer Bis Lieferantennummer E A Número de Proveedor A Número de Proveedor F Numéro fournisseur - A Numéro fournisseur - A I Numero fornitore - A Numero del fornitore - A JA 仕入先番号: 至 仕入先番号: 至 KO 공급자 번호: 까지 공급자 번호: 까지 PTB Número do Fornecedor - Até Número do Fornecedor - Até RU Конечный номер поставщика Конечный номер поставщика S Till leverantörsnummer Till leverantörsnummer TR Son Tedarikçi Numarası Son Tedarikçi Numarası US Vendor Number To Vendor Number To ZHS 供应商编号至 供应商编号至 4 30 :p_check_date_from Date sysdate AR من تاريخ الشيك من تاريخ الشيك D Von Scheckdatum Von Scheckdatum E De Fecha de Cheque De fecha de cheque F Date du chèque - Du Date du chèque - Du I Data assegno - Da Data dell'assegno - Da JA 小切手日付:自 小切手日付:自 KO 수표 일자: 부터 수표 일자: 부터 PTB Data de Verificação - De Data de Verificação - De RU Дата чека с Дата чека с S Från utbetalningsdatum Från utbetalningsdatum TR İlk Çek Tarihi İlk Çek Tarihi US From Check Date From Check Date ZHS 自支票日期 自支票日期 5 40 :p_check_date_to Date sysdate AR إلى تاريخ الشيك إلى تاريخ الشيك D Bis Scheckdatum Bis Scheckdatum E A Fecha de Cheque A fecha de cheque F Date du chèque - Au Date du chèque - Au I Data assegno - A Data dell'assegno - A JA 小切手日付:至 小切手日付:至 KO 수표 일자: 까지 수표 일자: 까지 PTB Data de Verificação - Até Data de Verificação - Até RU Дата чека по Дата чека по S Till utbetalningsdatum Till utbetalningsdatum TR Son Çek Tarihi Son Çek Tarihi US To Check Date To Check Date ZHS 至支票日期 至支票日期 6 50 :p_check_due_date_from Date sysdate AR من تاريخ استحقاق الشيك من تاريخ استحقاق الشيك D Von Scheckfälligkeit Von Scheckfälligkeit E De Fecha de Vencimiento de Cheque De fecha de vencimiento de cheque F Date d'échéance du chèque - Du Date d'échéance du chèque - Du I Data scadenza assegno - Da Data di scadenza dell'assegno - Da JA 小切手期日:自 小切手期日:自 KO 수표 만기 일자: 부터 수표 만기 일자: 부터 PTB Data de Vencimento da Verificação - De Data de Vencimento da Verificação - De RU Срок чека с Срок чека с S Från sista utbetalningsdatum Från sista utbetalningsdatum TR İlk Çek Vade Tarihi İlk Çek Vade Tarihi US From Check Due Date From Check Due Date ZHS 自支票到期日 自支票到期日 7 60 :p_check_due_date_to Date sysdate AR إلى تاريخ استحقاق الشيك إلى تاريخ استحقاق الشيك D Bis Scheckfälligkeit Bis Scheckfälligkeit E A Fecha de Vencimiento de Cheque A fecha de vencimiento de cheque F Date d'échéance du chèque - Au Date d'échéance du chèque - Au I Data scadenza assegno - A Data di scadenza dell'assegno - A JA 小切手期日:至 小切手期日:至 KO 수표 만기 일자: 까지 수표 만기 일자: 까지 PTB Data de Vencimento da Verificação - Até Data de Vencimento da Verificação - Até RU Срок чека по Срок чека по S Till sista utbetalningsdatum Till sista utbetalningsdatum TR Son Çek Vade Tarihi Son Çek Vade Tarihi US To Check Due Date To Check Due Date ZHS 至支票到期日 至支票到期日 8 70 :p_currency LOV Oracle AP_SRS_CURRENCY Y select currency_code id, currency_code value, description description from fnd_currencies_vl where currency_flag='Y' and enabled_flag in ('Y','N') order by currency_code SELECT currency_code FROM hr_organization_information O1, hr_organization_information O2, gl_ledgers_public_v GL WHERE O1.organization_id = O2.organization_id AND O1.organization_id = MO_GLOBAL.get_current_org_id AND O1.org_information_context = 'CLASS' AND O2.org_information_context = 'Operating Unit Information' AND O1.org_information1 = 'OPERATING_UNIT' AND O1.org_information2 = 'Y' AND O2.org_information3 = GL.ledger_id AND GL.ledger_category_code='PRIMARY' AR عملة الشيك عملة الشيك D Scheckwährung Scheckwährung E Divisa del Cheque Divisa del cheque F Devise du chèque Devise du chèque I Divisa assegno Divisa dell'assegno JA 小切手通貨 小切手通貨 KO 수표 통화 수표 통화 PTB Moeda do Cheque Moeda do Cheque RU Валюта чека Валюта чека S Kontrollera valuta Kontrollera valuta TR Çek Para Birimi Çek Para Birimi US Check Currency Check Currency ZHS 支票币种 支票币种 9 80 :p_check_stat LOV Oracle AP_SRS_PAYMENT_STATUS Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where lookup_type='CHECK STATE' order by value,description AR موقف الشيك موقف الشيك D Scheckstatus Scheckstatus E Estado del Cheque Estado del cheque F Statut du chèque Statut du chèque I Stato assegno Stato dell'assegno JA 小切手ステータス 小切手ステータス KO 수표 상태 수표 상태 PTB Verificar Status Verificar Status RU Статус чека Статус чека S Kontrollstatus Kontrollstatus TR Çek Statüsü Çek Statüsü US Check Status Check Status ZHS 支票状态 支票状态