select
B.ROWID ROW_ID,
B.COLLAB_ID,
B.TASK_ID,
B.MEETING_MODE,
B.MEETING_ID,
B.MEETING_URL,
B.JOIN_URL,
B.PLAYBACK_URL,
B.DOWNLOAD_URL,
B.CHAT_URL,
B.IS_STANDALONE_LOCATION,
B.CREATED_BY,
B.CREATION_DATE,
B.LAST_UPDATED_BY,
B.LAST_UPDATE_DATE,
B.LAST_UPDATE_LOGIN,
T.LOCATION,
T.DIAL_IN
from CAC_VIEW_COLLAB_DETAILS_TL T, CAC_VIEW_COLLAB_DETAILS B
where B.COLLAB_ID = T.COLLAB_ID
and T.LANGUAGE = userenv('LANG')
SELECT
B.ROWID ROW_ID
,
B.COLLAB_ID
,
B.TASK_ID
,
B.MEETING_MODE
,
B.MEETING_ID
,
B.MEETING_URL
,
B.JOIN_URL
,
B.PLAYBACK_URL
,
B.DOWNLOAD_URL
,
B.CHAT_URL
,
B.IS_STANDALONE_LOCATION
,
B.CREATED_BY
,
B.CREATION_DATE
,
B.LAST_UPDATED_BY
,
B.LAST_UPDATE_DATE
,
B.LAST_UPDATE_LOGIN
,
T.LOCATION
,
T.DIAL_IN
FROM CAC_VIEW_COLLAB_DETAILS_TL T
, CAC_VIEW_COLLAB_DETAILS B
WHERE B.COLLAB_ID = T.COLLAB_ID
AND T.LANGUAGE = USERENV('LANG')
|
|
|