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]

TABLE: WMS.WMS_LABEL_REQUESTS

Object Details

Object Name:	WMS_LABEL_REQUESTS
Object Type:	TABLE
Owner:	WMS
FND Design Data:	WMS.WMS_LABEL_REQUESTS
Subobject Name:
Status:	VALID

This table stores information about label printing requests. These records are used by rules engine to provide label format based on the label format rules and label request information.

Temporary Table Details

WMS.WMS_LABEL_REQUESTS is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
WMS_LABEL_REQUESTS_U1	NORMAL	UNIQUE		LABEL_REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LABEL_REQUEST_ID	NUMBER		Yes
DOCUMENT_ID	NUMBER			Unique Label Type Identifier
LABEL_ID	NUMBER
ORGANIZATION_ID	NUMBER			Organization Identifier
INVENTORY_ITEM_ID	NUMBER			Unique Item Identifier
SUBINVENTORY_CODE	VARCHAR2	(10)		Subinventory Code
LOCATOR_ID	NUMBER			Unique Locator Identifier
LOT_NUMBER	VARCHAR2	(80)		Lot Number
REVISION	VARCHAR2	(3)		Revision
SERIAL_NUMBER	VARCHAR2	(30)		Serial Number
LPN_ID	NUMBER			License Plate Identifier
SUPPLIER_ID	NUMBER			Supplier Identifier
SUPPLIER_SITE_ID	NUMBER			Supplier Site Identifier
SUPPLIER_ITEM_ID	NUMBER			Supplier's Item Identifier
CUSTOMER_ID	NUMBER			Customer Identifier
CUSTOMER_SITE_ID	NUMBER			Customer Site Identifier
CUSTOMER_ITEM_ID	NUMBER			Customer 's Item Identifier
CUSTOMER_CONTACT_ID	NUMBER			Customer 's Contact Identifier
FREIGHT_CODE	VARCHAR2	(25)		Freight Code
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER		Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER			Standard WHO Column
REQUEST_ID	NUMBER			Concurrent WHO Column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent WHO Column
PROGRAM_ID	NUMBER			Concurrent WHO Column
PROGRAM_UPDATE_DATE	DATE			Concurrent WHO Column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flex Field Category
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flex Field Column
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flex Field Column
LABEL_FORMAT_ID	NUMBER			Unique Label Format Identifier
DELIVERY_ID	NUMBER			Delivery ID
PRINTER_NAME	VARCHAR2	(240)		Printer Name
BUSINESS_FLOW_CODE	NUMBER			Business Flow Code
PACKAGE_ID	NUMBER			Package Identifier
DELIVERY_DETAIL_ID	NUMBER
SALES_ORDER_HEADER_ID	NUMBER
SALES_ORDER_LINE_ID	NUMBER
RULE_ID	NUMBER
RULE_WEIGHT	NUMBER
STRATEGY_ID	NUMBER

Query Text

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


SELECT LABEL_REQUEST_ID
,      DOCUMENT_ID
,      LABEL_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      SUBINVENTORY_CODE
,      LOCATOR_ID
,      LOT_NUMBER
,      REVISION
,      SERIAL_NUMBER
,      LPN_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      SUPPLIER_ITEM_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      CUSTOMER_ITEM_ID
,      CUSTOMER_CONTACT_ID
,      FREIGHT_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LABEL_FORMAT_ID
,      DELIVERY_ID
,      PRINTER_NAME
,      BUSINESS_FLOW_CODE
,      PACKAGE_ID
,      DELIVERY_DETAIL_ID
,      SALES_ORDER_HEADER_ID
,      SALES_ORDER_LINE_ID
,      RULE_ID
,      RULE_WEIGHT
,      STRATEGY_ID
FROM WMS.WMS_LABEL_REQUESTS;

Dependencies

[top of page]

WMS.WMS_LABEL_REQUESTS does not reference any database object

WMS.WMS_LABEL_REQUESTS is referenced by following:

APPS: WMS_LABEL_REQUESTS