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: | This table describes the classification of inventory goods into class A, B, C class types. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_SYSTEM_ITEMS.ABC_CLASS
MSC_SYSTEM_ITEMS.SR_INSTANCE_ID |
MSC_ABC_CLASSES |
MSC.MSC_ABC_CLASSES does not reference any database object
MSC.MSC_ABC_CLASSES is referenced by following:
Description: | This table describes the allocations |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_ALLOCATIONS.PARTNER_ID | MSC_TRADING_PARTNERS |
MSC_ALLOCATIONS.PARTNER_SITE_ID | MSC_TRADING_PARTNER_SITES |
MSC_ALLOCATIONS.TIME_PHASE_ID | MSC_ALLOC_RULE_TIME_PHASES |
MSC.MSC_ALLOCATIONS does not reference any database object
MSC.MSC_ALLOCATIONS is referenced by following:
Description: | This table describes the allocation assignments |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_ALLOCATION_ASSIGNMENTS.SR_INSTANCE_ID
MSC_ALLOCATION_ASSIGNMENTS.RESOURCE_GROUP |
MSC_RESOURCE_GROUPS |
MSC_ALLOCATION_ASSIGNMENTS.ALLOCATION_RULE_NAME | MSC_ALLOCATION_RULES |
MSC.MSC_ALLOCATION_ASSIGNMENTS does not reference any database object
MSC.MSC_ALLOCATION_ASSIGNMENTS is referenced by following:
Description: | This table describes the allocation rules |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_ALLOCATION_ASSIGNMENTS.ALLOCATION_RULE_NAME | MSC_ALLOCATION_RULES |
MSC_ALLOC_RULE_TIME_PHASES.ALLOCATION_RULE_NAME | MSC_ALLOCATION_RULES |
MSC.MSC_ALLOCATION_RULES does not reference any database object
MSC.MSC_ALLOCATION_RULES is referenced by following:
Description: |
---|
MSC.MSC_ALLOC_DEMANDS does not reference any database object
MSC.MSC_ALLOC_DEMANDS is referenced by following:
Description: | This table describes the time-phased allocation rules |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_ALLOC_RULE_TIME_PHASES.ALLOCATION_RULE_NAME | MSC_ALLOCATION_RULES |
Foreign Key Column | Foreign Table |
---|---|
MSC_ALLOCATIONS.TIME_PHASE_ID | MSC_ALLOC_RULE_TIME_PHASES |
MSC.MSC_ALLOC_RULE_TIME_PHASES does not reference any database object
MSC.MSC_ALLOC_RULE_TIME_PHASES is referenced by following:
Description: |
---|
MSC.MSC_ALLOC_SUPPLIES does not reference any database object
MSC.MSC_ALLOC_SUPPLIES is referenced by following:
Description: | User selected criteria for 10SC Planner Workbench |
---|
MSC.MSC_AMONG_VALUES does not reference any database object
MSC.MSC_AMONG_VALUES is referenced by following:
Description: |
---|
MSC.MSC_ANALYSIS_AGGREGATE does not reference any database object
MSC.MSC_ANALYSIS_AGGREGATE is referenced by following:
Description: |
---|
MSC.MSC_ANALYSIS_QUERY does not reference any database object
MSC.MSC_ANALYSIS_QUERY is referenced by following:
Description: | Stores the Answers for Ask Oracle Questions |
---|
MSC.MSC_ANSWERS does not reference any database object
MSC.MSC_ANSWERS is referenced by following:
Description: |
---|
MSC.MSC_APCC_ITEM_D does not reference any database object
MSC.MSC_APCC_ITEM_D is referenced by following:
Description: | This tables stores the information of each connected Application instance. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_INSTANCE_ORGS.SR_INSTANCE_ID | MSC_APPS_INSTANCES |
MSC.MSC_APPS_INSTANCES does not reference any database object
MSC.MSC_APPS_INSTANCES is referenced by following:
Description: | This table stores the assignment of sourcing rules (or bills of distribution) to item, organization, category, or at the global level. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_PLANS.ASSIGNMENT_SET_ID | MSC_ASSIGNMENT_SETS |
MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID | MSC_ASSIGNMENT_SETS |
MSC.MSC_ASSIGNMENT_SETS does not reference any database object
MSC.MSC_ASSIGNMENT_SETS is referenced by following:
Description: |
---|
MSC.MSC_ATP_DETAIL_PEG_TEMP does not reference any database object
MSC.MSC_ATP_DETAIL_PEG_TEMP is referenced by following:
Description: | ATP related parameters storage |
---|
MSC.MSC_ATP_PARAMETERS does not reference any database object
MSC.MSC_ATP_PARAMETERS is referenced by following:
Description: |
---|
MSC.MSC_ATP_PEGGING does not reference any database object
MSC.MSC_ATP_PEGGING is referenced by following:
Description: |
---|
MSC.MSC_ATP_PEG_TEMP does not reference any database object
MSC.MSC_ATP_PEG_TEMP is referenced by following:
Description: |
---|
APPS.MSC_ATP_PLAN_SN does not reference any database object
APPS.MSC_ATP_PLAN_SN is referenced by following:
Description: | This table stores rules and options that are used in Available To Promise computation. |
---|
MSC.MSC_ATP_RULES does not reference any database object
MSC.MSC_ATP_RULES is referenced by following:
Description: |
---|
MSC.MSC_ATP_SUMMARY_RES does not reference any database object
MSC.MSC_ATP_SUMMARY_RES is referenced by following:
Description: |
---|
MSC.MSC_ATP_SUMMARY_SD does not reference any database object
MSC.MSC_ATP_SUMMARY_SD is referenced by following:
Description: |
---|
MSC.MSC_ATP_SUMMARY_SO does not reference any database object
MSC.MSC_ATP_SUMMARY_SO is referenced by following:
Description: |
---|
MSC.MSC_ATP_SUMMARY_SUP does not reference any database object
MSC.MSC_ATP_SUMMARY_SUP is referenced by following:
Description: | Available to promise information for master scheduled parts |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_AVAILABLE_TO_PROMISE.INVENTORY_ITEM_ID
MSC_AVAILABLE_TO_PROMISE.PLAN_ID MSC_AVAILABLE_TO_PROMISE.SR_INSTANCE_ID MSC_AVAILABLE_TO_PROMISE.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC.MSC_AVAILABLE_TO_PROMISE does not reference any database object
MSC.MSC_AVAILABLE_TO_PROMISE is referenced by following:
Description: | This table stores the set of resources required in an organization. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_BILL_OF_RESOURCES.PLAN_ID
MSC_BILL_OF_RESOURCES.ORGANIZATION_ID MSC_BILL_OF_RESOURCES.SR_INSTANCE_ID |
MSC_PLAN_ORGANIZATIONS |
Foreign Key Column | Foreign Table |
---|---|
MSC_BOR_REQUIREMENTS.BILL_OF_RESOURCES
MSC_BOR_REQUIREMENTS.PLAN_ID MSC_BOR_REQUIREMENTS.ORGANIZATION_ID MSC_BOR_REQUIREMENTS.SR_INSTANCE_ID |
MSC_BILL_OF_RESOURCES |
MSC.MSC_BILL_OF_RESOURCES does not reference any database object
MSC.MSC_BILL_OF_RESOURCES is referenced by following:
Description: | A business plan in this context is one of possibly many scenarios which set performance targets to particular values anticipated under that scenario. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_BIS_TARGETS.SR_INSTANCE_ID
MSC_BIS_TARGETS.BUSINESS_PLAN_ID |
MSC_BIS_BUSINESS_PLANS |
MSC.MSC_BIS_BUSINESS_PLANS does not reference any database object
MSC.MSC_BIS_BUSINESS_PLANS is referenced by following:
Description: | KPI Summary Table |
---|
MSC.MSC_BIS_INV_CAT_MV_TAB does not reference any database object
MSC.MSC_BIS_INV_CAT_MV_TAB is referenced by following:
Description: | KPI Summary Table |
---|
MSC.MSC_BIS_INV_DATE_MV_TAB does not reference any database object
MSC.MSC_BIS_INV_DATE_MV_TAB is referenced by following:
Description: | MSC_BIS_INV_DETAIL contains Inventory balance details collected from source applications. |
---|
MSC.MSC_BIS_INV_DETAIL does not reference any database object
MSC.MSC_BIS_INV_DETAIL is referenced by following:
Description: | MSC_BIS_PERFORMANCE_MEASURES contains business performance measures collected from source applications. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_BIS_TARGET_LEVELS.MEASURE_ID
MSC_BIS_TARGET_LEVELS.SR_INSTANCE_ID |
MSC_BIS_PERFORMANCE_MEASURES |
MSC.MSC_BIS_PERFORMANCE_MEASURES does not reference any database object
MSC.MSC_BIS_PERFORMANCE_MEASURES is referenced by following:
Description: | MSC_BIS_PERIODS stores periods between the calendar start date and end dates. |
---|
MSC.MSC_BIS_PERIODS does not reference any database object
MSC.MSC_BIS_PERIODS is referenced by following:
Description: | KPI Summary Table |
---|
MSC.MSC_BIS_RES_DATE_MV_TAB does not reference any database object
MSC.MSC_BIS_RES_DATE_MV_TAB is referenced by following:
Description: | MSC_BIS_RES_SUMMARY stores resource required hours and available hours for BIS reports. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_BIS_RES_SUMMARY.PLAN_ID
MSC_BIS_RES_SUMMARY.ORGANIZATION_ID MSC_BIS_RES_SUMMARY.RESOURCE_ID MSC_BIS_RES_SUMMARY.SR_INSTANCE_ID MSC_BIS_RES_SUMMARY.DEPARTMENT_ID |
MSC_DEPARTMENT_RESOURCES |
MSC.MSC_BIS_RES_SUMMARY does not reference any database object
MSC.MSC_BIS_RES_SUMMARY is referenced by following:
Description: | MSC_BIS_SUPPLIER_SUMMARY Stores BIS Supplier Summaruy Entries |
---|
MSC.MSC_BIS_SUPPLIER_SUMMARY does not reference any database object
MSC.MSC_BIS_SUPPLIER_SUMMARY is referenced by following:
Description: | MSC_BIS_TARGETS stores the target values for the BIS reports. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_BIS_TARGETS.TARGET_LEVEL_ID
MSC_BIS_TARGETS.SR_INSTANCE_ID |
MSC_BIS_TARGET_LEVELS |
MSC_BIS_TARGETS.SR_INSTANCE_ID
MSC_BIS_TARGETS.BUSINESS_PLAN_ID |
MSC_BIS_BUSINESS_PLANS |
MSC.MSC_BIS_TARGETS does not reference any database object
MSC.MSC_BIS_TARGETS is referenced by following:
Description: | MSC_BIS_TARGET_LEVELS contains different combinations of dimension levels to be applied simultaneously to get a performance indicator relevant to a particular reporting need. For example, if someone wants to know sales revenues broken down |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_BIS_TARGET_LEVELS.MEASURE_ID
MSC_BIS_TARGET_LEVELS.SR_INSTANCE_ID |
MSC_BIS_PERFORMANCE_MEASURES |
Foreign Key Column | Foreign Table |
---|---|
MSC_BIS_TARGETS.TARGET_LEVEL_ID
MSC_BIS_TARGETS.SR_INSTANCE_ID |
MSC_BIS_TARGET_LEVELS |
MSC.MSC_BIS_TARGET_LEVELS does not reference any database object
MSC.MSC_BIS_TARGET_LEVELS is referenced by following:
Description: | This table represents the Bills Of Material of an item created at source applications. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_BOMS.ASSEMBLY_ITEM_ID
MSC_BOMS.PLAN_ID MSC_BOMS.SR_INSTANCE_ID MSC_BOMS.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
Foreign Key Column | Foreign Table |
---|---|
MSC_BOM_COMPONENTS.SR_INSTANCE_ID
MSC_BOM_COMPONENTS.BILL_SEQUENCE_ID MSC_BOM_COMPONENTS.PLAN_ID |
MSC_BOMS |
MSC_PROCESS_EFFECTIVITY.SR_INSTANCE_ID
MSC_PROCESS_EFFECTIVITY.BILL_SEQUENCE_ID MSC_PROCESS_EFFECTIVITY.PLAN_ID |
MSC_BOMS |
MSC.MSC_BOMS does not reference any database object
MSC.MSC_BOMS is referenced by following:
Description: | Interface table that contains the BOM/BOD data before validation |
---|
MSC.MSC_BOM_BOD_INTERFACE does not reference any database object
MSC.MSC_BOM_BOD_INTERFACE is referenced by following:
Description: | This table stores Bill of material data for plans in Oracle Advanced Planning and Oracle Supply Chain Hub products. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_BOM_COMPONENTS.SR_INSTANCE_ID
MSC_BOM_COMPONENTS.BILL_SEQUENCE_ID MSC_BOM_COMPONENTS.PLAN_ID |
MSC_BOMS |
MSC_BOM_COMPONENTS.INVENTORY_ITEM_ID
MSC_BOM_COMPONENTS.PLAN_ID MSC_BOM_COMPONENTS.SR_INSTANCE_ID MSC_BOM_COMPONENTS.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
Foreign Key Column | Foreign Table |
---|---|
MSC_COMPONENT_SUBSTITUTES.BILL_SEQUENCE_ID
MSC_COMPONENT_SUBSTITUTES.COMPONENT_SEQUENCE_ID MSC_COMPONENT_SUBSTITUTES.SR_INSTANCE_ID MSC_COMPONENT_SUBSTITUTES.PLAN_ID |
MSC_BOM_COMPONENTS |
MSC_OPERATION_COMPONENTS.BILL_SEQUENCE_ID
MSC_OPERATION_COMPONENTS.COMPONENT_SEQUENCE_ID MSC_OPERATION_COMPONENTS.SR_INSTANCE_ID MSC_OPERATION_COMPONENTS.PLAN_ID |
MSC_BOM_COMPONENTS |
MSC.MSC_BOM_COMPONENTS does not reference any database object
MSC.MSC_BOM_COMPONENTS is referenced by following:
Description: | BOM Temp Table |
---|
MSC.MSC_BOM_TEMP does not reference any database object
MSC.MSC_BOM_TEMP is referenced by following:
Description: | This table stores the set of resources required in an organization for an item. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_BOR_REQUIREMENTS.BILL_OF_RESOURCES
MSC_BOR_REQUIREMENTS.PLAN_ID MSC_BOR_REQUIREMENTS.ORGANIZATION_ID MSC_BOR_REQUIREMENTS.SR_INSTANCE_ID |
MSC_BILL_OF_RESOURCES |
MSC_BOR_REQUIREMENTS.ASSEMBLY_ITEM_ID
MSC_BOR_REQUIREMENTS.PLAN_ID MSC_BOR_REQUIREMENTS.SR_INSTANCE_ID MSC_BOR_REQUIREMENTS.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_BOR_REQUIREMENTS.PLAN_ID
MSC_BOR_REQUIREMENTS.ORGANIZATION_ID MSC_BOR_REQUIREMENTS.RESOURCE_ID MSC_BOR_REQUIREMENTS.SR_INSTANCE_ID MSC_BOR_REQUIREMENTS.DEPARTMENT_ID |
MSC_DEPARTMENT_RESOURCES |
MSC.MSC_BOR_REQUIREMENTS does not reference any database object
MSC.MSC_BOR_REQUIREMENTS is referenced by following:
Description: |
---|
MSC.MSC_BUDGETS_F does not reference any database object
MSC.MSC_BUDGETS_F is referenced by following:
Description: | MSC_CALENDARS stores the definition of your workday calendar.You can follow any of the four following type of quarters for your yearly calendar identified by Quarterly Calendar Type=1. 4-4-5 : quarterly pattern having two 4 weeks followedby |
---|
MSC.MSC_CALENDARS does not reference any database object
MSC.MSC_CALENDARS is referenced by following:
Description: | MSC_CALENDAR_DATES stores every date between the calendar start date and calendar end date for the given calendar using a specified exception set.This tables stores data collected from source applications. |
---|
MSC.MSC_CALENDAR_DATES does not reference any database object
MSC.MSC_CALENDAR_DATES is referenced by following:
Description: | MSC_CALENDAR_EXCEPTIONS stores exception dates for a calendar. You can define these exception dates to be working or non-working days. The workday calendar program uses this information to generate your workday calendar. |
---|
MSC.MSC_CALENDAR_EXCEPTIONS does not reference any database object
MSC.MSC_CALENDAR_EXCEPTIONS is referenced by following:
Description: | Workday calendar shifts |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_SHIFT_DATES.SR_INSTANCE_ID
MSC_SHIFT_DATES.CALENDAR_CODE MSC_SHIFT_DATES.SHIFT_NUM |
MSC_CALENDAR_SHIFTS |
MSC_SHIFT_EXCEPTIONS.SR_INSTANCE_ID
MSC_SHIFT_EXCEPTIONS.CALENDAR_CODE MSC_SHIFT_EXCEPTIONS.SHIFT_NUM |
MSC_CALENDAR_SHIFTS |
MSC.MSC_CALENDAR_SHIFTS does not reference any database object
MSC.MSC_CALENDAR_SHIFTS is referenced by following:
Description: | This table stores the workday calendar weekly start dates |
---|
MSC.MSC_CAL_WEEK_START_DATES does not reference any database object
MSC.MSC_CAL_WEEK_START_DATES is referenced by following:
Description: | Workday calendar yearly start dates |
---|
MSC.MSC_CAL_YEAR_START_DATES does not reference any database object
MSC.MSC_CAL_YEAR_START_DATES is referenced by following:
Description: | MSC_CAPACITY_PLANS is a generic table used by forms for querying data. This table is used to display capacity horizontal plan information in the Planner Workbench. QUERY_ID is the query identifier used while populating the table. The QUANT |
---|
MSC.MSC_CAPACITY_PLANS does not reference any database object
MSC.MSC_CAPACITY_PLANS is referenced by following:
Description: | This tables stores different category sets for an item. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_ITEM_CATEGORIES.CATEGORY_SET_ID | MSC_CATEGORY_SETS |
MSC_SR_ASSIGNMENTS.CATEGORY_SET_ID | MSC_CATEGORY_SETS |
MSC.MSC_CATEGORY_SETS does not reference any database object
MSC.MSC_CATEGORY_SETS is referenced by following:
Description: | This table is used by the collection program to maintain the correspondence between the source instances identifiers and the planning identifiers for category sets. |
---|
MSC.MSC_CATEGORY_SET_ID_LID does not reference any database object
MSC.MSC_CATEGORY_SET_ID_LID is referenced by following:
Description: | Table to Store Collection Session Parameter Information |
---|
MSC.MSC_COLL_PARAMETERS does not reference any database object
MSC.MSC_COLL_PARAMETERS is referenced by following:
Description: | Contains list of companies involved in collaboration |
---|
MSC.MSC_COMPANIES does not reference any database object
MSC.MSC_COMPANIES is referenced by following:
Description: | Table which contains the link between the company identifier in the source ERP system and the company identifier generated in APS. |
---|
MSC.MSC_COMPANY_ID_LID does not reference any database object
MSC.MSC_COMPANY_ID_LID is referenced by following:
Description: | Table to hold relationship between companies for interenterprise collaboration and planning. |
---|
MSC.MSC_COMPANY_RELATIONSHIPS does not reference any database object
MSC.MSC_COMPANY_RELATIONSHIPS is referenced by following:
Description: | This table contains the list of company site used in interenterprise collaboration and planning. |
---|
MSC.MSC_COMPANY_SITES does not reference any database object
MSC.MSC_COMPANY_SITES is referenced by following:
Description: | This table contains the link between the company site identifier in the source and thecompany site identifier generated in APS. |
---|
MSC.MSC_COMPANY_SITE_ID_LID does not reference any database object
MSC.MSC_COMPANY_SITE_ID_LID is referenced by following:
Description: | This table contains the user company association for Oracle Collaborative planning functionality. |
---|
MSC.MSC_COMPANY_USERS does not reference any database object
MSC.MSC_COMPANY_USERS is referenced by following:
Description: | This table represents possible substitutes component in a bill of material. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_COMPONENT_SUBSTITUTES.BILL_SEQUENCE_ID
MSC_COMPONENT_SUBSTITUTES.COMPONENT_SEQUENCE_ID MSC_COMPONENT_SUBSTITUTES.SR_INSTANCE_ID MSC_COMPONENT_SUBSTITUTES.PLAN_ID |
MSC_BOM_COMPONENTS |
MSC_COMPONENT_SUBSTITUTES.SUBSTITUTE_ITEM_ID
MSC_COMPONENT_SUBSTITUTES.PLAN_ID MSC_COMPONENT_SUBSTITUTES.SR_INSTANCE_ID MSC_COMPONENT_SUBSTITUTES.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC.MSC_COMPONENT_SUBSTITUTES does not reference any database object
MSC.MSC_COMPONENT_SUBSTITUTES is referenced by following:
Description: |
---|
MSC.MSC_COSTS_F does not reference any database object
MSC.MSC_COSTS_F is referenced by following:
Description: | Seeded criteria for Planner Workbench |
---|
MSC.MSC_CRITERIA does not reference any database object
MSC.MSC_CRITERIA is referenced by following:
Description: | Table created for Improved Exceptions |
---|
MSC.MSC_CRITICAL_PATHS does not reference any database object
MSC.MSC_CRITICAL_PATHS is referenced by following:
Description: |
---|
APPS.MSC_CURRENCY_CONV_MV does not reference any database object
APPS.MSC_CURRENCY_CONV_MV is referenced by following:
Description: |
---|
MSC.MSC_DELIVERY_DETAILS does not reference any database object
MSC.MSC_DELIVERY_DETAILS is referenced by following:
Description: | This table stores all the demands taken into account for planning. Disposition_id would be a foreign key to MSC_SUPPLIES for dependent demands. For independent demands, disposition_id holds MRP_SCHEDULE_DATES.MPS_TRANSACTION_ID. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_DEMANDS.INVENTORY_ITEM_ID
MSC_DEMANDS.PLAN_ID MSC_DEMANDS.SR_INSTANCE_ID MSC_DEMANDS.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_DEMANDS.ORGANIZATION_ID
MSC_DEMANDS.TASK_ID MSC_DEMANDS.PROJECT_ID MSC_DEMANDS.SR_INSTANCE_ID MSC_DEMANDS.PLAN_ID |
MSC_PROJECT_TASKS |
MSC_DEMANDS.SHIP_TO_SITE_ID | MSC_TRADING_PARTNER_SITES |
MSC_DEMANDS.SCHEDULE_DESIGNATOR_ID | MSC_DESIGNATORS |
MSC_DEMANDS.PLAN_ID
MSC_DEMANDS.DISPOSITION_ID |
MSC_SUPPLIES |
MSC_DEMANDS.CUSTOMER_ID | MSC_TRADING_PARTNERS |
MSC_DEMANDS.CUSTOMER_SITE_ID | MSC_TRADING_PARTNER_SITES |
MSC_DEMANDS.USING_ASSEMBLY_ITEM_ID
MSC_DEMANDS.PLAN_ID MSC_DEMANDS.SR_INSTANCE_ID MSC_DEMANDS.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_DEMANDS.PLAN_ID
MSC_DEMANDS.SR_INSTANCE_ID MSC_DEMANDS.PROJECT_ID MSC_DEMANDS.ORGANIZATION_ID |
MSC_PROJECTS |
MSC_DEMANDS.PLAN_ID
MSC_DEMANDS.PARENT_ID |
MSC_DEMANDS |
Foreign Key Column | Foreign Table |
---|---|
MSC_DEMANDS.PLAN_ID
MSC_DEMANDS.PARENT_ID |
MSC_DEMANDS |
MSC_FORECAST_UPDATES.PLAN_ID
MSC_FORECAST_UPDATES.FORECAST_DEMAND_ID MSC_FORECAST_UPDATES.SR_INSTANCE_ID |
MSC_DEMANDS |
MSC_FULL_PEGGING.PLAN_ID
MSC_FULL_PEGGING.DEMAND_ID |
MSC_DEMANDS |
MSC.MSC_DEMANDS does not reference any database object
MSC.MSC_DEMANDS is referenced by following:
Description: |
---|
MSC.MSC_DEMANDS_CUM_F does not reference any database object
MSC.MSC_DEMANDS_CUM_F is referenced by following:
Description: |
---|
MSC.MSC_DEMANDS_F does not reference any database object
MSC.MSC_DEMANDS_F is referenced by following:
Description: | This table stores the demand classes. |
---|
MSC.MSC_DEMAND_CLASSES does not reference any database object
MSC.MSC_DEMAND_CLASSES is referenced by following:
Description: | KPI Summary Table |
---|
MSC.MSC_DEMAND_MV_TAB does not reference any database object
MSC.MSC_DEMAND_MV_TAB is referenced by following:
Description: |
---|
MSC.MSC_DEMANTRA_F does not reference any database object
MSC.MSC_DEMANTRA_F is referenced by following:
Description: | This table stores the resources available for planning. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_DEPARTMENT_RESOURCES.PLAN_ID
MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID |
MSC_PLAN_ORGANIZATIONS |
MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID
MSC_DEPARTMENT_RESOURCES.RESOURCE_GROUP_NAME |
MSC_RESOURCE_GROUPS |
Foreign Key Column | Foreign Table |
---|---|
MSC_BIS_RES_SUMMARY.PLAN_ID
MSC_BIS_RES_SUMMARY.ORGANIZATION_ID MSC_BIS_RES_SUMMARY.RESOURCE_ID MSC_BIS_RES_SUMMARY.SR_INSTANCE_ID MSC_BIS_RES_SUMMARY.DEPARTMENT_ID |
MSC_DEPARTMENT_RESOURCES |
MSC_BOR_REQUIREMENTS.PLAN_ID
MSC_BOR_REQUIREMENTS.ORGANIZATION_ID MSC_BOR_REQUIREMENTS.RESOURCE_ID MSC_BOR_REQUIREMENTS.SR_INSTANCE_ID MSC_BOR_REQUIREMENTS.DEPARTMENT_ID |
MSC_DEPARTMENT_RESOURCES |
MSC_EXCEPTION_DETAILS.PLAN_ID
MSC_EXCEPTION_DETAILS.ORGANIZATION_ID MSC_EXCEPTION_DETAILS.RESOURCE_ID MSC_EXCEPTION_DETAILS.SR_INSTANCE_ID MSC_EXCEPTION_DETAILS.DEPARTMENT_ID |
MSC_DEPARTMENT_RESOURCES |
MSC_ITEM_EXCEPTIONS.PLAN_ID
MSC_ITEM_EXCEPTIONS.ORGANIZATION_ID MSC_ITEM_EXCEPTIONS.RESOURCE_ID MSC_ITEM_EXCEPTIONS.SR_INSTANCE_ID MSC_ITEM_EXCEPTIONS.DEPARTMENT_ID |
MSC_DEPARTMENT_RESOURCES |
MSC_NET_RESOURCE_AVAIL.PLAN_ID
MSC_NET_RESOURCE_AVAIL.ORGANIZATION_ID MSC_NET_RESOURCE_AVAIL.RESOURCE_ID MSC_NET_RESOURCE_AVAIL.SR_INSTANCE_ID MSC_NET_RESOURCE_AVAIL.DEPARTMENT_ID |
MSC_DEPARTMENT_RESOURCES |
MSC.MSC_DEPARTMENT_RESOURCES does not reference any database object
MSC.MSC_DEPARTMENT_RESOURCES is referenced by following:
Description: | This table stores MPS and MDS schedule names defined at source applications and planning server. MPS_RELIEF indicates whether or not the Planning Manager should consume this master demand or master production schedule..INVENTORY_ATP_FLAG in |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_DEMANDS.SCHEDULE_DESIGNATOR_ID | MSC_DESIGNATORS |
MSC_PLAN_SCHEDULES.INPUT_SCHEDULE_ID | MSC_DESIGNATORS |
MSC_SUPPLIES.SCHEDULE_DESIGNATOR_ID | MSC_DESIGNATORS |
MSC.MSC_DESIGNATORS does not reference any database object
MSC.MSC_DESIGNATORS is referenced by following:
Description: |
---|
MSC.MSC_DMD_SCN_METRICS does not reference any database object
MSC.MSC_DMD_SCN_METRICS is referenced by following:
Description: | This table Stores the Attachment information |
---|
MSC.MSC_DOC_ATTACHMENTS does not reference any database object
MSC.MSC_DOC_ATTACHMENTS is referenced by following:
Description: | This table Stores the association relationship between an EAM Activty and the corresponding Asset/rebuildable item |
---|
MSC.MSC_EAM_ACT_ASSOCIATIONS does not reference any database object
MSC.MSC_EAM_ACT_ASSOCIATIONS is referenced by following:
Description: |
---|
MSC.MSC_EAM_ASSET_EQUIP_DTLS does not reference any database object
MSC.MSC_EAM_ASSET_EQUIP_DTLS is referenced by following:
Description: | Stores the Errors that have occured during the pre-processing. ERROR_ID is a unique identifier for each record. TABLE_NAME stores the staging table name in which the error occured. TRANSACTION_ID maps to ST_TRANSACTION_ID of the staging tab |
---|
MSC.MSC_ERRORS does not reference any database object
MSC.MSC_ERRORS is referenced by following:
Description: |
---|
MSC.MSC_EXCEPTIONS_F does not reference any database object
MSC.MSC_EXCEPTIONS_F is referenced by following:
Description: | This table stores the details of exceptions generated by Oracle Advanced Planning and Scheduling(APS) and Oracle Supply Chain Hub products. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_EXCEPTION_DETAILS.INVENTORY_ITEM_ID
MSC_EXCEPTION_DETAILS.PLAN_ID MSC_EXCEPTION_DETAILS.SR_INSTANCE_ID MSC_EXCEPTION_DETAILS.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_EXCEPTION_DETAILS.PLAN_ID
MSC_EXCEPTION_DETAILS.ORGANIZATION_ID MSC_EXCEPTION_DETAILS.RESOURCE_ID MSC_EXCEPTION_DETAILS.SR_INSTANCE_ID MSC_EXCEPTION_DETAILS.DEPARTMENT_ID |
MSC_DEPARTMENT_RESOURCES |
MSC_EXCEPTION_DETAILS.PLAN_ID
MSC_EXCEPTION_DETAILS.EXCEPTION_TYPE MSC_EXCEPTION_DETAILS.INVENTORY_ITEM_ID MSC_EXCEPTION_DETAILS.ORGANIZATION_ID MSC_EXCEPTION_DETAILS.SR_INSTANCE_ID |
MSC_ITEM_EXCEPTIONS |
MSC.MSC_EXCEPTION_DETAILS does not reference any database object
MSC.MSC_EXCEPTION_DETAILS is referenced by following:
Description: | This table stores the order in which a user chooses to see the exception types. |
---|
MSC.MSC_EXCEPTION_PREFERENCES does not reference any database object
MSC.MSC_EXCEPTION_PREFERENCES is referenced by following:
Description: | This table is for storing the effective date of threshold defined for seeded and custom exceptions. This table is not used presently |
---|
MSC.MSC_EXCEPTION_THRESHOLDS does not reference any database object
MSC.MSC_EXCEPTION_THRESHOLDS is referenced by following:
Description: | This table stores threshold values for each exception type. For supplier facing exceptions, the threshold values are obtained in the following order (specific to general):company_id, company_site_id, item, supplier_id, supplier_site_idcom |
---|
MSC.MSC_EXCEPTION_THRESHOLD_VALUES does not reference any database object
MSC.MSC_EXCEPTION_THRESHOLD_VALUES is referenced by following:
Description: | This is an Exception Details table to be populated for Plan Comparison Reports. |
---|
MSC.MSC_EXC_DETAILS_ALL does not reference any database object
MSC.MSC_EXC_DETAILS_ALL is referenced by following:
Description: |
---|
MSC.MSC_FCTI_HEADERS_INTERFACE does not reference any database object
MSC.MSC_FCTI_HEADERS_INTERFACE is referenced by following:
Description: |
---|
MSC.MSC_FCTI_LINES_INTERFACE does not reference any database object
MSC.MSC_FCTI_LINES_INTERFACE is referenced by following:
Description: | File names used by the planner |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_FILES.PLAN_ID | MSC_PLANS |
MSC.MSC_FILES does not reference any database object
MSC.MSC_FILES is referenced by following:
Description: | This table describes the relationship between consumed forecast entries and sales order demands |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_FORECAST_UPDATES.PLAN_ID
MSC_FORECAST_UPDATES.FORECAST_DEMAND_ID MSC_FORECAST_UPDATES.SR_INSTANCE_ID |
MSC_DEMANDS |
MSC_FORECAST_UPDATES.INVENTORY_ITEM_ID
MSC_FORECAST_UPDATES.PLAN_ID MSC_FORECAST_UPDATES.SR_INSTANCE_ID MSC_FORECAST_UPDATES.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC.MSC_FORECAST_UPDATES does not reference any database object
MSC.MSC_FORECAST_UPDATES is referenced by following:
Description: | Temporaray table used in computation of results in Oracle Advanced planning and Oracle Supply Chain Hub products. |
---|
MSC.MSC_FORM_QUERY does not reference any database object
MSC.MSC_FORM_QUERY is referenced by following:
Description: | This table represents the pegging from supply to demands. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_FULL_PEGGING.INVENTORY_ITEM_ID
MSC_FULL_PEGGING.PLAN_ID MSC_FULL_PEGGING.SR_INSTANCE_ID MSC_FULL_PEGGING.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_FULL_PEGGING.PLAN_ID
MSC_FULL_PEGGING.DEMAND_ID |
MSC_DEMANDS |
MSC_FULL_PEGGING.PLAN_ID
MSC_FULL_PEGGING.TRANSACTION_ID |
MSC_SUPPLIES |
MSC_FULL_PEGGING.PLAN_ID
MSC_FULL_PEGGING.PREV_PEGGING_ID |
MSC_FULL_PEGGING |
MSC_FULL_PEGGING.PLAN_ID
MSC_FULL_PEGGING.END_PEGGING_ID |
MSC_FULL_PEGGING |
MSC_FULL_PEGGING.ORGANIZATION_ID
MSC_FULL_PEGGING.TASK_ID MSC_FULL_PEGGING.PROJECT_ID MSC_FULL_PEGGING.SR_INSTANCE_ID MSC_FULL_PEGGING.PLAN_ID |
MSC_PROJECT_TASKS |
MSC_FULL_PEGGING.PLAN_ID
MSC_FULL_PEGGING.SR_INSTANCE_ID MSC_FULL_PEGGING.PROJECT_ID MSC_FULL_PEGGING.ORGANIZATION_ID |
MSC_PROJECTS |
Foreign Key Column | Foreign Table |
---|---|
MSC_FULL_PEGGING.PLAN_ID
MSC_FULL_PEGGING.PREV_PEGGING_ID |
MSC_FULL_PEGGING |
MSC_FULL_PEGGING.PLAN_ID
MSC_FULL_PEGGING.END_PEGGING_ID |
MSC_FULL_PEGGING |
MSC.MSC_FULL_PEGGING does not reference any database object
MSC.MSC_FULL_PEGGING is referenced by following:
Description: |
---|
MSC.MSC_GANTT_QUERY does not reference any database object
MSC.MSC_GANTT_QUERY is referenced by following:
Description: | This table stores information about groups of trading partners. |
---|
MSC.MSC_GROUPS does not reference any database object
MSC.MSC_GROUPS is referenced by following:
Description: | This table stores membership information of various companies in different groups. |
---|
MSC.MSC_GROUP_COMPANIES does not reference any database object
MSC.MSC_GROUP_COMPANIES is referenced by following:
Description: |
---|
MSC.MSC_HUB_QUERY does not reference any database object
MSC.MSC_HUB_QUERY is referenced by following:
Description: |
---|
MSC.MSC_IB_CONTRACTS_TEMP does not reference any database object
MSC.MSC_IB_CONTRACTS_TEMP is referenced by following:
Description: | This stores the information of the association links between each organization and MSC. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_INSTANCE_ORGS.SR_INSTANCE_ID | MSC_APPS_INSTANCES |
MSC.MSC_INSTANCE_ORGS does not reference any database object
MSC.MSC_INSTANCE_ORGS is referenced by following:
Description: | This table stores the available and used instance partition information. Instance partitions are used to store the ODS data of specific instance. |
---|
MSC.MSC_INST_PARTITIONS does not reference any database object
MSC.MSC_INST_PARTITIONS is referenced by following:
Description: | This table stores the different shipment methods and their availability. |
---|
MSC.MSC_INTERORG_SHIP_METHODS does not reference any database object
MSC.MSC_INTERORG_SHIP_METHODS is referenced by following:
Description: |
---|
MSC.MSC_INT_10_E_SNO does not reference any database object
MSC.MSC_INT_10_E_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_10_TV does not reference any database object
MSC.MSC_INT_10_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_10_TV_SNO does not reference any database object
MSC.MSC_INT_10_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_11_E_SNO does not reference any database object
MSC.MSC_INT_11_E_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_11_TV does not reference any database object
MSC.MSC_INT_11_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_11_TV_SNO does not reference any database object
MSC.MSC_INT_11_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_12_E does not reference any database object
MSC.MSC_INT_12_E is referenced by following:
Description: |
---|
MSC.MSC_INT_12_E_SNO does not reference any database object
MSC.MSC_INT_12_E_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_12_TV_SNO does not reference any database object
MSC.MSC_INT_12_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_13_E does not reference any database object
MSC.MSC_INT_13_E is referenced by following:
Description: |
---|
MSC.MSC_INT_13_E_SNO does not reference any database object
MSC.MSC_INT_13_E_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_13_TV_SNO does not reference any database object
MSC.MSC_INT_13_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_14_E_SNO does not reference any database object
MSC.MSC_INT_14_E_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_14_TV_SNO does not reference any database object
MSC.MSC_INT_14_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_15_E_SNO does not reference any database object
MSC.MSC_INT_15_E_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_15_TV_SNO does not reference any database object
MSC.MSC_INT_15_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_16_E_SNO does not reference any database object
MSC.MSC_INT_16_E_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_16_TV_SNO does not reference any database object
MSC.MSC_INT_16_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_17_E_SNO does not reference any database object
MSC.MSC_INT_17_E_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_18_E_SNO does not reference any database object
MSC.MSC_INT_18_E_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_18_TV_SNO does not reference any database object
MSC.MSC_INT_18_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_19_E_SNO does not reference any database object
MSC.MSC_INT_19_E_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_19_TV_SNO does not reference any database object
MSC.MSC_INT_19_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_1_E does not reference any database object
MSC.MSC_INT_1_E is referenced by following:
Description: |
---|
MSC.MSC_INT_20_E_SNO does not reference any database object
MSC.MSC_INT_20_E_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_20_TV_SNO does not reference any database object
MSC.MSC_INT_20_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_21_TV_SNO does not reference any database object
MSC.MSC_INT_21_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_22_E_SNO does not reference any database object
MSC.MSC_INT_22_E_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_22_TV_SNO does not reference any database object
MSC.MSC_INT_22_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_23_TV_SNO does not reference any database object
MSC.MSC_INT_23_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_24_E_SNO does not reference any database object
MSC.MSC_INT_24_E_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_24_MEM_SNO does not reference any database object
MSC.MSC_INT_24_MEM_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_25_E_SNO does not reference any database object
MSC.MSC_INT_25_E_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_25_TV_SNO does not reference any database object
MSC.MSC_INT_25_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_26_E_SNO does not reference any database object
MSC.MSC_INT_26_E_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_26_MEM_SNO does not reference any database object
MSC.MSC_INT_26_MEM_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_26_TV_SNO does not reference any database object
MSC.MSC_INT_26_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_27_E_PLAN does not reference any database object
MSC.MSC_INT_27_E_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_27_E_SNO does not reference any database object
MSC.MSC_INT_27_E_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_27_TV_SNO does not reference any database object
MSC.MSC_INT_27_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_28_MEM_SNO does not reference any database object
MSC.MSC_INT_28_MEM_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_28_TV_PLAN does not reference any database object
MSC.MSC_INT_28_TV_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_28_TV_SNO does not reference any database object
MSC.MSC_INT_28_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_29_E_PLAN does not reference any database object
MSC.MSC_INT_29_E_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_29_E_SNO does not reference any database object
MSC.MSC_INT_29_E_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_29_TV_SNO does not reference any database object
MSC.MSC_INT_29_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_2_E does not reference any database object
MSC.MSC_INT_2_E is referenced by following:
Description: |
---|
MSC.MSC_INT_30_E_PLAN does not reference any database object
MSC.MSC_INT_30_E_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_30_TV_PLAN does not reference any database object
MSC.MSC_INT_30_TV_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_30_TV_SNO does not reference any database object
MSC.MSC_INT_30_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_31_E_PLAN does not reference any database object
MSC.MSC_INT_31_E_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_31_E_SNO does not reference any database object
MSC.MSC_INT_31_E_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_32_E_PLAN does not reference any database object
MSC.MSC_INT_32_E_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_32_TV_PLAN does not reference any database object
MSC.MSC_INT_32_TV_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_32_TV_SNO does not reference any database object
MSC.MSC_INT_32_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_33_E_PLAN does not reference any database object
MSC.MSC_INT_33_E_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_33_E_SNO does not reference any database object
MSC.MSC_INT_33_E_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_34_E_PLAN does not reference any database object
MSC.MSC_INT_34_E_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_34_TV_PLAN does not reference any database object
MSC.MSC_INT_34_TV_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_34_TV_SNO does not reference any database object
MSC.MSC_INT_34_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_35_E_PLAN does not reference any database object
MSC.MSC_INT_35_E_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_35_MEM_SNO does not reference any database object
MSC.MSC_INT_35_MEM_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_36_E_PLAN does not reference any database object
MSC.MSC_INT_36_E_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_36_E_SNO does not reference any database object
MSC.MSC_INT_36_E_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_36_TV_PLAN does not reference any database object
MSC.MSC_INT_36_TV_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_37_E_PLAN does not reference any database object
MSC.MSC_INT_37_E_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_37_TV_SNO does not reference any database object
MSC.MSC_INT_37_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_38_E_PLAN does not reference any database object
MSC.MSC_INT_38_E_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_39_E_PLAN does not reference any database object
MSC.MSC_INT_39_E_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_39_TV_PLAN does not reference any database object
MSC.MSC_INT_39_TV_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_3_TV does not reference any database object
MSC.MSC_INT_3_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_40_E_PLAN does not reference any database object
MSC.MSC_INT_40_E_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_41_E_PLAN does not reference any database object
MSC.MSC_INT_41_E_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_42_E_PLAN does not reference any database object
MSC.MSC_INT_42_E_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_43_E_PLAN does not reference any database object
MSC.MSC_INT_43_E_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_43_TV_PLAN does not reference any database object
MSC.MSC_INT_43_TV_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_44_E_PLAN does not reference any database object
MSC.MSC_INT_44_E_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_45_E_PLAN does not reference any database object
MSC.MSC_INT_45_E_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_46_E_PLAN does not reference any database object
MSC.MSC_INT_46_E_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_47_E_PLAN does not reference any database object
MSC.MSC_INT_47_E_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_48_E_PLAN does not reference any database object
MSC.MSC_INT_48_E_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_49_E_PLAN does not reference any database object
MSC.MSC_INT_49_E_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_4_E does not reference any database object
MSC.MSC_INT_4_E is referenced by following:
Description: |
---|
MSC.MSC_INT_50_E_PLAN does not reference any database object
MSC.MSC_INT_50_E_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_5_E does not reference any database object
MSC.MSC_INT_5_E is referenced by following:
Description: |
---|
MSC.MSC_INT_5_TV does not reference any database object
MSC.MSC_INT_5_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_6_E does not reference any database object
MSC.MSC_INT_6_E is referenced by following:
Description: |
---|
MSC.MSC_INT_6_TV does not reference any database object
MSC.MSC_INT_6_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_7_TV does not reference any database object
MSC.MSC_INT_7_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_7_TV_SNO does not reference any database object
MSC.MSC_INT_7_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_8_E does not reference any database object
MSC.MSC_INT_8_E is referenced by following:
Description: |
---|
MSC.MSC_INT_8_E_SNO does not reference any database object
MSC.MSC_INT_8_E_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_8_TV does not reference any database object
MSC.MSC_INT_8_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_9_E does not reference any database object
MSC.MSC_INT_9_E is referenced by following:
Description: |
---|
MSC.MSC_INT_9_TV does not reference any database object
MSC.MSC_INT_9_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_9_TV_SNO does not reference any database object
MSC.MSC_INT_9_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_ACTUAL_RESOURCE_PLAN does not reference any database object
MSC.MSC_INT_ACTUAL_RESOURCE_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_ACTUAL_RES_HRS does not reference any database object
MSC.MSC_INT_ACTUAL_RES_HRS is referenced by following:
Description: |
---|
MSC.MSC_INT_ALL_DEMAND_ITEM does not reference any database object
MSC.MSC_INT_ALL_DEMAND_ITEM is referenced by following:
Description: |
---|
MSC.MSC_INT_ALL_ITEM does not reference any database object
MSC.MSC_INT_ALL_ITEM is referenced by following:
Description: |
---|
MSC.MSC_INT_ALL_SUPPLY_ITEM does not reference any database object
MSC.MSC_INT_ALL_SUPPLY_ITEM is referenced by following:
Description: |
---|
MSC.MSC_INT_ALT_RES does not reference any database object
MSC.MSC_INT_ALT_RES is referenced by following:
Description: |
---|
MSC.MSC_INT_APCC_ITEM_SOURCE does not reference any database object
MSC.MSC_INT_APCC_ITEM_SOURCE is referenced by following:
Description: |
---|
MSC.MSC_INT_APCC_ORG_DETAIL does not reference any database object
MSC.MSC_INT_APCC_ORG_DETAIL is referenced by following:
Description: |
---|
MSC.MSC_INT_ASCP_DEMANDS does not reference any database object
MSC.MSC_INT_ASCP_DEMANDS is referenced by following:
Description: |
---|
MSC.MSC_INT_ASCP_DEPENDENT_DEMAND does not reference any database object
MSC.MSC_INT_ASCP_DEPENDENT_DEMAND is referenced by following:
Description: |
---|
MSC.MSC_INT_ASCP_END_ITEM does not reference any database object
MSC.MSC_INT_ASCP_END_ITEM is referenced by following:
Description: |
---|
MSC.MSC_INT_ASCP_EXCEPTION_DETAILS does not reference any database object
MSC.MSC_INT_ASCP_EXCEPTION_DETAILS is referenced by following:
Description: |
---|
MSC.MSC_INT_ASCP_EXPORT_BUCKETS does not reference any database object
MSC.MSC_INT_ASCP_EXPORT_BUCKETS is referenced by following:
Description: |
---|
MSC.MSC_INT_ASCP_INVENTORY does not reference any database object
MSC.MSC_INT_ASCP_INVENTORY is referenced by following:
Description: |
---|
MSC.MSC_INT_ASCP_KPI does not reference any database object
MSC.MSC_INT_ASCP_KPI is referenced by following:
Description: |
---|
MSC.MSC_INT_ASCP_LABOUR_UTIL does not reference any database object
MSC.MSC_INT_ASCP_LABOUR_UTIL is referenced by following:
Description: |
---|
MSC.MSC_INT_ASCP_MACHINE_UTIL does not reference any database object
MSC.MSC_INT_ASCP_MACHINE_UTIL is referenced by following:
Description: |
---|
MSC.MSC_INT_ASCP_MFG_PLAN_LABOUR does not reference any database object
MSC.MSC_INT_ASCP_MFG_PLAN_LABOUR is referenced by following:
Description: |
---|
MSC.MSC_INT_ASCP_MFG_PLAN_MACHINE does not reference any database object
MSC.MSC_INT_ASCP_MFG_PLAN_MACHINE is referenced by following:
Description: |
---|
MSC.MSC_INT_ASCP_PRODCOST_KPI does not reference any database object
MSC.MSC_INT_ASCP_PRODCOST_KPI is referenced by following:
Description: |
---|
MSC.MSC_INT_ASCP_SUPPLY does not reference any database object
MSC.MSC_INT_ASCP_SUPPLY is referenced by following:
Description: |
---|
MSC.MSC_INT_ASCP_SUPPLY_ITEM does not reference any database object
MSC.MSC_INT_ASCP_SUPPLY_ITEM is referenced by following:
Description: |
---|
MSC.MSC_INT_ASCP_TOTALPRODCOST does not reference any database object
MSC.MSC_INT_ASCP_TOTALPRODCOST is referenced by following:
Description: |
---|
MSC.MSC_INT_ASCP_TRANSPCOST_KPI does not reference any database object
MSC.MSC_INT_ASCP_TRANSPCOST_KPI is referenced by following:
Description: |
---|
MSC.MSC_INT_ASCP_TRANSPORTATION does not reference any database object
MSC.MSC_INT_ASCP_TRANSPORTATION is referenced by following:
Description: |
---|
MSC.MSC_INT_ASSET does not reference any database object
MSC.MSC_INT_ASSET is referenced by following:
Description: |
---|
MSC.MSC_INT_ASSIGNED_ATTRIBUTE does not reference any database object
MSC.MSC_INT_ASSIGNED_ATTRIBUTE is referenced by following:
Description: |
---|
MSC.MSC_INT_ATTRIBUTE_VALUE does not reference any database object
MSC.MSC_INT_ATTRIBUTE_VALUE is referenced by following:
Description: |
---|
MSC.MSC_INT_BEGINNING_INVENTORY does not reference any database object
MSC.MSC_INT_BEGINNING_INVENTORY is referenced by following:
Description: |
---|
MSC.MSC_INT_BOR_RES_NAME does not reference any database object
MSC.MSC_INT_BOR_RES_NAME is referenced by following:
Description: |
---|
MSC.MSC_INT_BRANCH does not reference any database object
MSC.MSC_INT_BRANCH is referenced by following:
Description: |
---|
MSC.MSC_INT_BRANCH_GROUP does not reference any database object
MSC.MSC_INT_BRANCH_GROUP is referenced by following:
Description: |
---|
MSC.MSC_INT_BRANCH_GROUP_MEM does not reference any database object
MSC.MSC_INT_BRANCH_GROUP_MEM is referenced by following:
Description: |
---|
MSC.MSC_INT_BRANCH_OPERATION does not reference any database object
MSC.MSC_INT_BRANCH_OPERATION is referenced by following:
Description: |
---|
MSC.MSC_INT_BRANCH_OPERATION_SET does not reference any database object
MSC.MSC_INT_BRANCH_OPERATION_SET is referenced by following:
Description: |
---|
MSC.MSC_INT_BRANCH_OPERATION_SNO does not reference any database object
MSC.MSC_INT_BRANCH_OPERATION_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_BRANCH_OPERATION_TV does not reference any database object
MSC.MSC_INT_BRANCH_OPERATION_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_BRANCH_ROUTING does not reference any database object
MSC.MSC_INT_BRANCH_ROUTING is referenced by following:
Description: |
---|
MSC.MSC_INT_BRANCH_ROUTING_SNO does not reference any database object
MSC.MSC_INT_BRANCH_ROUTING_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_BRANCH_ROUTING_TV does not reference any database object
MSC.MSC_INT_BRANCH_ROUTING_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_BRANCH_ROUTING_TV_SNO does not reference any database object
MSC.MSC_INT_BRANCH_ROUTING_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_BRANCH_SNO does not reference any database object
MSC.MSC_INT_BRANCH_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_CALENDAR does not reference any database object
MSC.MSC_INT_CALENDAR is referenced by following:
Description: |
---|
MSC.MSC_INT_CALENDAR_SNO does not reference any database object
MSC.MSC_INT_CALENDAR_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_CALENDAR_TV does not reference any database object
MSC.MSC_INT_CALENDAR_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_CALENDAR_TV_SNO does not reference any database object
MSC.MSC_INT_CALENDAR_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_CFC_SCENARIO_DETAILS does not reference any database object
MSC.MSC_INT_CFC_SCENARIO_DETAILS is referenced by following:
Description: |
---|
MSC.MSC_INT_CHANGEOVER_PATTERN does not reference any database object
MSC.MSC_INT_CHANGEOVER_PATTERN is referenced by following:
Description: |
---|
MSC.MSC_INT_CHANGEOVER_PATTERN_SNO does not reference any database object
MSC.MSC_INT_CHANGEOVER_PATTERN_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_CMRO_OP_REL does not reference any database object
MSC.MSC_INT_CMRO_OP_REL is referenced by following:
Description: |
---|
MSC.MSC_INT_CMRO_RES_REQS does not reference any database object
MSC.MSC_INT_CMRO_RES_REQS is referenced by following:
Description: |
---|
MSC.MSC_INT_COMPONENT_ITEM does not reference any database object
MSC.MSC_INT_COMPONENT_ITEM is referenced by following:
Description: |
---|
MSC.MSC_INT_CONSUMED_ITEM_BOM does not reference any database object
MSC.MSC_INT_CONSUMED_ITEM_BOM is referenced by following:
Description: |
---|
MSC.MSC_INT_CONSUMED_ITEM_BOM_SNO does not reference any database object
MSC.MSC_INT_CONSUMED_ITEM_BOM_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_CONSUMED_ITEM_BOM_TV does not reference any database object
MSC.MSC_INT_CONSUMED_ITEM_BOM_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_CONSUMED_ITEM_SET does not reference any database object
MSC.MSC_INT_CONSUMED_ITEM_SET is referenced by following:
Description: |
---|
MSC.MSC_INT_CONSUMED_ITEM_SET_SNO does not reference any database object
MSC.MSC_INT_CONSUMED_ITEM_SET_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_CREW does not reference any database object
MSC.MSC_INT_CREW is referenced by following:
Description: |
---|
MSC.MSC_INT_CREW_SNO does not reference any database object
MSC.MSC_INT_CREW_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_CREW_TV does not reference any database object
MSC.MSC_INT_CREW_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_CREW_TV_SNO does not reference any database object
MSC.MSC_INT_CREW_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_CUSTOMER does not reference any database object
MSC.MSC_INT_CUSTOMER is referenced by following:
Description: |
---|
MSC.MSC_INT_CUSTOMER_GROUP does not reference any database object
MSC.MSC_INT_CUSTOMER_GROUP is referenced by following:
Description: |
---|
MSC.MSC_INT_CUSTOMER_GROUP_MEM does not reference any database object
MSC.MSC_INT_CUSTOMER_GROUP_MEM is referenced by following:
Description: |
---|
MSC.MSC_INT_CUSTOMER_GROUP_MEM_SNO does not reference any database object
MSC.MSC_INT_CUSTOMER_GROUP_MEM_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_CUSTOMER_GROUP_SNO does not reference any database object
MSC.MSC_INT_CUSTOMER_GROUP_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_CUSTOMER_SNO does not reference any database object
MSC.MSC_INT_CUSTOMER_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_CUST_ITEM_TR_MODE does not reference any database object
MSC.MSC_INT_CUST_ITEM_TR_MODE is referenced by following:
Description: |
---|
MSC.MSC_INT_CUST_ITEM_TR_MODE_SNO does not reference any database object
MSC.MSC_INT_CUST_ITEM_TR_MODE_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_CUST_ITEM_TR_MODE_TV does not reference any database object
MSC.MSC_INT_CUST_ITEM_TR_MODE_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_CUST_TR_MODE does not reference any database object
MSC.MSC_INT_CUST_TR_MODE is referenced by following:
Description: |
---|
MSC.MSC_INT_CUST_TR_MODE_SNO does not reference any database object
MSC.MSC_INT_CUST_TR_MODE_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_CUST_TR_MODE_TV does not reference any database object
MSC.MSC_INT_CUST_TR_MODE_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_CUST_TR_MODE_TV_SNO does not reference any database object
MSC.MSC_INT_CUST_TR_MODE_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_END_ITEM does not reference any database object
MSC.MSC_INT_END_ITEM is referenced by following:
Description: |
---|
MSC.MSC_INT_ENTERPRISE_FORECAST does not reference any database object
MSC.MSC_INT_ENTERPRISE_FORECAST is referenced by following:
Description: |
---|
MSC.MSC_INT_ENT_FCST_DETAIL does not reference any database object
MSC.MSC_INT_ENT_FCST_DETAIL is referenced by following:
Description: |
---|
MSC.MSC_INT_ENT_FCST_DETAIL_SNO does not reference any database object
MSC.MSC_INT_ENT_FCST_DETAIL_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_ENT_FCST_DETAIL_TV does not reference any database object
MSC.MSC_INT_ENT_FCST_DETAIL_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_ENT_FCST_DETAIL_TV_SNO does not reference any database object
MSC.MSC_INT_ENT_FCST_DETAIL_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_EQUIPMENT does not reference any database object
MSC.MSC_INT_EQUIPMENT is referenced by following:
Description: |
---|
MSC.MSC_INT_FIXED_PRODUCTION_SNO does not reference any database object
MSC.MSC_INT_FIXED_PRODUCTION_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_IMPLEMENTING_RES does not reference any database object
MSC.MSC_INT_IMPLEMENTING_RES is referenced by following:
Description: |
---|
MSC.MSC_INT_IMPLEMENTING_RESOURCE does not reference any database object
MSC.MSC_INT_IMPLEMENTING_RESOURCE is referenced by following:
Description: |
---|
MSC.MSC_INT_IMPLEMENTING_RES_SNO does not reference any database object
MSC.MSC_INT_IMPLEMENTING_RES_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_IMPLEMENTING_RES_TV does not reference any database object
MSC.MSC_INT_IMPLEMENTING_RES_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_IMPL_RES does not reference any database object
MSC.MSC_INT_IMPL_RES is referenced by following:
Description: |
---|
MSC.MSC_INT_INVENTORY_POLICY does not reference any database object
MSC.MSC_INT_INVENTORY_POLICY is referenced by following:
Description: |
---|
MSC.MSC_INT_INVENTORY_POLICY_SNO does not reference any database object
MSC.MSC_INT_INVENTORY_POLICY_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_INVENTORY_POLICY_TV does not reference any database object
MSC.MSC_INT_INVENTORY_POLICY_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_INV_SAFE_TAR does not reference any database object
MSC.MSC_INT_INV_SAFE_TAR is referenced by following:
Description: |
---|
MSC.MSC_INT_INV_SAFE_TAR_DETAIL does not reference any database object
MSC.MSC_INT_INV_SAFE_TAR_DETAIL is referenced by following:
Description: |
---|
MSC.MSC_INT_INV_SAFE_TAR_DETAIL_TV does not reference any database object
MSC.MSC_INT_INV_SAFE_TAR_DETAIL_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_INV_SAFE_TAR_SNO does not reference any database object
MSC.MSC_INT_INV_SAFE_TAR_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_ITEM does not reference any database object
MSC.MSC_INT_ITEM is referenced by following:
Description: |
---|
MSC.MSC_INT_ITEM_BRANCH does not reference any database object
MSC.MSC_INT_ITEM_BRANCH is referenced by following:
Description: |
---|
MSC.MSC_INT_ITEM_BRANCH_SNO does not reference any database object
MSC.MSC_INT_ITEM_BRANCH_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_ITEM_BRANCH_TV does not reference any database object
MSC.MSC_INT_ITEM_BRANCH_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_ITEM_BRANCH_TV_SNO does not reference any database object
MSC.MSC_INT_ITEM_BRANCH_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_ITEM_GROUP does not reference any database object
MSC.MSC_INT_ITEM_GROUP is referenced by following:
Description: |
---|
MSC.MSC_INT_ITEM_GROUP_MEM does not reference any database object
MSC.MSC_INT_ITEM_GROUP_MEM is referenced by following:
Description: |
---|
MSC.MSC_INT_ITEM_GROUP_MEM_SNO does not reference any database object
MSC.MSC_INT_ITEM_GROUP_MEM_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_ITEM_GROUP_SNO does not reference any database object
MSC.MSC_INT_ITEM_GROUP_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_ITEM_PRICE does not reference any database object
MSC.MSC_INT_ITEM_PRICE is referenced by following:
Description: |
---|
MSC.MSC_INT_ITEM_PRICE_SNO does not reference any database object
MSC.MSC_INT_ITEM_PRICE_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_ITEM_PRICE_TV does not reference any database object
MSC.MSC_INT_ITEM_PRICE_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_ITEM_PRICE_TV_SNO does not reference any database object
MSC.MSC_INT_ITEM_PRICE_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_ITEM_SNO does not reference any database object
MSC.MSC_INT_ITEM_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_ITEM_STORAGE does not reference any database object
MSC.MSC_INT_ITEM_STORAGE is referenced by following:
Description: |
---|
MSC.MSC_INT_ITEM_STORAGE_SNO does not reference any database object
MSC.MSC_INT_ITEM_STORAGE_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_ITEM_STORAGE_TV does not reference any database object
MSC.MSC_INT_ITEM_STORAGE_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_ITEM_STORAGE_TV_SNO does not reference any database object
MSC.MSC_INT_ITEM_STORAGE_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_ITEM_TRANSPORT_MODE does not reference any database object
MSC.MSC_INT_ITEM_TRANSPORT_MODE is referenced by following:
Description: |
---|
MSC.MSC_INT_ITEM_TRAVEL_DISTANCE does not reference any database object
MSC.MSC_INT_ITEM_TRAVEL_DISTANCE is referenced by following:
Description: |
---|
MSC.MSC_INT_ITEM_UOM does not reference any database object
MSC.MSC_INT_ITEM_UOM is referenced by following:
Description: |
---|
MSC.MSC_INT_ITEM_UOM_SNO does not reference any database object
MSC.MSC_INT_ITEM_UOM_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_JOB_ALT_RES does not reference any database object
MSC.MSC_INT_JOB_ALT_RES is referenced by following:
Description: |
---|
MSC.MSC_INT_LANE does not reference any database object
MSC.MSC_INT_LANE is referenced by following:
Description: |
---|
MSC.MSC_INT_LANE_SNO does not reference any database object
MSC.MSC_INT_LANE_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_MACHINE does not reference any database object
MSC.MSC_INT_MACHINE is referenced by following:
Description: |
---|
MSC.MSC_INT_MACHINE_SNO does not reference any database object
MSC.MSC_INT_MACHINE_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_MACHINE_TV does not reference any database object
MSC.MSC_INT_MACHINE_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_MACHINE_TV_SNO does not reference any database object
MSC.MSC_INT_MACHINE_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_MACH_ATTRIBUTE does not reference any database object
MSC.MSC_INT_MACH_ATTRIBUTE is referenced by following:
Description: |
---|
MSC.MSC_INT_NEXT_WORK_ORDER does not reference any database object
MSC.MSC_INT_NEXT_WORK_ORDER is referenced by following:
Description: |
---|
MSC.MSC_INT_OPERATION does not reference any database object
MSC.MSC_INT_OPERATION is referenced by following:
Description: |
---|
MSC.MSC_INT_OPERATION_BOR does not reference any database object
MSC.MSC_INT_OPERATION_BOR is referenced by following:
Description: |
---|
MSC.MSC_INT_OPERATION_BOR_SNO does not reference any database object
MSC.MSC_INT_OPERATION_BOR_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_OPERATION_BOR_TV does not reference any database object
MSC.MSC_INT_OPERATION_BOR_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_OPERATION_BOR_TV_SNO does not reference any database object
MSC.MSC_INT_OPERATION_BOR_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_OPERATION_GROUP does not reference any database object
MSC.MSC_INT_OPERATION_GROUP is referenced by following:
Description: |
---|
MSC.MSC_INT_OPERATION_GROUP_MEM does not reference any database object
MSC.MSC_INT_OPERATION_GROUP_MEM is referenced by following:
Description: |
---|
MSC.MSC_INT_OPERATION_GROUP_SNO does not reference any database object
MSC.MSC_INT_OPERATION_GROUP_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_OPERATION_SET does not reference any database object
MSC.MSC_INT_OPERATION_SET is referenced by following:
Description: |
---|
MSC.MSC_INT_OPERATION_SET_MEM does not reference any database object
MSC.MSC_INT_OPERATION_SET_MEM is referenced by following:
Description: |
---|
MSC.MSC_INT_OPERATION_SET_MEM_SNO does not reference any database object
MSC.MSC_INT_OPERATION_SET_MEM_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_OPERATION_SET_SNO does not reference any database object
MSC.MSC_INT_OPERATION_SET_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_OPERATION_SNO does not reference any database object
MSC.MSC_INT_OPERATION_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_OSFM_PATH does not reference any database object
MSC.MSC_INT_OSFM_PATH is referenced by following:
Description: |
---|
MSC.MSC_INT_PEGGED_WORK_ORDER_PLAN does not reference any database object
MSC.MSC_INT_PEGGED_WORK_ORDER_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_PRODUCED_ITEM does not reference any database object
MSC.MSC_INT_PRODUCED_ITEM is referenced by following:
Description: |
---|
MSC.MSC_INT_PRODUCED_ITEM_BOM does not reference any database object
MSC.MSC_INT_PRODUCED_ITEM_BOM is referenced by following:
Description: |
---|
MSC.MSC_INT_PRODUCED_ITEM_BOM_SNO does not reference any database object
MSC.MSC_INT_PRODUCED_ITEM_BOM_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_PRODUCED_ITEM_BOM_TV does not reference any database object
MSC.MSC_INT_PRODUCED_ITEM_BOM_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_PRODUCED_ITEM_SNO does not reference any database object
MSC.MSC_INT_PRODUCED_ITEM_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_PS_ALL_ITEM does not reference any database object
MSC.MSC_INT_PS_ALL_ITEM is referenced by following:
Description: |
---|
MSC.MSC_INT_PS_DEMAND_ITEM does not reference any database object
MSC.MSC_INT_PS_DEMAND_ITEM is referenced by following:
Description: |
---|
MSC.MSC_INT_PS_END_ITEM does not reference any database object
MSC.MSC_INT_PS_END_ITEM is referenced by following:
Description: |
---|
MSC.MSC_INT_PS_SUPPLY_ITEM does not reference any database object
MSC.MSC_INT_PS_SUPPLY_ITEM is referenced by following:
Description: |
---|
MSC.MSC_INT_PURCHASE_ORDER does not reference any database object
MSC.MSC_INT_PURCHASE_ORDER is referenced by following:
Description: |
---|
MSC.MSC_INT_PURCHASE_ORDER_DETAIL does not reference any database object
MSC.MSC_INT_PURCHASE_ORDER_DETAIL is referenced by following:
Description: |
---|
MSC.MSC_INT_PURCHASE_ORDER_SNO does not reference any database object
MSC.MSC_INT_PURCHASE_ORDER_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_RESERVATION does not reference any database object
MSC.MSC_INT_RESERVATION is referenced by following:
Description: |
---|
MSC.MSC_INT_RESOURCE_ATTRIBUTE does not reference any database object
MSC.MSC_INT_RESOURCE_ATTRIBUTE is referenced by following:
Description: |
---|
MSC.MSC_INT_RESOURCE_GROUP does not reference any database object
MSC.MSC_INT_RESOURCE_GROUP is referenced by following:
Description: |
---|
MSC.MSC_INT_RESOURCE_GROUP_MEM does not reference any database object
MSC.MSC_INT_RESOURCE_GROUP_MEM is referenced by following:
Description: |
---|
MSC.MSC_INT_RESOURCE_GROUP_MEM_SNO does not reference any database object
MSC.MSC_INT_RESOURCE_GROUP_MEM_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_RESOURCE_GROUP_SNO does not reference any database object
MSC.MSC_INT_RESOURCE_GROUP_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_RESOURCE_PLAN does not reference any database object
MSC.MSC_INT_RESOURCE_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_RESOURCE_SCHEDULE_PLAN does not reference any database object
MSC.MSC_INT_RESOURCE_SCHEDULE_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_RESOURCE_SET does not reference any database object
MSC.MSC_INT_RESOURCE_SET is referenced by following:
Description: |
---|
MSC.MSC_INT_RESOURCE_SET_SNO does not reference any database object
MSC.MSC_INT_RESOURCE_SET_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_RES_INTERMEDIATE does not reference any database object
MSC.MSC_INT_RES_INTERMEDIATE is referenced by following:
Description: |
---|
MSC.MSC_INT_ROUTING does not reference any database object
MSC.MSC_INT_ROUTING is referenced by following:
Description: |
---|
MSC.MSC_INT_ROUTING_SNO does not reference any database object
MSC.MSC_INT_ROUTING_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_SALES_ORDER does not reference any database object
MSC.MSC_INT_SALES_ORDER is referenced by following:
Description: |
---|
MSC.MSC_INT_SALES_ORDER_DETAIL does not reference any database object
MSC.MSC_INT_SALES_ORDER_DETAIL is referenced by following:
Description: |
---|
MSC.MSC_INT_SALES_SNO does not reference any database object
MSC.MSC_INT_SALES_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_SALES_TV_SNO does not reference any database object
MSC.MSC_INT_SALES_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_SATISFIED_DEMAND_PLAN does not reference any database object
MSC.MSC_INT_SATISFIED_DEMAND_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_SCHEDULE_BOR_PLAN does not reference any database object
MSC.MSC_INT_SCHEDULE_BOR_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_SCHEDULE_MILESTONE does not reference any database object
MSC.MSC_INT_SCHEDULE_MILESTONE is referenced by following:
Description: |
---|
MSC.MSC_INT_SHIFT_CALENDAR does not reference any database object
MSC.MSC_INT_SHIFT_CALENDAR is referenced by following:
Description: |
---|
MSC.MSC_INT_SOURCE1 does not reference any database object
MSC.MSC_INT_SOURCE1 is referenced by following:
Description: |
---|
MSC.MSC_INT_SOURCE2 does not reference any database object
MSC.MSC_INT_SOURCE2 is referenced by following:
Description: |
---|
MSC.MSC_INT_SOURCE_ITEM_PLAN does not reference any database object
MSC.MSC_INT_SOURCE_ITEM_PLAN is referenced by following:
Description: |
---|
MSC.MSC_INT_SRC_RECOMMEND_DETAIL does not reference any database object
MSC.MSC_INT_SRC_RECOMMEND_DETAIL is referenced by following:
Description: |
---|
MSC.MSC_INT_STANDARD_UOM does not reference any database object
MSC.MSC_INT_STANDARD_UOM is referenced by following:
Description: |
---|
MSC.MSC_INT_STANDARD_UOM_SNO does not reference any database object
MSC.MSC_INT_STANDARD_UOM_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_STORAGE does not reference any database object
MSC.MSC_INT_STORAGE is referenced by following:
Description: |
---|
MSC.MSC_INT_STORAGE_SNO does not reference any database object
MSC.MSC_INT_STORAGE_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_STORAGE_TV does not reference any database object
MSC.MSC_INT_STORAGE_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_STORAGE_TV_SNO does not reference any database object
MSC.MSC_INT_STORAGE_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_SUB_COMPONENT_ITEM does not reference any database object
MSC.MSC_INT_SUB_COMPONENT_ITEM is referenced by following:
Description: |
---|
MSC.MSC_INT_SUPPLIER does not reference any database object
MSC.MSC_INT_SUPPLIER is referenced by following:
Description: |
---|
MSC.MSC_INT_SUPPLIER_GROUP does not reference any database object
MSC.MSC_INT_SUPPLIER_GROUP is referenced by following:
Description: |
---|
MSC.MSC_INT_SUPPLIER_GROUP_MEM does not reference any database object
MSC.MSC_INT_SUPPLIER_GROUP_MEM is referenced by following:
Description: |
---|
MSC.MSC_INT_SUPPLIER_GROUP_MEM_SNO does not reference any database object
MSC.MSC_INT_SUPPLIER_GROUP_MEM_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_SUPPLIER_GROUP_SNO does not reference any database object
MSC.MSC_INT_SUPPLIER_GROUP_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_SUPPLIER_ITEM does not reference any database object
MSC.MSC_INT_SUPPLIER_ITEM is referenced by following:
Description: |
---|
MSC.MSC_INT_SUPPLIER_ITEM_BRANCH does not reference any database object
MSC.MSC_INT_SUPPLIER_ITEM_BRANCH is referenced by following:
Description: |
---|
MSC.MSC_INT_SUPPLIER_ITEM_SNO does not reference any database object
MSC.MSC_INT_SUPPLIER_ITEM_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_SUPPLIER_ITEM_TV does not reference any database object
MSC.MSC_INT_SUPPLIER_ITEM_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_SUPPLIER_ITEM_TV_SNO does not reference any database object
MSC.MSC_INT_SUPPLIER_ITEM_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_SUPPLIER_SNO does not reference any database object
MSC.MSC_INT_SUPPLIER_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_TEMPORAL_RELATION does not reference any database object
MSC.MSC_INT_TEMPORAL_RELATION is referenced by following:
Description: |
---|
MSC.MSC_INT_TEMPORAL_RELATION_SNO does not reference any database object
MSC.MSC_INT_TEMPORAL_RELATION_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_TOOL does not reference any database object
MSC.MSC_INT_TOOL is referenced by following:
Description: |
---|
MSC.MSC_INT_TOOL_SNO does not reference any database object
MSC.MSC_INT_TOOL_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_TOOL_TV does not reference any database object
MSC.MSC_INT_TOOL_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_TOOL_TV_SNO does not reference any database object
MSC.MSC_INT_TOOL_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_TRANSFER_ORDER does not reference any database object
MSC.MSC_INT_TRANSFER_ORDER is referenced by following:
Description: |
---|
MSC.MSC_INT_TRANSFER_ORDER_DETAIL does not reference any database object
MSC.MSC_INT_TRANSFER_ORDER_DETAIL is referenced by following:
Description: |
---|
MSC.MSC_INT_TRANSFER_ORDER_IN does not reference any database object
MSC.MSC_INT_TRANSFER_ORDER_IN is referenced by following:
Description: |
---|
MSC.MSC_INT_TRANSFER_ORDER_OUT does not reference any database object
MSC.MSC_INT_TRANSFER_ORDER_OUT is referenced by following:
Description: |
---|
MSC.MSC_INT_TRANSFER_ORDER_SNO does not reference any database object
MSC.MSC_INT_TRANSFER_ORDER_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_TRANSPORT_MODE does not reference any database object
MSC.MSC_INT_TRANSPORT_MODE is referenced by following:
Description: |
---|
MSC.MSC_INT_TRANSPORT_MODE_SNO does not reference any database object
MSC.MSC_INT_TRANSPORT_MODE_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_TRANSPORT_MODE_TV does not reference any database object
MSC.MSC_INT_TRANSPORT_MODE_TV is referenced by following:
Description: |
---|
MSC.MSC_INT_TRANSPORT_MODE_TV_SNO does not reference any database object
MSC.MSC_INT_TRANSPORT_MODE_TV_SNO is referenced by following:
Description: |
---|
MSC.MSC_INT_VISIT does not reference any database object
MSC.MSC_INT_VISIT is referenced by following:
Description: |
---|
MSC.MSC_INT_WORK_ORDER does not reference any database object
MSC.MSC_INT_WORK_ORDER is referenced by following:
Description: |
---|
MSC.MSC_INT_WORK_ORDER_BOR does not reference any database object
MSC.MSC_INT_WORK_ORDER_BOR is referenced by following:
Description: |
---|
MSC.MSC_INT_WORK_ORDER_IMP_RES does not reference any database object
MSC.MSC_INT_WORK_ORDER_IMP_RES is referenced by following:
Description: |
---|
MSC.MSC_INT_WORK_ORDER_OPERATION does not reference any database object
MSC.MSC_INT_WORK_ORDER_OPERATION is referenced by following:
Description: |
---|
MSC.MSC_INT_WO_CMRO_CONFIG does not reference any database object
MSC.MSC_INT_WO_CMRO_CONFIG is referenced by following:
Description: |
---|
MSC.MSC_INT_WO_CONSUMED_ITEM_BOM does not reference any database object
MSC.MSC_INT_WO_CONSUMED_ITEM_BOM is referenced by following:
Description: |
---|
MSC.MSC_INT_WO_OPERATION_SET does not reference any database object
MSC.MSC_INT_WO_OPERATION_SET is referenced by following:
Description: |
---|
MSC.MSC_INT_WO_PRODUCED_ITEM_BOM does not reference any database object
MSC.MSC_INT_WO_PRODUCED_ITEM_BOM is referenced by following:
Description: |
---|
MSC.MSC_INT_WO_TEMPORAL_REL does not reference any database object
MSC.MSC_INT_WO_TEMPORAL_REL is referenced by following:
Description: | This table is used by the collection program to keep track of all inventory item identifiers generated at planning server. |
---|
MSC.MSC_ITEMS does not reference any database object
MSC.MSC_ITEMS is referenced by following:
Description: |
---|
MSC.MSC_ITEMS_F does not reference any database object
MSC.MSC_ITEMS_F is referenced by following:
Description: | This table stores the item assignment to categories within a category set. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_ITEM_CATEGORIES.CATEGORY_SET_ID | MSC_CATEGORY_SETS |
MSC.MSC_ITEM_CATEGORIES does not reference any database object
MSC.MSC_ITEM_CATEGORIES is referenced by following:
Description: | Table to hold customer items and cross references. |
---|
MSC.MSC_ITEM_CUSTOMERS does not reference any database object
MSC.MSC_ITEM_CUSTOMERS is referenced by following:
Description: | This table stores a row per exception message against an item for exceptions generated in the Oracle Advanced planning and scheduling (APS) and the Oracle Supply Chain Hub products. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_ITEM_EXCEPTIONS.INVENTORY_ITEM_ID
MSC_ITEM_EXCEPTIONS.PLAN_ID MSC_ITEM_EXCEPTIONS.SR_INSTANCE_ID MSC_ITEM_EXCEPTIONS.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_ITEM_EXCEPTIONS.PLAN_ID
MSC_ITEM_EXCEPTIONS.ORGANIZATION_ID MSC_ITEM_EXCEPTIONS.RESOURCE_ID MSC_ITEM_EXCEPTIONS.SR_INSTANCE_ID MSC_ITEM_EXCEPTIONS.DEPARTMENT_ID |
MSC_DEPARTMENT_RESOURCES |
MSC_ITEM_EXCEPTIONS.PLAN_ID
MSC_ITEM_EXCEPTIONS.SR_INSTANCE_ID MSC_ITEM_EXCEPTIONS.PROJECT_ID MSC_ITEM_EXCEPTIONS.ORGANIZATION_ID |
MSC_PROJECTS |
MSC_ITEM_EXCEPTIONS.ORGANIZATION_ID
MSC_ITEM_EXCEPTIONS.TASK_ID MSC_ITEM_EXCEPTIONS.PROJECT_ID MSC_ITEM_EXCEPTIONS.SR_INSTANCE_ID MSC_ITEM_EXCEPTIONS.PLAN_ID |
MSC_PROJECT_TASKS |
Foreign Key Column | Foreign Table |
---|---|
MSC_EXCEPTION_DETAILS.PLAN_ID
MSC_EXCEPTION_DETAILS.EXCEPTION_TYPE MSC_EXCEPTION_DETAILS.INVENTORY_ITEM_ID MSC_EXCEPTION_DETAILS.ORGANIZATION_ID MSC_EXCEPTION_DETAILS.SR_INSTANCE_ID |
MSC_ITEM_EXCEPTIONS |
MSC.MSC_ITEM_EXCEPTIONS does not reference any database object
MSC.MSC_ITEM_EXCEPTIONS is referenced by following:
Description: |
---|
APPS.MSC_ITEM_HIERARCHY_MV does not reference any database object
APPS.MSC_ITEM_HIERARCHY_MV is referenced by following:
Description: | This table is used by the collection program to maintain the correspondence between the source instances identifiers and the planning identifiers for items. |
---|
MSC.MSC_ITEM_ID_LID does not reference any database object
MSC.MSC_ITEM_ID_LID is referenced by following:
Description: |
---|
MSC.MSC_ITEM_INVENTORY_F does not reference any database object
MSC.MSC_ITEM_INVENTORY_F is referenced by following:
Description: |
---|
MSC.MSC_ITEM_ORDERS_F does not reference any database object
MSC.MSC_ITEM_ORDERS_F is referenced by following:
Description: | This table stores sourcing information for an item used in Oracle Advanced Planning and Scheduling. This table is also used to store Sourcing information for in line vehicle sequencing (ILVS) in the Supply Chain Hub product. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_ITEM_SOURCING.INVENTORY_ITEM_ID
MSC_ITEM_SOURCING.PLAN_ID MSC_ITEM_SOURCING.SR_INSTANCE_ID MSC_ITEM_SOURCING.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_ITEM_SOURCING.SOURCING_RULE_ID | MSC_SOURCING_RULES |
MSC_ITEM_SOURCING.ASSIGNMENT_ID | MSC_SR_ASSIGNMENTS |
MSC_ITEM_SOURCING.SUPPLIER_SITE_ID | MSC_TRADING_PARTNER_SITES |
MSC_ITEM_SOURCING.SUPPLIER_ID | MSC_TRADING_PARTNERS |
MSC.MSC_ITEM_SOURCING does not reference any database object
MSC.MSC_ITEM_SOURCING is referenced by following:
Description: | This table stores all the Relationships between Item Substitutes for planning. |
---|
MSC.MSC_ITEM_SUBSTITUTES does not reference any database object
MSC.MSC_ITEM_SUBSTITUTES is referenced by following:
Description: | This table stores the processing lead time, order modifier, and delivery calendar information for each item - supplier/site. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_ITEM_SUPPLIERS.INVENTORY_ITEM_ID
MSC_ITEM_SUPPLIERS.PLAN_ID MSC_ITEM_SUPPLIERS.SR_INSTANCE_ID MSC_ITEM_SUPPLIERS.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_ITEM_SUPPLIERS.SUPPLIER_ID | MSC_TRADING_PARTNERS |
MSC_ITEM_SUPPLIERS.SUPPLIER_SITE_ID | MSC_TRADING_PARTNER_SITES |
MSC.MSC_ITEM_SUPPLIERS does not reference any database object
MSC.MSC_ITEM_SUPPLIERS is referenced by following:
Description: |
---|
MSC.MSC_ITEM_WIPS_F does not reference any database object
MSC.MSC_ITEM_WIPS_F is referenced by following:
Description: |
---|
MSC.MSC_JOB_OPERATIONS does not reference any database object
MSC.MSC_JOB_OPERATIONS is referenced by following:
Description: |
---|
MSC.MSC_JOB_OPERATION_NETWORKS does not reference any database object
MSC.MSC_JOB_OPERATION_NETWORKS is referenced by following:
Description: |
---|
MSC.MSC_JOB_OP_RESOURCES does not reference any database object
MSC.MSC_JOB_OP_RESOURCES is referenced by following:
Description: |
---|
MSC.MSC_JOB_OP_RES_INSTANCES does not reference any database object
MSC.MSC_JOB_OP_RES_INSTANCES is referenced by following:
Description: |
---|
MSC.MSC_JOB_REQUIREMENT_OPS does not reference any database object
MSC.MSC_JOB_REQUIREMENT_OPS is referenced by following:
Description: | KPI Summary Table |
---|
MSC.MSC_LATE_ORDER_MV_TAB does not reference any database object
MSC.MSC_LATE_ORDER_MV_TAB is referenced by following:
Description: | MSC_LOCAL_ID_DEMAND table stores the mappings between the Local IDs and the User Defined Keys for all types of Demands. The table is striped by ENTITY_NAME. |
---|
MSC.MSC_LOCAL_ID_DEMAND does not reference any database object
MSC.MSC_LOCAL_ID_DEMAND is referenced by following:
Description: | MSC_LOCAL_ID_ITEM table stores the mappings between the Local IDs and the User Defined Keys for Items. The table is striped by ENTITY_NAME. The entities and their mappings with staging table columns are listed below.ENTITY_NAME: SR_INVENTOR |
---|
MSC.MSC_LOCAL_ID_ITEM does not reference any database object
MSC.MSC_LOCAL_ID_ITEM is referenced by following:
Description: | MSC_LOCAL_ID_MISC table stores the mappings between the Local IDs and the User Defined Keys for Sourcing Rules, Projects, Tasks and Categories. The table is striped by ENTITY_NAME. |
---|
MSC.MSC_LOCAL_ID_MISC does not reference any database object
MSC.MSC_LOCAL_ID_MISC is referenced by following:
Description: | MSC_LOCAL_ID_SETUP table stores the mappings between the Local IDs and the User Defined Keys for BOM, Routing, Trading Partners, Departments, Resources and Calendars. The table is striped by ENTITY_NAME. |
---|
MSC.MSC_LOCAL_ID_SETUP does not reference any database object
MSC.MSC_LOCAL_ID_SETUP is referenced by following:
Description: | MSC_LOCAL_ID_SUPPLY This table stores the mappings between the Local IDs and the User Defined Keys for all the Supplies. The table is striped by ENTITY_NAME. |
---|
MSC.MSC_LOCAL_ID_SUPPLY does not reference any database object
MSC.MSC_LOCAL_ID_SUPPLY is referenced by following:
Description: | This table stores location associations for organization, customer, customer sites, supplier, and supplier sites. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_LOCATION_ASSOCIATIONS.PARTNER_ID | MSC_TRADING_PARTNERS |
MSC_LOCATION_ASSOCIATIONS.PARTNER_SITE_ID | MSC_TRADING_PARTNER_SITES |
MSC.MSC_LOCATION_ASSOCIATIONS does not reference any database object
MSC.MSC_LOCATION_ASSOCIATIONS is referenced by following:
Description: | This table Stores the Short text Content |
---|
MSC.MSC_LONG_TEXT does not reference any database object
MSC.MSC_LONG_TEXT is referenced by following:
Description: | MSC_MATERIAL_PLANS is a generic table used by forms for querying data. |
---|
MSC.MSC_MATERIAL_PLANS does not reference any database object
MSC.MSC_MATERIAL_PLANS is referenced by following:
Description: |
---|
MSC.MSC_MTH_OPEN_SALES_ORDERS_F does not reference any database object
MSC.MSC_MTH_OPEN_SALES_ORDERS_F is referenced by following:
Description: | This table store the the status of the plan which has launched the "Compare Plan Exceptions" concurrent program. |
---|
MSC.MSC_NEC_COMPARE_PLANS does not reference any database object
MSC.MSC_NEC_COMPARE_PLANS is referenced by following:
Description: | This table is a working table for Plan Comparison Reports. |
---|
MSC.MSC_NEC_EXC_DTL_COMPARE does not reference any database object
MSC.MSC_NEC_EXC_DTL_COMPARE is referenced by following:
Description: | This table stores the criteria used in Plan Comparison Reports. |
---|
MSC.MSC_NET_CHANGE_CRITERIA does not reference any database object
MSC.MSC_NET_CHANGE_CRITERIA is referenced by following:
Description: | This table stores the resource availability profile of the different resources. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_NET_RESOURCE_AVAIL.SR_INSTANCE_ID
MSC_NET_RESOURCE_AVAIL.SIMULATION_SET MSC_NET_RESOURCE_AVAIL.ORGANIZATION_ID |
MSC_SIMULATION_SETS |
MSC_NET_RESOURCE_AVAIL.PLAN_ID
MSC_NET_RESOURCE_AVAIL.ORGANIZATION_ID MSC_NET_RESOURCE_AVAIL.RESOURCE_ID MSC_NET_RESOURCE_AVAIL.SR_INSTANCE_ID MSC_NET_RESOURCE_AVAIL.DEPARTMENT_ID |
MSC_DEPARTMENT_RESOURCES |
MSC_NET_RESOURCE_AVAIL.PARENT_ID
MSC_NET_RESOURCE_AVAIL.PLAN_ID |
MSC_NET_RESOURCE_AVAIL |
Foreign Key Column | Foreign Table |
---|---|
MSC_NET_RESOURCE_AVAIL.PARENT_ID
MSC_NET_RESOURCE_AVAIL.PLAN_ID |
MSC_NET_RESOURCE_AVAIL |
MSC.MSC_NET_RESOURCE_AVAIL does not reference any database object
MSC.MSC_NET_RESOURCE_AVAIL is referenced by following:
Description: |
---|
MSC.MSC_NET_RES_INST_AVAIL does not reference any database object
MSC.MSC_NET_RES_INST_AVAIL is referenced by following:
Description: |
---|
MSC.MSC_OE_DATA_TEMP does not reference any database object
MSC.MSC_OE_DATA_TEMP is referenced by following:
Description: | This table is the intersection table between MSC_BOM_COMPONENTS and MSC_ROUTING_OPERATIONS. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_OPERATION_COMPONENTS.BILL_SEQUENCE_ID
MSC_OPERATION_COMPONENTS.COMPONENT_SEQUENCE_ID MSC_OPERATION_COMPONENTS.SR_INSTANCE_ID MSC_OPERATION_COMPONENTS.PLAN_ID |
MSC_BOM_COMPONENTS |
MSC_OPERATION_COMPONENTS.PLAN_ID
MSC_OPERATION_COMPONENTS.ROUTING_SEQUENCE_ID MSC_OPERATION_COMPONENTS.SR_INSTANCE_ID MSC_OPERATION_COMPONENTS.OPERATION_SEQUENCE_ID |
MSC_ROUTING_OPERATIONS |
MSC.MSC_OPERATION_COMPONENTS does not reference any database object
MSC.MSC_OPERATION_COMPONENTS is referenced by following:
Description: | This table is a child table of msc_operations. Describes the network structure of operations of a network routing. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_OPERATION_NETWORKS.PLAN_ID
MSC_OPERATION_NETWORKS.ROUTING_SEQUENCE_ID MSC_OPERATION_NETWORKS.SR_INSTANCE_ID MSC_OPERATION_NETWORKS.FROM_OP_SEQ_ID |
MSC_ROUTING_OPERATIONS |
MSC_OPERATION_NETWORKS.PLAN_ID
MSC_OPERATION_NETWORKS.ROUTING_SEQUENCE_ID MSC_OPERATION_NETWORKS.SR_INSTANCE_ID MSC_OPERATION_NETWORKS.TO_OP_SEQ_ID |
MSC_ROUTING_OPERATIONS |
MSC.MSC_OPERATION_NETWORKS does not reference any database object
MSC.MSC_OPERATION_NETWORKS is referenced by following:
Description: | This table stores operation resources from a resource sequence. For each resource sequence, we have an alternative between different set of operation resources. This is described by the Alternate Number. Resources with the same Alternate |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_OPERATION_RESOURCES.PLAN_ID
MSC_OPERATION_RESOURCES.ROUTING_SEQUENCE_ID MSC_OPERATION_RESOURCES.SR_INSTANCE_ID MSC_OPERATION_RESOURCES.OPERATION_SEQUENCE_ID MSC_OPERATION_RESOURCES.RESOURCE_SEQ_NUM |
MSC_OPERATION_RESOURCE_SEQS |
Foreign Key Column | Foreign Table |
---|---|
MSC_RESOURCE_REQUIREMENTS.PLAN_ID
MSC_RESOURCE_REQUIREMENTS.OPERATION_SEQUENCE_ID MSC_RESOURCE_REQUIREMENTS.ROUTING_SEQUENCE_ID MSC_RESOURCE_REQUIREMENTS.RESOURCE_SEQ_NUM MSC_RESOURCE_REQUIREMENTS.RESOURCE_ID MSC_RESOURCE_REQUIREMENTS.ALTERNATE_NUM MSC_RESOURCE_REQUIREMENTS.SR_INSTANCE_ID |
MSC_OPERATION_RESOURCES |
MSC.MSC_OPERATION_RESOURCES does not reference any database object
MSC.MSC_OPERATION_RESOURCES is referenced by following:
Description: | This tables stores the operation resources for each routing operation. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_OPERATION_RESOURCE_SEQS.PLAN_ID
MSC_OPERATION_RESOURCE_SEQS.ROUTING_SEQUENCE_ID MSC_OPERATION_RESOURCE_SEQS.SR_INSTANCE_ID MSC_OPERATION_RESOURCE_SEQS.OPERATION_SEQUENCE_ID |
MSC_ROUTING_OPERATIONS |
Foreign Key Column | Foreign Table |
---|---|
MSC_OPERATION_RESOURCES.PLAN_ID
MSC_OPERATION_RESOURCES.ROUTING_SEQUENCE_ID MSC_OPERATION_RESOURCES.SR_INSTANCE_ID MSC_OPERATION_RESOURCES.OPERATION_SEQUENCE_ID MSC_OPERATION_RESOURCES.RESOURCE_SEQ_NUM |
MSC_OPERATION_RESOURCE_SEQS |
MSC_RESOURCE_REQUIREMENTS.PLAN_ID
MSC_RESOURCE_REQUIREMENTS.ROUTING_SEQUENCE_ID MSC_RESOURCE_REQUIREMENTS.SR_INSTANCE_ID MSC_RESOURCE_REQUIREMENTS.OPERATION_SEQUENCE_ID MSC_RESOURCE_REQUIREMENTS.RESOURCE_SEQ_NUM |
MSC_OPERATION_RESOURCE_SEQS |
MSC.MSC_OPERATION_RESOURCE_SEQS does not reference any database object
MSC.MSC_OPERATION_RESOURCE_SEQS is referenced by following:
Description: | This table stores the organizations to which a responsibility has access |
---|
MSC.MSC_ORG_ACCESS does not reference any database object
MSC.MSC_ORG_ACCESS is referenced by following:
Description: | This table Stores the aggregated quantity of the install base item instances at item,date,org level |
---|
MSC.MSC_ORG_AGGR_IBUC does not reference any database object
MSC.MSC_ORG_AGGR_IBUC is referenced by following:
Description: |
---|
MSC.MSC_ORP_MATERIAL_PLANS does not reference any database object
MSC.MSC_ORP_MATERIAL_PLANS is referenced by following:
Description: |
---|
MSC.MSC_ORP_RESOURCE_PLANS does not reference any database object
MSC.MSC_ORP_RESOURCE_PLANS is referenced by following:
Description: | Outbound XML transactions from Collaborative Planning |
---|
MSC.MSC_OUTBOUND_ENTRIES does not reference any database object
MSC.MSC_OUTBOUND_ENTRIES is referenced by following:
Description: | This table stores information about how the planning process works for a given organization. Each organization will have an entry in MSC_PARAMETERS if it is using planning. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_PLAN_ORGANIZATIONS.ORGANIZATION_ID
MSC_PLAN_ORGANIZATIONS.SR_INSTANCE_ID |
MSC_PARAMETERS |
MSC_REPETITIVE_PERIODS.ORGANIZATION_ID
MSC_REPETITIVE_PERIODS.SR_INSTANCE_ID |
MSC_PARAMETERS |
MSC.MSC_PARAMETERS does not reference any database object
MSC.MSC_PARAMETERS is referenced by following:
Description: | This table stores the partner contacts. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_PARTNER_CONTACTS.PARTNER_ID | MSC_TRADING_PARTNERS |
MSC_PARTNER_CONTACTS.PARTNER_SITE_ID | MSC_TRADING_PARTNER_SITES |
MSC.MSC_PARTNER_CONTACTS does not reference any database object
MSC.MSC_PARTNER_CONTACTS is referenced by following:
Description: |
---|
MSC.MSC_PART_DEMANDS does not reference any database object
MSC.MSC_PART_DEMANDS is referenced by following:
Description: |
---|
MSC.MSC_PART_PEGGING does not reference any database object
MSC.MSC_PART_PEGGING is referenced by following:
Description: |
---|
MSC.MSC_PART_SUPPLIES does not reference any database object
MSC.MSC_PART_SUPPLIES is referenced by following:
Description: | Store the parameters user entered in the Planning Detailed Reports |
---|
MSC.MSC_PDR_PARAMETERS does not reference any database object
MSC.MSC_PDR_PARAMETERS is referenced by following:
Description: | Store the parameters user entered in the Planning Detailed Reports |
---|
MSC.MSC_PDR_PARAMETERS_NEW does not reference any database object
MSC.MSC_PDR_PARAMETERS_NEW is referenced by following:
Description: | Workday calendar period start dates |
---|
MSC.MSC_PERIOD_START_DATES does not reference any database object
MSC.MSC_PERIOD_START_DATES is referenced by following:
Description: |
---|
APPS.MSC_PHUB_CATEGORIES_MV does not reference any database object
APPS.MSC_PHUB_CATEGORIES_MV is referenced by following:
Description: |
---|
APPS.MSC_PHUB_CUSTOMERS_MV does not reference any database object
APPS.MSC_PHUB_CUSTOMERS_MV is referenced by following:
Description: |
---|
APPS.MSC_PHUB_DATES_MV does not reference any database object
APPS.MSC_PHUB_DATES_MV is referenced by following:
Description: |
---|
APPS.MSC_PHUB_ITEM_CATEGORIES_MV does not reference any database object
APPS.MSC_PHUB_ITEM_CATEGORIES_MV is referenced by following:
Description: |
---|
APPS.MSC_PHUB_ORGS_MV does not reference any database object
APPS.MSC_PHUB_ORGS_MV is referenced by following:
Description: |
---|
APPS.MSC_PHUB_PROJECTS_MV does not reference any database object
APPS.MSC_PHUB_PROJECTS_MV is referenced by following:
Description: |
---|
APPS.MSC_PHUB_RESOURCES_MV does not reference any database object
APPS.MSC_PHUB_RESOURCES_MV is referenced by following:
Description: |
---|
APPS.MSC_PHUB_SUPPLIERS_MV does not reference any database object
APPS.MSC_PHUB_SUPPLIERS_MV is referenced by following:
Description: | This table stores and maintains a list of planner codes. |
---|
MSC.MSC_PLANNERS does not reference any database object
MSC.MSC_PLANNERS is referenced by following:
Description: | This table stores different plans, with their names, and settings in the Oracle Advanced Planning and Scheduling(APS) and Oracle Supply Chain Hub products. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_PLANS.ASSIGNMENT_SET_ID | MSC_ASSIGNMENT_SETS |
MSC_PLANS.ORGANIZATION_ID | HZ_PARTIES |
Foreign Key Column | Foreign Table |
---|---|
MSC_FILES.PLAN_ID | MSC_PLANS |
MSC_PLAN_ORGANIZATIONS.PLAN_ID | MSC_PLANS |
MSC_SNAPSHOT_TASKS.PLAN_ID | MSC_PLANS |
MSC_SUP_DEM_ENTRIES.PLAN_ID | MSC_PLANS |
MSC.MSC_PLANS does not reference any database object
MSC.MSC_PLANS is referenced by following:
Description: | This table stores bucket dates for Planner Workbench Horizontal Plan. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_PLAN_BUCKETS.PLAN_ID
MSC_PLAN_BUCKETS.ORGANIZATION_ID MSC_PLAN_BUCKETS.SR_INSTANCE_ID |
MSC_PLAN_ORGANIZATIONS |
MSC.MSC_PLAN_BUCKETS does not reference any database object
MSC.MSC_PLAN_BUCKETS is referenced by following:
Description: |
---|
MSC.MSC_PLAN_CONSTRAINTS does not reference any database object
MSC.MSC_PLAN_CONSTRAINTS is referenced by following:
Description: | This table stores the parameters relative to organizations that participate to the plan in Oracle Advanced Planning and Scheduling (APS). This table also contains the different companies which are collaborating in a supply or demand plan in |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_PLAN_ORGANIZATIONS.ORGANIZATION_ID
MSC_PLAN_ORGANIZATIONS.SR_INSTANCE_ID |
MSC_PARAMETERS |
MSC_PLAN_ORGANIZATIONS.PLAN_ID | MSC_PLANS |
Foreign Key Column | Foreign Table |
---|---|
MSC_BILL_OF_RESOURCES.PLAN_ID
MSC_BILL_OF_RESOURCES.ORGANIZATION_ID MSC_BILL_OF_RESOURCES.SR_INSTANCE_ID |
MSC_PLAN_ORGANIZATIONS |
MSC_DEPARTMENT_RESOURCES.PLAN_ID
MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID |
MSC_PLAN_ORGANIZATIONS |
MSC_PLAN_BUCKETS.PLAN_ID
MSC_PLAN_BUCKETS.ORGANIZATION_ID MSC_PLAN_BUCKETS.SR_INSTANCE_ID |
MSC_PLAN_ORGANIZATIONS |
MSC_PLAN_ORG_KPIS.PLAN_ID
MSC_PLAN_ORG_KPIS.ORGANIZATION_ID MSC_PLAN_ORG_KPIS.SR_INSTANCE_ID |
MSC_PLAN_ORGANIZATIONS |
MSC_PLAN_ORG_STATUS.PLAN_ID
MSC_PLAN_ORG_STATUS.ORGANIZATION_ID MSC_PLAN_ORG_STATUS.SR_INSTANCE_ID |
MSC_PLAN_ORGANIZATIONS |
MSC_PLAN_SCHEDULES.PLAN_ID
MSC_PLAN_SCHEDULES.ORGANIZATION_ID MSC_PLAN_SCHEDULES.SR_INSTANCE_ID |
MSC_PLAN_ORGANIZATIONS |
MSC_PROJECTS.PLAN_ID
MSC_PROJECTS.ORGANIZATION_ID MSC_PROJECTS.SR_INSTANCE_ID |
MSC_PLAN_ORGANIZATIONS |
MSC_SUB_INVENTORIES.PLAN_ID
MSC_SUB_INVENTORIES.ORGANIZATION_ID MSC_SUB_INVENTORIES.SR_INSTANCE_ID |
MSC_PLAN_ORGANIZATIONS |
MSC_SYSTEM_ITEMS.PLAN_ID
MSC_SYSTEM_ITEMS.ORGANIZATION_ID MSC_SYSTEM_ITEMS.SR_INSTANCE_ID |
MSC_PLAN_ORGANIZATIONS |
MSC.MSC_PLAN_ORGANIZATIONS does not reference any database object
MSC.MSC_PLAN_ORGANIZATIONS is referenced by following:
Description: | Maintains the key performance indicators and thresholds for plans created on Oracle Supply Chain Hub. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_PLAN_ORG_KPIS.PLAN_ID
MSC_PLAN_ORG_KPIS.ORGANIZATION_ID MSC_PLAN_ORG_KPIS.SR_INSTANCE_ID |
MSC_PLAN_ORGANIZATIONS |
MSC.MSC_PLAN_ORG_KPIS does not reference any database object
MSC.MSC_PLAN_ORG_KPIS is referenced by following:
Description: | Maintains the history of statuses of collaborating organizations in a plan. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_PLAN_ORG_STATUS.PLAN_ID
MSC_PLAN_ORG_STATUS.ORGANIZATION_ID MSC_PLAN_ORG_STATUS.SR_INSTANCE_ID |
MSC_PLAN_ORGANIZATIONS |
MSC.MSC_PLAN_ORG_STATUS does not reference any database object
MSC.MSC_PLAN_ORG_STATUS is referenced by following:
Description: | The table stores partition information for plans. |
---|
MSC.MSC_PLAN_PARTITIONS does not reference any database object
MSC.MSC_PLAN_PARTITIONS is referenced by following:
Description: | This table used by collection program to keep track of the refresh numbers for each plan. |
---|
MSC.MSC_PLAN_REFRESHES does not reference any database object
MSC.MSC_PLAN_REFRESHES is referenced by following:
Description: | This table stores master production schedules and master demand schedules for the planning process in an organization. This table is also used to store the input production schedule namefor In line vehicle sequencing (ILVS) on Oracle Supply |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_PLAN_SCHEDULES.PLAN_ID
MSC_PLAN_SCHEDULES.ORGANIZATION_ID MSC_PLAN_SCHEDULES.SR_INSTANCE_ID |
MSC_PLAN_ORGANIZATIONS |
MSC_PLAN_SCHEDULES.INPUT_SCHEDULE_ID | MSC_DESIGNATORS |
MSC.MSC_PLAN_SCHEDULES does not reference any database object
MSC.MSC_PLAN_SCHEDULES is referenced by following:
Description: | Requisition Import interface table |
---|
MSC.MSC_PO_REQUISITIONS_INTERFACE does not reference any database object
MSC.MSC_PO_REQUISITIONS_INTERFACE is referenced by following:
Description: | Requisition reschedule interface table |
---|
MSC.MSC_PO_RESCHEDULE_INTERFACE does not reference any database object
MSC.MSC_PO_RESCHEDULE_INTERFACE is referenced by following:
Description: | Stores results of different types of personal queries. |
---|
MSC.MSC_PQ_RESULTS does not reference any database object
MSC.MSC_PQ_RESULTS is referenced by following:
Description: | This table stores links between the bill of material and routings and store effectivities for this process. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_PROCESS_EFFECTIVITY.SR_INSTANCE_ID
MSC_PROCESS_EFFECTIVITY.BILL_SEQUENCE_ID MSC_PROCESS_EFFECTIVITY.PLAN_ID |
MSC_BOMS |
MSC_PROCESS_EFFECTIVITY.PLAN_ID
MSC_PROCESS_EFFECTIVITY.ROUTING_SEQUENCE_ID MSC_PROCESS_EFFECTIVITY.SR_INSTANCE_ID |
MSC_ROUTINGS |
MSC_PROCESS_EFFECTIVITY.ITEM_ID
MSC_PROCESS_EFFECTIVITY.PLAN_ID MSC_PROCESS_EFFECTIVITY.SR_INSTANCE_ID MSC_PROCESS_EFFECTIVITY.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC.MSC_PROCESS_EFFECTIVITY does not reference any database object
MSC.MSC_PROCESS_EFFECTIVITY is referenced by following:
Description: |
---|
MSC.MSC_PROFILES does not reference any database object
MSC.MSC_PROFILES is referenced by following:
Description: | This table stores the manufacturing parameters for a given project and organization. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_PROJECTS.PLAN_ID
MSC_PROJECTS.ORGANIZATION_ID MSC_PROJECTS.SR_INSTANCE_ID |
MSC_PLAN_ORGANIZATIONS |
Foreign Key Column | Foreign Table |
---|---|
MSC_DEMANDS.PLAN_ID
MSC_DEMANDS.SR_INSTANCE_ID MSC_DEMANDS.PROJECT_ID MSC_DEMANDS.ORGANIZATION_ID |
MSC_PROJECTS |
MSC_ITEM_EXCEPTIONS.PLAN_ID
MSC_ITEM_EXCEPTIONS.SR_INSTANCE_ID MSC_ITEM_EXCEPTIONS.PROJECT_ID MSC_ITEM_EXCEPTIONS.ORGANIZATION_ID |
MSC_PROJECTS |
MSC_FULL_PEGGING.PLAN_ID
MSC_FULL_PEGGING.SR_INSTANCE_ID MSC_FULL_PEGGING.PROJECT_ID MSC_FULL_PEGGING.ORGANIZATION_ID |
MSC_PROJECTS |
MSC_PROJECT_TASKS.PLAN_ID
MSC_PROJECT_TASKS.SR_INSTANCE_ID MSC_PROJECT_TASKS.PROJECT_ID MSC_PROJECT_TASKS.ORGANIZATION_ID |
MSC_PROJECTS |
MSC_ROUTINGS.PLAN_ID
MSC_ROUTINGS.SR_INSTANCE_ID MSC_ROUTINGS.PROJECT_ID MSC_ROUTINGS.ORGANIZATION_ID |
MSC_PROJECTS |
MSC_SUPPLIES.PLAN_ID
MSC_SUPPLIES.SR_INSTANCE_ID MSC_SUPPLIES.PROJECT_ID MSC_SUPPLIES.ORGANIZATION_ID |
MSC_PROJECTS |
MSC_SUPPLIES.PLAN_ID
MSC_SUPPLIES.SR_INSTANCE_ID MSC_SUPPLIES.IMPLEMENT_PROJECT_ID MSC_SUPPLIES.ORGANIZATION_ID |
MSC_PROJECTS |
MSC.MSC_PROJECTS does not reference any database object
MSC.MSC_PROJECTS is referenced by following:
Description: | This table stores the tasks maufacturing parameters. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_PROJECT_TASKS.PLAN_ID
MSC_PROJECT_TASKS.SR_INSTANCE_ID MSC_PROJECT_TASKS.PROJECT_ID MSC_PROJECT_TASKS.ORGANIZATION_ID |
MSC_PROJECTS |
Foreign Key Column | Foreign Table |
---|---|
MSC_DEMANDS.ORGANIZATION_ID
MSC_DEMANDS.TASK_ID MSC_DEMANDS.PROJECT_ID MSC_DEMANDS.SR_INSTANCE_ID MSC_DEMANDS.PLAN_ID |
MSC_PROJECT_TASKS |
MSC_FULL_PEGGING.ORGANIZATION_ID
MSC_FULL_PEGGING.TASK_ID MSC_FULL_PEGGING.PROJECT_ID MSC_FULL_PEGGING.SR_INSTANCE_ID MSC_FULL_PEGGING.PLAN_ID |
MSC_PROJECT_TASKS |
MSC_ITEM_EXCEPTIONS.ORGANIZATION_ID
MSC_ITEM_EXCEPTIONS.TASK_ID MSC_ITEM_EXCEPTIONS.PROJECT_ID MSC_ITEM_EXCEPTIONS.SR_INSTANCE_ID MSC_ITEM_EXCEPTIONS.PLAN_ID |
MSC_PROJECT_TASKS |
MSC_ROUTINGS.ORGANIZATION_ID
MSC_ROUTINGS.TASK_ID MSC_ROUTINGS.PROJECT_ID MSC_ROUTINGS.SR_INSTANCE_ID MSC_ROUTINGS.PLAN_ID |
MSC_PROJECT_TASKS |
MSC_SUPPLIES.ORGANIZATION_ID
MSC_SUPPLIES.TASK_ID MSC_SUPPLIES.PROJECT_ID MSC_SUPPLIES.SR_INSTANCE_ID MSC_SUPPLIES.PLAN_ID |
MSC_PROJECT_TASKS |
MSC_SUPPLIES.ORGANIZATION_ID
MSC_SUPPLIES.IMPLEMENT_TASK_ID MSC_SUPPLIES.IMPLEMENT_PROJECT_ID MSC_SUPPLIES.SR_INSTANCE_ID MSC_SUPPLIES.PLAN_ID |
MSC_PROJECT_TASKS |
MSC.MSC_PROJECT_TASKS does not reference any database object
MSC.MSC_PROJECT_TASKS is referenced by following:
Description: | This table stores the Purchase Order information to be rescheduled in the Source instance. |
---|
MSC.MSC_PURCHASE_ORDER_INTERFACE does not reference any database object
MSC.MSC_PURCHASE_ORDER_INTERFACE is referenced by following:
Description: | Table used to pass data across sessions. |
---|
MSC.MSC_QUERY does not reference any database object
MSC.MSC_QUERY is referenced by following:
Description: | This table stores the seeded and user defined questions for Ask Oracle. The associated MSC_QUESTIONS_TL table contains the translated questions by language. |
---|
MSC.MSC_QUESTIONS_B does not reference any database object
MSC.MSC_QUESTIONS_B is referenced by following:
Description: | This table contains the translated questions for Ask Oracle |
---|
MSC.MSC_QUESTIONS_TL does not reference any database object
MSC.MSC_QUESTIONS_TL is referenced by following:
Description: | This table contains geographical regions data |
---|
MSC.MSC_REGIONS does not reference any database object
MSC.MSC_REGIONS is referenced by following:
Description: | This table temporarily contains geographical regions data needed during an ATP request. |
---|
MSC.MSC_REGIONS_TEMP does not reference any database object
MSC.MSC_REGIONS_TEMP is referenced by following:
Description: | Stores mapping of locations to regions. This includes separate records for the most specific region mapped as well as records for its parents. |
---|
MSC.MSC_REGION_LOCATIONS does not reference any database object
MSC.MSC_REGION_LOCATIONS is referenced by following:
Description: | This table is for storing related exceptions to a custom exceptions. This table is not used presently. |
---|
MSC.MSC_RELATED_EXCEPTIONS does not reference any database object
MSC.MSC_RELATED_EXCEPTIONS is referenced by following:
Description: | Repetitive planning period start dates |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_REPETITIVE_PERIODS.ORGANIZATION_ID
MSC_REPETITIVE_PERIODS.SR_INSTANCE_ID |
MSC_PARAMETERS |
MSC.MSC_REPETITIVE_PERIODS does not reference any database object
MSC.MSC_REPETITIVE_PERIODS is referenced by following:
Description: | Material reservations |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_RESERVATIONS.INVENTORY_ITEM_ID
MSC_RESERVATIONS.PLAN_ID MSC_RESERVATIONS.SR_INSTANCE_ID MSC_RESERVATIONS.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_RESERVATIONS.SR_INSTANCE_ID
MSC_RESERVATIONS.PLAN_ID MSC_RESERVATIONS.ORGANIZATION_ID MSC_RESERVATIONS.SUBINVENTORY |
MSC_SUB_INVENTORIES |
MSC.MSC_RESERVATIONS does not reference any database object
MSC.MSC_RESERVATIONS is referenced by following:
Description: |
---|
MSC.MSC_RESOURCES_CUM_F does not reference any database object
MSC.MSC_RESOURCES_CUM_F is referenced by following:
Description: |
---|
MSC.MSC_RESOURCES_F does not reference any database object
MSC.MSC_RESOURCES_F is referenced by following:
Description: | Resource capacity modifications |
---|
MSC.MSC_RESOURCE_CHANGES does not reference any database object
MSC.MSC_RESOURCE_CHANGES is referenced by following:
Description: | This table stores different resource groups. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_ALLOCATION_ASSIGNMENTS.SR_INSTANCE_ID
MSC_ALLOCATION_ASSIGNMENTS.RESOURCE_GROUP |
MSC_RESOURCE_GROUPS |
MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID
MSC_DEPARTMENT_RESOURCES.RESOURCE_GROUP_NAME |
MSC_RESOURCE_GROUPS |
MSC.MSC_RESOURCE_GROUPS does not reference any database object
MSC.MSC_RESOURCE_GROUPS is referenced by following:
Description: |
---|
APPS.MSC_RESOURCE_HIERARCHY_MV does not reference any database object
APPS.MSC_RESOURCE_HIERARCHY_MV is referenced by following:
Description: |
---|
MSC.MSC_RESOURCE_INSTANCE_REQS does not reference any database object
MSC.MSC_RESOURCE_INSTANCE_REQS is referenced by following:
Description: | This table stores the resource requirments generated by existing supplies. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_RESOURCE_REQUIREMENTS.PLAN_ID
MSC_RESOURCE_REQUIREMENTS.SUPPLY_ID |
MSC_SUPPLIES |
MSC_RESOURCE_REQUIREMENTS.PLAN_ID
MSC_RESOURCE_REQUIREMENTS.ROUTING_SEQUENCE_ID MSC_RESOURCE_REQUIREMENTS.SR_INSTANCE_ID |
MSC_ROUTINGS |
MSC_RESOURCE_REQUIREMENTS.PLAN_ID
MSC_RESOURCE_REQUIREMENTS.ROUTING_SEQUENCE_ID MSC_RESOURCE_REQUIREMENTS.SR_INSTANCE_ID MSC_RESOURCE_REQUIREMENTS.OPERATION_SEQUENCE_ID MSC_RESOURCE_REQUIREMENTS.RESOURCE_SEQ_NUM |
MSC_OPERATION_RESOURCE_SEQS |
MSC_RESOURCE_REQUIREMENTS.PLAN_ID
MSC_RESOURCE_REQUIREMENTS.OPERATION_SEQUENCE_ID MSC_RESOURCE_REQUIREMENTS.ROUTING_SEQUENCE_ID MSC_RESOURCE_REQUIREMENTS.RESOURCE_SEQ_NUM MSC_RESOURCE_REQUIREMENTS.RESOURCE_ID MSC_RESOURCE_REQUIREMENTS.ALTERNATE_NUM MSC_RESOURCE_REQUIREMENTS.SR_INSTANCE_ID |
MSC_OPERATION_RESOURCES |
MSC_RESOURCE_REQUIREMENTS.PLAN_ID
MSC_RESOURCE_REQUIREMENTS.PARENT_ID |
MSC_RESOURCE_REQUIREMENTS |
Foreign Key Column | Foreign Table |
---|---|
MSC_RESOURCE_REQUIREMENTS.PLAN_ID
MSC_RESOURCE_REQUIREMENTS.PARENT_ID |
MSC_RESOURCE_REQUIREMENTS |
MSC.MSC_RESOURCE_REQUIREMENTS does not reference any database object
MSC.MSC_RESOURCE_REQUIREMENTS is referenced by following:
Description: | Resource shift information |
---|
MSC.MSC_RESOURCE_SHIFTS does not reference any database object
MSC.MSC_RESOURCE_SHIFTS is referenced by following:
Description: | This table stores the different routings available for a bill of material. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_ROUTINGS.ASSEMBLY_ITEM_ID
MSC_ROUTINGS.PLAN_ID MSC_ROUTINGS.SR_INSTANCE_ID MSC_ROUTINGS.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_ROUTINGS.PLAN_ID
MSC_ROUTINGS.SR_INSTANCE_ID MSC_ROUTINGS.PROJECT_ID MSC_ROUTINGS.ORGANIZATION_ID |
MSC_PROJECTS |
MSC_ROUTINGS.ORGANIZATION_ID
MSC_ROUTINGS.TASK_ID MSC_ROUTINGS.PROJECT_ID MSC_ROUTINGS.SR_INSTANCE_ID MSC_ROUTINGS.PLAN_ID |
MSC_PROJECT_TASKS |
Foreign Key Column | Foreign Table |
---|---|
MSC_PROCESS_EFFECTIVITY.PLAN_ID
MSC_PROCESS_EFFECTIVITY.ROUTING_SEQUENCE_ID MSC_PROCESS_EFFECTIVITY.SR_INSTANCE_ID |
MSC_ROUTINGS |
MSC_RESOURCE_REQUIREMENTS.PLAN_ID
MSC_RESOURCE_REQUIREMENTS.ROUTING_SEQUENCE_ID MSC_RESOURCE_REQUIREMENTS.SR_INSTANCE_ID |
MSC_ROUTINGS |
MSC_ROUTING_OPERATIONS.PLAN_ID
MSC_ROUTING_OPERATIONS.ROUTING_SEQUENCE_ID MSC_ROUTING_OPERATIONS.SR_INSTANCE_ID |
MSC_ROUTINGS |
MSC.MSC_ROUTINGS does not reference any database object
MSC.MSC_ROUTINGS is referenced by following:
Description: | This tables stores the operations composing each routing. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_ROUTING_OPERATIONS.PLAN_ID
MSC_ROUTING_OPERATIONS.ROUTING_SEQUENCE_ID MSC_ROUTING_OPERATIONS.SR_INSTANCE_ID |
MSC_ROUTINGS |
Foreign Key Column | Foreign Table |
---|---|
MSC_OPERATION_NETWORKS.PLAN_ID
MSC_OPERATION_NETWORKS.ROUTING_SEQUENCE_ID MSC_OPERATION_NETWORKS.SR_INSTANCE_ID MSC_OPERATION_NETWORKS.FROM_OP_SEQ_ID |
MSC_ROUTING_OPERATIONS |
MSC_OPERATION_NETWORKS.PLAN_ID
MSC_OPERATION_NETWORKS.ROUTING_SEQUENCE_ID MSC_OPERATION_NETWORKS.SR_INSTANCE_ID MSC_OPERATION_NETWORKS.TO_OP_SEQ_ID |
MSC_ROUTING_OPERATIONS |
MSC_OPERATION_RESOURCE_SEQS.PLAN_ID
MSC_OPERATION_RESOURCE_SEQS.ROUTING_SEQUENCE_ID MSC_OPERATION_RESOURCE_SEQS.SR_INSTANCE_ID MSC_OPERATION_RESOURCE_SEQS.OPERATION_SEQUENCE_ID |
MSC_ROUTING_OPERATIONS |
MSC_OPERATION_COMPONENTS.PLAN_ID
MSC_OPERATION_COMPONENTS.ROUTING_SEQUENCE_ID MSC_OPERATION_COMPONENTS.SR_INSTANCE_ID MSC_OPERATION_COMPONENTS.OPERATION_SEQUENCE_ID |
MSC_ROUTING_OPERATIONS |
MSC.MSC_ROUTING_OPERATIONS does not reference any database object
MSC.MSC_ROUTING_OPERATIONS is referenced by following:
Description: |
---|
APPS.MSC_RP_CATEGORY_MV does not reference any database object
APPS.MSC_RP_CATEGORY_MV is referenced by following:
Description: |
---|
MSC.MSC_RP_CTB_DONOR_COMPONENTS does not reference any database object
MSC.MSC_RP_CTB_DONOR_COMPONENTS is referenced by following:
Description: |
---|
MSC.MSC_RP_CTB_ORDER_COMPONENTS does not reference any database object
MSC.MSC_RP_CTB_ORDER_COMPONENTS is referenced by following:
Description: |
---|
MSC.MSC_RP_ITEM_UPDATES does not reference any database object
MSC.MSC_RP_ITEM_UPDATES is referenced by following:
Description: |
---|
MSC.MSC_RP_KPI does not reference any database object
MSC.MSC_RP_KPI is referenced by following:
Description: |
---|
MSC.MSC_RP_RELEASED_ORDERS does not reference any database object
MSC.MSC_RP_RELEASED_ORDERS is referenced by following:
Description: | Safety stock levels |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_SAFETY_STOCKS.INVENTORY_ITEM_ID
MSC_SAFETY_STOCKS.PLAN_ID MSC_SAFETY_STOCKS.SR_INSTANCE_ID MSC_SAFETY_STOCKS.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC.MSC_SAFETY_STOCKS does not reference any database object
MSC.MSC_SAFETY_STOCKS is referenced by following:
Description: | This table stores sales order demand and reservations from source application instances. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_SALES_ORDERS.PARENT_DEMAND_ID
MSC_SALES_ORDERS.SR_INSTANCE_ID |
MSC_SALES_ORDERS |
Foreign Key Column | Foreign Table |
---|---|
MSC_SALES_ORDERS.PARENT_DEMAND_ID
MSC_SALES_ORDERS.SR_INSTANCE_ID |
MSC_SALES_ORDERS |
MSC.MSC_SALES_ORDERS does not reference any database object
MSC.MSC_SALES_ORDERS is referenced by following:
Description: | This table stores the scheduling rules used to schedule lines. |
---|
MSC.MSC_SCHEDULING_RULES does not reference any database object
MSC.MSC_SCHEDULING_RULES is referenced by following:
Description: | This table is not used. |
---|
MSC.MSC_SECURITY_RULES does not reference any database object
MSC.MSC_SECURITY_RULES is referenced by following:
Description: | MSC Selection Criteria Stores the UI Search selection criteria |
---|
MSC.MSC_SELECTION_CRITERIA does not reference any database object
MSC.MSC_SELECTION_CRITERIA is referenced by following:
Description: | The table stores the sequence dependent setups and tears down. This is used by HLS to ensure a minimun delay between two operations using the same resource. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_SEQUENCE_DEPENDENT_SETUPS.FROM_ITEM
MSC_SEQUENCE_DEPENDENT_SETUPS.PLAN_ID MSC_SEQUENCE_DEPENDENT_SETUPS.SR_INSTANCE_ID MSC_SEQUENCE_DEPENDENT_SETUPS.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_SEQUENCE_DEPENDENT_SETUPS.TO_ITEM
MSC_SEQUENCE_DEPENDENT_SETUPS.PLAN_ID MSC_SEQUENCE_DEPENDENT_SETUPS.SR_INSTANCE_ID MSC_SEQUENCE_DEPENDENT_SETUPS.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC.MSC_SEQUENCE_DEPENDENT_SETUPS does not reference any database object
MSC.MSC_SEQUENCE_DEPENDENT_SETUPS is referenced by following:
Description: | This table stores unit level details for an onhand item. |
---|
MSC.MSC_SERIAL_NUMBERS does not reference any database object
MSC.MSC_SERIAL_NUMBERS is referenced by following:
Description: | Workday calendar shift dates |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_SHIFT_DATES.SR_INSTANCE_ID
MSC_SHIFT_DATES.CALENDAR_CODE MSC_SHIFT_DATES.SHIFT_NUM |
MSC_CALENDAR_SHIFTS |
MSC.MSC_SHIFT_DATES does not reference any database object
MSC.MSC_SHIFT_DATES is referenced by following:
Description: | Workday calendar shift exceptions |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_SHIFT_EXCEPTIONS.SR_INSTANCE_ID
MSC_SHIFT_EXCEPTIONS.CALENDAR_CODE MSC_SHIFT_EXCEPTIONS.SHIFT_NUM |
MSC_CALENDAR_SHIFTS |
MSC.MSC_SHIFT_EXCEPTIONS does not reference any database object
MSC.MSC_SHIFT_EXCEPTIONS is referenced by following:
Description: | Workday calendar shift times |
---|
MSC.MSC_SHIFT_TIMES does not reference any database object
MSC.MSC_SHIFT_TIMES is referenced by following:
Description: | This table Stores the Short text Content |
---|
MSC.MSC_SHORT_TEXT does not reference any database object
MSC.MSC_SHORT_TEXT is referenced by following:
Description: | This table stores the different simulation sets. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_NET_RESOURCE_AVAIL.SR_INSTANCE_ID
MSC_NET_RESOURCE_AVAIL.SIMULATION_SET MSC_NET_RESOURCE_AVAIL.ORGANIZATION_ID |
MSC_SIMULATION_SETS |
MSC.MSC_SIMULATION_SETS does not reference any database object
MSC.MSC_SIMULATION_SETS is referenced by following:
Description: | Single level supply to supply or supply to demand pegging. Currently used for DRP plans |
---|
MSC.MSC_SINGLE_LVL_PEG does not reference any database object
MSC.MSC_SINGLE_LVL_PEG is referenced by following:
Description: | Tasks to be performed by Snapshot Workers |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_SNAPSHOT_TASKS.PLAN_ID | MSC_PLANS |
MSC_SNAPSHOT_TASKS.PLAN_ID
MSC_SNAPSHOT_TASKS.DEPENDENT_TASK |
MSC_SNAPSHOT_TASKS |
MSC_SNAPSHOT_TASKS.PLAN_ID
MSC_SNAPSHOT_TASKS.DEPENDENT_TASK2 |
MSC_SNAPSHOT_TASKS |
Foreign Key Column | Foreign Table |
---|---|
MSC_SNAPSHOT_TASKS.PLAN_ID
MSC_SNAPSHOT_TASKS.DEPENDENT_TASK |
MSC_SNAPSHOT_TASKS |
MSC_SNAPSHOT_TASKS.PLAN_ID
MSC_SNAPSHOT_TASKS.DEPENDENT_TASK2 |
MSC_SNAPSHOT_TASKS |
MSC.MSC_SNAPSHOT_TASKS does not reference any database object
MSC.MSC_SNAPSHOT_TASKS is referenced by following:
Description: | This table describes the sorted details used by the Find window. |
---|
MSC.MSC_SORT_DATA does not reference any database object
MSC.MSC_SORT_DATA is referenced by following:
Description: | Historical information related to sourcing. |
---|
MSC.MSC_SOURCING_HISTORY does not reference any database object
MSC.MSC_SOURCING_HISTORY is referenced by following:
Description: | This table stores sourcing rules and bills of distribution information. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_ITEM_SOURCING.SOURCING_RULE_ID | MSC_SOURCING_RULES |
MSC_SR_ASSIGNMENTS.SOURCING_RULE_ID | MSC_SOURCING_RULES |
MSC_SR_RECEIPT_ORG.SOURCING_RULE_ID | MSC_SOURCING_RULES |
MSC.MSC_SOURCING_RULES does not reference any database object
MSC.MSC_SOURCING_RULES is referenced by following:
Description: |
---|
MSC.MSC_SOURCING_TRANSACTIONS does not reference any database object
MSC.MSC_SOURCING_TRANSACTIONS is referenced by following:
Description: | This table stores sql load parameters like table name, bindsize, number of rows etc. |
---|
MSC.MSC_SQLLOAD_PARAMETERS does not reference any database object
MSC.MSC_SQLLOAD_PARAMETERS is referenced by following:
Description: |
---|
MSC.MSC_SRP_ITEM_EXCEPTIONS does not reference any database object
MSC.MSC_SRP_ITEM_EXCEPTIONS is referenced by following:
Description: | This table stores the assignment of sourcing rules (or bills of distribution) to item, organization, category, or at the global level. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_SR_ASSIGNMENTS.SOURCING_RULE_ID | MSC_SOURCING_RULES |
MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID | MSC_ASSIGNMENT_SETS |
MSC_SR_ASSIGNMENTS.PARTNER_ID | MSC_TRADING_PARTNERS |
MSC_SR_ASSIGNMENTS.SHIP_TO_SITE_ID | MSC_TRADING_PARTNER_SITES |
MSC_SR_ASSIGNMENTS.CATEGORY_SET_ID | MSC_CATEGORY_SETS |
Foreign Key Column | Foreign Table |
---|---|
MSC_ITEM_SOURCING.ASSIGNMENT_ID | MSC_SR_ASSIGNMENTS |
MSC.MSC_SR_ASSIGNMENTS does not reference any database object
MSC.MSC_SR_ASSIGNMENTS is referenced by following:
Description: | Receiving Organizations for Sourcing Rules or Bills of distribution |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_SR_RECEIPT_ORG.SOURCING_RULE_ID | MSC_SOURCING_RULES |
MSC_SR_RECEIPT_ORG.RECEIPT_PARTNER_ID | MSC_TRADING_PARTNERS |
MSC_SR_RECEIPT_ORG.RECEIPT_PARTNER_SITE_ID | MSC_TRADING_PARTNER_SITES |
Foreign Key Column | Foreign Table |
---|---|
MSC_SR_SOURCE_ORG.SR_RECEIPT_ID | MSC_SR_RECEIPT_ORG |
MSC.MSC_SR_RECEIPT_ORG does not reference any database object
MSC.MSC_SR_RECEIPT_ORG is referenced by following:
Description: | Source organization for Sourcing Rules or Bills of distribution |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_SR_SOURCE_ORG.SR_RECEIPT_ID | MSC_SR_RECEIPT_ORG |
MSC_SR_SOURCE_ORG.SOURCE_PARTNER_ID | MSC_TRADING_PARTNERS |
MSC_SR_SOURCE_ORG.SOURCE_PARTNER_SITE_ID | MSC_TRADING_PARTNER_SITES |
MSC.MSC_SR_SOURCE_ORG does not reference any database object
MSC.MSC_SR_SOURCE_ORG is referenced by following:
Description: | Source side table that Stores the aggregated quantity of the install base item instances at item,date,zone level |
---|
MSC.MSC_SR_ZN_AGGR_IBUC does not reference any database object
MSC.MSC_SR_ZN_AGGR_IBUC is referenced by following:
Description: | The staging table used by the collection program to valid and process data for table MSC_ASSIGNMENT_SETS. |
---|
MSC.MSC_ST_ASSIGNMENT_SETS does not reference any database object
MSC.MSC_ST_ASSIGNMENT_SETS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_ATP_RULES. |
---|
MSC.MSC_ST_ATP_RULES does not reference any database object
MSC.MSC_ST_ATP_RULES is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_BILL_OF_RESOURCES. |
---|
MSC.MSC_ST_BILL_OF_RESOURCES does not reference any database object
MSC.MSC_ST_BILL_OF_RESOURCES is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_BIS_BUSINESS_PLANS. |
---|
MSC.MSC_ST_BIS_BUSINESS_PLANS does not reference any database object
MSC.MSC_ST_BIS_BUSINESS_PLANS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_BIS_PERIODS. |
---|
MSC.MSC_ST_BIS_PERIODS does not reference any database object
MSC.MSC_ST_BIS_PERIODS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_BIS_PFMC_MEASURES. |
---|
MSC.MSC_ST_BIS_PFMC_MEASURES does not reference any database object
MSC.MSC_ST_BIS_PFMC_MEASURES is referenced by following:
Description: | The staging table used by the collection program to valid and process data for table MSC_BIS_TARGETS. |
---|
MSC.MSC_ST_BIS_TARGETS does not reference any database object
MSC.MSC_ST_BIS_TARGETS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_BIS_TARGET_LEVELS |
---|
MSC.MSC_ST_BIS_TARGET_LEVELS does not reference any database object
MSC.MSC_ST_BIS_TARGET_LEVELS is referenced by following:
Description: | The staging table used by the collection program to valid and process data for table MSC_BOMS. |
---|
MSC.MSC_ST_BOMS does not reference any database object
MSC.MSC_ST_BOMS is referenced by following:
Description: | The staging table used by the collection program to valid and process data for table MSC_BOM_COMPONENTS. |
---|
MSC.MSC_ST_BOM_COMPONENTS does not reference any database object
MSC.MSC_ST_BOM_COMPONENTS is referenced by following:
Description: | The staging table used by the collection program to valid and process data for table MSC_BOR_REQUIREMENTS. |
---|
MSC.MSC_ST_BOR_REQUIREMENTS does not reference any database object
MSC.MSC_ST_BOR_REQUIREMENTS is referenced by following:
Description: |
---|
MSC.MSC_ST_BUDGETS_F does not reference any database object
MSC.MSC_ST_BUDGETS_F is referenced by following:
Description: | This is an interface table for staging definition of workday calendars from Legacy Instances. The 'Pre-Processor' would then validate the data in this table and insert into MSC_CALENDARS.You can follow any of the four following type of quar |
---|
MSC.MSC_ST_CALENDARS does not reference any database object
MSC.MSC_ST_CALENDARS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_CALENDAR_DATES. |
---|
MSC.MSC_ST_CALENDAR_DATES does not reference any database object
MSC.MSC_ST_CALENDAR_DATES is referenced by following:
Description: | This is an interface table for staging exception dates for calendar from Legacy Instances. The 'Pre-Processor' would then validate the data in this table and insert into MSC_CALENDAR_EXCEPTIONS. |
---|
MSC.MSC_ST_CALENDAR_EXCEPTIONS does not reference any database object
MSC.MSC_ST_CALENDAR_EXCEPTIONS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_CALENDAR_SHIFTS. |
---|
MSC.MSC_ST_CALENDAR_SHIFTS does not reference any database object
MSC.MSC_ST_CALENDAR_SHIFTS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_CAL_WEEK_START_DATES. |
---|
MSC.MSC_ST_CAL_WEEK_START_DATES does not reference any database object
MSC.MSC_ST_CAL_WEEK_START_DATES is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_YEAR_START_DATES. |
---|
MSC.MSC_ST_CAL_YEAR_START_DATES does not reference any database object
MSC.MSC_ST_CAL_YEAR_START_DATES is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_CATEGORY_SETS. |
---|
MSC.MSC_ST_CATEGORY_SETS does not reference any database object
MSC.MSC_ST_CATEGORY_SETS is referenced by following:
Description: | Staging table for user company association information. |
---|
MSC.MSC_ST_COMPANY_USERS does not reference any database object
MSC.MSC_ST_COMPANY_USERS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_COMPONENT_SUBSTITUTES. |
---|
MSC.MSC_ST_COMPONENT_SUBSTITUTES does not reference any database object
MSC.MSC_ST_COMPONENT_SUBSTITUTES is referenced by following:
Description: |
---|
MSC.MSC_ST_COSTS_F does not reference any database object
MSC.MSC_ST_COSTS_F is referenced by following:
Description: | This table is used for collecting the CO Product Bill in Legacy Collections |
---|
MSC.MSC_ST_CO_PRODUCTS does not reference any database object
MSC.MSC_ST_CO_PRODUCTS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_DEMANDS. |
---|
MSC.MSC_ST_DEMANDS does not reference any database object
MSC.MSC_ST_DEMANDS is referenced by following:
Description: |
---|
MSC.MSC_ST_DEMANDS_CUM_F does not reference any database object
MSC.MSC_ST_DEMANDS_CUM_F is referenced by following:
Description: |
---|
MSC.MSC_ST_DEMANDS_F does not reference any database object
MSC.MSC_ST_DEMANDS_F is referenced by following:
Description: | The staging table used by the collection program to validate and process data for demand classes. |
---|
MSC.MSC_ST_DEMAND_CLASSES does not reference any database object
MSC.MSC_ST_DEMAND_CLASSES is referenced by following:
Description: |
---|
MSC.MSC_ST_DEMANTRA_F does not reference any database object
MSC.MSC_ST_DEMANTRA_F is referenced by following:
Description: |
---|
MSC.MSC_ST_DEMANTRA_ODS_F does not reference any database object
MSC.MSC_ST_DEMANTRA_ODS_F is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_DEPARTMENT_RESOURCES. |
---|
MSC.MSC_ST_DEPARTMENT_RESOURCES does not reference any database object
MSC.MSC_ST_DEPARTMENT_RESOURCES is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_DESIGNTORS. |
---|
MSC.MSC_ST_DESIGNATORS does not reference any database object
MSC.MSC_ST_DESIGNATORS is referenced by following:
Description: | This staging table Stores the Attachment information |
---|
MSC.MSC_ST_DOC_ATTACHMENTS does not reference any database object
MSC.MSC_ST_DOC_ATTACHMENTS is referenced by following:
Description: |
---|
MSC.MSC_ST_EAM_ACT_ASSOCIATIONS does not reference any database object
MSC.MSC_ST_EAM_ACT_ASSOCIATIONS is referenced by following:
Description: |
---|
MSC.MSC_ST_EAM_ASSET_EQUIP_DTLS does not reference any database object
MSC.MSC_ST_EAM_ASSET_EQUIP_DTLS is referenced by following:
Description: |
---|
MSC.MSC_ST_EXCEPTIONS_F does not reference any database object
MSC.MSC_ST_EXCEPTIONS_F is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_GROUPS |
---|
MSC.MSC_ST_GROUPS does not reference any database object
MSC.MSC_ST_GROUPS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_GROUP_COMPANIES |
---|
MSC.MSC_ST_GROUP_COMPANIES does not reference any database object
MSC.MSC_ST_GROUP_COMPANIES is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_INTERORG_SHIP_METHODS. |
---|
MSC.MSC_ST_INTERORG_SHIP_METHODS does not reference any database object
MSC.MSC_ST_INTERORG_SHIP_METHODS is referenced by following:
Description: |
---|
MSC.MSC_ST_ITEMS_F does not reference any database object
MSC.MSC_ST_ITEMS_F is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_ITEM_CATEGORIES. |
---|
MSC.MSC_ST_ITEM_CATEGORIES does not reference any database object
MSC.MSC_ST_ITEM_CATEGORIES is referenced by following:
Description: | Staging table to hold item customers data. |
---|
MSC.MSC_ST_ITEM_CUSTOMERS does not reference any database object
MSC.MSC_ST_ITEM_CUSTOMERS is referenced by following:
Description: |
---|
MSC.MSC_ST_ITEM_INVENTORY_F does not reference any database object
MSC.MSC_ST_ITEM_INVENTORY_F is referenced by following:
Description: |
---|
MSC.MSC_ST_ITEM_ORDERS_F does not reference any database object
MSC.MSC_ST_ITEM_ORDERS_F is referenced by following:
Description: | This is a denormalized table for staging Sourcing Rules related data from Legacy Instances. The data in this table would be processed by the 'Pre-Processor' and sent to MSC_ST_ASSIGNMENT_SETS, MSC_ST_SR_ASSIGNMENTS, MSC_ST_SOURCING_RULES, M |
---|
MSC.MSC_ST_ITEM_SOURCING does not reference any database object
MSC.MSC_ST_ITEM_SOURCING is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_DEMANDS. |
---|
MSC.MSC_ST_ITEM_SUBSTITUTES does not reference any database object
MSC.MSC_ST_ITEM_SUBSTITUTES is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_ITEM_SUPPLIERS. |
---|
MSC.MSC_ST_ITEM_SUPPLIERS does not reference any database object
MSC.MSC_ST_ITEM_SUPPLIERS is referenced by following:
Description: |
---|
MSC.MSC_ST_ITEM_WIPS_F does not reference any database object
MSC.MSC_ST_ITEM_WIPS_F is referenced by following:
Description: |
---|
MSC.MSC_ST_JOB_OPERATIONS does not reference any database object
MSC.MSC_ST_JOB_OPERATIONS is referenced by following:
Description: |
---|
MSC.MSC_ST_JOB_OP_RESOURCES does not reference any database object
MSC.MSC_ST_JOB_OP_RESOURCES is referenced by following:
Description: |
---|
MSC.MSC_ST_JOB_REQUIREMENT_OPS does not reference any database object
MSC.MSC_ST_JOB_REQUIREMENT_OPS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_LOCATION_ASSOCIATIONS. |
---|
MSC.MSC_ST_LOCATION_ASSOCIATIONS does not reference any database object
MSC.MSC_ST_LOCATION_ASSOCIATIONS is referenced by following:
Description: | This table Stores the Long text Content |
---|
MSC.MSC_ST_LONG_TEXT does not reference any database object
MSC.MSC_ST_LONG_TEXT is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_NET_RESOURCE_AVAIL. |
---|
MSC.MSC_ST_NET_RESOURCE_AVAIL does not reference any database object
MSC.MSC_ST_NET_RESOURCE_AVAIL is referenced by following:
Description: |
---|
MSC.MSC_ST_NET_RES_INST_AVAIL does not reference any database object
MSC.MSC_ST_NET_RES_INST_AVAIL is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_OPERATION_COMPONENTS. |
---|
MSC.MSC_ST_OPERATION_COMPONENTS does not reference any database object
MSC.MSC_ST_OPERATION_COMPONENTS is referenced by following:
Description: | The staging table used by collections program to validate and process data for table MSC_OPERATION_NETWORKS. |
---|
MSC.MSC_ST_OPERATION_NETWORKS does not reference any database object
MSC.MSC_ST_OPERATION_NETWORKS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_OPERATION_RESOURCES. |
---|
MSC.MSC_ST_OPERATION_RESOURCES does not reference any database object
MSC.MSC_ST_OPERATION_RESOURCES is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_OPERATION_RESOURCE_SEQS. |
---|
MSC.MSC_ST_OPERATION_RESOURCE_SEQS does not reference any database object
MSC.MSC_ST_OPERATION_RESOURCE_SEQS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_PARAMETERS. |
---|
MSC.MSC_ST_PARAMETERS does not reference any database object
MSC.MSC_ST_PARAMETERS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_PARTNER_CONTACS. |
---|
MSC.MSC_ST_PARTNER_CONTACTS does not reference any database object
MSC.MSC_ST_PARTNER_CONTACTS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_PERIOD_START_DATES. |
---|
MSC.MSC_ST_PERIOD_START_DATES does not reference any database object
MSC.MSC_ST_PERIOD_START_DATES is referenced by following:
Description: | The staging table used by the collection program to validate and processdata for table MSC_PLANNERS.... |
---|
MSC.MSC_ST_PLANNERS does not reference any database object
MSC.MSC_ST_PLANNERS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_PROCESS_EFFECTIVITY. |
---|
MSC.MSC_ST_PROCESS_EFFECTIVITY does not reference any database object
MSC.MSC_ST_PROCESS_EFFECTIVITY is referenced by following:
Description: | This is the staging table to keep the profile options |
---|
MSC.MSC_ST_PROFILES does not reference any database object
MSC.MSC_ST_PROFILES is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_PROJECTS. |
---|
MSC.MSC_ST_PROJECTS does not reference any database object
MSC.MSC_ST_PROJECTS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_PROJECT_TASKS. |
---|
MSC.MSC_ST_PROJECT_TASKS does not reference any database object
MSC.MSC_ST_PROJECT_TASKS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_REGIONS. |
---|
MSC.MSC_ST_REGIONS does not reference any database object
MSC.MSC_ST_REGIONS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_REGION_LOCATIONS. |
---|
MSC.MSC_ST_REGION_LOCATIONS does not reference any database object
MSC.MSC_ST_REGION_LOCATIONS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_RESERVATIONS. |
---|
MSC.MSC_ST_RESERVATIONS does not reference any database object
MSC.MSC_ST_RESERVATIONS is referenced by following:
Description: |
---|
MSC.MSC_ST_RESOURCES_CUM_F does not reference any database object
MSC.MSC_ST_RESOURCES_CUM_F is referenced by following:
Description: |
---|
MSC.MSC_ST_RESOURCES_F does not reference any database object
MSC.MSC_ST_RESOURCES_F is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_RESOURCE_CHANGES. |
---|
MSC.MSC_ST_RESOURCE_CHANGES does not reference any database object
MSC.MSC_ST_RESOURCE_CHANGES is referenced by following:
Description: | The staging table used by the collection program to validate and processdata for table MSC_ST_RESOURCE_CHANGES. |
---|
MSC.MSC_ST_RESOURCE_GROUPS does not reference any database object
MSC.MSC_ST_RESOURCE_GROUPS is referenced by following:
Description: |
---|
MSC.MSC_ST_RESOURCE_INSTANCE_REQS does not reference any database object
MSC.MSC_ST_RESOURCE_INSTANCE_REQS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_RESOURCE_REQUIREMENTS. |
---|
MSC.MSC_ST_RESOURCE_REQUIREMENTS does not reference any database object
MSC.MSC_ST_RESOURCE_REQUIREMENTS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_RESOURCE_SHIFTS. |
---|
MSC.MSC_ST_RESOURCE_SHIFTS does not reference any database object
MSC.MSC_ST_RESOURCE_SHIFTS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_ROUTINGS. |
---|
MSC.MSC_ST_ROUTINGS does not reference any database object
MSC.MSC_ST_ROUTINGS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_ROUTING_OPERATIONS. |
---|
MSC.MSC_ST_ROUTING_OPERATIONS does not reference any database object
MSC.MSC_ST_ROUTING_OPERATIONS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_SAFETY_STOCKS. |
---|
MSC.MSC_ST_SAFETY_STOCKS does not reference any database object
MSC.MSC_ST_SAFETY_STOCKS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_SALES_ORDERS. |
---|
MSC.MSC_ST_SALES_ORDERS does not reference any database object
MSC.MSC_ST_SALES_ORDERS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_SERIAL_NUMBERS. |
---|
MSC.MSC_ST_SERIAL_NUMBERS does not reference any database object
MSC.MSC_ST_SERIAL_NUMBERS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_SHIFT_DATES. |
---|
MSC.MSC_ST_SHIFT_DATES does not reference any database object
MSC.MSC_ST_SHIFT_DATES is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_SHIFT_EXCEPTIONS. |
---|
MSC.MSC_ST_SHIFT_EXCEPTIONS does not reference any database object
MSC.MSC_ST_SHIFT_EXCEPTIONS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_SHIFT_TIMES. |
---|
MSC.MSC_ST_SHIFT_TIMES does not reference any database object
MSC.MSC_ST_SHIFT_TIMES is referenced by following:
Description: | This staging table Stores the Short text Content |
---|
MSC.MSC_ST_SHORT_TEXT does not reference any database object
MSC.MSC_ST_SHORT_TEXT is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_SIMULATION_SETS. |
---|
MSC.MSC_ST_SIMULATION_SETS does not reference any database object
MSC.MSC_ST_SIMULATION_SETS is referenced by following:
Description: | Historical information related to Sourcing |
---|
MSC.MSC_ST_SOURCING_HISTORY does not reference any database object
MSC.MSC_ST_SOURCING_HISTORY is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_SOURCING_RULES. |
---|
MSC.MSC_ST_SOURCING_RULES does not reference any database object
MSC.MSC_ST_SOURCING_RULES is referenced by following:
Description: | The staging table used by the collection program to valid and process data for table MSC_SR_ASSIGNMENTS. |
---|
MSC.MSC_ST_SR_ASSIGNMENTS does not reference any database object
MSC.MSC_ST_SR_ASSIGNMENTS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_SR_RECEIPT_ORG. |
---|
MSC.MSC_ST_SR_RECEIPT_ORG does not reference any database object
MSC.MSC_ST_SR_RECEIPT_ORG is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_SR_SOURCE_ORG. |
---|
MSC.MSC_ST_SR_SOURCE_ORG does not reference any database object
MSC.MSC_ST_SR_SOURCE_ORG is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_SUB_INVENTORIES. |
---|
MSC.MSC_ST_SUB_INVENTORIES does not reference any database object
MSC.MSC_ST_SUB_INVENTORIES is referenced by following:
Description: |
---|
MSC.MSC_ST_SUPPLIERS_F does not reference any database object
MSC.MSC_ST_SUPPLIERS_F is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_SUPPLIER_CAPACITIES. |
---|
MSC.MSC_ST_SUPPLIER_CAPACITIES does not reference any database object
MSC.MSC_ST_SUPPLIER_CAPACITIES is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_SUPPLIER_FLEX_FENCES. |
---|
MSC.MSC_ST_SUPPLIER_FLEX_FENCES does not reference any database object
MSC.MSC_ST_SUPPLIER_FLEX_FENCES is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_SUPPLIES. |
---|
MSC.MSC_ST_SUPPLIES does not reference any database object
MSC.MSC_ST_SUPPLIES is referenced by following:
Description: |
---|
MSC.MSC_ST_SUPPLIES_F does not reference any database object
MSC.MSC_ST_SUPPLIES_F is referenced by following:
Description: | The staging table used by the collection program to valid and process data for table MSC_SYSTEM_ITEMS. |
---|
MSC.MSC_ST_SYSTEM_ITEMS does not reference any database object
MSC.MSC_ST_SYSTEM_ITEMS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_TRADING_PARTNERS. |
---|
MSC.MSC_ST_TRADING_PARTNERS does not reference any database object
MSC.MSC_ST_TRADING_PARTNERS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_TRADING_PARTNER_SITES. |
---|
MSC.MSC_ST_TRADING_PARTNER_SITES does not reference any database object
MSC.MSC_ST_TRADING_PARTNER_SITES is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_UNITS_OF_MEASURE. |
---|
MSC.MSC_ST_UNITS_OF_MEASURE does not reference any database object
MSC.MSC_ST_UNITS_OF_MEASURE is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_UNIT_NUMBERS. |
---|
MSC.MSC_ST_UNIT_NUMBERS does not reference any database object
MSC.MSC_ST_UNIT_NUMBERS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_UOM_CLASS_CONVERSIONS. |
---|
MSC.MSC_ST_UOM_CLASS_CONVERSIONS does not reference any database object
MSC.MSC_ST_UOM_CLASS_CONVERSIONS is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_UOM_CONVERSIONS. |
---|
MSC.MSC_ST_UOM_CONVERSIONS does not reference any database object
MSC.MSC_ST_UOM_CONVERSIONS is referenced by following:
Description: |
---|
MSC.MSC_ST_VISITS does not reference any database object
MSC.MSC_ST_VISITS is referenced by following:
Description: |
---|
MSC.MSC_ST_WAREHOUSE_F does not reference any database object
MSC.MSC_ST_WAREHOUSE_F is referenced by following:
Description: | This is an interface table for staging days on/days off patterns for your calendar and your shifts from Legacy Instances. The 'Pre-Processor' would then validate the data in this table and insert into MSC_WORKDAY_PATTERNS.SEQ_NUM is the ord |
---|
MSC.MSC_ST_WORKDAY_PATTERNS does not reference any database object
MSC.MSC_ST_WORKDAY_PATTERNS is referenced by following:
Description: |
---|
MSC.MSC_ST_WORK_BREAKDOWN_STRUCT does not reference any database object
MSC.MSC_ST_WORK_BREAKDOWN_STRUCT is referenced by following:
Description: |
---|
MSC.MSC_ST_WO_ATTRIBUTES does not reference any database object
MSC.MSC_ST_WO_ATTRIBUTES is referenced by following:
Description: |
---|
MSC.MSC_ST_WO_MILESTONES does not reference any database object
MSC.MSC_ST_WO_MILESTONES is referenced by following:
Description: |
---|
MSC.MSC_ST_WO_OPERATION_REL does not reference any database object
MSC.MSC_ST_WO_OPERATION_REL is referenced by following:
Description: |
---|
MSC.MSC_ST_WO_SUB_COMP does not reference any database object
MSC.MSC_ST_WO_SUB_COMP is referenced by following:
Description: |
---|
MSC.MSC_ST_WO_TASK_HIERARCHY does not reference any database object
MSC.MSC_ST_WO_TASK_HIERARCHY is referenced by following:
Description: | This is the staging table that Stores the aggregated quantity of the install base item instances at item,date,zone level |
---|
MSC.MSC_ST_ZN_AGGR_IBUC does not reference any database object
MSC.MSC_ST_ZN_AGGR_IBUC is referenced by following:
Description: | The staging table used by the collection program to validate and process data for table MSC_ZONE_REGIONS. |
---|
MSC.MSC_ST_ZONE_REGIONS does not reference any database object
MSC.MSC_ST_ZONE_REGIONS is referenced by following:
Description: | MSC_SUB_INVENTORIES stores information about the netting type of eachsubinventory defined in Oracle Inventory. Each subinventory will havean entry in MSC_SUB_INVENTORIES and NETTING_TYPE will indicate whetheror not that subinventory should |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_SUB_INVENTORIES.PLAN_ID
MSC_SUB_INVENTORIES.ORGANIZATION_ID MSC_SUB_INVENTORIES.SR_INSTANCE_ID |
MSC_PLAN_ORGANIZATIONS |
Foreign Key Column | Foreign Table |
---|---|
MSC_RESERVATIONS.SR_INSTANCE_ID
MSC_RESERVATIONS.PLAN_ID MSC_RESERVATIONS.ORGANIZATION_ID MSC_RESERVATIONS.SUBINVENTORY |
MSC_SUB_INVENTORIES |
MSC.MSC_SUB_INVENTORIES does not reference any database object
MSC.MSC_SUB_INVENTORIES is referenced by following:
Description: |
---|
MSC.MSC_SUPDEM_HDRS_INTERFACE does not reference any database object
MSC.MSC_SUPDEM_HDRS_INTERFACE is referenced by following:
Description: | Supply demand lines interface table |
---|
MSC.MSC_SUPDEM_LINES_INTERFACE does not reference any database object
MSC.MSC_SUPDEM_LINES_INTERFACE is referenced by following:
Description: |
---|
MSC.MSC_SUPPLIERS_F does not reference any database object
MSC.MSC_SUPPLIERS_F is referenced by following:
Description: | This table stores the capacity information for planned items within an MPS, MRP, or DRP plan. Each row stores the capacity within a date range for a specific supplier of an item. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_SUPPLIER_CAPACITIES.PLAN_ID
MSC_SUPPLIER_CAPACITIES.PARENT_ID |
MSC_SUPPLIER_CAPACITIES |
Foreign Key Column | Foreign Table |
---|---|
MSC_SUPPLIER_CAPACITIES.PLAN_ID
MSC_SUPPLIER_CAPACITIES.PARENT_ID |
MSC_SUPPLIER_CAPACITIES |
MSC.MSC_SUPPLIER_CAPACITIES does not reference any database object
MSC.MSC_SUPPLIER_CAPACITIES is referenced by following:
Description: | MSC_SUPPLIER_FLEX_FENCES stores the supplier flex fence information for planned items within an MPS, MRP, or DRP plan. Each row stores the tolerance percentage a supplier allows for a certain number of days in advance for an item.This tab |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_SUPPLIER_FLEX_FENCES.PLAN_ID
MSC_SUPPLIER_FLEX_FENCES.PARENT_ID |
MSC_SUPPLIER_FLEX_FENCES |
Foreign Key Column | Foreign Table |
---|---|
MSC_SUPPLIER_FLEX_FENCES.PLAN_ID
MSC_SUPPLIER_FLEX_FENCES.PARENT_ID |
MSC_SUPPLIER_FLEX_FENCES |
MSC.MSC_SUPPLIER_FLEX_FENCES does not reference any database object
MSC.MSC_SUPPLIER_FLEX_FENCES is referenced by following:
Description: | This table stores the supplier lead time variabilities |
---|
MSC.MSC_SUPPLIER_LT_OUTCOMES does not reference any database object
MSC.MSC_SUPPLIER_LT_OUTCOMES is referenced by following:
Description: | MSC_SUPPLIER_PLANS is a generic table used by forms for querying data. This table is used to display supplier plan information in the Planner Workbench. QUERY_ID is the query identifier used while populating the table. The QUANTITY column |
---|
MSC.MSC_SUPPLIER_PLANS does not reference any database object
MSC.MSC_SUPPLIER_PLANS is referenced by following:
Description: |
---|
MSC.MSC_SUPPLIER_REQUIREMENTS does not reference any database object
MSC.MSC_SUPPLIER_REQUIREMENTS is referenced by following:
Description: | This table lists all the supplies for this plan. The supplies created by the planning process are added to this table. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_SUPPLIES.INVENTORY_ITEM_ID
MSC_SUPPLIES.PLAN_ID MSC_SUPPLIES.SR_INSTANCE_ID MSC_SUPPLIES.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_SUPPLIES.SCHEDULE_DESIGNATOR_ID | MSC_DESIGNATORS |
MSC_SUPPLIES.PLAN_ID
MSC_SUPPLIES.SR_INSTANCE_ID MSC_SUPPLIES.PROJECT_ID MSC_SUPPLIES.ORGANIZATION_ID |
MSC_PROJECTS |
MSC_SUPPLIES.ORGANIZATION_ID
MSC_SUPPLIES.TASK_ID MSC_SUPPLIES.PROJECT_ID MSC_SUPPLIES.SR_INSTANCE_ID MSC_SUPPLIES.PLAN_ID |
MSC_PROJECT_TASKS |
MSC_SUPPLIES.PLAN_ID
MSC_SUPPLIES.SR_INSTANCE_ID MSC_SUPPLIES.IMPLEMENT_PROJECT_ID MSC_SUPPLIES.ORGANIZATION_ID |
MSC_PROJECTS |
MSC_SUPPLIES.ORGANIZATION_ID
MSC_SUPPLIES.IMPLEMENT_TASK_ID MSC_SUPPLIES.IMPLEMENT_PROJECT_ID MSC_SUPPLIES.SR_INSTANCE_ID MSC_SUPPLIES.PLAN_ID |
MSC_PROJECT_TASKS |
Foreign Key Column | Foreign Table |
---|---|
MSC_DEMANDS.PLAN_ID
MSC_DEMANDS.DISPOSITION_ID |
MSC_SUPPLIES |
MSC_FULL_PEGGING.PLAN_ID
MSC_FULL_PEGGING.TRANSACTION_ID |
MSC_SUPPLIES |
MSC_RESOURCE_REQUIREMENTS.PLAN_ID
MSC_RESOURCE_REQUIREMENTS.SUPPLY_ID |
MSC_SUPPLIES |
MSC.MSC_SUPPLIES does not reference any database object
MSC.MSC_SUPPLIES is referenced by following:
Description: |
---|
MSC.MSC_SUPPLIES_F does not reference any database object
MSC.MSC_SUPPLIES_F is referenced by following:
Description: | This table holds transaction data for Oracle Collaborative planning. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_SUP_DEM_ENTRIES.INVENTORY_ITEM_ID | ICX_POR_ITEMS |
MSC_SUP_DEM_ENTRIES.PLAN_ID | MSC_PLANS |
MSC.MSC_SUP_DEM_ENTRIES does not reference any database object
MSC.MSC_SUP_DEM_ENTRIES is referenced by following:
Description: | Table to maintain historical information on data loaded into Oracle Collaborative planning. |
---|
MSC.MSC_SUP_DEM_HISTORY does not reference any database object
MSC.MSC_SUP_DEM_HISTORY is referenced by following:
Description: |
---|
MSC.MSC_SUP_HEADERS_INTERFACE does not reference any database object
MSC.MSC_SUP_HEADERS_INTERFACE is referenced by following:
Description: |
---|
MSC.MSC_SUP_LINES_INTERFACE does not reference any database object
MSC.MSC_SUP_LINES_INTERFACE is referenced by following:
Description: | MSC_SYSTEM_ITEMS stores the organization items defined at source applications. It also stores a copy of items planned by the planning process. Most of the columns in MSC_SYSTEM_ITEMS correspond to columns from the Oracle Inventory Item mast |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_SYSTEM_ITEMS.PLAN_ID
MSC_SYSTEM_ITEMS.ORGANIZATION_ID MSC_SYSTEM_ITEMS.SR_INSTANCE_ID |
MSC_PLAN_ORGANIZATIONS |
MSC_SYSTEM_ITEMS.ABC_CLASS
MSC_SYSTEM_ITEMS.SR_INSTANCE_ID |
MSC_ABC_CLASSES |
Foreign Key Column | Foreign Table |
---|---|
MSC_AVAILABLE_TO_PROMISE.INVENTORY_ITEM_ID
MSC_AVAILABLE_TO_PROMISE.PLAN_ID MSC_AVAILABLE_TO_PROMISE.SR_INSTANCE_ID MSC_AVAILABLE_TO_PROMISE.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_SYSTEM_ITEMS | |
MSC_BOMS.ASSEMBLY_ITEM_ID
MSC_BOMS.PLAN_ID MSC_BOMS.SR_INSTANCE_ID MSC_BOMS.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_BOM_COMPONENTS.INVENTORY_ITEM_ID
MSC_BOM_COMPONENTS.PLAN_ID MSC_BOM_COMPONENTS.SR_INSTANCE_ID MSC_BOM_COMPONENTS.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_BOR_REQUIREMENTS.ASSEMBLY_ITEM_ID
MSC_BOR_REQUIREMENTS.PLAN_ID MSC_BOR_REQUIREMENTS.SR_INSTANCE_ID MSC_BOR_REQUIREMENTS.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_DEMANDS.INVENTORY_ITEM_ID
MSC_DEMANDS.PLAN_ID MSC_DEMANDS.SR_INSTANCE_ID MSC_DEMANDS.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_DEMANDS.USING_ASSEMBLY_ITEM_ID
MSC_DEMANDS.PLAN_ID MSC_DEMANDS.SR_INSTANCE_ID MSC_DEMANDS.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_EXCEPTION_DETAILS.INVENTORY_ITEM_ID
MSC_EXCEPTION_DETAILS.PLAN_ID MSC_EXCEPTION_DETAILS.SR_INSTANCE_ID MSC_EXCEPTION_DETAILS.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_FORECAST_UPDATES.INVENTORY_ITEM_ID
MSC_FORECAST_UPDATES.PLAN_ID MSC_FORECAST_UPDATES.SR_INSTANCE_ID MSC_FORECAST_UPDATES.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_FULL_PEGGING.INVENTORY_ITEM_ID
MSC_FULL_PEGGING.PLAN_ID MSC_FULL_PEGGING.SR_INSTANCE_ID MSC_FULL_PEGGING.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_ITEM_EXCEPTIONS.INVENTORY_ITEM_ID
MSC_ITEM_EXCEPTIONS.PLAN_ID MSC_ITEM_EXCEPTIONS.SR_INSTANCE_ID MSC_ITEM_EXCEPTIONS.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_ITEM_SOURCING.INVENTORY_ITEM_ID
MSC_ITEM_SOURCING.PLAN_ID MSC_ITEM_SOURCING.SR_INSTANCE_ID MSC_ITEM_SOURCING.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_ITEM_SUPPLIERS.INVENTORY_ITEM_ID
MSC_ITEM_SUPPLIERS.PLAN_ID MSC_ITEM_SUPPLIERS.SR_INSTANCE_ID MSC_ITEM_SUPPLIERS.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_PROCESS_EFFECTIVITY.ITEM_ID
MSC_PROCESS_EFFECTIVITY.PLAN_ID MSC_PROCESS_EFFECTIVITY.SR_INSTANCE_ID MSC_PROCESS_EFFECTIVITY.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_RESERVATIONS.INVENTORY_ITEM_ID
MSC_RESERVATIONS.PLAN_ID MSC_RESERVATIONS.SR_INSTANCE_ID MSC_RESERVATIONS.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_ROUTINGS.ASSEMBLY_ITEM_ID
MSC_ROUTINGS.PLAN_ID MSC_ROUTINGS.SR_INSTANCE_ID MSC_ROUTINGS.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_SAFETY_STOCKS.INVENTORY_ITEM_ID
MSC_SAFETY_STOCKS.PLAN_ID MSC_SAFETY_STOCKS.SR_INSTANCE_ID MSC_SAFETY_STOCKS.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_SEQUENCE_DEPENDENT_SETUPS.FROM_ITEM
MSC_SEQUENCE_DEPENDENT_SETUPS.PLAN_ID MSC_SEQUENCE_DEPENDENT_SETUPS.SR_INSTANCE_ID MSC_SEQUENCE_DEPENDENT_SETUPS.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_SEQUENCE_DEPENDENT_SETUPS.TO_ITEM
MSC_SEQUENCE_DEPENDENT_SETUPS.PLAN_ID MSC_SEQUENCE_DEPENDENT_SETUPS.SR_INSTANCE_ID MSC_SEQUENCE_DEPENDENT_SETUPS.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_SUPPLIES.INVENTORY_ITEM_ID
MSC_SUPPLIES.PLAN_ID MSC_SUPPLIES.SR_INSTANCE_ID MSC_SUPPLIES.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC_COMPONENT_SUBSTITUTES.SUBSTITUTE_ITEM_ID
MSC_COMPONENT_SUBSTITUTES.PLAN_ID MSC_COMPONENT_SUBSTITUTES.SR_INSTANCE_ID MSC_COMPONENT_SUBSTITUTES.ORGANIZATION_ID |
MSC_SYSTEM_ITEMS |
MSC.MSC_SYSTEM_ITEMS does not reference any database object
MSC.MSC_SYSTEM_ITEMS is referenced by following:
Description: | Child table to MSC_DEMANDS storing pre-allocated demands |
---|
MSC.MSC_TEMP_ALLOC_DEMANDS does not reference any database object
MSC.MSC_TEMP_ALLOC_DEMANDS is referenced by following:
Description: | Child table to MSC_SUPPLIES storing pre-allocated supplies. Used during ATP post plan processing |
---|
MSC.MSC_TEMP_ALLOC_SUPPLIES does not reference any database object
MSC.MSC_TEMP_ALLOC_SUPPLIES is referenced by following:
Description: |
---|
MSC.MSC_TEMP_REGION_LOCATIONS does not reference any database object
MSC.MSC_TEMP_REGION_LOCATIONS is referenced by following:
Description: |
---|
MSC.MSC_TEMP_SALES_ORDERS does not reference any database object
MSC.MSC_TEMP_SALES_ORDERS is referenced by following:
Description: | Temp table for calculating resource summary data. (unused) |
---|
MSC.MSC_TEMP_SUMM_RES does not reference any database object
MSC.MSC_TEMP_SUMM_RES is referenced by following:
Description: | Temp table for calculating supply/demand summary data during post plan processing |
---|
MSC.MSC_TEMP_SUMM_SD does not reference any database object
MSC.MSC_TEMP_SUMM_SD is referenced by following:
Description: | Temp table used to calculate summary data for sales orders during post plan processing |
---|
MSC.MSC_TEMP_SUMM_SO does not reference any database object
MSC.MSC_TEMP_SUMM_SO is referenced by following:
Description: | Temp table for calculating supply summary data for post plan processing. (unused) |
---|
MSC.MSC_TEMP_SUMM_SUP does not reference any database object
MSC.MSC_TEMP_SUMM_SUP is referenced by following:
Description: | This table is used by the collection program to maintain the correspondence between the source instances identifiers and the planning identifiers for trading partners. |
---|
MSC.MSC_TP_ID_LID does not reference any database object
MSC.MSC_TP_ID_LID is referenced by following:
Description: | This table is used by the collection program to maintain the correspondence between the source instances identifiers and the planning identifiers for trading partner sites. |
---|
MSC.MSC_TP_SITE_ID_LID does not reference any database object
MSC.MSC_TP_SITE_ID_LID is referenced by following:
Description: | This table stores information about the different organizations: customers, vendors, and planned organizations. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_TRADING_PARTNERS.MODELED_CUSTOMER_ID | MSC_TRADING_PARTNERS |
MSC_TRADING_PARTNERS.MODELED_SUPPLIER_ID | MSC_TRADING_PARTNERS |
MSC_TRADING_PARTNERS.MODELED_CUSTOMER_SITE_ID | MSC_TRADING_PARTNER_SITES |
MSC_TRADING_PARTNERS.MODELED_SUPPLIER_SITE_ID | MSC_TRADING_PARTNER_SITES |
Foreign Key Column | Foreign Table |
---|---|
MSC_ALLOCATIONS.PARTNER_ID | MSC_TRADING_PARTNERS |
MSC_DEMANDS.CUSTOMER_ID | MSC_TRADING_PARTNERS |
MSC_ITEM_SOURCING.SUPPLIER_ID | MSC_TRADING_PARTNERS |
MSC_ITEM_SUPPLIERS.SUPPLIER_ID | MSC_TRADING_PARTNERS |
MSC_LOCATION_ASSOCIATIONS.PARTNER_ID | MSC_TRADING_PARTNERS |
MSC_PARTNER_CONTACTS.PARTNER_ID | MSC_TRADING_PARTNERS |
MSC_SR_ASSIGNMENTS.PARTNER_ID | MSC_TRADING_PARTNERS |
MSC_SR_RECEIPT_ORG.RECEIPT_PARTNER_ID | MSC_TRADING_PARTNERS |
MSC_SR_SOURCE_ORG.SOURCE_PARTNER_ID | MSC_TRADING_PARTNERS |
MSC_TRADING_PARTNERS.MODELED_CUSTOMER_ID | MSC_TRADING_PARTNERS |
MSC_TRADING_PARTNERS.MODELED_SUPPLIER_ID | MSC_TRADING_PARTNERS |
MSC_TRADING_PARTNER_SITES.PARTNER_ID | MSC_TRADING_PARTNERS |
MSC.MSC_TRADING_PARTNERS does not reference any database object
MSC.MSC_TRADING_PARTNERS is referenced by following:
Description: | This table contains mapping of data between MSC_TRADING_PARTNERS andMSC_COMPANIES and MSC_COMPANY_SITES table. |
---|
MSC.MSC_TRADING_PARTNER_MAPS does not reference any database object
MSC.MSC_TRADING_PARTNER_MAPS is referenced by following:
Description: | This table stores information about the different sites of an organization. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_TRADING_PARTNER_SITES.PARTNER_ID | MSC_TRADING_PARTNERS |
Foreign Key Column | Foreign Table |
---|---|
MSC_ALLOCATIONS.PARTNER_SITE_ID | MSC_TRADING_PARTNER_SITES |
MSC_DEMANDS.SHIP_TO_SITE_ID | MSC_TRADING_PARTNER_SITES |
MSC_DEMANDS.CUSTOMER_SITE_ID | MSC_TRADING_PARTNER_SITES |
MSC_ITEM_SOURCING.SUPPLIER_SITE_ID | MSC_TRADING_PARTNER_SITES |
MSC_ITEM_SUPPLIERS.SUPPLIER_SITE_ID | MSC_TRADING_PARTNER_SITES |
MSC_LOCATION_ASSOCIATIONS.PARTNER_SITE_ID | MSC_TRADING_PARTNER_SITES |
MSC_PARTNER_CONTACTS.PARTNER_SITE_ID | MSC_TRADING_PARTNER_SITES |
MSC_SR_ASSIGNMENTS.SHIP_TO_SITE_ID | MSC_TRADING_PARTNER_SITES |
MSC_SR_RECEIPT_ORG.RECEIPT_PARTNER_SITE_ID | MSC_TRADING_PARTNER_SITES |
MSC_SR_SOURCE_ORG.SOURCE_PARTNER_SITE_ID | MSC_TRADING_PARTNER_SITES |
MSC_TRADING_PARTNERS.MODELED_CUSTOMER_SITE_ID | MSC_TRADING_PARTNER_SITES |
MSC_TRADING_PARTNERS.MODELED_SUPPLIER_SITE_ID | MSC_TRADING_PARTNER_SITES |
MSC.MSC_TRADING_PARTNER_SITES does not reference any database object
MSC.MSC_TRADING_PARTNER_SITES is referenced by following:
Description: | This table describes the details of changes made to plan output. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_UNDO_DETAILS.UNDO_ID | MSC_UNDO_SUMMARY |
MSC.MSC_UNDO_DETAILS does not reference any database object
MSC.MSC_UNDO_DETAILS is referenced by following:
Description: | This table describes the summary of changes made to plan output. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_UNDO_DETAILS.UNDO_ID | MSC_UNDO_SUMMARY |
MSC.MSC_UNDO_SUMMARY does not reference any database object
MSC.MSC_UNDO_SUMMARY is referenced by following:
Description: | Unit of measure definitions |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_UOM_CONVERSIONS.UNIT_OF_MEASURE | MSC_UNITS_OF_MEASURE |
MSC_UOM_CLASS_CONVERSIONS.FROM_UNIT_OF_MEASURE | MSC_UNITS_OF_MEASURE |
MSC_UOM_CLASS_CONVERSIONS.TO_UNIT_OF_MEASURE | MSC_UNITS_OF_MEASURE |
MSC.MSC_UNITS_OF_MEASURE does not reference any database object
MSC.MSC_UNITS_OF_MEASURE is referenced by following:
Description: | This table stores the different units numbers. |
---|
MSC.MSC_UNIT_NUMBERS does not reference any database object
MSC.MSC_UNIT_NUMBERS is referenced by following:
Description: | Conversions between base units of two different classes |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_UOM_CLASS_CONVERSIONS.FROM_UNIT_OF_MEASURE | MSC_UNITS_OF_MEASURE |
MSC_UOM_CLASS_CONVERSIONS.TO_UNIT_OF_MEASURE | MSC_UNITS_OF_MEASURE |
MSC.MSC_UOM_CLASS_CONVERSIONS does not reference any database object
MSC.MSC_UOM_CLASS_CONVERSIONS is referenced by following:
Description: | This table stores the different non-base unit of measures known conversions. |
---|
Foreign Key Column | Foreign Table |
---|---|
MSC_UOM_CONVERSIONS.UNIT_OF_MEASURE | MSC_UNITS_OF_MEASURE |
MSC.MSC_UOM_CONVERSIONS does not reference any database object
MSC.MSC_UOM_CONVERSIONS is referenced by following:
Description: | User Defied expressions for custom exceptions. |
---|
MSC.MSC_USER_ADV_EXPRESSIONS does not reference any database object
MSC.MSC_USER_ADV_EXPRESSIONS is referenced by following:
Description: | MSC_USER_EXCEPTIONS is the header table for user defined exceptions. It stores attributes such as the name and the schedule for the user defined exception. |
---|
MSC.MSC_USER_EXCEPTIONS does not reference any database object
MSC.MSC_USER_EXCEPTIONS is referenced by following:
Description: | Holds components of a custom exception: Select clause attributes, simple condition attributes, advanced condition attributes |
---|
MSC.MSC_USER_EXCEPTION_COMPONENTS does not reference any database object
MSC.MSC_USER_EXCEPTION_COMPONENTS is referenced by following:
Description: | Recipients for exception notifications |
---|
MSC.MSC_USER_EXCEPTION_NTFS does not reference any database object
MSC.MSC_USER_EXCEPTION_NTFS is referenced by following:
Description: |
---|
MSC.MSC_VISITS does not reference any database object
MSC.MSC_VISITS is referenced by following:
Description: |
---|
MSC.MSC_WAREHOUSE_F does not reference any database object
MSC.MSC_WAREHOUSE_F is referenced by following:
Description: | Requests to add/delete/ modify material/resource requirements for jobs and schedules |
---|
MSC.MSC_WIP_JOB_DTLS_INTERFACE does not reference any database object
MSC.MSC_WIP_JOB_DTLS_INTERFACE is referenced by following:
Description: | Requests to create or modify jobs and schedules |
---|
MSC.MSC_WIP_JOB_SCHEDULE_INTERFACE does not reference any database object
MSC.MSC_WIP_JOB_SCHEDULE_INTERFACE is referenced by following:
Description: | User display preferences for Planner Workbench in APS and horizontal plan screen in Supply Chain Hub. |
---|
MSC.MSC_WORKBENCH_DISPLAY_OPTIONS does not reference any database object
MSC.MSC_WORKBENCH_DISPLAY_OPTIONS is referenced by following:
Description: | MSC_WORKDAY_PATTERNS stores the days on/days off patterns for your calendar and your shifts. You can define multiple days on/days off to form a repetitive pattern. The calendar compile program (MSCPCL) will create a workday calendar based o |
---|
MSC.MSC_WORKDAY_PATTERNS does not reference any database object
MSC.MSC_WORKDAY_PATTERNS is referenced by following:
Description: |
---|
MSC.MSC_WORK_BREAKDOWN_STRUCT does not reference any database object
MSC.MSC_WORK_BREAKDOWN_STRUCT is referenced by following:
Description: |
---|
MSC.MSC_WO_ATTRIBUTES does not reference any database object
MSC.MSC_WO_ATTRIBUTES is referenced by following:
Description: |
---|
MSC.MSC_WO_MILESTONES does not reference any database object
MSC.MSC_WO_MILESTONES is referenced by following:
Description: |
---|
MSC.MSC_WO_OPERATION_REL does not reference any database object
MSC.MSC_WO_OPERATION_REL is referenced by following:
Description: |
---|
MSC.MSC_WO_SUB_COMP does not reference any database object
MSC.MSC_WO_SUB_COMP is referenced by following:
Description: |
---|
MSC.MSC_WO_TASK_HIERARCHY does not reference any database object
MSC.MSC_WO_TASK_HIERARCHY is referenced by following:
Description: | This table contains exceptions generated in Oracle Collaborative planning |
---|
MSC.MSC_X_EXCEPTION_DETAILS does not reference any database object
MSC.MSC_X_EXCEPTION_DETAILS is referenced by following:
Description: |
---|
MSC.MSC_X_ITEM_ORGS_GTT does not reference any database object
MSC.MSC_X_ITEM_ORGS_GTT is referenced by following:
Description: |
---|
MSC.MSC_X_ITEM_SITES_GTT does not reference any database object
MSC.MSC_X_ITEM_SITES_GTT is referenced by following:
Description: |
---|
MSC.MSC_X_ITEM_SUPPLIERS_GTT does not reference any database object
MSC.MSC_X_ITEM_SUPPLIERS_GTT is referenced by following:
Description: | This table contains the security rules for processing data in Oracle Collaborative planning. |
---|
MSC.MSC_X_SECURITY_RULES does not reference any database object
MSC.MSC_X_SECURITY_RULES is referenced by following:
Description: | This table contains the mapping between user-defined zone and included regions |
---|
MSC.MSC_ZONE_REGIONS does not reference any database object
MSC.MSC_ZONE_REGIONS is referenced by following:
APPS.MSC_ACTION_ORDERS_TREE_V is not referenced by any database object
APPS.MSC_ACTION_SUMMARY_V is not referenced by any database object
APPS.MSC_ALLOCATION_ASSIGNMENTS_V is not referenced by any database object
APPS.MSC_ALTERNATE_RESOURCES_V is not referenced by any database object
APPS.MSC_ANSWERS_V is not referenced by any database object
APPS.MSC_APPS_INSTANCES_V is not referenced by any database object
APPS.MSC_AVAILABLE_ORGS_V is not referenced by any database object
APPS.MSC_AVAIL_RESOURCE_DETAIL_V is not referenced by any database object
APPS.MSC_AVAIL_RESOURCE_SUMMARY_V is not referenced by any database object
APPS.MSC_BILL_OF_RESOURCES_V is not referenced by any database object
APPS.MSC_BOD_SOURCING_RULES_V is not referenced by any database object
APPS.MSC_BOD_TASK_SR_LEVELS_V is not referenced by any database object
APPS.MSC_CATEGORIES_TREE_V is not referenced by any database object
APPS.MSC_COMPONENTS_SC_V is not referenced by any database object
APPS.MSC_COMPONENTS_TREE_V is not referenced by any database object
APPS.MSC_CONSTRAINED_FORECAST_V is not referenced by any database object
APPS.MSC_CO_PRODUCTS_V is not referenced by any database object
APPS.MSC_CRITICAL_PATHS_V is not referenced by any database object
APPS.MSC_CUST_BUCKET_V is not referenced by any database object
APPS.MSC_CUST_SUP_ORG_V is not referenced by any database object
APPS.MSC_DEMANDS_MV_V is not referenced by any database object
APPS.MSC_DEMAND_CLASSES_V is not referenced by any database object
APPS.MSC_DEMAND_PEGGING_V is not referenced by any database object
APPS.MSC_EXCEPTION_LOOKUP_V is not referenced by any database object
APPS.MSC_EXCEPTION_SUMMARY_V is not referenced by any database object
APPS.MSC_EXCEPTION_THRESHOLDS_V is not referenced by any database object
APPS.MSC_EXC_DETAIL_ALL_V is not referenced by any database object
APPS.MSC_EXC_DETAIL_ITEM_V is not referenced by any database object
APPS.MSC_EXC_DETAIL_RESOURCE_V is not referenced by any database object
APPS.MSC_FLP_DEMAND_SUPPLY_ATP_V is not referenced by any database object
APPS.MSC_FLP_DEMAND_SUPPLY_V is not referenced by any database object
APPS.MSC_FLP_DEMAND_SUPPLY_V2 is not referenced by any database object
APPS.MSC_FLP_END_DEMAND2_V is not referenced by any database object
APPS.MSC_FLP_END_DEMAND_V is not referenced by any database object
APPS.MSC_FLP_ONHAND_V is not referenced by any database object
APPS.MSC_FLP_OP_ATP_V is not referenced by any database object
APPS.MSC_FLP_OP_V is not referenced by any database object
APPS.MSC_FLP_RES_ATP_V is not referenced by any database object
APPS.MSC_FLP_RES_V is not referenced by any database object
APPS.MSC_FLP_SUPPLY_ATP_V is not referenced by any database object
APPS.MSC_FLP_SUPPLY_DEMAND_ATP_V is not referenced by any database object
APPS.MSC_FLP_SUPPLY_DEMAND_V is not referenced by any database object
APPS.MSC_FLP_SUPPLY_DEMAND_V2 is not referenced by any database object
APPS.MSC_FLP_SUPPLY_V is not referenced by any database object
APPS.MSC_FORECAST_UPDATES_V is not referenced by any database object
APPS.MSC_INSTANCE_ORGS_V is not referenced by any database object
APPS.MSC_ITEMS_TREE_V is not referenced by any database object
APPS.MSC_ITEM_EXCEPTION_V is not referenced by any database object
APPS.MSC_ITEM_EXCEPTION_V1 is not referenced by any database object
APPS.MSC_ITEM_EXCEPTION_V2 is not referenced by any database object
APPS.MSC_ITEM_SOURCING_LEVELS_V is not referenced by any database object
APPS.MSC_ITEM_SOURCING_V is not referenced by any database object
APPS.MSC_ITEM_SUPPLIER_V is not referenced by any database object
APPS.MSC_ITEM_TASK_SR_LEVELS_V is not referenced by any database object
APPS.MSC_ITEM_UOMS_VIEW is not referenced by any database object
APPS.MSC_LATE_ORDERS_MV_V is not referenced by any database object
APPS.MSC_LINE_ITEMS_LOV_V is not referenced by any database object
APPS.MSC_LOCATIONS_V is not referenced by any database object
APPS.MSC_NET_AGGREGATE_V is not referenced by any database object
APPS.MSC_NET_CONSTRAINTS_V is not referenced by any database object
APPS.MSC_NET_DEMAND_SCHD_V is not referenced by any database object
APPS.MSC_NET_EXCP_CRITERIA_V is not referenced by any database object
APPS.MSC_NET_EXC_DETAIL_V is not referenced by any database object
APPS.MSC_NET_EXC_GROUP_V is not referenced by any database object
APPS.MSC_NET_EXC_TYPE_V is not referenced by any database object
APPS.MSC_NET_FILTER_CRITERIA_V is not referenced by any database object
APPS.MSC_NET_GOAL_V is not referenced by any database object
APPS.MSC_NET_HZ_GRAPH_V is not referenced by any database object
APPS.MSC_NET_OPTIMIZE_V is not referenced by any database object
APPS.MSC_NET_OPTION_V is not referenced by any database object
APPS.MSC_NET_ORG_V is not referenced by any database object
APPS.MSC_NET_PLANS_V is not referenced by any database object
APPS.MSC_NET_PLANS_V2 is not referenced by any database object
APPS.MSC_NET_SUPPLY_SCHD_V is not referenced by any database object
APPS.MSC_NET_VERTICAL_GRAPH_V is not referenced by any database object
APPS.MSC_OPERATION_NETWORKS_V is not referenced by any database object
APPS.MSC_ORDERS_V is not referenced by any database object
APPS.MSC_ORG_SEC_RESP_V is not referenced by any database object
APPS.MSC_PARAMETERS_V is not referenced by any database object
APPS.MSC_PDR_ITEM_DETAILS_V is not referenced by any database object
APPS.MSC_PDR_LATE_ORDER_EXC_V is not referenced by any database object
APPS.MSC_PDR_MAT_RES_EXC_V is not referenced by any database object
APPS.MSC_PDR_PLAN_DETAILS_V is not referenced by any database object
APPS.MSC_PDR_RESOURCE_DETAILS_V is not referenced by any database object
APPS.MSC_PDR_VERT_LIST_V is not referenced by any database object
APPS.MSC_PLANNED_RESOURCES_V is not referenced by any database object
APPS.MSC_PLAN_ORGS_V is not referenced by any database object
APPS.MSC_PLAN_SCHEDULES_V is not referenced by any database object
APPS.MSC_PLAN_SCHED_V is not referenced by any database object
APPS.MSC_PO_REQUISITIONS_V is not referenced by any database object
APPS.MSC_PO_RESCHEDULE_DETAILS_V is not referenced by any database object
APPS.MSC_PO_RESCHEDULE_HEADER_V is not referenced by any database object
APPS.MSC_PROCESS_EFFECTIVITY_V is not referenced by any database object
APPS.MSC_PROJECTS_TREE_V is not referenced by any database object
APPS.MSC_PROJECT_ITEMS_TREE_V is not referenced by any database object
APPS.MSC_PUBLISH_ITEMS_LOV_V is not referenced by any database object
APPS.MSC_QUESTIONS_VL is not referenced by any database object
APPS.MSC_RELATED_EXC_DETAILS_V is not referenced by any database object
APPS.MSC_RESOURCE_ITEMS_TREE_V is not referenced by any database object
APPS.MSC_ROUTING_OPERATIONS_V is not referenced by any database object
APPS.MSC_SAFETY_STOCKS_V is not referenced by any database object
APPS.MSC_SCATP_ITEM_SR_LEVELS_V is not referenced by any database object
APPS.MSC_SCATP_SOURCES_V is not referenced by any database object
APPS.MSC_SCH_RULE_CRITERIA_V is not referenced by any database object
APPS.MSC_SCH_RULE_NAMES_V is not referenced by any database object
APPS.MSC_SC_BILL_BOM_V is not referenced by any database object
APPS.MSC_SC_BILL_MAKE_AT_V is not referenced by any database object
APPS.MSC_SC_BILL_SF_V is not referenced by any database object
APPS.MSC_SC_BILL_V is not referenced by any database object
APPS.MSC_SC_BILL_WU_V is not referenced by any database object
APPS.MSC_SEARCH_ACTIONS_V is not referenced by any database object
APPS.MSC_SEARCH_ITEMS_V is not referenced by any database object
APPS.MSC_SEARCH_ORGS_V is not referenced by any database object
APPS.MSC_SEARCH_PROJECTS_V is not referenced by any database object
APPS.MSC_SEARCH_RESOURCES_V is not referenced by any database object
APPS.MSC_SEARCH_SUPPLIERS_V is not referenced by any database object
APPS.MSC_SECURITY_RULES_V is not referenced by any database object
APPS.MSC_SELECTED_ORGS_V is not referenced by any database object
APPS.MSC_SR_ASSIGNMENTS_V is not referenced by any database object
APPS.MSC_SR_RECEIPT_ORG_V is not referenced by any database object
APPS.MSC_SR_VIEW_CON_V is not referenced by any database object
APPS.MSC_SR_VIEW_EXP_V is not referenced by any database object
APPS.MSC_SR_VIEW_MAKE_AT_V is not referenced by any database object
APPS.MSC_SR_VIEW_REC_V is not referenced by any database object
APPS.MSC_SR_VIEW_V is not referenced by any database object
APPS.MSC_SUBSTITUTE_COMPONENTS_V is not referenced by any database object
APPS.MSC_SUB_INVENTORIES_V is not referenced by any database object
APPS.MSC_SUPPLIERS_LOV_V is not referenced by any database object
APPS.MSC_SUPPLIERS_TREE_V is not referenced by any database object
APPS.MSC_SUPPLIER_CAPACITY_V is not referenced by any database object
APPS.MSC_SUPPLIER_FLEX_FENCES_V is not referenced by any database object
APPS.MSC_SUPPLIER_LT_OUTCOMES_V is not referenced by any database object
APPS.MSC_SUPPLIES_OUTBOUND_V is not referenced by any database object
APPS.MSC_SUPPLY_PEGGING_V is not referenced by any database object
APPS.MSC_SUP_DEM_ENTRIES_V is not referenced by any database object
APPS.MSC_SUP_DEM_ENTRIES_VMI_V is not referenced by any database object
APPS.MSC_SUP_DEM_ENT_CUSTOM_EX_V is not referenced by any database object
APPS.MSC_SUP_DEM_HISTORY_V is not referenced by any database object
APPS.MSC_SUP_DEM_HZ_UI_V is not referenced by any database object
APPS.MSC_SUP_DEM_SECURITY_V is not referenced by any database object
APPS.MSC_SUP_DEM_TRANSACTIONS_V is not referenced by any database object
APPS.MSC_SUP_DEM_UPDATE_SECURITY_V is not referenced by any database object
APPS.MSC_SYSTEM_ITEMS_SC_V is not referenced by any database object
APPS.MSC_TREE_SELECTION_V is not referenced by any database object
APPS.MSC_UNDO_DETAILS_V is not referenced by any database object
APPS.MSC_UNDO_SUMMARY_V is not referenced by any database object
APPS.MSC_UOM_CONVERSIONS_VIEW is not referenced by any database object
APPS.MSC_VERTICAL_PLAN_V is not referenced by any database object
APPS.MSC_VMI_ITEM_V is not referenced by any database object
APPS.MSC_WIP_JOB_COMPONENTS_V is not referenced by any database object
APPS.MSC_WIP_JOB_OPERATIONS_V is not referenced by any database object
APPS.MSC_WIP_JOB_RESOURCES_V is not referenced by any database object
APPS.MSC_WIP_JOB_SCHEDULE_V is not referenced by any database object
APPS.MSC_X_COMPANY_ORG_LOV_V is not referenced by any database object
APPS.MSC_X_COMPANY_SITES_LOV_V is not referenced by any database object
APPS.MSC_X_CUSTOMER_LOV_V is not referenced by any database object
APPS.MSC_X_ITEMS_LOV_V is not referenced by any database object
APPS.MSC_X_ITEM_EXCEPTIONS_V is not referenced by any database object
APPS.MSC_X_ORGS_LOV_V is not referenced by any database object
APPS.MSC_X_SUPPLIER_LOV_V is not referenced by any database object
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |