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

TABLE - GME.GME_BATCH_GROUPS_ASSOCIATION
TABLE - GME.GME_BATCH_GROUPS_B
TABLE - GME.GME_BATCH_GROUPS_TL
TABLE - GME.GME_BATCH_HEADER
TABLE - GME.GME_BATCH_HEADER_MIG
TABLE - GME.GME_BATCH_HISTORY
TABLE - GME.GME_BATCH_MAPPING_MIG
TABLE - GME.GME_BATCH_SALES_ORDERS
TABLE - GME.GME_BATCH_STEPS
TABLE - GME.GME_BATCH_STEPS_MIG
TABLE - GME.GME_BATCH_STEP_ACTIVITIES
TABLE - GME.GME_BATCH_STEP_ACTIV_MIG
TABLE - GME.GME_BATCH_STEP_CHARGES
TABLE - GME.GME_BATCH_STEP_CHARGES_MIG
TABLE - GME.GME_BATCH_STEP_DEPENDENCIES
TABLE - GME.GME_BATCH_STEP_DEP_MIG
TABLE - GME.GME_BATCH_STEP_ITEMS
TABLE - GME.GME_BATCH_STEP_ITEMS_MIG
TABLE - GME.GME_BATCH_STEP_RESOURCES
TABLE - GME.GME_BATCH_STEP_RESOURCES_MIG
TABLE - GME.GME_BATCH_STEP_RSRC_SUMMARY
TABLE - GME.GME_BATCH_STEP_TRANSFERS
TABLE - GME.GME_BATCH_STEP_TRANSFERS_MIG
TABLE - GME.GME_BATCH_TXNS_MIG
TABLE - GME.GME_ERES_GTMP
TABLE - GME.GME_EXCEPTIONS_GTMP
TABLE - GME.GME_GANTT_DOCUMENT_FILTER
TABLE - GME.GME_GANTT_GTMP
TABLE - GME.GME_INVENTORY_TXNS_GTMP
TABLE - GME.GME_LAB_BATCH_LOTS
TABLE - GME.GME_MATERIAL_DETAILS
TABLE - GME.GME_MATERIAL_DETAILS_MIG
TABLE - GME.GME_MATERIAL_DISPENSING_GTMP
TABLE - GME.GME_MIGRATION_CONTROL
TABLE - GME.GME_MTO_RULES
TABLE - GME.GME_MTO_RULE_ASSIGNMENTS
TABLE - GME.GME_PARAMETERS
TABLE - GME.GME_PENDING_PRODUCT_LOTS
TABLE - GME.GME_PROCESS_PARAMETERS
TABLE - GME.GME_PROCESS_PARAMETERS_MIG
TABLE - GME.GME_RESOURCE_TXNS
TABLE - GME.GME_RESOURCE_TXNS_GTMP
TABLE - GME.GME_RESOURCE_TXNS_MIG
TABLE - GME.GME_RESOURCE_TXNS_SUMMARY
TABLE - GME.GME_SCALE_DETAIL
TABLE - GME.GME_TEMP_EXCEPTIONS
TABLE - GME.GME_TEXT_HEADER
TABLE - GME.GME_TEXT_TABLE_TL
TABLE - GME.GME_TRANSACTION_PAIRS
TABLE - GME.GME_UNALLOCATED_ITEMS_GTMP
TABLE - GME.PC_BATCH_STEP_WK
TABLE - GME.PC_RESOURCE_WK
TABLE - GME.PC_TEXT_HDR
TABLE - GME.PC_TEXT_TBL_TL
TABLE - GME.PC_TRAN_PND
TABLE - GME.PC_WIP_INQ_WK
TABLE - GME.PM_BTCH_PKG
TABLE - GME.PM_HIST_HDR
TABLE - GME.PM_OPRN_DTL
TABLE - GME.PM_OPRN_WIP
TABLE - GME.PM_ROUT_DEP
TABLE - GME.PM_ROUT_DTL
TABLE - GME.PM_ROUT_MTL
TABLE - GME.PM_SCAL_DTL
TABLE - GME.PM_TEXT_HDR
TABLE - GME.PM_TEXT_TBL_TL
VIEW - APPS.GME_BATCH_HEADER_V1
VIEW - APPS.GME_BATCH_HEADER_VW
VIEW - APPS.GME_BATCH_STEPS_V
VIEW - APPS.GME_BATCH_STEP_ACTIVITIES_V
VIEW - APPS.GME_BATCH_STEP_ITEMS_V1
VIEW - APPS.GME_BATCH_STEP_RESOURCES_V
VIEW - APPS.GME_INGRED_PICK_VW
VIEW - APPS.GME_INV_TXNS_ERES_V
VIEW - APPS.GME_INV_TXNS_POSTED_ERES_V
VIEW - APPS.GME_INV_TXNS_TEMP_ERES_V
VIEW - APPS.GME_INV_TXN_LOTS_ERES_V
VIEW - APPS.GME_INV_TXN_LOTS_POSTED_ERES_V
VIEW - APPS.GME_INV_TXN_LOTS_TEMP_ERES_V
VIEW - APPS.GME_MATERIAL_DETAILS_V
VIEW - APPS.GME_MATERIAL_DETAILS_V1
VIEW - APPS.GME_PROCESS_PARAMETERS_V
VIEW - APPS.GME_RESOURCE_TXNS_V
VIEW - APPS.GME_STEP_MATERIAL_DETAILS_V
VIEW - APPS.GME_TEXT_TABLE_VL
VIEW - APPS.PC_TEXT_TBL_VL
VIEW - APPS.PM_TEXT_TBL_VL

Table: GME_BATCH_GROUPS_ASSOCIATION

Description: Batch to Group Association

[top of page]

GME.GME_BATCH_GROUPS_ASSOCIATION does not reference any database object

GME.GME_BATCH_GROUPS_ASSOCIATION is referenced by following:

GME
VIEW - GME_BATCH_GROUPS_ASSOCIATION#

[top of page]

Table: GME_BATCH_GROUPS_B

Description: Base table to define the Group to which batches can be associated

[top of page]

GME.GME_BATCH_GROUPS_B does not reference any database object

GME.GME_BATCH_GROUPS_B is referenced by following:

GME
VIEW - GME_BATCH_GROUPS_B#

[top of page]

Table: GME_BATCH_GROUPS_TL

Description: Translated view of batch groups

[top of page]

GME.GME_BATCH_GROUPS_TL does not reference any database object

GME.GME_BATCH_GROUPS_TL is referenced by following:

GME
VIEW - GME_BATCH_GROUPS_TL#

[top of page]

Table: GME_BATCH_HEADER

Description: Batch/FPO header. This table stores the header information for both Firm Planned Orders (FPOs) and Batches, including the plant, the validity rules, formula, and routing on which the batch was based, and the planned and actual start and com
Primary Key: GME_BATCH_HEADER_PK
  1. BATCH_ID

[top of page]

GME.GME_BATCH_HEADER does not reference any database object

GME.GME_BATCH_HEADER is referenced by following:

GME
VIEW - GME_BATCH_HEADER#

[top of page]

Table: GME_BATCH_HEADER_MIG

Description:

[top of page]

GME.GME_BATCH_HEADER_MIG does not reference any database object

GME.GME_BATCH_HEADER_MIG is referenced by following:

GME
VIEW - GME_BATCH_HEADER_MIG#

[top of page]

Table: GME_BATCH_HISTORY

Description: Production history table. History table for the production events. Records event with financial implications, such as status changes and WIP warehouse changes.
Primary Key: GME_BATCH_HISTORY_PK
  1. EVENT_ID

[top of page]

GME.GME_BATCH_HISTORY does not reference any database object

GME.GME_BATCH_HISTORY is referenced by following:

GME
VIEW - GME_BATCH_HISTORY#

[top of page]

Table: GME_BATCH_MAPPING_MIG

Description:

[top of page]

GME.GME_BATCH_MAPPING_MIG does not reference any database object

GME.GME_BATCH_MAPPING_MIG is referenced by following:

GME
VIEW - GME_BATCH_MAPPING_MIG#

[top of page]

Table: GME_BATCH_SALES_ORDERS

Description: This table tracks the sales order(s) used to generate the batch(es).
Primary Key: GME_BATCH_SALES_ORDERS_PK
  1. BATCH_ID
  2. ORDER_ID
  3. LINE_ID

[top of page]

GME.GME_BATCH_SALES_ORDERS does not reference any database object

GME.GME_BATCH_SALES_ORDERS is referenced by following:

GME
VIEW - GME_BATCH_SALES_ORDERS#

[top of page]

Table: GME_BATCH_STEPS

Description: Batch steps table. This table contains data about each step (operation) in a batch, such as the step status and planned and actual start and completion dates.
Primary Key: GME_BATCH_STEPS_PK
  1. BATCHSTEP_ID
Primary Key: GME_BATCH_STEPS_U1
  1. BATCH_ID
  2. BATCHSTEP_NO

[top of page]

GME.GME_BATCH_STEPS does not reference any database object

GME.GME_BATCH_STEPS is referenced by following:

GME
VIEW - GME_BATCH_STEPS#

[top of page]

Table: GME_BATCH_STEPS_MIG

Description:

[top of page]

GME.GME_BATCH_STEPS_MIG does not reference any database object

GME.GME_BATCH_STEPS_MIG is referenced by following:

GME
VIEW - GME_BATCH_STEPS_MIG#

[top of page]

Table: GME_BATCH_STEP_ACTIVITIES

Description: Batch operation (step) details. This table contains information for each activity within a batch step.
Primary Key: GME_BATCH_STEP_ACTIVITIES_PK
  1. BATCHSTEP_ACTIVITY_ID

[top of page]

GME.GME_BATCH_STEP_ACTIVITIES does not reference any database object

GME.GME_BATCH_STEP_ACTIVITIES is referenced by following:

GME
VIEW - GME_BATCH_STEP_ACTIVITIES#

[top of page]

Table: GME_BATCH_STEP_ACTIV_MIG

Description:

[top of page]

GME.GME_BATCH_STEP_ACTIV_MIG does not reference any database object

GME.GME_BATCH_STEP_ACTIV_MIG is referenced by following:

GME
VIEW - GME_BATCH_STEP_ACTIV_MIG#

[top of page]

Table: GME_BATCH_STEP_CHARGES

Description: Table to store the charge details

[top of page]

GME.GME_BATCH_STEP_CHARGES does not reference any database object

GME.GME_BATCH_STEP_CHARGES is referenced by following:

GME
VIEW - GME_BATCH_STEP_CHARGES#

[top of page]

Table: GME_BATCH_STEP_CHARGES_MIG

Description:

[top of page]

GME.GME_BATCH_STEP_CHARGES_MIG does not reference any database object

GME.GME_BATCH_STEP_CHARGES_MIG is referenced by following:

GME
VIEW - GME_BATCH_STEP_CHARGES_MIG#

[top of page]

Table: GME_BATCH_STEP_DEPENDENCIES

Description: This table contains data about dependencies between batch steps. For example, the start of a step can be dependent on the completion of a previous step
Primary Key: GME_BATCH_STEP_DEPENDENCIES_PK
  1. BATCH_ID
  2. BATCHSTEP_ID
  3. DEP_STEP_ID

[top of page]

GME.GME_BATCH_STEP_DEPENDENCIES does not reference any database object

GME.GME_BATCH_STEP_DEPENDENCIES is referenced by following:

GME
VIEW - GME_BATCH_STEP_DEPENDENCIES#

[top of page]

Table: GME_BATCH_STEP_DEP_MIG

Description:

[top of page]

GME.GME_BATCH_STEP_DEP_MIG does not reference any database object

GME.GME_BATCH_STEP_DEP_MIG is referenced by following:

GME
VIEW - GME_BATCH_STEP_DEP_MIG#

[top of page]

Table: GME_BATCH_STEP_ITEMS

Description: This table defines relationship between batch steps and batch lines. For example, if the third ingredient in a batch is consumed in the second step, that information is stored in this table.
Primary Key: GME_BATCH_STEP_ITEMS_PK
  1. MATERIAL_DETAIL_ID

[top of page]

GME.GME_BATCH_STEP_ITEMS does not reference any database object

GME.GME_BATCH_STEP_ITEMS is referenced by following:

GME
VIEW - GME_BATCH_STEP_ITEMS#

[top of page]

Table: GME_BATCH_STEP_ITEMS_MIG

Description:

[top of page]

GME.GME_BATCH_STEP_ITEMS_MIG does not reference any database object

GME.GME_BATCH_STEP_ITEMS_MIG is referenced by following:

GME
VIEW - GME_BATCH_STEP_ITEMS_MIG#

[top of page]

Table: GME_BATCH_STEP_RESOURCES

Description: Batch operation (step) details. This table contains information for each resource within an activity of batch step.
Primary Key: GME_BATCH_STEP_RESOURCES_PK
  1. BATCHSTEP_RESOURCE_ID

[top of page]

GME.GME_BATCH_STEP_RESOURCES does not reference any database object

GME.GME_BATCH_STEP_RESOURCES is referenced by following:

GME
VIEW - GME_BATCH_STEP_RESOURCES#

[top of page]

Table: GME_BATCH_STEP_RESOURCES_MIG

Description:

[top of page]

GME.GME_BATCH_STEP_RESOURCES_MIG does not reference any database object

GME.GME_BATCH_STEP_RESOURCES_MIG is referenced by following:

GME
VIEW - GME_BATCH_STEP_RESOURCES_MIG#

[top of page]

Table: GME_BATCH_STEP_RSRC_SUMMARY

Description: Batch step resource usages for Pending and WIP batch steps
Primary Key: GME_BATCH_STEP_RSRC_SUMMARY_PK
  1. BATCHSTEP_RESOURCE_ID

[top of page]

GME.GME_BATCH_STEP_RSRC_SUMMARY does not reference any database object

GME.GME_BATCH_STEP_RSRC_SUMMARY is referenced by following:

GME
VIEW - GME_BATCH_STEP_RSRC_SUMMARY#

[top of page]

Table: GME_BATCH_STEP_TRANSFERS

Description: This table records information (quantity and date) about material that a step has received from a previous step and material that it has sent on to a subsequent step
Primary Key: GME_BATCH_STEP_TRANSFERS_PK
  1. WIP_TRANS_ID

[top of page]

GME.GME_BATCH_STEP_TRANSFERS does not reference any database object

GME.GME_BATCH_STEP_TRANSFERS is referenced by following:

GME
VIEW - GME_BATCH_STEP_TRANSFERS#

[top of page]

Table: GME_BATCH_STEP_TRANSFERS_MIG

Description:

[top of page]

GME.GME_BATCH_STEP_TRANSFERS_MIG does not reference any database object

GME.GME_BATCH_STEP_TRANSFERS_MIG is referenced by following:

GME
VIEW - GME_BATCH_STEP_TRANSFERS_MIG#

[top of page]

Table: GME_BATCH_TXNS_MIG

Description:

[top of page]

GME.GME_BATCH_TXNS_MIG does not reference any database object

GME.GME_BATCH_TXNS_MIG is referenced by following:

GME
VIEW - GME_BATCH_TXNS_MIG#

[top of page]

Table: GME_ERES_GTMP

Description:

[top of page]

GME.GME_ERES_GTMP does not reference any database object

GME.GME_ERES_GTMP is referenced by following:

APPS
SYNONYM - GME_ERES_GTMP

[top of page]

Table: GME_EXCEPTIONS_GTMP

Description: This is a new table that holds material details information for the exception materials

[top of page]

GME.GME_EXCEPTIONS_GTMP does not reference any database object

GME.GME_EXCEPTIONS_GTMP is referenced by following:

APPS
SYNONYM - GME_EXCEPTIONS_GTMP

[top of page]

Table: GME_GANTT_DOCUMENT_FILTER

Description: Filter for the GME Gantt Chart informaiton

[top of page]

GME.GME_GANTT_DOCUMENT_FILTER does not reference any database object

GME.GME_GANTT_DOCUMENT_FILTER is referenced by following:

GME
VIEW - GME_GANTT_DOCUMENT_FILTER#

[top of page]

Table: GME_GANTT_GTMP

Description:

[top of page]

GME.GME_GANTT_GTMP does not reference any database object

GME.GME_GANTT_GTMP is referenced by following:

APPS
SYNONYM - GME_GANTT_GTMP

[top of page]

Table: GME_INVENTORY_TXNS_GTMP

Description:

[top of page]

GME.GME_INVENTORY_TXNS_GTMP does not reference any database object

GME.GME_INVENTORY_TXNS_GTMP is referenced by following:

APPS
SYNONYM - GME_INVENTORY_TXNS_GTMP

[top of page]

Table: GME_LAB_BATCH_LOTS

Description: This tables tracks lot values for a Lab batch when inventory is not updated for lot-controlled items.
Primary Key: GME_LAB_BATCH_LOTS_PK
  1. BATCH_ID
  2. MATERIAL_DETAIL_ID
  3. ITEM_ID
  4. LOT_ID

[top of page]

GME.GME_LAB_BATCH_LOTS does not reference any database object

GME.GME_LAB_BATCH_LOTS is referenced by following:

GME
VIEW - GME_LAB_BATCH_LOTS#

[top of page]

Table: GME_MATERIAL_DETAILS

Description: New quantity columns; for scaling a WIP batch. Actual quantities must match on the PM & POC sides. If a WIP batch is scaled the actual quantity is not updated on the PM side; therefore the value needs to be tracked elsewhere.Batch or FPO
Primary Key: GME_MATERIAL_DETAILS_PK
  1. MATERIAL_DETAIL_ID
Primary Key: GME_MATERIAL_DETAILS_U1
  1. BATCH_ID
  2. LINE_NO
  3. LINE_TYPE

[top of page]

GME.GME_MATERIAL_DETAILS does not reference any database object

GME.GME_MATERIAL_DETAILS is referenced by following:

GME
VIEW - GME_MATERIAL_DETAILS#

[top of page]

Table: GME_MATERIAL_DETAILS_MIG

Description:

[top of page]

GME.GME_MATERIAL_DETAILS_MIG does not reference any database object

GME.GME_MATERIAL_DETAILS_MIG is referenced by following:

GME
VIEW - GME_MATERIAL_DETAILS_MIG#

[top of page]

Table: GME_MATERIAL_DISPENSING_GTMP

Description:

[top of page]

GME.GME_MATERIAL_DISPENSING_GTMP does not reference any database object

GME.GME_MATERIAL_DISPENSING_GTMP is referenced by following:

APPS
SYNONYM - GME_MATERIAL_DISPENSING_GTMP

[top of page]

Table: GME_MIGRATION_CONTROL

Description: Control Table for Migration to determine whether a table has been migrated

[top of page]

GME.GME_MIGRATION_CONTROL does not reference any database object

GME.GME_MIGRATION_CONTROL is referenced by following:

GME
VIEW - GME_MIGRATION_CONTROL#

[top of page]

Table: GME_MTO_RULES

Description: This table store Make to Order Rules
Primary Key: GME_MTO_RULES_PK
  1. RULE_ID

[top of page]

GME.GME_MTO_RULES does not reference any database object

GME.GME_MTO_RULES is referenced by following:

GME
VIEW - GME_MTO_RULES#

[top of page]

Table: GME_MTO_RULE_ASSIGNMENTS

Description: This table stores association between Make to Order Rule to Assignment
Primary Key: GME_MTO_RULE_ASSIGNMENTS_PK
  1. RULE_ASSIGN_ID

[top of page]

GME.GME_MTO_RULE_ASSIGNMENTS does not reference any database object

GME.GME_MTO_RULE_ASSIGNMENTS is referenced by following:

GME
VIEW - GME_MTO_RULE_ASSIGNMENTS#

[top of page]

Table: GME_PARAMETERS

Description: This is a new table that holds all the GME parameters at the org level

[top of page]

GME.GME_PARAMETERS does not reference any database object

GME.GME_PARAMETERS is referenced by following:

GME
VIEW - GME_PARAMETERS#

[top of page]

Table: GME_PENDING_PRODUCT_LOTS

Description: This table contains the lots information for the lab batches, and the lot information for the products/byproducts for production batches.
Primary Key: GME_PENDING_PRODUCT_LOTS_U1
  1. PENDING_PRODUCT_LOT_ID

[top of page]

GME.GME_PENDING_PRODUCT_LOTS does not reference any database object

GME.GME_PENDING_PRODUCT_LOTS is referenced by following:

GME
VIEW - GME_PENDING_PRODUCT_LOTS#

[top of page]

Table: GME_PROCESS_PARAMETERS

Description: GME Process Parameters, table to store actual values of Process Parameters attached to a resource
Primary Key: GME_PROCESS_PARAMETERS_PK
  1. PROCESS_PARAM_ID

[top of page]

GME.GME_PROCESS_PARAMETERS does not reference any database object

GME.GME_PROCESS_PARAMETERS is referenced by following:

GME
VIEW - GME_PROCESS_PARAMETERS#

[top of page]

Table: GME_PROCESS_PARAMETERS_MIG

Description:

[top of page]

GME.GME_PROCESS_PARAMETERS_MIG does not reference any database object

GME.GME_PROCESS_PARAMETERS_MIG is referenced by following:

GME
VIEW - GME_PROCESS_PARAMETERS_MIG#

[top of page]

Table: GME_RESOURCE_TXNS

Description: Process operations control transaction table. This table stores resource transactions created in POC.
Primary Key: GME_RESOURCE_TXNS_PK
  1. POC_TRANS_ID

[top of page]

GME.GME_RESOURCE_TXNS does not reference any database object

GME.GME_RESOURCE_TXNS is referenced by following:

GME
VIEW - GME_RESOURCE_TXNS#

[top of page]

Table: GME_RESOURCE_TXNS_GTMP

Description:

[top of page]

GME.GME_RESOURCE_TXNS_GTMP does not reference any database object

GME.GME_RESOURCE_TXNS_GTMP is referenced by following:

APPS
SYNONYM - GME_RESOURCE_TXNS_GTMP

[top of page]

Table: GME_RESOURCE_TXNS_MIG

Description:

[top of page]

GME.GME_RESOURCE_TXNS_MIG does not reference any database object

GME.GME_RESOURCE_TXNS_MIG is referenced by following:

GME
VIEW - GME_RESOURCE_TXNS_MIG#

[top of page]

Table: GME_RESOURCE_TXNS_SUMMARY

Description: Pending resource transaction summary

[top of page]

GME.GME_RESOURCE_TXNS_SUMMARY does not reference any database object

GME.GME_RESOURCE_TXNS_SUMMARY is referenced by following:

GME
VIEW - GME_RESOURCE_TXNS_SUMMARY#

[top of page]

Table: GME_SCALE_DETAIL

Description: Table used by the Batch Yield Variance and Batch Usage and Substitution Variance reports to hold scaled batch data.

[top of page]

GME.GME_SCALE_DETAIL does not reference any database object

GME.GME_SCALE_DETAIL is referenced by following:

GME
VIEW - GME_SCALE_DETAIL#

[top of page]

Table: GME_TEMP_EXCEPTIONS

Description: Used to store the exceptions during the migration of data

[top of page]

GME.GME_TEMP_EXCEPTIONS does not reference any database object

GME.GME_TEMP_EXCEPTIONS is referenced by following:

GME
VIEW - GME_TEMP_EXCEPTIONS#

[top of page]

Table: GME_TEXT_HEADER

Description: Master table for creation and storage of text codes associated with Process Execution tables.

[top of page]

GME.GME_TEXT_HEADER does not reference any database object

GME.GME_TEXT_HEADER is referenced by following:

GME
VIEW - GME_TEXT_HEADER#

[top of page]

Table: GME_TEXT_TABLE_TL

Description: Production Management module text lines. Descriptive text for all tables in this module
Primary Key: GME_TEXT_TABLE_TL_PK
  1. TEXT_CODE
  2. LANG_CODE
  3. PARAGRAPH_CODE
  4. SUB_PARACODE
  5. LINE_NO
  6. LANGUAGE

[top of page]

GME.GME_TEXT_TABLE_TL does not reference any database object

GME.GME_TEXT_TABLE_TL is referenced by following:

GME
VIEW - GME_TEXT_TABLE_TL#

[top of page]

Table: GME_TRANSACTION_PAIRS

Description: This table store relationship between transaction row and its reversal

[top of page]

GME.GME_TRANSACTION_PAIRS does not reference any database object

GME.GME_TRANSACTION_PAIRS is referenced by following:

GME
VIEW - GME_TRANSACTION_PAIRS#

[top of page]

Table: GME_UNALLOCATED_ITEMS_GTMP

Description:

[top of page]

GME.GME_UNALLOCATED_ITEMS_GTMP does not reference any database object

GME.GME_UNALLOCATED_ITEMS_GTMP is referenced by following:

APPS
SYNONYM - GME_UNALLOCATED_ITEMS_GTMP

[top of page]

Table: PC_BATCH_STEP_WK

Description: Batch Step Variance Inquiry table.
Primary Key: PC_BATCH_STEP_WK_PK
  1. SEQ_ID
  2. BATCH_ID

[top of page]

GME.PC_BATCH_STEP_WK does not reference any database object

GME.PC_BATCH_STEP_WK is referenced by following:

GME
VIEW - PC_BATCH_STEP_WK#

[top of page]

Table: PC_RESOURCE_WK

Description: Resource Variance Inquiry table.
Primary Key: PC_RESOURCE_WK_PK
  1. SEQ_ID
  2. RESOURCES
  3. BATCH_ID
  4. BATCHSTEP_NO
  5. ACTIVITY

[top of page]

GME.PC_RESOURCE_WK does not reference any database object

GME.PC_RESOURCE_WK is referenced by following:

GME
VIEW - PC_RESOURCE_WK#

[top of page]

Table: PC_TEXT_HDR

Description: Table used to store text types for POC
Primary Key: PC_TEXT_HDR_PK
  1. TEXT_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
PC_TRAN_PND.TEXT_CODE PC_TEXT_HDR
PM_OPRN_WIP.TEXT_CODE PC_TEXT_HDR
PM_ROUT_DTL.TEXT_CODE PC_TEXT_HDR
PM_TEXT_TBL_TL.PM_TEXT_TBL_TL_TEXT_CODE PC_TEXT_HDR

[top of page]

GME.PC_TEXT_HDR does not reference any database object

GME.PC_TEXT_HDR is referenced by following:

GME
VIEW - PC_TEXT_HDR#

[top of page]

Table: PC_TEXT_TBL_TL

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

[top of page]

GME.PC_TEXT_TBL_TL does not reference any database object

GME.PC_TEXT_TBL_TL is referenced by following:

GME
VIEW - PC_TEXT_TBL_TL#

[top of page]

Table: PC_TRAN_PND

Description: POC transaction table.
Primary Key: PC_TRAN_PND_PK
  1. POC_TRANS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PC_TRAN_PND.TEXT_CODE PC_TEXT_HDR
PC_TRAN_PND.EVENT_ID PM_HIST_HDR
PC_TRAN_PND.DOC_TYPE SY_DOCS_MST
PC_TRAN_PND.ORGN_CODE SY_ORGN_MST_B
PC_TRAN_PND.ORGN_CODE SY_ORGN_MST
PC_TRAN_PND.REASON_CODE SY_REAS_CDS_B
PC_TRAN_PND.REASON_CODE SY_REAS_CDS
PC_TRAN_PND.TRANS_UM SY_UOMS_MST

[top of page]

GME.PC_TRAN_PND does not reference any database object

GME.PC_TRAN_PND is referenced by following:

GME
VIEW - PC_TRAN_PND#

[top of page]

Table: PC_WIP_INQ_WK

Description: WIP Inquiry table.
Primary Key: PC_WIP_INQ_WK_PK
  1. SEQ_ID
  2. BATCH_ID

[top of page]

GME.PC_WIP_INQ_WK does not reference any database object

GME.PC_WIP_INQ_WK is referenced by following:

GME
VIEW - PC_WIP_INQ_WK#

[top of page]

Table: PM_BTCH_PKG

Description: * NOT USED *
Primary Key: PM_BTCH_PKG_PK
  1. BULK_BATCH_ID
  2. BULK_LINE_ID
  3. PKG_BATCH_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PM_BTCH_PKG.BULK_BATCH_ID PM_BTCH_HDR
PM_BTCH_PKG.PKG_BATCH_ID PM_BTCH_HDR
PM_BTCH_PKG.BULK_BATCH_ID
PM_BTCH_PKG.BULK_LINE_ID 		PM_MATL_DTL

[top of page]

GME.PM_BTCH_PKG does not reference any database object

GME.PM_BTCH_PKG is referenced by following:

GME
VIEW - PM_BTCH_PKG#

[top of page]

Table: PM_HIST_HDR

Description: Production history table.
Primary Key: PM_HIST_HDR_PK
  1. EVENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PM_HIST_HDR.ORIG_WIP_WHSE IC_WHSE_MST
PM_HIST_HDR.NEW_WIP_WHSE IC_WHSE_MST
PM_HIST_HDR.BATCH_ID PM_BTCH_HDR
Foreign Keys to this table:
Foreign Key Column Foreign Table
PC_TRAN_PND.EVENT_ID PM_HIST_HDR

[top of page]

GME.PM_HIST_HDR does not reference any database object

GME.PM_HIST_HDR is referenced by following:

GME
VIEW - PM_HIST_HDR#

[top of page]

Table: PM_OPRN_DTL

Description: Batch operation details.
Primary Key: PM_OPRN_DTL_PK
  1. BATCH_ID
  2. BATCHSTEP_NO
  3. RESOURCES
  4. ACTIVITY
  5. BATCHSTEPLINE_ID
Primary Key: PM_OPRN_DTL_U1
  1. BATCHSTEPLINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PM_OPRN_DTL.COST_ANALYSIS_CODE CM_ALYS_MST
PM_OPRN_DTL.COST_CMPNTCLS_ID %
PM_OPRN_DTL.COST_CMPNTCLS_ID CM_CMPT_MST
PM_OPRN_DTL.RESOURCES %
PM_OPRN_DTL.RESOURCES CR_RSRC_MST
PM_OPRN_DTL.ACTIVITY FM_ACTV_MST
PM_OPRN_DTL.OPRN_LINE_ID FM_OPRN_DTL
PM_OPRN_DTL.ACTIVITY GMD_ACTIVITIES_B
PM_OPRN_DTL.BATCH_ID
PM_OPRN_DTL.BATCHSTEP_NO 		PM_ROUT_DTL
PM_OPRN_DTL.TEXT_CODE PM_TEXT_HDR
PM_OPRN_DTL.USAGE_UM SY_UOMS_MST

[top of page]

GME.PM_OPRN_DTL does not reference any database object

GME.PM_OPRN_DTL is referenced by following:

GME
VIEW - PM_OPRN_DTL#

[top of page]

Table: PM_OPRN_WIP

Description: Completed incoming/output WIP transactions.
Primary Key: PM_OPRN_WIP_PK
  1. WIP_TRANS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PM_OPRN_WIP.TEXT_CODE PC_TEXT_HDR
PM_OPRN_WIP.BATCH_ID
PM_OPRN_WIP.BATCHSTEP_NO 		PM_ROUT_DTL
PM_OPRN_WIP.BATCH_ID
PM_OPRN_WIP.TRANSFER_STEP_NO 		PM_ROUT_DTL
PM_OPRN_WIP.TRANS_UM SY_UOMS_MST

[top of page]

GME.PM_OPRN_WIP does not reference any database object

GME.PM_OPRN_WIP is referenced by following:

GME
VIEW - PM_OPRN_WIP#

[top of page]

Table: PM_ROUT_DEP

Description: Non-standard batch steps dependencies.
Primary Key: PM_ROUT_DEP_PK
  1. BATCH_ID
  2. BATCHSTEP_NO
  3. DEP_TYPE
  4. DEP_STEP_NO
Foreign Keys from this table:
Foreign Key Column Foreign Table
PM_ROUT_DEP.BATCH_ID
PM_ROUT_DEP.BATCHSTEP_NO 		PM_ROUT_DTL
PM_ROUT_DEP.TEXT_CODE PM_TEXT_HDR
PM_ROUT_DEP.TRANSFER_UM SY_UOMS_MST

[top of page]

GME.PM_ROUT_DEP does not reference any database object

GME.PM_ROUT_DEP is referenced by following:

GME
VIEW - PM_ROUT_DEP#

[top of page]

Table: PM_ROUT_DTL

Description: Batch routing steps.
Primary Key: PM_ROUT_DTL_PK
  1. BATCH_ID
  2. BATCHSTEP_NO
Foreign Keys from this table:
Foreign Key Column Foreign Table
PM_ROUT_DTL.OPRN_ID FM_OPRN_MST
PM_ROUT_DTL.ROUTINGSTEP_ID FM_ROUT_DTL
PM_ROUT_DTL.TEXT_CODE PC_TEXT_HDR
PM_ROUT_DTL.BATCH_ID PM_BTCH_HDR
Foreign Keys to this table:
Foreign Key Column Foreign Table
PM_OPRN_DTL.BATCH_ID
PM_OPRN_DTL.BATCHSTEP_NO 		PM_ROUT_DTL
PM_OPRN_WIP.BATCH_ID
PM_OPRN_WIP.BATCHSTEP_NO 		PM_ROUT_DTL
PM_OPRN_WIP.BATCH_ID
PM_OPRN_WIP.TRANSFER_STEP_NO 		PM_ROUT_DTL
PM_ROUT_DEP.BATCH_ID
PM_ROUT_DEP.BATCHSTEP_NO 		PM_ROUT_DTL
PM_ROUT_MTL.BATCH_ID
PM_ROUT_MTL.BATCHSTEP_NO 		PM_ROUT_DTL

[top of page]

GME.PM_ROUT_DTL does not reference any database object

GME.PM_ROUT_DTL is referenced by following:

GME
VIEW - PM_ROUT_DTL#

[top of page]

Table: PM_ROUT_MTL

Description: Batch steps to batch lines relationships.
Primary Key: PM_ROUT_MTL_PK
  1. BATCHLINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PM_ROUT_MTL.BATCH_ID
PM_ROUT_MTL.BATCHLINE_ID 		PM_MATL_DTL
PM_ROUT_MTL.BATCH_ID
PM_ROUT_MTL.BATCHSTEP_NO 		PM_ROUT_DTL
PM_ROUT_MTL.TEXT_CODE PM_TEXT_HDR

[top of page]

GME.PM_ROUT_MTL does not reference any database object

GME.PM_ROUT_MTL is referenced by following:

GME
VIEW - PM_ROUT_MTL#

[top of page]

Table: PM_SCAL_DTL

Description: Variance reports table.

[top of page]

GME.PM_SCAL_DTL does not reference any database object

GME.PM_SCAL_DTL is referenced by following:

GME
VIEW - PM_SCAL_DTL#

[top of page]

Table: PM_TEXT_HDR

Description: Table used to store text types for Production Management
Primary Key: PM_TEXT_HDR_PK
  1. TEXT_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
PM_BTCH_HDR.TEXT_CODE PM_TEXT_HDR
PM_MATL_DTL.TEXT_CODE PM_TEXT_HDR
PM_OPRN_DTL.TEXT_CODE PM_TEXT_HDR
PM_ROUT_DEP.TEXT_CODE PM_TEXT_HDR
PM_ROUT_MTL.TEXT_CODE PM_TEXT_HDR

[top of page]

GME.PM_TEXT_HDR does not reference any database object

GME.PM_TEXT_HDR is referenced by following:

GME
VIEW - PM_TEXT_HDR#

[top of page]

Table: PM_TEXT_TBL_TL

Description: PM Module Text Lines. Descriptive text for all tables in this module.
Primary Key: PM_TEXT_TBL_TL_PK
  1. TEXT_CODE
  2. LANG_CODE
  3. PARAGRAPH_CODE
  4. SUB_PARACODE
  5. LINE_NO
  6. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PM_TEXT_TBL_TL.PM_TEXT_TBL_TL_TEXT_CODE PC_TEXT_HDR

[top of page]

GME.PM_TEXT_TBL_TL does not reference any database object

GME.PM_TEXT_TBL_TL is referenced by following:

GME
VIEW - PM_TEXT_TBL_TL#

[top of page]

View: GME_BATCH_HEADER_V1

[top of page]

APPS.GME_BATCH_HEADER_V1 references the following:

APPS
SYNONYM - GME_BATCH_HEADER
APPS.GME_BATCH_HEADER_V1 is referenced by following:

APPS
SYNONYM - PM_BTCH_HDR

[top of page]

View: GME_BATCH_HEADER_VW

[top of page]

APPS.GME_BATCH_HEADER_VW references the following:

APPS
SYNONYM - FM_FORM_MST
SYNONYM - FM_ROUT_HDR
PACKAGE - FND_DATE
SYNONYM - FND_LOOKUP_VALUES
PACKAGE - FND_MESSAGE
SYNONYM - GMD_RECIPES
SYNONYM - GMD_RECIPE_VALIDITY_RULES
SYNONYM - GME_BATCH_HEADER
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_TRANSACTION_REASONS
APPS.GME_BATCH_HEADER_VW is referenced by following:

APPS
VIEW - GMF_SUBLEDGER_REP_V
VIEW - GMF_XLA_PM_RSRC_TXNS_V
VIEW - GMF_XLA_PM_TXNS_V
VIEW - MTL_MFG_BATCHES_SECURITY_V

[top of page]

View: GME_BATCH_STEPS_V

[top of page]

APPS.GME_BATCH_STEPS_V references the following:

APPS
PACKAGE - FND_DATE
PACKAGE - FND_MESSAGE
PACKAGE - FND_TIMEZONES
VIEW - GEM_LOOKUPS
SYNONYM - GMD_OPERATIONS
SYNONYM - GME_BATCH_STEPS
APPS.GME_BATCH_STEPS_V is referenced by following:

APPS
VIEW - GME_BATCH_STEP_ACTIVITIES_V

[top of page]

View: GME_BATCH_STEP_ACTIVITIES_V

[top of page]

APPS.GME_BATCH_STEP_ACTIVITIES_V references the following:

APPS
PACKAGE - FND_DATE
PACKAGE - FND_MESSAGE
PACKAGE - FND_TIMEZONES
VIEW - GMD_ACTIVITIES_VL
VIEW - GME_BATCH_STEPS_V
SYNONYM - GME_BATCH_STEP_ACTIVITIES

APPS.GME_BATCH_STEP_ACTIVITIES_V is not referenced by any database object

[top of page]

View: GME_BATCH_STEP_ITEMS_V1

[top of page]

APPS.GME_BATCH_STEP_ITEMS_V1 references the following:

APPS
SYNONYM - GME_BATCH_STEP_ITEMS
SYNONYM - GME_MATERIAL_DETAILS

APPS.GME_BATCH_STEP_ITEMS_V1 is not referenced by any database object

[top of page]

View: GME_BATCH_STEP_RESOURCES_V

[top of page]

APPS.GME_BATCH_STEP_RESOURCES_V references the following:

APPS
PACKAGE - FND_DATE
PACKAGE - FND_TIMEZONES
SYNONYM - GME_BATCH_STEP_RESOURCES
- CR_RSRC_MST

APPS.GME_BATCH_STEP_RESOURCES_V is not referenced by any database object

[top of page]

View: GME_INGRED_PICK_VW

[top of page]

APPS.GME_INGRED_PICK_VW references the following:

APPS
SYNONYM - GMD_OPERATIONS_B
SYNONYM - GME_BATCH_HEADER
SYNONYM - GME_BATCH_STEPS
SYNONYM - GME_BATCH_STEP_ITEMS
SYNONYM - GME_MATERIAL_DETAILS
PACKAGE - GME_PICKING_PVT
- MTL_SYSTEM_ITEMS_VL

APPS.GME_INGRED_PICK_VW is not referenced by any database object

[top of page]

View: GME_INV_TXNS_ERES_V

[top of page]

APPS.GME_INV_TXNS_ERES_V references the following:

APPS
PACKAGE - FND_DATE
SYNONYM - MTL_LOT_NUMBERS
SYNONYM - MTL_MATERIAL_STATUSES_TL
SYNONYM - MTL_MATERIAL_TRANSACTIONS
SYNONYM - MTL_MATERIAL_TRANSACTIONS_TEMP
SYNONYM - MTL_TRANSACTION_REASONS
SYNONYM - MTL_TRANSACTION_TYPES
- MTL_ITEM_LOCATIONS_KFV

APPS.GME_INV_TXNS_ERES_V is not referenced by any database object

[top of page]

View: GME_INV_TXNS_POSTED_ERES_V

[top of page]

APPS.GME_INV_TXNS_POSTED_ERES_V references the following:

APPS
PACKAGE - FND_DATE
SYNONYM - MTL_MATERIAL_TRANSACTIONS
SYNONYM - MTL_TRANSACTION_REASONS
SYNONYM - MTL_TRANSACTION_TYPES
- MTL_ITEM_LOCATIONS_KFV

APPS.GME_INV_TXNS_POSTED_ERES_V is not referenced by any database object

[top of page]

View: GME_INV_TXNS_TEMP_ERES_V

[top of page]

APPS.GME_INV_TXNS_TEMP_ERES_V references the following:

APPS
PACKAGE - FND_DATE
SYNONYM - MTL_LOT_NUMBERS
SYNONYM - MTL_MATERIAL_STATUSES_TL
SYNONYM - MTL_MATERIAL_TRANSACTIONS_TEMP
SYNONYM - MTL_TRANSACTION_REASONS
SYNONYM - MTL_TRANSACTION_TYPES
- MTL_ITEM_LOCATIONS_KFV

APPS.GME_INV_TXNS_TEMP_ERES_V is not referenced by any database object

[top of page]

View: GME_INV_TXN_LOTS_ERES_V

[top of page]

APPS.GME_INV_TXN_LOTS_ERES_V references the following:

APPS
PACKAGE - FND_DATE
SYNONYM - MTL_LOT_NUMBERS
SYNONYM - MTL_MATERIAL_STATUSES_TL
SYNONYM - MTL_MATERIAL_TRANSACTIONS
SYNONYM - MTL_MATERIAL_TRANSACTIONS_TEMP
SYNONYM - MTL_TRANSACTION_LOTS_TEMP
SYNONYM - MTL_TRANSACTION_LOT_NUMBERS

APPS.GME_INV_TXN_LOTS_ERES_V is not referenced by any database object

[top of page]

View: GME_INV_TXN_LOTS_POSTED_ERES_V

[top of page]

APPS.GME_INV_TXN_LOTS_POSTED_ERES_V references the following:

APPS
PACKAGE - FND_DATE
SYNONYM - MTL_LOT_NUMBERS
SYNONYM - MTL_MATERIAL_STATUSES_TL
SYNONYM - MTL_MATERIAL_TRANSACTIONS
SYNONYM - MTL_TRANSACTION_LOT_NUMBERS

APPS.GME_INV_TXN_LOTS_POSTED_ERES_V is not referenced by any database object

[top of page]

View: GME_INV_TXN_LOTS_TEMP_ERES_V

[top of page]

APPS.GME_INV_TXN_LOTS_TEMP_ERES_V references the following:

APPS
PACKAGE - FND_DATE
SYNONYM - MTL_LOT_NUMBERS
SYNONYM - MTL_MATERIAL_STATUSES_TL
SYNONYM - MTL_MATERIAL_TRANSACTIONS_TEMP
SYNONYM - MTL_TRANSACTION_LOTS_TEMP

APPS.GME_INV_TXN_LOTS_TEMP_ERES_V is not referenced by any database object

[top of page]

View: GME_MATERIAL_DETAILS_V

[top of page]

APPS.GME_MATERIAL_DETAILS_V references the following:

APPS
PACKAGE - FND_DATE
PACKAGE - FND_TIMEZONES
VIEW - GEM_LOOKUPS
SYNONYM - GME_BATCH_HEADER
SYNONYM - GME_MATERIAL_DETAILS
- MTL_ITEM_LOCATIONS_KFV
- MTL_SYSTEM_ITEMS_VL

APPS.GME_MATERIAL_DETAILS_V is not referenced by any database object

[top of page]

View: GME_MATERIAL_DETAILS_V1

[top of page]

APPS.GME_MATERIAL_DETAILS_V1 references the following:

APPS
SYNONYM - GME_MATERIAL_DETAILS

APPS.GME_MATERIAL_DETAILS_V1 is not referenced by any database object

[top of page]

View: GME_PROCESS_PARAMETERS_V

[top of page]

APPS.GME_PROCESS_PARAMETERS_V references the following:

APPS
SYNONYM - GME_PROCESS_PARAMETERS
- GMP_PROCESS_PARAMETERS_VL

APPS.GME_PROCESS_PARAMETERS_V is not referenced by any database object

[top of page]

View: GME_RESOURCE_TXNS_V

[top of page]

APPS.GME_RESOURCE_TXNS_V references the following:

APPS
PACKAGE - FND_DATE
PACKAGE - FND_TIMEZONES
SYNONYM - GME_RESOURCE_TXNS
SYNONYM - GME_RESOURCE_TXNS_GTMP
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_TRANSACTION_REASONS

APPS.GME_RESOURCE_TXNS_V is not referenced by any database object

[top of page]

View: GME_STEP_MATERIAL_DETAILS_V

[top of page]

APPS.GME_STEP_MATERIAL_DETAILS_V references the following:

APPS
PACKAGE - FND_DATE
PACKAGE - FND_TIMEZONES
VIEW - GEM_LOOKUPS
SYNONYM - GME_BATCH_STEP_ITEMS
SYNONYM - GME_MATERIAL_DETAILS
- MTL_ITEM_LOCATIONS_KFV
- MTL_SYSTEM_ITEMS_VL

APPS.GME_STEP_MATERIAL_DETAILS_V is not referenced by any database object

[top of page]

View: GME_TEXT_TABLE_VL

[top of page]

APPS.GME_TEXT_TABLE_VL references the following:

APPS
SYNONYM - GME_TEXT_TABLE_TL

APPS.GME_TEXT_TABLE_VL is not referenced by any database object

[top of page]

View: PC_TEXT_TBL_VL

[top of page]

APPS.PC_TEXT_TBL_VL references the following:

APPS
SYNONYM - PC_TEXT_TBL_TL
APPS.PC_TEXT_TBL_VL is referenced by following:

APPS
TRIGGER - GMA_PC_TEXT_TBL_T1
TRIGGER - GMA_PC_TEXT_TBL_T2
TRIGGER - GMA_PC_TEXT_TBL_T3
SYNONYM - PC_TEXT_TBL

[top of page]

View: PM_TEXT_TBL_VL

[top of page]

APPS.PM_TEXT_TBL_VL references the following:

APPS
SYNONYM - PM_TEXT_TBL_TL
APPS.PM_TEXT_TBL_VL is referenced by following:

APPS
TRIGGER - GMA_PM_TEXT_TBL_T1
TRIGGER - GMA_PM_TEXT_TBL_T2
TRIGGER - GMA_PM_TEXT_TBL_T3
SYNONYM - PM_TEXT_TBL

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