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 发现者终端用户层 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 72B756B2A56367E7E0530100007FB0F8 select x.workbook, x.description, x.owner, x.identifier workbook_identifier, x.access_count, x.last_accessed, x.last_updated_by, x.last_update_date, &folder_columns &item_columns x.doc_id from ( select ed.doc_name workbook, ed.doc_description description, xxen_util.dis_user_name(ed.doc_eu_id,:eul) owner, ed.doc_developer_key identifier, eqs.access_count, eqs.last_accessed, xxen_util.dis_user_name(ed.doc_updated_by) last_updated_by, ed.doc_updated_date last_update_date, xxen_util.dis_business_area(eo.obj_id,:eul) business_area, eo.obj_name folder, eo.obj_developer_key folder_identifier, xxen_util.dis_folder_type(eo.obj_type) folder_type, nvl2(eo.sobj_ext_table,nvl2((select dv.view_name from dba_views dv where eo.sobj_ext_table=dv.view_name and dv.owner='APPS'),'View','Table'),null) object_type, eo.sobj_ext_table object_name, 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, eo.obj_description folder_description, eo.obj_id, eex.ex_to_devkey, eex.ex_to_type, ed.doc_id from &eul.eul5_documents ed, (select distinct eex.ex_from_id, eex.ex_to_par_devkey, decode(:display_level,'Items',eex.ex_to_type) ex_to_type, decode(:display_level,'Items',eex.ex_to_devkey) ex_to_devkey from &eul.eul5_elem_xrefs eex where eex.ex_from_type='DOC' and :display_level in ('Folders','Items')) eex, ( 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, ( select eqs.qs_doc_name, upper(eqs.qs_doc_owner) qs_doc_owner, count(*) access_count, max(eqs.qs_created_date) last_accessed from &eul.eul5_qpp_stats eqs where 2=2 group by eqs.qs_doc_name, eqs.qs_doc_owner ) eqs where 1=1 and ed.doc_id=eex.ex_from_id(+) and eex.ex_to_par_devkey=eo.obj_developer_key(+) and ed.doc_name=eqs.qs_doc_name(+) and xxen_util.dis_user_name(ed.doc_eu_id,:eul,'N')=eqs.qs_doc_owner(+) ) x, ( select ee.it_obj_id obj_id, ee.* from &eul.eul5_expressions ee where ee.exp_type in ('CI','CO') and ee.fil_obj_id is null and :display_level='Items' union all select ee.fil_obj_id obj_id, ee.* from &eul.eul5_expressions ee where ee.exp_type='FIL' and ee.it_obj_id is null and :display_level='Items' ) ee, &eul.eul5_domains edo, &eul.eul5_expressions ee2, &eul.eul5_objs eo2, (select ekc.* from &eul.eul5_key_cons ekc where :display_level='Items') ekc, (select ef.* from &eul.eul5_functions ef where :display_level='Items') ef where x.obj_id=ee.obj_id(+) and case when x.ex_to_type in ('ITE','FIL') then x.ex_to_devkey end=ee.exp_developer_key(+) 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 decode(x.ex_to_type,'JOI',x.ex_to_devkey)=ekc.key_developer_key(+) and decode(x.ex_to_type,'FUN',x.ex_to_devkey)=ef.fun_developer_key(+) order by x.workbook &order_by_folder Y AR DIS Workbooks, Folders, Items and LOVs مصنفات Discoverer ، وأصحابها ، والمجلدات ، والعناصر ، وقوائم LOVs لفئة العنصر ، المشتقة من جدول التبعية eul5_elem_xrefs. D DIS Workbooks, Folders, Items and LOVs Discoverer-Arbeitsmappen, ihre Besitzer, Ordner, Elemente und Elementklassen-LOVs, abgeleitet aus der Abhängigkeitstabelle eul5_elem_xrefs. E DIS Workbooks, Folders, Items and LOVs Libros de trabajo de Discoverer, sus propietarios, carpetas, artículos y LOVs de clase de artículo, derivados de la tabla de dependencia eul5_elem_xrefs. F DIS Workbooks, Folders, Items and LOVs Les classeurs Discoverer, leurs propriétaires, les dossiers, les objets et les LOV des classes d'objets, dérivés de la table de dépendance eul5_elem_xrefs. I DIS Workbooks, Folders, Items and LOVs Le cartelle di lavoro Discoverer, i loro proprietari, le cartelle, gli elementi e le classi di elementi LOV, derivati dalla tabella delle dipendenze eul5_elem_xrefs. JA DIS Workbooks, Folders, Items and LOVs 依存関係テーブル eul5_elem_xrefs から派生したディスカバラーワークブック、その所有者、フォルダ、アイテム、アイテムクラス LOV。 KO DIS Workbooks, Folders, Items and LOVs 종속성 테이블 eul5_elem_xrefs에서 파생 된 Discoverer 워크 북, 해당 소유자, 폴더, 항목 및 항목 클래스 LOV PTB DIS Workbooks, Folders, Items and LOVs Descobridor de livros de exercícios, seus proprietários, pastas, itens e classe de itens LOVs, derivados da tabela de dependência eul5_elem_xrefs. RU DIS Workbooks, Folders, Items and LOVs Переносные рабочие книги, их владельцы, папки, элементы и LOV класса элементов, полученные из таблицы зависимостей eul5_elem_xrefs. S DIS Workbooks, Folders, Items and LOVs Discoverer-arbetsböcker, deras ägare, mappar, objekt och objektklass-LOV, härledda från beroendestabellen eul5_elem_xrefs. TR DIS Workbooks, Folders, Items and LOVs Eul5_elem_xrefs bağımlılık tablosundan türetilen Discoverer çalışma kitapları, sahipleri, klasörleri, öğeleri ve öğe sınıfı DL'leri. US DIS Workbooks, Folders, Items and LOVs Discoverer workbooks, their owners, folders, items and item class LOVs, derived from dependency table eul5_elem_xrefs. ZHS DIS Workbooks, Folders, Items and LOVs 发现者工作簿、它们的所有者、文件夹、项目和项目类LOVs，来源于依赖表eul5_elem_xrefs。 Enginatics &eul &folder_columns &item_columns &order_by_folder 1=1 2=2 :display_level :eul 1 10 1=1 ed.doc_name=:workbook 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 F Cahier d'exercices US Workbook 2 20 1=1 eo.obj_name like :folder LOV custom 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 where eo.obj_developer_key in (select eex.ex_to_par_devkey from eul_us.eul5_elem_xrefs eex) order by eo.obj_name F Dossier US Folder 3 30 1=1 eo.sobj_ext_table=:view_name LOV custom 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 and eo.obj_developer_key in (select eex.ex_to_par_devkey from eul_us.eul5_elem_xrefs eex) order by eo.sobj_ext_table F Nom de vue US View Name 4 40 1=1 ed.doc_id=:doc_id Number US Workbook Id 5 50 2=2 eqs.qs_created_date>sysdate-:days Number nvl(fnd_profile.value('XXEN_REPORT_DISCOVERER_IMPORT_LOV_ACCESS_HISTORY_DAYS'),90) F Nombre d'accès dans les x jours US Access Count within x Days 6 60 1=1 eqs.qs_doc_name is not null LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Afficher uniquement Active US Show Active only 7 70 :display_level LOV custom Y select 'Workbook' value, 'Workbooks only' description from dual union all select 'Folders' value, 'Workbooks and folders' description from dual union all select 'Items' value, 'Workbooks, folders and items' description from dual Folders Y F Niveau d'affichage US Display Level 8 &folder_columns x.business_area, x.folder, x.folder_type, x.object_type, x.object_name, x.folder_sql, x.view_sql, x.folder_description, x.obj_id, Folders F Niveau d'affichage US Display Level 9 &folder_columns x.business_area, x.folder, x.folder_type, x.object_type, x.object_name, x.folder_sql, x.view_sql, x.folder_description, x.obj_id, Items F Niveau d'affichage US Display Level 10 &item_columns coalesce(ee.exp_name,ekc.key_name,ef.fun_name) item_name, coalesce( xxen_util.dis_item_type(ee.exp_type), decode(x.ex_to_type,'ITE','Item','JOI','Join','FUN','Function','FIL','Condition',x.ex_to_type) ) item_type, lower(nvl2(ef.fun_ext_package,ef.fun_ext_package||'.',null)||ef.fun_ext_name) db_function_name, decode(ee.fil_runtime_filter,1,'Optional',0,'Mandatory') condition_type, coalesce(ee.it_ext_column,xxen_api.dis_formula_sql(ee.exp_id,:eul),ekc.key_description) column_or_formula, 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, eo2.obj_name lov_folder, ee2.exp_name lov_item, xxen_util.dis_lov_query(edo.dom_it_id_lov,:eul) lov_query, edo.dom_name lov_item_class, ee.exp_id, Items F Niveau d'affichage US Display Level 11 &order_by_folder ,x.folder Folders F Niveau d'affichage US Display Level 12 &order_by_folder ,x.folder Items F Niveau d'affichage US Display Level 13 80 &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 F Couche de l'utilisateur final US End User Layer 14 :eul F Couche de l'utilisateur final US End User Layer