[Home] [Help] [Dependency Information]
Object Name: | WMS_ELS_INDIVIDUAL_TASKS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | WMS.WMS_ELS_INDIVIDUAL_TASKS_VL |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
This view represents the MLS database entity WMS_ELS_INDIVIDUAL_TASKS
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ELS_DATA_ID | NUMBER | Yes | Unique Identifier for the table. | |
ORGANIZATION_ID | NUMBER | Yes | Identifier for the Organization | |
SEQUENCE_NUMBER | NUMBER | Yes | Defines the preference order in whichs the setup row will be applicable while doing the matching against the labor tracked transactions and the expected work. Lower the value, higher the preference. | |
ANALYSIS_ID | NUMBER | Identifier for the Analysis. It indicates to which of the analysis the setup row is applicable. The valid values are 'Both', Labor Productivity' and 'Work Outstanding'. | ||
ACTIVITY_ID | NUMBER | Identifier for the Activity. This value come from lookup type WMS_ELS_ACTIVITIES. | ||
ACTIVITY_DETAIL_ID | NUMBER | Identifier for the Activity Detail. This value come from lookup type WMS_ELS_ACTIVITY_DETAILS. | ||
OPERATION_ID | NUMBER | Identifier for the Operation. This value come from lookup type WMS_ELS_OPERATIONS. | ||
EQUIPMENT_ID | NUMBER | Identifier for the Equipment. | ||
SOURCE_ZONE_ID | NUMBER | Identifier for the Source Zone | ||
SOURCE_SUBINVENTORY | VARCHAR2 | (10) | Source Subinventory | |
DESTINATION_ZONE_ID | NUMBER | Identifier for the Destination Zone | ||
DESTINATION_SUBINVENTORY | VARCHAR2 | (10) | Destination Subinventory | |
LABOR_TXN_SOURCE_ID | NUMBER | dentifier for the transaction source for the individual tasks.This comes from the lookup type WMS_LABOR_TRX_TYPES. | ||
TRANSACTION_UOM | VARCHAR2 | (3) | Transaction Unit of Measure | |
FROM_QUANTITY | NUMBER | From Quantity | ||
TO_QUANTITY | NUMBER | To Quantity | ||
ITEM_CATEGORY_ID | NUMBER | Identifier for the Item Category | ||
OPERATION_PLAN_ID | NUMBER | Identifier for the operation plan used. | ||
GROUP_ID | NUMBER | Task Execution Mode. This value will come from the lookup type WMS_ELS_TASK_EXECUTION_MODES. | ||
TASK_TYPE_ID | NUMBER | Identifier for the user task type | ||
TASK_METHOD_ID | NUMBER | Identifier for the task method used for the individual tasks. This comes from the lookup type WMS_ELS_TASK_METHODS. | ||
EXPECTED_TRAVEL_TIME | NUMBER | Yes | Expected Travel Time for the individual task | |
EXPECTED_TXN_TIME | NUMBER | Yes | Expected Transaction Time for the individual task | |
EXPECTED_IDLE_TIME | NUMBER | Expected Idle Time for the individual task | ||
ACTUAL_TRAVEL_TIME | NUMBER | Actual Travel time. This value is calculated by the moving average of the actual travel times. | ||
ACTUAL_TXN_TIME | NUMBER | Actual Transaction time. This value is calculated by the moving average of the actual transaction times. | ||
ACTUAL_IDLE_TIME | NUMBER | Actual Idle time. This value is calculated by the moving average of the actual Idle times. | ||
TRAVEL_TIME_THRESHOLD | NUMBER | Threshold value for the travel time. Beyond this value the rest of the time will be considered as idle. | ||
HISTORY_FLAG | NUMBER | If the flag is 1 then the setup record is a history record. It is NULL when the record is not a history record. | ||
ARCHIVE_DATE | DATE | This is the date on which the setup row is archived. | ||
NUM_TRX_MATCHED | NUMBER | This is the counter, which tells the number of transactions matched to this setup row till date. | ||
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO Columns | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO Columns | ||
CREATED_BY | NUMBER | Yes | Standard WHO Columns | |
CREATION_DATE | DATE | Yes | Standard WHO Columns | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Columns | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
LANGUAGE | VARCHAR2 | (4) | Yes | Language Code |
SOURCE_LANG | VARCHAR2 | (4) | Yes | Source Language Code |
DESCRIPTION | VARCHAR2 | (240) | Translated Description of the IndividualTask Setup Row. |
Cut, paste (and edit) the following text to query this object:
SELECT ELS_DATA_ID
, ORGANIZATION_ID
, SEQUENCE_NUMBER
, ANALYSIS_ID
, ACTIVITY_ID
, ACTIVITY_DETAIL_ID
, OPERATION_ID
, EQUIPMENT_ID
, SOURCE_ZONE_ID
, SOURCE_SUBINVENTORY
, DESTINATION_ZONE_ID
, DESTINATION_SUBINVENTORY
, LABOR_TXN_SOURCE_ID
, TRANSACTION_UOM
, FROM_QUANTITY
, TO_QUANTITY
, ITEM_CATEGORY_ID
, OPERATION_PLAN_ID
, GROUP_ID
, TASK_TYPE_ID
, TASK_METHOD_ID
, EXPECTED_TRAVEL_TIME
, EXPECTED_TXN_TIME
, EXPECTED_IDLE_TIME
, ACTUAL_TRAVEL_TIME
, ACTUAL_TXN_TIME
, ACTUAL_IDLE_TIME
, TRAVEL_TIME_THRESHOLD
, HISTORY_FLAG
, ARCHIVE_DATE
, NUM_TRX_MATCHED
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, LANGUAGE
, SOURCE_LANG
, DESCRIPTION
FROM APPS.WMS_ELS_INDIVIDUAL_TASKS_VL;
APPS.WMS_ELS_INDIVIDUAL_TASKS_VL is not referenced by any database object
|
|
|