VIEW: APPS.OKS_INSTANCE_HISTORY_V

Source

View Text - Preformatted

SELECT INS.ROWID ROW_ID, INS.ID ID, INS.INSTANCE_ID INSTANCE_ID, INS.TRANSACTION_TYPE TRANSACTION_TYPE, INS.TRANSACTION_DATE TRANSACTION_DATE, INS.REFERENCE_NUMBER REFERENCE_NUMBER, INS.PARAMETERS PARAMETERS, INS.CREATED_BY CREATED_BY, INS.CREATION_DATE CREATION_DATE, INS.LAST_UPDATED_BY LAST_UPDATED_BY, INS.LAST_UPDATE_DATE LAST_UPDATE_DATE, INS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, INS.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, INS.SECURITY_GROUP_ID SECURITY_GROUP_ID FROM OKS_INSTANCE_HISTORY INS

View Text - HTML Formatted

SELECT INS.ROWID ROW_ID
, INS.ID ID
, INS.INSTANCE_ID INSTANCE_ID
, INS.TRANSACTION_TYPE TRANSACTION_TYPE
, INS.TRANSACTION_DATE TRANSACTION_DATE
, INS.REFERENCE_NUMBER REFERENCE_NUMBER
, INS.PARAMETERS PARAMETERS
, INS.CREATED_BY CREATED_BY
, INS.CREATION_DATE CREATION_DATE
, INS.LAST_UPDATED_BY LAST_UPDATED_BY
, INS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, INS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, INS.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, INS.SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM OKS_INSTANCE_HISTORY INS