SELECT t.table_name, t.display_name, c.table_classification_code FROM fem_tables_v t, fem_table_class_assignmt c WHERE c.table_name = t.table_name AND c.enabled_flag = 'Y'
View Text - HTML Formatted
SELECT T.TABLE_NAME , T.DISPLAY_NAME , C.TABLE_CLASSIFICATION_CODE FROM FEM_TABLES_V T , FEM_TABLE_CLASS_ASSIGNMT C WHERE C.TABLE_NAME = T.TABLE_NAME AND C.ENABLED_FLAG = 'Y'