ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDF1179D2E0530100007F1FF2 DIS Business Area Y select eb.ba_name value, eb.ba_description description from eul_us.eul5_bas eb order by eb.ba_name AR منطقة أعمال Discoverer D Geschäftsfeld Discoverer E Área de negocio Discoverer F Espace entreprises Discoverer I Area di business Discoverer JA ディスカバリーの営業エリア KO Discoverer 사업 영역 PTB Área de negócios do Discoverer RU Первооткрывательское направление деятельности S Discoverer affärsområde TR Discoverer iş alanı US Discoverer business area ZHS 发现者商业区 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 72B1B24E9A2154DAE0530100007F84B6 select xxen_util.dis_business_area(eo.obj_id,:eul) business_area, eo.obj_id, &exp_id 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, eqs.access_count, eqs.last_accessed, &sql_text_columns eo.obj_description folder_description, &item_columns xxen_util.dis_user_name(eo.obj_created_by) created_by, xxen_util.client_time(eo.obj_created_date) creation_date, xxen_util.dis_user_name(eo.obj_updated_by) last_updated_by, xxen_util.client_time(eo.obj_updated_date) last_update_date from ( 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 ee.it_obj_id obj_id, ee.* from &eul.eul5_expressions ee where '&show_items'='Y' and ee.exp_type in ('CI','CO') and ee.fil_obj_id is null union all select ee.fil_obj_id obj_id, ee.* from &eul.eul5_expressions ee where '&show_items'='Y' and ee.exp_type='FIL' and ee.it_obj_id is null ) ee, &eul.eul5_domains edo, &eul.eul5_expressions ee2, &eul.eul5_objs eo2, ( select eqs.obj_id, count(*) access_count, max(eqs.qs_created_date) last_accessed from ( select trim(regexp_substr(eqs.qs_object_use_key,'[^\.]+',1,rowgen.column_value)) obj_id, eqs.* from &eul.eul5_qpp_stats eqs, table(xxen_util.rowgen(regexp_count(eqs.qs_object_use_key,'\.')+1)) rowgen where 2=2 ) eqs where translate(eqs.obj_id,'x0123456789','x') is null group by eqs.obj_id ) eqs where 1=1 and eo.obj_id=ee.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 eo.obj_id=eqs.obj_id(+) order by eo.obj_name, decode(ee.exp_type,'CO',1,'CI',2,'FIL',3,'JP',4), ee.exp_sequence Y AR DIS Folders, Business Areas, Items and LOVs مجلدات Discoverer ومناطق وعناصر الأعمال. يُظهر العمودان "عدد مرات الوصول" و "آخر تم الوصول إليه" عدد المرات التي تم فيها الوصول إلى مجلد بواسطة ورقة عمل خلال الأيام الـ x الماضية. تقيد المعلمة "Show Active Only" المجلدات التي تم الوصول إليها من خلال عمليات تنفيذ ورقة العمل خلال آخر X يومًا. D DIS Folders, Business Areas, Items and LOVs Entdecker-Ordner, Geschäftsbereiche und Elemente. Die Spalten 'Access Count' und 'Last Accessed' zeigen an, wie oft innerhalb der letzten x Tage auf einen Ordner durch ein Arbeitsblatt zugegriffen wurde. Der Parameter 'Show Active Only' schränkt auf Ordner ein, auf die in den letzten x Tagen durch Arbeitsblattausführungen zugegriffen wurde. E DIS Folders, Business Areas, Items and LOVs Carpetas, áreas de negocio y elementos de Discoverer. Las columnas "Recuento de accesos" y "Último acceso" muestran cuántas veces se ha accedido a una carpeta mediante una hoja de trabajo en los últimos x días. El parámetro "Mostrar sólo activos" restringe las carpetas a las que se ha accedido mediante ejecuciones de hojas de trabajo en los últimos x días. F DIS Folders, Business Areas, Items and LOVs Dossiers de découverte, domaines d'activité et articles. Les colonnes "Nombre d'accès" et "Dernier accès" indiquent le nombre de fois qu'un dossier a été consulté par une feuille de calcul au cours des x derniers jours. Le paramètre "Afficher uniquement les dossiers actifs" se limite aux dossiers qui ont été consultés par des feuilles de calcul au cours des x derniers jours. I DIS Folders, Business Areas, Items and LOVs Cartelle Discoverer, aree aziendali e oggetti. Le colonne 'Access Count' e 'Last Accessed' mostrano quante volte una cartella è stata consultata da un foglio di lavoro negli ultimi x giorni. Il parametro 'Show Active Only' limita alle cartelle che sono state consultate da esecuzioni di fogli di lavoro negli ultimi x giorni. JA DIS Folders, Business Areas, Items and LOVs ディスカバラーのフォルダ、ビジネスエリア、およびアイテムを表示します。 アクセス回数」と「最後にアクセスした回数」の列には、過去 x 日間にワークシートによってフォルダにアクセスした回数が表示されます。 アクティブのみ表示] パラメータは、過去 x 日間にワークシートの実行によってアクセスされたフォルダに限定します。 KO DIS Folders, Business Areas, Items and LOVs Discoverer 폴더, 업무 영역 및 항목. '액세스 수'및 '마지막 액세스'열에는 지난 x 일 동안 워크 시트에서 폴더에 액세스 한 횟수가 표시됩니다. '활성 만 표시'매개 변수는 지난 x 일 동안 워크 시트 실행에서 액세스 한 폴더로 제한됩니다. PTB DIS Folders, Business Areas, Items and LOVs Pastas de descoberta, áreas de negócios e itens. As colunas 'Access Count' e 'Last Accessed' mostram quantas vezes uma pasta foi acessada por uma folha de trabalho nos últimos x dias. O parâmetro 'Mostrar somente ativo' restringe-se às pastas que foram acessadas pelas execuções da folha de trabalho nos últimos x dias. RU DIS Folders, Business Areas, Items and LOVs Переносные папки, деловые зоны и предметы. Колонки 'Счетчик доступа' и 'Последний доступ' показывают, сколько раз папка была обращена к рабочему листу за последние x дней. Параметр 'Показывать только активные' ограничивает папки, доступ к которым был получен по рабочему листу за последние x дней. S DIS Folders, Business Areas, Items and LOVs Discoverer-mappar, affärsområden och artiklar. Kolumner "Åtkomsträkning" och "Senast åtkomst" visar hur många gånger en mapp har nås av ett kalkylblad under de senaste x dagarna. Parametern "Visa endast aktiv" begränsar till mappar som har öppnats av kalkylbladskörningar under de senaste x dagarna. TR DIS Folders, Business Areas, Items and LOVs Discoverer klasörleri, iş alanları ve öğeler. 'Erişim Sayısı' ve 'Son Erişim' sütunları, son x gün içinde bir çalışma sayfasından bir klasöre kaç kez erişildiğini gösterir. 'Yalnızca Etkin Göster' parametresi, son x gün içinde çalışma sayfası yürütmeleriyle erişilen klasörlerle sınırlıdır. US DIS Folders, Business Areas, Items and LOVs Discoverer folders, business areas and items. Columns 'Access Count' and 'Last Accessed' shows how many times a folder was accessed by a worksheet within the past x days. Parameter 'Show Active Only' restricts to folders which have been accessed by worksheet executions within the past x days. ZHS DIS Folders, Business Areas, Items and LOVs 发现者文件夹、业务区域和项目。 列 "访问次数 "和 "最后访问 "显示了过去X天内工作表访问文件夹的次数。 参数 "仅显示活动 "限制在过去X天内被工作表执行访问的文件夹。 Enginatics &eul &exp_id &item_columns &show_items &sql_text_columns 1=1 2=2 :eul 1 10 1=1 eo.obj_id in ( select ebol.bol_obj_id from eul_us.eul5_bas eb, eul_us.eul5_ba_obj_links ebol where eb.ba_name=:business_area and eb.ba_id=ebol.bol_ba_id ) LOV DIS Business Area 8E2FF36EDF1179D2E0530100007F1FF2 Y select eb.ba_name value, eb.ba_description description from eul_us.eul5_bas eb order by eb.ba_name F Secteur d'activité US Business Area 2 20 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 F Dossier US Folder 3 30 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 F Identifiant du dossier US Folder Identifier 4 40 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 F Type de dossier US Folder Type 5 50 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 F Nom de vue US View Name 6 60 1=1 eo.obj_id=:object_id Number F Id de l'objet 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 F Utilisé par le cahier d'exercices 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 F Article US Item 9 &show_items Y F Article US Item 10 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 F Type d'article US Item Type 11 &show_items Y F Type d'article US Item Type 12 100 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 13 110 1=1 eqs.obj_id 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 14 120 &show_items Y 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$.item is not null or :$flex$.item_type is not null F Articles de spectacle US Show Items 15 &exp_id ee.exp_id, F Articles de spectacle US Show Items 16 &item_columns ee.exp_name item_name, xxen_util.dis_item_type(ee.exp_type) item_type, 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)) 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, F Articles de spectacle US Show Items 17 130 &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 select 'Y' from dual where :$flex$.show_items is null F Afficher l'objet SQL US Show Object SQL 18 140 &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 19 :eul F Couche de l'utilisateur final US End User Layer :$flex$.item Item Show Items :$flex$.item_type Item Type Show Items :$flex$.show_items Show Items Show Object SQL