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

SchemaAPPS
SynonymFND_USER
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_ACCOUNT_ROLES
SynonymHZ_ORG_CONTACTS
SynonymHZ_PARTIES
SynonymHZ_RELATIONSHIPS
ViewMFG_LOOKUPS
SynonymMTL_CUSTOMER_ITEMS
ViewMTL_ITEM_LOCATIONS_KFV
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL
SynonymWMS_LABEL_FORMATS
SynonymWMS_LABEL_REQUESTS_HIST
SynonymWMS_LICENSE_PLATE_NUMBERS
SynonymWMS_RULES_TL
SynonymWMS_STRATEGIES_TL
SynonymWSH_NEW_DELIVERIES

APPS.WMS_LABEL_REQUESTS_HIST_V is not referenced by any database object