ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN A412F6421530508AE053B46B6358EEE4 ECC Application Y select eat.application_name value, eab.application_short_name description from ecc.ecc_application_b eab, ecc.ecc_application_tl eat where eab.application_id=eat.application_id and eat.language=xxen_util.bcp47_language(userenv('lang')) order by eat.application_name US A412F6DAE15B5127E053B46B635821CD ECC Data Set Y select edt.display_name value, edb.dataset_key||' ('||( select distinct listagg(eat.application_name,', ') within group (order by eat.application_name) over (partition by eadr.dataset_id) application from ecc.ecc_app_ds_relationships eadr, ecc.ecc_application_tl eat where edb.dataset_id=eadr.dataset_id and eadr.application_id=eat.application_id and eat.language=xxen_util.bcp47_language(userenv('lang')) )||')' description from ecc.ecc_dataset_b edb, ecc.ecc_dataset_tl edt where (:$flex$.ecc_application is null or edb.dataset_id in ( select eadr.dataset_id from ecc.ecc_application_tl eat, ecc.ecc_app_ds_relationships eadr where eat.application_name=:$flex$.ecc_application and eat.language=xxen_util.bcp47_language(userenv('lang')) and eat.application_id=eadr.application_id ) ) and edb.dataset_id=edt.dataset_id and edt.language=xxen_util.bcp47_language(userenv('lang')) order by edt.display_name US A412E32BBE565028E053B46B6358672D select ( select distinct listagg(eat.application_name,', ') within group (order by eat.application_name) over (partition by eadr.dataset_id) application from ecc.ecc_app_ds_relationships eadr, ecc.ecc_application_tl eat where edb.dataset_id=eadr.dataset_id and eadr.application_id=eat.application_id and eat.language=xxen_util.bcp47_language(userenv('lang')) ) application, edb.dataset_key data_set_key, edt.display_name data_set, edab.attribute_key, initcap(edab.attr_source_datatype) source_data_type, edab.attr_profile_key profile, edat.display_name, edat.custom_display_name, xxen_util.yes(edab.text_searchable_flag) text_searchable, xxen_util.yes(edab.dim_enable_refinements_flag) refinable, xxen_util.yes(edab.translation_flag) translatable, edab.select_type_code refinement_behavior, edab.ranking_type_code refinement_order, xxen_util.yes(edab.show_in_guided_discovery_flag) show_in_guided_discovery, xxen_util.yes(edab.show_record_counts_flag) show_record_count, edat.default_value from ecc.ecc_dataset_b edb, ecc.ecc_dataset_tl edt, ecc.ecc_dataset_attrs_b edab, ecc.ecc_dataset_attrs_tl edat where 1=1 and edb.dataset_id=edt.dataset_id and edt.language=xxen_util.bcp47_language(userenv('lang')) and edb.dataset_id=edab.dataset_id and edab.attribute_id=edat.attribute_id and edat.language=xxen_util.bcp47_language(userenv('lang')) order by edab.attribute_id Y AR ECC Admin - Metadata Attributes سمات البيانات الوصفية لمراكز قيادة المؤسسة D ECC Admin - Metadata Attributes Metadaten-Attribute des Enterprise Command Centers E ECC Admin - Metadata Attributes Atributos de los metadatos de los Centros de Mando Empresarial F ECC Admin - Metadata Attributes Attributs de métadonnées des centres de commandement d'entreprise I ECC Admin - Metadata Attributes Attributi dei metadati di Enterprise Command Centers JA ECC Admin - Metadata Attributes エンタープライズ コマンド センターのメタデータ属性 KO ECC Admin - Metadata Attributes Enterprise Command Centers 메타 데이터 속성 PTB ECC Admin - Metadata Attributes Atributos dos metadados dos Centros de Comando Empresarial RU ECC Admin - Metadata Attributes Атрибуты метаданных командных центров предприятия S ECC Admin - Metadata Attributes Metadataattribut för Enterprise Command Centers TR ECC Admin - Metadata Attributes Kurumsal Komuta Merkezleri meta veri özellikleri US ECC Admin - Metadata Attributes Enterprise Command Centers metadata attributes ZHS ECC Admin - Metadata Attributes 企业指挥中心元数据属性 Enginatics R12 only 1=1 1 10 1=1 edb.dataset_id in ( select eadr.dataset_id from ecc.ecc_application_tl eat, ecc.ecc_app_ds_relationships eadr where eat.application_name=:application_name and eat.language='en' and eat.application_id=eadr.application_id ) LOV ECC Application A412F6421530508AE053B46B6358EEE4 Y select eat.application_name value, eab.application_short_name description from ecc.ecc_application_b eab, ecc.ecc_application_tl eat where eab.application_id=eat.application_id and eat.language=xxen_util.bcp47_language(userenv('lang')) order by eat.application_name US Application 2 20 1=1 edt.display_name=:data_set LOV ECC Data Set A412F6DAE15B5127E053B46B635821CD Y select edt.display_name value, edb.dataset_key||' ('||( select distinct listagg(eat.application_name,', ') within group (order by eat.application_name) over (partition by eadr.dataset_id) application from ecc.ecc_app_ds_relationships eadr, ecc.ecc_application_tl eat where edb.dataset_id=eadr.dataset_id and eadr.application_id=eat.application_id and eat.language=xxen_util.bcp47_language(userenv('lang')) )||')' description from ecc.ecc_dataset_b edb, ecc.ecc_dataset_tl edt where (:$flex$.ecc_application is null or edb.dataset_id in ( select eadr.dataset_id from ecc.ecc_application_tl eat, ecc.ecc_app_ds_relationships eadr where eat.application_name=:$flex$.ecc_application and eat.language=xxen_util.bcp47_language(userenv('lang')) and eat.application_id=eadr.application_id ) ) and edb.dataset_id=edt.dataset_id and edt.language=xxen_util.bcp47_language(userenv('lang')) order by edt.display_name F Ensemble de données US Data Set 3 30 1=1 edab.attribute_key=:attribute_key LOV custom Y select edab.attribute_key value, edat.display_name||': '||edb.dataset_key||'('||( select distinct listagg(eat.application_name,', ') within group (order by eat.application_name) over (partition by eadr.dataset_id) application from ecc.ecc_app_ds_relationships eadr, ecc.ecc_application_tl eat where edb.dataset_id=eadr.dataset_id and eadr.application_id=eat.application_id and eat.language=xxen_util.bcp47_language(userenv('lang')) )||')' description from ecc.ecc_dataset_b edb, ecc.ecc_dataset_tl edt, ecc.ecc_dataset_attrs_b edab, ecc.ecc_dataset_attrs_tl edat where 1=1 and edb.dataset_id=edt.dataset_id and edt.language=xxen_util.bcp47_language(userenv('lang')) and edb.dataset_id=edab.dataset_id and edab.attribute_id=edat.attribute_id and edat.language=xxen_util.bcp47_language(userenv('lang')) order by edab.attribute_key F Clé d'attribut US Attribute Key :$flex$.ecc_application Application Data Set