DBA Data[Home] [Help]

VIEW: APPS.WF_DIRECTORY_PARTITIONS_VL

Source

View Text - Preformatted

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')