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

TABLE: WMS.WMS_ELS_RESOURCE_SETUP

Object Details
Object Name: WMS_ELS_RESOURCE_SETUP
Object Type: TABLE
Owner: WMS
FND Design Data: TableWMS.WMS_ELS_RESOURCE_SETUP
Subobject Name:
Status: VALID


This table will hold the resource setup informnation for different activity and activity details for a labor management enabled warehouse.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WMS_ELS_RESOURCE_SETUP_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnWMS_ELS_RESOURCE_SETUP_ID
WMS_ELS_RESOURCE_SETUP_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnELS_PARAMETER_ID
ColumnACTIVITY_ID
ColumnACTIVITY_DETAIL_ID
Columns
Name Datatype Length Mandatory Comments
WMS_ELS_RESOURCE_SETUP_ID NUMBER
Yes Unique Identifier for the table
ELS_PARAMETER_ID NUMBER
Yes Foreign Key for WMS_ELS_PARAMETER.ELS_PARAMETER_ID.
ACTIVITY_ID NUMBER

Activity
ACTIVITY_DETAIL_ID NUMBER

Activity Detail
NUMBER_OF_RESOURCES NUMBER

Number of resources available for activity and activity detail.
LAST_UPDATE_DATE DATE
Yes Standard WHO Column.
LAST_UPDATED_BY NUMBER
Yes Standard WHO Column.
LAST_UPDATE_LOGIN NUMBER

Standard WHO Column.
CREATED_BY NUMBER
Yes Standard WHO Column.
CREATION_DATE DATE
Yes Standard WHO Column.
Query Text

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


SELECT WMS_ELS_RESOURCE_SETUP_ID
,      ELS_PARAMETER_ID
,      ACTIVITY_ID
,      ACTIVITY_DETAIL_ID
,      NUMBER_OF_RESOURCES
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM WMS.WMS_ELS_RESOURCE_SETUP;

Dependencies

[top of page]

WMS.WMS_ELS_RESOURCE_SETUP does not reference any database object

WMS.WMS_ELS_RESOURCE_SETUP is referenced by following:

SchemaWMS
ViewWMS_ELS_RESOURCE_SETUP#