VIEW: AMV.AMV_U_ACCESS#

Source

View Text - Preformatted

select ACCESS_ID ACCESS_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, 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, ACCESS_TO_TABLE_CODE ACCESS_TO_TABLE_CODE, ACCESS_TO_TABLE_RECORD_ID ACCESS_TO_TABLE_RECORD_ID, USER_OR_GROUP_ID USER_OR_GROUP_ID, USER_OR_GROUP_TYPE USER_OR_GROUP_TYPE, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EXPIRATION_DATE EXPIRATION_DATE, CAN_VIEW_FLAG CAN_VIEW_FLAG, CAN_CREATE_FLAG CAN_CREATE_FLAG, CAN_DELETE_FLAG CAN_DELETE_FLAG, CAN_UPDATE_FLAG CAN_UPDATE_FLAG, CAN_CREATE_DIST_RULE_FLAG CAN_CREATE_DIST_RULE_FLAG, CHL_APPROVER_FLAG CHL_APPROVER_FLAG, CHL_REQUIRED_FLAG CHL_REQUIRED_FLAG, CHL_REQUIRED_NEED_NOTIF_FLAG CHL_REQUIRED_NEED_NOTIF_FLAG, SECURITY_GROUP_ID SECURITY_GROUP_ID from "AMV"."AMV_U_ACCESS"

View Text - HTML Formatted

SELECT ACCESS_ID ACCESS_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, 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
, ACCESS_TO_TABLE_CODE ACCESS_TO_TABLE_CODE
, ACCESS_TO_TABLE_RECORD_ID ACCESS_TO_TABLE_RECORD_ID
, USER_OR_GROUP_ID USER_OR_GROUP_ID
, USER_OR_GROUP_TYPE USER_OR_GROUP_TYPE
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EXPIRATION_DATE EXPIRATION_DATE
, CAN_VIEW_FLAG CAN_VIEW_FLAG
, CAN_CREATE_FLAG CAN_CREATE_FLAG
, CAN_DELETE_FLAG CAN_DELETE_FLAG
, CAN_UPDATE_FLAG CAN_UPDATE_FLAG
, CAN_CREATE_DIST_RULE_FLAG CAN_CREATE_DIST_RULE_FLAG
, CHL_APPROVER_FLAG CHL_APPROVER_FLAG
, CHL_REQUIRED_FLAG CHL_REQUIRED_FLAG
, CHL_REQUIRED_NEED_NOTIF_FLAG CHL_REQUIRED_NEED_NOTIF_FLAG
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "AMV"."AMV_U_ACCESS"