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

TABLE: WSH.WSH_ITM_USER_SETUPS

Object Details
Object Name: WSH_ITM_USER_SETUPS
Object Type: TABLE
Owner: WSH
FND Design Data: TableWSH.WSH_ITM_USER_SETUPS
Subobject Name:
Status: VALID


Stores the login information of different partner ITM Applications. We allow registration at mutiple levels. A company may choose to have single login for entire company, or a separate login for each of its organizations or a separate login for each user.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ITM_USER_SEQUENCE_ID NUMBER
Yes Primary Key
VENDOR_ID NUMBER
Yes Foreign Key to WSH_ITM_VENDORS.VENDOR_ID
APPLICATION_ID NUMBER (15) Yes Application ID
MASTER_ORGANIZATION_ID NUMBER (15)
Master Organization identifier of the Calling User
ORGANIZATION_ID NUMBER (15)
Organization identifier of the Calling User
APPLICATION_USER_ID NUMBER (15)
Application User identifier of the Calling User
USER_ID VARCHAR2 (35) Yes User Id provided by partner ITM Application.
ENCRYPTED_USER_PASSWORD VARCHAR2 (100) Yes Password provided by the partner ITM Application
LAST_UPDATE_DATE VARCHAR2 (240)
Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
Query Text

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


SELECT ITM_USER_SEQUENCE_ID
,      VENDOR_ID
,      APPLICATION_ID
,      MASTER_ORGANIZATION_ID
,      ORGANIZATION_ID
,      APPLICATION_USER_ID
,      USER_ID
,      ENCRYPTED_USER_PASSWORD
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM WSH.WSH_ITM_USER_SETUPS;

Dependencies

[top of page]

WSH.WSH_ITM_USER_SETUPS does not reference any database object

WSH.WSH_ITM_USER_SETUPS is referenced by following:

SchemaAPPS
SynonymWSH_ITM_USER_SETUPS