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]

VIEW: APPS.WMS_DEVICE_REQUESTS_HIST_V

Object Details

Object Name:	WMS_DEVICE_REQUESTS_HIST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WMS.WMS_DEVICE_REQUESTS_HIST_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
REQUEST_ID	NUMBER
TASK_ID	NUMBER
RELATION_ID	NUMBER
SEQUENCE_ID	NUMBER
TASK_SUMMARY	VARCHAR2	(1)
TASK_TYPE_ID	NUMBER
TASK_TYPE	VARCHAR2	(80)
BUSINESS_EVENT_ID	NUMBER		Yes
BUSINESS_EVENT	VARCHAR2	(80)	Yes
ORGANIZATION_ID	NUMBER		Yes
ORGANIZATION_CODE	VARCHAR2	(3)
SUBINVENTORY_CODE	VARCHAR2	(30)
LOCATOR_ID	NUMBER
LOCATOR	CHAR	(1)
TRANSFER_ORG_ID	NUMBER
TRANSFER_ORG_CODE	VARCHAR2	(3)
TRANSFER_SUB_CODE	VARCHAR2	(30)
TRANSFER_LOC_ID	NUMBER
TRANSFER_LOCATOR	CHAR	(1)
INVENTORY_ITEM_ID	NUMBER
ITEM	VARCHAR2	(40)
REVISION	VARCHAR2	(10)
UOM	VARCHAR2	(3)
LOT_NUMBER	VARCHAR2	(80)
LOT_QTY	NUMBER
SERIAL_NUMBER	VARCHAR2	(30)
LPN_ID	NUMBER
LICENSE_PLATE_NUMBER	VARCHAR2	(30)
TRANSACTION_QUANTITY	NUMBER
DEVICE_ID	NUMBER		Yes
DEVICE_NAME	VARCHAR2	(30)	Yes
DEVICE_TYPE_ID	NUMBER		Yes
DEVICE_TYPE	VARCHAR2	(80)	Yes
STATUS_CODE	VARCHAR2	(1)	Yes
STATUS_MSG	VARCHAR2	(240)
OUTFILE_NAME	VARCHAR2	(240)
REQUEST_DATE	DATE		Yes
RESUBMIT_DATE	DATE
CONCURRENT_REQUEST_ID	NUMBER
REQUESTED_BY	NUMBER		Yes	requested by
RESPONSIBILITY_APPLICATION_ID	NUMBER		Yes	responsibility application id
RESPONSIBILITY_ID	NUMBER		Yes	responsibility id
CREATION_DATE	DATE		Yes	Standard WHO column
CREATED_BY	NUMBER		Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER			Standard WHO column
DEVICE_STATUS	VARCHAR2	(1)		DEVICE STATUS
REASON_ID	NUMBER			REASON ID: To be populated for descrepancy, will be used to fire appropriate workflow
XFER_LPN_ID	NUMBER			Transfer LPn id
EPC	VARCHAR2	(260)		EPC associated with transaction performed by the device

Query Text

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


SELECT ROW_ID
,      REQUEST_ID
,      TASK_ID
,      RELATION_ID
,      SEQUENCE_ID
,      TASK_SUMMARY
,      TASK_TYPE_ID
,      TASK_TYPE
,      BUSINESS_EVENT_ID
,      BUSINESS_EVENT
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      SUBINVENTORY_CODE
,      LOCATOR_ID
,      LOCATOR
,      TRANSFER_ORG_ID
,      TRANSFER_ORG_CODE
,      TRANSFER_SUB_CODE
,      TRANSFER_LOC_ID
,      TRANSFER_LOCATOR
,      INVENTORY_ITEM_ID
,      ITEM
,      REVISION
,      UOM
,      LOT_NUMBER
,      LOT_QTY
,      SERIAL_NUMBER
,      LPN_ID
,      LICENSE_PLATE_NUMBER
,      TRANSACTION_QUANTITY
,      DEVICE_ID
,      DEVICE_NAME
,      DEVICE_TYPE_ID
,      DEVICE_TYPE
,      STATUS_CODE
,      STATUS_MSG
,      OUTFILE_NAME
,      REQUEST_DATE
,      RESUBMIT_DATE
,      CONCURRENT_REQUEST_ID
,      REQUESTED_BY
,      RESPONSIBILITY_APPLICATION_ID
,      RESPONSIBILITY_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DEVICE_STATUS
,      REASON_ID
,      XFER_LPN_ID
,      EPC
FROM APPS.WMS_DEVICE_REQUESTS_HIST_V;

Dependencies

[top of page]

APPS.WMS_DEVICE_REQUESTS_HIST_V references the following:

APPS: MFG_LOOKUPS; MTL_ITEM_LOCATIONS_KFV; MTL_PARAMETERS; MTL_SYSTEM_ITEMS; WMS_DEVICES_VL; WMS_DEVICE_REQUESTS_HIST; WMS_EPC; WMS_LICENSE_PLATE_NUMBERS

APPS.WMS_DEVICE_REQUESTS_HIST_V is not referenced by any database object