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）限制的操作单元。 C6E085D46F4C51A9E05362FB09050512Y SELECT null Company, trx.invoice_currency_code Currency_A, decode(type.post_to_gl, 'Y',&p_yes ,&p_no ) Postable, look.meaning Class, trx.trx_number Invoice_Number, type.name Type, substrb(party.party_name,1,50) Customer_Name, cust.account_number Customer_Number, trx.trx_date Invoice_Date, suspdist.gl_date GL_Date, sum(suspdist.amount) Foreign_Currency, sum(suspdist.acctd_amount) Functional_Currency_A, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_company', 'SQLGL', 'GL#', gl.CHART_OF_ACCOUNTS_ID, NULL, gl.CODE_COMBINATION_ID, '1', 'Y', 'VALUE') D_Company, AR_RAXINPS_XMLP_PKG.c_company_labelformula(:D_Company) C_COMPANY_LABEL, AR_RAXINPS_XMLP_PKG.c_data_not_foundformula(gl.segment1) C_DATA_NOT_FOUND, AR_RAXINPS_XMLP_PKG.c_post_labelformula(decode ( type.post_to_gl , 'Y' , &p_yes , &p_no )) C_POST_LABEL, AR_RAXINPS_XMLP_PKG.c_currency_labelformula(trx.invoice_currency_code) C_CURRENCY_LABEL, AR_RAXINPS_XMLP_PKG.c_class_labelformula(look.meaning) C_CLASS_LABEL FROM ra_customer_trx trx, ra_customer_trx_lines lines, ra_cust_trx_types type, gl_code_combinations gl, hz_cust_accounts cust, hz_parties party, ar_lookups look, ar_xla_ctlgd_lines_v suspdist, ar_xla_ctlgd_lines_v recdist WHERE lines.customer_trx_id = trx.customer_trx_id AND suspdist.customer_trx_line_id = lines.customer_trx_line_id AND type.cust_trx_type_id = trx.cust_trx_type_id AND recdist.customer_trx_id = trx.customer_trx_id AND gl.code_combination_id = recdist.code_combination_id AND cust.cust_account_id = trx.bill_to_customer_id AND cust.party_id = party.party_id AND look.lookup_type = 'INV/CM' AND look.lookup_code = type.type AND trx.complete_flag = 'Y' AND suspdist.account_class = 'SUSPENSE' AND recdist.account_class = 'REC' AND recdist.latest_rec_flag = 'Y' AND type.type in ('INV','DEP','GUAR','CM') &lp_gl_start_date &lp_gl_end_date &lp_trx_start_date &lp_trx_end_date &lp_type_low &lp_type_high &lp_start_currency_code &lp_end_currency_code and suspdist.gl_date is NOT NULL and trx.trx_date is NOT NULL GROUP BY look.meaning, &ACCT_FLEX_BAL_SEG, type.post_to_gl, trx.invoice_currency_code, trx.trx_number, type.name, party.party_name, cust.account_number, trx.trx_date, suspdist.gl_date --Added during DT Fix ,fnd_flex_xml_publisher_apis.process_kff_combination_1('d_company', 'SQLGL', 'GL#', gl.CHART_OF_ACCOUNTS_ID, NULL, gl.CODE_COMBINATION_ID, '1', 'Y', 'VALUE') ,gl.segment1 ,type.post_to_gl --End of DT Fix ORDER BY &ACCT_FLEX_BAL_SEG , type.post_to_gl desc, trx.invoice_currency_code, look.meaning, type.name, decode(upper(:p_order_by), 'CUSTOMER', party.party_name, 'INVOICE NUMBER', trx.trx_number, trx.trx_number), trx.trx_number, suspdist.gl_date AR RAXINPS_XML AR AR فواتير مرحلة للتعليق (بتنسيق XML) Imported from BI Publisher Description: فواتير مرحلة لحسابات معلقة Application: المقبوضات Source: فواتير مرحلة للتعليق (بتنسيق XML) Short Name: RAXINPS_XML DB package: AR_RAXINPS_XMLP_PKG D AR Rechnungen - auf Interim verbucht Imported from BI Publisher Description: Rechnungen - auf Interim verbucht Application: Debitoren Source: Rechnungen - auf Interim verbucht (XML) Short Name: RAXINPS_XML DB package: AR_RAXINPS_XMLP_PKG E AR Contabilización de Facturas en Cuentas Transitorias Imported from BI Publisher Description: Contabilización de facturas en cuentas transitorias Application: Receivables Source: Contabilización de Facturas en Cuentas Transitorias (XML) Short Name: RAXINPS_XML DB package: AR_RAXINPS_XMLP_PKG F AR Factures imputées en compte d'attente Imported from BI Publisher Description: Factures imputées en compte d'attente Application: Receivables Source: Factures imputées en compte d'attente (XML) Short Name: RAXINPS_XML DB package: AR_RAXINPS_XMLP_PKG I AR Fatture contabilizzate in conti sospesi Imported from BI Publisher Description: Fatture contabilizzate nei conti sospesi Application: Receivables Source: Fatture contabilizzate in conti sospesi (XML) Short Name: RAXINPS_XML DB package: AR_RAXINPS_XMLP_PKG JA AR 仮勘定転記請求書 Imported from BI Publisher Description: 仮勘定転記請求書 Application: Receivables Source: 仮勘定転記請求書(XML) Short Name: RAXINPS_XML DB package: AR_RAXINPS_XMLP_PKG KO AR 미정산으로 전기된 송장 Imported from BI Publisher Description: 미정산으로 전기된 송장 Application: Receivables Source: 미정산으로 전기된 송장(XML) Short Name: RAXINPS_XML DB package: AR_RAXINPS_XMLP_PKG PTB AR NFFs Contabilizadas em Conta Suspensa Imported from BI Publisher Description: NFFs Contabilizadas em Conta Suspensa Application: Receivables Source: NFFs Contabilizadas em Conta Suspensa (XML) Short Name: RAXINPS_XML DB package: AR_RAXINPS_XMLP_PKG RU AR Счета-фактуры, проведенные на счет приостановленных выплат Imported from BI Publisher Description: Счета-фактуры, проведенные на счет приостановленных выплат Application: Дебиторы Source: Счета-фактуры, проведенные на счет приостановленных выплат (XML) Short Name: RAXINPS_XML DB package: AR_RAXINPS_XMLP_PKG S AR Fakturor postade till bevakningskonto Imported from BI Publisher Description: Fakturor postade till bevakningskonto Application: Receivables Source: Fakturor postade till bevakningskonto (XML) Short Name: RAXINPS_XML DB package: AR_RAXINPS_XMLP_PKG TR AR Geçici Hesaba Muhasebeleşen Faturalar Imported from BI Publisher Description: Geçici Hesaba Muhasebeleşen Faturalar Application: Alacaklar Muhasebesi Source: Geçici Hesaba Muhasebeleşen Faturalar (XML) Short Name: RAXINPS_XML DB package: AR_RAXINPS_XMLP_PKG US AR Invoices Posted to Suspense Imported from BI Publisher Description: Invoices Posted to Suspense Application: Receivables Source: Invoices Posted to Suspense (XML) Short Name: RAXINPS_XML DB package: AR_RAXINPS_XMLP_PKG ZHS AR 过帐至暂记帐户的发票 Imported from BI Publisher Description: 过帐至暂记帐户的发票 Application: 应收帐款 Source: 过帐至暂记帐户的发票 (XML) Short Name: RAXINPS_XML DB package: AR_RAXINPS_XMLP_PKG BI Publisher &acct_flex_bal_seg &lp_end_currency_code &lp_gl_end_date &lp_gl_start_date &lp_start_currency_code &lp_trx_end_date &lp_trx_start_date &lp_type_high &lp_type_low &p_no &p_yes :acct_bal_aprompt :cp_acc_message :d_company :lp_end_currency_code :lp_gl_end_date :lp_gl_start_date :lp_start_currency_code :lp_trx_end_date :lp_trx_start_date :lp_type_high :lp_type_low :operating_unit :p_conc_request_id :p_end_currency_code :p_gl_end_date :p_gl_end_date_t :p_gl_start_date :p_gl_start_date_t :p_no :p_order_by :p_set_of_books_id :p_start_currency_code :p_trx_end_date :p_trx_end_date_t :p_trx_start_date :p_trx_start_date_t :p_type_high :p_type_low :p_yes :rp_bal_lprompt :rp_company_name :rp_data_found :rp_gl_date_range :rp_report_name :rp_trx_date_range :rpd_report_summary 1 -40 :p_coa_id LOV Oracle AR_CHART_OF_ACCOUNTS Y select sb.chart_of_accounts_id id, sb.chart_of_accounts_id value, null description from gl_sets_of_books sb,ar_system_parameters sp where sb.set_of_books_id=sp.set_of_books_id order by value,description select gl.chart_of_accounts_id from gl_sets_of_books gl, ar_system_parameters ar where gl.set_of_books_id = ar.set_of_books_id Y AR معرف جدول تصنيف الحسابات معرف جدول تصنيف الحسابات D Kontenplankennung Kennung Kontenplan E Id Plan de Cuentas Identificador de Plan de Cuentas F ID plan de comptes ID plan de comptes I Id piano dei conti Id del piano dei conti JA 勘定体系ID 勘定体系ID KO 계정코드집 ID 계정코드집 id PTB Id do Plano de Contas Id do plano de contas RU Идентификатор плана счетов Идент. плана счетов S Kontoplans-id Kontoplans-id TR Hesap Planı No Hesap planı no US Chart of Accounts Id Chart of accounts id ZHS 科目表标识 科目表标识 2 -30 :p_end Char END Y AR نهاية D Ende E FIN F FIN I FINE JA 終了 KO 종료 PTB FINAL RU Конец TR SON US END ZHS 结束 3 -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 Buchkennung Buchkennung E Id Libro Mayor Identificador de libro mayor F ID livre ID livre I Id libro contabile Id del libro contabile JA 元帳ID 元帳ID KO 원장 ID 원장 ID PTB Id do Razão Id do Razão RU Идентификатор книги Идентификатор книги S Huvudboks-id Huvudboks-id TR Defter No Defter No US Ledger Id Ledger Id ZHS 分类帐标识 分类帐标识 4 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 5 10 :p_order_by LOV Oracle AR_RAXINPS_SORT_BY Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='SORT_BY_RAXINPS' order by value,description Y AR ترتيب حسب خيار الفرز حسب D Sortieren nach Sortieroption E Ordenar por Opción de ordenación F Tri par Option de tri I Ordina per Opzioni di ordinamento JA ソート・キー ソート・キー・オプション KO 정렬 기준 정렬 기준 옵션 PTB Ordenar Por Classificar Por Opção RU Сортировка Параметр сортировки S Ordna per Sorteringsalternativ TR Sıralama Bazı Sıralama Bazı Seçeneği US Order By Sort By Option ZHS 排序依据 排序依据选项 6 20 :p_gl_start_date Date AR تاريخ الأستاذ العام من مدى تاريخ الأستاذ العام من D Von Buchungsdatum Von Buchungsdatum E De Fecha Contable Rango inferior de fecha contable F Date GL - Du Début de la fourchette de dates GL I Data GL (min) Valore minimo per la data GL JA GL記帳日:自 GL記帳日:自 KO GL 일자 하한 GL 일자 하한 범위 PTB Data GL - Inferior Faixa de Datas GL - Inferior RU Дата ГК с Дата ГК с S Från bokf.datum Nedre intervallgräns för bokföringsdatum TR GL Tarihi Alt Değeri GL Tarihi Alt Değeri US GL Date Low Low Range of GL Date ZHS GL 日期下限 GL 日期下限 7 30 :p_gl_end_date Date AR تاريخ الأستاذ العام إلى مدى تاريخ الأستاذ العام إلى D Bis Buchungsdatum Bis Buchungsdatum E A Fecha Contable Rango superior de fecha contable F Date GL - Au Fin de la fourchette de dates GL I Data GL (max) Valore massimo per la data GL JA GL記帳日:至 GL記帳日:至 KO GL 일자 상한 GL 일자 상한 범위 PTB Data GL - Superior Faixa de Datas GL - Superior RU Дата ГК по Дата ГК по S Till bokf.datum Övre intervallgräns för bokföringsdatum TR GL Tarihi Üst Değeri GL Tarihi Üst Değeri US GL Date High High Range of GL Date ZHS GL 日期上限 GL 日期的上限 8 40 :p_trx_start_date Date AR تاريخ حركة من مدى من لتاريخ الحركة D Von Transaktionsdatum Von Transaktionsdatum E De Fecha de Transacción Rango inferior de fecha de transacción F Date du mouvement - Du Début de la fourchette de dates de mouvement I Data transazione (min) Valore minimo per la data della transazione JA 取引日:自 取引日:自 KO 거래 일자 하한 거래 일자의 하한 범위 PTB Data da Transação - Inferior Faixa de Datas de Transmissão - Inferior RU Дата транзакции с Дата транзакции с S Från transaktionsdatum Nedre intervallgräns för transaktionsdatum TR İşlem Tarihi Alt Değeri İşlem Tarihi Alt Aralığı US Transaction Date Low Low Range of Transaction Date ZHS 事务处理日期下限 事务处理日期下限 9 50 :p_trx_end_date Date AR تاريخ حركة إلى مدى إلى لتاريخ الحركة D Bis Transaktionsdatum Bis Transaktionsdatum E A Fecha de Transacción Rango superior de fecha de transacción F Date du mouvement - Au Fin de la fourchette de dates de mouvement I Data transazione (max) Valore massimo per la data della transazione JA 取引日:至 取引日:至 KO 거래 일자 상한 거래 일자의 상한 범위 PTB Data da Transação - Superior Faixa de Datas de Transmissão - Superior RU Дата транзакции по Дата транзакции по S Till transaktionsdatum Övre intervallgräns för transaktionsdatum TR İşlem Tarihi Üst Değeri İşlem Tarihi Üst Aralığı US Transaction Date High High Range of Transaction Date ZHS 事务处理日期上限 事务处理日期的上限 10 60 :p_type_low LOV Oracle AR_INVOICE_TYPE Y select name id, name value, null description from ra_cust_trx_types order by name AR نوع الفاتورة من من مدى نوع الفاتورة D Von Rechnungsart Von Rechnungsart E De Tipo de Factura Rango inferior de tipo de factura F Type de facture - De Début de la fourchette de types de facture I Tipo fattura (min) Valore minimo per il tipo di fattura JA 請求書タイプ:自 請求書タイプ:自 KO 송장 유형 하한 송장 유형의 하한 범위 PTB Tipo NFF-Infer. Faixa de Tipos de NFF - Inferior RU Тип счета-фактуры с Тип счета-фактуры с S Från fakturatyp Undre intervallsgräns för fakturatyp TR Fatura Tipi Alt Değeri Fatura Tipi Alt Aralığı US Invoice Type Low Low Range of Invoice Type ZHS 发票类型下限 发票类型下限 11 70 :p_type_high LOV Oracle AR_INVOICE_TYPE Y select name id, name value, null description from ra_cust_trx_types order by name AR نوع الفاتورة إلى إلى مدى نوع الفاتورة D Bis Rechnungsart Bis Rechnungsart E A Tipo de Factura Rango superior de tipo de factura F Type de facture - A Fin de la fourchette de types de facture I Tipo fattura (max) Valore massimo per il tipo di fattura JA 請求書タイプ:至 請求書タイプ:至 KO 송장 유형 상한 송장 유형의 상한 범위 PTB Tipo NFF-Superior Faixa de Tipos de NFF - Superior RU Тип счета-фактуры по Тип счета-фактуры по S Till fakturatyp Övre intervallsgräns för fakturatyp TR Fatura Tipi Üst Değeri Fatura Tipi Üst Aralığı US Invoice Type High High Range of Invoice Type ZHS 发票类型上限 发票类型的上限 12 80 :p_start_currency_code LOV Oracle AR_SRS_CURRENCY Y select currency_code id, currency_code value, name description from fnd_currencies_vl where currency_flag='Y' and enabled_flag in ('Y','N') order by currency_code AR رمز عملة من من مدى رمز العملة D Von Währung Von Währung E De Código de Divisa Rango inferior de código de divisa F Code devise - De Début de la fourchette de codes devise I Codice divisa (min) Valore minimo per il codice della divisa JA 通貨コード:自 通貨コード:自 KO 통화 코드 하한 통화 코드의 하한 범위 PTB Código de Moeda - Inferior Faixa de Códigos de Moeda - Inferior RU Код валюты с Код валюты с S Från valutakod Nedre intervallgräns för valutakod TR Para Birimi Kodu Alt Değeri Para Birimi Kodu Alt Aralığı US Currency Code Low Low Range of Currency Code ZHS 币种代码下限 币种代码的下限 13 90 :p_end_currency_code LOV Oracle AR_SRS_CURRENCY Y select currency_code id, currency_code value, name description from fnd_currencies_vl where currency_flag='Y' and enabled_flag in ('Y','N') order by currency_code AR رمز عملة إلى إلى مدى رمز العملة D Bis Währung Bis Währung E A Código de Divisa Rango superior de código de divisa F Code devise - A Fin de la fourchette de codes devise I Codice divisa (max) Valore massimo per il codice della divisa JA 通貨コード:至 通貨コード:至 KO 통화 코드 상한 통화 코드의 상한 범위 PTB Código de Moeda - Superior Faixa de Códigos de Moeda - Superior RU Код валюты по Код валюты по S Till valutakod Övre intervallgräns för valutakod TR Para Birimi Kodu Üst Değeri Para Birimi Kodu Üst Aralığı US Currency Code High High Range of Currency Code ZHS 币种代码上限 币种代码的上限