HWR_WLNS_NEWS_VL

Details

• Schema: FUSION

• Object owner: HWR

• Object type: VIEW

Columns

Name
NEWS_ID NEWS_TITLE NEWS_DESC START_DATE END_DATE NEWS_LINK NEWS_IMAGE ORDER_RANK IS_DELETED CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement
SELECT B.NEWS_ID, T.NEWS_TITLE, T.NEWS_DESC, B.START_DATE, B.END_DATE, B.NEWS_LINK, B.NEWS_IMAGE, B.ORDER_RANK, B.IS_DELETED, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN FROM HWR_WLNS_NEWS_B B, HWR_WLNS_NEWS_TL T WHERE B.NEWS_ID = T.NEWS_ID AND T.LANGUAGE = USERENV('LANG')