[Home] [Help]
View: OTA_CHATS_VL
Product: | OTA - Learning Management |
Description: | |
Implementation/DBA Data: |
APPS.OTA_CHATS_VL
|
View Text
SELECT CHB.ROWID
, CHB.CHAT_ID
, CHB.BUSINESS_GROUP_ID
, CHT.NAME
, CHT.DESCRIPTION
, CHB.START_DATE_ACTIVE
, CHB.END_DATE_ACTIVE
, CHB.PUBLIC_FLAG
, CHB.OBJECT_VERSION_NUMBER
, CHT.CREATED_BY
, CHT.CREATION_DATE
, CHT.LAST_UPDATE_DATE
, CHT.LAST_UPDATED_BY
, CHT.LAST_UPDATE_LOGIN
FROM OTA_CHATS_B CHB
, OTA_CHATS_TL CHT
WHERE CHB.CHAT_ID = CHT.CHAT_ID
AND CHT.LANGUAGE = USERENV('LANG')
Columns
Name |
ROW_ID |
CHAT_ID |
BUSINESS_GROUP_ID |
NAME |
DESCRIPTION |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
PUBLIC_FLAG |
OBJECT_VERSION_NUMBER |
CREATED_BY |
CREATION_DATE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |