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.
Oracle eBusiness Suite Technical Reference
Release 11i - Copyright (c) 2001 - 2005 Oracle
This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is
provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and
other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to
safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or
a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential
Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c)
restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was
disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends
or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or
by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this
TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.
The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter,
please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is'
with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements.
Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this
TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's
responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the
Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs.
Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose.
Restricted Rights Legend
This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and
use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the
applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal
Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this
TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500
Oracle Parkway, Redwood City, CA 94065.
Oracle is a registered trademark. AIM Advantage, Big Business. Small Business. All Business., CDM Advantage,
.comference, ConText®, Des40®, Easy*Query, Easy*SQL®, Education Objects, EMM Advantage, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM,
GEMMS®, Gist, Hyper*SQL, instantOracle, "Internet Business Intelligence - Insight for Everyone", iSQL*Plus, JInitiator,
NLS*Workbench®, Object Marketplace, ODP Pulse, ODP Techwire, OLA,
On Oracle, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE ®, Oracle Business OnLine®,
OracleDevConnect SM, Oracle® Discoverer,
Oracle® Expert, Oracle Financials®, OracleGOLD SM,
OracleIncident SM, OracleJSP,
OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURY SM,
OracleMetaLink SM, Oraclemetals SM, OracleMobile, Oracle Names®,
Oracle NetSolutions®, Oracle® One, Oracle Open Gateways®,
Oracle OpenWorld®, OraclePLATINUM SM,
Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®,
Oracle Quality®, Oracle Secure Network Services®, OracleSILVER SM,
Oracle® SQL/Services, Oracle® SQL*TutorSM,
OracleSTERLING SM, Oracle Store®,
Oracle Transparent Gateway®, OracleWare®, Oracle8i, Oracle9i,
PC Express®, Personal Express®, PJM Advantage, PL/SQL, Pro*Ada®,
Pro*C, Pro*C/C++, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®,
Pro*PL/1®, Pro*REXX®, Profit, ProREXX, Report Card,
Secure Access 2.0, Secure Network Services®, Security Without Compromise,
SellingPoint®, SQL*Plus®, Tutor are trademarks or
registered trademarks of Oracle. Other names may be trademarks of their respective owners.
The absence of a product or service name, slogan, or logo from this list does not constitute a
waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan,
or logo.
eTRM - WMS Tables and Views
TABLE - WMS.WMS_ALLOCATIONS_GTMP
TABLE - WMS.WMS_API_HOOKED_ENTITIES
TABLE - WMS.WMS_API_HOOK_CALLS
TABLE - WMS.WMS_API_HOOK_SIGNATURES
TABLE - WMS.WMS_ASN_DETAILS
TABLE - WMS.WMS_BFLOW_LABEL_TYPE
TABLE - WMS.WMS_BUS_EVENT_DEVICES
TABLE - WMS.WMS_CAROUSEL_CONFIGURATION
TABLE - WMS.WMS_CAROUSEL_DIRECTIVE_QUEUE
TABLE - WMS.WMS_CROSSDOCK_CRITERIA_B
TABLE - WMS.WMS_CROSSDOCK_CRITERIA_TL
TABLE - WMS.WMS_DB_OBJECTS
TABLE - WMS.WMS_DB_OBJECTS_PARENTS
TABLE - WMS.WMS_DB_OBJECT_JOINS
TABLE - WMS.WMS_DB_OBJECT_REFERENCES
TABLE - WMS.WMS_DB_OBJ_REF_MEMBERS
TABLE - WMS.WMS_DEPARTMENT_SUBINVENTORIES
TABLE - WMS.WMS_DEVICES_B
TABLE - WMS.WMS_DEVICES_TL
TABLE - WMS.WMS_DEVICE_ASSIGNMENT_TEMP
TABLE - WMS.WMS_DEVICE_REQUESTS
TABLE - WMS.WMS_DEVICE_REQUESTS_HIST
TABLE - WMS.WMS_DIRECT_SHIP_TEMP
TABLE - WMS.WMS_DISPATCHED_TASKS
TABLE - WMS.WMS_DISPATCHED_TASKS_ARCH
TABLE - WMS.WMS_DISPATCHED_TASKS_HISTORY
TABLE - WMS.WMS_DISPATCH_TASKS_GTMP
TABLE - WMS.WMS_DOCK_APPOINTMENTS_B
TABLE - WMS.WMS_DOCK_APPOINTMENTS_TL
TABLE - WMS.WMS_DS_CT_WT_GTEMP
TABLE - WMS.WMS_ELS_EXP_RESOURCE
TABLE - APPS.WMS_ELS_EXP_RESOURCE_GTEMP
TABLE - WMS.WMS_ELS_GROUPED_TASKS_B
TABLE - WMS.WMS_ELS_GROUPED_TASKS_GTMP
TABLE - WMS.WMS_ELS_GROUPED_TASKS_TL
TABLE - WMS.WMS_ELS_INDIVIDUAL_TASKS_B
TABLE - WMS.WMS_ELS_INDIVIDUAL_TASKS_TL
TABLE - WMS.WMS_ELS_NON_TRACKED_USERS
TABLE - WMS.WMS_ELS_PARAMETERS
TABLE - WMS.WMS_ELS_RATINGS_SETUP
TABLE - WMS.WMS_ELS_RESOURCE_SETUP
TABLE - WMS.WMS_ELS_TRX_SRC
TABLE - WMS.WMS_EPC
TABLE - WMS.WMS_EXCEPTIONS
TABLE - WMS.WMS_EXCEPTIONS_TEMP
TABLE - WMS.WMS_FREIGHT_COST_TEMP
TABLE - WMS.WMS_LABEL_FIELDS_B
TABLE - WMS.WMS_LABEL_FIELDS_TL
TABLE - WMS.WMS_LABEL_FIELD_VARIABLES
TABLE - WMS.WMS_LABEL_FORMATS
TABLE - WMS.WMS_LABEL_REQUESTS
TABLE - WMS.WMS_LABEL_REQUESTS_HIST
TABLE - WMS.WMS_LABEL_SET_FORMATS
TABLE - WMS.WMS_LICENSE_PLATE_NUMBERS
TABLE - WMS.WMS_LOCATIONS_LOCATORS
TABLE - WMS.WMS_LPN_CONTENTS
TABLE - WMS.WMS_LPN_CONTENTS_INTERFACE
TABLE - WMS.WMS_LPN_HISTORIES
TABLE - WMS.WMS_LPN_INTERFACE
TABLE - WMS.WMS_LPN_PROCESS_TEMP
TABLE - WMS.WMS_MATERIAL_TXN_TRACE
TABLE - WMS.WMS_MSG_COMPONENTS
TABLE - WMS.WMS_MSG_TEMPLATES
TABLE - WMS.WMS_OBJECTS_B
TABLE - WMS.WMS_OBJECTS_TL
TABLE - WMS.WMS_OP_DESTINATION_SEL_APIS
TABLE - WMS.WMS_OP_OPERATION_INSTANCES
TABLE - WMS.WMS_OP_OPERTN_INSTANCES_ARCH
TABLE - WMS.WMS_OP_OPERTN_INSTANCES_HIST
TABLE - WMS.WMS_OP_PLANS_B
TABLE - WMS.WMS_OP_PLANS_TL
TABLE - WMS.WMS_OP_PLAN_DETAILS
TABLE - WMS.WMS_OP_PLAN_INSTANCES
TABLE - WMS.WMS_OP_PLAN_INSTANCES_ARCH
TABLE - WMS.WMS_OP_PLAN_INSTANCES_HIST
TABLE - WMS.WMS_ORDERED_TASKS
TABLE - WMS.WMS_ORG_HIERARCHY_OBJS
TABLE - WMS.WMS_PACKAGING_HIST
TABLE - WMS.WMS_PACKING_MATERIAL_GTEMP
TABLE - WMS.WMS_PAGE_FIELDS_B
TABLE - WMS.WMS_PAGE_FIELDS_TL
TABLE - WMS.WMS_PAGE_FIELD_VALUES
TABLE - WMS.WMS_PAGE_TEMPLATES_B
TABLE - WMS.WMS_PAGE_TEMPLATES_TL
TABLE - WMS.WMS_PAGE_TEMPLATE_FIELDS
TABLE - WMS.WMS_PARAMETERS_B
TABLE - WMS.WMS_PARAMETERS_TL
TABLE - WMS.WMS_PRINTER_IP_DEF
TABLE - WMS.WMS_PUTAWAY_GROUP_TASKS_GTMP
TABLE - WMS.WMS_REPL_DEMAND_GTMP
TABLE - WMS.WMS_RESTRICTIONS
TABLE - WMS.WMS_RULES_B
TABLE - WMS.WMS_RULES_TL
TABLE - WMS.WMS_RULE_CONSISTENCIES
TABLE - WMS.WMS_RULE_LIST_PACKAGE
TABLE - WMS.WMS_RULE_TRACE_HEADERS
TABLE - WMS.WMS_RULE_TRACE_LINES
TABLE - WMS.WMS_SAVED_QUERIES
TABLE - WMS.WMS_SELECTION_CRITERIA_TXN
TABLE - WMS.WMS_SERIAL_NUMBERS_TRACE
TABLE - WMS.WMS_SHIPPING_TRANSACTION_TEMP
TABLE - WMS.WMS_SKIP_TASK_EXCEPTIONS
TABLE - WMS.WMS_SORT_CRITERIA
TABLE - WMS.WMS_STAGINGLANES_ASSIGNMENTS
TABLE - WMS.WMS_STRATEGIES_B
TABLE - WMS.WMS_STRATEGIES_TL
TABLE - WMS.WMS_STRATEGY_ASSIGNMENTS
TABLE - WMS.WMS_STRATEGY_MEMBERS
TABLE - WMS.WMS_TASKS_TEMP
TABLE - WMS.WMS_TASK_FILTER_B
TABLE - WMS.WMS_TASK_FILTER_DTL
TABLE - WMS.WMS_TASK_FILTER_TL
TABLE - WMS.WMS_TRANSACTIONS_TEMP
TABLE - WMS.WMS_TRANSACTION_LOTS_TRACE
TABLE - WMS.WMS_TXN_CONTEXT_TEMP
TABLE - WMS.WMS_WAVEPLAN_TASKS_TEMP
TABLE - WMS.WMS_WSH_WDD_GTEMP
TABLE - WMS.WMS_XDOCK_PEGGING_GTMP
TABLE - WMS.WMS_XDOCK_SOURCE_ASSIGNMENTS
TABLE - WMS.WMS_ZONES_B
TABLE - WMS.WMS_ZONES_TL
TABLE - WMS.WMS_ZONE_LOCATORS
VIEW - APPS.WMS_ACCESS_RULES_LOV_V
VIEW - APPS.WMS_ACTIVE_EXCEPTIONS_V
VIEW - APPS.WMS_ACTIVE_TASKS_V
VIEW - APPS.WMS_BUS_EVENT_DEVICES_V
VIEW - APPS.WMS_COMPLETED_EXCEPTIONS_V
VIEW - APPS.WMS_COMPLETED_TASKS_V
VIEW - APPS.WMS_COST_GROUPS_INPUT_V
VIEW - APPS.WMS_CROSSDOCK_CRITERIA_VL
VIEW - APPS.WMS_DEPTS_V
VIEW - APPS.WMS_DEPT_SUBINVENTORIES_V
VIEW - APPS.WMS_DEVICES_VL
VIEW - APPS.WMS_DEVICE_REQUESTS_HIST_V
VIEW - APPS.WMS_DEVICE_REQUESTS_WCSV
VIEW - APPS.WMS_DISPATCHABLE_TASKS_V
VIEW - APPS.WMS_DOCKS_V
VIEW - APPS.WMS_DOCK_APPOINTMENTS_V
VIEW - APPS.WMS_ELS_GROUPED_TASKS_VL
VIEW - APPS.WMS_ELS_INDIVIDUAL_TASKS_VL
VIEW - APPS.WMS_EXCEPTIONS_V
VIEW - APPS.WMS_ITEM_LOCATIONS_KFV
VIEW - APPS.WMS_LABEL_FIELDS_VL
VIEW - APPS.WMS_LABEL_FIELD_VARIABLES_VL
VIEW - APPS.WMS_LABEL_FORMATS_V
VIEW - APPS.WMS_LABEL_REQUESTS_HIST_V
VIEW - APPS.WMS_LABEL_SET_FORMATS_V
VIEW - APPS.WMS_LICENSE_PLATE_NUMBERS_V
VIEW - APPS.WMS_LOADED_QUANTITIES_V
VIEW - APPS.WMS_LPN_CONTENTS_DETAIL_V
VIEW - APPS.WMS_LPN_CONTENTS_LOT_V
VIEW - APPS.WMS_LPN_CONTENTS_SERIAL_V
VIEW - APPS.WMS_LPN_CONTENTS_V
VIEW - APPS.WMS_OBJECTS_HIERARCHY_LOV_V
VIEW - APPS.WMS_OBJECTS_OPERAND_LOV_V
VIEW - APPS.WMS_OBJECTS_RULE_LOV_V
VIEW - APPS.WMS_OBJECTS_STRATEGY_LOV_V
VIEW - APPS.WMS_OBJECTS_STRATEGY_V
VIEW - APPS.WMS_OBJECTS_VL
VIEW - APPS.WMS_ONHAND_AND_LOADED_QTY_V
VIEW - APPS.WMS_OP_PLANS_V
VIEW - APPS.WMS_OP_PLANS_VL
VIEW - APPS.WMS_OP_PLAN_DETAILS_V
VIEW - APPS.WMS_ORG_HIERARCHY_OBJS_V
VIEW - APPS.WMS_PACKING_KITTING_V
VIEW - APPS.WMS_PACKING_LPN_CONT_V
VIEW - APPS.WMS_PACKING_MATERIAL_V
VIEW - APPS.WMS_PAGE_CONFIG_UI_V
VIEW - APPS.WMS_PAGE_FIELDS_VL
VIEW - APPS.WMS_PAGE_TEMPLATES_FIELDS_F_V
VIEW - APPS.WMS_PAGE_TEMPLATES_VL
VIEW - APPS.WMS_PARAMETERS_LOV_V
VIEW - APPS.WMS_PARAMETERS_VL
VIEW - APPS.WMS_PENDING_EXCEPTIONS_V
VIEW - APPS.WMS_PENDING_TASKS_V
VIEW - APPS.WMS_PERSON_RESOURCE_UTT_V
VIEW - APPS.WMS_RESTRICTIONS_V
VIEW - APPS.WMS_RULES_V
VIEW - APPS.WMS_RULES_VL
VIEW - APPS.WMS_RULE_CONSISTENCIES_V
VIEW - APPS.WMS_SELECTION_CRITERIA_TXN_V
VIEW - APPS.WMS_SHIP_TO_SITES_V
VIEW - APPS.WMS_SORT_CRITERIA_V
VIEW - APPS.WMS_STAGINGLANES_ASSIGNMENTS_V
VIEW - APPS.WMS_STRATEGIES_V
VIEW - APPS.WMS_STRATEGIES_VL
VIEW - APPS.WMS_STRATEGY_ASSIGNMENTS_V
VIEW - APPS.WMS_STRATEGY_ASSIGNMENTS_V2
VIEW - APPS.WMS_STRATEGY_MAT_TXN_TMP_V
VIEW - APPS.WMS_STRATEGY_MEMBERS_V
VIEW - APPS.WMS_SUGGESTIONS_TEMP_V
VIEW - APPS.WMS_SUGGESTIONS_TRACE_V
VIEW - APPS.WMS_TASKS_V
VIEW - APPS.WMS_TASK_FILTER_VL
VIEW - APPS.WMS_TRX_DETAILS_TMP_V
VIEW - APPS.WMS_TXN_REQUEST_LINES_TRACE_V
VIEW - APPS.WMS_WAVEPLAN_TASKS_V
VIEW - APPS.WMS_WAVEPLAN_TASK_EXCEPTIONS_V
VIEW - APPS.WMS_XDOCK_SOURCE_ASSIGNMENTS_V
VIEW - APPS.WMS_ZONES_VL
VIEW - APPS.WMS_ZONE_LOCATORS_ALL_V
VIEW - APPS.WMS_ZONE_LOCATORS_TEMP
VIEW - APPS.WMS_ZONE_LOCATORS_V
VIEW - APPS.WMS_ZONE_LPN_FOR_RULE
Table: WMS_ALLOCATIONS_GTMP
[top of page]
WMS.WMS_ALLOCATIONS_GTMP does not reference any database object
WMS.WMS_ALLOCATIONS_GTMP is referenced by following:
APPS
SYNONYM - WMS_ALLOCATIONS_GTMP
[top of page]
Table: WMS_API_HOOKED_ENTITIES
[top of page]
WMS.WMS_API_HOOKED_ENTITIES does not reference any database object
WMS.WMS_API_HOOKED_ENTITIES is referenced by following:
APPS
SYNONYM - WMS_API_HOOKED_ENTITIES
[top of page]
Table: WMS_API_HOOK_CALLS
[top of page]
WMS.WMS_API_HOOK_CALLS does not reference any database object
WMS.WMS_API_HOOK_CALLS is referenced by following:
APPS
SYNONYM - WMS_API_HOOK_CALLS
[top of page]
Table: WMS_API_HOOK_SIGNATURES
[top of page]
WMS.WMS_API_HOOK_SIGNATURES does not reference any database object
WMS.WMS_API_HOOK_SIGNATURES is referenced by following:
APPS
SYNONYM - WMS_API_HOOK_SIGNATURES
[top of page]
Table: WMS_ASN_DETAILS
Description: Stored the WMS related information about the ASN shipped
[top of page]
WMS.WMS_ASN_DETAILS does not reference any database object
WMS.WMS_ASN_DETAILS is referenced by following:
APPS
SYNONYM - WMS_ASN_DETAILS
[top of page]
Table: WMS_BFLOW_LABEL_TYPE
Description: This table stores the business flow to label types relationship. This relationship is mandatory for labels to print from business flows like receipt, inspection, cross dock and so on and so forth. Please refer to the WMS documentation for
Primary Key: WMS_BFLOW_LABEL_TYPE_PK
BUSINESS_FLOW_CODE
DOCUMENT_ID
LEVEL_TYPE_CODE
LEVEL_VALUE_ID
[top of page]
WMS.WMS_BFLOW_LABEL_TYPE does not reference any database object
WMS.WMS_BFLOW_LABEL_TYPE is referenced by following:
APPS
SYNONYM - WMS_BFLOW_LABEL_TYPE
[top of page]
Table: WMS_BUS_EVENT_DEVICES
Description: This table stores the mapping between business event and devices.
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_BUS_EVENT_DEVICES.DEVICE_ID
WMS_DEVICES_B
WMS_BUS_EVENT_DEVICES.ORGANIZATION_ID
MTL_PARAMETERS
[top of page]
WMS.WMS_BUS_EVENT_DEVICES does not reference any database object
WMS.WMS_BUS_EVENT_DEVICES is referenced by following:
APPS
SYNONYM - WMS_BUS_EVENT_DEVICES
[top of page]
Table: WMS_CAROUSEL_CONFIGURATION
Description: Standard WHO Column
Primary Key: WMS_CAROUSEL_CONFIGURATION_PK
CAROUSEL_CONFIGURATION_ID
[top of page]
WMS.WMS_CAROUSEL_CONFIGURATION does not reference any database object
WMS.WMS_CAROUSEL_CONFIGURATION is referenced by following:
APPS
SYNONYM - WMS_CAROUSEL_CONFIGURATION
[top of page]
Table: WMS_CAROUSEL_DIRECTIVE_QUEUE
Primary Key: WMS_CAROUSEL_DIRECTIVE_Q_PK
CAROUSEL_DIRECTIVE_QUEUE_ID
[top of page]
WMS.WMS_CAROUSEL_DIRECTIVE_QUEUE does not reference any database object
WMS.WMS_CAROUSEL_DIRECTIVE_QUEUE is referenced by following:
APPS
SYNONYM - WMS_CAROUSEL_DIRECTIVE_QUEUE
[top of page]
Table: WMS_CROSSDOCK_CRITERIA_B
Description: Table to store WMS Crossdock Criteria
Primary Key: WMS_CROSSDOCK_CRITERIA_B_PK
CRITERION_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
MTL_PARAMETERS.DEFAULT_CROSSDOCK_CRITERIA_ID
WMS_CROSSDOCK_CRITERIA_B
[top of page]
WMS.WMS_CROSSDOCK_CRITERIA_B does not reference any database object
WMS.WMS_CROSSDOCK_CRITERIA_B is referenced by following:
APPS
SYNONYM - WMS_CROSSDOCK_CRITERIA
SYNONYM - WMS_CROSSDOCK_CRITERIA_B
[top of page]
Table: WMS_CROSSDOCK_CRITERIA_TL
Description: Translation table for WMS Crossdock Criteria
Primary Key: WMS_CROSSDOCK_CRITERIA_TL_PK
CRITERION_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_CROSSDOCK_CRITERIA_TL.CRITERION_ID
%
[top of page]
WMS.WMS_CROSSDOCK_CRITERIA_TL does not reference any database object
WMS.WMS_CROSSDOCK_CRITERIA_TL is referenced by following:
APPS
SYNONYM - WMS_CROSSDOCK_CRITERIA_TL
[top of page]
Table: WMS_DB_OBJECTS
Description: WMS Database Objects
Primary Key: WMS_DB_OBJECTS_PK
DB_OBJECT_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_DB_OBJECTS.CONTEXT_PARAMETER_ID
WMS_PARAMETERS_B
WMS_DB_OBJECTS.PARENT_DB_OBJECT_ID
WMS_DB_OBJECTS
Foreign Keys to this table:
Foreign Key Column
Foreign Table
WMS_DB_OBJECTS.PARENT_DB_OBJECT_ID
WMS_DB_OBJECTS
WMS_DB_OBJECTS_PARENTS.DB_OBJECT_ID
WMS_DB_OBJECTS
WMS_DB_OBJECT_JOINS.DB_OBJECT_ID
WMS_DB_OBJECTS
WMS_DB_OBJ_REF_MEMBERS.DB_OBJECT_ID
WMS_DB_OBJECTS
WMS_OBJECTS_B.STRAT_ASGMT_DB_OBJECT_ID
WMS_DB_OBJECTS
WMS_PARAMETERS_B.DB_OBJECT_ID
WMS_DB_OBJECTS
[top of page]
WMS.WMS_DB_OBJECTS does not reference any database object
WMS.WMS_DB_OBJECTS is referenced by following:
APPS
SYNONYM - WMS_DB_OBJECTS
[top of page]
Table: WMS_DB_OBJECTS_PARENTS
Description: WMS Database Object Parents
Primary Key: WMS_DB_OBJECTS_PARENT_PK
DB_OBJECT_ID
TYPE_CODE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_DB_OBJECTS_PARENTS.DB_OBJECT_ID
WMS_DB_OBJECTS
[top of page]
WMS.WMS_DB_OBJECTS_PARENTS does not reference any database object
WMS.WMS_DB_OBJECTS_PARENTS is referenced by following:
APPS
SYNONYM - WMS_DB_OBJECTS_PARENTS
[top of page]
Table: WMS_DB_OBJECT_JOINS
Description: WMS Database Object Joining Condition
Primary Key: WMS_DB_OBJECT_JOINS_PK
DB_OBJECT_ID
TYPE_CODE
SEQUENCE_NUMBER
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_DB_OBJECT_JOINS.PARAMETER_ID
WMS_PARAMETERS_B
WMS_DB_OBJECT_JOINS.PARENT_PARAMETER_ID
WMS_PARAMETERS_B
WMS_DB_OBJECT_JOINS.DB_OBJECT_ID
WMS_DB_OBJECTS
[top of page]
WMS.WMS_DB_OBJECT_JOINS does not reference any database object
WMS.WMS_DB_OBJECT_JOINS is referenced by following:
APPS
SYNONYM - WMS_DB_OBJECT_JOINS
[top of page]
Table: WMS_DB_OBJECT_REFERENCES
Description: WMS Database Object References
Primary Key: WMS_DB_OBJECT_REFERENCE_PK
DB_OBJECT_REFERENCE_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
WMS_DB_OBJ_REF_MEMBERS.DB_OBJECT_REFERENCE_ID
WMS_DB_OBJECT_REFERENCES
WMS_PARAMETERS_B.DB_OBJECT_REFERENCE_ID
WMS_DB_OBJECT_REFERENCES
[top of page]
WMS.WMS_DB_OBJECT_REFERENCES does not reference any database object
WMS.WMS_DB_OBJECT_REFERENCES is referenced by following:
APPS
SYNONYM - WMS_DB_OBJECT_REFERENCES
[top of page]
Table: WMS_DB_OBJ_REF_MEMBERS
Description: WMS Database Object Reference Members
Primary Key: WMS_DB_OBJ_REF_MEMBERS_PK
DB_OBJECT_REFERENCE_ID
SEQUENCE_NUMBER
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_DB_OBJ_REF_MEMBERS.DB_OBJECT_REFERENCE_ID
WMS_DB_OBJECT_REFERENCES
WMS_DB_OBJ_REF_MEMBERS.DB_OBJECT_ID
WMS_DB_OBJECTS
[top of page]
WMS.WMS_DB_OBJ_REF_MEMBERS does not reference any database object
WMS.WMS_DB_OBJ_REF_MEMBERS is referenced by following:
APPS
SYNONYM - WMS_DB_OBJ_REF_MEMBERS
[top of page]
Table: WMS_DEPARTMENT_SUBINVENTORIES
Description: This is a cross reference table for departments and subinventories.
Primary Key: WMS_DEPARTMENT_SUBINVENTORI_PK
ORGANIZATION_ID
SUBINVENTORY_CODE
DEPARTMENT_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_DEPARTMENT_SUBINVENTORIES.SUBINVENTORY_CODE
WMS_DEPARTMENT_SUBINVENTORIES.ORGANIZATION_ID
MTL_SECONDARY_INVENTORIES
WMS_DEPARTMENT_SUBINVENTORIES.DEPARTMENT_ID
BOM_DEPARTMENTS
WMS_DEPARTMENT_SUBINVENTORIES.ORGANIZATION_ID
MTL_PARAMETERS
[top of page]
WMS.WMS_DEPARTMENT_SUBINVENTORIES does not reference any database object
WMS.WMS_DEPARTMENT_SUBINVENTORIES is referenced by following:
APPS
SYNONYM - WMS_DEPARTMENT_SUBINVENTORIES
[top of page]
Table: WMS_DEVICES_B
Description: Device DefinitionTable
Primary Key: WMS_DEVICES_B_PK1
DEVICE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_DEVICES_B.ORGANIZATION_ID
MTL_PARAMETERS
Foreign Keys to this table:
Foreign Key Column
Foreign Table
WMS_BUS_EVENT_DEVICES.DEVICE_ID
WMS_DEVICES_B
WMS_DEVICES_TL.DEVICE_ID
WMS_DEVICES_B
WMS_DEVICE_REQUESTS_HIST.DEVICE_ID
WMS_DEVICES_B
[top of page]
WMS.WMS_DEVICES_B does not reference any database object
WMS.WMS_DEVICES_B is referenced by following:
APPS
SYNONYM - WMS_DEVICES_B
[top of page]
Table: WMS_DEVICES_TL
Description: This table stores translatable columns.Device_Id is the link between this table and the table WMS_DEVICES_B.
Primary Key: WMS_DEVICES_TL_PK1
DEVICE_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_DEVICES_TL.DEVICE_ID
WMS_DEVICES_B
[top of page]
WMS.WMS_DEVICES_TL does not reference any database object
WMS.WMS_DEVICES_TL is referenced by following:
APPS
SYNONYM - WMS_DEVICES_TL
[top of page]
Table: WMS_DEVICE_ASSIGNMENT_TEMP
Description: Device assignment temporary table
Primary Key: WMS_DEVICE_ASSIGNMENT_TEMP_PK
ASSIGNMENT_TEMP_ID
[top of page]
WMS.WMS_DEVICE_ASSIGNMENT_TEMP does not reference any database object
WMS.WMS_DEVICE_ASSIGNMENT_TEMP is referenced by following:
APPS
SYNONYM - WMS_DEVICE_ASSIGNMENT_TEMP
[top of page]
Table: WMS_DEVICE_REQUESTS
[top of page]
WMS.WMS_DEVICE_REQUESTS does not reference any database object
WMS.WMS_DEVICE_REQUESTS is referenced by following:
APPS
SYNONYM - WMS_DEVICE_REQUESTS
[top of page]
Table: WMS_DEVICE_REQUESTS_HIST
Description: History Table for device request. This table stores all the device requests that have been submitted.
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_DEVICE_REQUESTS_HIST.DEVICE_ID
WMS_DEVICES_B
[top of page]
WMS.WMS_DEVICE_REQUESTS_HIST does not reference any database object
WMS.WMS_DEVICE_REQUESTS_HIST is referenced by following:
APPS
SYNONYM - WMS_DEVICE_REQUESTS_HIST
[top of page]
Table: WMS_DIRECT_SHIP_TEMP
Description: Temporary table for processing the LPNs to be directly shipped bypassing Pick Release/Pick Confirm.
[top of page]
WMS.WMS_DIRECT_SHIP_TEMP does not reference any database object
WMS.WMS_DIRECT_SHIP_TEMP is referenced by following:
APPS
SYNONYM - WMS_DIRECT_SHIP_TEMP
[top of page]
Table: WMS_DISPATCHED_TASKS
Description: Dispatched Tasks Table
Primary Key: WMS_DISPATCHED_TASKS_PK
TASK_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_DISPATCHED_TASKS.ORGANIZATION_ID
MTL_PARAMETERS
WMS_DISPATCHED_TASKS.EQUIPMENT_INSTANCE
WMS_DISPATCHED_TASKS.EQUIPMENT_ID
WMS_DISPATCHED_TASKS.ORGANIZATION_ID
MTL_SERIAL_NUMBERS
WMS_DISPATCHED_TASKS.PERSON_RESOURCE_ID
BOM_RESOURCES
WMS_DISPATCHED_TASKS.MACHINE_RESOURCE_ID
BOM_RESOURCES
WMS_DISPATCHED_TASKS.PERSON_ID
WMS_DISPATCHED_TASKS.EFFECTIVE_START_DATE
WMS_DISPATCHED_TASKS.EFFECTIVE_END_DATE
PER_ALL_PEOPLE_F
Foreign Keys to this table:
Foreign Key Column
Foreign Table
WMS_EXCEPTIONS.TASK_ID
WMS_DISPATCHED_TASKS
WMS_SKIP_TASK_EXCEPTIONS.TASK_ID
WMS_DISPATCHED_TASKS
[top of page]
WMS.WMS_DISPATCHED_TASKS does not reference any database object
WMS.WMS_DISPATCHED_TASKS is referenced by following:
APPS
SYNONYM - WMS_DISPATCHED_TASKS
[top of page]
Table: WMS_DISPATCHED_TASKS_ARCH
Description: Archive Table for WMS_DISPATCHED_TASKS. Stores information about all tasks that have been completed
Primary Key: WMS_DISPATCHED_TASKS_ARCH_PK
TASK_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_DISPATCHED_TASKS_ARCH.EQUIPMENT_INSTANCE
WMS_DISPATCHED_TASKS_ARCH.EQUIPMENT_ID
WMS_DISPATCHED_TASKS_ARCH.ORGANIZATION_ID
MTL_SERIAL_NUMBERS
WMS_DISPATCHED_TASKS_ARCH.ORGANIZATION_ID
MTL_PARAMETERS
WMS_DISPATCHED_TASKS_ARCH.PERSON_RESOURCE_ID
BOM_RESOURCES
WMS_DISPATCHED_TASKS_ARCH.MACHINE_RESOURCE_ID
BOM_RESOURCES
WMS_DISPATCHED_TASKS_ARCH.PERSON_ID
WMS_DISPATCHED_TASKS_ARCH.EFFECTIVE_START_DATE
WMS_DISPATCHED_TASKS_ARCH.EFFECTIVE_END_DATE
PER_ALL_PEOPLE_F
[top of page]
WMS.WMS_DISPATCHED_TASKS_ARCH does not reference any database object
WMS.WMS_DISPATCHED_TASKS_ARCH is referenced by following:
APPS
SYNONYM - WMS_DISPATCHED_TASKS_ARCH
[top of page]
Table: WMS_DISPATCHED_TASKS_HISTORY
Description: History Table for WMS_DISPATCHED_TASKS. Stores information about all tasks that have been completed
Primary Key: WMS_DISPATCHED_TASKS_HIST_PK
TASK_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_DISPATCHED_TASKS_HISTORY.TRANSACTION_ID
MTL_MATERIAL_TRANSACTIONS
WMS_DISPATCHED_TASKS_HISTORY.EQUIPMENT_INSTANCE
WMS_DISPATCHED_TASKS_HISTORY.EQUIPMENT_ID
WMS_DISPATCHED_TASKS_HISTORY.ORGANIZATION_ID
MTL_SERIAL_NUMBERS
WMS_DISPATCHED_TASKS_HISTORY.ORGANIZATION_ID
MTL_PARAMETERS
WMS_DISPATCHED_TASKS_HISTORY.PERSON_RESOURCE_ID
BOM_RESOURCES
WMS_DISPATCHED_TASKS_HISTORY.MACHINE_RESOURCE_ID
BOM_RESOURCES
WMS_DISPATCHED_TASKS_HISTORY.PERSON_ID
WMS_DISPATCHED_TASKS_HISTORY.EFFECTIVE_START_DATE
WMS_DISPATCHED_TASKS_HISTORY.EFFECTIVE_END_DATE
PER_ALL_PEOPLE_F
[top of page]
WMS.WMS_DISPATCHED_TASKS_HISTORY does not reference any database object
WMS.WMS_DISPATCHED_TASKS_HISTORY is referenced by following:
APPS
SYNONYM - WMS_DISPATCHED_TASKS_HISTORY
[top of page]
Table: WMS_DISPATCH_TASKS_GTMP
[top of page]
WMS.WMS_DISPATCH_TASKS_GTMP does not reference any database object
WMS.WMS_DISPATCH_TASKS_GTMP is referenced by following:
APPS
SYNONYM - WMS_DISPATCH_TASKS_GTMP
[top of page]
Table: WMS_DOCK_APPOINTMENTS_B
Description: Base table for WMS dock assignment form. It stores dock door (locator) ID, trip stop ID for outbound appointment, start time, end time, and repetitive information for appointments.
Primary Key: WMS_DOCK_APPOINTMENTS_B
DOCK_APPOINTMENT_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_DOCK_APPOINTMENTS_B.TRIP_STOP
WSH_TRIP_STOPS
WMS_DOCK_APPOINTMENTS_B.DOCK_ID
WMS_DOCK_APPOINTMENTS_B.ORGANIZATION_ID
MTL_ITEM_LOCATIONS
[top of page]
WMS.WMS_DOCK_APPOINTMENTS_B does not reference any database object
WMS.WMS_DOCK_APPOINTMENTS_B is referenced by following:
APPS
SYNONYM - WMS_DOCK_APPOINTMENTS_B
[top of page]
Table: WMS_DOCK_APPOINTMENTS_TL
Description: WMS dock assignment translation table. Its base table is WMS_DOCK_APPOINTMENTS_B.
Primary Key: WMS_DOCK_APPOINTMENTS_TL_PK
DOCK_APPOINTMENT_ID
LANGUAGE
[top of page]
WMS.WMS_DOCK_APPOINTMENTS_TL does not reference any database object
WMS.WMS_DOCK_APPOINTMENTS_TL is referenced by following:
APPS
SYNONYM - WMS_DOCK_APPOINTMENTS_TL
[top of page]
Table: WMS_DS_CT_WT_GTEMP
[top of page]
WMS.WMS_DS_CT_WT_GTEMP does not reference any database object
WMS.WMS_DS_CT_WT_GTEMP is referenced by following:
APPS
SYNONYM - WMS_DS_CT_WT_GTEMP
[top of page]
Table: WMS_ELS_EXP_RESOURCE
Description: This is the table which wil be populated by all the expected work when the Concurrent program Expected Resource Requirement Analysis will be launched. This table will also hold information regarding what is the estimated time and estimated
Primary Key: WMS_ELS_EXP_RESOURCE_PK
ELS_EXP_RESOURCE_ID
[top of page]
WMS.WMS_ELS_EXP_RESOURCE does not reference any database object
WMS.WMS_ELS_EXP_RESOURCE is referenced by following:
APPS
SYNONYM - WMS_ELS_EXP_RESOURCE
[top of page]
Table: WMS_ELS_EXP_RESOURCE_GTEMP
[top of page]
APPS.WMS_ELS_EXP_RESOURCE_GTEMP does not reference any database object
APPS.WMS_ELS_EXP_RESOURCE_GTEMP is referenced by following:
APPS
PACKAGE BODY - WMS_LMS_EXPECTED_RES
[top of page]
Table: WMS_ELS_GROUPED_TASKS_B
Description: This table is for storing all the setup information for the grouped tasks.
Primary Key: WMS_ELS_GROUPED_TASKS_PK
ELS_GROUP_ID
[top of page]
WMS.WMS_ELS_GROUPED_TASKS_B does not reference any database object
WMS.WMS_ELS_GROUPED_TASKS_B is referenced by following:
APPS
SYNONYM - WMS_ELS_GROUPED_TASKS_B
[top of page]
Table: WMS_ELS_GROUPED_TASKS_GTMP
[top of page]
WMS.WMS_ELS_GROUPED_TASKS_GTMP does not reference any database object
WMS.WMS_ELS_GROUPED_TASKS_GTMP is referenced by following:
APPS
SYNONYM - WMS_ELS_GROUPED_TASKS_GTMP
[top of page]
Table: WMS_ELS_GROUPED_TASKS_TL
Description: This table is for storing all the translatable setup information like description for the grouped tasks.
Primary Key: WMS_ELS_GROUPED_TASKS_TL_PK
ELS_GROUP_ID
LANGUAGE
[top of page]
WMS.WMS_ELS_GROUPED_TASKS_TL does not reference any database object
WMS.WMS_ELS_GROUPED_TASKS_TL is referenced by following:
APPS
SYNONYM - WMS_ELS_GROUPED_TASKS_TL
[top of page]
Table: WMS_ELS_INDIVIDUAL_TASKS_B
Description: This table is for storing all the setup information for the individual tasks.
Primary Key: WMS_ELS_INDIVIDUAL_TASKS_PK
ELS_DATA_ID
[top of page]
WMS.WMS_ELS_INDIVIDUAL_TASKS_B does not reference any database object
WMS.WMS_ELS_INDIVIDUAL_TASKS_B is referenced by following:
APPS
SYNONYM - WMS_ELS_INDIVIDUAL_TASKS_B
[top of page]
Table: WMS_ELS_INDIVIDUAL_TASKS_TL
Description: This table is for storing all the translatable setup information like description for the individual tasks.
Primary Key: WMS_ELS_INDIVIDUAL_TASKS_TL_PK
ELS_DATA_ID
LANGUAGE
[top of page]
WMS.WMS_ELS_INDIVIDUAL_TASKS_TL does not reference any database object
WMS.WMS_ELS_INDIVIDUAL_TASKS_TL is referenced by following:
APPS
SYNONYM - WMS_ELS_INDIVIDUAL_TASKS_TL
[top of page]
Table: WMS_ELS_NON_TRACKED_USERS
Description: This table will hold the information for the list of non-tracked users for the organization.
Primary Key: WMS_ELS_NON_TRACKED_USERS_PK
ELS_NON_TRACKED_USER_ID
[top of page]
WMS.WMS_ELS_NON_TRACKED_USERS does not reference any database object
WMS.WMS_ELS_NON_TRACKED_USERS is referenced by following:
APPS
SYNONYM - WMS_ELS_NON_TRACKED_USERS
[top of page]
Table: WMS_ELS_PARAMETERS
Description: This table will hold the global setup informnation for a labor management enabled warehouse.
Primary Key: WMS_ELS_PARAMETERS_PK
ELS_PARAMETER_ID
[top of page]
WMS.WMS_ELS_PARAMETERS does not reference any database object
WMS.WMS_ELS_PARAMETERS is referenced by following:
APPS
SYNONYM - WMS_ELS_PARAMETERS
[top of page]
Table: WMS_ELS_RATINGS_SETUP
Description: This table will hold the ratings setup informnation for a labor management enabled warehouse.
Primary Key: WMS_ELS_RATINGS_SETUP_PK
ELS_RATINGS_SETUP_ID
[top of page]
WMS.WMS_ELS_RATINGS_SETUP does not reference any database object
WMS.WMS_ELS_RATINGS_SETUP is referenced by following:
APPS
SYNONYM - WMS_ELS_RATINGS_SETUP
[top of page]
Table: WMS_ELS_RESOURCE_SETUP
Description: This table will hold the resource setup informnation for different activity and activity details for a labor management enabled warehouse.
Primary Key: WMS_ELS_RESOURCE_SETUP_PK
WMS_ELS_RESOURCE_SETUP_ID
[top of page]
WMS.WMS_ELS_RESOURCE_SETUP does not reference any database object
WMS.WMS_ELS_RESOURCE_SETUP is referenced by following:
APPS
SYNONYM - WMS_ELS_RESOURCE_SETUP
[top of page]
Table: WMS_ELS_TRX_SRC
Description: This table will hold all the details for labor tracked transactions for a labor management enabled warehouse. Additionally the table will also hold the information regarding the user who has done the transaction and what is the rating and t
Primary Key: WMS_ELS_TRX_SRC_PK
ELS_TRX_SRC_ID
[top of page]
WMS.WMS_ELS_TRX_SRC does not reference any database object
WMS.WMS_ELS_TRX_SRC is referenced by following:
APPS
SYNONYM - WMS_ELS_TRX_SRC
[top of page]
Table: WMS_EPC
Description: Stores EPC cross-reference information
[top of page]
WMS.WMS_EPC does not reference any database object
WMS.WMS_EPC is referenced by following:
APPS
SYNONYM - WMS_EPC
[top of page]
Table: WMS_EXCEPTIONS
Description: Table to capture task exceptions
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_EXCEPTIONS.TASK_ID
WMS_DISPATCHED_TASKS
WMS_EXCEPTIONS.INVENTORY_ITEM_ID
WMS_EXCEPTIONS.ORGANIZATION_ID
WMS_EXCEPTIONS.LOT_NUMBER
MTL_LOT_NUMBERS
WMS_EXCEPTIONS.REASON_ID
MTL_TRANSACTION_REASONS
WMS_EXCEPTIONS.PERSON_ID
WMS_EXCEPTIONS.EFFECTIVE_START_DATE
WMS_EXCEPTIONS.EFFECTIVE_END_DATE
PER_ALL_PEOPLE_F
WMS_EXCEPTIONS.INVENTORY_ITEM_ID
WMS_EXCEPTIONS.ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B
WMS_EXCEPTIONS.ORGANIZATION_ID
MTL_PARAMETERS
WMS_EXCEPTIONS.TRANSACTION_HEADER_ID
MTL_MATERIAL_TRANSACTIONS_TEMP
WMS_EXCEPTIONS.SUBINVENTORY_CODE
WMS_EXCEPTIONS.ORGANIZATION_ID
MTL_SECONDARY_INVENTORIES
WMS_EXCEPTIONS.INVENTORY_LOCATION_ID
WMS_EXCEPTIONS.ORGANIZATION_ID
MTL_ITEM_LOCATIONS
WMS_EXCEPTIONS.INVENTORY_ITEM_ID
WMS_EXCEPTIONS.ORGANIZATION_ID
WMS_EXCEPTIONS.REVISION
MTL_ITEM_REVISIONS_B
[top of page]
WMS.WMS_EXCEPTIONS does not reference any database object
WMS.WMS_EXCEPTIONS is referenced by following:
APPS
SYNONYM - WMS_EXCEPTIONS
[top of page]
Table: WMS_EXCEPTIONS_TEMP
[top of page]
WMS.WMS_EXCEPTIONS_TEMP does not reference any database object
WMS.WMS_EXCEPTIONS_TEMP is referenced by following:
APPS
SYNONYM - WMS_EXCEPTIONS_TEMP
[top of page]
Table: WMS_FREIGHT_COST_TEMP
Description: Temporary table to store Freight Cost Information for LPN or Delivery or Trip and process for direct ship of LPN.
[top of page]
WMS.WMS_FREIGHT_COST_TEMP does not reference any database object
WMS.WMS_FREIGHT_COST_TEMP is referenced by following:
APPS
SYNONYM - WMS_FREIGHT_COST_TEMP
[top of page]
Table: WMS_LABEL_FIELDS_B
Description: This table stores the list of all accepted label fields for a specific Label Type defined in the lookups. While designing alabel format for a label type, the fields in the format are validated against the data in this table.
Primary Key: WMS_LABEL_FIELDS_B_PK1
LABEL_FIELD_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
WMS_LABEL_FIELD_VARIABLES.LABEL_FIELD_ID
WMS_LABEL_FIELDS_B
WMS_LABEL_FIELDS_TL.LABEL_FIELD_ID
WMS_LABEL_FIELDS_B
[top of page]
WMS.WMS_LABEL_FIELDS_B does not reference any database object
WMS.WMS_LABEL_FIELDS_B is referenced by following:
APPS
SYNONYM - WMS_LABEL_FIELDS_B
[top of page]
Table: WMS_LABEL_FIELDS_TL
Description: This table stores translatabke columns. Labek_field_id is the link between this table and the table WMS_LABEL_FIELDS_B.
Primary Key: WMS_LABEL_FIELDS_TL_PK1
LABEL_FIELD_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_LABEL_FIELDS_TL.LABEL_FIELD_ID
WMS_LABEL_FIELDS_B
[top of page]
WMS.WMS_LABEL_FIELDS_TL does not reference any database object
WMS.WMS_LABEL_FIELDS_TL is referenced by following:
APPS
SYNONYM - WMS_LABEL_FIELDS_TL
[top of page]
Table: WMS_LABEL_FIELD_VARIABLES
Description: This table stores all the label field variables that are required in a cerain label format.
Primary Key: WMS_LABEL_FIELD_VARIABLES_PK1
LABEL_FORMAT_ID
LABEL_FIELD_ID
FIELD_VARIABLE_NAME
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_LABEL_FIELD_VARIABLES.LABEL_FIELD_ID
WMS_LABEL_FIELDS_B
WMS_LABEL_FIELD_VARIABLES.LABEL_FORMAT_ID
WMS_LABEL_FORMATS
[top of page]
WMS.WMS_LABEL_FIELD_VARIABLES does not reference any database object
WMS.WMS_LABEL_FIELD_VARIABLES is referenced by following:
APPS
SYNONYM - WMS_LABEL_FIELD_VARIABLES
[top of page]
Table: WMS_LABEL_FORMATS
Description: This table stores a list of all label formats defined in the system for a label type. During label printing execution using the rules engine an appropriate label format will be picked and printed.
Primary Key: WMS_LABEL_FORMATS_PK1
LABEL_FORMAT_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
WMS_LABEL_REQUESTS.LABEL_FORMAT_ID
WMS_LABEL_FORMATS
WMS_LABEL_FIELD_VARIABLES.LABEL_FORMAT_ID
WMS_LABEL_FORMATS
[top of page]
WMS.WMS_LABEL_FORMATS does not reference any database object
WMS.WMS_LABEL_FORMATS is referenced by following:
APPS
SYNONYM - WMS_LABEL_FORMATS
[top of page]
Table: WMS_LABEL_REQUESTS
Description: 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.
Primary Key: WMS_LABEL_REQUESTS_PK
LABEL_REQUEST_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_LABEL_REQUESTS.ORGANIZATION_ID
MTL_PARAMETERS
WMS_LABEL_REQUESTS.LABEL_FORMAT_ID
WMS_LABEL_FORMATS
[top of page]
WMS.WMS_LABEL_REQUESTS does not reference any database object
WMS.WMS_LABEL_REQUESTS is referenced by following:
APPS
SYNONYM - WMS_LABEL_REQUESTS
[top of page]
Table: WMS_LABEL_REQUESTS_HIST
Description: History Table for label request. This table stores all the label requests that have been submitted.
[top of page]
WMS.WMS_LABEL_REQUESTS_HIST does not reference any database object
WMS.WMS_LABEL_REQUESTS_HIST is referenced by following:
APPS
SYNONYM - WMS_LABEL_REQUESTS_HIST
[top of page]
Table: WMS_LABEL_SET_FORMATS
Description: This table is key to Label-set feature in WMS. It stores formats and set relationship.
[top of page]
WMS.WMS_LABEL_SET_FORMATS does not reference any database object
WMS.WMS_LABEL_SET_FORMATS is referenced by following:
APPS
SYNONYM - WMS_LABEL_SET_FORMATS
[top of page]
Table: WMS_LICENSE_PLATE_NUMBERS
Description: Used to store the information related to a container instance (LPN)
Primary Key: WMS_LICENSE_PLATE_NUMBERS_PK
LPN_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_LICENSE_PLATE_NUMBERS.ORGANIZATION_ID
MTL_PARAMETERS
WMS_LICENSE_PLATE_NUMBERS.LOCATOR_ID
WMS_LICENSE_PLATE_NUMBERS.ORGANIZATION_ID
MTL_ITEM_LOCATIONS
WMS_LICENSE_PLATE_NUMBERS.INVENTORY_ITEM_ID
WMS_LICENSE_PLATE_NUMBERS.ORGANIZATION_ID
WMS_LICENSE_PLATE_NUMBERS.REVISION
MTL_ITEM_REVISIONS_B
WMS_LICENSE_PLATE_NUMBERS.INVENTORY_ITEM_ID
WMS_LICENSE_PLATE_NUMBERS.ORGANIZATION_ID
WMS_LICENSE_PLATE_NUMBERS.LOT_NUMBER
MTL_LOT_NUMBERS
WMS_LICENSE_PLATE_NUMBERS.SUBINVENTORY_CODE
WMS_LICENSE_PLATE_NUMBERS.ORGANIZATION_ID
MTL_SECONDARY_INVENTORIES
WMS_LICENSE_PLATE_NUMBERS.INVENTORY_ITEM_ID
WMS_LICENSE_PLATE_NUMBERS.ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B
WMS_LICENSE_PLATE_NUMBERS.SERIAL_NUMBER
WMS_LICENSE_PLATE_NUMBERS.INVENTORY_ITEM_ID
WMS_LICENSE_PLATE_NUMBERS.ORGANIZATION_ID
MTL_SERIAL_NUMBERS
Foreign Keys to this table:
Foreign Key Column
Foreign Table
MTL_CYCLE_COUNT_ENTRIES.PARENT_LPN_ID
WMS_LICENSE_PLATE_NUMBERS
MTL_CYCLE_COUNT_ENTRIES.OUTERMOST_LPN_ID
WMS_LICENSE_PLATE_NUMBERS
MTL_PHYSICAL_ADJUSTMENTS.OUTERMOST_LPN_ID
WMS_LICENSE_PLATE_NUMBERS
MTL_PHYSICAL_ADJUSTMENTS.PARENT_LPN_ID
WMS_LICENSE_PLATE_NUMBERS
MTL_PHYSICAL_INVENTORY_TAGS.PARENT_LPN_ID
WMS_LICENSE_PLATE_NUMBERS
MTL_PHYSICAL_INVENTORY_TAGS.OUTERMOST_LPN_ID
WMS_LICENSE_PLATE_NUMBERS
MTL_SERIAL_NUMBERS.LPN_ID
WMS_LICENSE_PLATE_NUMBERS
WMS_LPN_CONTENTS.PARENT_LPN_ID
WMS_LICENSE_PLATE_NUMBERS
WMS_LPN_HISTORIES.PARENT_LPN_ID
WMS_LICENSE_PLATE_NUMBERS
WMS_LPN_HISTORIES.LPN_ID
WMS_LICENSE_PLATE_NUMBERS
WMS_LPN_HISTORIES.OUTERMOST_LPN_ID
WMS_LICENSE_PLATE_NUMBERS
WMS_LPN_PROCESS_TEMP.LPN_ID
WMS_LICENSE_PLATE_NUMBERS
WMS_SHIPPING_TRANSACTION_TEMP.PARENT_LPN_ID
WMS_LICENSE_PLATE_NUMBERS
WMS_SHIPPING_TRANSACTION_TEMP.OUTERMOST_LPN_ID
WMS_LICENSE_PLATE_NUMBERS
[top of page]
WMS.WMS_LICENSE_PLATE_NUMBERS does not reference any database object
WMS.WMS_LICENSE_PLATE_NUMBERS is referenced by following:
APPS
SYNONYM - WMS_LICENSE_PLATE_NUMBERS
[top of page]
Table: WMS_LOCATIONS_LOCATORS
Description: WMS Configuration
Primary Key: WMS_LOCATIONS_LOCATORS_PK
LOCATOR_ID
LOCATION_ID
ORGANIZATION_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_LOCATIONS_LOCATORS.ORGANIZATION_ID
MTL_PARAMETERS
[top of page]
WMS.WMS_LOCATIONS_LOCATORS does not reference any database object
WMS.WMS_LOCATIONS_LOCATORS is referenced by following:
APPS
SYNONYM - WMS_LOCATIONS_LOCATORS
[top of page]
Table: WMS_LPN_CONTENTS
Description: Used to store all of the information related to the contents of a container
Primary Key: WMS_LPN_CONTENTS_PK
LPN_CONTENT_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_LPN_CONTENTS.PARENT_LPN_ID
WMS_LICENSE_PLATE_NUMBERS
WMS_LPN_CONTENTS.INVENTORY_ITEM_ID
WMS_LPN_CONTENTS.ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B
WMS_LPN_CONTENTS.INVENTORY_ITEM_ID
WMS_LPN_CONTENTS.ORGANIZATION_ID
WMS_LPN_CONTENTS.REVISION
MTL_ITEM_REVISIONS_B
WMS_LPN_CONTENTS.INVENTORY_ITEM_ID
WMS_LPN_CONTENTS.ORGANIZATION_ID
WMS_LPN_CONTENTS.LOT_NUMBER
MTL_LOT_NUMBERS
[top of page]
WMS.WMS_LPN_CONTENTS does not reference any database object
WMS.WMS_LPN_CONTENTS is referenced by following:
APPS
SYNONYM - WMS_LPN_CONTENTS
[top of page]
Table: WMS_LPN_CONTENTS_INTERFACE
Description: Open interface table for preprocessing LPNs shipped with ASN
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_LPN_CONTENTS_INTERFACE.INTERFACE_TRANSACTION_ID
RCV_TRANSACTIONS_INTERFACE
[top of page]
WMS.WMS_LPN_CONTENTS_INTERFACE does not reference any database object
WMS.WMS_LPN_CONTENTS_INTERFACE is referenced by following:
APPS
SYNONYM - WMS_LPN_CONTENTS_INTERFACE
[top of page]
Table: WMS_LPN_HISTORIES
Description: Used to store the history information related to the container's past transactions
Primary Key: WMS_LPN_HISTORIES_PK
LPN_HISTORY_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_LPN_HISTORIES.PARENT_LPN_ID
WMS_LICENSE_PLATE_NUMBERS
WMS_LPN_HISTORIES.LPN_ID
WMS_LICENSE_PLATE_NUMBERS
WMS_LPN_HISTORIES.INVENTORY_ITEM_ID
WMS_LPN_HISTORIES.ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B
WMS_LPN_HISTORIES.INVENTORY_ITEM_ID
WMS_LPN_HISTORIES.ORGANIZATION_ID
WMS_LPN_HISTORIES.REVISION
MTL_ITEM_REVISIONS_B
WMS_LPN_HISTORIES.INVENTORY_ITEM_ID
WMS_LPN_HISTORIES.ORGANIZATION_ID
WMS_LPN_HISTORIES.LOT_NUMBER
MTL_LOT_NUMBERS
WMS_LPN_HISTORIES.SERIAL_NUMBER
WMS_LPN_HISTORIES.INVENTORY_ITEM_ID
WMS_LPN_HISTORIES.ORGANIZATION_ID
MTL_SERIAL_NUMBERS
WMS_LPN_HISTORIES.OUTERMOST_LPN_ID
WMS_LICENSE_PLATE_NUMBERS
WMS_LPN_HISTORIES.LOCATOR_ID
WMS_LPN_HISTORIES.ORGANIZATION_ID
MTL_ITEM_LOCATIONS
WMS_LPN_HISTORIES.SUBINVENTORY_CODE
WMS_LPN_HISTORIES.ORGANIZATION_ID
MTL_SECONDARY_INVENTORIES
[top of page]
WMS.WMS_LPN_HISTORIES does not reference any database object
WMS.WMS_LPN_HISTORIES is referenced by following:
APPS
SYNONYM - WMS_LPN_HISTORIES
[top of page]
Table: WMS_LPN_INTERFACE
Description: Used to provide the information related to a container instance (LPN) for a transaction
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_LPN_INTERFACE.ORGANIZATION_ID
MTL_PARAMETERS
WMS_LPN_INTERFACE.LOCATOR_ID
WMS_LPN_INTERFACE.ORGANIZATION_ID
MTL_ITEM_LOCATIONS
WMS_LPN_INTERFACE.INVENTORY_ITEM_ID
WMS_LPN_INTERFACE.ORGANIZATION_ID
WMS_LPN_INTERFACE.LOT_NUMBER
MTL_LOT_NUMBERS
WMS_LPN_INTERFACE.SUBINVENTORY_CODE
WMS_LPN_INTERFACE.ORGANIZATION_ID
MTL_SECONDARY_INVENTORIES
WMS_LPN_INTERFACE.INVENTORY_ITEM_ID
WMS_LPN_INTERFACE.ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B
WMS_LPN_INTERFACE.SERIAL_NUMBER
WMS_LPN_INTERFACE.INVENTORY_ITEM_ID
WMS_LPN_INTERFACE.ORGANIZATION_ID
MTL_SERIAL_NUMBERS
[top of page]
WMS.WMS_LPN_INTERFACE does not reference any database object
WMS.WMS_LPN_INTERFACE is referenced by following:
APPS
SYNONYM - WMS_LPN_INTERFACE
[top of page]
Table: WMS_LPN_PROCESS_TEMP
Description: Temporary table used to store the generated lpn values after call of the Generate_LPN api. API will pass back a process_id that indicates with LPNs in the process temp table were generated during that particular call
Primary Key: WMS_LPN_PROCESS_TEMP_PK
LPN_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_LPN_PROCESS_TEMP.LPN_ID
WMS_LICENSE_PLATE_NUMBERS
[top of page]
WMS.WMS_LPN_PROCESS_TEMP does not reference any database object
WMS.WMS_LPN_PROCESS_TEMP is referenced by following:
APPS
SYNONYM - WMS_LPN_PROCESS_TEMP
[top of page]
Table: WMS_MATERIAL_TXN_TRACE
Description: This is history table for mtl_material_transaction_temp. - This for WMS internal Use only.
Primary Key: WMS_MATERIAL_TXN_T_PK
TRANSACTION_HEADER_ID
[top of page]
WMS.WMS_MATERIAL_TXN_TRACE does not reference any database object
WMS.WMS_MATERIAL_TXN_TRACE is referenced by following:
APPS
SYNONYM - WMS_MATERIAL_TXN_TRACE
[top of page]
Table: WMS_MSG_COMPONENTS
Primary Key: WMS_MSG_COMPONENTS_PK
COMPONENT_ID
[top of page]
WMS.WMS_MSG_COMPONENTS does not reference any database object
WMS.WMS_MSG_COMPONENTS is referenced by following:
APPS
SYNONYM - WMS_MSG_COMPONENTS
[top of page]
Table: WMS_MSG_TEMPLATES
Primary Key: WMS_MSG_TEMPLATES_PK
TEMPLATE_ID
[top of page]
WMS.WMS_MSG_TEMPLATES does not reference any database object
WMS.WMS_MSG_TEMPLATES is referenced by following:
APPS
SYNONYM - WMS_MSG_TEMPLATES
[top of page]
Table: WMS_OBJECTS_B
Description: WMS Business Objects
Primary Key: WMS_OBJECTS_B_PK
OBJECT_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_OBJECTS_B.STRAT_ASGMT_DB_OBJECT_ID
WMS_DB_OBJECTS
Foreign Keys to this table:
Foreign Key Column
Foreign Table
WMS_OBJECTS_TL.OBJECT_ID
WMS_OBJECTS_B
WMS_ORG_HIERARCHY_OBJS.OBJECT_ID
WMS_OBJECTS_B
WMS_PARAMETERS_B.OBJECT_ID
WMS_OBJECTS_B
WMS_STRATEGY_ASSIGNMENTS.OBJECT_ID
WMS_OBJECTS_B
[top of page]
WMS.WMS_OBJECTS_B does not reference any database object
WMS.WMS_OBJECTS_B is referenced by following:
APPS
SYNONYM - WMS_OBJECTS_B
[top of page]
Table: WMS_OBJECTS_TL
Description: Translation Table for WMS Business Objects
Primary Key: WMS_OBJECTS_TL_PK
OBJECT_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_OBJECTS_TL.OBJECT_ID
WMS_OBJECTS_B
[top of page]
WMS.WMS_OBJECTS_TL does not reference any database object
WMS.WMS_OBJECTS_TL is referenced by following:
APPS
SYNONYM - WMS_OBJECTS_TL
[top of page]
Table: WMS_OP_DESTINATION_SEL_APIS
[top of page]
WMS.WMS_OP_DESTINATION_SEL_APIS does not reference any database object
WMS.WMS_OP_DESTINATION_SEL_APIS is referenced by following:
APPS
SYNONYM - WMS_OP_DESTINATION_SEL_APIS
[top of page]
Table: WMS_OP_OPERATION_INSTANCES
Description: Not intended for use in Release 11.5.9
Primary Key: WMS_OP_OPERATION_INS_PK
OPERATION_INSTANCE_ID
[top of page]
WMS.WMS_OP_OPERATION_INSTANCES does not reference any database object
WMS.WMS_OP_OPERATION_INSTANCES is referenced by following:
APPS
SYNONYM - WMS_OP_OPERATION_INSTANCES
[top of page]
Table: WMS_OP_OPERTN_INSTANCES_ARCH
Description: Not intended for use in Release 11.5.9
[top of page]
WMS.WMS_OP_OPERTN_INSTANCES_ARCH does not reference any database object
WMS.WMS_OP_OPERTN_INSTANCES_ARCH is referenced by following:
APPS
SYNONYM - WMS_OP_OPERTN_INSTANCES_ARCH
[top of page]
Table: WMS_OP_OPERTN_INSTANCES_HIST
Description: Not intended for use in Release 11.5.9
Primary Key: WMS_OP_OPERTN_INS_HIST_PK
OPERATION_INSTANCE_ID
[top of page]
WMS.WMS_OP_OPERTN_INSTANCES_HIST does not reference any database object
WMS.WMS_OP_OPERTN_INSTANCES_HIST is referenced by following:
APPS
SYNONYM - WMS_OP_OPERTN_INSTANCES_HIST
[top of page]
Table: WMS_OP_PLANS_B
Description: Table to store header level Operation Plan Information
Primary Key: WMS_OP_PLANS_B_PK
OPERATION_PLAN_ID
[top of page]
WMS.WMS_OP_PLANS_B does not reference any database object
WMS.WMS_OP_PLANS_B is referenced by following:
APPS
SYNONYM - WMS_OP_PLANS_B
[top of page]
Table: WMS_OP_PLANS_TL
Description: Standard MLS TL Table for WMS_OP_PLANS_B
Primary Key: WMS_OP_PLANS_TL_PK
OPERATION_PLAN_ID
LANGUAGE
[top of page]
WMS.WMS_OP_PLANS_TL does not reference any database object
WMS.WMS_OP_PLANS_TL is referenced by following:
APPS
SYNONYM - WMS_OP_PLANS_TL
[top of page]
Table: WMS_OP_PLAN_DETAILS
Description: Table to store operation plan details
Primary Key: WMS_OP_PLAN_DETAILS_PK
OPERATION_PLAN_DETAIL_ID
[top of page]
WMS.WMS_OP_PLAN_DETAILS does not reference any database object
WMS.WMS_OP_PLAN_DETAILS is referenced by following:
APPS
SYNONYM - WMS_OP_PLAN_DETAILS
[top of page]
Table: WMS_OP_PLAN_INSTANCES
Description: Not intended for use in Release 11.5.9
Primary Key: WMS_OP_PLAN_INS_PK
OP_PLAN_INSTANCE_ID
[top of page]
WMS.WMS_OP_PLAN_INSTANCES does not reference any database object
WMS.WMS_OP_PLAN_INSTANCES is referenced by following:
APPS
SYNONYM - WMS_OP_PLAN_INSTANCES
[top of page]
Table: WMS_OP_PLAN_INSTANCES_ARCH
Description: Not intended for use in Release 11.5.9
[top of page]
WMS.WMS_OP_PLAN_INSTANCES_ARCH does not reference any database object
WMS.WMS_OP_PLAN_INSTANCES_ARCH is referenced by following:
APPS
SYNONYM - WMS_OP_PLAN_INSTANCES_ARCH
[top of page]
Table: WMS_OP_PLAN_INSTANCES_HIST
Description: Not intended for use in Release 11.5.9
Primary Key: WMS_OP_PLAN_INS_HIST_PK
OP_PLAN_INSTANCE_ID
[top of page]
WMS.WMS_OP_PLAN_INSTANCES_HIST does not reference any database object
WMS.WMS_OP_PLAN_INSTANCES_HIST is referenced by following:
APPS
SYNONYM - WMS_OP_PLAN_INSTANCES_HIST
[top of page]
Table: WMS_ORDERED_TASKS
[top of page]
WMS.WMS_ORDERED_TASKS does not reference any database object
WMS.WMS_ORDERED_TASKS is referenced by following:
APPS
SYNONYM - WMS_ORDERED_TASKS
[top of page]
Table: WMS_ORG_HIERARCHY_OBJS
Description: WMS Strategy Search Order
Primary Key: WMS_ORG_HIERARCHY_OBJS_PK
ORGANIZATION_ID
TYPE_CODE
OBJECT_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_ORG_HIERARCHY_OBJS.ORGANIZATION_ID
MTL_PARAMETERS
WMS_ORG_HIERARCHY_OBJS.OBJECT_ID
WMS_OBJECTS_B
[top of page]
WMS.WMS_ORG_HIERARCHY_OBJS does not reference any database object
WMS.WMS_ORG_HIERARCHY_OBJS is referenced by following:
APPS
SYNONYM - WMS_ORG_HIERARCHY_OBJS
[top of page]
Table: WMS_PACKAGING_HIST
Description: This is history table for packaging.
Primary Key: WMS_PACKAGING_HIST_PK1
HEADER_ID
SEQUENCE_ID
PACKAGING_MODE
[top of page]
WMS.WMS_PACKAGING_HIST does not reference any database object
WMS.WMS_PACKAGING_HIST is referenced by following:
APPS
SYNONYM - WMS_PACKAGING_HIST
[top of page]
Table: WMS_PACKING_MATERIAL_GTEMP
[top of page]
WMS.WMS_PACKING_MATERIAL_GTEMP does not reference any database object
WMS.WMS_PACKING_MATERIAL_GTEMP is referenced by following:
APPS
SYNONYM - WMS_PACKING_MATERIAL_GTEMP
[top of page]
Table: WMS_PAGE_FIELDS_B
Description: WMS Mobile Page Fields Configuration
Primary Key: WMS_PAGE_FIELDS_B_PK
FIELD_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
WMS_PAGE_FIELDS_TL.FIELD_ID
WMS_PAGE_FIELDS_B
WMS_PAGE_FIELD_VALUES.FIELD_ID
WMS_PAGE_FIELDS_B
WMS_PAGE_TEMPLATE_FIELDS.FIELD_ID
WMS_PAGE_FIELDS_B
[top of page]
WMS.WMS_PAGE_FIELDS_B does not reference any database object
WMS.WMS_PAGE_FIELDS_B is referenced by following:
APPS
SYNONYM - WMS_PAGE_FIELDS_B
[top of page]
Table: WMS_PAGE_FIELDS_TL
Description: WMS Mobile Page Fields Configuration
Primary Key: WMS_PAGE_FIELDS_TL_PK
FIELD_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_PAGE_FIELDS_TL.FIELD_ID
WMS_PAGE_FIELDS_B
[top of page]
WMS.WMS_PAGE_FIELDS_TL does not reference any database object
WMS.WMS_PAGE_FIELDS_TL is referenced by following:
APPS
SYNONYM - WMS_PAGE_FIELDS_TL
[top of page]
Table: WMS_PAGE_FIELD_VALUES
Description: Page Field Values
Primary Key: WMS_PAGE_FIELD_VALUES_PK
FIELD_ID
FIELD_PROPERTY
FIELD_VALUE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_PAGE_FIELD_VALUES.FIELD_ID
WMS_PAGE_FIELDS_B
[top of page]
WMS.WMS_PAGE_FIELD_VALUES does not reference any database object
WMS.WMS_PAGE_FIELD_VALUES is referenced by following:
APPS
SYNONYM - WMS_PAGE_FIELD_VALUES
[top of page]
Table: WMS_PAGE_TEMPLATES_B
Description: Page Templates
Primary Key: WMS_PAGE_TEMPLATES_B_PK
TEMPLATE_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
WMS_PAGE_TEMPLATES_TL.TEMPLATE_ID
WMS_PAGE_TEMPLATES_B
WMS_PAGE_TEMPLATE_FIELDS.TEMPLATE_ID
WMS_PAGE_TEMPLATES_B
[top of page]
WMS.WMS_PAGE_TEMPLATES_B does not reference any database object
WMS.WMS_PAGE_TEMPLATES_B is referenced by following:
APPS
SYNONYM - WMS_PAGE_TEMPLATES_B
[top of page]
Table: WMS_PAGE_TEMPLATES_TL
Description: Translated Table for Page Templates
Primary Key: WMS_PAGE_TEMPLATES_TL_PK
TEMPLATE_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_PAGE_TEMPLATES_TL.TEMPLATE_ID
WMS_PAGE_TEMPLATES_B
[top of page]
WMS.WMS_PAGE_TEMPLATES_TL does not reference any database object
WMS.WMS_PAGE_TEMPLATES_TL is referenced by following:
APPS
SYNONYM - WMS_PAGE_TEMPLATES_TL
[top of page]
Table: WMS_PAGE_TEMPLATE_FIELDS
Description: Page Template Fields
Primary Key: WMS_PAGE_TEMPLATE_FIELDS_PK
TEMPLATE_ID
FIELD_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_PAGE_TEMPLATE_FIELDS.TEMPLATE_ID
WMS_PAGE_TEMPLATES_B
WMS_PAGE_TEMPLATE_FIELDS.FIELD_ID
WMS_PAGE_FIELDS_B
[top of page]
WMS.WMS_PAGE_TEMPLATE_FIELDS does not reference any database object
WMS.WMS_PAGE_TEMPLATE_FIELDS is referenced by following:
APPS
SYNONYM - WMS_PAGE_TEMPLATE_FIELDS
[top of page]
Table: WMS_PARAMETERS_B
Description: WMS Parameters
Primary Key: WMS_PARAMETERS_B_PK
PARAMETER_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_PARAMETERS_B.OBJECT_ID
WMS_OBJECTS_B
WMS_PARAMETERS_B.DB_OBJECT_ID
WMS_DB_OBJECTS
WMS_PARAMETERS_B.DB_OBJECT_REFERENCE_ID
WMS_DB_OBJECT_REFERENCES
WMS_PARAMETERS_B.FLEXFIELD_APPLICATION_ID
FND_APPLICATION
Foreign Keys to this table:
Foreign Key Column
Foreign Table
WMS_DB_OBJECTS.CONTEXT_PARAMETER_ID
WMS_PARAMETERS_B
WMS_DB_OBJECT_JOINS.PARAMETER_ID
WMS_PARAMETERS_B
WMS_DB_OBJECT_JOINS.PARENT_PARAMETER_ID
WMS_PARAMETERS_B
WMS_PARAMETERS_TL.PARAMETER_ID
WMS_PARAMETERS_B
WMS_RESTRICTIONS.PARAMETER_ID
WMS_PARAMETERS_B
WMS_RESTRICTIONS.OPERAND_PARAMETER_ID
WMS_PARAMETERS_B
WMS_RULES_B.QTY_FUNCTION_PARAMETER_ID
WMS_PARAMETERS_B
WMS_RULE_CONSISTENCIES.PARAMETER_ID
WMS_PARAMETERS_B
WMS_SORT_CRITERIA.PARAMETER_ID
WMS_PARAMETERS_B
[top of page]
WMS.WMS_PARAMETERS_B does not reference any database object
WMS.WMS_PARAMETERS_B is referenced by following:
APPS
SYNONYM - WMS_PARAMETERS_B
[top of page]
Table: WMS_PARAMETERS_TL
Description: Translation Table for WMS Parameters
Primary Key: WMS_PARAMETERS_TL_PK
PARAMETER_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_PARAMETERS_TL.PARAMETER_ID
WMS_PARAMETERS_B
[top of page]
WMS.WMS_PARAMETERS_TL does not reference any database object
WMS.WMS_PARAMETERS_TL is referenced by following:
APPS
SYNONYM - WMS_PARAMETERS_TL
[top of page]
Table: WMS_PRINTER_IP_DEF
Description: Table to associate IP Address/Port to the Printer
Primary Key: WMS_PRINTER_IP_DEF_PK1
PRINTER_NAME
[top of page]
WMS.WMS_PRINTER_IP_DEF does not reference any database object
WMS.WMS_PRINTER_IP_DEF is referenced by following:
APPS
SYNONYM - WMS_PRINTER_IP_DEF
[top of page]
Table: WMS_PUTAWAY_GROUP_TASKS_GTMP
[top of page]
WMS.WMS_PUTAWAY_GROUP_TASKS_GTMP does not reference any database object
WMS.WMS_PUTAWAY_GROUP_TASKS_GTMP is referenced by following:
APPS
SYNONYM - WMS_PUTAWAY_GROUP_TASKS_GTMP
[top of page]
Table: WMS_REPL_DEMAND_GTMP
[top of page]
WMS.WMS_REPL_DEMAND_GTMP does not reference any database object
WMS.WMS_REPL_DEMAND_GTMP is referenced by following:
APPS
SYNONYM - WMS_REPL_DEMAND_GTMP
[top of page]
Table: WMS_RESTRICTIONS
Description: WMS Restrictions
Primary Key: WMS_RESTRICTIONS_PK
RULE_ID
SEQUENCE_NUMBER
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_RESTRICTIONS.OPERAND_FLEX_VALUE_SET_ID
FND_FLEX_VALUE_SETS
WMS_RESTRICTIONS.PARAMETER_ID
WMS_PARAMETERS_B
WMS_RESTRICTIONS.OPERAND_PARAMETER_ID
WMS_PARAMETERS_B
WMS_RESTRICTIONS.RULE_ID
WMS_RULES_B
[top of page]
WMS.WMS_RESTRICTIONS does not reference any database object
WMS.WMS_RESTRICTIONS is referenced by following:
APPS
SYNONYM - WMS_RESTRICTIONS
[top of page]
Table: WMS_RULES_B
Primary Key: WMS_RULES_B_PK
RULE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_RULES_B.ORGANIZATION_ID
MTL_PARAMETERS
WMS_RULES_B.QTY_FUNCTION_PARAMETER_ID
WMS_PARAMETERS_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
WMS_RESTRICTIONS.RULE_ID
WMS_RULES_B
WMS_RULES_TL.RULE_ID
WMS_RULES_B
WMS_RULE_CONSISTENCIES.RULE_ID
WMS_RULES_B
WMS_SORT_CRITERIA.RULE_ID
WMS_RULES_B
WMS_STRATEGY_MEMBERS.RULE_ID
WMS_RULES_B
WMS_TRANSACTIONS_TEMP.RULE_ID
WMS_RULES_B
[top of page]
WMS.WMS_RULES_B does not reference any database object
WMS.WMS_RULES_B is referenced by following:
APPS
SYNONYM - WMS_RULES_B
[top of page]
Table: WMS_RULES_TL
Description: Translation tables for WMS Rules
Primary Key: WMS_RULES_TL_PK
LANGUAGE
RULE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_RULES_TL.RULE_ID
WMS_RULES_B
[top of page]
WMS.WMS_RULES_TL does not reference any database object
WMS.WMS_RULES_TL is referenced by following:
APPS
SYNONYM - WMS_RULES_TL
[top of page]
Table: WMS_RULE_CONSISTENCIES
Description: WMS Rule Consistencies
Primary Key: WMS_RULE_CONSISTENCIES_PK
CONSISTENCY_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_RULE_CONSISTENCIES.RULE_ID
WMS_RULES_B
WMS_RULE_CONSISTENCIES.PARAMETER_ID
WMS_PARAMETERS_B
[top of page]
WMS.WMS_RULE_CONSISTENCIES does not reference any database object
WMS.WMS_RULE_CONSISTENCIES is referenced by following:
APPS
SYNONYM - WMS_RULE_CONSISTENCIES
[top of page]
Table: WMS_RULE_LIST_PACKAGE
Description: WMS Rule List Package Table is used to keep track the latest Rules List packages
[top of page]
WMS.WMS_RULE_LIST_PACKAGE does not reference any database object
WMS.WMS_RULE_LIST_PACKAGE is referenced by following:
APPS
SYNONYM - WMS_RULE_LIST_PACKAGE
[top of page]
Table: WMS_RULE_TRACE_HEADERS
Description: WMS Rule Trace Headers
Primary Key: WMS_RULE_TRACE_HEADERS_PK
HEADER_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
WMS_RULE_TRACE_LINES.HEADER_ID
WMS_RULE_TRACE_HEADERS
[top of page]
WMS.WMS_RULE_TRACE_HEADERS does not reference any database object
WMS.WMS_RULE_TRACE_HEADERS is referenced by following:
APPS
SYNONYM - WMS_RULE_TRACE_HEADERS
[top of page]
Table: WMS_RULE_TRACE_LINES
Description: WMS Rule Trace Lines
Primary Key: WMS_RULE_TRACE_LINES_PK
HEADER_ID
LINE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_RULE_TRACE_LINES.HEADER_ID
WMS_RULE_TRACE_HEADERS
[top of page]
WMS.WMS_RULE_TRACE_LINES does not reference any database object
WMS.WMS_RULE_TRACE_LINES is referenced by following:
APPS
SYNONYM - WMS_RULE_TRACE_LINES
[top of page]
Table: WMS_SAVED_QUERIES
Description: WMS Saved Queries
[top of page]
WMS.WMS_SAVED_QUERIES does not reference any database object
WMS.WMS_SAVED_QUERIES is referenced by following:
APPS
SYNONYM - WMS_SAVED_QUERIES
[top of page]
Table: WMS_SELECTION_CRITERIA_TXN
Description: Selection Criteria /Assignment Matrix Table
Primary Key: WMS_SELECTION_CRITERIA_TXN_PK1
FROM_ORGANIZATION_ID
RULE_TYPE_CODE
SEQUENCE_NUMBER
[top of page]
WMS.WMS_SELECTION_CRITERIA_TXN does not reference any database object
WMS.WMS_SELECTION_CRITERIA_TXN is referenced by following:
APPS
SYNONYM - WMS_SELECTION_CRITERIA_TXN
[top of page]
Table: WMS_SERIAL_NUMBERS_TRACE
Description: WMS_SERIAL_NUMBERS_TEMP is a history table . - This for WMS internal Use only.
[top of page]
WMS.WMS_SERIAL_NUMBERS_TRACE does not reference any database object
WMS.WMS_SERIAL_NUMBERS_TRACE is referenced by following:
APPS
SYNONYM - WMS_SERIAL_NUMBERS_TRACE
[top of page]
Table: WMS_SHIPPING_TRANSACTION_TEMP
Description: Temporary table used in mobile ship confirmation
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_SHIPPING_TRANSACTION_TEMP.DOCK_DOOR_ID
WMS_SHIPPING_TRANSACTION_TEMP.ORGANIZATION_ID
MTL_ITEM_LOCATIONS
WMS_SHIPPING_TRANSACTION_TEMP.INVENTORY_ITEM_ID
WMS_SHIPPING_TRANSACTION_TEMP.ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B
WMS_SHIPPING_TRANSACTION_TEMP.PARENT_LPN_ID
WMS_LICENSE_PLATE_NUMBERS
WMS_SHIPPING_TRANSACTION_TEMP.OUTERMOST_LPN_ID
WMS_LICENSE_PLATE_NUMBERS
WMS_SHIPPING_TRANSACTION_TEMP.DELIVERY_DETAIL_ID
WSH_DELIVERY_DETAILS
WMS_SHIPPING_TRANSACTION_TEMP.DELIVERY_ID
WSH_NEW_DELIVERIES
WMS_SHIPPING_TRANSACTION_TEMP.TRIP_ID
WSH_TRIPS
[top of page]
WMS.WMS_SHIPPING_TRANSACTION_TEMP does not reference any database object
WMS.WMS_SHIPPING_TRANSACTION_TEMP is referenced by following:
APPS
SYNONYM - WMS_SHIPPING_TRANSACTION_TEMP
[top of page]
Table: WMS_SKIP_TASK_EXCEPTIONS
Description: Table to capture task exceptions for skipping task
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_SKIP_TASK_EXCEPTIONS.TASK_ID
WMS_DISPATCHED_TASKS
WMS_SKIP_TASK_EXCEPTIONS.INVENTORY_ITEM_ID
WMS_SKIP_TASK_EXCEPTIONS.ORGANIZATION_ID
WMS_SKIP_TASK_EXCEPTIONS.LOT_NUMBER
MTL_LOT_NUMBERS
WMS_SKIP_TASK_EXCEPTIONS.REASON_ID
MTL_TRANSACTION_REASONS
WMS_SKIP_TASK_EXCEPTIONS.PERSON_ID
WMS_SKIP_TASK_EXCEPTIONS.EFFECTIVE_START_DATE
WMS_SKIP_TASK_EXCEPTIONS.EFFECTIVE_END_DATE
PER_ALL_PEOPLE_F
WMS_SKIP_TASK_EXCEPTIONS.INVENTORY_ITEM_ID
WMS_SKIP_TASK_EXCEPTIONS.ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B
WMS_SKIP_TASK_EXCEPTIONS.ORGANIZATION_ID
MTL_PARAMETERS
WMS_SKIP_TASK_EXCEPTIONS.TRANSACTION_HEADER_ID
MTL_MATERIAL_TRANSACTIONS_TEMP
WMS_SKIP_TASK_EXCEPTIONS.SUBINVENTORY_CODE
WMS_SKIP_TASK_EXCEPTIONS.ORGANIZATION_ID
MTL_SECONDARY_INVENTORIES
WMS_SKIP_TASK_EXCEPTIONS.INVENTORY_LOCATION_ID
WMS_SKIP_TASK_EXCEPTIONS.ORGANIZATION_ID
MTL_ITEM_LOCATIONS
WMS_SKIP_TASK_EXCEPTIONS.INVENTORY_ITEM_ID
WMS_SKIP_TASK_EXCEPTIONS.ORGANIZATION_ID
WMS_SKIP_TASK_EXCEPTIONS.REVISION
MTL_ITEM_REVISIONS_B
[top of page]
WMS.WMS_SKIP_TASK_EXCEPTIONS does not reference any database object
WMS.WMS_SKIP_TASK_EXCEPTIONS is referenced by following:
APPS
SYNONYM - WMS_SKIP_TASK_EXCEPTIONS
[top of page]
Table: WMS_SORT_CRITERIA
Description: WMS Sort Criteria
Primary Key: WMS_SORT_CRITERIA_PK
RULE_ID
SEQUENCE_NUMBER
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_SORT_CRITERIA.RULE_ID
WMS_RULES_B
WMS_SORT_CRITERIA.PARAMETER_ID
WMS_PARAMETERS_B
[top of page]
WMS.WMS_SORT_CRITERIA does not reference any database object
WMS.WMS_SORT_CRITERIA is referenced by following:
APPS
SYNONYM - WMS_SORT_CRITERIA
[top of page]
Table: WMS_STAGINGLANES_ASSIGNMENTS
Description: This table stores the staging lane to dock door relationship.
Primary Key: WMS_STAGINGLANES_ASSIGNMENT_PK
DOCK_DOOR_ID
DOCK_DOOR_ORGANIZATION_ID
STAGE_LANE_ID
STAGING_LANE_ORGANIZATION_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_STAGINGLANES_ASSIGNMENTS.DOCK_DOOR_ID
WMS_STAGINGLANES_ASSIGNMENTS.DOCK_DOOR_ORGANIZATION_ID
MTL_ITEM_LOCATIONS
WMS_STAGINGLANES_ASSIGNMENTS.STAGE_LANE_ID
WMS_STAGINGLANES_ASSIGNMENTS.STAGING_LANE_ORGANIZATION_ID
MTL_ITEM_LOCATIONS
[top of page]
WMS.WMS_STAGINGLANES_ASSIGNMENTS does not reference any database object
WMS.WMS_STAGINGLANES_ASSIGNMENTS is referenced by following:
APPS
SYNONYM - WMS_STAGINGLANES_ASSIGNMENTS
[top of page]
Table: WMS_STRATEGIES_B
Description: WMS Strategies
Primary Key: WMS_STRATEGIES_B_PK
STRATEGY_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_STRATEGIES_B.ORGANIZATION_ID
MTL_PARAMETERS
Foreign Keys to this table:
Foreign Key Column
Foreign Table
MTL_TXN_REQUEST_LINES.PICK_STRATEGY_ID
WMS_STRATEGIES_B
MTL_TXN_REQUEST_LINES.PUT_AWAY_STRATEGY_ID
WMS_STRATEGIES_B
WMS_STRATEGIES_TL.STRATEGY_ID
WMS_STRATEGIES_B
WMS_STRATEGY_ASSIGNMENTS.STRATEGY_ID
WMS_STRATEGIES_B
WMS_STRATEGY_MEMBERS.STRATEGY_ID
WMS_STRATEGIES_B
[top of page]
WMS.WMS_STRATEGIES_B does not reference any database object
WMS.WMS_STRATEGIES_B is referenced by following:
APPS
SYNONYM - WMS_STRATEGIES_B
[top of page]
Table: WMS_STRATEGIES_TL
Description: Translation Table for WMS Strategies
Primary Key: WMS_STRATEGIES_TL_PK
STRATEGY_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_STRATEGIES_TL.STRATEGY_ID
WMS_STRATEGIES_B
[top of page]
WMS.WMS_STRATEGIES_TL does not reference any database object
WMS.WMS_STRATEGIES_TL is referenced by following:
APPS
SYNONYM - WMS_STRATEGIES_TL
[top of page]
Table: WMS_STRATEGY_ASSIGNMENTS
Description: WMS Strategy Assignments
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_STRATEGY_ASSIGNMENTS.ORGANIZATION_ID
MTL_PARAMETERS
WMS_STRATEGY_ASSIGNMENTS.STRATEGY_ID
WMS_STRATEGIES_B
WMS_STRATEGY_ASSIGNMENTS.OBJECT_ID
WMS_OBJECTS_B
[top of page]
WMS.WMS_STRATEGY_ASSIGNMENTS does not reference any database object
WMS.WMS_STRATEGY_ASSIGNMENTS is referenced by following:
APPS
SYNONYM - WMS_STRATEGY_ASSIGNMENTS
[top of page]
Table: WMS_STRATEGY_MEMBERS
Description: WMS Strategy Members
Primary Key: WMS_STRATEGY_MEMBERS_PK
STRATEGY_ID
SEQUENCE_NUMBER
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_STRATEGY_MEMBERS.RULE_ID
WMS_RULES_B
WMS_STRATEGY_MEMBERS.STRATEGY_ID
WMS_STRATEGIES_B
[top of page]
WMS.WMS_STRATEGY_MEMBERS does not reference any database object
WMS.WMS_STRATEGY_MEMBERS is referenced by following:
APPS
SYNONYM - WMS_STRATEGY_MEMBERS
[top of page]
Table: WMS_TASKS_TEMP
[top of page]
WMS.WMS_TASKS_TEMP does not reference any database object
WMS.WMS_TASKS_TEMP is referenced by following:
APPS
SYNONYM - WMS_TASKS_TEMP
[top of page]
Table: WMS_TASK_FILTER_B
Description: Task Filter Definitions
Primary Key: WMS_TASK_FILTER_B_PK1
TASK_FILTER_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
WMS_TASK_FILTER_DTL.TASK_FILTER_ID
WMS_TASK_FILTER_B
WMS_TASK_FILTER_TL.TASK_FILTER_ID
WMS_TASK_FILTER_B
[top of page]
WMS.WMS_TASK_FILTER_B does not reference any database object
WMS.WMS_TASK_FILTER_B is referenced by following:
APPS
SYNONYM - WMS_TASK_FILTER_B
[top of page]
Table: WMS_TASK_FILTER_DTL
Description: Filter Constraints
Primary Key: WMS_TASK_FILTER_DTL_PK1
TASK_FILTER_ID
TASK_FILTER_SOURCE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_TASK_FILTER_DTL.TASK_FILTER_ID
WMS_TASK_FILTER_B
[top of page]
WMS.WMS_TASK_FILTER_DTL does not reference any database object
WMS.WMS_TASK_FILTER_DTL is referenced by following:
APPS
SYNONYM - WMS_TASK_FILTER_DTL
[top of page]
Table: WMS_TASK_FILTER_TL
Description: Translated Task Filters
Primary Key: WMS_TASK_FILTER_TL_PK1
TASK_FILTER_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_TASK_FILTER_TL.TASK_FILTER_ID
WMS_TASK_FILTER_B
[top of page]
WMS.WMS_TASK_FILTER_TL does not reference any database object
WMS.WMS_TASK_FILTER_TL is referenced by following:
APPS
SYNONYM - WMS_TASK_FILTER_TL
[top of page]
Table: WMS_TRANSACTIONS_TEMP
Description: WMS Detailing Temporary Table
Primary Key: WMS_TRANSACTIONS_TEMP_PK
PP_TRANSACTION_TEMP_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_TRANSACTIONS_TEMP.RULE_ID
WMS_RULES_B
WMS_TRANSACTIONS_TEMP.TRANSACTION_TEMP_ID
MTL_TXN_REQUEST_LINES
[top of page]
WMS.WMS_TRANSACTIONS_TEMP does not reference any database object
WMS.WMS_TRANSACTIONS_TEMP is referenced by following:
APPS
SYNONYM - WMS_TRANSACTIONS_TEMP
[top of page]
Table: WMS_TRANSACTION_LOTS_TRACE
Description: WMS_TRANSACTION_LOTS is history table - This for WMS internal Use only.
[top of page]
WMS.WMS_TRANSACTION_LOTS_TRACE does not reference any database object
WMS.WMS_TRANSACTION_LOTS_TRACE is referenced by following:
APPS
SYNONYM - WMS_TRANSACTION_LOTS_TRACE
[top of page]
Table: WMS_TXN_CONTEXT_TEMP
Description: WMS Detailing Context Temporary Table
Primary Key: WMS_TXN_CONTEXT_TEMP_PK
LINE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_TXN_CONTEXT_TEMP.LINE_ID
MTL_TXN_REQUEST_LINES
[top of page]
WMS.WMS_TXN_CONTEXT_TEMP does not reference any database object
WMS.WMS_TXN_CONTEXT_TEMP is referenced by following:
APPS
SYNONYM - WMS_TXN_CONTEXT_TEMP
[top of page]
Table: WMS_WAVEPLAN_TASKS_TEMP
[top of page]
WMS.WMS_WAVEPLAN_TASKS_TEMP does not reference any database object
WMS.WMS_WAVEPLAN_TASKS_TEMP is referenced by following:
APPS
SYNONYM - WMS_WAVEPLAN_TASKS_TEMP
[top of page]
Table: WMS_WSH_WDD_GTEMP
[top of page]
WMS.WMS_WSH_WDD_GTEMP does not reference any database object
WMS.WMS_WSH_WDD_GTEMP is referenced by following:
APPS
SYNONYM - WMS_WSH_WDD_GTEMP
[top of page]
Table: WMS_XDOCK_PEGGING_GTMP
[top of page]
WMS.WMS_XDOCK_PEGGING_GTMP does not reference any database object
WMS.WMS_XDOCK_PEGGING_GTMP is referenced by following:
APPS
SYNONYM - WMS_XDOCK_PEGGING_GTMP
[top of page]
Table: WMS_XDOCK_SOURCE_ASSIGNMENTS
Description: WMS Crossdock Criteria source type assignments
Primary Key: WMS_XDOCK_SOURCE_ASSIGNMENT_PK
CRITERION_ID
SOURCE_TYPE
SOURCE_CODE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WMS_XDOCK_SOURCE_ASSIGNMENTS.CRITERION_ID
%
[top of page]
WMS.WMS_XDOCK_SOURCE_ASSIGNMENTS does not reference any database object
WMS.WMS_XDOCK_SOURCE_ASSIGNMENTS is referenced by following:
APPS
SYNONYM - WMS_XDOCK_SOURCE_ASSIGNMENTS
[top of page]
Table: WMS_ZONES_B
Primary Key: WMS_ZONES_B_PK
ZONE_ID
[top of page]
WMS.WMS_ZONES_B does not reference any database object
WMS.WMS_ZONES_B is referenced by following:
APPS
SYNONYM - WMS_ZONES_B
[top of page]
Table: WMS_ZONES_TL
Primary Key: WMS_ZONES_TL_PK
ZONE_ID
LANGUAGE
[top of page]
WMS.WMS_ZONES_TL does not reference any database object
WMS.WMS_ZONES_TL is referenced by following:
APPS
SYNONYM - WMS_ZONES_TL
[top of page]
Table: WMS_ZONE_LOCATORS
[top of page]
WMS.WMS_ZONE_LOCATORS does not reference any database object
WMS.WMS_ZONE_LOCATORS is referenced by following:
APPS
SYNONYM - WMS_ZONE_LOCATORS
[top of page]
View: WMS_ACCESS_RULES_LOV_V
[top of page]
APPS.WMS_ACCESS_RULES_LOV_V references the following:
APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
VIEW - ORG_ACCESS_VIEW
PACKAGE - WMS_PARAMETER_PVT
VIEW - WMS_RULES_V
APPS.WMS_ACCESS_RULES_LOV_V is not referenced by any database object
[top of page]
View: WMS_ACTIVE_EXCEPTIONS_V
[top of page]
APPS.WMS_ACTIVE_EXCEPTIONS_V references the following:
APPS
SYNONYM - MTL_CYCLE_COUNT_ENTRIES
SYNONYM - MTL_CYCLE_COUNT_HEADERS
SYNONYM - MTL_MATERIAL_TRANSACTIONS_TEMP
SYNONYM - WMS_DISPATCHED_TASKS
SYNONYM - WMS_EXCEPTIONS
APPS.WMS_ACTIVE_EXCEPTIONS_V is not referenced by any database object
[top of page]
View: WMS_ACTIVE_TASKS_V
[top of page]
APPS.WMS_ACTIVE_TASKS_V references the following:
APPS
SYNONYM - MTL_CYCLE_COUNT_ENTRIES
SYNONYM - MTL_CYCLE_COUNT_HEADERS
SYNONYM - MTL_MATERIAL_TRANSACTIONS_TEMP
SYNONYM - WMS_DISPATCHED_TASKS
APPS.WMS_ACTIVE_TASKS_V is not referenced by any database object
[top of page]
View: WMS_BUS_EVENT_DEVICES_V
[top of page]
APPS.WMS_BUS_EVENT_DEVICES_V references the following:
APPS
VIEW - MFG_LOOKUPS
SYNONYM - MTL_PARAMETERS
SYNONYM - WMS_BUS_EVENT_DEVICES
VIEW - WMS_DEVICES_VL
APPS.WMS_BUS_EVENT_DEVICES_V is not referenced by any database object
[top of page]
View: WMS_COMPLETED_EXCEPTIONS_V
[top of page]
APPS.WMS_COMPLETED_EXCEPTIONS_V references the following:
APPS
SYNONYM - MTL_CYCLE_COUNT_ENTRIES
SYNONYM - MTL_CYCLE_COUNT_HEADERS
SYNONYM - MTL_MATERIAL_TRANSACTIONS
SYNONYM - WMS_DISPATCHED_TASKS_HISTORY
SYNONYM - WMS_EXCEPTIONS
APPS.WMS_COMPLETED_EXCEPTIONS_V is not referenced by any database object
[top of page]
View: WMS_COMPLETED_TASKS_V
[top of page]
APPS.WMS_COMPLETED_TASKS_V references the following:
APPS
SYNONYM - MTL_CYCLE_COUNT_ENTRIES
SYNONYM - MTL_CYCLE_COUNT_HEADERS
SYNONYM - MTL_MATERIAL_TRANSACTIONS
SYNONYM - WMS_DISPATCHED_TASKS_HISTORY
APPS.WMS_COMPLETED_TASKS_V is not referenced by any database object
[top of page]
View: WMS_COST_GROUPS_INPUT_V
[top of page]
APPS.WMS_COST_GROUPS_INPUT_V references the following:
APPS
SYNONYM - MTL_INTERORG_PARAMETERS
SYNONYM - MTL_MATERIAL_TRANSACTIONS_TEMP
SYNONYM - MTL_SERIAL_NUMBERS
SYNONYM - MTL_SERIAL_NUMBERS_TEMP
SYNONYM - MTL_TRANSACTION_LOTS_TEMP
SYNONYM - MTL_TRANSACTION_TYPES
SYNONYM - MTL_TXN_REQUEST_LINES
PACKAGE - WMS_COSTGROUPENGINE_PVT
APPS.WMS_COST_GROUPS_INPUT_V is referenced by following:
APPS
PACKAGE BODY - WMS_COSTGROUPENGINE_PVT
PACKAGE BODY - WMS_STRATEGY_PVT
[top of page]
View: WMS_CROSSDOCK_CRITERIA_VL
[top of page]
APPS.WMS_CROSSDOCK_CRITERIA_VL references the following:
APPS
SYNONYM - WMS_CROSSDOCK_CRITERIA_B
SYNONYM - WMS_CROSSDOCK_CRITERIA_TL
APPS.WMS_CROSSDOCK_CRITERIA_VL is referenced by following:
APPS
VIEW - MTL_PARAMETERS_VIEW
PACKAGE BODY - WMS_CROSSDOCK_GRP
PACKAGE BODY - WMS_RULES_WORKBENCH_PVT
[top of page]
View: WMS_DEPTS_V
[top of page]
APPS.WMS_DEPTS_V references the following:
APPS
VIEW - WMS_DEPT_SUBINVENTORIES_V
APPS.WMS_DEPTS_V is not referenced by any database object
[top of page]
View: WMS_DEPT_SUBINVENTORIES_V
[top of page]
APPS.WMS_DEPT_SUBINVENTORIES_V references the following:
APPS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SECONDARY_INVENTORIES
SYNONYM - WMS_DEPARTMENT_SUBINVENTORIES
APPS.WMS_DEPT_SUBINVENTORIES_V is referenced by following:
APPS
VIEW - WMS_DEPTS_V
[top of page]
View: WMS_DEVICES_VL
[top of page]
APPS.WMS_DEVICES_VL references the following:
APPS
VIEW - MFG_LOOKUPS
SYNONYM - MTL_PARAMETERS
SYNONYM - WMS_DEVICES_B
SYNONYM - WMS_DEVICES_TL
SYNONYM - WMS_MSG_TEMPLATES
APPS.WMS_DEVICES_VL is referenced by following:
APPS
PACKAGE BODY - GMO_DVC_INTG_PVT
VIEW - WMS_BUS_EVENT_DEVICES_V
SYNONYM - WMS_DEVICES
PACKAGE BODY - WMS_DEVICES_PKG
PACKAGE BODY - WMS_DEVICE_INTEGRATION_PVT
VIEW - WMS_DEVICE_REQUESTS_HIST_V
PACKAGE BODY - WMS_RFID_DEVICE_PUB
PACKAGE BODY - WMS_TASK_DISPATCH_DEVICE
PACKAGE BODY - WMS_TASK_DISPATCH_GEN
PACKAGE BODY - WMS_TASK_DISPATCH_LOV
[top of page]
View: WMS_DEVICE_REQUESTS_HIST_V
[top of page]
APPS.WMS_DEVICE_REQUESTS_HIST_V references the following:
APPS
VIEW - MFG_LOOKUPS
VIEW - MTL_ITEM_LOCATIONS_KFV
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS
VIEW - WMS_DEVICES_VL
SYNONYM - WMS_DEVICE_REQUESTS_HIST
SYNONYM - WMS_EPC
SYNONYM - WMS_LICENSE_PLATE_NUMBERS
APPS.WMS_DEVICE_REQUESTS_HIST_V is not referenced by any database object
[top of page]
View: WMS_DEVICE_REQUESTS_WCSV
[top of page]
APPS.WMS_DEVICE_REQUESTS_WCSV references the following:
APPS
PACKAGE - INV_PROJECT
VIEW - MFG_LOOKUPS
SYNONYM - MTL_ITEM_LOCATIONS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - WMS_DEVICES
SYNONYM - WMS_DEVICE_REQUESTS
SYNONYM - WMS_LICENSE_PLATE_NUMBERS
APPS.WMS_DEVICE_REQUESTS_WCSV is referenced by following:
APPS
PACKAGE BODY - WMS_CAROUSEL_INTEGRATION_PVT
PACKAGE - WMS_CAROUSEL_INTEGRATION_PVT
[top of page]
View: WMS_DISPATCHABLE_TASKS_V
[top of page]
APPS.WMS_DISPATCHABLE_TASKS_V references the following:
APPS
SYNONYM - MTL_CYCLE_COUNT_ENTRIES
SYNONYM - MTL_MATERIAL_TRANSACTIONS_TEMP
APPS.WMS_DISPATCHABLE_TASKS_V is referenced by following:
APPS
PACKAGE BODY - INV_CYC_LOVS
PACKAGE BODY - WMS_TASK_DISPATCH_ENGINE
[top of page]
View: WMS_DOCKS_V
[top of page]
APPS.WMS_DOCKS_V references the following:
APPS
SYNONYM - MTL_ITEM_LOCATIONS
APPS.WMS_DOCKS_V is not referenced by any database object
[top of page]
View: WMS_DOCK_APPOINTMENTS_V
[top of page]
APPS.WMS_DOCK_APPOINTMENTS_V references the following:
APPS
SYNONYM - WMS_DOCK_APPOINTMENTS_B
SYNONYM - WMS_DOCK_APPOINTMENTS_TL
APPS.WMS_DOCK_APPOINTMENTS_V is referenced by following:
APPS
PACKAGE - WMS_DOCK_APPOINTMENTS_PUB
PACKAGE BODY - WMS_DOCK_APPOINTMENTS_PUB
[top of page]
View: WMS_ELS_GROUPED_TASKS_VL
[top of page]
APPS.WMS_ELS_GROUPED_TASKS_VL references the following:
APPS
SYNONYM - WMS_ELS_GROUPED_TASKS_B
SYNONYM - WMS_ELS_GROUPED_TASKS_TL
APPS.WMS_ELS_GROUPED_TASKS_VL is not referenced by any database object
[top of page]
View: WMS_ELS_INDIVIDUAL_TASKS_VL
[top of page]
APPS.WMS_ELS_INDIVIDUAL_TASKS_VL references the following:
APPS
SYNONYM - WMS_ELS_INDIVIDUAL_TASKS_B
SYNONYM - WMS_ELS_INDIVIDUAL_TASKS_TL
APPS.WMS_ELS_INDIVIDUAL_TASKS_VL is not referenced by any database object
[top of page]
View: WMS_EXCEPTIONS_V
[top of page]
APPS.WMS_EXCEPTIONS_V references the following:
APPS
SYNONYM - BOM_RESOURCES
SYNONYM - BOM_STANDARD_OPERATIONS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
VIEW - MFG_LOOKUPS
VIEW - MTL_ITEM_LOCATIONS_KFV
SYNONYM - MTL_MATERIAL_TRANSACTIONS
SYNONYM - MTL_MATERIAL_TRANSACTIONS_TEMP
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - MTL_TRANSACTION_LOTS_TEMP
SYNONYM - MTL_TRANSACTION_LOT_NUMBERS
SYNONYM - MTL_TRANSACTION_REASONS
SYNONYM - MTL_TRANSACTION_TYPES
SYNONYM - MTL_TXN_SOURCE_TYPES
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - WMS_DISPATCHED_TASKS
SYNONYM - WMS_DISPATCHED_TASKS_HISTORY
SYNONYM - WMS_EXCEPTIONS
APPS.WMS_EXCEPTIONS_V is not referenced by any database object
[top of page]
View: WMS_ITEM_LOCATIONS_KFV
[top of page]
APPS.WMS_ITEM_LOCATIONS_KFV references the following:
APPS
SYNONYM - MTL_ITEM_LOCATIONS
APPS.WMS_ITEM_LOCATIONS_KFV is referenced by following:
APPS
PACKAGE BODY - GME_MOBILE_LOVS
PACKAGE BODY - GME_MOBILE_RSRV
PACKAGE BODY - GME_MOBILE_TXN
PACKAGE BODY - GME_RESERVATIONS_PVT
PACKAGE BODY - GME_TRANSACTIONS_PVT
PACKAGE BODY - INV_LABEL_PVT1
PACKAGE BODY - INV_LABEL_PVT2
PACKAGE BODY - INV_UI_ITEM_SUB_LOC_LOVS
PACKAGE BODY - WMS_PICK_LOAD_UI
[top of page]
View: WMS_LABEL_FIELDS_VL
[top of page]
APPS.WMS_LABEL_FIELDS_VL references the following:
APPS
SYNONYM - WMS_LABEL_FIELDS_B
SYNONYM - WMS_LABEL_FIELDS_TL
APPS.WMS_LABEL_FIELDS_VL is referenced by following:
APPS
PACKAGE BODY - INV_LABEL_PVT5
PACKAGE BODY - INV_LABEL_PVT8
SYNONYM - WMS_LABEL_FIELDS
[top of page]
View: WMS_LABEL_FIELD_VARIABLES_VL
[top of page]
APPS.WMS_LABEL_FIELD_VARIABLES_VL references the following:
APPS
SYNONYM - WMS_LABEL_FIELDS_TL
SYNONYM - WMS_LABEL_FIELD_VARIABLES
APPS.WMS_LABEL_FIELD_VARIABLES_VL is not referenced by any database object
[top of page]
View: WMS_LABEL_FORMATS_V
[top of page]
APPS.WMS_LABEL_FORMATS_V references the following:
APPS
SYNONYM - WMS_LABEL_FORMATS
APPS.WMS_LABEL_FORMATS_V is not referenced by any database object
[top of page]
View: WMS_LABEL_REQUESTS_HIST_V
[top of page]
APPS.WMS_LABEL_REQUESTS_HIST_V references the following:
APPS
SYNONYM - FND_USER
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCOUNT_ROLES
SYNONYM - HZ_ORG_CONTACTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
VIEW - MFG_LOOKUPS
SYNONYM - MTL_CUSTOMER_ITEMS
VIEW - MTL_ITEM_LOCATIONS_KFV
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OE_ORDER_LINES_ALL
VIEW - PO_VENDORS
VIEW - PO_VENDOR_SITES_ALL
SYNONYM - WMS_LABEL_FORMATS
SYNONYM - WMS_LABEL_REQUESTS_HIST
SYNONYM - WMS_LICENSE_PLATE_NUMBERS
SYNONYM - WMS_RULES_TL
SYNONYM - WMS_STRATEGIES_TL
SYNONYM - WSH_NEW_DELIVERIES
APPS.WMS_LABEL_REQUESTS_HIST_V is not referenced by any database object
[top of page]
View: WMS_LABEL_SET_FORMATS_V
[top of page]
APPS.WMS_LABEL_SET_FORMATS_V references the following:
APPS
SYNONYM - WMS_LABEL_FORMATS
SYNONYM - WMS_LABEL_SET_FORMATS
APPS.WMS_LABEL_SET_FORMATS_V is not referenced by any database object
[top of page]
View: WMS_LICENSE_PLATE_NUMBERS_V
[top of page]
APPS.WMS_LICENSE_PLATE_NUMBERS_V references the following:
APPS
SYNONYM - CST_COST_GROUPS
SYNONYM - WMS_LICENSE_PLATE_NUMBERS
APPS.WMS_LICENSE_PLATE_NUMBERS_V is not referenced by any database object
[top of page]
View: WMS_LOADED_QUANTITIES_V
[top of page]
APPS.WMS_LOADED_QUANTITIES_V references the following:
APPS
SYNONYM - MTL_MATERIAL_TRANSACTIONS_TEMP
SYNONYM - MTL_TRANSACTION_LOTS_TEMP
SYNONYM - WMS_DISPATCHED_TASKS
APPS.WMS_LOADED_QUANTITIES_V is referenced by following:
APPS
PACKAGE BODY - INV_CYC_LOVS
PACKAGE BODY - INV_MINMAX_PVT
PACKAGE BODY - MTL_INV_UTIL_GRP
[top of page]
View: WMS_LPN_CONTENTS_DETAIL_V
[top of page]
APPS.WMS_LPN_CONTENTS_DETAIL_V references the following:
APPS
SYNONYM - CST_COST_GROUPS
SYNONYM - MTL_SERIAL_NUMBERS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - WMS_LICENSE_PLATE_NUMBERS
SYNONYM - WMS_LPN_CONTENTS
APPS.WMS_LPN_CONTENTS_DETAIL_V is not referenced by any database object
[top of page]
View: WMS_LPN_CONTENTS_LOT_V
[top of page]
APPS.WMS_LPN_CONTENTS_LOT_V references the following:
APPS
SYNONYM - MTL_LOT_NUMBERS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - WMS_LICENSE_PLATE_NUMBERS
SYNONYM - WMS_LPN_CONTENTS
APPS.WMS_LPN_CONTENTS_LOT_V is not referenced by any database object
[top of page]
View: WMS_LPN_CONTENTS_SERIAL_V
[top of page]
APPS.WMS_LPN_CONTENTS_SERIAL_V references the following:
APPS
SYNONYM - MTL_SERIAL_NUMBERS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - WMS_LICENSE_PLATE_NUMBERS
APPS.WMS_LPN_CONTENTS_SERIAL_V is not referenced by any database object
[top of page]
View: WMS_LPN_CONTENTS_V
[top of page]
APPS.WMS_LPN_CONTENTS_V references the following:
APPS
SYNONYM - MTL_SERIAL_NUMBERS
SYNONYM - WMS_LICENSE_PLATE_NUMBERS
SYNONYM - WMS_LPN_CONTENTS
APPS.WMS_LPN_CONTENTS_V is referenced by following:
APPS
PACKAGE BODY - INV_RCV_STD_RCPT_APIS
PACKAGE BODY - INV_UI_ITEM_LOVS
[top of page]
View: WMS_OBJECTS_HIERARCHY_LOV_V
[top of page]
APPS.WMS_OBJECTS_HIERARCHY_LOV_V references the following:
APPS
VIEW - WMS_OBJECTS_VL
APPS.WMS_OBJECTS_HIERARCHY_LOV_V is not referenced by any database object
[top of page]
View: WMS_OBJECTS_OPERAND_LOV_V
[top of page]
APPS.WMS_OBJECTS_OPERAND_LOV_V references the following:
APPS
VIEW - MFG_LOOKUPS
VIEW - WMS_OBJECTS_VL
VIEW - WMS_PARAMETERS_VL
APPS.WMS_OBJECTS_OPERAND_LOV_V is not referenced by any database object
[top of page]
View: WMS_OBJECTS_RULE_LOV_V
[top of page]
APPS.WMS_OBJECTS_RULE_LOV_V references the following:
APPS
VIEW - WMS_OBJECTS_VL
VIEW - WMS_PARAMETERS_VL
APPS.WMS_OBJECTS_RULE_LOV_V is not referenced by any database object
[top of page]
View: WMS_OBJECTS_STRATEGY_LOV_V
[top of page]
APPS.WMS_OBJECTS_STRATEGY_LOV_V references the following:
APPS
VIEW - WMS_OBJECTS_VL
SYNONYM - WMS_ORG_HIERARCHY_OBJS
APPS.WMS_OBJECTS_STRATEGY_LOV_V is not referenced by any database object
[top of page]
View: WMS_OBJECTS_STRATEGY_V
[top of page]
APPS.WMS_OBJECTS_STRATEGY_V references the following:
APPS
PACKAGE - WMS_ASSIGNMENT_PVT
VIEW - WMS_STRATEGY_ASSIGNMENTS_V
APPS.WMS_OBJECTS_STRATEGY_V is not referenced by any database object
[top of page]
View: WMS_OBJECTS_VL
[top of page]
APPS.WMS_OBJECTS_VL references the following:
APPS
SYNONYM - WMS_OBJECTS_B
SYNONYM - WMS_OBJECTS_TL
APPS.WMS_OBJECTS_VL is referenced by following:
APPS
SYNONYM - WMS_OBJECTS
VIEW - WMS_OBJECTS_HIERARCHY_LOV_V
VIEW - WMS_OBJECTS_OPERAND_LOV_V
VIEW - WMS_OBJECTS_RULE_LOV_V
VIEW - WMS_OBJECTS_STRATEGY_LOV_V
VIEW - WMS_ORG_HIERARCHY_OBJS_V
VIEW - WMS_PARAMETERS_LOV_V
VIEW - WMS_RESTRICTIONS_V
VIEW - WMS_RULES_V
VIEW - WMS_RULE_CONSISTENCIES_V
VIEW - WMS_SORT_CRITERIA_V
VIEW - WMS_STRATEGY_ASSIGNMENTS_V
VIEW - WMS_STRATEGY_ASSIGNMENTS_V2
[top of page]
View: WMS_ONHAND_AND_LOADED_QTY_V
[top of page]
APPS.WMS_ONHAND_AND_LOADED_QTY_V references the following:
APPS
SYNONYM - MTL_MATERIAL_TRANSACTIONS_TEMP
SYNONYM - MTL_ONHAND_QUANTITIES_DETAIL
SYNONYM - MTL_TRANSACTION_LOTS_TEMP
SYNONYM - WMS_DISPATCHED_TASKS
APPS.WMS_ONHAND_AND_LOADED_QTY_V is referenced by following:
APPS
PACKAGE BODY - INV_ITEM_INQ
[top of page]
View: WMS_OP_PLANS_V
[top of page]
APPS.WMS_OP_PLANS_V references the following:
APPS
VIEW - MFG_LOOKUPS
SYNONYM - WMS_OP_PLANS_B
SYNONYM - WMS_OP_PLANS_TL
APPS.WMS_OP_PLANS_V is not referenced by any database object
[top of page]
View: WMS_OP_PLANS_VL
[top of page]
APPS.WMS_OP_PLANS_VL references the following:
APPS
SYNONYM - WMS_OP_PLANS_B
SYNONYM - WMS_OP_PLANS_TL
APPS.WMS_OP_PLANS_VL is referenced by following:
APPS
PACKAGE BODY - WMS_ATF_RUNTIME_PUB_APIS
VIEW - WMS_OP_PLAN_DETAILS_V
VIEW - WMS_RULES_V
[top of page]
View: WMS_OP_PLAN_DETAILS_V
[top of page]
APPS.WMS_OP_PLAN_DETAILS_V references the following:
APPS
VIEW - MFG_LOOKUPS
VIEW - MTL_ITEM_LOCATIONS_KFV
SYNONYM - WMS_API_HOOK_CALLS
SYNONYM - WMS_OP_PLANS_B
VIEW - WMS_OP_PLANS_VL
SYNONYM - WMS_OP_PLAN_DETAILS
SYNONYM - WMS_ZONES_TL
APPS.WMS_OP_PLAN_DETAILS_V is not referenced by any database object
[top of page]
View: WMS_ORG_HIERARCHY_OBJS_V
[top of page]
APPS.WMS_ORG_HIERARCHY_OBJS_V references the following:
APPS
VIEW - WMS_OBJECTS_VL
SYNONYM - WMS_ORG_HIERARCHY_OBJS
APPS.WMS_ORG_HIERARCHY_OBJS_V is not referenced by any database object
[top of page]
View: WMS_PACKING_KITTING_V
[top of page]
APPS.WMS_PACKING_KITTING_V references the following:
APPS
SYNONYM - WMS_PACKING_KITTING_GTEMP
APPS.WMS_PACKING_KITTING_V is not referenced by any database object
[top of page]
View: WMS_PACKING_LPN_CONT_V
[top of page]
APPS.WMS_PACKING_LPN_CONT_V references the following:
APPS
SYNONYM - MTL_MATERIAL_TRANSACTIONS_TEMP
SYNONYM - MTL_SERIAL_NUMBERS
SYNONYM - MTL_SERIAL_NUMBERS_TEMP
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - MTL_TRANSACTION_LOTS_TEMP
SYNONYM - WMS_LICENSE_PLATE_NUMBERS
SYNONYM - WMS_LPN_CONTENTS
APPS.WMS_PACKING_LPN_CONT_V is not referenced by any database object
[top of page]
View: WMS_PACKING_MATERIAL_V
[top of page]
APPS.WMS_PACKING_MATERIAL_V references the following:
APPS
SYNONYM - WMS_PACKING_MATERIAL_GTEMP
APPS.WMS_PACKING_MATERIAL_V is not referenced by any database object
[top of page]
View: WMS_PAGE_CONFIG_UI_V
[top of page]
APPS.WMS_PAGE_CONFIG_UI_V references the following:
APPS
VIEW - WMS_PAGE_FIELDS_VL
VIEW - WMS_PAGE_TEMPLATES_VL
SYNONYM - WMS_PAGE_TEMPLATE_FIELDS
APPS.WMS_PAGE_CONFIG_UI_V is referenced by following:
APPS
PACKAGE BODY - WMS_CONFIG_UI
[top of page]
View: WMS_PAGE_FIELDS_VL
[top of page]
APPS.WMS_PAGE_FIELDS_VL references the following:
APPS
SYNONYM - WMS_PAGE_FIELDS_B
SYNONYM - WMS_PAGE_FIELDS_TL
APPS.WMS_PAGE_FIELDS_VL is referenced by following:
APPS
PACKAGE BODY - WMS_CONFIG_UI
VIEW - WMS_PAGE_CONFIG_UI_V
PACKAGE BODY - WMS_PAGE_FIELDS_PKG
VIEW - WMS_PAGE_TEMPLATES_FIELDS_F_V
[top of page]
View: WMS_PAGE_TEMPLATES_FIELDS_F_V
[top of page]
APPS.WMS_PAGE_TEMPLATES_FIELDS_F_V references the following:
APPS
VIEW - MFG_LOOKUPS
VIEW - WMS_PAGE_FIELDS_VL
VIEW - WMS_PAGE_TEMPLATES_VL
SYNONYM - WMS_PAGE_TEMPLATE_FIELDS
APPS.WMS_PAGE_TEMPLATES_FIELDS_F_V is not referenced by any database object
[top of page]
View: WMS_PAGE_TEMPLATES_VL
[top of page]
APPS.WMS_PAGE_TEMPLATES_VL references the following:
APPS
SYNONYM - WMS_PAGE_TEMPLATES_B
SYNONYM - WMS_PAGE_TEMPLATES_TL
APPS.WMS_PAGE_TEMPLATES_VL is referenced by following:
APPS
PACKAGE BODY - WMS_CONFIG_UI
VIEW - WMS_PAGE_CONFIG_UI_V
VIEW - WMS_PAGE_TEMPLATES_FIELDS_F_V
PACKAGE BODY - WMS_PICKING_PKG
[top of page]
View: WMS_PARAMETERS_LOV_V
[top of page]
APPS.WMS_PARAMETERS_LOV_V references the following:
APPS
SYNONYM - WMS_DB_OBJECTS
VIEW - WMS_OBJECTS_VL
VIEW - WMS_PARAMETERS_VL
PACKAGE - WMS_PARAMETER_PVT
APPS.WMS_PARAMETERS_LOV_V is not referenced by any database object
[top of page]
View: WMS_PARAMETERS_VL
[top of page]
APPS.WMS_PARAMETERS_VL references the following:
APPS
SYNONYM - WMS_PARAMETERS_B
SYNONYM - WMS_PARAMETERS_TL
APPS.WMS_PARAMETERS_VL is referenced by following:
APPS
VIEW - WMS_OBJECTS_OPERAND_LOV_V
VIEW - WMS_OBJECTS_RULE_LOV_V
SYNONYM - WMS_PARAMETERS
VIEW - WMS_PARAMETERS_LOV_V
PACKAGE BODY - WMS_PARAMETER_PVT
VIEW - WMS_RESTRICTIONS_V
VIEW - WMS_RULES_V
VIEW - WMS_RULE_CONSISTENCIES_V
VIEW - WMS_SORT_CRITERIA_V
[top of page]
View: WMS_PENDING_EXCEPTIONS_V
[top of page]
APPS.WMS_PENDING_EXCEPTIONS_V references the following:
APPS
SYNONYM - MTL_CYCLE_COUNT_ENTRIES
SYNONYM - MTL_CYCLE_COUNT_HEADERS
SYNONYM - MTL_MATERIAL_TRANSACTIONS_TEMP
SYNONYM - WMS_DISPATCHED_TASKS
SYNONYM - WMS_EXCEPTIONS
APPS.WMS_PENDING_EXCEPTIONS_V is not referenced by any database object
[top of page]
View: WMS_PENDING_TASKS_V
[top of page]
APPS.WMS_PENDING_TASKS_V references the following:
APPS
SYNONYM - MTL_CYCLE_COUNT_ENTRIES
SYNONYM - MTL_CYCLE_COUNT_HEADERS
SYNONYM - MTL_MATERIAL_TRANSACTIONS_TEMP
SYNONYM - WMS_DISPATCHED_TASKS
APPS.WMS_PENDING_TASKS_V is not referenced by any database object
[top of page]
View: WMS_PERSON_RESOURCE_UTT_V
[top of page]
APPS.WMS_PERSON_RESOURCE_UTT_V references the following:
APPS
SYNONYM - BOM_RESOURCES
SYNONYM - BOM_RESOURCE_EMPLOYEES
SYNONYM - BOM_RESOURCE_EQUIPMENTS
SYNONYM - BOM_STD_OP_RESOURCES
APPS.WMS_PERSON_RESOURCE_UTT_V is not referenced by any database object
[top of page]
View: WMS_RESTRICTIONS_V
[top of page]
APPS.WMS_RESTRICTIONS_V references the following:
APPS
PACKAGE - FND_DATE
SYNONYM - FND_FLEX_VALUE_SETS
PACKAGE - FND_NUMBER
VIEW - MFG_LOOKUPS
VIEW - WMS_OBJECTS_VL
VIEW - WMS_PARAMETERS_VL
PACKAGE - WMS_PARAMETER_PVT
SYNONYM - WMS_RESTRICTIONS
VIEW - WMS_RULES_VL
APPS.WMS_RESTRICTIONS_V is not referenced by any database object
[top of page]
View: WMS_RULES_V
[top of page]
APPS.WMS_RULES_V references the following:
APPS
SYNONYM - BOM_STANDARD_OPERATIONS
SYNONYM - CST_COST_GROUPS
VIEW - MFG_LOOKUPS
SYNONYM - WMS_LABEL_FORMATS
VIEW - WMS_OBJECTS_VL
VIEW - WMS_OP_PLANS_VL
VIEW - WMS_PARAMETERS_VL
PACKAGE - WMS_PARAMETER_PVT
VIEW - WMS_RULES_VL
APPS.WMS_RULES_V is referenced by following:
APPS
VIEW - WMS_ACCESS_RULES_LOV_V
[top of page]
View: WMS_RULES_VL
[top of page]
APPS.WMS_RULES_VL references the following:
APPS
SYNONYM - WMS_RULES_B
SYNONYM - WMS_RULES_TL
APPS.WMS_RULES_VL is referenced by following:
APPS
VIEW - MTL_PARAMETERS_VIEW
VIEW - WMS_RESTRICTIONS_V
SYNONYM - WMS_RULES
VIEW - WMS_RULES_V
PACKAGE BODY - WMS_RULES_WORKBENCH_PVT
PACKAGE - WMS_RULE_PVT
PACKAGE BODY - WMS_RULE_PVT
PACKAGE BODY - WMS_SEARCH_ORDER_GLOBALS_PVT
VIEW - WMS_SORT_CRITERIA_V
VIEW - WMS_STRATEGY_MEMBERS_V
[top of page]
View: WMS_RULE_CONSISTENCIES_V
[top of page]
APPS.WMS_RULE_CONSISTENCIES_V references the following:
APPS
VIEW - WMS_OBJECTS_VL
VIEW - WMS_PARAMETERS_VL
PACKAGE - WMS_PARAMETER_PVT
SYNONYM - WMS_RULE_CONSISTENCIES
APPS.WMS_RULE_CONSISTENCIES_V is not referenced by any database object
[top of page]
View: WMS_SELECTION_CRITERIA_TXN_V
[top of page]
APPS.WMS_SELECTION_CRITERIA_TXN_V references the following:
APPS
SYNONYM - WMS_RULES_B
PACKAGE - WMS_RULES_WORKBENCH_PVT
SYNONYM - WMS_SELECTION_CRITERIA_TXN
SYNONYM - WMS_STRATEGIES_B
APPS.WMS_SELECTION_CRITERIA_TXN_V is referenced by following:
APPS
PACKAGE BODY - WMS_CARTNZN_PUB
[top of page]
View: WMS_SHIP_TO_SITES_V
[top of page]
APPS.WMS_SHIP_TO_SITES_V references the following:
APPS
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTY_SITES
APPS.WMS_SHIP_TO_SITES_V is not referenced by any database object
[top of page]
View: WMS_SORT_CRITERIA_V
[top of page]
APPS.WMS_SORT_CRITERIA_V references the following:
APPS
VIEW - MFG_LOOKUPS
VIEW - WMS_OBJECTS_VL
VIEW - WMS_PARAMETERS_VL
PACKAGE - WMS_PARAMETER_PVT
VIEW - WMS_RULES_VL
SYNONYM - WMS_SORT_CRITERIA
APPS.WMS_SORT_CRITERIA_V is not referenced by any database object
[top of page]
View: WMS_STAGINGLANES_ASSIGNMENTS_V
[top of page]
APPS.WMS_STAGINGLANES_ASSIGNMENTS_V references the following:
APPS
VIEW - MTL_ITEM_LOCATIONS_KFV
SYNONYM - MTL_PARAMETERS
SYNONYM - WMS_STAGINGLANES_ASSIGNMENTS
APPS.WMS_STAGINGLANES_ASSIGNMENTS_V is not referenced by any database object
[top of page]
View: WMS_STRATEGIES_V
[top of page]
APPS.WMS_STRATEGIES_V references the following:
APPS
VIEW - MFG_LOOKUPS
VIEW - WMS_STRATEGIES_VL
APPS.WMS_STRATEGIES_V is not referenced by any database object
[top of page]
View: WMS_STRATEGIES_VL
[top of page]
APPS.WMS_STRATEGIES_VL references the following:
APPS
SYNONYM - WMS_STRATEGIES_B
SYNONYM - WMS_STRATEGIES_TL
APPS.WMS_STRATEGIES_VL is referenced by following:
APPS
PACKAGE BODY - WMS_RULES_WORKBENCH_PVT
PACKAGE BODY - WMS_SEARCH_ORDER_GLOBALS_PVT
SYNONYM - WMS_STRATEGIES
VIEW - WMS_STRATEGIES_V
VIEW - WMS_STRATEGY_ASSIGNMENTS_V
VIEW - WMS_STRATEGY_ASSIGNMENTS_V2
VIEW - WMS_STRATEGY_MEMBERS_V
[top of page]
View: WMS_STRATEGY_ASSIGNMENTS_V
[top of page]
APPS.WMS_STRATEGY_ASSIGNMENTS_V references the following:
APPS
VIEW - MFG_LOOKUPS
PACKAGE - WMS_ASSIGNMENT_PVT
VIEW - WMS_OBJECTS_VL
VIEW - WMS_STRATEGIES_VL
SYNONYM - WMS_STRATEGY_ASSIGNMENTS
APPS.WMS_STRATEGY_ASSIGNMENTS_V is referenced by following:
APPS
VIEW - WMS_OBJECTS_STRATEGY_V
[top of page]
View: WMS_STRATEGY_ASSIGNMENTS_V2
[top of page]
APPS.WMS_STRATEGY_ASSIGNMENTS_V2 references the following:
APPS
VIEW - MFG_LOOKUPS
PACKAGE - WMS_ASSIGNMENT_PVT
VIEW - WMS_OBJECTS_VL
VIEW - WMS_STRATEGIES_VL
SYNONYM - WMS_STRATEGY_ASSIGNMENTS
APPS.WMS_STRATEGY_ASSIGNMENTS_V2 is not referenced by any database object
[top of page]
View: WMS_STRATEGY_MAT_TXN_TMP_V
[top of page]
APPS.WMS_STRATEGY_MAT_TXN_TMP_V references the following:
APPS
SYNONYM - MTL_TRANSACTION_TYPES
SYNONYM - MTL_TXN_REQUEST_LINES
SYNONYM - WMS_TXN_CONTEXT_TEMP
APPS.WMS_STRATEGY_MAT_TXN_TMP_V is referenced by following:
APPS
PACKAGE BODY - WMS_STRATEGY_PVT
[top of page]
View: WMS_STRATEGY_MEMBERS_V
[top of page]
APPS.WMS_STRATEGY_MEMBERS_V references the following:
APPS
VIEW - MFG_LOOKUPS
VIEW - WMS_RULES_VL
VIEW - WMS_STRATEGIES_VL
SYNONYM - WMS_STRATEGY_MEMBERS
APPS.WMS_STRATEGY_MEMBERS_V is not referenced by any database object
[top of page]
View: WMS_SUGGESTIONS_TEMP_V
[top of page]
APPS.WMS_SUGGESTIONS_TEMP_V references the following:
APPS
SYNONYM - MTL_MATERIAL_TRANSACTIONS_TEMP
SYNONYM - MTL_SERIAL_NUMBERS_TEMP
SYNONYM - MTL_TRANSACTION_LOTS_TEMP
SYNONYM - MTL_TXN_REQUEST_LINES
SYNONYM - WMS_TRANSACTIONS_TEMP
APPS.WMS_SUGGESTIONS_TEMP_V is referenced by following:
APPS
PACKAGE BODY - WMS_SEARCH_ORDER_GLOBALS_PVT
[top of page]
View: WMS_SUGGESTIONS_TRACE_V
[top of page]
APPS.WMS_SUGGESTIONS_TRACE_V references the following:
APPS
SYNONYM - WMS_MATERIAL_TXN_TRACE
SYNONYM - WMS_SERIAL_NUMBERS_TRACE
SYNONYM - WMS_TRANSACTION_LOTS_TRACE
APPS.WMS_SUGGESTIONS_TRACE_V is not referenced by any database object
[top of page]
View: WMS_TASKS_V
[top of page]
APPS.WMS_TASKS_V references the following:
APPS
SYNONYM - BOM_RESOURCES
SYNONYM - BOM_STANDARD_OPERATIONS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
VIEW - MFG_LOOKUPS
VIEW - MTL_ITEM_LOCATIONS_KFV
SYNONYM - MTL_MATERIAL_TRANSACTIONS
SYNONYM - MTL_MATERIAL_TRANSACTIONS_TEMP
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - MTL_TRANSACTION_LOTS_TEMP
SYNONYM - MTL_TRANSACTION_LOT_NUMBERS
SYNONYM - MTL_TRANSACTION_TYPES
SYNONYM - MTL_TXN_SOURCE_TYPES
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - WMS_DISPATCHED_TASKS
SYNONYM - WMS_DISPATCHED_TASKS_HISTORY
APPS.WMS_TASKS_V is not referenced by any database object
[top of page]
View: WMS_TASK_FILTER_VL
[top of page]
APPS.WMS_TASK_FILTER_VL references the following:
APPS
SYNONYM - WMS_TASK_FILTER_B
SYNONYM - WMS_TASK_FILTER_TL
APPS.WMS_TASK_FILTER_VL is not referenced by any database object
[top of page]
View: WMS_TRX_DETAILS_TMP_V
[top of page]
APPS.WMS_TRX_DETAILS_TMP_V references the following:
APPS
SYNONYM - MTL_TRANSACTION_TYPES
SYNONYM - MTL_TXN_REQUEST_LINES
SYNONYM - WMS_TRANSACTIONS_TEMP
SYNONYM - WMS_TXN_CONTEXT_TEMP
APPS.WMS_TRX_DETAILS_TMP_V is referenced by following:
APPS
PACKAGE BODY - WMS_RULE_1
PACKAGE BODY - WMS_RULE_10
PACKAGE BODY - WMS_RULE_11
PACKAGE BODY - WMS_RULE_13
PACKAGE BODY - WMS_RULE_14
PACKAGE BODY - WMS_RULE_15
PACKAGE BODY - WMS_RULE_16
PACKAGE BODY - WMS_RULE_17
PACKAGE BODY - WMS_RULE_18
PACKAGE BODY - WMS_RULE_2
PACKAGE BODY - WMS_RULE_3
PACKAGE BODY - WMS_RULE_4
PACKAGE BODY - WMS_RULE_5
PACKAGE BODY - WMS_RULE_6
PACKAGE BODY - WMS_RULE_7
PACKAGE BODY - WMS_RULE_8
PACKAGE BODY - WMS_RULE_9
[top of page]
View: WMS_TXN_REQUEST_LINES_TRACE_V
[top of page]
APPS.WMS_TXN_REQUEST_LINES_TRACE_V references the following:
APPS
SYNONYM - CST_COST_GROUPS
VIEW - MFG_LOOKUPS
SYNONYM - MTL_SECONDARY_INVENTORIES
SYNONYM - MTL_TRANSACTION_TYPES
SYNONYM - MTL_TXN_REQUEST_HEADERS
SYNONYM - MTL_TXN_REQUEST_LINES
SYNONYM - WMS_LICENSE_PLATE_NUMBERS
SYNONYM - WMS_RULE_TRACE_HEADERS
APPS.WMS_TXN_REQUEST_LINES_TRACE_V is not referenced by any database object
[top of page]
View: WMS_WAVEPLAN_TASKS_V
[top of page]
APPS.WMS_WAVEPLAN_TASKS_V references the following:
APPS
SYNONYM - WMS_WAVEPLAN_TASKS_TEMP
APPS.WMS_WAVEPLAN_TASKS_V is not referenced by any database object
[top of page]
View: WMS_WAVEPLAN_TASK_EXCEPTIONS_V
[top of page]
APPS.WMS_WAVEPLAN_TASK_EXCEPTIONS_V references the following:
APPS
VIEW - MTL_ITEM_LOCATIONS_KFV
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - MTL_TRANSACTION_REASONS
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - WMS_EXCEPTIONS
APPS.WMS_WAVEPLAN_TASK_EXCEPTIONS_V is not referenced by any database object
[top of page]
View: WMS_XDOCK_SOURCE_ASSIGNMENTS_V
[top of page]
APPS.WMS_XDOCK_SOURCE_ASSIGNMENTS_V references the following:
APPS
VIEW - MFG_LOOKUPS
SYNONYM - WMS_CROSSDOCK_CRITERIA_B
SYNONYM - WMS_XDOCK_SOURCE_ASSIGNMENTS
APPS.WMS_XDOCK_SOURCE_ASSIGNMENTS_V is not referenced by any database object
[top of page]
View: WMS_ZONES_VL
[top of page]
APPS.WMS_ZONES_VL references the following:
APPS
SYNONYM - WMS_ZONES_B
SYNONYM - WMS_ZONES_TL
APPS.WMS_ZONES_VL is referenced by following:
APPS
PACKAGE BODY - WMS_ZONES_PVT
VIEW - WMS_ZONE_LPN_FOR_RULE
[top of page]
View: WMS_ZONE_LOCATORS_ALL_V
[top of page]
APPS.WMS_ZONE_LOCATORS_ALL_V references the following:
APPS
SYNONYM - MTL_ITEM_LOCATIONS
SYNONYM - WMS_ZONE_LOCATORS
APPS.WMS_ZONE_LOCATORS_ALL_V is not referenced by any database object
[top of page]
View: WMS_ZONE_LOCATORS_TEMP
[top of page]
APPS.WMS_ZONE_LOCATORS_TEMP references the following:
APPS
SYNONYM - WMS_ZONE_LOCATORS_GTMP
APPS.WMS_ZONE_LOCATORS_TEMP is referenced by following:
APPS
PACKAGE BODY - WMS_ZONES_PVT
PACKAGE - WMS_ZONES_PVT
[top of page]
View: WMS_ZONE_LOCATORS_V
[top of page]
APPS.WMS_ZONE_LOCATORS_V references the following:
APPS
VIEW - MTL_ITEM_LOCATIONS_KFV
SYNONYM - MTL_SECONDARY_INVENTORIES
SYNONYM - WMS_ZONES_TL
SYNONYM - WMS_ZONE_LOCATORS
APPS.WMS_ZONE_LOCATORS_V is not referenced by any database object
[top of page]
View: WMS_ZONE_LPN_FOR_RULE
[top of page]
APPS.WMS_ZONE_LPN_FOR_RULE references the following:
APPS
SYNONYM - WMS_LICENSE_PLATE_NUMBERS
VIEW - WMS_ZONES_VL
SYNONYM - WMS_ZONE_LOCATORS
APPS.WMS_ZONE_LPN_FOR_RULE is not referenced by any database object
[top of page]