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: ViewWMS.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 VARCHAR2 (1)
TRANSFER_ORG_ID NUMBER

TRANSFER_ORG_CODE VARCHAR2 (3)
TRANSFER_SUB_CODE VARCHAR2 (30)
TRANSFER_LOC_ID NUMBER

TRANSFER_LOCATOR VARCHAR2 (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:

SchemaAPPS
ViewMFG_LOOKUPS
ViewMTL_ITEM_LOCATIONS_KFV
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS
ViewWMS_DEVICES_VL
SynonymWMS_DEVICE_REQUESTS_HIST
SynonymWMS_EPC
SynonymWMS_LICENSE_PLATE_NUMBERS

APPS.WMS_DEVICE_REQUESTS_HIST_V is not referenced by any database object