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）限制的操作单元。 C6E085D46F3F51A9E05362FB09050512Y select a.*, AR_ARXINVAD_XMLP_PKG.c_new_recordsformula(a.doc_sequence_value) C_new_records, AR_ARXINVAD_XMLP_PKG.C_last_value_p C_last_value from (SELECT aud.doc_sequence_value doc_sequence_value, aud.doc_sequence_id doc_sequence_id, aud.creation_date creation_date, decode( cr.doc_sequence_value, null, :C_deleted, :C_entered) status, dsc.name category, c.account_number customer_num, substrb(party.party_name,1,50) customer_name, cr.receipt_number invoice_num, cr.currency_code invoice_currency_code, cr.amount invoice_amount FROM ar_doc_sequence_audit aud, fnd_doc_sequence_assignments dsa, fnd_doc_sequence_categories dsc, hz_cust_accounts c, hz_parties party, ar_cash_receipts_all cr WHERE aud.doc_sequence_id = :p_sequence_id AND aud.doc_sequence_id = cr.doc_sequence_id(+) AND aud.doc_sequence_value = cr.doc_sequence_value(+) AND aud.doc_sequence_value BETWEEN :P_sequence_from AND :P_sequence_to AND aud.doc_sequence_assignment_id = dsa.doc_sequence_assignment_id AND dsa.category_code = dsc.code AND dsa.application_id = dsc.application_id AND cr.pay_from_customer = c.cust_account_id(+) AND c.party_id = party.party_id(+) AND :p_type = 'RECEIPT' UNION SELECT aud.doc_sequence_value doc_sequence_value, aud.doc_sequence_id doc_sequence_id, aud.creation_date creation_date, decode( ct.doc_sequence_value, null, :C_deleted, :C_entered ) status, dsc.name category, c.account_number customer_num, substrb(party.party_name,1,50) customer_name, ct.trx_number invoice_num, ct.invoice_currency_code invoice_currency_code, ctl.amount invoice_amount FROM ar_doc_sequence_audit aud, fnd_doc_sequence_assignments dsa, fnd_doc_sequence_categories dsc, hz_cust_accounts c, hz_parties party, ra_customer_trx_all ct, ra_cust_trx_line_gl_dist_all ctl WHERE aud.doc_sequence_id = :p_sequence_id AND aud.doc_sequence_id = ct.doc_sequence_id(+) AND aud.doc_sequence_value = ct.doc_sequence_value(+) AND aud.doc_sequence_value BETWEEN :P_sequence_from AND :P_sequence_to AND aud.doc_sequence_assignment_id = dsa.doc_sequence_assignment_id AND dsa.category_code = dsc.code AND dsa.application_id = dsc.application_id AND ct.bill_to_customer_id = c.cust_account_id(+) AND c.party_id = party.party_id(+) AND ct.customer_trx_id = ctl.customer_trx_id(+) AND nvl(ctl.account_class,'REC') = 'REC' AND nvl(ctl.latest_rec_flag,'Y') = 'Y' AND :p_type = 'INVOICE' UNION SELECT aud.doc_sequence_value doc_sequence_value, aud.doc_sequence_id doc_sequence_id, aud.creation_date creation_date, decode( adj.doc_sequence_value, null, :C_deleted, :C_entered ) status, dsc.name category, c.account_number customer_num, substrb(party.party_name,1,50) customer_name, adj.adjustment_number invoice_num, ps.invoice_currency_code invoice_currency_code, adj.amount invoice_amount FROM ar_doc_sequence_audit aud, fnd_doc_sequence_assignments dsa, fnd_doc_sequence_categories dsc, ar_payment_schedules_all ps, hz_cust_accounts c, hz_parties party, ra_customer_trx_all ct, ar_adjustments_all adj WHERE aud.doc_sequence_id = :p_sequence_id AND aud.doc_sequence_id = adj.doc_sequence_id(+) AND aud.doc_sequence_value = adj.doc_sequence_value(+) AND aud.doc_sequence_value BETWEEN :P_sequence_from AND :P_sequence_to AND aud.doc_sequence_assignment_id = dsa.doc_sequence_assignment_id AND dsa.category_code = dsc.code AND dsa.application_id = dsc.application_id AND adj.customer_trx_id = ct.customer_trx_id(+) AND ct.bill_to_customer_id = c.cust_account_id(+) AND c.party_id = party.party_id(+) AND adj.payment_schedule_id = ps.payment_schedule_id(+) AND :p_type = 'ADJUSTMENT' ORDER BY 1) a AR ARXINVAD_XML AR AR تقرير التدقيق حسب رقم المستند (بتنسيق XML) Imported from BI Publisher Description: تقرير التدقيق حسب رقم المستند Application: المقبوضات Source: تقرير التدقيق حسب رقم المستند (بتنسيق XML) Short Name: ARXINVAD_XML DB package: AR_ARXINVAD_XMLP_PKG D AR Prüfprotokoll nach Belegnummer Imported from BI Publisher Description: Auswertung "Prüfprotokoll nach Belegnummer" Application: Debitoren Source: Prüfprotokoll nach Belegnummer (XML) Short Name: ARXINVAD_XML DB package: AR_ARXINVAD_XMLP_PKG E AR Auditoría por Número de Documento Imported from BI Publisher Description: Informe de auditoría por número de documento Application: Receivables Source: Auditoría por Número de Documento (XML) Short Name: ARXINVAD_XML DB package: AR_ARXINVAD_XMLP_PKG F AR Etat Audit par numéro de document Imported from BI Publisher Description: Etat d'audit par numéro de document Application: Receivables Source: Etat Audit par numéro de document (XML) Short Name: ARXINVAD_XML DB package: AR_ARXINVAD_XMLP_PKG I AR Rapporto Audit per numero documento Imported from BI Publisher Description: Rapporto Audit per numero documento Application: Receivables Source: Rapporto Audit per numero documento (XML) Short Name: ARXINVAD_XML DB package: AR_ARXINVAD_XMLP_PKG JA AR 監査レポート(文書番号別) Imported from BI Publisher Description: 監査レポート(文書番号別) Application: Receivables Source: 監査レポート(文書番号別)(XML) Short Name: ARXINVAD_XML DB package: AR_ARXINVAD_XMLP_PKG KO AR 문서 번호별 감사 보고서 Imported from BI Publisher Description: 문서 번호별 감사 보고서 Application: Receivables Source: 문서 번호별 감사 보고서(XML) Short Name: ARXINVAD_XML DB package: AR_ARXINVAD_XMLP_PKG PTB AR Relatório de Auditoria por Número de Documento Imported from BI Publisher Description: Relatório de Auditoria por Número de Documento Application: Receivables Source: Relatório de Auditoria por Número de Documento (XML) Short Name: ARXINVAD_XML DB package: AR_ARXINVAD_XMLP_PKG RU AR Отчет об аудите по номеру документа Imported from BI Publisher Description: Отчет об аудите по номеру документа Application: Дебиторы Source: Отчет об аудите по номеру документа (XML) Short Name: ARXINVAD_XML DB package: AR_ARXINVAD_XMLP_PKG S AR Kontrollrapport per dokumentnummer Imported from BI Publisher Description: Kontrollrapport per dokumentnummer Application: Receivables Source: Kontrollrapport per dokumentnummer (XML) Short Name: ARXINVAD_XML DB package: AR_ARXINVAD_XMLP_PKG TR AR Doküman Numarasına Göre Denetleme Raporu Imported from BI Publisher Description: Doküman Numarasına Göre Denetleme Raporu Application: Alacaklar Muhasebesi Source: Doküman Numarasına Göre Denetleme Raporu (XML) Short Name: ARXINVAD_XML DB package: AR_ARXINVAD_XMLP_PKG US AR Audit Report by Document Number Imported from BI Publisher Description: Audit Report by Document Number Application: Receivables Source: Audit Report by Document Number (XML) Short Name: ARXINVAD_XML DB package: AR_ARXINVAD_XMLP_PKG ZHS AR 按单据编号列出的审核报表 Imported from BI Publisher Description: 按单据编号列出的审核报表 Application: 应收帐款 Source: 按单据编号列出的审核报表 (XML) Short Name: ARXINVAD_XML DB package: AR_ARXINVAD_XMLP_PKG BI Publisher :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_deleted :c_entered :c_last_value :c_nls_no_data_exists :c_report_start_date :c_report_type :c_sequence_method :c_sequence_name :operating_unit :p_conc_request_id :p_debug_switch :p_min_precision :p_sequence_from :p_sequence_id :p_sequence_to :p_set_of_books_id :p_type 1 -20 :p_set_of_books_id LOV Oracle AR_SRS_SET_OF_BOOKS_ID Y select set_of_books_id id, set_of_books_id value, null description from ar_system_parameters order by value,description select SET_OF_BOOKS_ID from AR_SYSTEM_PARAMETERS Y AR دفاتر الحسابات دفاتر الحسابات D Buchungsstruktur Buchungsstruktur E Juego de Libros Juego de Libros F Entité comptable Entité comptable I Set of books Set of books JA 会計帳簿 会計帳簿 KO SOB SOB RU Набор книг Набор книг S Räkenskaper Räkenskaper TR YMB YMB US SOB SOB 2 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 3 10 :p_type LOV Oracle AR_SRS_ARXINVAD_AUDIT_REPORT_TYPE Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='AUDIT_REPORT_TYPE' order by lookup_code Y AR نوع التقرير نوع التقرير D Auswertungsart Auswertungsart E Tipo de Informe Tipo de informe F Type d'état Type d'état I Tipo rapporto Tipo di rapporto JA レポート・タイプ レポート・タイプ KO 보고서 유형 보고서 유형 PTB Tipo de Relatório Tipo de Relatório RU Тип отчета Тип отчета S Rapporttyp Rapporttyp TR Rapor Tipi Rapor Tipi US Report Type Report Type ZHS 报表类型 报表类型 4 20 :p_sequence_id LOV Oracle AR_SRS_ARXINVAD_SEQUENCE_NAME Y select doc_sequence_id id, name value, null description from fnd_document_sequences where application_id=222 and table_name=decode(:$flex$.ar_srs_arxinvad_audit_report_type, 'ADJUSTMENT','AR_ADJUSTMENTS_ALL','RECEIPT', 'AR_CASH_RECEIPTS_ALL','INVOICE','RA_CUSTOMER_TRX_ALL') order by name Y AR اسم المسلسل اسم المسلسل D Bezeichnung Belegfolge Bezeichnung Belegfolge E Nombre de Secuencia Nombre de Secuencia F Code journal Code journal I Nome sequenza Nome della sequenza JA 連番名 連番名 KO 순번명 순번명 PTB Nome da Sequência Nome da Sequência RU Имя последовательности Имя последовательности S Sekvensnamn Sekvensnamn TR Sıra Adı Sıra Adı US Sequence Name Sequence Name ZHS 序号名 序号名 5 30 :p_sequence_from Number Y AR رقم المستند من رقم المستند من D Von Belegnummer Von Belegnummer E De Número de Documento De Número de Documento F Numéro de document - De Numéro de document - De I Numero documento - Da Numero documento - Da JA 文書番号:自 文書番号:自 KO 문서 번호: 부터 문서 번호: 부터 PTB Número do Documento - De Número do Documento - De RU Номер документа с Номер документа с S Från dokumentnummer Från dokumentnummer TR İlk Doküman Numarası İlk Doküman Numarası US Document Number From Document Number From ZHS 单据编号自 单据编号自 6 40 :p_sequence_to Number Y AR رقم المستند إلى رقم المستند إلى D Bis Belegnummer Bis Belegnummer E A Número de Documento A Número de Documento F Numéro de document - A Numéro de document - A I Numero documento - A Numero documento - A JA 文書番号:至 文書番号:至 KO 문서 번호: 까지 문서 번호: 까지 PTB Número de Documento - Até Número de Documento - Até RU Номер документа по Номер документа по S Till dokumentnummer Till dokumentnummer TR Son Doküman Numarası Son Doküman Numarası US Document Number To Document Number To ZHS 单据编号至 单据编号至