VIEW: CN.CN_NOTIFY_LOG_ALL#

Source

View Text - Preformatted

select NOTIFY_LOG_ID NOTIFY_LOG_ID, NOTIFY_LOG_DATE NOTIFY_LOG_DATE, DELETE_DATE DELETE_DATE, EVENT_LOG_ID EVENT_LOG_ID, NOTIFY_NAME NOTIFY_NAME, NOTIFY_ACTION NOTIFY_ACTION, OBJECT_OWNER_ID OBJECT_OWNER_ID, OBJECT_ID OBJECT_ID, OBJECT_TYPE OBJECT_TYPE, OBJECT_NAME OBJECT_NAME, STATUS STATUS, PRIORITY PRIORITY, SALESREP_ID SALESREP_ID, PERIOD_ID PERIOD_ID, REVERT_STATE REVERT_STATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, ORG_ID ORG_ID, REVERT_SEQUENCE REVERT_SEQUENCE, START_DATE START_DATE, END_DATE END_DATE, QUOTA_ID QUOTA_ID, COMP_GROUP_ID COMP_GROUP_ID, ACTION ACTION, ACTION_LINK_ID ACTION_LINK_ID, BASE_SALESREP_ID BASE_SALESREP_ID, BASE_COMP_GROUP_ID BASE_COMP_GROUP_ID, PHYSICAL_BATCH_ID PHYSICAL_BATCH_ID, ROLE_ID ROLE_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID from "CN"."CN_NOTIFY_LOG_ALL"

View Text - HTML Formatted

SELECT NOTIFY_LOG_ID NOTIFY_LOG_ID
, NOTIFY_LOG_DATE NOTIFY_LOG_DATE
, DELETE_DATE DELETE_DATE
, EVENT_LOG_ID EVENT_LOG_ID
, NOTIFY_NAME NOTIFY_NAME
, NOTIFY_ACTION NOTIFY_ACTION
, OBJECT_OWNER_ID OBJECT_OWNER_ID
, OBJECT_ID OBJECT_ID
, OBJECT_TYPE OBJECT_TYPE
, OBJECT_NAME OBJECT_NAME
, STATUS STATUS
, PRIORITY PRIORITY
, SALESREP_ID SALESREP_ID
, PERIOD_ID PERIOD_ID
, REVERT_STATE REVERT_STATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, ORG_ID ORG_ID
, REVERT_SEQUENCE REVERT_SEQUENCE
, START_DATE START_DATE
, END_DATE END_DATE
, QUOTA_ID QUOTA_ID
, COMP_GROUP_ID COMP_GROUP_ID
, ACTION ACTION
, ACTION_LINK_ID ACTION_LINK_ID
, BASE_SALESREP_ID BASE_SALESREP_ID
, BASE_COMP_GROUP_ID BASE_COMP_GROUP_ID
, PHYSICAL_BATCH_ID PHYSICAL_BATCH_ID
, ROLE_ID ROLE_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "CN"."CN_NOTIFY_LOG_ALL"