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）限制的操作单元。 FA29CD1A233936B0E05362FB09056125 SELECT pv.vendor_id vendor_id1, lc.displayed_field exception4, lc.lookup_code exception_code1 FROM po_vendors pv, ap_lookup_codes lc WHERE ( nvl ( pv.federal_reportable_flag , 'N' ) = 'Y' AND exists ( SELECT /*+ NO_UNNEST */ 'site exists' FROM po_vendor_sites WHERE vendor_id = pv.vendor_id ) AND not exists ( SELECT /*+ NO_UNNEST */ 'no 1099 site' FROM po_vendor_sites WHERE nvl ( tax_reporting_site_flag , 'N' ) = 'Y' AND vendor_id = pv.vendor_id ) AND lc.lookup_type = '1099 VENDOR EXCEPTION' AND lc.lookup_code = 'NO 1099 SITE' ) AND ( :vendor_id = pv.vendor_id) UNION SELECT pv.vendor_id vendor_id1, lc.displayed_field exception4, lc.lookup_code exception_code1 FROM po_vendors pv, ap_lookup_codes lc, (SELECT distinct person_id ,national_identifier FROM PER_ALL_PEOPLE_F) papf --bug6050423 WHERE ( ( pv.num_1099 is null OR replace ( replace ( nvl ( papf.national_identifier , nvl ( Pv.individual_1099 , Pv.num_1099 ) ) , '-' , '' ) , ' ' , '' ) is null OR replace ( replace ( nvl ( papf.national_identifier , nvl ( Pv.individual_1099 , Pv.num_1099 ) ) , '-' , '' ) , ' ' , '' ) = '000000000' ) AND nvl ( pv.federal_reportable_flag , 'N' ) = 'Y' AND lc.lookup_type = '1099 VENDOR EXCEPTION' AND lc.lookup_code = 'NULL TIN' AND nvl ( Pv.employee_id , - 99 ) = papf.person_id (+) ) AND ( :vendor_id = pv.vendor_id) UNION SELECT pv.vendor_id vendor_id1, lc.displayed_field exception4, lc.lookup_code exception_code1 FROM po_vendors pv, ap_lookup_codes lc WHERE ( pv.organization_type_lookup_code IS NULL AND nvl ( pv.federal_reportable_flag , 'N' ) = 'Y' AND lc.lookup_type = '1099 VENDOR EXCEPTION' AND lc.lookup_code = 'NULL ORGANIZATION TYPE' ) AND ( :vendor_id = pv.vendor_id) UNION SELECT pv.vendor_id vendor_id1, lc.displayed_field exception4, lc.lookup_code exception_code1 FROM po_vendor_sites pvs, ap_lookup_codes lc, po_vendors pv WHERE ( pvs.vendor_id = pv.vendor_id AND nvl ( pv.federal_reportable_flag , 'N' ) = 'Y' AND lc.lookup_type = '1099 VENDOR EXCEPTION' AND ( nvl ( pvs.tax_reporting_site_flag , 'N' ) = 'Y' OR EXISTS ( SELECT /*+ NO_UNNEST */ 'Only One Site Exists' FROM po_vendor_sites pvs1 WHERE pvs1.vendor_id = pv.vendor_id GROUP BY pvs1.vendor_id HAVING count ( * ) = 1 ) ) AND ( ( pvs.state is null and substr ( nvl ( pv.organization_type_lookup_code , 1 ) , 1 , 7 ) != 'FOREIGN' and lc.lookup_code = 'NULL STATE' ) OR ( lc.lookup_code = 'NON-STANDARD STATE' and substr ( nvl ( pv.organization_type_lookup_code , 1 ) , 1 , 7 ) != 'FOREIGN' and not exists ( SELECT /*+ NO_UNNEST */ 'Match on state' FROM AP_Income_Tax_Regions WHERE pvs.state = region_short_name AND sysdate < nvl ( inactive_date , sysdate + 1 ) AND sysdate >= nvl ( active_date , sysdate ) ) and pvs.state is not null ) OR ( lc.lookup_code = 'NULL ADDRESS LINES' and ( ( pvs.address_line1 is NULL or pvs.city is NULL or pvs.zip is null ) and substr ( nvl ( pv.organization_type_lookup_code , 1 ) , 1 , 7 ) != 'FOREIGN' ) ) OR ( lc.lookup_code = 'NULL FOREIGN ADDRESS' and ( ( pvs.address_line1 is NULL or pvs.country is null ) and substr ( nvl ( pv.organization_type_lookup_code , 1 ) , 1 , 7 ) = 'FOREIGN' ) ) ) ) AND ( :vendor_id = pv.vendor_id) UNION SELECT pv.vendor_id vendor_id1,lc.displayed_field exception4, lc.lookup_code exception_code1 FROM po_vendors pv, ap_lookup_codes lc WHERE ( nvl ( pv.federal_reportable_flag , 'N' ) = 'Y' AND substr ( nvl ( pv.organization_type_lookup_code , 1 ) , 1 , 7 ) = 'FOREIGN' AND lc.lookup_type = '1099 VENDOR EXCEPTION' AND lc.lookup_code = 'FOREIGN VENDOR' ) AND ( :vendor_id = pv.vendor_id) UNION SELECT pv.vendor_id vendor_id1, lc.displayed_field exception4, lc.lookup_code exception_code1 FROM po_vendors pv, po_vendors pv2 , ap_lookup_codes lc, (SELECT distinct person_id ,national_identifier FROM PER_ALL_PEOPLE_F) papf, --bug6050423 (SELECT distinct person_id ,national_identifier FROM PER_ALL_PEOPLE_F) papf1--bug6050423 WHERE ( nvl ( papf.national_identifier , nvl ( Pv.individual_1099 , Pv.num_1099 ) ) = nvl ( papf.national_identifier , nvl ( Pv.individual_1099 , Pv.num_1099 ) ) AND nvl ( pv.federal_reportable_flag , 'N' ) = 'Y' AND substr ( nvl ( pv.organization_type_lookup_code , 1 ) , 1 , 7 ) != 'FOREIGN' AND nvl ( pv2.federal_reportable_flag , 'N' ) = 'Y' AND pv2.vendor_id != pv.vendor_id AND substr ( nvl ( pv2.organization_type_lookup_code , 1 ) , 1 , 7 ) != 'FOREIGN' AND lc.lookup_type = '1099 VENDOR EXCEPTION' AND lc.lookup_code = 'DUPLICATE TIN' AND nvl ( Pv.employee_id , - 99 ) = papf.person_id (+) AND nvl ( Pv2.employee_id , - 99 ) = papf1.person_id (+) ) AND ( :vendor_id = pv.vendor_id) UNION SELECT pv.vendor_id vendor_id1,lc.displayed_field exception4, lc.lookup_code exception_code1 FROM po_vendors pv , ap_lookup_codes lc, (SELECT distinct person_id ,national_identifier FROM PER_ALL_PEOPLE_F) papf --bug6050423 WHERE ( nvl ( pv.federal_reportable_flag , 'N' ) = 'Y' AND substr ( nvl ( pv.organization_type_lookup_code , 1 ) , 1 , 7 ) != 'FOREIGN' AND ( length ( replace ( replace ( nvl ( papf.national_identifier , nvl ( Pv.individual_1099 , Pv.num_1099 ) ) , '-' , '' ) , ' ' , '' ) ) != 9 OR nvl ( length ( ltrim ( translate ( replace ( replace ( nvl ( papf.national_identifier , nvl ( Pv.individual_1099 , Pv.num_1099 ) ) , '-' , '' ) , ' ' , '' ) , '1234567890' , '1111111111' ) , '1' ) ) , 0 ) != 0 ) AND lc.lookup_type = '1099 VENDOR EXCEPTION' AND lc.lookup_code = 'NON-STANDARD TIN' AND nvl ( Pv.employee_id , - 99 ) = papf.person_id (+) ) AND ( :vendor_id = pv.vendor_id) SQLAP APXTRVEE_XML AR AP تقرير استثناءات المورِّدين 1099 (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل (1) Imported from BI Publisher Description: تقرير استثناءات موردي 1099 Application: المدفوعات Source: تقرير استثناءات المورِّدين 1099 (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: APXTRVEE_XML DB package: AP_APXT7VEE_XMLP_PKG D AP US-Steuerformular 1099 - Fehlerprotokoll Lieferanten- Nicht unterstützt: Reserviert für zukünftige Verwendung (1) Imported from BI Publisher Description: US-Steuerformular 1099 - Fehlerprotokoll Lieferanten Application: Kreditoren Source: US-Steuerformular 1099 - Fehlerprotokoll Lieferanten (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: APXTRVEE_XML DB package: AP_APXT7VEE_XMLP_PKG E AP Informe Excepciones de Proveedor 1099: No Admitido, Reservado para Uso Futuro (1) Imported from BI Publisher Description: Informe 1099 de excepciones de proveedor Application: Payables Source: Informe Excepciones de Proveedor 1099 (XML): No Admitido, Reservado para Uso Futuro Short Name: APXTRVEE_XML DB package: AP_APXT7VEE_XMLP_PKG F AP Etat des informations périmées sur les fournisseurs d'honoraires- Non pris en charge : réservé pour une utilisation future (1) Imported from BI Publisher Description: Etat des informations périmées sur les fournisseurs d'honoraires Application: Payables Source: Etat des informations périmées sur les fournisseurs d'honoraires (XML) - Non pris en charge : réservé pour une utilisation future Short Name: APXTRVEE_XML DB package: AP_APXT7VEE_XMLP_PKG I AP Rapporto Eccezioni fornitore 1099- non supportato: riservato per usi futuri (1) Imported from BI Publisher Description: Rapporto Eccezioni fornitore 1099 (US) Application: Payables Source: Rapporto Eccezioni fornitore 1099 (XML) - non supportato: riservato per usi futuri Short Name: APXTRVEE_XML DB package: AP_APXT7VEE_XMLP_PKG JA AP 1099仕入先例外レポート- 未サポート: 将来の使用のために予約 (1) Imported from BI Publisher Description: 1099仕入先例外レポート Application: Payables Source: 1099仕入先例外レポート(XML) - 未サポート: 将来の使用のために予約 Short Name: APXTRVEE_XML DB package: AP_APXT7VEE_XMLP_PKG KO AP 1099 공급자 예외 보고서- 지원되지 않음: 추후 사용을 위해 예약됨 (1) Imported from BI Publisher Description: 1099 공급자 예외 보고서 Application: Payables Source: 1099 공급자 예외 보고서(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: APXTRVEE_XML DB package: AP_APXT7VEE_XMLP_PKG PTB AP Relatório de Exceções do Fornecedor 1099- Não Suportado: Reservado Para Uso Futuro (1) Imported from BI Publisher Description: Relatório de Exceções do Fornecedor 1099 Application: Payables Source: Relatório de Exceções do Fornecedor 1099 (XML) - Não Suportado: Reservado Para Uso Futuro Short Name: APXTRVEE_XML DB package: AP_APXT7VEE_XMLP_PKG RU AP Отчет об исключениях поставщиков 1099- не поддерживается: зарезервировано для будущего использования (1) Imported from BI Publisher Description: Отчет об исключениях поставщиков 1099 Application: Кредиторы Source: Отчет об исключениях поставщиков 1099 (XML) - не поддерживается: зарезервировано для будущего использования Short Name: APXTRVEE_XML DB package: AP_APXT7VEE_XMLP_PKG S AP 1099-leverantörsavvikelser - rapport- Stöds inte: Reserverad för framtida bruk (1) Imported from BI Publisher Description: 1099-leverantörsavvikelser - rapport Application: Payables Source: 1099-leverantörsavvikelser - rapport (XML) - Stöds inte: Reserverad för framtida bruk Short Name: APXTRVEE_XML DB package: AP_APXT7VEE_XMLP_PKG TR AP 1099 Tedarikçi İstisnaları Raporu- Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır (1) Imported from BI Publisher Description: 1099 Tedarikçi İstisnalar Raporu Application: Borçlar Muhasebesi Source: 1099 Tedarikçi İstisnaları Raporu (XML) - Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Short Name: APXTRVEE_XML DB package: AP_APXT7VEE_XMLP_PKG US AP 1099 Supplier Exceptions Report- Not Supported: Reserved For Future Use (1) Imported from BI Publisher Description: 1099 Supplier Exceptions Report Application: Payables Source: 1099 Supplier Exceptions Report (XML) - Not Supported: Reserved For Future Use Short Name: APXTRVEE_XML DB package: AP_APXT7VEE_XMLP_PKG ZHS AP 1099 供应商例外报表- 不支持：已保留供将来使用 (1) Imported from BI Publisher Description: 1099 供应商例外报表 Application: 应付帐款 Source: 1099 供应商例外报表 (XML) - 不支持：已保留供将来使用 Short Name: APXTRVEE_XML DB package: AP_APXT7VEE_XMLP_PKG BI Publisher 1=1 :applications_template_report :c_balancing_segment :c_base_currency_code :c_base_description :c_base_min_acct_unit :c_base_precision :c_chart_of_accounts_id :c_company_name_header :c_dynamic_sql :c_misc_total :c_nls_all :c_nls_end_of_report :c_nls_na :c_nls_no :c_nls_no_data_exists :c_nls_void :c_nls_yes :c_rep_entity_name :c_report_start_date :c_reportable_only :cp_payment_date :operating_unit :p_conc_request_id :p_debug_switch :p_end_date :p_flexdata :p_min_precision :p_query_driver :p_rep_entity_id :p_set_of_books_id :p_start_date :p_trace_switch 1 -20 :p_set_of_books_id Char fnd_profile.value('GL_SET_OF_BKS_ID') AR دفتر الأستاذ دفتر الأستاذ D Buch Buch E Libro Mayor Libro mayor F Livre Livre I Libro contabile Libro contabile JA 元帳 元帳 KO 원장 원장 PTB Razão Razão RU Книга Книга S Huvudbok Huvudbok TR Defter Defter US Ledger Ledger ZHS 分类帐 分类帐 2 -10 :debugflag Char N AR علامة معالجة الأخطاء علامة معالجة أخطاء D DebugFlag Debug-Kennzeichen E Indicador de Depuración Indicador de Depuración F Indicateur Diagnostic Indicateur Diagnostic I Flag Debug Flag Debug JA デバッグ・フラグ デバッグ・フラグ KO 디버그 플래그 디버그 플래그 PTB DebugFlag Indicador de Depuração RU Флаг отладки Флаг отладки S DebugFlag Felsökningsflagga TR Hata Ayıklama İşareti Hata Ayıklama İşareti US DebugFlag Debug Flag ZHS 调试标志 调试标志 3 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 4 10 :p_rep_entity_id LOV Oracle AP_SRS_TAX_REPORTING_ENTITIES Y select tax_entity_id id, entity_name value, null description from ap_reporting_entities order by value,description select entity_name from ap_reporting_entities where 1 = (select count(*) from ap_reporting_entities) Y AR كيان التقرير اسم كيان التقرير الذي ترغب في تشغيل تقريرك له D Steuerpflichtiger Der Steuerpflichtige, für den Sie die Auswertung starten möchten E Entidad Fiscal El nombre de la entidad fiscal a la que desee ejecutar el informe F Entité de reporting Nom de l'entité de reporting pour laquelle vous voulez éditer l'état I Soggetto fiscale Nome del soggetto fiscale per cui si desidera eseguire il rapporto JA レポート・エンティティ 実行要求されているレポート・エンティティ名称 KO 보고 개체 보고서를 실행하려는 보고 개체 이름 PTB Entidade para geração de relatórios O nome da entidade de emissão de relatórios a qual você deseja executar o relatório RU Отчетная единица Имя отчетной единицы, для которой следует выполнить отчет S Rapporteringsenhet Namnet på den rapportentitet som du vill köra en rapport för TR Raporlama Tüzel Kişiliği Raporunuzu kendisi için çalıştırmak istediğiniz raporlama tüzel kişiliğinin adı US Reporting Entity The name of the reporting entity for which you wish to run your report ZHS 申报实体 您要运行报表的申报实体名称 5 20 :p_start_date Date AR من تاريخ السداد تاريخ بداية وضع المدفوعات في الاعتبار D Von Zahlungsdatum Datum, ab dem Zahlungen berücksichtigt werden E De Fecha de Pago Fecha de inicio desde la que deben considerarse los pagos F Date de règlement - Du Date à partir de laquelle les règlements doivent être pris en compte I Data pagamento - Da Data iniziale da cui considerare i pagamenti JA 支払日:自 支払が行われた日 KO 지급 일자: 부터 지급 수단 고려 시작 일자 PTB Data do Pagamento - De Data inicial a partir da qual os pagamentos serão considerados RU Дата платежа с Дата, начиная с которой анализируются платежи S Från betalningsdatum Startdatum för förväntade betalningar TR İlk Ödeme Tarihi Ödemelerin dikkate alınacağı başlangıç tarihi US From Payment Date Start date from which payments are to be considered ZHS 自付款日期 要考虑付款的起始日期 6 30 :p_end_date Date sysdate AR إلى تاريخ السداد تاريخ نهاية وضع المدفوعات في الاعتبار D Bis Zahlungsdatum Das Datum, bis zu dem Zahlungen berücksichtigt werden E A Fecha de Pago Última fecha hasta la que deben considerarse los pagos F Date de règlement - Au Date jusqu'à laquelle les règlements doivent être pris en compte I Data pagamento - A Data finale da cui verranno considerati i pagamenti JA 支払日:至 支払の最終日とみなされます KO 지급 일자: 까지 지급이 고려될 최종 일자 PTB Data do Pagamento - Até Data final a partir da qual os pagamentos serão considerados RU Дата платежа по Дата, после которой платежи не анализируются S Till betalningsdatum Slutdatum för förväntade betalningar TR Son Ödeme Tarihi Ödemelerin dikkate alınacağı son tarih US To Payment Date Last date from which payments will be considered ZHS 至付款日期 要考虑付款的最后日期 7 40 :p_min_rep_flag LOV Oracle AP_SRS_YES_NO_MAND Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y' Y AR موردين قابلين لتقرير فقط يتضمن موردين يقابلوا الحد الأدنى لمستويات التقرير فقط (ن/ل) D Nur steuerpflichtige Lieferanten Nur Lieferanten, die die Mindestanforderungen zur Steuererklärung erfüllen (J/N) E Sólo Proveedores Declarados Incluir Proveedores que cumplen sólo los niveles mínimos de declaración (S/N): F Fournisseurs soumis à la déclaration seulement Inclure uniquement les fournisseurs atteignant les niveaux minimum de déclaration (O/N) : I Solo fornitori dichiarabili Includi fornitori rispondenti solo a livelli minimi (S/N) JA 仕入先のみレポート可能 最小レポートレベルのみに合致する仕入先を含む (Y/N): KO 보고가능 공급자만 최소 보고 수준만 충족시키는 공급자 포함 (Y/N): PTB Apenas Fornecedores Declaráveis Incluir apenas os Fornecedores que satisfaçam os níveis mínimos de emissão de relatórios (S/N): RU Только подотчетные поставщики Включить только поставщиков, соответствующих минимальному уровню отчетности (Д/Н): S Bara rapporteringsbara leverantörer Inkludera leverantörer som bara uppfyller de lägsta rapportnivåerna (J/N): TR Salt Raporlanabilir Tedarikçiler Minimum raporlama düzeylerini karşılayan Tedarikçileri dahil et (Y/N): US Reportable Suppliers Only Include Suppliers meeting minimum reporting levels only (Y/N): ZHS 仅限于可申报的供应商 仅包括满足最低申报层的供应商（是/否）： :$flex$.ledger Ledger Operating Unit