VIEW: ASG.ASG_USER#

Source

View Text - Preformatted

select RESOURCE_ID RESOURCE_ID, USER_ID USER_ID, USER_NAME USER_NAME, CLIENT_NUMBER CLIENT_NUMBER, ENABLED ENABLED, LANGUAGE LANGUAGE, ORG_ID ORG_ID, LAST_SYNCH_MODE LAST_SYNCH_MODE, LAST_SYNCH_DATE_START LAST_SYNCH_DATE_START, LAST_SYNCH_DATE_END LAST_SYNCH_DATE_END, ONAIR_FLAG ONAIR_FLAG, COOKIE COOKIE, LAST_WIRELESS_CONTACT_DATE LAST_WIRELESS_CONTACT_DATE, NEW_DATA_FLAG NEW_DATA_FLAG, NEW_DATA_DATE NEW_DATA_DATE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, SECURITY_GROUP_ID SECURITY_GROUP_ID, HWM_TRANID HWM_TRANID, LAST_TRANID LAST_TRANID, PRIOR_SYNCH_DATE_END PRIOR_SYNCH_DATE_END, USER_SETUP_ERRORS USER_SETUP_ERRORS, SYNCH_ERRORS SYNCH_ERRORS, UPGRADE_FLAG UPGRADE_FLAG, UPGRADE_DATE UPGRADE_DATE, CURRENT_DEVICE CURRENT_DEVICE, DISABLE_USER_SYNCH DISABLE_USER_SYNCH, DISABLE_SYNCH_ERROR DISABLE_SYNCH_ERROR, APP_ID APP_ID, RESPONSIBILITY_ID RESPONSIBILITY_ID, PASSWORD_EXPIRED PASSWORD_EXPIRED, MIGRATION_COMPLETED MIGRATION_COMPLETED, MIGRATION_COMPLETED_DATE MIGRATION_COMPLETED_DATE, MIGRATION_COMPLETION_VERSION MIGRATION_COMPLETION_VERSION, GROUP_ID GROUP_ID, OWNER_ID OWNER_ID, ROLE_ID ROLE_ID, MULTI_PLATFORM MULTI_PLATFORM, HTML5_ENCRYPT HTML5_ENCRYPT from "ASG"."ASG_USER"

View Text - HTML Formatted

SELECT RESOURCE_ID RESOURCE_ID
, USER_ID USER_ID
, USER_NAME USER_NAME
, CLIENT_NUMBER CLIENT_NUMBER
, ENABLED ENABLED
, LANGUAGE LANGUAGE
, ORG_ID ORG_ID
, LAST_SYNCH_MODE LAST_SYNCH_MODE
, LAST_SYNCH_DATE_START LAST_SYNCH_DATE_START
, LAST_SYNCH_DATE_END LAST_SYNCH_DATE_END
, ONAIR_FLAG ONAIR_FLAG
, COOKIE COOKIE
, LAST_WIRELESS_CONTACT_DATE LAST_WIRELESS_CONTACT_DATE
, NEW_DATA_FLAG NEW_DATA_FLAG
, NEW_DATA_DATE NEW_DATA_DATE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, HWM_TRANID HWM_TRANID
, LAST_TRANID LAST_TRANID
, PRIOR_SYNCH_DATE_END PRIOR_SYNCH_DATE_END
, USER_SETUP_ERRORS USER_SETUP_ERRORS
, SYNCH_ERRORS SYNCH_ERRORS
, UPGRADE_FLAG UPGRADE_FLAG
, UPGRADE_DATE UPGRADE_DATE
, CURRENT_DEVICE CURRENT_DEVICE
, DISABLE_USER_SYNCH DISABLE_USER_SYNCH
, DISABLE_SYNCH_ERROR DISABLE_SYNCH_ERROR
, APP_ID APP_ID
, RESPONSIBILITY_ID RESPONSIBILITY_ID
, PASSWORD_EXPIRED PASSWORD_EXPIRED
, MIGRATION_COMPLETED MIGRATION_COMPLETED
, MIGRATION_COMPLETED_DATE MIGRATION_COMPLETED_DATE
, MIGRATION_COMPLETION_VERSION MIGRATION_COMPLETION_VERSION
, GROUP_ID GROUP_ID
, OWNER_ID OWNER_ID
, ROLE_ID ROLE_ID
, MULTI_PLATFORM MULTI_PLATFORM
, HTML5_ENCRYPT HTML5_ENCRYPT
FROM "ASG"."ASG_USER"