ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 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）限制的操作单元。 C6E085D470F251A9E05362FB09050512Y SELECT party_level party_level1 ,party_name party_name_cust , customer_name customer_name_cust ,customer_id customer_id_cust ,base_currency base_currency_cust ,unchecked_exposure unchecked_exposure_cust ,nvl(unchecked_exposure,0) unchecked_exposure_cust1 ,credit_limit_currency cr_lim_currency_cust ,cr_cur_overall_limit cr_overall_cust ,cr_cur_exposure cr_exposure_cust ,cr_cur_available cr_available_cust ,decode(base_cur_overall_limit,-1,TO_NUMBER(NULL),-2,TO_NUMBER(NULL),base_cur_overall_limit) base_overall_cust ,decode(base_cur_exposure,-1,TO_NUMBER(NULL),-2,TO_NUMBER(NULL),base_cur_exposure) base_exposure_cust ,decode(base_cur_available,-1,TO_NUMBER(NULL),-2,TO_NUMBER(NULL),base_cur_available) base_available_cust, decode(global_exposure_flag,'Y','*',NULL) global_exp_flag_cust, ONT_OEXCEXP_XMLP_PKG.cf_get_b_currency_custformula(base_currency) CF_get_b_currency_cust, ONT_OEXCEXP_XMLP_PKG.CP_base_currency_cust_p CP_base_currency_cust, -- ONT_OEXCEXP_XMLP_PKG.cf_total_unchecked_exp_custfor(:CS_total_exp_and_unch, unchecked_exposure) -- CF_TOTAL_unchecked_exp_cust, -- ONT_OEXCEXP_XMLP_PKG.cf_total_avail_party_custformu(:CS_total_overall_cust) CF_total_avail_party_cust, ONT_OEXCEXP_XMLP_PKG.CP_total_unchecked_exp_cust_p CP_total_unchecked_exp_cust, ONT_OEXCEXP_XMLP_PKG.CP_total_avail_party_cust_p CP_total_avail_party_cust, ONT_OEXCEXP_XMLP_PKG.cf_get_exp_and_unchformula(decode ( base_cur_exposure , - 1 , TO_NUMBER ( NULL ) , - 2 , TO_NUMBER ( NULL ) , base_cur_exposure )) CF_get_exp_and_unch, ONT_OEXCEXP_XMLP_PKG.CP_exp_and_unchecked_p CP_exp_and_unchecked FROM oe_credit_exposure_temp WHERE party_parent_id=NVL(:P_SPECIFIC_PARTY_ID,:P_SPEC_PARTY_NUM_ID) AND bill_to_site_id IS NULL AND party_id IS NOT NULL AND customer_id IS NOT NULL order by 1 ONT OEXCEXP_XML AR ONT تقرير التعرض لائتمان Imported from BI Publisher Application: إدارة الطلبات Source: تقرير التعرض لائتمان (XML) Short Name: OEXCEXP_XML DB package: ONT_OEXCEXP_XMLP_PKG D ONT Kreditrisiko Imported from BI Publisher Application: Order Management Source: Kreditrisiko (XML) Short Name: OEXCEXP_XML DB package: ONT_OEXCEXP_XMLP_PKG E ONT Informe Exposición de Crédito Imported from BI Publisher Application: Order Management Source: Informe Exposición de Crédito (XML) Short Name: OEXCEXP_XML DB package: ONT_OEXCEXP_XMLP_PKG F ONT Etat Risque de crédit Imported from BI Publisher Application: Order Management Source: Etat Risque de crédit (XML) Short Name: OEXCEXP_XML DB package: ONT_OEXCEXP_XMLP_PKG I ONT Rapporto Esposizione credito Imported from BI Publisher Application: Order Management Source: Rapporto Esposizione credito (XML) Short Name: OEXCEXP_XML DB package: ONT_OEXCEXP_XMLP_PKG JA ONT 与信債務レポート Imported from BI Publisher Application: Order Management Source: 与信債務レポート(XML) Short Name: OEXCEXP_XML DB package: ONT_OEXCEXP_XMLP_PKG KO ONT 신용 위험 노출 보고서 Imported from BI Publisher Application: Order Management Source: 신용 위험 노출 보고서(XML) Short Name: OEXCEXP_XML DB package: ONT_OEXCEXP_XMLP_PKG PTB ONT Relatório de Exposição de Crédito Imported from BI Publisher Application: Gerenciamento de Ordens Source: Relatório de Exposição de Crédito (XML) Short Name: OEXCEXP_XML DB package: ONT_OEXCEXP_XMLP_PKG RU ONT Отчет о суммарном объеме кредита Imported from BI Publisher Application: Управление заказами Source: Отчет о суммарном объеме кредита (XML) Short Name: OEXCEXP_XML DB package: ONT_OEXCEXP_XMLP_PKG S ONT Kreditexponering - rapport Imported from BI Publisher Application: Order Management Source: Kreditexponering - rapport (XML) Short Name: OEXCEXP_XML DB package: ONT_OEXCEXP_XMLP_PKG TR ONT Alacak Riski Raporu Imported from BI Publisher Application: Sipariş Yönetimi(1) Source: Alacak Riski Raporu (XML) Short Name: OEXCEXP_XML DB package: ONT_OEXCEXP_XMLP_PKG US ONT Credit Exposure Imported from BI Publisher Application: Order Management Source: Credit Exposure Report (XML) Short Name: OEXCEXP_XML DB package: ONT_OEXCEXP_XMLP_PKG ZHS ONT 信用风险报表 Imported from BI Publisher Application: 订单管理 Source: 信用风险报表 (XML) Short Name: OEXCEXP_XML DB package: ONT_OEXCEXP_XMLP_PKG BI Publisher :cp_base_currency :cp_base_currency1 :cp_base_currency_cust :cp_base_currency_d :cp_check_rule :cp_cust_available_grand_total :cp_cust_exposure_grand_total :cp_cust_limit_grand_total :cp_cust_num_high :cp_cust_num_low :cp_customer_high :cp_customer_low :cp_exp_and_unchecked :cp_exposure_total_d :cp_hierarchy_name :cp_operating_unit :cp_party_base_currency :cp_party_dtl_grand_total_avail :cp_party_exp_grand_total :cp_party_name :cp_party_name_total_exp :cp_party_name_uncheck :cp_party_number :cp_party_sum_grand_avail :cp_prof_class_high :cp_prof_class_low :cp_report_option :cp_site_total_exposure :cp_total_avail_party_cust :cp_total_exposure :cp_total_unchecked_exp_cust :cp_unchecked_exposure :operating_unit :p_conc_request_id :p_cr_check_rule_id :p_cust_number_high :p_cust_number_low :p_customer_name_high :p_customer_name_low :p_order_by :p_org_id :p_party_name :p_party_name_high :p_party_name_low :p_party_number_high :p_party_number_low :p_prof_class_high :p_prof_class_low :p_report_by_option :p_return_status :p_spec_party_num_id :p_specific_party_id :rp_company_name 1 -40 :p_dummy1 Char SELECT 'PARTY_SUMMARY' FROM dual WHERE :$flex$.report_by='PARTY_SUMMARY' AR ONT_CC_EXC_REP_DUMMY1 الحقل الافتراضي D ONT_CC_EXC_REP_DUMMY1 Dummy-Feld E ONT_CC_EXC_REP_DUMMY1 Campo Ficticio F ONT_CC_EXC_REP_DUMMY1 Champ fictif I ONT_CC_EXC_REP_DUMMY1 Campo fittizio JA ONT_CC_EXC_REP_DUMMY1 ダミー・フィールド KO ONT_CC_EXC_REP_DUMMY1 Dummy 필드 PTB ONT_CC_EXC_REP_DUMMY1 Campo Fictício RU ONT_CC_EXC_REP_DUMMY1 Фиктивное поле S ONT_CC_EXC_REP_DUMMY1 Dummy-fält TR ONT_CC_EXC_REP_DUMMY1 Sözde Alan US ONT_CC_EXC_REP_DUMMY1 Dummy field ZHS ONT_CC_EXC_REP_DUMMY1 虚拟字段 2 -30 :p_dummy2 Char SELECT 'PARTY_DETAILS' FROM dual WHERE :$flex$.report_by='PARTY_DETAILS' AR ONT_CC_EXC_REP_DUMMY2 الحقل الافتراضي D ONT_CC_EXC_REP_DUMMY2 Dummy-Feld E ONT_CC_EXC_REP_DUMMY2 Campo Ficticio F ONT_CC_EXC_REP_DUMMY2 Champ fictif I ONT_CC_EXC_REP_DUMMY2 Campo fittizio JA ONT_CC_EXC_REP_DUMMY2 ダミー・フィールド KO ONT_CC_EXC_REP_DUMMY2 Dummy 필드 PTB ONT_CC_EXC_REP_DUMMY2 Campo Fictício RU ONT_CC_EXC_REP_DUMMY2 Фиктивное поле S ONT_CC_EXC_REP_DUMMY2 Dummy-fält TR ONT_CC_EXC_REP_DUMMY2 Sözde Alan US ONT_CC_EXC_REP_DUMMY2 Dummy field ZHS ONT_CC_EXC_REP_DUMMY2 虚拟字段 3 -20 :p_dummy3 Char SELECT 'CUSTOMER' FROM dual WHERE :$flex$.report_by='CUST_SUMMARY' OR :$flex$.report_by='CUST_DETAILS' AR ONT_CC_EXC_REP_DUMMY3 الحقل الافتراضي D ONT_CC_EXC_REP_DUMMY3 Dummy-Feld E ONT_CC_EXC_REP_DUMMY3 Campo Ficticio F ONT_CC_EXC_REP_DUMMY3 Champ fictif I ONT_CC_EXC_REP_DUMMY3 Campo fittizio JA ONT_CC_EXC_REP_DUMMY3 ダミー・フィールド KO ONT_CC_EXC_REP_DUMMY3 Dummy 필드 PTB ONT_CC_EXC_REP_DUMMY3 Campo Fictício RU ONT_CC_EXC_REP_DUMMY3 Фиктивное поле S ONT_CC_EXC_REP_DUMMY3 Dummy-fält TR ONT_CC_EXC_REP_DUMMY3 Sözde Alan US ONT_CC_EXC_REP_DUMMY3 Dummy field ZHS ONT_CC_EXC_REP_DUMMY3 虚拟字段 4 0 :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 select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) Y US Operating Unit Required Operating Unit restriction for reports working in single operating unit mode only 5 10 :p_report_by_option LOV Oracle ONT_CC_EXC_REPORTBY_OPTION Y select lookup_code id, meaning value, null description from oe_lookups where lookup_type='ONT_CC_EXC_REPORTBY_OPTION' order by value,description SELECT meaning FROM oe_lookups WHERE lookup_type='ONT_CC_EXC_REPORTBY_OPTION' AND lookup_code='CUST_SUMMARY' Y AR التقرير حسب التقرير حسب D Auswertung nach Auswertung nach E Informe por Informe por F Edité par Edité par I Rapporto per Rapporto per JA レポート基準 レポート基準 KO 보고서 기준 보고서 기준 PTB Relatório por Relatório por RU Отчет по Отчет по S Rapport per Rapport per TR Raporlama Esası Raporlama Esası US Report By Report By ZHS 报表依据 报表依据 6 20 :p_specific_party_id LOV Oracle ONT_CC_EXC_SPECIFIC_PARTY Y select party_id id, party_name value, null description from hz_parties where :$flex$.ont_cc_exc_rep_dummy2='PARTY_DETAILS' and party_type in ('ORGANIZATION','PERSON') order by party_name AR اسم الطرف معرف الطرف D Parteiname Parteikennung E Nombre de Parte Id Parte F Nom de la partie ID partie I Nome parte ID parte JA パーティ名 パーティID KO 당사자명 당사자 ID PTB Nome da Parte Id da Parte RU Имя стороны Идентификатор стороны S Part Part-id TR Taraf Adı Taraf No US Party Name Party Id ZHS 交易方名称 交易方标识 7 30 :p_spec_party_num_id LOV Oracle ONT_CC_EXP_SPECIFIC_PARTY_NUM Y select party_id id, party_number value, null description from hz_parties where :$flex$.ont_cc_exc_rep_dummy2='PARTY_DETAILS' order by party_number AR رقم الطرف معرف رقم الطرف D Parteinummer Kennung Parteinummer E Número de Parte Identificador de Número de Parte F Numéro de partie ID numéro de partie I Numero parte Id numero parte JA パーティ番号 パーティ番号ID KO 당사자 번호 당사자 번호 ID PTB Nº do Componente Id do Nº da Parte RU Номер стороны Идентификатор номера стороны S Partnr Partnummer-id TR Taraf Numarası Taraf Numarası Kimliği US Party Number Party Number Id ZHS 交易方编号 交易方编号标识 8 40 :p_party_name_low LOV Oracle ONT_CC_EXC_PARTY_NAMES Y select party_name id, party_name value, null description from hz_parties where :$flex$.ont_cc_exc_rep_dummy1='PARTY_SUMMARY' and party_type in ('ORGANIZATION','PERSON') order by party_name AR أسماء الأطراف من اسم الطرف من D Von Parteiname Von Parteiname E De Nombre de Parte De Nombre de Parte F Noms de partie - De Nom de partie - De I Nomi parte - Da Nome parte - Da JA パーティ名:自 パーティ名:自 KO 당사자명 From 당사자명 From PTB Nomes de Parte - De Nome da Parte - De RU Имена сторон с Имя стороны с S Från partnamn Från partnamn TR Taraf Adları, İlk İlk Taraf Adı US Party Names From Party Name From ZHS 交易方名称自 交易方名称自 9 50 :p_party_name_high LOV Oracle ONT_CC_EXC_PARTY_NAMES Y select party_name id, party_name value, null description from hz_parties where :$flex$.ont_cc_exc_rep_dummy1='PARTY_SUMMARY' and party_type in ('ORGANIZATION','PERSON') order by party_name AR إلى اسم الطرف إلى D Bis Bis Parteiname E A A Número de Parte F A Nom de partie - A I A Nome parte - A JA 至 パーティ名:至 KO 까지 당사자명 To PTB Até Nome da Parte - Até RU По Имя стороны по S Till Till partnamn TR Son Son Taraf Adı US To Party Name To ZHS 至 交易方名称至 10 60 :p_party_number_low LOV Oracle ONT_CC_EXC_PARTY_NUMBERS Y select party_number id, party_number value, null description from hz_parties where :$flex$.ont_cc_exc_rep_dummy1='PARTY_SUMMARY' and party_type in ('ORGANIZATION','PERSON') order by party_number AR أرقام الأطراف من أرقام الأطراف من D Von Parteinummer Von Parteinummer E De Número de Parte De Número de Parte F Numéros de partie - De Numéros de partie - De I Numeri parte - Da Numeri parte - Da JA パーティ番号:自 パーティ番号:自 KO 당사자 번호 From 당사자 번호 From PTB Números de Parte - De Números de Parte - De RU Номера сторон с Номера сторон с S Från partnummer Från partnummer TR Taraf Numaraları, İlk Taraf Numaraları, İlk US Party Numbers From Party Numbers From ZHS 交易方编号自 交易方编号自 11 70 :p_party_number_high LOV Oracle ONT_CC_EXC_PARTY_NUMBERS Y select party_number id, party_number value, null description from hz_parties where :$flex$.ont_cc_exc_rep_dummy1='PARTY_SUMMARY' and party_type in ('ORGANIZATION','PERSON') order by party_number AR إلى 2 أرقام الأطراف إلى D Bis 2 Bis Parteinummer E A 2 A Números de Parte F A 2 Numéros de partie - A I A 2 Numeri parte - A JA 至 2 パーティ番号:至 KO 까지 2 당사자 번호 To PTB Até 2 Nomes de Parte - Até RU По 2 Номера сторон по S Till 2 Till partnummer TR Son 2 Taraf Numaraları, Son US To 2 Party Numbers To ZHS 至 2 交易方名称至 12 80 :p_prof_class_low LOV Oracle ONT_CC_EXC_PROFILE_CLASSES Y select name id, name value, null description from hz_cust_profile_classes where :$flex$.ont_cc_exc_rep_dummy3='CUSTOMER' order by name AR طبقات مرجع العميل من اسم طبقة مرجع العميل من D Von Kreditprofilklasse Von Kreditprofilklasse E De Clases de Perfil de Cliente De Nombre de Clase de Perfil de Cliente F Classes de profils de crédit - De Nom de classe de profils de crédit - De I Classi profilo cliente - Da Nome classe profilo cliente - Da JA 顧客プロファイル区分:自 顧客プロファイル区分名:自 KO 고객 프로파일 분류: 부터 고객 프로파일 분류명: 부터 PTB Classes de Perfil do Cliente - De Nome da classe de perfil do cliente - de RU Классы профилей заказчиков с Имя класса профиля заказчика с S Från kundprofilklasser Från kundprofilklassnamn TR Müşteri Profil Sınıfları, İlk İlk müşteri profil sınıfı adı US Customer Profile Classes From Customer profile class name from ZHS 客户配置文件分类自 客户配置文件分类名称自 13 90 :p_prof_class_high LOV Oracle ONT_CC_EXC_PROFILE_CLASSES Y select name id, name value, null description from hz_cust_profile_classes where :$flex$.ont_cc_exc_rep_dummy3='CUSTOMER' order by name AR إلى 3 اسم طبقة مرجع العميل إلى D Bis 3 Bis Kreditprofilklasse E A 3 A Nombre de Clase de Perfil de Cliente F A 3 Nom de classe de profils de crédit - A I A 3 Nome classe profilo cliente - A JA 至 3 顧客プロファイル区分名:至 KO 까지 3 고객 프로파일 분류명: 까지 PTB Até 3 Nome da classe de perfil do cliente - até RU По 3 Имя класса профиля заказчика по S Till 3 Till kundprofilklassnamn TR Son 3 Son müşteri profil sınıfı adı US To 3 Customer profile class name to ZHS 至 3 客户配置文件分类名称至 14 100 :p_customer_name_low LOV Oracle ONT_CC_EXC_CUSTOMER_NAMES Y select p.party_name id, p.party_name value, null description from hz_parties p,hz_cust_accounts ca where ca.party_id=p.party_id and :$flex$.ont_cc_exc_rep_dummy3='CUSTOMER' order by p.party_name AR أسماء العملاء من اسم العميل من D Von Kundenname Von Kundenname E De Nombre de Cliente De Nombre de Cliente F Noms de client - De Nom de client - De I Nomi clienti - Da Nome cliente - Da JA 顧客名:自 顧客名:自 KO 고객명: 부터 고객명: 부터 PTB Nomes de Cliente - De Nome do cliente - de RU Имена заказчиков с Имя заказчика с S Från kundnamn Från kundnamn TR Müşteri Adları, İlk İlk müşteri adı US Customer Names From Customer name from ZHS 客户名称自 客户名称自 15 110 :p_customer_name_high LOV Oracle ONT_CC_EXC_CUSTOMER_NAMES Y select p.party_name id, p.party_name value, null description from hz_parties p,hz_cust_accounts ca where ca.party_id=p.party_id and :$flex$.ont_cc_exc_rep_dummy3='CUSTOMER' order by p.party_name AR إلى 4 اسم العميل إلى D Bis 4 Bis Kundenname E A 4 A Nombre de Cliente F A 4 Nom de client - A I A 4 Nome cliente - A JA 至 4 顧客名:至 KO 까지 4 고객명: 부터 PTB Até 4 Nome do cliente - até RU По 4 Имя заказчика по S Till 4 Till kundnamn TR Son 4 Son müşteri adı US To 4 Customer name to ZHS 至 4 客户名称至 16 120 :p_cust_number_low LOV Oracle ONT_CC_EXC_CUSTOMER_NUMBERS Y select ca.account_number id, ca.account_number value, null description from hz_parties p,hz_cust_accounts ca where ca.party_id=p.party_id and :$flex$.ont_cc_exc_rep_dummy3='CUSTOMER' order by ca.account_number AR رقم العميل من رقم العميل من D Von Kundennummer Von Kundennummer E De Número de Cliente De Número de Cliente F Numéros de client - De Numéro de client - De I Numeri cliente - Da Numero cliente - Da JA 顧客番号:自 顧客番号:自 KO 고객 번호: 부터 고객 번호: 부터 PTB Números de Cliente - De Número do cliente - de RU Номера заказчиков с Номер заказчика с S Från kundnummer Från kundnummer TR Müşteri Numaraları İlk İlk müşteri numarası US Customer Numbers From Customer number from ZHS 客户编号自 客户编号自 17 130 :p_cust_number_high LOV Oracle ONT_CC_EXC_CUSTOMER_NUMBERS Y select ca.account_number id, ca.account_number value, null description from hz_parties p,hz_cust_accounts ca where ca.party_id=p.party_id and :$flex$.ont_cc_exc_rep_dummy3='CUSTOMER' order by ca.account_number AR إلى 5 رقم العميل إلى D Bis 5 Bis Kundennummer E A 5 A Número de Cliente F A 5 Numéro de client - A I A 5 Numero cliente - A JA 至 5 顧客番号:至 KO 까지 5 고객 번호: 까지 PTB Até 5 Número do cliente - até RU По 5 Номер заказчика по S Till 5 Till kundnummer TR Son 5 Son müşteri numarası US To 5 Customer number to ZHS 至 5 客户编号至 18 140 :p_cr_check_rule_id LOV Oracle ONT_CC_EXC_CR_CHECK_RULES Y select credit_check_rule_id id, name value, null description from oe_credit_check_rules order by value,description Y AR قاعدة فحص الائتمان قاعدة فحص الائتمان D Kreditprüfungsregel Kreditprüfungsregel E Regla de Comprobación de Crédito Regla de Comprobación de Crédito F Règle de contrôle du crédit Règle de contrôle du crédit I Regola controllo credito Regola controllo credito JA 与信チェック・ルール 与信チェック・ルール KO 신용 검사 규칙 신용 검사 규칙 PTB Regra de Verificação de Crédito Regra de Verificação de Crédito RU Правило проверки кредита Правило проверки кредита S Kreditregel Kreditregel TR Kredi Kontrol Kuralı Kredi kontrol kuralı US Credit Check Rule Credit check rule ZHS 信用检查规则 信用检查规则