ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F4351A9E05362FB09050512Y SELECT TRX.TRX_NUMBER AS TRANSACTION_NUMBER , MIN (TRX.TRX_DATE) TRANSACTION_DATE, MIN (ev.event_date) GL_DATE, MIN(PARTY.PARTY_NAME) CUSTOMER_NAME, MIN(HZCUST.ACCOUNT_NUMBER) ACCOUNT_NUMBER, CLCK.CONCATENATED_SEGMENTS CONCATENATED_SEGMENTS, MIN( (ARSYS.VRM_ADOPTION_PERIOD)) ADOPTION_PERIOD, MIN( (ARL.MEANING)) TRX_CLASS, SUM( DECODE(XLA.ACCOUNTING_CLASS_CODE,'REVENUE',NVL(XLA.ACCOUNTED_DR,0),0)) ACCT_REV_DEBIT_AMOUNT, SUM( DECODE(XLA.ACCOUNTING_CLASS_CODE,'REVENUE',NVL(XLA.ACCOUNTED_CR,0),0)) ACCT_REV_CREDIT_AMOUNT, SUM(DECODE(XLA.ACCOUNTING_CLASS_CODE,'UNEARN',NVL(XLA.ACCOUNTED_DR,0),0)) ACCT_UNEARN_DEBIT_AMOUNT, SUM( DECODE(XLA.ACCOUNTING_CLASS_CODE,'UNEARN',NVL(XLA.ACCOUNTED_CR,0),0)) ACCT_UNEARN_CREDIT_AMOUNT FROM RA_CUSTOMER_TRX TRX, HZ_CUST_ACCOUNTS HZCUST, HZ_PARTIES PARTY, XLA_TRANSACTION_ENTITIES_upg XTE, XLA_EVENTS ev, XLA_AE_HEADERS XAH, XLA_AE_LINES XLA, AR_SYSTEM_PARAMETERS_ALL ARSYS, GL_CODE_COMBINATIONS_KFV CLCK, RA_CUST_TRX_TYPES TRXTYPE, AR_LOOKUPS ARL WHERE TRX.CUSTOMER_TRX_ID =XTE.SOURCE_ID_INT_1 AND XTE.application_id =222 AND XTE.ENTITY_CODE = 'TRANSACTIONS' AND TRX.BILL_TO_CUSTOMER_ID =HZCUST.CUST_ACCOUNT_ID AND HZCUST.PARTY_ID =PARTY.PARTY_ID AND XTE.ENTITY_ID =XAH.ENTITY_ID AND XTE.entity_id = ev.entity_id AND ev.event_id = xah.event_id AND XAH.AE_HEADER_ID =XLA.AE_HEADER_ID AND xla.CODE_COMBINATION_ID =CLCK.CODE_COMBINATION_ID AND TRX.REV_REC_APPLICATION IN ('VRM_BILLING','VRM_SOURCE') AND TRX.DOCUMENT_TYPE_ID IS NOT NULL AND ARSYS.VRM_ADOPTION_PERIOD IS NOT NULL AND ev.event_DATE >=ARSYS.VRM_ADOPT_PERIOD_START_DATE AND XLA.ACCOUNTING_CLASS_CODE IN('REVENUE','UNEARN' ) AND TRX.CUST_TRX_TYPE_ID =TRXTYPE.CUST_TRX_TYPE_ID AND TRXTYPE.TYPE =ARL.LOOKUP_CODE AND ARL.LOOKUP_TYPE ='INV/CM' AND TRXTYPE.type IN ('INV','CM') &FINAL_WHERE_CLAUSE GROUP BY CLCK.CONCATENATED_SEGMENTS, TRX.TRX_NUMBER ORDER BY TRX.TRX_NUMBER AR ARXPADJT_XML AR AR تقرير المعاملات الخاصة بتعديلات فترة ما بعد التبني Imported from BI Publisher Description: تقرير المعاملات الخاص بتعديلات فترة ما بعد التبني Application: المقبوضات Source: تقرير المعاملات الخاصة بتعديلات فترة ما بعد التبني (XML) Short Name: ARXPADJT_XML DB package: AR_ARXPADJT_XML D AR Korrekturtransaktionen nach Einführung Imported from BI Publisher Description: Auswertung "Korrekturtransaktionen nach Einführung" Application: Debitoren Source: Korrekturtransaktionen nach Einführung (XML) Short Name: ARXPADJT_XML DB package: AR_ARXPADJT_XML E AR InformeTransacciones de Ajustes Posteriores a Adopción Imported from BI Publisher Description: Informe de transacciones de ajustes posteriores a adopción Application: Receivables Source: Informe (XML) Transacciones de Ajustes Posteriores a Adopción Short Name: ARXPADJT_XML DB package: AR_ARXPADJT_XML F AR Etat des mouvements d'ajustement après adoption Imported from BI Publisher Description: Etat des mouvements d'ajustement après adoption Application: Receivables Source: Etat des mouvements d'ajustement après adoption (XML) Short Name: ARXPADJT_XML DB package: AR_ARXPADJT_XML I AR Rapporto transazioni adeguamenti successivi ad adozione Imported from BI Publisher Description: Rapporto transazioni adeguamenti successivi ad adozione Application: Receivables Source: Rapporto transazioni adeguamenti successivi ad adozione (XML) Short Name: ARXPADJT_XML DB package: AR_ARXPADJT_XML JA AR 採用後修正取引レポート Imported from BI Publisher Description: 採用後修正取引レポート Application: Receivables Source: 採用後修正取引レポート(XML) Short Name: ARXPADJT_XML DB package: AR_ARXPADJT_XML KO AR 사후 채택 조정 거래 보고서 Imported from BI Publisher Description: 사후 채택 조정 거래 보고서 Application: Receivables Source: 사후 채택 조정 거래 보고서(XML) Short Name: ARXPADJT_XML DB package: AR_ARXPADJT_XML PTB AR Relatório de Transações de Ajustes Após a Adoção Imported from BI Publisher Description: Relatório de Transações de Ajustes Após a Adoção Application: Receivables Source: Relatório de Transações de Ajustes Após a Adoção (XML) Short Name: ARXPADJT_XML DB package: AR_ARXPADJT_XML RU AR Отчет о транзакциях корректировок после внедрения Imported from BI Publisher Description: Отчет о транзакциях корректировок после внедрения Application: Дебиторы Source: Отчет о транзакциях корректировок после внедрения (XML) Short Name: ARXPADJT_XML DB package: AR_ARXPADJT_XML S AR Transaktionsrapport för justeringar efter införande Imported from BI Publisher Description: Transaktionsrapport för justeringar efter införande Application: Receivables Source: Transaktionsrapport för justeringar efter införande (XML) Short Name: ARXPADJT_XML DB package: AR_ARXPADJT_XML TR AR Benimseme Sonrası Düzeltmeler İşlemler Raporu Imported from BI Publisher Description: Benimseme Sonrası Düzeltmeler İşlemler Raporu Application: Alacaklar Muhasebesi Source: Benimseme Sonrası Düzeltmeler İşlemler Raporu (XML) Short Name: ARXPADJT_XML DB package: AR_ARXPADJT_XML US AR Post Adoption Adjustments Transactions Imported from BI Publisher Description: Post Adoption Adjustments Transactions Report Application: Receivables Source: Post Adoption Adjustments Transactions Report (XML) Short Name: ARXPADJT_XML DB package: AR_ARXPADJT_XML ZHS AR 接受后调整事务处理报表 Imported from BI Publisher Description: 接受后调整事务处理报表 Application: 应收帐款 Source: 接受后调整事务处理报表 (XML) Short Name: ARXPADJT_XML DB package: AR_ARXPADJT_XML BI Publisher &final_where_clause :final_where_clause :p_ledger_id :p_ledger_name :p_period_from :p_period_from_date :p_period_to :p_period_to_date :p_transaction_from :p_transaction_to 1 -30 :p_ledger_name Char select entity_name from FND_MO_REPORTING_ENTITIES_V where entity_id= :$flex$.ledger AR اسم دفتر الأستاذ اسم دفتر الأستاذ D Buchbezeichnung Buchbezeichnung E Nombre de Libro Mayor Nombre de Libro Mayor F Nom du livre Nom du livre I Nome libro contabile Nome libro contabile JA 元帳名 元帳名 KO 원장명 원장명 PTB Nome do Razão Nome do Razão RU Имя книги Имя книги S Huvudbok 2 Huvudbok TR Defter Adı Defter Adı US Ledger Name Ledger Name ZHS 分类帐名称 分类帐名称 2 -20 :p_period_from_date Char select start_Date from ar_periods where upper(period_name)=upper(:$flex$.period_from) and period_Set_name='Accounting' AR تاريخ بداية الفترة الفترة من تاريخ D Startdatum Periode Periode von E Fecha de Inicio de Período De Fecha de Período F Date de début de la période Date de début de la période I Data inizio periodo Periodo dalla data JA 期間開始日 期間日付:自 KO 기간 시작 일자 기간 시작 일자 PTB Data Inicial do Período Data do Período - De RU Начальная дата периода Начальная дата периода S Startdatum för period Period från TR Dönem Başlangıç Tarihi Dönem Başlangıç Tarihi US Period Start Date Period From Date ZHS 期间起始日期 期间起始日期 3 -10 :p_period_to_date Char select end_Date from ar_periods where upper(period_name)=upper(:$flex$.period_to) and period_Set_name='Accounting' AR الفترة إلى تاريخ الفترة إلى تاريخ D Enddatum Periode Enddatum Periode E A Fecha de Período A Fecha de Período F Date de fin de la période Date de fin de la période I Progressivo periodo Progressivo periodo JA 期間日付:至 期間日付:至 KO 기간 누계 기간 누계 PTB Acumulado no Período Acumulado no Período RU Конечная дата периода Конечная дата периода S Ack. period Ack. period TR Dönem Bitiş Tarihi Dönem Bitiş Tarihi US Period To Date Period To Date ZHS 期间终止日期 期间终止日期 4 10 :p_ledger_id LOV Oracle AR_REPORTING_ENTITY Y select entity_id id, entity_name value, null description from fnd_mo_reporting_entities_v where reporting_level=1000 order by value,description AR دفتر الأستاذ معرف دفتر الأستاذ D Buch Buchkennung E Libro Mayor Id libro mayor F Livre ID livre I Libro contabile Id libro contabile JA 元帳 元帳ID KO 원장 원장 ID PTB Razão Id do Razão RU Книга Идентификатор книги S Huvudbok Huvudboks-id TR Defter Defter No US Ledger Ledger Id ZHS 分类帐 分类帐标识 5 20 :p_period_from LOV Oracle AR_GL_PERIOD_START Y select period_name id, period_name value, null description from ar_periods where period_set_name='Accounting' and start_date>=to_date('01-JAN-2014','DD-MON-RRRR') order by start_date AR الفترة من الفترة من D Von Periode Von Periode E De Período De Período F Période - De Période - De I Periodo - Da Periodo - Da JA 期間:自 期間:自 KO 시작 기간 시작 기간 PTB Período - De Período - De RU Период с Период с S Från period Från period TR Dönem Başlangıcı Dönem Başlangıcı US Period From Period From ZHS 期间自 期间自 6 30 :p_period_to LOV Oracle AR_GL_PERIOD_END Y select period_name id, period_name value, null description from ar_periods where period_set_name='Accounting' and start_date>=to_date('01-JAN-2014','DD-MON-RRRR') order by start_date AR الفترة إلى الفترة إلى D Bis Periode Bis Periode E A Período A Período F Période - A Période - A I Periodo - A Periodo - A JA 期間:至 期間:至 KO 종료 기간 종료 기간 PTB Período - Até Período - Até RU Период по Период по S Till period Till period TR Dönem Sonu Dönem Sonu US Period To Period To ZHS 期间至 期间至 7 40 :p_transaction_from LOV Oracle AR_INVOICE_NUMBER Y Y select ct.trx_number id, ct.trx_number value, null description from ra_customer_trx ct where ct.customer_trx_id in ( select max(ct2.customer_trx_id) from ra_customer_trx ct2 where ct.trx_number=ct2.trx_number) order by ct.trx_number,ct.customer_trx_id AR رقم الحركة من رقم الحركة من D Von Transaktionsnummer Von Transaktionsnummer E De Número de Transacción De Número de Transacción F Numéro de mouvement - De Numéro de mouvement - De I Numero transazione - Da Numero transazione - Da JA 取引番号:自 取引番号:自 KO 거래 시작 번호 거래 시작 번호 PTB Número da Transação - De Número da Transação - De RU Номер транзакции с Номер транзакции с S Från transaktionsnr Från transaktionsnr TR İlk İşlem Numarası İlk İşlem Numarası US Transaction Number From Transaction Number From ZHS 事务处理编号自 事务处理编号自 8 50 :p_transaction_to LOV Oracle AR_INVOICE_NUMBER Y Y select ct.trx_number id, ct.trx_number value, null description from ra_customer_trx ct where ct.customer_trx_id in ( select max(ct2.customer_trx_id) from ra_customer_trx ct2 where ct.trx_number=ct2.trx_number) order by ct.trx_number,ct.customer_trx_id AR رقم الحركة إلى رقم الحركة إلى D Bis Transaktionsnummer Bis Transaktionsnummer E A Número de Transacción A Número de Transacción F Numéro de mouvement - A Numéro de mouvement - A I Numero transazione - A Numero transazione - A JA 取引番号:至 取引番号:至 KO 거래 종료 번호 거래 종료 번호 PTB Número da Transação - Até Número da Transação - Até RU Номер транзакции по Номер транзакции по S Till transaktionsnr Till transaktionsnr TR Son İşlem Numarası Son İşlem Numarası US Transaction Number To Transaction Number To ZHS 事务处理编号至 事务处理编号至