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 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）限制的操作单元。 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 61AD1DAE484E4EC1A60F63B3FE5FFD54Y select hp.party_name customer_name, hca.account_number, haouv.name operating_unit, hcsua.location site_location, hps.party_site_number site_number, hz_format_pub.format_address(hps.location_id,null,null,' , ') site_address, ftv.territory_short_name site_country, xxen_util.meaning(hcsua.site_use_code,'SITE_USE_CODE',222) site_use, hcpc.name profile_class, hcpc.description profile_class_description, xxen_util.meaning(hcp.status,'CODE_STATUS',222) profile_status, rtv.name payment_terms, xxen_util.yes(hcp.override_terms) override_terms, xxen_util.yes(hcp.discount_terms) discount_allowed, hcp.discount_grace_days, hcp.payment_grace_days receipt_grace_days, ac.name collector, xxen_util.meaning(hcp.credit_rating,'CREDIT_RATING',222) credit_rating, xxen_util.meaning(hcp.risk_code,'RISK_CODE',222) risk_code, xxen_util.yes(hcp.credit_hold) credit_hold, xxen_util.yes(hcp.credit_checking) credit_check, hcp.tolerance, hcp.percent_collectable, xxen_util.meaning(hcp.account_status,'ACCOUNT_STATUS',222) account_status, xxen_util.yes(hcp.send_statements) send_statements, ascl.name statement_cycle, xxen_util.yes(hcp.credit_balance_statements) send_credit_balance_statements, xxen_util.yes(hcp.interest_charges) charge_interest, hcp.interest_period_days, xxen_util.yes(hcp.charge_on_finance_charge_flag) compound_interest, xxen_util.yes(hcp.dunning_letters) dunning_letters, adls.name dunning_letter_set, aah.hierarchy_name autocash_rule_set, xxen_util.yes(hcp.auto_rec_incl_disputed_flag) include_disputed_items, xxen_util.meaning(hcp.tax_printing_option,'TAX_PRINTING_OPTION',222) tax_printing, rgr.name grouping_rule, xxen_util.yes(hcp.cons_inv_flag) balance_forward_billing, xxen_util.meaning(decode(hcp.cons_inv_flag,'Y',nvl(hcp.cons_inv_type,'SUMMARY'),hcp.cons_inv_type),'HZ_CONS_INV_TYPE',222) balance_forward_bill_type, hcpa.currency_code, hcpa.interest_rate, hcpa.max_interest_charge, hcpa.min_fc_balance_amount min_finance_charge_balance, hcpa.min_fc_invoice_amount min_finance_charge_invoice, hcpa.min_statement_amount, hcpa.auto_rec_min_receipt_amount min_receipt_amount, hcpa.min_dunning_amount, hcpa.min_dunning_invoice_amount, hcpa.overall_credit_limit credit_limit, hcpa.trx_credit_limit order_credit_limit from hz_cust_accounts hca, hz_parties hp, hz_customer_profiles hcp, hz_cust_profile_classes hcpc, ar_collectors ac, ra_terms_vl rtv, ar_statement_cycles ascl, ar_dunning_letter_sets adls, ar_autocash_hierarchies aah, ra_grouping_rules rgr, hz_cust_site_uses_all hcsua, hz_cust_acct_sites_all hcasa, hz_party_sites hps, hr_all_organization_units_vl haouv, fnd_territories_vl ftv, hz_locations hl, hz_cust_profile_amts hcpa where 1=1 and hca.cust_account_id=hcp.cust_account_id and hca.party_id=hp.party_id and hcp.profile_class_id=hcpc.profile_class_id(+) and hcp.collector_id=ac.collector_id and hcp.standard_terms=rtv.term_id(+) and hcp.statement_cycle_id=ascl.statement_cycle_id(+) and hcp.dunning_letter_set_id=adls.dunning_letter_set_id(+) and hcp.autocash_hierarchy_id=aah.autocash_hierarchy_id(+) and hcp.grouping_rule_id=rgr.grouping_rule_id(+) and hcp.site_use_id=hcsua.site_use_id(+) and hcsua.cust_acct_site_id=hcasa.cust_acct_site_id(+) and hcsua.org_id=haouv.organization_id(+) and hcasa.party_site_id=hps.party_site_id(+) and hps.location_id=hl.location_id(+) and hl.country=ftv.territory_code(+) and hcp.cust_account_profile_id=hcpa.cust_account_profile_id(+) and (hcp.site_use_id is null or hcsua.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)) order by hp.party_name, hca.account_number, hcsua.location, hcpa.currency_code AR AR تقرير مراجع العميل (بتنسيق XML) Application: المقبوضات Source: تقرير مراجع العميل (بتنسيق XML) Short Name: ARXCCP_XML DB package: AR_ARXCCP_XMLP_PKG D AR Kunden - Kreditprofile Application: Debitoren Source: Kunden - Kreditprofile (XML) Short Name: ARXCCP_XML DB package: AR_ARXCCP_XMLP_PKG F AR Etat Profils de crédit clients Application: Receivables Source: Etat Profils de crédit clients (XML) Short Name: ARXCCP_XML DB package: AR_ARXCCP_XMLP_PKG US AR Customer Profiles Customer account and site level profile details such as profile class, payment terms, statement, dunning, collector and credit settings, including the profile amount limits per currency. Application: Receivables Source: Customer Profiles Report (XML) Short Name: ARXCCP_XML DB package: AR_ARXCCP_XMLP_PKG ZHS AR 客户配置文件报表 Application: 应收帐款 Source: 客户配置文件报表 (XML) Short Name: ARXCCP_XML DB package: AR_ARXCCP_XMLP_PKG 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 AR رقم العميل من D Von Kundennummer F Numéro de client - De US Operating Unit ZHS 客户编号下限 2 20 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 AR رقم العميل إلى D Bis Kundennummer F Numéro de client - A US Customer Name ZHS 客户编号上限 3 30 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 US Account Number 4 40 1=1 hca.account_number>=:account_number_from Char US Account Number From 5 50 1=1 hca.account_number<=:account_number_to Char :$flex$.Account_Number_From US Account Number To 6 60 1=1 hcpc.name=:profile_class LOV custom Y select hcpc.name value, hcpc.description from hz_cust_profile_classes hcpc order by hcpc.name US Profile Class 7 70 1=1 ac.name=:collector LOV custom Y select ac.name value, ac.description from ar_collectors ac order by ac.name US Collector 8 80 1=1 hcp.credit_hold=:credit_hold LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Credit Hold :$flex$.Account_Number_From Account Number From Account Number To :$flex$.operating_unit Operating Unit Account Number :$flex$.operating_unit Operating Unit Customer Name