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: | Cost error table |
---|
INV.COST_UPGR_ERROR_TABLE does not reference any database object
INV.COST_UPGR_ERROR_TABLE is referenced by following:
Description: |
---|
INV.INV_DIAG_MSN_TEMP does not reference any database object
INV.INV_DIAG_MSN_TEMP is referenced by following:
Description: |
---|
INV.INV_ITEM_TEMP does not reference any database object
INV.INV_ITEM_TEMP is referenced by following:
Description: | This table will be used as basis for capacity calculation seeded source in 3PL Billing Solution |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_3PL_LOCATOR_OCCUPANCY.CLIENT_CODE | MTL_CLIENT_PARAMETERS |
INV.MTL_3PL_LOCATOR_OCCUPANCY does not reference any database object
INV.MTL_3PL_LOCATOR_OCCUPANCY is referenced by following:
Description: | Assigns abc classes to abc groups |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_ABC_ASSGN_GROUP_CLASSES.ABC_CLASS_ID | MTL_ABC_CLASSES |
MTL_ABC_ASSGN_GROUP_CLASSES.ASSIGNMENT_GROUP_ID | MTL_ABC_ASSIGNMENT_GROUPS |
Foreign Key Column | Foreign Table |
---|---|
MTL_ABC_ASSIGNMENTS.ASSIGNMENT_GROUP_ID
MTL_ABC_ASSIGNMENTS.ABC_CLASS_ID |
MTL_ABC_ASSGN_GROUP_CLASSES |
INV.MTL_ABC_ASSGN_GROUP_CLASSES does not reference any database object
INV.MTL_ABC_ASSGN_GROUP_CLASSES is referenced by following:
Description: | Assigns items to abc classes in an abc group |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_ABC_ASSIGNMENTS.ASSIGNMENT_GROUP_ID | MTL_ABC_ASSIGNMENT_GROUPS |
MTL_ABC_ASSIGNMENTS.ABC_CLASS_ID | MTL_ABC_CLASSES |
MTL_ABC_ASSIGNMENTS.ASSIGNMENT_GROUP_ID
MTL_ABC_ASSIGNMENTS.ABC_CLASS_ID |
MTL_ABC_ASSGN_GROUP_CLASSES |
INV.MTL_ABC_ASSIGNMENTS does not reference any database object
INV.MTL_ABC_ASSIGNMENTS is referenced by following:
Description: | Defines abc groups |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_ABC_ASSIGNMENT_GROUPS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_ABC_ASSIGNMENT_GROUPS.COMPILE_ID | MTL_ABC_COMPILE_HEADERS |
MTL_ABC_ASSIGNMENT_GROUPS.SECONDARY_INVENTORY
MTL_ABC_ASSIGNMENT_GROUPS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
Foreign Key Column | Foreign Table |
---|---|
MRP_PARAMETERS.DEFAULT_ABC_ASSIGNMENT_GROUP | MTL_ABC_ASSIGNMENT_GROUPS |
MTL_ABC_ASSGN_GROUP_CLASSES.ASSIGNMENT_GROUP_ID | MTL_ABC_ASSIGNMENT_GROUPS |
MTL_ABC_ASSIGNMENTS.ASSIGNMENT_GROUP_ID | MTL_ABC_ASSIGNMENT_GROUPS |
MTL_CYCLE_COUNT_HEADERS.ABC_ASSIGNMENT_GROUP_ID | MTL_ABC_ASSIGNMENT_GROUPS |
MTL_CYCLE_COUNT_CLASSES.ABC_ASSIGNMENT_GROUP_ID | MTL_ABC_ASSIGNMENT_GROUPS |
INV.MTL_ABC_ASSIGNMENT_GROUPS does not reference any database object
INV.MTL_ABC_ASSIGNMENT_GROUPS is referenced by following:
Description: | Inventory ABC classes |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_ABC_CLASSES.ORGANIZATION_ID | MTL_PARAMETERS |
Foreign Key Column | Foreign Table |
---|---|
MRP_SYSTEM_ITEMS.ABC_CLASS | MTL_ABC_CLASSES |
MTL_ABC_ASSGN_GROUP_CLASSES.ABC_CLASS_ID | MTL_ABC_CLASSES |
MTL_ABC_ASSIGNMENTS.ABC_CLASS_ID | MTL_ABC_CLASSES |
MTL_CYCLE_COUNT_CLASSES.ABC_CLASS_ID | MTL_ABC_CLASSES |
MTL_CYCLE_COUNT_ITEMS.ABC_CLASS_ID | MTL_ABC_CLASSES |
INV.MTL_ABC_CLASSES does not reference any database object
INV.MTL_ABC_CLASSES is referenced by following:
Description: | ABC descending value compile data |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_ABC_COMPILES.SECONDARY_INVENTORY
MTL_ABC_COMPILES.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_ABC_COMPILES.COMPILE_ID | MTL_ABC_COMPILE_HEADERS |
MTL_ABC_COMPILES.INVENTORY_ITEM_ID
MTL_ABC_COMPILES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
INV.MTL_ABC_COMPILES does not reference any database object
INV.MTL_ABC_COMPILES is referenced by following:
Description: | Euro as a Functional Currency Archive |
---|
INV.MTL_ABC_COMPILES_EFC does not reference any database object
INV.MTL_ABC_COMPILES_EFC is referenced by following:
Description: | ABC compile header data |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_ABC_COMPILE_HEADERS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_ABC_COMPILE_HEADERS.SCHEDULE_DESIGNATOR
MTL_ABC_COMPILE_HEADERS.ORGANIZATION_ID |
MRP_SCHEDULE_DESIGNATORS |
MTL_ABC_COMPILE_HEADERS.SECONDARY_INVENTORY
MTL_ABC_COMPILE_HEADERS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_ABC_COMPILE_HEADERS.MRP_FORECAST_NAME
MTL_ABC_COMPILE_HEADERS.ORGANIZATION_ID |
MRP_FORECAST_DESIGNATORS |
MTL_ABC_COMPILE_HEADERS.ORGANIZATION_ID
MTL_ABC_COMPILE_HEADERS.MRP_PLAN_NAME |
MRP_PLANS |
MTL_ABC_COMPILE_HEADERS.COST_TYPE | CST_COST_TYPES |
Foreign Key Column | Foreign Table |
---|---|
MTL_ABC_ASSIGNMENT_GROUPS.COMPILE_ID | MTL_ABC_COMPILE_HEADERS |
MTL_ABC_COMPILES.COMPILE_ID | MTL_ABC_COMPILE_HEADERS |
INV.MTL_ABC_COMPILE_HEADERS does not reference any database object
INV.MTL_ABC_COMPILE_HEADERS is referenced by following:
Description: | Euro as a Functional Currency Archive |
---|
INV.MTL_ABC_COMPILE_HEADERS_EFC does not reference any database object
INV.MTL_ABC_COMPILE_HEADERS_EFC is referenced by following:
Description: | Action Codes |
---|
INV.MTL_ACTIONS_B does not reference any database object
INV.MTL_ACTIONS_B is referenced by following:
Description: | Action Codes Language Translation |
---|
INV.MTL_ACTIONS_TL does not reference any database object
INV.MTL_ACTIONS_TL is referenced by following:
Description: | Stores the material overhead subelements |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_ACTUAL_COST_SUBELEMENT.TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
MTL_ACTUAL_COST_SUBELEMENT.COST_ELEMENT_ID | CST_COST_ELEMENTS |
MTL_ACTUAL_COST_SUBELEMENT.RESOURCE_ID | BOM_RESOURCES |
INV.MTL_ACTUAL_COST_SUBELEMENT does not reference any database object
INV.MTL_ACTUAL_COST_SUBELEMENT is referenced by following:
Description: | Euro as a Functional Currency Archive |
---|
INV.MTL_ACTUAL_COST_SUBELEMENT_EFC does not reference any database object
INV.MTL_ACTUAL_COST_SUBELEMENT_EFC is referenced by following:
Description: |
---|
INV.MTL_ADJUSTMENT_SYNC_TEMP does not reference any database object
INV.MTL_ADJUSTMENT_SYNC_TEMP is referenced by following:
Description: | ATP computation rules |
---|
Foreign Key Column | Foreign Table |
---|---|
BOM_DEPARTMENT_RESOURCES.ATP_RULE_ID | MTL_ATP_RULES |
MTL_DEMAND_INTERFACE.ATP_RULE_ID | MTL_ATP_RULES |
MTL_PARAMETERS.DEFAULT_ATP_RULE_ID | MTL_ATP_RULES |
MTL_SYSTEM_ITEMS_B.ATP_RULE_ID | MTL_ATP_RULES |
INV.MTL_ATP_RULES does not reference any database object
INV.MTL_ATP_RULES is referenced by following:
Description: | Dependencies between item attributes and Oracle products |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_ATTR_APPL_DEPENDENCIES.ATTRIBUTE_NAME | MTL_ITEM_ATTRIBUTES |
MTL_ATTR_APPL_DEPENDENCIES.APPLICATION_ID | FND_APPLICATION |
INV.MTL_ATTR_APPL_DEPENDENCIES does not reference any database object
INV.MTL_ATTR_APPL_DEPENDENCIES is referenced by following:
Description: |
---|
INV.MTL_AVAILABLE_INVENTORY_TEMP does not reference any database object
INV.MTL_AVAILABLE_INVENTORY_TEMP is referenced by following:
Description: | Base table for 3PL Billing Rules definitions |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_BILLING_RULE_LINES.BILLING_RULE_HEADER_ID | MTL_BILLING_RULE_HEADERS_B |
INV.MTL_BILLING_RULE_HEADERS_B does not reference any database object
INV.MTL_BILLING_RULE_HEADERS_B is referenced by following:
Description: | Translation table for 3PL billing rule header table |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_BILLING_RULE_HEADERS_TL.BILLING_RULE_HEADER_ID | % |
INV.MTL_BILLING_RULE_HEADERS_TL does not reference any database object
INV.MTL_BILLING_RULE_HEADERS_TL is referenced by following:
Description: | Billing Rule Lines table for 3PL Billing Project. |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_BILLING_RULE_LINES.BILLING_RULE_HEADER_ID | MTL_BILLING_RULE_HEADERS_B |
MTL_BILLING_RULE_LINES.CLIENT_CODE | MTL_CLIENT_PARAMETERS |
INV.MTL_BILLING_RULE_LINES does not reference any database object
INV.MTL_BILLING_RULE_LINES is referenced by following:
Description: | Base Table for Billing sources required in 3PL Billing project |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_BILLING_SOURCES_TL.BILLING_SOURCE_ID | MTL_BILLING_SOURCES_B |
INV.MTL_BILLING_SOURCES_B does not reference any database object
INV.MTL_BILLING_SOURCES_B is referenced by following:
Description: | MTL_BILLING_SOURCES_TL is the translation table for the billing sources |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_BILLING_SOURCES_TL.BILLING_SOURCE_ID | MTL_BILLING_SOURCES_B |
INV.MTL_BILLING_SOURCES_TL does not reference any database object
INV.MTL_BILLING_SOURCES_TL is referenced by following:
Description: | BIS table that stores inventory turns data by organization, accounting period and Inventory item id for open periods and closed periods |
---|
INV.MTL_BIS_INV_BY_PERIOD does not reference any database object
INV.MTL_BIS_INV_BY_PERIOD is referenced by following:
Description: | Items returned by item searches |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_CATALOG_SEARCH_ITEMS.INVENTORY_ITEM_ID
MTL_CATALOG_SEARCH_ITEMS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
INV.MTL_CATALOG_SEARCH_ITEMS does not reference any database object
INV.MTL_CATALOG_SEARCH_ITEMS is referenced by following:
Description: | Code combinations table for Item Category |
---|
Foreign Key Column | Foreign Table |
---|---|
AR_REVENUE_ADJUSTMENTS_ALL.FROM_CATEGORY_ID | MTL_CATEGORIES_B |
AR_REVENUE_ADJUSTMENTS_ALL.TO_CATEGORY_ID | MTL_CATEGORIES_B |
AS_AP_TRACKING_OBJECTIVES.PRODUCT_CATEGORY_ID | MTL_CATEGORIES_B |
AS_INTEREST_CODES_B.CATEGORY_ID | MTL_CATEGORIES_B |
CSI_I_EXTENDED_ATTRIBS.ITEM_CATEGORY_ID | MTL_CATEGORIES_B |
CSP_EXCESS_RULES_B.CATEGORY_ID | MTL_CATEGORIES_B |
CSP_PLANNING_PARAMETERS.CATEGORY_ID | MTL_CATEGORIES_B |
CSS_DEF_CAT_PROD_DENORM.CATEGORY_ID | MTL_CATEGORIES_B |
CSS_DEF_PROD_CAT_HRCHY.CATEGORY_ID | MTL_CATEGORIES_B |
CSS_DEF_PROD_CAT_HRCHY.PARENT_CATEGORY_ID | MTL_CATEGORIES_B |
CST_COST_TYPE_HISTORY.CATEGORY_ID | MTL_CATEGORIES_B |
CST_COST_UPDATES.CATEGORY_ID | MTL_CATEGORIES_B |
CST_ITEM_OVERHEAD_DEFAULTS.CATEGORY_ID | MTL_CATEGORIES_B |
CS_INCIDENTS_ALL_B.CATEGORY_ID | MTL_CATEGORIES_B |
CS_SR_PROB_CODE_MAPPING.CATEGORY_ID | MTL_CATEGORIES_B |
CS_SR_PROB_CODE_MAPPING_DETAIL.CATEGORY_ID | MTL_CATEGORIES_B |
CS_SR_RES_CODE_MAPPING.CATEGORY_ID | MTL_CATEGORIES_B |
CS_SR_RES_CODE_MAPPING_DETAIL.CATEGORY_ID | MTL_CATEGORIES_B |
HZ_CREDIT_PROFILES.ITEM_CATEGORY_ID | MTL_CATEGORIES_B |
IBE_CT_IMEDIA_SEARCH.CATEGORY_ID | MTL_CATEGORIES_B |
IBE_CT_RELATION_RULES.ORIGIN_OBJECT_ID | MTL_CATEGORIES_B |
IBE_CT_RELATION_RULES.DEST_OBJECT_ID | MTL_CATEGORIES_B |
IBE_DSP_OBJ_LGL_CTNT.OBJECT_ID | MTL_CATEGORIES_B |
IBE_DSP_TPL_CTG.CATEGORY_ID | MTL_CATEGORIES_B |
MTL_CATEGORIES_B | |
ICX_RELATED_CATEGORIES.CATEGORY_ID | MTL_CATEGORIES_B |
ICX_RELATED_CATEGORIES.RELATED_CATEGORY_ID | MTL_CATEGORIES_B |
MTL_CATEGORIES_B | |
IGR_EPU_CATEGORY_UPG.PRODUCT_CATEGORY_ID | MTL_CATEGORIES_B |
IGR_IS_I_LINES.PRODUCT_CATEGORY_ID | MTL_CATEGORIES_B |
IGR_I_LINES_INT.PRODUCT_CATEGORY_ID | MTL_CATEGORIES_B |
IGR_I_PKGITM_ASSIGN.PRODUCT_CATEGORY_ID | MTL_CATEGORIES_B |
JTF_DSP_OBJ_LGL_CTNT.OBJECT_ID | MTL_CATEGORIES_B |
JTF_DSP_TPL_CTG.CATEGORY_ID | MTL_CATEGORIES_B |
MRP_SR_ASSIGNMENTS.CATEGORY_ID | MTL_CATEGORIES_B |
MRP_SYSTEM_ITEMS.CATEGORY_ID | MTL_CATEGORIES_B |
FTE_LANE_COMMODITIES.COMMODITY_CATG_ID | MTL_CATEGORIES_B |
MTL_CATEGORIES_TL.CATEGORY_ID | MTL_CATEGORIES_B |
MTL_CATEGORY_ACCOUNTS.CATEGORY_ID | MTL_CATEGORIES_B |
MTL_CATEGORY_SETS_B.DEFAULT_CATEGORY_ID | MTL_CATEGORIES_B |
MTL_CATEGORY_SET_VALID_CATS.CATEGORY_ID | MTL_CATEGORIES_B |
MTL_FISCAL_CAT_ACCOUNTS.CATEGORY_ID | MTL_CATEGORIES_B |
MTL_ICG_CATEGORIES.CATEGORY_ID | MTL_CATEGORIES_B |
MTL_SUPPLY.CATEGORY_ID | MTL_CATEGORIES_B |
PA_RESOURCE_ASSIGNMENTS.ITEM_CATEGORY_ID | MTL_CATEGORIES_B |
PA_RESOURCE_LIST_MEMBERS.ITEM_CATEGORY_ID | MTL_CATEGORIES_B |
PJM_DEFAULT_TASKS.CATEGORY_ID | MTL_CATEGORIES_B |
PON_AUCTION_ITEM_PRICES_ALL.CATEGORY_ID | MTL_CATEGORIES_B |
PON_AUCTION_TEMPLATES.CATEGORY_ID | MTL_CATEGORIES_B |
PON_AUC_ITEMS_INTERFACE.CATEGORY_ID | MTL_CATEGORIES_B |
PO_AGENTS.CATEGORY_ID | MTL_CATEGORIES_B |
PO_COMMODITY_CATEGORIES.CATEGORY_ID | MTL_CATEGORIES_B |
PO_LINES_ARCHIVE_ALL.CATEGORY_ID | MTL_CATEGORIES_B |
PO_LINES_DRAFT_ALL.CATEGORY_ID | MTL_CATEGORIES_B |
PO_LINES_ALL.CATEGORY_ID | MTL_CATEGORIES_B |
PO_LINE_TYPES_B.CATEGORY_ID | MTL_CATEGORIES_B |
PO_REQEXPRESS_LINES_ALL.CATEGORY_ID | MTL_CATEGORIES_B |
PO_REQUISITIONS_INTERFACE_ALL.CATEGORY_ID | MTL_CATEGORIES_B |
PO_REQUISITION_LINES_ALL.CATEGORY_ID | MTL_CATEGORIES_B |
RCV_SHIPMENT_LINES.CATEGORY_ID | MTL_CATEGORIES_B |
INV.MTL_CATEGORIES_B does not reference any database object
INV.MTL_CATEGORIES_B is referenced by following:
Description: | Categories table storing translated Description column for Item Categories |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_CATEGORIES_TL.CATEGORY_ID | MTL_CATEGORIES_B |
INV.MTL_CATEGORIES_TL does not reference any database object
INV.MTL_CATEGORIES_TL is referenced by following:
Description: | Asset and expense accounts by item category, by subinventory |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_CATEGORY_ACCOUNTS.CATEGORY_ID | MTL_CATEGORIES_B |
MTL_CATEGORY_ACCOUNTS.ENCUMBRANCE_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_CATEGORY_ACCOUNTS.BRIDGING_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_CATEGORY_ACCOUNTS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_CATEGORY_ACCOUNTS.MATERIAL_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_CATEGORY_ACCOUNTS.MATERIAL_OVERHEAD_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_CATEGORY_ACCOUNTS.RESOURCE_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_CATEGORY_ACCOUNTS.OUTSIDE_PROCESSING_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_CATEGORY_ACCOUNTS.OVERHEAD_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_CATEGORY_ACCOUNTS.EXPENSE_ACCOUNT | GL_CODE_COMBINATIONS |
INV.MTL_CATEGORY_ACCOUNTS does not reference any database object
INV.MTL_CATEGORY_ACCOUNTS is referenced by following:
Description: | Category Sets |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_CATEGORY_SETS_B.DEFAULT_CATEGORY_ID | MTL_CATEGORIES_B |
Foreign Key Column | Foreign Table |
---|---|
AS_AP_TRACKING_OBJECTIVES.PRODUCT_CAT_SET_ID | MTL_CATEGORY_SETS_B |
AS_INTEREST_CATEGORY_SETS_ALL.CATEGORY_SET_ID | MTL_CATEGORY_SETS_B |
AS_INTEREST_CODES_B.CATEGORY_SET_ID | MTL_CATEGORY_SETS_B |
CSP_EXCESS_RULES_B.CATEGORY_SET_ID | MTL_CATEGORY_SETS_B |
CSP_PLANNING_PARAMETERS.CATEGORY_SET_ID | MTL_CATEGORY_SETS_B |
CST_COST_TYPE_HISTORY.CATEGORY_SET_ID | MTL_CATEGORY_SETS_B |
CST_COST_UPDATES.CATEGORY_SET_ID | MTL_CATEGORY_SETS_B |
CS_INCIDENTS_ALL_B.CATEGORY_SET_ID | MTL_CATEGORY_SETS_B |
IBE_CT_IMEDIA_SEARCH.CATEGORY_SET_ID | MTL_CATEGORY_SETS_B |
ICX_RELATED_CATEGORIES.CATEGORY_SET_ID | MTL_CATEGORY_SETS_B |
MTL_CATEGORY_SETS_B | |
ICX_WEB_STORE_OPTIONS.CATEGORY_SET_ID | MTL_CATEGORY_SETS_B |
IGR_EPU_CATEGORY_UPG.PRODUCT_CATEGORY_SET_ID | MTL_CATEGORY_SETS_B |
IGR_IS_I_LINES.PRODUCT_CATEGORY_SET_ID | MTL_CATEGORY_SETS_B |
IGR_I_LINES_INT.PRODUCT_CATEGORY_SET_ID | MTL_CATEGORY_SETS_B |
IGR_I_PKGITM_ASSIGN.PRODUCT_CATEGORY_SET_ID | MTL_CATEGORY_SETS_B |
MTL_CATEGORY_SETS_TL.CATEGORY_SET_ID | MTL_CATEGORY_SETS_B |
MTL_CATEGORY_SET_VALID_CATS.CATEGORY_SET_ID | MTL_CATEGORY_SETS_B |
MTL_DEFAULT_CATEGORY_SETS.CATEGORY_SET_ID | MTL_CATEGORY_SETS_B |
MTL_ICG_CATEGORIES.CATEGORY_SET_ID | MTL_CATEGORY_SETS_B |
PA_PLAN_RES_DEFAULTS.ITEM_CATEGORY_SET_ID | MTL_CATEGORY_SETS_B |
ZX_FC_TYPES_B.OWNER_ID_NUM | MTL_CATEGORY_SETS_B |
INV.MTL_CATEGORY_SETS_B does not reference any database object
INV.MTL_CATEGORY_SETS_B is referenced by following:
Description: | A table holding translated Name and Description columns for Category Sets |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_CATEGORY_SETS_TL.CATEGORY_SET_ID | MTL_CATEGORY_SETS_B |
INV.MTL_CATEGORY_SETS_TL does not reference any database object
INV.MTL_CATEGORY_SETS_TL is referenced by following:
Description: | Valid categories for category sets |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_CATEGORY_SET_VALID_CATS.CATEGORY_SET_ID | MTL_CATEGORY_SETS_B |
MTL_CATEGORY_SET_VALID_CATS.CATEGORY_ID | MTL_CATEGORIES_B |
Foreign Key Column | Foreign Table |
---|---|
MTL_ITEM_CATEGORIES.CATEGORY_SET_ID
MTL_ITEM_CATEGORIES.CATEGORY_ID |
MTL_CATEGORY_SET_VALID_CATS |
INV.MTL_CATEGORY_SET_VALID_CATS does not reference any database object
INV.MTL_CATEGORY_SET_VALID_CATS is referenced by following:
Description: | Cycle Count Entries Interface data |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_CC_ENTRIES_INTERFACE.ADJUSTMENT_ACCOUNT_ID | GL_CODE_COMBINATIONS |
MTL_CC_ENTRIES_INTERFACE.CYCLE_COUNT_ENTRY_ID | MTL_CYCLE_COUNT_ENTRIES |
MTL_CC_ENTRIES_INTERFACE.CYCLE_COUNT_HEADER_ID | MTL_CYCLE_COUNT_HEADERS |
MTL_CC_ENTRIES_INTERFACE.LOCATOR_ID
MTL_CC_ENTRIES_INTERFACE.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_CC_ENTRIES_INTERFACE.INVENTORY_ITEM_ID
MTL_CC_ENTRIES_INTERFACE.ORGANIZATION_ID MTL_CC_ENTRIES_INTERFACE.REVISION |
MTL_ITEM_REVISIONS_B |
MTL_CC_ENTRIES_INTERFACE.INVENTORY_ITEM_ID
MTL_CC_ENTRIES_INTERFACE.ORGANIZATION_ID MTL_CC_ENTRIES_INTERFACE.LOT_NUMBER |
MTL_LOT_NUMBERS |
MTL_CC_ENTRIES_INTERFACE.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_CC_ENTRIES_INTERFACE.SUBINVENTORY
MTL_CC_ENTRIES_INTERFACE.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_CC_ENTRIES_INTERFACE.INVENTORY_ITEM_ID
MTL_CC_ENTRIES_INTERFACE.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_CC_ENTRIES_INTERFACE.TRANSACTION_REASON_ID | MTL_TRANSACTION_REASONS |
Foreign Key Column | Foreign Table |
---|---|
MTL_CC_INTERFACE_ERRORS.CC_ENTRY_INTERFACE_ID | MTL_CC_ENTRIES_INTERFACE |
INV.MTL_CC_ENTRIES_INTERFACE does not reference any database object
INV.MTL_CC_ENTRIES_INTERFACE is referenced by following:
Description: | Cycle Count Entries Interface process errors |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_CC_INTERFACE_ERRORS.CC_ENTRY_INTERFACE_ID | MTL_CC_ENTRIES_INTERFACE |
INV.MTL_CC_INTERFACE_ERRORS does not reference any database object
INV.MTL_CC_INTERFACE_ERRORS is referenced by following:
Description: | Defines cycle count schedule requests |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_CC_SCHEDULE_REQUESTS.CYCLE_COUNT_HEADER_ID | MTL_CYCLE_COUNT_HEADERS |
MTL_CC_SCHEDULE_REQUESTS.CYCLE_COUNT_HEADER_ID
MTL_CC_SCHEDULE_REQUESTS.INVENTORY_ITEM_ID |
MTL_CYCLE_COUNT_ITEMS |
Foreign Key Column | Foreign Table |
---|---|
MTL_CC_SCHED_COUNT_XREFS.CYCLE_COUNT_SCHEDULE_ID | MTL_CC_SCHEDULE_REQUESTS |
INV.MTL_CC_SCHEDULE_REQUESTS does not reference any database object
INV.MTL_CC_SCHEDULE_REQUESTS is referenced by following:
Description: | Cross references count entry requests |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_CC_SCHED_COUNT_XREFS.CYCLE_COUNT_SCHEDULE_ID | MTL_CC_SCHEDULE_REQUESTS |
MTL_CC_SCHED_COUNT_XREFS.CYCLE_COUNT_ENTRY_ID | MTL_CYCLE_COUNT_ENTRIES |
INV.MTL_CC_SCHED_COUNT_XREFS does not reference any database object
INV.MTL_CC_SCHED_COUNT_XREFS is referenced by following:
Description: | Serial Numbers for Cycle Count Entries. |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_CC_SERIAL_NUMBERS.CYCLE_COUNT_ENTRY_ID | MTL_CYCLE_COUNT_ENTRIES |
INV.MTL_CC_SERIAL_NUMBERS does not reference any database object
INV.MTL_CC_SERIAL_NUMBERS is referenced by following:
Description: | Defines subinventories to be used in subinventory level cycle count |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_CC_SUBINVENTORIES.CYCLE_COUNT_HEADER_ID | MTL_CYCLE_COUNT_HEADERS |
INV.MTL_CC_SUBINVENTORIES does not reference any database object
INV.MTL_CC_SUBINVENTORIES is referenced by following:
Description: | Child Lot Number Sequences |
---|
INV.MTL_CHILD_LOT_NUMBERS does not reference any database object
INV.MTL_CHILD_LOT_NUMBERS is referenced by following:
Description: | Customer Items Interface |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_CI_INTERFACE.CUSTOMER_ID | RA_CUSTOMERS |
MTL_CI_INTERFACE.ADDRESS_ID | RA_ADDRESSES_ALL |
MTL_CI_INTERFACE.CONTAINER_ITEM_ORG_ID | MTL_PARAMETERS |
MTL_CI_INTERFACE.COMMODITY_CODE_ID | MTL_COMMODITY_CODES |
MTL_CI_INTERFACE.MODEL_CUSTOMER_ITEM_ID | MTL_CUSTOMER_ITEMS |
INV.MTL_CI_INTERFACE does not reference any database object
INV.MTL_CI_INTERFACE is referenced by following:
Description: | Customer Items Cross References Interface |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_CI_XREFS_INTERFACE.CUSTOMER_ITEM_ID | MTL_CUSTOMER_ITEMS |
MTL_CI_XREFS_INTERFACE.MASTER_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_CI_XREFS_INTERFACE.CUSTOMER_ID | RA_CUSTOMERS |
MTL_CI_XREFS_INTERFACE.ADDRESS_ID | RA_ADDRESSES_ALL |
INV.MTL_CI_XREFS_INTERFACE does not reference any database object
INV.MTL_CI_XREFS_INTERFACE is referenced by following:
Description: | Client Parameters table |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_CLIENT_PARAMETERS.CLIENT_ID | HZ_CUST_ACCOUNTS |
MTL_CLIENT_PARAMETERS.TRADING_PARTNER_SITE_ID | HZ_PARTY_SITES |
MTL_CLIENT_PARAMETERS.SHIP_CONFIRM_RULE_ID | WSH_SHIP_CONFIRM_RULES |
MTL_CLIENT_PARAMETERS.DELIVERY_REPORT_SET_ID | WSH_REPORT_SETS |
Foreign Key Column | Foreign Table |
---|---|
MTL_3PL_LOCATOR_OCCUPANCY.CLIENT_CODE | MTL_CLIENT_PARAMETERS |
MTL_BILLING_RULE_LINES.CLIENT_CODE | MTL_CLIENT_PARAMETERS |
INV.MTL_CLIENT_PARAMETERS does not reference any database object
INV.MTL_CLIENT_PARAMETERS is referenced by following:
Description: |
---|
INV.MTL_COGS_RECOGNITION_TEMP does not reference any database object
INV.MTL_COGS_RECOGNITION_TEMP is referenced by following:
Description: | Customer item commodity codes |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_CI_INTERFACE.COMMODITY_CODE_ID | MTL_COMMODITY_CODES |
MTL_CUSTOMER_ITEMS.COMMODITY_CODE_ID | MTL_COMMODITY_CODES |
INV.MTL_COMMODITY_CODES does not reference any database object
INV.MTL_COMMODITY_CODES is referenced by following:
Description: | This table contains the results of the Consigned inventory diagnostics concurrent program. |
---|
INV.MTL_CONSIGNED_DIAG_ERRORS does not reference any database object
INV.MTL_CONSIGNED_DIAG_ERRORS is referenced by following:
Description: | This table stores set up records for consumption rules of consigned inventory |
---|
INV.MTL_CONSUMPTION_DEFINITION does not reference any database object
INV.MTL_CONSUMPTION_DEFINITION is referenced by following:
Description: | MTL_CONSUMPTION_TRANSACTIONS contains information related to the change of ownership transactions that have occurred to your consigned inventory. The table is used by the "Create Consumption Advice" concurrent program. Each consumption adv |
---|
INV.MTL_CONSUMPTION_TRANSACTIONS does not reference any database object
INV.MTL_CONSUMPTION_TRANSACTIONS is referenced by following:
Description: |
---|
INV.MTL_CONSUMPTION_TXN_TEMP does not reference any database object
INV.MTL_CONSUMPTION_TXN_TEMP is referenced by following:
Description: | Interface Table for the Copy Inventory Organizations Concurrent Program. The GROUP_CODE column is used in Copy Inventory Organizations Standard Concurrent Request to identify a set of rows that describe the organizations to be generated by |
---|
INV.MTL_COPY_ORG_INTERFACE does not reference any database object
INV.MTL_COPY_ORG_INTERFACE is referenced by following:
Description: | This private table contains temporary data to construct a Copy Inventory Organization Report. It is populated by a java session and read by Oracle Reports during a single concurrent request; it will only contain data while the request is ru |
---|
INV.MTL_COPY_ORG_REPORT does not reference any database object
INV.MTL_COPY_ORG_REPORT is referenced by following:
Description: | stores information concerning the assignment of countries to economic zones. |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_COUNTRY_ASSIGNMENTS.ZONE_CODE | MTL_ECONOMIC_ZONES_B |
MTL_COUNTRY_ASSIGNMENTS.TERRITORY_CODE | FND_TERRITORIES |
INV.MTL_COUNTRY_ASSIGNMENTS does not reference any database object
INV.MTL_COUNTRY_ASSIGNMENTS is referenced by following:
Description: | Assign cross references to items |
---|
INV.MTL_CROSS_REFERENCES_B does not reference any database object
INV.MTL_CROSS_REFERENCES_B is referenced by following:
Description: | (not currently used) |
---|
INV.MTL_CROSS_REFERENCES_INTERFACE does not reference any database object
INV.MTL_CROSS_REFERENCES_INTERFACE is referenced by following:
Description: | Cross Reference table storing translated Description column |
---|
INV.MTL_CROSS_REFERENCES_TL does not reference any database object
INV.MTL_CROSS_REFERENCES_TL is referenced by following:
Description: | Define cross reference types |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_CROSS_REFERENCES.CROSS_REFERENCE_TYPE | MTL_CROSS_REFERENCE_TYPES |
OE_ORDER_LINES_ALL.ITEM_IDENTIFIER_TYPE | MTL_CROSS_REFERENCE_TYPES |
INV.MTL_CROSS_REFERENCE_TYPES does not reference any database object
INV.MTL_CROSS_REFERENCE_TYPES is referenced by following:
Description: | Actual cost information by element and by level |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_CST_ACTUAL_COST_DETAILS.TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
MTL_CST_ACTUAL_COST_DETAILS.COST_ELEMENT_ID | CST_COST_ELEMENTS |
MTL_CST_ACTUAL_COST_DETAILS.INVENTORY_ITEM_ID
MTL_CST_ACTUAL_COST_DETAILS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
INV.MTL_CST_ACTUAL_COST_DETAILS does not reference any database object
INV.MTL_CST_ACTUAL_COST_DETAILS is referenced by following:
Description: | Euro as a Functional Currency Archive |
---|
INV.MTL_CST_ACTUAL_COST_DETAIL_EFC does not reference any database object
INV.MTL_CST_ACTUAL_COST_DETAIL_EFC is referenced by following:
Description: | Actual cost information by element, by level |
---|
INV.MTL_CST_LAYER_ACT_COST_DETAILS does not reference any database object
INV.MTL_CST_LAYER_ACT_COST_DETAILS is referenced by following:
Description: | The cost of a transaction by element and by level |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_CST_TXN_COST_DETAILS.TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
MTL_CST_TXN_COST_DETAILS.COST_ELEMENT_ID | CST_COST_ELEMENTS |
MTL_CST_TXN_COST_DETAILS.INVENTORY_ITEM_ID
MTL_CST_TXN_COST_DETAILS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
INV.MTL_CST_TXN_COST_DETAILS does not reference any database object
INV.MTL_CST_TXN_COST_DETAILS is referenced by following:
Description: | Euro as a Functional Currency Archive |
---|
INV.MTL_CST_TXN_COST_DETAILS_EFC does not reference any database object
INV.MTL_CST_TXN_COST_DETAILS_EFC is referenced by following:
Description: | Customer item Information |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_CUSTOMER_ITEMS.CUSTOMER_ID | RA_CUSTOMERS |
MTL_CUSTOMER_ITEMS.ADDRESS_ID | RA_ADDRESSES_ALL |
MTL_CUSTOMER_ITEMS.MODEL_CUSTOMER_ITEM_ID | MTL_CUSTOMER_ITEMS |
MTL_CUSTOMER_ITEMS.COMMODITY_CODE_ID | MTL_COMMODITY_CODES |
MTL_CUSTOMER_ITEMS.CONTAINER_ITEM_ORG_ID | MTL_PARAMETERS |
Foreign Key Column | Foreign Table |
---|---|
MTL_CI_INTERFACE.MODEL_CUSTOMER_ITEM_ID | MTL_CUSTOMER_ITEMS |
MTL_CI_XREFS_INTERFACE.CUSTOMER_ITEM_ID | MTL_CUSTOMER_ITEMS |
MTL_CUSTOMER_ITEMS.MODEL_CUSTOMER_ITEM_ID | MTL_CUSTOMER_ITEMS |
MTL_CUSTOMER_ITEM_XREFS.CUSTOMER_ITEM_ID | MTL_CUSTOMER_ITEMS |
OE_ORDER_LINES_ALL.ORDERED_ITEM_ID | MTL_CUSTOMER_ITEMS |
INV.MTL_CUSTOMER_ITEMS does not reference any database object
INV.MTL_CUSTOMER_ITEMS is referenced by following:
Description: | Relationships between customer items and inventory items |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_CUSTOMER_ITEM_XREFS.MASTER_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_CUSTOMER_ITEM_XREFS.INVENTORY_ITEM_ID
MTL_CUSTOMER_ITEM_XREFS.MASTER_ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_CUSTOMER_ITEM_XREFS.CUSTOMER_ITEM_ID | MTL_CUSTOMER_ITEMS |
INV.MTL_CUSTOMER_ITEM_XREFS does not reference any database object
INV.MTL_CUSTOMER_ITEM_XREFS is referenced by following:
Description: | Defines cycle count classes |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_CYCLE_COUNT_CLASSES.ABC_CLASS_ID | MTL_ABC_CLASSES |
MTL_CYCLE_COUNT_CLASSES.CYCLE_COUNT_HEADER_ID | MTL_CYCLE_COUNT_HEADERS |
MTL_CYCLE_COUNT_CLASSES.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_CYCLE_COUNT_CLASSES.ABC_ASSIGNMENT_GROUP_ID | MTL_ABC_ASSIGNMENT_GROUPS |
Foreign Key Column | Foreign Table |
---|---|
MTL_CYCLE_COUNT_ITEMS.ABC_CLASS_ID
MTL_CYCLE_COUNT_ITEMS.CYCLE_COUNT_HEADER_ID |
MTL_CYCLE_COUNT_CLASSES |
INV.MTL_CYCLE_COUNT_CLASSES does not reference any database object
INV.MTL_CYCLE_COUNT_CLASSES is referenced by following:
Description: | Euro as a Functional Currency Archive |
---|
INV.MTL_CYCLE_COUNT_CLASSES_EFC does not reference any database object
INV.MTL_CYCLE_COUNT_CLASSES_EFC is referenced by following:
Description: | Defines cycle count entries |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_CYCLE_COUNT_ENTRIES.INVENTORY_ITEM_ID
MTL_CYCLE_COUNT_ENTRIES.ORGANIZATION_ID MTL_CYCLE_COUNT_ENTRIES.REVISION |
MTL_ITEM_REVISIONS_B |
MTL_CYCLE_COUNT_ENTRIES.INVENTORY_ITEM_ID
MTL_CYCLE_COUNT_ENTRIES.ORGANIZATION_ID MTL_CYCLE_COUNT_ENTRIES.LOT_NUMBER |
MTL_LOT_NUMBERS |
MTL_CYCLE_COUNT_ENTRIES.TRANSACTION_REASON_ID | MTL_TRANSACTION_REASONS |
MTL_CYCLE_COUNT_ENTRIES.COST_GROUP_ID | CST_COST_GROUPS |
MTL_CYCLE_COUNT_ENTRIES.PARENT_LPN_ID | WMS_LICENSE_PLATE_NUMBERS |
MTL_CYCLE_COUNT_ENTRIES.OUTERMOST_LPN_ID | WMS_LICENSE_PLATE_NUMBERS |
MTL_CYCLE_COUNT_ENTRIES.INVENTORY_ITEM_ID
MTL_CYCLE_COUNT_ENTRIES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_CYCLE_COUNT_ENTRIES.SUBINVENTORY
MTL_CYCLE_COUNT_ENTRIES.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_CYCLE_COUNT_ENTRIES.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_CYCLE_COUNT_ENTRIES.CYCLE_COUNT_HEADER_ID | MTL_CYCLE_COUNT_HEADERS |
MTL_CYCLE_COUNT_ENTRIES.LOCATOR_ID
MTL_CYCLE_COUNT_ENTRIES.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_CYCLE_COUNT_ENTRIES.INVENTORY_ADJUSTMENT_ACCOUNT | GL_CODE_COMBINATIONS |
Foreign Key Column | Foreign Table |
---|---|
MTL_CC_ENTRIES_INTERFACE.CYCLE_COUNT_ENTRY_ID | MTL_CYCLE_COUNT_ENTRIES |
MTL_CC_SCHED_COUNT_XREFS.CYCLE_COUNT_ENTRY_ID | MTL_CYCLE_COUNT_ENTRIES |
MTL_CC_SERIAL_NUMBERS.CYCLE_COUNT_ENTRY_ID | MTL_CYCLE_COUNT_ENTRIES |
MTL_MATERIAL_TRANSACTIONS.CYCLE_COUNT_ID | MTL_CYCLE_COUNT_ENTRIES |
INV.MTL_CYCLE_COUNT_ENTRIES does not reference any database object
INV.MTL_CYCLE_COUNT_ENTRIES is referenced by following:
Description: | Euro as a Functional Currency Archive |
---|
INV.MTL_CYCLE_COUNT_ENTRIES_EFC does not reference any database object
INV.MTL_CYCLE_COUNT_ENTRIES_EFC is referenced by following:
Description: | Defines cycle count header information |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_CYCLE_COUNT_HEADERS.CALENDAR_EXCEPTION_SET | BOM_EXCEPTION_SETS |
MTL_CYCLE_COUNT_HEADERS.ABC_ASSIGNMENT_GROUP_ID | MTL_ABC_ASSIGNMENT_GROUPS |
MTL_CYCLE_COUNT_HEADERS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_CYCLE_COUNT_HEADERS.INVENTORY_ADJUSTMENT_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_CYCLE_COUNT_HEADERS.CYCLE_COUNT_CALENDAR | BOM_CALENDARS |
Foreign Key Column | Foreign Table |
---|---|
MTL_CC_ENTRIES_INTERFACE.CYCLE_COUNT_HEADER_ID | MTL_CYCLE_COUNT_HEADERS |
MTL_CC_SCHEDULE_REQUESTS.CYCLE_COUNT_HEADER_ID | MTL_CYCLE_COUNT_HEADERS |
MTL_CC_SUBINVENTORIES.CYCLE_COUNT_HEADER_ID | MTL_CYCLE_COUNT_HEADERS |
MTL_CYCLE_COUNT_CLASSES.CYCLE_COUNT_HEADER_ID | MTL_CYCLE_COUNT_HEADERS |
MTL_CYCLE_COUNT_ENTRIES.CYCLE_COUNT_HEADER_ID | MTL_CYCLE_COUNT_HEADERS |
MTL_CYCLE_COUNT_ITEMS.CYCLE_COUNT_HEADER_ID | MTL_CYCLE_COUNT_HEADERS |
INV.MTL_CYCLE_COUNT_HEADERS does not reference any database object
INV.MTL_CYCLE_COUNT_HEADERS is referenced by following:
Description: | Euro as a Functional Currency Archive |
---|
INV.MTL_CYCLE_COUNT_HEADERS_EFC does not reference any database object
INV.MTL_CYCLE_COUNT_HEADERS_EFC is referenced by following:
Description: | Defines items to be used in cycle count |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_CYCLE_COUNT_ITEMS.CYCLE_COUNT_HEADER_ID | MTL_CYCLE_COUNT_HEADERS |
MTL_CYCLE_COUNT_ITEMS.ABC_CLASS_ID | MTL_ABC_CLASSES |
MTL_CYCLE_COUNT_ITEMS.ABC_CLASS_ID
MTL_CYCLE_COUNT_ITEMS.CYCLE_COUNT_HEADER_ID |
MTL_CYCLE_COUNT_CLASSES |
Foreign Key Column | Foreign Table |
---|---|
MTL_CC_SCHEDULE_REQUESTS.CYCLE_COUNT_HEADER_ID
MTL_CC_SCHEDULE_REQUESTS.INVENTORY_ITEM_ID |
MTL_CYCLE_COUNT_ITEMS |
INV.MTL_CYCLE_COUNT_ITEMS does not reference any database object
INV.MTL_CYCLE_COUNT_ITEMS is referenced by following:
Description: | Default category set for a particular functional area |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_DEFAULT_CATEGORY_SETS.CATEGORY_SET_ID | MTL_CATEGORY_SETS_B |
INV.MTL_DEFAULT_CATEGORY_SETS does not reference any database object
INV.MTL_DEFAULT_CATEGORY_SETS is referenced by following:
Description: | Sales order demand and reservations |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_DEMAND.INVENTORY_ITEM_ID
MTL_DEMAND.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_DEMAND.DEMAND_SOURCE_HEADER_ID | MTL_SALES_ORDERS |
MTL_DEMAND.DEMAND_SOURCE_HEADER_ID | GL_CODE_COMBINATIONS |
MTL_DEMAND.DEMAND_SOURCE_HEADER_ID
MTL_DEMAND.ORGANIZATION_ID |
MTL_GENERIC_DISPOSITIONS |
MTL_DEMAND.LOCATOR_ID
MTL_DEMAND.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_DEMAND.COMPONENT_SEQUENCE_ID | BOM_COMPONENTS_B |
MTL_DEMAND.SUBINVENTORY
MTL_DEMAND.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_DEMAND.INVENTORY_ITEM_ID
MTL_DEMAND.ORGANIZATION_ID MTL_DEMAND.LOT_NUMBER |
MTL_LOT_NUMBERS |
MTL_DEMAND.INVENTORY_ITEM_ID
MTL_DEMAND.ORGANIZATION_ID MTL_DEMAND.REVISION |
MTL_ITEM_REVISIONS_B |
MTL_DEMAND.DUPLICATED_CONFIG_ITEM_ID
MTL_DEMAND.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_DEMAND.DEMAND_SOURCE_TYPE | MTL_TXN_SOURCE_TYPES |
Foreign Key Column | Foreign Table |
---|---|
MRP_RELIEF_INTERFACE.DISPOSITION_ID | MTL_DEMAND |
MRP_SALES_ORDER_UPDATES.SALES_ORDER_ID | MTL_DEMAND |
MTL_DEMAND_INTERFACE.DEMAND_ID | MTL_DEMAND |
INV.MTL_DEMAND does not reference any database object
INV.MTL_DEMAND is referenced by following:
Description: | Sales order demand and reservations |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_DEMAND_HISTORIES.INVENTORY_ITEM_ID
MTL_DEMAND_HISTORIES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
INV.MTL_DEMAND_HISTORIES does not reference any database object
INV.MTL_DEMAND_HISTORIES is referenced by following:
Description: | Temporary demand storage for the transaction processor |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_DEMAND_INTERFACE.INVENTORY_ITEM_ID
MTL_DEMAND_INTERFACE.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_DEMAND_INTERFACE.DEMAND_SOURCE_HEADER_ID | MTL_SALES_ORDERS |
MTL_DEMAND_INTERFACE.DEMAND_SOURCE_HEADER_ID | GL_CODE_COMBINATIONS |
MTL_DEMAND_INTERFACE.DEMAND_SOURCE_HEADER_ID
MTL_DEMAND_INTERFACE.ORGANIZATION_ID |
MTL_GENERIC_DISPOSITIONS |
MTL_DEMAND_INTERFACE.LOCATOR_ID
MTL_DEMAND_INTERFACE.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_DEMAND_INTERFACE.SUBINVENTORY
MTL_DEMAND_INTERFACE.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_DEMAND_INTERFACE.INVENTORY_ITEM_ID
MTL_DEMAND_INTERFACE.ORGANIZATION_ID MTL_DEMAND_INTERFACE.LOT_NUMBER |
MTL_LOT_NUMBERS |
MTL_DEMAND_INTERFACE.INVENTORY_ITEM_ID
MTL_DEMAND_INTERFACE.ORGANIZATION_ID MTL_DEMAND_INTERFACE.REVISION |
MTL_ITEM_REVISIONS_B |
MTL_DEMAND_INTERFACE.ATP_RULE_ID | MTL_ATP_RULES |
MTL_DEMAND_INTERFACE.DEMAND_ID | MTL_DEMAND |
INV.MTL_DEMAND_INTERFACE does not reference any database object
INV.MTL_DEMAND_INTERFACE is referenced by following:
Description: | Descriptive element definitions for an item catalog group |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_DESCRIPTIVE_ELEMENTS.ITEM_CATALOG_GROUP_ID | MTL_ITEM_CATALOG_GROUPS_B |
INV.MTL_DESCRIPTIVE_ELEMENTS does not reference any database object
INV.MTL_DESCRIPTIVE_ELEMENTS is referenced by following:
Description: | Stores the descriptive element values for a particular item |
---|
INV.MTL_DESCR_ELEMENT_VALUES does not reference any database object
INV.MTL_DESCR_ELEMENT_VALUES is referenced by following:
Description: | Not used currently |
---|
INV.MTL_DESC_ELEM_VAL_INTERFACE does not reference any database object
INV.MTL_DESC_ELEM_VAL_INTERFACE is referenced by following:
Description: | Table for Asset Activity Association |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_EAM_ASSET_ACTIVITIES.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_EAM_ASSET_ACTIVITIES.ASSET_ACTIVITY_ID
MTL_EAM_ASSET_ACTIVITIES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_EAM_ASSET_ACTIVITIES.SERIAL_NUMBER
MTL_EAM_ASSET_ACTIVITIES.INVENTORY_ITEM_ID MTL_EAM_ASSET_ACTIVITIES.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
MTL_EAM_ASSET_ACTIVITIES.INVENTORY_ITEM_ID
MTL_EAM_ASSET_ACTIVITIES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
Foreign Key Column | Foreign Table |
---|---|
EAM_FORECASTED_WORK_ORDERS.ACTIVITY_ASSOCIATION_ID | MTL_EAM_ASSET_ACTIVITIES |
EAM_PM_ACTIVITIES.ACTIVITY_ASSOCIATION_ID | MTL_EAM_ASSET_ACTIVITIES |
EAM_PM_LAST_SERVICE.ACTIVITY_ASSOCIATION_ID | MTL_EAM_ASSET_ACTIVITIES |
EAM_PM_SCHEDULINGS.ACTIVITY_ASSOCIATION_ID | MTL_EAM_ASSET_ACTIVITIES |
EAM_SUPPRESSION_RELATIONS.CHILD_ASSOCIATION_ID | MTL_EAM_ASSET_ACTIVITIES |
EAM_SUPPRESSION_RELATIONS.PARENT_ASSOCIATION_ID | MTL_EAM_ASSET_ACTIVITIES |
INV.MTL_EAM_ASSET_ACTIVITIES does not reference any database object
INV.MTL_EAM_ASSET_ACTIVITIES is referenced by following:
Description: | Table for asset attribute groups |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_EAM_ASSET_ATTR_GROUPS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_EAM_ASSET_ATTR_GROUPS.INVENTORY_ITEM_ID
MTL_EAM_ASSET_ATTR_GROUPS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_EAM_ASSET_ATTR_GROUPS.APPLICATION_ID
MTL_EAM_ASSET_ATTR_GROUPS.DESCRIPTIVE_FLEXFIELD_NAME MTL_EAM_ASSET_ATTR_GROUPS.DESCRIPTIVE_FLEX_CONTEXT_CODE |
FND_DESCR_FLEX_CONTEXTS |
INV.MTL_EAM_ASSET_ATTR_GROUPS does not reference any database object
INV.MTL_EAM_ASSET_ATTR_GROUPS is referenced by following:
Description: | Table for asset attribute values |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_EAM_ASSET_ATTR_VALUES.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_EAM_ASSET_ATTR_VALUES.SERIAL_NUMBER
MTL_EAM_ASSET_ATTR_VALUES.INVENTORY_ITEM_ID MTL_EAM_ASSET_ATTR_VALUES.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
INV.MTL_EAM_ASSET_ATTR_VALUES does not reference any database object
INV.MTL_EAM_ASSET_ATTR_VALUES is referenced by following:
Description: | Asset Number Interface table |
---|
INV.MTL_EAM_ASSET_NUM_INTERFACE does not reference any database object
INV.MTL_EAM_ASSET_NUM_INTERFACE is referenced by following:
Description: | Temporary table for Asset Search |
---|
INV.MTL_EAM_ASSET_SEARCH_TEMP does not reference any database object
INV.MTL_EAM_ASSET_SEARCH_TEMP is referenced by following:
Description: | Asset Attribute Interface table |
---|
INV.MTL_EAM_ATTR_VAL_INTERFACE does not reference any database object
INV.MTL_EAM_ATTR_VAL_INTERFACE is referenced by following:
Description: | Table for EAM area |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_EAM_LOCATIONS.ORGANIZATION_ID | MTL_PARAMETERS |
INV.MTL_EAM_LOCATIONS does not reference any database object
INV.MTL_EAM_LOCATIONS is referenced by following:
Description: | Table for association of assets to asset route. |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_EAM_NETWORK_ASSETS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_EAM_NETWORK_ASSETS.NETWORK_SERIAL_NUMBER
MTL_EAM_NETWORK_ASSETS.NETWORK_ITEM_ID MTL_EAM_NETWORK_ASSETS.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
MTL_EAM_NETWORK_ASSETS.SERIAL_NUMBER
MTL_EAM_NETWORK_ASSETS.INVENTORY_ITEM_ID MTL_EAM_NETWORK_ASSETS.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
INV.MTL_EAM_NETWORK_ASSETS does not reference any database object
INV.MTL_EAM_NETWORK_ASSETS is referenced by following:
Description: | Stores information concerning all the economic zones. |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_COUNTRY_ASSIGNMENTS.ZONE_CODE | MTL_ECONOMIC_ZONES_B |
MTL_ECONOMIC_ZONES_TL.ZONE_CODE | MTL_ECONOMIC_ZONES_B |
MTL_LE_ECONOMIC_ZONES.ZONE_CODE | MTL_ECONOMIC_ZONES_B |
MTL_STAT_TYPE_USAGES.ZONE_CODE | MTL_ECONOMIC_ZONES_B |
INV.MTL_ECONOMIC_ZONES_B does not reference any database object
INV.MTL_ECONOMIC_ZONES_B is referenced by following:
Description: | Corresponding transalation table for MTL_ECONOMIC_ZONES_B. |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_ECONOMIC_ZONES_TL.ZONE_CODE | MTL_ECONOMIC_ZONES_B |
INV.MTL_ECONOMIC_ZONES_TL does not reference any database object
INV.MTL_ECONOMIC_ZONES_TL is referenced by following:
Description: |
---|
INV.MTL_ERES_TRANSACTIONS_GTMP does not reference any database object
INV.MTL_ERES_TRANSACTIONS_GTMP is referenced by following:
Description: | External component information of an inventory item |
---|
INV.MTL_EXT_OBJECTS does not reference any database object
INV.MTL_EXT_OBJECTS is referenced by following:
Description: | Category account definitions for legal entity |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_FISCAL_CAT_ACCOUNTS.LEGAL_ENTITY_ID | HR_ALL_ORGANIZATION_UNITS |
MTL_FISCAL_CAT_ACCOUNTS.EXPENSE_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_FISCAL_CAT_ACCOUNTS.BRIDGING_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_FISCAL_CAT_ACCOUNTS.COST_TYPE_ID | CST_COST_TYPES |
MTL_FISCAL_CAT_ACCOUNTS.COST_GROUP_ID | CST_COST_GROUPS |
MTL_FISCAL_CAT_ACCOUNTS.CATEGORY_ID | MTL_CATEGORIES_B |
MTL_FISCAL_CAT_ACCOUNTS.MATERIAL_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_FISCAL_CAT_ACCOUNTS.MATERIAL_OVERHEAD_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_FISCAL_CAT_ACCOUNTS.RESOURCE_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_FISCAL_CAT_ACCOUNTS.OVERHEAD_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_FISCAL_CAT_ACCOUNTS.OUTSIDE_PROCESSING_ACCOUNT | GL_CODE_COMBINATIONS |
INV.MTL_FISCAL_CAT_ACCOUNTS does not reference any database object
INV.MTL_FISCAL_CAT_ACCOUNTS is referenced by following:
Description: | Context mapping table for Lot & Serial attributes Descriptive Flex Fields. |
---|
INV.MTL_FLEX_CONTEXT does not reference any database object
INV.MTL_FLEX_CONTEXT is referenced by following:
Description: | Forecast rules for forecast processes |
---|
Foreign Key Column | Foreign Table |
---|---|
MRP_FORECAST_DATES.FORECAST_RULE_ID | MTL_FORECAST_RULES |
MTL_SEASONALITY_INDICES.FORECAST_RULE_ID | MTL_FORECAST_RULES |
INV.MTL_FORECAST_RULES does not reference any database object
INV.MTL_FORECAST_RULES is referenced by following:
Description: | Account alias definition |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_GENERIC_DISPOSITIONS.DISTRIBUTION_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_GENERIC_DISPOSITIONS.ORGANIZATION_ID | MTL_PARAMETERS |
Foreign Key Column | Foreign Table |
---|---|
MTL_DEMAND.DEMAND_SOURCE_HEADER_ID
MTL_DEMAND.ORGANIZATION_ID |
MTL_GENERIC_DISPOSITIONS |
MTL_DEMAND_INTERFACE.DEMAND_SOURCE_HEADER_ID
MTL_DEMAND_INTERFACE.ORGANIZATION_ID |
MTL_GENERIC_DISPOSITIONS |
MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_TYPE_ID
MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID |
MTL_GENERIC_DISPOSITIONS |
MTL_USER_SUPPLY.SOURCE_ID
MTL_USER_SUPPLY.ORGANIZATION_ID |
MTL_GENERIC_DISPOSITIONS |
INV.MTL_GENERIC_DISPOSITIONS does not reference any database object
INV.MTL_GENERIC_DISPOSITIONS is referenced by following:
Description: |
---|
INV.MTL_GEN_TEMP does not reference any database object
INV.MTL_GEN_TEMP is referenced by following:
Description: | Grade Codes |
---|
INV.MTL_GRADES_B does not reference any database object
INV.MTL_GRADES_B is referenced by following:
Description: | Grade Codes Language Translation |
---|
INV.MTL_GRADES_TL does not reference any database object
INV.MTL_GRADES_TL is referenced by following:
Description: |
---|
INV.MTL_GRADE_STATUS_ERES_GTMP does not reference any database object
INV.MTL_GRADE_STATUS_ERES_GTMP is referenced by following:
Description: | Recommended item aliases for items in an item catalog group |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_ICG_ALIASES.ITEM_CATALOG_GROUP_ID | MTL_ITEM_CATALOG_GROUPS_B |
INV.MTL_ICG_ALIASES does not reference any database object
INV.MTL_ICG_ALIASES is referenced by following:
Description: | Recommended item categories for items in an item catalog group |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_ICG_CATEGORIES.ITEM_CATALOG_GROUP_ID | MTL_ITEM_CATALOG_GROUPS_B |
MTL_ICG_CATEGORIES.CATEGORY_ID | MTL_CATEGORIES_B |
MTL_ICG_CATEGORIES.CATEGORY_SET_ID | MTL_CATEGORY_SETS_B |
INV.MTL_ICG_CATEGORIES does not reference any database object
INV.MTL_ICG_CATEGORIES is referenced by following:
Description: | Inter-company relationships |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_INTERCOMPANY_PARAMETERS.VENDOR_ID | PO_VENDORS |
MTL_INTERCOMPANY_PARAMETERS.VENDOR_SITE_ID | PO_VENDOR_SITES_ALL |
MTL_INTERCOMPANY_PARAMETERS.CUSTOMER_ID | RA_CUSTOMERS |
MTL_INTERCOMPANY_PARAMETERS.ADDRESS_ID | RA_ADDRESSES_ALL |
MTL_INTERCOMPANY_PARAMETERS.CUSTOMER_SITE_ID | RA_SITE_USES_ALL |
MTL_INTERCOMPANY_PARAMETERS.CUST_TRX_TYPE_ID | RA_CUST_TRX_TYPES_ALL |
INV.MTL_INTERCOMPANY_PARAMETERS does not reference any database object
INV.MTL_INTERCOMPANY_PARAMETERS is referenced by following:
Description: | Item open interface errors |
---|
INV.MTL_INTERFACE_ERRORS does not reference any database object
INV.MTL_INTERFACE_ERRORS is referenced by following:
Description: | Interface Processes Control Parameters |
---|
INV.MTL_INTERFACE_PROC_CONTROLS does not reference any database object
INV.MTL_INTERFACE_PROC_CONTROLS is referenced by following:
Description: | Inter-organization relationships |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_INTERORG_PARAMETERS.FROM_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_INTERORG_PARAMETERS.TO_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_INTERORG_PARAMETERS.INTERORG_TRANSFER_CR_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_INTERORG_PARAMETERS.INTERORG_PRICE_VAR_ACCOUNT | GL_CODE_COMBINATIONS |
Foreign Key Column | Foreign Table |
---|---|
FLM_KANBAN_SUMMARY.SOURCE_ORGANIZATION_ID
FLM_KANBAN_SUMMARY.ORGANIZATION_ID |
MTL_INTERORG_PARAMETERS |
MTL_KANBAN_CARDS.SOURCE_ORGANIZATION_ID
MTL_KANBAN_CARDS.ORGANIZATION_ID |
MTL_INTERORG_PARAMETERS |
MTL_KANBAN_PULL_SEQUENCES.SOURCE_ORGANIZATION_ID
MTL_KANBAN_PULL_SEQUENCES.ORGANIZATION_ID |
MTL_INTERORG_PARAMETERS |
MTL_SUPPLY.FROM_ORGANIZATION_ID
MTL_SUPPLY.TO_ORGANIZATION_ID |
MTL_INTERORG_PARAMETERS |
INV.MTL_INTERORG_PARAMETERS does not reference any database object
INV.MTL_INTERORG_PARAMETERS is referenced by following:
Description: | Relationships between shipping networks and shipment methods |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_INTERORG_SHIP_METHODS.FROM_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_INTERORG_SHIP_METHODS.TO_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_INTERORG_SHIP_METHODS.FROM_LOCATION_ID | HR_LOCATIONS_ALL |
MTL_INTERORG_SHIP_METHODS.TO_LOCATION_ID | HR_LOCATIONS_ALL |
MTL_INTERORG_SHIP_METHODS.CURRENCY_CODE | FND_CURRENCIES |
INV.MTL_INTERORG_SHIP_METHODS does not reference any database object
INV.MTL_INTERORG_SHIP_METHODS is referenced by following:
Description: | Inventory Packing slip documents. |
---|
INV.MTL_INV_PACKSLIPS does not reference any database object
INV.MTL_INV_PACKSLIPS is referenced by following:
Description: | Inventory Picking rules |
---|
INV.MTL_INV_PICKING_RULES does not reference any database object
INV.MTL_INV_PICKING_RULES is referenced by following:
Description: | Item attributes table |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_ATTR_APPL_DEPENDENCIES.ATTRIBUTE_NAME | MTL_ITEM_ATTRIBUTES |
MTL_ITEM_TEMPL_ATTRIBUTES.ATTRIBUTE_NAME | MTL_ITEM_ATTRIBUTES |
MTL_STATUS_ATTRIBUTE_VALUES.ATTRIBUTE_NAME | MTL_ITEM_ATTRIBUTES |
INV.MTL_ITEM_ATTRIBUTES does not reference any database object
INV.MTL_ITEM_ATTRIBUTES is referenced by following:
Description: | MTL_ITEM_ATTRIBUTES_SEED_INFO contains the seed attributes information to be used specifically in the copy item attributes user interface module. |
---|
INV.MTL_ITEM_ATTRIBUTES_SEED_INFO does not reference any database object
INV.MTL_ITEM_ATTRIBUTES_SEED_INFO is referenced by following:
Description: |
---|
INV.MTL_ITEM_ATTRIBUTES_TEMP does not reference any database object
INV.MTL_ITEM_ATTRIBUTES_TEMP is referenced by following:
Description: | Item Bulkloaded Records |
---|
INV.MTL_ITEM_BULKLOAD_RECS does not reference any database object
INV.MTL_ITEM_BULKLOAD_RECS is referenced by following:
Description: | Item Catalog Groups |
---|
Foreign Key Column | Foreign Table |
---|---|
BOM_STRUCTURE_TYPES_B.ITEM_CATALOG_GROUP_ID | MTL_ITEM_CATALOG_GROUPS_B |
MTL_DESCRIPTIVE_ELEMENTS.ITEM_CATALOG_GROUP_ID | MTL_ITEM_CATALOG_GROUPS_B |
MTL_ICG_ALIASES.ITEM_CATALOG_GROUP_ID | MTL_ITEM_CATALOG_GROUPS_B |
MTL_ICG_CATEGORIES.ITEM_CATALOG_GROUP_ID | MTL_ITEM_CATALOG_GROUPS_B |
MTL_ITEM_CATALOG_GROUPS_TL.ITEM_CATALOG_GROUP_ID | MTL_ITEM_CATALOG_GROUPS_B |
MTL_SYSTEM_ITEMS_B.ITEM_CATALOG_GROUP_ID | MTL_ITEM_CATALOG_GROUPS_B |
OKL_DF_CTGY_RMK_TMS.ICO_ID | MTL_ITEM_CATALOG_GROUPS_B |
OKL_DF_CTGY_RMK_TMS_ALL.ICO_ID | MTL_ITEM_CATALOG_GROUPS_B |
INV.MTL_ITEM_CATALOG_GROUPS_B does not reference any database object
INV.MTL_ITEM_CATALOG_GROUPS_B is referenced by following:
Description: | Item Catalog Groups table storing translated Description column |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_ITEM_CATALOG_GROUPS_TL.ITEM_CATALOG_GROUP_ID | MTL_ITEM_CATALOG_GROUPS_B |
INV.MTL_ITEM_CATALOG_GROUPS_TL does not reference any database object
INV.MTL_ITEM_CATALOG_GROUPS_TL is referenced by following:
Description: | Define item assignments to categories |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_ITEM_CATEGORIES.INVENTORY_ITEM_ID
MTL_ITEM_CATEGORIES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_ITEM_CATEGORIES.CATEGORY_SET_ID
MTL_ITEM_CATEGORIES.CATEGORY_ID |
MTL_CATEGORY_SET_VALID_CATS |
MTL_ITEM_CATEGORIES.ORGANIZATION_ID | MTL_PARAMETERS |
Foreign Key Column | Foreign Table |
---|---|
AMS_ACT_PRODUCTS.INVENTORY_ITEM_ID
AMS_ACT_PRODUCTS.ORGANIZATION_ID AMS_ACT_PRODUCTS.CATEGORY_SET_ID |
MTL_ITEM_CATEGORIES |
MRP_SR_ASSIGNMENTS.INVENTORY_ITEM_ID
MRP_SR_ASSIGNMENTS.ORGANIZATION_ID MRP_SR_ASSIGNMENTS.CATEGORY_SET_ID |
MTL_ITEM_CATEGORIES |
OKL_FE_EO_TERM_OBJECTS.INVENTORY_ITEM_ID
OKL_FE_EO_TERM_OBJECTS.ORGANIZATION_ID OKL_FE_EO_TERM_OBJECTS.CATEGORY_SET_ID |
MTL_ITEM_CATEGORIES |
OKL_FE_ITEM_RESIDUAL_ALL.INVENTORY_ITEM_ID
OKL_FE_ITEM_RESIDUAL_ALL.ORGANIZATION_ID OKL_FE_ITEM_RESIDUAL_ALL.CATEGORY_SET_ID |
MTL_ITEM_CATEGORIES |
OKL_FE_RESI_CAT_OBJECTS.INVENTORY_ITEM_ID
OKL_FE_RESI_CAT_OBJECTS.ORGANIZATION_ID OKL_FE_RESI_CAT_OBJECTS.CATEGORY_SET_ID |
MTL_ITEM_CATEGORIES |
INV.MTL_ITEM_CATEGORIES does not reference any database object
INV.MTL_ITEM_CATEGORIES is referenced by following:
Description: | Item Category Open Interface table; used to load item assignments to category sets and categories into Oracle Inventory. |
---|
INV.MTL_ITEM_CATEGORIES_INTERFACE does not reference any database object
INV.MTL_ITEM_CATEGORIES_INTERFACE is referenced by following:
Description: | Not currently used |
---|
INV.MTL_ITEM_CHILD_INFO_INTERFACE does not reference any database object
INV.MTL_ITEM_CHILD_INFO_INTERFACE is referenced by following:
Description: | Definitions for stock locators |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_ITEM_LOCATIONS.INVENTORY_ACCOUNT_ID | GL_CODE_COMBINATIONS |
MTL_ITEM_LOCATIONS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_ITEM_LOCATIONS.SUBINVENTORY_CODE
MTL_ITEM_LOCATIONS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_ITEM_LOCATIONS.STATUS_ID | MTL_MATERIAL_STATUSES_B |
Foreign Key Column | Foreign Table |
---|---|
AHL_WORKORDER_MTL_TXNS.LOCATOR_ID
AHL_WORKORDER_MTL_TXNS.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
BOM_OPERATIONAL_ROUTINGS.COMPLETION_LOCATOR_ID
BOM_OPERATIONAL_ROUTINGS.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
CSP_INV_LOC_ASSIGNMENTS.LOCATOR_ID
CSP_INV_LOC_ASSIGNMENTS.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_CC_ENTRIES_INTERFACE.LOCATOR_ID
MTL_CC_ENTRIES_INTERFACE.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_CYCLE_COUNT_ENTRIES.LOCATOR_ID
MTL_CYCLE_COUNT_ENTRIES.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_DEMAND.LOCATOR_ID
MTL_DEMAND.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_DEMAND_INTERFACE.LOCATOR_ID
MTL_DEMAND_INTERFACE.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_ITEM_LOC_DEFAULTS.LOCATOR_ID
MTL_ITEM_LOC_DEFAULTS.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_MATERIAL_STATUS_HISTORY.LOCATOR_ID
MTL_MATERIAL_STATUS_HISTORY.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_MATERIAL_TRANSACTIONS.LOCATOR_ID
MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_MATERIAL_TRANSACTIONS_TEMP.LOCATOR_ID
MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSFER_TO_LOCATION
MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSFER_ORGANIZATION |
MTL_ITEM_LOCATIONS |
MTL_ONHAND_QUANTITIES.LOCATOR_ID
MTL_ONHAND_QUANTITIES.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_ONHAND_QUANTITY_TEMP.LOCATOR_ID
MTL_ONHAND_QUANTITY_TEMP.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_PHYSICAL_INVENTORY_TAGS.LOCATOR_ID
MTL_PHYSICAL_INVENTORY_TAGS.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_REPLENISH_LINES.LOCATOR_ID
MTL_REPLENISH_LINES.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_REPLENISH_LINES_INT.LOCATOR_ID
MTL_REPLENISH_LINES_INT.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_RESERVATIONS.LOCATOR_ID
MTL_RESERVATIONS.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_RESERVATIONS_INTERFACE.LOCATOR_ID
MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_RESERVATIONS_INTERFACE.TO_LOCATOR_ID
MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_SECONDARY_LOCATORS.SECONDARY_LOCATOR
MTL_SECONDARY_LOCATORS.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_SERIAL_NUMBERS.CURRENT_LOCATOR_ID
MTL_SERIAL_NUMBERS.CURRENT_ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_SUPPLY.LOCATION_ID
MTL_SUPPLY.TO_ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_SYSTEM_ITEMS_B.WIP_SUPPLY_LOCATOR_ID
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_TRANSACTIONS_INTERFACE.LOCATOR_ID
MTL_TRANSACTIONS_INTERFACE.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_TRANSACTIONS_INTERFACE.TRANSFER_LOCATOR
MTL_TRANSACTIONS_INTERFACE.TRANSFER_ORGANIZATION |
MTL_ITEM_LOCATIONS |
MTL_UNIT_TRANSACTIONS.LOCATOR_ID
MTL_UNIT_TRANSACTIONS.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
RCV_TRANSACTIONS.LOCATOR_ID
RCV_TRANSACTIONS.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
RCV_TRANSACTIONS_INTERFACE.LOCATOR_ID
RCV_TRANSACTIONS_INTERFACE.TO_ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
WIP_DISCRETE_JOBS.COMPLETION_LOCATOR_ID
WIP_DISCRETE_JOBS.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
WIP_FLOW_SCHEDULES.COMPLETION_LOCATOR_ID
WIP_FLOW_SCHEDULES.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
WIP_PARAMETERS.DEFAULT_PULL_SUPPLY_LOCATOR_ID
WIP_PARAMETERS.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
WIP_REPETITIVE_ITEMS.COMPLETION_LOCATOR_ID
WIP_REPETITIVE_ITEMS.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
WIP_REQUIREMENT_OPERATIONS.SUPPLY_LOCATOR_ID
WIP_REQUIREMENT_OPERATIONS.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
WMS_DOCK_APPOINTMENTS_B.DOCK_ID
WMS_DOCK_APPOINTMENTS_B.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
WMS_EXCEPTIONS.INVENTORY_LOCATION_ID
WMS_EXCEPTIONS.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
WMS_LICENSE_PLATE_NUMBERS.LOCATOR_ID
WMS_LICENSE_PLATE_NUMBERS.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
WMS_LPN_HISTORIES.LOCATOR_ID
WMS_LPN_HISTORIES.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
WMS_LPN_INTERFACE.LOCATOR_ID
WMS_LPN_INTERFACE.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
WMS_SHIPPING_TRANSACTION_TEMP.DOCK_DOOR_ID
WMS_SHIPPING_TRANSACTION_TEMP.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
WMS_SKIP_TASK_EXCEPTIONS.INVENTORY_LOCATION_ID
WMS_SKIP_TASK_EXCEPTIONS.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
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 |
WSM_CO_PRODUCTS.SUPPLY_LOCATOR_ID
WSM_CO_PRODUCTS.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
WSM_LOT_JOB_INTERFACE.COMPLETION_LOCATOR_ID
WSM_LOT_JOB_INTERFACE.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
WSM_RESULTING_LOTS_INTERFACE.LOCATOR_ID
WSM_RESULTING_LOTS_INTERFACE.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
WSM_SM_RESULTING_LOTS.LOCATOR_ID
WSM_SM_RESULTING_LOTS.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
WSM_SM_STARTING_LOTS.LOCATOR_ID
WSM_SM_STARTING_LOTS.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
WSM_STARTING_LOTS_INTERFACE.LOCATOR_ID
WSM_STARTING_LOTS_INTERFACE.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
INV.MTL_ITEM_LOCATIONS does not reference any database object
INV.MTL_ITEM_LOCATIONS is referenced by following:
Description: | Inventory item receiving and shipping locator default values |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_ITEM_LOC_DEFAULTS.INVENTORY_ITEM_ID
MTL_ITEM_LOC_DEFAULTS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_ITEM_LOC_DEFAULTS.LOCATOR_ID
MTL_ITEM_LOC_DEFAULTS.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_ITEM_LOC_DEFAULTS.SUBINVENTORY_CODE
MTL_ITEM_LOC_DEFAULTS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
INV.MTL_ITEM_LOC_DEFAULTS does not reference any database object
INV.MTL_ITEM_LOC_DEFAULTS is referenced by following:
Description: | Item revisions |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_ITEM_REVISIONS_B.INVENTORY_ITEM_ID
MTL_ITEM_REVISIONS_B.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_ITEM_REVISIONS_B.CHANGE_NOTICE
MTL_ITEM_REVISIONS_B.ORGANIZATION_ID |
ENG_ENGINEERING_CHANGES |
MTL_ITEM_REVISIONS_B.ORGANIZATION_ID | MTL_PARAMETERS |
Foreign Key Column | Foreign Table |
---|---|
CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID
CSI_ITEM_INSTANCES.INV_MASTER_ORGANIZATION_ID CSI_ITEM_INSTANCES.INVENTORY_REVISION |
MTL_ITEM_REVISIONS_B |
CS_CUSTOMER_PRODUCTS_ALL.MIB_INVENTORY_ITEM_ID
CS_CUSTOMER_PRODUCTS_ALL.MIB_ORGANIZATION_ID CS_CUSTOMER_PRODUCTS_ALL.MIB_REVISION_ID |
MTL_ITEM_REVISIONS_B |
MRP_REPETITIVE_SCHEDULES.INVENTORY_ITEM_ID
MRP_REPETITIVE_SCHEDULES.ORGANIZATION_ID MRP_REPETITIVE_SCHEDULES.REVISION |
MTL_ITEM_REVISIONS_B |
MRP_RESERVATIONS.INVENTORY_ITEM_ID
MRP_RESERVATIONS.ORGANIZATION_ID MRP_RESERVATIONS.REVISION |
MTL_ITEM_REVISIONS_B |
MRP_SYSTEM_ITEMS.INVENTORY_ITEM_ID
MRP_SYSTEM_ITEMS.ORGANIZATION_ID MRP_SYSTEM_ITEMS.REVISION |
MTL_ITEM_REVISIONS_B |
MTL_CC_ENTRIES_INTERFACE.INVENTORY_ITEM_ID
MTL_CC_ENTRIES_INTERFACE.ORGANIZATION_ID MTL_CC_ENTRIES_INTERFACE.REVISION |
MTL_ITEM_REVISIONS_B |
MTL_CYCLE_COUNT_ENTRIES.INVENTORY_ITEM_ID
MTL_CYCLE_COUNT_ENTRIES.ORGANIZATION_ID MTL_CYCLE_COUNT_ENTRIES.REVISION |
MTL_ITEM_REVISIONS_B |
MTL_DEMAND.INVENTORY_ITEM_ID
MTL_DEMAND.ORGANIZATION_ID MTL_DEMAND.REVISION |
MTL_ITEM_REVISIONS_B |
MTL_DEMAND_INTERFACE.INVENTORY_ITEM_ID
MTL_DEMAND_INTERFACE.ORGANIZATION_ID MTL_DEMAND_INTERFACE.REVISION |
MTL_ITEM_REVISIONS_B |
MTL_ITEM_REVISIONS_TL.INVENTORY_ITEM_ID
MTL_ITEM_REVISIONS_TL.ORGANIZATION_ID MTL_ITEM_REVISIONS_TL.REVISION_ID |
MTL_ITEM_REVISIONS_B |
MTL_MATERIAL_TRANSACTIONS.INVENTORY_ITEM_ID
MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID MTL_MATERIAL_TRANSACTIONS.REVISION |
MTL_ITEM_REVISIONS_B |
MTL_MATERIAL_TRANSACTIONS_TEMP.INVENTORY_ITEM_ID
MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID MTL_MATERIAL_TRANSACTIONS_TEMP.REVISION |
MTL_ITEM_REVISIONS_B |
MTL_ONHAND_QUANTITIES.INVENTORY_ITEM_ID
MTL_ONHAND_QUANTITIES.ORGANIZATION_ID MTL_ONHAND_QUANTITIES.REVISION |
MTL_ITEM_REVISIONS_B |
MTL_PHYSICAL_ADJUSTMENTS.INVENTORY_ITEM_ID
MTL_PHYSICAL_ADJUSTMENTS.ORGANIZATION_ID MTL_PHYSICAL_ADJUSTMENTS.REVISION |
MTL_ITEM_REVISIONS_B |
MTL_PHYSICAL_INVENTORY_TAGS.INVENTORY_ITEM_ID
MTL_PHYSICAL_INVENTORY_TAGS.ORGANIZATION_ID MTL_PHYSICAL_INVENTORY_TAGS.REVISION |
MTL_ITEM_REVISIONS_B |
MTL_RESERVATIONS.INVENTORY_ITEM_ID
MTL_RESERVATIONS.ORGANIZATION_ID MTL_RESERVATIONS.REVISION |
MTL_ITEM_REVISIONS_B |
MTL_RESERVATIONS_INTERFACE.INVENTORY_ITEM_ID
MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID MTL_RESERVATIONS_INTERFACE.REVISION |
MTL_ITEM_REVISIONS_B |
MTL_RESERVATIONS_INTERFACE.INVENTORY_ITEM_ID
MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID MTL_RESERVATIONS_INTERFACE.TO_REVISION |
MTL_ITEM_REVISIONS_B |
MTL_SERIAL_NUMBERS.INVENTORY_ITEM_ID
MTL_SERIAL_NUMBERS.CURRENT_ORGANIZATION_ID MTL_SERIAL_NUMBERS.REVISION |
MTL_ITEM_REVISIONS_B |
MTL_SUPPLY.ITEM_ID
MTL_SUPPLY.TO_ORGANIZATION_ID MTL_SUPPLY.ITEM_REVISION |
MTL_ITEM_REVISIONS_B |
MTL_TXN_REQUEST_LINES.INVENTORY_ITEM_ID
MTL_TXN_REQUEST_LINES.ORGANIZATION_ID MTL_TXN_REQUEST_LINES.REVISION |
MTL_ITEM_REVISIONS_B |
PJM_BORROW_TRANSACTIONS.INVENTORY_ITEM_ID
PJM_BORROW_TRANSACTIONS.ORGANIZATION_ID PJM_BORROW_TRANSACTIONS.REVISION |
MTL_ITEM_REVISIONS_B |
WIP_DISCRETE_JOBS.PRIMARY_ITEM_ID
WIP_DISCRETE_JOBS.ORGANIZATION_ID WIP_DISCRETE_JOBS.BOM_REVISION |
MTL_ITEM_REVISIONS_B |
WIP_FLOW_SCHEDULES.PRIMARY_ITEM_ID
WIP_FLOW_SCHEDULES.ORGANIZATION_ID WIP_FLOW_SCHEDULES.BOM_REVISION |
MTL_ITEM_REVISIONS_B |
WMS_EXCEPTIONS.INVENTORY_ITEM_ID
WMS_EXCEPTIONS.ORGANIZATION_ID WMS_EXCEPTIONS.REVISION |
MTL_ITEM_REVISIONS_B |
WMS_LICENSE_PLATE_NUMBERS.INVENTORY_ITEM_ID
WMS_LICENSE_PLATE_NUMBERS.ORGANIZATION_ID WMS_LICENSE_PLATE_NUMBERS.REVISION |
MTL_ITEM_REVISIONS_B |
WMS_LPN_CONTENTS.INVENTORY_ITEM_ID
WMS_LPN_CONTENTS.ORGANIZATION_ID WMS_LPN_CONTENTS.REVISION |
MTL_ITEM_REVISIONS_B |
WMS_LPN_HISTORIES.INVENTORY_ITEM_ID
WMS_LPN_HISTORIES.ORGANIZATION_ID WMS_LPN_HISTORIES.REVISION |
MTL_ITEM_REVISIONS_B |
WMS_SKIP_TASK_EXCEPTIONS.INVENTORY_ITEM_ID
WMS_SKIP_TASK_EXCEPTIONS.ORGANIZATION_ID WMS_SKIP_TASK_EXCEPTIONS.REVISION |
MTL_ITEM_REVISIONS_B |
INV.MTL_ITEM_REVISIONS_B does not reference any database object
INV.MTL_ITEM_REVISIONS_B is referenced by following:
Description: | Item Revisions interface |
---|
INV.MTL_ITEM_REVISIONS_INTERFACE does not reference any database object
INV.MTL_ITEM_REVISIONS_INTERFACE is referenced by following:
Description: | Item Revisions table storing translated Description column |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_ITEM_REVISIONS_TL.INVENTORY_ITEM_ID
MTL_ITEM_REVISIONS_TL.ORGANIZATION_ID MTL_ITEM_REVISIONS_TL.REVISION_ID |
MTL_ITEM_REVISIONS_B |
INV.MTL_ITEM_REVISIONS_TL does not reference any database object
INV.MTL_ITEM_REVISIONS_TL is referenced by following:
Description: | Material status definitions |
---|
INV.MTL_ITEM_STATUS_TL does not reference any database object
INV.MTL_ITEM_STATUS_TL is referenced by following:
Description: | Inventory item receiving and shipping subinventory default values |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_ITEM_SUB_DEFAULTS.INVENTORY_ITEM_ID
MTL_ITEM_SUB_DEFAULTS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_ITEM_SUB_DEFAULTS.SUBINVENTORY_CODE
MTL_ITEM_SUB_DEFAULTS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
INV.MTL_ITEM_SUB_DEFAULTS does not reference any database object
INV.MTL_ITEM_SUB_DEFAULTS is referenced by following:
Description: | Item-subinventory assignments |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_ITEM_SUB_INVENTORIES.SECONDARY_INVENTORY
MTL_ITEM_SUB_INVENTORIES.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_ITEM_SUB_INVENTORIES.INVENTORY_ITEM_ID
MTL_ITEM_SUB_INVENTORIES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_ITEM_SUB_INVENTORIES.SOURCE_SUBINVENTORY
MTL_ITEM_SUB_INVENTORIES.SOURCE_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_ITEM_SUB_INVENTORIES.SOURCE_ORGANIZATION_ID | MTL_PARAMETERS |
Foreign Key Column | Foreign Table |
---|---|
MTL_SECONDARY_LOCATORS.INVENTORY_ITEM_ID
MTL_SECONDARY_LOCATORS.ORGANIZATION_ID MTL_SECONDARY_LOCATORS.SUBINVENTORY_CODE |
MTL_ITEM_SUB_INVENTORIES |
WIP_DISCRETE_JOBS.PRIMARY_ITEM_ID
WIP_DISCRETE_JOBS.ORGANIZATION_ID WIP_DISCRETE_JOBS.COMPLETION_SUBINVENTORY |
MTL_ITEM_SUB_INVENTORIES |
WIP_FLOW_SCHEDULES.PRIMARY_ITEM_ID
WIP_FLOW_SCHEDULES.ORGANIZATION_ID WIP_FLOW_SCHEDULES.COMPLETION_SUBINVENTORY |
MTL_ITEM_SUB_INVENTORIES |
WIP_REPETITIVE_ITEMS.PRIMARY_ITEM_ID
WIP_REPETITIVE_ITEMS.ORGANIZATION_ID WIP_REPETITIVE_ITEMS.COMPLETION_SUBINVENTORY |
MTL_ITEM_SUB_INVENTORIES |
WIP_REQUIREMENT_OPERATIONS.INVENTORY_ITEM_ID
WIP_REQUIREMENT_OPERATIONS.ORGANIZATION_ID WIP_REQUIREMENT_OPERATIONS.SUPPLY_SUBINVENTORY |
MTL_ITEM_SUB_INVENTORIES |
INV.MTL_ITEM_SUB_INVENTORIES does not reference any database object
INV.MTL_ITEM_SUB_INVENTORIES is referenced by following:
Description: | (currently not used) |
---|
INV.MTL_ITEM_SUB_INVS_INTERFACE does not reference any database object
INV.MTL_ITEM_SUB_INVS_INTERFACE is referenced by following:
Description: | Item template definitions |
---|
INV.MTL_ITEM_TEMPLATES_B does not reference any database object
INV.MTL_ITEM_TEMPLATES_B is referenced by following:
Description: | MTL_ITEM_TEMPLATES_TL is a table holding translated Template and Description columns for Templates. Templates now support multilingual description. MLS is implemented with a pair of tables: MTL_ITEM_TEMPLATES_B and MTL_ITEM_TEMPLATES_TL. Tr |
---|
INV.MTL_ITEM_TEMPLATES_TL does not reference any database object
INV.MTL_ITEM_TEMPLATES_TL is referenced by following:
Description: | Item attributes and attribute values for a template |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_ITEM_TEMPL_ATTRIBUTES.TEMPLATE_ID | MTL_ITEM_TEMPLATES |
MTL_ITEM_TEMPL_ATTRIBUTES.ATTRIBUTE_NAME | MTL_ITEM_ATTRIBUTES |
INV.MTL_ITEM_TEMPL_ATTRIBUTES does not reference any database object
INV.MTL_ITEM_TEMPL_ATTRIBUTES is referenced by following:
Description: | Holds Item Attributes and their values. Used in the Item Attributes Copyform. |
---|
INV.MTL_ITEM_VALUES_TEMP does not reference any database object
INV.MTL_ITEM_VALUES_TEMP is referenced by following:
Description: | Kanban Cards |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_KANBAN_CARDS.INVENTORY_ITEM_ID
MTL_KANBAN_CARDS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_KANBAN_CARDS.WIP_LINE_ID | WIP_LINES |
MTL_KANBAN_CARDS.PULL_SEQUENCE_ID | MTL_KANBAN_PULL_SEQUENCES |
MTL_KANBAN_CARDS.SUBINVENTORY_NAME
MTL_KANBAN_CARDS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_KANBAN_CARDS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_KANBAN_CARDS.SOURCE_ORGANIZATION_ID
MTL_KANBAN_CARDS.ORGANIZATION_ID |
MTL_INTERORG_PARAMETERS |
MTL_KANBAN_CARDS.SOURCE_SUBINVENTORY
MTL_KANBAN_CARDS.SOURCE_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_KANBAN_CARDS.SUPPLIER_ID | PO_VENDORS |
MTL_KANBAN_CARDS.SUPPLIER_SITE_ID | PO_VENDOR_SITES_ALL |
Foreign Key Column | Foreign Table |
---|---|
MTL_KANBAN_CARD_ACTIVITY.KANBAN_CARD_ID | MTL_KANBAN_CARDS |
MTL_TXN_REQUEST_LINES.REFERENCE_ID | MTL_KANBAN_CARDS |
PO_REQUISITIONS_INTERFACE_ALL.KANBAN_CARD_ID | MTL_KANBAN_CARDS |
WIP_DISCRETE_JOBS.KANBAN_CARD_ID | MTL_KANBAN_CARDS |
WIP_JOB_SCHEDULE_INTERFACE.KANBAN_CARD_ID | MTL_KANBAN_CARDS |
WIP_FLOW_SCHEDULES.KANBAN_CARD_ID | MTL_KANBAN_CARDS |
INV.MTL_KANBAN_CARDS does not reference any database object
INV.MTL_KANBAN_CARDS is referenced by following:
Description: | Kanban Card Activity |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_KANBAN_CARD_ACTIVITY.INVENTORY_ITEM_ID
MTL_KANBAN_CARD_ACTIVITY.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_KANBAN_CARD_ACTIVITY.SUPPLIER_SITE_ID | PO_VENDOR_SITES_ALL |
MTL_KANBAN_CARD_ACTIVITY.DOCUMENT_DETAIL_ID | PO_DISTRIBUTIONS_ALL |
MTL_KANBAN_CARD_ACTIVITY.DOCUMENT_DETAIL_ID | PO_REQUISITION_LINES_ALL |
MTL_KANBAN_CARD_ACTIVITY.DOCUMENT_HEADER_ID | PO_HEADERS_ALL |
MTL_KANBAN_CARD_ACTIVITY.DOCUMENT_HEADER_ID | PO_REQUISITION_HEADERS_ALL |
MTL_KANBAN_CARD_ACTIVITY.WIP_LINE_ID | WIP_LINES |
MTL_KANBAN_CARD_ACTIVITY.DOCUMENT_HEADER_ID | MTL_TXN_REQUEST_HEADERS |
MTL_KANBAN_CARD_ACTIVITY.DOCUMENT_HEADER_ID | WIP_ENTITIES |
MTL_KANBAN_CARD_ACTIVITY.DOCUMENT_DETAIL_ID | MTL_TXN_REQUEST_LINES |
MTL_KANBAN_CARD_ACTIVITY.SUBINVENTORY_NAME
MTL_KANBAN_CARD_ACTIVITY.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_KANBAN_CARD_ACTIVITY.KANBAN_CARD_ID | MTL_KANBAN_CARDS |
MTL_KANBAN_CARD_ACTIVITY.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_KANBAN_CARD_ACTIVITY.SOURCE_SUBINVENTORY
MTL_KANBAN_CARD_ACTIVITY.SOURCE_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_KANBAN_CARD_ACTIVITY.SUPPLIER_ID | PO_VENDORS |
INV.MTL_KANBAN_CARD_ACTIVITY does not reference any database object
INV.MTL_KANBAN_CARD_ACTIVITY is referenced by following:
Description: | Temporary table used to print kanban cards |
---|
INV.MTL_KANBAN_CARD_PRINT_TEMP does not reference any database object
INV.MTL_KANBAN_CARD_PRINT_TEMP is referenced by following:
Description: | Kanban Pull Sequences |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_KANBAN_PULL_SEQUENCES.INVENTORY_ITEM_ID
MTL_KANBAN_PULL_SEQUENCES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_KANBAN_PULL_SEQUENCES.WIP_LINE_ID | WIP_LINES |
MTL_KANBAN_PULL_SEQUENCES.SUBINVENTORY_NAME
MTL_KANBAN_PULL_SEQUENCES.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_KANBAN_PULL_SEQUENCES.SOURCE_SUBINVENTORY
MTL_KANBAN_PULL_SEQUENCES.SOURCE_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_KANBAN_PULL_SEQUENCES.SUPPLIER_SITE_ID | PO_VENDOR_SITES_ALL |
MTL_KANBAN_PULL_SEQUENCES.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_KANBAN_PULL_SEQUENCES.SOURCE_ORGANIZATION_ID
MTL_KANBAN_PULL_SEQUENCES.ORGANIZATION_ID |
MTL_INTERORG_PARAMETERS |
MTL_KANBAN_PULL_SEQUENCES.SUPPLIER_ID | PO_VENDORS |
Foreign Key Column | Foreign Table |
---|---|
MTL_KANBAN_CARDS.PULL_SEQUENCE_ID | MTL_KANBAN_PULL_SEQUENCES |
INV.MTL_KANBAN_PULL_SEQUENCES does not reference any database object
INV.MTL_KANBAN_PULL_SEQUENCES is referenced by following:
Description: | Kanban Template |
---|
INV.MTL_KANBAN_TEMPLATES does not reference any database object
INV.MTL_KANBAN_TEMPLATES is referenced by following:
Description: | stores information concerning the assignment of legal entity to economic zones. |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_LE_ECONOMIC_ZONES.LEGAL_ENTITY_ID | HR_ALL_ORGANIZATION_UNITS |
MTL_LE_ECONOMIC_ZONES.ZONE_CODE | MTL_ECONOMIC_ZONES_B |
INV.MTL_LE_ECONOMIC_ZONES does not reference any database object
INV.MTL_LE_ECONOMIC_ZONES is referenced by following:
Description: |
---|
INV.MTL_LOTATT_SYNC_REPORT_TEMP does not reference any database object
INV.MTL_LOTATT_SYNC_REPORT_TEMP is referenced by following:
Description: | Audit Trail for conversion changes |
---|
INV.MTL_LOT_CONV_AUDIT does not reference any database object
INV.MTL_LOT_CONV_AUDIT is referenced by following:
Description: | Audit Detail Record |
---|
INV.MTL_LOT_CONV_AUDIT_DETAILS does not reference any database object
INV.MTL_LOT_CONV_AUDIT_DETAILS is referenced by following:
Description: |
---|
INV.MTL_LOT_ERES_GTMP does not reference any database object
INV.MTL_LOT_ERES_GTMP is referenced by following:
Description: | New Table, stores the grade update history lot grade updates. |
---|
INV.MTL_LOT_GRADE_HISTORY does not reference any database object
INV.MTL_LOT_GRADE_HISTORY is referenced by following:
Description: | Lot number definitions |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_LOT_NUMBERS.INVENTORY_ITEM_ID
MTL_LOT_NUMBERS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_LOT_NUMBERS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_LOT_NUMBERS.STATUS_ID | MTL_MATERIAL_STATUSES_B |
Foreign Key Column | Foreign Table |
---|---|
AHL_WORKORDER_MTL_TXNS.INVENTORY_ITEM_ID
AHL_WORKORDER_MTL_TXNS.ORGANIZATION_ID AHL_WORKORDER_MTL_TXNS.LOT_NUMBER |
MTL_LOT_NUMBERS |
CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID
CSI_ITEM_INSTANCES.INV_MASTER_ORGANIZATION_ID CSI_ITEM_INSTANCES.LOT_NUMBER |
MTL_LOT_NUMBERS |
CSP_PACKLIST_SERIAL_LOTS.INVENTORY_ITEM_ID
CSP_PACKLIST_SERIAL_LOTS.ORGANIZATION_ID CSP_PACKLIST_SERIAL_LOTS.LOT_NUMBER |
MTL_LOT_NUMBERS |
CSP_PICKLIST_SERIAL_LOTS.INVENTORY_ITEM_ID
CSP_PICKLIST_SERIAL_LOTS.ORGANIZATION_ID CSP_PICKLIST_SERIAL_LOTS.LOT_NUMBER |
MTL_LOT_NUMBERS |
MRP_INVENTORY_LOTS.INVENTORY_ITEM_ID
MRP_INVENTORY_LOTS.ORGANIZATION_ID MRP_INVENTORY_LOTS.INVENTORY_LOT_NUMBER |
MTL_LOT_NUMBERS |
MTL_CC_ENTRIES_INTERFACE.INVENTORY_ITEM_ID
MTL_CC_ENTRIES_INTERFACE.ORGANIZATION_ID MTL_CC_ENTRIES_INTERFACE.LOT_NUMBER |
MTL_LOT_NUMBERS |
MTL_CYCLE_COUNT_ENTRIES.INVENTORY_ITEM_ID
MTL_CYCLE_COUNT_ENTRIES.ORGANIZATION_ID MTL_CYCLE_COUNT_ENTRIES.LOT_NUMBER |
MTL_LOT_NUMBERS |
MTL_DEMAND.INVENTORY_ITEM_ID
MTL_DEMAND.ORGANIZATION_ID MTL_DEMAND.LOT_NUMBER |
MTL_LOT_NUMBERS |
MTL_DEMAND_INTERFACE.INVENTORY_ITEM_ID
MTL_DEMAND_INTERFACE.ORGANIZATION_ID MTL_DEMAND_INTERFACE.LOT_NUMBER |
MTL_LOT_NUMBERS |
MTL_MATERIAL_STATUS_HISTORY.INVENTORY_ITEM_ID
MTL_MATERIAL_STATUS_HISTORY.ORGANIZATION_ID MTL_MATERIAL_STATUS_HISTORY.LOT_NUMBER |
MTL_LOT_NUMBERS |
MTL_ONHAND_QUANTITIES.INVENTORY_ITEM_ID
MTL_ONHAND_QUANTITIES.ORGANIZATION_ID MTL_ONHAND_QUANTITIES.LOT_NUMBER |
MTL_LOT_NUMBERS |
MTL_PHYSICAL_ADJUSTMENTS.INVENTORY_ITEM_ID
MTL_PHYSICAL_ADJUSTMENTS.ORGANIZATION_ID MTL_PHYSICAL_ADJUSTMENTS.LOT_NUMBER |
MTL_LOT_NUMBERS |
MTL_PHYSICAL_INVENTORY_TAGS.INVENTORY_ITEM_ID
MTL_PHYSICAL_INVENTORY_TAGS.ORGANIZATION_ID MTL_PHYSICAL_INVENTORY_TAGS.LOT_NUMBER |
MTL_LOT_NUMBERS |
MTL_PHYSICAL_INVENTORY_TAGS.INVENTORY_ITEM_ID
MTL_PHYSICAL_INVENTORY_TAGS.ORGANIZATION_ID MTL_PHYSICAL_INVENTORY_TAGS.LOT_NUMBER |
MTL_LOT_NUMBERS |
MTL_RESERVATIONS.INVENTORY_ITEM_ID
MTL_RESERVATIONS.ORGANIZATION_ID MTL_RESERVATIONS.LOT_NUMBER |
MTL_LOT_NUMBERS |
MTL_RESERVATIONS_INTERFACE.INVENTORY_ITEM_ID
MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID MTL_RESERVATIONS_INTERFACE.LOT_NUMBER |
MTL_LOT_NUMBERS |
MTL_RESERVATIONS_INTERFACE.INVENTORY_ITEM_ID
MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID MTL_RESERVATIONS_INTERFACE.TO_LOT_NUMBER |
MTL_LOT_NUMBERS |
MTL_SERIAL_NUMBERS.INVENTORY_ITEM_ID
MTL_SERIAL_NUMBERS.CURRENT_ORGANIZATION_ID MTL_SERIAL_NUMBERS.LOT_NUMBER |
MTL_LOT_NUMBERS |
MTL_TRANSACTION_LOT_NUMBERS.INVENTORY_ITEM_ID
MTL_TRANSACTION_LOT_NUMBERS.ORGANIZATION_ID MTL_TRANSACTION_LOT_NUMBERS.LOT_NUMBER |
MTL_LOT_NUMBERS |
MTL_TXN_REQUEST_LINES.INVENTORY_ITEM_ID
MTL_TXN_REQUEST_LINES.ORGANIZATION_ID MTL_TXN_REQUEST_LINES.LOT_NUMBER |
MTL_LOT_NUMBERS |
WMS_EXCEPTIONS.INVENTORY_ITEM_ID
WMS_EXCEPTIONS.ORGANIZATION_ID WMS_EXCEPTIONS.LOT_NUMBER |
MTL_LOT_NUMBERS |
WMS_LICENSE_PLATE_NUMBERS.INVENTORY_ITEM_ID
WMS_LICENSE_PLATE_NUMBERS.ORGANIZATION_ID WMS_LICENSE_PLATE_NUMBERS.LOT_NUMBER |
MTL_LOT_NUMBERS |
WMS_LPN_CONTENTS.INVENTORY_ITEM_ID
WMS_LPN_CONTENTS.ORGANIZATION_ID WMS_LPN_CONTENTS.LOT_NUMBER |
MTL_LOT_NUMBERS |
WMS_LPN_HISTORIES.INVENTORY_ITEM_ID
WMS_LPN_HISTORIES.ORGANIZATION_ID WMS_LPN_HISTORIES.LOT_NUMBER |
MTL_LOT_NUMBERS |
WMS_LPN_INTERFACE.INVENTORY_ITEM_ID
WMS_LPN_INTERFACE.ORGANIZATION_ID WMS_LPN_INTERFACE.LOT_NUMBER |
MTL_LOT_NUMBERS |
WMS_SKIP_TASK_EXCEPTIONS.INVENTORY_ITEM_ID
WMS_SKIP_TASK_EXCEPTIONS.ORGANIZATION_ID WMS_SKIP_TASK_EXCEPTIONS.LOT_NUMBER |
MTL_LOT_NUMBERS |
INV.MTL_LOT_NUMBERS does not reference any database object
INV.MTL_LOT_NUMBERS is referenced by following:
Description: | Lot specific conversions |
---|
INV.MTL_LOT_UOM_CLASS_CONVERSIONS does not reference any database object
INV.MTL_LOT_UOM_CLASS_CONVERSIONS is referenced by following:
Description: |
---|
INV.MTL_LPN_ATR_QTY_GT does not reference any database object
INV.MTL_LPN_ATR_QTY_GT is referenced by following:
Description: | Onhand Xml |
---|
INV.MTL_LSP_ONHAND_BALANCE_TMP does not reference any database object
INV.MTL_LSP_ONHAND_BALANCE_TMP is referenced by following:
Description: | Define manufacturers |
---|
Foreign Key Column | Foreign Table |
---|---|
AHL_MR_EFFECTIVITY_DTLS.MANUFACTURER_ID | MTL_MANUFACTURERS |
MTL_MFG_PART_NUMBERS.MANUFACTURER_ID | MTL_MANUFACTURERS |
INV.MTL_MANUFACTURERS does not reference any database object
INV.MTL_MANUFACTURERS is referenced by following:
Description: | Base table for inventory status definitions - Used by WMS only |
---|
Foreign Key Column | Foreign Table |
---|---|
AHL_RA_SETUPS.STATUS_ID | MTL_MATERIAL_STATUSES_B |
CSI_ITEM_INSTANCES.INSTANCE_CONDITION_ID | MTL_MATERIAL_STATUSES_B |
MTL_ITEM_LOCATIONS.STATUS_ID | MTL_MATERIAL_STATUSES_B |
MTL_LOT_NUMBERS.STATUS_ID | MTL_MATERIAL_STATUSES_B |
MTL_MATERIAL_STATUSES_TL.STATUS_ID | MTL_MATERIAL_STATUSES_B |
MTL_MATERIAL_STATUS_HISTORY.STATUS_ID | MTL_MATERIAL_STATUSES_B |
MTL_SECONDARY_INVENTORIES.STATUS_ID | MTL_MATERIAL_STATUSES_B |
MTL_SERIAL_NUMBERS.STATUS_ID | MTL_MATERIAL_STATUSES_B |
MTL_STATUS_TRANSACTION_CONTROL.STATUS_ID | MTL_MATERIAL_STATUSES_B |
INV.MTL_MATERIAL_STATUSES_B does not reference any database object
INV.MTL_MATERIAL_STATUSES_B is referenced by following:
Description: | Translation table for inventory status definition - Used by WMS only |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_MATERIAL_STATUSES_TL.STATUS_ID | MTL_MATERIAL_STATUSES_B |
INV.MTL_MATERIAL_STATUSES_TL does not reference any database object
INV.MTL_MATERIAL_STATUSES_TL is referenced by following:
Description: | Inventory status update history - Used by WMS only |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_MATERIAL_STATUS_HISTORY.STATUS_ID | MTL_MATERIAL_STATUSES_B |
MTL_MATERIAL_STATUS_HISTORY.ZONE_CODE
MTL_MATERIAL_STATUS_HISTORY.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_MATERIAL_STATUS_HISTORY.LOCATOR_ID
MTL_MATERIAL_STATUS_HISTORY.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_MATERIAL_STATUS_HISTORY.INVENTORY_ITEM_ID
MTL_MATERIAL_STATUS_HISTORY.ORGANIZATION_ID MTL_MATERIAL_STATUS_HISTORY.LOT_NUMBER |
MTL_LOT_NUMBERS |
MTL_MATERIAL_STATUS_HISTORY.SERIAL_NUMBER
MTL_MATERIAL_STATUS_HISTORY.INVENTORY_ITEM_ID MTL_MATERIAL_STATUS_HISTORY.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
MTL_MATERIAL_STATUS_HISTORY.UPDATE_REASON_ID | MTL_TRANSACTION_REASONS |
INV.MTL_MATERIAL_STATUS_HISTORY does not reference any database object
INV.MTL_MATERIAL_STATUS_HISTORY is referenced by following:
Description: | Material transaction table |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_MATERIAL_TRANSACTIONS.TRANSFER_COST_DIST_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_MATERIAL_TRANSACTIONS.INVENTORY_ITEM_ID
MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID MTL_MATERIAL_TRANSACTIONS.REVISION |
MTL_ITEM_REVISIONS_B |
MTL_MATERIAL_TRANSACTIONS.CYCLE_COUNT_ID | MTL_CYCLE_COUNT_ENTRIES |
MTL_MATERIAL_TRANSACTIONS.PHYSICAL_ADJUSTMENT_ID | MTL_PHYSICAL_ADJUSTMENTS |
MTL_MATERIAL_TRANSACTIONS.TRANSACTION_TYPE_ID | MTL_TRANSACTION_TYPES |
MTL_MATERIAL_TRANSACTIONS.CURRENCY_CODE | GL_DAILY_CONVERSION_TYPES |
MTL_MATERIAL_TRANSACTIONS.INVENTORY_ITEM_ID
MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_MATERIAL_TRANSACTIONS.TRANSFER_COST_GROUP_ID | CST_COST_GROUPS |
MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_ID | WIP_DISCRETE_JOBS |
MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_ID
MTL_MATERIAL_TRANSACTIONS.REPETITIVE_LINE_ID |
WIP_REPETITIVE_ITEMS |
MTL_MATERIAL_TRANSACTIONS.LOCATOR_ID
MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_MATERIAL_TRANSACTIONS.ACCT_PERIOD_ID
MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID |
ORG_ACCT_PERIODS |
MTL_MATERIAL_TRANSACTIONS.TRANSPORTATION_DIST_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_MATERIAL_TRANSACTIONS.SUBINVENTORY_CODE
MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_ID | WIP_FLOW_SCHEDULES |
MTL_MATERIAL_TRANSACTIONS.RCV_TRANSACTION_ID | RCV_TRANSACTIONS |
MTL_MATERIAL_TRANSACTIONS.MOVE_TRANSACTION_ID | WIP_MOVE_TRANSACTIONS |
MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
MTL_MATERIAL_TRANSACTIONS.MOVE_ORDER_LINE_ID | MTL_TXN_REQUEST_LINES |
MTL_MATERIAL_TRANSACTIONS.REASON_ID | MTL_TRANSACTION_REASONS |
MTL_MATERIAL_TRANSACTIONS.DISTRIBUTION_ACCOUNT_ID | GL_CODE_COMBINATIONS |
MTL_MATERIAL_TRANSACTIONS.ENCUMBRANCE_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_MATERIAL_TRANSACTIONS.COST_GROUP_ID | CST_COST_GROUPS |
Foreign Key Column | Foreign Table |
---|---|
AHL_WORKORDER_MTL_TXNS.MATERIAL_TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
CST_COGS_EVENTS.MMT_TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
CST_AE_HEADERS.ACCOUNTING_EVENT_ID | MTL_MATERIAL_TRANSACTIONS |
CST_COMP_SNAPSHOT.TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
CST_MGD_INFL_TSF_ORG_ENTRIES.TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
CST_MISC_RECONCILIATION.INVENTORY_TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
CST_WRITE_OFFS.INVENTORY_TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
CST_WRITE_OFF_DETAILS.INVENTORY_TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
JAI_CMN_RG_23D_TRXS.GOODS_ISSUE_ID | MTL_MATERIAL_TRANSACTIONS |
JAI_CMN_TRANSACTIONS_T.TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
JAI_ENCUM_TAX_RVRSL_DTLS.ACCT_TXN_ID | MTL_MATERIAL_TRANSACTIONS |
JAI_PO_RMA_RTN_LINES.RMA_RTN_ID | MTL_MATERIAL_TRANSACTIONS |
JAI_PO_RMA_RTN_TX_LNS.RMA_RTN_ID | MTL_MATERIAL_TRANSACTIONS |
MTL_ACTUAL_COST_SUBELEMENT.TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
MTL_CST_ACTUAL_COST_DETAILS.TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
MTL_CST_TXN_COST_DETAILS.TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
MTL_MATERIAL_TXN_ALLOCATIONS.TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
MTL_OBJECT_EVENTS.TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
MTL_OBJECT_GENEALOGY.ORIGIN_TXN_ID | MTL_MATERIAL_TRANSACTIONS |
MTL_ONHAND_QUANTITIES.CREATE_TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
MTL_ONHAND_QUANTITIES.UPDATE_TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
MTL_PAC_ACTUAL_COST_DETAILS.TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
MTL_PAC_COST_SUBELEMENTS.TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
MTL_PAC_TXN_COST_DETAILS.TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
MTL_SERIAL_NUMBERS.LAST_TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
MTL_TRANSACTION_ACCOUNTS.TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
MTL_TRANSACTION_LOT_NUMBERS.TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
MTL_UNIT_TRANSACTIONS.TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
PJM_BORROW_PAYBACKS.PAYBACK_TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
PJM_BORROW_TRANSACTIONS.BORROW_TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
PO_ACCRUAL_RECONCILE_TEMP_ALL.INV_TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
PO_ACCRUAL_WRITE_OFFS_ALL.INV_TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
RCV_TRANSACTIONS.INV_TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
RCV_TRANSACTIONS_INTERFACE.INV_TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
WIP_SCRAP_VALUES.TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
WMS_DISPATCHED_TASKS_HISTORY.TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
INV.MTL_MATERIAL_TRANSACTIONS does not reference any database object
INV.MTL_MATERIAL_TRANSACTIONS is referenced by following:
Description: | Euro as a Functional Currency Archive |
---|
INV.MTL_MATERIAL_TRANSACTIONS_EFC does not reference any database object
INV.MTL_MATERIAL_TRANSACTIONS_EFC is referenced by following:
Description: | Temporary table for processing material transactions |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_MATERIAL_TRANSACTIONS_TEMP.DISTRIBUTION_ACCOUNT_ID | GL_CODE_COMBINATIONS |
MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSFER_SUBINVENTORY
MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSFER_ORGANIZATION |
MTL_SECONDARY_INVENTORIES |
MTL_MATERIAL_TRANSACTIONS_TEMP.INVENTORY_ITEM_ID
MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_MATERIAL_TRANSACTIONS_TEMP.RCV_TRANSACTION_ID | RCV_TRANSACTIONS |
MTL_MATERIAL_TRANSACTIONS_TEMP.ACCT_PERIOD_ID
MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID |
ORG_ACCT_PERIODS |
MTL_MATERIAL_TRANSACTIONS_TEMP.MOVE_TRANSACTION_ID | WIP_MOVE_TRANSACTIONS |
MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_ID | WIP_DISCRETE_JOBS |
MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_ID | WIP_FLOW_SCHEDULES |
MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_TYPE_ID
MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID |
MTL_GENERIC_DISPOSITIONS |
MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSPORTATION_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_MATERIAL_TRANSACTIONS_TEMP.MOVE_ORDER_LINE_ID | MTL_TXN_REQUEST_LINES |
MTL_MATERIAL_TRANSACTIONS_TEMP.RESERVATION_ID | MTL_RESERVATIONS |
MTL_MATERIAL_TRANSACTIONS_TEMP.LOCATOR_ID
MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSFER_TO_LOCATION
MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSFER_ORGANIZATION |
MTL_ITEM_LOCATIONS |
MTL_MATERIAL_TRANSACTIONS_TEMP.INVENTORY_ITEM_ID
MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID MTL_MATERIAL_TRANSACTIONS_TEMP.REVISION |
MTL_ITEM_REVISIONS_B |
MTL_MATERIAL_TRANSACTIONS_TEMP.SUBINVENTORY_CODE
MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
Foreign Key Column | Foreign Table |
---|---|
WMS_EXCEPTIONS.TRANSACTION_HEADER_ID | MTL_MATERIAL_TRANSACTIONS_TEMP |
WMS_SKIP_TASK_EXCEPTIONS.TRANSACTION_HEADER_ID | MTL_MATERIAL_TRANSACTIONS_TEMP |
INV.MTL_MATERIAL_TRANSACTIONS_TEMP does not reference any database object
INV.MTL_MATERIAL_TRANSACTIONS_TEMP is referenced by following:
Description: | Unit allocations among repetitive schedules |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_MATERIAL_TXN_ALLOCATIONS.TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
MTL_MATERIAL_TXN_ALLOCATIONS.REPETITIVE_SCHEDULE_ID | WIP_REPETITIVE_SCHEDULES |
MTL_MATERIAL_TXN_ALLOCATIONS.ORGANIZATION_ID | MTL_PARAMETERS |
INV.MTL_MATERIAL_TXN_ALLOCATIONS does not reference any database object
INV.MTL_MATERIAL_TXN_ALLOCATIONS is referenced by following:
Description: | Define manufacturer part numbers |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_MFG_PART_NUMBERS.MANUFACTURER_ID | MTL_MANUFACTURERS |
MTL_MFG_PART_NUMBERS.INVENTORY_ITEM_ID
MTL_MFG_PART_NUMBERS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_MFG_PART_NUMBERS.ORGANIZATION_ID | MTL_PARAMETERS |
INV.MTL_MFG_PART_NUMBERS does not reference any database object
INV.MTL_MFG_PART_NUMBERS is referenced by following:
Description: | Stores the data sets built for on line display or for export |
---|
INV.MTL_MGD_INVENTORY_POSITIONS does not reference any database object
INV.MTL_MGD_INVENTORY_POSITIONS is referenced by following:
Description: | this table will store information about user logging history |
---|
INV.MTL_MOBILE_LOGIN_HIST does not reference any database object
INV.MTL_MOBILE_LOGIN_HIST is referenced by following:
Description: | Back up table for Inventory onhand |
---|
INV.MTL_MOQD_BACKUP does not reference any database object
INV.MTL_MOQD_BACKUP is referenced by following:
Description: | Movement parameter values |
---|
INV.MTL_MOVEMENT_PARAMETERS does not reference any database object
INV.MTL_MOVEMENT_PARAMETERS is referenced by following:
Description: | Stores all relevant information for movement statistics transactions. |
---|
INV.MTL_MOVEMENT_STATISTICS does not reference any database object
INV.MTL_MOVEMENT_STATISTICS is referenced by following:
Description: | Euro as a Functional Currency Archive |
---|
INV.MTL_MOVEMENT_STATISTICS_EFC does not reference any database object
INV.MTL_MOVEMENT_STATISTICS_EFC is referenced by following:
Description: | This table stores validation rules defined for movement statistics fields that belong to a rule set as defined in MTL_MVT_STATS_RULE_SETS_B table.Each row stores a rule that can determine a valid set of values for a field or an alternate u |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_MVT_STATS_RULES.RULE_SET_CODE | MTL_MVT_STATS_RULE_SETS_B |
INV.MTL_MVT_STATS_RULES does not reference any database object
INV.MTL_MVT_STATS_RULES is referenced by following:
Description: | Movement Statistics table to store Rule Sets for validation rules. |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_MVT_STATS_RULES.RULE_SET_CODE | MTL_MVT_STATS_RULE_SETS_B |
MTL_STAT_TYPE_USAGES.ATTRIBUTE_RULE_SET_CODE | MTL_MVT_STATS_RULE_SETS_B |
MTL_STAT_TYPE_USAGES.ALT_UOM_RULE_SET_CODE | MTL_MVT_STATS_RULE_SETS_B |
MTL_MVT_STATS_RULE_SETS_TL.RULE_SET_CODE | MTL_MVT_STATS_RULE_SETS_B |
INV.MTL_MVT_STATS_RULE_SETS_B does not reference any database object
INV.MTL_MVT_STATS_RULE_SETS_B is referenced by following:
Description: | MTL_MVT_STATS_RULE_SET_TL is the corresponding transalation table for MTL_MVT_STATS_RULE_SET_B.This table contains one entry for every Rule Set Code and Language.Rule Set Code and Language uniquely identify a row.Rule Set Display Name iden |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_MVT_STATS_RULE_SETS_TL.RULE_SET_CODE | MTL_MVT_STATS_RULE_SETS_B |
INV.MTL_MVT_STATS_RULE_SETS_TL does not reference any database object
INV.MTL_MVT_STATS_RULE_SETS_TL is referenced by following:
Description: |
---|
INV.MTL_MWB_GTMP does not reference any database object
INV.MTL_MWB_GTMP is referenced by following:
Description: | Major events that have occurred relevant to an object |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_OBJECT_EVENTS.TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
INV.MTL_OBJECT_EVENTS does not reference any database object
INV.MTL_OBJECT_EVENTS is referenced by following:
Description: | Genealogy information between an object and its parents |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_OBJECT_GENEALOGY.ORIGIN_TXN_ID | MTL_MATERIAL_TRANSACTIONS |
INV.MTL_OBJECT_GENEALOGY does not reference any database object
INV.MTL_OBJECT_GENEALOGY is referenced by following:
Description: | Object Genealogy Inteface table |
---|
INV.MTL_OBJECT_GENEALOGY_INTERFACE does not reference any database object
INV.MTL_OBJECT_GENEALOGY_INTERFACE is referenced by following:
Description: |
---|
INV.MTL_ONHAND_LOCK_TEMP does not reference any database object
INV.MTL_ONHAND_LOCK_TEMP is referenced by following:
Description: | FIFO quantities by control level and receipt |
---|
INV.MTL_ONHAND_QUANTITIES_DETAIL does not reference any database object
INV.MTL_ONHAND_QUANTITIES_DETAIL is referenced by following:
Description: | Temporary table for on-hand quantity queries |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_ONHAND_QUANTITY_TEMP.LOCATOR_ID
MTL_ONHAND_QUANTITY_TEMP.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_ONHAND_QUANTITY_TEMP.SUBINVENTORY
MTL_ONHAND_QUANTITY_TEMP.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_ONHAND_QUANTITY_TEMP.INVENTORY_ITEM_ID
MTL_ONHAND_QUANTITY_TEMP.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
INV.MTL_ONHAND_QUANTITY_TEMP does not reference any database object
INV.MTL_ONHAND_QUANTITY_TEMP is referenced by following:
Description: | Multi-organization inventory report temporary table |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_ORG_REPORT_TEMP.ORGANIZATION_ID | MTL_PARAMETERS |
INV.MTL_ORG_REPORT_TEMP does not reference any database object
INV.MTL_ORG_REPORT_TEMP is referenced by following:
Description: | Stores the elemental cost for a given transaction in a period |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_PAC_ACTUAL_COST_DETAILS.COST_GROUP_ID | CST_COST_GROUPS |
MTL_PAC_ACTUAL_COST_DETAILS.TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
MTL_PAC_ACTUAL_COST_DETAILS.PAC_PERIOD_ID | CST_PAC_PERIODS |
MTL_PAC_ACTUAL_COST_DETAILS.COST_TYPE_ID | CST_COST_TYPES |
MTL_PAC_ACTUAL_COST_DETAILS.COST_ELEMENT_ID | CST_COST_ELEMENTS |
MTL_PAC_ACTUAL_COST_DETAILS.COST_LAYER_ID | CST_PAC_ITEM_COSTS |
INV.MTL_PAC_ACTUAL_COST_DETAILS does not reference any database object
INV.MTL_PAC_ACTUAL_COST_DETAILS is referenced by following:
Description: | Euro as a Functional Currency Archive |
---|
INV.MTL_PAC_ACTUAL_COST_DETAIL_EFC does not reference any database object
INV.MTL_PAC_ACTUAL_COST_DETAIL_EFC is referenced by following:
Description: | Used to temporarily hold data during the interorg iteration process |
---|
INV.MTL_PAC_ACT_CST_DTL_TEMP does not reference any database object
INV.MTL_PAC_ACT_CST_DTL_TEMP is referenced by following:
Description: | Stores the material overhead sub-elements that are charged for a given transaction in a particular period. |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_PAC_COST_SUBELEMENTS.COST_GROUP_ID | CST_COST_GROUPS |
MTL_PAC_COST_SUBELEMENTS.TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
MTL_PAC_COST_SUBELEMENTS.PAC_PERIOD_ID | CST_PAC_PERIODS |
MTL_PAC_COST_SUBELEMENTS.COST_TYPE_ID | CST_COST_TYPES |
MTL_PAC_COST_SUBELEMENTS.COST_ELEMENT_ID | CST_COST_ELEMENTS |
MTL_PAC_COST_SUBELEMENTS.RESOURCE_ID | BOM_RESOURCES |
INV.MTL_PAC_COST_SUBELEMENTS does not reference any database object
INV.MTL_PAC_COST_SUBELEMENTS is referenced by following:
Description: | Euro as a Functional Currency Archive |
---|
INV.MTL_PAC_COST_SUBELEMENTS_EFC does not reference any database object
INV.MTL_PAC_COST_SUBELEMENTS_EFC is referenced by following:
Description: | Transaction details for a period |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_PAC_TXN_COST_DETAILS.COST_GROUP_ID | CST_COST_GROUPS |
MTL_PAC_TXN_COST_DETAILS.TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
MTL_PAC_TXN_COST_DETAILS.PAC_PERIOD_ID | CST_PAC_PERIODS |
MTL_PAC_TXN_COST_DETAILS.COST_TYPE_ID | CST_COST_TYPES |
MTL_PAC_TXN_COST_DETAILS.COST_ELEMENT_ID | CST_COST_ELEMENTS |
INV.MTL_PAC_TXN_COST_DETAILS does not reference any database object
INV.MTL_PAC_TXN_COST_DETAILS is referenced by following:
Description: | Euro as a Functional Currency Archive |
---|
INV.MTL_PAC_TXN_COST_DETAILS_EFC does not reference any database object
INV.MTL_PAC_TXN_COST_DETAILS_EFC is referenced by following:
Description: | Inventory control options and defaults |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_PARAMETERS.AP_ACCRUAL_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_PARAMETERS.INTRANSIT_INV_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_PARAMETERS.RESOURCE_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_PARAMETERS.MATERIAL_OVERHEAD_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_PARAMETERS.AVERAGE_COST_VAR_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_PARAMETERS.MATL_OVHD_ABSORPTION_ACCT | GL_CODE_COMBINATIONS |
MTL_PARAMETERS.OVERHEAD_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_PARAMETERS.SALES_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_PARAMETERS.MATERIAL_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_PARAMETERS.COST_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_PARAMETERS.SOURCE_SUBINVENTORY
MTL_PARAMETERS.SOURCE_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_PARAMETERS.MASTER_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_PARAMETERS.OUTSIDE_PROCESSING_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_PARAMETERS.DEFAULT_PICKING_RULE_ID | MTL_PICKING_RULES |
MTL_PARAMETERS.DEFAULT_ATP_RULE_ID | MTL_ATP_RULES |
MTL_PARAMETERS.INVOICE_PRICE_VAR_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_PARAMETERS.EXPENSE_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_PARAMETERS.CALENDAR_CODE | BOM_CALENDARS |
MTL_PARAMETERS.CALENDAR_EXCEPTION_SET_ID | BOM_EXCEPTION_SETS |
MTL_PARAMETERS.SOURCE_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_PARAMETERS.DEFAULT_MATERIAL_COST_ID | BOM_RESOURCES |
MTL_PARAMETERS.COST_OF_SALES_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_PARAMETERS.ORGANIZATION_ID | HR_ALL_ORGANIZATION_UNITS |
MTL_PARAMETERS.DEFAULT_COST_GROUP_ID | CST_COST_GROUPS |
MTL_PARAMETERS.DEFERRED_COGS_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_PARAMETERS.DEFAULT_CROSSDOCK_CRITERIA_ID | WMS_CROSSDOCK_CRITERIA_B |
MTL_PARAMETERS.PURCHASE_PRICE_VAR_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_PARAMETERS.ENCUMBRANCE_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_PARAMETERS.INTERORG_TRANSFER_CR_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_PARAMETERS.INTERORG_PAYABLES_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_PARAMETERS.INTERORG_PRICE_VAR_ACCOUNT | GL_CODE_COMBINATIONS |
Foreign Key Column | Foreign Table |
---|---|
BOM_ALTERNATE_DESIGNATORS.ORGANIZATION_ID | MTL_PARAMETERS |
BOM_DEPARTMENTS.ORGANIZATION_ID | MTL_PARAMETERS |
BOM_DEPARTMENT_CLASSES.ORGANIZATION_ID | MTL_PARAMETERS |
BOM_EAM_DEPT_APPROVERS.ORGANIZATION_ID | MTL_PARAMETERS |
BOM_RESOURCES.ORGANIZATION_ID | MTL_PARAMETERS |
BOM_STANDARD_OPERATIONS.ORGANIZATION_ID | MTL_PARAMETERS |
CSP_REQUIREMENT_HEADERS.DESTINATION_ORGANIZATION_ID | MTL_PARAMETERS |
CSP_REQUIREMENT_LINES.SOURCE_ORGANIZATION_ID | MTL_PARAMETERS |
CST_AE_HEADERS.ORGANIZATION_ID | MTL_PARAMETERS |
CST_COST_GROUP_ASSIGNMENTS.ORGANIZATION_ID | MTL_PARAMETERS |
CST_MARGIN_BUILD.ORGANIZATION_ID | MTL_PARAMETERS |
CST_PAC_EAM_WO_EST_STATUSES.ORGANIZATION_ID | MTL_PARAMETERS |
EAM_ASSET_STATUS_HISTORY.ORGANIZATION_ID | MTL_PARAMETERS |
ENG_ENGINEERING_CHANGES.ORGANIZATION_ID | MTL_PARAMETERS |
FLM_FILTER_CRITERIA.ORGANIZATION_ID | MTL_PARAMETERS |
FLM_KANBAN_SUMMARY.ORGANIZATION_ID | MTL_PARAMETERS |
FLM_MMM_PLANS.ORGANIZATION_ID | MTL_PARAMETERS |
FLM_SEQ_LINE_RULES.ORGANIZATION_ID | MTL_PARAMETERS |
FLM_SEQ_RULES.ORGANIZATION_ID | MTL_PARAMETERS |
FLM_SEQ_RULE_CONSTRAINTS.ORGANIZATION_ID | MTL_PARAMETERS |
FLM_SEQ_TASKS.ORGANIZATION_ID | MTL_PARAMETERS |
FLM_SEQ_TASK_CONSTRAINTS.ORGANIZATION_ID | MTL_PARAMETERS |
FLM_SEQ_TASK_DEMANDS.ORGANIZATION_ID | MTL_PARAMETERS |
FLM_SEQ_TASK_EXCEPTIONS.ORGANIZATION_ID | MTL_PARAMETERS |
FLM_SEQ_TASK_LINES.ORGANIZATION_ID | MTL_PARAMETERS |
JMF_SHIKYU_REPLENISHMENTS.OEM_ORGANIZATION_ID | MTL_PARAMETERS |
JMF_SHIKYU_REPLENISHMENTS.TP_ORGANIZATION_ID | MTL_PARAMETERS |
JMF_SUBCONTRACT_ORDERS.OEM_ORGANIZATION_ID | MTL_PARAMETERS |
JMF_SUBCONTRACT_ORDERS.TP_ORGANIZATION_ID | MTL_PARAMETERS |
MRP_ITEM_SUPPLIERS.ORGANIZATION_ID | MTL_PARAMETERS |
MRP_PARAMETERS.ORGANIZATION_ID | MTL_PARAMETERS |
MRP_SR_ASSIGNMENTS.ORGANIZATION_ID | MTL_PARAMETERS |
MRP_SR_RECEIPT_ORG.RECEIPT_ORGANIZATION_ID | MTL_PARAMETERS |
MRP_SR_SOURCE_ORG.SOURCE_ORGANIZATION_ID | MTL_PARAMETERS |
MRP_SUPPLIER_CAPACITIES.ORGANIZATION_ID | MTL_PARAMETERS |
MRP_SUPPLIER_FLEX_FENCES.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_ABC_ASSIGNMENT_GROUPS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_ABC_CLASSES.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_ABC_COMPILE_HEADERS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_CATEGORY_ACCOUNTS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_CC_ENTRIES_INTERFACE.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_CI_INTERFACE.CONTAINER_ITEM_ORG_ID | MTL_PARAMETERS |
MTL_CI_XREFS_INTERFACE.MASTER_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_CROSS_REFERENCES.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_CUSTOMER_ITEM_XREFS.MASTER_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_CUSTOMER_ITEMS.CONTAINER_ITEM_ORG_ID | MTL_PARAMETERS |
MTL_CYCLE_COUNT_CLASSES.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_CYCLE_COUNT_ENTRIES.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_CYCLE_COUNT_HEADERS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_EAM_ASSET_ACTIVITIES.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_EAM_ASSET_ATTR_GROUPS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_EAM_ASSET_ATTR_VALUES.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_EAM_LOCATIONS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_EAM_NETWORK_ASSETS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_GENERIC_DISPOSITIONS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_INTERORG_PARAMETERS.FROM_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_INTERORG_PARAMETERS.TO_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_INTERORG_SHIP_METHODS.FROM_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_INTERORG_SHIP_METHODS.TO_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_ITEM_CATEGORIES.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_ITEM_LOCATIONS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_ITEM_REVISIONS_B.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_ITEM_SUB_INVENTORIES.SOURCE_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_ITEM_TEMPLATES.CONTEXT_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_KANBAN_CARDS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_KANBAN_CARD_ACTIVITY.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_KANBAN_PULL_SEQUENCES.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_LOT_NUMBERS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_MATERIAL_TXN_ALLOCATIONS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_MFG_PART_NUMBERS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_ORG_REPORT_TEMP.ORGANIZATION_ID | MTL_PARAMETERS |
WMS_LABEL_REQUESTS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_PARAMETERS.COST_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_PARAMETERS.MASTER_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_PARAMETERS.SOURCE_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_PENDING_ITEM_STATUS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_PHYSICAL_INVENTORIES.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_PHYSICAL_SUBINVENTORIES.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_PLANNERS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_PURGE_HEADER.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_RELATED_ITEMS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_REPLENISH_HEADERS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_REPLENISH_LINES.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_REPLENISH_HEADERS_INT.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_REPLENISH_LINES.SOURCE_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_REPLENISH_LINES_INT.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_RESERVATIONS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_RESERVATIONS_INTERFACE.TO_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_RTG_ITEM_REVISIONS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_SECONDARY_INVENTORIES.SOURCE_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_SECONDARY_INVENTORIES.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_SERIAL_NUMBERS.CURRENT_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_SHORT_CHK_PARAM.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_SHORT_CHK_STATEMENTS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_SHORT_CHK_TEMP.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_SUPPLY.TO_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_SUPPLY.INTRANSIT_OWNING_ORG_ID | MTL_PARAMETERS |
MTL_SUPPLY.MRP_TO_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_SYSTEM_ITEMS_B.DEFAULT_SHIPPING_ORG | MTL_PARAMETERS |
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_SYSTEM_ITEMS_B.SOURCE_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_TXN_REQUEST_HEADERS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_TXN_REQUEST_LINES.TO_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_TXN_REQUEST_LINES.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_USER_SUPPLY.ORGANIZATION_ID | MTL_PARAMETERS |
ORG_ACCT_PERIODS.ORGANIZATION_ID | MTL_PARAMETERS |
ORG_FREIGHT_TL.ORGANIZATION_ID | MTL_PARAMETERS |
ORG_GL_BATCHES.ORGANIZATION_ID | MTL_PARAMETERS |
PJM_ORG_PARAMETERS.ORGANIZATION_ID | MTL_PARAMETERS |
PJM_UNIT_NUMBERS.MASTER_ORGANIZATION_ID | MTL_PARAMETERS |
RCV_ACCOUNTING_EVENTS.ORGANIZATION_ID | MTL_PARAMETERS |
RCV_ACCOUNTING_EVENTS.TRANSFER_ORGANIZATION_ID | MTL_PARAMETERS |
WIP_EAM_PARAMETERS.ORGANIZATION_ID | MTL_PARAMETERS |
WIP_PAC_PERIOD_BALANCES.ORGANIZATION_ID | MTL_PARAMETERS |
WMS_BUS_EVENT_DEVICES.ORGANIZATION_ID | MTL_PARAMETERS |
WMS_DEPARTMENT_SUBINVENTORIES.ORGANIZATION_ID | MTL_PARAMETERS |
WMS_DEVICES_B.ORGANIZATION_ID | MTL_PARAMETERS |
WMS_DISPATCHED_TASKS_ARCH.ORGANIZATION_ID | MTL_PARAMETERS |
WMS_DISPATCHED_TASKS.ORGANIZATION_ID | MTL_PARAMETERS |
WMS_DISPATCHED_TASKS_HISTORY.ORGANIZATION_ID | MTL_PARAMETERS |
WMS_EXCEPTIONS.ORGANIZATION_ID | MTL_PARAMETERS |
WMS_LICENSE_PLATE_NUMBERS.ORGANIZATION_ID | MTL_PARAMETERS |
WMS_LOCATIONS_LOCATORS.ORGANIZATION_ID | MTL_PARAMETERS |
WMS_LPN_INTERFACE.ORGANIZATION_ID | MTL_PARAMETERS |
WMS_ORG_HIERARCHY_OBJS.ORGANIZATION_ID | MTL_PARAMETERS |
WMS_RULES_B.ORGANIZATION_ID | MTL_PARAMETERS |
WMS_SKIP_TASK_EXCEPTIONS.ORGANIZATION_ID | MTL_PARAMETERS |
WMS_STRATEGIES_B.ORGANIZATION_ID | MTL_PARAMETERS |
WMS_STRATEGY_ASSIGNMENTS.ORGANIZATION_ID | MTL_PARAMETERS |
WSM_PARAMETERS.ORGANIZATION_ID | MTL_PARAMETERS |
INV.MTL_PARAMETERS does not reference any database object
INV.MTL_PARAMETERS is referenced by following:
Description: | History of item-status assignments |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_PENDING_ITEM_STATUS.STATUS_CODE | MTL_ITEM_STATUS |
MTL_PENDING_ITEM_STATUS.INVENTORY_ITEM_ID
MTL_PENDING_ITEM_STATUS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_PENDING_ITEM_STATUS.ORGANIZATION_ID | MTL_PARAMETERS |
INV.MTL_PENDING_ITEM_STATUS does not reference any database object
INV.MTL_PENDING_ITEM_STATUS is referenced by following:
Description: | The table contains summarized inventory valuation details for an accounting period, organization, inventory type and cost group |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_PERIOD_CG_SUMMARY.ACCT_PERIOD_ID
MTL_PERIOD_CG_SUMMARY.ORGANIZATION_ID |
ORG_ACCT_PERIODS |
MTL_PERIOD_CG_SUMMARY.COST_GROUP_ID | CST_COST_GROUPS |
INV.MTL_PERIOD_CG_SUMMARY does not reference any database object
INV.MTL_PERIOD_CG_SUMMARY is referenced by following:
Description: | Period summary inventory values for subinventories |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_PERIOD_SUMMARY.SECONDARY_INVENTORY
MTL_PERIOD_SUMMARY.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_PERIOD_SUMMARY.ACCT_PERIOD_ID
MTL_PERIOD_SUMMARY.ORGANIZATION_ID |
ORG_ACCT_PERIODS |
INV.MTL_PERIOD_SUMMARY does not reference any database object
INV.MTL_PERIOD_SUMMARY is referenced by following:
Description: | Euro as a Functional Currency Archive |
---|
INV.MTL_PERIOD_SUMMARY_EFC does not reference any database object
INV.MTL_PERIOD_SUMMARY_EFC is referenced by following:
Description: | Inventory Period Close Details |
---|
INV.MTL_PER_CLOSE_DTLS does not reference any database object
INV.MTL_PER_CLOSE_DTLS is referenced by following:
Description: | Euro as a Functional Currency Archive |
---|
INV.MTL_PER_CLOSE_DTLS_EFC does not reference any database object
INV.MTL_PER_CLOSE_DTLS_EFC is referenced by following:
Description: | Physical inventory adjustments |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_PHYSICAL_ADJUSTMENTS.ORGANIZATION_ID
MTL_PHYSICAL_ADJUSTMENTS.PHYSICAL_INVENTORY_ID |
MTL_PHYSICAL_INVENTORIES |
MTL_PHYSICAL_ADJUSTMENTS.OUTERMOST_LPN_ID | WMS_LICENSE_PLATE_NUMBERS |
MTL_PHYSICAL_ADJUSTMENTS.COST_GROUP_ID | CST_COST_GROUPS |
MTL_PHYSICAL_ADJUSTMENTS.PARENT_LPN_ID | WMS_LICENSE_PLATE_NUMBERS |
MTL_PHYSICAL_ADJUSTMENTS.INVENTORY_ITEM_ID
MTL_PHYSICAL_ADJUSTMENTS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_PHYSICAL_ADJUSTMENTS.SUBINVENTORY_NAME
MTL_PHYSICAL_ADJUSTMENTS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_PHYSICAL_ADJUSTMENTS.INVENTORY_ITEM_ID
MTL_PHYSICAL_ADJUSTMENTS.ORGANIZATION_ID MTL_PHYSICAL_ADJUSTMENTS.REVISION |
MTL_ITEM_REVISIONS_B |
MTL_PHYSICAL_ADJUSTMENTS.GL_ADJUST_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_PHYSICAL_ADJUSTMENTS.INVENTORY_ITEM_ID
MTL_PHYSICAL_ADJUSTMENTS.ORGANIZATION_ID MTL_PHYSICAL_ADJUSTMENTS.LOT_NUMBER |
MTL_LOT_NUMBERS |
MTL_PHYSICAL_ADJUSTMENTS.SERIAL_NUMBER
MTL_PHYSICAL_ADJUSTMENTS.INVENTORY_ITEM_ID MTL_PHYSICAL_ADJUSTMENTS.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
Foreign Key Column | Foreign Table |
---|---|
MTL_MATERIAL_TRANSACTIONS.PHYSICAL_ADJUSTMENT_ID | MTL_PHYSICAL_ADJUSTMENTS |
MTL_PHYSICAL_INVENTORY_TAGS.ADJUSTMENT_ID | MTL_PHYSICAL_ADJUSTMENTS |
MTL_PHYSICAL_INVENTORY_TAGS.ADJUSTMENT_ID | MTL_PHYSICAL_ADJUSTMENTS |
INV.MTL_PHYSICAL_ADJUSTMENTS does not reference any database object
INV.MTL_PHYSICAL_ADJUSTMENTS is referenced by following:
Description: | Euro as a Functional Currency Archive |
---|
INV.MTL_PHYSICAL_ADJUSTMENTS_EFC does not reference any database object
INV.MTL_PHYSICAL_ADJUSTMENTS_EFC is referenced by following:
Description: | Physical inventory definitions |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_PHYSICAL_INVENTORIES.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_PHYSICAL_INVENTORIES.DEFAULT_GL_ADJUST_ACCOUNT | GL_CODE_COMBINATIONS |
Foreign Key Column | Foreign Table |
---|---|
MTL_PHYSICAL_ADJUSTMENTS.ORGANIZATION_ID
MTL_PHYSICAL_ADJUSTMENTS.PHYSICAL_INVENTORY_ID |
MTL_PHYSICAL_INVENTORIES |
MTL_PHYSICAL_INVENTORY_TAGS.ORGANIZATION_ID
MTL_PHYSICAL_INVENTORY_TAGS.PHYSICAL_INVENTORY_ID |
MTL_PHYSICAL_INVENTORIES |
MTL_PHYSICAL_SUBINVENTORIES.ORGANIZATION_ID
MTL_PHYSICAL_SUBINVENTORIES.PHYSICAL_INVENTORY_ID |
MTL_PHYSICAL_INVENTORIES |
INV.MTL_PHYSICAL_INVENTORIES does not reference any database object
INV.MTL_PHYSICAL_INVENTORIES is referenced by following:
Description: | Euro as a Functional Currency Archive |
---|
INV.MTL_PHYSICAL_INVENTORIES_EFC does not reference any database object
INV.MTL_PHYSICAL_INVENTORIES_EFC is referenced by following:
Description: | Physical inventory tag definitions |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_PHYSICAL_INVENTORY_TAGS.COST_GROUP_ID | CST_COST_GROUPS |
MTL_PHYSICAL_INVENTORY_TAGS.INVENTORY_ITEM_ID
MTL_PHYSICAL_INVENTORY_TAGS.ORGANIZATION_ID MTL_PHYSICAL_INVENTORY_TAGS.LOT_NUMBER |
MTL_LOT_NUMBERS |
MTL_PHYSICAL_INVENTORY_TAGS.ADJUSTMENT_ID | MTL_PHYSICAL_ADJUSTMENTS |
MTL_PHYSICAL_INVENTORY_TAGS.SERIAL_NUM
MTL_PHYSICAL_INVENTORY_TAGS.INVENTORY_ITEM_ID MTL_PHYSICAL_INVENTORY_TAGS.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
MTL_PHYSICAL_INVENTORY_TAGS.PARENT_LPN_ID | WMS_LICENSE_PLATE_NUMBERS |
MTL_PHYSICAL_INVENTORY_TAGS.OUTERMOST_LPN_ID | WMS_LICENSE_PLATE_NUMBERS |
MTL_PHYSICAL_INVENTORY_TAGS.LOCATOR_ID
MTL_PHYSICAL_INVENTORY_TAGS.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_PHYSICAL_INVENTORY_TAGS.INVENTORY_ITEM_ID
MTL_PHYSICAL_INVENTORY_TAGS.ORGANIZATION_ID MTL_PHYSICAL_INVENTORY_TAGS.REVISION |
MTL_ITEM_REVISIONS_B |
MTL_PHYSICAL_INVENTORY_TAGS.ORGANIZATION_ID
MTL_PHYSICAL_INVENTORY_TAGS.PHYSICAL_INVENTORY_ID |
MTL_PHYSICAL_INVENTORIES |
MTL_PHYSICAL_INVENTORY_TAGS.SUBINVENTORY
MTL_PHYSICAL_INVENTORY_TAGS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_PHYSICAL_INVENTORY_TAGS.INVENTORY_ITEM_ID
MTL_PHYSICAL_INVENTORY_TAGS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_PHYSICAL_INVENTORY_TAGS.INVENTORY_ITEM_ID
MTL_PHYSICAL_INVENTORY_TAGS.ORGANIZATION_ID MTL_PHYSICAL_INVENTORY_TAGS.LOT_NUMBER |
MTL_LOT_NUMBERS |
MTL_PHYSICAL_INVENTORY_TAGS.ADJUSTMENT_ID | MTL_PHYSICAL_ADJUSTMENTS |
MTL_PHYSICAL_INVENTORY_TAGS.SERIAL_NUM
MTL_PHYSICAL_INVENTORY_TAGS.INVENTORY_ITEM_ID MTL_PHYSICAL_INVENTORY_TAGS.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
INV.MTL_PHYSICAL_INVENTORY_TAGS does not reference any database object
INV.MTL_PHYSICAL_INVENTORY_TAGS is referenced by following:
Description: | Physical inventory specific subinventories |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_PHYSICAL_SUBINVENTORIES.ORGANIZATION_ID
MTL_PHYSICAL_SUBINVENTORIES.PHYSICAL_INVENTORY_ID |
MTL_PHYSICAL_INVENTORIES |
MTL_PHYSICAL_SUBINVENTORIES.SUBINVENTORY
MTL_PHYSICAL_SUBINVENTORIES.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_PHYSICAL_SUBINVENTORIES.ORGANIZATION_ID | MTL_PARAMETERS |
INV.MTL_PHYSICAL_SUBINVENTORIES does not reference any database object
INV.MTL_PHYSICAL_SUBINVENTORIES is referenced by following:
Description: | Picking Rule Definitions |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_PARAMETERS.DEFAULT_PICKING_RULE_ID | MTL_PICKING_RULES |
MTL_SYSTEM_ITEMS_B.PICKING_RULE_ID | MTL_PICKING_RULES |
INV.MTL_PICKING_RULES does not reference any database object
INV.MTL_PICKING_RULES is referenced by following:
Description: | This table is used by parallel pick release |
---|
INV.MTL_PICK_SLIP_NUMBERS does not reference any database object
INV.MTL_PICK_SLIP_NUMBERS is referenced by following:
Description: | Planner code definitions |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_PLANNERS.ORGANIZATION_ID | MTL_PARAMETERS |
Foreign Key Column | Foreign Table |
---|---|
CSP_MSTRSTCK_LISTS_ITMS.PLANNER_CODE
CSP_MSTRSTCK_LISTS_ITMS.ORGANIZATION_ID |
MTL_PLANNERS |
CSP_NOTIFICATIONS.PLANNER_CODE
CSP_NOTIFICATIONS.ORGANIZATION_ID |
MTL_PLANNERS |
CSP_PARTS_LOOPS_B.PLANNER_CODE
CSP_PARTS_LOOPS_B.ORGANIZATION_ID |
MTL_PLANNERS |
MTL_SYSTEM_ITEMS_B.PLANNER_CODE
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID |
MTL_PLANNERS |
INV.MTL_PLANNERS does not reference any database object
INV.MTL_PLANNERS is referenced by following:
Description: | This table contains the Purchasing packing slips information. It is used by the purhjasing packing slip report |
---|
INV.MTL_PO_PACKSLIPS does not reference any database object
INV.MTL_PO_PACKSLIPS is referenced by following:
Description: |
---|
INV.MTL_PULL_SEQ_SUPPLIERS does not reference any database object
INV.MTL_PULL_SEQ_SUPPLIERS is referenced by following:
Description: | Transaction history purges |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_PURGE_HEADER.ORGANIZATION_ID | MTL_PARAMETERS |
INV.MTL_PURGE_HEADER does not reference any database object
INV.MTL_PURGE_HEADER is referenced by following:
Description: | (not currently used) |
---|
INV.MTL_QOH_ITEM_TMP does not reference any database object
INV.MTL_QOH_ITEM_TMP is referenced by following:
Description: | (not currently used) |
---|
INV.MTL_QOH_LOCATOR_TMP does not reference any database object
INV.MTL_QOH_LOCATOR_TMP is referenced by following:
Description: | (not currently used) |
---|
INV.MTL_QOH_LOT_TMP does not reference any database object
INV.MTL_QOH_LOT_TMP is referenced by following:
Description: | (not currently used) |
---|
INV.MTL_QOH_REV_TMP does not reference any database object
INV.MTL_QOH_REV_TMP is referenced by following:
Description: | (not currently used) |
---|
INV.MTL_QOH_SUB_TMP does not reference any database object
INV.MTL_QOH_SUB_TMP is referenced by following:
Description: | Item Relationships |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_RELATED_ITEMS.INVENTORY_ITEM_ID
MTL_RELATED_ITEMS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_RELATED_ITEMS.RELATED_ITEM_ID
MTL_RELATED_ITEMS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_RELATED_ITEMS.ORGANIZATION_ID | MTL_PARAMETERS |
Foreign Key Column | Foreign Table |
---|---|
QP_LIST_LINES.INVENTORY_ITEM_ID
QP_LIST_LINES.RELATED_ITEM_ID QP_LIST_LINES.RELATIONSHIP_TYPE_ID QP_LIST_LINES.ORGANIZATION_ID |
MTL_RELATED_ITEMS |
INV.MTL_RELATED_ITEMS does not reference any database object
INV.MTL_RELATED_ITEMS is referenced by following:
Description: | Item Relationships Customer References |
---|
INV.MTL_RELATED_ITEMS_CUST_REF does not reference any database object
INV.MTL_RELATED_ITEMS_CUST_REF is referenced by following:
Description: | Not currently used |
---|
INV.MTL_RELATED_ITEMS_INTERFACE does not reference any database object
INV.MTL_RELATED_ITEMS_INTERFACE is referenced by following:
Description: | Item Relationships Planning Information |
---|
INV.MTL_RELATED_ITEMS_PLN_INFO does not reference any database object
INV.MTL_RELATED_ITEMS_PLN_INFO is referenced by following:
Description: | Replenishment header information |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_REPLENISH_HEADERS.SUBINVENTORY_CODE
MTL_REPLENISH_HEADERS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_REPLENISH_HEADERS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_REPLENISH_HEADERS.DELIVERY_LOCATION_ID | HR_LOCATIONS_ALL |
Foreign Key Column | Foreign Table |
---|---|
MTL_REPLENISH_LINES.REPLENISHMENT_HEADER_ID | MTL_REPLENISH_HEADERS |
INV.MTL_REPLENISH_HEADERS does not reference any database object
INV.MTL_REPLENISH_HEADERS is referenced by following:
Description: | Replenishment header interface information |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_REPLENISH_HEADERS_INT.SUBINVENTORY_CODE
MTL_REPLENISH_HEADERS_INT.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_REPLENISH_HEADERS_INT.ORGANIZATION_ID | MTL_PARAMETERS |
Foreign Key Column | Foreign Table |
---|---|
MTL_REPLENISH_LINES_INT.REPLENISHMENT_HEADER_ID | MTL_REPLENISH_HEADERS_INT |
INV.MTL_REPLENISH_HEADERS_INT does not reference any database object
INV.MTL_REPLENISH_HEADERS_INT is referenced by following:
Description: | Replenishment line information |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_REPLENISH_LINES.INVENTORY_ITEM_ID
MTL_REPLENISH_LINES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_REPLENISH_LINES.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_REPLENISH_LINES.REPLENISHMENT_HEADER_ID | MTL_REPLENISH_HEADERS |
MTL_REPLENISH_LINES.SOURCE_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_REPLENISH_LINES.SOURCE_SUBINVENTORY
MTL_REPLENISH_LINES.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_REPLENISH_LINES.LOCATOR_ID
MTL_REPLENISH_LINES.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
INV.MTL_REPLENISH_LINES does not reference any database object
INV.MTL_REPLENISH_LINES is referenced by following:
Description: | Replenishment line interface information |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_REPLENISH_LINES_INT.REPLENISHMENT_HEADER_ID | MTL_REPLENISH_HEADERS_INT |
MTL_REPLENISH_LINES_INT.INVENTORY_ITEM_ID
MTL_REPLENISH_LINES_INT.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_REPLENISH_LINES_INT.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_REPLENISH_LINES_INT.LOCATOR_ID
MTL_REPLENISH_LINES_INT.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
INV.MTL_REPLENISH_LINES_INT does not reference any database object
INV.MTL_REPLENISH_LINES_INT is referenced by following:
Description: | Reservations |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_RESERVATIONS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_RESERVATIONS.INVENTORY_ITEM_ID
MTL_RESERVATIONS.ORGANIZATION_ID MTL_RESERVATIONS.LOT_NUMBER |
MTL_LOT_NUMBERS |
MTL_RESERVATIONS.INVENTORY_ITEM_ID
MTL_RESERVATIONS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_RESERVATIONS.DEMAND_SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
MTL_RESERVATIONS.SUPPLY_SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
MTL_RESERVATIONS.INVENTORY_ITEM_ID
MTL_RESERVATIONS.ORGANIZATION_ID MTL_RESERVATIONS.REVISION |
MTL_ITEM_REVISIONS_B |
MTL_RESERVATIONS.SUBINVENTORY_CODE
MTL_RESERVATIONS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_RESERVATIONS.LOCATOR_ID
MTL_RESERVATIONS.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
Foreign Key Column | Foreign Table |
---|---|
CSP_REQUIREMENT_LINES.RESERVATION_ID | MTL_RESERVATIONS |
CSP_REQUIREMENT_LINES.LOCAL_RESERVATION_ID | MTL_RESERVATIONS |
MTL_MATERIAL_TRANSACTIONS_TEMP.RESERVATION_ID | MTL_RESERVATIONS |
INV.MTL_RESERVATIONS does not reference any database object
INV.MTL_RESERVATIONS is referenced by following:
Description: | Reservations Interface |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_RESERVATIONS_INTERFACE.INVENTORY_ITEM_ID
MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID MTL_RESERVATIONS_INTERFACE.LOT_NUMBER |
MTL_LOT_NUMBERS |
MTL_RESERVATIONS_INTERFACE.INVENTORY_ITEM_ID
MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID MTL_RESERVATIONS_INTERFACE.TO_LOT_NUMBER |
MTL_LOT_NUMBERS |
MTL_RESERVATIONS_INTERFACE.SUBINVENTORY_CODE
MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_RESERVATIONS_INTERFACE.TO_SUBINVENTORY_CODE
MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_RESERVATIONS_INTERFACE.LOCATOR_ID
MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_RESERVATIONS_INTERFACE.TO_LOCATOR_ID
MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_RESERVATIONS_INTERFACE.TO_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_RESERVATIONS_INTERFACE.INVENTORY_ITEM_ID
MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_RESERVATIONS_INTERFACE.DEMAND_SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
MTL_RESERVATIONS_INTERFACE.TO_DEMAND_SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
MTL_RESERVATIONS_INTERFACE.SUPPLY_SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
MTL_RESERVATIONS_INTERFACE.TO_SUPPLY_SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
MTL_RESERVATIONS_INTERFACE.INVENTORY_ITEM_ID
MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID MTL_RESERVATIONS_INTERFACE.REVISION |
MTL_ITEM_REVISIONS_B |
MTL_RESERVATIONS_INTERFACE.INVENTORY_ITEM_ID
MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID MTL_RESERVATIONS_INTERFACE.TO_REVISION |
MTL_ITEM_REVISIONS_B |
INV.MTL_RESERVATIONS_INTERFACE does not reference any database object
INV.MTL_RESERVATIONS_INTERFACE is referenced by following:
Description: |
---|
INV.MTL_RMA_SERIAL_TEMP does not reference any database object
INV.MTL_RMA_SERIAL_TEMP is referenced by following:
Description: | Routing revisions |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_RTG_ITEM_REVISIONS.CHANGE_NOTICE
MTL_RTG_ITEM_REVISIONS.ORGANIZATION_ID |
ENG_ENGINEERING_CHANGES |
MTL_RTG_ITEM_REVISIONS.ORGANIZATION_ID | MTL_PARAMETERS |
Foreign Key Column | Foreign Table |
---|---|
WIP_DISCRETE_JOBS.PRIMARY_ITEM_ID
WIP_DISCRETE_JOBS.ORGANIZATION_ID WIP_DISCRETE_JOBS.ROUTING_REVISION |
MTL_RTG_ITEM_REVISIONS |
WIP_FLOW_SCHEDULES.PRIMARY_ITEM_ID
WIP_FLOW_SCHEDULES.ORGANIZATION_ID WIP_FLOW_SCHEDULES.ROUTING_REVISION |
MTL_RTG_ITEM_REVISIONS |
INV.MTL_RTG_ITEM_REVISIONS does not reference any database object
INV.MTL_RTG_ITEM_REVISIONS is referenced by following:
Description: | Routing revisions interface table |
---|
INV.MTL_RTG_ITEM_REVS_INTERFACE does not reference any database object
INV.MTL_RTG_ITEM_REVS_INTERFACE is referenced by following:
Description: | Safety stocks |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_SAFETY_STOCKS.INVENTORY_ITEM_ID
MTL_SAFETY_STOCKS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_SAFETY_STOCKS.FORECAST_DESIGNATOR
MTL_SAFETY_STOCKS.ORGANIZATION_ID |
MRP_FORECAST_DESIGNATORS |
INV.MTL_SAFETY_STOCKS does not reference any database object
INV.MTL_SAFETY_STOCKS is referenced by following:
Description: | Local definitions of sales orders |
---|
Foreign Key Column | Foreign Table |
---|---|
MRP_FORECAST_UPDATES.UPDATE_SALES_ORDER | MTL_SALES_ORDERS |
MRP_RESERVATIONS.DISPOSITION_ID | MTL_SALES_ORDERS |
MRP_SCHEDULE_DATES.SOURCE_SALES_ORDER_ID | MTL_SALES_ORDERS |
MTL_DEMAND.DEMAND_SOURCE_HEADER_ID | MTL_SALES_ORDERS |
MTL_DEMAND_INTERFACE.DEMAND_SOURCE_HEADER_ID | MTL_SALES_ORDERS |
MTL_SO_RMA_INTERFACE.SALES_ORDER_ID | MTL_SALES_ORDERS |
WIP_SO_ALLOCATIONS.DEMAND_SOURCE_HEADER_ID | MTL_SALES_ORDERS |
INV.MTL_SALES_ORDERS does not reference any database object
INV.MTL_SALES_ORDERS is referenced by following:
Description: | Seasonality indices |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_SEASONALITY_INDICES.FORECAST_RULE_ID | MTL_FORECAST_RULES |
INV.MTL_SEASONALITY_INDICES does not reference any database object
INV.MTL_SEASONALITY_INDICES is referenced by following:
Description: | Subinventory definitions |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_SECONDARY_INVENTORIES.MATERIAL_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_SECONDARY_INVENTORIES.NOTIFY_LIST_ID | ENG_ECN_APPROVAL_LISTS |
MTL_SECONDARY_INVENTORIES.SOURCE_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_SECONDARY_INVENTORIES.SOURCE_SUBINVENTORY
MTL_SECONDARY_INVENTORIES.SOURCE_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_SECONDARY_INVENTORIES.ENCUMBRANCE_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_SECONDARY_INVENTORIES.STATUS_ID | MTL_MATERIAL_STATUSES_B |
MTL_SECONDARY_INVENTORIES.DEFAULT_COST_GROUP_ID | CST_COST_GROUPS |
MTL_SECONDARY_INVENTORIES.RESOURCE_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_SECONDARY_INVENTORIES.MATERIAL_OVERHEAD_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_SECONDARY_INVENTORIES.OVERHEAD_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_SECONDARY_INVENTORIES.OUTSIDE_PROCESSING_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_SECONDARY_INVENTORIES.EXPENSE_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_SECONDARY_INVENTORIES.ORGANIZATION_ID | MTL_PARAMETERS |
Foreign Key Column | Foreign Table |
---|---|
AHL_WORKORDER_MTL_TXNS.SUBINVENTORY_CODE
AHL_WORKORDER_MTL_TXNS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
BOM_OPERATIONAL_ROUTINGS.COMPLETION_SUBINVENTORY
BOM_OPERATIONAL_ROUTINGS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
CSP_CURR_SUP_DEM_SUMS.SUBINVENTORY_CODE
CSP_CURR_SUP_DEM_SUMS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
CSP_EXCESS_LISTS.SUBINVENTORY_CODE
CSP_EXCESS_LISTS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
CSP_INV_LOC_ASSIGNMENTS.SUBINVENTORY_CODE
CSP_INV_LOC_ASSIGNMENTS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
CSP_PACKLIST_HEADERS.SUBINVENTORY_CODE
CSP_PACKLIST_HEADERS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
CSP_PLANNING_PARAMETERS.SECONDARY_INVENTORY
CSP_PLANNING_PARAMETERS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
CSP_REQUIREMENT_LINES.SOURCE_SUBINVENTORY
CSP_REQUIREMENT_LINES.SOURCE_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
CSP_SEC_INVENTORIES.SECONDARY_INVENTORY_NAME
CSP_SEC_INVENTORIES.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
CSP_SUPPLY_CHAIN.SECONDARY_INVENTORY
CSP_SUPPLY_CHAIN.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
CSP_USAGE_HEADERS.SECONDARY_INVENTORY
CSP_USAGE_HEADERS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
CSP_USAGE_HISTORIES.SUBINVENTORY_CODE
CSP_USAGE_HISTORIES.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
FLM_KANBAN_SUMMARY.SUBINVENTORY_NAME
FLM_KANBAN_SUMMARY.SOURCE_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
JA_AU_SUBINV_LOC_ASSOCS.SUBINVENTORY_NAME
JA_AU_SUBINV_LOC_ASSOCS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MRP_SUB_INVENTORIES.SUB_INVENTORY_CODE
MRP_SUB_INVENTORIES.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_ABC_ASSIGNMENT_GROUPS.SECONDARY_INVENTORY
MTL_ABC_ASSIGNMENT_GROUPS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_ABC_COMPILES.SECONDARY_INVENTORY
MTL_ABC_COMPILES.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_ABC_COMPILE_HEADERS.SECONDARY_INVENTORY
MTL_ABC_COMPILE_HEADERS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_CC_ENTRIES_INTERFACE.SUBINVENTORY
MTL_CC_ENTRIES_INTERFACE.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_CYCLE_COUNT_ENTRIES.SUBINVENTORY
MTL_CYCLE_COUNT_ENTRIES.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_DEMAND.SUBINVENTORY
MTL_DEMAND.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_DEMAND_INTERFACE.SUBINVENTORY
MTL_DEMAND_INTERFACE.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_ITEM_LOCATIONS.SUBINVENTORY_CODE
MTL_ITEM_LOCATIONS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_ITEM_LOC_DEFAULTS.SUBINVENTORY_CODE
MTL_ITEM_LOC_DEFAULTS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_ITEM_SUB_DEFAULTS.SUBINVENTORY_CODE
MTL_ITEM_SUB_DEFAULTS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_ITEM_SUB_INVENTORIES.SECONDARY_INVENTORY
MTL_ITEM_SUB_INVENTORIES.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_ITEM_SUB_INVENTORIES.SOURCE_SUBINVENTORY
MTL_ITEM_SUB_INVENTORIES.SOURCE_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_KANBAN_CARDS.SUBINVENTORY_NAME
MTL_KANBAN_CARDS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_KANBAN_CARDS.SOURCE_SUBINVENTORY
MTL_KANBAN_CARDS.SOURCE_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_KANBAN_CARD_ACTIVITY.SUBINVENTORY_NAME
MTL_KANBAN_CARD_ACTIVITY.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_KANBAN_CARD_ACTIVITY.SOURCE_SUBINVENTORY
MTL_KANBAN_CARD_ACTIVITY.SOURCE_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_KANBAN_PULL_SEQUENCES.SUBINVENTORY_NAME
MTL_KANBAN_PULL_SEQUENCES.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_KANBAN_PULL_SEQUENCES.SOURCE_SUBINVENTORY
MTL_KANBAN_PULL_SEQUENCES.SOURCE_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_MATERIAL_STATUS_HISTORY.ZONE_CODE
MTL_MATERIAL_STATUS_HISTORY.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_MATERIAL_TRANSACTIONS.SUBINVENTORY_CODE
MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSFER_SUBINVENTORY
MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSFER_ORGANIZATION |
MTL_SECONDARY_INVENTORIES |
MTL_MATERIAL_TRANSACTIONS_TEMP.SUBINVENTORY_CODE
MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_ONHAND_QUANTITIES.SUBINVENTORY_CODE
MTL_ONHAND_QUANTITIES.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_ONHAND_QUANTITY_TEMP.SUBINVENTORY
MTL_ONHAND_QUANTITY_TEMP.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_PARAMETERS.SOURCE_SUBINVENTORY
MTL_PARAMETERS.SOURCE_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_PERIOD_SUMMARY.SECONDARY_INVENTORY
MTL_PERIOD_SUMMARY.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_PHYSICAL_ADJUSTMENTS.SUBINVENTORY_NAME
MTL_PHYSICAL_ADJUSTMENTS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_PHYSICAL_INVENTORY_TAGS.SUBINVENTORY
MTL_PHYSICAL_INVENTORY_TAGS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_PHYSICAL_SUBINVENTORIES.SUBINVENTORY
MTL_PHYSICAL_SUBINVENTORIES.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_REPLENISH_HEADERS.SUBINVENTORY_CODE
MTL_REPLENISH_HEADERS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_REPLENISH_HEADERS_INT.SUBINVENTORY_CODE
MTL_REPLENISH_HEADERS_INT.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_REPLENISH_LINES.SOURCE_SUBINVENTORY
MTL_REPLENISH_LINES.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_RESERVATIONS.SUBINVENTORY_CODE
MTL_RESERVATIONS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_RESERVATIONS_INTERFACE.SUBINVENTORY_CODE
MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_RESERVATIONS_INTERFACE.TO_SUBINVENTORY_CODE
MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_SECONDARY_INVENTORIES.SOURCE_SUBINVENTORY
MTL_SECONDARY_INVENTORIES.SOURCE_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_SERIAL_NUMBERS.CURRENT_SUBINVENTORY_CODE
MTL_SERIAL_NUMBERS.CURRENT_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_SUPPLY.FROM_SUBINVENTORY
MTL_SUPPLY.FROM_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_SUPPLY.TO_SUBINVENTORY
MTL_SUPPLY.TO_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_SUPPLY.MRP_TO_SUBINVENTORY
MTL_SUPPLY.MRP_TO_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_SYSTEM_ITEMS_B.SOURCE_SUBINVENTORY
MTL_SYSTEM_ITEMS_B.SOURCE_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_SYSTEM_ITEMS_B.WIP_SUPPLY_SUBINVENTORY
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_TRANSACTIONS_INTERFACE.SUBINVENTORY_CODE
MTL_TRANSACTIONS_INTERFACE.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_TRANSACTIONS_INTERFACE.TRANSFER_SUBINVENTORY
MTL_TRANSACTIONS_INTERFACE.TRANSFER_ORGANIZATION |
MTL_SECONDARY_INVENTORIES |
MTL_TXN_REQUEST_HEADERS.FROM_SUBINVENTORY_CODE
MTL_TXN_REQUEST_HEADERS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_TXN_REQUEST_HEADERS.TO_SUBINVENTORY_CODE
MTL_TXN_REQUEST_HEADERS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_TXN_REQUEST_LINES.FROM_SUBINVENTORY_CODE
MTL_TXN_REQUEST_LINES.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_TXN_REQUEST_LINES.TO_SUBINVENTORY_CODE
MTL_TXN_REQUEST_LINES.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_UNIT_TRANSACTIONS.SUBINVENTORY_CODE
MTL_UNIT_TRANSACTIONS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
PJM_DEFAULT_TASKS.SUBINVENTORY_CODE
PJM_DEFAULT_TASKS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
PO_DISTRIBUTIONS_ARCHIVE_ALL.DESTINATION_SUBINVENTORY
PO_DISTRIBUTIONS_ARCHIVE_ALL.DESTINATION_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
PO_DISTRIBUTIONS_DRAFT_ALL.DESTINATION_SUBINVENTORY
PO_DISTRIBUTIONS_DRAFT_ALL.DESTINATION_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
PO_DISTRIBUTIONS_ALL.DESTINATION_SUBINVENTORY
PO_DISTRIBUTIONS_ALL.DESTINATION_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
PO_REQUISITIONS_INTERFACE_ALL.SOURCE_SUBINVENTORY
PO_REQUISITIONS_INTERFACE_ALL.SOURCE_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
PO_REQUISITIONS_INTERFACE_ALL.DESTINATION_SUBINVENTORY
PO_REQUISITIONS_INTERFACE_ALL.DESTINATION_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
RCV_SHIPMENT_LINES.TO_SUBINVENTORY
RCV_SHIPMENT_LINES.TO_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
RCV_SUPPLY.FROM_SUBINVENTORY
RCV_SUPPLY.FROM_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
RCV_SUPPLY.TO_SUBINVENTORY
RCV_SUPPLY.TO_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
RCV_TRANSACTIONS.SUBINVENTORY
RCV_TRANSACTIONS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
RCV_TRANSACTIONS_INTERFACE.SUBINVENTORY
RCV_TRANSACTIONS_INTERFACE.TO_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
WIP_DISCRETE_JOBS.COMPLETION_SUBINVENTORY
WIP_DISCRETE_JOBS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
WIP_PARAMETERS.DEFAULT_PULL_SUPPLY_SUBINV
WIP_PARAMETERS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
WIP_REPETITIVE_ITEMS.COMPLETION_SUBINVENTORY
WIP_REPETITIVE_ITEMS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
WIP_REQUIREMENT_OPERATIONS.SUPPLY_SUBINVENTORY
WIP_REQUIREMENT_OPERATIONS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
WMS_DEPARTMENT_SUBINVENTORIES.SUBINVENTORY_CODE
WMS_DEPARTMENT_SUBINVENTORIES.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
WMS_EXCEPTIONS.SUBINVENTORY_CODE
WMS_EXCEPTIONS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
WMS_LICENSE_PLATE_NUMBERS.SUBINVENTORY_CODE
WMS_LICENSE_PLATE_NUMBERS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
WMS_LPN_HISTORIES.SUBINVENTORY_CODE
WMS_LPN_HISTORIES.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
WMS_LPN_INTERFACE.SUBINVENTORY_CODE
WMS_LPN_INTERFACE.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
WMS_SKIP_TASK_EXCEPTIONS.SUBINVENTORY_CODE
WMS_SKIP_TASK_EXCEPTIONS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
WSM_CO_PRODUCTS.SUPPLY_SUBINVENTORY
WSM_CO_PRODUCTS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
WSM_LOT_JOB_INTERFACE.COMPLETION_SUBINVENTORY
WSM_LOT_JOB_INTERFACE.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
WSM_RESULTING_LOTS_INTERFACE.SUBINVENTORY_CODE
WSM_RESULTING_LOTS_INTERFACE.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
WSM_SM_STARTING_LOTS.SUBINVENTORY_CODE
WSM_SM_STARTING_LOTS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
WSM_STARTING_LOTS_INTERFACE.SUBINVENTORY_CODE
WSM_STARTING_LOTS_INTERFACE.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
WSM_SUBINVENTORY_EXTENSIONS.SECONDARY_INVENTORY_NAME
WSM_SUBINVENTORY_EXTENSIONS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
INV.MTL_SECONDARY_INVENTORIES does not reference any database object
INV.MTL_SECONDARY_INVENTORIES is referenced by following:
Description: | Item-subinventory-locator assignments |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_SECONDARY_LOCATORS.SECONDARY_LOCATOR
MTL_SECONDARY_LOCATORS.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_SECONDARY_LOCATORS.INVENTORY_ITEM_ID
MTL_SECONDARY_LOCATORS.ORGANIZATION_ID MTL_SECONDARY_LOCATORS.SUBINVENTORY_CODE |
MTL_ITEM_SUB_INVENTORIES |
Foreign Key Column | Foreign Table |
---|---|
WIP_DISCRETE_JOBS.PRIMARY_ITEM_ID
WIP_DISCRETE_JOBS.ORGANIZATION_ID WIP_DISCRETE_JOBS.COMPLETION_LOCATOR_ID |
MTL_SECONDARY_LOCATORS |
WIP_REPETITIVE_ITEMS.PRIMARY_ITEM_ID
WIP_REPETITIVE_ITEMS.ORGANIZATION_ID WIP_REPETITIVE_ITEMS.COMPLETION_LOCATOR_ID |
MTL_SECONDARY_LOCATORS |
WIP_REQUIREMENT_OPERATIONS.INVENTORY_ITEM_ID
WIP_REQUIREMENT_OPERATIONS.ORGANIZATION_ID WIP_REQUIREMENT_OPERATIONS.SUPPLY_LOCATOR_ID |
MTL_SECONDARY_LOCATORS |
INV.MTL_SECONDARY_LOCATORS does not reference any database object
INV.MTL_SECONDARY_LOCATORS is referenced by following:
Description: | (not currently used) |
---|
INV.MTL_SECONDARY_LOCS_INTERFACE does not reference any database object
INV.MTL_SECONDARY_LOCS_INTERFACE is referenced by following:
Description: | Serial number definitions |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_SERIAL_NUMBERS.LPN_ID | WMS_LICENSE_PLATE_NUMBERS |
MTL_SERIAL_NUMBERS.CURRENT_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_SERIAL_NUMBERS.INVENTORY_ITEM_ID
MTL_SERIAL_NUMBERS.CURRENT_ORGANIZATION_ID MTL_SERIAL_NUMBERS.LOT_NUMBER |
MTL_LOT_NUMBERS |
MTL_SERIAL_NUMBERS.ORIGINAL_UNIT_VENDOR_ID | AP_SUPPLIERS |
MTL_SERIAL_NUMBERS.END_ITEM_UNIT_NUMBER | PJM_UNIT_NUMBERS |
MTL_SERIAL_NUMBERS.STATUS_ID | MTL_MATERIAL_STATUSES_B |
MTL_SERIAL_NUMBERS.CURRENT_LOCATOR_ID
MTL_SERIAL_NUMBERS.CURRENT_ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_SERIAL_NUMBERS.INVENTORY_ITEM_ID
MTL_SERIAL_NUMBERS.CURRENT_ORGANIZATION_ID MTL_SERIAL_NUMBERS.REVISION |
MTL_ITEM_REVISIONS_B |
MTL_SERIAL_NUMBERS.CURRENT_SUBINVENTORY_CODE
MTL_SERIAL_NUMBERS.CURRENT_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_SERIAL_NUMBERS.INVENTORY_ITEM_ID
MTL_SERIAL_NUMBERS.CURRENT_ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_SERIAL_NUMBERS.PARENT_SERIAL_NUMBER
MTL_SERIAL_NUMBERS.PARENT_ITEM_ID MTL_SERIAL_NUMBERS.CURRENT_ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
MTL_SERIAL_NUMBERS.ORIGINAL_WIP_ENTITY_ID | WIP_ENTITIES |
MTL_SERIAL_NUMBERS.LAST_TXN_SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
MTL_SERIAL_NUMBERS.LAST_TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
Foreign Key Column | Foreign Table |
---|---|
AHL_WORKORDER_MTL_TXNS.SERIAL_NUMBER
AHL_WORKORDER_MTL_TXNS.INVENTORY_ITEM_ID AHL_WORKORDER_MTL_TXNS.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
CSI_ITEM_INSTANCES.SERIAL_NUMBER
CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID CSI_ITEM_INSTANCES.INV_MASTER_ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
CSP_PACKLIST_SERIAL_LOTS.SERIAL_NUMBER
CSP_PACKLIST_SERIAL_LOTS.INVENTORY_ITEM_ID CSP_PACKLIST_SERIAL_LOTS.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
CSP_PICKLIST_SERIAL_LOTS.SERIAL_NUMBER
CSP_PICKLIST_SERIAL_LOTS.INVENTORY_ITEM_ID CSP_PICKLIST_SERIAL_LOTS.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
CST_EAM_ASSET_PER_BALANCES.SERIAL_NUMBER
CST_EAM_ASSET_PER_BALANCES.INVENTORY_ITEM_ID CST_EAM_ASSET_PER_BALANCES.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
EAM_ASSET_METERS.ASSET_NUMBER
EAM_ASSET_METERS.ASSET_GROUP_ID EAM_ASSET_METERS.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
EAM_ASSET_STATUS_HISTORY.ASSET_NUMBER
EAM_ASSET_STATUS_HISTORY.ASSET_GROUP_ID EAM_ASSET_STATUS_HISTORY.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
EAM_JOB_COMPLETION_TXNS.ASSET_NUMBER
EAM_JOB_COMPLETION_TXNS.ASSET_GROUP_ID EAM_JOB_COMPLETION_TXNS.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
EAM_OP_COMPLETION_TXNS.ASSET_NUMBER
EAM_OP_COMPLETION_TXNS.ASSET_GROUP_ID EAM_OP_COMPLETION_TXNS.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
MTL_EAM_ASSET_ACTIVITIES.SERIAL_NUMBER
MTL_EAM_ASSET_ACTIVITIES.INVENTORY_ITEM_ID MTL_EAM_ASSET_ACTIVITIES.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
MTL_EAM_ASSET_ATTR_VALUES.SERIAL_NUMBER
MTL_EAM_ASSET_ATTR_VALUES.INVENTORY_ITEM_ID MTL_EAM_ASSET_ATTR_VALUES.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
MTL_EAM_NETWORK_ASSETS.NETWORK_SERIAL_NUMBER
MTL_EAM_NETWORK_ASSETS.NETWORK_ITEM_ID MTL_EAM_NETWORK_ASSETS.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
MTL_EAM_NETWORK_ASSETS.SERIAL_NUMBER
MTL_EAM_NETWORK_ASSETS.INVENTORY_ITEM_ID MTL_EAM_NETWORK_ASSETS.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
MTL_MATERIAL_STATUS_HISTORY.SERIAL_NUMBER
MTL_MATERIAL_STATUS_HISTORY.INVENTORY_ITEM_ID MTL_MATERIAL_STATUS_HISTORY.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
MTL_PHYSICAL_ADJUSTMENTS.SERIAL_NUMBER
MTL_PHYSICAL_ADJUSTMENTS.INVENTORY_ITEM_ID MTL_PHYSICAL_ADJUSTMENTS.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
MTL_PHYSICAL_INVENTORY_TAGS.SERIAL_NUM
MTL_PHYSICAL_INVENTORY_TAGS.INVENTORY_ITEM_ID MTL_PHYSICAL_INVENTORY_TAGS.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
MTL_PHYSICAL_INVENTORY_TAGS.SERIAL_NUM
MTL_PHYSICAL_INVENTORY_TAGS.INVENTORY_ITEM_ID MTL_PHYSICAL_INVENTORY_TAGS.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
MTL_SERIAL_NUMBERS.PARENT_SERIAL_NUMBER
MTL_SERIAL_NUMBERS.PARENT_ITEM_ID MTL_SERIAL_NUMBERS.CURRENT_ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
MTL_TXN_REQUEST_LINES.SERIAL_NUMBER_START
MTL_TXN_REQUEST_LINES.INVENTORY_ITEM_ID MTL_TXN_REQUEST_LINES.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
MTL_TXN_REQUEST_LINES.SERIAL_NUMBER_END
MTL_TXN_REQUEST_LINES.INVENTORY_ITEM_ID MTL_TXN_REQUEST_LINES.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
MTL_UNIT_TRANSACTIONS.SERIAL_NUMBER
MTL_UNIT_TRANSACTIONS.INVENTORY_ITEM_ID MTL_UNIT_TRANSACTIONS.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
PJM_UNIT_SERIAL_HISTORY.SERIAL_NUMBER
PJM_UNIT_SERIAL_HISTORY.INVENTORY_ITEM_ID PJM_UNIT_SERIAL_HISTORY.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
WIP_EAM_WORK_REQUESTS.ASSET_NUMBER
WIP_EAM_WORK_REQUESTS.ASSET_GROUP WIP_EAM_WORK_REQUESTS.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
WMS_DISPATCHED_TASKS_ARCH.EQUIPMENT_INSTANCE
WMS_DISPATCHED_TASKS_ARCH.EQUIPMENT_ID WMS_DISPATCHED_TASKS_ARCH.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
WMS_DISPATCHED_TASKS.EQUIPMENT_INSTANCE
WMS_DISPATCHED_TASKS.EQUIPMENT_ID WMS_DISPATCHED_TASKS.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
WMS_DISPATCHED_TASKS_HISTORY.EQUIPMENT_INSTANCE
WMS_DISPATCHED_TASKS_HISTORY.EQUIPMENT_ID WMS_DISPATCHED_TASKS_HISTORY.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
WMS_LICENSE_PLATE_NUMBERS.SERIAL_NUMBER
WMS_LICENSE_PLATE_NUMBERS.INVENTORY_ITEM_ID WMS_LICENSE_PLATE_NUMBERS.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
WMS_LPN_HISTORIES.SERIAL_NUMBER
WMS_LPN_HISTORIES.INVENTORY_ITEM_ID WMS_LPN_HISTORIES.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
WMS_LPN_INTERFACE.SERIAL_NUMBER
WMS_LPN_INTERFACE.INVENTORY_ITEM_ID WMS_LPN_INTERFACE.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
INV.MTL_SERIAL_NUMBERS does not reference any database object
INV.MTL_SERIAL_NUMBERS is referenced by following:
Description: |
---|
INV.MTL_SERIAL_NUMBERS_GT does not reference any database object
INV.MTL_SERIAL_NUMBERS_GT is referenced by following:
Description: | Temporary serial number storage for transactions processor |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_TRANSACTION_LOTS_INTERFACE.SERIAL_TRANSACTION_TEMP_ID | MTL_SERIAL_NUMBERS_INTERFACE |
INV.MTL_SERIAL_NUMBERS_INTERFACE does not reference any database object
INV.MTL_SERIAL_NUMBERS_INTERFACE is referenced by following:
Description: | Temporary serial number holding table |
---|
INV.MTL_SERIAL_NUMBERS_TEMP does not reference any database object
INV.MTL_SERIAL_NUMBERS_TEMP is referenced by following:
Description: |
---|
INV.MTL_SERIAL_TAGGING_ASSIGNMENTS does not reference any database object
INV.MTL_SERIAL_TAGGING_ASSIGNMENTS is referenced by following:
Description: | Shortage Parameters |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_SHORT_CHK_PARAM.ORGANIZATION_ID | MTL_PARAMETERS |
INV.MTL_SHORT_CHK_PARAM does not reference any database object
INV.MTL_SHORT_CHK_PARAM is referenced by following:
Description: | Shortage Check Statements |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_SHORT_CHK_STATEMENTS.ORGANIZATION_ID | MTL_PARAMETERS |
INV.MTL_SHORT_CHK_STATEMENTS does not reference any database object
INV.MTL_SHORT_CHK_STATEMENTS is referenced by following:
Description: | Shortage Check Temporary Table |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_SHORT_CHK_TEMP.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_SHORT_CHK_TEMP.INVENTORY_ITEM_ID
MTL_SHORT_CHK_TEMP.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
INV.MTL_SHORT_CHK_TEMP does not reference any database object
INV.MTL_SHORT_CHK_TEMP is referenced by following:
Description: | THIS TABLE IS OBSOLETE WITH THE NEW ORDER MANAGEMENT SYSTEM. IT IS USED ONLY FOR DATA MIGRATION FROM THIS TABLE TO THE NEW ORDER MANAGEMENT SYSTEM. .RMA headers and lines for OE interface |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_SO_RMA_INTERFACE.SALES_ORDER_ID | MTL_SALES_ORDERS |
MTL_SO_RMA_INTERFACE.INVENTORY_ITEM_ID
MTL_SO_RMA_INTERFACE.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
Foreign Key Column | Foreign Table |
---|---|
MTL_SO_RMA_RECEIPTS.RMA_INTERFACE_ID | MTL_SO_RMA_INTERFACE |
INV.MTL_SO_RMA_INTERFACE does not reference any database object
INV.MTL_SO_RMA_INTERFACE is referenced by following:
Description: | THIS TABLE IS OBSOLETE WITH THE NEW ORDER MANAGEMENT SYSTEM. IT IS USED ONLY FOR DATA MIGRATION FROM THIS TABLE TO THE NEW ORDER MANAGEMENT SYSTEM. RMA receipt transactions |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_SO_RMA_RECEIPTS.RMA_INTERFACE_ID | MTL_SO_RMA_INTERFACE |
MTL_SO_RMA_RECEIPTS.INVENTORY_ITEM_ID
MTL_SO_RMA_RECEIPTS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
INV.MTL_SO_RMA_RECEIPTS does not reference any database object
INV.MTL_SO_RMA_RECEIPTS is referenced by following:
Description: | Item status code attribute values |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_STATUS_ATTRIBUTE_VALUES.INVENTORY_ITEM_STATUS_CODE | MTL_ITEM_STATUS |
MTL_STATUS_ATTRIBUTE_VALUES.ATTRIBUTE_NAME | MTL_ITEM_ATTRIBUTES |
INV.MTL_STATUS_ATTRIBUTE_VALUES does not reference any database object
INV.MTL_STATUS_ATTRIBUTE_VALUES is referenced by following:
Description: | Relations between inventory status and transaction type - Used by WMS only |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_STATUS_TRANSACTION_CONTROL.STATUS_ID | MTL_MATERIAL_STATUSES_B |
MTL_STATUS_TRANSACTION_CONTROL.TRANSACTION_TYPE_ID | MTL_TRANSACTION_TYPES |
INV.MTL_STATUS_TRANSACTION_CONTROL does not reference any database object
INV.MTL_STATUS_TRANSACTION_CONTROL is referenced by following:
Description: | Stores information which determines the statistical type data for each legal entity. |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_STAT_TYPE_USAGES.LEGAL_ENTITY_ID | HR_ALL_ORGANIZATION_UNITS |
MTL_STAT_TYPE_USAGES.ZONE_CODE | MTL_ECONOMIC_ZONES_B |
MTL_STAT_TYPE_USAGES.ATTRIBUTE_RULE_SET_CODE | MTL_MVT_STATS_RULE_SETS_B |
MTL_STAT_TYPE_USAGES.ALT_UOM_RULE_SET_CODE | MTL_MVT_STATS_RULE_SETS_B |
INV.MTL_STAT_TYPE_USAGES does not reference any database object
INV.MTL_STAT_TYPE_USAGES is referenced by following:
Description: | Transaction summaries |
---|
INV.MTL_SUMMARY_TEMP does not reference any database object
INV.MTL_SUMMARY_TEMP is referenced by following:
Description: |
---|
INV.MTL_SUM_DEMD_HIST_GT does not reference any database object
INV.MTL_SUM_DEMD_HIST_GT is referenced by following:
Description: | Stores incoming supply information |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_SUPPLY.REQ_HEADER_ID | PO_REQUISITION_HEADERS_ALL |
MTL_SUPPLY.RCV_TRANSACTION_ID | RCV_TRANSACTIONS |
MTL_SUPPLY.ITEM_ID
MTL_SUPPLY.TO_ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_SUPPLY.ITEM_ID
MTL_SUPPLY.TO_ORGANIZATION_ID MTL_SUPPLY.ITEM_REVISION |
MTL_ITEM_REVISIONS_B |
MTL_SUPPLY.CATEGORY_ID | MTL_CATEGORIES_B |
MTL_SUPPLY.LOCATION_ID
MTL_SUPPLY.TO_ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_SUPPLY.FROM_ORGANIZATION_ID
MTL_SUPPLY.TO_ORGANIZATION_ID |
MTL_INTERORG_PARAMETERS |
MTL_SUPPLY.FROM_SUBINVENTORY
MTL_SUPPLY.FROM_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_SUPPLY.TO_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_SUPPLY.REQ_LINE_ID | PO_REQUISITION_LINES_ALL |
MTL_SUPPLY.TO_SUBINVENTORY
MTL_SUPPLY.TO_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_SUPPLY.INTRANSIT_OWNING_ORG_ID | MTL_PARAMETERS |
MTL_SUPPLY.MRP_TO_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_SUPPLY.MRP_TO_SUBINVENTORY
MTL_SUPPLY.MRP_TO_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_SUPPLY.PO_HEADER_ID | PO_HEADERS_ALL |
MTL_SUPPLY.PO_RELEASE_ID | PO_RELEASES_ALL |
MTL_SUPPLY.PO_LINE_ID | PO_LINES_ALL |
MTL_SUPPLY.PO_LINE_LOCATION_ID | PO_LINE_LOCATIONS_ALL |
MTL_SUPPLY.PO_DISTRIBUTION_ID | PO_DISTRIBUTIONS_ALL |
MTL_SUPPLY.SHIPMENT_HEADER_ID | RCV_SHIPMENT_HEADERS |
MTL_SUPPLY.SHIPMENT_LINE_ID | RCV_SHIPMENT_LINES |
INV.MTL_SUPPLY does not reference any database object
INV.MTL_SUPPLY is referenced by following:
Description: | Temporary table containing ATP details returned from ATP user-exit |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_SUPPLY_DEMAND_TEMP.INVENTORY_ITEM_ID
MTL_SUPPLY_DEMAND_TEMP.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
INV.MTL_SUPPLY_DEMAND_TEMP does not reference any database object
INV.MTL_SUPPLY_DEMAND_TEMP is referenced by following:
Description: | Inventory item definitions |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_SYSTEM_ITEMS_B.COST_OF_SALES_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_SYSTEM_ITEMS_B.DEFAULT_SHIPPING_ORG | MTL_PARAMETERS |
MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_STATUS_CODE | MTL_ITEM_STATUS |
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_SYSTEM_ITEMS_B.ENGINEERING_ITEM_ID
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_SYSTEM_ITEMS_B.ACCOUNTING_RULE_ID | RA_RULES |
MTL_SYSTEM_ITEMS_B.SOURCE_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_SYSTEM_ITEMS_B.SOURCE_SUBINVENTORY
MTL_SYSTEM_ITEMS_B.SOURCE_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_SYSTEM_ITEMS_B.HAZARD_CLASS_ID | PO_HAZARD_CLASSES_B |
MTL_SYSTEM_ITEMS_B.INVOICING_RULE_ID | RA_RULES |
MTL_SYSTEM_ITEMS_B.UN_NUMBER_ID | PO_UN_NUMBERS_B |
MTL_SYSTEM_ITEMS_B.ASSET_CATEGORY_ID | FA_CATEGORIES_B |
MTL_SYSTEM_ITEMS_B.BASE_ITEM_ID
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_SYSTEM_ITEMS_B.WIP_SUPPLY_LOCATOR_ID
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_SYSTEM_ITEMS_B.WIP_SUPPLY_SUBINVENTORY
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_SYSTEM_ITEMS_B.RECEIVING_ROUTING_ID | RCV_ROUTING_HEADERS |
MTL_SYSTEM_ITEMS_B.ATP_RULE_ID | MTL_ATP_RULES |
MTL_SYSTEM_ITEMS_B.BASE_WARRANTY_SERVICE_ID
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_SYSTEM_ITEMS_B.PAYMENT_TERMS_ID | RA_TERMS_B |
MTL_SYSTEM_ITEMS_B.ITEM_CATALOG_GROUP_ID | MTL_ITEM_CATALOG_GROUPS_B |
MTL_SYSTEM_ITEMS_B.EXPENSE_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_SYSTEM_ITEMS_B.ENCUMBRANCE_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_SYSTEM_ITEMS_B.ENGINEERING_ECN_CODE
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID |
ENG_ENGINEERING_CHANGES |
MTL_SYSTEM_ITEMS_B.PRODUCT_FAMILY_ITEM_ID
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_SYSTEM_ITEMS_B.SALES_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_SYSTEM_ITEMS_B.PICKING_RULE_ID | MTL_PICKING_RULES |
MTL_SYSTEM_ITEMS_B.PLANNER_CODE
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID |
MTL_PLANNERS |
Foreign Key Column | Foreign Table |
---|---|
AHL_INV_SERVICE_ITEM_RELS.INV_ITEM_ID
AHL_INV_SERVICE_ITEM_RELS.INV_ORG_ID |
MTL_SYSTEM_ITEMS_B |
AHL_INV_SERVICE_ITEM_RELS.SERVICE_ITEM_ID
AHL_INV_SERVICE_ITEM_RELS.INV_ORG_ID |
MTL_SYSTEM_ITEMS_B |
AHL_MR_EFFECTIVITIES.INVENTORY_ITEM_ID
AHL_MR_EFFECTIVITIES.INVENTORY_ORG_ID |
MTL_SYSTEM_ITEMS_B |
AHL_PRD_DISPOSITIONS_B.INVENTORY_ITEM_ID
AHL_PRD_DISPOSITIONS_B.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
AHL_PRD_DISPOSITIONS_B_H.INVENTORY_ITEM_ID
AHL_PRD_DISPOSITIONS_B_H.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
AHL_RA_DEFINITION_HDR.INVENTORY_ITEM_ID
AHL_RA_DEFINITION_HDR.INVENTORY_ORG_ID |
MTL_SYSTEM_ITEMS_B |
AHL_ROUTES_B.SERVICE_ITEM_ID
AHL_ROUTES_B.SERVICE_ITEM_ORG_ID |
MTL_SYSTEM_ITEMS_B |
AHL_ROUTE_EFFECTIVITIES.INVENTORY_ITEM_ID
AHL_ROUTE_EFFECTIVITIES.INVENTORY_MASTER_ORG_ID |
MTL_SYSTEM_ITEMS_B |
AHL_RT_OPER_MATERIALS.INVENTORY_ITEM_ID
AHL_RT_OPER_MATERIALS.INVENTORY_ORG_ID |
MTL_SYSTEM_ITEMS_B |
AHL_RT_OPER_MATERIALS_H.INVENTORY_ITEM_ID
AHL_RT_OPER_MATERIALS_H.INVENTORY_ORG_ID |
MTL_SYSTEM_ITEMS_B |
AHL_UF_HEADERS.INVENTORY_ITEM_ID
AHL_UF_HEADERS.INVENTORY_ORG_ID |
MTL_SYSTEM_ITEMS_B |
AHL_VISITS_B.INVENTORY_ITEM_ID
AHL_VISITS_B.ITEM_ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
AHL_VISIT_TASKS_B.INVENTORY_ITEM_ID
AHL_VISIT_TASKS_B.ITEM_ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
AHL_WORKORDER_MTL_TXNS.INVENTORY_ITEM_ID
AHL_WORKORDER_MTL_TXNS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
AMS_ACT_PRODUCTS.INVENTORY_ITEM_ID
AMS_ACT_PRODUCTS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
AMS_ITEM_ATTRIBUTES.INVENTORY_ITEM_ID
AMS_ITEM_ATTRIBUTES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
AS_AP_TRACKING_OBJECTIVES.INVENTORY_ITEM_ID
AS_AP_TRACKING_OBJECTIVES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
AS_COLLATERAL_REQ_ITEMS.INVENTORY_ITEM_ID
AS_COLLATERAL_REQ_ITEMS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
AS_INTEREST_CODES_B.PF_ITEM_ID
AS_INTEREST_CODES_B.PF_ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
AS_LEAD_LINES_ALL.INVENTORY_ITEM_ID
AS_LEAD_LINES_ALL.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
AS_LEAD_LINES_ALL.INVENTORY_ITEM_ID
AS_LEAD_LINES_ALL.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
AS_PROMOTIONS_ALL.COLLATERAL_INVENTORY_ITEM_ID
AS_PROMOTIONS_ALL.COLLATERAL_ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
AS_SALES_LEAD_LINES.INVENTORY_ITEM_ID
AS_SALES_LEAD_LINES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
AS_SCRIPT_ANSWER_ACTIONS_ALL.INVENTORY_ITEM_ID
AS_SCRIPT_ANSWER_ACTIONS_ALL.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
AS_TERRITORY_VALUES_ALL.INVENTORY_ITEM_ID
AS_TERRITORY_VALUES_ALL.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
AS_TERRITORY_VALUES_ALL.INVENTORY_ITEM_ID
AS_TERRITORY_VALUES_ALL.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
BOM_BILL_OF_MATERIALS.ASSEMBLY_ITEM_ID
BOM_BILL_OF_MATERIALS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
BOM_BILL_OF_MATERIALS.COMMON_ASSEMBLY_ITEM_ID
BOM_BILL_OF_MATERIALS.COMMON_ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
BOM_EXPLOSIONS.TOP_ITEM_ID
BOM_EXPLOSIONS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
BOM_EXPLOSIONS.COMPONENT_ITEM_ID
BOM_EXPLOSIONS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
BOM_MIXED_MODEL_MAP_HEADER.FAMILY_ITEM_ID
BOM_MIXED_MODEL_MAP_HEADER.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
BOM_OPERATIONAL_ROUTINGS.COMMON_ASSEMBLY_ITEM_ID
BOM_OPERATIONAL_ROUTINGS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
BOM_OPERATIONAL_ROUTINGS.ASSEMBLY_ITEM_ID
BOM_OPERATIONAL_ROUTINGS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
BOM_STRUCTURES_B.ASSEMBLY_ITEM_ID
BOM_STRUCTURES_B.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
BOM_STRUCTURES_B.COMMON_ASSEMBLY_ITEM_ID
BOM_STRUCTURES_B.COMMON_ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CRP_BILL_OF_RESOURCE_ITEMS.INVENTORY_ITEM_ID
CRP_BILL_OF_RESOURCE_ITEMS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CRP_RESOURCE_HOURS.SOURCE_ITEM_ID
CRP_RESOURCE_HOURS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CSD_GROUP_JOB_PARAM_TEMP.INVENTORY_ITEM_ID
CSD_GROUP_JOB_PARAM_TEMP.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID
CSI_ITEM_INSTANCES.INV_MASTER_ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CSI_I_EXTENDED_ATTRIBS.INVENTORY_ITEM_ID
CSI_I_EXTENDED_ATTRIBS.MASTER_ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CSP_CURR_SUP_DEM_SUMS.INVENTORY_ITEM_ID
CSP_CURR_SUP_DEM_SUMS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CSP_EXCESS_LISTS.INVENTORY_ITEM_ID
CSP_EXCESS_LISTS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CSP_MSTRSTCK_LISTS_ITMS.INVENTORY_ITEM_ID
CSP_MSTRSTCK_LISTS_ITMS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CSP_NOTIFICATIONS.INVENTORY_ITEM_ID
CSP_NOTIFICATIONS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CSP_NOTIFICATION_DETAILS.INVENTORY_ITEM_ID
CSP_NOTIFICATION_DETAILS.SOURCE_ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CSP_PACKLIST_LINES.INVENTORY_ITEM_ID
CSP_PACKLIST_LINES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CSP_STOCK_LISTS.INVENTORY_ITEM_ID
CSP_STOCK_LISTS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CSP_SUPPLY_CHAIN.INVENTORY_ITEM_ID
CSP_SUPPLY_CHAIN.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CSP_USAGE_HEADERS.INVENTORY_ITEM_ID
CSP_USAGE_HEADERS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CSP_USAGE_HISTORIES.INVENTORY_ITEM_ID
CSP_USAGE_HISTORIES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CST_COST_TYPE_HISTORY.INVENTORY_ITEM_ID
CST_COST_TYPE_HISTORY.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CST_ITEM_COSTS.INVENTORY_ITEM_ID
CST_ITEM_COSTS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CST_ITEM_COSTS_INTERFACE.INVENTORY_ITEM_ID
CST_ITEM_COSTS_INTERFACE.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CST_ITEM_COST_DETAILS.INVENTORY_ITEM_ID
CST_ITEM_COST_DETAILS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CST_ITEM_CST_DTLS_INTERFACE.INVENTORY_ITEM_ID
CST_ITEM_CST_DTLS_INTERFACE.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CST_QUANTITY_LAYERS.INVENTORY_ITEM_ID
CST_QUANTITY_LAYERS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CST_WRITE_OFFS.INVENTORY_ITEM_ID
CST_WRITE_OFFS.OPERATING_UNIT_ID |
MTL_SYSTEM_ITEMS_B |
CUN_NON_SERIALIZED_UNITS.ITEM_ID
CUN_NON_SERIALIZED_UNITS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CUN_SERIALIZED_UNITS.ITEM_ID
CUN_SERIALIZED_UNITS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CZ_AUTOSELECTION_ITEMS.INVENTORY_ITEM_ID
CZ_AUTOSELECTION_ITEMS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CZ_CONSTRAINT_ASSIGNMENTS.INVENTORY_ITEM_ID
CZ_CONSTRAINT_ASSIGNMENTS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
EAM_ASSET_METERS.ASSET_GROUP_ID
EAM_ASSET_METERS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
EAM_JOB_COMPLETION_TXNS.ASSET_ACTIVITY_ID
EAM_JOB_COMPLETION_TXNS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
EAM_OP_COMPLETION_TXNS.ASSET_ACTIVITY_ID
EAM_OP_COMPLETION_TXNS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
EAM_WORK_ORDER_BILLS.BILLED_INVENTORY_ITEM_ID
EAM_WORK_ORDER_BILLS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
ENG_REVISED_ITEMS.REVISED_ITEM_ID
ENG_REVISED_ITEMS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
ENG_REVISED_ITEMS.USE_UP_ITEM_ID
ENG_REVISED_ITEMS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
FLM_MMM_OP_ITEMS.ASSEMBLY_ITEM_ID
FLM_MMM_OP_ITEMS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
FLM_SEQ_TASK_DEMANDS.PRIMARY_ITEM_ID
FLM_SEQ_TASK_DEMANDS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
IBE_CT_IMEDIA_SEARCH.INVENTORY_ITEM_ID
IBE_CT_IMEDIA_SEARCH.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
IBE_CT_RELATED_ITEMS.INVENTORY_ITEM_ID
IBE_CT_RELATED_ITEMS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
IBE_CT_RELATED_ITEMS.RELATED_ITEM_ID
IBE_CT_RELATED_ITEMS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
IBE_CT_REL_EXCLUSIONS.INVENTORY_ITEM_ID
IBE_CT_REL_EXCLUSIONS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
IBE_CT_REL_EXCLUSIONS.RELATED_ITEM_ID
IBE_CT_REL_EXCLUSIONS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
IBE_DSP_SECTION_ITEMS.INVENTORY_ITEM_ID
IBE_DSP_SECTION_ITEMS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
IBE_ECR_ORDERS_FACT.INVENTORY_ITEM_ID
IBE_ECR_ORDERS_FACT.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
IBE_ECR_QUOTES_FACT.INVENTORY_ITEM_ID
IBE_ECR_QUOTES_FACT.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
IBE_SHP_LIST_ITEMS_ALL.INVENTORY_ITEM_ID
IBE_SHP_LIST_ITEMS_ALL.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
IBE_SECTION_SEARCH.INVENTORY_ITEM_ID
IBE_SECTION_SEARCH.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
ICX_SHOPPING_CART_LINES.ITEM_ID
ICX_SHOPPING_CART_LINES.DESTINATION_ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
ICX_WEB_STORE_OPTIONS.NON_SHIPITEM_ID
ICX_WEB_STORE_OPTIONS.ORG_ID |
MTL_SYSTEM_ITEMS_B |
JAI_CMN_TRANSACTIONS_T.INVENTORY_ITEM_ID
JAI_CMN_TRANSACTIONS_T.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
JAI_INV_ITM_SETUPS.INVENTORY_ITEM_ID
JAI_INV_ITM_SETUPS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
JAI_MTL_MATCH_RECEIPTS.INVENTORY_ITEM_ID
JAI_MTL_MATCH_RECEIPTS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
JAI_MTL_TRXS.INVENTORY_ITEM_ID
JAI_MTL_TRXS.FROM_ORGANIZATION |
MTL_SYSTEM_ITEMS_B |
JAI_OPM_OSP_DTLS.ITEM_ID
JAI_OPM_OSP_DTLS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
JAI_OPM_OSP_DTLS.INVENTORY_ITEM_ID
JAI_OPM_OSP_DTLS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
JAI_PO_OSP_CENVAT_DTLS.INVENTORY_ITEM_ID
JAI_PO_OSP_CENVAT_DTLS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
JAI_PO_OSP_ITM_DTLS.OSP_ITEM_ID
JAI_PO_OSP_ITM_DTLS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
JAI_PO_OSP_ITM_DTLS.ITEM_ID
JAI_PO_OSP_ITM_DTLS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
JAI_PO_OSP_ITM_HDRS.OSP_ITEM_ID
JAI_PO_OSP_ITM_HDRS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
JAI_PO_RMA_RTN_LINES.INVENTORY_ITEM_ID
JAI_PO_RMA_RTN_LINES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
JAI_RCV_LINES.INVENTORY_ITEM_ID
JAI_RCV_LINES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
JAI_RCV_RGM_LINES.INVENTORY_ITEM_ID
JAI_RCV_RGM_LINES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID
JAI_RCV_TRANSACTIONS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
JAI_RETRO_LINE_CHANGES.INVENTORY_ITEM_ID
JAI_RETRO_LINE_CHANGES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID
JAI_RGM_ITM_REGNS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
JL_BR_AR_TX_EXC_ITM_ALL.INVENTORY_ITEM_ID
JL_BR_AR_TX_EXC_ITM_ALL.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
JL_BR_PO_TAX_EXC_ITEMS_ALL.INVENTORY_ITEM_ID
JL_BR_PO_TAX_EXC_ITEMS_ALL.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
JL_ZZ_AR_TX_EXC_ITM_ALL.INVENTORY_ITEM_ID
JL_ZZ_AR_TX_EXC_ITM_ALL.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
JMF_SHIKYU_COMPONENTS.SHIKYU_COMPONENT_ID
JMF_SHIKYU_COMPONENTS.OEM_ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
JMF_SHIKYU_REPLENISHMENTS.SHIKYU_COMPONENT_ID
JMF_SHIKYU_REPLENISHMENTS.OEM_ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
JMF_SUBCONTRACT_ORDERS.OSA_ITEM_ID
JMF_SUBCONTRACT_ORDERS.OEM_ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MRP_FORECAST_INTERFACE.INVENTORY_ITEM_ID
MRP_FORECAST_INTERFACE.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MRP_FORECAST_ITEMS.INVENTORY_ITEM_ID
MRP_FORECAST_ITEMS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MRP_ITEM_SUPPLIERS.INVENTORY_ITEM_ID
MRP_ITEM_SUPPLIERS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MRP_RELIEF_INTERFACE.INVENTORY_ITEM_ID
MRP_RELIEF_INTERFACE.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MRP_SALES_ORDER_UPDATES.BASE_MODEL_ID
MRP_SALES_ORDER_UPDATES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MRP_SALES_ORDER_UPDATES.INVENTORY_ITEM_ID
MRP_SALES_ORDER_UPDATES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MRP_SCHEDULE_INTERFACE.INVENTORY_ITEM_ID
MRP_SCHEDULE_INTERFACE.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MRP_SCHEDULE_ITEMS.INVENTORY_ITEM_ID
MRP_SCHEDULE_ITEMS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MRP_SUPPLIER_CAPACITIES.INVENTORY_ITEM_ID
MRP_SUPPLIER_CAPACITIES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MRP_SUPPLIER_FLEX_FENCES.INVENTORY_ITEM_ID
MRP_SUPPLIER_FLEX_FENCES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MRP_SYSTEM_ITEMS.INVENTORY_ITEM_ID
MRP_SYSTEM_ITEMS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_ABC_COMPILES.INVENTORY_ITEM_ID
MTL_ABC_COMPILES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_CATALOG_SEARCH_ITEMS.INVENTORY_ITEM_ID
MTL_CATALOG_SEARCH_ITEMS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_CC_ENTRIES_INTERFACE.INVENTORY_ITEM_ID
MTL_CC_ENTRIES_INTERFACE.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_CROSS_REFERENCES.INVENTORY_ITEM_ID
MTL_CROSS_REFERENCES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_CST_ACTUAL_COST_DETAILS.INVENTORY_ITEM_ID
MTL_CST_ACTUAL_COST_DETAILS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_CST_TXN_COST_DETAILS.INVENTORY_ITEM_ID
MTL_CST_TXN_COST_DETAILS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_CUSTOMER_ITEM_XREFS.INVENTORY_ITEM_ID
MTL_CUSTOMER_ITEM_XREFS.MASTER_ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_CYCLE_COUNT_ENTRIES.INVENTORY_ITEM_ID
MTL_CYCLE_COUNT_ENTRIES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_DEMAND.INVENTORY_ITEM_ID
MTL_DEMAND.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_DEMAND.DUPLICATED_CONFIG_ITEM_ID
MTL_DEMAND.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_DEMAND_HISTORIES.INVENTORY_ITEM_ID
MTL_DEMAND_HISTORIES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_DEMAND_INTERFACE.INVENTORY_ITEM_ID
MTL_DEMAND_INTERFACE.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_EAM_ASSET_ACTIVITIES.ASSET_ACTIVITY_ID
MTL_EAM_ASSET_ACTIVITIES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_EAM_ASSET_ACTIVITIES.INVENTORY_ITEM_ID
MTL_EAM_ASSET_ACTIVITIES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_EAM_ASSET_ATTR_GROUPS.INVENTORY_ITEM_ID
MTL_EAM_ASSET_ATTR_GROUPS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_ITEM_CATEGORIES.INVENTORY_ITEM_ID
MTL_ITEM_CATEGORIES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_ITEM_LOC_DEFAULTS.INVENTORY_ITEM_ID
MTL_ITEM_LOC_DEFAULTS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_ITEM_REVISIONS_B.INVENTORY_ITEM_ID
MTL_ITEM_REVISIONS_B.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_ITEM_SUB_DEFAULTS.INVENTORY_ITEM_ID
MTL_ITEM_SUB_DEFAULTS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_ITEM_SUB_INVENTORIES.INVENTORY_ITEM_ID
MTL_ITEM_SUB_INVENTORIES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_KANBAN_CARDS.INVENTORY_ITEM_ID
MTL_KANBAN_CARDS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_KANBAN_CARD_ACTIVITY.INVENTORY_ITEM_ID
MTL_KANBAN_CARD_ACTIVITY.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_KANBAN_PULL_SEQUENCES.INVENTORY_ITEM_ID
MTL_KANBAN_PULL_SEQUENCES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_LOT_NUMBERS.INVENTORY_ITEM_ID
MTL_LOT_NUMBERS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_MATERIAL_TRANSACTIONS.INVENTORY_ITEM_ID
MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_MATERIAL_TRANSACTIONS_TEMP.INVENTORY_ITEM_ID
MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_MFG_PART_NUMBERS.INVENTORY_ITEM_ID
MTL_MFG_PART_NUMBERS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_ONHAND_QUANTITIES.INVENTORY_ITEM_ID
MTL_ONHAND_QUANTITIES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_ONHAND_QUANTITY_TEMP.INVENTORY_ITEM_ID
MTL_ONHAND_QUANTITY_TEMP.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_PENDING_ITEM_STATUS.INVENTORY_ITEM_ID
MTL_PENDING_ITEM_STATUS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_PHYSICAL_ADJUSTMENTS.INVENTORY_ITEM_ID
MTL_PHYSICAL_ADJUSTMENTS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_PHYSICAL_INVENTORY_TAGS.INVENTORY_ITEM_ID
MTL_PHYSICAL_INVENTORY_TAGS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_RELATED_ITEMS.INVENTORY_ITEM_ID
MTL_RELATED_ITEMS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_RELATED_ITEMS.RELATED_ITEM_ID
MTL_RELATED_ITEMS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_REPLENISH_LINES.INVENTORY_ITEM_ID
MTL_REPLENISH_LINES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_REPLENISH_LINES_INT.INVENTORY_ITEM_ID
MTL_REPLENISH_LINES_INT.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_RESERVATIONS.INVENTORY_ITEM_ID
MTL_RESERVATIONS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_RESERVATIONS_INTERFACE.INVENTORY_ITEM_ID
MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_SAFETY_STOCKS.INVENTORY_ITEM_ID
MTL_SAFETY_STOCKS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_SERIAL_NUMBERS.INVENTORY_ITEM_ID
MTL_SERIAL_NUMBERS.CURRENT_ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_SHORT_CHK_TEMP.INVENTORY_ITEM_ID
MTL_SHORT_CHK_TEMP.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_SO_RMA_INTERFACE.INVENTORY_ITEM_ID
MTL_SO_RMA_INTERFACE.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_SO_RMA_RECEIPTS.INVENTORY_ITEM_ID
MTL_SO_RMA_RECEIPTS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_SUPPLY_DEMAND_TEMP.INVENTORY_ITEM_ID
MTL_SUPPLY_DEMAND_TEMP.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_SUPPLY.ITEM_ID
MTL_SUPPLY.TO_ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_SYSTEM_ITEMS_B.ENGINEERING_ITEM_ID
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_SYSTEM_ITEMS_B.BASE_ITEM_ID
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_SYSTEM_ITEMS_B.BASE_WARRANTY_SERVICE_ID
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_SYSTEM_ITEMS_B.PRODUCT_FAMILY_ITEM_ID
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_SYSTEM_ITEMS_TL.INVENTORY_ITEM_ID
MTL_SYSTEM_ITEMS_TL.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_TRANSACTIONS_INTERFACE.INVENTORY_ITEM_ID
MTL_TRANSACTIONS_INTERFACE.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_TRANSACTION_ACCOUNTS.INVENTORY_ITEM_ID
MTL_TRANSACTION_ACCOUNTS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_TXN_REQUEST_LINES.INVENTORY_ITEM_ID
MTL_TXN_REQUEST_LINES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_USER_DEMAND.INVENTORY_ITEM_ID
MTL_USER_DEMAND.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_USER_SUPPLY.INVENTORY_ITEM_ID
MTL_USER_SUPPLY.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
OKL_ASSET_RETURNS_ALL_B.IMR_ID
OKL_ASSET_RETURNS_ALL_B.ORG_ID |
MTL_SYSTEM_ITEMS_B |
OKL_FE_EO_TERM_OBJECTS.INVENTORY_ITEM_ID
OKL_FE_EO_TERM_OBJECTS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
OKL_FE_ITEM_RESIDUAL_ALL.INVENTORY_ITEM_ID
OKL_FE_ITEM_RESIDUAL_ALL.ORG_ID |
MTL_SYSTEM_ITEMS_B |
OKL_FE_RESI_CAT_OBJECTS.INVENTORY_ITEM_ID
OKL_FE_RESI_CAT_OBJECTS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
OKL_SUBSIDY_CRITERIA.INVENTORY_ITEM_ID
OKL_SUBSIDY_CRITERIA.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
OZF_RETAIL_PRICE_POINTS.INVENTORY_ITEM_ID
OZF_RETAIL_PRICE_POINTS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
PJM_BORROW_TRANSACTIONS.INVENTORY_ITEM_ID
PJM_BORROW_TRANSACTIONS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
PJM_DEFAULT_TASKS.INVENTORY_ITEM_ID
PJM_DEFAULT_TASKS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
PJM_DEFAULT_TASKS.ASSEMBLY_ITEM_ID
PJM_DEFAULT_TASKS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
PJM_UNIT_NUMBERS.END_ITEM_ID
PJM_UNIT_NUMBERS.MASTER_ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
QA_RESULTS.ASSET_GROUP_ID
QA_RESULTS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
QA_RESULTS.ASSET_ACTIVITY_ID
QA_RESULTS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
QA_RESULTS.ITEM_ID
QA_RESULTS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
WIP_COST_TXN_INTERFACE.PRIMARY_ITEM_ID
WIP_COST_TXN_INTERFACE.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
WIP_DISCRETE_JOBS.PRIMARY_ITEM_ID
WIP_DISCRETE_JOBS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
WIP_DISCRETE_JOBS.BOM_REFERENCE_ID
WIP_DISCRETE_JOBS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
WIP_DISCRETE_JOBS.ROUTING_REFERENCE_ID
WIP_DISCRETE_JOBS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
WIP_ENTITIES.PRIMARY_ITEM_ID
WIP_ENTITIES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
WIP_FLOW_SCHEDULES.PRIMARY_ITEM_ID
WIP_FLOW_SCHEDULES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
WIP_MOVE_TXN_INTERFACE.PRIMARY_ITEM_ID
WIP_MOVE_TXN_INTERFACE.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
WIP_REPETITIVE_ITEMS.PRIMARY_ITEM_ID
WIP_REPETITIVE_ITEMS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
WIP_REQUIREMENT_OPERATIONS.INVENTORY_ITEM_ID
WIP_REQUIREMENT_OPERATIONS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
WIP_TEMP_REPORTS.INVENTORY_ITEM_ID
WIP_TEMP_REPORTS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
WIP_TRANSACTIONS.PRIMARY_ITEM_ID
WIP_TRANSACTIONS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
WMS_EXCEPTIONS.INVENTORY_ITEM_ID
WMS_EXCEPTIONS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
WMS_LICENSE_PLATE_NUMBERS.INVENTORY_ITEM_ID
WMS_LICENSE_PLATE_NUMBERS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
WMS_LPN_CONTENTS.INVENTORY_ITEM_ID
WMS_LPN_CONTENTS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
WMS_LPN_HISTORIES.INVENTORY_ITEM_ID
WMS_LPN_HISTORIES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
WMS_LPN_INTERFACE.INVENTORY_ITEM_ID
WMS_LPN_INTERFACE.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
WMS_SHIPPING_TRANSACTION_TEMP.INVENTORY_ITEM_ID
WMS_SHIPPING_TRANSACTION_TEMP.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
WMS_SKIP_TASK_EXCEPTIONS.INVENTORY_ITEM_ID
WMS_SKIP_TASK_EXCEPTIONS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
WSH_PACKED_CONTAINERS.CONTAINER_INVENTORY_ITEM_ID
WSH_PACKED_CONTAINERS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
XDP_ORDER_LINE_ITEMS.INVENTORY_ITEM_ID
XDP_ORDER_LINE_ITEMS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
XDP_SERVICE_VAL_ACTS.INVENTORY_ITEM_ID
XDP_SERVICE_VAL_ACTS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
XNC_FESW_REST_B.INVENTORY_ITEM_ID
XNC_FESW_REST_B.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
XNC_ITEM_ACTIONS_B.INVENTORY_ITEM_ID
XNC_ITEM_ACTIONS_B.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
ZX_EXCEPTIONS.PRODUCT_ID | MTL_SYSTEM_ITEMS_B |
ZX_EXEMPTIONS.PRODUCT_ID | MTL_SYSTEM_ITEMS_B |
INV.MTL_SYSTEM_ITEMS_B does not reference any database object
INV.MTL_SYSTEM_ITEMS_B is referenced by following:
Description: | Euro as a Functional Currency Archive |
---|
INV.MTL_SYSTEM_ITEMS_B_EFC does not reference any database object
INV.MTL_SYSTEM_ITEMS_B_EFC is referenced by following:
Description: | Inventory Items Open Interface table |
---|
INV.MTL_SYSTEM_ITEMS_INTERFACE does not reference any database object
INV.MTL_SYSTEM_ITEMS_INTERFACE is referenced by following:
Description: | Translations table table holding item descriptions in multiple languages |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_SYSTEM_ITEMS_TL.INVENTORY_ITEM_ID
MTL_SYSTEM_ITEMS_TL.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
INV.MTL_SYSTEM_ITEMS_TL does not reference any database object
INV.MTL_SYSTEM_ITEMS_TL is referenced by following:
Description: | Gateway for externally generated material transactions |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_TRANSACTIONS_INTERFACE.DISTRIBUTION_ACCOUNT_ID | GL_CODE_COMBINATIONS |
MTL_TRANSACTIONS_INTERFACE.INVENTORY_ITEM_ID
MTL_TRANSACTIONS_INTERFACE.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_TRANSACTIONS_INTERFACE.TRANSPORTATION_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_TRANSACTIONS_INTERFACE.LOCATOR_ID
MTL_TRANSACTIONS_INTERFACE.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_TRANSACTIONS_INTERFACE.TRANSFER_LOCATOR
MTL_TRANSACTIONS_INTERFACE.TRANSFER_ORGANIZATION |
MTL_ITEM_LOCATIONS |
MTL_TRANSACTIONS_INTERFACE.SUBINVENTORY_CODE
MTL_TRANSACTIONS_INTERFACE.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_TRANSACTIONS_INTERFACE.TRANSFER_SUBINVENTORY
MTL_TRANSACTIONS_INTERFACE.TRANSFER_ORGANIZATION |
MTL_SECONDARY_INVENTORIES |
MTL_TRANSACTIONS_INTERFACE.SCHEDULE_NUMBER
MTL_TRANSACTIONS_INTERFACE.ORGANIZATION_ID |
WIP_FLOW_SCHEDULES |
INV.MTL_TRANSACTIONS_INTERFACE does not reference any database object
INV.MTL_TRANSACTIONS_INTERFACE is referenced by following:
Description: | Material transaction distributions |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_TRANSACTION_ACCOUNTS.REFERENCE_ACCOUNT | GL_CODE_COMBINATIONS |
MTL_TRANSACTION_ACCOUNTS.ENCUMBRANCE_TYPE_ID | GL_ENCUMBRANCE_TYPES |
MTL_TRANSACTION_ACCOUNTS.REPETITIVE_SCHEDULE_ID | WIP_REPETITIVE_SCHEDULES |
MTL_TRANSACTION_ACCOUNTS.TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
MTL_TRANSACTION_ACCOUNTS.ORGANIZATION_ID
MTL_TRANSACTION_ACCOUNTS.GL_BATCH_ID |
ORG_GL_BATCHES |
MTL_TRANSACTION_ACCOUNTS.INVENTORY_ITEM_ID
MTL_TRANSACTION_ACCOUNTS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_TRANSACTION_ACCOUNTS.TRANSACTION_SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
MTL_TRANSACTION_ACCOUNTS.RESOURCE_ID | BOM_RESOURCES |
MTL_TRANSACTION_ACCOUNTS.COST_ELEMENT_ID | CST_COST_ELEMENTS |
MTL_TRANSACTION_ACCOUNTS.ACTIVITY_ID | CST_ACTIVITIES |
MTL_TRANSACTION_ACCOUNTS.CURRENCY_CODE | FND_CURRENCIES |
INV.MTL_TRANSACTION_ACCOUNTS does not reference any database object
INV.MTL_TRANSACTION_ACCOUNTS is referenced by following:
Description: | Euro as a Functional Currency Archive |
---|
INV.MTL_TRANSACTION_ACCOUNTS_EFC does not reference any database object
INV.MTL_TRANSACTION_ACCOUNTS_EFC is referenced by following:
Description: | Intercompany Transaction Flow |
---|
INV.MTL_TRANSACTION_FLOW_HEADERS does not reference any database object
INV.MTL_TRANSACTION_FLOW_HEADERS is referenced by following:
Description: | Inter-company Transaction flow lines |
---|
INV.MTL_TRANSACTION_FLOW_LINES does not reference any database object
INV.MTL_TRANSACTION_FLOW_LINES is referenced by following:
Description: | Temporary lot storage for transaction processor |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_TRANSACTION_LOTS_INTERFACE.SERIAL_TRANSACTION_TEMP_ID | MTL_SERIAL_NUMBERS_INTERFACE |
INV.MTL_TRANSACTION_LOTS_INTERFACE does not reference any database object
INV.MTL_TRANSACTION_LOTS_INTERFACE is referenced by following:
Description: | Temporary lot numbers holding table |
---|
INV.MTL_TRANSACTION_LOTS_TEMP does not reference any database object
INV.MTL_TRANSACTION_LOTS_TEMP is referenced by following:
Description: | Transaction lot numbers |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_TRANSACTION_LOT_NUMBERS.TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
MTL_TRANSACTION_LOT_NUMBERS.TRANSACTION_SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
MTL_TRANSACTION_LOT_NUMBERS.INVENTORY_ITEM_ID
MTL_TRANSACTION_LOT_NUMBERS.ORGANIZATION_ID MTL_TRANSACTION_LOT_NUMBERS.LOT_NUMBER |
MTL_LOT_NUMBERS |
INV.MTL_TRANSACTION_LOT_NUMBERS does not reference any database object
INV.MTL_TRANSACTION_LOT_NUMBERS is referenced by following:
Description: | Inventory Transaction Reasons Table |
---|
Foreign Key Column | Foreign Table |
---|---|
CST_WRITE_OFFS.REASON_ID | MTL_TRANSACTION_REASONS |
EAM_OP_COMPLETION_TXNS.REASON_ID | MTL_TRANSACTION_REASONS |
MTL_CC_ENTRIES_INTERFACE.TRANSACTION_REASON_ID | MTL_TRANSACTION_REASONS |
MTL_CYCLE_COUNT_ENTRIES.TRANSACTION_REASON_ID | MTL_TRANSACTION_REASONS |
MTL_MATERIAL_STATUS_HISTORY.UPDATE_REASON_ID | MTL_TRANSACTION_REASONS |
MTL_MATERIAL_TRANSACTIONS.REASON_ID | MTL_TRANSACTION_REASONS |
MTL_TXN_REQUEST_LINES.REASON_ID | MTL_TRANSACTION_REASONS |
PO_ACCRUAL_RECONCILE_TEMP_ALL.REASON_ID | MTL_TRANSACTION_REASONS |
PO_ACCRUAL_WRITE_OFFS_ALL.REASON_ID | MTL_TRANSACTION_REASONS |
RCV_SHIPMENT_LINES.REASON_ID | MTL_TRANSACTION_REASONS |
RCV_TRANSACTIONS.REASON_ID | MTL_TRANSACTION_REASONS |
RCV_TRANSACTIONS_INTERFACE.REASON_ID | MTL_TRANSACTION_REASONS |
WIP_COST_TXN_INTERFACE.REASON_ID | MTL_TRANSACTION_REASONS |
WIP_MOVE_TRANSACTIONS.REASON_ID | MTL_TRANSACTION_REASONS |
WIP_MOVE_TXN_INTERFACE.REASON_ID | MTL_TRANSACTION_REASONS |
WIP_TRANSACTIONS.REASON_ID | MTL_TRANSACTION_REASONS |
WMS_EXCEPTIONS.REASON_ID | MTL_TRANSACTION_REASONS |
WMS_SKIP_TASK_EXCEPTIONS.REASON_ID | MTL_TRANSACTION_REASONS |
WSM_LOT_MOVE_TXN_INTERFACE.REASON_ID | MTL_TRANSACTION_REASONS |
WSM_LOT_SPLIT_MERGES.REASON_ID | MTL_TRANSACTION_REASONS |
WSM_LOT_SPLIT_MERGES_INTERFACE.REASON_ID | MTL_TRANSACTION_REASONS |
WSM_SPLIT_MERGE_TXN_INTERFACE.REASON_ID | MTL_TRANSACTION_REASONS |
WSM_SPLIT_MERGE_TRANSACTIONS.REASON_ID | MTL_TRANSACTION_REASONS |
INV.MTL_TRANSACTION_REASONS does not reference any database object
INV.MTL_TRANSACTION_REASONS is referenced by following:
Description: | Inventory Transaction Types Table |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_TRANSACTION_TYPES.TRANSACTION_SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
Foreign Key Column | Foreign Table |
---|---|
AHL_WORKORDER_MTL_TXNS.TRANSACTION_TYPE_ID | MTL_TRANSACTION_TYPES |
CSP_USAGE_HISTORIES.TRANSACTION_TYPE_ID | MTL_TRANSACTION_TYPES |
EAM_JOB_COMPLETION_TXNS.TRANSACTION_TYPE | MTL_TRANSACTION_TYPES |
EAM_OP_COMPLETION_TXNS.TRANSACTION_TYPE | MTL_TRANSACTION_TYPES |
JAI_CMN_TRANSACTIONS_T.TRANSACTION_TYPE_ID | MTL_TRANSACTION_TYPES |
JAI_MTL_TRXS.TRANSACTION_TYPE_ID | MTL_TRANSACTION_TYPES |
JAI_PO_OSP_CENVAT_HDRS.TRANSACTION_TYPE_ID | MTL_TRANSACTION_TYPES |
MTL_MATERIAL_TRANSACTIONS.TRANSACTION_TYPE_ID | MTL_TRANSACTION_TYPES |
MTL_STATUS_TRANSACTION_CONTROL.TRANSACTION_TYPE_ID | MTL_TRANSACTION_TYPES |
MTL_TXN_REQUEST_HEADERS.TRANSACTION_TYPE_ID | MTL_TRANSACTION_TYPES |
MTL_TXN_REQUEST_LINES.TRANSACTION_TYPE_ID | MTL_TRANSACTION_TYPES |
INV.MTL_TRANSACTION_TYPES does not reference any database object
INV.MTL_TRANSACTION_TYPES is referenced by following:
Description: |
---|
INV.MTL_TRANSFER_TEMP does not reference any database object
INV.MTL_TRANSFER_TEMP is referenced by following:
Description: | Table MTL_TRANS_REASON_SECURITY, includes the items details for Regulatory Items with regard to the Convergence model |
---|
INV.MTL_TRANS_REASON_SECURITY does not reference any database object
INV.MTL_TRANS_REASON_SECURITY is referenced by following:
Description: |
---|
INV.MTL_TXNS_HISTORY does not reference any database object
INV.MTL_TXNS_HISTORY is referenced by following:
Description: | Stores transaction cost by element and by level for transactions to be imported through the transaction interface |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_TXN_COST_DET_INTERFACE.COST_ELEMENT_ID | CST_COST_ELEMENTS |
INV.MTL_TXN_COST_DET_INTERFACE does not reference any database object
INV.MTL_TXN_COST_DET_INTERFACE is referenced by following:
Description: | Move Order headers table |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_TXN_REQUEST_HEADERS.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_TXN_REQUEST_HEADERS.FROM_SUBINVENTORY_CODE
MTL_TXN_REQUEST_HEADERS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_TXN_REQUEST_HEADERS.TO_SUBINVENTORY_CODE
MTL_TXN_REQUEST_HEADERS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_TXN_REQUEST_HEADERS.TO_ACCOUNT_ID | GL_CODE_COMBINATIONS |
MTL_TXN_REQUEST_HEADERS.TRANSACTION_TYPE_ID | MTL_TRANSACTION_TYPES |
Foreign Key Column | Foreign Table |
---|---|
CSP_MOVEORDER_HEADERS.HEADER_ID | MTL_TXN_REQUEST_HEADERS |
CSP_MOVEORDER_LINES.HEADER_ID | MTL_TXN_REQUEST_HEADERS |
MTL_KANBAN_CARD_ACTIVITY.DOCUMENT_HEADER_ID | MTL_TXN_REQUEST_HEADERS |
MTL_TXN_REQUEST_LINES.HEADER_ID | MTL_TXN_REQUEST_HEADERS |
INV.MTL_TXN_REQUEST_HEADERS does not reference any database object
INV.MTL_TXN_REQUEST_HEADERS is referenced by following:
Description: | Move order lines table |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_TXN_REQUEST_LINES.HEADER_ID | MTL_TXN_REQUEST_HEADERS |
MTL_TXN_REQUEST_LINES.SERIAL_NUMBER_START
MTL_TXN_REQUEST_LINES.INVENTORY_ITEM_ID MTL_TXN_REQUEST_LINES.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
MTL_TXN_REQUEST_LINES.SERIAL_NUMBER_END
MTL_TXN_REQUEST_LINES.INVENTORY_ITEM_ID MTL_TXN_REQUEST_LINES.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
MTL_TXN_REQUEST_LINES.REASON_ID | MTL_TRANSACTION_REASONS |
MTL_TXN_REQUEST_LINES.TO_ACCOUNT_ID | GL_CODE_COMBINATIONS |
MTL_TXN_REQUEST_LINES.REFERENCE_ID | MTL_KANBAN_CARDS |
MTL_TXN_REQUEST_LINES.TO_ORGANIZATION_ID | MTL_PARAMETERS |
MTL_TXN_REQUEST_LINES.TRANSACTION_TYPE_ID | MTL_TRANSACTION_TYPES |
MTL_TXN_REQUEST_LINES.TRANSACTION_SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
MTL_TXN_REQUEST_LINES.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_TXN_REQUEST_LINES.PICK_STRATEGY_ID | WMS_STRATEGIES_B |
MTL_TXN_REQUEST_LINES.PUT_AWAY_STRATEGY_ID | WMS_STRATEGIES_B |
MTL_TXN_REQUEST_LINES.INVENTORY_ITEM_ID
MTL_TXN_REQUEST_LINES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_TXN_REQUEST_LINES.INVENTORY_ITEM_ID
MTL_TXN_REQUEST_LINES.ORGANIZATION_ID MTL_TXN_REQUEST_LINES.REVISION |
MTL_ITEM_REVISIONS_B |
MTL_TXN_REQUEST_LINES.FROM_SUBINVENTORY_CODE
MTL_TXN_REQUEST_LINES.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_TXN_REQUEST_LINES.TO_SUBINVENTORY_CODE
MTL_TXN_REQUEST_LINES.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_TXN_REQUEST_LINES.INVENTORY_ITEM_ID
MTL_TXN_REQUEST_LINES.ORGANIZATION_ID MTL_TXN_REQUEST_LINES.LOT_NUMBER |
MTL_LOT_NUMBERS |
Foreign Key Column | Foreign Table |
---|---|
CSP_MOVEORDER_LINES.LINE_ID | MTL_TXN_REQUEST_LINES |
CSP_PACKLIST_LINES.LINE_ID | MTL_TXN_REQUEST_LINES |
CSP_PICKLIST_LINES.LINE_ID | MTL_TXN_REQUEST_LINES |
MTL_KANBAN_CARD_ACTIVITY.DOCUMENT_DETAIL_ID | MTL_TXN_REQUEST_LINES |
MTL_MATERIAL_TRANSACTIONS.MOVE_ORDER_LINE_ID | MTL_TXN_REQUEST_LINES |
MTL_MATERIAL_TRANSACTIONS_TEMP.MOVE_ORDER_LINE_ID | MTL_TXN_REQUEST_LINES |
WMS_TRANSACTIONS_TEMP.TRANSACTION_TEMP_ID | MTL_TXN_REQUEST_LINES |
WMS_TXN_CONTEXT_TEMP.LINE_ID | MTL_TXN_REQUEST_LINES |
INV.MTL_TXN_REQUEST_LINES does not reference any database object
INV.MTL_TXN_REQUEST_LINES is referenced by following:
Description: | Valid transaction source types |
---|
Foreign Key Column | Foreign Table |
---|---|
CST_MGD_IAL_INVALID_MMT.TRANSACTION_SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
MTL_DEMAND.DEMAND_SOURCE_TYPE | MTL_TXN_SOURCE_TYPES |
MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
MTL_RESERVATIONS.DEMAND_SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
MTL_RESERVATIONS.SUPPLY_SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
MTL_RESERVATIONS_INTERFACE.DEMAND_SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
MTL_RESERVATIONS_INTERFACE.TO_DEMAND_SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
MTL_RESERVATIONS_INTERFACE.SUPPLY_SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
MTL_RESERVATIONS_INTERFACE.TO_SUPPLY_SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
MTL_SERIAL_NUMBERS.LAST_TXN_SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
MTL_TRANSACTION_ACCOUNTS.TRANSACTION_SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
MTL_TRANSACTION_LOT_NUMBERS.TRANSACTION_SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
MTL_TRANSACTION_TYPES.TRANSACTION_SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
MTL_TXN_REQUEST_LINES.TRANSACTION_SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
MTL_UNIT_TRANSACTIONS.TRANSACTION_SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
MTL_USER_SUPPLY.SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
INV.MTL_TXN_SOURCE_TYPES does not reference any database object
INV.MTL_TXN_SOURCE_TYPES is referenced by following:
Description: | Unit of measure definitions |
---|
INV.MTL_UNITS_OF_MEASURE_TL does not reference any database object
INV.MTL_UNITS_OF_MEASURE_TL is referenced by following:
Description: | Serial number transactions |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_UNIT_TRANSACTIONS.LOCATOR_ID
MTL_UNIT_TRANSACTIONS.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
MTL_UNIT_TRANSACTIONS.TRANSACTION_ID | MTL_MATERIAL_TRANSACTIONS |
MTL_UNIT_TRANSACTIONS.SUBINVENTORY_CODE
MTL_UNIT_TRANSACTIONS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
MTL_UNIT_TRANSACTIONS.SERIAL_NUMBER
MTL_UNIT_TRANSACTIONS.INVENTORY_ITEM_ID MTL_UNIT_TRANSACTIONS.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
MTL_UNIT_TRANSACTIONS.TRANSACTION_SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
INV.MTL_UNIT_TRANSACTIONS does not reference any database object
INV.MTL_UNIT_TRANSACTIONS is referenced by following:
Description: | Unit of measure classes |
---|
INV.MTL_UOM_CLASSES_TL does not reference any database object
INV.MTL_UOM_CLASSES_TL is referenced by following:
Description: | Conversions between base units of two different classes |
---|
INV.MTL_UOM_CLASS_CONVERSIONS does not reference any database object
INV.MTL_UOM_CLASS_CONVERSIONS is referenced by following:
Description: | Unit of measure conversion table for both default and item specific conversions |
---|
INV.MTL_UOM_CONVERSIONS does not reference any database object
INV.MTL_UOM_CONVERSIONS is referenced by following:
Description: |
---|
INV.MTL_UOM_CONVERSIONS_ERES_GTMP does not reference any database object
INV.MTL_UOM_CONVERSIONS_ERES_GTMP is referenced by following:
Description: | Used exclusively for the item attribute copy form |
---|
INV.MTL_UPDATE_RECORDS_TEMP does not reference any database object
INV.MTL_UPDATE_RECORDS_TEMP is referenced by following:
Description: | External demand information to be considered in ATP |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_USER_DEMAND.INVENTORY_ITEM_ID
MTL_USER_DEMAND.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
INV.MTL_USER_DEMAND does not reference any database object
INV.MTL_USER_DEMAND is referenced by following:
Description: | External supply information to be considered in ATP |
---|
Foreign Key Column | Foreign Table |
---|---|
MTL_USER_SUPPLY.INVENTORY_ITEM_ID
MTL_USER_SUPPLY.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
MTL_USER_SUPPLY.ORGANIZATION_ID | MTL_PARAMETERS |
MTL_USER_SUPPLY.SOURCE_ID | PO_HEADERS_ALL |
MTL_USER_SUPPLY.SOURCE_ID | WIP_ENTITIES |
MTL_USER_SUPPLY.SOURCE_ID | GL_CODE_COMBINATIONS |
MTL_USER_SUPPLY.SOURCE_ID
MTL_USER_SUPPLY.ORGANIZATION_ID |
MTL_GENERIC_DISPOSITIONS |
MTL_USER_SUPPLY.SOURCE_TYPE_ID | MTL_TXN_SOURCE_TYPES |
INV.MTL_USER_SUPPLY does not reference any database object
INV.MTL_USER_SUPPLY is referenced by following:
Description: |
---|
INV.MTL_VMI_QUANTITIES_TEMP does not reference any database object
INV.MTL_VMI_QUANTITIES_TEMP is referenced by following:
Description: | Organization access rules table |
---|
Foreign Key Column | Foreign Table |
---|---|
ORG_ACCESS.RESP_APPLICATION_ID
ORG_ACCESS.RESPONSIBILITY_ID |
FND_RESPONSIBILITY |
INV.ORG_ACCESS does not reference any database object
INV.ORG_ACCESS is referenced by following:
Description: | Organization accounting period definition table |
---|
Foreign Key Column | Foreign Table |
---|---|
ORG_ACCT_PERIODS.ORGANIZATION_ID | MTL_PARAMETERS |
ORG_ACCT_PERIODS.PERIOD_SET_NAME
ORG_ACCT_PERIODS.PERIOD_NAME |
GL_PERIODS |
Foreign Key Column | Foreign Table |
---|---|
CST_EAM_BALANCE_BY_ACCOUNTS.ACCT_PERIOD_ID
CST_EAM_BALANCE_BY_ACCOUNTS.ORGANIZATION_ID |
ORG_ACCT_PERIODS |
CST_MGD_INFL_ADJUSTED_COSTS.ACCT_PERIOD_ID
CST_MGD_INFL_ADJUSTED_COSTS.ORGANIZATION_ID |
ORG_ACCT_PERIODS |
CST_MGD_INFL_ADJ_PER_STATUSES.ACCT_PERIOD_ID
CST_MGD_INFL_ADJ_PER_STATUSES.ORGANIZATION_ID |
ORG_ACCT_PERIODS |
CST_MGD_INFL_TSF_ORG_ENTRIES.ACCT_PERIOD_ID
CST_MGD_INFL_TSF_ORG_ENTRIES.ORGANIZATION_ID |
ORG_ACCT_PERIODS |
EAM_JOB_COMPLETION_TXNS.ACCT_PERIOD_ID
EAM_JOB_COMPLETION_TXNS.ORGANIZATION_ID |
ORG_ACCT_PERIODS |
EAM_OP_COMPLETION_TXNS.ACCT_PERIOD_ID
EAM_OP_COMPLETION_TXNS.ORGANIZATION_ID |
ORG_ACCT_PERIODS |
MTL_MATERIAL_TRANSACTIONS.ACCT_PERIOD_ID
MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID |
ORG_ACCT_PERIODS |
MTL_MATERIAL_TRANSACTIONS_TEMP.ACCT_PERIOD_ID
MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID |
ORG_ACCT_PERIODS |
MTL_PERIOD_CG_SUMMARY.ACCT_PERIOD_ID
MTL_PERIOD_CG_SUMMARY.ORGANIZATION_ID |
ORG_ACCT_PERIODS |
MTL_PERIOD_SUMMARY.ACCT_PERIOD_ID
MTL_PERIOD_SUMMARY.ORGANIZATION_ID |
ORG_ACCT_PERIODS |
ORG_GL_BATCHES.ACCT_PERIOD_ID
ORG_GL_BATCHES.ORGANIZATION_ID |
ORG_ACCT_PERIODS |
WIP_COST_TXN_INTERFACE.ACCT_PERIOD_ID
WIP_COST_TXN_INTERFACE.ORGANIZATION_ID |
ORG_ACCT_PERIODS |
WIP_MOVE_TRANSACTIONS.ACCT_PERIOD_ID
WIP_MOVE_TRANSACTIONS.ORGANIZATION_ID |
ORG_ACCT_PERIODS |
WIP_MOVE_TXN_INTERFACE.ACCT_PERIOD_ID
WIP_MOVE_TXN_INTERFACE.ORGANIZATION_ID |
ORG_ACCT_PERIODS |
WIP_PERIOD_BALANCES.ACCT_PERIOD_ID
WIP_PERIOD_BALANCES.ORGANIZATION_ID |
ORG_ACCT_PERIODS |
WIP_TRANSACTIONS.ACCT_PERIOD_ID
WIP_TRANSACTIONS.ORGANIZATION_ID |
ORG_ACCT_PERIODS |
INV.ORG_ACCT_PERIODS does not reference any database object
INV.ORG_ACCT_PERIODS is referenced by following:
Description: | Freight codes |
---|
Foreign Key Column | Foreign Table |
---|---|
ORG_FREIGHT_TL.DISTRIBUTION_ACCOUNT | GL_CODE_COMBINATIONS |
ORG_FREIGHT_TL.ORGANIZATION_ID | MTL_PARAMETERS |
INV.ORG_FREIGHT_TL does not reference any database object
INV.ORG_FREIGHT_TL is referenced by following:
Description: | General Ledger transfer information for each batch |
---|
Foreign Key Column | Foreign Table |
---|---|
ORG_GL_BATCHES.ORGANIZATION_ID | MTL_PARAMETERS |
ORG_GL_BATCHES.ACCT_PERIOD_ID
ORG_GL_BATCHES.ORGANIZATION_ID |
ORG_ACCT_PERIODS |
Foreign Key Column | Foreign Table |
---|---|
MTL_TRANSACTION_ACCOUNTS.ORGANIZATION_ID
MTL_TRANSACTION_ACCOUNTS.GL_BATCH_ID |
ORG_GL_BATCHES |
WIP_TRANSACTION_ACCOUNTS.ORGANIZATION_ID
WIP_TRANSACTION_ACCOUNTS.GL_BATCH_ID |
ORG_GL_BATCHES |
INV.ORG_GL_BATCHES does not reference any database object
INV.ORG_GL_BATCHES is referenced by following:
Description: |
---|
INV.WMS_CARTONIZATION_TEMP1 does not reference any database object
INV.WMS_CARTONIZATION_TEMP1 is referenced by following:
APPS.ICX_MTL_DEMAND_SUMMARY_V is not referenced by any database object
APPS.INVBV_ABC_ASSGN_GROUP_CLASSES is not referenced by any database object
APPS.INVBV_ABC_ASSIGNMENTS is not referenced by any database object
APPS.INVBV_ABC_ASSIGNMENT_GROUPS is not referenced by any database object
APPS.INVBV_ABC_CLASSES is not referenced by any database object
APPS.INVBV_CUSTOMER_ITEMS is not referenced by any database object
APPS.INVBV_CUSTOMER_ITEM_XREFS is not referenced by any database object
APPS.INVBV_CYCLE_COUNTS is not referenced by any database object
APPS.INVBV_CYCLE_COUNT_ADJUSTMENTS is not referenced by any database object
APPS.INVBV_CYCLE_COUNT_CLASSES is not referenced by any database object
APPS.INVBV_CYCLE_COUNT_ITEMS is not referenced by any database object
APPS.INVBV_DESCRIPTIVE_ELEMENTS is not referenced by any database object
APPS.INVBV_EXTERNAL_ITEM_XREFS is not referenced by any database object
APPS.INVBV_EXT_ITEM_XREF_TYPES is not referenced by any database object
APPS.INVBV_FREIGHT_CARRIERS is not referenced by any database object
APPS.INVBV_FUTURE_ITEM_STATUSES is not referenced by any database object
APPS.INVBV_GL_ACCOUNT_ALIASES is not referenced by any database object
APPS.INVBV_INTERORG_LEAD_TIMES is not referenced by any database object
APPS.INVBV_INTERORG_SHIPPING_INFO is not referenced by any database object
APPS.INVBV_INVENTORY_DEMANDS is not referenced by any database object
APPS.INVBV_INVENTORY_LOCATORS is not referenced by any database object
APPS.INVBV_INVENTORY_ORGANIZATIONS is not referenced by any database object
APPS.INVBV_INVENTORY_RESERVATIONS is not referenced by any database object
APPS.INVBV_INVENTORY_SUPPLIES is not referenced by any database object
APPS.INVBV_INVENTORY_TXN_TYPES is not referenced by any database object
APPS.INVBV_INV_BY_PERIOD_AND_ITEM is not referenced by any database object
APPS.INVBV_ITEMS is not referenced by any database object
APPS.INVBV_ITEM_CATALOG_GROUPS is not referenced by any database object
APPS.INVBV_ITEM_CATEGORIES is not referenced by any database object
APPS.INVBV_ITEM_CATEGORY_ASGNS is not referenced by any database object
APPS.INVBV_ITEM_CATEGORY_TYPES is not referenced by any database object
APPS.INVBV_ITEM_CATEGORY_TYPE_ASGNS is not referenced by any database object
APPS.INVBV_ITEM_DESC_ELEMENT_VALUES is not referenced by any database object
APPS.INVBV_ITEM_RELATIONS is not referenced by any database object
APPS.INVBV_ITEM_REPLENISH_COUNTS is not referenced by any database object
APPS.INVBV_ITEM_REVISIONS is not referenced by any database object
APPS.INVBV_ITEM_STATUS_ATTR_VALUES is not referenced by any database object
APPS.INVBV_ITEM_STATUS_CODES is not referenced by any database object
APPS.INVBV_KANBAN_CARDS is not referenced by any database object
APPS.INVBV_KANBAN_CARD_ACTIVITIES is not referenced by any database object
APPS.INVBV_KANBAN_LOCATION_ITEMS is not referenced by any database object
APPS.INVBV_LOTS is not referenced by any database object
APPS.INVBV_LOT_TRANSACTIONS is not referenced by any database object
APPS.INVBV_MANUFACTURERS is not referenced by any database object
APPS.INVBV_MATERIAL_TRANSACTIONS is not referenced by any database object
APPS.INVBV_MFG_PART_NUMBERS is not referenced by any database object
APPS.INVBV_MOVEMENT_PARAMETERS is not referenced by any database object
APPS.INVBV_MOVEMENT_STATISTICS is not referenced by any database object
APPS.INVBV_MOVE_ORDERS_HEADERS is not referenced by any database object
APPS.INVBV_MOVE_ORDERS_LINES is not referenced by any database object
APPS.INVBV_ONHAND_BALANCES is not referenced by any database object
APPS.INVBV_ORGANIZATION_ITEMS is not referenced by any database object
APPS.INVBV_ORG_ITEM_REVISIONS is not referenced by any database object
APPS.INVBV_PHYSICAL_ADJUSTMENTS is not referenced by any database object
APPS.INVBV_PHYSICAL_INVENTORIES is not referenced by any database object
APPS.INVBV_PHYSICAL_INV_COUNTS is not referenced by any database object
APPS.INVBV_PRODUCT_FAMILY_MEMBERS is not referenced by any database object
APPS.INVBV_SERIAL_NUMBERS is not referenced by any database object
APPS.INVBV_SERIAL_NUMBER_TXNS is not referenced by any database object
APPS.INVBV_SHIP_METHODS is not referenced by any database object
APPS.INVBV_SUBINVENTORIES is not referenced by any database object
APPS.INVBV_SUB_REPLENISH_COUNTS is not referenced by any database object
APPS.INVBV_TRANSACTION_SOURCE_TYPES is not referenced by any database object
APPS.INVBV_UNITS_OF_MEASURE is not referenced by any database object
APPS.INVBV_UOM_CLASSES is not referenced by any database object
APPS.INVBV_UOM_CLASS_CONVERSIONS is not referenced by any database object
APPS.INVBV_UOM_CONVERSIONS is not referenced by any database object
APPS.INVFV_ABC_ASSGN_GROUP_CLASSES is not referenced by any database object
APPS.INVFV_ABC_ASSIGNMENTS is not referenced by any database object
APPS.INVFV_ABC_ASSIGNMENT_GROUPS is not referenced by any database object
APPS.INVFV_ABC_CLASSES is not referenced by any database object
APPS.INVFV_CUSTOMER_ITEMS is not referenced by any database object
APPS.INVFV_CUSTOMER_ITEM_XREFS is not referenced by any database object
APPS.INVFV_CYCLE_COUNTS is not referenced by any database object
APPS.INVFV_CYCLE_COUNT_ADJUSTMENTS is not referenced by any database object
APPS.INVFV_CYCLE_COUNT_CLASSES is not referenced by any database object
APPS.INVFV_CYCLE_COUNT_ITEMS is not referenced by any database object
APPS.INVFV_DESCRIPTIVE_ELEMENTS is not referenced by any database object
APPS.INVFV_EXTERNAL_ITEM_XREFS is not referenced by any database object
APPS.INVFV_EXT_ITEM_XREF_TYPES is not referenced by any database object
APPS.INVFV_FREIGHT_CARRIERS is not referenced by any database object
APPS.INVFV_FUTURE_ITEM_STATUSES is not referenced by any database object
APPS.INVFV_GL_ACCOUNT_ALIASES is not referenced by any database object
APPS.INVFV_INTERORG_LEAD_TIMES is not referenced by any database object
APPS.INVFV_INTERORG_SHIPPING_INFO is not referenced by any database object
APPS.INVFV_INVENTORY_DEMANDS is not referenced by any database object
APPS.INVFV_INVENTORY_LOCATORS is not referenced by any database object
APPS.INVFV_INVENTORY_ORGANIZATIONS is not referenced by any database object
APPS.INVFV_INVENTORY_RESERVATIONS is not referenced by any database object
APPS.INVFV_INVENTORY_SUPPLIES is not referenced by any database object
APPS.INVFV_INVENTORY_TXN_TYPES is not referenced by any database object
APPS.INVFV_INV_BY_PERIOD_AND_ITEM is not referenced by any database object
APPS.INVFV_ITEMS is not referenced by any database object
APPS.INVFV_ITEM_CATALOG_GROUPS is not referenced by any database object
APPS.INVFV_ITEM_CATEGORIES is not referenced by any database object
APPS.INVFV_ITEM_CATEGORY_ASGNS is not referenced by any database object
APPS.INVFV_ITEM_CATEGORY_TYPES is not referenced by any database object
APPS.INVFV_ITEM_CATEGORY_TYPE_ASGNS is not referenced by any database object
APPS.INVFV_ITEM_DESC_ELEMENT_VALUES is not referenced by any database object
APPS.INVFV_ITEM_RELATIONS is not referenced by any database object
APPS.INVFV_ITEM_REPLENISH_COUNTS is not referenced by any database object
APPS.INVFV_ITEM_REVISIONS is not referenced by any database object
APPS.INVFV_ITEM_STATUS_ATTR_VALUES is not referenced by any database object
APPS.INVFV_ITEM_STATUS_CODES is not referenced by any database object
APPS.INVFV_KANBAN_CARDS is not referenced by any database object
APPS.INVFV_KANBAN_CARD_ACTIVITIES is not referenced by any database object
APPS.INVFV_KANBAN_LOCATION_ITEMS is not referenced by any database object
APPS.INVFV_LOTS is not referenced by any database object
APPS.INVFV_LOT_TRANSACTIONS is not referenced by any database object
APPS.INVFV_MANUFACTURERS is not referenced by any database object
APPS.INVFV_MATERIAL_TRANSACTIONS is not referenced by any database object
APPS.INVFV_MFG_PART_NUMBERS is not referenced by any database object
APPS.INVFV_MOVEMENT_PARAMETERS is not referenced by any database object
APPS.INVFV_MOVE_ORDERS_HEADERS is not referenced by any database object
APPS.INVFV_MOVE_ORDERS_LINES is not referenced by any database object
APPS.INVFV_ONHAND_BALANCES is not referenced by any database object
APPS.INVFV_ORGANIZATION_ITEMS is not referenced by any database object
APPS.INVFV_ORG_ITEM_REVISIONS is not referenced by any database object
APPS.INVFV_PHYSICAL_ADJUSTMENTS is not referenced by any database object
APPS.INVFV_PHYSICAL_INVENTORIES is not referenced by any database object
APPS.INVFV_PHYSICAL_INV_COUNTS is not referenced by any database object
APPS.INVFV_PRODUCT_FAMILY_MEMBERS is not referenced by any database object
APPS.INVFV_SERIAL_NUMBERS is not referenced by any database object
APPS.INVFV_SERIAL_NUMBER_TXNS is not referenced by any database object
APPS.INVFV_SHIP_METHODS is not referenced by any database object
APPS.INVFV_SUBINVENTORIES is not referenced by any database object
APPS.INVFV_SUB_REPLENISH_COUNTS is not referenced by any database object
APPS.INVFV_TRANSACTION_SOURCE_TYPES is not referenced by any database object
APPS.INVFV_UNITS_OF_MEASURE is not referenced by any database object
APPS.INVFV_UOM_CLASSES is not referenced by any database object
APPS.INVFV_UOM_CLASS_CONVERSIONS is not referenced by any database object
APPS.INVFV_UOM_CONVERSIONS is not referenced by any database object
APPS.INV_3PL_CLIENTS_V is not referenced by any database object
APPS.INV_3PL_CONTRACTS_V is not referenced by any database object
APPS.INV_BIS_ITEM_COSTS is not referenced by any database object
APPS.INV_BIS_SUPPLY_CHAIN_INVENTORY is not referenced by any database object
APPS.INV_LOT_SERIAL_COLUMNS_V is not referenced by any database object
APPS.INV_LOT_SERIAL_CONTEXT_V is not referenced by any database object
APPS.INV_ORGANIZATION_INFO_V is not referenced by any database object
APPS.INV_ORGANIZATION_NAME_V is not referenced by any database object
APPS.MFG_LOOKUPS_V is not referenced by any database object
APPS.MTL_ABC_ASSGNMNT_GROUPS_ALL_V is not referenced by any database object
APPS.MTL_ABC_ASSGN_GROUP_CLASSES_V is not referenced by any database object
APPS.MTL_ABC_ASSIGNMENTS_V is not referenced by any database object
APPS.MTL_ABC_ASSIGNMENT_GROUPS_V is not referenced by any database object
APPS.MTL_ABC_CLASSES_ALL_V is not referenced by any database object
APPS.MTL_ABC_CLASSES_V is not referenced by any database object
APPS.MTL_ABC_CLASSES_VAL_V is not referenced by any database object
APPS.MTL_ABC_COMPILES_V is not referenced by any database object
APPS.MTL_ABC_COMPILE_HEADERS_V is not referenced by any database object
APPS.MTL_ACTIONS_VL is not referenced by any database object
APPS.MTL_ADJUSTMENT_LOTSERIAL_V is not referenced by any database object
APPS.MTL_ADJ_SYNC_WRAPPER_V is not referenced by any database object
APPS.MTL_AGREEMENT_DETAILS_V is not referenced by any database object
APPS.MTL_ATT_QTY_V is not referenced by any database object
APPS.MTL_AVAILABLE_INVENTORY_V is not referenced by any database object
APPS.MTL_BILLING_RULE_LINES_V is not referenced by any database object
APPS.MTL_BIS_INV_VALUE_V is not referenced by any database object
APPS.MTL_CATALOG_SEARCH_ITEMS_ALL_V is not referenced by any database object
APPS.MTL_CATEGORY_ACCOUNTS_V is not referenced by any database object
APPS.MTL_CATEGORY_GRANTS_V is not referenced by any database object
APPS.MTL_CATEGORY_SETS_ALL_V is not referenced by any database object
APPS.MTL_CATEGORY_SETS_V is not referenced by any database object
APPS.MTL_CATEGORY_SET_VALID_CATS_V is not referenced by any database object
APPS.MTL_CC_ENTRIES_INTERFACE_V is not referenced by any database object
APPS.MTL_CC_SCHEDULES_V is not referenced by any database object
APPS.MTL_CC_SUBINVENTORIES_ALL_V is not referenced by any database object
APPS.MTL_CLIENT_ITEMS_VL is not referenced by any database object
APPS.MTL_COMMODITY_CODES_ACTIVE_V is not referenced by any database object
APPS.MTL_COMMODITY_CODES_ALL_V is not referenced by any database object
APPS.MTL_CONSUMPTION_DEFINITION_V is not referenced by any database object
APPS.MTL_COUNTRY_ASSIGNMENTS_V is not referenced by any database object
APPS.MTL_CROSS_REFERENCES_SRW_V is not referenced by any database object
APPS.MTL_CROSS_REFERENCES_V is not referenced by any database object
APPS.MTL_CST_TXN_COST_DETAILS_V is not referenced by any database object
APPS.MTL_CUSTOMER_ITEMS_ACTIVE_V is not referenced by any database object
APPS.MTL_CYCLE_COUNT_CLASSES_ALL_V is not referenced by any database object
APPS.MTL_CYCLE_COUNT_CLASSES_V is not referenced by any database object
APPS.MTL_CYCLE_COUNT_ENTRIES_ALL_V is not referenced by any database object
APPS.MTL_CYCLE_COUNT_ENTRIES_V is not referenced by any database object
APPS.MTL_CYCLE_COUNT_HEADERS_ALL_V is not referenced by any database object
APPS.MTL_CYCLE_COUNT_HEADERS_V is not referenced by any database object
APPS.MTL_CYCLE_COUNT_HEADERS_VAL_V is not referenced by any database object
APPS.MTL_CYCLE_COUNT_ITEMS_ALL_V is not referenced by any database object
APPS.MTL_CYCLE_COUNT_ITEMS_V is not referenced by any database object
APPS.MTL_DEMAND_HISTORY_ITEMS_V is not referenced by any database object
APPS.MTL_DEMAND_HISTORY_V is not referenced by any database object
APPS.MTL_DEMAND_INTERFACE_V is not referenced by any database object
APPS.MTL_DEMAND_INTERFACE_VIEW is not referenced by any database object
APPS.MTL_DEMAND_V is not referenced by any database object
APPS.MTL_DESCR_ELEMENT_VALUES_V is not referenced by any database object
APPS.MTL_DESCR_ELEM_VAL_V is not referenced by any database object
APPS.MTL_EAM_ASSET_ACTIVITIES_V is not referenced by any database object
APPS.MTL_EAM_ASSET_ACTIVITIES_WB_V is not referenced by any database object
APPS.MTL_EAM_ASSET_ATTR_VALUES_V is not referenced by any database object
APPS.MTL_EAM_ASSET_NUMBERS_ALL_V is not referenced by any database object
APPS.MTL_EAM_ASSET_NUMBERS_V is not referenced by any database object
APPS.MTL_EAM_ASSET_NUM_INTERFACE_V is not referenced by any database object
APPS.MTL_EAM_ASSET_REBUILDS_DTLS_V is not referenced by any database object
APPS.MTL_EAM_ASSET_REBUILDS_V is not referenced by any database object
APPS.MTL_EAM_EQUIP_RESOURCES_V is not referenced by any database object
APPS.MTL_EAM_ITEMS_V is not referenced by any database object
APPS.MTL_EAM_JOBS_RESOURCES_V is not referenced by any database object
APPS.MTL_EAM_NETWORK_ASSETS_V is not referenced by any database object
APPS.MTL_EMPLOYEES_CURRENT_VIEW is not referenced by any database object
APPS.MTL_FISCAL_CAT_ACCOUNTS_V is not referenced by any database object
APPS.MTL_FORECAST_DATES_COST_V is not referenced by any database object
APPS.MTL_GENEALOGY_QA_DATA is not referenced by any database object
APPS.MTL_GRADE_CHANGE_ERV is not referenced by any database object
APPS.MTL_GRD_STS_HISTORY_V is not referenced by any database object
APPS.MTL_GROSS_REQ_COST_V is not referenced by any database object
APPS.MTL_GROUP_ATPS_VIEW is not referenced by any database object
APPS.MTL_GROUP_ITEM_ATPS_VIEW is not referenced by any database object
APPS.MTL_INTERCOMPANY_PARAMETERS_V is not referenced by any database object
APPS.MTL_INTERFACE_PROC_CONTROLS_V is not referenced by any database object
APPS.MTL_INV_TXNS_MFG_LOTS_V is not referenced by any database object
APPS.MTL_ITEM_ATTRIBUTES_V is not referenced by any database object
APPS.MTL_ITEM_ATTRIBUTE_NAMES_V is not referenced by any database object
APPS.MTL_ITEM_ATTRIBUTE_VALUES_V is not referenced by any database object
APPS.MTL_ITEM_ATTR_APPL_INST_V is not referenced by any database object
APPS.MTL_ITEM_ATTR_FIELDS_V is not referenced by any database object
APPS.MTL_ITEM_CATALOG_GROUPS_VL is not referenced by any database object
APPS.MTL_ITEM_CATEGORIES_VIEW is not referenced by any database object
APPS.MTL_ITEM_LOCATIONS_VIEW is not referenced by any database object
APPS.MTL_ITEM_LOT_QUANTITIES_VIEW is not referenced by any database object
APPS.MTL_ITEM_LOT_UOM_CONV_ERV is not referenced by any database object
APPS.MTL_ITEM_ORG_CATEG_V is not referenced by any database object
APPS.MTL_ITEM_ORG_REV_V is not referenced by any database object
APPS.MTL_ITEM_QUANTITIES_VIEW is not referenced by any database object
APPS.MTL_ITEM_REVISIONS_ALL_V is not referenced by any database object
APPS.MTL_ITEM_REVISIONS_ORG_VAL_V is not referenced by any database object
APPS.MTL_ITEM_REV_HIGHDATE_V is not referenced by any database object
APPS.MTL_ITEM_SUB_AST_TRK_VAL_V is not referenced by any database object
APPS.MTL_ITEM_SUB_AST_VAL_V is not referenced by any database object
APPS.MTL_ITEM_SUB_EXP_TRK_VAL_V is not referenced by any database object
APPS.MTL_ITEM_SUB_EXP_VAL_V is not referenced by any database object
APPS.MTL_ITEM_SUB_INVENTORIES_ALL_V is not referenced by any database object
APPS.MTL_ITEM_SUB_TRK_ALL_V is not referenced by any database object
APPS.MTL_ITEM_SUB_TRK_VAL_V is not referenced by any database object
APPS.MTL_ITEM_SUB_VAL_V is not referenced by any database object
APPS.MTL_ITEM_TEMPLATES_ALL_V is not referenced by any database object
APPS.MTL_ITEM_TEMPL_ATTRIBUTES_V is not referenced by any database object
APPS.MTL_ITEM_UOMS_VIEW is not referenced by any database object
APPS.MTL_KANBAN_CARDS_V is not referenced by any database object
APPS.MTL_KANBAN_CARD_ACTIVITY_V is not referenced by any database object
APPS.MTL_KANBAN_PULL_SEQUENCES_V is not referenced by any database object
APPS.MTL_LE_ECONOMIC_ZONES_V is not referenced by any database object
APPS.MTL_LOT_CONV_AUDITDETAILS_ERV is not referenced by any database object
APPS.MTL_LOT_CONV_AUDIT_DETAILS_V is not referenced by any database object
APPS.MTL_LOT_DEMAND_VAL_V is not referenced by any database object
APPS.MTL_LOT_ISSUES_VAL_V is not referenced by any database object
APPS.MTL_LOT_NUMBERS_ALL_V is not referenced by any database object
APPS.MTL_LOT_NUMBERS_ERV is not referenced by any database object
APPS.MTL_LOT_NUMBERS_SRW_V is not referenced by any database object
APPS.MTL_LOT_NUMBERS_VAL_V is not referenced by any database object
APPS.MTL_LOT_ONHAND_SUM_V is not referenced by any database object
APPS.MTL_LOT_SERIAL_DFF_ERV is not referenced by any database object
APPS.MTL_LOT_UOM_CLASS_CONV_V is not referenced by any database object
APPS.MTL_MATERIAL_STATUS_HIST_ERV is not referenced by any database object
APPS.MTL_MATERIAL_TXNS_TEMP_VIEW is not referenced by any database object
APPS.MTL_MATERIAL_TXNS_VAL_V is not referenced by any database object
APPS.MTL_MFG_BATCHES_SECURITY_V is not referenced by any database object
APPS.MTL_MFG_BATCHES_V is not referenced by any database object
APPS.MTL_MFG_COMPONENTS_V is not referenced by any database object
APPS.MTL_MFG_GENEALOGY_LOTATTR_V is not referenced by any database object
APPS.MTL_MFG_LOTS_TRANS_V is not referenced by any database object
APPS.MTL_MFG_PART_NUMBERS_ALL_V is not referenced by any database object
APPS.MTL_MFG_PRODUCTS_V is not referenced by any database object
APPS.MTL_MGD_INVPOS_DATA_SETS_V is not referenced by any database object
APPS.MTL_MOVEMENT_PARAMETERS_V is not referenced by any database object
APPS.MTL_MVT_STATS_RULE_SETS_VL is not referenced by any database object
APPS.MTL_MWB_GTMP_V is not referenced by any database object
APPS.MTL_NEGATIVE_VIEW is not referenced by any database object
APPS.MTL_OBJECT_GRANTS_V is not referenced by any database object
APPS.MTL_ONHAND_ATP is not referenced by any database object
APPS.MTL_ONHAND_DUMMY_V is not referenced by any database object
APPS.MTL_ONHAND_ITEMS_V is not referenced by any database object
APPS.MTL_ONHAND_LOCATOR_LOT_V is not referenced by any database object
APPS.MTL_ONHAND_LOCATOR_V is not referenced by any database object
APPS.MTL_ONHAND_LOT_V is not referenced by any database object
APPS.MTL_ONHAND_LPN_MWB_V is not referenced by any database object
APPS.MTL_ONHAND_LPN_V is not referenced by any database object
APPS.MTL_ONHAND_NET is not referenced by any database object
APPS.MTL_ONHAND_NEW_LPN_MWB_V is not referenced by any database object
APPS.MTL_ONHAND_NEW_LPN_V is not referenced by any database object
APPS.MTL_ONHAND_REV_V is not referenced by any database object
APPS.MTL_ONHAND_SERIAL_MWB_V is not referenced by any database object
APPS.MTL_ONHAND_SERIAL_V is not referenced by any database object
APPS.MTL_ONHAND_SUB_V is not referenced by any database object
APPS.MTL_ONHAND_SYNC_V is not referenced by any database object
APPS.MTL_ONHAND_TOTAL_MWB_V is not referenced by any database object
APPS.MTL_ONHAND_TOTAL_V is not referenced by any database object
APPS.MTL_OPSM_LOT_EXPORT_V is not referenced by any database object
APPS.MTL_OPSM_SYSTEM_ITEMS_V is not referenced by any database object
APPS.MTL_ORG_ASSIGN_V is not referenced by any database object
APPS.MTL_ORG_REPORT_TEMP_FK_V is not referenced by any database object
APPS.MTL_PAC_TXN_COST_DETAILS_V is not referenced by any database object
APPS.MTL_PARAMETERS_ALL_V is not referenced by any database object
APPS.MTL_PARAMETERS_VIEW is not referenced by any database object
APPS.MTL_PENDING_TXNS_MFG_LOTS_V is not referenced by any database object
APPS.MTL_PENDING_TXN_DETAILS_V is not referenced by any database object
APPS.MTL_PERIODS is not referenced by any database object
APPS.MTL_PERIOD_SUMMARY_V is not referenced by any database object
APPS.MTL_PHYSICAL_ADJUSTMENTS_V is not referenced by any database object
APPS.MTL_PHYSICAL_ADJUSTMENTS_VIEW is not referenced by any database object
APPS.MTL_PHYSICAL_INVENTORIES_V is not referenced by any database object
APPS.MTL_PHYSICAL_INVENTORY_TAGS_V is not referenced by any database object
APPS.MTL_PHYSICAL_SUBINVENTORIES_V is not referenced by any database object
APPS.MTL_PHY_ADJ_COST_V is not referenced by any database object
APPS.MTL_PHY_INV_TAGS_COST_V is not referenced by any database object
APPS.MTL_PRIMARY_UOMS_VV is not referenced by any database object
APPS.MTL_PROCURING_TXN_FLOW_HDRS_V is not referenced by any database object
APPS.MTL_PROCURING_TXN_FLOW_LINES_V is not referenced by any database object
APPS.MTL_PROJECT_DEMAND_VIEW is not referenced by any database object
APPS.MTL_QOH_ITEM_ALL_V is not referenced by any database object
APPS.MTL_QOH_ITEM_V is not referenced by any database object
APPS.MTL_QOH_LOCATOR_V is not referenced by any database object
APPS.MTL_QOH_LOC_ALL_V is not referenced by any database object
APPS.MTL_QOH_LOT_ALL_V is not referenced by any database object
APPS.MTL_QOH_LOT_V is not referenced by any database object
APPS.MTL_QOH_REV_ALL_V is not referenced by any database object
APPS.MTL_QOH_REV_V is not referenced by any database object
APPS.MTL_QOH_SUB_ALL_V is not referenced by any database object
APPS.MTL_QOH_SUB_V is not referenced by any database object
APPS.MTL_RCV_MWB_NEW_OH_V is not referenced by any database object
APPS.MTL_RCV_MWB_ONHAND_V is not referenced by any database object
APPS.MTL_RCV_SERIAL_MWB_OH_V is not referenced by any database object
APPS.MTL_RCV_SERIAL_OH_V is not referenced by any database object
APPS.MTL_RELATED_ITEMS_ALL_V is not referenced by any database object
APPS.MTL_RELATED_ITEMS_CUST_REF_V is not referenced by any database object
APPS.MTL_RELATED_ITEMS_PLN_INFO_V is not referenced by any database object
APPS.MTL_REPLENISH_HEADERS_VIEW is not referenced by any database object
APPS.MTL_REPLENISH_LINES_VIEW is not referenced by any database object
APPS.MTL_RESERVATIONS_ALL_V is not referenced by any database object
APPS.MTL_RESERVATIONS_INTERFACE_V is not referenced by any database object
APPS.MTL_RESERVATIONS_V is not referenced by any database object
APPS.MTL_RESERVATIONS_VIEW is not referenced by any database object
APPS.MTL_SAFETY_STOCKS_VIEW is not referenced by any database object
APPS.MTL_SECINV_QUANTITIES_VIEW is not referenced by any database object
APPS.MTL_SECONDARY_INVENTORIES_FK_V is not referenced by any database object
APPS.MTL_SECONDARY_LOCATORS_ALL_V is not referenced by any database object
APPS.MTL_SERIAL_NUMBERS_ALL_V is not referenced by any database object
APPS.MTL_SERIAL_NUMBERS_SRW_V is not referenced by any database object
APPS.MTL_SERIAL_NUMBERS_TEMP_ERV is not referenced by any database object
APPS.MTL_SERIAL_NUMBERS_VAL_V is not referenced by any database object
APPS.MTL_SERIAL_NUMBER_GEN_V is not referenced by any database object
APPS.MTL_SERVICE_CONTRACTS_V is not referenced by any database object
APPS.MTL_SHIPPING_NETWORK_VIEW is not referenced by any database object
APPS.MTL_SHORT_SUMMARY_V is not referenced by any database object
APPS.MTL_STATUS_CONTROL_V is not referenced by any database object
APPS.MTL_STAT_ATTRIB_VALUES_ALL_V is not referenced by any database object
APPS.MTL_STAT_TYPE_USAGES_V is not referenced by any database object
APPS.MTL_SUBINVENTORIES_ALL_V is not referenced by any database object
APPS.MTL_SUBINVENTORIES_VAL_V is not referenced by any database object
APPS.MTL_SUB_AST_TRK_VAL_V is not referenced by any database object
APPS.MTL_SUB_AST_VAL_V is not referenced by any database object
APPS.MTL_SUB_EXP_TRK_VAL_V is not referenced by any database object
APPS.MTL_SUB_EXP_VAL_V is not referenced by any database object
APPS.MTL_SUB_TRK_ALL_V is not referenced by any database object
APPS.MTL_SUMMARY_TEMP_V is not referenced by any database object
APPS.MTL_SUPPLIER_SITES_V is not referenced by any database object
APPS.MTL_SYSTEM_ITEMS_ER1_V is not referenced by any database object
APPS.MTL_SYSTEM_ITEMS_ER2_V is not referenced by any database object
APPS.MTL_SYSTEM_ITEMS_ER3_V is not referenced by any database object
APPS.MTL_SYSTEM_ITEMS_ER4_V is not referenced by any database object
APPS.MTL_SYSTEM_ITEMS_FVL is not referenced by any database object
APPS.MTL_TRANSACTIONS_INTERFACE_V is not referenced by any database object
APPS.MTL_TRANSACTIONS_TEMP_ALL_V is not referenced by any database object
APPS.MTL_TRANSACTION_DETAILS_V is not referenced by any database object
APPS.MTL_TRANSACTION_FLOWS_V is not referenced by any database object
APPS.MTL_TRANSACTION_FLOW_HEADERS_V is not referenced by any database object
APPS.MTL_TRANSACTION_FLOW_LINES_V is not referenced by any database object
APPS.MTL_TRANSACTION_LOTS_TEMP_V is not referenced by any database object
APPS.MTL_TRANSACTION_LOTS_VIEW is not referenced by any database object
APPS.MTL_TRANSACTION_LOT_VAL_V is not referenced by any database object
APPS.MTL_TRANSACTION_REASONS_ALL_V is not referenced by any database object
APPS.MTL_TRANSACTION_REASONS_VAL_V is not referenced by any database object
APPS.MTL_TRANSACT_INTERFACE_VIEW is not referenced by any database object
APPS.MTL_TRAN_TYPES_SYS_VAL_VIEW is not referenced by any database object
APPS.MTL_TRAN_TYPES_USER_VAL_VIEW is not referenced by any database object
APPS.MTL_TRX_TYPES_VIEW is not referenced by any database object
APPS.MTL_TXN_BACKORDERS_V is not referenced by any database object
APPS.MTL_TXN_REQUEST_HEADERS_V is not referenced by any database object
APPS.MTL_TXN_REQUEST_LINES_V is not referenced by any database object
APPS.MTL_TXN_SOURCE_TYPES_ALL_V is not referenced by any database object
APPS.MTL_TXN_SRC_FOR_TRAN_TYPE_VIEW is not referenced by any database object
APPS.MTL_UNITS_OF_MEASURE_AV is not referenced by any database object
APPS.MTL_UNITS_OF_MEASURE_VV is not referenced by any database object
APPS.MTL_UNIT_TRANSACTIONS_ALL_V is not referenced by any database object
APPS.MTL_UOM_CLASSES_AV is not referenced by any database object
APPS.MTL_UOM_CLASSES_VV is not referenced by any database object
APPS.MTL_UOM_CLASS_CONV_VAL_V is not referenced by any database object
APPS.MTL_UOM_CONVERSIONS_VAL_V is not referenced by any database object
APPS.MTL_UOM_CONVERSIONS_VIEW is not referenced by any database object
APPS.MTL_VENDOR_LOT_VIEW is not referenced by any database object
APPS.MTL_WORK_ORDER_HEADER_V is not referenced by any database object
APPS.ORG_ACCESS_V is not referenced by any database object
APPS.ORG_ACCT_PERIODS_V is not referenced by any database object
APPS.ORG_ENABLED_FREIGHT_VAL_V is not referenced by any database object
APPS.ORG_FREIGHT_CODE_ALL_V is not referenced by any database object
APPS.ORG_FREIGHT_CODE_VAL_V is not referenced by any database object
APPS.ORG_GL_BATCHES_V is not referenced by any database object
APPS.ORG_ORGANIZATION_DEFINITIONS2 is not referenced by any database object
APPS.ORG_ORGANIZATION_DEF_MRC_V is not referenced by any database object
APPS.ORG_ORG_DEFINITIONS_ALL_V is not referenced by any database object
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |