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 8E2FF36EDE9A79D2E0530100007F1FF2 AR Transaction Type Y select rctta.name value, nvl(flvv.meaning,rctta.type)||': '||haouv.name description from hr_all_organization_units_vl haouv, ra_cust_trx_types_all rctta, fnd_lookup_values_vl flvv where (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') and haouv.organization_id=rctta.org_id and rctta.type=flvv.lookup_code(+) and flvv.lookup_type(+)='INV/CM/ADJ' and flvv.view_application_id(+)=222 and flvv.security_group_id(+)=0 order by rctta.name, haouv.name US 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）限制的操作单元。 B16963CD8D7755B1E0530100007F44CB JTF Salesperson (active) Y select distinct jrrev.resource_name value, jrrev.source_city||nvl2(jrrev.source_country,', '||jrrev.source_country,null) description from jtf_rs_salesreps jrs, jtf_rs_resource_extns_vl jrrev where (:$flex$.operating_unit is null or jrs.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and sysdate between jrs.start_date_active and nvl(jrs.end_date_active,sysdate) and sysdate between jrrev.start_date_active and nvl(jrrev.end_date_active,sysdate) and jrs.resource_id=jrrev.resource_id order by jrrev.resource_name US 3A3828F2F1C7AEFCE06362FB0905A1D1 select haouv.name operating_unit, apsa.invoice_currency_code currency, hp.party_name customer_name, hca.account_number, apsa.trx_number invoice_number, xxen_util.meaning(apsa.class,'INV/CM/ADJ',222) class, rctta.name invoice_type, rcta.purchase_order, apsa.trx_date invoice_date, apsa.due_date, 'test' comment, apsa.amount_due_original invoice_amount, apsa.tax_original tax_amount, apsa.balance_due, apsa.days_past_due, ac.name collector, rs.name salesperson, xxen_util.user_name(rcta.created_by) created_by, xxen_util.client_time(rcta.creation_date) creation_date, xxen_util.user_name(rcta.last_updated_by) last_updated_by, xxen_util.client_time(rcta.last_update_date) last_update_date from hr_all_organization_units_vl haouv, (select arpt_sql_func_util.get_balance_due_as_of_date(apsa.payment_schedule_id,:p_as_of_date,apsa.class) balance_due, :p_as_of_date-trunc(apsa.due_date) days_past_due, apsa.* from ar_payment_schedules_all apsa where apsa.actual_date_closed>:p_as_of_date and apsa.due_date<=:p_as_of_date) apsa, ra_customer_trx_all rcta, ra_cust_trx_types_all rctta, hz_cust_accounts hca, hz_parties hp, ra_salesreps rs, hz_customer_profiles hcp, hz_customer_profiles hcp1, ar_collectors ac where 1=1 and apsa.balance_due<>0 and haouv.organization_id=apsa.org_id and apsa.customer_trx_id=rcta.customer_trx_id and rcta.cust_trx_type_id=rctta.cust_trx_type_id and rcta.org_id=rctta.org_id and rcta.bill_to_customer_id=hca.cust_account_id and hca.party_id=hp.party_id and rcta.primary_salesrep_id=rs.salesrep_id(+) and rcta.org_id=rs.org_id(+) and hca.cust_account_id=hcp.cust_account_id and hcp.site_use_id is null and apsa.customer_site_use_id=hcp1.site_use_id(+) and nvl(hcp1.collector_id, hcp.collector_id)=ac.collector_id order by decode(:p_order_by,'Salesperson',rs.name,'Customer',hp.party_name), decode(:p_order_by,'Balance Due',apsa.balance_due,0) CRF#bdfdjhv Y AR 67ACE63282E32538E05392D1825EC634 US AG: AR Past Due Invoice Detail past due AR invoice report with invoice number, days past due, amount past due and currency code 1=1 :p_as_of_date :p_order_by 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 :p_order_by LOV Oracle AR_SRS_ARXPDI_SORT_BY Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='SORT_BY_ARXPDI' order by upper(meaning) Customer Y F Commander par US Order By 3 30 :p_as_of_date Date sysdate Y F En date du US As of Date 4 40 1=1 apsa.days_past_due>=:p_past_days_due_low Number F Jours de retard Faible US Days Late Low 5 50 1=1 apsa.days_past_due<=:p_past_days_due_high Number F Jours de retard Haut US Days Late High 6 60 1=1 apsa.balance_due>=:p_amount_low Number F Solde dû faible US Balance Due Low 7 70 1=1 apsa.balance_due<=:p_amount_high Number F Solde dû élevé US Balance Due High 8 80 1=1 ac.name=:p_collector LOV Oracle AR_COLLECTOR_NAME Y select name id, name value, null description from ar_collectors where status!='I' order by name,collector_id F Collecteur US Collector 9 90 1=1 hp.party_name=: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 10 100 1=1 hca.account_number=:customer_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 client US Customer Number 11 110 1=1 rctta.name=:invoice_type LOV AR Transaction Type 8E2FF36EDE9A79D2E0530100007F1FF2 Y select rctta.name value, nvl(flvv.meaning,rctta.type)||': '||haouv.name description from hr_all_organization_units_vl haouv, ra_cust_trx_types_all rctta, fnd_lookup_values_vl flvv where (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') and haouv.organization_id=rctta.org_id and rctta.type=flvv.lookup_code(+) and flvv.lookup_type(+)='INV/CM/ADJ' and flvv.view_application_id(+)=222 and flvv.security_group_id(+)=0 order by rctta.name, haouv.name US Type Low 12 120 1=1 rs.name=:salesrep LOV JTF Salesperson (active) B16963CD8D7755B1E0530100007F44CB Y select distinct jrrev.resource_name value, jrrev.source_city||nvl2(jrrev.source_country,', '||jrrev.source_country,null) description from jtf_rs_salesreps jrs, jtf_rs_resource_extns_vl jrrev where (:$flex$.operating_unit is null or jrs.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and sysdate between jrs.start_date_active and nvl(jrs.end_date_active,sysdate) and sysdate between jrrev.start_date_active and nvl(jrrev.end_date_active,sysdate) and jrs.resource_id=jrrev.resource_id order by jrrev.resource_name F Vendeur/Agent Faible US Salesperson/Agent Low :$flex$.operating_unit Operating Unit Customer Name :$flex$.operating_unit Operating Unit Customer Number :$flex$.operating_unit Operating Unit Salesperson/Agent Low :$flex$.operating_unit Operating Unit Type Low