VIEW: APPS.HR_KI_TOPICS_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID ,B.TOPIC_ID ,B.TOPIC_KEY ,B.HANDLER ,T.NAME ,B.LAST_UPDATE_DATE ,B.LAST_UPDATED_BY ,B.LAST_UPDATE_LOGIN ,B.CREATED_BY ,B.CREATION_DATE ,B.OBJECT_VERSION_NUMBER FROM HR_KI_TOPICS B, HR_KI_TOPICS_TL T WHERE B.TOPIC_ID = T.TOPIC_ID AND T.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.TOPIC_ID
, B.TOPIC_KEY
, B.HANDLER
, T.NAME
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATED_BY
, B.CREATION_DATE
, B.OBJECT_VERSION_NUMBER
FROM HR_KI_TOPICS B
, HR_KI_TOPICS_TL T
WHERE B.TOPIC_ID = T.TOPIC_ID
AND T.LANGUAGE = USERENV('LANG')