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_EXP_RESOURCE

Object Details

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

This is the table which wil be populated by all the expected work when the Concurrent program Expected Resource Requirement Analysis will be launched. This table will also hold information regarding what is the estimated time and estimated resource required to finish the expected work.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WMS_ELS_EXP_RESOURCE_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ELS_EXP_RESOURCE_ID
WMS_ELS_EXP_RESOURCE_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ELS_DATA_ID
WMS_ELS_EXP_RESOURCE_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UNATTRIBUTED_FLAG
WMS_ELS_EXP_RESOURCE_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID ACTIVITY_ID ACTIVITY_DETAIL_ID OPERATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ELS_EXP_RESOURCE_ID	NUMBER		Yes	Unique Identifier for the table
ORGANIZATION_ID	NUMBER		Yes	Organization Identifier
ACTIVITY_ID	NUMBER			What is the activity for this work. Will come from the lookup WMS_ELS_ACTIVITIES. This will identify whether the expected work is a part of Inbound, Outbound etc.
ACTIVITY_DETAIL_ID	NUMBER			What is the activity detail for this work. Will come from the lookup WMS_ELS_ACTIVITY_DETAILS. This will identify whether the expected work is a part of Recieving,Putaway,Counting etc.
OPERATION_ID	NUMBER			What is the operation for this expected work. Will come from the lookup WMS_ELS_OPERATIONS. This will identify whether the expected work is a part of Load, Drop,Count etc.
DOCUMENT_TYPE	VARCHAR2	(25)		What document is the source(Purchase Order,Requisition,Shipment) for this work.This will be populated when activity is Inbound and activity detail is recieving.
SOURCE_SUBINVENTORY	VARCHAR2	(10)		Source Subinventory
SOURCE_LOCATOR_ID	NUMBER			Identifier for the Source Locator
DESTINATION_SUBINVENTORY	VARCHAR2	(10)		Destination Subinventory
DESTINATION_LOCATOR_ID	NUMBER			Identifier for the Destination Locator
SOURCE_ZONE_ID	NUMBER			Identifier for the Source Zone
DESTINATION_ZONE_ID	NUMBER			Identifier for the Destination Zone
TRANSACTION_UOM	VARCHAR2	(3)		Transaction Unit Of Measure
INVENTORY_ITEM_ID	NUMBER			Identifier for the the Item
QUANTITY	NUMBER			Transaction Quantity
ITEM_CATEGORY_ID	NUMBER			Identifier for the Item Category
OPERATION_PLAN_ID	NUMBER			Expected Operation Plan for the work
SOURCE_HEADER_ID	NUMBER			This will store Identifiers for the source document. ex po_header_id,transaction_temp_id
SOURCE_LINE_ID	NUMBER			This will store Identifiers for the lines of source document ex. po_line_id
GROUP_ID	NUMBER			Task Execution Mode. This value will come from the lookup type WMS_ELS_TASK_EXECUTION_MODES.
UNATTRIBUTED_FLAG	NUMBER			This flag would indicated whether a expected work line has not found a match with any setup row.This would be Null if the expected work row has not been once picked for processing. If the record has been picked for processing and no match has been found it will be marked as 1.
ELS_DATA_ID	NUMBER			Identifier for the setup row against which the match has been found.
ESTIMATED_TIME_REQUIRED	NUMBER			Estimated Time required to perform the expected work.
ESTIMATED_RESOURCE_REQUIRED	NUMBER			Estimated Resource required to perform the expected work.
WORK_SCHEDULED_DATE	DATE			What is this scheduled date for that expected work.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Columns.
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.

Query Text

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


SELECT ELS_EXP_RESOURCE_ID
,      ORGANIZATION_ID
,      ACTIVITY_ID
,      ACTIVITY_DETAIL_ID
,      OPERATION_ID
,      DOCUMENT_TYPE
,      SOURCE_SUBINVENTORY
,      SOURCE_LOCATOR_ID
,      DESTINATION_SUBINVENTORY
,      DESTINATION_LOCATOR_ID
,      SOURCE_ZONE_ID
,      DESTINATION_ZONE_ID
,      TRANSACTION_UOM
,      INVENTORY_ITEM_ID
,      QUANTITY
,      ITEM_CATEGORY_ID
,      OPERATION_PLAN_ID
,      SOURCE_HEADER_ID
,      SOURCE_LINE_ID
,      GROUP_ID
,      UNATTRIBUTED_FLAG
,      ELS_DATA_ID
,      ESTIMATED_TIME_REQUIRED
,      ESTIMATED_RESOURCE_REQUIRED
,      WORK_SCHEDULED_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM WMS.WMS_ELS_EXP_RESOURCE;

Dependencies

[top of page]

WMS.WMS_ELS_EXP_RESOURCE does not reference any database object

WMS.WMS_ELS_EXP_RESOURCE is referenced by following:

WMS: WMS_ELS_EXP_RESOURCE#