SELECT B.ROWID ROW_ID, B.PARTITION_ID, B.ORIG_SYSTEM, T.DISPLAY_NAME from WF_DIRECTORY_PARTITIONS_TL T, WF_DIRECTORY_PARTITIONS B WHERE B.ORIG_SYSTEM = T.ORIG_SYSTEM and T.LANGUAGE = userenv('LANG')
View Text - HTML Formatted
SELECT B.ROWID ROW_ID , B.PARTITION_ID , B.ORIG_SYSTEM , T.DISPLAY_NAME FROM WF_DIRECTORY_PARTITIONS_TL T , WF_DIRECTORY_PARTITIONS B WHERE B.ORIG_SYSTEM = T.ORIG_SYSTEM AND T.LANGUAGE = USERENV('LANG')