Oracle eBusiness Suite Technical Reference

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

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

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

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

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - GMP Tables and Views

TABLE - GMP.CR_ARES_MST
TABLE - GMP.CR_DOPR_TBL
TABLE - GMP.CR_GLED_CLS
TABLE - GMP.CR_RSRC_CLS_B
TABLE - GMP.CR_RSRC_CLS_TL
TABLE - GMP.CR_RSRC_DTL
TABLE - GMP.CR_RSRC_MST_B
TABLE - GMP.CR_RSRC_MST_TL
TABLE - GMP.CR_SQDS_TBL
TABLE - GMP.CR_TEXT_HDR
TABLE - GMP.CR_TEXT_TBL_TL
TABLE - GMP.FC_FCST_DTL
TABLE - GMP.FC_FCST_HDR
TABLE - GMP.FC_TEXT_HDR
TABLE - GMP.FC_TEXT_TBL_TL
TABLE - GMP.GMP_ALTRESOURCE_PRODUCTS
TABLE - GMP.GMP_APS_OUTPUT_DTL
TABLE - GMP.GMP_APS_OUTPUT_TBL
TABLE - GMP.GMP_BUCKETED_XML_TEMP
TABLE - GMP.GMP_CALENDAR_DETAIL_GTMP
TABLE - GMP.GMP_DEMANDS_API
TABLE - GMP.GMP_FORM_EFF
TABLE - GMP.GMP_HORIZONTAL_PDR_GTMP
TABLE - GMP.GMP_ITEM_APS
TABLE - GMP.GMP_ITEM_WPS
TABLE - GMP.GMP_PARAMETER_VALUES_B
TABLE - GMP.GMP_PARAMETER_VALUES_TL
TABLE - GMP.GMP_PDR_ITEMS_GTMP
TABLE - GMP.GMP_PDR_XML_TEMP
TABLE - GMP.GMP_PLANT_RSRC_PARAMETERS
TABLE - GMP.GMP_PROCESS_DTL_APS
TABLE - GMP.GMP_PROCESS_HDR_APS
TABLE - GMP.GMP_PROCESS_MSG_APS
TABLE - GMP.GMP_PROCESS_PARAMETERS_B
TABLE - GMP.GMP_PROCESS_PARAMETERS_TL
TABLE - GMP.GMP_PROCESS_PARAMETER_SETS
TABLE - GMP.GMP_PROCESS_PARAMETER_SET_B
TABLE - GMP.GMP_PROCESS_PARAMETER_SET_TL
TABLE - GMP.GMP_PROCESS_TYP_APS
TABLE - GMP.GMP_RESDISP_XML_TEMP
TABLE - GMP.GMP_RESOURCE_AVAIL
TABLE - GMP.GMP_RESOURCE_DEVICES
TABLE - GMP.GMP_RESOURCE_DEVICE_MESSAGES
TABLE - GMP.GMP_RESOURCE_EQUIPMENTS
TABLE - GMP.GMP_RESOURCE_INSTANCES
TABLE - GMP.GMP_RESOURCE_PARAMETERS
TABLE - GMP.GMP_ROUTING_OFFSETS
TABLE - GMP.GMP_RSRC_EXCP_ASNMT
TABLE - GMP.GMP_RSRC_EXCP_DTL
TABLE - GMP.GMP_RSRC_EXCP_HDR
TABLE - GMP.GMP_RSRC_UNAVAIL_MAN
TABLE - GMP.GMP_SEQUENCE_DEPENDENCIES
TABLE - GMP.GMP_SEQUENCE_TYPES
TABLE - GMP.GMP_UNBUCKETED_XML_TEMP
TABLE - GMP.MR_ACTN_TBL
TABLE - GMP.MR_MESG_TBL
TABLE - GMP.MR_PARM_DTL
TABLE - GMP.MR_PEGG_TBL
TABLE - GMP.MR_SHCL_DTL
TABLE - GMP.MR_SHCL_HDR
TABLE - GMP.MR_SHDY_DTL
TABLE - GMP.MR_SHDY_HDR
TABLE - GMP.MR_SIZE_TBL
TABLE - GMP.MR_TEXT_HDR
TABLE - GMP.MR_TEXT_TBL_TL
TABLE - GMP.MR_TRAN_TBL
TABLE - GMP.MR_UBKT_DTL
TABLE - GMP.PS_MATL_DTL
TABLE - GMP.PS_MATL_HDR
TABLE - GMP.PS_OPER_PCL
TABLE - GMP.PS_SCHD_DTL
TABLE - GMP.PS_SCHD_FOR
TABLE - GMP.PS_SCHD_HDR
TABLE - GMP.PS_TEXT_HDR
TABLE - GMP.PS_TEXT_TBL_TL
TABLE - GMP.PS_UBKT_DTL
TABLE - GMP.PS_WHSE_EFF
TABLE - GMP.RH_ACTN_TBL
TABLE - GMP.RH_DORD_IMP
TABLE - GMP.RH_EXPT_DTL
TABLE - GMP.RH_EXPT_MST
TABLE - GMP.RH_IMPT_DTL
TABLE - GMP.RH_IMPT_MST
TABLE - GMP.RH_MESG_TBL
TABLE - GMP.RH_MORD_IMP
TABLE - GMP.RH_PARM_TBL
TABLE - GMP.RH_PARM_TYP
TABLE - GMP.RH_RSCL_TBL
VIEW - APPS.CR_RSRC_CLS_VL
VIEW - APPS.CR_RSRC_DTL_VW1
VIEW - APPS.CR_RSRC_DTL_VW2
VIEW - APPS.CR_RSRC_MST_VL
VIEW - APPS.CR_SQDS_TBL_V
VIEW - APPS.CR_SQDT_CLS_VW
VIEW - APPS.CR_TEXT_TBL_VL
VIEW - APPS.FC_TEXT_TBL_VL
VIEW - APPS.GMP_EAM_EQUIP_RESOURCES_V
VIEW - APPS.GMP_EAM_JOBS_RESOURCES_V
VIEW - APPS.GMP_MFG_TIME_WEEKS_V
VIEW - APPS.GMP_NETTABLE_ONHANDS_V
VIEW - APPS.GMP_PARAMETER_VALUES_VL
VIEW - APPS.GMP_PDR_BUYER_V
VIEW - APPS.GMP_PDR_CATEGORY_V
VIEW - APPS.GMP_PLAN_ORGANIZATION_V
VIEW - APPS.GMP_PROCESS_PARAMETERS_VL
VIEW - APPS.GMP_PROCESS_PARAMETER_SET_VL
VIEW - APPS.GMP_RESOURCE_AVAIL_V
VIEW - APPS.GMP_RSRC_CAL_V
VIEW - APPS.GMP_RSRC_UNAVAIL_DTL_V
VIEW - APPS.GMP_SCHEDULING_EXCEPTIONS_V
VIEW - APPS.GMP_SR_BG_ALL_V
VIEW - APPS.GMP_SR_BOOKING_DATA_V
VIEW - APPS.GMP_SR_LE_BG_V
VIEW - APPS.GMP_SR_MFG_FCST_V
VIEW - APPS.GMP_SR_MFG_TIME_V
VIEW - APPS.GMP_SR_ORG_OU_V
VIEW - APPS.GMP_SR_OU_LE_V
VIEW - APPS.GMP_SR_SHIPMENT_DATA_V
VIEW - APPS.MR_TEXT_TBL_VL
VIEW - APPS.PS_PLNG_CLS_VW
VIEW - APPS.PS_TEXT_TBL_VL

Table: CR_ARES_MST

Description: Alternate resource table
Primary Key: CR_ARES_MST_PK
  1. PRIMARY_RESOURCE
  2. ALTERNATE_RESOURCE
Foreign Keys from this table:
Foreign Key Column Foreign Table
CR_ARES_MST.PRIMARY_RESOURCE CR_RSRC_MST_B
CR_ARES_MST.ALTERNATE_RESOURCE CR_RSRC_MST_B
CR_ARES_MST.PRIMARY_RESOURCE CR_RSRC_MST
CR_ARES_MST.ALTERNATE_RESOURCE CR_RSRC_MST
CR_ARES_MST.TEXT_CODE CR_TEXT_HDR

[top of page]

GMP.CR_ARES_MST does not reference any database object

GMP.CR_ARES_MST is referenced by following:

GMP
VIEW - CR_ARES_MST#

[top of page]

Table: CR_DOPR_TBL

Description: Demand order priority table. Allows priority to be set on Demand Orders
Primary Key: CR_DOPR_TBL_PK
  1. LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CR_DOPR_TBL.LINE_ID OP_ORDR_DTL

[top of page]

GMP.CR_DOPR_TBL does not reference any database object

GMP.CR_DOPR_TBL is referenced by following:

GMP
VIEW - CR_DOPR_TBL#

[top of page]

Table: CR_GLED_CLS

Description: Capacity G/L Class Code Descriptions
Primary Key: CR_GLED_CLS_PK
  1. CRGL_CLASS
Foreign Keys from this table:
Foreign Key Column Foreign Table
CR_GLED_CLS.TEXT_CODE CR_TEXT_HDR

[top of page]

GMP.CR_GLED_CLS does not reference any database object

GMP.CR_GLED_CLS is referenced by following:

GMP
VIEW - CR_GLED_CLS#

[top of page]

Table: CR_RSRC_CLS_B

Description: Resource class
Primary Key: CR_RSRC_CLS_B_PK
  1. RESOURCE_CLASS
Foreign Keys from this table:
Foreign Key Column Foreign Table
CR_RSRC_CLS_B.TEXT_CODE CR_TEXT_HDR
Foreign Keys to this table:
Foreign Key Column Foreign Table
CR_RSRC_MST_B.RESOURCE_CLASS CR_RSRC_CLS_B

[top of page]

GMP.CR_RSRC_CLS_B does not reference any database object

GMP.CR_RSRC_CLS_B is referenced by following:

GMP
VIEW - CR_RSRC_CLS_B#

[top of page]

Table: CR_RSRC_CLS_TL

Description: Resource Master for MRP

[top of page]

GMP.CR_RSRC_CLS_TL does not reference any database object

GMP.CR_RSRC_CLS_TL is referenced by following:

GMP
VIEW - CR_RSRC_CLS_TL#

[top of page]

Table: CR_RSRC_DTL

Description: Plant-specific resource information
Primary Key: CR_RSRC_DTL_I1
  1. ORGN_CODE
  2. RESOURCES
Primary Key: CR_RSRC_DTL_PK
  1. RESOURCE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CR_RSRC_DTL.RESOURCES CR_RSRC_MST_B
CR_RSRC_DTL.GROUP_RESOURCE CR_RSRC_MST_B
CR_RSRC_DTL.RESOURCES CR_RSRC_MST
CR_RSRC_DTL.GROUP_RESOURCE CR_RSRC_MST
CR_RSRC_DTL.TEXT_CODE CR_TEXT_HDR
CR_RSRC_DTL.ORGN_CODE SY_ORGN_MST_B
CR_RSRC_DTL.ORGN_CODE SY_ORGN_MST
CR_RSRC_DTL.USAGE_UM SY_UOMS_MST
Foreign Keys to this table:
Foreign Key Column Foreign Table
GMP_PLANT_RSRC_PARAMETERS.RESOURCE_ID CR_RSRC_DTL
GMP_RSRC_EXCP_ASNMT.RESOURCE_ID CR_RSRC_DTL
GMP_RSRC_UNAVAIL_MAN.RESOURCE_ID CR_RSRC_DTL

[top of page]

GMP.CR_RSRC_DTL does not reference any database object

GMP.CR_RSRC_DTL is referenced by following:

GMP
VIEW - CR_RSRC_DTL#

[top of page]

Table: CR_RSRC_MST_B

Description: Resource master
Primary Key: CR_RSRC_MST_B_PK
  1. RESOURCES
Foreign Keys from this table:
Foreign Key Column Foreign Table
CR_RSRC_MST_B.COST_CMPNTCLS_ID CM_CMPT_MST_B
CR_RSRC_MST_B.RESOURCE_CLASS CR_RSRC_CLS_B
CR_RSRC_MST_B.TEXT_CODE CR_TEXT_HDR
Foreign Keys to this table:
Foreign Key Column Foreign Table
CM_BRDN_DTL.RESOURCES CR_RSRC_MST_B
CM_RSRC_DTL.RESOURCES CR_RSRC_MST_B
CM_SCST_LED.RESOURCES CR_RSRC_MST_B
CR_ARES_MST.PRIMARY_RESOURCE CR_RSRC_MST_B
CR_ARES_MST.ALTERNATE_RESOURCE CR_RSRC_MST_B
CR_RSRC_DTL.RESOURCES CR_RSRC_MST_B
CR_RSRC_DTL.GROUP_RESOURCE CR_RSRC_MST_B
FM_ARES_MST.PRIMARY_RESOURCE CR_RSRC_MST_B
FM_ARES_MST.ALTERNATE_RESOURCE CR_RSRC_MST_B
GL_ACCT_MAP.RESOURCES CR_RSRC_MST_B
GMP_RESOURCE_PARAMETERS.RESOURCES CR_RSRC_MST_B

[top of page]

GMP.CR_RSRC_MST_B does not reference any database object

GMP.CR_RSRC_MST_B is referenced by following:

GMP
VIEW - CR_RSRC_MST_B#

[top of page]

Table: CR_RSRC_MST_TL

Description: Resource Master for MRP

[top of page]

GMP.CR_RSRC_MST_TL does not reference any database object

GMP.CR_RSRC_MST_TL is referenced by following:

GMP
VIEW - CR_RSRC_MST_TL#

[top of page]

Table: CR_SQDS_TBL

Description: Sequence-dependent setup
Primary Key: CR_SQDS_TBL_PK
  1. OPRN_ID
  2. TO_ITEM_ID
  3. FROM_ITEM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CR_SQDS_TBL.FROM_ITEM_CLASS CR_SQDT_CLS
CR_SQDS_TBL.TO_ITEM_CLASS CR_SQDT_CLS
CR_SQDS_TBL.TEXT_CODE CR_TEXT_HDR
CR_SQDS_TBL.OPRN_ID FM_OPRN_MST
CR_SQDS_TBL.FROM_ITEM_ID IC_ITEM_MST_B
CR_SQDS_TBL.TO_ITEM_ID IC_ITEM_MST_B
CR_SQDS_TBL.FROM_ITEM_ID IC_ITEM_MST
CR_SQDS_TBL.TO_ITEM_ID IC_ITEM_MST

[top of page]

GMP.CR_SQDS_TBL does not reference any database object

GMP.CR_SQDS_TBL is referenced by following:

GMP
VIEW - CR_SQDS_TBL#

[top of page]

Table: CR_TEXT_HDR

Description: Table used to store text types for Capacity
Primary Key: CR_TEXT_HDR_PK
  1. TEXT_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
CR_ARES_MST.TEXT_CODE CR_TEXT_HDR
CR_GLED_CLS.TEXT_CODE CR_TEXT_HDR
CR_RSRC_CLS_B.TEXT_CODE CR_TEXT_HDR
CR_RSRC_CLS.TEXT_CODE CR_TEXT_HDR
CR_RSRC_DTL.TEXT_CODE CR_TEXT_HDR
CR_RSRC_MST_B.TEXT_CODE CR_TEXT_HDR
CR_RSRC_MST.TEXT_CODE CR_TEXT_HDR
CR_SQDS_TBL.TEXT_CODE CR_TEXT_HDR
CR_SQDT_CLS.TEXT_CODE CR_TEXT_HDR

[top of page]

GMP.CR_TEXT_HDR does not reference any database object

GMP.CR_TEXT_HDR is referenced by following:

GMP
VIEW - CR_TEXT_HDR#

[top of page]

Table: CR_TEXT_TBL_TL

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

[top of page]

GMP.CR_TEXT_TBL_TL does not reference any database object

GMP.CR_TEXT_TBL_TL is referenced by following:

GMP
VIEW - CR_TEXT_TBL_TL#

[top of page]

Table: FC_FCST_DTL

Description: Forecast detail
Primary Key: FC_FCST_DTL_PK
  1. LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FC_FCST_DTL.FORECAST_ID FC_FCST_HDR
FC_FCST_DTL.TEXT_CODE FC_TEXT_HDR
FC_FCST_DTL.ITEM_ID IC_ITEM_MST_B
FC_FCST_DTL.ITEM_ID IC_ITEM_MST
FC_FCST_DTL.WHSE_CODE IC_WHSE_MST
FC_FCST_DTL.ORGN_CODE SY_ORGN_MST_B
FC_FCST_DTL.ORGN_CODE SY_ORGN_MST

[top of page]

GMP.FC_FCST_DTL does not reference any database object

GMP.FC_FCST_DTL is referenced by following:

GMP
VIEW - FC_FCST_DTL#

[top of page]

Table: FC_FCST_HDR

Description: Forecast header
Primary Key: FC_FCST_HDR_PK
  1. FORECAST_ID
Primary Key: FC_FCST_HDR_U1
  1. FORECAST
Foreign Keys from this table:
Foreign Key Column Foreign Table
FC_FCST_HDR.TEXT_CODE FC_TEXT_HDR
Foreign Keys to this table:
Foreign Key Column Foreign Table
FC_FCST_DTL.FORECAST_ID FC_FCST_HDR
PS_SCHD_FOR.FORECAST_ID FC_FCST_HDR

[top of page]

GMP.FC_FCST_HDR does not reference any database object

GMP.FC_FCST_HDR is referenced by following:

GMP
VIEW - FC_FCST_HDR#

[top of page]

Table: FC_TEXT_HDR

Description: Table used to store text types for Forecasting.
Primary Key: FC_TEXT_HDR_PK
  1. TEXT_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
FC_FCST_DTL.TEXT_CODE FC_TEXT_HDR
FC_FCST_HDR.TEXT_CODE FC_TEXT_HDR
PS_SCHD_FOR.TEXT_CODE FC_TEXT_HDR

[top of page]

GMP.FC_TEXT_HDR does not reference any database object

GMP.FC_TEXT_HDR is referenced by following:

GMP
VIEW - FC_TEXT_HDR#

[top of page]

Table: FC_TEXT_TBL_TL

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

[top of page]

GMP.FC_TEXT_TBL_TL does not reference any database object

GMP.FC_TEXT_TBL_TL is referenced by following:

GMP
VIEW - FC_TEXT_TBL_TL#

[top of page]

Table: GMP_ALTRESOURCE_PRODUCTS

Description: Product specific alternate resources are stored in this table
Primary Key: GMP_ALTRESOURCE_PRODUCTS_U1
  1. PRIMARY_RESOURCE
  2. ALTERNATE_RESOURCE
  3. INVENTORY_ITEM_ID
  4. ITEM_ID

[top of page]

GMP.GMP_ALTRESOURCE_PRODUCTS does not reference any database object

GMP.GMP_ALTRESOURCE_PRODUCTS is referenced by following:

GMP
VIEW - GMP_ALTRESOURCE_PRODUCTS#

[top of page]

Table: GMP_APS_OUTPUT_DTL

Description: APS Output Detail table

[top of page]

GMP.GMP_APS_OUTPUT_DTL does not reference any database object

GMP.GMP_APS_OUTPUT_DTL is referenced by following:

GMP
VIEW - GMP_APS_OUTPUT_DTL#

[top of page]

Table: GMP_APS_OUTPUT_TBL

Description: Temp table for APS Output

[top of page]

GMP.GMP_APS_OUTPUT_TBL does not reference any database object

GMP.GMP_APS_OUTPUT_TBL is referenced by following:

GMP
VIEW - GMP_APS_OUTPUT_TBL#

[top of page]

Table: GMP_BUCKETED_XML_TEMP

Description:

[top of page]

GMP.GMP_BUCKETED_XML_TEMP does not reference any database object

GMP.GMP_BUCKETED_XML_TEMP is referenced by following:

GMP
VIEW - GMP_BUCKETED_XML_TEMP#

[top of page]

Table: GMP_CALENDAR_DETAIL_GTMP

Description:

[top of page]

GMP.GMP_CALENDAR_DETAIL_GTMP does not reference any database object

GMP.GMP_CALENDAR_DETAIL_GTMP is referenced by following:

APPS
SYNONYM - GMP_CALENDAR_DETAIL_GTMP

[top of page]

Table: GMP_DEMANDS_API

Description: API table for Sales and Forecast Demands

[top of page]

GMP.GMP_DEMANDS_API does not reference any database object

GMP.GMP_DEMANDS_API is referenced by following:

GMP
VIEW - GMP_DEMANDS_API#

[top of page]

Table: GMP_FORM_EFF

Description: Formula Effectivity Mapping Table
Primary Key: GMP_FORM_EFF_PK
  1. APS_FMEFF_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMP_FORM_EFF.FMEFF_ID FM_FORM_EFF
GMP_FORM_EFF.FORMULA_ID FM_FORM_MST
GMP_FORM_EFF.ROUTING_ID GMD_ROUTINGS_B
GMP_FORM_EFF.WHSE_CODE IC_WHSE_MST
GMP_FORM_EFF.ROUTING_ID FM_ROUT_HDR
GMP_FORM_EFF.PLANT_CODE SY_ORGN_MST_B
GMP_FORM_EFF.PLANT_CODE SY_ORGN_MST

[top of page]

GMP.GMP_FORM_EFF does not reference any database object

GMP.GMP_FORM_EFF is referenced by following:

GMP
VIEW - GMP_FORM_EFF#

[top of page]

Table: GMP_HORIZONTAL_PDR_GTMP

Description:

[top of page]

GMP.GMP_HORIZONTAL_PDR_GTMP does not reference any database object

GMP.GMP_HORIZONTAL_PDR_GTMP is referenced by following:

APPS
SYNONYM - GMP_HORIZONTAL_PDR_GTMP

[top of page]

Table: GMP_ITEM_APS

Description: Item Master Table for APS
Primary Key: GMP_ITEM_APS_PK
  1. ITEM_ID
  2. WHSE_CODE
  3. PLANT_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMP_ITEM_APS.ITEM_ID IC_ITEM_MST_B
GMP_ITEM_APS.ITEM_NO IC_ITEM_MST_B
GMP_ITEM_APS.ITEM_ID IC_ITEM_MST
GMP_ITEM_APS.ITEM_NO IC_ITEM_MST
GMP_ITEM_APS.WHSE_CODE IC_WHSE_MST
GMP_ITEM_APS.PLANT_CODE SY_ORGN_MST_B
GMP_ITEM_APS.PLANT_CODE SY_ORGN_MST
GMP_ITEM_APS.ITEM_UM SY_UOMS_MST

[top of page]

GMP.GMP_ITEM_APS does not reference any database object

GMP.GMP_ITEM_APS is referenced by following:

GMP
VIEW - GMP_ITEM_APS#

[top of page]

Table: GMP_ITEM_WPS

Description: Table for OPM Items Scheduling in WPS
Primary Key: GMP_ITEM_WPS_PK
  1. ITEM_ID
  2. WHSE_CODE
  3. PLANT_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMP_ITEM_WPS.ITEM_ID IC_ITEM_MST_B
GMP_ITEM_WPS.ITEM_NO IC_ITEM_MST_B
GMP_ITEM_WPS.WHSE_CODE IC_WHSE_MST
GMP_ITEM_WPS.PLANT_CODE SY_ORGN_MST_B

[top of page]

GMP.GMP_ITEM_WPS does not reference any database object

GMP.GMP_ITEM_WPS is referenced by following:

GMP
VIEW - GMP_ITEM_WPS#

[top of page]

Table: GMP_PARAMETER_VALUES_B

Description: Process Parameter values
Primary Key: GMP_PARAM_VALUES_B_PK
  1. PARAMETER_ID
  2. PARAMETER_VALUE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMP_PARAMETER_VALUES_B.PARAMETER_ID GMP_PROCESS_PARAMETERS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
GMP_PARAMETER_VALUES_TL.PARAMETER_ID
GMP_PARAMETER_VALUES_TL.PARAMETER_VALUE 		GMP_PARAMETER_VALUES_B

[top of page]

GMP.GMP_PARAMETER_VALUES_B does not reference any database object

GMP.GMP_PARAMETER_VALUES_B is referenced by following:

GMP
VIEW - GMP_PARAMETER_VALUES_B#

[top of page]

Table: GMP_PARAMETER_VALUES_TL

Description: Process Parameter values Translation table
Primary Key: GMP_PARAM_VALUES_TL_PK
  1. PARAMETER_ID
  2. PARAMETER_VALUE
  3. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMP_PARAMETER_VALUES_TL.PARAMETER_ID
GMP_PARAMETER_VALUES_TL.PARAMETER_VALUE 		GMP_PARAMETER_VALUES_B

[top of page]

GMP.GMP_PARAMETER_VALUES_TL does not reference any database object

GMP.GMP_PARAMETER_VALUES_TL is referenced by following:

GMP
VIEW - GMP_PARAMETER_VALUES_TL#

[top of page]

Table: GMP_PDR_ITEMS_GTMP

Description:

[top of page]

GMP.GMP_PDR_ITEMS_GTMP does not reference any database object

GMP.GMP_PDR_ITEMS_GTMP is referenced by following:

APPS
SYNONYM - GMP_PDR_ITEMS_GTMP

[top of page]

Table: GMP_PDR_XML_TEMP

Description: Table used to store XML generated for Planning Detail Report.

[top of page]

GMP.GMP_PDR_XML_TEMP does not reference any database object

GMP.GMP_PDR_XML_TEMP is referenced by following:

GMP
VIEW - GMP_PDR_XML_TEMP#

[top of page]

Table: GMP_PLANT_RSRC_PARAMETERS

Description: Table for Association of Parameters to the Generic Resources
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMP_PLANT_RSRC_PARAMETERS.RESOURCE_ID CR_RSRC_DTL
GMP_PLANT_RSRC_PARAMETERS.PARAMETER_ID GMP_PROCESS_PARAMETERS_B

[top of page]

GMP.GMP_PLANT_RSRC_PARAMETERS does not reference any database object

GMP.GMP_PLANT_RSRC_PARAMETERS is referenced by following:

GMP
VIEW - GMP_PLANT_RSRC_PARAMETERS#

[top of page]

Table: GMP_PROCESS_DTL_APS

Description: APS Process Update Detail Table - Currently Not Used
Primary Key: GMP_PROCESS_DTL_APS_PK
  1. PROCESS_UPD_ID
  2. PROCESS_UPD_TYPE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMP_PROCESS_DTL_APS.PROCESS_UPD_ID GMP_PROCESS_HDR_APS
GMP_PROCESS_DTL_APS.PROCESS_UPD_TYPE_ID GMP_PROCESS_TYP_APS

[top of page]

GMP.GMP_PROCESS_DTL_APS does not reference any database object

GMP.GMP_PROCESS_DTL_APS is referenced by following:

GMP
VIEW - GMP_PROCESS_DTL_APS#

[top of page]

Table: GMP_PROCESS_HDR_APS

Description: APS Process Update Header Table - Currently Not Used
Primary Key: GMP_PROCESS_HDR_APS_PK
  1. PROCESS_UPD_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
GMP_PROCESS_DTL_APS.PROCESS_UPD_ID GMP_PROCESS_HDR_APS
GMP_PROCESS_MSG_APS.PROCESS_UPD_ID GMP_PROCESS_HDR_APS

[top of page]

GMP.GMP_PROCESS_HDR_APS does not reference any database object

GMP.GMP_PROCESS_HDR_APS is referenced by following:

GMP
VIEW - GMP_PROCESS_HDR_APS#

[top of page]

Table: GMP_PROCESS_MSG_APS

Description: APS Process Update Message table - Currently Not Used
Primary Key: GMP_PROCESS_MSG_APS_PK
  1. PROCESS_UPD_ID
  2. LINE_NO
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMP_PROCESS_MSG_APS.PROCESS_UPD_ID GMP_PROCESS_HDR_APS

[top of page]

GMP.GMP_PROCESS_MSG_APS does not reference any database object

GMP.GMP_PROCESS_MSG_APS is referenced by following:

GMP
VIEW - GMP_PROCESS_MSG_APS#

[top of page]

Table: GMP_PROCESS_PARAMETERS_B

Description: Table for Process Parameters
Primary Key: GMP_PROCESS_PARAM_B_PK
  1. PARAMETER_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
GMD_OPRN_PROCESS_PARAMETERS.PARAMETER_ID GMP_PROCESS_PARAMETERS_B
GMD_RECIPE_PROCESS_PARAMETERS.PARAMETER_ID GMP_PROCESS_PARAMETERS_B
GMP_PARAMETER_VALUES_B.PARAMETER_ID GMP_PROCESS_PARAMETERS_B
GMP_PLANT_RSRC_PARAMETERS.PARAMETER_ID GMP_PROCESS_PARAMETERS_B
GMP_PROCESS_PARAMETER_SETS.PARAMETER_ID GMP_PROCESS_PARAMETERS_B
GMP_PROCESS_PARAMETERS_TL.PARAMETER_ID GMP_PROCESS_PARAMETERS_B
GMP_RESOURCE_PARAMETERS.PARAMETER_ID GMP_PROCESS_PARAMETERS_B

[top of page]

GMP.GMP_PROCESS_PARAMETERS_B does not reference any database object

GMP.GMP_PROCESS_PARAMETERS_B is referenced by following:

GMP
VIEW - GMP_PROCESS_PARAMETERS_B#

[top of page]

Table: GMP_PROCESS_PARAMETERS_TL

Description: Table for to store Process Parameters description ( MLS )
Primary Key: GMP_PROCESS_PARAM_TL_PK
  1. PARAMETER_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMP_PROCESS_PARAMETERS_TL.PARAMETER_ID GMP_PROCESS_PARAMETERS_B

[top of page]

GMP.GMP_PROCESS_PARAMETERS_TL does not reference any database object

GMP.GMP_PROCESS_PARAMETERS_TL is referenced by following:

GMP
VIEW - GMP_PROCESS_PARAMETERS_TL#

[top of page]

Table: GMP_PROCESS_PARAMETER_SETS

Description: Table for Association of Parameters to the Parameter Sets
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMP_PROCESS_PARAMETER_SETS.PARAMETER_SET_ID GMP_PROCESS_PARAMETER_SET_B
GMP_PROCESS_PARAMETER_SETS.PARAMETER_ID GMP_PROCESS_PARAMETERS_B

[top of page]

GMP.GMP_PROCESS_PARAMETER_SETS does not reference any database object

GMP.GMP_PROCESS_PARAMETER_SETS is referenced by following:

GMP
VIEW - GMP_PROCESS_PARAMETER_SETS#

[top of page]

Table: GMP_PROCESS_PARAMETER_SET_B

Description: Table for Process Parameter Sets
Primary Key: GMP_PROCESS_PARAM_SET_B_PK
  1. PARAMETER_SET_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
GMP_PROCESS_PARAMETER_SETS.PARAMETER_SET_ID GMP_PROCESS_PARAMETER_SET_B
GMP_PROCESS_PARAMETER_SET_TL.PARAMETER_SET_ID GMP_PROCESS_PARAMETER_SET_B

[top of page]

GMP.GMP_PROCESS_PARAMETER_SET_B does not reference any database object

GMP.GMP_PROCESS_PARAMETER_SET_B is referenced by following:

GMP
VIEW - GMP_PROCESS_PARAMETER_SET_B#

[top of page]

Table: GMP_PROCESS_PARAMETER_SET_TL

Description: Table for Process Parameter Sets
Primary Key: GMP_PROCESS_PARAM_SET_TL_PK
  1. PARAMETER_SET_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMP_PROCESS_PARAMETER_SET_TL.PARAMETER_SET_ID GMP_PROCESS_PARAMETER_SET_B

[top of page]

GMP.GMP_PROCESS_PARAMETER_SET_TL does not reference any database object

GMP.GMP_PROCESS_PARAMETER_SET_TL is referenced by following:

GMP
VIEW - GMP_PROCESS_PARAMETER_SET_TL#

[top of page]

Table: GMP_PROCESS_TYP_APS

Description: APS Process Update Type table - Currently Not Used
Primary Key: GMP_PROCESS_TYP_APS_PK
  1. PROCESS_UPD_TYPE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
GMP_PROCESS_DTL_APS.PROCESS_UPD_TYPE_ID GMP_PROCESS_TYP_APS

[top of page]

GMP.GMP_PROCESS_TYP_APS does not reference any database object

GMP.GMP_PROCESS_TYP_APS is referenced by following:

GMP
VIEW - GMP_PROCESS_TYP_APS#

[top of page]

Table: GMP_RESDISP_XML_TEMP

Description: Table used to store XML generated for Resource Dispatch Report.

[top of page]

GMP.GMP_RESDISP_XML_TEMP does not reference any database object

GMP.GMP_RESDISP_XML_TEMP is referenced by following:

GMP
VIEW - GMP_RESDISP_XML_TEMP#

[top of page]

Table: GMP_RESOURCE_AVAIL

Description: Table for Resource Availability

[top of page]

GMP.GMP_RESOURCE_AVAIL does not reference any database object

GMP.GMP_RESOURCE_AVAIL is referenced by following:

GMP
VIEW - GMP_RESOURCE_AVAIL#

[top of page]

Table: GMP_RESOURCE_DEVICES

Description: Resource-Device Association

[top of page]

GMP.GMP_RESOURCE_DEVICES does not reference any database object

GMP.GMP_RESOURCE_DEVICES is referenced by following:

GMP
VIEW - GMP_RESOURCE_DEVICES#

[top of page]

Table: GMP_RESOURCE_DEVICE_MESSAGES

Description: Resource Parameter to Device Response Messages Mapping Table

[top of page]

GMP.GMP_RESOURCE_DEVICE_MESSAGES does not reference any database object

GMP.GMP_RESOURCE_DEVICE_MESSAGES is referenced by following:

GMP
VIEW - GMP_RESOURCE_DEVICE_MESSAGES#

[top of page]

Table: GMP_RESOURCE_EQUIPMENTS

Description: Table for Resource Equipment
Primary Key: GMP_RESOURCE_EQUIPMENTS_PK
  1. RESOURCE_ID
  2. EQUIPMENT_ITEM_ID

[top of page]

GMP.GMP_RESOURCE_EQUIPMENTS does not reference any database object

GMP.GMP_RESOURCE_EQUIPMENTS is referenced by following:

GMP
VIEW - GMP_RESOURCE_EQUIPMENTS#

[top of page]

Table: GMP_RESOURCE_INSTANCES

Description: Table for Resource Instances
Primary Key: GMP_RESOURCE_INSTANCES_U1
  1. EQUIPMENT_ITEM_ID
  2. EQP_SERIAL_NUMBER

[top of page]

GMP.GMP_RESOURCE_INSTANCES does not reference any database object

GMP.GMP_RESOURCE_INSTANCES is referenced by following:

GMP
VIEW - GMP_RESOURCE_INSTANCES#

[top of page]

Table: GMP_RESOURCE_PARAMETERS

Description: Table for Association of Parameters to the Generic Resources
Primary Key: GMP_RESOURCE_PARAM_PK
  1. RESOURCES
  2. PARAMETER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMP_RESOURCE_PARAMETERS.RESOURCES CR_RSRC_MST_B
GMP_RESOURCE_PARAMETERS.PARAMETER_ID GMP_PROCESS_PARAMETERS_B

[top of page]

GMP.GMP_RESOURCE_PARAMETERS does not reference any database object

GMP.GMP_RESOURCE_PARAMETERS is referenced by following:

GMP
VIEW - GMP_RESOURCE_PARAMETERS#

[top of page]

Table: GMP_ROUTING_OFFSETS

Description: Table for Routing offsets used in Lead Time Calculations

[top of page]

GMP.GMP_ROUTING_OFFSETS does not reference any database object

GMP.GMP_ROUTING_OFFSETS is referenced by following:

GMP
VIEW - GMP_ROUTING_OFFSETS#

[top of page]

Table: GMP_RSRC_EXCP_ASNMT

Description: Resource Assignment Table
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMP_RSRC_EXCP_ASNMT.EXCEPTION_ID GMP_RSRC_EXCP_HDR
GMP_RSRC_EXCP_ASNMT.RESOURCE_ID CR_RSRC_DTL

[top of page]

GMP.GMP_RSRC_EXCP_ASNMT does not reference any database object

GMP.GMP_RSRC_EXCP_ASNMT is referenced by following:

GMP
VIEW - GMP_RSRC_EXCP_ASNMT#

[top of page]

Table: GMP_RSRC_EXCP_DTL

Description: Exception Details Table
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMP_RSRC_EXCP_DTL.EXCEPTION_ID GMP_RSRC_EXCP_HDR
GMP_RSRC_EXCP_DTL.REASON_CODE SY_REAS_CDS_B

[top of page]

GMP.GMP_RSRC_EXCP_DTL does not reference any database object

GMP.GMP_RSRC_EXCP_DTL is referenced by following:

GMP
VIEW - GMP_RSRC_EXCP_DTL#

[top of page]

Table: GMP_RSRC_EXCP_HDR

Description: Exception Header Table
Primary Key: GMP_RSRC_EXCP_HDR_PK
  1. EXCEPTION_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
GMP_RSRC_EXCP_ASNMT.EXCEPTION_ID GMP_RSRC_EXCP_HDR
GMP_RSRC_EXCP_DTL.EXCEPTION_ID GMP_RSRC_EXCP_HDR

[top of page]

GMP.GMP_RSRC_EXCP_HDR does not reference any database object

GMP.GMP_RSRC_EXCP_HDR is referenced by following:

GMP
VIEW - GMP_RSRC_EXCP_HDR#

[top of page]

Table: GMP_RSRC_UNAVAIL_MAN

Description: Manual Entries Table
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMP_RSRC_UNAVAIL_MAN.RESOURCE_ID CR_RSRC_DTL
GMP_RSRC_UNAVAIL_MAN.REASON_CODE SY_REAS_CDS_B

[top of page]

GMP.GMP_RSRC_UNAVAIL_MAN does not reference any database object

GMP.GMP_RSRC_UNAVAIL_MAN is referenced by following:

GMP
VIEW - GMP_RSRC_UNAVAIL_MAN#

[top of page]

Table: GMP_SEQUENCE_DEPENDENCIES

Description: Table for Sequence Dependencies

[top of page]

GMP.GMP_SEQUENCE_DEPENDENCIES does not reference any database object

GMP.GMP_SEQUENCE_DEPENDENCIES is referenced by following:

GMP
VIEW - GMP_SEQUENCE_DEPENDENCIES#

[top of page]

Table: GMP_SEQUENCE_TYPES

Description: Table for Sequence Types

[top of page]

GMP.GMP_SEQUENCE_TYPES does not reference any database object

GMP.GMP_SEQUENCE_TYPES is referenced by following:

GMP
VIEW - GMP_SEQUENCE_TYPES#

[top of page]

Table: GMP_UNBUCKETED_XML_TEMP

Description: Table used to store XML generated for Unbucketed Material Activity Report

[top of page]

GMP.GMP_UNBUCKETED_XML_TEMP does not reference any database object

GMP.GMP_UNBUCKETED_XML_TEMP is referenced by following:

GMP
VIEW - GMP_UNBUCKETED_XML_TEMP#

[top of page]

Table: MR_ACTN_TBL

Description: MRP Action messages.
Primary Key: MR_ACTN_TBLI1
  1. MRP_ID
  2. ITEM_ID
  3. WHSE_CODE
  4. EVENT_DATE
  5. ACTION_NO
Primary Key: MR_ACTN_TBL_PK
  1. MRP_ID
  2. ACTION_NO
Foreign Keys from this table:
Foreign Key Column Foreign Table
MR_ACTN_TBL.FORMULA_ID FM_FORM_MST
MR_ACTN_TBL.ITEM_ID IC_ITEM_MST_B
MR_ACTN_TBL.ITEM_ID IC_ITEM_MST
MR_ACTN_TBL.WHSE_CODE IC_WHSE_MST
MR_ACTN_TBL.WHSE_CODE_2 IC_WHSE_MST
MR_ACTN_TBL.MRP_ID MR_PARM_DTL
MR_ACTN_TBL.DOC_TYPE SY_DOCS_MST
MR_ACTN_TBL.ORGN_CODE SY_ORGN_MST_B
MR_ACTN_TBL.ORGN_CODE SY_ORGN_MST
Foreign Keys to this table:
Foreign Key Column Foreign Table
MR_PEGG_TBL.MRP_ID
MR_PEGG_TBL.ACTION_NO 		MR_ACTN_TBL

[top of page]

GMP.MR_ACTN_TBL does not reference any database object

GMP.MR_ACTN_TBL is referenced by following:

GMP
VIEW - MR_ACTN_TBL#

[top of page]

Table: MR_MESG_TBL

Description: MRP Error message log.
Primary Key: MR_MESG_TBL_PK
  1. MRP_ID
  2. MESSAGE_LINE_NO
Foreign Keys from this table:
Foreign Key Column Foreign Table
MR_MESG_TBL.FORMULA_ID FM_FORM_MST
MR_MESG_TBL.ITEM_ID1 IC_ITEM_MST_B
MR_MESG_TBL.ITEM_ID2 IC_ITEM_MST_B
MR_MESG_TBL.ITEM_ID1 IC_ITEM_MST
MR_MESG_TBL.ITEM_ID2 IC_ITEM_MST
MR_MESG_TBL.WHSE_CODE1 IC_WHSE_MST
MR_MESG_TBL.WHSE_CODE2 IC_WHSE_MST
MR_MESG_TBL.MRP_ID MR_PARM_DTL
MR_MESG_TBL.CALENDAR_ID MR_SHCL_HDR
MR_MESG_TBL.ORGN_CODE SY_ORGN_MST_B
MR_MESG_TBL.ORGN_CODE SY_ORGN_MST

[top of page]

GMP.MR_MESG_TBL does not reference any database object

GMP.MR_MESG_TBL is referenced by following:

GMP
VIEW - MR_MESG_TBL#

[top of page]

Table: MR_PARM_DTL

Description: MRP run parameters.
Primary Key: MR_PARM_DTL_PK
  1. MRP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
MR_PARM_DTL.TEXT_CODE MR_TEXT_HDR
MR_PARM_DTL.SCHEDULE_ID PS_SCHD_HDR
Foreign Keys to this table:
Foreign Key Column Foreign Table
MR_ACTN_TBL.MRP_ID MR_PARM_DTL
MR_MESG_TBL.MRP_ID MR_PARM_DTL
MR_TRAN_TBL.MRP_ID MR_PARM_DTL

[top of page]

GMP.MR_PARM_DTL does not reference any database object

GMP.MR_PARM_DTL is referenced by following:

GMP
VIEW - MR_PARM_DTL#

[top of page]

Table: MR_PEGG_TBL

Description: Pegging table. Pegging of demands to the shortage warnings is done
Primary Key: MR_PEGG_TBL_PK
  1. MRP_ID
  2. ACTION_NO
  3. LINE_NO
Foreign Keys from this table:
Foreign Key Column Foreign Table
MR_PEGG_TBL.MRP_ID
MR_PEGG_TBL.ACTION_NO 		MR_ACTN_TBL

[top of page]

GMP.MR_PEGG_TBL does not reference any database object

GMP.MR_PEGG_TBL is referenced by following:

GMP
VIEW - MR_PEGG_TBL#

[top of page]

Table: MR_SHCL_DTL

Description: Shop calendar details.
Primary Key: MR_SHCL_DTL_PK
  1. CALENDAR_ID
  2. CALENDAR_DATE
Foreign Keys from this table:
Foreign Key Column Foreign Table
MR_SHCL_DTL.CALENDAR_ID MR_SHCL_HDR
MR_SHCL_DTL.SHOPDAY_NO MR_SHDY_HDR
MR_SHCL_DTL.TEXT_CODE MR_TEXT_HDR

[top of page]

GMP.MR_SHCL_DTL does not reference any database object

GMP.MR_SHCL_DTL is referenced by following:

GMP
VIEW - MR_SHCL_DTL#

[top of page]

Table: MR_SHCL_HDR

Description: Shop calendar header.
Primary Key: MR_SHCL_HDR_PK
  1. CALENDAR_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
MR_SHCL_HDR.DAY1 MR_SHDY_HDR
MR_SHCL_HDR.DAY2 MR_SHDY_HDR
MR_SHCL_HDR.DAY3 MR_SHDY_HDR
MR_SHCL_HDR.DAY4 MR_SHDY_HDR
MR_SHCL_HDR.DAY5 MR_SHDY_HDR
MR_SHCL_HDR.DAY6 MR_SHDY_HDR
MR_SHCL_HDR.DAY7 MR_SHDY_HDR
MR_SHCL_HDR.TEXT_CODE MR_TEXT_HDR
Foreign Keys to this table:
Foreign Key Column Foreign Table
MR_MESG_TBL.CALENDAR_ID MR_SHCL_HDR
MR_SHCL_DTL.CALENDAR_ID MR_SHCL_HDR
PS_SCHD_DTL.CALENDAR_ID MR_SHCL_HDR

[top of page]

GMP.MR_SHCL_HDR does not reference any database object

GMP.MR_SHCL_HDR is referenced by following:

GMP
VIEW - MR_SHCL_HDR#

[top of page]

Table: MR_SHDY_DTL

Description: Shop day detail.
Primary Key: MR_SHDY_DTL_PK
  1. SHOPDAY_NO
  2. SHIFT_NO
Foreign Keys from this table:
Foreign Key Column Foreign Table
MR_SHDY_DTL.SHOPDAY_NO MR_SHDY_HDR
MR_SHDY_DTL.TEXT_CODE MR_TEXT_HDR

[top of page]

GMP.MR_SHDY_DTL does not reference any database object

GMP.MR_SHDY_DTL is referenced by following:

GMP
VIEW - MR_SHDY_DTL#

[top of page]

Table: MR_SHDY_HDR

Description: Shop day header.
Primary Key: MR_SHDY_HDR_PK
  1. SHOPDAY_NO
Foreign Keys from this table:
Foreign Key Column Foreign Table
MR_SHDY_HDR.TEXT_CODE FM_TEXT_HDR
Foreign Keys to this table:
Foreign Key Column Foreign Table
MR_SHCL_DTL.SHOPDAY_NO MR_SHDY_HDR
MR_SHCL_HDR.DAY1 MR_SHDY_HDR
MR_SHCL_HDR.DAY2 MR_SHDY_HDR
MR_SHCL_HDR.DAY3 MR_SHDY_HDR
MR_SHCL_HDR.DAY4 MR_SHDY_HDR
MR_SHCL_HDR.DAY5 MR_SHDY_HDR
MR_SHCL_HDR.DAY6 MR_SHDY_HDR
MR_SHCL_HDR.DAY7 MR_SHDY_HDR
MR_SHDY_DTL.SHOPDAY_NO MR_SHDY_HDR

[top of page]

GMP.MR_SHDY_HDR does not reference any database object

GMP.MR_SHDY_HDR is referenced by following:

GMP
VIEW - MR_SHDY_HDR#

[top of page]

Table: MR_SIZE_TBL

Description: MRP runs sizing. MRP allocates memory based on max number of rows mentioned in this table. The values are updated when a MRP Run gets rows more than mentioned in this table.
Primary Key: MR_SIZE_TBL_PK
  1. SCHEDULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
MR_SIZE_TBL.SCHEDULE_ID PS_SCHD_HDR

[top of page]

GMP.MR_SIZE_TBL does not reference any database object

GMP.MR_SIZE_TBL is referenced by following:

GMP
VIEW - MR_SIZE_TBL#

[top of page]

Table: MR_TEXT_HDR

Description: Table used to store text types for MRP.
Primary Key: MR_TEXT_HDR_PK
  1. TEXT_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
MR_PARM_DTL.TEXT_CODE MR_TEXT_HDR
MR_SHCL_DTL.TEXT_CODE MR_TEXT_HDR
MR_SHCL_HDR.TEXT_CODE MR_TEXT_HDR
MR_SHDY_DTL.TEXT_CODE MR_TEXT_HDR

[top of page]

GMP.MR_TEXT_HDR does not reference any database object

GMP.MR_TEXT_HDR is referenced by following:

GMP
VIEW - MR_TEXT_HDR#

[top of page]

Table: MR_TEXT_TBL_TL

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

[top of page]

GMP.MR_TEXT_TBL_TL does not reference any database object

GMP.MR_TEXT_TBL_TL is referenced by following:

GMP
VIEW - MR_TEXT_TBL_TL#

[top of page]

Table: MR_TRAN_TBL

Description: MRP transactions.
Primary Key: MR_TRAN_TBLI1
  1. MRP_ID
  2. ITEM_ID
  3. WHSE_CODE
  4. TRANS_DATE
  5. LINE_NO
Primary Key: MR_TRAN_TBL_PK
  1. MRP_ID
  2. LINE_NO
Foreign Keys from this table:
Foreign Key Column Foreign Table
MR_TRAN_TBL.ITEM_ID IC_ITEM_MST_B
MR_TRAN_TBL.ITEM_ID IC_ITEM_MST
MR_TRAN_TBL.WHSE_CODE IC_WHSE_MST
MR_TRAN_TBL.MRP_ID MR_PARM_DTL
MR_TRAN_TBL.ORGN_CODE SY_ORGN_MST_B
MR_TRAN_TBL.CO_CODE SY_ORGN_MST_B
MR_TRAN_TBL.ORGN_CODE SY_ORGN_MST
MR_TRAN_TBL.CO_CODE SY_ORGN_MST
MR_TRAN_TBL.TRANS_UM SY_UOMS_MST

[top of page]

GMP.MR_TRAN_TBL does not reference any database object

GMP.MR_TRAN_TBL is referenced by following:

GMP
VIEW - MR_TRAN_TBL#

[top of page]

Table: MR_UBKT_DTL

Description: This table is a 'temporary table' in the sense that data is deleted with each MRP run and there were issues running the reports with PK, therefore it was removed.

[top of page]

GMP.MR_UBKT_DTL does not reference any database object

GMP.MR_UBKT_DTL is referenced by following:

GMP
VIEW - MR_UBKT_DTL#

[top of page]

Table: PS_MATL_DTL

Description: Temporary data about the report
Primary Key: PS_MATL_DTL_PK
  1. MATL_REP_ID
  2. ITEM_ID
  3. PERD_END_DATE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PS_MATL_DTL.MATL_REP_ID
PS_MATL_DTL.ITEM_ID 		PS_MATL_HDR

[top of page]

GMP.PS_MATL_DTL does not reference any database object

GMP.PS_MATL_DTL is referenced by following:

GMP
VIEW - PS_MATL_DTL#

[top of page]

Table: PS_MATL_HDR

Description: Temporary data about the report
Primary Key: PS_MATL_HDR_PK
  1. MATL_REP_ID
  2. ITEM_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
PS_MATL_DTL.MATL_REP_ID
PS_MATL_DTL.ITEM_ID 		PS_MATL_HDR
PS_UBKT_DTL.MATL_REP_ID
PS_UBKT_DTL.ITEM_ID 		PS_MATL_HDR

[top of page]

GMP.PS_MATL_HDR does not reference any database object

GMP.PS_MATL_HDR is referenced by following:

GMP
VIEW - PS_MATL_HDR#

[top of page]

Table: PS_OPER_PCL

Description: Associates operator codes and planning classes.
Primary Key: PS_OPER_PCL_PK
  1. USER_ID
  2. PLANNING_CLASS
Foreign Keys from this table:
Foreign Key Column Foreign Table
PS_OPER_PCL.PLANNING_CLASS PS_PLNG_CLS
PS_OPER_PCL.TEXT_CODE PS_TEXT_HDR

[top of page]

GMP.PS_OPER_PCL does not reference any database object

GMP.PS_OPER_PCL is referenced by following:

GMP
VIEW - PS_OPER_PCL#

[top of page]

Table: PS_SCHD_DTL

Description: Schedule detail.
Primary Key: PS_SCHD_DTL_PK
  1. SCHEDULE_ID
  2. ORGN_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PS_SCHD_DTL.CALENDAR_ID MR_SHCL_HDR
PS_SCHD_DTL.SCHEDULE_ID PS_SCHD_HDR
PS_SCHD_DTL.TEXT_CODE PS_TEXT_HDR
PS_SCHD_DTL.ORGN_CODE SY_ORGN_MST_B
PS_SCHD_DTL.ORGN_CODE SY_ORGN_MST

[top of page]

GMP.PS_SCHD_DTL does not reference any database object

GMP.PS_SCHD_DTL is referenced by following:

GMP
VIEW - PS_SCHD_DTL#

[top of page]

Table: PS_SCHD_FOR

Description: Schedule forecast association.
Primary Key: PS_SCHD_FOR_PK
  1. SCHEDULE_ID
  2. FORECAST_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PS_SCHD_FOR.FORECAST_ID FC_FCST_HDR
PS_SCHD_FOR.TEXT_CODE FC_TEXT_HDR
PS_SCHD_FOR.SCHEDULE_ID PS_SCHD_HDR

[top of page]

GMP.PS_SCHD_FOR does not reference any database object

GMP.PS_SCHD_FOR is referenced by following:

GMP
VIEW - PS_SCHD_FOR#

[top of page]

Table: PS_SCHD_HDR

Description: Schedule header.
Primary Key: PS_SCHD_HDR_PK
  1. SCHEDULE_ID
Primary Key: PS_SCHD_HDR_U1
  1. ORGN_CODE
  2. SCHEDULE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PS_SCHD_HDR.TEXT_CODE PS_TEXT_HDR
PS_SCHD_HDR.ORGN_CODE SY_ORGN_MST_B
PS_SCHD_HDR.ORGN_CODE SY_ORGN_MST
Foreign Keys to this table:
Foreign Key Column Foreign Table
MR_PARM_DTL.SCHEDULE_ID PS_SCHD_HDR
MR_SIZE_TBL.SCHEDULE_ID PS_SCHD_HDR
PS_SCHD_DTL.SCHEDULE_ID PS_SCHD_HDR
PS_SCHD_FOR.SCHEDULE_ID PS_SCHD_HDR

[top of page]

GMP.PS_SCHD_HDR does not reference any database object

GMP.PS_SCHD_HDR is referenced by following:

GMP
VIEW - PS_SCHD_HDR#

[top of page]

Table: PS_TEXT_HDR

Description: Table used to store text types for Production Scheduling.
Primary Key: PS_TEXT_HDR_PK
  1. TEXT_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
PS_OPER_PCL.TEXT_CODE PS_TEXT_HDR
PS_SCHD_DTL.TEXT_CODE PS_TEXT_HDR
PS_SCHD_HDR.TEXT_CODE PS_TEXT_HDR
PS_WHSE_EFF.TEXT_CODE PS_TEXT_HDR

[top of page]

GMP.PS_TEXT_HDR does not reference any database object

GMP.PS_TEXT_HDR is referenced by following:

GMP
VIEW - PS_TEXT_HDR#

[top of page]

Table: PS_TEXT_TBL_TL

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

[top of page]

GMP.PS_TEXT_TBL_TL does not reference any database object

GMP.PS_TEXT_TBL_TL is referenced by following:

GMP
VIEW - PS_TEXT_TBL_TL#

[top of page]

Table: PS_UBKT_DTL

Description: Table used to store data for the Material Activity Report.
Foreign Keys from this table:
Foreign Key Column Foreign Table
PS_UBKT_DTL.MATL_REP_ID
PS_UBKT_DTL.ITEM_ID 		PS_MATL_HDR

[top of page]

GMP.PS_UBKT_DTL does not reference any database object

GMP.PS_UBKT_DTL is referenced by following:

GMP
VIEW - PS_UBKT_DTL#

[top of page]

Table: PS_WHSE_EFF

Description: Plant-warehouse relationship (effectivity).
Primary Key: PS_WHSE_EFF_PK
  1. PSWHSE_EFF_ID
Primary Key: PS_WHSE_EFF_U1
  1. PLANT_CODE
  2. WHSE_CODE
  3. WHSE_ITEM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PS_WHSE_EFF.WHSE_ITEM_ID IC_ITEM_MST_B
PS_WHSE_EFF.WHSE_ITEM_ID IC_ITEM_MST
PS_WHSE_EFF.WHSE_CODE IC_WHSE_MST
PS_WHSE_EFF.TEXT_CODE PS_TEXT_HDR
PS_WHSE_EFF.PLANT_CODE SY_ORGN_MST_B
PS_WHSE_EFF.PLANT_CODE SY_ORGN_MST

[top of page]

GMP.PS_WHSE_EFF does not reference any database object

GMP.PS_WHSE_EFF is referenced by following:

GMP
VIEW - PS_WHSE_EFF#

[top of page]

Table: RH_ACTN_TBL

Description: Table storing all the syntaxes for the actions executed during data transfer between OPM and Rhythm
Primary Key: RH_ACTN_TBL_PK
  1. ACTION_SET
  2. SEQUENCE_NUMBER

[top of page]

GMP.RH_ACTN_TBL does not reference any database object

GMP.RH_ACTN_TBL is referenced by following:

GMP
VIEW - RH_ACTN_TBL#

[top of page]

Table: RH_DORD_IMP

Description: Demand order import table. Stores imported details of demand orders. - Currently Not Used
Primary Key: RH_DORD_IMP_PK
  1. IMPORT_ID
  2. DOC_TYPE
  3. LINE_ID
  4. LINE_NO
  5. NEW_DOC_TYPE
  6. NEW_DOC_ID
  7. ACTION_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
RH_DORD_IMP.IMPORT_ID RH_IMPT_MST

[top of page]

GMP.RH_DORD_IMP does not reference any database object

GMP.RH_DORD_IMP is referenced by following:

GMP
VIEW - RH_DORD_IMP#

[top of page]

Table: RH_EXPT_DTL

Description: Datils of each export
Primary Key: RH_EXPT_DTL_PK
  1. EXPORT_ID
  2. EXPORT_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
RH_EXPT_DTL.EXPORT_ID RH_EXPT_MST

[top of page]

GMP.RH_EXPT_DTL does not reference any database object

GMP.RH_EXPT_DTL is referenced by following:

GMP
VIEW - RH_EXPT_DTL#

[top of page]

Table: RH_EXPT_MST

Description: Export Master table
Primary Key: RH_EXPT_MST_PK
  1. EXPORT_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
RH_EXPT_DTL.EXPORT_ID RH_EXPT_MST

[top of page]

GMP.RH_EXPT_MST does not reference any database object

GMP.RH_EXPT_MST is referenced by following:

GMP
VIEW - RH_EXPT_MST#

[top of page]

Table: RH_IMPT_DTL

Description: Demand order import details.
Primary Key: RH_IMPT_DTL_PK
  1. IMPORT_ID
  2. IMPORT_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
RH_IMPT_DTL.IMPORT_ID RH_IMPT_MST

[top of page]

GMP.RH_IMPT_DTL does not reference any database object

GMP.RH_IMPT_DTL is referenced by following:

GMP
VIEW - RH_IMPT_DTL#

[top of page]

Table: RH_IMPT_MST

Description: Import master.
Primary Key: RH_IMPT_MST_PK
  1. IMPORT_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
RH_DORD_IMP.IMPORT_ID RH_IMPT_MST
RH_IMPT_DTL.IMPORT_ID RH_IMPT_MST
RH_MORD_IMP.IMPORT_ID RH_IMPT_MST

[top of page]

GMP.RH_IMPT_MST does not reference any database object

GMP.RH_IMPT_MST is referenced by following:

GMP
VIEW - RH_IMPT_MST#

[top of page]

Table: RH_MESG_TBL

Description: Message table for data transfers
Primary Key: RH_MESG_TBL_PK
  1. FKEY_ID
  2. LINE_NO

[top of page]

GMP.RH_MESG_TBL does not reference any database object

GMP.RH_MESG_TBL is referenced by following:

GMP
VIEW - RH_MESG_TBL#

[top of page]

Table: RH_MORD_IMP

Description: Manufacturing order import. - Currently Not Used
Primary Key: RH_MORD_IMP_PK
  1. IMPORT_ID
  2. BATCH_ID
  3. LINE_NO
  4. NEW_DOC_TYPE
  5. NEW_DOC_ID
  6. ACTION_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
RH_MORD_IMP.BATCH_ID PM_BTCH_HDR
RH_MORD_IMP.IMPORT_ID RH_IMPT_MST
RH_MORD_IMP.ORGN_CODE SY_ORGN_MST

[top of page]

GMP.RH_MORD_IMP does not reference any database object

GMP.RH_MORD_IMP is referenced by following:

GMP
VIEW - RH_MORD_IMP#

[top of page]

Table: RH_PARM_TBL

Description: Parameter table for all INSTALLED schedules
Primary Key: RH_PARM_TBL_PK
  1. SCHEDULE_ID
  2. PARAMETER

[top of page]

GMP.RH_PARM_TBL does not reference any database object

GMP.RH_PARM_TBL is referenced by following:

GMP
VIEW - RH_PARM_TBL#

[top of page]

Table: RH_PARM_TYP

Description: Master table for storing parameters and their default values. During installation of a schedule the parameters are copied from here.
Primary Key: RH_PARM_TYP_PK
  1. PARAMETER

[top of page]

GMP.RH_PARM_TYP does not reference any database object

GMP.RH_PARM_TYP is referenced by following:

GMP
VIEW - RH_PARM_TYP#

[top of page]

Table: RH_RSCL_TBL

Description: * NOT USED *
Primary Key: RH_RSCL_TBL_PK
  1. SCHEDULE_ID
  2. ORGN_CODE
  3. RESOURCES

[top of page]

GMP.RH_RSCL_TBL does not reference any database object

GMP.RH_RSCL_TBL is referenced by following:

GMP
VIEW - RH_RSCL_TBL#

[top of page]

View: CR_RSRC_CLS_VL

[top of page]

APPS.CR_RSRC_CLS_VL references the following:

APPS
SYNONYM - CR_RSRC_CLS_B
SYNONYM - CR_RSRC_CLS_TL
APPS.CR_RSRC_CLS_VL is referenced by following:

APPS
SYNONYM - CR_RSRC_CLS

[top of page]

View: CR_RSRC_DTL_VW1

[top of page]

APPS.CR_RSRC_DTL_VW1 references the following:

APPS
SYNONYM - CR_RSRC_DTL
- CR_RSRC_MST

APPS.CR_RSRC_DTL_VW1 is not referenced by any database object

[top of page]

View: CR_RSRC_DTL_VW2

[top of page]

APPS.CR_RSRC_DTL_VW2 references the following:

APPS
SYNONYM - CR_RSRC_DTL
- CR_RSRC_MST

APPS.CR_RSRC_DTL_VW2 is not referenced by any database object

[top of page]

View: CR_RSRC_MST_VL

[top of page]

APPS.CR_RSRC_MST_VL references the following:

APPS
SYNONYM - CR_RSRC_MST_B
SYNONYM - CR_RSRC_MST_TL
APPS.CR_RSRC_MST_VL is referenced by following:

APPS
SYNONYM - CR_RSRC_MST
VIEW - MTH_SRC_EQUIP_ENTITIES_V
VIEW - MTH_SRC_EQUIP_HIERARCHY_V
VIEW - MTH_SRC_RESOURCES_V

[top of page]

View: CR_SQDS_TBL_V

[top of page]

APPS.CR_SQDS_TBL_V references the following:

APPS
SYNONYM - CR_SQDS_TBL
SYNONYM - FM_OPRN_MST

APPS.CR_SQDS_TBL_V is not referenced by any database object

[top of page]

View: CR_SQDT_CLS_VW

[top of page]

APPS.CR_SQDT_CLS_VW references the following:

APPS
VIEW - MTL_CATEGORIES_V
SYNONYM - MTL_CATEGORY_SET_VALID_CATS
SYNONYM - MTL_DEFAULT_CATEGORY_SETS
- MTL_CATEGORY_SETS

APPS.CR_SQDT_CLS_VW is not referenced by any database object

[top of page]

View: CR_TEXT_TBL_VL

[top of page]

APPS.CR_TEXT_TBL_VL references the following:

APPS
SYNONYM - CR_TEXT_TBL_TL

APPS.CR_TEXT_TBL_VL is not referenced by any database object

[top of page]

View: FC_TEXT_TBL_VL

[top of page]

APPS.FC_TEXT_TBL_VL references the following:

APPS
SYNONYM - FC_TEXT_TBL_TL

APPS.FC_TEXT_TBL_VL is not referenced by any database object

[top of page]

View: GMP_EAM_EQUIP_RESOURCES_V

[top of page]

APPS.GMP_EAM_EQUIP_RESOURCES_V references the following:

APPS
SYNONYM - CR_RSRC_DTL
SYNONYM - CR_RSRC_MST
SYNONYM - GMP_RESOURCE_EQUIPMENTS
SYNONYM - GMP_RESOURCE_INSTANCES
SYNONYM - MTL_PARAMETERS
APPS.GMP_EAM_EQUIP_RESOURCES_V is referenced by following:

APPS
VIEW - MTL_EAM_EQUIP_RESOURCES_V

[top of page]

View: GMP_EAM_JOBS_RESOURCES_V

[top of page]

APPS.GMP_EAM_JOBS_RESOURCES_V references the following:

APPS
SYNONYM - CR_RSRC_DTL
VIEW - GEM_LOOKUPS
SYNONYM - GME_BATCH_HEADER
SYNONYM - GME_BATCH_STEPS
SYNONYM - GME_BATCH_STEP_ACTIVITIES
SYNONYM - GME_BATCH_STEP_RESOURCES
APPS.GMP_EAM_JOBS_RESOURCES_V is referenced by following:

APPS
VIEW - MTL_EAM_JOBS_RESOURCES_V

[top of page]

View: GMP_MFG_TIME_WEEKS_V

[top of page]

APPS.GMP_MFG_TIME_WEEKS_V references the following:

APPS
SYNONYM - MR_SHCL_DTL

APPS.GMP_MFG_TIME_WEEKS_V is not referenced by any database object

[top of page]

View: GMP_NETTABLE_ONHANDS_V

[top of page]

APPS.GMP_NETTABLE_ONHANDS_V references the following:

APPS
SYNONYM - MTL_ITEM_LOCATIONS
SYNONYM - MTL_LOT_NUMBERS
SYNONYM - MTL_MATERIAL_TRANSACTIONS_TEMP
SYNONYM - MTL_ONHAND_QUANTITIES_DETAIL
SYNONYM - MTL_SECONDARY_INVENTORIES
SYNONYM - MTL_SERIAL_NUMBERS
SYNONYM - MTL_SERIAL_NUMBERS_TEMP
SYNONYM - MTL_SYSTEM_ITEMS_B
SYNONYM - PJM_PROJECT_PARAMETERS
PACKAGE - PJM_UNIT_EFF
- MTL_MATERIAL_STATUSES

APPS.GMP_NETTABLE_ONHANDS_V is not referenced by any database object

[top of page]

View: GMP_PARAMETER_VALUES_VL

[top of page]

APPS.GMP_PARAMETER_VALUES_VL references the following:

APPS
SYNONYM - GMP_PARAMETER_VALUES_B
SYNONYM - GMP_PARAMETER_VALUES_TL

APPS.GMP_PARAMETER_VALUES_VL is not referenced by any database object

[top of page]

View: GMP_PDR_BUYER_V

[top of page]

APPS.GMP_PDR_BUYER_V references the following:

APPS
SYNONYM - MSC_SYSTEM_ITEMS

APPS.GMP_PDR_BUYER_V is not referenced by any database object

[top of page]

View: GMP_PDR_CATEGORY_V

[top of page]

APPS.GMP_PDR_CATEGORY_V references the following:

APPS
SYNONYM - MSC_ITEM_CATEGORIES

APPS.GMP_PDR_CATEGORY_V is not referenced by any database object

[top of page]

View: GMP_PLAN_ORGANIZATION_V

[top of page]

APPS.GMP_PLAN_ORGANIZATION_V references the following:

APPS
SYNONYM - MSC_PLAN_ORGANIZATIONS
- MFG_LOOKUPS

APPS.GMP_PLAN_ORGANIZATION_V is not referenced by any database object

[top of page]

View: GMP_PROCESS_PARAMETERS_VL

[top of page]

APPS.GMP_PROCESS_PARAMETERS_VL references the following:

APPS
SYNONYM - GMP_PROCESS_PARAMETERS_B
SYNONYM - GMP_PROCESS_PARAMETERS_TL

APPS.GMP_PROCESS_PARAMETERS_VL is not referenced by any database object

[top of page]

View: GMP_PROCESS_PARAMETER_SET_VL

[top of page]

APPS.GMP_PROCESS_PARAMETER_SET_VL references the following:

APPS
SYNONYM - GMP_PROCESS_PARAMETER_SET_B
SYNONYM - GMP_PROCESS_PARAMETER_SET_TL

APPS.GMP_PROCESS_PARAMETER_SET_VL is not referenced by any database object

[top of page]

View: GMP_RESOURCE_AVAIL_V

[top of page]

APPS.GMP_RESOURCE_AVAIL_V references the following:

APPS
SYNONYM - CR_RSRC_DTL
SYNONYM - GMP_RESOURCE_AVAIL

APPS.GMP_RESOURCE_AVAIL_V is not referenced by any database object

[top of page]

View: GMP_RSRC_CAL_V

[top of page]

APPS.GMP_RSRC_CAL_V references the following:

APPS
SYNONYM - MR_SHCL_DTL
SYNONYM - MR_SHDY_DTL
SYNONYM - MR_SHDY_HDR

APPS.GMP_RSRC_CAL_V is not referenced by any database object

[top of page]

View: GMP_RSRC_UNAVAIL_DTL_V

[top of page]

APPS.GMP_RSRC_UNAVAIL_DTL_V references the following:

APPS
SYNONYM - GMP_RSRC_EXCP_ASNMT
SYNONYM - GMP_RSRC_EXCP_DTL
SYNONYM - GMP_RSRC_EXCP_HDR
SYNONYM - GMP_RSRC_UNAVAIL_MAN
SYNONYM - MTL_TRANSACTION_REASONS

APPS.GMP_RSRC_UNAVAIL_DTL_V is not referenced by any database object

[top of page]

View: GMP_SCHEDULING_EXCEPTIONS_V

[top of page]

APPS.GMP_SCHEDULING_EXCEPTIONS_V references the following:

APPS
SYNONYM - GMD_RECIPE_VALIDITY_RULES
SYNONYM - GME_BATCH_HEADER
SYNONYM - MTL_PARAMETERS
SYNONYM - WIP_SCHEDULING_EXCEPTIONS
- MTL_SYSTEM_ITEMS_KFV

APPS.GMP_SCHEDULING_EXCEPTIONS_V is not referenced by any database object

[top of page]

View: GMP_SR_BG_ALL_V

[top of page]

APPS.GMP_SR_BG_ALL_V references the following:

SYS
TABLE - DUAL

APPS.GMP_SR_BG_ALL_V is not referenced by any database object

[top of page]

View: GMP_SR_BOOKING_DATA_V

[top of page]

APPS.GMP_SR_BOOKING_DATA_V references the following:

SYS
TABLE - DUAL

APPS.GMP_SR_BOOKING_DATA_V is not referenced by any database object

[top of page]

View: GMP_SR_LE_BG_V

[top of page]

APPS.GMP_SR_LE_BG_V references the following:

SYS
TABLE - DUAL

APPS.GMP_SR_LE_BG_V is not referenced by any database object

[top of page]

View: GMP_SR_MFG_FCST_V

[top of page]

APPS.GMP_SR_MFG_FCST_V references the following:

SYS
TABLE - DUAL

APPS.GMP_SR_MFG_FCST_V is not referenced by any database object

[top of page]

View: GMP_SR_MFG_TIME_V

[top of page]

APPS.GMP_SR_MFG_TIME_V references the following:

SYS
TABLE - DUAL

APPS.GMP_SR_MFG_TIME_V is not referenced by any database object

[top of page]

View: GMP_SR_ORG_OU_V

[top of page]

APPS.GMP_SR_ORG_OU_V references the following:

SYS
TABLE - DUAL

APPS.GMP_SR_ORG_OU_V is not referenced by any database object

[top of page]

View: GMP_SR_OU_LE_V

[top of page]

APPS.GMP_SR_OU_LE_V references the following:

SYS
TABLE - DUAL

APPS.GMP_SR_OU_LE_V is not referenced by any database object

[top of page]

View: GMP_SR_SHIPMENT_DATA_V

[top of page]

APPS.GMP_SR_SHIPMENT_DATA_V references the following:

SYS
TABLE - DUAL

APPS.GMP_SR_SHIPMENT_DATA_V is not referenced by any database object

[top of page]

View: MR_TEXT_TBL_VL

[top of page]

APPS.MR_TEXT_TBL_VL references the following:

APPS
SYNONYM - MR_TEXT_TBL_TL

APPS.MR_TEXT_TBL_VL is not referenced by any database object

[top of page]

View: PS_PLNG_CLS_VW

[top of page]

APPS.PS_PLNG_CLS_VW references the following:

APPS
SYNONYM - GMI_CATEGORY_SETS
VIEW - MTL_CATEGORIES_V
SYNONYM - MTL_CATEGORY_SETS
SYNONYM - MTL_CATEGORY_SET_VALID_CATS
APPS.PS_PLNG_CLS_VW is referenced by following:

APPS
SYNONYM - PS_PLNG_CLS

[top of page]

View: PS_TEXT_TBL_VL

[top of page]

APPS.PS_TEXT_TBL_VL references the following:

APPS
SYNONYM - PS_TEXT_TBL_TL

APPS.PS_TEXT_TBL_VL is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract