ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB879D2E0530100007F1FF2 GL Ledger Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='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(+)) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name AR دفاتر الأستاذ المقيدة بمجموعة الوصول ، المحددة بواسطة قيمة الملف الشخصي "مجموعة الوصول إلى بيانات GL" لمسؤولية تسجيل الدخول الحالية D Ledger, die durch das Zugriffsset eingeschränkt sind, definiert durch den Profilwert 'GL Data Access Set' der aktuellen Anmeldeverantwortung E Libros restringidos por el conjunto de acceso, definido por el valor del perfil "Conjunto de acceso a datos GL" de la responsabilidad de inicio de sesión actual F Grands livres limités par un ensemble d'accès, défini par la valeur du profil "GL Data Access Set" de la responsabilité de connexion actuelle I Libri mastri limitati dal set di accesso, definito dal valore del profilo 'GL Data Access Set' della responsabilità di login corrente JA 現在のログイン責任者のプロファイル値'GL Data Access Set'によって定義されたアクセスセットによって制限された元帳 KO 현재 로그인 권한의 프로파일 값 'GL 데이터 액세스 세트'로 정의 된 액세스 세트로 제한되는 원장 PTB Ledgers restritos pelo conjunto de acesso, definido pelo valor do perfil 'GL Data Access Set' da atual responsabilidade de login RU Леджеры, ограниченные набором доступа, определяемые значением профиля "GL Data Access Set" текущей ответственности за вход в систему S Ledgers begränsade av åtkomstuppsättning, definierade av profilvärde 'GL Data Access Set' för det aktuella inloggningsansvaret TR Mevcut oturum açma sorumluluğunun profil değeri 'GL Veri Erişim Kümesi' ile tanımlanan erişim kümesiyle kısıtlanmış defterler US Ledgers restricted by access set, defined by profile value 'GL Data Access Set' of the current login responsibility ZHS 由访问集限制的分类账，由当前登录责任的配置文件值 "GL数据访问集 "定义。 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）限制的操作单元。 8E2FF36EDEE779D2E0530100007F1FF2 ONT Order Number Y Y select ooha.order_number value, ottt.name||': '||hca.account_name||' ('||xxen_util.meaning(ooha.flow_status_code,'FLOW_STATUS',660)||')' description from oe_order_headers_all ooha, oe_transaction_types_tl ottt, hz_cust_accounts hca where nvl(ooha.transaction_phase_code,'F')='F' and (:$flex$.operating_unit is null or ooha.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and ooha.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) and ooha.sold_to_org_id=hca.cust_account_id and ooha.order_type_id=ottt.transaction_type_id and ottt.language=userenv('lang') order by ooha.order_number desc Fixed bug in operating unit access restriction when the default operating unit is set to something else US A8A90FEFA0BF3C79E053B46B63585557 select gl.name ledger, hou.name operating_unit, ooha.order_number, rtrim(oola.line_number||'.'||oola.shipment_number||'.'||oola.option_number||'.'||oola.component_number||'.'||oola.service_number,'.') line, xxen_util.meaning(obpha.billing_plan_status,'BILLING_PLAN_STATUS',660) billing_plan_status, obpha.billing_frequency, obpha.billing_period, obpha.start_date, obpha.billing_amount, obpha.bill_with_source_line, obpha.type_of_billing, obpha.last_reviewed_extd_price, obpha.usage_unit_desc, obpha.type_of_usage, obpla.sequence_number, obpla.bill_date, obpla.bill_amount, obpla.description, rtrim(oola2.line_number||'.'||oola2.shipment_number||'.'||oola2.option_number||'.'||oola2.component_number||'.'||oola2.service_number,'.') billed_line, xxen_util.meaning(obpla.milestone,'BILLING_PLAN_MILESTONE',660) milestone, obpla.usage, xxen_util.user_name(obpha.created_by) created_by, xxen_util.client_time(obpha.creation_date) creation_date, xxen_util.user_name(obpha.last_updated_by) last_updated_by, xxen_util.client_time(obpha.last_update_date) last_update_date from hr_operating_units hou, gl_ledgers gl, oe_order_headers_all ooha, oe_order_lines_all oola, oe_billing_plan_headers_all obpha, oe_billing_plan_lines_all obpla, oe_order_lines_all oola2 where 1=1 and hou.organization_id=ooha.org_id and gl.ledger_id=hou.set_of_books_id and ooha.header_id=obpha.source_order_header_id and oola.line_id=obpha.source_order_line_id and obpha.billing_plan_header_id=obpla.billing_plan_header_id and obpla.billed_line_id=oola2.line_id(+) order by gl.name, hou.name, ooha.order_number, line, obpla.sequence_number Y (:Ledger is not null or :Operating_Unit is not null) AR ONT Recurring Billing Plan تقرير الملف الشخصي يعرض خطة الفوترة المتكررة لأمر المبيعات لتفاصيل العنوان والسطر بما في ذلك الحالة والتكرار وفترة الفوترة ومبالغ الفواتير والتواريخ. D ONT Recurring Billing Plan Profilbericht, der den Kundenauftrags-Wiederholungsfakturierungsplan für Kopf- und Zeilendetails einschließlich Status, Häufigkeit, Fakturierungszeitraum, Fakturierungsbeträge und -daten anzeigt. E ONT Recurring Billing Plan Informe de perfil que muestra el plan de facturación periódica del pedido de cliente para los detalles de la cabecera y la línea, incluyendo el estado, la frecuencia, el período de facturación, los importes de facturación y las fechas. F ONT Recurring Billing Plan Rapport de profil montrant le plan de facturation récurrente de la commande client pour les détails d'en-tête et de ligne, y compris le statut, la fréquence, la période de facturation, les montants et les dates de facturation. I ONT Recurring Billing Plan Rapporto di profilo che mostra il piano di fatturazione ricorrente dell'ordine di vendita per i dettagli dell'intestazione e della linea, compreso lo stato, la frequenza, il periodo di fatturazione, gli importi e le date di fatturazione. JA ONT Recurring Billing Plan ステータス、頻度、請求期間、請求金額、日付を含むヘッダーとラインの詳細について、販売注文の定期的な請求プランを表示するプロファイルレポートです。 KO ONT Recurring Billing Plan 상태, 빈도, 청구 기간, 청구 금액 및 날짜를 포함한 헤더 및 라인 세부 사항에 대한 판매 주문 반복 청구 계획을 보여주는 프로필 보고서. PTB ONT Recurring Billing Plan Relatório de perfil mostrando o plano de faturamento periódico da ordem de venda para detalhes de cabeçalho e linha incluindo status, freqüência, período de faturamento, valores e datas de faturamento. RU ONT Recurring Billing Plan Профильный отчет, показывающий план повторяющихся расчетов по заголовкам и строкам, включая статус, частоту, расчетный период, суммы и даты выставления счетов. S ONT Recurring Billing Plan Profilrapport som visar återkommande faktureringsplan för försäljningsorder för rubrik- och raddetaljer inklusive status, frekvens, faktureringsperiod, faktureringsbelopp och datum. TR ONT Recurring Billing Plan Durum, sıklık, fatura dönemi, fatura tutarları ve tarihleri dahil olmak üzere başlık ve satır ayrıntıları için Satış siparişi yinelenen faturalandırma planını gösteren profil raporu. US ONT Recurring Billing Plan Profile report showing the Sales order recurring billing plan for header and line details including status, frequency, billing period, billing amounts and dates. Please enter a Ledger or Operating Unit ZHS ONT Recurring Billing Plan 概要报告显示了销售订单重复计费计划的标题和行的详细信息，包括状态、频率、计费周期、计费金额和日期。 Enginatics R12 only 1=1 1 10 1=1 gl.name=:ledger 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) LOV GL Ledger 8E2FF36EDEB879D2E0530100007F1FF2 Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='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(+)) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name US Ledger 2 20 1=1 hou.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)) US Operating Unit 3 30 1=1 ooha.order_number=:order_number LOV ONT Order Number 8E2FF36EDEE779D2E0530100007F1FF2 Y Y select ooha.order_number value, ottt.name||': '||hca.account_name||' ('||xxen_util.meaning(ooha.flow_status_code,'FLOW_STATUS',660)||')' description from oe_order_headers_all ooha, oe_transaction_types_tl ottt, hz_cust_accounts hca where nvl(ooha.transaction_phase_code,'F')='F' and (:$flex$.operating_unit is null or ooha.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and ooha.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) and ooha.sold_to_org_id=hca.cust_account_id and ooha.order_type_id=ottt.transaction_type_id and ottt.language=userenv('lang') order by ooha.order_number desc US Order Number :$flex$.ledger Ledger Operating Unit :$flex$.operating_unit Operating Unit Order Number