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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ASG_USER_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESOURCE_ID
ASG_USER_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnUSER_ID
ASG_USER_U3 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnUSER_NAME
ASG_USER_U4 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCLIENT_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 (100) 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.
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 does not reference any database object

ASG.ASG_USER is referenced by following:

SchemaASG
ViewASG_USER#