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）限制的操作单元。 A72A182C50EA2557E0530100007F63D0 OKS Contract Number Y Y select okhab.contract_number value, okhab.contract_number_modifier||nvl2(okhab.contract_number_modifier,' ',null)||osv0.meaning||': '||osclv.meaning||' ('||haouv.name||')' description from hr_all_organization_units_vl haouv, okc_k_headers_b okhab, okc_statuses_v osv0, okc_subclasses_v osclv where (:$flex$.operating_unit is null or haouv.name=:$flex$.operating_unit) and okhab.scs_code in ('SERVICE','WARRANTY','SUBSCRIPTION') and haouv.organization_id=okhab.authoring_org_id and okhab.sts_code=osv0.code(+) and okhab.scs_code=osclv.code(+) US 01EBA8B26251E287E0630100007FDA69 OKS Contract Status Y select osv0.meaning value, count(*) description from okc_k_headers_all_b okhab, okc_statuses_v osv0 where okhab.authoring_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 okhab.scs_code in (select osb.code from okc_subclasses_b osb where osb.cls_code='SERVICE') and okhab.sts_code=osv0.code group by osv0.meaning order by osv0.meaning Fixed bug in operating unit access restriction when the default operating unit is set to something else US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US A722DCF7B991875CE053B46B6358F0EBY select haouv.name operating_unit, ocv.meaning class, osclv.meaning category, okhab.contract_number, okhab.contract_number_modifier modifier, osv0.meaning contract_status, osv1.meaning line_status, osv2.meaning subline_status, oklb1.line_number||nvl2(oklb2.line_number,'.'||oklb2.line_number,null) line_number, xxen_util.meaning(nvl(olsb2.lty_code,olsb1.lty_code),'OKC_LINE_TYPE',0)||' '||xxen_util.meaning(okslb1.usage_type,'OKS_USAGE_TYPES',0) contract_line_type, okslb2.base_reading, okslb1.usage_period, rr.name invoice_rule, rr2.name accounting_rule, oslb.sequence_no stream_level_sequence, oslb.level_periods, oslb.uom_per_period, oslb.uom_code, oslb.start_date stream_level_start_date, oslb.end_date stream_level_end_date, to_number(ole.sequence_number) level_sequence, ole.date_start bill_from, ole.date_end bill_to, ole.date_to_interface interface_date, ole.date_completed, ole.amount, okhab.scs_code, okslb1.usage_type, olsb1.lty_code, xxen_util.user_name(ole.created_by) created_by, xxen_util.client_time(ole.creation_date) creation_date, xxen_util.user_name(ole.last_updated_by) last_updated_by, xxen_util.client_time(ole.last_update_date) last_update_date from hr_all_organization_units_vl haouv, okc_k_headers_all_b okhab, okc_subclasses_v osclv, okc_classes_v ocv, okc_statuses_v osv0, okc_statuses_v osv1, okc_statuses_v osv2, okc_k_lines_b oklb1, (select oklb.* from okc_k_lines_b oklb where '&show_subline'='Y') oklb2, oks_k_lines_b okslb1, oks_k_lines_b okslb2, okc_line_styles_b olsb1, okc_line_styles_b olsb2, oks_stream_levels_b oslb, oks_level_elements ole, ra_rules rr, ra_rules rr2 where 1=1 and okhab.authoring_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 haouv.organization_id=okhab.authoring_org_id and okhab.scs_code=osclv.code(+) and osclv.cls_code=ocv.code(+) and okhab.sts_code=osv0.code(+) and oklb1.sts_code=osv1.code(+) and oklb2.sts_code=osv2.code(+) and okhab.id=oklb1.chr_id and oklb1.id=oklb2.cle_id(+) and oklb1.id=okslb1.cle_id and oklb2.id=okslb2.cle_id(+) and oklb1.lse_id=olsb1.id and oklb2.lse_id=olsb2.id(+) and oslb.id=ole.rul_id and oklb1.inv_rule_id=rr.rule_id(+) and okslb1.acct_rule_id=rr2.rule_id(+) order by haouv.name, okhab.scs_code, okhab.contract_number, okhab.contract_number_modifier, line_number, oslb.sequence_no, to_number(ole.sequence_number) Fixed bug in operating unit access restriction when the default operating unit is set to something else AR OKS Service Contracts Billing Schedule جدول فوترة عقود الخدمة مع قواعد الفواتير والمحاسبة ، ومفصلة لتواريخ الفواتير والمبالغ من جدول عناصر مستوى التدفق oks_level_elements. يتم استخدام العمود date_competed لتحديد السجلات المفتوحة أو التي تمت فوترتها بالفعل ويستخدم برنامج إعداد فواتير عقود الخدمة date_to_interface لتحديد السجلات التي سيتم إصدار فواتير بها في أي تاريخ معين. بالنسبة للفوترة المسبقة ، يتم تعيين date_to_interface على بداية فترة الفاتورة وبالنسبة للمتأخرات ، يتم تعيينها على النهاية. عند إنشاء سجل جديد لجدول الفوترة للفترات الماضية (كان يجب أن يكون قد تم تحرير فاتورة به بالفعل) ، يتم تعيين date_to_interface على التاريخ الحالي. يمكن العثور على نظرة عامة حول عقود خدمة أوراكل وأنواع الخطوط الأخرى هنا: https://www.enginatics.com/reports/okc-contract-lines-summary/ D OKS Service Contracts Billing Schedule Abrechnungsplan für Serviceverträge mit Fakturierungs- und Abrechnungsregeln und detaillierten abzurechnenden Periodenterminen und Beträgen aus der Tabelle oks_level_elements der Stromebene. Die Spalte date_competed wird verwendet, um offene oder bereits abgerechnete Datensätze zu identifizieren, und date_to_interface wird vom Abrechnungsprogramm für Serviceverträge verwendet, um die zu einem bestimmten Datum abzurechnenden Datensätze zu identifizieren. Bei Vorausabrechnung wird date_to_interface auf den Beginn des Abrechnungszeitraums und bei Verzug auf das Ende gesetzt. Beim Erstellen eines neuen Abrechnungsplansatzes für vergangene Zeiträume (die bereits fakturiert sein sollten) wird date_to_interface auf das aktuelle Datum gesetzt. Eine Übersicht über Oracle-Serviceverträge und andere Leitungstypen finden Sie hier: https://www.enginatics.com/reports/okc-contract-lines-summary/ E OKS Service Contracts Billing Schedule Calendario de facturación de los Contratos de Servicios con reglas de facturación y contabilidad, y fechas e importes detallados de los períodos a facturar de la tabla de elementos de nivel de flujo oks_level_elements. La columna date_competed se utiliza para identificar los registros abiertos o ya facturados y date_to_interface es utilizada por el programa de facturación de contratos de servicios para identificar los registros a facturar en una fecha determinada. Para la facturación anticipada, date_to_interface se establece al principio del periodo de facturación y para los atrasos, se establece al final. Cuando se crea un nuevo registro del programa de facturación para periodos pasados (que ya deberían haber sido facturados), date_to_interface se establece en la fecha actual. Puede encontrar un resumen de los contratos de servicio de oracle y otros tipos de línea aquí: https://www.enginatics.com/reports/okc-contract-lines-summary/ F OKS Service Contracts Billing Schedule Calendrier de facturation des contrats de service avec les règles de facturation et de comptabilité, et les dates et montants détaillés des périodes à facturer à partir de la table des éléments de niveau de flux oks_level_elements. La colonne date_competed est utilisée pour identifier les enregistrements ouverts ou déjà facturés et la colonne date_to_interface est utilisée par le programme de facturation des contrats de service pour identifier les enregistrements à facturer à une date donnée. Pour la facturation anticipée, la date_to_interface est fixée au début de la période de facturation et pour les arriérés, elle est fixée à la fin. Lors de la création d'un nouvel enregistrement de calendrier de facturation pour des périodes passées (qui auraient déjà dû être facturées), date_to_interface est fixée à la date du jour. Un aperçu des contrats de services oracle et d'autres types de lignes peut être trouvé ici : https://www.enginatics.com/reports/okc-contract-lines-summary/ I OKS Service Contracts Billing Schedule Programma di fatturazione dei contratti di servizio con regole di fatturazione e contabilità, e date e importi dettagliati del periodo da fatturare dalla tabella degli elementi del livello di flusso oks_level_elements. La colonna date_competed è usata per identificare i record aperti o già fatturati e date_to_interface è usata dal programma di fatturazione dei contratti di servizio per identificare i record da fatturare in qualsiasi data. Per la fatturazione anticipata, date_to_interface è impostato all'inizio del periodo di fatturazione e per gli arretrati è impostato alla fine. Quando si crea un nuovo record del programma di fatturazione per i periodi passati (che dovrebbero essere già stati fatturati), date_to_interface è impostato alla data corrente. Una panoramica dei contratti di servizio oracle e di altri tipi di linea può essere trovata qui: https://www.enginatics.com/reports/okc-contract-lines-summary/ JA OKS Service Contracts Billing Schedule ストリームレベル要素テーブル oks_level_elements から、請求書発行と会計ルール、および請求される期間の日付と金額の詳細を持つサービス契約の請求書スケジュール。 カラム date_competed は、未解決または既に請求されたレコードを識別するために使用され、date_to_interface は、サービス契約の請求プログラムによって、任意の日付で請求されるレコードを識別するために使用されます。 事前請求の場合、date_to_interfaceは請求期間の開始日に設定され、滞納の場合は終了日に設定されます。過去の期間（既に課金されているはずの）の新しい課金スケジュールレコードを作成する場合、date_to_interface は現在の日付に設定されます。 オラクルのサービス契約およびその他のラインタイプの概要については、こちらをご覧ください: https://www.enginatics.com/reports/okc-contract-lines-summary/ KO OKS Service Contracts Billing Schedule 송장 발행 및 회계 규칙이있는 서비스 계약 청구 일정, 스트림 레벨 요소 테이블 oks_level_elements의 청구 기간 날짜 및 금액에 대해 자세히 설명합니다. date_competed 열은 열려 있거나 이미 청구 된 레코드를 식별하는 데 사용되며 date_to_interface는 서비스 계약 청구 프로그램에서 지정된 날짜에 청구될 레코드를 식별하는 데 사용됩니다. 선불 결제의 경우 date_to_interface는 결제 기간의 시작으로 설정되고 연체의 경우 끝으로 설정됩니다. 이전 기간 (이미 청구되어야 함)에 대한 새 청구 일정 레코드를 만들 때 date_to_interface가 현재 날짜로 설정됩니다. 오라클 서비스 계약 및 기타 라인 유형에 대한 개요는 https://www.enginatics.com/reports/okc-contract-lines-summary/에서 확인할 수 있습니다. PTB OKS Service Contracts Billing Schedule Contratos de serviço com programação de faturamento e regras contábeis, e datas e valores detalhados a serem faturados no período a partir da tabela de elementos de nível de fluxo de dados oks_level_elements. A coluna date_competed é usada para identificar registros abertos ou já faturados e a data_à_interface é usada pelo programa de faturamento de contratos de serviços para identificar os registros a serem faturados em uma determinada data. Para faturamento antecipado, a data_à_interface é definida para o início do período de faturamento e, para atrasos, é definida para o final. Ao criar um novo registro de programação de faturamento para períodos passados (que já deveriam ter sido faturados), a data_até_interface é definida para a data atual. Uma visão geral dos contratos de serviços do oracle e outros tipos de linha pode ser encontrada aqui: https://www.enginatics.com/reports/okc-contract-lines-summary/ RU OKS Service Contracts Billing Schedule График выставления счетов по контрактам на обслуживание с правилами выставления счетов и учета, а также подробная информация о датах и суммах расчетного периода из таблицы элементов уровня потока oks_level_elements. Колонка date_competed используется для идентификации открытых или уже выставленных счетов, а date_to_interface используется биллинговой программой контрактов на оказание услуг для идентификации записей, которые будут выставлены счета на определенную дату. Для авансового биллинга date_to_interface устанавливается в начало биллингового периода, а для просроченных - в конец. При создании новой записи расписания биллинга за прошедшие периоды (которые должны были быть уже выставлены), date_to_interface устанавливается на текущую дату. Обзор договоров на предоставление услуг oracle и других типов линий можно найти здесь: https://www.enginatics.com/reports/okc-contract-lines-summary/. S OKS Service Contracts Billing Schedule Servicekontrakt faktureringsschema med fakturerings- och redovisningsregler och detaljerade fakturerade perioddatum och belopp från strömnivåelementtabellen oks_level_elements. Column date_competed används för att identifiera öppna eller redan fakturerade poster och date_to_interface används av serviceavtalets faktureringsprogram för att identifiera de poster som ska faktureras vid ett visst datum. För förskottsfakturering är date_to_interface inställt på början av faktureringsperioden och för efterskott är det inställt till slutet. När du skapar en ny post för faktureringsschema för tidigare perioder (som borde ha fakturerats redan) är datum_ till_interface inställt på det aktuella datumet. En översikt över oracle-serviceavtal och andra linjetyper hittar du här: https://www.enginatics.com/reports/okc-contract-lines-summary/ TR OKS Service Contracts Billing Schedule Faturalama ve muhasebe kuralları ile birlikte Servis Sözleşmeleri faturalama çizelgesi ve ayrıntılı faturalandırılacak dönem tarihleri ve tutarları akış seviyesi elemanları tablosundan oks_level_elements. Date_competed sütunu, açık veya önceden faturalandırılmış kayıtları tanımlamak için kullanılır ve date_to_interface, herhangi bir tarihte faturalandırılacak kayıtları tanımlamak için hizmet sözleşmeleri faturalama programı tarafından kullanılır. Ön faturalama için, tarih_ arayüzüne, fatura döneminin başlangıcına, gecikmeler için ise sona ayarlanır. Geçmiş dönemler için yeni faturalama programı kaydı oluştururken (önceden faturalandırılmış olması gerekirdi), date_to_interface geçerli tarihe ayarlanır. Oracle hizmet sözleşmelerine ve diğer hat türlerine genel bir bakış burada bulunabilir: https://www.enginatics.com/reports/okc-contract-lines-summary/ US OKS Service Contracts Billing Schedule Service Contracts billing schedule with invoicing and accounting rules, and detailed to be billed period dates and amounts from the stream level elements table oks_level_elements. Column date_competed is used to identify open or already billed records and date_to_interface is used by the service contracts billing program to identify the records to be billed at any given date. For advance billing, date_to_interface is set to the beginning of the billing period and for arrears, it is set to the end. When creating new billing schedule record for past periods (that should have been billed already), date_to_interface is set to the current date. An overview of oracle service contracts and other line types can be found here: https://www.enginatics.com/reports/okc-contract-lines-summary/ ZHS OKS Service Contracts Billing Schedule 服务合同计费时间表，包括开票和会计规则，以及详细的计费期日期和金额，来自流水平元素表oks_level_elements。 列中的date_competed用于识别未开票或已经开票的记录，而date_to_interface则被服务合同计费程序用于识别在任何给定日期要开票的记录。 对于预付费，date_to_interface被设置为计费期的开始，对于欠费，则被设置为结束。当为过去的时期创建新的计费计划记录时（应该已经计费了），date_to_interface被设置为当前日期。 关于oracle服务合同和其他线路类型的概述可以在这里找到：https://www.enginatics.com/reports/okc-contract-lines-summary/。 Enginatics &show_subline 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)) F Unité d'exploitation US Operating Unit 2 20 1=1 okhab.contract_number=:contract_nunber LOV OKS Contract Number A72A182C50EA2557E0530100007F63D0 Y Y select okhab.contract_number value, okhab.contract_number_modifier||nvl2(okhab.contract_number_modifier,' ',null)||osv0.meaning||': '||osclv.meaning||' ('||haouv.name||')' description from hr_all_organization_units_vl haouv, okc_k_headers_b okhab, okc_statuses_v osv0, okc_subclasses_v osclv where (:$flex$.operating_unit is null or haouv.name=:$flex$.operating_unit) and okhab.scs_code in ('SERVICE','WARRANTY','SUBSCRIPTION') and haouv.organization_id=okhab.authoring_org_id and okhab.sts_code=osv0.code(+) and okhab.scs_code=osclv.code(+) F Numéro de contrat US Contract Number 3 30 1=1 okhab.contract_number_modifier=:modifier LOV custom Y select okhab.contract_number_modifier value, null description from okc_k_headers_b okhab where okhab.contract_number=:$flex$.contract_number order by okhab.creation_date desc US Modifier 4 32 1=1 osv0.meaning=:contract_status LOV OKS Contract Status 01EBA8B26251E287E0630100007FDA69 Y select osv0.meaning value, count(*) description from okc_k_headers_all_b okhab, okc_statuses_v osv0 where okhab.authoring_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 okhab.scs_code in (select osb.code from okc_subclasses_b osb where osb.cls_code='SERVICE') and okhab.sts_code=osv0.code group by osv0.meaning order by osv0.meaning US Contract Status 5 34 1=1 osv0.meaning<>:exclude_contract_status LOV OKS Contract Status 01EBA8B26251E287E0630100007FDA69 Y select osv0.meaning value, count(*) description from okc_k_headers_all_b okhab, okc_statuses_v osv0 where okhab.authoring_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 okhab.scs_code in (select osb.code from okc_subclasses_b osb where osb.cls_code='SERVICE') and okhab.sts_code=osv0.code group by osv0.meaning order by osv0.meaning US Exclude Contract Status 6 35 1=1 ole.date_to_interface>=:interface_date_from Date US Interface Date From 7 40 1=1 ole.date_to_interface<:interface_date_to+1 Date last_day(:$flex$.interface_date_from) US Interface Date To 8 50 1=1 ole.date_completed is null LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select 'Y' from dual where :$flex$.due_to_bill_before_date is not null F Afficher uniquement les non facturés US Show unbilled only 9 60 1=1 oklb1.id=oslb.cle_id LOV custom Y select 'Line' value, null description from dual union all select 'Sub Line' value, null description from dual Line Line Y US Level 10 1=1 oklb2.id=oslb.cle_id Sub Line US Level 11 &show_subline Y Sub Line US Level :$flex$.contract_number Contract Number Modifier :$flex$.interface_date_from Interface Date From Y Interface Date To :$flex$.operating_unit Operating Unit Contract Number