ZSF_DS_PARTICIPANT_RF_DN_VIEW

Details

• Schema: FUSION

• Object owner: ZSF

• Object type: VIEW

Columns

Name
METRIC_DIM_DN_ID METRIC_DIM_CODE METRIC_DIM_KEY METRIC_DIM_PARENT_KEY DIM_PATH DIM_LEVEL ROOT_PARENT_FLAG OWNER_RESOURCE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE METRIC_DIM_NAME METRIC_DIM_PARENT_NAME

Query

SQL_Statement

select metric_dim_dn_id , metric_dim_code , metric_dim_key , metric_dim_parent_key , dim_path , dim_level , root_parent_flag , owner_resource_id , created_by , creation_date , last_updated_by , last_update_date , last_update_login , object_version_number , request_id , job_definition_name , job_definition_package , metric_dim_name , metric_dim_parent_name from zsf_ds_metric_dim_rf_dn where metric_dim_code = ( SELECT metric_dim1_code FROM zsf_ds_param p , zsf_ds_metric_src s WHERE p.param_name = 'ACTIVE_METRIC_SOURCE' and s.metric_src_code = p.param_value and rownum = 1 )