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 8E2FF36EDEAF79D2E0530100007F1FF2 AR Period 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 asp.set_of_books_id from ar_system_parameters asp where (:$flex$.ledger is null or asp.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and (:$flex$.operating_unit is null or asp.set_of_books_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and rownum=1 ) and gps.start_date<=sysdate+400 and gps.application_id=222 order by gps.start_date desc AR فترة AR السابقة لدفتر الأستاذ الحالي لتسجيل الدخول D Vergangene AR-Periode des aktuellen Login-Ledgers E Periodo AR pasado del libro de registro actual F Période AR passée du registre de connexion actuel I Periodo AR passato del libro mastro del login corrente JA 現在のログイン帳の過去のAR期間 KO 현재 로그인 원장의 과거 AR 기간 PTB Período AR passado do registro de login atual RU Прошедший период АР текущей регистрационной книги S Senaste AR-perioden för den aktuella inloggningsboken TR Mevcut giriş defterinin geçmiş AR dönemi US Past AR period of the current login ledger ZHS 当前登录分类账的过去AR期 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 B5F889C2A61D0296E0530100007FC863 select haouv.name operating_unit, arm.name receipt_method, acra.receipt_number, acra.receipt_date, acrha1.gl_date, acra.currency_code currency, acra.amount, acrha2.acctd_amount functional_amount, xxen_util.meaning(acrha2.status,'RECEIPT_CREATION_STATUS',222) state, 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 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, hca.account_number, hp.party_name, hcsua.location location, hz_format_pub.format_address (hps.location_id,null,null,' , ') address, hp.jgzz_fiscal_code taxpayer_id, acra.misc_payment_source paid_by, arta.name activity, adsa.distribution_set_name distribution_set, acra.customer_receipt_reference reference, acra.comments, replace(initcap(arm.payment_type_code),'_',' ') payment_method, abac.bank_account_num instrument_number, acra.payment_server_order_num pson, abbc.bank_name bank_name, abbc.bank_branch_name bank_branch, abbr.bank_name remit_bank_name, abbr.bank_branch_name remit_bank_branch, abar.bank_account_num remit_bank_account from ar_cash_receipts_all acra, hr_all_organization_units_vl haouv, ar_cash_receipt_history_all acrha1, ar_cash_receipt_history_all acrha2, ar_receipt_methods arm, ap_bank_accounts_all abac, ap_bank_branches abbc, ar_receivables_trx_all arta, hz_cust_accounts hca, hz_parties hp, hz_cust_site_uses_all hcsua, hz_cust_acct_sites_all hcasa, hz_party_sites hps, ap_bank_accounts_all abar, ap_bank_branches abbr, ar_distribution_sets_all adsa where 1=1 and acra.type='MISC' and acra.org_id=haouv.organization_id and acra.receipt_method_id=arm.receipt_method_id(+) and acra.customer_bank_account_id = abac.bank_account_id (+) and abac.bank_branch_id = abbc.bank_branch_id (+) and acra.cash_receipt_id=acrha1.cash_receipt_id(+) and acra.cash_receipt_id=acrha2.cash_receipt_id(+) and acrha1.first_posted_record_flag(+)='Y' and acrha2.current_record_flag(+)='Y' and acra.receivables_trx_id=arta.receivables_trx_id(+) and acra.org_id=arta.org_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 acra.remittance_bank_account_id = abar.bank_account_id (+) and abar.bank_branch_id = abbr.bank_branch_id (+) and acra.distribution_set_id=adsa.distribution_set_id(+) order by haouv.name, acra.receipt_date desc, acra.receipt_number desc Y 49A8B1A8036F08ACE0530100007FEB91 US AR Miscellaneous Receipts 11i Receivables miscellaneous receipts Enginatics 1=1 1 10 1=1 haouv.name=:operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) Y F Unité d'exploitation US Operating Unit 2 20 1=1 arm.name=:receipt_method LOV custom Y select arm.name value, replace(initcap(arm.payment_type_code),'_',' ') description from ar_receipt_methods arm order by arm.name F Méthode de réception Contexte de la ligne d'interface pour les rapports d'EI US Receipt Method Interface line context for AR reports 3 30 1=1 acra.receipt_date>=(select gps.start_date from gl_period_statuses gps where gps.period_name=:period_name and gps.set_of_books_id=(select hou.set_of_books_id from hr_operating_units hou where hou.organization_id=fnd_global.org_id) and gps.application_id=222) and acra.receipt_date<(select gps.end_date+1 from gl_period_statuses gps where gps.period_name=:period_name and gps.set_of_books_id=(select hou.set_of_books_id from hr_operating_units hou where hou.organization_id=fnd_global.org_id) and gps.application_id=222) LOV AR Period 8E2FF36EDEAF79D2E0530100007F1FF2 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 asp.set_of_books_id from ar_system_parameters asp where (:$flex$.ledger is null or asp.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and (:$flex$.operating_unit is null or asp.set_of_books_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and rownum=1 ) and gps.start_date<=sysdate+400 and gps.application_id=222 order by gps.start_date desc F Période US Period 4 40 1=1 acra.receipt_date>=:trx_date_from Date F Date de réception du US Receipt Date From 5 50 1=1 acra.receipt_date<:trx_date_to+1 Date last_day(:$flex$.receipt_date_from) F Date de réception au US Receipt Date To 6 60 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 État US State 7 70 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 8 80 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 US Account Number 9 90 1=1 acra.receipt_number=:receipt_number Char F Numéro du reçu US Receipt Number :$flex$.operating_unit Operating Unit Account Number :$flex$.operating_unit Operating Unit Customer Name :$flex$.operating_unit Operating Unit Period :$flex$.receipt_date_from Receipt Date From Y Receipt Date To