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

TABLE: WSM.WSM_USER_DISPATCH_CONFIGS

Object Details
Object Name: WSM_USER_DISPATCH_CONFIGS
Object Type: TABLE
Owner: WSM
Subobject Name:
Status: VALID


This table stores User's Dispatch list contexts.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WSM_USER_DISPATCH_CONFIGS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnUSER_ID
Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER
Yes User Identifier
ORGANIZATION_ID NUMBER
Yes Organization Identifier
JOB_OP_TYPE VARCHAR2 (1)
Flag for indicating whether the current operations, completed operations, or scheduled and current operations should be shown
DEPARTMENT_ID NUMBER

Department Identifier
STANDARD_OP_ID NUMBER

Standard Operation Identifier
RESOURCE_ID NUMBER

Resource Identifier
INSTANCE_ID NUMBER

Resource Instance Identifier
SERIAL_NUMBER VARCHAR2 (30)
Serial Number of the Resource Instance
SCHEDULED_OP_DATE_FROM DATE

Scheduled operation start date based on which the dispatch list will be displayed
SCHEDULED_DAYS NUMBER

Number of days from the scheduled operation start date based on which the dispatch list will be displayed
SCHEDULED_TODAY_ONLY NUMBER

Flag to indicate whether the dispatch list should be displayed for today only when the current and scheduled operations are shown
SCHEDULED_OP_DURATION NUMBER

Duration for each day based on which the dispatch list is displayed when the current and scheduled operations are shown
ACTUAL_OP_DATE_FROM DATE

Actual operation start date based on which the dispatch list will be displayed
ACTUAL_DAYS NUMBER

Number of days from the actual operation start date based on which the dispatch list will be displayed
ACTUAL_TODAY_ONLY NUMBER

Flag to indicate whether the dispatch list should be displayed for today only when the current or completed operations are shown
ACTUAL_OP_DURATION NUMBER

Duration for each day based on which the dispatch list is displayed when the current or completed operations are shown
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when the row was last updated
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID)
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID)
CREATION_DATE DATE
Yes Standard Who column - date when the row was created
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID)
Query Text

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


SELECT USER_ID
,      ORGANIZATION_ID
,      JOB_OP_TYPE
,      DEPARTMENT_ID
,      STANDARD_OP_ID
,      RESOURCE_ID
,      INSTANCE_ID
,      SERIAL_NUMBER
,      SCHEDULED_OP_DATE_FROM
,      SCHEDULED_DAYS
,      SCHEDULED_TODAY_ONLY
,      SCHEDULED_OP_DURATION
,      ACTUAL_OP_DATE_FROM
,      ACTUAL_DAYS
,      ACTUAL_TODAY_ONLY
,      ACTUAL_OP_DURATION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
FROM WSM.WSM_USER_DISPATCH_CONFIGS;

Dependencies

[top of page]

WSM.WSM_USER_DISPATCH_CONFIGS does not reference any database object

WSM.WSM_USER_DISPATCH_CONFIGS is referenced by following:

SchemaAPPS
SynonymWSM_USER_DISPATCH_CONFIGS