ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 72B1B24E9A2154DAE0530100007F84B6Y 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 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