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 49A8B1A8036F08ACE0530100007FEB91 select misc_receipts.* from ( select gl.name ledger, haou.name operating_unit, decode(nvl(aba1.batch_source_id,-1) ,-1, null ,absa.name ) batch_source, decode(acrha2.status , 'REVERSED', aba1.name , aba1.name) batch_name, acra.receipt_number, xxen_util.meaning(acra.type,'PAYMENT_CATEGORY_TYPE',222) receipt_type, arm.name receipt_method, xxen_util.meaning(acra.status,'CHECK_STATUS',222) receipt_status, xxen_util.meaning(acrha2.status,'RECEIPT_CREATION_STATUS',222) receipt_history_status, acrha1.gl_date, acra.receipt_date, acra.deposit_date, acra.anticipated_clearing_date, acra.currency_code currency, case when 1 = row_number() over (partition by acra.cash_receipt_id,acrha2.cash_receipt_history_id order by amcda.misc_cash_distribution_id) then decode(acrha2.status,'REVERSED',acrha2.amount*-1,acrha2.amount) end amount, case when 1 = row_number() over (partition by acra.cash_receipt_id,acrha2.cash_receipt_history_id order by amcda.misc_cash_distribution_id) then decode(acrha2.status,'REVERSED',acrha2.acctd_amount*-1,acrha2.acctd_amount) end accounted_amount, case when 1 = row_number() over (partition by acra.cash_receipt_id,acrha2.cash_receipt_history_id order by amcda.misc_cash_distribution_id) then decode(acrha2.status,'REVERSED',acrha2.factor_discount_amount*-1,acrha2.factor_discount_amount) end discount_amount, case when 1 = row_number() over (partition by acra.cash_receipt_id,acrha2.cash_receipt_history_id order by amcda.misc_cash_distribution_id) then decode(acrha2.status,'REVERSED',acrha2.acctd_factor_discount_amount*-1,acrha2.acctd_factor_discount_amount) end accounted_discount_amount, --gcck1.concatenated_segments accounting_flexfield, &l_dist_select acra.exchange_rate, acra.exchange_date, acra.exchange_rate_type exchange_type, acra.misc_payment_source payment_source, arta.name activity, adsa.distribution_set_name distribution_set, xxen_util.meaning('APP','CHECK_STATUS',222) state, xxen_util.meaning(acrha2.status,'RECEIPT_CREATION_STATUS',222) status, decode(ada.source_type ,'TAX', avta.tax_code , NULL) tax_code, fds.name document_sequence_name, acra.doc_sequence_value document_sequence, xxen_util.meaning(acra.reference_type,'CB_REFERENCE_TYPE',222) reference_type, case when acra.reference_type='REMITTANCE' then (select ab.name from ar_batches_all ab where acra.reference_id=ab.batch_id) when acra.reference_type='RECEIPT' then (select acra.receipt_number from ar_cash_receipts_all acra0 where acra.reference_id=acra0.cash_receipt_id) when acra.reference_type='PAYMENT_BATCH' then (select aisca.checkrun_name from ap_inv_selection_criteria_all aisca where acra.reference_id=aisca.checkrun_id) when acra.reference_type='PAYMENT' then (select to_char(aca.check_number) from ap_checks_all aca where acra.reference_id=aca.check_id) when acra.reference_type='CREDIT_MEMO' then (select rcta.trx_number from ra_customer_trx_all rcta where acra.reference_id=rcta.customer_trx_id) end reference_number, acra.customer_receipt_reference customer_receipt_reference, substrb(hp.party_name,1,240) customer_name, decode(hp.party_type ,'ORGANIZATION',hp.organization_name_phonetic , null ) customer_name_alt, hca.account_number customer_number, hcsua.location customer_location, hz_format_pub.format_address (hps.location_id,null,null,' , ') customer_address, hp.jgzz_fiscal_code customer_tax_number, nvl(ac2.name,ac.name) collector, ac.name collector_account, ac2.name collector_site, ifpct.payment_channel_name payment_method, hp2.party_name bank_name, hp3.party_name bank_branch, decode(ipiua.instrument_type ,'BANKACCOUNT',ieba.masked_bank_account_num ,'CREDITCARD',ic.masked_cc_number ) instrument_number, nvl(ifte.payment_system_order_number ,nvl2(ifte.trxn_extension_id ,substr(iby_fndcpt_trxn_pub.get_tangible_id(fa.application_short_name,ifte.order_id,ifte.trxn_ref_number1,ifte.trxn_ref_number2),1,80) ,null)) pson, cbbv.bank_name remit_bank_name, cbbv.bank_branch_name remit_bank_branch_name, cbbv.bank_name_alt remit_bank_name_alt, cbbv.bank_branch_name_alt remit_bank_branch_name_alt, cbbv.bank_number remit_bank_number, cbbv.branch_number remit_bank_branch_number, cba.bank_account_name remit_bank_account_name, cba.bank_account_name_alt remit_bank_account_name_alt, case when cba.bank_account_id is not null then ce_bank_and_account_util.get_masked_bank_acct_num(cba.bank_account_id) end remit_bank_account_number, cba.currency_code remit_bank_account_currency, acra.comments receipt_comments &l_gcck2_segments from hr_all_organization_units haou, gl_ledgers gl, ar_cash_receipts_all acra, ar_cash_receipt_history_all acrha1, ar_cash_receipt_history_all acrha2, ar_batches_all aba1, ar_batches_all aba2, ar_batch_sources_all absa, ar_receipt_methods arm, ar_distribution_sets_all adsa, ar_receivables_trx_all arta, -- distribution info ar_misc_cash_distributions_all amcda, ar_distributions_all ada, gl_code_combinations_kfv gcck1, gl_code_combinations_kfv gcck2, -- customer info hz_cust_accounts hca, hz_parties hp, hz_cust_site_uses_all hcsua, hz_cust_acct_sites_all hcasa, hz_party_sites hps, hz_customer_profiles hcp, ar_collectors ac, hz_customer_profiles hcp2, ar_collectors ac2, -- remit bank info ce_bank_accounts cba, ce_bank_acct_uses_all cbaua, ce_bank_branches_v cbbv, ar_vat_tax_all avta, fnd_document_sequences fds, -- payment info iby_fndcpt_pmt_chnnls_tl ifpct, iby_fndcpt_tx_extensions ifte, fnd_application fa, iby_pmt_instr_uses_all ipiua, iby_ext_bank_accounts ieba, iby_creditcard ic, hz_parties hp2, hz_parties hp3 where acra.type = 'MISC' 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 acrha1.first_posted_record_flag = 'Y' and acrha1.batch_id = aba1.batch_id(+) and nvl(aba1.batch_source_id,-1) = absa.batch_source_id(+) and nvl(aba1.org_id, -1) = absa.org_id(+) and acra.cash_receipt_id = acrha2.cash_receipt_id and acrha2.batch_id = aba2.batch_id(+) and ( ( acrha2.current_record_flag = 'Y' and acrha2.status = 'REVERSED' ) or (acrha2.cash_receipt_history_id in (select nvl(acrha4.cash_receipt_history_id, acrha3.cash_receipt_history_id) from ar_cash_receipt_history_all acrha3, ar_cash_receipt_history_all acrha4 where acrha3.cash_receipt_id = acrha2.cash_receipt_id and acrha3.first_posted_record_flag = 'Y' and acrha4.cash_receipt_id(+) = acrha3.cash_receipt_id and acrha4.current_record_flag(+) = 'Y' and acrha4.status(+) <> 'REVERSED' and acrha3.status <> 'REVERSED' and 2=2 ) ) ) and acrha2.account_code_combination_id = gcck1.code_combination_id (+) and acra.receipt_method_id = arm.receipt_method_id and acra.receivables_trx_id = arta.receivables_trx_id (+) and acra.org_id = arta.org_id (+) and acra.distribution_set_id = adsa.distribution_set_id (+) and acra.doc_sequence_id = fds.doc_sequence_id(+) and acra.vat_tax_id = avta.vat_tax_id(+) -- distribution info and decode(:p_report_detail,'Receipt',-999,acra.cash_receipt_id) = amcda.cash_receipt_id (+) and amcda.misc_cash_distribution_id = ada.source_id(+) and ada.source_table(+) = 'MCD' and ada.code_combination_id = gcck2.code_combination_id (+) -- remit bank info and acra.remit_bank_acct_use_id = cbaua.bank_acct_use_id and cbaua.bank_account_id = cba.bank_account_id and cba.bank_branch_id = cbbv.branch_party_id -- customer info 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 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 (+) -- customer payment info and acra.payment_trxn_extension_id = ifte.trxn_extension_id (+) and ifte.origin_application_id = fa.application_id(+) and ifte.instr_assignment_id = ipiua.instrument_payment_use_id(+) and decode(ipiua.instrument_type ,'BANKACCOUNT',ipiua.instrument_id) = ieba.ext_bank_account_id(+) and decode(ipiua.instrument_type ,'CREDITCARD',ipiua.instrument_id) = ic.instrid(+) and ieba.bank_id = hp2.party_id(+) and ieba.branch_id = hp3.party_id(+) and arm.payment_channel_code = ifpct.payment_channel_code(+) and ifpct.language (+) = userenv('lang') -- and :reporting_level in (1000,3000) and :reporting_context is not null and :p_coa is not null and 1=1 order by acrha1.gl_date ,acra.receipt_date ,acra.receipt_number ,acra.cash_receipt_id ,acrha2.cash_receipt_history_id ,amcda.misc_cash_distribution_id ) misc_receipts where 3=3 Y #,##0.00;[Red]-#,##0.00 AR AR Miscellaneous Receipts Imported from Concurrent Program Application: المقبوضات Source: تسجيل الإيصالات المتنوعة Short Name: ARRXMTRG D AR Miscellaneous Receipts Imported from Concurrent Program Application: Debitoren Source: Sonstige Zahlungseingänge - Liste Short Name: ARRXMTRG E AR Miscellaneous Receipts Imported from Concurrent Program Application: Receivables Source: Registro de Otros Cobros Short Name: ARRXMTRG F AR Miscellaneous Receipts Imported from Concurrent Program Application: Receivables Source: Registre des encaissements divers Short Name: ARRXMTRG I AR Miscellaneous Receipts Imported from Concurrent Program Application: Receivables Source: Registro incassi vari Short Name: ARRXMTRG JA AR Miscellaneous Receipts Imported from Concurrent Program Application: Receivables Source: その他入金台帳 Short Name: ARRXMTRG KO AR Miscellaneous Receipts Imported from Concurrent Program Application: Receivables Source: 기타 수금 등록 Short Name: ARRXMTRG PTB AR Miscellaneous Receipts Imported from Concurrent Program Application: Receivables Source: Registro de Recebimentos Diversos Short Name: ARRXMTRG RU AR Miscellaneous Receipts Imported from Concurrent Program Application: Дебиторы Source: Реестр прочих поступлений Short Name: ARRXMTRG S AR Miscellaneous Receipts Imported from Concurrent Program Application: Receivables Source: Register över övriga inbetalningar Short Name: ARRXMTRG TR AR Miscellaneous Receipts Imported from Concurrent Program Application: Alacaklar Muhasebesi Source: Muhtelif Alacaklar Kaydı Short Name: ARRXMTRG US AR Miscellaneous Receipts Receivables Miscellaneous Receipts Imported from Concurrent Program Application: Receivables Source: Miscellaneous Receipts Register Short Name: ARRXMTRG ZHS AR Miscellaneous Receipts Imported from Concurrent Program Application: 应收帐款 Source: 杂项收款登记表 Short Name: ARRXMTRG Concurrent Program Enginatics R12 only &l_dist_select &l_gcck2_segments 1=1 2=2 3=3 :p_coa :p_report_detail :reporting_context :reporting_level 1 -10 :p_coa Number select gl.chart_of_accounts_id from gl_ledgers gl where (:$flex$.reporting_level = 1000 and gl.ledger_id = :$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.organization_id = :$flex$.reporting_context)) F Plan de comptes Id US Chart of Accounts Id 2 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 报告层 报告层 3 1=1 acra.set_of_books_id = :reporting_context 1000 F Niveau de rapport US Reporting Level 4 1=1 acra.org_id = :reporting_context 3000 F Niveau de rapport US Reporting Level 5 20 :reporting_context LOV Oracle FND_MO_REPORTING_ENTITY Y select entity_id id, entity_name value, null description from fnd_mo_reporting_entities_v where reporting_level=:$flex$.fnd_mo_reporting_level order by value,description SELECT entity_id FROM FND_MO_REPORTING_ENTITIES_V WHERE reporting_level = :$flex$.fnd_mo_reporting_level and rownum=1 Y 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 报告上下文 报告上下文 6 30 :p_report_detail LOV custom Y select value, description from ( select 'Receipt' value,'Receipt Level' description from dual union select 'Receipt Distribution','Receipt Distribution Level' from dual ) order by value Receipt F Détail du rapport US Reporting Detail 7 &l_dist_select select null from dual Receipt US Reporting Detail 8 &l_dist_select gcck2.concatenated_segments distribution_account, decode(ada.source_type ,'TAX',null ,amcda.percent ) distribution_percent, decode(sign(amcda.amount) , 1, ada.amount_cr ,-1, sign(amcda.amount) * ada.amount_dr , 0 ) distribution_amount, decode(sign(amcda.acctd_amount) , 1,ada.acctd_amount_cr ,-1, sign(amcda.acctd_amount) * ada.acctd_amount_dr , 0 ) accounted_distribution_amount, Receipt Distribution F Détail du rapport US Reporting Detail 9 &l_gcck2_segments select null from dual Receipt F Détail du rapport US Reporting Detail 10 &l_gcck2_segments select distinct decode(fifsv.segment_num, min(fifsv.segment_num) over (partition by fifsv.id_flex_num),', ',' ')|| 'gcck2.'||lower(fifsv.application_column_name)||' "'||substrb(fifsv.form_left_prompt_,1,xxen_report.max_column_length)||'",'||chr(10)|| 'xxen_util.segment_description(gcck2.'||lower(fifsv.application_column_name)||', '''||fifsv.application_column_name||''', gcck2.chart_of_accounts_id'|| ( select ', gcck2.'||lower(fifs.application_column_name) from fnd_id_flex_segments fifs where fifsv.application_id=fifs.application_id and fifsv.id_flex_code=fifs.id_flex_code and fifsv.id_flex_num=fifs.id_flex_num and fifsv.enabled_flag=fifs.enabled_flag and fifs.flex_value_set_id=(select ffvs.parent_flex_value_set_id from fnd_flex_value_sets ffvs where fifsv.flex_value_set_id=ffvs.flex_value_set_id) )||') "'||substrb(fifsv.form_left_prompt_,1,xxen_report.max_column_length-5)||' desc"'||decode(fifsv.segment_num, max(fifsv.segment_num) over (partition by fifsv.id_flex_num),' ',', ') text, min(fifsv.id_flex_num) over (partition by fifsv.application_column_name, fifsv.form_left_prompt) min_id_flex_num, min(fifsv.segment_num) over (partition by fifsv.application_column_name, fifsv.form_left_prompt) min_segment_num from (select xxen_util.init_cap(fifsv.form_left_prompt) form_left_prompt_, fifsv.* from fnd_id_flex_segments_vl fifsv) fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num=:p_coa order by min_id_flex_num, min_segment_num Receipt Distribution F Détail du rapport US Reporting Detail 11 3=3 misc_receipts.amount is not null Receipt F Détail du rapport US Reporting Detail 12 40 1=1 select 'gcck2.' || fifsgv.application_column_name || ' >= ''' || :p_bal_segment_low || '''' from fnd_segment_attribute_values fsav, fnd_id_flex_segments_vl fifsgv where fsav.application_id = 101 and fsav.id_flex_code = 'GL#' and fsav.segment_attribute_type = 'GL_BALANCING' and fsav.id_flex_num = :p_coa and fsav.attribute_value = 'Y' and fifsgv.application_id=fsav.application_id and fifsgv.id_flex_code=fsav.id_flex_code and fifsgv.id_flex_num=fsav.id_flex_num and fifsgv.application_column_name = fsav.application_column_name 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 公司段下限 公司段下限 13 50 1=1 select 'gcck2.' || fifsgv.application_column_name || ' <= ''' || :p_bal_segment_high || '''' from fnd_segment_attribute_values fsav, fnd_id_flex_segments_vl fifsgv where fsav.application_id = 101 and fsav.id_flex_code = 'GL#' and fsav.segment_attribute_type = 'GL_BALANCING' and fsav.id_flex_num = :p_coa and fsav.attribute_value = 'Y' and fifsgv.application_id=fsav.application_id and fifsgv.id_flex_code=fsav.id_flex_code and fifsgv.id_flex_num=fsav.id_flex_num and fifsgv.application_column_name = fsav.application_column_name 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 公司段上限 公司段上限 14 60 1=1 select 'acrha2.gl_date >= to_date(''' || to_char(gps.start_date,'YYYY/MM/DD') || ''',''YYYY/MM/DD'') and acrha2.gl_date < to_date(''' || to_char(gps.end_date+1,'YYYY/MM/DD') || ''',''YYYY/MM/DD'') and ' || 'amcda.gl_date >= to_date(''' || to_char(gps.start_date,'YYYY/MM/DD') || ''',''YYYY/MM/DD'') and amcda.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.ledger_id = :reporting_context) or (:reporting_level = 3000 and gl.ledger_id = (select hou.set_of_books_id from hr_operating_units hou where hou.organization_id = :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.ledger_id = :$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.organization_id = :$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 15 2=2 select 'acrha3.gl_date >= to_date(''' || to_char(gps.start_date,'YYYY/MM/DD') || ''',''YYYY/MM/DD'') and acrha3.gl_date < to_date(''' || to_char(gps.end_date+1,'YYYY/MM/DD') || ''',''YYYY/MM/DD'') and ' || 'acrha4.gl_date (+) >= to_date(''' || to_char(gps.start_date,'YYYY/MM/DD') || ''',''YYYY/MM/DD'') and acrha4.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.ledger_id = :reporting_context) or (:reporting_level = 3000 and gl.ledger_id = (select hou.set_of_books_id from hr_operating_units hou where hou.organization_id = :reporting_context)) ) and gps.application_id=222 F Période comptable US Accounting Period 16 70 1=1 acrha2.gl_date>=:p_gl_date_from and amcda.gl_date>=:p_gl_date_from Date AR تاريخ أ/ع من تاريخ أ/ع من D Von Buchungsdatum Von Buchungsdatum E De Fecha Contable De Fecha Contable F GL 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 GL Date From GL Date From ZHS GL 日期自 GL 日期自 17 2=2 acrha3.gl_date>=:p_gl_date_from and acrha4.gl_date (+)>=:p_gl_date_from F GL Date du US GL Date From 18 80 1=1 acrha2.gl_date<:p_gl_date_to+1 and amcda.gl_date<:p_gl_date_to+1 Date last_day(:$flex$.Gl_Date_From) AR تاريخ أ/ع إلى تاريخ أ/ع إلى D Bis Buchungsdatum Bis Buchungsdatum E A Fecha Contable A Fecha Contable F GL Date à Date GL - Au I Data GL - A Data GL - A JA GL記帳日:至 GL記帳日:至 KO GL 일자-까지 GL 일자-까지 PTB Data GL - Até Data GL - Até RU Дата ГК по Дата ГК по S Till bokf.datum Till bokf.datum TR GL Bitiş Tarihi GL Bitiş Tarihi US GL Date To GL Date To ZHS GL 日期至 GL 日期至 19 2=2 acrha3.gl_date<:p_gl_date_to+1 and acrha4.gl_date(+)<:p_gl_date_to+1 F GL Date à US GL Date To 20 90 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 输入币种 输入币种 21 100 1=1 upper(hp.party_name) like upper(: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 22 110 1=1 hca.account_number=: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 23 120 1=1 arm.name=: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 130 1=1 acrha2.status=xxen_util.lookup_code(:state,'RECEIPT_CREATION_STATUS',222) LOV custom Y select flv.meaning value, flv.description from fnd_lookup_values flv where flv.lookup_type='RECEIPT_CREATION_STATUS' and flv.view_application_id=222 and flv.language=userenv('lang') and flv.security_group_id=0 order by flv.meaning F Statut de réception US Receipt Status 25 140 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 150 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 160 1=1 acra.receipt_date>=:p_receipt_date_from Date F Date de réception du US Receipt Date From 28 170 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 180 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 190 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 200 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 收款编号下限 收款编号下限 32 210 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 接收编号上限 接收编号上限 33 220 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.ledger_id = :$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.organization_id = :$flex$.reporting_context)) ) order by fds.name F Nom de la séquence du document US Document Sequence Name 34 230 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 35 240 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 :$flex$.Balancing_Segment_Low Balancing Segment Low Balancing Segment High :$flex$.Batch_Name_Low Batch Name Low Batch Name High :$flex$.Deposit_Date_From Deposit Date From Y Deposit Date To :$flex$.Document_Number_Low Document Number Low Document Number High :$flex$.Gl_Date_From GL Date From Y GL Date To :$flex$.Receipt_Date_From Receipt Date From Y Receipt Date To :$flex$.Receipt_Number_Low Receipt Number Low Receipt Number High :$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$.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$.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_level Reporting Level Accounting Period :$flex$.reporting_level Reporting Level Chart of Accounts Id :$flex$.reporting_level Reporting Level Document Sequence Name