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_LABEL_REQUESTS_HIST_V

Object Details

Object Name:	WMS_LABEL_REQUESTS_HIST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WMS.WMS_LABEL_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)		Row ID
LABEL_REQUEST_ID	NUMBER		Yes	Label Request Identifier
JOB_NAME	VARCHAR2	(150)		Print Job Name
REQUEST_MODE_CODE	NUMBER			Request Mode Code
REQUEST_MODE	VARCHAR2	(80)		Request Mode Name
REQUEST_DATE	DATE			Request Date
REQUEST_USER_ID	NUMBER			Request User ID
REQUEST_USER	VARCHAR2	(100)	Yes	Request User
BUSINESS_FLOW_CODE	NUMBER			Business Flow Code
BUSINESS_FLOW_CODE_NAME	VARCHAR2	(80)		Business Flow Code Name
LABEL_TYPE_ID	NUMBER			Label Type ID
LABEL_TYPE	VARCHAR2	(80)		Label Type
LABEL_FORMAT_ID	NUMBER			Label Format ID
LABEL_FORMAT_NAME	VARCHAR2	(240)		Label Format Name
PRINTER_NAME	VARCHAR2	(100)		Printer Name
LABEL_CONTENT	LONG	(0)		Label XML Content
OUTFILE_NAME	VARCHAR2	(240)		Outfile XML file name
OUTFILE_DIRECTORY	VARCHAR2	(240)		Outfile directory
NO_OF_COPY	NUMBER			Number of copy
ENCODING	VARCHAR2	(100)		Encoding
ORIGINAL_REQUEST_ID	NUMBER			Original Request ID
ORGANIZATION_ID	NUMBER			Organization ID
ORGANIZATION_CODE	VARCHAR2	(3)		Organization Code
INVENTORY_ITEM_ID	NUMBER			Inventtory Item ID
ITEM	VARCHAR2	(40)		Item
SUBINVENTORY_CODE	VARCHAR2	(10)		Subinventory Code
LOCATOR_ID	NUMBER			Locator ID
LOCATOR	VARCHAR2	(1)		Locator
LOT_NUMBER	VARCHAR2	(80)		Lot Number
REVISION	VARCHAR2	(3)		Revision
SERIAL_NUMBER	VARCHAR2	(30)		Serial Number
LPN_ID	NUMBER			LPN ID
LICENSE_PLATE_NUMBER	VARCHAR2	(30)		LPN
DELIVERY_ID	NUMBER			Delivery ID
DELIVERY	VARCHAR2	(30)		Delivery
DELIVERY_DETAIL_ID	NUMBER			Delivery Detail ID
PACKAGE_ID	NUMBER			Pakcage ID
SALES_ORDER_HEADER_ID	NUMBER			Sales Order Header ID
SALES_ORDER_HEADER	NUMBER			Sales Order Header Number
SALES_ORDER_LINE_ID	NUMBER			Sales Order Line ID
SALES_ORDER_LINE	NUMBER			Sales Order Line Number
SUPPLIER_ID	NUMBER			Supplier ID
SUPPLIER	VARCHAR2	(240)		Supplier Name
SUPPLIER_SITE_ID	NUMBER			Supplier Site ID
SUPPLIER_SITE	VARCHAR2	(15)		Supplier Site
SUPPLIER_ITEM_ID	NUMBER			Supplier Item ID
CUSTOMER_ID	NUMBER			Customer ID
CUSTOMER_NUMBER	VARCHAR2	(30)		Customer Number
CUSTOMER_NAME	VARCHAR2	(360)		Customer Name
CUSTOMER_SITE_ID	NUMBER			Customer Site ID
CUSTOMER_ITEM_ID	NUMBER			Customer Item ID
CUSTOMER_ITEM_NUMBER	VARCHAR2	(50)		Customer Item Number
CUSTOMER_CONTACT_ID	NUMBER			Customer Contact ID
CUSTOMER_CONTACT_NAME	VARCHAR2	(101)		Customer Contact Name
FREIGHT_CODE	VARCHAR2	(25)		Freight Code
RULE_ID	NUMBER			Rule ID
RULE_NAME	VARCHAR2	(80)		Rule Name
RULE_WEIGHT	NUMBER			Rule Weight
STRATEGY_ID	NUMBER			Strategy ID
STRATEGY_NAME	VARCHAR2	(80)		Strategy Name
STATUS_FLAG	VARCHAR2	(1)		Status Flag
ERROR_MESSAGE	VARCHAR2	(4000)		Error Message
JOB_STATUS	VARCHAR2	(2000)		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

Query Text

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


SELECT ROW_ID
,      LABEL_REQUEST_ID
,      JOB_NAME
,      REQUEST_MODE_CODE
,      REQUEST_MODE
,      REQUEST_DATE
,      REQUEST_USER_ID
,      REQUEST_USER
,      BUSINESS_FLOW_CODE
,      BUSINESS_FLOW_CODE_NAME
,      LABEL_TYPE_ID
,      LABEL_TYPE
,      LABEL_FORMAT_ID
,      LABEL_FORMAT_NAME
,      PRINTER_NAME
,      LABEL_CONTENT
,      OUTFILE_NAME
,      OUTFILE_DIRECTORY
,      NO_OF_COPY
,      ENCODING
,      ORIGINAL_REQUEST_ID
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      INVENTORY_ITEM_ID
,      ITEM
,      SUBINVENTORY_CODE
,      LOCATOR_ID
,      LOCATOR
,      LOT_NUMBER
,      REVISION
,      SERIAL_NUMBER
,      LPN_ID
,      LICENSE_PLATE_NUMBER
,      DELIVERY_ID
,      DELIVERY
,      DELIVERY_DETAIL_ID
,      PACKAGE_ID
,      SALES_ORDER_HEADER_ID
,      SALES_ORDER_HEADER
,      SALES_ORDER_LINE_ID
,      SALES_ORDER_LINE
,      SUPPLIER_ID
,      SUPPLIER
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE
,      SUPPLIER_ITEM_ID
,      CUSTOMER_ID
,      CUSTOMER_NUMBER
,      CUSTOMER_NAME
,      CUSTOMER_SITE_ID
,      CUSTOMER_ITEM_ID
,      CUSTOMER_ITEM_NUMBER
,      CUSTOMER_CONTACT_ID
,      CUSTOMER_CONTACT_NAME
,      FREIGHT_CODE
,      RULE_ID
,      RULE_NAME
,      RULE_WEIGHT
,      STRATEGY_ID
,      STRATEGY_NAME
,      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
FROM APPS.WMS_LABEL_REQUESTS_HIST_V;

Dependencies

[top of page]

APPS.WMS_LABEL_REQUESTS_HIST_V references the following:

APPS: FND_USER; HZ_CUST_ACCOUNTS; HZ_CUST_ACCOUNT_ROLES; HZ_ORG_CONTACTS; HZ_PARTIES; HZ_RELATIONSHIPS; MFG_LOOKUPS; MTL_CUSTOMER_ITEMS; MTL_ITEM_LOCATIONS_KFV; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_KFV; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL; PO_VENDORS; PO_VENDOR_SITES_ALL; WMS_LABEL_FORMATS; WMS_LABEL_REQUESTS_HIST; WMS_LICENSE_PLATE_NUMBERS; WMS_RULES_TL; WMS_STRATEGIES_TL; WSH_NEW_DELIVERIES

APPS.WMS_LABEL_REQUESTS_HIST_V is not referenced by any database object