[Home] [Help] [Dependency Information]
Object Name: | WMS_ELS_RATINGS_SETUP |
---|---|
Object Type: | TABLE |
Owner: | WMS |
FND Design Data: | WMS.WMS_ELS_RATINGS_SETUP |
Subobject Name: | |
Status: | VALID |
This table will hold the ratings setup informnation for a labor management enabled warehouse.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WMS_ELS_RATINGS_SETUP_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ELS_RATINGS_SETUP_ID |
WMS_ELS_RATINGS_SETUP_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ELS_PARAMETER_ID |
WMS_ELS_RATINGS_SETUP_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RATING_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ELS_RATINGS_SETUP_ID | NUMBER | Yes | Unique Identifier for the table | |
ELS_PARAMETER_ID | NUMBER | Yes | Foreign Key for WMS_ELS_PARAMETER.ELS_PARAMETER_ID. | |
LABOR_RATING | NUMBER | What is the Labor Rating. The values are coming from lookup WMS_LABOR_RATINGS. | ||
PER_EXPECTED_TIME_FROM | NUMBER | From value for the percentage of expected time. | ||
PER_EXPECTED_TIME_TO | NUMBER | To value for the percentage of expected time. | ||
PER_SCORE | NUMBER | Score for this rating. | ||
RATING_TYPE | VARCHAR2 | (3) | Time component for this rating type.' IDL' (for Idle Time),' TXN ' (for Transaction time) and 'TRA' (for Travel Time). | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT ELS_RATINGS_SETUP_ID
, ELS_PARAMETER_ID
, LABOR_RATING
, PER_EXPECTED_TIME_FROM
, PER_EXPECTED_TIME_TO
, PER_SCORE
, RATING_TYPE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM WMS.WMS_ELS_RATINGS_SETUP;
WMS.WMS_ELS_RATINGS_SETUP does not reference any database object
WMS.WMS_ELS_RATINGS_SETUP is referenced by following:
|
|
|