eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: ASG.ASG_USER#

Object Details

Object Name:	ASG_USER#
Object Type:	VIEW
Owner:	ASG
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
RESOURCE_ID	NUMBER		Yes
USER_ID	NUMBER		Yes
USER_NAME	VARCHAR2	(100)	Yes
CLIENT_NUMBER	NUMBER		Yes
ENABLED	VARCHAR2	(1)
LANGUAGE	VARCHAR2	(4)
ORG_ID	NUMBER
LAST_SYNCH_MODE	NUMBER
LAST_SYNCH_DATE_START	DATE
LAST_SYNCH_DATE_END	DATE
ONAIR_FLAG	VARCHAR2	(1)
COOKIE	VARCHAR2	(240)
LAST_WIRELESS_CONTACT_DATE	DATE
NEW_DATA_FLAG	VARCHAR2	(1)
NEW_DATA_DATE	DATE
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
SECURITY_GROUP_ID	NUMBER
HWM_TRANID	NUMBER
LAST_TRANID	NUMBER
PRIOR_SYNCH_DATE_END	DATE
USER_SETUP_ERRORS	VARCHAR2	(4000)
SYNCH_ERRORS	VARCHAR2	(2000)
UPGRADE_FLAG	VARCHAR2	(1)
UPGRADE_DATE	DATE
CURRENT_DEVICE	VARCHAR2	(30)
DISABLE_USER_SYNCH	VARCHAR2	(1)
DISABLE_SYNCH_ERROR	VARCHAR2	(2000)
APP_ID	NUMBER
RESPONSIBILITY_ID	NUMBER
PASSWORD_EXPIRED	VARCHAR2	(1)
MIGRATION_COMPLETED	VARCHAR2	(1)
MIGRATION_COMPLETED_DATE	DATE
MIGRATION_COMPLETION_VERSION	NUMBER
GROUP_ID	NUMBER
OWNER_ID	NUMBER
ROLE_ID	NUMBER
MULTI_PLATFORM	VARCHAR2	(1)
HTML5_ENCRYPT	VARCHAR2	(1)

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

ASG.ASG_USER# references the following:

ASG: ASG_USER

ASG.ASG_USER# is referenced by following:

APPS: ASG_USER