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

OKC_BUSINESS_EVENTS_VL

Details

  • Schema: FUSION

  • Object owner: OKC

  • Object type: VIEW

Columns

Name

ROW_ID

EVENT_ID

EVENT_CODE

BEFORE_AFTER

EVENT_NAME

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT

eventb.ROWID ROW_ID,

eventb.EVENT_ID event_id,

eventb.EVENT_CODE event_code,

eventb.BEFORE_AFTER before_after,

eventtl.EVENT_NAME event_name,

eventb.CREATED_BY created_by,

eventb.CREATION_DATE creation_date,

eventb.LAST_UPDATED_BY last_updated_by,

eventb.LAST_UPDATE_DATE last_update_date,

eventb.LAST_UPDATE_LOGIN last_update_login,

eventb.OBJECT_VERSION_NUMBER object_version_number

FROM

OKC_BUSINESS_EVENTS_B eventb,

OKC_BUSINESS_EVENTS_TL eventtl

WHERE

eventb.EVENT_ID = eventtl.EVENT_ID AND eventtl.LANGUAGE = USERENV('LANG')