VIEW: APPS.OKC_BUS_DOC_EVENTS_V

Source

View Text - Preformatted

SELECT devb.rowid ROW_ID, devb.bus_doc_event_id bus_doc_event_id, devb.business_event_code BUSINESS_EVENT_CODE, devb.bus_doc_type bus_doc_type, devb.before_after before_after, devb.start_end_qualifier start_end_qualifier, devt.meaning EVENT_NAME, devb.created_by created_by, devb.creation_date creation_date, devb.last_updated_by last_updated_by, devb.last_update_date last_update_date, devb.last_update_login last_update_login, devb.object_version_number object_version_number FROM OKC_BUS_DOC_EVENTS_B DEVB,OKC_BUS_DOC_EVENTS_TL DEVT WHERE devb.bus_doc_event_id = devt.bus_doc_event_id and devt.language = USERENV('LANG')

View Text - HTML Formatted

SELECT DEVB.ROWID ROW_ID
, DEVB.BUS_DOC_EVENT_ID BUS_DOC_EVENT_ID
, DEVB.BUSINESS_EVENT_CODE BUSINESS_EVENT_CODE
, DEVB.BUS_DOC_TYPE BUS_DOC_TYPE
, DEVB.BEFORE_AFTER BEFORE_AFTER
, DEVB.START_END_QUALIFIER START_END_QUALIFIER
, DEVT.MEANING EVENT_NAME
, DEVB.CREATED_BY CREATED_BY
, DEVB.CREATION_DATE CREATION_DATE
, DEVB.LAST_UPDATED_BY LAST_UPDATED_BY
, DEVB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DEVB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DEVB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM OKC_BUS_DOC_EVENTS_B DEVB
, OKC_BUS_DOC_EVENTS_TL DEVT
WHERE DEVB.BUS_DOC_EVENT_ID = DEVT.BUS_DOC_EVENT_ID
AND DEVT.LANGUAGE = USERENV('LANG')