Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, 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.

eTRM - MSC Tables and Views

TABLE - MSC.MSC_ABC_CLASSES

TABLE - MSC.MSC_ALLOCATIONS

TABLE - MSC.MSC_ALLOCATION_ASSIGNMENTS

TABLE - MSC.MSC_ALLOCATION_RULES

TABLE - MSC.MSC_ALLOC_DEMANDS

TABLE - MSC.MSC_ALLOC_RULE_TIME_PHASES

TABLE - MSC.MSC_ALLOC_SUPPLIES

TABLE - MSC.MSC_AMONG_VALUES

TABLE - MSC.MSC_ANALYSIS_QUERY

TABLE - MSC.MSC_ANSWERS

TABLE - MSC.MSC_APPS_INSTANCES

TABLE - MSC.MSC_ASSIGNMENT_SETS

TABLE - MSC.MSC_ATP_DETAIL_PEG_TEMP

TABLE - MSC.MSC_ATP_PARAMETERS

TABLE - MSC.MSC_ATP_PEGGING

TABLE - MSC.MSC_ATP_RULES

TABLE - MSC.MSC_ATP_SUMMARY_RES

TABLE - MSC.MSC_ATP_SUMMARY_SD

TABLE - MSC.MSC_ATP_SUMMARY_SO

TABLE - MSC.MSC_ATP_SUMMARY_SUP

TABLE - MSC.MSC_AVAILABLE_TO_PROMISE

TABLE - MSC.MSC_BILL_OF_RESOURCES

TABLE - MSC.MSC_BIS_BUSINESS_PLANS

TABLE - MSC.MSC_BIS_INV_CAT_MV_TAB

TABLE - MSC.MSC_BIS_INV_DATE_MV_TAB

TABLE - MSC.MSC_BIS_INV_DETAIL

TABLE - MSC.MSC_BIS_PERFORMANCE_MEASURES

TABLE - MSC.MSC_BIS_PERIODS

TABLE - MSC.MSC_BIS_RES_DATE_MV_TAB

TABLE - MSC.MSC_BIS_RES_SUMMARY

TABLE - MSC.MSC_BIS_SUPPLIER_SUMMARY

TABLE - MSC.MSC_BIS_TARGETS

TABLE - MSC.MSC_BIS_TARGET_LEVELS

TABLE - MSC.MSC_BOMS

TABLE - MSC.MSC_BOM_BOD_INTERFACE

TABLE - MSC.MSC_BOM_COMPONENTS

TABLE - MSC.MSC_BOM_TEMP

TABLE - MSC.MSC_BOR_REQUIREMENTS

TABLE - MSC.MSC_CALENDARS

TABLE - MSC.MSC_CALENDAR_DATES

TABLE - MSC.MSC_CALENDAR_EXCEPTIONS

TABLE - MSC.MSC_CALENDAR_SHIFTS

TABLE - MSC.MSC_CAL_WEEK_START_DATES

TABLE - MSC.MSC_CAL_YEAR_START_DATES

TABLE - MSC.MSC_CAPACITY_PLANS

TABLE - MSC.MSC_CATEGORY_SETS

TABLE - MSC.MSC_CATEGORY_SET_ID_LID

TABLE - MSC.MSC_COLL_PARAMETERS

TABLE - MSC.MSC_COMPANIES

TABLE - MSC.MSC_COMPANY_ID_LID

TABLE - MSC.MSC_COMPANY_RELATIONSHIPS

TABLE - MSC.MSC_COMPANY_SITES

TABLE - MSC.MSC_COMPANY_SITE_ID_LID

TABLE - MSC.MSC_COMPANY_USERS

TABLE - MSC.MSC_COMPONENT_SUBSTITUTES

TABLE - MSC.MSC_CRITERIA

TABLE - MSC.MSC_CRITICAL_PATHS

TABLE - MSC.MSC_DELIVERY_DETAILS

TABLE - MSC.MSC_DEMANDS

TABLE - MSC.MSC_DEMANDS_CUM_F

TABLE - MSC.MSC_DEMANDS_F

TABLE - MSC.MSC_DEMAND_CLASSES

TABLE - MSC.MSC_DEMAND_MV_TAB

TABLE - MSC.MSC_DEMANTRA_F

TABLE - MSC.MSC_DEPARTMENT_RESOURCES

TABLE - MSC.MSC_DESIGNATORS

TABLE - MSC.MSC_ERRORS

TABLE - MSC.MSC_EXCEPTIONS_F

TABLE - MSC.MSC_EXCEPTION_DETAILS

TABLE - MSC.MSC_EXCEPTION_PREFERENCES

TABLE - MSC.MSC_EXCEPTION_THRESHOLDS

TABLE - MSC.MSC_EXCEPTION_THRESHOLD_VALUES

TABLE - MSC.MSC_EXC_DETAILS_ALL

TABLE - MSC.MSC_FCTI_HEADERS_INTERFACE

TABLE - MSC.MSC_FCTI_LINES_INTERFACE

TABLE - MSC.MSC_FILES

TABLE - MSC.MSC_FORECAST_UPDATES

TABLE - MSC.MSC_FORM_QUERY

TABLE - MSC.MSC_FULL_PEGGING

TABLE - MSC.MSC_GANTT_QUERY

TABLE - MSC.MSC_GROUPS

TABLE - MSC.MSC_GROUP_COMPANIES

TABLE - MSC.MSC_HUB_QUERY

TABLE - MSC.MSC_INSTANCE_ORGS

TABLE - MSC.MSC_INST_PARTITIONS

TABLE - MSC.MSC_INTERORG_SHIP_METHODS

TABLE - MSC.MSC_INT_10_TV

TABLE - MSC.MSC_INT_11_TV

TABLE - MSC.MSC_INT_12_E

TABLE - MSC.MSC_INT_13_E

TABLE - MSC.MSC_INT_14_TV_SNO

TABLE - MSC.MSC_INT_15_E_SNO

TABLE - MSC.MSC_INT_16_TV_SNO

TABLE - MSC.MSC_INT_17_E_SNO

TABLE - MSC.MSC_INT_18_E_SNO

TABLE - MSC.MSC_INT_19_TV_SNO

TABLE - MSC.MSC_INT_1_E

TABLE - MSC.MSC_INT_20_E_SNO

TABLE - MSC.MSC_INT_21_TV_SNO

TABLE - MSC.MSC_INT_22_E_SNO

TABLE - MSC.MSC_INT_23_TV_SNO

TABLE - MSC.MSC_INT_24_E_SNO

TABLE - MSC.MSC_INT_25_E_SNO

TABLE - MSC.MSC_INT_26_TV_SNO

TABLE - MSC.MSC_INT_27_E_SNO

TABLE - MSC.MSC_INT_28_TV_SNO

TABLE - MSC.MSC_INT_29_TV_SNO

TABLE - MSC.MSC_INT_2_E

TABLE - MSC.MSC_INT_30_TV_SNO

TABLE - MSC.MSC_INT_31_E_SNO

TABLE - MSC.MSC_INT_32_TV_SNO

TABLE - MSC.MSC_INT_33_E_SNO

TABLE - MSC.MSC_INT_34_TV_SNO

TABLE - MSC.MSC_INT_35_MEM_SNO

TABLE - MSC.MSC_INT_36_E_SNO

TABLE - MSC.MSC_INT_37_TV_SNO

TABLE - MSC.MSC_INT_38_E_PLAN

TABLE - MSC.MSC_INT_39_TV_PLAN

TABLE - MSC.MSC_INT_3_TV

TABLE - MSC.MSC_INT_40_E_PLAN

TABLE - MSC.MSC_INT_41_E_PLAN

TABLE - MSC.MSC_INT_42_E_PLAN

TABLE - MSC.MSC_INT_43_TV_PLAN

TABLE - MSC.MSC_INT_44_E_PLAN

TABLE - MSC.MSC_INT_45_E_PLAN

TABLE - MSC.MSC_INT_46_E_PLAN

TABLE - MSC.MSC_INT_47_E_PLAN

TABLE - MSC.MSC_INT_48_E_PLAN

TABLE - MSC.MSC_INT_49_E_PLAN

TABLE - MSC.MSC_INT_4_E

TABLE - MSC.MSC_INT_50_E_PLAN

TABLE - MSC.MSC_INT_5_TV

TABLE - MSC.MSC_INT_6_E

TABLE - MSC.MSC_INT_7_TV

TABLE - MSC.MSC_INT_8_E

TABLE - MSC.MSC_INT_9_TV

TABLE - MSC.MSC_INT_ACTUAL_RESOURCE_PLAN

TABLE - MSC.MSC_INT_ALT_RES

TABLE - MSC.MSC_INT_ASCP_DEMANDS

TABLE - MSC.MSC_INT_ASCP_DEPENDENT_DEMAND

TABLE - MSC.MSC_INT_ASCP_EXCEPTION_DETAILS

TABLE - MSC.MSC_INT_ASCP_EXPORT_BUCKETS

TABLE - MSC.MSC_INT_ASCP_INVENTORY

TABLE - MSC.MSC_INT_ASCP_KPI

TABLE - MSC.MSC_INT_ASCP_LABOUR_UTIL

TABLE - MSC.MSC_INT_ASCP_MACHINE_UTIL

TABLE - MSC.MSC_INT_ASCP_MFG_PLAN_LABOUR

TABLE - MSC.MSC_INT_ASCP_MFG_PLAN_MACHINE

TABLE - MSC.MSC_INT_ASCP_PRODCOST_KPI

TABLE - MSC.MSC_INT_ASCP_SUPPLY

TABLE - MSC.MSC_INT_ASCP_TOTALPRODCOST

TABLE - MSC.MSC_INT_ASCP_TRANSPCOST_KPI

TABLE - MSC.MSC_INT_ASCP_TRANSPORTATION

TABLE - MSC.MSC_INT_ASSIGNED_ATTRIBUTE

TABLE - MSC.MSC_INT_ATTRIBUTE_VALUE

TABLE - MSC.MSC_INT_BEGINNING_INVENTORY

TABLE - MSC.MSC_INT_BOR_RES_NAME

TABLE - MSC.MSC_INT_BRANCH

TABLE - MSC.MSC_INT_BRANCH_GROUP

TABLE - MSC.MSC_INT_BRANCH_GROUP_MEM

TABLE - MSC.MSC_INT_BRANCH_OPERATION

TABLE - MSC.MSC_INT_BRANCH_OPERATION_SET

TABLE - MSC.MSC_INT_BRANCH_OPERATION_SNO

TABLE - MSC.MSC_INT_BRANCH_OPERATION_TV

TABLE - MSC.MSC_INT_BRANCH_ROUTING

TABLE - MSC.MSC_INT_BRANCH_ROUTING_SNO

TABLE - MSC.MSC_INT_BRANCH_ROUTING_TV

TABLE - MSC.MSC_INT_BRANCH_ROUTING_TV_SNO

TABLE - MSC.MSC_INT_BRANCH_SNO

TABLE - MSC.MSC_INT_CALENDAR

TABLE - MSC.MSC_INT_CALENDAR_SNO

TABLE - MSC.MSC_INT_CALENDAR_TV

TABLE - MSC.MSC_INT_CALENDAR_TV_SNO

TABLE - MSC.MSC_INT_CFC_SCENARIO_DETAILS

TABLE - MSC.MSC_INT_CHANGEOVER_PATTERN

TABLE - MSC.MSC_INT_CHANGEOVER_PATTERN_SNO

TABLE - MSC.MSC_INT_CONSUMED_ITEM_BOM

TABLE - MSC.MSC_INT_CONSUMED_ITEM_BOM_SNO

TABLE - MSC.MSC_INT_CONSUMED_ITEM_BOM_TV

TABLE - MSC.MSC_INT_CONSUMED_ITEM_SET

TABLE - MSC.MSC_INT_CONSUMED_ITEM_SET_SNO

TABLE - MSC.MSC_INT_CREW

TABLE - MSC.MSC_INT_CREW_SNO

TABLE - MSC.MSC_INT_CREW_TV

TABLE - MSC.MSC_INT_CREW_TV_SNO

TABLE - MSC.MSC_INT_CUSTOMER

TABLE - MSC.MSC_INT_CUSTOMER_GROUP

TABLE - MSC.MSC_INT_CUSTOMER_GROUP_MEM

TABLE - MSC.MSC_INT_CUSTOMER_GROUP_MEM_SNO

TABLE - MSC.MSC_INT_CUSTOMER_GROUP_SNO

TABLE - MSC.MSC_INT_CUSTOMER_SNO

TABLE - MSC.MSC_INT_ENTERPRISE_FORECAST

TABLE - MSC.MSC_INT_ENT_FCST_DETAIL

TABLE - MSC.MSC_INT_ENT_FCST_DETAIL_SNO

TABLE - MSC.MSC_INT_ENT_FCST_DETAIL_TV

TABLE - MSC.MSC_INT_ENT_FCST_DETAIL_TV_SNO

TABLE - MSC.MSC_INT_FIXED_PRODUCTION_SNO

TABLE - MSC.MSC_INT_IMPLEMENTING_RESOURCE

TABLE - MSC.MSC_INT_IMPL_RES

TABLE - MSC.MSC_INT_INVENTORY_POLICY

TABLE - MSC.MSC_INT_INVENTORY_POLICY_SNO

TABLE - MSC.MSC_INT_INVENTORY_POLICY_TV

TABLE - MSC.MSC_INT_INV_SAFE_TAR

TABLE - MSC.MSC_INT_INV_SAFE_TAR_DETAIL

TABLE - MSC.MSC_INT_INV_SAFE_TAR_DETAIL_TV

TABLE - MSC.MSC_INT_INV_SAFE_TAR_SNO

TABLE - MSC.MSC_INT_ITEM

TABLE - MSC.MSC_INT_ITEM_BRANCH

TABLE - MSC.MSC_INT_ITEM_BRANCH_SNO

TABLE - MSC.MSC_INT_ITEM_BRANCH_TV

TABLE - MSC.MSC_INT_ITEM_BRANCH_TV_SNO

TABLE - MSC.MSC_INT_ITEM_GROUP

TABLE - MSC.MSC_INT_ITEM_GROUP_MEM

TABLE - MSC.MSC_INT_ITEM_GROUP_MEM_SNO

TABLE - MSC.MSC_INT_ITEM_GROUP_SNO

TABLE - MSC.MSC_INT_ITEM_PRICE

TABLE - MSC.MSC_INT_ITEM_PRICE_SNO

TABLE - MSC.MSC_INT_ITEM_PRICE_TV

TABLE - MSC.MSC_INT_ITEM_PRICE_TV_SNO

TABLE - MSC.MSC_INT_ITEM_SNO

TABLE - MSC.MSC_INT_ITEM_STORAGE

TABLE - MSC.MSC_INT_ITEM_STORAGE_SNO

TABLE - MSC.MSC_INT_ITEM_STORAGE_TV

TABLE - MSC.MSC_INT_ITEM_STORAGE_TV_SNO

TABLE - MSC.MSC_INT_ITEM_TRANSPORT_MODE

TABLE - MSC.MSC_INT_ITEM_UOM

TABLE - MSC.MSC_INT_ITEM_UOM_SNO

TABLE - MSC.MSC_INT_JOB_ALT_RES

TABLE - MSC.MSC_INT_LANE

TABLE - MSC.MSC_INT_LANE_SNO

TABLE - MSC.MSC_INT_MACHINE

TABLE - MSC.MSC_INT_MACHINE_SNO

TABLE - MSC.MSC_INT_MACHINE_TV

TABLE - MSC.MSC_INT_MACHINE_TV_SNO

TABLE - MSC.MSC_INT_MACH_ATTRIBUTE

TABLE - MSC.MSC_INT_NEXT_WORK_ORDER

TABLE - MSC.MSC_INT_OPERATION

TABLE - MSC.MSC_INT_OPERATION_BOR

TABLE - MSC.MSC_INT_OPERATION_BOR_SNO

TABLE - MSC.MSC_INT_OPERATION_BOR_TV

TABLE - MSC.MSC_INT_OPERATION_BOR_TV_SNO

TABLE - MSC.MSC_INT_OPERATION_GROUP

TABLE - MSC.MSC_INT_OPERATION_GROUP_MEM

TABLE - MSC.MSC_INT_OPERATION_GROUP_SNO

TABLE - MSC.MSC_INT_OPERATION_SET

TABLE - MSC.MSC_INT_OPERATION_SET_MEM

TABLE - MSC.MSC_INT_OPERATION_SET_MEM_SNO

TABLE - MSC.MSC_INT_OPERATION_SET_SNO

TABLE - MSC.MSC_INT_OPERATION_SNO

TABLE - MSC.MSC_INT_OSFM_PATH

TABLE - MSC.MSC_INT_PEGGED_WORK_ORDER_PLAN

TABLE - MSC.MSC_INT_PRODUCED_ITEM

TABLE - MSC.MSC_INT_PRODUCED_ITEM_BOM

TABLE - MSC.MSC_INT_PRODUCED_ITEM_BOM_SNO

TABLE - MSC.MSC_INT_PRODUCED_ITEM_BOM_TV

TABLE - MSC.MSC_INT_PRODUCED_ITEM_SNO

TABLE - MSC.MSC_INT_PURCHASE_ORDER

TABLE - MSC.MSC_INT_PURCHASE_ORDER_DETAIL

TABLE - MSC.MSC_INT_PURCHASE_ORDER_SNO

TABLE - MSC.MSC_INT_RESOURCE_ATTRIBUTE

TABLE - MSC.MSC_INT_RESOURCE_GROUP

TABLE - MSC.MSC_INT_RESOURCE_GROUP_MEM

TABLE - MSC.MSC_INT_RESOURCE_GROUP_MEM_SNO

TABLE - MSC.MSC_INT_RESOURCE_GROUP_SNO

TABLE - MSC.MSC_INT_RESOURCE_PLAN

TABLE - MSC.MSC_INT_RESOURCE_SCHEDULE_PLAN

TABLE - MSC.MSC_INT_RESOURCE_SET

TABLE - MSC.MSC_INT_RESOURCE_SET_SNO

TABLE - MSC.MSC_INT_ROUTING

TABLE - MSC.MSC_INT_ROUTING_SNO

TABLE - MSC.MSC_INT_SALES_ORDER

TABLE - MSC.MSC_INT_SALES_ORDER_DETAIL

TABLE - MSC.MSC_INT_SALES_SNO

TABLE - MSC.MSC_INT_SALES_TV_SNO

TABLE - MSC.MSC_INT_SATISFIED_DEMAND_PLAN

TABLE - MSC.MSC_INT_SCHEDULE_BOR_PLAN

TABLE - MSC.MSC_INT_SOURCE1

TABLE - MSC.MSC_INT_SOURCE2

TABLE - MSC.MSC_INT_SOURCE_ITEM_PLAN

TABLE - MSC.MSC_INT_SRC_RECOMMEND_DETAIL

TABLE - MSC.MSC_INT_STANDARD_UOM

TABLE - MSC.MSC_INT_STANDARD_UOM_SNO

TABLE - MSC.MSC_INT_STORAGE

TABLE - MSC.MSC_INT_STORAGE_SNO

TABLE - MSC.MSC_INT_STORAGE_TV

TABLE - MSC.MSC_INT_STORAGE_TV_SNO

TABLE - MSC.MSC_INT_SUPPLIER

TABLE - MSC.MSC_INT_SUPPLIER_GROUP

TABLE - MSC.MSC_INT_SUPPLIER_GROUP_MEM

TABLE - MSC.MSC_INT_SUPPLIER_GROUP_MEM_SNO

TABLE - MSC.MSC_INT_SUPPLIER_GROUP_SNO

TABLE - MSC.MSC_INT_SUPPLIER_ITEM

TABLE - MSC.MSC_INT_SUPPLIER_ITEM_BRANCH

TABLE - MSC.MSC_INT_SUPPLIER_ITEM_SNO

TABLE - MSC.MSC_INT_SUPPLIER_ITEM_TV

TABLE - MSC.MSC_INT_SUPPLIER_ITEM_TV_SNO

TABLE - MSC.MSC_INT_SUPPLIER_SNO

TABLE - MSC.MSC_INT_TEMPORAL_RELATION

TABLE - MSC.MSC_INT_TEMPORAL_RELATION_SNO

TABLE - MSC.MSC_INT_TOOL

TABLE - MSC.MSC_INT_TOOL_TV

TABLE - MSC.MSC_INT_TRANSFER_ORDER

TABLE - MSC.MSC_INT_TRANSFER_ORDER_DETAIL

TABLE - MSC.MSC_INT_TRANSFER_ORDER_IN

TABLE - MSC.MSC_INT_TRANSFER_ORDER_OUT

TABLE - MSC.MSC_INT_TRANSFER_ORDER_SNO

TABLE - MSC.MSC_INT_TRANSPORT_MODE

TABLE - MSC.MSC_INT_TRANSPORT_MODE_SNO

TABLE - MSC.MSC_INT_TRANSPORT_MODE_TV

TABLE - MSC.MSC_INT_TRANSPORT_MODE_TV_SNO

TABLE - MSC.MSC_INT_WORK_ORDER

TABLE - MSC.MSC_INT_WORK_ORDER_BOR

TABLE - MSC.MSC_INT_WORK_ORDER_IMP_RES

TABLE - MSC.MSC_INT_WORK_ORDER_OPERATION

TABLE - MSC.MSC_ITEMS

TABLE - MSC.MSC_ITEM_CATEGORIES

TABLE - MSC.MSC_ITEM_CUSTOMERS

TABLE - MSC.MSC_ITEM_EXCEPTIONS

TABLE - MSC.MSC_ITEM_ID_LID

TABLE - MSC.MSC_ITEM_INVENTORY_F

TABLE - MSC.MSC_ITEM_ORDERS_F

TABLE - MSC.MSC_ITEM_SOURCING

TABLE - MSC.MSC_ITEM_SUBSTITUTES

TABLE - MSC.MSC_ITEM_SUPPLIERS

TABLE - MSC.MSC_ITEM_WIPS_F

TABLE - MSC.MSC_JOB_OPERATIONS

TABLE - MSC.MSC_JOB_OPERATION_NETWORKS

TABLE - MSC.MSC_JOB_OP_RESOURCES

TABLE - MSC.MSC_JOB_OP_RES_INSTANCES

TABLE - MSC.MSC_JOB_REQUIREMENT_OPS

TABLE - MSC.MSC_LATE_ORDER_MV_TAB

TABLE - MSC.MSC_LOCAL_ID_DEMAND

TABLE - MSC.MSC_LOCAL_ID_ITEM

TABLE - MSC.MSC_LOCAL_ID_MISC

TABLE - MSC.MSC_LOCAL_ID_SETUP

TABLE - MSC.MSC_LOCAL_ID_SUPPLY

TABLE - MSC.MSC_LOCATION_ASSOCIATIONS

TABLE - MSC.MSC_MATERIAL_PLANS

TABLE - MSC.MSC_NEC_COMPARE_PLANS

TABLE - MSC.MSC_NEC_EXC_DTL_COMPARE

TABLE - MSC.MSC_NET_CHANGE_CRITERIA

TABLE - MSC.MSC_NET_RESOURCE_AVAIL

TABLE - MSC.MSC_NET_RES_INST_AVAIL

TABLE - MSC.MSC_OE_DATA_TEMP

TABLE - MSC.MSC_OPERATION_COMPONENTS

TABLE - MSC.MSC_OPERATION_NETWORKS

TABLE - MSC.MSC_OPERATION_RESOURCES

TABLE - MSC.MSC_OPERATION_RESOURCE_SEQS

TABLE - MSC.MSC_ORG_ACCESS

TABLE - MSC.MSC_OUTBOUND_ENTRIES

TABLE - MSC.MSC_PARAMETERS

TABLE - MSC.MSC_PARTNER_CONTACTS

TABLE - MSC.MSC_PART_DEMANDS

TABLE - MSC.MSC_PART_PEGGING

TABLE - MSC.MSC_PART_SUPPLIES

TABLE - MSC.MSC_PDR_PARAMETERS

TABLE - MSC.MSC_PDR_PARAMETERS_NEW

TABLE - MSC.MSC_PERIOD_START_DATES

TABLE - MSC.MSC_PLANNERS

TABLE - MSC.MSC_PLANS

TABLE - MSC.MSC_PLAN_BUCKETS

TABLE - MSC.MSC_PLAN_ORGANIZATIONS

TABLE - MSC.MSC_PLAN_ORG_KPIS

TABLE - MSC.MSC_PLAN_ORG_STATUS

TABLE - MSC.MSC_PLAN_PARTITIONS

TABLE - MSC.MSC_PLAN_REFRESHES

TABLE - MSC.MSC_PLAN_SCHEDULES

TABLE - MSC.MSC_PO_REQUISITIONS_INTERFACE

TABLE - MSC.MSC_PO_RESCHEDULE_INTERFACE

TABLE - MSC.MSC_PQ_RESULTS

TABLE - MSC.MSC_PROCESS_EFFECTIVITY

TABLE - MSC.MSC_PROFILES

TABLE - MSC.MSC_PROJECTS

TABLE - MSC.MSC_PROJECT_TASKS

TABLE - MSC.MSC_PURCHASE_ORDER_INTERFACE

TABLE - MSC.MSC_QUERY

TABLE - MSC.MSC_QUESTIONS_B

TABLE - MSC.MSC_QUESTIONS_TL

TABLE - MSC.MSC_REGIONS

TABLE - MSC.MSC_REGIONS_TEMP

TABLE - MSC.MSC_REGION_LOCATIONS

TABLE - MSC.MSC_RELATED_EXCEPTIONS

TABLE - MSC.MSC_REPETITIVE_PERIODS

TABLE - MSC.MSC_RESERVATIONS

TABLE - MSC.MSC_RESOURCES_F

TABLE - MSC.MSC_RESOURCE_CHANGES

TABLE - MSC.MSC_RESOURCE_GROUPS

TABLE - MSC.MSC_RESOURCE_INSTANCE_REQS

TABLE - MSC.MSC_RESOURCE_REQUIREMENTS

TABLE - MSC.MSC_RESOURCE_SHIFTS

TABLE - MSC.MSC_ROUTINGS

TABLE - MSC.MSC_ROUTING_OPERATIONS

TABLE - MSC.MSC_SAFETY_STOCKS

TABLE - MSC.MSC_SALES_ORDERS

TABLE - MSC.MSC_SCHEDULING_RULES

TABLE - MSC.MSC_SECURITY_RULES

TABLE - MSC.MSC_SELECTION_CRITERIA

TABLE - MSC.MSC_SEQUENCE_DEPENDENT_SETUPS

TABLE - MSC.MSC_SERIAL_NUMBERS

TABLE - MSC.MSC_SHIFT_DATES

TABLE - MSC.MSC_SHIFT_EXCEPTIONS

TABLE - MSC.MSC_SHIFT_TIMES

TABLE - MSC.MSC_SIMULATION_SETS

TABLE - MSC.MSC_SINGLE_LVL_PEG

TABLE - MSC.MSC_SNAPSHOT_TASKS

TABLE - MSC.MSC_SORT_DATA

TABLE - MSC.MSC_SOURCING_HISTORY

TABLE - MSC.MSC_SOURCING_RULES

TABLE - MSC.MSC_SOURCING_TRANSACTIONS

TABLE - MSC.MSC_SQLLOAD_PARAMETERS

TABLE - MSC.MSC_SRP_ITEM_EXCEPTIONS

TABLE - MSC.MSC_SR_ASSIGNMENTS

TABLE - MSC.MSC_SR_RECEIPT_ORG

TABLE - MSC.MSC_SR_SOURCE_ORG

TABLE - MSC.MSC_ST_ASSIGNMENT_SETS

TABLE - MSC.MSC_ST_ATP_RULES

TABLE - MSC.MSC_ST_BILL_OF_RESOURCES

TABLE - MSC.MSC_ST_BIS_BUSINESS_PLANS

TABLE - MSC.MSC_ST_BIS_PERIODS

TABLE - MSC.MSC_ST_BIS_PFMC_MEASURES

TABLE - MSC.MSC_ST_BIS_TARGETS

TABLE - MSC.MSC_ST_BIS_TARGET_LEVELS

TABLE - MSC.MSC_ST_BOMS

TABLE - MSC.MSC_ST_BOM_COMPONENTS

TABLE - MSC.MSC_ST_BOR_REQUIREMENTS

TABLE - MSC.MSC_ST_CALENDARS

TABLE - MSC.MSC_ST_CALENDAR_DATES

TABLE - MSC.MSC_ST_CALENDAR_EXCEPTIONS

TABLE - MSC.MSC_ST_CALENDAR_SHIFTS

TABLE - MSC.MSC_ST_CAL_WEEK_START_DATES

TABLE - MSC.MSC_ST_CAL_YEAR_START_DATES

TABLE - MSC.MSC_ST_CATEGORY_SETS

TABLE - MSC.MSC_ST_COMPANY_USERS

TABLE - MSC.MSC_ST_COMPONENT_SUBSTITUTES

TABLE - MSC.MSC_ST_CO_PRODUCTS

TABLE - MSC.MSC_ST_DEMANDS

TABLE - MSC.MSC_ST_DEMAND_CLASSES

TABLE - MSC.MSC_ST_DEPARTMENT_RESOURCES

TABLE - MSC.MSC_ST_DESIGNATORS

TABLE - MSC.MSC_ST_GROUPS

TABLE - MSC.MSC_ST_GROUP_COMPANIES

TABLE - MSC.MSC_ST_INTERORG_SHIP_METHODS

TABLE - MSC.MSC_ST_ITEM_CATEGORIES

TABLE - MSC.MSC_ST_ITEM_CUSTOMERS

TABLE - MSC.MSC_ST_ITEM_SOURCING

TABLE - MSC.MSC_ST_ITEM_SUBSTITUTES

TABLE - MSC.MSC_ST_ITEM_SUPPLIERS

TABLE - MSC.MSC_ST_JOB_OPERATIONS

TABLE - MSC.MSC_ST_JOB_OP_RESOURCES

TABLE - MSC.MSC_ST_JOB_REQUIREMENT_OPS

TABLE - MSC.MSC_ST_LOCATION_ASSOCIATIONS

TABLE - MSC.MSC_ST_NET_RESOURCE_AVAIL

TABLE - MSC.MSC_ST_NET_RES_INST_AVAIL

TABLE - MSC.MSC_ST_OPERATION_COMPONENTS

TABLE - MSC.MSC_ST_OPERATION_NETWORKS

TABLE - MSC.MSC_ST_OPERATION_RESOURCES

TABLE - MSC.MSC_ST_OPERATION_RESOURCE_SEQS

TABLE - MSC.MSC_ST_PARAMETERS

TABLE - MSC.MSC_ST_PARTNER_CONTACTS

TABLE - MSC.MSC_ST_PERIOD_START_DATES

TABLE - MSC.MSC_ST_PLANNERS

TABLE - MSC.MSC_ST_PROCESS_EFFECTIVITY

TABLE - MSC.MSC_ST_PROFILES

TABLE - MSC.MSC_ST_PROJECTS

TABLE - MSC.MSC_ST_PROJECT_TASKS

TABLE - MSC.MSC_ST_REGIONS

TABLE - MSC.MSC_ST_REGION_LOCATIONS

TABLE - MSC.MSC_ST_RESERVATIONS

TABLE - MSC.MSC_ST_RESOURCE_CHANGES

TABLE - MSC.MSC_ST_RESOURCE_GROUPS

TABLE - MSC.MSC_ST_RESOURCE_INSTANCE_REQS

TABLE - MSC.MSC_ST_RESOURCE_REQUIREMENTS

TABLE - MSC.MSC_ST_RESOURCE_SHIFTS

TABLE - MSC.MSC_ST_ROUTINGS

TABLE - MSC.MSC_ST_ROUTING_OPERATIONS

TABLE - MSC.MSC_ST_SAFETY_STOCKS

TABLE - MSC.MSC_ST_SALES_ORDERS

TABLE - MSC.MSC_ST_SERIAL_NUMBERS

TABLE - MSC.MSC_ST_SHIFT_DATES

TABLE - MSC.MSC_ST_SHIFT_EXCEPTIONS

TABLE - MSC.MSC_ST_SHIFT_TIMES

TABLE - MSC.MSC_ST_SIMULATION_SETS

TABLE - MSC.MSC_ST_SOURCING_HISTORY

TABLE - MSC.MSC_ST_SOURCING_RULES

TABLE - MSC.MSC_ST_SR_ASSIGNMENTS

TABLE - MSC.MSC_ST_SR_RECEIPT_ORG

TABLE - MSC.MSC_ST_SR_SOURCE_ORG

TABLE - MSC.MSC_ST_SUB_INVENTORIES

TABLE - MSC.MSC_ST_SUPPLIER_CAPACITIES

TABLE - MSC.MSC_ST_SUPPLIER_FLEX_FENCES

TABLE - MSC.MSC_ST_SUPPLIES

TABLE - MSC.MSC_ST_SYSTEM_ITEMS

TABLE - MSC.MSC_ST_TRADING_PARTNERS

TABLE - MSC.MSC_ST_TRADING_PARTNER_SITES

TABLE - MSC.MSC_ST_UNITS_OF_MEASURE

TABLE - MSC.MSC_ST_UNIT_NUMBERS

TABLE - MSC.MSC_ST_UOM_CLASS_CONVERSIONS

TABLE - MSC.MSC_ST_UOM_CONVERSIONS

TABLE - MSC.MSC_ST_WORKDAY_PATTERNS

TABLE - MSC.MSC_ST_ZONE_REGIONS

TABLE - MSC.MSC_SUB_INVENTORIES

TABLE - MSC.MSC_SUPDEM_HDRS_INTERFACE

TABLE - MSC.MSC_SUPDEM_LINES_INTERFACE

TABLE - MSC.MSC_SUPPLIERS_F

TABLE - MSC.MSC_SUPPLIER_CAPACITIES

TABLE - MSC.MSC_SUPPLIER_FLEX_FENCES

TABLE - MSC.MSC_SUPPLIER_LT_OUTCOMES

TABLE - MSC.MSC_SUPPLIER_PLANS

TABLE - MSC.MSC_SUPPLIER_REQUIREMENTS

TABLE - MSC.MSC_SUPPLIES

TABLE - MSC.MSC_SUPPLIES_F

TABLE - MSC.MSC_SUP_DEM_ENTRIES

TABLE - MSC.MSC_SUP_DEM_HISTORY

TABLE - MSC.MSC_SUP_HEADERS_INTERFACE

TABLE - MSC.MSC_SUP_LINES_INTERFACE

TABLE - MSC.MSC_SYSTEM_ITEMS

TABLE - MSC.MSC_TEMP_ALLOC_DEMANDS

TABLE - MSC.MSC_TEMP_ALLOC_SUPPLIES

TABLE - MSC.MSC_TEMP_REGION_LOCATIONS

TABLE - MSC.MSC_TEMP_SALES_ORDERS

TABLE - MSC.MSC_TEMP_SUMM_RES

TABLE - MSC.MSC_TEMP_SUMM_SD

TABLE - MSC.MSC_TEMP_SUMM_SO

TABLE - MSC.MSC_TEMP_SUMM_SUP

TABLE - MSC.MSC_TP_ID_LID

TABLE - MSC.MSC_TP_SITE_ID_LID

TABLE - MSC.MSC_TRADING_PARTNERS

TABLE - MSC.MSC_TRADING_PARTNER_MAPS

TABLE - MSC.MSC_TRADING_PARTNER_SITES

TABLE - MSC.MSC_UNDO_DETAILS

TABLE - MSC.MSC_UNDO_SUMMARY

TABLE - MSC.MSC_UNITS_OF_MEASURE

TABLE - MSC.MSC_UNIT_NUMBERS

TABLE - MSC.MSC_UOM_CLASS_CONVERSIONS

TABLE - MSC.MSC_UOM_CONVERSIONS

TABLE - MSC.MSC_USER_ADV_EXPRESSIONS

TABLE - MSC.MSC_USER_EXCEPTIONS

TABLE - MSC.MSC_USER_EXCEPTION_COMPONENTS

TABLE - MSC.MSC_USER_EXCEPTION_NTFS

TABLE - MSC.MSC_WIP_JOB_DTLS_INTERFACE

TABLE - MSC.MSC_WIP_JOB_SCHEDULE_INTERFACE

TABLE - MSC.MSC_WORKBENCH_DISPLAY_OPTIONS

TABLE - MSC.MSC_WORKDAY_PATTERNS

TABLE - MSC.MSC_X_EXCEPTION_DETAILS

TABLE - MSC.MSC_X_ITEM_ORGS_GTT

TABLE - MSC.MSC_X_ITEM_SITES_GTT

TABLE - MSC.MSC_X_ITEM_SUPPLIERS_GTT

TABLE - MSC.MSC_X_SECURITY_RULES

TABLE - MSC.MSC_ZONE_REGIONS

VIEW - APPS.MSC_ACTIONS_TREE_V

VIEW - APPS.MSC_ACTION_ORDERS_TREE_V

VIEW - APPS.MSC_ACTION_SUMMARY_V

VIEW - APPS.MSC_ALLOCATION_ASSIGNMENTS_V

VIEW - APPS.MSC_ALTERNATE_RESOURCES_V

VIEW - APPS.MSC_ANSWERS_V

VIEW - APPS.MSC_APPS_INSTANCES_V

VIEW - APPS.MSC_AVAILABLE_ORGS_V

VIEW - APPS.MSC_AVAIL_RESOURCE_DETAIL_V

VIEW - APPS.MSC_AVAIL_RESOURCE_SUMMARY_V

VIEW - APPS.MSC_BILL_OF_RESOURCES_V

VIEW - APPS.MSC_BOD_SOURCING_RULES_V

VIEW - APPS.MSC_BOD_TASK_SR_LEVELS_V

VIEW - APPS.MSC_CATEGORIES_TREE_V

VIEW - APPS.MSC_COMPONENTS_SC_V

VIEW - APPS.MSC_COMPONENTS_TREE_V

VIEW - APPS.MSC_CONSTRAINED_FORECAST_V

VIEW - APPS.MSC_CO_PRODUCTS_V

VIEW - APPS.MSC_CRITICAL_PATHS_V

VIEW - APPS.MSC_CUST_BUCKET_V

VIEW - APPS.MSC_CUST_SUP_ORG_V

VIEW - APPS.MSC_DEMANDS_MV_V

VIEW - APPS.MSC_DEMAND_CLASSES_V

VIEW - APPS.MSC_DEMAND_PEGGING_V

VIEW - APPS.MSC_EXCEPTION_DETAILS_V

VIEW - APPS.MSC_EXCEPTION_LOOKUP_V

VIEW - APPS.MSC_EXCEPTION_SUMMARY_V

VIEW - APPS.MSC_EXCEPTION_THRESHOLDS_V

VIEW - APPS.MSC_EXC_DETAIL_ALL_V

VIEW - APPS.MSC_EXC_DETAIL_ITEM_V

VIEW - APPS.MSC_EXC_DETAIL_RESOURCE_V

VIEW - APPS.MSC_FLP_DEMAND_SUPPLY_ATP_V

VIEW - APPS.MSC_FLP_DEMAND_SUPPLY_V

VIEW - APPS.MSC_FLP_DEMAND_SUPPLY_V2

VIEW - APPS.MSC_FLP_END_DEMAND2_V

VIEW - APPS.MSC_FLP_END_DEMAND_V

VIEW - APPS.MSC_FLP_ONHAND_V

VIEW - APPS.MSC_FLP_OP_ATP_V

VIEW - APPS.MSC_FLP_OP_V

VIEW - APPS.MSC_FLP_RES_ATP_V

VIEW - APPS.MSC_FLP_RES_V

VIEW - APPS.MSC_FLP_SUPPLY_ATP_V

VIEW - APPS.MSC_FLP_SUPPLY_DEMAND_ATP_V

VIEW - APPS.MSC_FLP_SUPPLY_DEMAND_V

VIEW - APPS.MSC_FLP_SUPPLY_DEMAND_V2

VIEW - APPS.MSC_FLP_SUPPLY_V

VIEW - APPS.MSC_FORECAST_UPDATES_V

VIEW - APPS.MSC_INSTANCE_ORGS_V

VIEW - APPS.MSC_ITEMS_TREE_V

VIEW - APPS.MSC_ITEM_EXCEPTION_V

VIEW - APPS.MSC_ITEM_EXCEPTION_V1

VIEW - APPS.MSC_ITEM_EXCEPTION_V2

VIEW - APPS.MSC_ITEM_LOWEST_SR_LEVEL_V

VIEW - APPS.MSC_ITEM_SOURCING_LEVELS_V

VIEW - APPS.MSC_ITEM_SOURCING_V

VIEW - APPS.MSC_ITEM_SR_LEVELS_V

VIEW - APPS.MSC_ITEM_SUPPLIER_V

VIEW - APPS.MSC_ITEM_TASK_SR_LEVELS_V

VIEW - APPS.MSC_ITEM_UOMS_VIEW

VIEW - APPS.MSC_LATE_ORDERS_MV_V

VIEW - APPS.MSC_LINE_ITEMS_LOV_V

VIEW - APPS.MSC_LOCATIONS_V

VIEW - APPS.MSC_NET_AGGREGATE_V

VIEW - APPS.MSC_NET_CONSTRAINTS_V

VIEW - APPS.MSC_NET_DEMAND_SCHD_V

VIEW - APPS.MSC_NET_EXCP_CRITERIA_V

VIEW - APPS.MSC_NET_EXC_DETAIL_V

VIEW - APPS.MSC_NET_EXC_GROUP_V

VIEW - APPS.MSC_NET_EXC_TYPE_V

VIEW - APPS.MSC_NET_FILTER_CRITERIA_V

VIEW - APPS.MSC_NET_GOAL_V

VIEW - APPS.MSC_NET_HZ_GRAPH_V

VIEW - APPS.MSC_NET_OPTIMIZE_V

VIEW - APPS.MSC_NET_OPTION_V

VIEW - APPS.MSC_NET_ORG_V

VIEW - APPS.MSC_NET_PLANS_V

VIEW - APPS.MSC_NET_PLANS_V2

VIEW - APPS.MSC_NET_SUPPLY_SCHD_V

VIEW - APPS.MSC_NET_VERTICAL_GRAPH_V

VIEW - APPS.MSC_OPERATION_NETWORKS_V

VIEW - APPS.MSC_ORDERS_V

VIEW - APPS.MSC_ORGS_TREE_V

VIEW - APPS.MSC_ORG_SEC_RESP_V

VIEW - APPS.MSC_PARAMETERS_V

VIEW - APPS.MSC_PDR_ITEM_DETAILS_V

VIEW - APPS.MSC_PDR_LATE_ORDER_EXC_V

VIEW - APPS.MSC_PDR_MAT_RES_EXC_V

VIEW - APPS.MSC_PDR_PLAN_DETAILS_V

VIEW - APPS.MSC_PDR_PLAN_DETAILS_V1

VIEW - APPS.MSC_PDR_RESOURCE_DETAILS_V

VIEW - APPS.MSC_PDR_VERT_LIST_V

VIEW - APPS.MSC_PLANNED_RESOURCES_V

VIEW - APPS.MSC_PLANS_TREE_V

VIEW - APPS.MSC_PLAN_ORGANIZATIONS_V

VIEW - APPS.MSC_PLAN_ORGS_V

VIEW - APPS.MSC_PLAN_PARAMETERS_V

VIEW - APPS.MSC_PLAN_SCHEDULES_V

VIEW - APPS.MSC_PLAN_SCHED_V

VIEW - APPS.MSC_PO_REQUISITIONS_V

VIEW - APPS.MSC_PO_RESCHEDULE_DETAILS_V

VIEW - APPS.MSC_PO_RESCHEDULE_HEADER_V

VIEW - APPS.MSC_PROCESS_EFFECTIVITY_V

VIEW - APPS.MSC_PRODUCT_FAMILIES_TREE_V

VIEW - APPS.MSC_PROJECTS_TREE_V

VIEW - APPS.MSC_PROJECT_ITEMS_TREE_V

VIEW - APPS.MSC_PUBLISH_ITEMS_LOV_V

VIEW - APPS.MSC_QUESTIONS_VL

VIEW - APPS.MSC_RELATED_EXC_DETAILS_V

VIEW - APPS.MSC_RESOURCES_TREE_V

VIEW - APPS.MSC_RESOURCE_ITEMS_TREE_V

VIEW - APPS.MSC_RESOURCE_REQUIREMENTS_V

VIEW - APPS.MSC_ROUTING_OPERATIONS_V

VIEW - APPS.MSC_SAFETY_STOCKS_V

VIEW - APPS.MSC_SCATP_ITEM_SR_LEVELS_V

VIEW - APPS.MSC_SCATP_SOURCES_V

VIEW - APPS.MSC_SCH_RULE_CRITERIA_V

VIEW - APPS.MSC_SCH_RULE_NAMES_V

VIEW - APPS.MSC_SC_BILL_BOM_V

VIEW - APPS.MSC_SC_BILL_MAKE_AT_V

VIEW - APPS.MSC_SC_BILL_SF_V

VIEW - APPS.MSC_SC_BILL_V

VIEW - APPS.MSC_SC_BILL_WU_V

VIEW - APPS.MSC_SEARCH_ACTIONS_V

VIEW - APPS.MSC_SEARCH_ITEMS_V

VIEW - APPS.MSC_SEARCH_ORGS_V

VIEW - APPS.MSC_SEARCH_PROJECTS_V

VIEW - APPS.MSC_SEARCH_RESOURCES_V

VIEW - APPS.MSC_SEARCH_SUPPLIERS_V

VIEW - APPS.MSC_SECURITY_RULES_V

VIEW - APPS.MSC_SELECTED_ORGS_V

VIEW - APPS.MSC_SOURCES_V

VIEW - APPS.MSC_SR_ASSIGNMENTS_V

VIEW - APPS.MSC_SR_RECEIPT_ORG_V

VIEW - APPS.MSC_SR_SOURCE_ORG_V

VIEW - APPS.MSC_SR_VIEW_CON_V

VIEW - APPS.MSC_SR_VIEW_EXP_V

VIEW - APPS.MSC_SR_VIEW_MAKE_AT_V

VIEW - APPS.MSC_SR_VIEW_REC_V

VIEW - APPS.MSC_SR_VIEW_V

VIEW - APPS.MSC_SUBSTITUTE_COMPONENTS_V

VIEW - APPS.MSC_SUB_INVENTORIES_V

VIEW - APPS.MSC_SUPPLIERS_LOV_V

VIEW - APPS.MSC_SUPPLIERS_TREE_V

VIEW - APPS.MSC_SUPPLIER_CAPACITY_V

VIEW - APPS.MSC_SUPPLIER_FLEX_FENCES_V

VIEW - APPS.MSC_SUPPLIER_LT_OUTCOMES_V

VIEW - APPS.MSC_SUPPLIES_OUTBOUND_V

VIEW - APPS.MSC_SUPPLY_PEGGING_V

VIEW - APPS.MSC_SUP_DEM_ENTRIES_UI_V

VIEW - APPS.MSC_SUP_DEM_ENTRIES_V

VIEW - APPS.MSC_SUP_DEM_ENTRIES_VMI_V

VIEW - APPS.MSC_SUP_DEM_ENT_CUSTOM_EX_V

VIEW - APPS.MSC_SUP_DEM_HISTORY_V

VIEW - APPS.MSC_SUP_DEM_HZ_UI_V

VIEW - APPS.MSC_SUP_DEM_SECURITY_V

VIEW - APPS.MSC_SUP_DEM_TRANSACTIONS_V

VIEW - APPS.MSC_SUP_DEM_UPDATE_SECURITY_V

VIEW - APPS.MSC_SYSTEM_ITEMS_SC_V

VIEW - APPS.MSC_TREE_SELECTION_V

VIEW - APPS.MSC_UNDO_DETAILS_V

VIEW - APPS.MSC_UNDO_SUMMARY_V

VIEW - APPS.MSC_UOM_CONVERSIONS_VIEW

VIEW - APPS.MSC_VERTICAL_PLAN_V

VIEW - APPS.MSC_VMI_ITEM_V

VIEW - APPS.MSC_WIP_JOB_COMPONENTS_V

VIEW - APPS.MSC_WIP_JOB_OPERATIONS_V

VIEW - APPS.MSC_WIP_JOB_RESOURCES_V

VIEW - APPS.MSC_WIP_JOB_SCHEDULE_V

VIEW - APPS.MSC_X_COMPANY_ORG_LOV_V

VIEW - APPS.MSC_X_COMPANY_SITES_LOV_V

VIEW - APPS.MSC_X_CUSTOMER_LOV_V

VIEW - APPS.MSC_X_ITEMS_LOV_V

VIEW - APPS.MSC_X_ITEM_EXCEPTIONS_V

VIEW - APPS.MSC_X_ORGS_LOV_V

VIEW - APPS.MSC_X_SUPPLIER_LOV_V

Table: MSC_ABC_CLASSES

Primary Key: MSC_ABC_CLASSES_PK

1. ABC_CLASS_ID
2. SR_INSTANCE_ID

Foreign Keys to this table:

Comments

This table describes the classification of inventory goods into class A, B, C class types.

Indexes

Columns

[top of page]

MSC.MSC_ABC_CLASSES does not reference any database object

MSC.MSC_ABC_CLASSES is referenced by following:

APPS

SYNONYM - MSC_ABC_CLASSES

[top of page]

Table: MSC_ALLOCATIONS

Primary Key: MSC_ALLOCATIONS_PK

1. ALLOCATION_ID

Foreign Keys from this table:

Comments

This table describes the allocations

Indexes

Columns

[top of page]

MSC.MSC_ALLOCATIONS does not reference any database object

MSC.MSC_ALLOCATIONS is referenced by following:

APPS

SYNONYM - MSC_ALLOCATIONS

MSC

MATERIALIZED VIEW - MSC_ITEM_HIERARCHY_MV

MATERIALIZED VIEW - MSC_RESOURCE_HIERARCHY_MV

[top of page]

Table: MSC_ALLOCATION_ASSIGNMENTS

Primary Key: MSC_ALLOCATION_ASSIGNMENTS_PK

1. ASSIGNMENT_ID

Foreign Keys from this table:

Comments

This table describes the allocation assignments

Indexes

Columns

[top of page]

MSC.MSC_ALLOCATION_ASSIGNMENTS does not reference any database object

MSC.MSC_ALLOCATION_ASSIGNMENTS is referenced by following:

APPS

SYNONYM - MSC_ALLOCATION_ASSIGNMENTS

MSC

MATERIALIZED VIEW - MSC_ITEM_HIERARCHY_MV

MATERIALIZED VIEW - MSC_RESOURCE_HIERARCHY_MV

[top of page]

Table: MSC_ALLOCATION_RULES

Primary Key: MSC_ALLOCATION_RULES_PK

1. ALLOCATION_RULE_NAME

Foreign Keys to this table:

Comments

This table describes the allocation rules

Indexes

Columns

[top of page]

MSC.MSC_ALLOCATION_RULES does not reference any database object

MSC.MSC_ALLOCATION_RULES is referenced by following:

APPS

SYNONYM - MSC_ALLOCATION_RULES

[top of page]

Table: MSC_ALLOC_DEMANDS

Comments

Indexes

Columns

[top of page]

MSC.MSC_ALLOC_DEMANDS does not reference any database object

MSC.MSC_ALLOC_DEMANDS is referenced by following:

APPS

SYNONYM - MSC_ALLOC_DEMANDS

[top of page]

Table: MSC_ALLOC_RULE_TIME_PHASES

Primary Key: MSC_ALLOC_TIME_PHASES_PK

1. TIME_PHASE_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This table describes the time-phased allocation rules

Indexes

Columns

[top of page]

MSC.MSC_ALLOC_RULE_TIME_PHASES does not reference any database object

MSC.MSC_ALLOC_RULE_TIME_PHASES is referenced by following:

APPS

SYNONYM - MSC_ALLOC_RULE_TIME_PHASES

MSC

MATERIALIZED VIEW - MSC_ITEM_HIERARCHY_MV

MATERIALIZED VIEW - MSC_RESOURCE_HIERARCHY_MV

[top of page]

Table: MSC_ALLOC_SUPPLIES

Comments

Indexes

Columns

[top of page]

MSC.MSC_ALLOC_SUPPLIES does not reference any database object

MSC.MSC_ALLOC_SUPPLIES is referenced by following:

APPS

SYNONYM - MSC_ALLOC_SUPPLIES

[top of page]

Table: MSC_AMONG_VALUES

Comments

MSC_AMONG_VALUES stores the values entered by
the user in the Planner Workbench Find Windows when choosing
'among' condition. This table is used with MSC_SELECTION_CRITERIA by
the Planner Workbench to filter the data seen in the Items,
Supply, Demand, Supply/Demand and Exception Summary window.
FOLDER_ID identifies the folder that is tied to the criteria.
FIELD_NAME and SEQUENCE identify the field against which the
criteria is specified by the user. OR_VALUES and HIDDEN_VALUES store
the criteria values.

Indexes

Columns

[top of page]

MSC.MSC_AMONG_VALUES does not reference any database object

MSC.MSC_AMONG_VALUES is referenced by following:

APPS

SYNONYM - MSC_AMONG_VALUES

[top of page]

Table: MSC_ANALYSIS_QUERY

Comments

Indexes

Columns

[top of page]

MSC.MSC_ANALYSIS_QUERY does not reference any database object

MSC.MSC_ANALYSIS_QUERY is referenced by following:

APPS

SYNONYM - MSC_ANALYSIS_QUERY

[top of page]

Table: MSC_ANSWERS

Comments

Indexes

Columns

[top of page]

MSC.MSC_ANSWERS does not reference any database object

MSC.MSC_ANSWERS is referenced by following:

APPS

SYNONYM - MSC_ANSWERS

[top of page]

Table: MSC_APPS_INSTANCES

Primary Key: MSC_APPS_INSTANCES_PK

1. INSTANCE_ID

Foreign Keys to this table:

Comments

This tables stores the information of each connected Application instance.

Indexes

Columns

[top of page]

MSC.MSC_APPS_INSTANCES does not reference any database object

MSC.MSC_APPS_INSTANCES is referenced by following:

APPS

SYNONYM - MSC_APPS_INSTANCES

TRIGGER - MSC_APPS_INSTANCES_T1

TRIGGER - MSC_APPS_INSTANCES_T2

TRIGGER - MSC_APPS_INSTANCES_T3

MATERIALIZED VIEW - MSD_DEM_SCN_ENTRIES_MV

MSC

MATERIALIZED VIEW - MSC_ATP_PLAN_SN

[top of page]

Table: MSC_ASSIGNMENT_SETS

Primary Key: MSC_ASSINGMENT_SETS_PK

1. ASSIGNMENT_SET_ID

Foreign Keys to this table:

Comments

This table stores the assignment of sourcing rules (or bills of distribution) to item, organization, category, or at the global level.
This table stores data which are created at planning server and source applications.

Indexes

Columns

[top of page]

MSC.MSC_ASSIGNMENT_SETS does not reference any database object

MSC.MSC_ASSIGNMENT_SETS is referenced by following:

APPS

SYNONYM - MSC_ASSIGNMENT_SETS

[top of page]

Table: MSC_ATP_DETAIL_PEG_TEMP

Comments

Indexes

Columns

[top of page]

MSC.MSC_ATP_DETAIL_PEG_TEMP does not reference any database object

MSC.MSC_ATP_DETAIL_PEG_TEMP is referenced by following:

APPS

SYNONYM - MSC_ATP_DETAIL_PEG_TEMP

[top of page]

Table: MSC_ATP_PARAMETERS

Comments

ATP related parameters storage

Columns

[top of page]

MSC.MSC_ATP_PARAMETERS does not reference any database object

MSC.MSC_ATP_PARAMETERS is referenced by following:

APPS

SYNONYM - MSC_ATP_PARAMETERS

[top of page]

Table: MSC_ATP_PEGGING

Comments

Indexes

Columns

[top of page]

MSC.MSC_ATP_PEGGING does not reference any database object

MSC.MSC_ATP_PEGGING is referenced by following:

APPS

SYNONYM - MSC_ATP_PEGGING

[top of page]

Table: MSC_ATP_RULES

Primary Key: MSC_ATP_RULES_PK

1. SR_INSTANCE_ID
2. RULE_ID

Comments

This table stores rules and options that are used in Available To Promise computation.

Indexes

Columns

[top of page]

MSC.MSC_ATP_RULES does not reference any database object

MSC.MSC_ATP_RULES is referenced by following:

APPS

SYNONYM - MSC_ATP_RULES

[top of page]

Table: MSC_ATP_SUMMARY_RES

Primary Key: MSC_ATP_SUMMARY_RES_PK

1. PLAN_ID
2. SR_INSTANCE_ID
3. ORGANIZATION_ID
4. DEPARTMENT_ID
5. RESOURCE_ID
6. SD_DATE

Comments

Indexes

Columns

[top of page]

MSC.MSC_ATP_SUMMARY_RES does not reference any database object

MSC.MSC_ATP_SUMMARY_RES is referenced by following:

APPS

SYNONYM - MSC_ATP_SUMMARY_RES

[top of page]

Table: MSC_ATP_SUMMARY_SD

Primary Key: MSC_ATP_SUMMARY_SD_PK

1. PLAN_ID
2. SR_INSTANCE_ID
3. ORGANIZATION_ID
4. INVENTORY_ITEM_ID
5. SD_DATE
6. DEMAND_CLASS

Comments

Indexes

Columns

[top of page]

MSC.MSC_ATP_SUMMARY_SD does not reference any database object

MSC.MSC_ATP_SUMMARY_SD is referenced by following:

APPS

SYNONYM - MSC_ATP_SUMMARY_SD

[top of page]

Table: MSC_ATP_SUMMARY_SO

Primary Key: MSC_ATP_SUMMARY_SO

1. PLAN_ID
2. SR_INSTANCE_ID
3. ORGANIZATION_ID
4. INVENTORY_ITEM_ID
5. SD_DATE
6. DEMAND_CLASS

Comments

Indexes

Columns

[top of page]

MSC.MSC_ATP_SUMMARY_SO does not reference any database object

MSC.MSC_ATP_SUMMARY_SO is referenced by following:

APPS

SYNONYM - MSC_ATP_SUMMARY_SO

[top of page]

Table: MSC_ATP_SUMMARY_SUP

Comments

Indexes

Columns

[top of page]

MSC.MSC_ATP_SUMMARY_SUP does not reference any database object

MSC.MSC_ATP_SUMMARY_SUP is referenced by following:

APPS

SYNONYM - MSC_ATP_SUMMARY_SUP

[top of page]

Table: MSC_AVAILABLE_TO_PROMISE

Primary Key: MSC_AVAILABLE_TO_PROMISE_PK

1. PLAN_ID
2. TRANSACTION_ID

Foreign Keys from this table:

Comments

MSC_AVAILABLE_TO_PROMISE stores the projected ATP values for an item
in an MRP or MPS plan. Each row represents the available to promise
quantity for an item on a given date.
The table is populated by the Planner.

Indexes

Columns

[top of page]

MSC.MSC_AVAILABLE_TO_PROMISE does not reference any database object

MSC.MSC_AVAILABLE_TO_PROMISE is referenced by following:

APPS

SYNONYM - MSC_AVAILABLE_TO_PROMISE

[top of page]

Table: MSC_BILL_OF_RESOURCES

Primary Key: MSC_BILL_OF_RESOURCES_PK

1. BILL_OF_RESOURCES
2. PLAN_ID
3. ORGANIZATION_ID
4. SR_INSTANCE_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This table stores the set of resources required in an organization.

Indexes

Columns

[top of page]

MSC.MSC_BILL_OF_RESOURCES does not reference any database object

MSC.MSC_BILL_OF_RESOURCES is referenced by following:

APPS

SYNONYM - MSC_BILL_OF_RESOURCES

[top of page]

Table: MSC_BIS_BUSINESS_PLANS

Primary Key: MSC_BIS_BUSINESS_PLANS_PK

1. BUSINESS_PLAN_ID
2. SR_INSTANCE_ID

Foreign Keys to this table:

Comments

A business plan in this context is one of possibly many scenarios which set performance targets to particular values anticipated under that scenario.
The MSC_BIS_BUSINESS_PLANS table is a simple listing of business plans collected from source applications.

Indexes

Columns

[top of page]

MSC.MSC_BIS_BUSINESS_PLANS does not reference any database object

MSC.MSC_BIS_BUSINESS_PLANS is referenced by following:

APPS

SYNONYM - MSC_BIS_BUSINESS_PLANS

[top of page]

Table: MSC_BIS_INV_CAT_MV_TAB

Comments

This is a KPI Summary Table to group data from MSC_BIS_INV_DETAIL table by plan_id, org_id,sr_instance_id,category_id, and detailed date.

Indexes

Columns

[top of page]

MSC.MSC_BIS_INV_CAT_MV_TAB does not reference any database object

MSC.MSC_BIS_INV_CAT_MV_TAB is referenced by following:

APPS

SYNONYM - MSC_BIS_INV_CAT_MV_TAB

[top of page]

Table: MSC_BIS_INV_DATE_MV_TAB

Comments

This is a KPI Summary Table to group data from MSC_BIS_INV_DETAIL table by plan_id,org_id,sr_instance_id and detail_date.

Indexes

Columns

[top of page]

MSC.MSC_BIS_INV_DATE_MV_TAB does not reference any database object

MSC.MSC_BIS_INV_DATE_MV_TAB is referenced by following:

APPS

SYNONYM - MSC_BIS_INV_DATE_MV_TAB

[top of page]

Table: MSC_BIS_INV_DETAIL

Comments

MSC_BIS_INV_DETAIL contains Inventory balance details collected from source applications.

Indexes

Columns