View: GHR_EVENT_HISTORY_V

Product:	GHR - US Federal Human Resources
Description:	This view is based GHR_EVENT_HISTORY table.
Implementation/DBA Data:	APPS.GHR_EVENT_HISTORY_V

View Text

SELECT EHIS.EVENT_HISTORY_ID
, EHIS.EVENT_ID
, EHIS.TABLE_NAME
, EHIS.RECORD_ID
, EHIS.START_DATE
, EHIS.END_DATE
, EHIS.COMMENTS
, EVE.CODE
, EVE.DESCRIPTION
, EVE.CATEGORY_CODE
, EVE.START_DATE_DESC
, EVE.END_DATE_DESC
, EVE.STD_COMPLETION_TIME
, EHIS.OBJECT_VERSION_NUMBER
, EHIS.CREATED_BY
, EHIS.CREATION_DATE
, EHIS.LAST_UPDATED_BY
, EHIS.LAST_UPDATE_DATE
, EHIS.LAST_UPDATE_LOGIN
FROM GHR_EVENTS EVE
, GHR_EVENT_HISTORY EHIS
WHERE EVE.EVENT_ID = EHIS.EVENT_ID

Columns