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


TABLE: INV.MTL_MOBILE_LOGIN_HIST

Object Details
Object Name: MTL_MOBILE_LOGIN_HIST
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.MTL_MOBILE_LOGIN_HIST
Subobject Name:
Status: VALID


this table will store information about user logging history


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_MOBILE_LOGIN_HIST_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUSER_ID
Columns
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
Query Text

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;

Dependencies

[top of page]

INV.MTL_MOBILE_LOGIN_HIST does not reference any database object

INV.MTL_MOBILE_LOGIN_HIST is referenced by following:

SchemaAPPS
SynonymMTL_MOBILE_LOGIN_HIST