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: APPS.ASG_USER_VERSIONS

Object Details

Object Name:	ASG_USER_VERSIONS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ASG.ASG_USER_VERSIONS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Mobile user information.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DEVICE_USER_ID	NUMBER		Yes	Mobile user identifier.
CLIENT_NAME	VARCHAR2	(30)	Yes	Mobile user name.
MOBILE_APPLICATION_ID	NUMBER		Yes	Mobile user application identifier.
USER_ID	NUMBER		Yes	User identifier.
RESOURCE_ID	NUMBER		Yes	Resource identifier.
SERVER_ID	NUMBER		Yes	Mobile Gateway Server identifier.
SNAP_DATABASE	VARCHAR2	(240)	Yes	The middler tier database global name.
RELEASE_VERSION	NUMBER			Release version.
COMPATIBLE_VERSION	NUMBER			Compatible version.

Query Text

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


SELECT DEVICE_USER_ID
,      CLIENT_NAME
,      MOBILE_APPLICATION_ID
,      USER_ID
,      RESOURCE_ID
,      SERVER_ID
,      SNAP_DATABASE
,      RELEASE_VERSION
,      COMPATIBLE_VERSION
FROM APPS.ASG_USER_VERSIONS;

Dependencies

[top of page]

APPS.ASG_USER_VERSIONS references the following:

APPS: ASG_APPLICATIONS_B; ASG_DEVICE_USERS; ASG_PUBLICATIONS; ASG_SERVER_PUBS; ASG_SYNCH_SERVER

APPS.ASG_USER_VERSIONS is not referenced by any database object