eTRM uses javascript that opens and focuses a separate window to display reports.
Your browser does not appear to support javascript. This should not prevent you from using
eTRM but it does mean the window focus feature will not work. Please check the contents of
other windows on your desktop if you click on a link that does not appear to do anything.
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®,
OracleDevConnect SM, Oracle® Discoverer,
Oracle® Expert, Oracle Financials®, OracleGOLD SM,
OracleIncident SM, OracleJSP,
OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURY SM,
OracleMetaLink SM, Oraclemetals SM, OracleMobile, Oracle Names®,
Oracle NetSolutions®, Oracle® One, Oracle Open Gateways®,
Oracle OpenWorld®, OraclePLATINUM SM,
Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®,
Oracle Quality®, Oracle Secure Network Services®, OracleSILVER SM,
Oracle® SQL/Services, Oracle® SQL*TutorSM,
OracleSTERLING SM, 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
OPRN_ID
PRIMARY_RESOURCE
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:
APPS
SYNONYM - 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
FMCONF_ID
Primary Key: FM_CONF_TBL_U1
ORGN_CODE
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:
APPS
SYNONYM - FM_CONF_TBL
[top of page]
Table: FM_FMCT_CLS
Description: Formula control classes -NOT USED-
Primary Key: FM_FMCT_CLS_PK
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:
APPS
SYNONYM - FM_FMCT_CLS
[top of page]
Table: FM_FORM_MST_B
Description: Formula header base table
Primary Key: FM_FORM_MST_B_PK
FORMULA_ID
Primary Key: FM_FORM_MST_B_UK
FORMULA_NO
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:
APPS
SYNONYM - FM_FORM_MST_B
TRIGGER - FM_FORM_MST_B_TG
TRIGGER - GMDFMTRG_UPDATE_WF
TRIGGER - GMDFMTRG_UPD_FS
[top of page]
Table: FM_FORM_MST_TL
Description: Formula header translation table
Primary Key: FM_FORM_MST_TL_PK
FORMULA_ID
LANGUAGE
[top of page]
GMD.FM_FORM_MST_TL does not reference any database object
GMD.FM_FORM_MST_TL is referenced by following:
APPS
SYNONYM - 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
TOP_FORMULA_ID
EXPLODE_SEQ
[top of page]
GMD.FM_IBOM_DTL does not reference any database object
GMD.FM_IBOM_DTL is referenced by following:
APPS
SYNONYM - 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
TOP_FORMULA_ID
[top of page]
GMD.FM_IBOM_HDR does not reference any database object
GMD.FM_IBOM_HDR is referenced by following:
APPS
SYNONYM - 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
FORMULALINE_ID
Primary Key: FM_MATL_DTL_U1
FORMULA_ID
LINE_TYPE
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:
APPS
SYNONYM - FM_MATL_DTL
[top of page]
Table: FM_ROUT_DEP
Description: Routing step dependencies
Primary Key: FM_ROUT_DEP_PK
ROUTINGSTEP_NO
DEP_ROUTINGSTEP_NO
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:
APPS
SYNONYM - FM_ROUT_DEP
[top of page]
Table: FM_ROUT_DTL
Description: Routing details
Primary Key: FM_ROUT_DTLI1
ROUTINGSTEP_ID
Primary Key: FM_ROUT_DTL_PK
ROUTING_ID
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:
APPS
SYNONYM - FM_ROUT_DTL
[top of page]
Table: FM_ROUT_MTL
Description: Routing Steps to Formula Lines Association
Primary Key: FM_ROUT_MTL_PK
FORMULA_ID
ROUTING_ID
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:
APPS
SYNONYM - 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
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:
APPS
SYNONYM - 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
TEXT_CODE
LANG_CODE
PARAGRAPH_CODE
SUB_PARACODE
LINE_NO
LANGUAGE
[top of page]
GMD.FM_TEXT_TBL_TL does not reference any database object
GMD.FM_TEXT_TBL_TL is referenced by following:
APPS
SYNONYM - FM_TEXT_TBL_TL
[top of page]
Table: GMD_ACTIONS_B
Description: OPM Quality Actions
Primary Key: GMD_ACTIONS_B_PK
ACTION_CODE
[top of page]
GMD.GMD_ACTIONS_B does not reference any database object
GMD.GMD_ACTIONS_B is referenced by following:
APPS
SYNONYM - GMD_ACTIONS_B
[top of page]
Table: GMD_ACTIONS_TL
Description: OPM Quality Translation table
Primary Key: GMD_ACTIONS_TL_PK
ACTION_CODE
LANGUAGE
[top of page]
GMD.GMD_ACTIONS_TL does not reference any database object
GMD.GMD_ACTIONS_TL is referenced by following:
APPS
SYNONYM - 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
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:
APPS
SYNONYM - GMD_ACTIVITIES_B
[top of page]
Table: GMD_ACTIVITIES_TL
Description: Activities Translation Table
Primary Key: GMD_ACTIVITIES_TL_PK
ACTIVITY
LANGUAGE
[top of page]
GMD.GMD_ACTIVITIES_TL does not reference any database object
GMD.GMD_ACTIVITIES_TL is referenced by following:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - GMD_COA_RSLT_TEXT
[top of page]
Table: GMD_COA_SPEC_HDR_TEXT
[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:
APPS
SYNONYM - 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:
APPS
SYNONYM - GMD_COA_SPEC_TEXT
[top of page]
Table: GMD_COMPOSITE_RESULTS
Description: OPM Quality Composite results
Primary Key: GMD_COMPOSITE_RESULTS_PK
COMPOSITE_RESULT_ID
[top of page]
GMD.GMD_COMPOSITE_RESULTS does not reference any database object
GMD.GMD_COMPOSITE_RESULTS is referenced by following:
APPS
SYNONYM - GMD_COMPOSITE_RESULTS
SYNONYM - GMD_COMP_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:
APPS
SYNONYM - GMD_COMPOSITE_RESULT_ASSOC
SYNONYM - GMD_COMP_RESULT_ASSOC
[top of page]
Table: GMD_COMPOSITE_SPEC_DISP
Description: OPM Quality Composite Specification Display
Primary Key: GMD_COMPOSITE_SPEC_DISP_PK
EVENT_SPEC_DISP_ID
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:
APPS
SYNONYM - GMD_COMPOSITE_SPEC_DISP
SYNONYM - GMD_COMP_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:
APPS
SYNONYM - 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
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:
APPS
SYNONYM - GMD_CUSTOMER_SPEC_VRS
[top of page]
Table: GMD_CUSTOMER_TESTS_B
Description: Customer Tests
Primary Key: GMD_CUSTOMER_TESTS_B_PK
TEST_ID
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:
APPS
SYNONYM - GMD_CUSTOMER_TESTS_B
[top of page]
Table: GMD_CUSTOMER_TESTS_TL
Description: Customer Tests Translation table
Primary Key: GMD_CUSTOMER_TESTS_TL_PK
TEST_ID
CUST_ID
LANGUAGE
[top of page]
GMD.GMD_CUSTOMER_TESTS_TL does not reference any database object
GMD.GMD_CUSTOMER_TESTS_TL is referenced by following:
APPS
SYNONYM - 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
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:
APPS
SYNONYM - 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:
APPS
SYNONYM - GMD_FORMULATION_SPECS
[top of page]
Table: GMD_FORMULA_ANALYSIS_DTL
Description: Formula analysis detail table
Primary Key: GMD_FORMULA_ANALYSIS_DTL_PK
FORMULA_ID
ORGN_CODE
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:
APPS
SYNONYM - GMD_FORMULA_ANALYSIS_DTL
[top of page]
Table: GMD_FORMULA_ANALYSIS_HDR
Description: Formula Analysis Header table.
Primary Key: GMD_FORMULA_ANALYSIS_HDR_PK
FORMULA_ID
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:
APPS
SYNONYM - 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
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:
APPS
SYNONYM - 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:
APPS
SYNONYM - GMD_FORMULA_CLASS_TL
[top of page]
Table: GMD_FORMULA_SECURITY
Description: Formula Security table
Primary Key: GMD_FORMULA_SECURITY_PK
FORMULA_SECURITY_ID
Primary Key: GMD_FORMULA_SECURITY_U1
ORGN_CODE
USER_ID
RESPONSIBILITY_ID
FORMULA_ID
OTHER_ORGN
[top of page]
GMD.GMD_FORMULA_SECURITY does not reference any database object
GMD.GMD_FORMULA_SECURITY is referenced by following:
APPS
SYNONYM - GMD_FORMULA_SECURITY
[top of page]
Table: GMD_FORMULA_SECURITY_TEMP
[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:
APPS
SYNONYM - GMD_FORMULA_SUBSTITUTION
[top of page]
Table: GMD_GRADES_B
Description: QC grade code master.
Primary Key: GMD_GRADES_B_PK
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:
APPS
SYNONYM - GMD_GRADES_B
[top of page]
Table: GMD_GRADES_TL
Description: QC Units Translation Table
Primary Key: GMD_GRADES_TL_PK
QC_GRADE
LANGUAGE
[top of page]
GMD.GMD_GRADES_TL does not reference any database object
GMD.GMD_GRADES_TL is referenced by following:
APPS
SYNONYM - GMD_GRADES_TL
[top of page]
Table: GMD_HOLD_REASONS_B
Description: OPM Quality Hold reasons
Primary Key: GMD_HOLD_REASONS_B_PK
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:
APPS
SYNONYM - GMD_HOLD_REASONS_B
[top of page]
Table: GMD_HOLD_REASONS_TL
Description: OPM Quality Hold Reasons
Primary Key: GMD_HOLD_REASONS_TL_PK
QCHOLD_RES_CODE
LANGUAGE
[top of page]
GMD.GMD_HOLD_REASONS_TL does not reference any database object
GMD.GMD_HOLD_REASONS_TL is referenced by following:
APPS
SYNONYM - 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
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:
APPS
SYNONYM - 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
[top of page]
GMD.GMD_ITEM_SUBSTITUTION_DTL does not reference any database object
GMD.GMD_ITEM_SUBSTITUTION_DTL is referenced by following:
APPS
SYNONYM - 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
[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:
APPS
SYNONYM - GMD_ITEM_SUBSTITUTION_HDR_B
[top of page]
Table: GMD_ITEM_SUBSTITUTION_HDR_TL
Description: This is translate table for the Item Substitution
[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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - GMD_LAB_ORGN_ASSOC
[top of page]
Table: GMD_LCF_CATEGORY_DTL_GTMP
[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
[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
[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:
APPS
SYNONYM - GMD_LCF_EXTERNAL_COST
[top of page]
Table: GMD_LCF_TECH_DATA_GTMP
[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
[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:
APPS
SYNONYM - GMD_MASS_SAMPLES
[top of page]
Table: GMD_MATERIAL_DETAILS_GTMP
[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
[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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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
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:
APPS
SYNONYM - 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:
APPS
SYNONYM - GMD_MSNR_RESULTS
[top of page]
Table: GMD_OPERATIONS_B
Description: Operations base table.
Primary Key: GMD_OPERATIONS_B_PK
OPRN_ID
Primary Key: GMD_OPERATIONS_B_U1
OPRN_NO
OPRN_VERS
[top of page]
GMD.GMD_OPERATIONS_B does not reference any database object
GMD.GMD_OPERATIONS_B is referenced by following:
APPS
TRIGGER - GMDOPTRG_UPDATE_WF
SYNONYM - GMD_OPERATIONS_B
[top of page]
Table: GMD_OPERATIONS_TL
Description: Operations translation table.
Primary Key: GMD_OPERATIONS_TL_PK
OPRN_ID
LANGUAGE
[top of page]
GMD.GMD_OPERATIONS_TL does not reference any database object
GMD.GMD_OPERATIONS_TL is referenced by following:
APPS
SYNONYM - GMD_OPERATIONS_TL
[top of page]
Table: GMD_OPERATION_ACTIVITIES
Description: Operation Activity details
Primary Key: GMD_OPERATION_ACTIVITIES_PK
OPRN_LINE_ID
[top of page]
GMD.GMD_OPERATION_ACTIVITIES does not reference any database object
GMD.GMD_OPERATION_ACTIVITIES is referenced by following:
APPS
SYNONYM - 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
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:
APPS
SYNONYM - 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:
APPS
SYNONYM - GMD_OPERATION_CLASS_TL
[top of page]
Table: GMD_OPERATION_RESOURCES
Description: Operation Resource details
Primary Key: GMD_OPERATION_RESOURCES_PK
OPRN_LINE_ID
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:
APPS
SYNONYM - 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
OPRN_LINE_ID
RESOURCES
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:
APPS
SYNONYM - GMD_OPRN_PROCESS_PARAMETERS
[top of page]
Table: GMD_OPTIMIZER_HDR_GTMP
[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
[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
PARAMETER_ID
[top of page]
GMD.GMD_PARAMETERS does not reference any database object
GMD.GMD_PARAMETERS is referenced by following:
APPS
SYNONYM - 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:
APPS
SYNONYM - GMD_PARAMETERS_DTL
[top of page]
Table: GMD_PARAMETERS_HDR
Description: used instead of profiles
Primary Key: GMD_PARAMETERS_HDR_PK
PARAMETER_ID
[top of page]
GMD.GMD_PARAMETERS_HDR does not reference any database object
GMD.GMD_PARAMETERS_HDR is referenced by following:
APPS
SYNONYM - 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:
APPS
SYNONYM - GMD_PARSED_EXPRESSION
[top of page]
Table: GMD_PROCESS_LOSS
Description: Routing Process Loss
Primary Key: GMD_PROCESS_LOSS_U1
ROUTING_CLASS
MAX_QUANTITY
[top of page]
GMD.GMD_PROCESS_LOSS does not reference any database object
GMD.GMD_PROCESS_LOSS is referenced by following:
APPS
SYNONYM - 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
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:
APPS
SYNONYM - GMD_QC_ASSAY_CLASS
[top of page]
Table: GMD_QC_SPEC_MST_GTMP
[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
STATUS_CODE
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:
APPS
SYNONYM - 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
CURRENT_STATUS
ENTITY_TYPE
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:
APPS
SYNONYM - GMD_QC_STATUS_NEXT
[top of page]
Table: GMD_QC_STATUS_TL
Description: OPM Quality Status translation
Primary Key: GMD_QC_STATUS_TL_PK
STATUS_CODE
ENTITY_TYPE
LANGUAGE
[top of page]
GMD.GMD_QC_STATUS_TL does not reference any database object
GMD.GMD_QC_STATUS_TL is referenced by following:
APPS
SYNONYM - GMD_QC_STATUS_TL
[top of page]
Table: GMD_QC_TESTS_B
Primary Key: GMD_QC_TESTS_B_PK
TEST_ID
Primary Key: GMD_QC_TESTS_B_U1
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:
APPS
SYNONYM - GMD_QC_TESTS_B
[top of page]
Table: GMD_QC_TESTS_TL
Primary Key: GMD_QC_TESTS_TL_PK
TEST_ID
LANGUAGE
[top of page]
GMD.GMD_QC_TESTS_TL does not reference any database object
GMD.GMD_QC_TESTS_TL is referenced by following:
APPS
SYNONYM - 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
TEST_VALUE_ID
Primary Key: GMD_QC_TEST_VALUES_B_U1
TEST_ID
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:
APPS
SYNONYM - 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
TEST_VALUE_ID
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:
APPS
SYNONYM - GMD_QC_TEST_VALUES_TL
[top of page]
Table: GMD_QUALITY_CONFIG
Description: OPM Quality Configuration
Primary Key: GMD_QUALITY_CONFIG_PK
ORGANIZATION_ID
Primary Key: GMD_QUALITY_CONFIG_U1
ORGN_CODE
[top of page]
GMD.GMD_QUALITY_CONFIG does not reference any database object
GMD.GMD_QUALITY_CONFIG is referenced by following:
APPS
SYNONYM - GMD_QUALITY_CONFIG
[top of page]
Table: GMD_RECIPES_B
Description: Recipe header base table.
Primary Key: GMD_RECIPES_B_PK
RECIPE_ID
Primary Key: GMD_RECIPES_B_U1
RECIPE_NO
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:
APPS
TRIGGER - GMDRPTRG_UPDATE_WF
SYNONYM - GMD_RECIPES_B
[top of page]
Table: GMD_RECIPES_TL
Description: Recipe Translation Table
Primary Key: GMD_RECIPES_TL_PK
RECIPE_ID
LANGUAGE
[top of page]
GMD.GMD_RECIPES_TL does not reference any database object
GMD.GMD_RECIPES_TL is referenced by following:
APPS
SYNONYM - GMD_RECIPES_TL
[top of page]
Table: GMD_RECIPE_CUSTOMERS
Description: This table stores recipe customer data
Primary Key: GMD_RECIPE_CUSTOMERS_PK
RECIPE_ID
CUSTOMER_ID
[top of page]
GMD.GMD_RECIPE_CUSTOMERS does not reference any database object
GMD.GMD_RECIPE_CUSTOMERS is referenced by following:
APPS
SYNONYM - GMD_RECIPE_CUSTOMERS
[top of page]
Table: GMD_RECIPE_EFF_ASSOC
Description: Recipe-Effectivity Association Table
Primary Key: GMD_RECIPE_EFF_ASSOC_PK
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:
APPS
SYNONYM - GMD_RECIPE_EFF_ASSOC
[top of page]
Table: GMD_RECIPE_GENERATION
Description: Recipe Generation for automatic creation
Primary Key: GMD_RECIPE_GENERATION_PK
RECIPE_GENERATION_ID
[top of page]
GMD.GMD_RECIPE_GENERATION does not reference any database object
GMD.GMD_RECIPE_GENERATION is referenced by following:
APPS
SYNONYM - 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
RECIPE_ID
ORGN_CODE
ROUTINGSTEP_ID
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:
APPS
SYNONYM - 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
RECIPE_ID
ORGN_CODE
ROUTINGSTEP_ID
OPRN_LINE_ID
RESOURCES
[top of page]
GMD.GMD_RECIPE_ORGN_RESOURCES does not reference any database object
GMD.GMD_RECIPE_ORGN_RESOURCES is referenced by following:
APPS
SYNONYM - 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
RECIPE_PROCESS_LOSS_ID
Primary Key: GMD_RECIPE_PROCESS_LOSS_U1
RECIPE_ID
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:
APPS
SYNONYM - 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
RECIPE_ID
ORGANIZATION_ID
ROUTINGSTEP_ID
OPRN_LINE_ID
PARAMETER_ID
RESOURCES
Primary Key: GMD_RCP_PROC_PARAM_UK
OPRN_LINE_ID
ORGANIZATION_ID
PARAMETER_ID
RECIPE_ID
RESOURCES
ROUTINGSTEP_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:
APPS
SYNONYM - 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
RECIPE_ID
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:
APPS
SYNONYM - 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
RECIPE_ID
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:
APPS
SYNONYM - 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
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:
APPS
TRIGGER - GMDRVTRG_UPDATE_WF
SYNONYM - GMD_RECIPE_VALIDITY_RULES
TRIGGER - GMD_RECIPE_VALIDITY_RULES_TG
[top of page]
Table: GMD_REPLACE
Description: Used for Mass Search and Replace
Primary Key: GMD_REPLACE_PK
REQUEST_ID
[top of page]
GMD.GMD_REPLACE does not reference any database object
GMD.GMD_REPLACE is referenced by following:
APPS
SYNONYM - GMD_REPLACE
[top of page]
Table: GMD_RESULTS
Description: OPM Quality Results
Primary Key: GMD_RESULTS_PK
RESULT_ID
[top of page]
GMD.GMD_RESULTS does not reference any database object
GMD.GMD_RESULTS is referenced by following:
APPS
SYNONYM - GMD_RESULTS
[top of page]
Table: GMD_ROUTINGS_B
Description: Routing header base table.
Primary Key: GMD_ROUTINGS_B_PK
ROUTING_ID
Primary Key: GMD_ROUTINGS_B_UC1
ROUTING_NO
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:
APPS
TRIGGER - GMDRTTRG_UPDATE_WF
SYNONYM - GMD_ROUTINGS_B
[top of page]
Table: GMD_ROUTINGS_TL
Description: Routings header translations table
Primary Key: GMD_ROUTING_TL_PK
ROUTING_ID
LANGUAGE
[top of page]
GMD.GMD_ROUTINGS_TL does not reference any database object
GMD.GMD_ROUTINGS_TL is referenced by following:
APPS
SYNONYM - 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
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:
APPS
SYNONYM - 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
ROUTING_CLASS
LANGUAGE
[top of page]
GMD.GMD_ROUTING_CLASS_TL does not reference any database object
GMD.GMD_ROUTING_CLASS_TL is referenced by following:
APPS
SYNONYM - GMD_ROUTING_CLASS_TL
[top of page]
Table: GMD_SAMPLES
Description: OPM Quality Samples
Primary Key: GMD_SAMPLES_PK
SAMPLE_ID
Primary Key: GMD_SAMPLES_U1
ORGN_CODE
SAMPLE_NO
[top of page]
GMD.GMD_SAMPLES does not reference any database object
GMD.GMD_SAMPLES is referenced by following:
APPS
SYNONYM - GMD_SAMPLES
[top of page]
Table: GMD_SAMPLES_LAB
Description: OPM Quality Samples Lab
Primary Key: GMD_SAMPLES_LAB_PK
SAMPLE_ID
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:
APPS
SYNONYM - GMD_SAMPLES_LAB
[top of page]
Table: GMD_SAMPLE_REPLICATES_GT
[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
EVENT_SPEC_DISP_ID
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:
APPS
SYNONYM - GMD_SAMPLE_SPEC_DISP
[top of page]
Table: GMD_SAMPLING_EVENTS
Description: OPM Quality Sampling Event
Primary Key: GMD_SAMPLING_EVENTS_PK
SAMPLING_EVENT_ID
[top of page]
GMD.GMD_SAMPLING_EVENTS does not reference any database object
GMD.GMD_SAMPLING_EVENTS is referenced by following:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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
OBJECT_TYPE
ORGN_CODE
[top of page]
GMD.GMD_SECURITY_CONTROL does not reference any database object
GMD.GMD_SECURITY_CONTROL is referenced by following:
APPS
SYNONYM - 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
SECURITY_PROFILE_ID
Primary Key: GMD_SECURITY_PROFILES_UI1
OBJECT_TYPE
ASSIGN_METHOD_IND
ACCESS_TYPE_IND
ORGN_CODE
USER_ID
RESPONSIBILITY_ID
OTHER_ORGN
[top of page]
GMD.GMD_SECURITY_PROFILES does not reference any database object
GMD.GMD_SECURITY_PROFILES is referenced by following:
APPS
SYNONYM - GMD_SECURITY_PROFILES
[top of page]
Table: GMD_SPECIFICATIONS_B
Description: OPM Quality Specifications
Primary Key: GMD_SPECIFICATIONS_B_PK
SPEC_ID
Primary Key: GMD_SPECIFICATIONS_B_U1
SPEC_NAME
SPEC_VERS
[top of page]
GMD.GMD_SPECIFICATIONS_B does not reference any database object
GMD.GMD_SPECIFICATIONS_B is referenced by following:
APPS
SYNONYM - GMD_SPECIFICATIONS_B
[top of page]
Table: GMD_SPECIFICATIONS_TL
Description: OPM Quality Specifications Translation
Primary Key: GMD_SPECIFICATIONS_TL_PK
SPEC_ID
LANGUAGE
[top of page]
GMD.GMD_SPECIFICATIONS_TL does not reference any database object
GMD.GMD_SPECIFICATIONS_TL is referenced by following:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - GMD_SPEC_MAPPING
[top of page]
Table: GMD_SPEC_MAPPING_GTMP
[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
EVENT_SPEC_DISP_ID
RESULT_ID
[top of page]
GMD.GMD_SPEC_RESULTS does not reference any database object
GMD.GMD_SPEC_RESULTS is referenced by following:
APPS
SYNONYM - GMD_SPEC_RESULTS
[top of page]
Table: GMD_SPEC_TESTS_B
Description: OPM Specification tests
Primary Key: GMD_SPEC_TESTS_B_PK
SPEC_ID
TEST_ID
[top of page]
GMD.GMD_SPEC_TESTS_B does not reference any database object
GMD.GMD_SPEC_TESTS_B is referenced by following:
APPS
SYNONYM - GMD_SPEC_TESTS_B
[top of page]
Table: GMD_SPEC_TESTS_TL
Description: OPM Specification tests
Primary Key: GMD_SPEC_TESTS_TL_PK
SPEC_ID
TEST_ID
LANGUAGE
[top of page]
GMD.GMD_SPEC_TESTS_TL does not reference any database object
GMD.GMD_SPEC_TESTS_TL is referenced by following:
APPS
SYNONYM - GMD_SPEC_TESTS_TL
[top of page]
Table: GMD_SPREAD_ERRORS_GTMP
[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
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:
APPS
SYNONYM - 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
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:
APPS
SYNONYM - 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
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:
APPS
SYNONYM - GMD_SS_STORAGE_PACKAGE
[top of page]
Table: GMD_SS_TIME_POINTS
Description: Stability Study Time Points
Primary Key: GMD_SS_TIME_POINTS_PK
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:
APPS
SYNONYM - GMD_SS_TIME_POINTS
[top of page]
Table: GMD_SS_VARIANTS
Description: Stability Study Variants
Primary Key: GMD_SS_VARIANTS_PK
VARIANT_ID
[top of page]
GMD.GMD_SS_VARIANTS does not reference any database object
GMD.GMD_SS_VARIANTS is referenced by following:
APPS
SYNONYM - GMD_SS_VARIANTS
[top of page]
Table: GMD_STABILITY_SPEC_VRS
Description: Stability Study Validity Rules
Primary Key: GMD_STABILITY_SPEC_VRS_PK
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:
APPS
SYNONYM - GMD_STABILITY_SPEC_VRS
[top of page]
Table: GMD_STABILITY_STUDIES_B
Description: Stability Study
Primary Key: GMD_STABILITY_STUDIES_B_PK
SS_ID
Primary Key: GMD_STABILITY_STUDIES_B_U1
ORGN_CODE
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:
APPS
SYNONYM - GMD_STABILITY_STUDIES_B
[top of page]
Table: GMD_STABILITY_STUDIES_TL
Description: Stability Study Translation table
Primary Key: GMD_STABILITY_STUDIES_TL_PK
SS_ID
LANGUAGE
[top of page]
GMD.GMD_STABILITY_STUDIES_TL does not reference any database object
GMD.GMD_STABILITY_STUDIES_TL is referenced by following:
APPS
SYNONYM - GMD_STABILITY_STUDIES_TL
[top of page]
Table: GMD_STATUS_B
Description: Base table for status code definitions.
Primary Key: GMD_STATUS_B_PK
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:
APPS
SYNONYM - 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
TARGET_STATUS
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:
APPS
SYNONYM - GMD_STATUS_NEXT
[top of page]
Table: GMD_STATUS_TL
Description: Status Code Translation Table
Primary Key: GMD_STATUS_TL_PK
STATUS_CODE
LANGUAGE
[top of page]
GMD.GMD_STATUS_TL does not reference any database object
GMD.GMD_STATUS_TL is referenced by following:
APPS
SYNONYM - GMD_STATUS_TL
[top of page]
Table: GMD_STORAGE_PLANS_B
Description: Stability Study Storage Plan
Primary Key: GMD_STORAGE_PLANS_B_PK
STORAGE_PLAN_ID
Primary Key: GMD_STORAGE_PLANS_B_U1
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:
APPS
SYNONYM - 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
STORAGE_PLAN_ID
LANGUAGE
[top of page]
GMD.GMD_STORAGE_PLANS_TL does not reference any database object
GMD.GMD_STORAGE_PLANS_TL is referenced by following:
APPS
SYNONYM - 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
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:
APPS
SYNONYM - 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
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:
APPS
SYNONYM - GMD_SUPPLIER_SPEC_VRS
[top of page]
Table: GMD_TECHNICAL_DATA_DTL
Description: Technical Parameter data detail
Primary Key: GMD_TECHNICAL_DATA_DTL_PK
TECH_DATA_ID
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:
APPS
SYNONYM - GMD_TECHNICAL_DATA_DTL
TRIGGER - GMD_TECHNICAL_DATA_DTL_TG
[top of page]
Table: GMD_TECHNICAL_DATA_HDR
Description: Technical Parameter data header
Primary Key: GMD_TECHNICAL_DATA_HDR_PK
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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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
TECH_SEQ_ID
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:
APPS
SYNONYM - 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
TECH_SEQ_ID
Primary Key: GMD_TECHNICAL_SEQUENCE_HDR_UK
ORGN_CODE
ITEM_ID
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:
APPS
SYNONYM - 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
TECH_PARM_ID
Primary Key: GMD_TECH_PARAMETERS_B_UK
ORGN_CODE
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:
APPS
SYNONYM - 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
TECH_PARM_ID
LANGUAGE
[top of page]
GMD.GMD_TECH_PARAMETERS_TL does not reference any database object
GMD.GMD_TECH_PARAMETERS_TL is referenced by following:
APPS
SYNONYM - GMD_TECH_PARAMETERS_TL
[top of page]
Table: GMD_TESTS_B
Primary Key: GMD_TESTS_B_PK
QCASSY_TYP_ID
Primary Key: GMD_TESTS_B_U1
ORGN_CODE
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:
APPS
SYNONYM - GMD_TESTS_B
[top of page]
Table: GMD_TESTS_TL
Primary Key: GMD_TESTS_TL_PK
QCASSY_TYP_ID
LANGUAGE
[top of page]
GMD.GMD_TESTS_TL does not reference any database object
GMD.GMD_TESTS_TL is referenced by following:
APPS
SYNONYM - GMD_TESTS_TL
[top of page]
Table: GMD_TEST_CLASSES_B
Description: OPM Quality Test Classes
Primary Key: GMD_TEST_CLASSES_B_PK
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:
APPS
SYNONYM - 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
TEST_CLASS
LANGUAGE
[top of page]
GMD.GMD_TEST_CLASSES_TL does not reference any database object
GMD.GMD_TEST_CLASSES_TL is referenced by following:
APPS
SYNONYM - GMD_TEST_CLASSES_TL
[top of page]
Table: GMD_TEST_GROUP_GT
[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
TEST_INTERVAL_PLAN_ID
Primary Key: GMD_TEST_INTERVAL_PLANS_B_U1
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:
APPS
SYNONYM - 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
TEST_INTERVAL_PLAN_ID
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:
APPS
SYNONYM - 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
PERIOD_ID
Primary Key: GMD_TEST_INT_PLAN_PERIODS_U1
TEST_INTERVAL_PLAN_ID
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:
APPS
SYNONYM - GMD_TEST_INTERVAL_PLAN_PERIODS
[top of page]
Table: GMD_TEST_METHODS_B
Description: OPM Quality Test Methods
Primary Key: GMD_TEST_METHODS_B_PK
TEST_METHOD_ID
Primary Key: GMD_TEST_METHODS_B_U1
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:
APPS
SYNONYM - GMD_TEST_METHODS_B
[top of page]
Table: GMD_TEST_METHODS_TL
Description: OPM Quality test methods
Primary Key: GMD_TEST_METHODS_TL_PK
TEST_METHOD_ID
LANGUAGE
[top of page]
GMD.GMD_TEST_METHODS_TL does not reference any database object
GMD.GMD_TEST_METHODS_TL is referenced by following:
APPS
SYNONYM - GMD_TEST_METHODS_TL
[top of page]
Table: GMD_TEST_VALUES_B
Primary Key: GMD_TEST_VALUES_B_PK
QCASSY_VAL_ID
Primary Key: GMD_TEST_VALUES_B_U1
ORGN_CODE
ASSAY_CODE
ASSAY_VALUE
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:
APPS
SYNONYM - GMD_TEST_VALUES_B
[top of page]
Table: GMD_TEST_VALUES_TL
Primary Key: GMD_TEST_VALUES_TL_PK
QCASSY_VAL_ID
LANGUAGE
[top of page]
GMD.GMD_TEST_VALUES_TL does not reference any database object
GMD.GMD_TEST_VALUES_TL is referenced by following:
APPS
SYNONYM - GMD_TEST_VALUES_TL
[top of page]
Table: GMD_UNITS_B
Description: Units of measure for QC assays.
Primary Key: GMD_UNITS_B_PK
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:
APPS
SYNONYM - GMD_UNITS_B
[top of page]
Table: GMD_UNITS_TL
Description: QC Units Translation Table
Primary Key: GMD_UNITS_TL_PK
QCUNIT_CODE
LANGUAGE
[top of page]
GMD.GMD_UNITS_TL does not reference any database object
GMD.GMD_UNITS_TL is referenced by following:
APPS
SYNONYM - GMD_UNITS_TL
[top of page]
Table: GMD_UOM_CONVERSIONS
Description: UOM Conversions Based on Quality Results.
Primary Key: GMD_UOM_CONVERSIONS_PK
EVENT_SPEC_DISP_ID
TEST_ID
[top of page]
GMD.GMD_UOM_CONVERSIONS does not reference any database object
GMD.GMD_UOM_CONVERSIONS is referenced by following:
APPS
SYNONYM - GMD_UOM_CONVERSIONS
[top of page]
Table: GMD_VAL_RULE_GTMP
[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
ACTIVE_FORMULA_IND
[top of page]
GMD.GMD_VPD_SECURITY does not reference any database object
GMD.GMD_VPD_SECURITY is referenced by following:
APPS
SYNONYM - 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
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:
APPS
SYNONYM - 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
LAB_TYPE
FORMULALINE_ID
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:
APPS
SYNONYM - 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
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:
APPS
SYNONYM - 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
FORMULA_ID
Primary Key: LM_FORM_MST_U1
FORMULA_NO
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:
APPS
SYNONYM - LM_FORM_MST
[top of page]
Table: LM_LTYP_MST
Description: Laboratory type master
Primary Key: LM_LTYP_MST_PK
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:
APPS
SYNONYM - LM_LTYP_MST
[top of page]
Table: LM_SPRD_DTL
Description: Table to store Lab Spreadsheet detail
Primary Key: LM_SPRD_DTL_PK
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:
APPS
SYNONYM - LM_SPRD_DTL
[top of page]
Table: LM_SPRD_FLS
Description: Laboratory Spreadsheets files
Primary Key: LM_SPRD_FLS_PK
SPRD_ID
Primary Key: LM_SPRD_FLS_U1
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:
APPS
SYNONYM - 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
SPRD_ID
LAB_TYPE
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:
APPS
SYNONYM - 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
LINE_ID
LAB_TYPE
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:
APPS
SYNONYM - LM_SPRD_TEC
[top of page]
Table: LM_TECH_DTL
Description: Valid values for technical parameters
Primary Key: LM_TECH_DTL_PK
TECH_PARM_ID
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:
APPS
SYNONYM - LM_TECH_DTL
[top of page]
Table: LM_TEXT_HDR
Description: Holds text types defined for Lab module
Primary Key: LM_TEXT_HDR_PK
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:
APPS
SYNONYM - 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
TEXT_CODE
LANG_CODE
PARAGRAPH_CODE
SUB_PARACODE
LINE_NO
LANGUAGE
[top of page]
GMD.LM_TEXT_TBL_TL does not reference any database object
GMD.LM_TEXT_TBL_TL is referenced by following:
APPS
SYNONYM - LM_TEXT_TBL_TL
[top of page]
Table: QC_ACTN_MST
Description: QC action codes.
Primary Key: QC_ACTN_MST_PK
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:
APPS
SYNONYM - QC_ACTN_MST
[top of page]
Table: QC_HRES_MST
Description: QC hold reason code master.
Primary Key: QC_HRES_MST_PK
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:
APPS
SYNONYM - QC_HRES_MST
[top of page]
Table: QC_RSLT_MST
Description: QC results master.
Primary Key: QC_RSLT_MST_PK
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:
APPS
SYNONYM - QC_RSLT_MST
[top of page]
Table: QC_SMPL_MST
Description: QC sample master.
Primary Key: QC_SMPL_MST_PK
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:
APPS
SYNONYM - QC_SMPL_MST
[top of page]
Table: QC_SPEC_MST
Description: QC specification master.
Primary Key: QC_SPEC_MST_PK
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:
APPS
SYNONYM - QC_SPEC_MST
[top of page]
Table: QC_TEXT_HDR
Description: Holds text types defined for QC module
Primary Key: QC_TEXT_HDR_PK
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:
APPS
SYNONYM - 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
TEXT_CODE
LANG_CODE
PARAGRAPH_CODE
SUB_PARACODE
LINE_NO
LANGUAGE
[top of page]
GMD.QC_TEXT_TBL_TL does not reference any database object
GMD.QC_TEXT_TBL_TL is referenced by following:
APPS
SYNONYM - QC_TEXT_TBL_TL
[top of page]
View: FM_FORM_EFF_VW1
[top of page]
APPS.FM_FORM_EFF_VW1 references the following:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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
TRIGGER - FM_FORM_MST_IL
TRIGGER - FM_FORM_MST_UL
VIEW - GMD_MBR_RECIPE_HEADER_V1
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 referenced by following:
APPS
SYNONYM - FM_OPRN_DTL
[top of page]
View: FM_OPRN_MST_VW1
[top of page]
APPS.FM_OPRN_MST_VW1 references the following:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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 referenced by following:
APPS
SYNONYM - FM_TEXT_TBL
TRIGGER - GMA_FM_TEXT_TBL_T1
TRIGGER - GMA_FM_TEXT_TBL_T2
TRIGGER - GMA_FM_TEXT_TBL_T3
PACKAGE BODY - GMD_RECIPE_DESIGNER_PKG
[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 referenced by following:
APPS
SYNONYM - GMD_ACTIONS
[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
SYNONYM - GMD_ACTIVITIES
TRIGGER - GMD_ACTIVITIES_DL
TRIGGER - GMD_ACTIVITIES_IL
TRIGGER - GMD_ACTIVITIES_UL
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
PACKAGE BODY - GMD_QM_CONC_REPLACE_PKG
[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 referenced by following:
APPS
PACKAGE BODY - GMD_COA_DATA_OM_NEW
PACKAGE BODY - GMD_QMSED
PACKAGE BODY - GMD_QMSMC
PACKAGE BODY - GMD_RESULTS_GRP
[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 referenced by following:
APPS
SYNONYM - GMD_CUSTOMER_TESTS
[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 - OP_CUST_MST
SYNONYM - PO_VEND_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
VIEW - HR_OPERATING_UNITS
SYNONYM - HZ_CUST_ACCOUNTS_ALL
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_PARTIES
VIEW - PO_VENDORS
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
SYNONYM - MTL_SYSTEM_ITEMS_KFV
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_RECIPES
SYNONYM - GMD_ROUTINGS
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 referenced by following:
APPS
SYNONYM - FM_FORM_CLS
SYNONYM - GMD_FORMULA_CLASS
TRIGGER - GMD_FORMULA_CLASS_DL
TRIGGER - GMD_FORMULA_CLASS_IL
TRIGGER - GMD_FORMULA_CLASS_UL
[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
SYNONYM - GMD_GRADES
TRIGGER - GMD_GRADES_DL
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
SYNONYM - GMD_HOLD_REASONS
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 referenced by following:
APPS
SYNONYM - GMD_ITEM_SUBSTITUTION_HDR
PACKAGE BODY - GMD_VERSION_CONTROL
[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
PACKAGE BODY - GMDFMVAL_PUB
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
VIEW - 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
VIEW - 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
PACKAGE BODY - GMD_FETCH_OPRN
SYNONYM - GMD_OPERATIONS
TRIGGER - GMD_OPERATIONS_DL
TRIGGER - GMD_OPERATIONS_IL
TRIGGER - GMD_OPERATIONS_UL
PACKAGE - GMD_RECIPE_FETCH_PUB
PACKAGE BODY - GMD_RECIPE_FETCH_PUB
PACKAGE BODY - GMD_SEARCH_REPLACE_VERS
PACKAGE BODY - GMD_STATUS_CODE
PACKAGE BODY - GMD_VERSION_CONTROL
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 referenced by following:
APPS
SYNONYM - FM_OPRN_CLS
SYNONYM - GMD_OPERATION_CLASS
TRIGGER - GMD_OPERATION_CLASS_DL
TRIGGER - GMD_OPERATION_CLASS_IL
TRIGGER - GMD_OPERATION_CLASS_UL
[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 referenced by following:
APPS
PACKAGE BODY - GMD_FETCH_OPRN
PACKAGE BODY - GMD_VERSION_CONTROL
[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
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
SYNONYM - MTL_PARAMETERS
SYNONYM - ORG_ACCESS
APPS.GMD_ORG_ACCESS_VW is referenced by following:
APPS
PACKAGE BODY - GMD_SPEC_VRS_GRP
[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
VIEW - HR_OPERATING_UNITS
SYNONYM - HZ_CUST_ACCOUNTS_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_PARTIES
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OE_ORDER_LINES_ALL
SYNONYM - OE_TRANSACTION_TYPES
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
VIEW - HR_OPERATING_UNITS
SYNONYM - HZ_CUST_ACCOUNTS_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_PARTIES
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OE_ORDER_LINES_ALL
SYNONYM - OE_TRANSACTION_TYPES
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
SYNONYM - GMD_SAMPLES
VIEW - HR_OPERATING_UNITS
SYNONYM - MTL_PARAMETERS
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES_ALL
VIEW - PO_VENDORS
VIEW - PO_VENDOR_SITES_ALL
SYNONYM - RCV_SHIPMENT_HEADERS
SYNONYM - RCV_SHIPMENT_LINES
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
SYNONYM - GMD_SAMPLING_EVENTS
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES_ALL
VIEW - PO_VENDORS
VIEW - PO_VENDOR_SITES_ALL
SYNONYM - RCV_SHIPMENT_HEADERS
SYNONYM - RCV_SHIPMENT_LINES
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 referenced by following:
APPS
PACKAGE BODY - GMD_QC_LABELS_UTIL
[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
PACKAGE BODY - GMD_QMTES
PACKAGE BODY - GMD_SAMPLES_GRP
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
VIEW - MTL_ITEM_LOCATIONS_KFV
SYNONYM - MTL_PARAMETERS
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
SYNONYM - 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_SPECIFICATIONS
SYNONYM - GMD_SS_TIME_POINTS
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 - 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
PACKAGE BODY - GMD_ERES_UTILS
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 referenced by following:
APPS
SYNONYM - FM_ROUT_CLS
SYNONYM - GMD_ROUTING_CLASS
[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 referenced by following:
APPS
SYNONYM - GMD_SAMPLING_PLANS
[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
VIEW - 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
PUBLIC
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 referenced by following:
APPS
SYNONYM - GMD_STORAGE_PLANS
PUBLIC
SYNONYM - GMD_STORAGE_PLANS
[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
PACKAGE BODY - GMD_LABUOM_CALCULATE_PKG
PACKAGE BODY - GMD_LCF_FETCH_PKG
PACKAGE BODY - GMD_SPREAD_FETCH_PKG
TRIGGER - INSTEAD_OF_UPDATE
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 referenced by following:
APPS
PACKAGE BODY - GMD_SPREAD_FETCH_PKG
SYNONYM - LM_PRLT_ASC
[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 referenced by following:
APPS
SYNONYM - GMD_TECH_PARAMETERS
SYNONYM - LM_TECH_HDR
[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 - GMD_TESTS
TRIGGER - GMD_TESTS_DL
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
SYNONYM - GMD_TEST_CLASSES
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 referenced by following:
APPS
SYNONYM - GMD_TEST_INTERVAL_PLANS
PUBLIC
SYNONYM - GMD_TEST_INTERVAL_PLANS
[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 - GMD_TEST_VALUES
TRIGGER - GMD_TEST_VALUES_DL
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 referenced by following:
APPS
SYNONYM - GMD_UNITS
TRIGGER - GMD_UNITS_DL
SYNONYM - QC_UNIT_MST
[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 referenced by following:
APPS
TRIGGER - GMA_LM_TEXT_TBL_T1
TRIGGER - GMA_LM_TEXT_TBL_T2
TRIGGER - GMA_LM_TEXT_TBL_T3
SYNONYM - LM_TEXT_TBL
[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 referenced by following:
APPS
TRIGGER - GMA_QC_TEXT_TBL_T1
TRIGGER - GMA_QC_TEXT_TBL_T2
TRIGGER - GMA_QC_TEXT_TBL_T3
SYNONYM - QC_TEXT_TBL
[top of page]
View: QC_TRAN_VW1
[top of page]
APPS.QC_TRAN_VW1 references the following:
APPS
SYNONYM - IC_TRAN_PND
VIEW - IC_TRAN_VW1
SYNONYM - PM_BTCH_HDR
SYNONYM - PM_MATL_DTL
SYNONYM - PO_RECV_DTL
SYNONYM - PO_RECV_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
VIEW - IC_TRAN_VW1
SYNONYM - OP_ORDR_DTL
SYNONYM - OP_ORDR_HDR
SYNONYM - PM_BTCH_HDR
SYNONYM - PM_MATL_DTL
APPS.QC_TRAN_VW2 is not referenced by any database object
[top of page]