[Home] [Help] [Dependency Information]
Object Name: | MTL_MOBILE_LOGIN_HIST |
---|---|
Object Type: | TABLE |
Owner: | INV |
FND Design Data: | INV.MTL_MOBILE_LOGIN_HIST |
Subobject Name: | |
Status: | VALID |
this table will store information about user logging history
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MTL_MOBILE_LOGIN_HIST_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | USER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
USER_ID | NUMBER | Yes | user id | |
LOGON_DATE | DATE | log on date by user | ||
LOGOFF_DATE | DATE | log off date | ||
SERVER_MACHINE_NAME | VARCHAR2 | (100) | server machine name: the one to which mobile user connects to | |
SERVER_PORT_NUMBER | NUMBER | server port number: the one at which mobile user connects to | ||
CLIENT_MACHINE_NAME | VARCHAR2 | (100) | client machine name: the one which mobile user connects from | |
CLIENT_PORT_NUMBER | NUMBER | client port number : the one which mobile user connects from | ||
EVENT_MESSAGE | VARCHAR2 | (50) | log off message |
Cut, paste (and edit) the following text to query this object:
SELECT USER_ID
, LOGON_DATE
, LOGOFF_DATE
, SERVER_MACHINE_NAME
, SERVER_PORT_NUMBER
, CLIENT_MACHINE_NAME
, CLIENT_PORT_NUMBER
, EVENT_MESSAGE
FROM INV.MTL_MOBILE_LOGIN_HIST;
INV.MTL_MOBILE_LOGIN_HIST does not reference any database object
INV.MTL_MOBILE_LOGIN_HIST is referenced by following:
|
|
|