Product: | OKS - Service Contracts |
---|---|
Description: | View on top oks_interaction_history |
Implementation/DBA Data: | APPS.OKS_INTERACTION_HIST_V |
SELECT INH.ROWID ROW_ID
, INH.ID ID
, INH.CHR_ID CHR_ID
, INH.CONTRACT_NUMBER CONTRACT_NUMBER
, INH.CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, INH.RENEWAL_STATUS RENEWAL_STATUS
, INH.PARTY_ID PARTY_ID
, INH.USER_ID USER_ID
, INH.DESCRIPTION DESCRIPTION
, INH.STATUS STATUS
, INH.TASK_NAME TASK_NAME
, INH.TASK_RESULT TASK_RESULT
, INH.CREATION_DATE CREATION_DATE
, INH.CREATED_BY CREATED_BY
, INH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, INH.LAST_UPDATED_BY LAST_UPDATED_BY
, INH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, INH.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM OKS_INTERACTION_HISTORY INH