ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE7F79D2E0530100007F1FF2 AR Account Number Y Y select hca.account_number value, hp.party_name||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name US 8E2FF36EDE8679D2E0530100007F1FF2 AR Customer Name Y select hp.party_name value, hca.account_number||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name US 8E2FF36EDEA579D2E0530100007F1FF2 AR Receipt Method Y select arm.name value, ifpct.payment_channel_name description from ar_receipt_methods arm, iby_fndcpt_pmt_chnnls_tl ifpct where arm.payment_channel_code=ifpct.payment_channel_code(+) and ifpct.language(+)=userenv('lang') order by arm.name US F26C78167A214EFBE0530100007F336B GL Balancing Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and (fifsgv.application_id, fifsgv.id_flex_code, fifsgv.id_flex_num, fifsgv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='GL_BALANCING' and fsav.attribute_value='Y') and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and (:$flex$.chart_of_accounts_id is not null or :$flex$.chart_of_accounts is not null or :$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null or :$flex$.book is not null) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( fifsv.id_flex_num=:$flex$.chart_of_accounts_id or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or (:$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null) and fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (:$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 (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) or fifsgv.id_flex_num in (select fbc.accounting_flex_structure from fa_book_controls fbc where xxen_util.contains(:$flex$.book,fbc.book_type_code)='Y') ) ) order by ffvv.flex_value US CBCC89B0214507FDE05362FB09054E05 select x.* from ( select gl.name ledger, gl.currency_code ledger_currency, haou.name operating_unit, hp.party_name customer_name, hca.account_number customer_number, decode(hp.party_type, 'ORGANIZATION',hp.organization_name_phonetic, null) customer_name_alt, hcsua.location customer_location, hz_format_pub.format_address(hps.location_id,null,null,' , ') customer_address, ftv2.territory_short_name customer_country, hp.jgzz_fiscal_code customer_tax_number, nvl(ac2.name,ac.name) collector, ac.name collector_account, ac2.name collector_site, -- Receipt Main Details decode(acrha.status, 'REVERSED', aba1.name, aba1.name) batch_name, absa.name batch_source, acra.receipt_number, acra.receipt_date, xxen_util.meaning(acra.type,'PAYMENT_CATEGORY_TYPE',222) receipt_type, arm.name receipt_method, case when acra.status in ('REV', 'NSF', 'STOP') and acrha.status <> 'REVERSED' then case :p_mrc_flag when 'R' 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_apps_all_mrc_v araa2 where araa2.cash_receipt_id = acra.cash_receipt_id ) else (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 araa2.cash_receipt_id = acra.cash_receipt_id ) end else xxen_util.meaning(acra.status,'CHECK_STATUS',222) end receipt_status, xxen_util.meaning(acrha.status,'RECEIPT_CREATION_STATUS',222) receipt_history_status, acra.currency_code receipt_currency, decode(acrha.status,'REVERSED',0,acrha.amount) + decode(acrha.status,'REVERSED',0,nvl(acrha.factor_discount_amount,0)) receipt_amount, decode(acrha.status,'REVERSED',0,acrha.factor_discount_amount) factor_discount_amount, decode(acrha.status,'REVERSED',0,acrha.acctd_amount) + decode(acrha.status,'REVERSED',0,nvl(acrha.acctd_factor_discount_amount,0)) acctd_receipt_amount, decode(acrha.status,'REVERSED',0,acrha.acctd_factor_discount_amount) acctd_factor_discount_amount, -- Applied To Trx Details case when aspa.show_billing_number_flag = 'Y' then decode(araa.status, 'ACC', xxen_util.meaning('ACC','PAYMENT_TYPE',222) , decode(acia.cons_billing_number, null, apsa.trx_number , substrb(rtrim(acia.cons_billing_number)||'/'||rtrim(to_char(rcta.trx_number)),1,30))) else decode(araa.status, 'ACC', xxen_util.meaning('ACC','PAYMENT_TYPE',222) , apsa.trx_number) end applied_to_trx_number, rcta.trx_date, rcta.invoice_currency_code trx_currency, nvl(rctlgda.amount,0) trx_amount, nvl(rctlgda.acctd_amount,0) acctd_trx_amount, hca2.account_number related_customer_number, -- Application Details araa.apply_date, araa.gl_date apply_gl_date, nvl(araa.amount_applied_from,araa.amount_applied) amount_applied_from_receipt, nvl(araa.amount_applied,0) amount_applied_to_trx, nvl(araa.earned_discount_taken,0) earned_discount_taken, nvl(araa.unearned_discount_taken,0) unearned_discount_taken, nvl(araa.acctd_amount_applied_from,0) acctd_amt_applied_from_receipt, nvl(araa.acctd_amount_applied_to + araa.acctd_earned_discount_taken + araa.acctd_unearned_discount_taken,0) acctd_amt_applied_to_trx, nvl(araa.acctd_earned_discount_taken,0) acctd_earned_discount_taken, nvl(araa.acctd_unearned_discount_taken,0) acctd_unearned_discount_taken, nvl(araa.acctd_amount_applied_from - araa.acctd_amount_applied_to,0) receipt_gain_loss, -- Additional Receipt Infor fds.name doc_sequence_name, acra.doc_sequence_value, acra.creation_date receipt_creation_date, xxen_util.user_name(acra.created_by) receipt_created_by, acra.last_update_date receipt_last_updated_date, xxen_util.user_name(acra.last_updated_by) receipt_last_updated_by, acra.deposit_date, acra.anticipated_clearing_date, acra.misc_payment_source, xxen_util.meaning(acra.reference_type,'CB_REFERENCE_TYPE',222) reference_type, avta.tax_code, acra.exchange_rate, acra.exchange_date, acra.exchange_rate_type, acra.application_notes, cbbv.bank_name, cbbv.bank_name_alt, cbbv.bank_number, cbbv.bank_branch_name, cbbv.bank_branch_name_alt, cbbv.branch_number, 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, -- Debit GL Account Info fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', gcc2.chart_of_accounts_id, NULL, gcc2.code_combination_id, 'ALL', 'Y', 'VALUE') debit_account, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', gcc2.chart_of_accounts_id, NULL, gcc2.code_combination_id, 'ALL', 'Y', 'DESCRIPTION') debit_account_desc, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', gcc2.chart_of_accounts_id, NULL, gcc2.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE') balancing_segment, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', gcc2.chart_of_accounts_id, NULL, gcc2.code_combination_id, 'GL_BALANCING', 'Y', 'DESCRIPTION') balancing_segment_desc, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', gcc2.chart_of_accounts_id, NULL, gcc2.code_combination_id, 'GL_ACCOUNT', 'Y', 'VALUE') account_segment, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', gcc2.chart_of_accounts_id, NULL, gcc2.code_combination_id, 'GL_ACCOUNT', 'Y', 'DESCRIPTION') account_segment_desc, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', gcc2.chart_of_accounts_id, NULL, gcc2.code_combination_id, 'ALL', 'Y', 'VALUE') || ' - ' || fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', gcc2.chart_of_accounts_id, NULL, gcc2.code_combination_id, 'ALL', 'Y', 'DESCRIPTION') debit_account_pivot_label, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', gcc2.chart_of_accounts_id, NULL, gcc2.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE') || ' - ' || fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', gcc2.chart_of_accounts_id, NULL, gcc2.code_combination_id, 'GL_BALANCING', 'Y', 'DESCRIPTION') bal_seg_pivot_label, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', gcc2.chart_of_accounts_id, NULL, gcc2.code_combination_id, 'GL_ACCOUNT', 'Y', 'VALUE') || ' - ' || fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', gcc2.chart_of_accounts_id, NULL, gcc2.code_combination_id, 'GL_ACCOUNT', 'Y', 'DESCRIPTION') account_pivot_label, hp.party_name || ' - ' || hca.account_number cust_name_pivot_label, hca.account_number || ' - ' || hp.party_name cust_number_pivot_label, decode(:reporting_level,1000,gl.name,3000,haou.name,null) reporting_entity from &lp_table_list where acra.org_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 acra.org_id = haou.organization_id and acra.set_of_books_id = gl.ledger_id and acra.cash_receipt_id = acrha1.cash_receipt_id and acra.org_id = acrha1.org_id and acrha1.first_posted_record_flag = 'Y' and acrha1.batch_id = aba1.batch_id(+) and acrha1.org_id = aba1.org_id(+) and acrha.batch_id = aba.batch_id(+) and acrha.org_id = aba.org_id(+) and acra.doc_sequence_id = fds.doc_sequence_id(+) and acra.vat_tax_id = avta.vat_tax_id(+) and acra.org_id = avta.org_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 acra.receipt_method_id = arm.receipt_method_id and acra.cash_receipt_id = acrha.cash_receipt_id and acra.org_id = acrha.org_id and gcc.code_combination_id = acrha.account_code_combination_id 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 araa.cash_receipt_id = acra.cash_receipt_id and araa.org_id = acra.org_id and ( araa.status = 'APP' or (araa.status = 'ACTIVITY' and araa.receivables_trx_id = -16)) and araa.applied_customer_trx_id = rcta.customer_trx_id(+) and araa.org_id = rcta.org_id(+) and araa.applied_customer_trx_id = rctlgda.customer_trx_id(+) and araa.org_id = rctlgda.org_id(+) and nvl(aba.batch_source_id,-1) = absa.batch_source_id(+) and nvl(aba.org_id,-1) = absa.org_id(+) and araa.applied_payment_schedule_id = apsa.payment_schedule_id(+) and araa.org_id = apsa.org_id(+) and apsa.customer_id = hca2.cust_account_id(+) and rctlgda.latest_rec_flag(+) = 'Y' and araa.code_combination_id = gcc2.code_combination_id and apsa.cons_inv_id = acia.cons_inv_id(+) and apsa.org_id = acia.org_id(+) and aspa.org_id = araa.org_id and :reporting_level in (1000,3000) and nvl(:p_coa,-1) = nvl(:p_coa,-1) and :p_mrc_flag = :p_mrc_flag and nvl(:p_gl_date_low_h,sysdate) = nvl(:p_gl_date_low_h,sysdate) and nvl(:p_gl_date_high_h,sysdate) = nvl(:p_gl_date_high_h,sysdate) and 1=1 ) x where 2=2 order by x.ledger, x.balancing_segment, x.operating_unit, x.receipt_currency, x.apply_date, x.receipt_number, x.applied_to_trx_number Removed incorrect not exists clause for 11i operating unit security Y #,##0.00;[Red]-#,##0.00 US AR Applied Receipts Application: Receivables Description: Receivables Applied Receipts Register Provided Templates: Default: Detail - Detail Listing with no Pivot Summarization Pivot: Summary by Apply Date - Summary by Balancing Segment, Receipt Currency, Apply Date Pivot: Summary by Batch - Summary by Balancing Segment, Receipt Currency, Batch Pivot: Summary by Customer Name - Summary by Balancing Segment, Receipt Currency, Customer with drilldown to details Pivot: Summary by Debit Account - Summary by Balancing Segment, Account Segment, Debit Account, Receipt Currency Pivot: Summary by GL Date - Summary by Balancing Segment, Receipt Currency, GL Date Source: Applied Receipts Register Short Name: RXARARRG Enginatics R12 only &lp_table_list 1=1 2=2 :p_coa :p_gl_date_high_h :p_gl_date_low_h :p_mrc_flag :reporting_level 1 -40 :p_coa Number select gl.chart_of_accounts_id from gl_ledgers gl where ( (:$flex$.reporting_level = 1000 and gl.name = :$flex$.reporting_context) or (:$flex$.reporting_level = 3000 and gl.ledger_id = (select hou.set_of_books_id from hr_operating_units hou where hou.name = :$flex$.reporting_context)) or (not exists (select null from gl_ledgers gl2 where ((:$flex$.reporting_level = 1000 and gl2.name = :$flex$.reporting_context) or (:$flex$.reporting_level = 3000 and gl2.ledger_id = (select hou2.set_of_books_id from hr_operating_units hou2 where hou2.name = :$flex$.reporting_context)) ) ) and gl.ledger_id = nvl(fnd_profile.value('GL_SET_OF_BKS_ID'),(select asp.set_of_books_id from ar_system_parameters asp where rownum <=1)) ) ) F Plan de comptes Id US Chart of Accounts Id 2 -30 :p_mrc_flag Char select case when (x.ci_rsob_id = x.pf_rsob_id) or (x.ci_rsob_id = -99) then 'P' else 'R' end from (select to_number(nvl(replace(substr(userenv('CLIENT_INFO'),45,10),' '),-99)) ci_rsob_id, to_number(nvl(fnd_profile.value('MRC_REPORTING_SOB_ID'),-1)) pf_rsob_id from dual ) x F Drapeau MRC US MRC Flag 3 &lp_table_list hr_all_organization_units haou, gl_ledgers gl, ar_cash_receipts_all acra, fnd_document_sequences fds, ar_vat_tax_all avta, ce_bank_accounts cba, ce_bank_acct_uses_all cbaua, ce_bank_branches_v cbbv, ar_receipt_methods arm, ar_cash_receipt_history_all acrha, gl_code_combinations gcc, 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_batches_all aba, ar_cash_receipt_history_all acrha1, ar_batches_all aba1, ar_receivable_applications_all araa, ra_customer_trx_all rcta, ra_cust_trx_line_gl_dist_all rctlgda, hz_cust_accounts hca2, ar_payment_schedules_all apsa, ar_batch_sources_all absa, gl_code_combinations gcc2, ar_cons_inv_all acia, ar_system_parameters_all aspa P F Drapeau MRC US MRC Flag 4 &lp_table_list hr_all_organization_units haou, gl_ledgers gl, ar_cash_receipts_all_mrc_v acra, fnd_document_sequences fds, ar_vat_tax_all avta, ce_bank_accounts cba, ce_bank_acct_uses_all cbaua, ce_bank_branches_v cbbv, ar_receipt_methods arm, ar_cash_receipt_hist_all_mrc_v acrha, gl_code_combinations gcc, 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_batches_all_mrc_v aba, ar_cash_receipt_hist_all_mrc_v archa1, ar_batches_all_mrc_v aba1, ar_receivable_apps_all_mrc_v araa, ra_customer_trx_all_mrc_v rcta, ra_trx_line_gl_dist_all_mrc_v rctlgda, hz_cust_accounts hca2, ar_payment_schedules_all_mrc_v apsa, ar_batch_sources_all absa, gl_code_combinations gcc2, ar_cons_inv_all acia, ar_system_parameters_all aspa R F Drapeau MRC US MRC Flag 5 1=1 acrha.cash_receipt_history_id in (select nvl(max(crhnew.cash_receipt_history_id ), max(decode(incrh.created_from,'RATE ADJUSTMENT TRIGGER', decode(incrh.current_record_flag,'N', decode(incrh.reversal_created_from,null,-100,incrh.cash_receipt_history_id), incrh.cash_receipt_history_id) ,incrh.cash_receipt_history_id ))) from ar_cash_receipt_history_all incrh, ar_cash_receipt_history_all crhnew where incrh.cash_receipt_id = acrha.cash_receipt_id and crhnew.cash_receipt_id(+) = incrh.cash_receipt_id and crhnew.current_record_flag(+) = 'Y' and incrh.gl_date <= nvl(:p_gl_date_high_h,to_date('2147/12/31','YYYY/MM/DD')) and crhnew.gl_date(+) <= nvl(:p_gl_date_high_h,to_date('2147/12/31','YYYY/MM/DD')) ) P US MRC Flag 6 1=1 acrha.cash_receipt_history_id in (select max(incrh.cash_receipt_history_id) from ar_cash_receipt_hist_all_mrc_v incrh where incrh.cash_receipt_id = acrha.cash_receipt_id and incrh.gl_date <= nvl(:p_gl_date_high_h,to_date('2147/12/31','YYYY/MM/DD')) ) R US MRC Flag 7 -20 :p_gl_date_low_h Date select nvl(:$flex$.applied_gl_date_from, ( select gps.start_date from gl_period_statuses gps where gps.period_name=:$flex$.Accounting_Period and gps.set_of_books_id= (select gl.ledger_id from gl_ledgers gl where (:$flex$.reporting_level = 1000 and gl.name = :$flex$.reporting_context) or (:$flex$.reporting_level = 3000 and gl.ledger_id = (select hou.set_of_books_id from hr_operating_units hou where hou.name = :$flex$.reporting_context)) ) and gps.application_id=222 ) ) from dual US GL Date Low Hidden 8 -10 :p_gl_date_high_h Date select nvl(:$flex$.applied_gl_date_to, ( select gps.end_date from gl_period_statuses gps where gps.period_name=:$flex$.Accounting_Period and gps.set_of_books_id= (select gl.ledger_id from gl_ledgers gl where (:$flex$.reporting_level = 1000 and gl.name = :$flex$.reporting_context) or (:$flex$.reporting_level = 3000 and gl.ledger_id = (select hou.set_of_books_id from hr_operating_units hou where hou.name = :$flex$.reporting_context)) ) and gps.application_id=222 ) ) from dual US GL Date High Hidden 9 10 :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 1000 Y AR مستوى إعداد التقرير مستوى إعداد التقرير D Auswertungsebene Auswertungsebene E Nivel de Informe Nivel de Informe F Niveau de rapport Niveau de reporting I Livello dichiarazione Livello di creazione rapporti JA レポート・レベル レポート・レベル KO 보고 레벨 보고 레벨 PTB Nível do Relatório Nível do Relatório RU Уровень отчетности Уровень отчетности S Rapporteringsnivå Rapporteringsnivå TR Raporlama Düzeyi Raporlama Düzeyi US Reporting Level Reporting Level ZHS 报告层 报告层 10 20 2=2 x.reporting_entity=:reporting_context LOV custom Y select 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 FROM FND_MO_REPORTING_ENTITIES_V WHERE reporting_level = :$flex$.fnd_mo_reporting_level and rownum=1 AR سياق إعداد التقرير سياق إعداد التقرير D Auswertungskontext Auswertungskontext E Contexto del Informe Contexto del Informe F Contexte du rapport Contexte de reporting I Contesto dichiarazione Contesto creazione rapporti JA レポート・コンテキスト レポート・コンテキスト KO 보고 컨텍스트 보고 컨텍스트 PTB Contexto do Relatório Contexto do Relatório RU Контекст отчетности Контекст отчетности S Rapporteringssammanhang Rapporteringssammanhang TR Raporlama İçeriği Raporlama İçeriği US Reporting Context Reporting Context ZHS 报告上下文 报告上下文 11 30 1=1 :p_bal_segment_low=:p_bal_segment_low and fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', :p_coa, NULL, gcc2.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE') >= :p_bal_segment_low LOV GL Balancing F26C78167A214EFBE0530100007F336B Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and (fifsgv.application_id, fifsgv.id_flex_code, fifsgv.id_flex_num, fifsgv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='GL_BALANCING' and fsav.attribute_value='Y') and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and (:$flex$.chart_of_accounts_id is not null or :$flex$.chart_of_accounts is not null or :$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null or :$flex$.book is not null) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( fifsv.id_flex_num=:$flex$.chart_of_accounts_id or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or (:$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null) and fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (:$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 (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) or fifsgv.id_flex_num in (select fbc.accounting_flex_structure from fa_book_controls fbc where xxen_util.contains(:$flex$.book,fbc.book_type_code)='Y') ) ) order by ffvv.flex_value AR مقطع الشركة من مقطع الشركة من D Von Firmensegment Von Firmensegment E De Segmento de Compañía De Segmento de Compañía F Segment d'équilibrage Bas Segment de société - De I Segmento società - minimo Segmento società - minimo JA 会社セグメント:自 会社セグメント:自 KO 회사 세그먼트 하한 회사 세그먼트 하한 PTB Segmento Empresa (Inferior) Segmento Empresa (Inferior) RU Сегмент компании с Сегмент компании с S Från bolagssegment Från bolagssegment TR Şirket Segmenti Alt Değeri Şirket Segmenti Alt Değeri US Balancing Segment Low Balancing Segment Low ZHS 公司段下限 公司段下限 12 40 1=1 :p_bal_segment_high=:p_bal_segment_high and fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', :p_coa, NULL, gcc2.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE') <= :p_bal_segment_high LOV GL Balancing F26C78167A214EFBE0530100007F336B Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and (fifsgv.application_id, fifsgv.id_flex_code, fifsgv.id_flex_num, fifsgv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='GL_BALANCING' and fsav.attribute_value='Y') and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and (:$flex$.chart_of_accounts_id is not null or :$flex$.chart_of_accounts is not null or :$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null or :$flex$.book is not null) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( fifsv.id_flex_num=:$flex$.chart_of_accounts_id or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or (:$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null) and fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (:$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 (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) or fifsgv.id_flex_num in (select fbc.accounting_flex_structure from fa_book_controls fbc where xxen_util.contains(:$flex$.book,fbc.book_type_code)='Y') ) ) order by ffvv.flex_value :$flex$.Balancing_Segment_Low AR مقطع الشركة إلى مقطع الشركة إلى D Bis Firmensegment Bis Firmensegment E A Segmento de Compañía A Segmento de Compañía F Segment d'équilibrage Haut Segment de société - A I Segmento società (max) Segmento società (max) JA 会社セグメント:至 会社セグメント:至 KO 회사 세그먼트 상한 회사 세그먼트 상한 PTB Segmento Empresa (Superior) Segmento Empresa (Superior) RU Сегмент компании по Сегмент компании по S Till bolagssegment Till bolagssegment TR Şirket Segmenti Üst Değeri Şirket Segmenti Üst Değeri US Balancing Segment High Balancing Segment High ZHS 公司段上限 公司段上限 13 50 1=1 select 'araa.gl_date>=to_date(''' || to_char(gps.start_date,'YYYY/MM/DD') || ''',''YYYY/MM/DD'') and araa.gl_date < to_date(''' || to_char(gps.end_date+1,'YYYY/MM/DD') || ''',''YYYY/MM/DD'')' from gl_period_statuses gps where gps.period_name=:period_name and gps.set_of_books_id= (select gl.ledger_id from gl_ledgers gl where (:reporting_level = 1000 and gl.name = :reporting_context) or (:reporting_level = 3000 and gl.ledger_id = (select hou.set_of_books_id from hr_operating_units hou where hou.name = :reporting_context)) ) and gps.application_id=222 LOV custom Y select gps.period_name value, xxen_util.meaning(gps.closing_status,'CLOSING_STATUS',222)||': '||gps.start_date||' - '||gps.end_date description from gl_period_statuses gps where gps.ledger_id= (select gl.ledger_id from gl_ledgers gl where (:$flex$.reporting_level = 1000 and gl.name = :$flex$.reporting_context) or (:$flex$.reporting_level = 3000 and gl.ledger_id = (select hou.set_of_books_id from hr_operating_units hou where hou.name = :$flex$.reporting_context)) ) and gps.start_date<=sysdate and gps.application_id=222 order by gps.start_date desc F Période comptable US Accounting Period 14 60 1=1 araa.gl_date>=:p_gl_date_from Date AR تاريخ أ/ع من تاريخ أ/ع من D Von Buchungsdatum Von Buchungsdatum E De Fecha Contable De Fecha Contable F GL appliqué Date 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 Applied GL Date From GL Date From ZHS GL 日期自 GL 日期自 15 70 1=1 araa.gl_date<:p_gl_date_to+1 Date last_day(:$flex$.applied_gl_date_from) AR تاريخ أ/ع إلى تاريخ أ/ع إلى D Bis Buchungsdatum Bis Buchungsdatum E A Fecha Contable A Fecha Contable F Date GL appliquée à 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 Applied GL Date To GL Date To ZHS GL 日期至 GL 日期至 16 80 1=1 acra.currency_code=:p_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 Eingabewährung Eingabewährung E Divisa Introducida Divisa Introducida F Devise saisie Devise de saisie I Divisa inserita Divisa inserita JA 入力通貨 入力通貨 KO 입력 통화 입력 통화 PTB Moeda Informada Moeda Informada RU Введенная валюта Введенная валюта S Registrerad valuta Registrerad valuta TR Girilen Para Birimi Girilen Para Birimi US Entered Currency Entered Currency ZHS 输入币种 输入币种 17 90 1=1 upper(hp.party_name) like upper(:p_customer_name) LOV AR Customer Name 8E2FF36EDE8679D2E0530100007F1FF2 Y select hp.party_name value, hca.account_number||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name F Nom du client US Customer Name 18 100 1=1 hp.party_name>=:p_customer_name_low LOV AR Customer Name 8E2FF36EDE8679D2E0530100007F1FF2 Y select hp.party_name value, hca.account_number||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name F Nom du client Low US Customer Name Low 19 110 1=1 hp.party_name<=:p_customer_name_high LOV AR Customer Name 8E2FF36EDE8679D2E0530100007F1FF2 Y select hp.party_name value, hca.account_number||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name :$flex$.Customer_Name_Low F Nom du client High US Customer Name High 20 120 1=1 hca.account_number=:p_account_number LOV AR Account Number 8E2FF36EDE7F79D2E0530100007F1FF2 Y Y select hca.account_number value, hp.party_name||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name F Numéro de compte du client US Customer Account Number 21 130 1=1 hca.account_number>=:p_account_number_low LOV AR Account Number 8E2FF36EDE7F79D2E0530100007F1FF2 Y Y select hca.account_number value, hp.party_name||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name F Numéro de compte client faible US Customer Account Num Low 22 140 1=1 hca.account_number<=:p_account_number_high LOV AR Account Number 8E2FF36EDE7F79D2E0530100007F1FF2 Y Y select hca.account_number value, hp.party_name||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name :$flex$.Customer_Account_Num_Low F Numéro de compte client élevé US Customer Account Num High 23 150 1=1 arm.name=:p_receipt_method LOV AR Receipt Method 8E2FF36EDEA579D2E0530100007F1FF2 Y select arm.name value, ifpct.payment_channel_name description from ar_receipt_methods arm, iby_fndcpt_pmt_chnnls_tl ifpct where arm.payment_channel_code=ifpct.payment_channel_code(+) and ifpct.language(+)=userenv('lang') order by arm.name F Méthode de réception US Receipt Method 24 160 1=1 acra.status=xxen_util.lookup_code(:p_receipt_status,'CHECK_STATUS',222) LOV custom Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='CHECK_STATUS' and flvv.view_application_id=222 and flvv.security_group_id=0 order by flvv.meaning F Statut de réception US Receipt Status 25 170 1=1 aba1.name>=:p_batch_name_low 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 AR اسم مجموعة من اسم مجموعة من D Von Stapel Von Stapel E De Nombre del Lote De Nombre del Lote F Nom du lot Bas Nom de lot - De I Nome batch - minimo Nome batch - minimo JA バッチ名:自 バッチ名:自 KO 뱃치명 하한 뱃치명 하한 PTB Nome do Lote - Inferior Nome do Lote - Inferior RU Имя пакета с Имя пакета с S Från buntnamn Från buntnamn TR İşlem Grubu Adı Alt Değeri İşlem Grubu Adı Alt Değeri US Batch Name Low Batch Name Low ZHS 批名下限 批名下限 26 180 1=1 aba1.name<=:p_batch_name_high 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 :$flex$.Batch_Name_Low AR اسم مجموعة إلى اسم مجموعة إلى D Bis Stapel Bis Stapel E A Nombre del Lote A Nombre del Lote F Nom du lot Haut Nom de lot - A I Nome batch - massimo Nome batch - massimo JA バッチ名:至 バッチ名:至 KO 뱃치명 상한 뱃치명 상한 PTB Nome do Lote - Superior Nome do Lote - Superior RU Имя пакета по Имя пакета по S Till buntnamn Till buntnamn TR İşlem Grubu Adı Üst Değeri İşlem Grubu Adı Üst Değeri US Batch Name High Batch Name High ZHS 批名上限 批名上限 27 190 1=1 acra.receipt_date>=:p_receipt_date_from Date F Date de réception du US Receipt Date From 28 200 1=1 acra.receipt_date<:p_receipt_date_to+1 Date last_day(:$flex$.receipt_date_from) F Date de réception au US Receipt Date To 29 210 1=1 acra.deposit_date>=:p_deposit_date_from Date AR تاريخ الإيداع من تاريخ الإيداع من D Von Anzahlungsdatum Von Anzahlungsdatum E A Fecha de Depósito A Fecha de Depósito F Date de dépôt du Date de remise - Du I Data versamento - Da Data versamento - Da JA 預入日:自 預入日:自 KO 예금 일자 From 예금 일자 From PTB Data do Depósito - De Data do Depósito - De RU Дата депонирования с Дата депонирования с S Från insättningsdatum Från insättningsdatum TR Kaparo Başlangıç Tarihi Kaparo Başlangıç Tarihi US Deposit Date From Deposit Date From ZHS 存款起始日期 存款起始日期 30 220 1=1 acra.deposit_date<:p_deposit_date_to+1 Date last_day(:$flex$.deposit_date_from) AR تاريخ الإيداع إلى تاريخ الإيداع إلى D Bis Anzahlungsdatum Bis Anzahlungsdatum E A Fecha de Depósito 2 A Fecha de Depósito F Date du dépôt au Date de remise - Du I Data versamento - A Data versamento - A JA 預入日:至 預入日:至 KO 예금 일자 To 예금 일자 To PTB Data do Depósito - Até Data do Depósito - Até RU Дата депонирования по Дата депонирования по S Till insättningsdatum Till insättningsdatum TR Kaparo Bitiş Tarihi Kaparo Bitiş Tarihi US Deposit Date To Deposit Date To ZHS 存款终止日期 存款终止日期 31 230 1=1 araa.apply_date>=:p_apply_date_from Date F Date d'application du US Apply Date From 32 240 1=1 araa.apply_date<:p_apply_date_to+1 Date last_day(:$flex$.apply_date_from) F Date d'application jusqu'au US Apply Date To 33 250 1=1 acra.last_update_date>=:p_lud_from Date F Reçu Dernière mise à jour de US Receipt Last Updated From 34 260 1=1 acra.last_update_date<:p_lud_to+1 Date F Reçu Dernière mise à jour au US Receipt Last Updated To 35 270 1=1 acra.receipt_number>=:p_receipt_num_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 AR رقم إيصال من رقم إيصال من D Von Zahlungs-Nr. Von Zahlungs-Nr. E De Número de Cobro De Número de Cobro F Numéro du récépissé Bas Numéro de règlement - De I Numero incasso - Minimo Numero incasso - Minimo JA 入金番号:自 入金番号:自 KO 수금 번호 하한 수금 번호 하한 PTB Número do Recebimento - Inferior Número do Recebimento - Inferior RU Номер поступления с Номер поступления с S Från betalningsnummer Från betalningsnummer TR Alınan Ödeme Numarası Alt Değeri Alınan Ödeme Numarası Alt Değeri US Receipt Number Low Receipt Number Low ZHS 收款编号下限 收款编号下限 36 280 1=1 acra.receipt_number<=:p_receipt_num_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 :$flex$.Receipt_Number_Low AR رقم إيصال إلى رقم إيصال إلى D Bis Zahlungs-Nr. Bis Zahlungs-Nr. E A Número de Cobro A Número de Cobro F Numéro de reçu élevé Numéro de règlement - A I Numero incasso - Massimo Numero incasso - Massimo JA 入金番号:至 入金番号:至 KO 수금 번호 상한 수금 번호 상한 PTB Número do Recebimento - Superior Número do Recebimento - Superior RU Номер поступления по Номер поступления по S Till betalningsnummer Till betalningsnummer TR Alınan Ödeme Numrası Üst Değeri Alınan Ödeme Numrası Üst Değeri US Receipt Number High Receipt Number High ZHS 接收编号上限 接收编号上限 37 290 1=1 acra.doc_sequence_id = (select fds.doc_sequence_id from fnd_document_sequences fds where fds.name=:p_doc_seq_name) LOV custom select fds.name value, null description from fnd_document_sequences fds, fnd_doc_sequence_assignments fdsa where fdsa.doc_sequence_id = fds.doc_sequence_id and fdsa.set_of_books_id in ( select gl.ledger_id from gl_ledgers gl where (:$flex$.reporting_level = 1000 and gl.name = :$flex$.reporting_context) or (:$flex$.reporting_level = 3000 and gl.ledger_id = (select hou.set_of_books_id from hr_operating_units hou where hou.name = :$flex$.reporting_context)) ) order by fds.name F Nom de la séquence du document US Document Sequence Name 38 300 1=1 acra.doc_sequence_value>=:p_doc_num_low LOV custom select to_char(doc_sequence_value) value, null description from ar_doc_sequence_audit where doc_sequence_id= (select doc_sequence_id from fnd_document_sequences where name = :$flex$.document_sequence_name) order by value,description F Numéro du document Faible US Document Number Low 39 310 1=1 acra.doc_sequence_value<=:p_doc_num_high LOV custom select to_char(doc_sequence_value) value, null description from ar_doc_sequence_audit where doc_sequence_id= (select doc_sequence_id from fnd_document_sequences where name = :$flex$.document_sequence_name) order by value,description :$flex$.Document_Number_Low F Numéro du document Haut US Document Number High 40 320 1=1 apsa.trx_number>=:p_trx_number_low 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 F Numéro de transaction Bas US Transaction Number Low 41 330 1=1 apsa.trx_number<=:p_trx_number_high 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 :$flex$.Transaction_Number_Low F Numéro de transaction Haut US Transaction Number High 42 340 1=1 arpt_sql_func_util.get_trx_type_details(rcta.cust_trx_type_id,'NAME') >= :p_trx_type_low LOV Oracle AR_INVOICE_TYPE Y select name id, name value, null description from ra_cust_trx_types order by name US Transaction Type Low 43 350 1=1 arpt_sql_func_util.get_trx_type_details(rcta.cust_trx_type_id,'NAME') <= :p_trx_type_high LOV Oracle AR_INVOICE_TYPE Y select name id, name value, null description from ra_cust_trx_types order by name :$flex$.Transaction_Type_Low F Type de transaction élevé US Transaction Type High :$flex$.Accounting_Period Accounting Period GL Date High Hidden :$flex$.Accounting_Period Accounting Period GL Date Low Hidden :$flex$.Balancing_Segment_Low Balancing Segment Low Balancing Segment High :$flex$.Batch_Name_Low Batch Name Low Batch Name High :$flex$.Customer_Account_Num_Low Customer Account Num Low Customer Account Num High :$flex$.Customer_Name_Low Customer Name Low Customer Name High :$flex$.Document_Number_Low Document Number Low Document Number High :$flex$.Receipt_Number_Low Receipt Number Low Receipt Number High :$flex$.Transaction_Number_Low Transaction Number Low Transaction Number High :$flex$.Transaction_Type_Low Transaction Type Low Transaction Type High :$flex$.applied_gl_date_from Applied GL Date From Y Applied GL Date To :$flex$.applied_gl_date_from Applied GL Date From Y GL Date Low Hidden :$flex$.applied_gl_date_to Applied GL Date To Y GL Date High Hidden :$flex$.apply_date_from Apply Date From Y Apply Date To :$flex$.chart_of_accounts_id Chart of Accounts Id Balancing Segment High :$flex$.chart_of_accounts_id Chart of Accounts Id Balancing Segment Low :$flex$.deposit_date_from Deposit Date From Y Deposit Date To :$flex$.document_sequence_name Document Sequence Name Document Number High :$flex$.document_sequence_name Document Sequence Name Document Number Low :$flex$.fnd_mo_reporting_level Reporting Level Reporting Context :$flex$.receipt_date_from Receipt Date From Y Receipt Date To :$flex$.reporting_context Reporting Context Accounting Period :$flex$.reporting_context Reporting Context Chart of Accounts Id :$flex$.reporting_context Reporting Context Document Sequence Name :$flex$.reporting_context Reporting Context GL Date High Hidden :$flex$.reporting_context Reporting Context GL Date Low Hidden :$flex$.reporting_level Reporting Level Accounting Period :$flex$.reporting_level Reporting Level Chart of Accounts Id :$flex$.reporting_level Reporting Level Document Sequence Name :$flex$.reporting_level Reporting Level GL Date High Hidden :$flex$.reporting_level Reporting Level GL Date Low Hidden Default: Detail Default Detail Template SYSADMIN 78 ACCOUNT_PIVOT_LABEL 74 ACCOUNT_SEGMENT 75 ACCOUNT_SEGMENT_DESC 42 ACCTD_AMT_APPLIED_FROM_RECEIPT 43 ACCTD_AMT_APPLIED_TO_TRX 44 ACCTD_EARNED_DISCOUNT_TAKEN 28 ACCTD_FACTOR_DISCOUNT_AMOUNT 27 ACCTD_RECEIPT_AMOUNT 33 ACCTD_TRX_AMOUNT 45 ACCTD_UNEARNED_DISCOUNT_TAKEN 38 AMOUNT_APPLIED_FROM_RECEIPT 39 AMOUNT_APPLIED_TO_TRX 54 ANTICIPATED_CLEARING_DATE 61 APPLICATION_NOTES 29 APPLIED_TO_TRX_NUMBER 6 35 APPLY_DATE 4 36 APPLY_GL_DATE 3 BALANCING_SEGMENT 2 4 BALANCING_SEGMENT_DESC 77 BAL_SEG_PIVOT_LABEL 71 BANK_ACCOUNT_CURRENCY 72 BANK_ACCOUNT_DESCRIPTION 70 BANK_ACCOUNT_NAME 69 BANK_ACCOUNT_NAME_ALT 68 BANK_ACCOUNT_NUMBER 66 BANK_BRANCH_NAME 67 BANK_BRANCH_NAME_ALT 63 BANK_NAME 64 BANK_NAME_ALT 62 BANK_NUMBER 16 BATCH_NAME 17 BATCH_SOURCE 65 BRANCH_NUMBER 13 COLLECTOR 14 COLLECTOR_ACCOUNT 15 COLLECTOR_SITE 10 CUSTOMER_ADDRESS 11 CUSTOMER_COUNTRY 9 CUSTOMER_LOCATION 6 CUSTOMER_NAME 8 CUSTOMER_NAME_ALT 7 CUSTOMER_NUMBER 12 CUSTOMER_TAX_NUMBER 79 CUST_NAME_PIVOT_LABEL 80 CUST_NUMBER_PIVOT_LABEL 37 DEBIT_ACCOUNT 73 DEBIT_ACCOUNT_DESC 76 DEBIT_ACCOUNT_PIVOT_LABEL 53 DEPOSIT_DATE 47 DOC_SEQUENCE_NAME 48 DOC_SEQUENCE_VALUE 40 EARNED_DISCOUNT_TAKEN 59 EXCHANGE_DATE 58 EXCHANGE_RATE 60 EXCHANGE_RATE_TYPE 26 FACTOR_DISCOUNT_AMOUNT 1 LEDGER 1 2 LEDGER_CURRENCY 55 MISC_PAYMENT_SOURCE 5 OPERATING_UNIT 3 25 RECEIPT_AMOUNT 50 RECEIPT_CREATED_BY 49 RECEIPT_CREATION_DATE 24 RECEIPT_CURRENCY 19 RECEIPT_DATE 46 RECEIPT_GAIN_LOSS 23 RECEIPT_HISTORY_STATUS 52 RECEIPT_LAST_UPDATED_BY 51 RECEIPT_LAST_UPDATED_DATE 21 RECEIPT_METHOD 18 RECEIPT_NUMBER 5 22 RECEIPT_STATUS 20 RECEIPT_TYPE 56 REFERENCE_TYPE 34 RELATED_CUSTOMER_NUMBER 81 REPORTING_ENTITY 57 TAX_CODE 32 TRX_AMOUNT 31 TRX_CURRENCY 30 TRX_DATE 41 UNEARNED_DISCOUNT_TAKEN S Site Pivot: Summary by Apply Date Pivot: Summary by Balancing Segment, Receipt Currency, Apply Date with drilldown to details SYSADMIN 78 ACCOUNT_PIVOT_LABEL 74 ACCOUNT_SEGMENT 75 ACCOUNT_SEGMENT_DESC 38 ACCTD_AMT_APPLIED_FROM_RECEIPT 39 ACCTD_AMT_APPLIED_TO_TRX 41 ACCTD_EARNED_DISCOUNT_TAKEN 24 ACCTD_FACTOR_DISCOUNT_AMOUNT 23 ACCTD_RECEIPT_AMOUNT 29 ACCTD_TRX_AMOUNT 42 ACCTD_UNEARNED_DISCOUNT_TAKEN 34 AMOUNT_APPLIED_FROM_RECEIPT 35 AMOUNT_APPLIED_TO_TRX 54 ANTICIPATED_CLEARING_DATE 61 APPLICATION_NOTES 25 APPLIED_TO_TRX_NUMBER 7 31 APPLY_DATE 4 32 APPLY_GL_DATE 3 BALANCING_SEGMENT 2 4 BALANCING_SEGMENT_DESC 77 BAL_SEG_PIVOT_LABEL 71 BANK_ACCOUNT_CURRENCY 72 BANK_ACCOUNT_DESCRIPTION 68 BANK_ACCOUNT_NAME 69 BANK_ACCOUNT_NAME_ALT 70 BANK_ACCOUNT_NUMBER 65 BANK_BRANCH_NAME 66 BANK_BRANCH_NAME_ALT 62 BANK_NAME 63 BANK_NAME_ALT 64 BANK_NUMBER 16 BATCH_NAME 17 BATCH_SOURCE 67 BRANCH_NUMBER 13 COLLECTOR 14 COLLECTOR_ACCOUNT 15 COLLECTOR_SITE 10 CUSTOMER_ADDRESS 11 CUSTOMER_COUNTRY 9 CUSTOMER_LOCATION 6 CUSTOMER_NAME 5 8 CUSTOMER_NAME_ALT 7 CUSTOMER_NUMBER 12 CUSTOMER_TAX_NUMBER 79 CUST_NAME_PIVOT_LABEL 80 CUST_NUMBER_PIVOT_LABEL 33 DEBIT_ACCOUNT 73 DEBIT_ACCOUNT_DESC 76 DEBIT_ACCOUNT_PIVOT_LABEL 53 DEPOSIT_DATE 43 DOC_SEQUENCE_NAME 44 DOC_SEQUENCE_VALUE 36 EARNED_DISCOUNT_TAKEN 59 EXCHANGE_DATE 58 EXCHANGE_RATE 60 EXCHANGE_RATE_TYPE 22 FACTOR_DISCOUNT_AMOUNT 1 LEDGER 1 2 LEDGER_CURRENCY 55 MISC_PAYMENT_SOURCE 5 OPERATING_UNIT 21 RECEIPT_AMOUNT 50 RECEIPT_CREATED_BY 49 RECEIPT_CREATION_DATE 20 RECEIPT_CURRENCY 3 19 RECEIPT_DATE 40 RECEIPT_GAIN_LOSS 48 RECEIPT_HISTORY_STATUS 52 RECEIPT_LAST_UPDATED_BY 51 RECEIPT_LAST_UPDATED_DATE 46 RECEIPT_METHOD 18 RECEIPT_NUMBER 6 47 RECEIPT_STATUS 45 RECEIPT_TYPE 56 REFERENCE_TYPE 30 RELATED_CUSTOMER_NUMBER 81 REPORTING_ENTITY 57 TAX_CODE 28 TRX_AMOUNT 27 TRX_CURRENCY 26 TRX_DATE 37 UNEARNED_DISCOUNT_TAKEN ACCOUNT_SEGMENT FILTER 3 ACCTD_AMT_APPLIED_FROM_RECEIPT VALUE 5 SUM ACCTD_AMT_APPLIED_TO_TRX VALUE 6 SUM ACCTD_EARNED_DISCOUNT_TAKEN VALUE 8 SUM ACCTD_UNEARNED_DISCOUNT_TAKEN VALUE 9 SUM AMOUNT_APPLIED_FROM_RECEIPT VALUE 1 SUM AMOUNT_APPLIED_TO_TRX VALUE 2 SUM APPLY_DATE ROW 3 BALANCING_SEGMENT FILTER 2 BAL_SEG_PIVOT_LABEL ROW 1 BATCH_SOURCE FILTER 7 CUSTOMER_NAME FILTER 5 CUSTOMER_NUMBER FILTER 6 EARNED_DISCOUNT_TAKEN VALUE 3 SUM LEDGER FILTER 1 OPERATING_UNIT FILTER 4 RECEIPT_CURRENCY ROW 2 RECEIPT_GAIN_LOSS VALUE 7 SUM UNEARNED_DISCOUNT_TAKEN VALUE 4 SUM S Site Pivot: Summary by Batch Pivot: Summary by Balancing Segment, Receipt Currency, Batch with drilldown to details SYSADMIN 78 ACCOUNT_PIVOT_LABEL 74 ACCOUNT_SEGMENT 75 ACCOUNT_SEGMENT_DESC 38 ACCTD_AMT_APPLIED_FROM_RECEIPT 39 ACCTD_AMT_APPLIED_TO_TRX 41 ACCTD_EARNED_DISCOUNT_TAKEN 24 ACCTD_FACTOR_DISCOUNT_AMOUNT 23 ACCTD_RECEIPT_AMOUNT 29 ACCTD_TRX_AMOUNT 42 ACCTD_UNEARNED_DISCOUNT_TAKEN 34 AMOUNT_APPLIED_FROM_RECEIPT 35 AMOUNT_APPLIED_TO_TRX 54 ANTICIPATED_CLEARING_DATE 61 APPLICATION_NOTES 25 APPLIED_TO_TRX_NUMBER 7 31 APPLY_DATE 5 32 APPLY_GL_DATE 3 BALANCING_SEGMENT 2 4 BALANCING_SEGMENT_DESC 77 BAL_SEG_PIVOT_LABEL 71 BANK_ACCOUNT_CURRENCY 72 BANK_ACCOUNT_DESCRIPTION 68 BANK_ACCOUNT_NAME 69 BANK_ACCOUNT_NAME_ALT 70 BANK_ACCOUNT_NUMBER 65 BANK_BRANCH_NAME 66 BANK_BRANCH_NAME_ALT 62 BANK_NAME 63 BANK_NAME_ALT 64 BANK_NUMBER 16 BATCH_NAME 4 17 BATCH_SOURCE 67 BRANCH_NUMBER 13 COLLECTOR 14 COLLECTOR_ACCOUNT 15 COLLECTOR_SITE 10 CUSTOMER_ADDRESS 11 CUSTOMER_COUNTRY 9 CUSTOMER_LOCATION 6 CUSTOMER_NAME 8 CUSTOMER_NAME_ALT 7 CUSTOMER_NUMBER 12 CUSTOMER_TAX_NUMBER 79 CUST_NAME_PIVOT_LABEL 80 CUST_NUMBER_PIVOT_LABEL 33 DEBIT_ACCOUNT 73 DEBIT_ACCOUNT_DESC 76 DEBIT_ACCOUNT_PIVOT_LABEL 53 DEPOSIT_DATE 43 DOC_SEQUENCE_NAME 44 DOC_SEQUENCE_VALUE 36 EARNED_DISCOUNT_TAKEN 59 EXCHANGE_DATE 58 EXCHANGE_RATE 60 EXCHANGE_RATE_TYPE 22 FACTOR_DISCOUNT_AMOUNT 1 LEDGER 1 2 LEDGER_CURRENCY 55 MISC_PAYMENT_SOURCE 5 OPERATING_UNIT 21 RECEIPT_AMOUNT 46 RECEIPT_CREATED_BY 45 RECEIPT_CREATION_DATE 20 RECEIPT_CURRENCY 3 19 RECEIPT_DATE 40 RECEIPT_GAIN_LOSS 50 RECEIPT_HISTORY_STATUS 52 RECEIPT_LAST_UPDATED_BY 51 RECEIPT_LAST_UPDATED_DATE 48 RECEIPT_METHOD 18 RECEIPT_NUMBER 6 49 RECEIPT_STATUS 47 RECEIPT_TYPE 56 REFERENCE_TYPE 30 RELATED_CUSTOMER_NUMBER 81 REPORTING_ENTITY 57 TAX_CODE 28 TRX_AMOUNT 27 TRX_CURRENCY 26 TRX_DATE 37 UNEARNED_DISCOUNT_TAKEN ACCOUNT_SEGMENT FILTER 3 ACCTD_AMT_APPLIED_FROM_RECEIPT VALUE 5 SUM ACCTD_AMT_APPLIED_TO_TRX VALUE 6 SUM ACCTD_EARNED_DISCOUNT_TAKEN VALUE 8 SUM ACCTD_UNEARNED_DISCOUNT_TAKEN VALUE 9 SUM AMOUNT_APPLIED_FROM_RECEIPT VALUE 1 SUM AMOUNT_APPLIED_TO_TRX VALUE 2 SUM BALANCING_SEGMENT FILTER 2 BAL_SEG_PIVOT_LABEL ROW 1 BATCH_NAME ROW 3 BATCH_SOURCE FILTER 7 CUSTOMER_NAME FILTER 5 CUSTOMER_NUMBER FILTER 6 EARNED_DISCOUNT_TAKEN VALUE 3 SUM LEDGER FILTER 1 OPERATING_UNIT FILTER 4 RECEIPT_CURRENCY ROW 2 RECEIPT_GAIN_LOSS VALUE 7 SUM UNEARNED_DISCOUNT_TAKEN VALUE 4 SUM S Site Pivot: Summary by Customer Name Pivot: Summary by Balancing Segment, Receipt Currency, Customer with drilldown to details SYSADMIN 78 ACCOUNT_PIVOT_LABEL 74 ACCOUNT_SEGMENT 75 ACCOUNT_SEGMENT_DESC 38 ACCTD_AMT_APPLIED_FROM_RECEIPT 39 ACCTD_AMT_APPLIED_TO_TRX 41 ACCTD_EARNED_DISCOUNT_TAKEN 24 ACCTD_FACTOR_DISCOUNT_AMOUNT 23 ACCTD_RECEIPT_AMOUNT 29 ACCTD_TRX_AMOUNT 42 ACCTD_UNEARNED_DISCOUNT_TAKEN 34 AMOUNT_APPLIED_FROM_RECEIPT 35 AMOUNT_APPLIED_TO_TRX 54 ANTICIPATED_CLEARING_DATE 61 APPLICATION_NOTES 25 APPLIED_TO_TRX_NUMBER 7 31 APPLY_DATE 5 32 APPLY_GL_DATE 3 BALANCING_SEGMENT 2 4 BALANCING_SEGMENT_DESC 77 BAL_SEG_PIVOT_LABEL 71 BANK_ACCOUNT_CURRENCY 72 BANK_ACCOUNT_DESCRIPTION 68 BANK_ACCOUNT_NAME 69 BANK_ACCOUNT_NAME_ALT 70 BANK_ACCOUNT_NUMBER 65 BANK_BRANCH_NAME 66 BANK_BRANCH_NAME_ALT 62 BANK_NAME 63 BANK_NAME_ALT 64 BANK_NUMBER 16 BATCH_NAME 17 BATCH_SOURCE 67 BRANCH_NUMBER 13 COLLECTOR 14 COLLECTOR_ACCOUNT 15 COLLECTOR_SITE 10 CUSTOMER_ADDRESS 11 CUSTOMER_COUNTRY 9 CUSTOMER_LOCATION 6 CUSTOMER_NAME 4 8 CUSTOMER_NAME_ALT 7 CUSTOMER_NUMBER 12 CUSTOMER_TAX_NUMBER 79 CUST_NAME_PIVOT_LABEL 80 CUST_NUMBER_PIVOT_LABEL 33 DEBIT_ACCOUNT 73 DEBIT_ACCOUNT_DESC 76 DEBIT_ACCOUNT_PIVOT_LABEL 53 DEPOSIT_DATE 43 DOC_SEQUENCE_NAME 44 DOC_SEQUENCE_VALUE 36 EARNED_DISCOUNT_TAKEN 59 EXCHANGE_DATE 58 EXCHANGE_RATE 60 EXCHANGE_RATE_TYPE 22 FACTOR_DISCOUNT_AMOUNT 1 LEDGER 1 2 LEDGER_CURRENCY 55 MISC_PAYMENT_SOURCE 5 OPERATING_UNIT 21 RECEIPT_AMOUNT 50 RECEIPT_CREATED_BY 49 RECEIPT_CREATION_DATE 20 RECEIPT_CURRENCY 3 19 RECEIPT_DATE 40 RECEIPT_GAIN_LOSS 48 RECEIPT_HISTORY_STATUS 52 RECEIPT_LAST_UPDATED_BY 51 RECEIPT_LAST_UPDATED_DATE 46 RECEIPT_METHOD 18 RECEIPT_NUMBER 6 47 RECEIPT_STATUS 45 RECEIPT_TYPE 56 REFERENCE_TYPE 30 RELATED_CUSTOMER_NUMBER 81 REPORTING_ENTITY 57 TAX_CODE 28 TRX_AMOUNT 27 TRX_CURRENCY 26 TRX_DATE 37 UNEARNED_DISCOUNT_TAKEN ACCOUNT_SEGMENT FILTER 3 ACCTD_AMT_APPLIED_FROM_RECEIPT VALUE 5 SUM ACCTD_AMT_APPLIED_TO_TRX VALUE 6 SUM ACCTD_EARNED_DISCOUNT_TAKEN VALUE 8 SUM ACCTD_UNEARNED_DISCOUNT_TAKEN VALUE 9 SUM AMOUNT_APPLIED_FROM_RECEIPT VALUE 1 SUM AMOUNT_APPLIED_TO_TRX VALUE 2 SUM BALANCING_SEGMENT FILTER 2 BAL_SEG_PIVOT_LABEL ROW 1 BATCH_SOURCE FILTER 7 CUSTOMER_NAME FILTER 5 CUSTOMER_NUMBER FILTER 6 CUST_NAME_PIVOT_LABEL ROW 3 EARNED_DISCOUNT_TAKEN VALUE 3 SUM LEDGER FILTER 1 OPERATING_UNIT FILTER 4 RECEIPT_CURRENCY ROW 2 RECEIPT_GAIN_LOSS VALUE 7 SUM UNEARNED_DISCOUNT_TAKEN VALUE 4 SUM S Site Pivot: Summary by Debit Account Pivot: Summary by Balancing Segment, Account Segment, Debit Account, Receipt Currency with drilldown to details SYSADMIN 77 ACCOUNT_PIVOT_LABEL 74 ACCOUNT_SEGMENT 75 ACCOUNT_SEGMENT_DESC 38 ACCTD_AMT_APPLIED_FROM_RECEIPT 39 ACCTD_AMT_APPLIED_TO_TRX 41 ACCTD_EARNED_DISCOUNT_TAKEN 24 ACCTD_FACTOR_DISCOUNT_AMOUNT 23 ACCTD_RECEIPT_AMOUNT 29 ACCTD_TRX_AMOUNT 42 ACCTD_UNEARNED_DISCOUNT_TAKEN 34 AMOUNT_APPLIED_FROM_RECEIPT 35 AMOUNT_APPLIED_TO_TRX 54 ANTICIPATED_CLEARING_DATE 61 APPLICATION_NOTES 25 APPLIED_TO_TRX_NUMBER 7 31 APPLY_DATE 4 32 APPLY_GL_DATE 3 BALANCING_SEGMENT 2 4 BALANCING_SEGMENT_DESC 76 BAL_SEG_PIVOT_LABEL 71 BANK_ACCOUNT_CURRENCY 72 BANK_ACCOUNT_DESCRIPTION 68 BANK_ACCOUNT_NAME 69 BANK_ACCOUNT_NAME_ALT 70 BANK_ACCOUNT_NUMBER 65 BANK_BRANCH_NAME 66 BANK_BRANCH_NAME_ALT 62 BANK_NAME 63 BANK_NAME_ALT 64 BANK_NUMBER 16 BATCH_NAME 17 BATCH_SOURCE 67 BRANCH_NUMBER 13 COLLECTOR 14 COLLECTOR_ACCOUNT 15 COLLECTOR_SITE 10 CUSTOMER_ADDRESS 11 CUSTOMER_COUNTRY 9 CUSTOMER_LOCATION 6 CUSTOMER_NAME 5 8 CUSTOMER_NAME_ALT 7 CUSTOMER_NUMBER 12 CUSTOMER_TAX_NUMBER 78 CUST_NAME_PIVOT_LABEL 79 CUST_NUMBER_PIVOT_LABEL 33 DEBIT_ACCOUNT 73 DEBIT_ACCOUNT_DESC 81 DEBIT_ACCOUNT_PIVOT_LABEL 53 DEPOSIT_DATE 43 DOC_SEQUENCE_NAME 44 DOC_SEQUENCE_VALUE 36 EARNED_DISCOUNT_TAKEN 59 EXCHANGE_DATE 58 EXCHANGE_RATE 60 EXCHANGE_RATE_TYPE 22 FACTOR_DISCOUNT_AMOUNT 1 LEDGER 1 2 LEDGER_CURRENCY 55 MISC_PAYMENT_SOURCE 5 OPERATING_UNIT 21 RECEIPT_AMOUNT 50 RECEIPT_CREATED_BY 49 RECEIPT_CREATION_DATE 20 RECEIPT_CURRENCY 3 19 RECEIPT_DATE 40 RECEIPT_GAIN_LOSS 48 RECEIPT_HISTORY_STATUS 52 RECEIPT_LAST_UPDATED_BY 51 RECEIPT_LAST_UPDATED_DATE 46 RECEIPT_METHOD 18 RECEIPT_NUMBER 6 47 RECEIPT_STATUS 45 RECEIPT_TYPE 56 REFERENCE_TYPE 30 RELATED_CUSTOMER_NUMBER 80 REPORTING_ENTITY 57 TAX_CODE 28 TRX_AMOUNT 27 TRX_CURRENCY 26 TRX_DATE 37 UNEARNED_DISCOUNT_TAKEN ACCOUNT_PIVOT_LABEL ROW 2 ACCOUNT_SEGMENT FILTER 3 ACCTD_AMT_APPLIED_FROM_RECEIPT VALUE 5 SUM ACCTD_AMT_APPLIED_TO_TRX VALUE 6 SUM ACCTD_EARNED_DISCOUNT_TAKEN VALUE 8 SUM ACCTD_UNEARNED_DISCOUNT_TAKEN VALUE 9 SUM AMOUNT_APPLIED_FROM_RECEIPT VALUE 1 SUM AMOUNT_APPLIED_TO_TRX VALUE 2 SUM BALANCING_SEGMENT FILTER 2 BAL_SEG_PIVOT_LABEL ROW 1 BATCH_SOURCE FILTER 7 CUSTOMER_NAME FILTER 5 CUSTOMER_NUMBER FILTER 6 DEBIT_ACCOUNT_PIVOT_LABEL ROW 3 EARNED_DISCOUNT_TAKEN VALUE 3 SUM LEDGER FILTER 1 OPERATING_UNIT FILTER 4 RECEIPT_CURRENCY ROW 4 RECEIPT_GAIN_LOSS VALUE 7 SUM UNEARNED_DISCOUNT_TAKEN VALUE 4 SUM S Site Pivot: Summary by GL Date Pivot: Summary by Balancing Segment, Receipt Currency, GL Date with drilldown to details SYSADMIN 78 ACCOUNT_PIVOT_LABEL 74 ACCOUNT_SEGMENT 75 ACCOUNT_SEGMENT_DESC 38 ACCTD_AMT_APPLIED_FROM_RECEIPT 39 ACCTD_AMT_APPLIED_TO_TRX 41 ACCTD_EARNED_DISCOUNT_TAKEN 24 ACCTD_FACTOR_DISCOUNT_AMOUNT 23 ACCTD_RECEIPT_AMOUNT 29 ACCTD_TRX_AMOUNT 42 ACCTD_UNEARNED_DISCOUNT_TAKEN 34 AMOUNT_APPLIED_FROM_RECEIPT 35 AMOUNT_APPLIED_TO_TRX 54 ANTICIPATED_CLEARING_DATE 61 APPLICATION_NOTES 25 APPLIED_TO_TRX_NUMBER 7 31 APPLY_DATE 32 APPLY_GL_DATE 4 3 BALANCING_SEGMENT 2 4 BALANCING_SEGMENT_DESC 77 BAL_SEG_PIVOT_LABEL 71 BANK_ACCOUNT_CURRENCY 72 BANK_ACCOUNT_DESCRIPTION 68 BANK_ACCOUNT_NAME 69 BANK_ACCOUNT_NAME_ALT 70 BANK_ACCOUNT_NUMBER 65 BANK_BRANCH_NAME 66 BANK_BRANCH_NAME_ALT 62 BANK_NAME 63 BANK_NAME_ALT 64 BANK_NUMBER 16 BATCH_NAME 17 BATCH_SOURCE 67 BRANCH_NUMBER 13 COLLECTOR 14 COLLECTOR_ACCOUNT 15 COLLECTOR_SITE 10 CUSTOMER_ADDRESS 11 CUSTOMER_COUNTRY 9 CUSTOMER_LOCATION 6 CUSTOMER_NAME 5 8 CUSTOMER_NAME_ALT 7 CUSTOMER_NUMBER 12 CUSTOMER_TAX_NUMBER 79 CUST_NAME_PIVOT_LABEL 80 CUST_NUMBER_PIVOT_LABEL 33 DEBIT_ACCOUNT 73 DEBIT_ACCOUNT_DESC 76 DEBIT_ACCOUNT_PIVOT_LABEL 53 DEPOSIT_DATE 43 DOC_SEQUENCE_NAME 44 DOC_SEQUENCE_VALUE 36 EARNED_DISCOUNT_TAKEN 59 EXCHANGE_DATE 58 EXCHANGE_RATE 60 EXCHANGE_RATE_TYPE 22 FACTOR_DISCOUNT_AMOUNT 1 LEDGER 1 2 LEDGER_CURRENCY 55 MISC_PAYMENT_SOURCE 5 OPERATING_UNIT 21 RECEIPT_AMOUNT 50 RECEIPT_CREATED_BY 49 RECEIPT_CREATION_DATE 20 RECEIPT_CURRENCY 3 19 RECEIPT_DATE 40 RECEIPT_GAIN_LOSS 48 RECEIPT_HISTORY_STATUS 52 RECEIPT_LAST_UPDATED_BY 51 RECEIPT_LAST_UPDATED_DATE 46 RECEIPT_METHOD 18 RECEIPT_NUMBER 6 47 RECEIPT_STATUS 45 RECEIPT_TYPE 56 REFERENCE_TYPE 30 RELATED_CUSTOMER_NUMBER 81 REPORTING_ENTITY 57 TAX_CODE 28 TRX_AMOUNT 27 TRX_CURRENCY 26 TRX_DATE 37 UNEARNED_DISCOUNT_TAKEN ACCOUNT_SEGMENT FILTER 3 ACCTD_AMT_APPLIED_FROM_RECEIPT VALUE 5 SUM ACCTD_AMT_APPLIED_TO_TRX VALUE 6 SUM ACCTD_EARNED_DISCOUNT_TAKEN VALUE 8 SUM ACCTD_UNEARNED_DISCOUNT_TAKEN VALUE 9 SUM AMOUNT_APPLIED_FROM_RECEIPT VALUE 1 SUM AMOUNT_APPLIED_TO_TRX VALUE 2 SUM APPLY_GL_DATE ROW 3 BALANCING_SEGMENT FILTER 2 BAL_SEG_PIVOT_LABEL ROW 1 BATCH_SOURCE FILTER 7 CUSTOMER_NAME FILTER 5 CUSTOMER_NUMBER FILTER 6 EARNED_DISCOUNT_TAKEN VALUE 3 SUM LEDGER FILTER 1 OPERATING_UNIT FILTER 4 RECEIPT_CURRENCY ROW 2 RECEIPT_GAIN_LOSS VALUE 7 SUM UNEARNED_DISCOUNT_TAKEN VALUE 4 SUM S Site SYSADMIN Pivot: Summary by GL Date DEVELOPER Pivot: Summary by Customer Name ENGINATICS Pivot: Summary by Customer Name Default: Detail