1. Tables and Views for Sales and Fusion Service
  2. OKC_RISK_EVENTS_VL

OKC_RISK_EVENTS_VL

Details

  • Schema: FUSION

  • Object owner: OKC

  • Object type: VIEW

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

Query

SQL_Statement

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')