VIEW: OKS.OKS_INTERACTION_HISTORY#

Source

View Text - Preformatted

select ID ID, CHR_ID CHR_ID, CONTRACT_NUMBER CONTRACT_NUMBER, CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER, RENEWAL_STATUS RENEWAL_STATUS, PARTY_ID PARTY_ID, USER_ID USER_ID, DESCRIPTION DESCRIPTION, STATUS STATUS, TASK_NAME TASK_NAME, TASK_RESULT TASK_RESULT, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "OKS"."OKS_INTERACTION_HISTORY"

View Text - HTML Formatted

SELECT ID ID
, CHR_ID CHR_ID
, CONTRACT_NUMBER CONTRACT_NUMBER
, CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, RENEWAL_STATUS RENEWAL_STATUS
, PARTY_ID PARTY_ID
, USER_ID USER_ID
, DESCRIPTION DESCRIPTION
, STATUS STATUS
, TASK_NAME TASK_NAME
, TASK_RESULT TASK_RESULT
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "OKS"."OKS_INTERACTION_HISTORY"