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_WCSV

Object Details

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

View Type

A Business Intelligence System view

View on which device request query and device response query can be based

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
REQUEST_ID	NUMBER			Request Id
TASK_ID	NUMBER			Task Id
SEQUENCE_ID	NUMBER			Sequence Id
TASK_TYPE_ID	NUMBER			Task Type Id
QUANTITY	NUMBER			Quantity
SUBINVENTORY_CODE	VARCHAR2	(30)		Subinventory Code
LOCATOR	VARCHAR2	(4000)		Locator
DEVICE_NAME	VARCHAR2	(30)	Yes	Device Name
DEVICE_ID	NUMBER		Yes	Device Id
DEVICE_TYPE_ID	NUMBER		Yes	Device Type Id
BUSINESS_EVENT	VARCHAR2	(80)		Business Event
BUSINESS_EVENT_ID	NUMBER		Yes	Business Event Id
RELATION_ID	NUMBER			Relation Id
LPN	VARCHAR2	(30)		License Plate Number
ITEM	VARCHAR2	(40)		Item
SEGMENT1	VARCHAR2	(40)		Locator Segment
SEGMENT2	VARCHAR2	(40)		Locator Segment
SEGMENT3	VARCHAR2	(40)		Locator Segment
SEGMENT4	VARCHAR2	(40)		Locator Segment
SEGMENT5	VARCHAR2	(40)		Locator Segment
SEGMENT6	VARCHAR2	(40)		Locator Segment
SEGMENT7	VARCHAR2	(40)		Locator Segment
SEGMENT8	VARCHAR2	(40)		Locator Segment
SEGMENT9	VARCHAR2	(40)		Locator Segment
SEGMENT10	VARCHAR2	(40)		Locator Segment
SEGMENT11	VARCHAR2	(40)		Locator Segment
SEGMENT12	VARCHAR2	(40)		Locator Segment
SEGMENT13	VARCHAR2	(40)		Locator Segment
SEGMENT14	VARCHAR2	(40)		Locator Segment
SEGMENT15	VARCHAR2	(40)		Locator Segment
SEGMENT16	VARCHAR2	(40)		Locator Segment
SEGMENT17	VARCHAR2	(40)		Locator Segment
SEGMENT18	VARCHAR2	(40)		Locator Segment
SEGMENT19	VARCHAR2	(40)		Locator Segment
SEGMENT20	VARCHAR2	(40)		Locator Segment
TASK_SUMMARY	VARCHAR2	(1)		Task Summary
LOCATOR_ID	NUMBER			Locator Id
TRANSFER_ORG_ID	NUMBER			Transfer Organization Id
TRANSFER_SUB_CODE	VARCHAR2	(30)		Transfer Subinventory Code
TRANSFER_LOC_ID	NUMBER			Transfer Locator Id
INVENTORY_ITEM_ID	NUMBER			Inventory Item Id
REVISION	VARCHAR2	(10)		Revision
UOM	VARCHAR2	(3)		Unit Of Measure
LOT_NUMBER	VARCHAR2	(80)		Lot Number
LOT_QTY	NUMBER			Lot Quantity
SERIAL_NUMBER	VARCHAR2	(30)		Serial Number
TRANSACTION_QUANTITY	NUMBER			Transaction Quantity
STATUS_CODE	VARCHAR2	(1)		Status Code
STATUS_MSG	VARCHAR2	(240)		Status Message
OUTFILE_NAME	VARCHAR2	(255)		Output File Name

Query Text

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


SELECT REQUEST_ID
,      TASK_ID
,      SEQUENCE_ID
,      TASK_TYPE_ID
,      QUANTITY
,      SUBINVENTORY_CODE
,      LOCATOR
,      DEVICE_NAME
,      DEVICE_ID
,      DEVICE_TYPE_ID
,      BUSINESS_EVENT
,      BUSINESS_EVENT_ID
,      RELATION_ID
,      LPN
,      ITEM
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      TASK_SUMMARY
,      LOCATOR_ID
,      TRANSFER_ORG_ID
,      TRANSFER_SUB_CODE
,      TRANSFER_LOC_ID
,      INVENTORY_ITEM_ID
,      REVISION
,      UOM
,      LOT_NUMBER
,      LOT_QTY
,      SERIAL_NUMBER
,      TRANSACTION_QUANTITY
,      STATUS_CODE
,      STATUS_MSG
,      OUTFILE_NAME
FROM APPS.WMS_DEVICE_REQUESTS_WCSV;

Dependencies

[top of page]

APPS.WMS_DEVICE_REQUESTS_WCSV references the following:

APPS: INV_PROJECT - show dependent code; MFG_LOOKUPS; MTL_ITEM_LOCATIONS; MTL_SYSTEM_ITEMS; WMS_DEVICES; WMS_DEVICE_REQUESTS; WMS_LICENSE_PLATE_NUMBERS

APPS.WMS_DEVICE_REQUESTS_WCSV is referenced by following:

APPS: WMS_CAROUSEL_INTEGRATION_PVT - show dependent code; WMS_CAROUSEL_INTEGRATION_PVT - show dependent code