DBA Data[Home] [Help]

VIEW: APPS.CAC_VIEW_COLLAB_DETAILS_VL

Source

View Text - Preformatted

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

   
View Text - HTML Formatted

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