SELECT B.ROWID ROW_ID ,B.NOTIFICATION_ID ,T.NOTIFICATION_MESSAGE ,B.COLLABORATION_POINT ,B.NOTIFICATION_CODE ,B.CREATION_DATE ,B.CREATED_BY ,B.LAST_UPDATE_DATE ,B.LAST_UPDATED_BY ,B.LAST_UPDATE_LOGIN FROM CLN_NOTIFICATION_CODES_B B, CLN_NOTIFICATION_CODES_TL T WHERE B.NOTIFICATION_ID = T.NOTIFICATION_ID AND T.LANGUAGE = userenv('LANG')
SELECT B.ROWID ROW_ID
, B.NOTIFICATION_ID
, T.NOTIFICATION_MESSAGE
, B.COLLABORATION_POINT
, B.NOTIFICATION_CODE
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
FROM CLN_NOTIFICATION_CODES_B B
, CLN_NOTIFICATION_CODES_TL T
WHERE B.NOTIFICATION_ID = T.NOTIFICATION_ID
AND T.LANGUAGE = USERENV('LANG')
|
|
|