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 - GMD Tables and Views

TABLE - GMD.FM_ARES_MST
TABLE - GMD.FM_CONF_TBL
TABLE - GMD.FM_FMCT_CLS
TABLE - GMD.FM_FORM_MST_B
TABLE - GMD.FM_FORM_MST_TL
TABLE - GMD.FM_IBOM_DTL
TABLE - GMD.FM_IBOM_HDR
TABLE - GMD.FM_MATL_DTL
TABLE - GMD.FM_ROUT_DEP
TABLE - GMD.FM_ROUT_DTL
TABLE - GMD.FM_ROUT_MTL
TABLE - GMD.FM_TEXT_HDR
TABLE - GMD.FM_TEXT_TBL_TL
TABLE - GMD.GMD_ACTIONS_B
TABLE - GMD.GMD_ACTIONS_TL
TABLE - GMD.GMD_ACTIVITIES_B
TABLE - GMD.GMD_ACTIVITIES_TL
TABLE - GMD.GMD_CHANGE_DISPOSITION
TABLE - GMD.GMD_CHANGE_LOTS
TABLE - GMD.GMD_COA_DETAILS
TABLE - GMD.GMD_COA_HEADERS
TABLE - GMD.GMD_COA_RSLT_TEXT
TABLE - GMD.GMD_COA_SPEC_HDR_TEXT
TABLE - GMD.GMD_COA_SPEC_TEXT
TABLE - GMD.GMD_COMPOSITE_RESULTS
TABLE - GMD.GMD_COMPOSITE_RESULT_ASSOC
TABLE - GMD.GMD_COMPOSITE_SPEC_DISP
TABLE - GMD.GMD_COMPOSITIONAL_REQS
TABLE - GMD.GMD_CUSTOMER_SPEC_VRS
TABLE - GMD.GMD_CUSTOMER_TESTS_B
TABLE - GMD.GMD_CUSTOMER_TESTS_TL
TABLE - GMD.GMD_EVENT_SPEC_DISP
TABLE - GMD.GMD_FORMULATION_SPECS
TABLE - GMD.GMD_FORMULA_ANALYSIS_DTL
TABLE - GMD.GMD_FORMULA_ANALYSIS_HDR
TABLE - GMD.GMD_FORMULA_CLASS_B
TABLE - GMD.GMD_FORMULA_CLASS_TL
TABLE - GMD.GMD_FORMULA_SECURITY
TABLE - GMD.GMD_FORMULA_SECURITY_TEMP
TABLE - GMD.GMD_FORMULA_SUBSTITUTION
TABLE - GMD.GMD_GRADES_B
TABLE - GMD.GMD_GRADES_TL
TABLE - GMD.GMD_HOLD_REASONS_B
TABLE - GMD.GMD_HOLD_REASONS_TL
TABLE - GMD.GMD_INVENTORY_SPEC_VRS
TABLE - GMD.GMD_ITEM_SUBSTITUTION_DTL
TABLE - GMD.GMD_ITEM_SUBSTITUTION_HDR_B
TABLE - GMD.GMD_ITEM_SUBSTITUTION_HDR_TL
TABLE - GMD.GMD_LAB_FORMULA_ASSOC
TABLE - GMD.GMD_LAB_ORGN_ASSOC
TABLE - GMD.GMD_LCF_CATEGORY_DTL_GTMP
TABLE - GMD.GMD_LCF_CATEGORY_HDR_GTMP
TABLE - GMD.GMD_LCF_DETAILS_GTMP
TABLE - GMD.GMD_LCF_EXTERNAL_COST
TABLE - GMD.GMD_LCF_TECH_DATA_GTMP
TABLE - GMD.GMD_MASS_RESULTS_GT
TABLE - GMD.GMD_MASS_SAMPLES
TABLE - GMD.GMD_MATERIAL_DETAILS_GTMP
TABLE - GMD.GMD_MATERIAL_HEADER_GTMP
TABLE - GMD.GMD_MATERIAL_REQS
TABLE - GMD.GMD_MIGRATE_PARMS
TABLE - GMD.GMD_MIGRATION
TABLE - GMD.GMD_MONITORING_SPEC_VRS
TABLE - GMD.GMD_MSNR_RESULTS
TABLE - GMD.GMD_OPERATIONS_B
TABLE - GMD.GMD_OPERATIONS_TL
TABLE - GMD.GMD_OPERATION_ACTIVITIES
TABLE - GMD.GMD_OPERATION_CLASS_B
TABLE - GMD.GMD_OPERATION_CLASS_TL
TABLE - GMD.GMD_OPERATION_RESOURCES
TABLE - GMD.GMD_OPRN_PROCESS_PARAMETERS
TABLE - GMD.GMD_OPTIMIZER_HDR_GTMP
TABLE - GMD.GMD_OPTIMIZER_LINE_GTMP
TABLE - GMD.GMD_PARAMETERS
TABLE - GMD.GMD_PARAMETERS_DTL
TABLE - GMD.GMD_PARAMETERS_HDR
TABLE - GMD.GMD_PARSED_EXPRESSION
TABLE - GMD.GMD_PROCESS_LOSS
TABLE - GMD.GMD_QC_ASSAY_CLASS
TABLE - GMD.GMD_QC_SPEC_MST_GTMP
TABLE - GMD.GMD_QC_STATUS_B
TABLE - GMD.GMD_QC_STATUS_NEXT
TABLE - GMD.GMD_QC_STATUS_TL
TABLE - GMD.GMD_QC_TESTS_B
TABLE - GMD.GMD_QC_TESTS_TL
TABLE - GMD.GMD_QC_TEST_VALUES_B
TABLE - GMD.GMD_QC_TEST_VALUES_TL
TABLE - GMD.GMD_QUALITY_CONFIG
TABLE - GMD.GMD_RECIPES_B
TABLE - GMD.GMD_RECIPES_TL
TABLE - GMD.GMD_RECIPE_CUSTOMERS
TABLE - GMD.GMD_RECIPE_EFF_ASSOC
TABLE - GMD.GMD_RECIPE_GENERATION
TABLE - GMD.GMD_RECIPE_ORGN_ACTIVITIES
TABLE - GMD.GMD_RECIPE_ORGN_RESOURCES
TABLE - GMD.GMD_RECIPE_PROCESS_LOSS
TABLE - GMD.GMD_RECIPE_PROCESS_PARAMETERS
TABLE - GMD.GMD_RECIPE_ROUTING_STEPS
TABLE - GMD.GMD_RECIPE_STEP_MATERIALS
TABLE - GMD.GMD_RECIPE_VALIDITY_RULES
TABLE - GMD.GMD_REPLACE
TABLE - GMD.GMD_RESULTS
TABLE - GMD.GMD_ROUTINGS_B
TABLE - GMD.GMD_ROUTINGS_TL
TABLE - GMD.GMD_ROUTING_CLASS_B
TABLE - GMD.GMD_ROUTING_CLASS_TL
TABLE - GMD.GMD_SAMPLES
TABLE - GMD.GMD_SAMPLES_LAB
TABLE - GMD.GMD_SAMPLE_REPLICATES_GT
TABLE - GMD.GMD_SAMPLE_SPEC_DISP
TABLE - GMD.GMD_SAMPLING_EVENTS
TABLE - GMD.GMD_SAMPLING_PLANS_B
TABLE - GMD.GMD_SAMPLING_PLANS_TL
TABLE - GMD.GMD_SECURITY_CONTROL
TABLE - GMD.GMD_SECURITY_PROFILES
TABLE - GMD.GMD_SPECIFICATIONS_B
TABLE - GMD.GMD_SPECIFICATIONS_TL
TABLE - GMD.GMD_SPECIFICATION_ATTRIBUTES
TABLE - GMD.GMD_SPEC_MAPPING
TABLE - GMD.GMD_SPEC_MAPPING_GTMP
TABLE - GMD.GMD_SPEC_RESULTS
TABLE - GMD.GMD_SPEC_TESTS_B
TABLE - GMD.GMD_SPEC_TESTS_TL
TABLE - GMD.GMD_SPREAD_ERRORS_GTMP
TABLE - GMD.GMD_SS_MATERIAL_SOURCES
TABLE - GMD.GMD_SS_STORAGE_HISTORY
TABLE - GMD.GMD_SS_STORAGE_PACKAGE
TABLE - GMD.GMD_SS_TIME_POINTS
TABLE - GMD.GMD_SS_VARIANTS
TABLE - GMD.GMD_STABILITY_SPEC_VRS
TABLE - GMD.GMD_STABILITY_STUDIES_B
TABLE - GMD.GMD_STABILITY_STUDIES_TL
TABLE - GMD.GMD_STATUS_B
TABLE - GMD.GMD_STATUS_NEXT
TABLE - GMD.GMD_STATUS_TL
TABLE - GMD.GMD_STORAGE_PLANS_B
TABLE - GMD.GMD_STORAGE_PLANS_TL
TABLE - GMD.GMD_STORAGE_PLAN_DETAILS
TABLE - GMD.GMD_SUPPLIER_SPEC_VRS
TABLE - GMD.GMD_TECHNICAL_DATA_DTL
TABLE - GMD.GMD_TECHNICAL_DATA_HDR
TABLE - GMD.GMD_TECHNICAL_REQS
TABLE - GMD.GMD_TECHNICAL_SEQUENCE_DTL
TABLE - GMD.GMD_TECHNICAL_SEQUENCE_HDR
TABLE - GMD.GMD_TECH_PARAMETERS_B
TABLE - GMD.GMD_TECH_PARAMETERS_TL
TABLE - GMD.GMD_TESTS_B
TABLE - GMD.GMD_TESTS_TL
TABLE - GMD.GMD_TEST_CLASSES_B
TABLE - GMD.GMD_TEST_CLASSES_TL
TABLE - GMD.GMD_TEST_GROUP_GT
TABLE - GMD.GMD_TEST_INTERVAL_PLANS_B
TABLE - GMD.GMD_TEST_INTERVAL_PLANS_TL
TABLE - GMD.GMD_TEST_INTERVAL_PLAN_PERIODS
TABLE - GMD.GMD_TEST_METHODS_B
TABLE - GMD.GMD_TEST_METHODS_TL
TABLE - GMD.GMD_TEST_VALUES_B
TABLE - GMD.GMD_TEST_VALUES_TL
TABLE - GMD.GMD_UNITS_B
TABLE - GMD.GMD_UNITS_TL
TABLE - GMD.GMD_UOM_CONVERSIONS
TABLE - GMD.GMD_VAL_RULE_GTMP
TABLE - GMD.GMD_VPD_SECURITY
TABLE - GMD.GMD_WIP_SPEC_VRS
TABLE - GMD.LM_FORM_DAT
TABLE - GMD.LM_FORM_DTL
TABLE - GMD.LM_FORM_MST
TABLE - GMD.LM_LTYP_MST
TABLE - GMD.LM_SPRD_DTL
TABLE - GMD.LM_SPRD_FLS
TABLE - GMD.LM_SPRD_PRM
TABLE - GMD.LM_SPRD_TEC
TABLE - GMD.LM_TECH_DTL
TABLE - GMD.LM_TEXT_HDR
TABLE - GMD.LM_TEXT_TBL_TL
TABLE - GMD.QC_ACTN_MST
TABLE - GMD.QC_HRES_MST
TABLE - GMD.QC_RSLT_MST
TABLE - GMD.QC_SMPL_MST
TABLE - GMD.QC_SPEC_MST
TABLE - GMD.QC_TEXT_HDR
TABLE - GMD.QC_TEXT_TBL_TL
VIEW - APPS.FM_FORM_EFF_VW1
VIEW - APPS.FM_FORM_EFF_VW3
VIEW - APPS.FM_FORM_EFF_VW3_OLD
VIEW - APPS.FM_FORM_MST_V1
VIEW - APPS.FM_FORM_MST_V2
VIEW - APPS.FM_FORM_MST_VL
VIEW - APPS.FM_OPRN_DTL_VW1
VIEW - APPS.FM_OPRN_MST_VW1
VIEW - APPS.FM_ROUT_DTL_V1
VIEW - APPS.FM_ROUT_HDR_V1
VIEW - APPS.FM_ROUT_HDR_V2
VIEW - APPS.FM_ROUT_MTL_VW1
VIEW - APPS.FM_TEXT_TBL_VL
VIEW - APPS.GMD_ACTIONS_VL
VIEW - APPS.GMD_ACTIVITIES_VL
VIEW - APPS.GMD_ALL_SPEC_VRS_VL
VIEW - APPS.GMD_COM_SPEC_VRS_VL
VIEW - APPS.GMD_CUSTOMER_TESTS_VL
VIEW - APPS.GMD_CUST_VEND_MST_V1
VIEW - APPS.GMD_CUST_VEND_MST_V2
VIEW - APPS.GMD_ERES_MATERIALS_VW
VIEW - APPS.GMD_ERES_RECIPES_VW
VIEW - APPS.GMD_FORMULA_CLASS_VL
VIEW - APPS.GMD_GRADES_VL
VIEW - APPS.GMD_HOLD_REASONS_VL
VIEW - APPS.GMD_ITEM_SUBSTITUTION_HDR_VL
VIEW - APPS.GMD_MATERIAL_EFFECTIVITIES_VW
VIEW - APPS.GMD_MBR_MATERIAL_V1
VIEW - APPS.GMD_MBR_OPRN_ACTIVITIY_V1
VIEW - APPS.GMD_MBR_RECIPE_HEADER_V1
VIEW - APPS.GMD_MBR_RECIPE_RSRC_V1
VIEW - APPS.GMD_MBR_STEP_MATERIAL_V1
VIEW - APPS.GMD_MBR_STEP_OPRN_V1
VIEW - APPS.GMD_OPERATIONS_VL
VIEW - APPS.GMD_OPERATION_CLASS_VL
VIEW - APPS.GMD_OPRN_PROCESS_PARAMETERS_V1
VIEW - APPS.GMD_ORG_ACCESS_VW
VIEW - APPS.GMD_QC_E_ALL_SPEC_VRS_DISP_V
VIEW - APPS.GMD_QC_E_COMPOSITE_RESULTS_V
VIEW - APPS.GMD_QC_E_CUST_SAMPLE_DTLS_V
VIEW - APPS.GMD_QC_E_CUST_SMPEVT_DTLS_V
VIEW - APPS.GMD_QC_E_RESULTS_V
VIEW - APPS.GMD_QC_E_SAMPLES_USED_V
VIEW - APPS.GMD_QC_E_SAMPLE_RESULTS_V
VIEW - APPS.GMD_QC_E_SPEC_TESTS_V
VIEW - APPS.GMD_QC_E_SUPP_SAMPLE_DTLS_V
VIEW - APPS.GMD_QC_E_SUPP_SMPEVT_DTLS_V
VIEW - APPS.GMD_QC_E_TEST_INSTANCE_V
VIEW - APPS.GMD_QC_E_WIP_SAMPLE_DTLS_V
VIEW - APPS.GMD_QC_E_WIP_SMPEVT_DTLS_V
VIEW - APPS.GMD_QC_STATUS_VL
VIEW - APPS.GMD_QC_TESTS_VL
VIEW - APPS.GMD_QC_TEST_VALUES_VL
VIEW - APPS.GMD_QM_E_MATERIAL_SOURCES_V
VIEW - APPS.GMD_QM_E_STABILITY_STUDIES_V
VIEW - APPS.GMD_QM_E_TIMEPOINTS_V
VIEW - APPS.GMD_RECIPES_VL
VIEW - APPS.GMD_ROUTINGS_VL
VIEW - APPS.GMD_ROUTING_CLASS_VL
VIEW - APPS.GMD_SAMPLING_PLANS_VL
VIEW - APPS.GMD_SPECIFICATIONS_VL
VIEW - APPS.GMD_SPEC_SUMMARY
VIEW - APPS.GMD_SPEC_TESTS_VL
VIEW - APPS.GMD_STABILITY_STUDIES_VL
VIEW - APPS.GMD_STATUS_VL
VIEW - APPS.GMD_STORAGE_PLANS_VL
VIEW - APPS.GMD_TECHNICAL_DATA_VL
VIEW - APPS.GMD_TECHNICAL_SEQUENCE_VL
VIEW - APPS.GMD_TECH_PARAMETERS_VL
VIEW - APPS.GMD_TESTS_VL
VIEW - APPS.GMD_TEST_CLASSES_VL
VIEW - APPS.GMD_TEST_INTERVAL_PLANS_VL
VIEW - APPS.GMD_TEST_METHODS_VL
VIEW - APPS.GMD_TEST_VALUES_VL
VIEW - APPS.GMD_UNITS_VL
VIEW - APPS.LM_TEXT_TBL_VL
VIEW - APPS.QC_TEXT_TBL_VL
VIEW - APPS.QC_TRAN_VW1
VIEW - APPS.QC_TRAN_VW2

Table: FM_ARES_MST

Description: Operation-specific alternate resource factors
Primary Key: FM_ARES_MST_PK
  1. OPRN_ID
  2. PRIMARY_RESOURCE
  3. ALTERNATE_RESOURCE
Foreign Keys from this table:
Foreign Key Column Foreign Table
FM_ARES_MST.PRIMARY_RESOURCE CR_RSRC_MST_B
FM_ARES_MST.ALTERNATE_RESOURCE CR_RSRC_MST_B
FM_ARES_MST.PRIMARY_RESOURCE CR_RSRC_MST
FM_ARES_MST.ALTERNATE_RESOURCE CR_RSRC_MST
FM_ARES_MST.TEXT_CODE FM_TEXT_HDR

[top of page]

GMD.FM_ARES_MST does not reference any database object

GMD.FM_ARES_MST is referenced by following:

GMD
VIEW - FM_ARES_MST#

[top of page]

Table: FM_CONF_TBL

Description: FM effectivity configuration. Controls how formula effectivities are created.
Primary Key: FM_CONF_TBL_PK
  1. FMCONF_ID
Primary Key: FM_CONF_TBL_U1
  1. ORGN_CODE
  2. FORMULA_USE
Foreign Keys from this table:
Foreign Key Column Foreign Table
FM_CONF_TBL.TEXT_CODE FM_TEXT_HDR
FM_CONF_TBL.ORGN_CODE SY_ORGN_MST_B
FM_CONF_TBL.ORGN_CODE SY_ORGN_MST

[top of page]

GMD.FM_CONF_TBL does not reference any database object

GMD.FM_CONF_TBL is referenced by following:

GMD
VIEW - FM_CONF_TBL#

[top of page]

Table: FM_FMCT_CLS

Description: Formula control classes -NOT USED-
Primary Key: FM_FMCT_CLS_PK
  1. FMCONTROL_CLASS
Foreign Keys from this table:
Foreign Key Column Foreign Table
FM_FMCT_CLS.TEXT_CODE FM_TEXT_HDR
Foreign Keys to this table:
Foreign Key Column Foreign Table
FM_FORM_MST_B.FMCONTROL_CLASS FM_FMCT_CLS
FM_FORM_MST.FMCONTROL_CLASS FM_FMCT_CLS
LM_FORM_MST.FMCONTROL_CLASS FM_FMCT_CLS

[top of page]

GMD.FM_FMCT_CLS does not reference any database object

GMD.FM_FMCT_CLS is referenced by following:

GMD
VIEW - FM_FMCT_CLS#

[top of page]

Table: FM_FORM_MST_B

Description: Formula header base table
Primary Key: FM_FORM_MST_B_PK
  1. FORMULA_ID
Primary Key: FM_FORM_MST_B_UK
  1. FORMULA_NO
  2. FORMULA_VERS
Foreign Keys from this table:
Foreign Key Column Foreign Table
FM_FORM_MST_B.FMCONTROL_CLASS FM_FMCT_CLS
FM_FORM_MST_B.TEXT_CODE FM_TEXT_HDR
FM_FORM_MST_B.FORMULA_CLASS GMD_FORMULA_CLASS_B

[top of page]

GMD.FM_FORM_MST_B does not reference any database object

GMD.FM_FORM_MST_B is referenced by following:

GMD
VIEW - FM_FORM_MST_B#

[top of page]

Table: FM_FORM_MST_TL

Description: Formula header translation table
Primary Key: FM_FORM_MST_TL_PK
  1. FORMULA_ID
  2. LANGUAGE

[top of page]

GMD.FM_FORM_MST_TL does not reference any database object

GMD.FM_FORM_MST_TL is referenced by following:

GMD
VIEW - FM_FORM_MST_TL#

[top of page]

Table: FM_IBOM_DTL

Description: Detail table for Indented Bill of Materials Report
Primary Key: FM_IBOM_DTL_PK
  1. TOP_FORMULA_ID
  2. EXPLODE_SEQ

[top of page]

GMD.FM_IBOM_DTL does not reference any database object

GMD.FM_IBOM_DTL is referenced by following:

GMD
VIEW - FM_IBOM_DTL#

[top of page]

Table: FM_IBOM_HDR

Description: Header table used for Indented Bill Of Materials report
Primary Key: FM_IBOM_HDR_PK
  1. TOP_FORMULA_ID

[top of page]

GMD.FM_IBOM_HDR does not reference any database object

GMD.FM_IBOM_HDR is referenced by following:

GMD
VIEW - FM_IBOM_HDR#

[top of page]

Table: FM_MATL_DTL

Description: Formula material details - contains products,byproducts and ingredient information
Primary Key: FM_MATL_DTL_PK
  1. FORMULALINE_ID
Primary Key: FM_MATL_DTL_U1
  1. FORMULA_ID
  2. LINE_TYPE
  3. LINE_NO
Foreign Keys from this table:
Foreign Key Column Foreign Table
FM_MATL_DTL.FORMULA_ID FM_FORM_MST
FM_MATL_DTL.TEXT_CODE FM_TEXT_HDR
FM_MATL_DTL.ITEM_ID IC_ITEM_MST_B
FM_MATL_DTL.ITEM_ID IC_ITEM_MST
FM_MATL_DTL.ITEM_UM SY_UOMS_MST
Foreign Keys to this table:
Foreign Key Column Foreign Table
FM_ROUT_MTL.FORMULALINE_ID FM_MATL_DTL
QC_RSLT_MST.FORMULALINE_ID FM_MATL_DTL
QC_SMPL_MST.FORMULALINE_ID FM_MATL_DTL
QC_SPEC_MST.FORMULALINE_ID FM_MATL_DTL

[top of page]

GMD.FM_MATL_DTL does not reference any database object

GMD.FM_MATL_DTL is referenced by following:

GMD
VIEW - FM_MATL_DTL#

[top of page]

Table: FM_ROUT_DEP

Description: Routing step dependencies
Primary Key: FM_ROUT_DEP_PK
  1. ROUTINGSTEP_NO
  2. DEP_ROUTINGSTEP_NO
  3. ROUTING_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FM_ROUT_DEP.ROUTING_ID
FM_ROUT_DEP.ROUTINGSTEP_NO
FM_ROUT_DTL
FM_ROUT_DEP.ROUTING_ID
FM_ROUT_DEP.DEP_ROUTINGSTEP_NO
FM_ROUT_DTL
FM_ROUT_DEP.TEXT_CODE FM_TEXT_HDR

[top of page]

GMD.FM_ROUT_DEP does not reference any database object

GMD.FM_ROUT_DEP is referenced by following:

GMD
VIEW - FM_ROUT_DEP#

[top of page]

Table: FM_ROUT_DTL

Description: Routing details
Primary Key: FM_ROUT_DTLI1
  1. ROUTINGSTEP_ID
Primary Key: FM_ROUT_DTL_PK
  1. ROUTING_ID
  2. ROUTINGSTEP_NO
Foreign Keys from this table:
Foreign Key Column Foreign Table
FM_ROUT_DTL.OPRN_ID FM_OPRN_MST
FM_ROUT_DTL.ROUTING_ID FM_ROUT_HDR
FM_ROUT_DTL.TEXT_CODE FM_TEXT_HDR
FM_ROUT_DTL.ROUTING_ID GMD_ROUTINGS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
FM_ROUT_DEP.ROUTING_ID
FM_ROUT_DEP.ROUTINGSTEP_NO
FM_ROUT_DTL
FM_ROUT_DEP.ROUTING_ID
FM_ROUT_DEP.DEP_ROUTINGSTEP_NO
FM_ROUT_DTL
GMD_RECIPE_PROCESS_PARAMETERS.ROUTINGSTEP_ID FM_ROUT_DTL
PM_ROUT_DTL.ROUTINGSTEP_ID FM_ROUT_DTL
QC_RSLT_MST.ROUTING_ID
QC_RSLT_MST.ROUTINGSTEP_NO
FM_ROUT_DTL
QC_SMPL_MST.ROUTING_ID
QC_SMPL_MST.ROUTINGSTEP_NO
FM_ROUT_DTL
QC_SPEC_MST.ROUTING_ID
QC_SPEC_MST.ROUTINGSTEP_NO
FM_ROUT_DTL

[top of page]

GMD.FM_ROUT_DTL does not reference any database object

GMD.FM_ROUT_DTL is referenced by following:

GMD
VIEW - FM_ROUT_DTL#

[top of page]

Table: FM_ROUT_MTL

Description: Routing Steps to Formula Lines Association
Primary Key: FM_ROUT_MTL_PK
  1. FORMULA_ID
  2. ROUTING_ID
  3. FORMULALINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FM_ROUT_MTL.FORMULALINE_ID FM_MATL_DTL
FM_ROUT_MTL.TEXT_CODE FM_TEXT_HDR

[top of page]

GMD.FM_ROUT_MTL does not reference any database object

GMD.FM_ROUT_MTL is referenced by following:

GMD
VIEW - FM_ROUT_MTL#

[top of page]

Table: FM_TEXT_HDR

Description: Table used to store text types for Formula Model
Primary Key: FM_TEXT_HDR_PK
  1. TEXT_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
FM_ACTV_MST.TEXT_CODE FM_TEXT_HDR
FM_ARES_MST.TEXT_CODE FM_TEXT_HDR
FM_CONF_TBL.TEXT_CODE FM_TEXT_HDR
FM_FMCT_CLS.TEXT_CODE FM_TEXT_HDR
FM_FORM_CLS.TEXT_CODE FM_TEXT_HDR
FM_FORM_EFF.TEXT_CODE FM_TEXT_HDR
FM_FORM_MST_B.TEXT_CODE FM_TEXT_HDR
FM_FORM_MST.TEXT_CODE FM_TEXT_HDR
FM_MATL_DTL.TEXT_CODE FM_TEXT_HDR
FM_OPRN_CLS.TEXT_CODE FM_TEXT_HDR
FM_OPRN_DTL.TEXT_CODE FM_TEXT_HDR
FM_OPRN_MST.TEXT_CODE FM_TEXT_HDR
FM_ROUT_CLS.TEXT_CODE FM_TEXT_HDR
FM_ROUT_DEP.TEXT_CODE FM_TEXT_HDR
FM_ROUT_DTL.TEXT_CODE FM_TEXT_HDR
FM_ROUT_HDR.TEXT_CODE FM_TEXT_HDR
FM_ROUT_MTL.TEXT_CODE FM_TEXT_HDR
GMD_ACTIVITIES_B.TEXT_CODE FM_TEXT_HDR
GMD_FORMULA_CLASS_B.TEXT_CODE FM_TEXT_HDR
GMD_OPERATION_CLASS_B.TEXT_CODE FM_TEXT_HDR
GMD_ROUTINGS_B.TEXT_CODE FM_TEXT_HDR
GMD_ROUTING_CLASS_B.TEXT_CODE FM_TEXT_HDR
LM_SPRD_FLS.TEXT_CODE FM_TEXT_HDR
MR_SHDY_HDR.TEXT_CODE FM_TEXT_HDR

[top of page]

GMD.FM_TEXT_HDR does not reference any database object

GMD.FM_TEXT_HDR is referenced by following:

GMD
VIEW - FM_TEXT_HDR#

[top of page]

Table: FM_TEXT_TBL_TL

Description: FM Module Text Lines. Descriptive text for all tables in this module.
Primary Key: FM_TEXT_TBL_TL_PK
  1. TEXT_CODE
  2. LANG_CODE
  3. PARAGRAPH_CODE
  4. SUB_PARACODE
  5. LINE_NO
  6. LANGUAGE

[top of page]

GMD.FM_TEXT_TBL_TL does not reference any database object

GMD.FM_TEXT_TBL_TL is referenced by following:

GMD
VIEW - FM_TEXT_TBL_TL#

[top of page]

Table: GMD_ACTIONS_B

Description: OPM Quality Actions
Primary Key: GMD_ACTIONS_B_PK
  1. ACTION_CODE

[top of page]

GMD.GMD_ACTIONS_B does not reference any database object

GMD.GMD_ACTIONS_B is referenced by following:

GMD
VIEW - GMD_ACTIONS_B#

[top of page]

Table: GMD_ACTIONS_TL

Description: OPM Quality Translation table
Primary Key: GMD_ACTIONS_TL_PK
  1. ACTION_CODE
  2. LANGUAGE

[top of page]

GMD.GMD_ACTIONS_TL does not reference any database object

GMD.GMD_ACTIONS_TL is referenced by following:

GMD
VIEW - GMD_ACTIONS_TL#

[top of page]

Table: GMD_ACTIVITIES_B

Description: Activities base table. Defines activities which are performed in operations.
Primary Key: GMD_ACTIVITIES_B_PK
  1. ACTIVITY
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMD_ACTIVITIES_B.COST_ANALYSIS_CODE CM_ALYS_MST
GMD_ACTIVITIES_B.TEXT_CODE FM_TEXT_HDR
Foreign Keys to this table:
Foreign Key Column Foreign Table
PM_OPRN_DTL.ACTIVITY GMD_ACTIVITIES_B

[top of page]

GMD.GMD_ACTIVITIES_B does not reference any database object

GMD.GMD_ACTIVITIES_B is referenced by following:

GMD
VIEW - GMD_ACTIVITIES_B#

[top of page]

Table: GMD_ACTIVITIES_TL

Description: Activities Translation Table
Primary Key: GMD_ACTIVITIES_TL_PK
  1. ACTIVITY
  2. LANGUAGE

[top of page]

GMD.GMD_ACTIVITIES_TL does not reference any database object

GMD.GMD_ACTIVITIES_TL is referenced by following:

GMD
VIEW - GMD_ACTIVITIES_TL#

[top of page]

Table: GMD_CHANGE_DISPOSITION

Description: Change Disposition form history table

[top of page]

GMD.GMD_CHANGE_DISPOSITION does not reference any database object

GMD.GMD_CHANGE_DISPOSITION is referenced by following:

GMD
VIEW - GMD_CHANGE_DISPOSITION#

[top of page]

Table: GMD_CHANGE_LOTS

Description: Change Disposition form history - Lots affected

[top of page]

GMD.GMD_CHANGE_LOTS does not reference any database object

GMD.GMD_CHANGE_LOTS is referenced by following:

GMD
VIEW - GMD_CHANGE_LOTS#

[top of page]

Table: GMD_COA_DETAILS

Description: Certificate of Analysis report details information

[top of page]

GMD.GMD_COA_DETAILS does not reference any database object

GMD.GMD_COA_DETAILS is referenced by following:

GMD
VIEW - GMD_COA_DETAILS#

[top of page]

Table: GMD_COA_HEADERS

Description: Certificate of Analysis report header information

[top of page]

GMD.GMD_COA_HEADERS does not reference any database object

GMD.GMD_COA_HEADERS is referenced by following:

GMD
VIEW - GMD_COA_HEADERS#

[top of page]

Table: GMD_COA_RSLT_TEXT

Description: Certificate of Analysis result text

[top of page]

GMD.GMD_COA_RSLT_TEXT does not reference any database object

GMD.GMD_COA_RSLT_TEXT is referenced by following:

GMD
VIEW - GMD_COA_RSLT_TEXT#

[top of page]

Table: GMD_COA_SPEC_HDR_TEXT

Description: Certificate of Analysis report header text information

[top of page]

GMD.GMD_COA_SPEC_HDR_TEXT does not reference any database object

GMD.GMD_COA_SPEC_HDR_TEXT is referenced by following:

GMD
VIEW - GMD_COA_SPEC_HDR_TEXT#

[top of page]

Table: GMD_COA_SPEC_TEXT

Description: Certificate of Analysis Specification text

[top of page]

GMD.GMD_COA_SPEC_TEXT does not reference any database object

GMD.GMD_COA_SPEC_TEXT is referenced by following:

GMD
VIEW - GMD_COA_SPEC_TEXT#

[top of page]

Table: GMD_COMPOSITE_RESULTS

Description: OPM Quality Composite results
Primary Key: GMD_COMPOSITE_RESULTS_PK
  1. COMPOSITE_RESULT_ID

[top of page]

GMD.GMD_COMPOSITE_RESULTS does not reference any database object

GMD.GMD_COMPOSITE_RESULTS is referenced by following:

GMD
VIEW - GMD_COMPOSITE_RESULTS#

[top of page]

Table: GMD_COMPOSITE_RESULT_ASSOC

Description: OPM Quality Composite Result Association

[top of page]

GMD.GMD_COMPOSITE_RESULT_ASSOC does not reference any database object

GMD.GMD_COMPOSITE_RESULT_ASSOC is referenced by following:

GMD
VIEW - GMD_COMPOSITE_RESULT_ASSOC#

[top of page]

Table: GMD_COMPOSITE_SPEC_DISP

Description: OPM Quality Composite Specification Display
Primary Key: GMD_COMPOSITE_SPEC_DISP_PK
  1. EVENT_SPEC_DISP_ID
  2. COMPOSITE_SPEC_DISP_ID

[top of page]

GMD.GMD_COMPOSITE_SPEC_DISP does not reference any database object

GMD.GMD_COMPOSITE_SPEC_DISP is referenced by following:

GMD
VIEW - GMD_COMPOSITE_SPEC_DISP#

[top of page]

Table: GMD_COMPOSITIONAL_REQS

Description: LCF - Compositional Requirements Table

[top of page]

GMD.GMD_COMPOSITIONAL_REQS does not reference any database object

GMD.GMD_COMPOSITIONAL_REQS is referenced by following:

GMD
VIEW - GMD_COMPOSITIONAL_REQS#

[top of page]

Table: GMD_CUSTOMER_SPEC_VRS

Description: OPM Work-in-Process Specification validity rules
Primary Key: GMD_CUSTOMER_SPEC_VRS_PK
  1. SPEC_VR_ID

[top of page]

GMD.GMD_CUSTOMER_SPEC_VRS does not reference any database object

GMD.GMD_CUSTOMER_SPEC_VRS is referenced by following:

GMD
VIEW - GMD_CUSTOMER_SPEC_VRS#

[top of page]

Table: GMD_CUSTOMER_TESTS_B

Description: Customer Tests
Primary Key: GMD_CUSTOMER_TESTS_B_PK
  1. TEST_ID
  2. CUST_ID

[top of page]

GMD.GMD_CUSTOMER_TESTS_B does not reference any database object

GMD.GMD_CUSTOMER_TESTS_B is referenced by following:

GMD
VIEW - GMD_CUSTOMER_TESTS_B#

[top of page]

Table: GMD_CUSTOMER_TESTS_TL

Description: Customer Tests Translation table
Primary Key: GMD_CUSTOMER_TESTS_TL_PK
  1. TEST_ID
  2. CUST_ID
  3. LANGUAGE

[top of page]

GMD.GMD_CUSTOMER_TESTS_TL does not reference any database object

GMD.GMD_CUSTOMER_TESTS_TL is referenced by following:

GMD
VIEW - GMD_CUSTOMER_TESTS_TL#

[top of page]

Table: GMD_EVENT_SPEC_DISP

Description: OPM Quality Event Specification Display
Primary Key: GMD_EVENT_SPEC_DISP_PK
  1. EVENT_SPEC_DISP_ID

[top of page]

GMD.GMD_EVENT_SPEC_DISP does not reference any database object

GMD.GMD_EVENT_SPEC_DISP is referenced by following:

GMD
VIEW - GMD_EVENT_SPEC_DISP#

[top of page]

Table: GMD_FORMULATION_SPECS

Description: LCF - Formulation Specification table

[top of page]

GMD.GMD_FORMULATION_SPECS does not reference any database object

GMD.GMD_FORMULATION_SPECS is referenced by following:

GMD
VIEW - GMD_FORMULATION_SPECS#

[top of page]

Table: GMD_FORMULA_ANALYSIS_DTL

Description: Formula analysis detail table
Primary Key: GMD_FORMULA_ANALYSIS_DTL_PK
  1. FORMULA_ID
  2. ORGN_CODE
  3. ITEM_ID

[top of page]

GMD.GMD_FORMULA_ANALYSIS_DTL does not reference any database object

GMD.GMD_FORMULA_ANALYSIS_DTL is referenced by following:

GMD
VIEW - GMD_FORMULA_ANALYSIS_DTL#

[top of page]

Table: GMD_FORMULA_ANALYSIS_HDR

Description: Formula Analysis Header table.
Primary Key: GMD_FORMULA_ANALYSIS_HDR_PK
  1. FORMULA_ID
  2. ORGN_CODE

[top of page]

GMD.GMD_FORMULA_ANALYSIS_HDR does not reference any database object

GMD.GMD_FORMULA_ANALYSIS_HDR is referenced by following:

GMD
VIEW - GMD_FORMULA_ANALYSIS_HDR#

[top of page]

Table: GMD_FORMULA_CLASS_B

Description: Formula classes base table - used to group formulas.
Primary Key: GMD_FORMULA_CLASS_B_PK
  1. FORMULA_CLASS
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMD_FORMULA_CLASS_B.TEXT_CODE FM_TEXT_HDR
Foreign Keys to this table:
Foreign Key Column Foreign Table
FM_FORM_MST_B.FORMULA_CLASS GMD_FORMULA_CLASS_B

[top of page]

GMD.GMD_FORMULA_CLASS_B does not reference any database object

GMD.GMD_FORMULA_CLASS_B is referenced by following:

GMD
VIEW - GMD_FORMULA_CLASS_B#

[top of page]

Table: GMD_FORMULA_CLASS_TL

Description: Formula Class translation table

[top of page]

GMD.GMD_FORMULA_CLASS_TL does not reference any database object

GMD.GMD_FORMULA_CLASS_TL is referenced by following:

GMD
VIEW - GMD_FORMULA_CLASS_TL#

[top of page]

Table: GMD_FORMULA_SECURITY

Description: Formula Security table
Primary Key: GMD_FORMULA_SECURITY_PK
  1. FORMULA_SECURITY_ID
Primary Key: GMD_FORMULA_SECURITY_U1
  1. ORGN_CODE
  2. USER_ID
  3. RESPONSIBILITY_ID
  4. FORMULA_ID
  5. OTHER_ORGN

[top of page]

GMD.GMD_FORMULA_SECURITY does not reference any database object

GMD.GMD_FORMULA_SECURITY is referenced by following:

GMD
VIEW - GMD_FORMULA_SECURITY#

[top of page]

Table: GMD_FORMULA_SECURITY_TEMP

Description:

[top of page]

GMD.GMD_FORMULA_SECURITY_TEMP does not reference any database object

GMD.GMD_FORMULA_SECURITY_TEMP is referenced by following:

APPS
SYNONYM - GMD_FORMULA_SECURITY_TEMP

[top of page]

Table: GMD_FORMULA_SUBSTITUTION

Description: Formula Substitution table holds the valid formulas which are valid for the context item substitution

[top of page]

GMD.GMD_FORMULA_SUBSTITUTION does not reference any database object

GMD.GMD_FORMULA_SUBSTITUTION is referenced by following:

GMD
VIEW - GMD_FORMULA_SUBSTITUTION#

[top of page]

Table: GMD_GRADES_B

Description: QC grade code master.
Primary Key: GMD_GRADES_B_PK
  1. QC_GRADE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMD_GRADES_B.TEXT_CODE QC_TEXT_HDR
Foreign Keys to this table:
Foreign Key Column Foreign Table
IC_ADJS_JNL.QC_GRADE GMD_GRADES_B
IC_ITEM_MST_B.QC_GRADE GMD_GRADES_B
IC_LOTS_MST.QC_GRADE GMD_GRADES_B
IC_PHYS_CNT.GRADE_CODE GMD_GRADES_B
IC_TRAN_ARC.QC_GRADE GMD_GRADES_B
IC_TRAN_CMP.QC_GRADE GMD_GRADES_B
IC_TRAN_PND.QC_GRADE GMD_GRADES_B
OP_ALOT_PRM.PREFQC_GRADE GMD_GRADES_B
OP_CNTR_DTL.QC_GRADE GMD_GRADES_B
OP_ORDR_DTL.QC_GRADE_WANTED GMD_GRADES_B
OP_PRCE_ITM.QC_GRADE GMD_GRADES_B
OP_PRSL_DTL.QC_GRADE_WANTED GMD_GRADES_B
PO_BPOS_DTL.QC_GRADE_WANTED GMD_GRADES_B
PO_ORDR_DTL.QC_GRADE_WANTED GMD_GRADES_B

[top of page]

GMD.GMD_GRADES_B does not reference any database object

GMD.GMD_GRADES_B is referenced by following:

GMD
VIEW - GMD_GRADES_B#

[top of page]

Table: GMD_GRADES_TL

Description: QC Units Translation Table
Primary Key: GMD_GRADES_TL_PK
  1. QC_GRADE
  2. LANGUAGE

[top of page]

GMD.GMD_GRADES_TL does not reference any database object

GMD.GMD_GRADES_TL is referenced by following:

GMD
VIEW - GMD_GRADES_TL#

[top of page]

Table: GMD_HOLD_REASONS_B

Description: OPM Quality Hold reasons
Primary Key: GMD_HOLD_REASONS_B_PK
  1. QCHOLD_RES_CODE

[top of page]

GMD.GMD_HOLD_REASONS_B does not reference any database object

GMD.GMD_HOLD_REASONS_B is referenced by following:

GMD
VIEW - GMD_HOLD_REASONS_B#

[top of page]

Table: GMD_HOLD_REASONS_TL

Description: OPM Quality Hold Reasons
Primary Key: GMD_HOLD_REASONS_TL_PK
  1. QCHOLD_RES_CODE
  2. LANGUAGE

[top of page]

GMD.GMD_HOLD_REASONS_TL does not reference any database object

GMD.GMD_HOLD_REASONS_TL is referenced by following:

GMD
VIEW - GMD_HOLD_REASONS_TL#

[top of page]

Table: GMD_INVENTORY_SPEC_VRS

Description: OPM Quality Inventory Specification Validity Rules
Primary Key: GMD_INVENTORY_SPEC_VRS_PK
  1. SPEC_VR_ID

[top of page]

GMD.GMD_INVENTORY_SPEC_VRS does not reference any database object

GMD.GMD_INVENTORY_SPEC_VRS is referenced by following:

GMD
VIEW - GMD_INVENTORY_SPEC_VRS#

[top of page]

Table: GMD_ITEM_SUBSTITUTION_DTL

Description: Substitution Detail table holds the replacement item(s) for the original item in the Substitution Table
Primary Key: GMD_ITEM_SUBSTITUTION_DTL_PK
  1. SUBSTITUTION_LINE_ID

[top of page]

GMD.GMD_ITEM_SUBSTITUTION_DTL does not reference any database object

GMD.GMD_ITEM_SUBSTITUTION_DTL is referenced by following:

GMD
VIEW - GMD_ITEM_SUBSTITUTION_DTL#

[top of page]

Table: GMD_ITEM_SUBSTITUTION_HDR_B

Description: This is master table for the Item Substitution, which holds the item substitution details
Primary Key: GMD_ITEM_SUBSTITUTION_HDR_B_PK
  1. SUBSTITUTION_ID

[top of page]

GMD.GMD_ITEM_SUBSTITUTION_HDR_B does not reference any database object

GMD.GMD_ITEM_SUBSTITUTION_HDR_B is referenced by following:

GMD
VIEW - GMD_ITEM_SUBSTITUTION_HDR_B#

[top of page]

Table: GMD_ITEM_SUBSTITUTION_HDR_TL

Description: This is translate table for the Item Substitution
Primary Key: GMD_ITEM_SUBSTITUTION_HDR_TL_P
  1. LANGUAGE
  2. SUBSTITUTION_ID

[top of page]

GMD.GMD_ITEM_SUBSTITUTION_HDR_TL does not reference any database object

GMD.GMD_ITEM_SUBSTITUTION_HDR_TL is referenced by following:

GMD
VIEW - GMD_ITEM_SUBSTITUTION_HDR_TL#

[top of page]

Table: GMD_LAB_FORMULA_ASSOC

Description: Association for lab values that get converted to formulas

[top of page]

GMD.GMD_LAB_FORMULA_ASSOC does not reference any database object

GMD.GMD_LAB_FORMULA_ASSOC is referenced by following:

GMD
VIEW - GMD_LAB_FORMULA_ASSOC#

[top of page]

Table: GMD_LAB_ORGN_ASSOC

Description: Association for lab types that get converted to orgn codes

[top of page]

GMD.GMD_LAB_ORGN_ASSOC does not reference any database object

GMD.GMD_LAB_ORGN_ASSOC is referenced by following:

GMD
VIEW - GMD_LAB_ORGN_ASSOC#

[top of page]

Table: GMD_LCF_CATEGORY_DTL_GTMP

Description:

[top of page]

GMD.GMD_LCF_CATEGORY_DTL_GTMP does not reference any database object

GMD.GMD_LCF_CATEGORY_DTL_GTMP is referenced by following:

APPS
SYNONYM - GMD_LCF_CATEGORY_DTL_GTMP

[top of page]

Table: GMD_LCF_CATEGORY_HDR_GTMP

Description:

[top of page]

GMD.GMD_LCF_CATEGORY_HDR_GTMP does not reference any database object

GMD.GMD_LCF_CATEGORY_HDR_GTMP is referenced by following:

APPS
SYNONYM - GMD_LCF_CATEGORY_HDR_GTMP

[top of page]

Table: GMD_LCF_DETAILS_GTMP

Description:

[top of page]

GMD.GMD_LCF_DETAILS_GTMP does not reference any database object

GMD.GMD_LCF_DETAILS_GTMP is referenced by following:

APPS
SYNONYM - GMD_LCF_DETAILS_GTMP

[top of page]

Table: GMD_LCF_EXTERNAL_COST

Description: Source for, external cost values

[top of page]

GMD.GMD_LCF_EXTERNAL_COST does not reference any database object

GMD.GMD_LCF_EXTERNAL_COST is referenced by following:

GMD
VIEW - GMD_LCF_EXTERNAL_COST#

[top of page]

Table: GMD_LCF_TECH_DATA_GTMP

Description:

[top of page]

GMD.GMD_LCF_TECH_DATA_GTMP does not reference any database object

GMD.GMD_LCF_TECH_DATA_GTMP is referenced by following:

APPS
SYNONYM - GMD_LCF_TECH_DATA_GTMP

[top of page]

Table: GMD_MASS_RESULTS_GT

Description:

[top of page]

GMD.GMD_MASS_RESULTS_GT does not reference any database object

GMD.GMD_MASS_RESULTS_GT is referenced by following:

APPS
SYNONYM - GMD_MASS_RESULTS_GT

[top of page]

Table: GMD_MASS_SAMPLES

Description: Sample IDs for Mass Results Entry

[top of page]

GMD.GMD_MASS_SAMPLES does not reference any database object

GMD.GMD_MASS_SAMPLES is referenced by following:

GMD
VIEW - GMD_MASS_SAMPLES#

[top of page]

Table: GMD_MATERIAL_DETAILS_GTMP

Description:

[top of page]

GMD.GMD_MATERIAL_DETAILS_GTMP does not reference any database object

GMD.GMD_MATERIAL_DETAILS_GTMP is referenced by following:

APPS
SYNONYM - GMD_MATERIAL_DETAILS_GTMP

[top of page]

Table: GMD_MATERIAL_HEADER_GTMP

Description:

[top of page]

GMD.GMD_MATERIAL_HEADER_GTMP does not reference any database object

GMD.GMD_MATERIAL_HEADER_GTMP is referenced by following:

APPS
SYNONYM - GMD_MATERIAL_HEADER_GTMP

[top of page]

Table: GMD_MATERIAL_REQS

Description: LCF - Material Requirements Table

[top of page]

GMD.GMD_MATERIAL_REQS does not reference any database object

GMD.GMD_MATERIAL_REQS is referenced by following:

GMD
VIEW - GMD_MATERIAL_REQS#

[top of page]

Table: GMD_MIGRATE_PARMS

Description: Quality Migration Setup Table

[top of page]

GMD.GMD_MIGRATE_PARMS does not reference any database object

GMD.GMD_MIGRATE_PARMS is referenced by following:

GMD
VIEW - GMD_MIGRATE_PARMS#

[top of page]

Table: GMD_MIGRATION

Description: Stores error messages during data migration from 11i to 11i+

[top of page]

GMD.GMD_MIGRATION does not reference any database object

GMD.GMD_MIGRATION is referenced by following:

GMD
VIEW - GMD_MIGRATION#

[top of page]

Table: GMD_MONITORING_SPEC_VRS

Description: OPM Quality for Monitoring Spec Validity Rule
Primary Key: GMD_MONITORING_SPEC_VRS_PK
  1. SPEC_VR_ID

[top of page]

GMD.GMD_MONITORING_SPEC_VRS does not reference any database object

GMD.GMD_MONITORING_SPEC_VRS is referenced by following:

GMD
VIEW - GMD_MONITORING_SPEC_VRS#

[top of page]

Table: GMD_MSNR_RESULTS

Description: GMD Mass Search and Replace table for storing query results

[top of page]

GMD.GMD_MSNR_RESULTS does not reference any database object

GMD.GMD_MSNR_RESULTS is referenced by following:

GMD
VIEW - GMD_MSNR_RESULTS#

[top of page]

Table: GMD_OPERATIONS_B

Description: Operations base table.
Primary Key: GMD_OPERATIONS_B_PK
  1. OPRN_ID
Primary Key: GMD_OPERATIONS_B_U1
  1. OPRN_NO
  2. OPRN_VERS

[top of page]

GMD.GMD_OPERATIONS_B does not reference any database object

GMD.GMD_OPERATIONS_B is referenced by following:

GMD
VIEW - GMD_OPERATIONS_B#

[top of page]

Table: GMD_OPERATIONS_TL

Description: Operations translation table.
Primary Key: GMD_OPERATIONS_TL_PK
  1. OPRN_ID
  2. LANGUAGE

[top of page]

GMD.GMD_OPERATIONS_TL does not reference any database object

GMD.GMD_OPERATIONS_TL is referenced by following:

GMD
VIEW - GMD_OPERATIONS_TL#

[top of page]

Table: GMD_OPERATION_ACTIVITIES

Description: Operation Activity details
Primary Key: GMD_OPERATION_ACTIVITIES_PK
  1. OPRN_LINE_ID

[top of page]

GMD.GMD_OPERATION_ACTIVITIES does not reference any database object

GMD.GMD_OPERATION_ACTIVITIES is referenced by following:

GMD
VIEW - GMD_OPERATION_ACTIVITIES#

[top of page]

Table: GMD_OPERATION_CLASS_B

Description: Operation class base table. Used to group operations.
Primary Key: GMD_OPERATION_CLASS_B_PK
  1. OPRN_CLASS
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMD_OPERATION_CLASS_B.TEXT_CODE FM_TEXT_HDR

[top of page]

GMD.GMD_OPERATION_CLASS_B does not reference any database object

GMD.GMD_OPERATION_CLASS_B is referenced by following:

GMD
VIEW - GMD_OPERATION_CLASS_B#

[top of page]

Table: GMD_OPERATION_CLASS_TL

Description: Translation table for Operation Class

[top of page]

GMD.GMD_OPERATION_CLASS_TL does not reference any database object

GMD.GMD_OPERATION_CLASS_TL is referenced by following:

GMD
VIEW - GMD_OPERATION_CLASS_TL#

[top of page]

Table: GMD_OPERATION_RESOURCES

Description: Operation Resource details
Primary Key: GMD_OPERATION_RESOURCES_PK
  1. OPRN_LINE_ID
  2. RESOURCES
Foreign Keys to this table:
Foreign Key Column Foreign Table
GMD_OPRN_PROCESS_PARAMETERS.OPRN_LINE_ID
GMD_OPRN_PROCESS_PARAMETERS.RESOURCES
GMD_OPERATION_RESOURCES
GMD_RECIPE_PROCESS_PARAMETERS.OPRN_LINE_ID
GMD_RECIPE_PROCESS_PARAMETERS.RESOURCES
GMD_OPERATION_RESOURCES

[top of page]

GMD.GMD_OPERATION_RESOURCES does not reference any database object

GMD.GMD_OPERATION_RESOURCES is referenced by following:

GMD
VIEW - GMD_OPERATION_RESOURCES#

[top of page]

Table: GMD_OPRN_PROCESS_PARAMETERS

Description: Table associating process parameters to operation resource
Primary Key: GMD_OPRN_PROC_PARAM_PK
  1. OPRN_LINE_ID
  2. RESOURCES
  3. PARAMETER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMD_OPRN_PROCESS_PARAMETERS.PARAMETER_ID GMP_PROCESS_PARAMETERS_B
GMD_OPRN_PROCESS_PARAMETERS.OPRN_LINE_ID
GMD_OPRN_PROCESS_PARAMETERS.RESOURCES
GMD_OPERATION_RESOURCES

[top of page]

GMD.GMD_OPRN_PROCESS_PARAMETERS does not reference any database object

GMD.GMD_OPRN_PROCESS_PARAMETERS is referenced by following:

GMD
VIEW - GMD_OPRN_PROCESS_PARAMETERS#

[top of page]

Table: GMD_OPTIMIZER_HDR_GTMP

Description:

[top of page]

GMD.GMD_OPTIMIZER_HDR_GTMP does not reference any database object

GMD.GMD_OPTIMIZER_HDR_GTMP is referenced by following:

APPS
SYNONYM - GMD_OPTIMIZER_HDR_GTMP

[top of page]

Table: GMD_OPTIMIZER_LINE_GTMP

Description:

[top of page]

GMD.GMD_OPTIMIZER_LINE_GTMP does not reference any database object

GMD.GMD_OPTIMIZER_LINE_GTMP is referenced by following:

APPS
SYNONYM - GMD_OPTIMIZER_LINE_GTMP

[top of page]

Table: GMD_PARAMETERS

Description: Stores the default statuses for Organization
Primary Key: GMD_PARAMETERS_PK
  1. PARAMETER_ID

[top of page]

GMD.GMD_PARAMETERS does not reference any database object

GMD.GMD_PARAMETERS is referenced by following:

GMD
VIEW - GMD_PARAMETERS#

[top of page]

Table: GMD_PARAMETERS_DTL

Description: GMD parameters line table

[top of page]

GMD.GMD_PARAMETERS_DTL does not reference any database object

GMD.GMD_PARAMETERS_DTL is referenced by following:

GMD
VIEW - GMD_PARAMETERS_DTL#

[top of page]

Table: GMD_PARAMETERS_HDR

Description: used instead of profiles
Primary Key: GMD_PARAMETERS_HDR_PK
  1. PARAMETER_ID

[top of page]

GMD.GMD_PARAMETERS_HDR does not reference any database object

GMD.GMD_PARAMETERS_HDR is referenced by following:

GMD
VIEW - GMD_PARAMETERS_HDR#

[top of page]

Table: GMD_PARSED_EXPRESSION

Description: This table stores the parsed expression for the technical parameter

[top of page]

GMD.GMD_PARSED_EXPRESSION does not reference any database object

GMD.GMD_PARSED_EXPRESSION is referenced by following:

GMD
VIEW - GMD_PARSED_EXPRESSION#

[top of page]

Table: GMD_PROCESS_LOSS

Description: Routing Process Loss
Primary Key: GMD_PROCESS_LOSS_U1
  1. ROUTING_CLASS
  2. MAX_QUANTITY

[top of page]

GMD.GMD_PROCESS_LOSS does not reference any database object

GMD.GMD_PROCESS_LOSS is referenced by following:

GMD
VIEW - GMD_PROCESS_LOSS#

[top of page]

Table: GMD_QC_ASSAY_CLASS

Description: Quality Assay Class. Assay classes are quality test groupings.
Primary Key: GMD_QC_ASSAY_CLASS_PK
  1. ASSAY_CLASS

[top of page]

GMD.GMD_QC_ASSAY_CLASS does not reference any database object

GMD.GMD_QC_ASSAY_CLASS is referenced by following:

GMD
VIEW - GMD_QC_ASSAY_CLASS#

[top of page]

Table: GMD_QC_SPEC_MST_GTMP

Description:

[top of page]

GMD.GMD_QC_SPEC_MST_GTMP does not reference any database object

GMD.GMD_QC_SPEC_MST_GTMP is referenced by following:

APPS
SYNONYM - GMD_QC_SPEC_MST_GTMP

[top of page]

Table: GMD_QC_STATUS_B

Description: OPM Quality Status
Primary Key: GMD_QC_STATUS_B_PK
  1. STATUS_CODE
  2. ENTITY_TYPE

[top of page]

GMD.GMD_QC_STATUS_B does not reference any database object

GMD.GMD_QC_STATUS_B is referenced by following:

GMD
VIEW - GMD_QC_STATUS_B#

[top of page]

Table: GMD_QC_STATUS_NEXT

Description: OPM Quality target Status codes
Primary Key: GMD_QC_STATUS_NEXT_PK
  1. CURRENT_STATUS
  2. ENTITY_TYPE
  3. TARGET_STATUS

[top of page]

GMD.GMD_QC_STATUS_NEXT does not reference any database object

GMD.GMD_QC_STATUS_NEXT is referenced by following:

GMD
VIEW - GMD_QC_STATUS_NEXT#

[top of page]

Table: GMD_QC_STATUS_TL

Description: OPM Quality Status translation
Primary Key: GMD_QC_STATUS_TL_PK
  1. STATUS_CODE
  2. ENTITY_TYPE
  3. LANGUAGE

[top of page]

GMD.GMD_QC_STATUS_TL does not reference any database object

GMD.GMD_QC_STATUS_TL is referenced by following:

GMD
VIEW - GMD_QC_STATUS_TL#

[top of page]

Table: GMD_QC_TESTS_B

Description: OPM QC Test
Primary Key: GMD_QC_TESTS_B_PK
  1. TEST_ID
Primary Key: GMD_QC_TESTS_B_U1
  1. TEST_CODE

[top of page]

GMD.GMD_QC_TESTS_B does not reference any database object

GMD.GMD_QC_TESTS_B is referenced by following:

GMD
VIEW - GMD_QC_TESTS_B#

[top of page]

Table: GMD_QC_TESTS_TL

Description: OPM QC Test
Primary Key: GMD_QC_TESTS_TL_PK
  1. TEST_ID
  2. LANGUAGE

[top of page]

GMD.GMD_QC_TESTS_TL does not reference any database object

GMD.GMD_QC_TESTS_TL is referenced by following:

GMD
VIEW - GMD_QC_TESTS_TL#

[top of page]

Table: GMD_QC_TEST_VALUES_B

Description: OPM Test values
Primary Key: GMD_QC_TEST_VALUES_B_PK
  1. TEST_VALUE_ID
Primary Key: GMD_QC_TEST_VALUES_B_U1
  1. TEST_ID
  2. TEST_VALUE_ID

[top of page]

GMD.GMD_QC_TEST_VALUES_B does not reference any database object

GMD.GMD_QC_TEST_VALUES_B is referenced by following:

GMD
VIEW - GMD_QC_TEST_VALUES_B#

[top of page]

Table: GMD_QC_TEST_VALUES_TL

Description: OPM Test values Translation table
Primary Key: GMD_QC_TEST_VALUES_TL_PK
  1. TEST_VALUE_ID
  2. LANGUAGE

[top of page]

GMD.GMD_QC_TEST_VALUES_TL does not reference any database object

GMD.GMD_QC_TEST_VALUES_TL is referenced by following:

GMD
VIEW - GMD_QC_TEST_VALUES_TL#

[top of page]

Table: GMD_QUALITY_CONFIG

Description: OPM Quality Configuration
Primary Key: GMD_QUALITY_CONFIG_PK
  1. ORGANIZATION_ID
Primary Key: GMD_QUALITY_CONFIG_U1
  1. ORGN_CODE

[top of page]

GMD.GMD_QUALITY_CONFIG does not reference any database object

GMD.GMD_QUALITY_CONFIG is referenced by following:

GMD
VIEW - GMD_QUALITY_CONFIG#

[top of page]

Table: GMD_RECIPES_B

Description: Recipe header base table.
Primary Key: GMD_RECIPES_B_PK
  1. RECIPE_ID
Primary Key: GMD_RECIPES_B_U1
  1. RECIPE_NO
  2. RECIPE_VERSION
Foreign Keys to this table:
Foreign Key Column Foreign Table
GMD_RECIPE_PROCESS_PARAMETERS.RECIPE_ID GMD_RECIPES_B

[top of page]

GMD.GMD_RECIPES_B does not reference any database object

GMD.GMD_RECIPES_B is referenced by following:

GMD
VIEW - GMD_RECIPES_B#

[top of page]

Table: GMD_RECIPES_TL

Description: Recipe Translation Table
Primary Key: GMD_RECIPES_TL_PK
  1. RECIPE_ID
  2. LANGUAGE

[top of page]

GMD.GMD_RECIPES_TL does not reference any database object

GMD.GMD_RECIPES_TL is referenced by following:

GMD
VIEW - GMD_RECIPES_TL#

[top of page]

Table: GMD_RECIPE_CUSTOMERS

Description: This table stores recipe customer data
Primary Key: GMD_RECIPE_CUSTOMERS_PK
  1. RECIPE_ID
  2. CUSTOMER_ID

[top of page]

GMD.GMD_RECIPE_CUSTOMERS does not reference any database object

GMD.GMD_RECIPE_CUSTOMERS is referenced by following:

GMD
VIEW - GMD_RECIPE_CUSTOMERS#

[top of page]

Table: GMD_RECIPE_EFF_ASSOC

Description: Recipe-Effectivity Association Table
Primary Key: GMD_RECIPE_EFF_ASSOC_PK
  1. FMEFF_ID

[top of page]

GMD.GMD_RECIPE_EFF_ASSOC does not reference any database object

GMD.GMD_RECIPE_EFF_ASSOC is referenced by following:

GMD
VIEW - GMD_RECIPE_EFF_ASSOC#

[top of page]

Table: GMD_RECIPE_GENERATION

Description: Recipe Generation for automatic creation
Primary Key: GMD_RECIPE_GENERATION_PK
  1. RECIPE_GENERATION_ID

[top of page]

GMD.GMD_RECIPE_GENERATION does not reference any database object

GMD.GMD_RECIPE_GENERATION is referenced by following:

GMD
VIEW - GMD_RECIPE_GENERATION#

[top of page]

Table: GMD_RECIPE_ORGN_ACTIVITIES

Description: This table stores updates to operation activity details at the recipe level.
Primary Key: GMD_RECIPE_ORGN_ACTIVITIES_PK
  1. RECIPE_ID
  2. ORGN_CODE
  3. ROUTINGSTEP_ID
  4. OPRN_LINE_ID

[top of page]

GMD.GMD_RECIPE_ORGN_ACTIVITIES does not reference any database object

GMD.GMD_RECIPE_ORGN_ACTIVITIES is referenced by following:

GMD
VIEW - GMD_RECIPE_ORGN_ACTIVITIES#

[top of page]

Table: GMD_RECIPE_ORGN_RESOURCES

Description: This table stores updates to operation resources at the recipe level.
Primary Key: GMD_RECIPE_ORGN_RESOURCES_PK
  1. RECIPE_ID
  2. ORGN_CODE
  3. ROUTINGSTEP_ID
  4. OPRN_LINE_ID
  5. RESOURCES

[top of page]

GMD.GMD_RECIPE_ORGN_RESOURCES does not reference any database object

GMD.GMD_RECIPE_ORGN_RESOURCES is referenced by following:

GMD
VIEW - GMD_RECIPE_ORGN_RESOURCES#

[top of page]

Table: GMD_RECIPE_PROCESS_LOSS

Description: Stores process loss at the recipe level.
Primary Key: GMD_RECIPE_PROCESS_LOSS_PK
  1. RECIPE_PROCESS_LOSS_ID
Primary Key: GMD_RECIPE_PROCESS_LOSS_U1
  1. RECIPE_ID
  2. ORGN_CODE

[top of page]

GMD.GMD_RECIPE_PROCESS_LOSS does not reference any database object

GMD.GMD_RECIPE_PROCESS_LOSS is referenced by following:

GMD
VIEW - GMD_RECIPE_PROCESS_LOSS#

[top of page]

Table: GMD_RECIPE_PROCESS_PARAMETERS

Description: Table associating process parameters to Recipe orgn resource
Primary Key: GMD_RCP_PROC_PARAM_PK
  1. RECIPE_ID
  2. ORGANIZATION_ID
  3. ROUTINGSTEP_ID
  4. OPRN_LINE_ID
  5. PARAMETER_ID
  6. RESOURCES
Primary Key: GMD_RCP_PROC_PARAM_UK
  1. OPRN_LINE_ID
  2. ORGANIZATION_ID
  3. RECIPE_ID
  4. ROUTINGSTEP_ID
  5. RESOURCES
  6. PARAMETER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMD_RECIPE_PROCESS_PARAMETERS.PARAMETER_ID GMP_PROCESS_PARAMETERS_B
GMD_RECIPE_PROCESS_PARAMETERS.ROUTINGSTEP_ID FM_ROUT_DTL
GMD_RECIPE_PROCESS_PARAMETERS.OPRN_LINE_ID
GMD_RECIPE_PROCESS_PARAMETERS.RESOURCES
GMD_OPERATION_RESOURCES
GMD_RECIPE_PROCESS_PARAMETERS.RECIPE_ID GMD_RECIPES_B
GMD_RECIPE_PROCESS_PARAMETERS.ORGN_CODE SY_ORGN_MST_B

[top of page]

GMD.GMD_RECIPE_PROCESS_PARAMETERS does not reference any database object

GMD.GMD_RECIPE_PROCESS_PARAMETERS is referenced by following:

GMD
VIEW - GMD_RECIPE_PROCESS_PARAMETERS#

[top of page]

Table: GMD_RECIPE_ROUTING_STEPS

Description: This table stores updates to routing steps at the recipe level.
Primary Key: GMD_RECIPE_ROUTING_STEPS_PK
  1. RECIPE_ID
  2. ROUTINGSTEP_ID

[top of page]

GMD.GMD_RECIPE_ROUTING_STEPS does not reference any database object

GMD.GMD_RECIPE_ROUTING_STEPS is referenced by following:

GMD
VIEW - GMD_RECIPE_ROUTING_STEPS#

[top of page]

Table: GMD_RECIPE_STEP_MATERIALS

Description: This table stores step material information at the recipe level.
Primary Key: GMD_RECIPE_STEP_MATERIALS_PK
  1. RECIPE_ID
  2. FORMULALINE_ID

[top of page]

GMD.GMD_RECIPE_STEP_MATERIALS does not reference any database object

GMD.GMD_RECIPE_STEP_MATERIALS is referenced by following:

GMD
VIEW - GMD_RECIPE_STEP_MATERIALS#

[top of page]

Table: GMD_RECIPE_VALIDITY_RULES

Description: Stores quantity and effective dates for variou uses and/or organizations (formerly effectivities).
Primary Key: GMD_RECIPE_VALIDITY_RULES_PK
  1. RECIPE_VALIDITY_RULE_ID

[top of page]

GMD.GMD_RECIPE_VALIDITY_RULES does not reference any database object

GMD.GMD_RECIPE_VALIDITY_RULES is referenced by following:

GMD
VIEW - GMD_RECIPE_VALIDITY_RULES#

[top of page]

Table: GMD_REPLACE

Description: Used for Mass Search and Replace
Primary Key: GMD_REPLACE_PK
  1. REQUEST_ID

[top of page]

GMD.GMD_REPLACE does not reference any database object

GMD.GMD_REPLACE is referenced by following:

GMD
VIEW - GMD_REPLACE#

[top of page]

Table: GMD_RESULTS

Description: OPM Quality Results
Primary Key: GMD_RESULTS_PK
  1. RESULT_ID

[top of page]

GMD.GMD_RESULTS does not reference any database object

GMD.GMD_RESULTS is referenced by following:

GMD
VIEW - GMD_RESULTS#

[top of page]

Table: GMD_ROUTINGS_B

Description: Routing header base table.
Primary Key: GMD_ROUTINGS_B_PK
  1. ROUTING_ID
Primary Key: GMD_ROUTINGS_B_UC1
  1. ROUTING_NO
  2. ROUTING_VERS
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMD_ROUTINGS_B.TEXT_CODE FM_TEXT_HDR
GMD_ROUTINGS_B.ROUTING_CLASS GMD_ROUTING_CLASS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
FM_ROUT_DTL.ROUTING_ID GMD_ROUTINGS_B
GL_ACCT_MAP.ROUTING_ID GMD_ROUTINGS_B
GMP_FORM_EFF.ROUTING_ID GMD_ROUTINGS_B
PM_BTCH_HDR.ROUTING_ID GMD_ROUTINGS_B

[top of page]

GMD.GMD_ROUTINGS_B does not reference any database object

GMD.GMD_ROUTINGS_B is referenced by following:

GMD
VIEW - GMD_ROUTINGS_B#

[top of page]

Table: GMD_ROUTINGS_TL

Description: Routings header translations table
Primary Key: GMD_ROUTING_TL_PK
  1. ROUTING_ID
  2. LANGUAGE

[top of page]

GMD.GMD_ROUTINGS_TL does not reference any database object

GMD.GMD_ROUTINGS_TL is referenced by following:

GMD
VIEW - GMD_ROUTINGS_TL#

[top of page]

Table: GMD_ROUTING_CLASS_B

Description: Routing class base table - used to group routings.
Primary Key: GMD_ROUTING_CLASS_B_PK
  1. ROUTING_CLASS
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMD_ROUTING_CLASS_B.TEXT_CODE FM_TEXT_HDR
Foreign Keys to this table:
Foreign Key Column Foreign Table
GMD_ROUTINGS_B.ROUTING_CLASS GMD_ROUTING_CLASS_B

[top of page]

GMD.GMD_ROUTING_CLASS_B does not reference any database object

GMD.GMD_ROUTING_CLASS_B is referenced by following:

GMD
VIEW - GMD_ROUTING_CLASS_B#

[top of page]

Table: GMD_ROUTING_CLASS_TL

Description: Translation Table for routing class
Primary Key: GMD_ROUTING_CLASS_TL_FK
  1. ROUTING_CLASS
  2. LANGUAGE

[top of page]

GMD.GMD_ROUTING_CLASS_TL does not reference any database object

GMD.GMD_ROUTING_CLASS_TL is referenced by following:

GMD
VIEW - GMD_ROUTING_CLASS_TL#

[top of page]

Table: GMD_SAMPLES

Description: OPM Quality Samples
Primary Key: GMD_SAMPLES_PK
  1. SAMPLE_ID
Primary Key: GMD_SAMPLES_U1
  1. ORGN_CODE
  2. SAMPLE_NO

[top of page]

GMD.GMD_SAMPLES does not reference any database object

GMD.GMD_SAMPLES is referenced by following:

GMD
VIEW - GMD_SAMPLES#

[top of page]

Table: GMD_SAMPLES_LAB

Description: OPM Quality Samples Lab
Primary Key: GMD_SAMPLES_LAB_PK
  1. SAMPLE_ID
  2. QC_LAB_ORGN_CODE

[top of page]

GMD.GMD_SAMPLES_LAB does not reference any database object

GMD.GMD_SAMPLES_LAB is referenced by following:

GMD
VIEW - GMD_SAMPLES_LAB#

[top of page]

Table: GMD_SAMPLE_REPLICATES_GT

Description:

[top of page]

GMD.GMD_SAMPLE_REPLICATES_GT does not reference any database object

GMD.GMD_SAMPLE_REPLICATES_GT is referenced by following:

APPS
SYNONYM - GMD_SAMPLE_REPLICATES_GT

[top of page]

Table: GMD_SAMPLE_SPEC_DISP

Description: OPM Quality Sample Specification Display
Primary Key: GMD_SAMPLE_SPEC_DISP_PK
  1. EVENT_SPEC_DISP_ID
  2. SAMPLE_ID

[top of page]

GMD.GMD_SAMPLE_SPEC_DISP does not reference any database object

GMD.GMD_SAMPLE_SPEC_DISP is referenced by following:

GMD
VIEW - GMD_SAMPLE_SPEC_DISP#

[top of page]

Table: GMD_SAMPLING_EVENTS

Description: OPM Quality Sampling Event
Primary Key: GMD_SAMPLING_EVENTS_PK
  1. SAMPLING_EVENT_ID

[top of page]

GMD.GMD_SAMPLING_EVENTS does not reference any database object

GMD.GMD_SAMPLING_EVENTS is referenced by following:

GMD
VIEW - GMD_SAMPLING_EVENTS#

[top of page]

Table: GMD_SAMPLING_PLANS_B

Description: OPM Quality Sampling Plan

[top of page]

GMD.GMD_SAMPLING_PLANS_B does not reference any database object

GMD.GMD_SAMPLING_PLANS_B is referenced by following:

GMD
VIEW - GMD_SAMPLING_PLANS_B#

[top of page]

Table: GMD_SAMPLING_PLANS_TL

Description: OPM Quality Sampling Plan translation table

[top of page]

GMD.GMD_SAMPLING_PLANS_TL does not reference any database object

GMD.GMD_SAMPLING_PLANS_TL is referenced by following:

GMD
VIEW - GMD_SAMPLING_PLANS_TL#

[top of page]

Table: GMD_SECURITY_CONTROL

Description: Defines the level Formula Security is contorlled per OPM Organization
Primary Key: GMD_SECURITY_CONTROL_PK
  1. OBJECT_TYPE
  2. ORGN_CODE

[top of page]

GMD.GMD_SECURITY_CONTROL does not reference any database object

GMD.GMD_SECURITY_CONTROL is referenced by following:

GMD
VIEW - GMD_SECURITY_CONTROL#

[top of page]

Table: GMD_SECURITY_PROFILES

Description: Security Profiles give access to the object specified data. For example, a Security Profile gives access to a User for Formula data.
Primary Key: GMD_SECURITY_PROFILES_PK
  1. SECURITY_PROFILE_ID
Primary Key: GMD_SECURITY_PROFILES_UI1
  1. OBJECT_TYPE
  2. ASSIGN_METHOD_IND
  3. ACCESS_TYPE_IND
  4. ORGN_CODE
  5. USER_ID
  6. RESPONSIBILITY_ID
  7. OTHER_ORGN

[top of page]

GMD.GMD_SECURITY_PROFILES does not reference any database object

GMD.GMD_SECURITY_PROFILES is referenced by following:

GMD
VIEW - GMD_SECURITY_PROFILES#

[top of page]

Table: GMD_SPECIFICATIONS_B

Description: OPM Quality Specifications
Primary Key: GMD_SPECIFICATIONS_B_PK
  1. SPEC_ID
Primary Key: GMD_SPECIFICATIONS_B_U1
  1. SPEC_NAME
  2. SPEC_VERS

[top of page]

GMD.GMD_SPECIFICATIONS_B does not reference any database object

GMD.GMD_SPECIFICATIONS_B is referenced by following:

GMD
VIEW - GMD_SPECIFICATIONS_B#

[top of page]

Table: GMD_SPECIFICATIONS_TL

Description: OPM Quality Specifications Translation
Primary Key: GMD_SPECIFICATIONS_TL_PK
  1. SPEC_ID
  2. LANGUAGE

[top of page]

GMD.GMD_SPECIFICATIONS_TL does not reference any database object

GMD.GMD_SPECIFICATIONS_TL is referenced by following:

GMD
VIEW - GMD_SPECIFICATIONS_TL#

[top of page]

Table: GMD_SPECIFICATION_ATTRIBUTES

Description: LCF - Formulation Specification Attributes Table

[top of page]

GMD.GMD_SPECIFICATION_ATTRIBUTES does not reference any database object

GMD.GMD_SPECIFICATION_ATTRIBUTES is referenced by following:

GMD
VIEW - GMD_SPECIFICATION_ATTRIBUTES#

[top of page]

Table: GMD_SPEC_MAPPING

Description: Table used to map old spec definition to new definition

[top of page]

GMD.GMD_SPEC_MAPPING does not reference any database object

GMD.GMD_SPEC_MAPPING is referenced by following:

GMD
VIEW - GMD_SPEC_MAPPING#

[top of page]

Table: GMD_SPEC_MAPPING_GTMP

Description:

[top of page]

GMD.GMD_SPEC_MAPPING_GTMP does not reference any database object

GMD.GMD_SPEC_MAPPING_GTMP is referenced by following:

APPS
SYNONYM - GMD_SPEC_MAPPING_GTMP

[top of page]

Table: GMD_SPEC_RESULTS

Description: OPM Quality Specification Results
Primary Key: GMD_SPEC_RESULTS_PK
  1. RESULT_ID
  2. EVENT_SPEC_DISP_ID

[top of page]

GMD.GMD_SPEC_RESULTS does not reference any database object

GMD.GMD_SPEC_RESULTS is referenced by following:

GMD
VIEW - GMD_SPEC_RESULTS#

[top of page]

Table: GMD_SPEC_TESTS_B

Description: OPM Specification tests
Primary Key: GMD_SPEC_TESTS_B_PK
  1. TEST_ID
  2. SPEC_ID

[top of page]

GMD.GMD_SPEC_TESTS_B does not reference any database object

GMD.GMD_SPEC_TESTS_B is referenced by following:

GMD
VIEW - GMD_SPEC_TESTS_B#

[top of page]

Table: GMD_SPEC_TESTS_TL

Description: OPM Specification tests
Primary Key: GMD_SPEC_TESTS_TL_PK
  1. LANGUAGE
  2. SPEC_ID
  3. TEST_ID

[top of page]

GMD.GMD_SPEC_TESTS_TL does not reference any database object

GMD.GMD_SPEC_TESTS_TL is referenced by following:

GMD
VIEW - GMD_SPEC_TESTS_TL#

[top of page]

Table: GMD_SPREAD_ERRORS_GTMP

Description:

[top of page]

GMD.GMD_SPREAD_ERRORS_GTMP does not reference any database object

GMD.GMD_SPREAD_ERRORS_GTMP is referenced by following:

APPS
SYNONYM - GMD_SPREAD_ERRORS_GTMP

[top of page]

Table: GMD_SS_MATERIAL_SOURCES

Description: Stability Study Material Sources
Primary Key: GMD_SS_MATERIAL_SOURCES_PK
  1. SOURCE_ID

[top of page]

GMD.GMD_SS_MATERIAL_SOURCES does not reference any database object

GMD.GMD_SS_MATERIAL_SOURCES is referenced by following:

GMD
VIEW - GMD_SS_MATERIAL_SOURCES#

[top of page]

Table: GMD_SS_STORAGE_HISTORY

Description: Stability Study Variant Storage History
Primary Key: GMD_SS_STORAGE_HISTORY_PK
  1. STORAGE_HISTORY_ID

[top of page]

GMD.GMD_SS_STORAGE_HISTORY does not reference any database object

GMD.GMD_SS_STORAGE_HISTORY is referenced by following:

GMD
VIEW - GMD_SS_STORAGE_HISTORY#

[top of page]

Table: GMD_SS_STORAGE_PACKAGE

Description: Stability Study Variant Storage Package
Primary Key: GMD_SS_STORAGE_PACKAGE_PK
  1. PACKAGE_ID

[top of page]

GMD.GMD_SS_STORAGE_PACKAGE does not reference any database object

GMD.GMD_SS_STORAGE_PACKAGE is referenced by following:

GMD
VIEW - GMD_SS_STORAGE_PACKAGE#

[top of page]

Table: GMD_SS_TIME_POINTS

Description: Stability Study Time Points
Primary Key: GMD_SS_TIME_POINTS_PK
  1. TIME_POINT_ID

[top of page]

GMD.GMD_SS_TIME_POINTS does not reference any database object

GMD.GMD_SS_TIME_POINTS is referenced by following:

GMD
VIEW - GMD_SS_TIME_POINTS#

[top of page]

Table: GMD_SS_VARIANTS

Description: Stability Study Variants
Primary Key: GMD_SS_VARIANTS_PK
  1. VARIANT_ID

[top of page]

GMD.GMD_SS_VARIANTS does not reference any database object

GMD.GMD_SS_VARIANTS is referenced by following:

GMD
VIEW - GMD_SS_VARIANTS#

[top of page]

Table: GMD_STABILITY_SPEC_VRS

Description: Stability Study Validity Rules
Primary Key: GMD_STABILITY_SPEC_VRS_PK
  1. SPEC_VR_ID

[top of page]

GMD.GMD_STABILITY_SPEC_VRS does not reference any database object

GMD.GMD_STABILITY_SPEC_VRS is referenced by following:

GMD
VIEW - GMD_STABILITY_SPEC_VRS#

[top of page]

Table: GMD_STABILITY_STUDIES_B

Description: Stability Study
Primary Key: GMD_STABILITY_STUDIES_B_PK
  1. SS_ID
Primary Key: GMD_STABILITY_STUDIES_B_U1
  1. ORGN_CODE
  2. SS_NO

[top of page]

GMD.GMD_STABILITY_STUDIES_B does not reference any database object

GMD.GMD_STABILITY_STUDIES_B is referenced by following:

GMD
VIEW - GMD_STABILITY_STUDIES_B#

[top of page]

Table: GMD_STABILITY_STUDIES_TL

Description: Stability Study Translation table
Primary Key: GMD_STABILITY_STUDIES_TL_PK
  1. SS_ID
  2. LANGUAGE

[top of page]

GMD.GMD_STABILITY_STUDIES_TL does not reference any database object

GMD.GMD_STABILITY_STUDIES_TL is referenced by following:

GMD
VIEW - GMD_STABILITY_STUDIES_TL#

[top of page]

Table: GMD_STATUS_B

Description: Base table for status code definitions.
Primary Key: GMD_STATUS_B_PK
  1. STATUS_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
GMD_STATUS_NEXT.CURRENT_STATUS GMD_STATUS_B
GMD_STATUS_NEXT.TARGET_STATUS GMD_STATUS_B
GMD_STATUS_NEXT.PENDING_STATUS GMD_STATUS_B
GMD_STATUS_NEXT.REWORK_STATUS GMD_STATUS_B

[top of page]

GMD.GMD_STATUS_B does not reference any database object

GMD.GMD_STATUS_B is referenced by following:

GMD
VIEW - GMD_STATUS_B#

[top of page]

Table: GMD_STATUS_NEXT

Description: This table stores information in regards to which status codes the current status can be changed to.
Primary Key: GMD_STATUS_NEXT_PK
  1. TARGET_STATUS
  2. CURRENT_STATUS
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMD_STATUS_NEXT.CURRENT_STATUS GMD_STATUS_B
GMD_STATUS_NEXT.TARGET_STATUS GMD_STATUS_B
GMD_STATUS_NEXT.PENDING_STATUS GMD_STATUS_B
GMD_STATUS_NEXT.REWORK_STATUS GMD_STATUS_B

[top of page]

GMD.GMD_STATUS_NEXT does not reference any database object

GMD.GMD_STATUS_NEXT is referenced by following:

GMD
VIEW - GMD_STATUS_NEXT#

[top of page]

Table: GMD_STATUS_TL

Description: Status Code Translation Table
Primary Key: GMD_STATUS_TL_PK
  1. STATUS_CODE
  2. LANGUAGE

[top of page]

GMD.GMD_STATUS_TL does not reference any database object

GMD.GMD_STATUS_TL is referenced by following:

GMD
VIEW - GMD_STATUS_TL#

[top of page]

Table: GMD_STORAGE_PLANS_B

Description: Stability Study Storage Plan
Primary Key: GMD_STORAGE_PLANS_B_PK
  1. STORAGE_PLAN_ID
Primary Key: GMD_STORAGE_PLANS_B_U1
  1. STORAGE_PLAN_NAME

[top of page]

GMD.GMD_STORAGE_PLANS_B does not reference any database object

GMD.GMD_STORAGE_PLANS_B is referenced by following:

GMD
VIEW - GMD_STORAGE_PLANS_B#

[top of page]

Table: GMD_STORAGE_PLANS_TL

Description: Stability Study Storage Plan Translation table
Primary Key: GMD_STORAGE_PLANS_TL_PK
  1. STORAGE_PLAN_ID
  2. LANGUAGE

[top of page]

GMD.GMD_STORAGE_PLANS_TL does not reference any database object

GMD.GMD_STORAGE_PLANS_TL is referenced by following:

GMD
VIEW - GMD_STORAGE_PLANS_TL#

[top of page]

Table: GMD_STORAGE_PLAN_DETAILS

Description: Stability Study Storage Plan Details
Primary Key: GMD_STORAGE_PLAN_DETAILS_PK
  1. STORAGE_PLAN_DETAIL_ID

[top of page]

GMD.GMD_STORAGE_PLAN_DETAILS does not reference any database object

GMD.GMD_STORAGE_PLAN_DETAILS is referenced by following:

GMD
VIEW - GMD_STORAGE_PLAN_DETAILS#

[top of page]

Table: GMD_SUPPLIER_SPEC_VRS

Description: OPM Work-in-Process Specification validity rules
Primary Key: GMD_SUPPLIER_SPEC_VRS_PK
  1. SPEC_VR_ID

[top of page]

GMD.GMD_SUPPLIER_SPEC_VRS does not reference any database object

GMD.GMD_SUPPLIER_SPEC_VRS is referenced by following:

GMD
VIEW - GMD_SUPPLIER_SPEC_VRS#

[top of page]

Table: GMD_TECHNICAL_DATA_DTL

Description: Technical Parameter data detail
Primary Key: GMD_TECHNICAL_DATA_DTL_PK
  1. TECH_DATA_ID
  2. TECH_PARM_ID

[top of page]

GMD.GMD_TECHNICAL_DATA_DTL does not reference any database object

GMD.GMD_TECHNICAL_DATA_DTL is referenced by following:

GMD
VIEW - GMD_TECHNICAL_DATA_DTL#

[top of page]

Table: GMD_TECHNICAL_DATA_HDR

Description: Technical Parameter data header
Primary Key: GMD_TECHNICAL_DATA_HDR_PK
  1. TECH_DATA_ID

[top of page]

GMD.GMD_TECHNICAL_DATA_HDR does not reference any database object

GMD.GMD_TECHNICAL_DATA_HDR is referenced by following:

GMD
VIEW - GMD_TECHNICAL_DATA_HDR#

[top of page]

Table: GMD_TECHNICAL_REQS

Description: LCF - Technical Requirements Table

[top of page]

GMD.GMD_TECHNICAL_REQS does not reference any database object

GMD.GMD_TECHNICAL_REQS is referenced by following:

GMD
VIEW - GMD_TECHNICAL_REQS#

[top of page]

Table: GMD_TECHNICAL_SEQUENCE_DTL

Description: Technical Parameter Sort Sequence Detail Table
Primary Key: GMD_TECHNICAL_SEQUENCE_DTL_PK
  1. TECH_SEQ_ID
  2. TECH_PARM_ID

[top of page]

GMD.GMD_TECHNICAL_SEQUENCE_DTL does not reference any database object

GMD.GMD_TECHNICAL_SEQUENCE_DTL is referenced by following:

GMD
VIEW - GMD_TECHNICAL_SEQUENCE_DTL#

[top of page]

Table: GMD_TECHNICAL_SEQUENCE_HDR

Description: Technical Parameter Sort Sequence Table
Primary Key: GMD_TECHNICAL_SEQUENCE_HDR_PK
  1. TECH_SEQ_ID
Primary Key: GMD_TECHNICAL_SEQUENCE_HDR_UK
  1. ORGANIZATION_ID
  2. INVENTORY_ITEM_ID
  3. CATEGORY_ID

[top of page]

GMD.GMD_TECHNICAL_SEQUENCE_HDR does not reference any database object

GMD.GMD_TECHNICAL_SEQUENCE_HDR is referenced by following:

GMD
VIEW - GMD_TECHNICAL_SEQUENCE_HDR#

[top of page]

Table: GMD_TECH_PARAMETERS_B

Description: Technical parameters header base table
Primary Key: GMD_TECH_PARAMETERS_B_PK
  1. TECH_PARM_ID
Primary Key: GMD_TECH_PARAMETERS_B_UK
  1. ORGN_CODE
  2. TECH_PARM_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMD_TECH_PARAMETERS_B.QCASSY_TYP_ID %
GMD_TECH_PARAMETERS_B.TEXT_CODE LM_TEXT_HDR
GMD_TECH_PARAMETERS_B.QCASSY_TYP_ID QC_ASSY_TYP

[top of page]

GMD.GMD_TECH_PARAMETERS_B does not reference any database object

GMD.GMD_TECH_PARAMETERS_B is referenced by following:

GMD
VIEW - GMD_TECH_PARAMETERS_B#

[top of page]

Table: GMD_TECH_PARAMETERS_TL

Description: Technical parameters header translation table
Primary Key: GMD_TECH_PARAMETERS_TL_PK
  1. TECH_PARM_ID
  2. LANGUAGE

[top of page]

GMD.GMD_TECH_PARAMETERS_TL does not reference any database object

GMD.GMD_TECH_PARAMETERS_TL is referenced by following:

GMD
VIEW - GMD_TECH_PARAMETERS_TL#

[top of page]

Table: GMD_TESTS_B

Description:
Primary Key: GMD_TESTS_B_PK
  1. QCASSY_TYP_ID
Primary Key: GMD_TESTS_B_U1
  1. ORGN_CODE
  2. ASSAY_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMD_TESTS_B.QCUNIT_CODE %
GMD_TESTS_B.TEXT_CODE QC_TEXT_HDR
GMD_TESTS_B.ORGN_CODE SY_ORGN_MST_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
GMD_TEST_VALUES_B.QCASSY_TYP_ID GMD_TESTS_B

[top of page]

GMD.GMD_TESTS_B does not reference any database object

GMD.GMD_TESTS_B is referenced by following:

GMD
VIEW - GMD_TESTS_B#

[top of page]

Table: GMD_TESTS_TL

Description:
Primary Key: GMD_TESTS_TL_PK
  1. QCASSY_TYP_ID
  2. LANGUAGE

[top of page]

GMD.GMD_TESTS_TL does not reference any database object

GMD.GMD_TESTS_TL is referenced by following:

GMD
VIEW - GMD_TESTS_TL#

[top of page]

Table: GMD_TEST_CLASSES_B

Description: OPM Quality Test Classes
Primary Key: GMD_TEST_CLASSES_B_PK
  1. TEST_CLASS

[top of page]

GMD.GMD_TEST_CLASSES_B does not reference any database object

GMD.GMD_TEST_CLASSES_B is referenced by following:

GMD
VIEW - GMD_TEST_CLASSES_B#

[top of page]

Table: GMD_TEST_CLASSES_TL

Description: OPM Quality test classes translation
Primary Key: GMD_TEST_CLASSES_TL_PK
  1. TEST_CLASS
  2. LANGUAGE

[top of page]

GMD.GMD_TEST_CLASSES_TL does not reference any database object

GMD.GMD_TEST_CLASSES_TL is referenced by following:

GMD
VIEW - GMD_TEST_CLASSES_TL#

[top of page]

Table: GMD_TEST_GROUP_GT

Description:

[top of page]

GMD.GMD_TEST_GROUP_GT does not reference any database object

GMD.GMD_TEST_GROUP_GT is referenced by following:

APPS
SYNONYM - GMD_TEST_GROUP_GT

[top of page]

Table: GMD_TEST_INTERVAL_PLANS_B

Description: Base table for test interval plans
Primary Key: GMD_TEST_INTERVAL_PLANS_B_PK
  1. TEST_INTERVAL_PLAN_ID
Primary Key: GMD_TEST_INTERVAL_PLANS_B_U1
  1. NAME

[top of page]

GMD.GMD_TEST_INTERVAL_PLANS_B does not reference any database object

GMD.GMD_TEST_INTERVAL_PLANS_B is referenced by following:

GMD
VIEW - GMD_TEST_INTERVAL_PLANS_B#

[top of page]

Table: GMD_TEST_INTERVAL_PLANS_TL

Description: Translation table for test interval plans
Primary Key: GMD_TEST_INTRVL_PLANS_TL_PK
  1. TEST_INTERVAL_PLAN_ID
  2. LANGUAGE

[top of page]

GMD.GMD_TEST_INTERVAL_PLANS_TL does not reference any database object

GMD.GMD_TEST_INTERVAL_PLANS_TL is referenced by following:

GMD
VIEW - GMD_TEST_INTERVAL_PLANS_TL#

[top of page]

Table: GMD_TEST_INTERVAL_PLAN_PERIODS

Description: Table for test interval plan periods
Primary Key: GMD_TEST_INT_PLAN_PERIODS_PK
  1. PERIOD_ID
Primary Key: GMD_TEST_INT_PLAN_PERIODS_U1
  1. TEST_INTERVAL_PLAN_ID
  2. NAME

[top of page]

GMD.GMD_TEST_INTERVAL_PLAN_PERIODS does not reference any database object

GMD.GMD_TEST_INTERVAL_PLAN_PERIODS is referenced by following:

GMD
VIEW - GMD_TEST_INTERVAL_PLAN_PERIOD#

[top of page]

Table: GMD_TEST_METHODS_B

Description: OPM Quality Test Methods
Primary Key: GMD_TEST_METHODS_B_PK
  1. TEST_METHOD_ID
Primary Key: GMD_TEST_METHODS_B_U1
  1. TEST_METHOD_CODE

[top of page]

GMD.GMD_TEST_METHODS_B does not reference any database object

GMD.GMD_TEST_METHODS_B is referenced by following:

GMD
VIEW - GMD_TEST_METHODS_B#

[top of page]

Table: GMD_TEST_METHODS_TL

Description: OPM Quality test methods
Primary Key: GMD_TEST_METHODS_TL_PK
  1. TEST_METHOD_ID
  2. LANGUAGE

[top of page]

GMD.GMD_TEST_METHODS_TL does not reference any database object

GMD.GMD_TEST_METHODS_TL is referenced by following:

GMD
VIEW - GMD_TEST_METHODS_TL#

[top of page]

Table: GMD_TEST_VALUES_B

Description:
Primary Key: GMD_TEST_VALUES_B_PK
  1. QCASSY_VAL_ID
Primary Key: GMD_TEST_VALUES_B_U1
  1. ORGN_CODE
  2. ASSAY_CODE
  3. ASSAY_VALUE
  4. VALUE_NUM_MIN
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMD_TEST_VALUES_B.QCASSY_TYP_ID GMD_TESTS_B
GMD_TEST_VALUES_B.TEXT_CODE QC_TEXT_HDR

[top of page]

GMD.GMD_TEST_VALUES_B does not reference any database object

GMD.GMD_TEST_VALUES_B is referenced by following:

GMD
VIEW - GMD_TEST_VALUES_B#

[top of page]

Table: GMD_TEST_VALUES_TL

Description:
Primary Key: GMD_TEST_VALUES_TL_PK
  1. QCASSY_VAL_ID
  2. LANGUAGE

[top of page]

GMD.GMD_TEST_VALUES_TL does not reference any database object

GMD.GMD_TEST_VALUES_TL is referenced by following:

GMD
VIEW - GMD_TEST_VALUES_TL#

[top of page]

Table: GMD_UNITS_B

Description: Units of measure for QC assays.
Primary Key: GMD_UNITS_B_PK
  1. QCUNIT_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMD_UNITS_B.TEXT_CODE QC_TEXT_HDR
Foreign Keys to this table:
Foreign Key Column Foreign Table
QC_RSLT_MST.QCUNIT_CODE GMD_UNITS_B
QC_SPEC_MST.QCUNIT_CODE GMD_UNITS_B

[top of page]

GMD.GMD_UNITS_B does not reference any database object

GMD.GMD_UNITS_B is referenced by following:

GMD
VIEW - GMD_UNITS_B#

[top of page]

Table: GMD_UNITS_TL

Description: QC Units Translation Table
Primary Key: GMD_UNITS_TL_PK
  1. QCUNIT_CODE
  2. LANGUAGE

[top of page]

GMD.GMD_UNITS_TL does not reference any database object

GMD.GMD_UNITS_TL is referenced by following:

GMD
VIEW - GMD_UNITS_TL#

[top of page]

Table: GMD_UOM_CONVERSIONS

Description: UOM Conversions Based on Quality Results.
Primary Key: GMD_UOM_CONVERSIONS_PK
  1. EVENT_SPEC_DISP_ID
  2. TEST_ID

[top of page]

GMD.GMD_UOM_CONVERSIONS does not reference any database object

GMD.GMD_UOM_CONVERSIONS is referenced by following:

GMD
VIEW - GMD_UOM_CONVERSIONS#

[top of page]

Table: GMD_VAL_RULE_GTMP

Description:

[top of page]

GMD.GMD_VAL_RULE_GTMP does not reference any database object

GMD.GMD_VAL_RULE_GTMP is referenced by following:

APPS
SYNONYM - GMD_VAL_RULE_GTMP

[top of page]

Table: GMD_VPD_SECURITY

Description: Reflects whether NPD Security is Active or Inactive
Primary Key: GMD_VPD_SECURITY_PK
  1. ACTIVE_FORMULA_IND

[top of page]

GMD.GMD_VPD_SECURITY does not reference any database object

GMD.GMD_VPD_SECURITY is referenced by following:

GMD
VIEW - GMD_VPD_SECURITY#

[top of page]

Table: GMD_WIP_SPEC_VRS

Description: OPM Work-in-Process Specification validity rules
Primary Key: GMD_WIP_SPEC_VRS_PK
  1. SPEC_VR_ID

[top of page]

GMD.GMD_WIP_SPEC_VRS does not reference any database object

GMD.GMD_WIP_SPEC_VRS is referenced by following:

GMD
VIEW - GMD_WIP_SPEC_VRS#

[top of page]

Table: LM_FORM_DAT

Description: OBSOLETE as of 11.5.6 (OPM PF.G)
Primary Key: LM_FORM_DAT_PK
  1. LAB_TYPE
  2. FORMULALINE_ID
  3. TECH_PARM_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
LM_FORM_DAT.FORMULALINE_ID LM_FORM_DTL
LM_FORM_DAT.LAB_TYPE
LM_FORM_DAT.TECH_PARM_NAME
LM_TECH_HDR
LM_FORM_DAT.TEXT_CODE LM_TEXT_HDR

[top of page]

GMD.LM_FORM_DAT does not reference any database object

GMD.LM_FORM_DAT is referenced by following:

GMD
VIEW - LM_FORM_DAT#

[top of page]

Table: LM_FORM_DTL

Description: OBSOLETE as of 11.5.6 (OPM PF.G)
Primary Key: LM_FORM_DTL_PK
  1. FORMULALINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LM_FORM_DTL.ITEM_ID IC_ITEM_MST
LM_FORM_DTL.FORMULA_ID LM_FORM_MST
LM_FORM_DTL.TPFORMULA_ID LM_FORM_MST
LM_FORM_DTL.TEXT_CODE LM_TEXT_HDR
LM_FORM_DTL.ITEM_UM SY_UOMS_MST
Foreign Keys to this table:
Foreign Key Column Foreign Table
LM_FORM_DAT.FORMULALINE_ID LM_FORM_DTL

[top of page]

GMD.LM_FORM_DTL does not reference any database object

GMD.LM_FORM_DTL is referenced by following:

GMD
VIEW - LM_FORM_DTL#

[top of page]

Table: LM_FORM_MST

Description: OBSOLETE as of 11.5.6 (OPM PF.G)
Primary Key: LM_FORM_MST_PK
  1. FORMULA_ID
Primary Key: LM_FORM_MST_U1
  1. FORMULA_NO
  2. FORMULA_VERS
Foreign Keys from this table:
Foreign Key Column Foreign Table
LM_FORM_MST.FMCONTROL_CLASS FM_FMCT_CLS
LM_FORM_MST.FORMULA_CLASS FM_FORM_CLS
LM_FORM_MST.TEXT_CODE LM_TEXT_HDR
Foreign Keys to this table:
Foreign Key Column Foreign Table
LM_FORM_DTL.FORMULA_ID LM_FORM_MST
LM_FORM_DTL.TPFORMULA_ID LM_FORM_MST
LM_ITEM_DAT.FORMULA_ID LM_FORM_MST
LM_SPRD_FLS.FORMULA_ID LM_FORM_MST

[top of page]

GMD.LM_FORM_MST does not reference any database object

GMD.LM_FORM_MST is referenced by following:

GMD
VIEW - LM_FORM_MST#

[top of page]

Table: LM_LTYP_MST

Description: Laboratory type master
Primary Key: LM_LTYP_MST_PK
  1. LAB_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
LM_LTYP_MST.SHARED_LAB_TYPE LM_LTYP_MST
LM_LTYP_MST.TEXT_CODE LM_TEXT_HDR
Foreign Keys to this table:
Foreign Key Column Foreign Table
LM_LTYP_MST.SHARED_LAB_TYPE LM_LTYP_MST
LM_SPRD_DTL.LAB_TYPE LM_LTYP_MST
LM_SPRD_FLS.LAB_TYPE LM_LTYP_MST
LM_TECH_HDR.LAB_TYPE LM_LTYP_MST

[top of page]

GMD.LM_LTYP_MST does not reference any database object

GMD.LM_LTYP_MST is referenced by following:

GMD
VIEW - LM_LTYP_MST#

[top of page]

Table: LM_SPRD_DTL

Description: Table to store Lab Spreadsheet detail
Primary Key: LM_SPRD_DTL_PK
  1. LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LM_SPRD_DTL.ITEM_ID IC_ITEM_MST_B
LM_SPRD_DTL.ITEM_ID IC_ITEM_MST
LM_SPRD_DTL.LAB_TYPE LM_LTYP_MST
LM_SPRD_DTL.SPRD_ID LM_SPRD_FLS
LM_SPRD_DTL.TEXT_CODE LM_TEXT_HDR
LM_SPRD_DTL.ITEM_UM SY_UOMS_MST

[top of page]

GMD.LM_SPRD_DTL does not reference any database object

GMD.LM_SPRD_DTL is referenced by following:

GMD
VIEW - LM_SPRD_DTL#

[top of page]

Table: LM_SPRD_FLS

Description: Laboratory Spreadsheets files
Primary Key: LM_SPRD_FLS_PK
  1. SPRD_ID
Primary Key: LM_SPRD_FLS_U1
  1. SPRD_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
LM_SPRD_FLS.TEXT_CODE FM_TEXT_HDR
LM_SPRD_FLS.FORMULA_ID LM_FORM_MST
LM_SPRD_FLS.LAB_TYPE LM_LTYP_MST
LM_SPRD_FLS.TEXT_CODE LM_TEXT_HDR
Foreign Keys to this table:
Foreign Key Column Foreign Table
LM_SPRD_DTL.SPRD_ID LM_SPRD_FLS
LM_SPRD_PRM.SPRD_ID LM_SPRD_FLS
LM_SPRD_TEC.SPRD_ID LM_SPRD_FLS

[top of page]

GMD.LM_SPRD_FLS does not reference any database object

GMD.LM_SPRD_FLS is referenced by following:

GMD
VIEW - LM_SPRD_FLS#

[top of page]

Table: LM_SPRD_PRM

Description: Table used to store the technical paramter definitions that belong with the spreadsheet
Primary Key: LM_SPRD_PRM_PK
  1. SPRD_ID
  2. LAB_TYPE
  3. TECH_PARM_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
LM_SPRD_PRM.QC_ORGN_CODE
LM_SPRD_PRM.QC_ASSAY_NAME
%
LM_SPRD_PRM.SPRD_ID LM_SPRD_FLS
LM_SPRD_PRM.LAB_TYPE
LM_SPRD_PRM.TECH_PARM_NAME
LM_TECH_HDR
LM_SPRD_PRM.QC_ORGN_CODE
LM_SPRD_PRM.QC_ASSAY_NAME
QC_ASSY_TYP

[top of page]

GMD.LM_SPRD_PRM does not reference any database object

GMD.LM_SPRD_PRM is referenced by following:

GMD
VIEW - LM_SPRD_PRM#

[top of page]

Table: LM_SPRD_TEC

Description: Table used to store the values of the technical parameters on the spreadsheet
Primary Key: LM_SPRD_TEC_PK
  1. LINE_ID
  2. LAB_TYPE
  3. TECH_PARM_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
LM_SPRD_TEC.SPRD_ID LM_SPRD_FLS
LM_SPRD_TEC.LAB_TYPE
LM_SPRD_TEC.TECH_PARM_NAME
LM_TECH_HDR

[top of page]

GMD.LM_SPRD_TEC does not reference any database object

GMD.LM_SPRD_TEC is referenced by following:

GMD
VIEW - LM_SPRD_TEC#

[top of page]

Table: LM_TECH_DTL

Description: Valid values for technical parameters
Primary Key: LM_TECH_DTL_PK
  1. TECH_PARM_ID
  2. VALID_ANS
Foreign Keys from this table:
Foreign Key Column Foreign Table
LM_TECH_DTL.LAB_TYPE
LM_TECH_DTL.TECH_PARM_NAME
LM_TECH_HDR
LM_TECH_DTL.TEXT_CODE LM_TEXT_HDR

[top of page]

GMD.LM_TECH_DTL does not reference any database object

GMD.LM_TECH_DTL is referenced by following:

GMD
VIEW - LM_TECH_DTL#

[top of page]

Table: LM_TEXT_HDR

Description: Holds text types defined for Lab module
Primary Key: LM_TEXT_HDR_PK
  1. TEXT_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
GMD_TECH_PARAMETERS_B.TEXT_CODE LM_TEXT_HDR
LM_FORM_DAT.TEXT_CODE LM_TEXT_HDR
LM_FORM_DTL.TEXT_CODE LM_TEXT_HDR
LM_FORM_MST.TEXT_CODE LM_TEXT_HDR
LM_ITEM_DAT.TEXT_CODE LM_TEXT_HDR
LM_LTYP_MST.TEXT_CODE LM_TEXT_HDR
LM_PRLT_ASC.TEXT_CODE LM_TEXT_HDR
LM_SPRD_DTL.TEXT_CODE LM_TEXT_HDR
LM_SPRD_FLS.TEXT_CODE LM_TEXT_HDR
LM_TECH_DTL.TEXT_CODE LM_TEXT_HDR
LM_TECH_HDR.TEXT_CODE LM_TEXT_HDR

[top of page]

GMD.LM_TEXT_HDR does not reference any database object

GMD.LM_TEXT_HDR is referenced by following:

GMD
VIEW - LM_TEXT_HDR#

[top of page]

Table: LM_TEXT_TBL_TL

Description: LM Module Text Lines. Descriptive text for all tables in this module.
Primary Key: LM_TEXT_TBL_TL_PK
  1. TEXT_CODE
  2. LANG_CODE
  3. PARAGRAPH_CODE
  4. SUB_PARACODE
  5. LINE_NO
  6. LANGUAGE

[top of page]

GMD.LM_TEXT_TBL_TL does not reference any database object

GMD.LM_TEXT_TBL_TL is referenced by following:

GMD
VIEW - LM_TEXT_TBL_TL#

[top of page]

Table: QC_ACTN_MST

Description: QC action codes.
Primary Key: QC_ACTN_MST_PK
  1. ACTION_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
QC_ACTN_MST.TEXT_CODE QC_TEXT_HDR
Foreign Keys to this table:
Foreign Key Column Foreign Table
IC_ITEM_MST_B.EXPACTION_CODE QC_ACTN_MST
IC_ITEM_MST.EXPACTION_CODE QC_ACTN_MST
IC_LOTS_MST.EXPACTION_CODE QC_ACTN_MST
QC_SPEC_MST.OUTACTION_CODE QC_ACTN_MST

[top of page]

GMD.QC_ACTN_MST does not reference any database object

GMD.QC_ACTN_MST is referenced by following:

GMD
VIEW - QC_ACTN_MST#

[top of page]

Table: QC_HRES_MST

Description: QC hold reason code master.
Primary Key: QC_HRES_MST_PK
  1. QCHOLD_RES_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
QC_HRES_MST.TEXT_CODE QC_TEXT_HDR
Foreign Keys to this table:
Foreign Key Column Foreign Table
IC_ITEM_MST_B.QCHOLD_RES_CODE QC_HRES_MST
IC_ITEM_MST.QCHOLD_RES_CODE QC_HRES_MST
IC_LOCT_INV.QCHOLD_RES_CODE QC_HRES_MST
IC_LOTS_STS.QCHOLD_RES_CODE QC_HRES_MST
IC_PERD_BAL.QCHOLD_RES_CODE QC_HRES_MST

[top of page]

GMD.QC_HRES_MST does not reference any database object

GMD.QC_HRES_MST is referenced by following:

GMD
VIEW - QC_HRES_MST#

[top of page]

Table: QC_RSLT_MST

Description: QC results master.
Primary Key: QC_RSLT_MST_PK
  1. QC_RESULT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
QC_RSLT_MST.FORMULALINE_ID FM_MATL_DTL
QC_RSLT_MST.OPRN_ID FM_OPRN_MST
QC_RSLT_MST.ROUTING_ID
QC_RSLT_MST.ROUTINGSTEP_NO
FM_ROUT_DTL
QC_RSLT_MST.QCASSY_TYP_ID %
QC_RSLT_MST.QCUNIT_CODE GMD_UNITS_B
QC_RSLT_MST.ITEM_ID IC_ITEM_MST_B
QC_RSLT_MST.ITEM_ID IC_ITEM_MST
QC_RSLT_MST.WHSE_CODE
QC_RSLT_MST.LOCATION
IC_LOCT_MST
QC_RSLT_MST.ITEM_ID
QC_RSLT_MST.LOT_ID
IC_LOTS_MST
QC_RSLT_MST.WHSE_CODE IC_WHSE_MST
QC_RSLT_MST.CUST_ID OP_CUST_MST
QC_RSLT_MST.BATCH_ID PM_BTCH_HDR
QC_RSLT_MST.VENDOR_ID PO_VEND_MST
QC_RSLT_MST.QCASSY_TYP_ID QC_ASSY_TYP
QC_RSLT_MST.SAMPLE_ID QC_SMPL_MST
QC_RSLT_MST.QC_SPEC_ID QC_SPEC_MST
QC_RSLT_MST.TEXT_CODE QC_TEXT_HDR
QC_RSLT_MST.QCUNIT_CODE QC_UNIT_MST
QC_RSLT_MST.ORGN_CODE SY_ORGN_MST_B
QC_RSLT_MST.ORGN_CODE SY_ORGN_MST

[top of page]

GMD.QC_RSLT_MST does not reference any database object

GMD.QC_RSLT_MST is referenced by following:

GMD
VIEW - QC_RSLT_MST#

[top of page]

Table: QC_SMPL_MST

Description: QC sample master.
Primary Key: QC_SMPL_MST_PK
  1. SAMPLE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
QC_SMPL_MST.FORMULALINE_ID FM_MATL_DTL
QC_SMPL_MST.OPRN_ID FM_OPRN_MST
QC_SMPL_MST.ROUTING_ID
QC_SMPL_MST.ROUTINGSTEP_NO
FM_ROUT_DTL
QC_SMPL_MST.ITEM_ID IC_ITEM_MST_B
QC_SMPL_MST.ITEM_ID IC_ITEM_MST
QC_SMPL_MST.ITEM_ID
QC_SMPL_MST.LOT_ID
IC_LOTS_MST
QC_SMPL_MST.WHSE_CODE IC_WHSE_MST
QC_SMPL_MST.CUST_ID OP_CUST_MST
QC_SMPL_MST.BATCH_ID PM_BTCH_HDR
QC_SMPL_MST.VENDOR_ID PO_VEND_MST
QC_SMPL_MST.TEXT_CODE QC_TEXT_HDR
QC_SMPL_MST.ORGN_CODE SY_ORGN_MST_B
QC_SMPL_MST.ORGN_CODE SY_ORGN_MST
Foreign Keys to this table:
Foreign Key Column Foreign Table
QC_RSLT_MST.SAMPLE_ID QC_SMPL_MST

[top of page]

GMD.QC_SMPL_MST does not reference any database object

GMD.QC_SMPL_MST is referenced by following:

GMD
VIEW - QC_SMPL_MST#

[top of page]

Table: QC_SPEC_MST

Description: QC specification master.
Primary Key: QC_SPEC_MST_PK
  1. QC_SPEC_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
QC_SPEC_MST.FORMULALINE_ID FM_MATL_DTL
QC_SPEC_MST.OPRN_ID FM_OPRN_MST
QC_SPEC_MST.ROUTING_ID
QC_SPEC_MST.ROUTINGSTEP_NO
FM_ROUT_DTL
QC_SPEC_MST.QCASSY_TYP_ID %
QC_SPEC_MST.QCUNIT_CODE GMD_UNITS_B
QC_SPEC_MST.ITEM_ID IC_ITEM_MST_B
QC_SPEC_MST.ITEM_ID IC_ITEM_MST
QC_SPEC_MST.WHSE_CODE
QC_SPEC_MST.LOCATION
IC_LOCT_MST
QC_SPEC_MST.ITEM_ID
QC_SPEC_MST.LOT_ID
IC_LOTS_MST
QC_SPEC_MST.WHSE_CODE IC_WHSE_MST
QC_SPEC_MST.CUST_ID OP_CUST_MST
QC_SPEC_MST.BATCH_ID PM_BTCH_HDR
QC_SPEC_MST.VENDOR_ID PO_VEND_MST
QC_SPEC_MST.OUTACTION_CODE QC_ACTN_MST
QC_SPEC_MST.QCASSY_TYP_ID QC_ASSY_TYP
QC_SPEC_MST.TEXT_CODE QC_TEXT_HDR
QC_SPEC_MST.QCUNIT_CODE QC_UNIT_MST
QC_SPEC_MST.ORGN_CODE SY_ORGN_MST_B
QC_SPEC_MST.ORGN_CODE SY_ORGN_MST
Foreign Keys to this table:
Foreign Key Column Foreign Table
QC_RSLT_MST.QC_SPEC_ID QC_SPEC_MST

[top of page]

GMD.QC_SPEC_MST does not reference any database object

GMD.QC_SPEC_MST is referenced by following:

GMD
VIEW - QC_SPEC_MST#

[top of page]

Table: QC_TEXT_HDR

Description: Holds text types defined for QC module
Primary Key: QC_TEXT_HDR_PK
  1. TEXT_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
GMD_GRADES_B.TEXT_CODE QC_TEXT_HDR
GMD_TESTS_B.TEXT_CODE QC_TEXT_HDR
GMD_TEST_VALUES_B.TEXT_CODE QC_TEXT_HDR
GMD_UNITS_B.TEXT_CODE QC_TEXT_HDR
QC_ACTN_MST.TEXT_CODE QC_TEXT_HDR
QC_ASSY_TYP.TEXT_CODE QC_TEXT_HDR
QC_ASSY_VAL.TEXT_CODE QC_TEXT_HDR
QC_GRAD_MST.TEXT_CODE QC_TEXT_HDR
QC_HRES_MST.TEXT_CODE QC_TEXT_HDR
QC_RSLT_MST.TEXT_CODE QC_TEXT_HDR
QC_SMPL_MST.TEXT_CODE QC_TEXT_HDR
QC_SPEC_MST.TEXT_CODE QC_TEXT_HDR
QC_UNIT_MST.TEXT_CODE QC_TEXT_HDR

[top of page]

GMD.QC_TEXT_HDR does not reference any database object

GMD.QC_TEXT_HDR is referenced by following:

GMD
VIEW - QC_TEXT_HDR#

[top of page]

Table: QC_TEXT_TBL_TL

Description: QC Module Text Lines. Descriptive text for all tables in this module.
Primary Key: QC_TEXT_TBL_TL_PK
  1. TEXT_CODE
  2. LANG_CODE
  3. PARAGRAPH_CODE
  4. SUB_PARACODE
  5. LINE_NO
  6. LANGUAGE

[top of page]

GMD.QC_TEXT_TBL_TL does not reference any database object

GMD.QC_TEXT_TBL_TL is referenced by following:

GMD
VIEW - QC_TEXT_TBL_TL#

[top of page]

View: FM_FORM_EFF_VW1

[top of page]

APPS.FM_FORM_EFF_VW1 references the following:

- FM_FORM_EFF

APPS.FM_FORM_EFF_VW1 is not referenced by any database object

[top of page]

View: FM_FORM_EFF_VW3

[top of page]

APPS.FM_FORM_EFF_VW3 references the following:

APPS
SYNONYM - GMD_RECIPES_B
SYNONYM - GMD_RECIPE_VALIDITY_RULES
SYNONYM - GMD_STATUS_B
APPS.FM_FORM_EFF_VW3 is referenced by following:

APPS
SYNONYM - FM_FORM_EFF

[top of page]

View: FM_FORM_EFF_VW3_OLD

[top of page]

APPS.FM_FORM_EFF_VW3_OLD references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - GMD_RECIPES_B
SYNONYM - GMD_RECIPE_CUSTOMERS
SYNONYM - GMD_RECIPE_VALIDITY_RULES
SYNONYM - GMD_STATUS_B

APPS.FM_FORM_EFF_VW3_OLD is not referenced by any database object

[top of page]

View: FM_FORM_MST_V1

[top of page]

APPS.FM_FORM_MST_V1 references the following:

- FM_FORM_MST

APPS.FM_FORM_MST_V1 is not referenced by any database object

[top of page]

View: FM_FORM_MST_V2

[top of page]

APPS.FM_FORM_MST_V2 references the following:

- FM_FORM_MST

APPS.FM_FORM_MST_V2 is not referenced by any database object

[top of page]

View: FM_FORM_MST_VL

[top of page]

APPS.FM_FORM_MST_VL references the following:

APPS
SYNONYM - FM_FORM_MST_B
SYNONYM - FM_FORM_MST_TL
APPS.FM_FORM_MST_VL is referenced by following:

APPS
SYNONYM - FM_FORM_MST
VIEW - GMD_MBR_RECIPE_HEADER_V1
VIEW - MTH_SRC_PRODUCTION_SCHEDULES_V
VIEW - MTH_SRC_PROD_MTL_PRODUCED_V
VIEW - PMIFV_BATCH_DETAILS_V

[top of page]

View: FM_OPRN_DTL_VW1

[top of page]

APPS.FM_OPRN_DTL_VW1 references the following:

APPS
SYNONYM - GMD_OPERATION_ACTIVITIES
SYNONYM - GMD_OPERATION_RESOURCES

APPS.FM_OPRN_DTL_VW1 is not referenced by any database object

[top of page]

View: FM_OPRN_MST_VW1

[top of page]

APPS.FM_OPRN_MST_VW1 references the following:

- GMD_OPERATIONS

APPS.FM_OPRN_MST_VW1 is not referenced by any database object

[top of page]

View: FM_ROUT_DTL_V1

[top of page]

APPS.FM_ROUT_DTL_V1 references the following:

APPS
SYNONYM - FM_ROUT_DTL

APPS.FM_ROUT_DTL_V1 is not referenced by any database object

[top of page]

View: FM_ROUT_HDR_V1

[top of page]

APPS.FM_ROUT_HDR_V1 references the following:

- FM_ROUT_HDR

APPS.FM_ROUT_HDR_V1 is not referenced by any database object

[top of page]

View: FM_ROUT_HDR_V2

[top of page]

APPS.FM_ROUT_HDR_V2 references the following:

- FM_ROUT_HDR

APPS.FM_ROUT_HDR_V2 is not referenced by any database object

[top of page]

View: FM_ROUT_MTL_VW1

[top of page]

APPS.FM_ROUT_MTL_VW1 references the following:

APPS
SYNONYM - FM_MATL_DTL
SYNONYM - FM_ROUT_DTL
SYNONYM - GMD_RECIPE_STEP_MATERIALS

APPS.FM_ROUT_MTL_VW1 is not referenced by any database object

[top of page]

View: FM_TEXT_TBL_VL

[top of page]

APPS.FM_TEXT_TBL_VL references the following:

APPS
SYNONYM - FM_TEXT_TBL_TL

APPS.FM_TEXT_TBL_VL is not referenced by any database object

[top of page]

View: GMD_ACTIONS_VL

[top of page]

APPS.GMD_ACTIONS_VL references the following:

APPS
SYNONYM - GMD_ACTIONS_B
SYNONYM - GMD_ACTIONS_TL

APPS.GMD_ACTIONS_VL is not referenced by any database object

[top of page]

View: GMD_ACTIVITIES_VL

[top of page]

APPS.GMD_ACTIVITIES_VL references the following:

APPS
SYNONYM - GMD_ACTIVITIES_B
SYNONYM - GMD_ACTIVITIES_TL
APPS.GMD_ACTIVITIES_VL is referenced by following:

APPS
SYNONYM - FM_ACTV_MST
VIEW - GME_BATCH_STEP_ACTIVITIES_V

[top of page]

View: GMD_ALL_SPEC_VRS_VL

[top of page]

APPS.GMD_ALL_SPEC_VRS_VL references the following:

APPS
SYNONYM - GMD_CUSTOMER_SPEC_VRS
SYNONYM - GMD_INVENTORY_SPEC_VRS
SYNONYM - GMD_MONITORING_SPEC_VRS
SYNONYM - GMD_QC_STATUS_TL
SYNONYM - GMD_SPECIFICATIONS_B
SYNONYM - GMD_STABILITY_SPEC_VRS
SYNONYM - GMD_SUPPLIER_SPEC_VRS
SYNONYM - GMD_WIP_SPEC_VRS
VIEW - MTL_ITEM_LOCATIONS_KFV
SYNONYM - MTL_MATERIAL_STATUSES
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
APPS.GMD_ALL_SPEC_VRS_VL is referenced by following:

APPS
SYNONYM - GMD_ALL_SPEC_VRS

[top of page]

View: GMD_COM_SPEC_VRS_VL

[top of page]

APPS.GMD_COM_SPEC_VRS_VL references the following:

APPS
SYNONYM - GMD_CUSTOMER_SPEC_VRS
SYNONYM - GMD_INVENTORY_SPEC_VRS
SYNONYM - GMD_MONITORING_SPEC_VRS
SYNONYM - GMD_STABILITY_SPEC_VRS
SYNONYM - GMD_SUPPLIER_SPEC_VRS
SYNONYM - GMD_WIP_SPEC_VRS

APPS.GMD_COM_SPEC_VRS_VL is not referenced by any database object

[top of page]

View: GMD_CUSTOMER_TESTS_VL

[top of page]

APPS.GMD_CUSTOMER_TESTS_VL references the following:

APPS
SYNONYM - GMD_CUSTOMER_TESTS_B
SYNONYM - GMD_CUSTOMER_TESTS_TL

APPS.GMD_CUSTOMER_TESTS_VL is not referenced by any database object

[top of page]

View: GMD_CUST_VEND_MST_V1

[top of page]

APPS.GMD_CUST_VEND_MST_V1 references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - PO_VEND_MST
- OP_CUST_MST

APPS.GMD_CUST_VEND_MST_V1 is not referenced by any database object

[top of page]

View: GMD_CUST_VEND_MST_V2

[top of page]

APPS.GMD_CUST_VEND_MST_V2 references the following:

APPS
SYNONYM - HZ_CUST_ACCOUNTS_ALL
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_PARTIES
VIEW - PO_VENDORS
- HR_OPERATING_UNITS

APPS.GMD_CUST_VEND_MST_V2 is not referenced by any database object

[top of page]

View: GMD_ERES_MATERIALS_VW

[top of page]

APPS.GMD_ERES_MATERIALS_VW references the following:

APPS
SYNONYM - FM_MATL_DTL
SYNONYM - FM_ROUT_DTL
SYNONYM - GMD_RECIPE_STEP_MATERIALS
- MTL_SYSTEM_ITEMS_VL

APPS.GMD_ERES_MATERIALS_VW is not referenced by any database object

[top of page]

View: GMD_ERES_RECIPES_VW

[top of page]

APPS.GMD_ERES_RECIPES_VW references the following:

APPS
SYNONYM - FM_FORM_MST
SYNONYM - GMD_ROUTINGS
- GMD_RECIPES

APPS.GMD_ERES_RECIPES_VW is not referenced by any database object

[top of page]

View: GMD_FORMULA_CLASS_VL

[top of page]

APPS.GMD_FORMULA_CLASS_VL references the following:

APPS
SYNONYM - GMD_FORMULA_CLASS_B
SYNONYM - GMD_FORMULA_CLASS_TL

APPS.GMD_FORMULA_CLASS_VL is not referenced by any database object

[top of page]

View: GMD_GRADES_VL

[top of page]

APPS.GMD_GRADES_VL references the following:

APPS
SYNONYM - GMD_GRADES_B
SYNONYM - GMD_GRADES_TL
APPS.GMD_GRADES_VL is referenced by following:

APPS
VIEW - PMIFV_INV_SUMMARY_V
SYNONYM - QC_GRAD_MST

[top of page]

View: GMD_HOLD_REASONS_VL

[top of page]

APPS.GMD_HOLD_REASONS_VL references the following:

APPS
SYNONYM - GMD_HOLD_REASONS_B
SYNONYM - GMD_HOLD_REASONS_TL
APPS.GMD_HOLD_REASONS_VL is referenced by following:

APPS
VIEW - PMIFV_CURRENTINVENTORY_V
VIEW - PMIFV_PERIODINVENTORY_V

[top of page]

View: GMD_ITEM_SUBSTITUTION_HDR_VL

[top of page]

APPS.GMD_ITEM_SUBSTITUTION_HDR_VL references the following:

APPS
SYNONYM - GMD_ITEM_SUBSTITUTION_HDR_B
SYNONYM - GMD_ITEM_SUBSTITUTION_HDR_TL

APPS.GMD_ITEM_SUBSTITUTION_HDR_VL is not referenced by any database object

[top of page]

View: GMD_MATERIAL_EFFECTIVITIES_VW

[top of page]

APPS.GMD_MATERIAL_EFFECTIVITIES_VW references the following:

APPS
SYNONYM - FM_MATL_DTL
SYNONYM - GMD_FORMULA_SUBSTITUTION
SYNONYM - GMD_ITEM_SUBSTITUTION_DTL
SYNONYM - GMD_ITEM_SUBSTITUTION_HDR_B
APPS.GMD_MATERIAL_EFFECTIVITIES_VW is referenced by following:

APPS
VIEW - GMD_MBR_MATERIAL_V1
VIEW - GMD_MBR_STEP_MATERIAL_V1
VIEW - GMF_MATERIAL_EFFECTIVITIES_VW1

[top of page]

View: GMD_MBR_MATERIAL_V1

[top of page]

APPS.GMD_MBR_MATERIAL_V1 references the following:

APPS
SYNONYM - FM_FORM_MST
VIEW - GEM_LOOKUPS
PACKAGE - GMDFMVAL_PUB
VIEW - GMD_MATERIAL_EFFECTIVITIES_VW
PACKAGE - GMD_MBR_UTIL_PKG
SYNONYM - GMD_RECIPES_B
PACKAGE - GMO_MBR_UTIL
- MTL_SYSTEM_ITEMS_VL

APPS.GMD_MBR_MATERIAL_V1 is not referenced by any database object

[top of page]

View: GMD_MBR_OPRN_ACTIVITIY_V1

[top of page]

APPS.GMD_MBR_OPRN_ACTIVITIY_V1 references the following:

APPS
SYNONYM - FM_ACTV_MST
SYNONYM - FM_ROUT_DTL
SYNONYM - GMD_OPERATIONS_B
SYNONYM - GMD_OPERATION_ACTIVITIES
SYNONYM - GMD_RECIPES_B

APPS.GMD_MBR_OPRN_ACTIVITIY_V1 is not referenced by any database object

[top of page]

View: GMD_MBR_RECIPE_HEADER_V1

[top of page]

APPS.GMD_MBR_RECIPE_HEADER_V1 references the following:

APPS
VIEW - FM_FORM_MST_VL
PACKAGE - FND_DATE
PACKAGE - FND_TIMEZONES
VIEW - GMD_RECIPES_VL
VIEW - GMD_ROUTINGS_VL
VIEW - GMD_STATUS_VL

APPS.GMD_MBR_RECIPE_HEADER_V1 is not referenced by any database object

[top of page]

View: GMD_MBR_RECIPE_RSRC_V1

[top of page]

APPS.GMD_MBR_RECIPE_RSRC_V1 references the following:

APPS
SYNONYM - CR_RSRC_MST_B
SYNONYM - FM_ROUT_DTL
SYNONYM - GMD_OPERATIONS_B
SYNONYM - GMD_OPERATION_ACTIVITIES
SYNONYM - GMD_OPERATION_RESOURCES
SYNONYM - GMD_RECIPES_B

APPS.GMD_MBR_RECIPE_RSRC_V1 is not referenced by any database object

[top of page]

View: GMD_MBR_STEP_MATERIAL_V1

[top of page]

APPS.GMD_MBR_STEP_MATERIAL_V1 references the following:

APPS
SYNONYM - FM_FORM_MST
SYNONYM - FM_ROUT_DTL
VIEW - GEM_LOOKUPS
PACKAGE - GMDFMVAL_PUB
VIEW - GMD_MATERIAL_EFFECTIVITIES_VW
PACKAGE - GMD_MBR_UTIL_PKG
SYNONYM - GMD_OPERATIONS_B
SYNONYM - GMD_RECIPES_B
SYNONYM - GMD_RECIPE_STEP_MATERIALS
SYNONYM - GMD_ROUTINGS_B
PACKAGE - GMO_MBR_UTIL
- MTL_SYSTEM_ITEMS_VL

APPS.GMD_MBR_STEP_MATERIAL_V1 is not referenced by any database object

[top of page]

View: GMD_MBR_STEP_OPRN_V1

[top of page]

APPS.GMD_MBR_STEP_OPRN_V1 references the following:

APPS
SYNONYM - FM_ROUT_DTL
PACKAGE - FND_DATE
PACKAGE - FND_TIMEZONES
SYNONYM - GMD_OPERATIONS
SYNONYM - GMD_RECIPES_B

APPS.GMD_MBR_STEP_OPRN_V1 is not referenced by any database object

[top of page]

View: GMD_OPERATIONS_VL

[top of page]

APPS.GMD_OPERATIONS_VL references the following:

APPS
SYNONYM - GMD_OPERATIONS_B
SYNONYM - GMD_OPERATIONS_TL
APPS.GMD_OPERATIONS_VL is referenced by following:

APPS
SYNONYM - FM_OPRN_MST
SYNONYM - GMD_OPERATIONS
VIEW - GMO_BATCH_STEPS_V

[top of page]

View: GMD_OPERATION_CLASS_VL

[top of page]

APPS.GMD_OPERATION_CLASS_VL references the following:

APPS
SYNONYM - GMD_OPERATION_CLASS_B
SYNONYM - GMD_OPERATION_CLASS_TL

APPS.GMD_OPERATION_CLASS_VL is not referenced by any database object

[top of page]

View: GMD_OPRN_PROCESS_PARAMETERS_V1

[top of page]

APPS.GMD_OPRN_PROCESS_PARAMETERS_V1 references the following:

APPS
SYNONYM - GMD_OPERATION_RESOURCES
SYNONYM - GMD_OPRN_PROCESS_PARAMETERS
SYNONYM - GMP_RESOURCE_PARAMETERS

APPS.GMD_OPRN_PROCESS_PARAMETERS_V1 is not referenced by any database object

[top of page]

View: GMD_ORG_ACCESS_VW

[top of page]

APPS.GMD_ORG_ACCESS_VW references the following:

APPS
PACKAGE - FND_GLOBAL
PACKAGE - HR_GENERAL
SYNONYM - HR_ORGANIZATION_INFORMATION
PACKAGE - HR_SECURITY
SYNONYM - MTL_PARAMETERS
SYNONYM - ORG_ACCESS
- HR_ORGANIZATION_UNITS

APPS.GMD_ORG_ACCESS_VW is not referenced by any database object

[top of page]

View: GMD_QC_E_ALL_SPEC_VRS_DISP_V

[top of page]

APPS.GMD_QC_E_ALL_SPEC_VRS_DISP_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - GMD_ALL_SPEC_VRS

APPS.GMD_QC_E_ALL_SPEC_VRS_DISP_V is not referenced by any database object

[top of page]

View: GMD_QC_E_COMPOSITE_RESULTS_V

[top of page]

APPS.GMD_QC_E_COMPOSITE_RESULTS_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - GMD_COMPOSITE_RESULTS
SYNONYM - GMD_COMPOSITE_SPEC_DISP
SYNONYM - GMD_EVENT_SPEC_DISP
SYNONYM - GMD_QC_TESTS
PACKAGE - GMD_QC_TEST_VALUES_GRP
SYNONYM - GMD_SPEC_TESTS
SYNONYM - GMD_TEST_METHODS

APPS.GMD_QC_E_COMPOSITE_RESULTS_V is not referenced by any database object

[top of page]

View: GMD_QC_E_CUST_SAMPLE_DTLS_V

[top of page]

APPS.GMD_QC_E_CUST_SAMPLE_DTLS_V references the following:

APPS
SYNONYM - GMD_SAMPLES
SYNONYM - HZ_CUST_ACCOUNTS_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_PARTIES
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OE_ORDER_LINES_ALL
- OE_TRANSACTION_TYPES
- HR_OPERATING_UNITS

APPS.GMD_QC_E_CUST_SAMPLE_DTLS_V is not referenced by any database object

[top of page]

View: GMD_QC_E_CUST_SMPEVT_DTLS_V

[top of page]

APPS.GMD_QC_E_CUST_SMPEVT_DTLS_V references the following:

APPS
SYNONYM - GMD_SAMPLING_EVENTS
SYNONYM - HZ_CUST_ACCOUNTS_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_PARTIES
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OE_ORDER_LINES_ALL
- OE_TRANSACTION_TYPES
- HR_OPERATING_UNITS

APPS.GMD_QC_E_CUST_SMPEVT_DTLS_V is not referenced by any database object

[top of page]

View: GMD_QC_E_RESULTS_V

[top of page]

APPS.GMD_QC_E_RESULTS_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - GMD_EVENT_SPEC_DISP
SYNONYM - GMD_QC_TESTS
PACKAGE - GMD_QC_TEST_VALUES_GRP
SYNONYM - GMD_RESULTS
SYNONYM - GMD_SAMPLES
SYNONYM - GMD_SPEC_RESULTS
SYNONYM - GMD_SPEC_TESTS
SYNONYM - GMD_TEST_METHODS
SYNONYM - MTL_PARAMETERS

APPS.GMD_QC_E_RESULTS_V is not referenced by any database object

[top of page]

View: GMD_QC_E_SAMPLES_USED_V

[top of page]

APPS.GMD_QC_E_SAMPLES_USED_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - GMD_COMPOSITE_RESULT_ASSOC
SYNONYM - GMD_QC_TESTS
SYNONYM - GMD_RESULTS
SYNONYM - GMD_SAMPLES

APPS.GMD_QC_E_SAMPLES_USED_V is not referenced by any database object

[top of page]

View: GMD_QC_E_SAMPLE_RESULTS_V

[top of page]

APPS.GMD_QC_E_SAMPLE_RESULTS_V references the following:

APPS
SYNONYM - FND_USER
SYNONYM - GMD_QC_TESTS_B
SYNONYM - GMD_RESULTS
SYNONYM - GMD_SAMPLES
SYNONYM - MTL_PARAMETERS

APPS.GMD_QC_E_SAMPLE_RESULTS_V is not referenced by any database object

[top of page]

View: GMD_QC_E_SPEC_TESTS_V

[top of page]

APPS.GMD_QC_E_SPEC_TESTS_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - GMD_QC_TESTS
PACKAGE - GMD_QC_TEST_VALUES_GRP
SYNONYM - GMD_SPEC_TESTS
SYNONYM - GMD_TEST_METHODS
SYNONYM - MTL_ACTIONS

APPS.GMD_QC_E_SPEC_TESTS_V is not referenced by any database object

[top of page]

View: GMD_QC_E_SUPP_SAMPLE_DTLS_V

[top of page]

APPS.GMD_QC_E_SUPP_SAMPLE_DTLS_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - GMD_SAMPLES
SYNONYM - MTL_PARAMETERS
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES_ALL
VIEW - PO_VENDORS
SYNONYM - RCV_SHIPMENT_HEADERS
SYNONYM - RCV_SHIPMENT_LINES
- PO_VENDOR_SITES_ALL
- HR_OPERATING_UNITS

APPS.GMD_QC_E_SUPP_SAMPLE_DTLS_V is not referenced by any database object

[top of page]

View: GMD_QC_E_SUPP_SMPEVT_DTLS_V

[top of page]

APPS.GMD_QC_E_SUPP_SMPEVT_DTLS_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - GMD_SAMPLING_EVENTS
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES_ALL
VIEW - PO_VENDORS
SYNONYM - RCV_SHIPMENT_HEADERS
SYNONYM - RCV_SHIPMENT_LINES
- PO_VENDOR_SITES_ALL

APPS.GMD_QC_E_SUPP_SMPEVT_DTLS_V is not referenced by any database object

[top of page]

View: GMD_QC_E_TEST_INSTANCE_V

[top of page]

APPS.GMD_QC_E_TEST_INSTANCE_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - GMD_QC_TESTS
SYNONYM - GMD_RESULTS
SYNONYM - GMD_TEST_METHODS_B

APPS.GMD_QC_E_TEST_INSTANCE_V is not referenced by any database object

[top of page]

View: GMD_QC_E_WIP_SAMPLE_DTLS_V

[top of page]

APPS.GMD_QC_E_WIP_SAMPLE_DTLS_V references the following:

APPS
SYNONYM - FM_FORM_MST_B
SYNONYM - GMD_OPERATIONS
SYNONYM - GMD_RECIPES_B
SYNONYM - GMD_ROUTINGS_B
SYNONYM - GMD_SAMPLES
SYNONYM - GME_BATCH_HEADER

APPS.GMD_QC_E_WIP_SAMPLE_DTLS_V is not referenced by any database object

[top of page]

View: GMD_QC_E_WIP_SMPEVT_DTLS_V

[top of page]

APPS.GMD_QC_E_WIP_SMPEVT_DTLS_V references the following:

APPS
SYNONYM - FM_FORM_MST_B
SYNONYM - GMD_OPERATIONS
SYNONYM - GMD_RECIPES_B
SYNONYM - GMD_ROUTINGS_B
SYNONYM - GMD_SAMPLING_EVENTS
SYNONYM - GME_BATCH_HEADER
SYNONYM - MTL_PARAMETERS

APPS.GMD_QC_E_WIP_SMPEVT_DTLS_V is not referenced by any database object

[top of page]

View: GMD_QC_STATUS_VL

[top of page]

APPS.GMD_QC_STATUS_VL references the following:

APPS
SYNONYM - GMD_QC_STATUS_B
SYNONYM - GMD_QC_STATUS_TL
APPS.GMD_QC_STATUS_VL is referenced by following:

APPS
SYNONYM - GMD_QC_STATUS
VIEW - GMD_SPEC_SUMMARY

[top of page]

View: GMD_QC_TESTS_VL

[top of page]

APPS.GMD_QC_TESTS_VL references the following:

APPS
SYNONYM - GMD_QC_TESTS_B
SYNONYM - GMD_QC_TESTS_TL
APPS.GMD_QC_TESTS_VL is referenced by following:

APPS
SYNONYM - GMD_QC_TESTS
VIEW - PMIFV_BTCH_QCRSLT_V
VIEW - PMIFV_QCRESULT_V
VIEW - PMITS_QC_TESTS_V

[top of page]

View: GMD_QC_TEST_VALUES_VL

[top of page]

APPS.GMD_QC_TEST_VALUES_VL references the following:

APPS
SYNONYM - GMD_QC_TEST_VALUES_B
SYNONYM - GMD_QC_TEST_VALUES_TL
APPS.GMD_QC_TEST_VALUES_VL is referenced by following:

APPS
SYNONYM - GMD_QC_TEST_VALUES
VIEW - PMITS_QC_TESTS_V

[top of page]

View: GMD_QM_E_MATERIAL_SOURCES_V

[top of page]

APPS.GMD_QM_E_MATERIAL_SOURCES_V references the following:

APPS
SYNONYM - FM_FORM_MST_B
SYNONYM - GMD_RECIPES_B
SYNONYM - GMD_SPECIFICATIONS_B
SYNONYM - GMD_SS_MATERIAL_SOURCES
SYNONYM - GMD_SS_STORAGE_PACKAGE
SYNONYM - GMD_SS_VARIANTS
SYNONYM - GME_BATCH_HEADER
SYNONYM - MTL_PARAMETERS
- MTL_ITEM_LOCATIONS_KFV

APPS.GMD_QM_E_MATERIAL_SOURCES_V is not referenced by any database object

[top of page]

View: GMD_QM_E_STABILITY_STUDIES_V

[top of page]

APPS.GMD_QM_E_STABILITY_STUDIES_V references the following:

APPS
SYNONYM - GMD_QC_STATUS
SYNONYM - GMD_SPECIFICATIONS
SYNONYM - GMD_STABILITY_STUDIES
- MTL_SYSTEM_ITEMS_KFV

APPS.GMD_QM_E_STABILITY_STUDIES_V is not referenced by any database object

[top of page]

View: GMD_QM_E_TIMEPOINTS_V

[top of page]

APPS.GMD_QM_E_TIMEPOINTS_V references the following:

APPS
SYNONYM - GMD_SS_TIME_POINTS
- GMD_SPECIFICATIONS

APPS.GMD_QM_E_TIMEPOINTS_V is not referenced by any database object

[top of page]

View: GMD_RECIPES_VL

[top of page]

APPS.GMD_RECIPES_VL references the following:

APPS
SYNONYM - GMD_RECIPES_B
SYNONYM - GMD_RECIPES_TL
APPS.GMD_RECIPES_VL is referenced by following:

APPS
VIEW - GMD_MBR_RECIPE_HEADER_V1
SYNONYM - GMD_RECIPES
VIEW - MTH_SRC_PRODUCTION_SCHEDULES_V
VIEW - MTH_SRC_PROD_MTL_PRODUCED_V
VIEW - PMITS_RECIPE_VALIDITY_RULE_V

[top of page]

View: GMD_ROUTINGS_VL

[top of page]

APPS.GMD_ROUTINGS_VL references the following:

APPS
SYNONYM - GMD_ROUTINGS_B
SYNONYM - GMD_ROUTINGS_TL
APPS.GMD_ROUTINGS_VL is referenced by following:

APPS
SYNONYM - FM_ROUT_HDR
VIEW - GMD_MBR_RECIPE_HEADER_V1
SYNONYM - GMD_ROUTINGS

[top of page]

View: GMD_ROUTING_CLASS_VL

[top of page]

APPS.GMD_ROUTING_CLASS_VL references the following:

APPS
SYNONYM - GMD_ROUTING_CLASS_B
SYNONYM - GMD_ROUTING_CLASS_TL

APPS.GMD_ROUTING_CLASS_VL is not referenced by any database object

[top of page]

View: GMD_SAMPLING_PLANS_VL

[top of page]

APPS.GMD_SAMPLING_PLANS_VL references the following:

APPS
SYNONYM - GMD_SAMPLING_PLANS_B
SYNONYM - GMD_SAMPLING_PLANS_TL

APPS.GMD_SAMPLING_PLANS_VL is not referenced by any database object

[top of page]

View: GMD_SPECIFICATIONS_VL

[top of page]

APPS.GMD_SPECIFICATIONS_VL references the following:

APPS
SYNONYM - GMD_SPECIFICATIONS_B
SYNONYM - GMD_SPECIFICATIONS_TL
APPS.GMD_SPECIFICATIONS_VL is referenced by following:

APPS
SYNONYM - GMD_SPECIFICATIONS
VIEW - GMD_SPEC_SUMMARY

[top of page]

View: GMD_SPEC_SUMMARY

[top of page]

APPS.GMD_SPEC_SUMMARY references the following:

APPS
VIEW - GMD_QC_STATUS_VL
VIEW - GMD_SPECIFICATIONS_VL
SYNONYM - MTL_PARAMETERS
- MTL_SYSTEM_ITEMS_B_KFV

APPS.GMD_SPEC_SUMMARY is not referenced by any database object

[top of page]

View: GMD_SPEC_TESTS_VL

[top of page]

APPS.GMD_SPEC_TESTS_VL references the following:

APPS
SYNONYM - GMD_SPEC_TESTS_B
SYNONYM - GMD_SPEC_TESTS_TL
APPS.GMD_SPEC_TESTS_VL is referenced by following:

APPS
SYNONYM - GMD_SPEC_TESTS

[top of page]

View: GMD_STABILITY_STUDIES_VL

[top of page]

APPS.GMD_STABILITY_STUDIES_VL references the following:

APPS
SYNONYM - GMD_STABILITY_STUDIES_B
SYNONYM - GMD_STABILITY_STUDIES_TL
APPS.GMD_STABILITY_STUDIES_VL is referenced by following:

APPS
SYNONYM - GMD_STABILITY_STUDIES

[top of page]

View: GMD_STATUS_VL

[top of page]

APPS.GMD_STATUS_VL references the following:

APPS
SYNONYM - GMD_STATUS_B
SYNONYM - GMD_STATUS_TL
APPS.GMD_STATUS_VL is referenced by following:

APPS
VIEW - GMD_MBR_RECIPE_HEADER_V1
SYNONYM - GMD_STATUS

[top of page]

View: GMD_STORAGE_PLANS_VL

[top of page]

APPS.GMD_STORAGE_PLANS_VL references the following:

APPS
SYNONYM - GMD_STORAGE_PLANS_B
SYNONYM - GMD_STORAGE_PLANS_TL

APPS.GMD_STORAGE_PLANS_VL is not referenced by any database object

[top of page]

View: GMD_TECHNICAL_DATA_VL

[top of page]

APPS.GMD_TECHNICAL_DATA_VL references the following:

APPS
SYNONYM - GMD_TECHNICAL_DATA_DTL
SYNONYM - GMD_TECHNICAL_DATA_HDR
SYNONYM - GMD_TECH_PARAMETERS_B
APPS.GMD_TECHNICAL_DATA_VL is referenced by following:

APPS
SYNONYM - LM_ITEM_DAT

[top of page]

View: GMD_TECHNICAL_SEQUENCE_VL

[top of page]

APPS.GMD_TECHNICAL_SEQUENCE_VL references the following:

APPS
SYNONYM - GMD_TECHNICAL_SEQUENCE_DTL
SYNONYM - GMD_TECHNICAL_SEQUENCE_HDR
SYNONYM - GMD_TECH_PARAMETERS_B

APPS.GMD_TECHNICAL_SEQUENCE_VL is not referenced by any database object

[top of page]

View: GMD_TECH_PARAMETERS_VL

[top of page]

APPS.GMD_TECH_PARAMETERS_VL references the following:

APPS
SYNONYM - GMD_TECH_PARAMETERS_B
SYNONYM - GMD_TECH_PARAMETERS_TL

APPS.GMD_TECH_PARAMETERS_VL is not referenced by any database object

[top of page]

View: GMD_TESTS_VL

[top of page]

APPS.GMD_TESTS_VL references the following:

APPS
SYNONYM - GMD_TESTS_B
SYNONYM - GMD_TESTS_TL
APPS.GMD_TESTS_VL is referenced by following:

APPS
SYNONYM - QC_ASSY_TYP

[top of page]

View: GMD_TEST_CLASSES_VL

[top of page]

APPS.GMD_TEST_CLASSES_VL references the following:

APPS
SYNONYM - GMD_TEST_CLASSES_B
SYNONYM - GMD_TEST_CLASSES_TL
APPS.GMD_TEST_CLASSES_VL is referenced by following:

APPS
VIEW - PMITS_QC_TESTS_V

[top of page]

View: GMD_TEST_INTERVAL_PLANS_VL

[top of page]

APPS.GMD_TEST_INTERVAL_PLANS_VL references the following:

APPS
SYNONYM - GMD_TEST_INTERVAL_PLANS_B
SYNONYM - GMD_TEST_INTERVAL_PLANS_TL

APPS.GMD_TEST_INTERVAL_PLANS_VL is not referenced by any database object

[top of page]

View: GMD_TEST_METHODS_VL

[top of page]

APPS.GMD_TEST_METHODS_VL references the following:

APPS
SYNONYM - GMD_TEST_METHODS_B
SYNONYM - GMD_TEST_METHODS_TL
APPS.GMD_TEST_METHODS_VL is referenced by following:

APPS
SYNONYM - GMD_TEST_METHODS

[top of page]

View: GMD_TEST_VALUES_VL

[top of page]

APPS.GMD_TEST_VALUES_VL references the following:

APPS
SYNONYM - GMD_TEST_VALUES_B
SYNONYM - GMD_TEST_VALUES_TL
APPS.GMD_TEST_VALUES_VL is referenced by following:

APPS
SYNONYM - QC_ASSY_VAL

[top of page]

View: GMD_UNITS_VL

[top of page]

APPS.GMD_UNITS_VL references the following:

APPS
SYNONYM - GMD_UNITS_B
SYNONYM - GMD_UNITS_TL

APPS.GMD_UNITS_VL is not referenced by any database object

[top of page]

View: LM_TEXT_TBL_VL

[top of page]

APPS.LM_TEXT_TBL_VL references the following:

APPS
SYNONYM - LM_TEXT_TBL_TL

APPS.LM_TEXT_TBL_VL is not referenced by any database object

[top of page]

View: QC_TEXT_TBL_VL

[top of page]

APPS.QC_TEXT_TBL_VL references the following:

APPS
SYNONYM - QC_TEXT_TBL_TL

APPS.QC_TEXT_TBL_VL is not referenced by any database object

[top of page]

View: QC_TRAN_VW1

[top of page]

APPS.QC_TRAN_VW1 references the following:

APPS
SYNONYM - IC_TRAN_PND
SYNONYM - PM_MATL_DTL
SYNONYM - PO_RECV_DTL
SYNONYM - PO_RECV_HDR
- IC_TRAN_VW1
- PM_BTCH_HDR

APPS.QC_TRAN_VW1 is not referenced by any database object

[top of page]

View: QC_TRAN_VW2

[top of page]

APPS.QC_TRAN_VW2 references the following:

APPS
SYNONYM - IC_TRAN_PND
SYNONYM - OP_ORDR_DTL
SYNONYM - OP_ORDR_HDR
SYNONYM - PM_MATL_DTL
- IC_TRAN_VW1
- PM_BTCH_HDR

APPS.QC_TRAN_VW2 is not referenced by any database object

[top of page]



Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract