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: ViewWMS.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:

SchemaAPPS
PL/SQL PackageINV_PROJECT - show dependent code
ViewMFG_LOOKUPS
SynonymMTL_ITEM_LOCATIONS
SynonymMTL_SYSTEM_ITEMS
SynonymWMS_DEVICES
SynonymWMS_DEVICE_REQUESTS
SynonymWMS_LICENSE_PLATE_NUMBERS
APPS.WMS_DEVICE_REQUESTS_WCSV is referenced by following:

SchemaAPPS
Package BodyWMS_CAROUSEL_INTEGRATION_PVT - show dependent code
PL/SQL PackageWMS_CAROUSEL_INTEGRATION_PVT - show dependent code