eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: WMS.WMS_ELS_TRX_SRC

Object Details

Object Name:	WMS_ELS_TRX_SRC
Object Type:	TABLE
Owner:	WMS
FND Design Data:	WMS.WMS_ELS_TRX_SRC
Subobject Name:
Status:	VALID

This table will hold all the details for labor tracked transactions for a labor management enabled warehouse. Additionally the table will also hold the information regarding the user who has done the transaction and what is the rating and the score he has achieved for completing the task depending upon the travel, transaction and idle time he has taken for the transaction.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WMS_ELS_TRX_SRC_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ELS_TRX_SRC_ID
WMS_ELS_TRX_SRC_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UNATTRIBUTED_FLAG
WMS_ELS_TRX_SRC_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTIVITY_ID ACTIVITY_DETAIL_ID OPERATION_ID ORGANIZATION_ID LABOR_TXN_SOURCE_ID
WMS_ELS_TRX_SRC_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ELS_DATA_ID
WMS_ELS_TRX_SRC_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID USER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ELS_TRX_SRC_ID	NUMBER		Yes	Unique identifier for the table.
TRANSACTION_DATE	DATE			Date on which this Transaction was done
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.
ORGANIZATION_ID	NUMBER		Yes	Identifier for the Organization
USER_ID	NUMBER			The user who has performed the task
EQUIPMENT_ID	NUMBER			Unique Identifier for the Equipment.
SOURCE_ZONE_ID	NUMBER			Identifier for the Source Zone
SOURCE_SUBINVENTORY	VARCHAR2	(10)		Source Subinventory
DESTINATION_SUBINVENTORY	VARCHAR2	(10)		Destination Subinventory
FROM_LOCATOR_ID	NUMBER			Identifier for the source locator
TO_LOCATOR_ID	NUMBER			Identifier for the destination locator
DESTINATION_ZONE_ID	NUMBER			Identifier for the Destination Zone
LABOR_TXN_SOURCE_ID	NUMBER			Identifier for the transaction source for the task.This comes from the lookup type WMS_LABOR_TRX_TYPES.
TRANSACTION_UOM	VARCHAR2	(3)		Transaction Unit of Measure.
QUANTITY	NUMBER			Transaction Quantity
ITEM_CATEGORY_ID	NUMBER			Identifier for thr Item Category
INVENTORY_ITEM_ID	NUMBER			Identifier for the Inventory Item
OPERATION_PLAN_ID	NUMBER			Identifier for the Operation Plan used in the task
GROUP_ID	NUMBER			Task Execution Mode. This value will come from the lookup type WMS_ELS_TASK_EXECUTION_MODES.
TASK_METHOD_ID	NUMBER			Identifier for the task method used for performing the task. This comes from the lookup type WMS_ELS_TASK_METHODS.
TASK_TYPE_ID	NUMBER			Identifier for the User Task Type used to perform the task
GROUPED_TASK_IDENTIFIER	NUMBER			Identifier which defines whether the tasks belong to a group. Tasks having same value for this column will be belonging to same group of tasks
GROUP_SIZE	NUMBER			What is the size of the group of which the task is part of.
MATCH_GROUP	NUMBER			To indicate that the transactions are ready for matching with group setup data (1 ready , 2 done)
TRAVEL_TIME	NUMBER			Actual Travel time taken.
TRANSACTION_TIME	NUMBER			Actual Transaction time taken.
IDLE_TIME	NUMBER			Actual Idle time taken.
TRAVEL_AND_IDLE_TIME	NUMBER			This column will hold the value of travel+idle time populated from the transaction pages.
TRAVEL_SCORE	NUMBER			What is the Travel score earned for this task
TXN_SCORE	NUMBER			What is the Transaction score earned for this task
IDLE_SCORE	NUMBER			What is the Idle score earned for this task
EMPLOYEE_RATING_TRAVEL	NUMBER			Travel Rating for this task.
EMPLOYEE_RATING_TXN	NUMBER			Transaction Rating for this task.
EMPLOYEE_RATING_IDLE	NUMBER			Idle Rating for this task.
UNATTRIBUTED_FLAG	NUMBER			This would be Null if the Transaction row has not been once picked for processing against the setup. If the record has been picked for processing and no match has been found with the setup row it will be marked as 1
ELS_DATA_ID	NUMBER			Identifier of the setup row against which the match has been found for this transaction.
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 ELS_TRX_SRC_ID
,      TRANSACTION_DATE
,      ACTIVITY_ID
,      ACTIVITY_DETAIL_ID
,      OPERATION_ID
,      ORGANIZATION_ID
,      USER_ID
,      EQUIPMENT_ID
,      SOURCE_ZONE_ID
,      SOURCE_SUBINVENTORY
,      DESTINATION_SUBINVENTORY
,      FROM_LOCATOR_ID
,      TO_LOCATOR_ID
,      DESTINATION_ZONE_ID
,      LABOR_TXN_SOURCE_ID
,      TRANSACTION_UOM
,      QUANTITY
,      ITEM_CATEGORY_ID
,      INVENTORY_ITEM_ID
,      OPERATION_PLAN_ID
,      GROUP_ID
,      TASK_METHOD_ID
,      TASK_TYPE_ID
,      GROUPED_TASK_IDENTIFIER
,      GROUP_SIZE
,      MATCH_GROUP
,      TRAVEL_TIME
,      TRANSACTION_TIME
,      IDLE_TIME
,      TRAVEL_AND_IDLE_TIME
,      TRAVEL_SCORE
,      TXN_SCORE
,      IDLE_SCORE
,      EMPLOYEE_RATING_TRAVEL
,      EMPLOYEE_RATING_TXN
,      EMPLOYEE_RATING_IDLE
,      UNATTRIBUTED_FLAG
,      ELS_DATA_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM WMS.WMS_ELS_TRX_SRC;

Dependencies

[top of page]

WMS.WMS_ELS_TRX_SRC does not reference any database object

WMS.WMS_ELS_TRX_SRC is referenced by following:

APPS: WMS_ELS_TRX_SRC