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®, OracleDevConnectSM, Oracle® Discoverer, Oracle® Expert, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile, Oracle Names®, Oracle NetSolutions®, Oracle® One, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services, Oracle® SQL*TutorSM, OracleSTERLINGSM, 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.
Description: |
---|
WMS.WMS_ALLOCATIONS_GTMP does not reference any database object
WMS.WMS_ALLOCATIONS_GTMP is referenced by following:
Description: |
---|
WMS.WMS_API_HOOKED_ENTITIES does not reference any database object
WMS.WMS_API_HOOKED_ENTITIES is referenced by following:
Description: |
---|
WMS.WMS_API_HOOK_CALLS does not reference any database object
WMS.WMS_API_HOOK_CALLS is referenced by following:
Description: |
---|
WMS.WMS_API_HOOK_SIGNATURES does not reference any database object
WMS.WMS_API_HOOK_SIGNATURES is referenced by following:
Description: | Stored the WMS related information about the ASN shipped |
---|
WMS.WMS_ASN_DETAILS does not reference any database object
WMS.WMS_ASN_DETAILS is referenced by following:
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 |
---|
WMS.WMS_BFLOW_LABEL_TYPE does not reference any database object
WMS.WMS_BFLOW_LABEL_TYPE is referenced by following:
Description: | This table stores the mapping between business event and devices. |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_BUS_EVENT_DEVICES.DEVICE_ID | WMS_DEVICES_B |
WMS_BUS_EVENT_DEVICES.ORGANIZATION_ID | MTL_PARAMETERS |
WMS.WMS_BUS_EVENT_DEVICES does not reference any database object
WMS.WMS_BUS_EVENT_DEVICES is referenced by following:
Description: | Standard WHO Column |
---|
WMS.WMS_CAROUSEL_CONFIGURATION does not reference any database object
WMS.WMS_CAROUSEL_CONFIGURATION is referenced by following:
Description: |
---|
WMS.WMS_CAROUSEL_DIRECTIVE_QUEUE does not reference any database object
WMS.WMS_CAROUSEL_DIRECTIVE_QUEUE is referenced by following:
Description: | Table to store WMS Crossdock Criteria |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_PARAMETERS.DEFAULT_CROSSDOCK_CRITERIA_ID | WMS_CROSSDOCK_CRITERIA_B |
WMS.WMS_CROSSDOCK_CRITERIA_B does not reference any database object
WMS.WMS_CROSSDOCK_CRITERIA_B is referenced by following:
Description: | Translation table for WMS Crossdock Criteria |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_CROSSDOCK_CRITERIA_TL.CRITERION_ID | % |
WMS.WMS_CROSSDOCK_CRITERIA_TL does not reference any database object
WMS.WMS_CROSSDOCK_CRITERIA_TL is referenced by following:
Description: | WMS Database Objects |
---|
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 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 |
WMS.WMS_DB_OBJECTS does not reference any database object
WMS.WMS_DB_OBJECTS is referenced by following:
Description: | WMS Database Object Parents |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_DB_OBJECTS_PARENTS.DB_OBJECT_ID | WMS_DB_OBJECTS |
WMS.WMS_DB_OBJECTS_PARENTS does not reference any database object
WMS.WMS_DB_OBJECTS_PARENTS is referenced by following:
Description: | WMS Database Object Joining Condition |
---|
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 |
WMS.WMS_DB_OBJECT_JOINS does not reference any database object
WMS.WMS_DB_OBJECT_JOINS is referenced by following:
Description: | WMS Database Object References |
---|
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 |
WMS.WMS_DB_OBJECT_REFERENCES does not reference any database object
WMS.WMS_DB_OBJECT_REFERENCES is referenced by following:
Description: | WMS Database Object Reference Members |
---|
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 |
WMS.WMS_DB_OBJ_REF_MEMBERS does not reference any database object
WMS.WMS_DB_OBJ_REF_MEMBERS is referenced by following:
Description: | This is a cross reference table for departments and subinventories. |
---|
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 |
WMS.WMS_DEPARTMENT_SUBINVENTORIES does not reference any database object
WMS.WMS_DEPARTMENT_SUBINVENTORIES is referenced by following:
Description: | Device DefinitionTable |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_DEVICES_B.ORGANIZATION_ID | MTL_PARAMETERS |
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 |
WMS.WMS_DEVICES_B does not reference any database object
WMS.WMS_DEVICES_B is referenced by following:
Description: | This table stores translatable columns.Device_Id is the link between this table and the table WMS_DEVICES_B. |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_DEVICES_TL.DEVICE_ID | WMS_DEVICES_B |
WMS.WMS_DEVICES_TL does not reference any database object
WMS.WMS_DEVICES_TL is referenced by following:
Description: | Device assignment temporary table |
---|
WMS.WMS_DEVICE_ASSIGNMENT_TEMP does not reference any database object
WMS.WMS_DEVICE_ASSIGNMENT_TEMP is referenced by following:
Description: |
---|
WMS.WMS_DEVICE_REQUESTS does not reference any database object
WMS.WMS_DEVICE_REQUESTS is referenced by following:
Description: | History Table for device request. This table stores all the device requests that have been submitted. |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_DEVICE_REQUESTS_HIST.DEVICE_ID | WMS_DEVICES_B |
WMS.WMS_DEVICE_REQUESTS_HIST does not reference any database object
WMS.WMS_DEVICE_REQUESTS_HIST is referenced by following:
Description: | Temporary table for processing the LPNs to be directly shipped bypassing Pick Release/Pick Confirm. |
---|
WMS.WMS_DIRECT_SHIP_TEMP does not reference any database object
WMS.WMS_DIRECT_SHIP_TEMP is referenced by following:
Description: | Dispatched Tasks 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 Key Column | Foreign Table |
---|---|
WMS_EXCEPTIONS.TASK_ID | WMS_DISPATCHED_TASKS |
WMS_SKIP_TASK_EXCEPTIONS.TASK_ID | WMS_DISPATCHED_TASKS |
WMS.WMS_DISPATCHED_TASKS does not reference any database object
WMS.WMS_DISPATCHED_TASKS is referenced by following:
Description: | Archive Table for WMS_DISPATCHED_TASKS. Stores information about all tasks that have been completed |
---|
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 |
WMS.WMS_DISPATCHED_TASKS_ARCH does not reference any database object
WMS.WMS_DISPATCHED_TASKS_ARCH is referenced by following:
Description: | History Table for WMS_DISPATCHED_TASKS. Stores information about all tasks that have been completed |
---|
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 |
WMS.WMS_DISPATCHED_TASKS_HISTORY does not reference any database object
WMS.WMS_DISPATCHED_TASKS_HISTORY is referenced by following:
Description: |
---|
WMS.WMS_DISPATCH_TASKS_GTMP does not reference any database object
WMS.WMS_DISPATCH_TASKS_GTMP is referenced by following:
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. |
---|
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 |
WMS.WMS_DOCK_APPOINTMENTS_B does not reference any database object
WMS.WMS_DOCK_APPOINTMENTS_B is referenced by following:
Description: | WMS dock assignment translation table. Its base table is WMS_DOCK_APPOINTMENTS_B. |
---|
WMS.WMS_DOCK_APPOINTMENTS_TL does not reference any database object
WMS.WMS_DOCK_APPOINTMENTS_TL is referenced by following:
Description: |
---|
WMS.WMS_DS_CT_WT_GTEMP does not reference any database object
WMS.WMS_DS_CT_WT_GTEMP is referenced by following:
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 |
---|
WMS.WMS_ELS_EXP_RESOURCE does not reference any database object
WMS.WMS_ELS_EXP_RESOURCE is referenced by following:
Description: |
---|
APPS.WMS_ELS_EXP_RESOURCE_GTEMP does not reference any database object
APPS.WMS_ELS_EXP_RESOURCE_GTEMP is referenced by following:
Description: | This table is for storing all the setup information for the grouped tasks. |
---|
WMS.WMS_ELS_GROUPED_TASKS_B does not reference any database object
WMS.WMS_ELS_GROUPED_TASKS_B is referenced by following:
Description: |
---|
WMS.WMS_ELS_GROUPED_TASKS_GTMP does not reference any database object
WMS.WMS_ELS_GROUPED_TASKS_GTMP is referenced by following:
Description: | This table is for storing all the translatable setup information like description for the grouped tasks. |
---|
WMS.WMS_ELS_GROUPED_TASKS_TL does not reference any database object
WMS.WMS_ELS_GROUPED_TASKS_TL is referenced by following:
Description: | This table is for storing all the setup information for the individual tasks. |
---|
WMS.WMS_ELS_INDIVIDUAL_TASKS_B does not reference any database object
WMS.WMS_ELS_INDIVIDUAL_TASKS_B is referenced by following:
Description: | This table is for storing all the translatable setup information like description for the individual tasks. |
---|
WMS.WMS_ELS_INDIVIDUAL_TASKS_TL does not reference any database object
WMS.WMS_ELS_INDIVIDUAL_TASKS_TL is referenced by following:
Description: | This table will hold the information for the list of non-tracked users for the organization. |
---|
WMS.WMS_ELS_NON_TRACKED_USERS does not reference any database object
WMS.WMS_ELS_NON_TRACKED_USERS is referenced by following:
Description: | This table will hold the global setup informnation for a labor management enabled warehouse. |
---|
WMS.WMS_ELS_PARAMETERS does not reference any database object
WMS.WMS_ELS_PARAMETERS is referenced by following:
Description: | This table will hold the ratings setup informnation for a labor management enabled warehouse. |
---|
WMS.WMS_ELS_RATINGS_SETUP does not reference any database object
WMS.WMS_ELS_RATINGS_SETUP is referenced by following:
Description: | This table will hold the resource setup informnation for different activity and activity details for a labor management enabled warehouse. |
---|
WMS.WMS_ELS_RESOURCE_SETUP does not reference any database object
WMS.WMS_ELS_RESOURCE_SETUP is referenced by following:
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 |
---|
WMS.WMS_ELS_TRX_SRC does not reference any database object
WMS.WMS_ELS_TRX_SRC is referenced by following:
Description: | Stores EPC cross-reference information |
---|
WMS.WMS_EPC does not reference any database object
WMS.WMS_EPC is referenced by following:
Description: | Table to capture task exceptions |
---|
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 |
WMS.WMS_EXCEPTIONS does not reference any database object
WMS.WMS_EXCEPTIONS is referenced by following:
Description: |
---|
WMS.WMS_EXCEPTIONS_TEMP does not reference any database object
WMS.WMS_EXCEPTIONS_TEMP is referenced by following:
Description: | Temporary table to store Freight Cost Information for LPN or Delivery or Trip and process for direct ship of LPN. |
---|
WMS.WMS_FREIGHT_COST_TEMP does not reference any database object
WMS.WMS_FREIGHT_COST_TEMP is referenced by following:
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. |
---|
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 |
WMS.WMS_LABEL_FIELDS_B does not reference any database object
WMS.WMS_LABEL_FIELDS_B is referenced by following:
Description: | This table stores translatabke columns. Labek_field_id is the link between this table and the table WMS_LABEL_FIELDS_B. |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_LABEL_FIELDS_TL.LABEL_FIELD_ID | WMS_LABEL_FIELDS_B |
WMS.WMS_LABEL_FIELDS_TL does not reference any database object
WMS.WMS_LABEL_FIELDS_TL is referenced by following:
Description: | This table stores all the label field variables that are required in a cerain label format. |
---|
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 |
WMS.WMS_LABEL_FIELD_VARIABLES does not reference any database object
WMS.WMS_LABEL_FIELD_VARIABLES is referenced by following:
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. |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_LABEL_REQUESTS.LABEL_FORMAT_ID | WMS_LABEL_FORMATS |
WMS_LABEL_FIELD_VARIABLES.LABEL_FORMAT_ID | WMS_LABEL_FORMATS |
WMS.WMS_LABEL_FORMATS does not reference any database object
WMS.WMS_LABEL_FORMATS is referenced by following:
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. |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_LABEL_REQUESTS.ORGANIZATION_ID | MTL_PARAMETERS |
WMS_LABEL_REQUESTS.LABEL_FORMAT_ID | WMS_LABEL_FORMATS |
WMS.WMS_LABEL_REQUESTS does not reference any database object
WMS.WMS_LABEL_REQUESTS is referenced by following:
Description: | History Table for label request. This table stores all the label requests that have been submitted. |
---|
WMS.WMS_LABEL_REQUESTS_HIST does not reference any database object
WMS.WMS_LABEL_REQUESTS_HIST is referenced by following:
Description: | This table is key to Label-set feature in WMS. It stores formats and set relationship. |
---|
WMS.WMS_LABEL_SET_FORMATS does not reference any database object
WMS.WMS_LABEL_SET_FORMATS is referenced by following:
Description: | Used to store the information related to a container instance (LPN) |
---|
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 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 |
WMS.WMS_LICENSE_PLATE_NUMBERS does not reference any database object
WMS.WMS_LICENSE_PLATE_NUMBERS is referenced by following:
Description: | WMS Configuration |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_LOCATIONS_LOCATORS.ORGANIZATION_ID | MTL_PARAMETERS |
WMS.WMS_LOCATIONS_LOCATORS does not reference any database object
WMS.WMS_LOCATIONS_LOCATORS is referenced by following:
Description: | Used to store all of the information related to the contents of a container |
---|
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 |
WMS.WMS_LPN_CONTENTS does not reference any database object
WMS.WMS_LPN_CONTENTS is referenced by following:
Description: | Open interface table for preprocessing LPNs shipped with ASN |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_LPN_CONTENTS_INTERFACE.INTERFACE_TRANSACTION_ID | RCV_TRANSACTIONS_INTERFACE |
WMS.WMS_LPN_CONTENTS_INTERFACE does not reference any database object
WMS.WMS_LPN_CONTENTS_INTERFACE is referenced by following:
Description: | Used to store the history information related to the container's past transactions |
---|
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 |
WMS.WMS_LPN_HISTORIES does not reference any database object
WMS.WMS_LPN_HISTORIES is referenced by following:
Description: | Used to provide the information related to a container instance (LPN) for a transaction |
---|
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 |
WMS.WMS_LPN_INTERFACE does not reference any database object
WMS.WMS_LPN_INTERFACE is referenced by following:
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 |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_LPN_PROCESS_TEMP.LPN_ID | WMS_LICENSE_PLATE_NUMBERS |
WMS.WMS_LPN_PROCESS_TEMP does not reference any database object
WMS.WMS_LPN_PROCESS_TEMP is referenced by following:
Description: | This is history table for mtl_material_transaction_temp. - This for WMS internal Use only. |
---|
WMS.WMS_MATERIAL_TXN_TRACE does not reference any database object
WMS.WMS_MATERIAL_TXN_TRACE is referenced by following:
Description: |
---|
WMS.WMS_MSG_COMPONENTS does not reference any database object
WMS.WMS_MSG_COMPONENTS is referenced by following:
Description: |
---|
WMS.WMS_MSG_TEMPLATES does not reference any database object
WMS.WMS_MSG_TEMPLATES is referenced by following:
Description: | WMS Business Objects |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_OBJECTS_B.STRAT_ASGMT_DB_OBJECT_ID | WMS_DB_OBJECTS |
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 |
WMS.WMS_OBJECTS_B does not reference any database object
WMS.WMS_OBJECTS_B is referenced by following:
Description: | Translation Table for WMS Business Objects |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_OBJECTS_TL.OBJECT_ID | WMS_OBJECTS_B |
WMS.WMS_OBJECTS_TL does not reference any database object
WMS.WMS_OBJECTS_TL is referenced by following:
Description: |
---|
WMS.WMS_OP_DESTINATION_SEL_APIS does not reference any database object
WMS.WMS_OP_DESTINATION_SEL_APIS is referenced by following:
Description: | Not intended for use in Release 11.5.9 |
---|
WMS.WMS_OP_OPERATION_INSTANCES does not reference any database object
WMS.WMS_OP_OPERATION_INSTANCES is referenced by following:
Description: | Not intended for use in Release 11.5.9 |
---|
WMS.WMS_OP_OPERTN_INSTANCES_ARCH does not reference any database object
WMS.WMS_OP_OPERTN_INSTANCES_ARCH is referenced by following:
Description: | Not intended for use in Release 11.5.9 |
---|
WMS.WMS_OP_OPERTN_INSTANCES_HIST does not reference any database object
WMS.WMS_OP_OPERTN_INSTANCES_HIST is referenced by following:
Description: | Table to store header level Operation Plan Information |
---|
WMS.WMS_OP_PLANS_B does not reference any database object
WMS.WMS_OP_PLANS_B is referenced by following:
Description: | Standard MLS TL Table for WMS_OP_PLANS_B |
---|
WMS.WMS_OP_PLANS_TL does not reference any database object
WMS.WMS_OP_PLANS_TL is referenced by following:
Description: | Table to store operation plan details |
---|
WMS.WMS_OP_PLAN_DETAILS does not reference any database object
WMS.WMS_OP_PLAN_DETAILS is referenced by following:
Description: | Not intended for use in Release 11.5.9 |
---|
WMS.WMS_OP_PLAN_INSTANCES does not reference any database object
WMS.WMS_OP_PLAN_INSTANCES is referenced by following:
Description: | Not intended for use in Release 11.5.9 |
---|
WMS.WMS_OP_PLAN_INSTANCES_ARCH does not reference any database object
WMS.WMS_OP_PLAN_INSTANCES_ARCH is referenced by following:
Description: | Not intended for use in Release 11.5.9 |
---|
WMS.WMS_OP_PLAN_INSTANCES_HIST does not reference any database object
WMS.WMS_OP_PLAN_INSTANCES_HIST is referenced by following:
Description: |
---|
WMS.WMS_ORDERED_TASKS does not reference any database object
WMS.WMS_ORDERED_TASKS is referenced by following:
Description: | WMS Strategy Search Order |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_ORG_HIERARCHY_OBJS.ORGANIZATION_ID | MTL_PARAMETERS |
WMS_ORG_HIERARCHY_OBJS.OBJECT_ID | WMS_OBJECTS_B |
WMS.WMS_ORG_HIERARCHY_OBJS does not reference any database object
WMS.WMS_ORG_HIERARCHY_OBJS is referenced by following:
Description: | This is history table for packaging. |
---|
WMS.WMS_PACKAGING_HIST does not reference any database object
WMS.WMS_PACKAGING_HIST is referenced by following:
Description: |
---|
WMS.WMS_PACKING_MATERIAL_GTEMP does not reference any database object
WMS.WMS_PACKING_MATERIAL_GTEMP is referenced by following:
Description: | WMS Mobile Page Fields Configuration |
---|
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 |
WMS.WMS_PAGE_FIELDS_B does not reference any database object
WMS.WMS_PAGE_FIELDS_B is referenced by following:
Description: | WMS Mobile Page Fields Configuration |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_PAGE_FIELDS_TL.FIELD_ID | WMS_PAGE_FIELDS_B |
WMS.WMS_PAGE_FIELDS_TL does not reference any database object
WMS.WMS_PAGE_FIELDS_TL is referenced by following:
Description: | Page Field Values |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_PAGE_FIELD_VALUES.FIELD_ID | WMS_PAGE_FIELDS_B |
WMS.WMS_PAGE_FIELD_VALUES does not reference any database object
WMS.WMS_PAGE_FIELD_VALUES is referenced by following:
Description: | Page Templates |
---|
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 |
WMS.WMS_PAGE_TEMPLATES_B does not reference any database object
WMS.WMS_PAGE_TEMPLATES_B is referenced by following:
Description: | Translated Table for Page Templates |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_PAGE_TEMPLATES_TL.TEMPLATE_ID | WMS_PAGE_TEMPLATES_B |
WMS.WMS_PAGE_TEMPLATES_TL does not reference any database object
WMS.WMS_PAGE_TEMPLATES_TL is referenced by following:
Description: | Page Template Fields |
---|
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 |
WMS.WMS_PAGE_TEMPLATE_FIELDS does not reference any database object
WMS.WMS_PAGE_TEMPLATE_FIELDS is referenced by following:
Description: | WMS Parameters |
---|
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 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 |
WMS.WMS_PARAMETERS_B does not reference any database object
WMS.WMS_PARAMETERS_B is referenced by following:
Description: | Translation Table for WMS Parameters |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_PARAMETERS_TL.PARAMETER_ID | WMS_PARAMETERS_B |
WMS.WMS_PARAMETERS_TL does not reference any database object
WMS.WMS_PARAMETERS_TL is referenced by following:
Description: | Table to associate IP Address/Port to the Printer |
---|
WMS.WMS_PRINTER_IP_DEF does not reference any database object
WMS.WMS_PRINTER_IP_DEF is referenced by following:
Description: |
---|
WMS.WMS_PUTAWAY_GROUP_TASKS_GTMP does not reference any database object
WMS.WMS_PUTAWAY_GROUP_TASKS_GTMP is referenced by following:
Description: |
---|
WMS.WMS_REPL_DEMAND_GTMP does not reference any database object
WMS.WMS_REPL_DEMAND_GTMP is referenced by following:
Description: | WMS Restrictions |
---|
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 |
WMS.WMS_RESTRICTIONS does not reference any database object
WMS.WMS_RESTRICTIONS is referenced by following:
Description: | WMS Rules |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_RULES_B.ORGANIZATION_ID | MTL_PARAMETERS |
WMS_RULES_B.QTY_FUNCTION_PARAMETER_ID | WMS_PARAMETERS_B |
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 |
WMS.WMS_RULES_B does not reference any database object
WMS.WMS_RULES_B is referenced by following:
Description: | Translation tables for WMS Rules |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_RULES_TL.RULE_ID | WMS_RULES_B |
WMS.WMS_RULES_TL does not reference any database object
WMS.WMS_RULES_TL is referenced by following:
Description: | WMS Rule Consistencies |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_RULE_CONSISTENCIES.RULE_ID | WMS_RULES_B |
WMS_RULE_CONSISTENCIES.PARAMETER_ID | WMS_PARAMETERS_B |
WMS.WMS_RULE_CONSISTENCIES does not reference any database object
WMS.WMS_RULE_CONSISTENCIES is referenced by following:
Description: | WMS Rule List Package Table is used to keep track the latest Rules List packages |
---|
WMS.WMS_RULE_LIST_PACKAGE does not reference any database object
WMS.WMS_RULE_LIST_PACKAGE is referenced by following:
Description: | WMS Rule Trace Headers |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_RULE_TRACE_LINES.HEADER_ID | WMS_RULE_TRACE_HEADERS |
WMS.WMS_RULE_TRACE_HEADERS does not reference any database object
WMS.WMS_RULE_TRACE_HEADERS is referenced by following:
Description: | WMS Rule Trace Lines |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_RULE_TRACE_LINES.HEADER_ID | WMS_RULE_TRACE_HEADERS |
WMS.WMS_RULE_TRACE_LINES does not reference any database object
WMS.WMS_RULE_TRACE_LINES is referenced by following:
Description: | WMS Saved Queries |
---|
WMS.WMS_SAVED_QUERIES does not reference any database object
WMS.WMS_SAVED_QUERIES is referenced by following:
Description: | Selection Criteria /Assignment Matrix Table |
---|
WMS.WMS_SELECTION_CRITERIA_TXN does not reference any database object
WMS.WMS_SELECTION_CRITERIA_TXN is referenced by following:
Description: | WMS_SERIAL_NUMBERS_TEMP is a history table . - This for WMS internal Use only. |
---|
WMS.WMS_SERIAL_NUMBERS_TRACE does not reference any database object
WMS.WMS_SERIAL_NUMBERS_TRACE is referenced by following:
Description: | Temporary table used in mobile ship confirmation |
---|
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 |
WMS.WMS_SHIPPING_TRANSACTION_TEMP does not reference any database object
WMS.WMS_SHIPPING_TRANSACTION_TEMP is referenced by following:
Description: | Table to capture task exceptions for skipping task |
---|
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 |
WMS.WMS_SKIP_TASK_EXCEPTIONS does not reference any database object
WMS.WMS_SKIP_TASK_EXCEPTIONS is referenced by following:
Description: | WMS Sort Criteria |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_SORT_CRITERIA.RULE_ID | WMS_RULES_B |
WMS_SORT_CRITERIA.PARAMETER_ID | WMS_PARAMETERS_B |
WMS.WMS_SORT_CRITERIA does not reference any database object
WMS.WMS_SORT_CRITERIA is referenced by following:
Description: | This table stores the staging lane to dock door relationship. |
---|
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 |
WMS.WMS_STAGINGLANES_ASSIGNMENTS does not reference any database object
WMS.WMS_STAGINGLANES_ASSIGNMENTS is referenced by following:
Description: | WMS Strategies |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_STRATEGIES_B.ORGANIZATION_ID | MTL_PARAMETERS |
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 |
WMS.WMS_STRATEGIES_B does not reference any database object
WMS.WMS_STRATEGIES_B is referenced by following:
Description: | Translation Table for WMS Strategies |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_STRATEGIES_TL.STRATEGY_ID | WMS_STRATEGIES_B |
WMS.WMS_STRATEGIES_TL does not reference any database object
WMS.WMS_STRATEGIES_TL is referenced by following:
Description: | WMS Strategy Assignments |
---|
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 |
WMS.WMS_STRATEGY_ASSIGNMENTS does not reference any database object
WMS.WMS_STRATEGY_ASSIGNMENTS is referenced by following:
Description: | WMS Strategy Members |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_STRATEGY_MEMBERS.RULE_ID | WMS_RULES_B |
WMS_STRATEGY_MEMBERS.STRATEGY_ID | WMS_STRATEGIES_B |
WMS.WMS_STRATEGY_MEMBERS does not reference any database object
WMS.WMS_STRATEGY_MEMBERS is referenced by following:
Description: |
---|
WMS.WMS_TASKS_TEMP does not reference any database object
WMS.WMS_TASKS_TEMP is referenced by following:
Description: | Task Filter Definitions |
---|
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 |
WMS.WMS_TASK_FILTER_B does not reference any database object
WMS.WMS_TASK_FILTER_B is referenced by following:
Description: | Filter Constraints |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_TASK_FILTER_DTL.TASK_FILTER_ID | WMS_TASK_FILTER_B |
WMS.WMS_TASK_FILTER_DTL does not reference any database object
WMS.WMS_TASK_FILTER_DTL is referenced by following:
Description: | Translated Task Filters |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_TASK_FILTER_TL.TASK_FILTER_ID | WMS_TASK_FILTER_B |
WMS.WMS_TASK_FILTER_TL does not reference any database object
WMS.WMS_TASK_FILTER_TL is referenced by following:
Description: | WMS Detailing Temporary Table |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_TRANSACTIONS_TEMP.RULE_ID | WMS_RULES_B |
WMS_TRANSACTIONS_TEMP.TRANSACTION_TEMP_ID | MTL_TXN_REQUEST_LINES |
WMS.WMS_TRANSACTIONS_TEMP does not reference any database object
WMS.WMS_TRANSACTIONS_TEMP is referenced by following:
Description: | WMS_TRANSACTION_LOTS is history table - This for WMS internal Use only. |
---|
WMS.WMS_TRANSACTION_LOTS_TRACE does not reference any database object
WMS.WMS_TRANSACTION_LOTS_TRACE is referenced by following:
Description: | WMS Detailing Context Temporary Table |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_TXN_CONTEXT_TEMP.LINE_ID | MTL_TXN_REQUEST_LINES |
WMS.WMS_TXN_CONTEXT_TEMP does not reference any database object
WMS.WMS_TXN_CONTEXT_TEMP is referenced by following:
Description: |
---|
WMS.WMS_WAVEPLAN_TASKS_TEMP does not reference any database object
WMS.WMS_WAVEPLAN_TASKS_TEMP is referenced by following:
Description: |
---|
WMS.WMS_WP_EXCEPTIONS_GTMP does not reference any database object
WMS.WMS_WP_EXCEPTIONS_GTMP is referenced by following:
Description: |
---|
WMS.WMS_WP_LABOR_GTMP does not reference any database object
WMS.WMS_WP_LABOR_GTMP is referenced by following:
Description: |
---|
WMS.WMS_WP_LINES_GTMP does not reference any database object
WMS.WMS_WP_LINES_GTMP is referenced by following:
Description: |
---|
WMS.WMS_WP_ORDERS_GTMP does not reference any database object
WMS.WMS_WP_ORDERS_GTMP is referenced by following:
Description: |
---|
WMS.WMS_WP_REC_REQUESTS_GTMP does not reference any database object
WMS.WMS_WP_REC_REQUESTS_GTMP is referenced by following:
Description: |
---|
WMS.WMS_WP_REQUESTS_GTMP does not reference any database object
WMS.WMS_WP_REQUESTS_GTMP is referenced by following:
Description: |
---|
WMS.WMS_WP_RESERVATIONS_GTMP does not reference any database object
WMS.WMS_WP_RESERVATIONS_GTMP is referenced by following:
Description: |
---|
WMS.WMS_WP_RULES_SIMULATION does not reference any database object
WMS.WMS_WP_RULES_SIMULATION is referenced by following:
Description: |
---|
WMS.WMS_WP_TASKS_GTMP does not reference any database object
WMS.WMS_WP_TASKS_GTMP is referenced by following:
Description: |
---|
WMS.WMS_WP_TP_MMTT does not reference any database object
WMS.WMS_WP_TP_MMTT is referenced by following:
Description: |
---|
WMS.WMS_WP_WAVE_DETAILS_GTMP does not reference any database object
WMS.WMS_WP_WAVE_DETAILS_GTMP is referenced by following:
Description: |
---|
WMS.WMS_WSH_WDD_GTEMP does not reference any database object
WMS.WMS_WSH_WDD_GTEMP is referenced by following:
Description: |
---|
WMS.WMS_XDOCK_PEGGING_GTMP does not reference any database object
WMS.WMS_XDOCK_PEGGING_GTMP is referenced by following:
Description: | WMS Crossdock Criteria source type assignments |
---|
Foreign Key Column | Foreign Table |
---|---|
WMS_XDOCK_SOURCE_ASSIGNMENTS.CRITERION_ID | % |
WMS.WMS_XDOCK_SOURCE_ASSIGNMENTS does not reference any database object
WMS.WMS_XDOCK_SOURCE_ASSIGNMENTS is referenced by following:
Description: |
---|
WMS.WMS_ZONES_B does not reference any database object
WMS.WMS_ZONES_B is referenced by following:
Description: |
---|
WMS.WMS_ZONES_TL does not reference any database object
WMS.WMS_ZONES_TL is referenced by following:
Description: |
---|
WMS.WMS_ZONE_LOCATORS does not reference any database object
WMS.WMS_ZONE_LOCATORS is referenced by following:
APPS.WMS_ACCESS_RULES_LOV_V is not referenced by any database object
APPS.WMS_ACTIVE_EXCEPTIONS_V is not referenced by any database object
APPS.WMS_ACTIVE_TASKS_V is not referenced by any database object
APPS.WMS_BUS_EVENT_DEVICES_V is not referenced by any database object
APPS.WMS_COMPLETED_EXCEPTIONS_V is not referenced by any database object
APPS.WMS_COMPLETED_TASKS_V is not referenced by any database object
APPS.WMS_COST_GROUPS_INPUT_V is not referenced by any database object
APPS.WMS_CROSSDOCK_CRITERIA_VL is not referenced by any database object
APPS.WMS_DEPTS_V is not referenced by any database object
APPS.WMS_DEPT_SUBINVENTORIES_V is not referenced by any database object
APPS.WMS_DEVICE_REQUESTS_HIST_V is not referenced by any database object
APPS.WMS_DEVICE_REQUESTS_WCSV is not referenced by any database object
APPS.WMS_DISPATCHABLE_TASKS_V is not referenced by any database object
APPS.WMS_DOCKS_V is not referenced by any database object
APPS.WMS_DOCK_APPOINTMENTS_V is not referenced by any database object
APPS.WMS_ELS_GROUPED_TASKS_VL is not referenced by any database object
APPS.WMS_ELS_INDIVIDUAL_TASKS_VL is not referenced by any database object
APPS.WMS_EXCEPTIONS_V is not referenced by any database object
APPS.WMS_ITEM_LOCATIONS_KFV is not referenced by any database object
APPS.WMS_LABEL_FIELDS_VL is not referenced by any database object
APPS.WMS_LABEL_FIELD_VARIABLES_VL is not referenced by any database object
APPS.WMS_LABEL_FORMATS_V is not referenced by any database object
APPS.WMS_LABEL_REQUESTS_HIST_V is not referenced by any database object
APPS.WMS_LABEL_SET_FORMATS_V is not referenced by any database object
APPS.WMS_LICENSE_PLATE_NUMBERS_V is not referenced by any database object
APPS.WMS_LOADED_QUANTITIES_V is not referenced by any database object
APPS.WMS_LPN_CONTENTS_DETAIL_V is not referenced by any database object
APPS.WMS_LPN_CONTENTS_LOT_V is not referenced by any database object
APPS.WMS_LPN_CONTENTS_SERIAL_V is not referenced by any database object
APPS.WMS_LPN_CONTENTS_V is not referenced by any database object
APPS.WMS_OBJECTS_HIERARCHY_LOV_V is not referenced by any database object
APPS.WMS_OBJECTS_OPERAND_LOV_V is not referenced by any database object
APPS.WMS_OBJECTS_RULE_LOV_V is not referenced by any database object
APPS.WMS_OBJECTS_STRATEGY_LOV_V is not referenced by any database object
APPS.WMS_OBJECTS_STRATEGY_V is not referenced by any database object
APPS.WMS_ONHAND_AND_LOADED_QTY_V is not referenced by any database object
APPS.WMS_OP_PLANS_V is not referenced by any database object
APPS.WMS_OP_PLANS_VL is not referenced by any database object
APPS.WMS_OP_PLAN_DETAILS_V is not referenced by any database object
APPS.WMS_ORG_HIERARCHY_OBJS_V is not referenced by any database object
APPS.WMS_PACKING_KITTING_V is not referenced by any database object
APPS.WMS_PACKING_LPN_CONT_V is not referenced by any database object
APPS.WMS_PACKING_MATERIAL_V is not referenced by any database object
APPS.WMS_PAGE_CONFIG_UI_V is not referenced by any database object
APPS.WMS_PAGE_TEMPLATES_FIELDS_F_V is not referenced by any database object
APPS.WMS_PARAMETERS_LOV_V is not referenced by any database object
APPS.WMS_PENDING_EXCEPTIONS_V is not referenced by any database object
APPS.WMS_PENDING_TASKS_V is not referenced by any database object
APPS.WMS_PERSON_RESOURCE_UTT_V is not referenced by any database object
APPS.WMS_RESTRICTIONS_V is not referenced by any database object
APPS.WMS_RULE_CONSISTENCIES_V is not referenced by any database object
APPS.WMS_SELECTION_CRITERIA_TXN_V is not referenced by any database object
APPS.WMS_SHIP_TO_SITES_V is not referenced by any database object
APPS.WMS_SORT_CRITERIA_V is not referenced by any database object
APPS.WMS_STAGINGLANES_ASSIGNMENTS_V is not referenced by any database object
APPS.WMS_STRATEGIES_V is not referenced by any database object
APPS.WMS_STRATEGY_ASSIGNMENTS_V2 is not referenced by any database object
APPS.WMS_STRATEGY_MAT_TXN_TMP_V is not referenced by any database object
APPS.WMS_STRATEGY_MEMBERS_V is not referenced by any database object
APPS.WMS_SUGGESTIONS_TEMP_V is not referenced by any database object
APPS.WMS_SUGGESTIONS_TRACE_V is not referenced by any database object
APPS.WMS_TASKS_V is not referenced by any database object
APPS.WMS_TASK_FILTER_VL is not referenced by any database object
APPS.WMS_TASK_RELEASE_VL is not referenced by any database object
APPS.WMS_TRX_DETAILS_TMP_V is not referenced by any database object
APPS.WMS_TXN_REQUEST_LINES_TRACE_V is not referenced by any database object
APPS.WMS_WAVEPLAN_TASKS_V is not referenced by any database object
APPS.WMS_WAVEPLAN_TASK_EXCEPTIONS_V is not referenced by any database object
APPS.WMS_WP_LINES_GTMP_V is not referenced by any database object
APPS.WMS_WP_ORDERS_GTMP_V is not referenced by any database object
APPS.WMS_WP_PLANNING_CRITERIA_VL is not referenced by any database object
APPS.WMS_WP_REC_REQUESTS_GTMP_V is not referenced by any database object
APPS.WMS_WP_REQUESTS_GTMP_V is not referenced by any database object
APPS.WMS_WP_TASKS_GTMP_V is not referenced by any database object
APPS.WMS_WP_WAVE_DETAILS_GTMP_V is not referenced by any database object
APPS.WMS_WP_WAVE_EXCEPTIONS_VL is not referenced by any database object
APPS.WMS_WP_WAVE_HEADERS_VL is not referenced by any database object
APPS.WMS_WP_WWB_ORDERS_V is not referenced by any database object
APPS.WMS_XDOCK_SOURCE_ASSIGNMENTS_V is not referenced by any database object
APPS.WMS_ZONE_LOCATORS_ALL_V is not referenced by any database object
APPS.WMS_ZONE_LOCATORS_TEMP is not referenced by any database object
APPS.WMS_ZONE_LOCATORS_V is not referenced by any database object
APPS.WMS_ZONE_LPN_FOR_RULE is not referenced by any database object
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |