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]

TABLE: ASG.ASG_USER

Object Details

Object Name:	ASG_USER
Object Type:	TABLE
Owner:	ASG
Subobject Name:
Status:	VALID

Stores the mobile users.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ASG_USER_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RESOURCE_ID
ASG_USER_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	USER_ID
ASG_USER_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	USER_NAME
ASG_USER_U4	NORMAL	UNIQUE	APPS_TS_TX_IDX	CLIENT_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
RESOURCE_ID	NUMBER		Yes	Resource id of the User
USER_ID	NUMBER		Yes	User id.
USER_NAME	VARCHAR2	(30)	Yes	User name.
CLIENT_NUMBER	NUMBER		Yes	Client num.
ENABLED	VARCHAR2	(1)		Enabled flag.
LANGUAGE	VARCHAR2	(4)		Language.
ORG_ID	NUMBER			Organization identifier
LAST_SYNCH_MODE	NUMBER			Last synch mode.
LAST_SYNCH_DATE_START	DATE			Last synch date start.
LAST_SYNCH_DATE_END	DATE			Last synch date end.
ONAIR_FLAG	VARCHAR2	(1)		Onair flag.
COOKIE	VARCHAR2	(240)		Cookie.
LAST_WIRELESS_CONTACT_DATE	DATE			Last wireless contact date.
NEW_DATA_FLAG	VARCHAR2	(1)		New data flag.
NEW_DATA_DATE	DATE			New data date.
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
SECURITY_GROUP_ID	NUMBER			Security group id.
HWM_TRANID	NUMBER			HWM_TRANID.
LAST_TRANID	NUMBER			LAST_TRANID.
PRIOR_SYNCH_DATE_END	DATE			Prior Synch Date.
USER_SETUP_ERRORS	VARCHAR2	(4000)		User setup error.
SYNCH_ERRORS	VARCHAR2	(2000)		Synch Error.
UPGRADE_FLAG	VARCHAR2	(1)		Upgrade Flag
UPGRADE_DATE	DATE			Upgrade Date
CURRENT_DEVICE	VARCHAR2	(30)		Upgrade Device
DISABLE_USER_SYNCH	VARCHAR2	(1)		Disable User Sync
DISABLE_SYNCH_ERROR	VARCHAR2	(2000)		Disable Sync error
APP_ID	NUMBER			application id
RESPONSIBILITY_ID	NUMBER			responsibility id
PASSWORD_EXPIRED	VARCHAR2	(1)		password expired
MIGRATION_COMPLETED	VARCHAR2	(1)		Migration completed info
MIGRATION_COMPLETED_DATE	DATE			Migration Completed Date
MIGRATION_COMPLETION_VERSION	NUMBER			Migration Completion Version
GROUP_ID	NUMBER			Will have the groupid of the group to which the User belongs.
OWNER_ID	NUMBER			Will have the Owner id of the group to which the User belongs.
ROLE_ID	NUMBER			Will have the Role id of the User.

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
FROM ASG.ASG_USER;

Dependencies

[top of page]

ASG.ASG_USER does not reference any database object

ASG.ASG_USER is referenced by following:

APPS: ASG_USER