ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 53B31EFFC6B85470E0630100007F501D Blitz Report DFF Display Y select 'V' id, 'Value' value, 'Value only' description from dual union all select 'C' id, 'Value: Description' value, 'Concatenated value and description' description from dual union all select 'S' id, 'Value, Description' value, 'Value and description in separate columns' description from dual US B581C79E6D7AE63DE0530100007FE14A GL Ledger (restricted by AR System Parameters) Y select gl.name value, fifsv.id_flex_structure_name||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where gl.ledger_id in (select asp.set_of_books_id from ar_system_parameters asp) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, gl.name AR دفاتر الأستاذ مقيدة بمعلمات النظام ar D Ledger eingeschränkt durch ar-Systemparameter E Libros mayores restringidos por los parámetros del sistema ar F Les grands livres sont limités par les paramètres du système ar I Libri mastri limitati da parametri di sistema JA ARシステムパラメータで制限された帳票 KO AR 시스템 매개 변수에 의해 제한되는 원장 PTB Ledgers restringidos por parâmetros do sistema ar RU Леджеры ограничены параметрами системы ar S Ledgers begränsade av ar-systemparametrar TR Ar sistem parametreleri ile kısıtlanmış defterler US Ledgers restricted by ar system parameters ZHS 受人工智能系统参数限制的分类账 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）限制的操作单元。 E32BB68D727ACCAFE0530100007F85F2 Revaluation Currency Y select distinct fcv.currency_code value, fcv.description from fnd_currencies_vl fcv, gl_daily_rates gdr where fcv.currency_code=gdr.to_currency and fcv.enabled_flag='Y' and gdr.from_currency in ( select gl.currency_code from gl_ledgers gl where gl.ledger_id in (select asp.set_of_books_id from ar_system_parameters asp) and (:$flex$.Ledger is null or xxen_util.contains(:$flex$.Ledger,gl.name) = 'Y') and (:$flex$.Operating_Unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.Operating_unit,hou.name) = 'Y')) ) and gdr.conversion_date>=sysdate-365 order by 1 US Revaluation Currency Code to be used in SUb Ledger Reports E32BB68D727BCCAFE0530100007F85F2 Revaluation Rate Type Y select distinct gdct.user_conversion_type value, gdct.description||' ('||count(*) over (partition by gdr.conversion_type)||')' description from gl_daily_conversion_types gdct, gl_daily_rates gdr where gdr.from_currency in ( select gl.currency_code from gl_ledgers gl where gl.ledger_id in (select asp.set_of_books_id from ar_system_parameters asp) and (:$flex$.Ledger is null or xxen_util.contains(:$flex$.Ledger,gl.name) = 'Y') and (:$flex$.Operating_Unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.Operating_unit,hou.name) = 'Y')) ) and gdr.to_currency=:$flex$.revaluation_currency and gdr.conversion_date>=sysdate-365 and gdct.conversion_type=gdr.conversion_type order by 1 US Revaluation Rate Type to be used in SUb Ledger Reports 6887D2C6BEF34053E0530100007FBABFY select x.ledger, x.balancing_segment, x.balancing_segment_desc, x.account_segment, x.account_segment_desc, x.customer_name, x.customer_number, x.customer_location, x.customer_address, x.customer_country, nvl(x.collector_site,x.collector_account) collector, x.collector_account, x.collector_site, x.batch_source_name, x.batch_name, x.receipt_number, xxen_util.meaning(x.receipt_type,'PAYMENT_CATEGORY_TYPE',222) receipt_type, x.receipt_method, case when x.receipt_status in ('REV', 'NSF', 'STOP') and x.receipt_history_status <> 'REVERSED' then (select case when sum(decode(araa2.status,'UNID',araa2.amount_applied,0)) != 0 then xxen_util.meaning('UNID','CHECK_STATUS',222) when sum(decode(araa2.status,'UNAPP',araa2.amount_applied,0)) != 0 then xxen_util.meaning('UNAPP','CHECK_STATUS',222) else xxen_util.meaning('APP','CHECK_STATUS',222) end from ar_receivable_applications_all araa2 where x.cash_receipt_id=araa2.cash_receipt_id ) else xxen_util.meaning(x.receipt_status,'CHECK_STATUS',222) end receipt_status, xxen_util.meaning(x.receipt_history_status,'RECEIPT_CREATION_STATUS',222) receipt_history_status, x.issue_date, x.receipt_date, x.receipt_gl_date, &apply_date_cols x.receipt_currency, x.currency, x.receipt_amount, x.on_account_amt, x.unapplied_amt, x.claim_amt, &reval_cols x.application_notes, x.operating_unit, x.bank_name, x.bank_name_alt, x.bank_number, x.bank_branch_name, x.bank_branch_name_alt, x.branch_number, x.bank_branch_country, x.bank_account_name, x.bank_account_name_alt, x.bank_account_number, x.bank_account_currency, x.bank_account_description, &receipt_dff_cols2 x.receipt_created_by, x.receipt_creation_date, x.receipt_last_updated_by, x.receipt_last_update_date from ( select nvl2(gcc.code_combination_id,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE'),null) balancing_segment, nvl2(gcc.code_combination_id,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'GL_BALANCING', 'Y', 'DESCRIPTION'),null) balancing_segment_desc, nvl2(gcc.code_combination_id,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'GL_ACCOUNT', 'Y', 'VALUE'),null) account_segment, nvl2(gcc.code_combination_id,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'GL_ACCOUNT', 'Y', 'DESCRIPTION'),null) account_segment_desc, hp.party_name customer_name, hca.account_number customer_number, hcsua.location customer_location, hz_format_pub.format_address(hps.location_id,null,null,' , ') customer_address, ftv2.territory_short_name customer_country, ac.name collector_account, ac2.name collector_site, acra.receipt_number, acra.type receipt_type, acra.status receipt_status, acrha2.status receipt_history_status, arm.name receipt_method, acra.issue_date, acra.receipt_date, apsa.gl_date receipt_gl_date, nvl2(:p_as_of_date,to_date(null),araa.apply_date) applied_date, nvl2(:p_as_of_date,to_date(null),araa.gl_date) applied_gl_date, &receipt_dff_cols xxen_util.user_name(acra.created_by) receipt_created_by, xxen_util.client_time(acra.creation_date) receipt_creation_date, xxen_util.user_name(acra.last_updated_by) receipt_last_updated_by, xxen_util.client_time(acra.last_update_date) receipt_last_update_date, max(araa.apply_date) latest_applied_date, max(araa.gl_date) latest_applied_gl_date, absa.name batch_source_name, aba.name batch_name, apsa.invoice_currency_code receipt_currency, nvl(upper(:p_in_curr_code),gl.currency_code) currency, decode (upper (:p_in_curr_code),null, acrha2.acctd_amount,acrha2.amount) receipt_amount, sum(decode (araa.status,'ACC', decode (upper (:p_in_curr_code),null, araa.acctd_amount_applied_from,araa.amount_applied),'OTHER ACC', decode(araa.applied_payment_schedule_id,-7, decode(upper (:p_in_curr_code),null, araa.acctd_amount_applied_from,araa.amount_applied),0),0)) on_account_amt, sum(decode (araa.status,'UNAPP', decode (upper (:p_in_curr_code),null, araa.acctd_amount_applied_from,araa.amount_applied),'UNID', decode (upper(:p_in_curr_code),null, araa.acctd_amount_applied_from,araa.amount_applied),0)) unapplied_amt, sum(decode(araa.status,'OTHER ACC', decode(araa.applied_payment_schedule_id,-4, decode(upper(:p_in_curr_code),null, araa.acctd_amount_applied_from,araa.amount_applied),0),0)) claim_amt, acra.application_notes, gl.name ledger, hou.name operating_unit, max(decode(nvl(upper(:p_in_curr_code),gl.currency_code),:p_reval_currency,1,(select gdr.conversion_rate from gl_daily_conversion_types gdct, gl_daily_rates gdr where nvl(upper(:p_in_curr_code),gl.currency_code)=gdr.from_currency and gdr.to_currency=:p_reval_currency and :p_reval_conv_date=gdr.conversion_date and gdct.user_conversion_type=:p_reval_conv_type and gdct.conversion_type=gdr.conversion_type))) reval_conv_rate, acra.rowid row_id, acra.attribute_category, acra.cash_receipt_id, cbbv.bank_name, cbbv.bank_name_alt, cbbv.bank_number, cbbv.bank_branch_name, cbbv.bank_branch_name_alt, cbbv.branch_number, ftv.territory_short_name bank_branch_country, cba.bank_account_name, cba.bank_account_name_alt, cba.masked_account_num bank_account_number, cba.currency_code bank_account_currency, cba.description bank_account_description from gl_ledgers gl, hr_operating_units hou, ar_payment_schedules_all apsa, hz_cust_accounts hca, hz_parties hp, hz_cust_site_uses_all hcsua, hz_cust_acct_sites_all hcasa, hz_party_sites hps, hz_locations hl, fnd_territories_vl ftv2, hz_customer_profiles hcp, ar_collectors ac, hz_customer_profiles hcp2, ar_collectors ac2, ar_receipt_methods arm, gl_code_combinations gcc, ar_receivable_applications_all araa, ar_cash_receipts_all acra, ar_cash_receipt_history_all acrha1, ar_cash_receipt_history_all acrha2, ar_batches_all aba, ar_batch_sources_all absa, ce_bank_accounts cba, ce_bank_acct_uses_all cbaua, ce_bank_branches_v cbbv, fnd_territories_vl ftv where 1=1 and gl.ledger_id=hou.set_of_books_id and hou.organization_id=araa.org_id 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) and apsa.class='PMT' and apsa.invoice_currency_code=nvl(upper(:p_in_curr_code),apsa.invoice_currency_code) and apsa.gl_date_closed >= nvl(:p_as_of_date+1,to_date ('31-12-4712','DD-MM-YYYY')) and -- to_date ('31-12-4712','DD-MM-YYYY') and apsa.cash_receipt_id=araa.cash_receipt_id and apsa.payment_schedule_id=araa.payment_schedule_id and araa.status in ('ACC','UNAPP','UNID','OTHER ACC') and nvl(araa.confirmed_flag,'Y')='Y' and araa.gl_date < nvl(:p_as_of_date+1,to_date ('31-12-4712','DD-MM-YYYY')) and araa.cash_receipt_id=acra.cash_receipt_id and nvl(acra.confirmed_flag,'Y')='Y' and acra.pay_from_customer=hca.cust_account_id(+) and hca.party_id=hp.party_id(+) and acra.customer_site_use_id=hcsua.site_use_id(+) and hcsua.cust_acct_site_id=hcasa.cust_acct_site_id(+) and hcasa.party_site_id=hps.party_site_id(+) and hps.location_id=hl.location_id(+) and hl.country=ftv2.territory_code(+) and acra.pay_from_customer=hcp.cust_account_id(+) and nvl(hcp.site_use_id(+),-999)=-999 and hcp.collector_id=ac.collector_id(+) and acra.pay_from_customer=hcp2.cust_account_id(+) and acra.customer_site_use_id=hcp2.site_use_id(+) and hcp2.collector_id=ac2.collector_id(+) and acra.receipt_method_id=arm.receipt_method_id and araa.code_combination_id=gcc.code_combination_id and acra.cash_receipt_id=acrha1.cash_receipt_id and acrha1.first_posted_record_flag='Y' and acra.cash_receipt_id=acrha2.cash_receipt_id and acrha2.current_record_flag='Y' and acrha1.batch_id=aba.batch_id(+) and aba.batch_source_id=absa.batch_source_id(+) and acra.remit_bank_acct_use_id = cbaua.bank_acct_use_id and acra.org_id = cbaua.org_id and cba.bank_branch_id = cbbv.branch_party_id and cbaua.bank_account_id = cba.bank_account_id and ftv.territory_code (+) = cbbv.country group by nvl2(gcc.code_combination_id,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE'),null), nvl2(gcc.code_combination_id,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'GL_BALANCING', 'Y', 'DESCRIPTION'),null), nvl2(gcc.code_combination_id,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'GL_ACCOUNT', 'Y', 'VALUE'),null), nvl2(gcc.code_combination_id,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'GL_ACCOUNT', 'Y', 'DESCRIPTION'),null), hp.party_name, hca.account_number, hcsua.location, hps.location_id, ftv2.territory_short_name, ac.name, ac2.name, absa.name, aba.name, arm.name, acra.receipt_number, acra.type, acra.status, acrha2.status, acra.issue_date, acra.receipt_date, apsa.gl_date, &receipt_dff_cols3 acra.creation_date, acra.created_by, acra.last_update_date, acra.last_updated_by, nvl2(:p_as_of_date,to_date(null),araa.apply_date), nvl2(:p_as_of_date,to_date(null),araa.gl_date), apsa.invoice_currency_code, acra.application_notes, acra.rowid, acra.attribute_category, acra.cash_receipt_id, nvl(upper(:p_in_curr_code),gl.currency_code), decode (upper (:p_in_curr_code),null, acrha2.acctd_amount,acrha2.amount), nvl(hca.cust_account_id,0), decode (hca.cust_account_id,null,'*',null), gl.name, hou.name, cbbv.bank_name, cbbv.bank_name_alt, cbbv.bank_number, cbbv.bank_branch_name, cbbv.bank_branch_name_alt, cbbv.branch_number, ftv.territory_short_name, cba.bank_account_name, cba.bank_account_name_alt, cba.masked_account_num, cba.currency_code, cba.description having sum(decode(araa.status,'ACC',araa.acctd_amount_applied_from,0))!=0 or sum(decode(araa.status,'UNAPP',araa.acctd_amount_applied_from,'UNID',araa.acctd_amount_applied_from,0))!=0 or sum(decode(araa.status,'OTHER ACC',araa.acctd_amount_applied_from,0))!=0 ) x order by x.operating_unit, x.balancing_segment asc, x.customer_number asc, x.applied_gl_date, x.receipt_gl_date, x.receipt_number, x.batch_source_name, x.batch_name, x.receipt_method, x.receipt_date #,##0.00;[Red]-#,##0.00 AR AR Unapplied Receipts Register تقرير مفصل عن الإيصالات غير المطبقة مع رقم الإيصال والتاريخ والمبلغ D AR Unapplied Receipts Register Application: Debitoren Source: Zahlungseingänge - nicht zugeordnet (veraltet) Short Name: ARXCOA2 E AR Unapplied Receipts Register Informe detallado de recibos no aplicados con número de recibo, fecha e importe F AR Unapplied Receipts Register Application: Receivables Source: Registre des règlements non lettrés (obsolète) Short Name: ARXCOA2 I AR Unapplied Receipts Register Application: Receivables Source: Registro incassi non applicati (obsoleto) Short Name: ARXCOA2 JA AR Unapplied Receipts Register 領収書番号、日付、金額が記載された未申請領収書の詳細レポート KO AR Unapplied Receipts Register 수금 번호, 일자 및 금액이 포함 된 미 반제 수금 상세 보고서 PTB AR Unapplied Receipts Register Detalhe do relatório de recibos não aplicados com número de recibo, data e valor RU AR Unapplied Receipts Register Подробный отчет о неполученных квитанциях с номером квитанции, датой и суммой S AR Unapplied Receipts Register Detalj om otillämpad kvittonrapport med kvittonummer, datum och belopp TR AR Unapplied Receipts Register Makbuz numarası, tarihi ve tutarı ile detaylandırılmamış makbuz raporu US AR Unapplied Receipts Register Detail unapplied receipts report with receipt number, date and amount ZHS AR Unapplied Receipts Register 附有收据编号、日期和金额的未定用途收据详细报告。 Enginatics R12 only &apply_date_cols &receipt_dff_cols &receipt_dff_cols2 &receipt_dff_cols3 &reval_cols 1=1 :p_as_of_date :p_in_curr_code :p_reval_conv_date :p_reval_conv_type :p_reval_currency 1 -10 &apply_date_cols select 'x.applied_date, x.applied_gl_date,' from dual where :p_adc_summary = 'N' union select 'x.latest_applied_date, x.latest_applied_gl_date,' from dual where :p_adc_summary = 'Y' Char select nvl2(:$flex$.As_Of_GL_Date,'Y','N') from dual F Date d'application Cols US Apply Date Cols 2 10 1=1 gl.name=:ledger LOV GL Ledger (restricted by AR System Parameters) B581C79E6D7AE63DE0530100007FE14A Y select gl.name value, fifsv.id_flex_structure_name||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where gl.ledger_id in (select asp.set_of_books_id from ar_system_parameters asp) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, gl.name coalesce(xxen_util.previous_parameter_value(:parameter_id),xxen_util.default_ledger) D Buchwährung F Grand livre I Divisa libro contabile US Ledger 3 20 1=1 hou.name=: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 coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) F Unité d'exploitation US Operating Unit 4 30 :p_as_of_date Date F A la date du GL US As of GL Date 5 40 1=1 apsa.gl_date>=:gl_date_from Date D Von Zahlungs-Buchungsdatum F Date de réception GL Low I Data GL incasso - Minimo US Receipt GL Date Low 6 50 1=1 apsa.gl_date<:gl_date_to+1 Date last_day(:$flex$.receipt_gl_date_low) D Bis Zahlungs-Buchungsdatum F Date de réception GL Haut I Data GL incasso - Massimo US Receipt GL Date High 7 60 1=1 araa.gl_date>=:appl_gl_date_from Date US Application GL Date Low 8 70 1=1 araa.gl_date<:appl_gl_date_to+1 Date last_day(:$flex$.application_gl_date_low) F Application GL Date Haut US Application GL Date High 9 80 1=1 acra.last_update_date>=:p_lud_from Date F Reçu Dernière mise à jour de US Receipt Last Updated From 10 90 1=1 acra.last_update_date<:p_lud_to+1 Date last_day(:$flex$.receipt_last_updated_from) F Reçu Dernière mise à jour au US Receipt Last Updated To 11 100 :p_in_curr_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 D Eingabewährung F Devise saisie I Divisa inserita US Entered Currency 12 110 1=1 hp.party_name=:party_name LOV Oracle AR_CUSTOMER_NAME Y Y select party.party_name id, party.party_name value, null description from hz_cust_accounts cu,hz_parties party where cu.party_id=party.party_id and cu.cust_account_id in (select cu2.cust_account_id from hz_cust_accounts cu2,hz_parties party2 where cu2.party_id=party2.party_id and party2.party_name= party.party_name) order by party.party_name D Von Kundenname F Nom du client I Nome cliente (min) US Customer Name 13 120 1=1 hca.account_number=:account_number LOV Oracle AR_CUSTOMER_NUMBER Y Y select cust.account_number id, cust.account_number value, null description from hz_cust_accounts cust,hz_parties party where cust.party_id=party.party_id order by cust.account_number D Von Kundennummer F Numéro de client I Numero cliente (min) US Customer Number 14 130 1=1 aba.name=:batch_name LOV Oracle AR_BATCH_NAME Y select b1.name id, b1.name value, null description from ar_batches b1 where b1.batch_id=(select max(b2.batch_id) from ar_batches b2 where b2.name=b1.name) order by b1.name D Stapel F Nom du lot I Nome batch US Batch Name 15 140 1=1 absa.name=:batch_source_name LOV Oracle AR_BATCH_SOURCE_NAME Y select name id, name value, null description from ar_batch_sources order by name D Von Belegherkunft F Nom de la source du lot I Nome origine batch - Minimo US Batch Source Name 16 150 1=1 acra.receipt_number>=:receipt_number_from LOV Oracle AR_RECEIPT_NUMBER Y Y select cr.receipt_number id, cr.receipt_number value, null description from ar_cash_receipts cr where cr.cash_receipt_id in (select max(cr2.cash_receipt_id) from ar_cash_receipts cr2 where cr.receipt_number=cr2.receipt_number) and not exists ( select 'X' from okl_trx_csh_receipt_b oklrct where oklrct.cash_receipt_id=cr.cash_receipt_id and nvl(oklrct.receipt_type,'REG')='FUT' ) order by cr.receipt_number,cr.cash_receipt_id D Von Zahlungs-Nr. F Numéro du récépissé Bas I Numero incasso - Minimo US Receipt Number Low 17 160 1=1 acra.receipt_number<=:receipt_number_to LOV Oracle AR_RECEIPT_NUMBER Y Y select cr.receipt_number id, cr.receipt_number value, null description from ar_cash_receipts cr where cr.cash_receipt_id in (select max(cr2.cash_receipt_id) from ar_cash_receipts cr2 where cr.receipt_number=cr2.receipt_number) and not exists ( select 'X' from okl_trx_csh_receipt_b oklrct where oklrct.cash_receipt_id=cr.cash_receipt_id and nvl(oklrct.receipt_type,'REG')='FUT' ) order by cr.receipt_number,cr.cash_receipt_id D Bis Zahlungs-Nr. F Numéro de reçu élevé I Numero incasso - Massimo US Receipt Number High 18 170 :p_reval_currency LOV Revaluation Currency E32BB68D727ACCAFE0530100007F85F2 Y select distinct fcv.currency_code value, fcv.description from fnd_currencies_vl fcv, gl_daily_rates gdr where fcv.currency_code=gdr.to_currency and fcv.enabled_flag='Y' and gdr.from_currency in ( select gl.currency_code from gl_ledgers gl where gl.ledger_id in (select asp.set_of_books_id from ar_system_parameters asp) and (:$flex$.Ledger is null or xxen_util.contains(:$flex$.Ledger,gl.name) = 'Y') and (:$flex$.Operating_Unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.Operating_unit,hou.name) = 'Y')) ) and gdr.conversion_date>=sysdate-365 order by 1 F Monnaie de réévaluation US Revaluation Currency 19 &reval_cols select 'x.currency revaluation_from_currency, :p_reval_currency revaluation_currency, :p_reval_conv_type revaluation_rate_type, nvl2(:p_reval_currency,:p_reval_conv_date,null) revaluation_date, x.reval_conv_rate revaluation_rate, x.on_account_amt * x.reval_conv_rate "On Account Amt ' || :p_reval_currency || '", x.unapplied_amt * x.reval_conv_rate "Unapplied Amt ' || :p_reval_currency || '", x.claim_amt * x.reval_conv_rate "Claim Amt ' || :p_reval_currency || '",' from dual F Monnaie de réévaluation US Revaluation Currency 20 180 :p_reval_conv_type LOV Revaluation Rate Type E32BB68D727BCCAFE0530100007F85F2 Y select distinct gdct.user_conversion_type value, gdct.description||' ('||count(*) over (partition by gdr.conversion_type)||')' description from gl_daily_conversion_types gdct, gl_daily_rates gdr where gdr.from_currency in ( select gl.currency_code from gl_ledgers gl where gl.ledger_id in (select asp.set_of_books_id from ar_system_parameters asp) and (:$flex$.Ledger is null or xxen_util.contains(:$flex$.Ledger,gl.name) = 'Y') and (:$flex$.Operating_Unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.Operating_unit,hou.name) = 'Y')) ) and gdr.to_currency=:$flex$.revaluation_currency and gdr.conversion_date>=sysdate-365 and gdct.conversion_type=gdr.conversion_type order by 1 F Taux de réévaluation Type US Revaluation Rate Type 21 190 :p_reval_conv_date Date sysdate F Date de réévaluation US Revaluation Date 22 200 &receipt_dff_cols select xxen_util.dff_columns('ar_cash_receipts_all', p_display_mode=>:receipt_dff_display) sql_text from dual LOV Blitz Report DFF Display 53B31EFFC6B85470E0630100007F501D Y select 'V' id, 'Value' value, 'Value only' description from dual union all select 'C' id, 'Value: Description' value, 'Concatenated value and description' description from dual union all select 'S' id, 'Value, Description' value, 'Value and description in separate columns' description from dual fnd_profile.value('XXEN_REPORT_DFF_DISPLAY') F Receipt DFF Display US Show Receipt DFF Segments 23 &receipt_dff_cols2 select xxen_util.dff_columns(p_table_name=>'ar_cash_receipts_all',p_prefix=>'x.', p_display_mode=>:receipt_dff_display) sql_text from dual US Receipt DFF Display 24 &receipt_dff_cols3 select xxen_util.dff_columns(p_table_name=>'ar_cash_receipts_all',p_hide_column_name=>'Y', p_display_mode=>:receipt_dff_display) sql_text from dual US Receipt DFF Display :$flex$.As_Of_GL_Date As of GL Date Y Apply Date Cols :$flex$.Ledger Ledger Revaluation Currency :$flex$.Ledger Ledger Revaluation Rate Type :$flex$.Operating_Unit Operating Unit Revaluation Currency :$flex$.Operating_Unit Operating Unit Revaluation Rate Type :$flex$.Operating_unit Operating Unit Revaluation Currency :$flex$.Operating_unit Operating Unit Revaluation Rate Type :$flex$.application_gl_date_low Application GL Date Low Y Application GL Date High :$flex$.ledger Ledger Operating Unit :$flex$.receipt_gl_date_low Receipt GL Date Low Y Receipt GL Date High :$flex$.receipt_last_updated_from Receipt Last Updated From Y Receipt Last Updated To :$flex$.revaluation_currency Revaluation Currency Revaluation Rate Type 73FC6C0370F1EB5E7EBD51A1AD25F19A Pivot: By Customer Y SYSADMIN 4 ACCOUNT_SEGMENT 5 ACCOUNT_SEGMENT_DESC 36 APPLICATION_NOTES 28 APPLIED_DATE 29 APPLIED_GL_DATE 2 BALANCING_SEGMENT 3 BALANCING_SEGMENT_DESC 48 BANK_ACCOUNT_CURRENCY 49 BANK_ACCOUNT_DESCRIPTION 45 BANK_ACCOUNT_NAME 46 BANK_ACCOUNT_NAME_ALT 47 BANK_ACCOUNT_NUMBER 44 BANK_BRANCH_COUNTRY 41 BANK_BRANCH_NAME 42 BANK_BRANCH_NAME_ALT 38 BANK_NAME 39 BANK_NAME_ALT 40 BANK_NUMBER 15 BATCH_NAME 14 BATCH_SOURCE_NAME 43 BRANCH_NUMBER 35 CLAIM_AMT 11 COLLECTOR 12 COLLECTOR_ACCOUNT 13 COLLECTOR_SITE 31 CURRENCY 9 CUSTOMER_ADDRESS 10 CUSTOMER_COUNTRY 8 CUSTOMER_LOCATION 6 CUSTOMER_NAME 7 CUSTOMER_NUMBER 21 ISSUE_DATE 1 LEDGER 33 ON_ACCOUNT_AMT 37 OPERATING_UNIT 32 RECEIPT_AMOUNT 25 RECEIPT_CREATED_BY 24 RECEIPT_CREATION_DATE 30 RECEIPT_CURRENCY 22 RECEIPT_DATE 23 RECEIPT_GL_DATE 20 RECEIPT_HISTORY_STATUS 27 RECEIPT_LAST_UPDATED_BY 26 RECEIPT_LAST_UPDATED_DATE 18 RECEIPT_METHOD 16 RECEIPT_NUMBER 19 RECEIPT_STATUS 17 RECEIPT_TYPE 34 UNAPPLIED_AMT ACCOUNT_SEGMENT FILTER 3 BALANCING_SEGMENT FILTER 2 BALANCING_SEGMENT_DESC ROW 1 BATCH_SOURCE_NAME FILTER 5 CLAIM_AMT VALUE 4 SUM CUSTOMER_NAME ROW 2 CUSTOMER_NUMBER FILTER 4 LEDGER FILTER 1 ON_ACCOUNT_AMT VALUE 2 SUM RECEIPT_AMOUNT VALUE 1 SUM UNAPPLIED_AMT VALUE 3 SUM S Site SYSADMIN 73FC6C0370F1EB5E7EBD51A1AD25F19A