Skip to content FND Design Data [Home] [Help]

View: OKC_RISK_EVENTS_VL

Product: OKC - Contracts Core
Description: VL view on OKC_RISK_EVENTS_B and OKC_RISK_EVENTS_TL tables.
Implementation/DBA Data: ViewAPPS.OKC_RISK_EVENTS_VL
View Text

SELECT REVB.ROWID
, REVB.RISK_EVENT_ID
, REVTL.NAME
, REVTL.DESCRIPTION
, REVB.START_DATE
, REVB.END_DATE
, REVB.OBJECT_VERSION_NUMBER
, REVB.CREATED_BY
, REVB.CREATION_DATE
, REVB.LAST_UPDATED_BY
, REVB.LAST_UPDATE_DATE
, REVB.LAST_UPDATE_LOGIN
FROM OKC_RISK_EVENTS_B REVB
, OKC_RISK_EVENTS_TL REVTL
WHERE REVB.RISK_EVENT_ID = REVTL.RISK_EVENT_ID
AND REVTL.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
RISK_EVENT_ID
NAME
DESCRIPTION
START_DATE
END_DATE
OBJECT_VERSION_NUMBER
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN