ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDF3879D2E0530100007F1FF2 DIS End User Layer Y select lower(do.owner) value, do.created description from dba_objects do where do.object_type='TABLE' and do.object_name='EUL5_VERSIONS' order by do.created desc AR طبقة المستخدم النهائي للمكتشف D Entdecker-Endbenutzerschicht E Capa de usuario final de Discoverer F Couche utilisateur final Discoverer I Livello utente finale Discoverer JA 発見者エンドユーザー層 KO Discoverer 최종 사용자 계층 PTB Camada do usuário final do Discoverer RU Уровень конечного пользователя S Discoverer-slutanvändarlager TR Discoverer son kullanıcı katmanı US Discoverer end user layer ZHS 发现者终端用户层 8E2FF36EDEE079D2E0530100007F1FF2 DIS Folder Y select eo.obj_name value, nvl(eo.sobj_ext_table,eo.obj_developer_key)||nvl2(eo.obj_description,' ('||eo.obj_description||')',null) description from eul_us.eul5_objs eo order by eo.obj_name AR مجلد Discoverer D Entdecker-Ordner E Carpeta Discoverer F Dossier Discoverer I Cartella Discoverer JA 発見者フォルダ KO Discoverer 폴더 PTB Pasta do descobridor RU Папка первооткрывателя S Discoverer-mapp TR Discoverer klasörü US Discoverer folder ZHS 发现者文件夹 B42C590EA428C91BE0530100007F4403 DIS Folder Identifier Y select eo.obj_developer_key value, eo.obj_name||nvl2(eo.obj_description,' ('||eo.obj_description||')',null) description from eul_us.eul5_objs eo order by eo.obj_developer_key AR معرف مجلد Discoverer D Bezeichner des Entdecker-Ordners E Identificador de la carpeta Discoverer F Identificateur de dossier Discoverer I Identificatore della cartella Discoverer JA 発見者フォルダ識別子 KO Discoverer 폴더 식별자 PTB Identificador de pasta do descobridor RU Идентификатор папки первооткрывателя S Identifierare för Discoverer-mapp TR Discoverer klasör tanımlayıcı US Discoverer folder identifier ZHS 发现者文件夹标识符 8E2FF36EDF1579D2E0530100007F1FF2 DIS Folder Type Y select 'Standard' value, 'Based on a database Views' description from dual union all select 'Custom SQL' value, 'Based on a SQL' description from dual union all select 'Complex view' value, 'Based on other Folders' description from dual AR نوع مجلد Discoverer D Entdecker-Ordnertyp E Tipo de carpeta Discoverer F Type de dossier Discoverer I Tipo di cartella Discoverer JA ディスカバラーのフォルダタイプ KO Discoverer 폴더 유형 PTB Descobridor tipo pasta RU Тип папки Переводчик S Discoverer-mapptyp TR Discoverer klasör türü US Discoverer folder type ZHS 发现者文件夹类型 8E2FF36EDEC179D2E0530100007F1FF2 DIS Item Y select distinct ee.exp_name value, decode(ee.exp_type,'FIL','Condition','CI','Calculated Item','CO','Item','JP','Join Predicate',ee.exp_type)||nvl2(ee.exp_description,': '||ee.exp_description,null) description from eul_us.eul5_expressions ee where ee.exp_type<>'JP' order by ee.exp_name AR عنصر المستكشف D Entdecker-Element E Artículo del Descubridor F Objet à découvrir I Elemento scopritore JA 発見者アイテム KO Discoverer 항목 PTB Descobridor item RU Первооткрыватель S Discoverer-objekt TR Discoverer öğesi US Discoverer item ZHS 发现者项目 8E2FF36EDF1679D2E0530100007F1FF2 DIS Item Type Y select 'Item' value, 'Standard item based on a table or view' description from dual union all select 'Calculated Item' value, 'Calculated item based on other items or a formula' description from dual union all select 'Condition' value, 'Filter condition' description from dual union all select 'Join Predicate' value, 'Join between different folders' description from dual AR نوع عنصر المستكشف D Entdecker-Elementtyp E Tipo de elemento descubridor F Type d'article à découvrir I Tipo di voce Discoverer JA 発見者のアイテムタイプ KO Discoverer 항목 유형 PTB Descobridor tipo de item RU Тип изделия Первооткрывателя S Discoverer-artikeltyp TR Discoverer öğe türü US Discoverer item type ZHS 发现者项目类型 8E2FF36EDF3179D2E0530100007F1FF2 DIS View Name Y select distinct eo.sobj_ext_table value, max(eo.obj_name) over (partition by eo.sobj_ext_table) description from eul_us.eul5_objs eo where eo.sobj_ext_table is not null order by eo.sobj_ext_table AR اسم عرض المجلد القياسي لـ Discoverer D Name der Discoverer-Standardordneransicht E Nombre de la vista de la carpeta estándar de Discoverer F Nom de la vue standard du dossier Discoverer I Nome della vista cartella standard Discoverer JA ディスカバーラー標準のフォルダ ビュー名 KO Discoverer 표준 폴더보기 이름 PTB Nome da pasta de visualização padrão do Discoverer RU Отключить стандартное имя просмотра папок S Discoverer standard mappvy namn TR Discoverer standart klasör görünümü adı US Discoverer standard folder view name ZHS 发现者标准文件夹视图名称 8E2FF36EDF2079D2E0530100007F1FF2 DIS Workbook Y select ed.doc_name value, ed.doc_description||' ('||ed.doc_developer_key||')' description from eul_us.eul5_documents ed order by ed.doc_name AR مصنف Discoverer D Entdecker-Arbeitsmappe E Cuaderno de trabajo Discoverer F Manuel du découvreur I Libro di lavoro Discoverer JA ディスカバラーワークブック KO Discoverer 워크 북 PTB Livro de exercícios do descobridor RU рабочая тетрадь первооткрывателя S Discoverer-arbetsbok TR Discoverer çalışma kitabı US Discoverer workbook ZHS 发现者工作手册 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US B546794731847B12E0530100007F9C03 select xxen_util.dis_business_area(eo.obj_id,:eul) business_area, eo.obj_id, ee.exp_id, xxen_util.dis_folder_type(eo.obj_type) folder_type, eo.obj_name folder_name, nvl2(eo.sobj_ext_table,nvl2(uv.view_name,'View','Table'),null) object_type, eo.sobj_ext_table object_name, &sql_text_columns xxen_util.dis_item_type(ee.exp_type) item_type, ee.exp_name item_name, eo3.obj_name join_folder_name, xxen_util.meaning(ee.fk_mstr_no_detail,'SYS_YES_NO',700) outer_join, ee.key_name join_name, ee.fk_obj_id_remote, ee.key_obj_id, decode(ee.exp_data_type,1,'Varchar',2,'Number',3,'Long',4,'Date',5,'Raw',6,'Large binary object',8,'Char',10,null,ee.exp_data_type) data_type, xxen_api.dis_formula_sql(ee.exp_id,:eul) formula, ee.it_ext_column db_column_name, eo2.obj_name lov_folder, xxen_util.dis_folder_type(eo2.obj_type) lov_folder_type, ee2.exp_name lov_item, ee2.lov_query, &lov_validation_error edo.dom_name lov_item_class, ee.exp_formula1, ee.exp_type, ee2.it_obj_id lov_obj_id, ee2.exp_id lov_exp_id, ee2.exp_type lov_exp_type, ee2.it_ext_column lov_column_name from ( select ee.*, ekc.key_name, ekc.key_obj_id, ekc.fk_obj_id_remote, ekc.fk_mstr_no_detail from &eul.eul5_expressions ee, &eul.eul5_key_cons ekc where decode(ee.exp_type,'JP',ee.jp_key_id)=ekc.key_id(+) ) ee, ( select ( select xxen_util.long_to_clob('SYS.VIEW$', 'TEXT', v.rowid) text from sys."_CURRENT_EDITION_OBJ" o, sys.view$ v, sys.user$ u where u.name='APPS' and eo.sobj_ext_table=o.name and o.obj#=v.obj# and o.owner#=u.user# ) text, eo.* from &eul.eul5_objs eo ) eo, user_views uv, &eul.eul5_domains edo, (select xxen_util.dis_lov_query(ee2.exp_id,:eul) lov_query, ee2.* from &eul.eul5_expressions ee2) ee2, &eul.eul5_objs eo2, &eul.eul5_objs eo3 where 1=1 and decode(ee.exp_type,'FIL',ee.fil_obj_id,'CI',ee.it_obj_id,'CO',ee.it_obj_id,'JP',ee.key_obj_id)=eo.obj_id(+) and ee.it_dom_id=edo.dom_id(+) and edo.dom_it_id_lov=ee2.exp_id(+) and ee2.it_obj_id=eo2.obj_id(+) and ee.fk_obj_id_remote=eo3.obj_id(+) and eo.sobj_ext_table=uv.view_name(+) order by eo.obj_name, decode(ee.exp_type,'CO',1,'CI',2,'FIL',3,'JP',4), ee.exp_sequence moved function dis_formula_sql from xxen_xdo to xxen_api Y AR DIS Items, Folders and Formulas عناصر Discoverer (التعبيرات) والمجلدات (الكائنات) ، بما في ذلك شروط الانضمام والصيغ (العناصر المحسوبة) D DIS Items, Folders and Formulas Erkennungselemente (Ausdrücke) und Ordner (Objekte), einschließlich Verknüpfungsbedingungen und Formeln (berechnete Elemente) E DIS Items, Folders and Formulas Elementos del Discoverer (expresiones) y carpetas (objetos), incluyendo condiciones de unión y fórmulas (elementos calculados) F DIS Items, Folders and Formulas Éléments de découverte (expressions) et dossiers (objets), y compris les conditions et formules de jointure (éléments calculés) I DIS Items, Folders and Formulas Elementi di Discoverer (espressioni) e cartelle (oggetti), comprese le condizioni di unione e le formule (elementi calcolati) JA DIS Items, Folders and Formulas 結合条件や数式（計算項目）を含む、発見者の項目（式）とフォルダ（オブジェクト）。 KO DIS Items, Folders and Formulas 결합 조건 및 공식 (계산 된 항목)을 포함한 Discoverer 항목 (표현식) 및 폴더 (객체) PTB DIS Items, Folders and Formulas Itens (expressões) e pastas (objetos) de descoberta, incluindo condições e fórmulas de adesão (itens calculados) RU DIS Items, Folders and Formulas Перенос элементов (выражений) и папок (объектов), в том числе условий и формул присоединения (вычисляемых элементов) S DIS Items, Folders and Formulas Discoverer-objekt (uttryck) och mappar (objekt), inklusive kopplingsvillkor och formler (beräknade objekt) TR DIS Items, Folders and Formulas Discoverer öğeleri (ifadeler) ve klasörler (nesneler), birleştirme koşulları ve formüller (hesaplanan öğeler) dahil US DIS Items, Folders and Formulas Discoverer items (expressions) and folders (objects), including join conditions and formulas (calculated items) ZHS DIS Items, Folders and Formulas 发现者项目（表达式）和文件夹（对象），包括连接条件和公式（计算项目）。 Enginatics &eul &lov_validation_error &sql_text_columns 1=1 :eul 1 10 1=1 eo.obj_name like :folder LOV DIS Folder 8E2FF36EDEE079D2E0530100007F1FF2 Y select eo.obj_name value, nvl(eo.sobj_ext_table,eo.obj_developer_key)||nvl2(eo.obj_description,' ('||eo.obj_description||')',null) description from eul_us.eul5_objs eo order by eo.obj_name US Folder 2 20 1=1 eo.obj_developer_key=:folder_identifier LOV DIS Folder Identifier B42C590EA428C91BE0530100007F4403 Y select eo.obj_developer_key value, eo.obj_name||nvl2(eo.obj_description,' ('||eo.obj_description||')',null) description from eul_us.eul5_objs eo order by eo.obj_developer_key US Folder Identifier 3 30 1=1 eo.obj_type=decode(:folder_type,'Standard','SOBJ','Complex view','COBJ','Custom SQL','CUO') LOV DIS Folder Type 8E2FF36EDF1579D2E0530100007F1FF2 Y select 'Standard' value, 'Based on a database Views' description from dual union all select 'Custom SQL' value, 'Based on a SQL' description from dual union all select 'Complex view' value, 'Based on other Folders' description from dual US Folder Type 4 40 1=1 eo.sobj_ext_table=:view_name LOV DIS View Name 8E2FF36EDF3179D2E0530100007F1FF2 Y select distinct eo.sobj_ext_table value, max(eo.obj_name) over (partition by eo.sobj_ext_table) description from eul_us.eul5_objs eo where eo.sobj_ext_table is not null order by eo.sobj_ext_table US View Name 5 50 1=1 ee.exp_id=:item_id Number US Item Id 6 60 1=1 eo.obj_id=:object_id Number US Object Id 7 70 1=1 eo.obj_developer_key in ( select eex.ex_to_par_devkey from eul_us.eul5_documents ed, eul_us.eul5_elem_xrefs eex where ed.doc_name=:workbook and ed.doc_id=eex.ex_from_id and eex.ex_from_type='DOC' ) LOV DIS Workbook 8E2FF36EDF2079D2E0530100007F1FF2 Y select ed.doc_name value, ed.doc_description||' ('||ed.doc_developer_key||')' description from eul_us.eul5_documents ed order by ed.doc_name US Used by Workbook 8 80 1=1 ee.exp_name=:item LOV DIS Item 8E2FF36EDEC179D2E0530100007F1FF2 Y select distinct ee.exp_name value, decode(ee.exp_type,'FIL','Condition','CI','Calculated Item','CO','Item','JP','Join Predicate',ee.exp_type)||nvl2(ee.exp_description,': '||ee.exp_description,null) description from eul_us.eul5_expressions ee where ee.exp_type<>'JP' order by ee.exp_name US Item 9 90 1=1 ee.exp_type=decode(:item_type,'Condition','FIL','Calculated Item','CI','Item','CO','Join Predicate','JP') LOV DIS Item Type 8E2FF36EDF1679D2E0530100007F1FF2 Y select 'Item' value, 'Standard item based on a table or view' description from dual union all select 'Calculated Item' value, 'Calculated item based on other items or a formula' description from dual union all select 'Condition' value, 'Filter condition' description from dual union all select 'Join Predicate' value, 'Join between different folders' description from dual US Item Type 10 100 &sql_text_columns xxen_util.dis_folder_sql3(eo.obj_id,:eul) folder_sql, case when lower(dbms_lob.substr(eo.text,15,length(eo.text)-14))=' with read only' then substr(eo.text,1,length(eo.text)-15) else eo.text end view_sql, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show Object SQL 11 110 &lov_validation_error xxen_report.validate_sql(replace(ee2.lov_query,':$flex$.',':'),'parse') lov_error_message, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Validate LOV SQL Show an additional column with SQL validation errors when set to Yes 12 120 &eul <parameter_value> LOV DIS End User Layer 8E2FF36EDF3879D2E0530100007F1FF2 Y select lower(do.owner) value, do.created description from dba_objects do where do.object_type='TABLE' and do.object_name='EUL5_VERSIONS' order by do.created desc xxen_util.dis_default_eul Y US End User Layer 13 :eul US End User Layer