[Home] [Help]
View: WF_WL_REGIONS_VL
View Text
SELECT B.ROWID ROW_ID
, B.REGION_ID
, B.REGION_KEY
, B.CONTENT_TYPE
, B.REGION
, B.SEQUENCE
, B.MESSAGE_TYPE
, B.MESSAGE_NAME
, B.IS_SEEDED
, B.CUSTOMIZATION_LEVEL
, B.STATUS
,
T.TITLE
, T.DESCRIPTION
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.SECURITY_GROUP_ID
FROM WF_WL_REGIONS B
, WF_WL_REGIONS_TL T
WHERE B.REGION_ID = T.REGION_ID
AND T.LANGUAGE = USERENV('LANG')