ZSP_ODM_ATTRIBUTE_LIST_VL

Details

• Schema: FUSION

• Object owner: ZSP

• Object type: VIEW

Columns

Name
MODEL_INPUT_GUID MODEL_INPUT_DESC ACTIVE_FLAG EXTENDED_FLAG OTBI_EXTN_TABLE_NAME OTBI_EXTN_COLUMN_NAME ODM_TRAIN_ATTRIBUTE ATTR_DATA_TYPE

Query

SQL_Statement

select model_input.model_input_guid,model_input.model_input_desc, model_input.active_flag, model_input.extended_flag, model_input.otbi_extn_table_name, model_input.OTBI_EXTN_COLUMN_NAME, model_input.ODM_TRAIN_ATTRIBUTE, CASE WHEN MODEL_INPUT.otbi_extn_table_name is not null THEN (SELECT DATA_TYPE FROM all_tab_columns WHERE table_name = model_input.otbi_extn_table_name and column_name = model_input.otbi_extn_column_name ) ELSE (SELECT DATA_TYPE FROM all_tab_columns WHERE table_name = model_input.otbi_odm_view and column_name = model_input.odm_train_attribute ) END AS attr_data_type from zsp_model_inputs model_input where active_flag = 'Y'