ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F4D51A9E05362FB09050512Y SELECT decode(type.post_to_gl, 'Y', :Yes, :No) C_POSTABLE, money.currency_code C_CURRENCY_CODE, trx.trx_number C_INVOICE_NUMBER, SUBSTR(arpt_sql_func_util.get_lookup_meaning('INV/CM',type.type),1,8) C_TYPE, substrb(party.party_name,1,50) C_NAME, cust.account_number C_CUSTOMER_NUMBER, trx.trx_date C_INVOICE_DATE, dist.amount C_AMOUNT_IC, dist.acctd_amount C_AMOUNT_FC, decode(upper(:lp_sortname),'CUSTOMER',party.party_name, 'INVOICE_NUMBER',trx.trx_number,trx.trx_number ) C_SORT FROM hz_cust_accounts_all cust, hz_parties party, ra_cust_trx_types_all type, fnd_currencies money, /*ar_xla_ctlgd_lines_v dist,*/ ra_cust_trx_line_gl_dist_all dist, ra_customer_trx_all trx, gl_code_combinations cc WHERE trx.complete_flag = 'Y' AND cust.cust_account_id = trx.bill_to_customer_id AND cust.party_id = party.party_id AND trx.set_of_books_id = :set_of_books_id AND not exists ( select 'x' from ar_payment_schedules_all pay where pay.customer_trx_id = trx.customer_trx_id ) AND trx.cust_trx_type_id = type.cust_trx_type_id AND type.type in ('INV', 'DEP', 'GUAR', 'CM','DM') AND trx.invoice_currency_code = money.currency_code AND trx.cust_trx_type_id = type.cust_trx_type_id AND dist.customer_trx_id = trx.customer_trx_id AND dist.account_class = 'REC' AND dist.latest_rec_flag = 'Y' AND dist.gl_date IS NULL AND dist.code_combination_id = cc.code_combination_id &lp_start_trx_date2 &lp_end_trx_date2 &lp_start_currency &lp_end_currency &lp_start_trx &lp_end_trx &lp_start_trx_date &lp_end_trx_date &lp_bal_seg_low &lp_bal_seg_high &P_ORG_WHERE_CUST &P_ORG_WHERE_DIST &P_ORG_WHERE_TRX &P_ORG_WHERE_TYPE union all SELECT decode(type.post_to_gl,'Y',:Yes,:No) C_POSTABLE, money.currency_code C_CURRENCY_CODE, trx.trx_number C_INVOICE_NUMBER, substr(arpt_sql_func_util.get_lookup_meaning('INV/CM',type.type) ,1,8) C_TYPE, substrb(party.party_name,1,50) C_NAME, cust.account_number C_CUSTOMER_NUMBER, trx.trx_date C_INVOICE_DATE, dist.amount C_AMOUNT_IC, dist.acctd_amount C_AMOUNT_FC, decode(upper(:lp_sortname),'CUSTOMER',party.party_name, 'INVOICE_NUMBER',trx.trx_number,trx.trx_number) C_SORT from hz_cust_accounts_all cust, hz_parties party, ra_cust_trx_types_all type, fnd_currencies money, /*ar_xla_ctlgd_lines_v dist,*/ ra_cust_trx_line_gl_dist_all dist, ra_customer_trx_all trx, gl_code_combinations cc where trx.complete_flag = 'Y' AND cust.cust_account_id = trx.bill_to_customer_id AND cust.party_id = party.party_id AND trx.set_of_books_id = :Set_of_books_id AND not exists (select 'x' from ar_payment_schedules_all pay where pay.customer_trx_id = trx.customer_trx_id) AND trx.cust_trx_type_id = type.cust_trx_type_id AND type.type in('INV','DEP','GUAR','CM','DM','CM') AND trx.invoice_currency_code = money.currency_code AND trx.cust_trx_type_id = type.cust_trx_type_id AND dist.customer_trx_id = trx.customer_trx_id AND dist.account_class = 'REC' AND dist.latest_rec_flag = 'Y' AND dist.gl_date IS NOT NULL AND dist.code_combination_id = cc.code_combination_id &lp_start_gl_date &lp_end_gl_date &lp_start_currency &lp_end_currency &lp_start_trx &lp_end_trx &lp_start_trx_date &lp_end_trx_date &lp_bal_seg_low &lp_bal_seg_high &P_ORG_WHERE_CUST &P_ORG_WHERE_DIST &P_ORG_WHERE_TRX &P_ORG_WHERE_TYPE /*ORDER BY C_POSTABLE, C_CURRENCY_CODE, C_TYPE, C_SORT, C_INVOICE_NUMBER*/ ORDER BY C_POSTABLE,C_CURRENCY_CODE,C_SORT AR RAXINX_XML AR AR تقرير استثناءات الفواتير (بتنسيق XML) Imported from BI Publisher Description: قائمة لكل فواتير المقبوضات غير المفتوحة Application: المقبوضات Source: تقرير استثناءات الفواتير (بتنسيق XML) Short Name: RAXINX_XML DB package: AR_RAXINX_XMLP_PKG D AR Rechnungen - Ausnahmen Imported from BI Publisher Description: Listet alle Rechnungen auf, die keine offenen Forderungen sind Application: Debitoren Source: Rechnungen - Ausnahmen (XML) Short Name: RAXINX_XML DB package: AR_RAXINX_XMLP_PKG E AR Excepciones de Facturas Imported from BI Publisher Description: Enumera todas las facturas que no sean cuentas a cobrar vivas Application: Receivables Source: Excepciones de Facturas (XML) Short Name: RAXINX_XML DB package: AR_RAXINX_XMLP_PKG F AR Etat Ecarts de facturation Imported from BI Publisher Description: Liste de toutes les factures dont la case à cocher Actualiser les soldes a pour valeur Non Application: Receivables Source: Etat Ecarts de facturation (XML) Short Name: RAXINX_XML DB package: AR_RAXINX_XMLP_PKG I AR Rapporto Eccezioni fatture Imported from BI Publisher Description: Elenca tutte le fatture non aperte nel conto clienti Application: Receivables Source: Rapporto Eccezioni fatture (XML) Short Name: RAXINX_XML DB package: AR_RAXINX_XMLP_PKG JA AR 請求書例外レポート Imported from BI Publisher Description: 回収済売掛/未収金の全請求書のリスト Application: Receivables Source: 請求書例外レポート(XML) Short Name: RAXINX_XML DB package: AR_RAXINX_XMLP_PKG KO AR 송장 예외 보고서 Imported from BI Publisher Description: 미결 AR이 아닌 모든 송장 목록 Application: Receivables Source: 송장 예외 보고서(XML) Short Name: RAXINX_XML DB package: AR_RAXINX_XMLP_PKG PTB AR Relatório de Exceção de NFF Imported from BI Publisher Description: Lista todas as NFFs não abertas nas contas a receber Application: Receivables Source: Relatório de Exceção de NFF (XML) Short Name: RAXINX_XML DB package: AR_RAXINX_XMLP_PKG RU AR Отчет об исключениях счетов-фактур Imported from BI Publisher Description: Список всех счетов-фактур, не открытых Дебиторами Application: Дебиторы Source: Отчет об исключениях счетов-фактур (XML) Short Name: RAXINX_XML DB package: AR_RAXINX_XMLP_PKG S AR Fakturaavvikelser - rapport Imported from BI Publisher Description: Visar en lista över alla fakturor som inte är obetalda kundfordringar Application: Receivables Source: Fakturaavvikelser - rapport (XML) Short Name: RAXINX_XML DB package: AR_RAXINX_XMLP_PKG TR AR Fatura İstisna Raporu Imported from BI Publisher Description: Açık alacak olmayan tüm faturaları listeler Application: Alacaklar Muhasebesi Source: Fatura İstisna Raporu (XML) Short Name: RAXINX_XML DB package: AR_RAXINX_XMLP_PKG US AR Invoice Exception Imported from BI Publisher Description: Lists all invoices not open receivable Application: Receivables Source: Invoice Exception Report (XML) Short Name: RAXINX_XML DB package: AR_RAXINX_XMLP_PKG ZHS AR 发票例外报表 Imported from BI Publisher Description: 列出应收款未结清的所有发票 Application: 应收帐款 Source: 发票例外报表 (XML) Short Name: RAXINX_XML DB package: AR_RAXINX_XMLP_PKG BI Publisher &lp_bal_seg_high &lp_bal_seg_low &lp_end_currency &lp_end_gl_date &lp_end_trx &lp_end_trx_date &lp_end_trx_date2 &lp_start_currency &lp_start_gl_date &lp_start_trx &lp_start_trx_date &lp_start_trx_date2 &p_org_where_cust &p_org_where_dist &p_org_where_trx &p_org_where_type :cp_acc_message :cp_end_gl_date :cp_end_trx_date :cp_start_gl_date :cp_start_trx_date :d_company_name :end_currency_code :invoice_type_high :invoice_type_low :lp_bal_seg_high :lp_bal_seg_low :lp_end_currency :lp_end_gl_date :lp_end_trx :lp_end_trx_date :lp_end_trx_date2 :lp_sortname :lp_start_currency :lp_start_gl_date :lp_start_trx :lp_start_trx_date :lp_start_trx_date2 :no :p_coaid :p_conc_request_id :p_end_gl_date :p_end_trx_date :p_in_bal_segment_high :p_in_bal_segment_low :p_org_where_cust :p_org_where_dist :p_org_where_trx :p_org_where_type :p_reporting_entity_id :p_reporting_entity_name :p_reporting_level :p_reporting_level_name :p_start_gl_date :p_start_trx_date :rp_func_curr :rp_message :rp_report_name :set_of_books_id :sortname :start_currency_code :yes 1 -20 :p_coaid Char SELECT SB.CHART_OF_ACCOUNTS_ID FROM GL_SETS_OF_BOOKS SB,AR_SYSTEM_PARAMETERS SP WHERE SB.SET_OF_BOOKS_ID = SP.SET_OF_BOOKS_ID AR جدول تصنيف الحسابات جدول تصنيف الحسابات D Kontenplan Kontenplan E Plan de Cuentas Plan de cuentas F Plan de comptes Plan de comptes I Piano dei conti Piano dei conti JA 勘定体系 勘定体系 KO 계정코드집 계정코드집 PTB Plano de Contas Plano de Contas RU План счетов План счетов S Kontoplan Kontoplan TR Hesap Planı Hesap Planı US Chart of Accounts Chart of Accounts ZHS 科目表 科目表 2 10 :p_reporting_level LOV Oracle FND_MO_REPORTING_LEVEL Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='FND_MO_REPORTING_LEVEL' and lookup_code in (1000,3000) order by value,description SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'FND_MO_REPORTING_LEVEL' AND rownum=1 Y AR مستوى إعداد التقرير للإشارة إلى مستوى إعداد التقرير D Auswertungsebene Gibt die Auswertungsebene an E Nivel de Informe Indica el nivel de informe F Niveau de reporting Indique le niveau de reporting I Livello di creazione rapporti Indica il livello di creazione rapporti JA レポート・レベル レポート・レベルの表示 KO 보고 레벨 보고 레벨 표시 PTB Nível do Relatório Indica o Nível de Geração de Relatórios RU Уровень отчетности Уровень отчетности S Rapporteringsnivå Visar rapportnivå TR Raporlama Düzeyi Raporlama Düzeyini Gösterir US Reporting Level Indicates Reporting Level ZHS 报告层 表示报告层 3 20 :p_reporting_entity_id LOV Oracle FND_MO_REPORTING_ENTITY Y select entity_id id, entity_name value, null description from fnd_mo_reporting_entities_v where reporting_level=:$flex$.fnd_mo_reporting_level order by value,description SELECT entity_name, entity_id FROM FND_MO_REPORTING_ENTITIES_V WHERE reporting_level = :$flex$.reporting_level and rownum=1 Y AR سياق إعداد التقرير للإشارة إلى سياق إعداد التقرير D Auswertungskontext Gibt den Auswertungskontext an E Contexto del Informe Indica el contexto del informe F Contexte de reporting Indique le contexte de reporting I Contesto creazione rapporti Indica il contesto di creazione rapporti JA レポート・コンテキスト レポート・コンテキストの表示 KO 보고 컨텍스트 보고 컨텍스트 표시 PTB Contexto do Relatório Indica o Contexto para Geração de Relatórios RU Контекст отчетности Контекст отчетности S Rapporteringssammanhang Visar rapporteringssammanhang TR Raporlama İçeriği Raporlama İçeriğini Gösterir US Reporting Context Indicates Reporting Context ZHS 报告上下文 表示报告上下文 4 30 :p_ca_set_of_books_id Char AR عملة دفتر الأستاذ عملة دفتر الأستاذ D Buchwährung Buchwährung E Divisa de Libro Mayor Divisa de Libro Mayor F Devise comptable Devise comptable I Divisa libro contabile Divisa del libro contabile JA 元帳通貨 元帳通貨 KO 원장 통화 원장 통화 PTB Moeda do Razão Moeda do Razão RU Валюта книги Валюта книги S Huvudboksvaluta Huvudboksvaluta TR Defter Para Birimi Defter Para Birimi US Ledger Currency Ledger Currency ZHS 分类帐币种 分类帐币种 5 40 :p_in_bal_segment_low Char AR مقطع الشركة من مقطع الشركة من D Von Firmensegment Von Firmensegment E De Segmento de Compañía De segmento de compañía F Segment société - De Segment société - De I Segmento aziendale (min) Segmento aziendale (min) JA 会社セグメント:自 会社セグメント:自 KO 회사 세그먼트 하한 회사 세그먼트 하한 PTB Segmento da Empresa - Inferior Segmento da Empresa - Inferior RU Сегмент компании с Сегмент компании с S Från bolagssegment Från bolagssegment TR Şirket Segmenti Alt Değeri Şirket Segmenti Alt Değeri US Company Segment Low Company Segment Low ZHS 公司段下限 公司段下限 6 50 :p_in_bal_segment_high Char AR مقطع الشركة إلى مقطع الشركة إلى D Bis Firmensegment Bis Firmensegment E A Segmento de Compañía A segmento de compañía F Segment société - A Segment société - A I Segmento aziendale (max) Segmento aziendale (max) JA 会社セグメント:至 会社セグメント:至 KO 회사 세그먼트 상한 회사 세그먼트 상한 PTB Segmento da Empresa - Superior Segmento da Empresa - Superior RU Сегмент компании по Сегмент компании по S Till bolagssegment Till bolagssegment TR Şirket Segmenti Üst Değeri Şirket Segmenti Üst Değeri US Company Segment High Company Segment High ZHS 公司段上限 公司段上限 7 60 :p_start_gl_date Date AR تاريخ الأستاذ العام من تاريخ الأستاذ العام من D Von Buchungsdatum Von Buchungsdatum E De Fecha Contable De Fecha Contable F Date GL - Du Date GL - Du I Data GL - Da Data GL - Da JA GL記帳日:自 GL記帳日:自 KO GL 일자: 부터 GL 일자: 부터 PTB Data GL - De Data GL - De RU Дата ГК с Дата ГК с S Från bokf.datum Från bokf.datum TR GL Başlangıç Tarihi GL Başlangıç Tarihi US GL Date From GL Date From ZHS GL 日期自 GL 日期自 8 70 :p_end_gl_date Date AR تاريخ الأستاذ العام إلى تاريخ الأستاذ العام إلى D Bis Buchungsdatum Bis Buchungsdatum E A Fecha Contable A Fecha Contable F Date GL - Au Date GL - Au I Data GL - A Data GL - A JA GL記帳日:至 GL記帳日:至 KO GL 일자: 까지 GL 일자: 까지 PTB Data GL - Até Data GL - Até RU Дата ГК по Дата ГК по S Till bokf.datum Till bokf.datum TR GL Bitiş Tarihi GL Bitiş Tarihi US GL Date To GL Date To ZHS GL 日期至 GL 日期至 9 80 :sortname LOV Oracle AR_SRS_RAXINX_SORTBY Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='SORT_BY_RAXINX' order by value,description AR ترتيب حسب خيار الفرز حسب D Sortieren nach Sortieroption E Ordenar por Opción de ordenación F Tri par Option de tri I Ordina per Opzione Ordina per JA ソート・キー オプション・ソート KO 정렬 기준 정렬 기준 옵션 PTB Ordenar Por Ordenar por opção RU Сортировка Параметр сортировки S Ordna per Sorteringsalternativ TR Sıralama Bazı Sıralama Esası seçeneği US Order By Order By option ZHS 排序依据 排序依据选项 10 90 :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 Eingabewährung Von Eingabewährung E De Divisa Introducida De Divisa Introducida F Devise de saisie - De Devise de saisie - De I Divisa inserita (min) Divisa inserita (min) JA 入力通貨:自 入力通貨:自 KO 입력 통화 하한 입력 통화 하한 PTB Moeda Informada - Inferior Moeda Informada - Inferior RU Введенная валюта с Введенная валюта с S Från registrerad valuta Från registrerad valuta TR Girilen Para Birimi Alt Değeri Girilen Para Birimi Alt Değeri US Entered Currency Low Entered Currency Low ZHS 输入币种下限 输入币种下限 11 100 :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 Eingabewährung Bis Eingabewährung E A Divisa Introducida A Divisa Introducida F Devise de saisie - A Devise de saisie - A I Divisa inserita (max) Divisa inserita (max) JA 入力通貨:至 入力通貨:至 KO 입력 통화 상한 입력 통화 상한 PTB Moeda Informada - Superior Moeda Informada - Superior RU Введенная валюта по Введенная валюта по S Till registrerad valuta Till registrerad valuta TR Girilen Para Birimi Üst Değeri Girilen Para Birimi Üst Değeri US Entered Currency High Entered Currency High ZHS 输入币种上限 输入币种上限 12 110 :p_start_trx_date Date AR تاريخ الحركة من تاريخ الحركة من D Von Transaktionsdatum Von Transaktionsdatum E De Fecha de Transacción De Fecha de Transacción F Date de mouvement - Du Date de mouvement - Du I Data transazione - Da Data transazione - Da JA 取引日:自 取引日:自 KO 거래 일자: 부터 거래 일자: 부터 PTB Data da Transação - De Data da Transação - De RU Дата транзакции с Дата транзакции с S Från transaktionsdatum Från transaktionsdatum TR İlk İşlem Tarihi İşlem Başlangıç Tarihi US Transaction Date From Transaction Date From ZHS 事务处理起始日期 事务处理起始日期 13 120 :p_end_trx_date Date AR تاريخ الحركة إلى تاريخ الحركة إلى D Bis Transaktionsdatum Bis Transaktionsdatum E A Fecha de Transacción A Fecha de Transacción F Date de mouvement - Au Date de mouvement - Au I Data transazione - A Data transazione - A JA 取引日:至 取引日:至 KO 거래 일자: 까지 거래 일자: 까지 PTB Data da Transação - Até Data da Transação - Até RU Дата транзакции по Дата транзакции по S Till transaktionsdatum Till transaktionsdatum TR Son İşlem Tarihi İşlem Bitiş Tarihi US Transaction Date To Transaction Date To ZHS 事务处理日期至 事务处理日期至 14 130 :invoice_type_low LOV Oracle AR_RAXINX_TRANS_TYPE Y select name id, name value, null description from ra_cust_trx_types where upper(accounting_affect_flag)='N' order by name AR نوع الحركة من نوع الحركة من D Von Transaktionsart Von Transaktionsart E De Tipo de Transacción De tipo de transacción F Type de mouvement - De Type de mouvement - De I Tipo transazione (min) Tipo transazione (min) JA 取引タイプ:自 取引タイプ:自 KO 거래 유형 하한 거래 유형 하한 PTB Tipo de Transação - Inferior Tipo de Transação - Inferior RU Тип транзакции с Тип транзакции с S Från transaktionstyp Från transaktionstyp TR İşlem Tipi Alt Değeri İşlem Tipi Alt Değeri US Transaction Type Low Transaction Type Low ZHS 事务处理类型下限 事务处理类型下限 15 140 :invoice_type_high LOV Oracle AR_RAXINX_TRANS_TYPE Y select name id, name value, null description from ra_cust_trx_types where upper(accounting_affect_flag)='N' order by name AR نوع الحركة إلى نوع الحركة إلى D Bis Transaktionsart Bis Transaktionsart E A Tipo de Transacción A tipo de transacción F Type de mouvement - A Type de mouvement - A I Tipo transazione (max) Tipo transazione (max) JA 取引タイプ:至 取引タイプ:至 KO 거래 유형 상한 거래 유형 상한 PTB Tipo de Transação - Superior Tipo de Transação - Superior RU Тип транзакции по Тип транзакции по S Till transaktionstyp Till transaktionstyp TR İşlem Tipi Üst Değeri İşlem Tipi Üst Değeri US Transaction Type High Transaction Type High ZHS 事务处理类型上限 事务处理类型上限