DBA Data[Home] [Help] [Dependency Information]

TABLE: WMS.WMS_LABEL_REQUESTS_HIST

Object Details
Object Name: WMS_LABEL_REQUESTS_HIST
Object Type: TABLE
Owner: WMS
FND Design Data: TableWMS.WMS_LABEL_REQUESTS_HIST
Subobject Name:
Status: VALID


History Table for label request. This table stores all the label requests that have been submitted.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WMS_LABEL_REQUESTS_HIST_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLABEL_REQUEST_ID
WMS_LABEL_REQUESTS_HIST_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_USER_ID
WMS_LABEL_REQUESTS_HIST_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_FLOW_CODE
ColumnORGANIZATION_ID
WMS_LABEL_REQUESTS_HIST_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLABEL_TYPE_ID
ColumnLABEL_FORMAT_ID
Columns
Name Datatype Length Mandatory Comments
LABEL_REQUEST_ID NUMBER
Yes Request Identifier
JOB_NAME VARCHAR2 (150)
Print Job Name
REQUEST_MODE_CODE NUMBER

Request Mode Code to indicate whether it is synchronous or asynchronous
REQUEST_DATE DATE

Request Date
REQUEST_USER_ID NUMBER

User ID
BUSINESS_FLOW_CODE NUMBER

Business Flow Code
LABEL_TYPE_ID NUMBER

Label Type Identifier
LABEL_FORMAT_ID NUMBER

Label Format Identifier
PRINTER_NAME VARCHAR2 (100)
Printer Name
OUTFILE_NAME VARCHAR2 (240)
File name of XML label file
OUTFILE_DIRECTORY VARCHAR2 (240)
Directory of the label xml file
NO_OF_COPY NUMBER

Number of Copy of the label
ENCODING VARCHAR2 (100)
Label data encoding
ORIGINAL_REQUEST_ID NUMBER

The original request ID, if this is a reprint request
ORGANIZATION_ID NUMBER

Organization ID
INVENTORY_ITEM_ID NUMBER

Item ID
SUBINVENTORY_CODE VARCHAR2 (10)
Subinventory
LOCATOR_ID NUMBER

Locator
LOT_NUMBER VARCHAR2 (80)
Lot Number
REVISION VARCHAR2 (3)
Revision
SERIAL_NUMBER VARCHAR2 (30)
Serial Number
LPN_ID NUMBER

LPN Identifier
DELIVERY_ID NUMBER

Delivery ID
DELIVERY_DETAIL_ID NUMBER

Delivery Detail ID
PACKAGE_ID NUMBER

Package ID
SALES_ORDER_HEADER_ID NUMBER

Sales Order Header ID
SALES_ORDER_LINE_ID NUMBER

Sales Order Line ID
SUPPLIER_ID NUMBER

Supplier iD
SUPPLIER_SITE_ID NUMBER

Supplier Site ID
SUPPLIER_ITEM_ID NUMBER

Supplier Item ID
CUSTOMER_ID NUMBER

Customer ID
CUSTOMER_SITE_ID NUMBER

Customer Site ID
CUSTOMER_ITEM_ID NUMBER

Customer Item ID
CUSTOMER_CONTACT_ID NUMBER

Customer Contact ID
FREIGHT_CODE VARCHAR2 (25)
Freight Code
RULE_ID NUMBER

Rule ID
RULE_WEIGHT NUMBER

Rule Weight
STRATEGY_ID NUMBER

Rule Strategy ID
STATUS_FLAG VARCHAR2 (1)
Request Status Flag
ERROR_MESSAGE VARCHAR2 (4000)
Error Message
JOB_STATUS VARCHAR2 (2000)
Print Job Status
PRINTER_STATUS VARCHAR2 (2000)
Printer Status
STATUS_TYPE VARCHAR2 (100)
Status Type
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Attribute Category
ATTRIBUTE1 VARCHAR2 (150)
Attribute 1
ATTRIBUTE2 VARCHAR2 (150)
Attribute 2
ATTRIBUTE3 VARCHAR2 (150)
Attribute 3
ATTRIBUTE4 VARCHAR2 (150)
Attribute 4
ATTRIBUTE5 VARCHAR2 (150)
Attribute 5
ATTRIBUTE6 VARCHAR2 (150)
Attribute 6
ATTRIBUTE7 VARCHAR2 (150)
Attribute 7
ATTRIBUTE8 VARCHAR2 (150)
Attribute 8
ATTRIBUTE9 VARCHAR2 (150)
Attribute 9
ATTRIBUTE10 VARCHAR2 (150)
Attribute 10
ATTRIBUTE11 VARCHAR2 (150)
Attribute 11
ATTRIBUTE12 VARCHAR2 (150)
Attribute 12
ATTRIBUTE13 VARCHAR2 (150)
Attribute 13
ATTRIBUTE14 VARCHAR2 (150)
Attribute 14
ATTRIBUTE15 VARCHAR2 (150)
Attribute 15
CREATION_DATE DATE
Yes Creation Date
CREATED_BY NUMBER
Yes Created By
LAST_UPDATE_DATE DATE
Yes Last Update Date
LAST_UPDATED_BY NUMBER
Yes Last Updated By
LAST_UPDATE_LOGIN NUMBER

Last Update Login
REQUEST_ID NUMBER

Request ID
PROGRAM_APPLICATION_ID NUMBER

Program Application ID
PROGRAM_ID NUMBER

Program ID
PROGRAM_UPDATE_DATE DATE

Program Update Date
LABEL_CONTENT LONG (0)
The XML content of the label
Query Text

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


SELECT LABEL_REQUEST_ID
,      JOB_NAME
,      REQUEST_MODE_CODE
,      REQUEST_DATE
,      REQUEST_USER_ID
,      BUSINESS_FLOW_CODE
,      LABEL_TYPE_ID
,      LABEL_FORMAT_ID
,      PRINTER_NAME
,      OUTFILE_NAME
,      OUTFILE_DIRECTORY
,      NO_OF_COPY
,      ENCODING
,      ORIGINAL_REQUEST_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      SUBINVENTORY_CODE
,      LOCATOR_ID
,      LOT_NUMBER
,      REVISION
,      SERIAL_NUMBER
,      LPN_ID
,      DELIVERY_ID
,      DELIVERY_DETAIL_ID
,      PACKAGE_ID
,      SALES_ORDER_HEADER_ID
,      SALES_ORDER_LINE_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      SUPPLIER_ITEM_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      CUSTOMER_ITEM_ID
,      CUSTOMER_CONTACT_ID
,      FREIGHT_CODE
,      RULE_ID
,      RULE_WEIGHT
,      STRATEGY_ID
,      STATUS_FLAG
,      ERROR_MESSAGE
,      JOB_STATUS
,      PRINTER_STATUS
,      STATUS_TYPE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LABEL_CONTENT
FROM WMS.WMS_LABEL_REQUESTS_HIST;

Dependencies

[top of page]

WMS.WMS_LABEL_REQUESTS_HIST does not reference any database object

WMS.WMS_LABEL_REQUESTS_HIST is referenced by following:

SchemaAPPS
SynonymWMS_LABEL_REQUESTS_HIST