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.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
Comments

Alternate resource table.

Indexes
Index Type Tablespace Column
CR_ARES_MST_PK UNIQUE APPS_TS_SEED PRIMARY_RESOURCE
ALTERNATE_RESOURCE
Columns
Name Datatype Length Mandatory Comments
PRIMARY_RESOURCE VARCHAR2 (16) Y Primary resource
ALTERNATE_RESOURCE VARCHAR2 (16) Y Resource which can be used in place of primary resource
SETUP_FACTOR NUMBER

Factor by which setup time of primary resource must be multiplied when using the alternate resource
RUNTIME_FACTOR NUMBER
Y Factor by which runtime of primary resource must be multiplied when using the alternate resource
POSTOP_FACTOR NUMBER

Factor by which postop time of primary resource must be multiplied when using the alternate resource
DELETE_MARK NUMBER
Y Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TRANS_CNT NUMBER

Not currently used
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
PREFERENCE NUMBER (16)
Preference for use planning and scheduling

[top of page]

GMP.CR_ARES_MST does not reference any database object

GMP.CR_ARES_MST is referenced by following:

APPS
SYNONYM - 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
Comments

Demand order priority table. Allows priority to be set on sales
orders for prioritization in Rhythm.

Indexes
Index Type Tablespace Column
CR_DOPR_TBL_PK UNIQUE APPS_TS_TX_IDX LINE_ID
Columns
Name Datatype Length Mandatory Comments
ORDER_ID NUMBER
Y Surrogate key for a sales order.
LINE_ID NUMBER (10) Y Surrogate key for a sales order line.
PRIORITY NUMBER
Y Priority to be given to the sales order line. The lower the number, higher the priority.
TRANS_CNT NUMBER

Not currently used
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column

[top of page]

GMP.CR_DOPR_TBL does not reference any database object

GMP.CR_DOPR_TBL is referenced by following:

APPS
SYNONYM - 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
Comments

Capacity G/L class code descriptions.

Indexes
Index Type Tablespace Column
CR_GLED_CLS_PK UNIQUE APPS_TS_SEED CRGL_CLASS
Columns
Name Datatype Length Mandatory Comments
CRGL_CLASS VARCHAR2 (8) Y GL Class code.
CRGL_CLASS_DESC VARCHAR2 (40) Y GL class description
CREATION_DATE DATE
Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
TRANS_CNT NUMBER (10)
Not currently used
DELETE_MARK NUMBER (5) Y Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module

[top of page]

GMP.CR_GLED_CLS does not reference any database object

GMP.CR_GLED_CLS is referenced by following:

APPS
SYNONYM - 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
Comments

Resource class table.

Indexes
Index Type Tablespace Column
CR_RSRC_CLS_B_PK UNIQUE APPS_TS_SEED RESOURCE_CLASS
Columns
Name Datatype Length Mandatory Comments
RESOURCE_CLASS VARCHAR2 (8) Y Resource class code
RESOURCE_CLASS_DESC VARCHAR2 (40)
Description of the resource class.
CREATION_DATE DATE
Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
TRANS_CNT NUMBER (10)
Not currently used
DELETE_MARK NUMBER (5) Y Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column

[top of page]

GMP.CR_RSRC_CLS_B does not reference any database object

GMP.CR_RSRC_CLS_B is referenced by following:

APPS
SYNONYM - CR_RSRC_CLS_B

[top of page]

Table: CR_RSRC_CLS_TL

Description: Resource Master for MRP
Comments

Resource Master for MRP

Columns
Name Datatype Length Mandatory Comments
RESOURCE_CLASS VARCHAR2 (8) Y Resource class code
LANGUAGE VARCHAR2 (4) Y Language.
SOURCE_LANG VARCHAR2 (4) Y Source Language.
RESOURCE_CLASS_DESC VARCHAR2 (40) Y Description of the resource class.
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column

[top of page]

GMP.CR_RSRC_CLS_TL does not reference any database object

GMP.CR_RSRC_CLS_TL is referenced by following:

APPS
SYNONYM - 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
Comments

Plant-specific resource information.

Indexes
Index Type Tablespace Column
CR_RSRC_DTL_I1 UNIQUE APPS_TS_TX_IDX ORGN_CODE
RESOURCES
CR_RSRC_DTL_PK UNIQUE APPS_TS_TX_IDX RESOURCE_ID
Columns
Name Datatype Length Mandatory Comments
ORGN_CODE VARCHAR2 (4)
Plant code
RESOURCES VARCHAR2 (16) Y Recsource code - from resource master
GROUP_RESOURCE VARCHAR2 (16) Y Resource group - resources can be grouped by this type
ASSIGNED_QTY NUMBER
Y How many of this resource are in this plant.
DAILY_AVAIL_USE NUMBER

Number of hours the resource is available in the plant each day.
USAGE_UM VARCHAR2 (4)
Unit of measure in which daily_avail_use is expressed.
NOMINAL_COST NUMBER
Y Cost of the resource in the plant.
INACTIVE_IND NUMBER
Y Inactive indicator. 0=Active, 1=Inactive.
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
TRANS_CNT NUMBER

Not currently used
DELETE_MARK NUMBER
Y Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
IDEAL_CAPACITY NUMBER
Y Optimum throughput capacity.
MIN_CAPACITY NUMBER
Y Minimum throughput capacity.
MAX_CAPACITY NUMBER
Y Maximum throughput capacity.
CAPACITY_UOM VARCHAR2 (4)
Unit of measure in which capacity is expressed.
RESOURCE_ID NUMBER (10) Y Surrogate key
CAPACITY_CONSTRAINT NUMBER (5)
Capacity Constraint
CAPACITY_TOLERANCE NUMBER

Resource Capacity Tolerance
SCHEDULE_IND NUMBER

This Column is used to define whether a resource is should be Scheduled or Not, the Values are 1= Scheduling , 2= Schedule to Instance, 0= Do Not Schedule
UTILIZATION NUMBER

Indicates the resource utilization.
EFFICIENCY NUMBER

Indicates the resource efficiency.
PLANNING_EXCEPTION_SET VARCHAR2 (10)
This is the column which identifies the Planning Exception Set
IDLE_TIME_TOLERENCE NUMBER

This is the tolerance on the idle time that the user is willing to accept as part of optimizing the schedule on the resource.
SDS_WINDOW NUMBER

This is the window considered while optimizing the sequence of activities on a SDS resource.
ORGANIZATION_ID NUMBER

Organization ID
USAGE_UOM VARCHAR2 (3)
Unit of measure in which resource is expressed
CAPACITY_UM VARCHAR2 (3)
Unit of Measure in which capacity is expressed
CALENDAR_CODE VARCHAR2 (10)
Calendar Code
BATCHABLE_FLAG NUMBER

This is the batchable flag
BATCH_WINDOW NUMBER

This is the batching Window
BATCH_WINDOW_UOM VARCHAR2 (3)
This is the batching Window unit of measure

[top of page]

GMP.CR_RSRC_DTL does not reference any database object

GMP.CR_RSRC_DTL is referenced by following:

APPS
SYNONYM - CR_RSRC_DTL
MATERIALIZED VIEW - ENI_RES_4_MV

[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
Comments

Resource master.

Indexes
Index Type Tablespace Column
CR_RSRC_MST_B_PK UNIQUE APPS_TS_TX_IDX RESOURCES
Columns
Name Datatype Length Mandatory Comments
RESOURCES VARCHAR2 (16) Y Code for the resource.
RESOURCE_DESC VARCHAR2 (40)
Description of the resource.
STD_USAGE_UM VARCHAR2 (4)
Unit of measure in which resource usage is expressed.
COST_CMPNTCLS_ID NUMBER (10) Y Surrogate key of the cost component class which is used for tracking costs.
RESOURCE_CLASS VARCHAR2 (8)
Resource class to which the resource belongs.
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
TRANS_CNT NUMBER (22)
Not currently used
DELETE_MARK NUMBER (22) Y Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
MIN_CAPACITY NUMBER

Minimum capacity
MAX_CAPACITY NUMBER

Maximum capacity
CAPACITY_CONSTRAINT NUMBER (5)
resource capacity constraint
CAPACITY_UOM VARCHAR2 (4)
resource capacity UOM
CAPACITY_TOLERANCE NUMBER

Resource Capacity Tolerance
UTILIZATION NUMBER

Indicates the resource utilization
EFFICIENCY NUMBER

Indicates the resource efficiency.
STD_USAGE_UOM VARCHAR2 (3)
Unit of Measure in which resource usage is expressed
CAPACITY_UM VARCHAR2 (3)
Unit of Measure in which capacity of the resource is expressed

[top of page]

GMP.CR_RSRC_MST_B does not reference any database object

GMP.CR_RSRC_MST_B is referenced by following:

APPS
SYNONYM - CR_RSRC_MST_B
MATERIALIZED VIEW - ENI_RES_4_MV

[top of page]

Table: CR_RSRC_MST_TL

Description: Resource Master for MRP
Comments

Resource Master for MRP

Indexes
Index Type Tablespace Column
CR_RSRC_MST_TL_N1 NONUNIQUE APPS_TS_TX_IDX RESOURCES
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
RESOURCES VARCHAR2 (16) Y Code for the resource.
LANGUAGE VARCHAR2 (4) Y Language.
SOURCE_LANG VARCHAR2 (4) Y Source Language.
RESOURCE_DESC VARCHAR2 (40) Y Description of the resource.
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column

[top of page]

GMP.CR_RSRC_MST_TL does not reference any database object

GMP.CR_RSRC_MST_TL is referenced by following:

APPS
SYNONYM - 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
Comments

Sequence-dependent setup table. Used to define additional setup time
required for an operation when items or sequence-dependent classes
are processed in a certain sequence.
KAREN THEEL: 02/13/98 Used mainly for information only.
The table is never used as in a FK relationship
so it is not a problem that it doesn't have a Pk.

Indexes
Index Type Tablespace Column
CR_SQDS_TBL_PK UNIQUE APPS_TS_TX_IDX OPRN_ID
FROM_ITEM_ID
TO_ITEM_ID
Columns
Name Datatype Length Mandatory Comments
OPRN_ID NUMBER
Y Surrogate key for the operation for which additional setup time is required.
FROM_ITEM_ID NUMBER
Y The first item to be processed in the sequence.
TO_ITEM_ID NUMBER
Y The second item to be processed in the sequence
FROM_ITEM_CLASS VARCHAR2 (8) Y The first sequence-dependent class to be processed.
TO_ITEM_CLASS VARCHAR2 (8) Y The second sequence-dependent class to be processed.
SETUP_TIME NUMBER
Y The additional setup time required when the second item is taken for processing
TRANS_CNT NUMBER

Not currently used
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
FROM_CATEGORY_ID NUMBER

Category Id for FROM_CLASS
TO_CATEGORY_ID NUMBER

Category Id for TO_CLASS

[top of page]

GMP.CR_SQDS_TBL does not reference any database object

GMP.CR_SQDS_TBL is referenced by following:

APPS
SYNONYM - 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
Comments

Table used to store text types for Capacity

Indexes
Index Type Tablespace Column
CR_TEXT_HDR_PK UNIQUE APPS_TS_TX_IDX TEXT_CODE
Columns
Name Datatype Length Mandatory Comments
TEXT_CODE NUMBER (10) Y Surrogate key for the record. ID which joins any rows of text in this table to the Text Table for this Module
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column

[top of page]

GMP.CR_TEXT_HDR does not reference any database object

GMP.CR_TEXT_HDR is referenced by following:

APPS
SYNONYM - 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
Comments

CR module Text Lines. Description text for all tables in this module

Indexes
Index Type Tablespace Column
CR_TEXT_TBL_TL_PK UNIQUE APPS_TS_TX_IDX TEXT_CODE
LANG_CODE
PARAGRAPH_CODE
SUB_PARACODE
LINE_NO
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
TEXT_CODE NUMBER (10) Y Surrogate key for the record. ID which joins any rows of text in this table to the Text Table for this Module
LANG_CODE VARCHAR2 (4) Y Indicates language used in text.
PARAGRAPH_CODE VARCHAR2 (4) Y Defined in sy_para_cds.
SUB_PARACODE NUMBER (5) Y Defined in sy_para_cds.
LINE_NO NUMBER (5) Y Line number which allows multiple lines of descripitive text for underlying record. -1 = line is used to recreate key of underlying record; 1 <= descriptive text.
TEXT VARCHAR2 (70)
Descriptive text.
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y Source language code
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column

[top of page]

GMP.CR_TEXT_TBL_TL does not reference any database object

GMP.CR_TEXT_TBL_TL is referenced by following:

APPS
SYNONYM - 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
Comments

Forecast detail table. Contains items and forecast quantities by organization and warehouse.

Indexes
Index Type Tablespace Column
FC_FCST_DTL_PK UNIQUE APPS_TS_TX_IDX LINE_ID
FC_FCST_DTL_I1 NONUNIQUE APPS_TS_TX_IDX FORECAST_ID
ITEM_ID
LINE_ID
Columns
Name Datatype Length Mandatory Comments
LINE_ID NUMBER (10) Y Surrogate key identifying the forecast line.
ITEM_ID NUMBER (10) Y Surrogate key for the item forecasted.
ORGN_CODE VARCHAR2 (4) Y Organization for the forecast.
WHSE_CODE VARCHAR2 (4) Y Warehouse in which the item demand is forecasted.
FORECAST_ID NUMBER (10) Y Surrogate key for the forecast.
TRANS_DATE DATE
Y Date on which the demand is forecasted.
TRANS_QTY NUMBER
Y Quantity of the item forecasted.
DELETE_MARK NUMBER (5) Y Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column

[top of page]

GMP.FC_FCST_DTL does not reference any database object

GMP.FC_FCST_DTL is referenced by following:

APPS
SYNONYM - 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
Comments

Forecast header.

Indexes
Index Type Tablespace Column
FC_FCST_HDR_PK UNIQUE APPS_TS_TX_IDX FORECAST_ID
FC_FCST_HDR_U1 UNIQUE APPS_TS_TX_IDX FORECAST
Columns
Name Datatype Length Mandatory Comments
FORECAST_ID NUMBER (10) Y Surrogate key for the forecast.
FORECAST VARCHAR2 (16) Y Name of the forecast.
FORECAST_DESC VARCHAR2 (40) Y Description of the forecast.
DELETE_MARK NUMBER (5) Y Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
IN_USE NUMBER (10)
Not currently used
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
FORECAST_SET VARCHAR2 (10)
This column identifies the forecast set
CONSUMPTION_IND NUMBER

This is the Forecast Consumption Indicator
BACKWARD_TIME_FENCE NUMBER

This column identifies the backward consumption days
FORWARD_TIME_FENCE NUMBER

This column identifies the forward consumption days

[top of page]

GMP.FC_FCST_HDR does not reference any database object

GMP.FC_FCST_HDR is referenced by following:

APPS
SYNONYM - 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
Comments

Table used to store text types for Forecasting.

Indexes
Index Type Tablespace Column
FC_TEXT_HDR_PK UNIQUE APPS_TS_TX_IDX TEXT_CODE
Columns
Name Datatype Length Mandatory Comments
CREATION_DATE DATE
Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
TEXT_CODE NUMBER (10) Y Surrogate key for the record. ID which joins any rows of text in this table to the Text Table for this Module

[top of page]

GMP.FC_TEXT_HDR does not reference any database object

GMP.FC_TEXT_HDR is referenced by following:

APPS
SYNONYM - 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
Comments

FC Module Text Lines. Descriptive text for all tables in this module.

Indexes
Index Type Tablespace Column
FC_TEXT_TBL_TL_PK UNIQUE APPS_TS_TX_IDX TEXT_CODE
LANG_CODE
PARAGRAPH_CODE
SUB_PARACODE
LINE_NO
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
TEXT_CODE NUMBER (10) Y Surrogate key for the record. ID which joins any rows of text in this table to the Text Table for this Module
LANG_CODE VARCHAR2 (4) Y Indicates language used in text.
PARAGRAPH_CODE VARCHAR2 (4) Y Defined in sy_para_cds.
SUB_PARACODE NUMBER (5) Y Defined in sy_para_cds.
LINE_NO NUMBER (5) Y Line number which allows multiple lines of descripitive text for underlying record. -1 = line is used to recreate key of underlying record; 1 <= descriptive text.
TEXT VARCHAR2 (70)
Descriptive text.
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y Source language code
LAST_UPDATED_BY NUMBER (15) Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column

[top of page]

GMP.FC_TEXT_TBL_TL does not reference any database object

GMP.FC_TEXT_TBL_TL is referenced by following:

APPS
SYNONYM - FC_TEXT_TBL_TL

[top of page]

Table: GMP_ALTRESOURCE_PRODUCTS

Description:
Primary Key: GMP_ALTRESOURCE_PRODUCTS_U1
  1. PRIMARY_RESOURCE
  2. ALTERNATE_RESOURCE
  3. INVENTORY_ITEM_ID
  4. ITEM_ID
Comments

Product specific alternate resources are stored in this table

Indexes
Index Type Tablespace Column
GMP_ALTRESOURCE_PRODUCTS_U1 UNIQUE APPS_TS_TX_IDX PRIMARY_RESOURCE
ALTERNATE_RESOURCE
INVENTORY_ITEM_ID
ITEM_ID
Columns
Name Datatype Length Mandatory Comments
PRIMARY_RESOURCE VARCHAR2 (16) Y This is Primary ie. Original resource - which could be substituted by Altrenate resource
ALTERNATE_RESOURCE VARCHAR2 (16) Y This is the Alternate resource that can be used in place of Original Resource
ITEM_ID NUMBER

Column Not used in Release R12 - refer inventory_item_id column
INVENTORY_ITEM_ID NUMBER

This is the product item id for which the alternate resource can be used in place of original resource
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column

[top of page]

GMP.GMP_ALTRESOURCE_PRODUCTS does not reference any database object

GMP.GMP_ALTRESOURCE_PRODUCTS is referenced by following:

APPS
SYNONYM - GMP_ALTRESOURCE_PRODUCTS

[top of page]

Table: GMP_APS_OUTPUT_DTL

Description: APS Output Detail table
Comments

APS Output Detail table

Columns
Name Datatype Length Mandatory Comments
GROUP_ID NUMBER

Processing group Identifier
WIP_ENTITY_ID NUMBER

WIP job or repetitive assembly Identifier
ORGANIZATION_ID NUMBER

Organization Identifier
OPERATION_SEQ_NUM NUMBER
Y Operation sequence number within a routing
RESOURCE_SEQ_NUM NUMBER

Resource sequence number
RESOURCE_ID_OLD NUMBER

Resource Identifier existing in current jobs/schedules
RESOURCE_ID_NEW NUMBER

Resource Identifier to be added or changed
USAGE_RATE_OR_AMOUNT NUMBER

Rate per assembly or amount per job or schedule
SCHEDULED_FLAG NUMBER

Method of scheduling the resource
ASSIGNED_UNITS NUMBER

Number of resources assigned to work
UOM_CODE VARCHAR2 (3)
Unit of measure code
START_DATE DATE

Scheduled start date of the resource
COMPLETION_DATE DATE

Scheduled completion date of the resource
INVENTORY_ITEM_ID_OLD NUMBER

Old material requirement Identifier
INVENTORY_ITEM_ID_NEW NUMBER

New material requirement Identifier
QUANTITY_PER_ASSEMBLY NUMBER

Part usage quantity
WIP_SUPPLY_TYPE NUMBER

Method of material consumption within WIP
DATE_REQUIRED DATE

Operation requirement start date
REQUIRED_QUANTITY NUMBER

Part quantity required
QUANTITY_ISSUED NUMBER

Part quantity issued
LOAD_TYPE NUMBER
Y Material or resource requirement
SUBSTITUTION_TYPE NUMBER
Y Add, delete or change
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
PARENT_HEADER_ID NUMBER
Y Identifies this row's parent in GMP_APS_OUTPUT_TBL
FIRST_UNIT_START_DATE DATE

First unit scheduled receipt date
LAST_UNIT_COMPLETION_DATE DATE

Last unit scheduled completion date
MINIMUM_TRANSFER_QUANTITY NUMBER

Minimum operation transfer quantity
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield
SCHEDULE_SEQ_NUM NUMBER

schedule sequence number
SUBSTITUTE_GROUP_NUM NUMBER

substitute group number
REPLACEMENT_GROUP_NUM NUMBER

replacement group number
CHARGE_NUMBER NUMBER

This column is identifies the Charge Number
FIRM_FLAG NUMBER

This column identifies the Firm Flag in wip_job_dtls_interface
GROUP_SEQUENCE_ID NUMBER

This column identifies the Group Sequence Id
PARENT_SEQ_NUM NUMBER

This column is identifies the Parent Sequence Number
RESOURCE_INSTANCE_ID NUMBER

This column is the Unique identifier of Resource Instance
RESOURCE_INSTANCE_NUMBER NUMBER

Thisidentifies specific instance of a resource
SETUP_ID NUMBER

This column identifies the Setup Id in wip_job_dtls_interface
GROUP_SEQUENCE_NUMBER NUMBER

This column identifies the Group Sequence Number

[top of page]

GMP.GMP_APS_OUTPUT_DTL does not reference any database object

GMP.GMP_APS_OUTPUT_DTL is referenced by following:

APPS
SYNONYM - GMP_APS_OUTPUT_DTL

[top of page]

Table: GMP_APS_OUTPUT_TBL

Description: Temp table for APS Output
Comments

Temp table for APS Output

Indexes
Index Type Tablespace Column
GMP_APS_OUTPUT_TBL_I1 NONUNIQUE APPS_TS_INTERFACE ITEM_ID
ORGANIZATION_CODE
Columns
Name Datatype Length Mandatory Comments
PROCESS_ID NUMBER
Y Data transfer process number (Group_Id)
ITEM_ID NUMBER

Item Id for which suggestion is made
ORGANIZATION_CODE VARCHAR2 (4)
OPM Organization
ORGANIZATION_ID NUMBER
Y Corresponding Apps Orgn Id
BATCH_ID NUMBER

APS suggested rescheduling this batch
WAREHOUSE_CODE VARCHAR2 (4)
OPM Warehouse
EFFECTIVITY_ID NUMBER

Suggested effectivity
PLAN_QUANTITY NUMBER

Suggested quantity of new batch
PLAN_START_DATE DATE

Start date for new batch or rescheduled batch
PLAN_END_DATE DATE

End date for new batch or rescheduled batch
ACTION_TYPE NUMBER

New or Update
PROCESSED_IND NUMBER

Shows if this row has been processed, i.e. the feedback from APS is implemented in OPM, 0=not yet processed, non-zero value = processed
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
HEADER_ID NUMBER
Y Header Identifier
SCHEDULING_METHOD NUMBER

Scheduling Method
ORDER_PRIORITY NUMBER

This column identifies the Order priority
REQUIRED_COMPLETION_DATE DATE

This column identifies the Required Completion Date
INVENTORY_ITEM_ID NUMBER (16)
This is the Inventory Item Identification
FIRM_FLAG NUMBER (16)
This is the Firm Flag

[top of page]

GMP.GMP_APS_OUTPUT_TBL does not reference any database object

GMP.GMP_APS_OUTPUT_TBL is referenced by following:

APPS
SYNONYM - GMP_APS_OUTPUT_TBL

[top of page]

Table: GMP_BUCKETED_XML_TEMP

Description:
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
SYS_IL0000401045C00002$$ UNIQUE APPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
BCKT_MATL_XML_ID NUMBER

Unique id to identify the file per report run
XML_FILE CLOB (4000)
XML file to be used further by XML publisher

[top of page]

GMP.GMP_BUCKETED_XML_TEMP does not reference any database object

GMP.GMP_BUCKETED_XML_TEMP is referenced by following:

APPS
SYNONYM - GMP_BUCKETED_XML_TEMP

[top of page]

Table: GMP_CALENDAR_DETAIL_GTMP

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
CALENDAR_ID NUMBER (10)
SHIFT_NUM NUMBER (10)
SHIFT_DATE DATE

FROM_TIME NUMBER (15)
TO_TIME NUMBER (15)
FROM_DATE DATE

TO_DATE DATE

CALENDAR_CODE VARCHAR2 (10)

[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
Comments

API table for Sales and Forecast Demands

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Organization ID of demand warehouse
SCHEDULE_ID NUMBER

Schedule ID for Manufacturing Schedule
INVENTORY_ITEM_ID NUMBER

Apps Inventory Item ID as per MTL_SYSTEM_ITEMS
DEMAND_DATE DATE

Scheduled Order Ship Date or Forecast Trans Date
DEMAND_QUANTITY NUMBER

Pending order quantity or forecast qty
ORIGINATION_TYPE NUMBER

6 = Sales Order demand, 7 = Forecast demand
DOC_ID NUMBER

Surrogate key to order_id or forecast_id
LAST_UPDATE_DATE DATE

Standard "Who" column
LAST_UPDATED_BY NUMBER

Standard "Who" column
CREATION_DATE DATE

Standard "Who" column
CREATED_BY NUMBER

Standard "Who" column
SELLING_PRICE NUMBER

Selling Price for Orders, List Price for forecast

[top of page]

GMP.GMP_DEMANDS_API does not reference any database object

GMP.GMP_DEMANDS_API is referenced by following:

APPS
SYNONYM - 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
Comments

Formula Effectivity Mapping Table

Indexes
Index Type Tablespace Column
GMP_FORM_EFF_PK UNIQUE APPS_TS_INTERFACE APS_FMEFF_ID
Columns
Name Datatype Length Mandatory Comments
APS_FMEFF_ID NUMBER (10) Y Surrogate Key
FMEFF_ID NUMBER (10) Y Effectivity surrogate key
FORMULA_ID NUMBER (10) Y Formula surrogate key
ROUTING_ID NUMBER (10)
Routing surrogate key
WHSE_CODE VARCHAR2 (4)
Warehouse code where the effectivity is valid
PLANT_CODE VARCHAR2 (4)
Plant code where the effectivity is valid
CREATION_DATE DATE
Y Standard WHO Column
CREATED_BY NUMBER (15) Y Standard WHO Column
LAST_UPDATE_DATE DATE
Y Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
ORGANIZATION_ID NUMBER

Organization Id

[top of page]

GMP.GMP_FORM_EFF does not reference any database object

GMP.GMP_FORM_EFF is referenced by following:

APPS
SYNONYM - GMP_FORM_EFF

[top of page]

Table: GMP_HORIZONTAL_PDR_GTMP

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

INVENTORY_ITEM_ID NUMBER

BUCKET_DATE DATE

QUANTITY1 NUMBER

QUANTITY2 NUMBER

QUANTITY3 NUMBER

QUANTITY4 NUMBER

QUANTITY5 NUMBER

QUANTITY6 NUMBER

QUANTITY7 NUMBER

QUANTITY8 NUMBER

QUANTITY9 NUMBER

QUANTITY10 NUMBER

QUANTITY11 NUMBER

QUANTITY12 NUMBER

QUANTITY13 NUMBER

QUANTITY14 NUMBER

QUANTITY15 NUMBER

QUANTITY16 NUMBER

QUANTITY17 NUMBER

QUANTITY18 NUMBER

QUANTITY19 NUMBER

QUANTITY20 NUMBER

QUANTITY21 NUMBER

QUANTITY22 NUMBER

QUANTITY23 NUMBER

QUANTITY24 NUMBER

QUANTITY25 NUMBER

QUANTITY26 NUMBER

QUANTITY27 NUMBER

QUANTITY28 NUMBER

QUANTITY29 NUMBER

QUANTITY30 NUMBER

QUANTITY31 NUMBER

QUANTITY32 NUMBER

QUANTITY33 NUMBER

QUANTITY34 NUMBER

QUANTITY35 NUMBER

QUANTITY36 NUMBER

QUANTITY37 NUMBER

QUANTITY38 NUMBER

QUANTITY39 NUMBER

QUANTITY40 NUMBER

QUANTITY41 NUMBER

QUANTITY42 NUMBER

QUANTITY43 NUMBER

QUANTITY44 NUMBER

QUANTITY45 NUMBER

[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
Comments

Item Master Table for APS

Indexes
Index Type Tablespace Column
GMP_ITEM_APS_PK UNIQUE APPS_TS_INTERFACE ITEM_ID
WHSE_CODE
PLANT_CODE
GMP_ITEM_APS_I1 NONUNIQUE APPS_TS_INTERFACE ITEM_ID
PLANT_CODE
GMP_ITEM_APS_I2 NONUNIQUE APPS_TS_INTERFACE ORGANIZATION_ID
APS_ITEM_ID
Columns
Name Datatype Length Mandatory Comments
ITEM_NO VARCHAR2 (32) Y Item number
ITEM_ID NUMBER (10) Y Surrogate key for item number
ITEM_UM VARCHAR2 (4) Y Unit of Measure for the item
UOM_CODE VARCHAR2 (3) Y Aps version of the unit of measure
LOT_CONTROL NUMBER (5) Y lot control indicator
ITEM_DESC1 VARCHAR2 (70) Y Description of the item
APS_ITEM_ID NUMBER
Y Apps surrogate key for the item
ORGANIZATION_ID NUMBER
Y Apps organization surrogate key
WHSE_CODE VARCHAR2 (4) Y Warehouse code where the item is located
REPLEN_IND NUMBER (5) Y Replenishment indicator
CONSUM_IND NUMBER (5) Y Consumption indicator
PLANT_CODE VARCHAR2 (4) Y Plant code the item is associated with
CREATION_DATE DATE
Y WHO Column
CREATED_BY NUMBER (15) Y WHO Column
LAST_UPDATE_DATE DATE
Y WHO Column
LAST_UPDATED_BY NUMBER (15) Y WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
WHO Column
CATEGORY_ID NUMBER

This column Uniquely identifies the Item Category
SEQ_DEP_ID NUMBER

This column Uniquely identifies the Sequence Dependency
SEQ_DPND_CLASS VARCHAR2 (8)
This column identifies the Sequence Dependent Class

[top of page]

GMP.GMP_ITEM_APS does not reference any database object

GMP.GMP_ITEM_APS is referenced by following:

APPS
SYNONYM - 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
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
GMP_ITEM_WPS_PK UNIQUE APPS_TS_INTERFACE ITEM_ID
WHSE_CODE
PLANT_CODE
GMP_ITEM_WPS_N1 NONUNIQUE APPS_TS_INTERFACE ITEM_ID
PLANT_CODE
GMP_ITEM_WPS_N2 NONUNIQUE APPS_TS_INTERFACE ITEM_ID
ORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
ITEM_NO VARCHAR2 (32) Y OPM Item Number , defined in OPM Inventory
ITEM_ID NUMBER (10) Y OPM Item ID
ITEM_UM VARCHAR2 (4) Y Unit of Measure for the OPM Item
UOM_CODE VARCHAR2 (3) Y UOM Code for the OPM Item
LOT_CONTROL NUMBER (5) Y Lot Control Indicator
ITEM_DESC1 VARCHAR2 (70) Y OPM Item description
APS_ITEM_ID NUMBER
Y APPS Surrogate key for the Item
ORGANIZATION_ID NUMBER
Y APPS Organization Surrogate key
WHSE_CODE VARCHAR2 (4) Y OPM Warehouse code where Items are located
REPLEN_IND NUMBER (5) Y Replenishment Indicator which is defined in the OPM Plant Ware house effectivity.
CONSUM_IND NUMBER (5) Y Consumption Indicator which is defined in the OPM Plant Ware house effectivity.
PLANT_CODE VARCHAR2 (4) Y Plant code the Item is Associated with
CREATION_DATE DATE
Y Standard "Row Who" column
CREATED_BY NUMBER (15) Y Standard "Row Who" column
LAST_UPDATE_DATE DATE
Y Standard "Row Who" column
LAST_UPDATED_BY NUMBER (15) Y Standard "Row Who" column
LAST_UPDATE_LOGIN NUMBER (15)
Standard "Row Who" column

[top of page]

GMP.GMP_ITEM_WPS does not reference any database object

GMP.GMP_ITEM_WPS is referenced by following:

APPS
SYNONYM - 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
Comments

Process Parameter values

Indexes
Index Type Tablespace Column
GMP_PARAM_VALUES_B_PK UNIQUE APPS_TS_TX_IDX PARAMETER_ID
PARAMETER_VALUE
Columns
Name Datatype Length Mandatory Comments
PARAMETER_ID NUMBER (15) Y Process Parameter ID
PARAMETER_VALUE VARCHAR2 (16) Y Process Parameter value
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER
Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER
Y Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column

[top of page]

GMP.GMP_PARAMETER_VALUES_B does not reference any database object

GMP.GMP_PARAMETER_VALUES_B is referenced by following:

APPS
SYNONYM - 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
Comments

Process Parameter values Translation table

Indexes
Index Type Tablespace Column
GMP_PARAM_VALUES_TL_PK UNIQUE APPS_TS_TX_IDX PARAMETER_ID
PARAMETER_VALUE
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
PARAMETER_ID NUMBER (15) Y Process parameter ID
PARAMETER_VALUE VARCHAR2 (16) Y Process parameter value
PARAMETER_VALUE_DESCRIPTION VARCHAR2 (240) Y Process parameter value description
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y Source language
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER
Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER
Y Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column

[top of page]

GMP.GMP_PARAMETER_VALUES_TL does not reference any database object

GMP.GMP_PARAMETER_VALUES_TL is referenced by following:

APPS
SYNONYM - GMP_PARAMETER_VALUES_TL

[top of page]

Table: GMP_PDR_ITEMS_GTMP

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER

ORGANIZATION_ID NUMBER

ORGANIZATION_CODE VARCHAR2 (7)
ITEM_NAME VARCHAR2 (250)
CATEGORY_NAME VARCHAR2 (250)
BUYER_NAME VARCHAR2 (240)
PLANNER_CODE VARCHAR2 (10)
ABC_CLASS_NAME VARCHAR2 (40)
BASE_ITEM_ID NUMBER

STANDARD_COST NUMBER

CALCULATE_ATP NUMBER

WIP_SUPPLY_TYPE NUMBER

BOM_ITEM_TYPE NUMBER

[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.
Comments

Table used to store XML generated for Planning Detail Report.

Indexes
Index Type Tablespace Column
SYS_IL0000401041C00001$$ UNIQUE APPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
XML_FILE CLOB (4000)
Column used to store Planning Detail Report XML.
FILE_TYPE NUMBER

Planning Detail Report Component. 1=Combined PDR, 2=Horizontal, 3=Vertical, 4=Exception, 5=Action
PDR_XML_ID NUMBER

Unique ID for each xml row generated.

[top of page]

GMP.GMP_PDR_XML_TEMP does not reference any database object

GMP.GMP_PDR_XML_TEMP is referenced by following:

APPS
SYNONYM - 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
Comments

Table for Association of Parameters to the Generic Resources

Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER
Y Surrogate key which uniquely identifies the resource, Foreign Key to resource_id in cr_rsrc_dtl
PARAMETER_ID NUMBER (15) Y Column which identifies the Process Parameter Set name. Foreign Key to gmp_process_parameter_set_b. process_parameter_set
TARGET_VALUE VARCHAR2 (16)
Ideal Value for this process parameter. Not required if a Min and max Values are specified
MINIMUM_VALUE NUMBER

Minimum value for this Process Parameter. Not required if a Target or a Maximum value is provided
MAXIMUM_VALUE NUMBER

Maximum value for this Process Parameter. Not required if a Target or a Maximum value is provided
CREATION_DATE DATE
Y Standard "Row Who" column
CREATED_BY NUMBER
Y Standard "Row Who" column
LAST_UPDATE_DATE DATE
Y Standard "Row Who" column
LAST_UPDATED_BY NUMBER
Y Standard "Row Who" column
LAST_UPDATE_LOGIN NUMBER

Standard "Row Who" column

[top of page]

GMP.GMP_PLANT_RSRC_PARAMETERS does not reference any database object

GMP.GMP_PLANT_RSRC_PARAMETERS is referenced by following:

APPS
SYNONYM - 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
Comments
Indexes
Index Type Tablespace Column
GMP_PROCESS_DTL_APS_PK NONUNIQUE APPS_TS_SEED PROCESS_UPD_ID
PROCESS_UPD_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
PROCESS_UPD_ID NUMBER (10) Y
PROCESS_UPD_TYPE_ID NUMBER (10) Y
PROCESS_UPD_STATUS NUMBER (5) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

GMP.GMP_PROCESS_DTL_APS does not reference any database object

GMP.GMP_PROCESS_DTL_APS is referenced by following:

APPS
SYNONYM - 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
Comments
Indexes
Index Type Tablespace Column
GMP_PROCESS_HDR_APS_I1 NONUNIQUE APPS_TS_SEED ACTUAL_END_DATE
GMP_PROCESS_HDR_APS_PK NONUNIQUE APPS_TS_SEED PROCESS_UPD_ID
Columns
Name Datatype Length Mandatory Comments
PROCESS_UPD_ID NUMBER (10) Y
ACTUAL_END_DATE DATE

ACTUAL_START_DATE DATE

QUEUE_NO NUMBER
Y
PROCESS_UPD_STATUS NUMBER (5) Y
PROCESS_UPD_BY VARCHAR2 (4) Y
BATCH_DATE DATE
Y
GROUP_ID NUMBER

IN_USE NUMBER (15)
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

GMP.GMP_PROCESS_HDR_APS does not reference any database object

GMP.GMP_PROCESS_HDR_APS is referenced by following:

APPS
SYNONYM - 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
Comments
Indexes
Index Type Tablespace Column
GMP_PROCESS_MSG_APS_PK NONUNIQUE APPS_TS_SEED PROCESS_UPD_ID
LINE_NO
Columns
Name Datatype Length Mandatory Comments
PROCESS_UPD_ID NUMBER (10) Y
LINE_NO NUMBER (10) Y
MESSAGE_CODE VARCHAR2 (32) Y
PARAMETER1 VARCHAR2 (32)
PARAMETER2 VARCHAR2 (32)
PARAMETER3 VARCHAR2 (32)
PARAMETER4 VARCHAR2 (32)
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

GMP.GMP_PROCESS_MSG_APS does not reference any database object

GMP.GMP_PROCESS_MSG_APS is referenced by following:

APPS
SYNONYM - 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
Comments

Table for Process Parameters

Indexes
Index Type Tablespace Column
GMP_PROCESS_PARAM_B_PK UNIQUE APPS_TS_TX_IDX PARAMETER_ID
Columns
Name Datatype Length Mandatory Comments
PARAMETER_ID NUMBER (15) Y Surrogate Key which uniquely identifies the Process Parameter
PARAMETER_NAME VARCHAR2 (40) Y Column which identifies the Process Parameter name (e.g., Speed, temperature etc., )
PARAMETER_TYPE NUMBER
Y This field is a Validation type for this Process Parameter. Possible Values are 1Text 2Numeric Range 3List of values
MINIMUM_VALUE NUMBER

Minimum value for this Process Parameter. Not required if a Target or a Maximum value is provided
MAXIMUM_VALUE NUMBER

Maximum value for this Process Parameter. Not required if a Target or a Maximum value is provided
UNITS VARCHAR2 (25)
This field stores the unit of measure for the process parameter (e.g Degress, Celsius, Millimeters....)
DELETE_MARK NUMBER
Y This column identifies if the process parameter is marked deleted or not. Valid values are 1Deleted, 0Not deleted.
TEXT_CODE NUMBER (10)
This column provides the edit Text feature
CREATION_DATE DATE
Y Standard "Row Who" column
CREATED_BY NUMBER
Y Standard "Row Who" column
LAST_UPDATE_DATE DATE
Y Standard "Row Who" column
LAST_UPDATED_BY NUMBER
Y Standard "Row Who" column
LAST_UPDATE_LOGIN NUMBER

Standard "Row Who" column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard Flex fields
ATTRIBUTE1 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE2 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE3 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE4 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE5 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE6 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE7 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE8 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE9 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE10 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE11 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE12 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE13 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE14 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE15 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE16 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE17 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE18 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE19 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE20 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE21 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE22 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE23 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE24 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE25 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE26 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE27 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE28 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE29 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE30 VARCHAR2 (240)
Standard Flex fields

[top of page]

GMP.GMP_PROCESS_PARAMETERS_B does not reference any database object

GMP.GMP_PROCESS_PARAMETERS_B is referenced by following:

APPS
SYNONYM - 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
Comments

Table for to store Process Parameters description ( MLS )

Indexes
Index Type Tablespace Column
GMP_PROCESS_PARAM_TL_PK UNIQUE APPS_TS_TX_IDX PARAMETER_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
PARAMETER_ID NUMBER
Y Surrogate Key which uniquely identifies the Process Parameter
PARAMETER_DESCRIPTION VARCHAR2 (240) Y Parameter Description ( e.g., " speed used for the S-40 Mix"),Multilingual field
LANGUAGE VARCHAR2 (4) Y Foreign Key reference to FND_LANGUAGES. Denotes which language this data is stored
SOURCE_LANG VARCHAR2 (4) Y Foreign reference to FND_LANGUAGES. Denotes which language this data was originally created.
CREATION_DATE DATE
Y Standard "Row Who" column
CREATED_BY NUMBER
Y Standard "Row Who" column
LAST_UPDATE_DATE DATE
Y Standard "Row Who" column
LAST_UPDATED_BY NUMBER
Y Standard "Row Who" column
LAST_UPDATE_LOGIN NUMBER

Standard "Row Who" column

[top of page]

GMP.GMP_PROCESS_PARAMETERS_TL does not reference any database object

GMP.GMP_PROCESS_PARAMETERS_TL is referenced by following:

APPS
SYNONYM - 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
Comments

Table for Association of Parameters to the Parameter Sets

Columns
Name Datatype Length Mandatory Comments
PARAMETER_SET_ID NUMBER (15) Y Surrogate Key which uniquely identifies the Process Parameter Set
SEQUENCE_NO NUMBER
Y This column uniquely identifies the orders in which the Process Parameter is stored
PARAMETER_ID NUMBER
Y Column which identifies the Process Parameter Set name. Foreign Key to gmp_process_parameter_set_b. process_parameter_set
CREATION_DATE DATE
Y Standard "Row Who" column
CREATED_BY NUMBER
Y Standard "Row Who" column
LAST_UPDATE_DATE DATE
Y Standard "Row Who" column
LAST_UPDATED_BY NUMBER
Y Standard "Row Who" column
LAST_UPDATE_LOGIN NUMBER

Standard "Row Who" column

[top of page]

GMP.GMP_PROCESS_PARAMETER_SETS does not reference any database object

GMP.GMP_PROCESS_PARAMETER_SETS is referenced by following:

APPS
SYNONYM - 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
Comments

Table for Process Parameter Sets

Indexes
Index Type Tablespace Column
GMP_PROCESS_PARAM_SET_B_PK NONUNIQUE APPS_TS_TX_IDX PARAMETER_SET_ID
Columns
Name Datatype Length Mandatory Comments
PARAMETER_SET_ID NUMBER (15) Y Surrogate Key which uniquely identifies the Process Parameter Set
PARAMETER_SET VARCHAR2 (40) Y Column which identifies the Process Parameter Set name
CREATION_DATE DATE
Y Standard "Row Who" column
CREATED_BY NUMBER
Y Standard "Row Who" column
LAST_UPDATE_DATE DATE
Y Standard "Row Who" column
LAST_UPDATED_BY NUMBER
Y Standard "Row Who" column
LAST_UPDATE_LOGIN NUMBER

Standard "Row Who" column

[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:

APPS
SYNONYM - 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
Comments

Table for Process Parameter Sets

Indexes
Index Type Tablespace Column
GMP_PROCESS_PARAM_SET_TL_PK UNIQUE APPS_TS_TX_IDX PARAMETER_SET_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
PARAMETER_SET_ID NUMBER (15) Y Surrogate Key which uniquely identifies the Process Parameter Set
SET_DESCRIPTION VARCHAR2 (240) Y Column which identifies the Process Parameter Set name
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y Source language
CREATION_DATE DATE
Y Standard "Row Who" column
CREATED_BY NUMBER
Y Standard "Row Who" column
LAST_UPDATE_DATE DATE
Y Standard "Row Who" column
LAST_UPDATED_BY NUMBER
Y Standard "Row Who" column
LAST_UPDATE_LOGIN NUMBER

Standard "Row Who" column

[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:

APPS
SYNONYM - 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
Comments
Indexes
Index Type Tablespace Column
GMP_PROCESS_TYP_APS_I1 NONUNIQUE APPS_TS_SEED PROCESS_UPD_NAME
GMP_PROCESS_TYP_APS_PK NONUNIQUE APPS_TS_SEED PROCESS_UPD_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
PROCESS_UPD_NAME VARCHAR2 (16) Y
PROCESS_UPD_TYPE_ID NUMBER (10) Y
PROCESS_UPD_DESC VARCHAR2 (70) Y
PROCESS_UPD_TYPE NUMBER (5) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

GMP.GMP_PROCESS_TYP_APS does not reference any database object

GMP.GMP_PROCESS_TYP_APS is referenced by following:

APPS
SYNONYM - GMP_PROCESS_TYP_APS

[top of page]

Table: GMP_RESDISP_XML_TEMP

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

Table used to store XML generated for Resource Dispatch Report.

Indexes
Index Type Tablespace Column
SYS_IL0000401052C00002$$ UNIQUE APPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
RESDISP_XML_RPT_ID NUMBER

Unique ID for each xml row generated.
RESULT CLOB (4000)
Column used to store Resource Dispatch Report XML.

[top of page]

GMP.GMP_RESDISP_XML_TEMP does not reference any database object

GMP.GMP_RESDISP_XML_TEMP is referenced by following:

APPS
SYNONYM - GMP_RESDISP_XML_TEMP

[top of page]

Table: GMP_RESOURCE_AVAIL

Description: Table for Resource Availability
Comments

Table for Resource Availability

Indexes
Index Type Tablespace Column
GMP_RESOURCE_AVAIL_N1 NONUNIQUE APPS_TS_INTERFACE CALENDAR_ID
RESOURCE_ID
SHIFT_DATE
Columns
Name Datatype Length Mandatory Comments
INSTANCE_ID NUMBER

instance ID
PLANT_CODE VARCHAR2 (4)
plant code
RESOURCE_ID NUMBER
Y The Surrogate Key of the Resource
CALENDAR_ID NUMBER

Surrogate Key to uniquely identify the Calendar
RESOURCE_INSTANCE_ID NUMBER

The surrogate key identifying the resource instance . This will be a coming from the sequence GMP_RESOURCE_INSTANCES_S
SHIFT_NUM NUMBER
Y The integer number for the Shift
SHIFT_DATE DATE
Y the Date in which the Shift Occurs
FROM_TIME NUMBER

the number of seconds from the start of the day for the shift to the begin
TO_TIME NUMBER

the number of seconds from the start of the day for the shift to the end
RESOURCE_UNITS NUMBER
Y Integer number which indicates the number of resource units available. If instance_id is NOT NULL, then this must be 1
CREATION_DATE DATE
Y Standard "Row Who" column
CREATED_BY NUMBER
Y Standard "Row Who" column
LAST_UPDATE_DATE DATE
Y Standard "Row Who" column
LAST_UPDATED_BY NUMBER
Y Standard "Row Who" column
LAST_UPDATE_LOGIN NUMBER

Standard "Row Who" column
CALENDAR_CODE VARCHAR2 (10)
Holds the calendar
ORGANIZATION_ID NUMBER

Organization ID.

[top of page]

GMP.GMP_RESOURCE_AVAIL does not reference any database object

GMP.GMP_RESOURCE_AVAIL is referenced by following:

APPS
SYNONYM - GMP_RESOURCE_AVAIL

[top of page]

Table: GMP_RESOURCE_DEVICES

Description: Resource-Device Association
Comments

This table stores data for Resource to Device association

Indexes
Index Type Tablespace Column
GMP_RESOURCE_DEVICES_U1 UNIQUE APPS_TS_TX_IDX RESOURCE_ID
DEVICE_ID
Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER
Y Unique identofier of the Resource
DEVICE_ID NUMBER
Y Unique identifier of the Device
CREATED_BY NUMBER
Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER
Y Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column

[top of page]

GMP.GMP_RESOURCE_DEVICES does not reference any database object

GMP.GMP_RESOURCE_DEVICES is referenced by following:

APPS
SYNONYM - GMP_RESOURCE_DEVICES

[top of page]

Table: GMP_RESOURCE_DEVICE_MESSAGES

Description: Resource Parameter to Device Response Messages Mapping Table
Comments

Resource Parameter to Device Response Messages Mapping Table

Indexes
Index Type Tablespace Column
GMP_RESOURCE_DEVICE_MESSAGES_U UNIQUE APPS_TS_TX_IDX RESOURCE_ID
DEVICE_ID
RESP_COMP_CODE_VALUE
Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER
Y Unique Identifier of resource
DEVICE_ID NUMBER
Y Unique Identifier of Device
PROCESS_PARAM_ID NUMBER
Y Unique identifier of the Process Parameter associated with the resource
RESP_COMP_CODE_VALUE NUMBER
Y Response Value mapped to the process parameter of the resource
RESP_COMP_CODE_UOM NUMBER
Y Response UOM
EVENT_ID NUMBER

Event ID
CREATED_BY NUMBER
Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER
Y Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column

[top of page]

GMP.GMP_RESOURCE_DEVICE_MESSAGES does not reference any database object

GMP.GMP_RESOURCE_DEVICE_MESSAGES is referenced by following:

APPS
SYNONYM - 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
Comments

Table for Resource Equipment

Indexes
Index Type Tablespace Column
GMP_RESOURCE_EQUIPMENTS_PK UNIQUE APPS_TS_TX_IDX RESOURCE_ID
EQUIPMENT_ITEM_ID
Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER
Y The Surrogate Key of the Resource
EQUIPMENT_ITEM_ID NUMBER
Y Surrogate Key to uniquely identify the Equipment Item
CREATION_DATE DATE
Y Standard "Who" column
CREATED_BY NUMBER
Y Standard "Who" column
LAST_UPDATE_DATE DATE
Y Standard "Who" column
LAST_UPDATED_BY NUMBER
Y Standard "Who" column
LAST_UPDATE_LOGIN NUMBER
Y Standard "Who" column

[top of page]

GMP.GMP_RESOURCE_EQUIPMENTS does not reference any database object

GMP.GMP_RESOURCE_EQUIPMENTS is referenced by following:

APPS
SYNONYM - 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
Comments

Table for Resource Instances

Indexes
Index Type Tablespace Column
GMP_RESOURCE_INSTANCES_U1 UNIQUE APPS_TS_TX_IDX EQUIPMENT_ITEM_ID
EQP_SERIAL_NUMBER
Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER
Y The Surrogate Key of the Resource
INSTANCE_ID NUMBER
Y Surrogate Key to uniquely identify the Instance
INSTANCE_NUMBER NUMBER
Y The number identifying the resource uniquely. This will be a serial number staring from 1 and progress up to the total number of resources at the Plant
VENDOR_ID NUMBER

the Key to the Vendor from whom the Equipment was purchased
MODEL_NUMBER VARCHAR2 (30)
the Model number from the manufacturer for the resource
SERIAL_NUMBER VARCHAR2 (30)
the Combination of numbers, Letters and Symbols the manufacturer uses to identify the resource
TRACKING_NUMBER VARCHAR2 (30)
the unique combination of numbers, Letters and symbols to identify the resource for internal tracking
EFF_START_DATE DATE
Y The Start Date for the Resource when it becomes Active
EFF_END_DATE DATE

The End Date for the Resource when it becomes Inactive
LAST_MAINTENANCE_DATE DATE

The Date maintenance last occurred for the resource
MAINTENANCE_INTERVAL NUMBER

The number of Days from the last time maintenance was done where maintenance should occur again
INACTIVE_IND NUMBER
Y inactive indicator
CALIBRATION_FREQUENCY NUMBER

Resource Calibration Frequency, If there is a value in calibration_frequency, there must be a value in calibration_period
CALIBRATION_PERIOD VARCHAR2 (4)
Resource Calibration Period, If there is a value in calibration_period, there must be a value in calibration_frequency
CALIBRATION_ITEM_ID NUMBER

The Item with which the Calibration is done - Must be valid from ic_item_mst
LAST_CALIBRATION_DATE DATE

Standard date validation + cannot be greater than sysdate
NEXT_CALIBRATION_DATE DATE

Standard date validation + cannot be greater than sysdate
LAST_CERTIFICATION_DATE DATE

Standard date validation + cannot be greater than sysdate
CERTIFIED_BY VARCHAR2 (32)
Person Who has done the Calibration Certification
CREATION_DATE DATE
Y Standard "Who" column
CREATED_BY NUMBER
Y Standard "Who" column
LAST_UPDATE_DATE DATE
Y Standard "Who" column
LAST_UPDATED_BY NUMBER
Y Standard "Who" column
LAST_UPDATE_LOGIN NUMBER

Standard "Who" column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard Flex fields
ATTRIBUTE1 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE2 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE3 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE4 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE5 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE6 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE7 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE8 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE9 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE10 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE11 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE12 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE13 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE14 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE15 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE16 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE17 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE18 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE19 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE20 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE21 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE22 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE23 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE24 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE25 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE26 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE27 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE28 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE29 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE30 VARCHAR2 (240)
Standard Flex fields
EQUIPMENT_ITEM_ID NUMBER

The surrogate key for equipment item
EQP_SERIAL_NUMBER VARCHAR2 (30)
This is the Equipment Serial Number - this comes from the Serial numbers defined from Oracle Inventory APPS
LAST_SETUP_ID NUMBER

Identifier of the last sequence depndent setup performed on the resource instance

[top of page]

GMP.GMP_RESOURCE_INSTANCES does not reference any database object

GMP.GMP_RESOURCE_INSTANCES is referenced by following:

APPS
SYNONYM - 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
Comments

Table for Association of Parameters to the Generic Resources

Indexes
Index Type Tablespace Column
GMP_RESOURCE_PARAM_PK UNIQUE APPS_TS_TX_IDX RESOURCES
PARAMETER_ID
Columns
Name Datatype Length Mandatory Comments
RESOURCES VARCHAR2 (16) Y Column which identifies the Resources, Foreign key to cr_rsrc_mst.resources
SEQUENCE_NO NUMBER
Y This column uniquely identifies the orders in which the Process Parameter is stored
PARAMETER_ID NUMBER (15) Y Column which identifies the Process Parameter Set name. Foreign Key to gmp_process_parameter_set_b. process_parameter_set
TARGET_VALUE VARCHAR2 (16)
Ideal Value for this process parameter. Not required if a Min and max Values are specified
MINIMUM_VALUE NUMBER

Minimum value for this Process Parameter. Not required if a Target or a Maximum value is provided
MAXIMUM_VALUE NUMBER

Maximum value for this Process Parameter. Not required if a Target or a Maximum value is provided
CREATION_DATE DATE
Y Standard "Row Who" column
CREATED_BY NUMBER
Y Standard "Row Who" column
LAST_UPDATE_DATE DATE
Y Standard "Row Who" column
LAST_UPDATED_BY NUMBER
Y Standard "Row Who" column
LAST_UPDATE_LOGIN NUMBER

Standard "Row Who" column

[top of page]

GMP.GMP_RESOURCE_PARAMETERS does not reference any database object

GMP.GMP_RESOURCE_PARAMETERS is referenced by following:

APPS
SYNONYM - GMP_RESOURCE_PARAMETERS

[top of page]

Table: GMP_ROUTING_OFFSETS

Description: Table for Routing offsets used in Lead Time Calculations
Comments

Table for Routing offsets used in Lead Time Calculations

Columns
Name Datatype Length Mandatory Comments
PLANT_CODE VARCHAR2 (4)
Column Identifies the OPM Plant
FMEFF_ID NUMBER (15) Y Column Identifies the Effectivity Id, Surrogate Key for the Effectivity Row
RECIPE_ID NUMBER (15) Y Unique identifier for a Recipe
FORMULA_ID NUMBER (10) Y The Formula ID associated with this Recipe. A Formula is required in order to create a Recipe
ROUTING_ID NUMBER (15) Y The Routing ID associated with this Recipe. It is optional to associate a Routing with a Recipe
ROUTINGSTEP_ID NUMBER (10) Y Surrogate key for the routing step
START_OFFSET NUMBER
Y Column identifies the Starting Offset
END_OFFSET NUMBER
Y Column identifies the End Offset
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER
Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER
Y Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
ORGANIZATION_ID NUMBER

Organization Id

[top of page]

GMP.GMP_ROUTING_OFFSETS does not reference any database object

GMP.GMP_ROUTING_OFFSETS is referenced by following:

APPS
SYNONYM - 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
Comments

Resource Assignment Table

Indexes
Index Type Tablespace Column
GMP_RSRC_EXCP_ASNMT_U1 UNIQUE APPS_TS_TX_IDX EXCEPTION_ID
RESOURCE_ID
INSTANCE_ID
Columns
Name Datatype Length Mandatory Comments
EXCEPTION_ID NUMBER
Y Surrogate Key FK toGMP_RSRC_EXCP_HDR
RESOURCE_ID NUMBER (10) Y Internal Id for resource FK to CR_RSRC_DTL
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
RESOURCE_UNITS NUMBER

Number of Resources that are Not Available
INSTANCE_ID NUMBER
Y Surrogate key which uniquely indentifies the instance of a resource. This comes from the sequence GMP_RESOURCE_INSTANCES_S.

[top of page]

GMP.GMP_RSRC_EXCP_ASNMT does not reference any database object

GMP.GMP_RSRC_EXCP_ASNMT is referenced by following:

APPS
SYNONYM - 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
Comments

Exception Details Table

Columns
Name Datatype Length Mandatory Comments
EXCEPTION_ID NUMBER
Y Surrogate Key FK toGMP_RSRC_EXCP_HDR
FROM_DATE DATE
Y Start Date-time of Unavailable time
TO_DATE DATE
Y End Date-time of Unavailable time
REASON_CODE VARCHAR2 (30) Y Code for Unavailable reason.FKto SY_REAS_CDS
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column

[top of page]

GMP.GMP_RSRC_EXCP_DTL does not reference any database object

GMP.GMP_RSRC_EXCP_DTL is referenced by following:

APPS
SYNONYM - 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
Comments

Exception Header Table

Indexes
Index Type Tablespace Column
GMP_RSRC_EXCP_HDR_PK UNIQUE APPS_TS_TX_IDX EXCEPTION_ID
Columns
Name Datatype Length Mandatory Comments
EXCEPTION_ID NUMBER
Y Surrogate Key
EXCEPTION_CODE VARCHAR2 (6) Y Code,User generated Description
DESCRIPTION VARCHAR2 (100)
Description of the Exception Code
INACTIVE_IND NUMBER
Y Whether Active 0 or 1
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column

[top of page]

GMP.GMP_RSRC_EXCP_HDR does not reference any database object

GMP.GMP_RSRC_EXCP_HDR is referenced by following:

APPS
SYNONYM - 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
Comments

Manual Entries Table

Indexes
Index Type Tablespace Column
GMP_RSRC_UNAVAIL_MAN_U1 UNIQUE APPS_TS_TX_IDX FROM_DATE
TO_DATE
RESOURCE_ID
INSTANCE_ID
Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER

Surrogate Key for Exception set
FROM_DATE DATE
Y Start Date-time ofUnavailable time
TO_DATE DATE
Y End Date-time of Unavailabletime
REASON_CODE VARCHAR2 (30) Y Code for Unavailable reason. FKto SY_REAS_CDS
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
RESOURCE_UNITS NUMBER

Number of Resources that are Not Available
INSTANCE_ID NUMBER
Y Surrogate key which uniquely indentifies the instance of a resource. This comes from the sequence GMP_RESOURCE_INSTANCES_S.
MAINT_ORG_ID NUMBER

This column identifies the Maintenance Organization id for the work order number in eAM
WIP_ENTITY_ID NUMBER

This column identifies the work order number in eAM
OP_SEQ NUMBER

This column identifies Operation Sequence Number

[top of page]

GMP.GMP_RSRC_UNAVAIL_MAN does not reference any database object

GMP.GMP_RSRC_UNAVAIL_MAN is referenced by following:

APPS
SYNONYM - GMP_RSRC_UNAVAIL_MAN

[top of page]

Table: GMP_SEQUENCE_DEPENDENCIES

Description: Table for Sequence Dependencies
Comments

Table for Sequence Dependencies

Columns
Name Datatype Length Mandatory Comments
OPRN_ID NUMBER
Y The Surrogate Key for an Operation to be considered for sequence dependencies
FROM_CATEGORY_ID NUMBER
Y The Sequence dependent Item Class for the item which was processed before the Current Item
TO_CATEGORY_ID NUMBER
Y The Sequence dependent Item Class for the item which was processed after the last Item
SETUP_TIME NUMBER
Y The amount of time to be added to the resources for operation of the later batch
PENALTY_FACTOR NUMBER
Y the value to be used by WPS to discourage the operation from processing the different Item Classes after each other
FROM_SEQ_DEP_ID NUMBER
Y the new surrogate to allow for the unique identification of combination of Operation and item class
TO_SEQ_DEP_ID NUMBER
Y the new surrogate to allow for the unique identification of combination of Operation and item class
CREATION_DATE DATE
Y Standard "Row Who" column
CREATED_BY NUMBER
Y Standard "Row Who" column
LAST_UPDATE_DATE DATE
Y Standard "Row Who" column
LAST_UPDATED_BY NUMBER
Y Standard "Row Who" column
LAST_UPDATE_LOGIN NUMBER

Standard "Row Who" column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard Flex fields
ATTRIBUTE1 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE2 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE3 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE4 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE5 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE6 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE7 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE8 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE9 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE10 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE11 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE12 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE13 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE14 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE15 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE16 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE17 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE18 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE19 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE20 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE21 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE22 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE23 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE24 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE25 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE26 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE27 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE28 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE29 VARCHAR2 (240)
Standard Flex fields
ATTRIBUTE30 VARCHAR2 (240)
Standard Flex fields
TO_OPRN_ID NUMBER

To Operation Identification

[top of page]

GMP.GMP_SEQUENCE_DEPENDENCIES does not reference any database object

GMP.GMP_SEQUENCE_DEPENDENCIES is referenced by following:

APPS
SYNONYM - GMP_SEQUENCE_DEPENDENCIES

[top of page]

Table: GMP_SEQUENCE_TYPES

Description: Table for Sequence Types
Comments

Table for Sequence Types

Columns
Name Datatype Length Mandatory Comments
OPRN_ID NUMBER
Y The Surrogate Key from the Operation
CATEGORY_ID NUMBER
Y The Sequence dependent Item Class
SEQ_DEP_ID NUMBER
Y the surrogate key for the row
CREATION_DATE DATE
Y Standard "Row Who" column
CREATED_BY NUMBER
Y Standard "Row Who" column
LAST_UPDATE_DATE DATE
Y Standard "Row Who" column
LAST_UPDATED_BY NUMBER
Y Standard "Row Who" column
LAST_UPDATE_LOGIN NUMBER

Standard "Row Who" column

[top of page]

GMP.GMP_SEQUENCE_TYPES does not reference any database object

GMP.GMP_SEQUENCE_TYPES is referenced by following:

APPS
SYNONYM - GMP_SEQUENCE_TYPES

[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
Comments

Action messages generated by P/MRP.

Indexes
Index Type Tablespace Column
MR_ACTN_TBLI1 UNIQUE APPS_TS_TX_IDX MRP_ID
ITEM_ID
WHSE_CODE
EVENT_DATE
ACTION_NO
MR_ACTN_TBL_PK UNIQUE APPS_TS_TX_IDX MRP_ID
ACTION_NO
Columns
Name Datatype Length Mandatory Comments
MRP_ID NUMBER (10) Y Surrogate key for the MRP run.
ACTION_NO NUMBER (10) Y Action number. Unique number generated for each message for this run.
ITEM_ID NUMBER (10) Y Surrogate key for the item to which the action message pertains.
WHSE_CODE VARCHAR2 (4) Y Warehouse code to which the action message pertains.
EVENT_DATE DATE
Y Date of shortage occurence in case of warnings; date of replenishment
INVENTORY_DATE DATE
Y Date on which inventory is affected by the action. For shortage, the day on which shortage occurs
DOC_TYPE VARCHAR2 (4)
Document type. Production=PROD; Purchaseorder=PORD; Firm Planned = FPO; Planned Production= PPRD etc. There are more doc_types. The list of all types is in sy_docs_mst
DOC_ID NUMBER (10)
Surrogate key identifying the document to which the action message
MESSAGE_CODE VARCHAR2 (32) Y The code for the action message. Description of the code explains the action required.
FORMULA_ID NUMBER (10)
Surrogate key for the formula related to the action message.
MRP_MSG_IND NUMBER (5) Y Valid message values. 0=warning; 1=transfer; 2=production; 3=purchase.
PROJ_BALANCE_QTY NUMBER
Y Quantity available subsequent to the event referred to by this
ACTION_QTY NUMBER
Y Replenishment quantity in case of recommendations.
WHSE_CODE_2 VARCHAR2 (4)
Contains values only in case of transfer suggestions. Refers to the warehouse to which transfer is suggested.
NET_REQ_ACTION_REF NUMBER (10) Y Correlates actions to a shortage warning. Contains action_no of suggested action generateing requirement for this action
ORGN_CODE VARCHAR2 (4)
Organization associated with this action message.
STATUS_IND NUMBER (5) Y Indicator showing whether PPRD has been converted to a batch or FPO.
LAST_UPDATED_BY NUMBER (15) Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
REQUEST_ID NUMBER (15)
Concurrent who column
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent who column
PROGRAM_ID NUMBER (15)
Concurrent who column
PROGRAM_UPDATE_DATE DATE

Concurrent who column
FMEFF_ID NUMBER (15)
This is column identifies the Effectivity Id

[top of page]

GMP.MR_ACTN_TBL does not reference any database object

GMP.MR_ACTN_TBL is referenced by following:

APPS
SYNONYM - 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
Comments

Error message log. Stores the list of error messages generated during
the P/MRP run.

Indexes
Index Type Tablespace Column
MR_MESG_TBL_PK UNIQUE APPS_TS_TX_IDX MRP_ID
MESSAGE_LINE_NO
MR_MESG_TBLI1 NONUNIQUE APPS_TS_TX_IDX MESSAGE_CODE
Columns
Name Datatype Length Mandatory Comments
MRP_ID NUMBER (10) Y Surrogate key for the MRP run.
MESSAGE_LINE_NO NUMBER (10) Y Unique number generated for each row written into the table for this MRP Run.
MESSAGE_CODE VARCHAR2 (32) Y Code for the error message. The description of this code gives details of the error
SHOPDAY_NO VARCHAR2 (8)
Number identifying the shop day referred to (if any) in the error message.
CALENDAR_ID NUMBER (10)
Surrogate key identifying the calendar referred to (if any) in the error
ITEM_ID1 NUMBER (10)
Surrogate key identifying the first item referred to in the message
ITEM_ID2 NUMBER (10)
Surrogate key identifying the second item referred to in the message
WHSE_CODE1 VARCHAR2 (4)
First warehouse referred to in the message text.
WHSE_CODE2 VARCHAR2 (4)
Second warehouse referred to in the message.
REQUIRED_QTY NUMBER

The required quantity referred to in the error message.example - Such an error message would generated for cases where MRP could not plan.
START_DATE DATE
Y Start date referred to in the error message.
FORMULA_ID NUMBER (10)
Surrogate key identifying the formula referred to in the message text.
END_DATE DATE
Y End date referred to in the error message.
ORGN_CODE VARCHAR2 (4)
Organization code referred to in the error message.
LEADTIME NUMBER

Lead time referred to in the error message.
ACTION_NO NUMBER (10)
Action number - if related to an action message
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
REQUEST_ID NUMBER (15)
Concurrent who column
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent who column
PROGRAM_ID NUMBER (15)
Concurrent who column
PROGRAM_UPDATE_DATE DATE

Concurrent who column

[top of page]

GMP.MR_MESG_TBL does not reference any database object

GMP.MR_MESG_TBL is referenced by following:

APPS
SYNONYM - 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
Comments

P/MRP run parameters. Used to store information regarding P/MRP runs
for a schedule.

Indexes
Index Type Tablespace Column
MR_PARM_DTL_PK UNIQUE APPS_TS_TX_IDX MRP_ID
Columns
Name Datatype Length Mandatory Comments
MRP_ID NUMBER (10) Y Surrogate key that uniquely identifies each MRP run.
SCHEDULE_ID NUMBER (10) Y Surrogate id of the schedule for which this MRP run was made.
BATCH_DATE DATE
Y Planned start date on which the run is scheduled.
ACTUAL_START_DATE DATE

Date on which the run started.
ACTUAL_END_DATE DATE

Date on which the run was completed.
QUEUE_NO NUMBER (8) Y Queue to which the run was submitted. NOW - immediate , QUEUE = Planned for a future date
RUN_STATUS NUMBER (5) Y Completion status of run. -2=OS error; -1=DB error; 0=Pending; 1= Run; 2= Completed
DATA_DELETED NUMBER (5) Y 0=Data not deleted; 1=Data deleted.
RUN_BY NUMBER (15) Y Code of operator who ran MRP.
APPROVED_BY NUMBER (15)
Operator who approved the run.
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
DELETE_MARK NUMBER (5) Y Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE17 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE18 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE19 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE20 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE21 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE22 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE23 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE24 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE25 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE26 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE27 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE28 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE29 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE30 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield segment
REQUEST_ID NUMBER (15)
Concurrent who column
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent who column
PROGRAM_ID NUMBER (15)
Concurrent who column
PROGRAM_UPDATE_DATE DATE

Concurrent who column

[top of page]

GMP.MR_PARM_DTL does not reference any database object

GMP.MR_PARM_DTL is referenced by following:

APPS
SYNONYM - 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
Comments

Pegging table. Pegging of demands to the shortage warnings is done
thru this table.

Indexes
Index Type Tablespace Column
MR_PEGG_TBL_PK UNIQUE APPS_TS_TX_IDX MRP_ID
ACTION_NO
LINE_NO
Columns
Name Datatype Length Mandatory Comments
MRP_ID NUMBER (10) Y Key to the MRP run for which the pegging data is stored.
ACTION_NO NUMBER (10) Y Reference to shortage warning message created by this transaction.
LINE_NO NUMBER (10) Y Reference to transaction that caused the shortage warning.
LAST_UPDATED_BY NUMBER (15) Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
REQUEST_ID NUMBER (15)
Concurrent who column
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent who column
PROGRAM_ID NUMBER (15)
Concurrent who column
PROGRAM_UPDATE_DATE DATE

Concurrent who column

[top of page]

GMP.MR_PEGG_TBL does not reference any database object

GMP.MR_PEGG_TBL is referenced by following:

APPS
SYNONYM - 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
Comments

Shop calendar details. Contains details of each date in the shop
calendar which is used by MRP.

Indexes
Index Type Tablespace Column
MR_SHCL_DTL_PK UNIQUE APPS_TS_TX_IDX CALENDAR_ID
CALENDAR_DATE
Columns
Name Datatype Length Mandatory Comments
CALENDAR_ID NUMBER (10) Y Surrogate key for the calendar for which details are stored.
CALENDAR_DATE DATE
Y Calendar date.
SECS_SINCE_DAY0 NUMBER (10) Y Seconds elapsed since day 0. Used in calculation of start times for shifts (day)
DAYS_SINCE_DAY0 NUMBER (10) Y Days passed since day 0. Used in calculation of purchase/transfer suggestions
SHOPDAY_NO VARCHAR2 (8) Y Code identifying the shop day for this date.
DELETE_MARK NUMBER (5) Y Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column

[top of page]

GMP.MR_SHCL_DTL does not reference any database object

GMP.MR_SHCL_DTL is referenced by following:

APPS
SYNONYM - 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
Comments

Shop calendar header.

Indexes
Index Type Tablespace Column
MR_SHCL_HDR_PK UNIQUE APPS_TS_TX_IDX CALENDAR_ID
Columns
Name Datatype Length Mandatory Comments
CALENDAR_ID NUMBER (10) Y Surrogate key for the shop calendar.
CALENDAR_NO VARCHAR2 (16) Y Name of the shop calendar.
CALENDAR_DESC VARCHAR2 (40) Y Description of the shop calendar.
ACTIVE_IND NUMBER (5) Y Whetether calendar is active. 0=Inactive; 1=Active.
DAY1 VARCHAR2 (8)
Identifies the default type of shop day for Sundays.
DAY2 VARCHAR2 (8)
Identifies the default type of shop day for Mondays.
DAY3 VARCHAR2 (8)
Identifies the default type of shop day for Tuesdays.
DAY4 VARCHAR2 (8)
Identifies the default type of shop day for Wednesdays.
DAY5 VARCHAR2 (8)
Identifies the default type of shop day for Thursdays.
DAY6 VARCHAR2 (8)
Identifies the default type of shop day for Fridays.
DAY7 VARCHAR2 (8)
Identifies the default type of shop day for Saturdays.
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
IN_USE NUMBER (10)
Not currently used
DELETE_MARK NUMBER (5) Y Standard: 0=Active record (default); 1=Marked for (logical) deletion.
DAILY_WORK_HOURS NUMBER

This is the column that identifies the Average Work hours for a work day

[top of page]

GMP.MR_SHCL_HDR does not reference any database object

GMP.MR_SHCL_HDR is referenced by following:

APPS
SYNONYM - 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
Comments

Shop day detail. Provides details of the shop day.

Indexes
Index Type Tablespace Column
MR_SHDY_DTL_PK UNIQUE APPS_TS_TX_IDX SHOPDAY_NO
SHIFT_NO
Columns
Name Datatype Length Mandatory Comments
SHOPDAY_NO VARCHAR2 (8) Y Name of the shop day.
SHIFT_NO NUMBER (5) Y Shift number in the day.
SHIFT_START NUMBER (10) Y Shift start time, stored in seconds since midnight.
SHIFT_DURATION NUMBER (10) Y Shift duration, stored in seconds.
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
DELETE_MARK NUMBER (5) Y Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TRANS_CNT NUMBER (10)
Not currently used
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module

[top of page]

GMP.MR_SHDY_DTL does not reference any database object

GMP.MR_SHDY_DTL is referenced by following:

APPS
SYNONYM - 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
Comments

Shop day header.

Indexes
Index Type Tablespace Column
MR_SHDY_HDR_PK UNIQUE APPS_TS_TX_IDX SHOPDAY_NO
Columns
Name Datatype Length Mandatory Comments
SHOPDAY_NO VARCHAR2 (8) Y Shop day name.
SHOPDAY_DESC VARCHAR2 (40) Y Shop day description.
TRANS_CNT NUMBER (10)
Not currently used
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
DELETE_MARK NUMBER (5) Y Standard: 0=Active record (default); 1=Marked for (logical) deletion.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column

[top of page]

GMP.MR_SHDY_HDR does not reference any database object

GMP.MR_SHDY_HDR is referenced by following:

APPS
SYNONYM - 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
Comments

Sizing table. Stores info about the maximum number of rows required by mrp to run for a schedule. Use for allocating memory to subsequent MRP runs.

Indexes
Index Type Tablespace Column
MR_SIZE_TBL_PK UNIQUE APPS_TS_TX_IDX SCHEDULE_ID
Columns
Name Datatype Length Mandatory Comments
SCHEDULE_ID NUMBER (10) Y Surrogate key identifying the schedule.
MAX_FM_FORM_EFF NUMBER (10) Y Maximum number of formula effectivity rows selected.
MAX_FM_MATL_DTL NUMBER (10) Y Maximum number of formula material records selected.
MAX_FORMULA NUMBER (10) Y Maximum number of formula rows selected.
MAX_IC_PLNT_INV NUMBER (10) Y Maximum number of production rules rows selected.
MAX_IC_SUMM_INV NUMBER (10) Y Maximum number of ic_summ_inv rows selected.
MAX_IC_TRAN_PND NUMBER (10) Y Maximum number of pending transaction rows selected.
MAX_IC_WHSE_INV NUMBER (10) Y Maximum number of warehouse rules rows selected.
MAX_IC_WHSE_REL NUMBER (10) Y Maximum number of transfer rule rows selected.
MAX_ITEM NUMBER (10) Y Maximum number of item rows selected from ic_item_mst.
MAX_MR_SHCL_DTL NUMBER (10) Y Maximum number of shop calendar detail rows selected.
MAX_MR_SHDY_DTL NUMBER (10) Y Maximum number of shop day detail rows selected.
MAX_PS_SCHD_DTL NUMBER (10) Y Maximum number of schedule detail rows selected.
MAX_PS_WHSE_EFF NUMBER (10) Y Maximum number of warehouse effectivity rows selected.
RESIZE_PERCENT NUMBER (10) Y Percentage by which memory is resized when a call to central memory resize function is made in code- during MRP Run.
MAX_PO_BPOS_DTL NUMBER (10) Y Maximum number of blanket purchase order detail rows selected.
MAX_PO_BPOS_HDR NUMBER (10) Y Maximum number of blanket purchase order header rows selected.
MAX_PO_ORDR_DTL NUMBER (10) Y Maximum number of purchase order detail rows selected.
MAX_PO_RELS_SCH NUMBER (10) Y Maximum number of BPO release schedule rows selected.
MAX_PS_SCHD_FOR NUMBER (10) Y Maximum number of schedule/forecast association rows selected.
CREATION_DATE DATE
Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
REQUEST_ID NUMBER (15)
Concurrent who column
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent who column
PROGRAM_ID NUMBER (15)
Concurrent who column
PROGRAM_UPDATE_DATE DATE

Concurrent who column

[top of page]

GMP.MR_SIZE_TBL does not reference any database object

GMP.MR_SIZE_TBL is referenced by following:

APPS
SYNONYM - 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
Comments

Table used to store text types for MRP.

Indexes
Index Type Tablespace Column
MR_TEXT_HDR_PK UNIQUE APPS_TS_TX_IDX TEXT_CODE
Columns
Name Datatype Length Mandatory Comments
TEXT_CODE NUMBER (10) Y Surrogate key for the record. ID which joins any rows of text in this table to the Text Table for this Module
LAST_UPDATE_DATE DATE
Y Standard who column
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column

[top of page]

GMP.MR_TEXT_HDR does not reference any database object

GMP.MR_TEXT_HDR is referenced by following:

APPS
SYNONYM - 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
Comments

MR Module Text Lines. Descriptive text for all tables in this module.

Indexes
Index Type Tablespace Column
MR_TEXT_TBL_TL_PK UNIQUE APPS_TS_TX_IDX TEXT_CODE
LANG_CODE
PARAGRAPH_CODE
SUB_PARACODE
LINE_NO
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
TEXT_CODE NUMBER (10) Y Surrogate key for the record. ID which joins any rows of text in this table to the Text Table for this Module
LANG_CODE VARCHAR2 (4) Y Indicates language used in text.
PARAGRAPH_CODE VARCHAR2 (4) Y Defined in sy_para_cds.
SUB_PARACODE NUMBER (5) Y Defined in sy_para_cds.
LINE_NO NUMBER (5) Y Line number which allows multiple lines of descripitive text for underlying record. -1 = line is used to recreate key of underlying record; 1 <= descriptive text.
TEXT VARCHAR2 (70)
Descriptive text.
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y Source language code
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column

[top of page]

GMP.MR_TEXT_TBL_TL does not reference any database object

GMP.MR_TEXT_TBL_TL is referenced by following:

APPS
SYNONYM - 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
Comments

MRP transaction table. Scheduled transactions, MRP transactions, and adjusted forecast.

Indexes
Index Type Tablespace Column
MR_TRAN_TBLI1 UNIQUE APPS_TS_TX_IDX MRP_ID
ITEM_ID
WHSE_CODE
TRANS_DATE
LINE_NO
MR_TRAN_TBL_PK UNIQUE APPS_TS_TX_IDX MRP_ID
LINE_NO
Columns
Name Datatype Length Mandatory Comments
MRP_ID NUMBER (10) Y Key identifying the MRP run whose transaction are written.
LINE_NO NUMBER (10) Y Unique number assigned to each row in this table for this run.
ACTION_NO NUMBER (10)
Assigned values only for MRP generated transactions.
ITEM_ID NUMBER (10) Y Surrogate key identifying the item for which there is a transaction.
CO_CODE VARCHAR2 (4)
Company code for the transaction.
ORGN_CODE VARCHAR2 (4)
Organization code for the transaction.
WHSE_CODE VARCHAR2 (4) Y Warehouse code on the transaction.
CREATED_BY NUMBER (15) Y Standard who column
DOC_TYPE VARCHAR2 (4) Y Code identifying the type of document which created the transaction.
TRANS_DATE DATE
Y Transaction date on which transaction will occur.
TRANS_QTY NUMBER
Y Transaction quantity.
TRANS_UM VARCHAR2 (4)
Primary UOM of an item.
DOC_ID NUMBER (10)
Surrogate key identifying the document which created the transaction.
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
REQUEST_ID NUMBER (15)
Concurrent who column
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent who column
PROGRAM_ID NUMBER (15)
Concurrent who column
PROGRAM_UPDATE_DATE DATE

Concurrent who column

[top of page]

GMP.MR_TRAN_TBL does not reference any database object

GMP.MR_TRAN_TBL is referenced by following:

APPS
SYNONYM - 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.
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
MATL_REP_ID NUMBER (10) Y Surrogate id for the report
ITEM_ID NUMBER (10) Y Surrogate id of the item in the report.
DOC_TYPE VARCHAR2 (4) Y Doc type of the transaction/action
ORGN_CODE VARCHAR2 (4) Y Organization code of the organization under which the transaction falls
DOC_ID NUMBER (10) Y Surrogate id of the document (if any) for the transaction
DOC_NO VARCHAR2 (32)
Document number of the document of the transaction (if any)
PLANNING_CLASS VARCHAR2 (8)
Planning class of the item
WHSE_CODE VARCHAR2 (4)
Warehouse code of the warehouse under which the transaction/action falls
START_BALANCE NUMBER

Starting quantity of the item in the warehouse
PAST_DUE VARCHAR2 (1)
Total past due quantity of the item in that warehouse
TRANS_DATE DATE

Date of the transaction
TRANS_QTY NUMBER

Quantity of the transaction
BALANCE NUMBER

Balance left at the end of that period
CRITICAL_IND VARCHAR2 (2)
Denotes whether the item has become critical - below safety stock
CUST_VEND VARCHAR2 (32)
Customer or vendor code
PLANNING_CATEGORY_ID NUMBER

Category Id for PLANNING_CLASS

[top of page]

GMP.MR_UBKT_DTL does not reference any database object

GMP.MR_UBKT_DTL is referenced by following:

APPS
SYNONYM - 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
Comments

Temporary data about the report

Indexes
Index Type Tablespace Column
PS_MATL_DTL_PK UNIQUE APPS_TS_INTERFACE MATL_REP_ID
ITEM_ID
PERD_END_DATE
Columns
Name Datatype Length Mandatory Comments
MATL_REP_ID NUMBER (10) Y Surrogate id for the report
ITEM_ID NUMBER (10)
Surrogate id of the item in the report
PLANNING_CLASS VARCHAR2 (8)
Planning class of the item
WHSE_CODE VARCHAR2 (4)
Warehouse in which the transaction occurs
QTY_ON_HAND NUMBER

Quantity of the item on hand as of now.
PERD_NAME VARCHAR2 (20)
Name of the period - depending of the buckets defined.
PERD_END_DATE DATE
Y End date of the period ( bucket )
SALES_ORDERS NUMBER

Sum quantities of all sales orders in the period
FORE_CAST NUMBER

Sum all forecasted quantities in the period
SCHED_INGRED NUMBER

Quantities to be consumed in the scheduled batches as ingredient
FIRM_INGRED NUMBER

Quantities to be consumed in the Firm Planned Orders as ingredient
PLND_INGRED NUMBER

Quantities to be consumed in the Planned batches as ingredient
TOTAL_DEMAND NUMBER

Total of all the demand quantities
PO_RECEIPTS NUMBER

Quantity for the item to be received from the Purchase Order
REQ_RECEIPTS NUMBER

Receipt quantity
SCHED_PROD NUMBER

Quantity from the scheduled batches
FIRM_PROD NUMBER

Quantity coming from the Firm Planned Orders
PLND_PROD NUMBER

Quantity coming from the Planned Batches
ENDING_BAL NUMBER

Net ending balance for that preiod EB=Starting qty + Total replenishment - Total demand
NET_SS_REQMT NUMBER

Net Safety Stock requirement
PLND_TRANSFER_OUT NUMBER

Schedule transfer quantity outgoing
PLND_TRANSFER_IN NUMBER

Schedule transfer quantity incoming
PLANNING_CATEGORY_ID NUMBER

Category Id for PLANNING_CLASS
SCHED_TRANSFER_IN NUMBER

schedule transfer in
SCHED_TRANSFER_OUT NUMBER

schedule transfer out
PREQ_SUPPLY NUMBER

preq supply
PRCV_SUPPLY NUMBER

prcv supply
SHMT_SUPPLY NUMBER

MRP shortage suppoy
PLND_PURCHASE NUMBER

Planned Purchase
OTHER_DEMAND NUMBER

Stores demands not covered under the other specific columns - currently it stores the demand caused by expired lot
INVENTORY_ITEM_ID NUMBER

Inventory Item ID
ORGANIZATION_ID NUMBER

Organization ID

[top of page]

GMP.PS_MATL_DTL does not reference any database object

GMP.PS_MATL_DTL is referenced by following:

APPS
SYNONYM - 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
Comments

Temporary data about the report

Indexes
Index Type Tablespace Column
PS_MATL_HDR_PK UNIQUE APPS_TS_INTERFACE MATL_REP_ID
ITEM_ID
Columns
Name Datatype Length Mandatory Comments
MATL_REP_ID NUMBER (10) Y Surrogate id of the report
PLANNING_CLASS VARCHAR2 (8)
Planning class of the item
ITEM_ID NUMBER (10)
Surrogate id of the item
PLANNING_CATEGORY_ID NUMBER

Category Id for PLANNING_CLASS
INVENTORY_ITEM_ID NUMBER

Inventory Item ID
ORGANIZATION_ID NUMBER

Organization ID
CATEGORY_ID NUMBER

Category ID

[top of page]

GMP.PS_MATL_HDR does not reference any database object

GMP.PS_MATL_HDR is referenced by following:

APPS
SYNONYM - 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
Comments

Association table between operator codes and planning classes. Used
to limit the items that are displayed on MPS and MRP reports run by
the user.

Indexes
Index Type Tablespace Column
PS_OPER_PCL_PK UNIQUE APPS_TS_SEED USER_ID
PLANNING_CLASS
Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER (15) Y Surrogate key for the OPM user
PLANNING_CLASS VARCHAR2 (8) Y Code for the planning class associated with the operator.
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
TRANS_CNT NUMBER (10)
Not currently used
DELETE_MARK NUMBER (5) Y Standard: 0=Active record (default); 1=Marked for (logical) deletion.
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
PLANNING_CATEGORY_ID NUMBER

Category Id for PLANNING_CLASS

[top of page]

GMP.PS_OPER_PCL does not reference any database object

GMP.PS_OPER_PCL is referenced by following:

APPS
SYNONYM - 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
Comments

Schedule detail. Stores data on the organizations which are part of
this schedule, and the shop calendar and timefences for those organizations.

Indexes
Index Type Tablespace Column
PS_SCHD_DTL_PK UNIQUE APPS_TS_TX_IDX SCHEDULE_ID
ORGN_CODE
Columns
Name Datatype Length Mandatory Comments
SCHEDULE_ID NUMBER (10) Y Surrogate key for the schedule.
ORGN_CODE VARCHAR2 (4)
Code for the organization which is part of the schedule.
CALENDAR_ID NUMBER (10)
Surrogate key for the shop calendar used by the organization.
INNER_TIMEFENCE NUMBER

Earliest date on which any replenishment action can be initiated in the warehouse
OUTER_TIMEFENCE NUMBER

Latest date on which any replenishmnt can be started for this organization (Warehouse)
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
ORGANIZATION_ID NUMBER

Organization ID of the organization included in schedule

[top of page]

GMP.PS_SCHD_DTL does not reference any database object

GMP.PS_SCHD_DTL is referenced by following:

APPS
SYNONYM - 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
Comments

Schedule forecast association. List of forecasts which are to be considered for this schedule.

Indexes
Index Type Tablespace Column
PS_SCHD_FOR_PK UNIQUE APPS_TS_TX_IDX SCHEDULE_ID
FORECAST_ID
PS_SCHD_FORI1 NONUNIQUE APPS_TS_TX_IDX FORECAST_ID
Columns
Name Datatype Length Mandatory Comments
SCHEDULE_ID NUMBER (10) Y Surrogate key for the schedule to which forecasts are associated.
FORECAST_ID NUMBER (10)
Surrogate key for the forecast which is associated to a schedule.
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
ORGANIZATION_ID NUMBER

Organization ID of the forecast designator
FORECAST_DESIGNATOR VARCHAR2 (10)
Forecast Designator from Oracle Forecasting

[top of page]

GMP.PS_SCHD_FOR does not reference any database object

GMP.PS_SCHD_FOR is referenced by following:

APPS
SYNONYM - 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
Comments

Schedule header table that stores general info about the schedule.

Indexes
Index Type Tablespace Column
PS_SCHD_HDR_PK UNIQUE APPS_TS_TX_IDX SCHEDULE_ID
PS_SCHD_HDR_U1 UNIQUE APPS_TS_TX_IDX ORGN_CODE
SCHEDULE
Columns
Name Datatype Length Mandatory Comments
SCHEDULE_ID NUMBER (10) Y Surrogate key that uniquely identifies each record.
ORGN_CODE VARCHAR2 (4)
Organization code to which the schedule belongs
SCHEDULE VARCHAR2 (16) Y Name of the schedule.
SCHEDULE_DESC VARCHAR2 (40) Y Schedule description.
STOCK_IND NUMBER (5) Y Make to stock indicator. 0=Do not include forecast demand, 1=Include Forecasted demand
ORDER_IND NUMBER (5) Y Make to order indicator. 0=Do not include sales order demand, 1= include sales order demand
EXCESS_IND NUMBER (5)
Not currently used.
CONSUME_IND NUMBER (5) Y Not currently used.
CARRY_IND NUMBER (5)
Not currently used.
BLANKET_IND NUMBER (5)
Not currently used.
ACTIVE_IND NUMBER (5) Y 0=Inactive schedule; 1=Active schedule.
BPO_IND NUMBER (5)
Consider Blanket Purchase Order release schedule supply flag. 0=MRP ignores BPO 1= MRP considers BPO as replenishments
BPO_SUGGEST NUMBER (5)
BPO suggestion flag. 0=MRP will not make suggestions regarding BPO 1=MRP will make BPO Suggestions if required
INNER_TIMEFENCE NUMBER

Earliest date for the schedule on which any replenishment action can be suggested under this schedule
OUTER_TIMEFENCE NUMBER

Latest date on which any replenishment action can be initiated.
MRP_HORIZON NUMBER
Y Maximum date up to which transactions are considered for planning by MRP
NO_DAYS NUMBER (10) Y Number of day buckets displayed on the Bucketed Material Activity
NO_WEEKS NUMBER (10) Y Number of weekly buckets displayed on the Bucketed Material Activity
NO_4WEEKS NUMBER (10) Y Number of monthly buckets displayed on the Bucketed Material Activity
NO_13WEEKS NUMBER (10) Y No of quarterly buckets that appear on the Bucketed Material Activity
IN_USE NUMBER (10)
Not currently used
DELETE_MARK NUMBER (5) Y Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
ORGANIZATION_ID NUMBER

Organization ID Owning the Schedule
NONNET_IND NUMBER (5)
Flag to include non-nettable inventory

[top of page]

GMP.PS_SCHD_HDR does not reference any database object

GMP.PS_SCHD_HDR is referenced by following:

APPS
SYNONYM - 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
Comments

Table used to store text types for Production Scheduling.

Indexes
Index Type Tablespace Column
PS_TEXT_HDR_PK UNIQUE APPS_TS_TX_IDX TEXT_CODE
Columns
Name Datatype Length Mandatory Comments
TEXT_CODE NUMBER (10) Y Surrogate key for the record. ID which joins any rows of text in this table to the Text Table for this Module
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column

[top of page]

GMP.PS_TEXT_HDR does not reference any database object

GMP.PS_TEXT_HDR is referenced by following:

APPS
SYNONYM - 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
Comments

PS Module Text Lines. Descriptive text for all tables in this module.

Indexes
Index Type Tablespace Column
PS_TEXT_TBL_TL_PK UNIQUE APPS_TS_TX_IDX TEXT_CODE
LANG_CODE
PARAGRAPH_CODE
SUB_PARACODE
LINE_NO
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
TEXT_CODE NUMBER (10) Y Surrogate key for the record. ID which joins any rows of text in this table to the Text Table for this Module
LANG_CODE VARCHAR2 (4) Y Indicates language used in text.
PARAGRAPH_CODE VARCHAR2 (4) Y Defined in sy_para_cds.
SUB_PARACODE NUMBER (5) Y Defined in sy_para_cds.
LINE_NO NUMBER (5) Y Line number which allows multiple lines of descripitive text for underlying record. -1 = line is used to recreate key of underlying record; 1 <= descriptive text.
TEXT VARCHAR2 (70)
Descriptive text.
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y Source language code
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column

[top of page]

GMP.PS_TEXT_TBL_TL does not reference any database object

GMP.PS_TEXT_TBL_TL is referenced by following:

APPS
SYNONYM - 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
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
PS_UBKT_DTL_I1 NONUNIQUE APPS_TS_INTERFACE MATL_REP_ID
ITEM_ID
Columns
Name Datatype Length Mandatory Comments
LINE_ID NUMBER (10) Y Surrogate for the line in the report
MATL_REP_ID NUMBER (10) Y Surrogate id for the report
ITEM_ID NUMBER (10)
Surrogate id of the item being reported
DOC_TYPE VARCHAR2 (4) Y Doc type of the transaction
ORGN_CODE VARCHAR2 (4)
Organization under which the transaction falls
DOC_NO VARCHAR2 (32)
Document number (if any) of the document for the transaction
PLANNING_CLASS VARCHAR2 (8)
Planning class of the item
WHSE_CODE VARCHAR2 (4)
Warehouse code of the warehouse in the transaction
START_BALANCE NUMBER

Satrting balance quantity for the item
PAST_DUE VARCHAR2 (1)
Total past due quantity for the trans type
TRANS_DATE DATE

Date of the transaction
TRANS_QTY NUMBER

Quantity of the transaction
BALANCE NUMBER

Balance = Starting balance + Replenishment - Demand
CRITICAL_IND VARCHAR2 (2)
Whether the item has become critical
CUST_VEND VARCHAR2 (32)
Customer - Vendor code
PLANNING_CATEGORY_ID NUMBER

Category Id for PLANNING_CLASS
INVENTORY_ITEM_ID NUMBER

Inventory Item ID
ORGANIZATION_ID NUMBER

Organization ID

[top of page]

GMP.PS_UBKT_DTL does not reference any database object

GMP.PS_UBKT_DTL is referenced by following:

APPS
SYNONYM - 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
Comments

Plant-warehouse relationship (effectivity) table. Specifies the warehouses items are consumed from and replenished by plants. Used MRP, and by Production for determining default warehouse for
transactions.

Indexes
Index Type Tablespace Column
PS_WHSE_EFF_PK UNIQUE APPS_TS_TX_IDX PSWHSE_EFF_ID
PS_WHSE_EFF_U1 UNIQUE APPS_TS_TX_IDX PLANT_CODE
WHSE_CODE
WHSE_ITEM_ID
Columns
Name Datatype Length Mandatory Comments
PSWHSE_EFF_ID NUMBER (15) Y Surrogate id for the effectivity
PLANT_CODE VARCHAR2 (4) Y Plant for which consumption and replenishment warehouses are defined.
WHSE_CODE VARCHAR2 (4) Y Warehouse associated with the plant.
WHSE_ITEM_ID NUMBER (10)
Surrogate key for a warehouse item. Warehouse items are used to group together items having similar consumption-replenishment characteristics
CONSUM_IND NUMBER (5) Y Consumption indicator. 0=Item is not consumed from this warehouse,
REPLEN_IND NUMBER (5) Y Replenishment indicator. 0=Item is not replenished into this warehouse; 1= Item can be replenished into this warehouse
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
TRANS_CNT NUMBER (10)
Not currently used
DELETE_MARK NUMBER (5) Y Standard: 0=Active record (default); 1=Marked for (logical) deletion.
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column

[top of page]

GMP.PS_WHSE_EFF does not reference any database object

GMP.PS_WHSE_EFF is referenced by following:

APPS
SYNONYM - 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
Comments
Primary Key: RH_ACTN_TBL_PK
  1. ACTION_SET
  2. SEQUENCE_NUMBER
Indexes
Index Type Tablespace Column
RH_ACTN_TBL_PK UNIQUE APPS_TS_ARCHIVE ACTION_SET
SEQUENCE_NUMBER
Columns
Name Datatype Length Mandatory Comments
ACTION_SET VARCHAR2 (240) Y
ACTION_TYPE VARCHAR2 (240) Y
ACTION_IND VARCHAR2 (1) Y
DESCRIPTION VARCHAR2 (240) Y
SEQUENCE_NUMBER NUMBER
Y
BATCH_COMMAND VARCHAR2 (240) Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

GMP.RH_ACTN_TBL does not reference any database object

GMP.RH_ACTN_TBL is referenced by following:

APPS
SYNONYM - 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
Comments
Indexes
Index Type Tablespace Column
RH_DORD_IMPI1 NONUNIQUE APPS_TS_SEED IMPORT_ID
ACTION_TYPE
ORGN_CODE
Columns
Name Datatype Length Mandatory Comments
IMPORT_ID NUMBER (10) Y
LINE_ID NUMBER (10) Y
LINE_NO NUMBER (10) Y
PROCESS_ID NUMBER (10) Y
ORGN_CODE VARCHAR2 (4) Y
DOC_TYPE VARCHAR2 (4) Y
ORDER_NO VARCHAR2 (32) Y
OLD_ORDER_QTY NUMBER (21) Y
ORDER_QTY NUMBER (21) Y
OLD_SCHED_DATE DATE
Y
SCHED_DATE DATE
Y
OLD_PRIORITY NUMBER (10) Y
PRIORITY NUMBER (10) Y
NEW_DOC_TYPE VARCHAR2 (4) Y
NEW_DOC_ID NUMBER (10) Y
ACTION_TYPE NUMBER (1) Y
OLD_ORDER_UOM VARCHAR2 (4) Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y

[top of page]

GMP.RH_DORD_IMP does not reference any database object

GMP.RH_DORD_IMP is referenced by following:

APPS
SYNONYM - 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
Comments
Columns
Name Datatype Length Mandatory Comments
EXPORT_ID NUMBER (10) Y
EXPORT_TYPE VARCHAR2 (16) Y
ROWS_PROCESSED NUMBER (10) Y
RUN_STATUS NUMBER (5) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15) Y

[top of page]

GMP.RH_EXPT_DTL does not reference any database object

GMP.RH_EXPT_DTL is referenced by following:

APPS
SYNONYM - 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
Comments
Indexes
Index Type Tablespace Column
RH_EXPT_MST_I1 NONUNIQUE APPS_TS_ARCHIVE SCHEDULE_ID
EXPORT_ID
Columns
Name Datatype Length Mandatory Comments
SCHEDULE_ID NUMBER (22) Y
RUN_STATUS NUMBER (5) Y
RUN_BY VARCHAR2 (4) Y
EXPORT_ID NUMBER (10) Y
QUEUE_NO NUMBER
Y
BATCH_DATE DATE
Y
ACTUAL_END_DATE DATE

ACTUAL_START_DATE DATE

CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

GMP.RH_EXPT_MST does not reference any database object

GMP.RH_EXPT_MST is referenced by following:

APPS
SYNONYM - 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
Comments
Columns
Name Datatype Length Mandatory Comments
IMPORT_ID NUMBER (10) Y
IMPORT_TYPE VARCHAR2 (16) Y
RUN_STATUS NUMBER (5) Y
ROWS_PROCESSED NUMBER (10) Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

GMP.RH_IMPT_DTL does not reference any database object

GMP.RH_IMPT_DTL is referenced by following:

APPS
SYNONYM - 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
Comments
Indexes
Index Type Tablespace Column
RH_IMPT_MST_I1 NONUNIQUE APPS_TS_ARCHIVE SCHEDULE_ID
IMPORT_ID
Columns
Name Datatype Length Mandatory Comments
IMPORT_ID NUMBER (10) Y
SCHEDULE_ID NUMBER (22) Y
ACTUAL_END_DATE DATE

ACTUAL_START_DATE DATE

QUEUE_NO NUMBER
Y
RUN_STATUS NUMBER (5) Y
RUN_BY VARCHAR2 (4) Y
BATCH_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y

[top of page]

GMP.RH_IMPT_MST does not reference any database object

GMP.RH_IMPT_MST is referenced by following:

APPS
SYNONYM - 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
Comments
Columns
Name Datatype Length Mandatory Comments
FKEY_ID NUMBER (10) Y
LINE_NO NUMBER (10) Y
MESSAGE_CODE VARCHAR2 (32) Y
PARAMETER1 VARCHAR2 (32)
PARAMETER2 VARCHAR2 (32)
PARAMETER3 VARCHAR2 (32)
PARAMETER4 VARCHAR2 (32)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y

[top of page]

GMP.RH_MESG_TBL does not reference any database object

GMP.RH_MESG_TBL is referenced by following:

APPS
SYNONYM - 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
Comments
Indexes
Index Type Tablespace Column
RH_MORD_IMPI1 NONUNIQUE APPS_TS_ARCHIVE IMPORT_ID
ACTION_TYPE
ORGN_CODE
Columns
Name Datatype Length Mandatory Comments
IMPORT_ID NUMBER (10) Y
BATCH_ID NUMBER (10) Y
LINE_NO NUMBER (10) Y
PROCESS_ID NUMBER (10) Y
DOC_TYPE VARCHAR2 (4) Y
BATCH_NO VARCHAR2 (32) Y
ORGN_CODE VARCHAR2 (4) Y
OLD_ROUTING_NO VARCHAR2 (32) Y
OLD_ROUTING_VERS NUMBER (5) Y
ROUTING_NO VARCHAR2 (32) Y
ROUTING_VERS NUMBER (10) Y
EFF_ID NUMBER (10) Y
OLD_EFF_ID NUMBER (10) Y
OLD_PLAN_QTY NUMBER (21) Y
PLAN_QTY NUMBER (21) Y
OLD_PST DATE
Y
PST DATE
Y
OLD_PET DATE
Y
PET DATE
Y
NEW_DOC_TYPE VARCHAR2 (4) Y
NEW_DOC_ID NUMBER (10) Y
ACTION_TYPE NUMBER (10) Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

GMP.RH_MORD_IMP does not reference any database object

GMP.RH_MORD_IMP is referenced by following:

APPS
SYNONYM - 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
Comments
Columns
Name Datatype Length Mandatory Comments
PARM_TYPE NUMBER (5) Y
PARM_VALUE VARCHAR2 (40) Y
PARAMETER VARCHAR2 (16) Y
SCHEDULE_ID NUMBER (22) Y
DESCRIPTION VARCHAR2 (70) Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

GMP.RH_PARM_TBL does not reference any database object

GMP.RH_PARM_TBL is referenced by following:

APPS
SYNONYM - 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
Comments
Columns
Name Datatype Length Mandatory Comments
PARAMETER VARCHAR2 (16) Y
PARM_TYPE NUMBER (5) Y
DESCRIPTION VARCHAR2 (70) Y
DEFAULT_VALUE VARCHAR2 (40) Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

GMP.RH_PARM_TYP does not reference any database object

GMP.RH_PARM_TYP is referenced by following:

APPS
SYNONYM - 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
Comments
Columns
Name Datatype Length Mandatory Comments
SCHEDULE_ID NUMBER
Y
ORGN_CODE VARCHAR2 (4) Y
RESOURCES VARCHAR2 (16) Y
CALENDAR_ID NUMBER
Y
DATE_EXPORTED DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

GMP.RH_RSCL_TBL does not reference any database object

GMP.RH_RSCL_TBL is referenced by following:

APPS
SYNONYM - RH_RSCL_TBL

[top of page]

View: CR_RSRC_CLS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Resource Class view

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
RESOURCE_CLASS VARCHAR2 (8) Y
CREATION_DATE DATE
Y
LAST_UPDATE_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
TRANS_CNT NUMBER (10)
DELETE_MARK NUMBER (5) Y
TEXT_CODE NUMBER (10)
LAST_UPDATE_LOGIN NUMBER (15)
RESOURCE_CLASS_DESC VARCHAR2 (40) Y

[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
TRIGGER - CR_RSRC_CLS_DL
TRIGGER - CR_RSRC_CLS_IL
TRIGGER - CR_RSRC_CLS_UL

[top of page]

View: CR_RSRC_DTL_VW1

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

NOT CURRENTLY USED.

Columns
Name Datatype Length Mandatory Comments
RESOURCES VARCHAR2 (16) Y Resource name
RESOURCE_DESC VARCHAR2 (40) Y Description of the resource
DELETE_MARK NUMBER (22) Y Indicator to show if the resource is marked for purge.
ORGN_CODE VARCHAR2 (4)
Organization code of the owner organization

[top of page]

APPS.CR_RSRC_DTL_VW1 references the following:

APPS
SYNONYM - CR_RSRC_DTL
SYNONYM - CR_RSRC_MST

APPS.CR_RSRC_DTL_VW1 is not referenced by any database object

[top of page]

View: CR_RSRC_DTL_VW2

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

View for identifying group resources.

Columns
Name Datatype Length Mandatory Comments
RESOURCES VARCHAR2 (16) Y Resource name.
RESOURCE_DESC VARCHAR2 (40) Y Resource description.
DELETE_MARK NUMBER (22) Y Delete mark. 0=not deleted, 1=deleted.
ORGN_CODE VARCHAR2 (4)
Organization code of the owner organization

[top of page]

APPS.CR_RSRC_DTL_VW2 references the following:

APPS
SYNONYM - CR_RSRC_DTL
SYNONYM - CR_RSRC_MST

APPS.CR_RSRC_DTL_VW2 is not referenced by any database object

[top of page]

View: CR_RSRC_MST_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Resource Master view

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
RESOURCE_CLASS VARCHAR2 (8)
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
TRANS_CNT NUMBER (22)
DELETE_MARK NUMBER (22) Y
TEXT_CODE NUMBER (10)
LAST_UPDATE_LOGIN NUMBER (15)
MIN_CAPACITY NUMBER

MAX_CAPACITY NUMBER

CAPACITY_CONSTRAINT NUMBER (5)
CAPACITY_UOM VARCHAR2 (4)
RESOURCES VARCHAR2 (16) Y
STD_USAGE_UM VARCHAR2 (4)
COST_CMPNTCLS_ID NUMBER (10) Y
CAPACITY_TOLERANCE NUMBER

Resource Capacity Tolerance
UTILIZATION NUMBER

Indicates the resource utilization.
EFFICIENCY NUMBER

Indicates the resource efficiency.
RESOURCE_DESC VARCHAR2 (40) Y
STD_USAGE_UOM VARCHAR2 (3)
Standard Usage UOM
CAPACITY_UM VARCHAR2 (3)
Capacity UM

[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
TRIGGER - CR_RSRC_MST_DL

[top of page]

View: CR_SQDS_TBL_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

Not currently used.

Columns
Name Datatype Length Mandatory Comments
OPRN_NO VARCHAR2 (16) Y Operation identifier
FROM_ITEM_CLASS VARCHAR2 (8) Y Sequence dependent class name for "From" class
TO_ITEM_CLASS VARCHAR2 (8) Y Sequence dependent class name for "To" class

[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

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

Not currently used.

Columns
Name Datatype Length Mandatory Comments
SEQ_DPND_CLASS VARCHAR2 (163)
Name of the sequence dependent class /category
SEQ_CATEGORY_ID NUMBER

Unique identifier of the category ccode
SEQ_DPND_CLASS_DESC VARCHAR2 (240)
Description of the sequence dependent class/category
TRANS_CNT NUMBER

No longer used
DELETE_MARK NUMBER

Indicator if the sequence dependent class if marked for purge.
TEXT_CODE NUMBER

Text code of the text associated with the Sequence Dependent class
CREATION_DATE DATE

Standard "Who" Cloumn
CREATED_BY NUMBER

Standard "Who" Cloumn
LAST_UPDATE_DATE DATE

Standard "Who" Cloumn
LAST_UPDATED_BY NUMBER

Standard "Who" Cloumn
LAST_UPDATE_LOGIN NUMBER

Standard "Who" Cloumn

[top of page]

APPS.CR_SQDT_CLS_VW references the following:

APPS
VIEW - MTL_CATEGORIES_V
SYNONYM - MTL_CATEGORY_SETS
SYNONYM - MTL_CATEGORY_SET_VALID_CATS
SYNONYM - MTL_DEFAULT_CATEGORY_SETS
APPS.CR_SQDT_CLS_VW is referenced by following:

APPS
SYNONYM - CR_SQDT_CLS

[top of page]

View: CR_TEXT_TBL_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

CR text table view

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
TEXT_CODE NUMBER (10) Y ID which joins any rows of text in this table to the Text Table for this Module
LANG_CODE VARCHAR2 (4) Y
PARAGRAPH_CODE VARCHAR2 (4) Y
SUB_PARACODE NUMBER (5) Y
LINE_NO NUMBER (5) Y
LAST_UPDATED_BY NUMBER (15) Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
CREATION_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
TEXT VARCHAR2 (70)

[top of page]

APPS.CR_TEXT_TBL_VL references the following:

APPS
SYNONYM - CR_TEXT_TBL_TL
APPS.CR_TEXT_TBL_VL is referenced by following:

APPS
SYNONYM - CR_TEXT_TBL
TRIGGER - GMA_CR_TEXT_TBL_T1
TRIGGER - GMA_CR_TEXT_TBL_T2
TRIGGER - GMA_CR_TEXT_TBL_T3

[top of page]

View: FC_TEXT_TBL_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

FC text table view

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
TEXT_CODE NUMBER (10) Y ID which joins any rows of text in this table to the Text Table for this Module
LANG_CODE VARCHAR2 (4) Y
PARAGRAPH_CODE VARCHAR2 (4) Y
SUB_PARACODE NUMBER (5) Y
LINE_NO NUMBER (5) Y
LAST_UPDATED_BY NUMBER (15) Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
CREATION_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
TEXT VARCHAR2 (70)

[top of page]

APPS.FC_TEXT_TBL_VL references the following:

APPS
SYNONYM - FC_TEXT_TBL_TL
APPS.FC_TEXT_TBL_VL is referenced by following:

APPS
SYNONYM - FC_TEXT_TBL
TRIGGER - GMA_FC_TEXT_TBL_T1
TRIGGER - GMA_FC_TEXT_TBL_T2
TRIGGER - GMA_FC_TEXT_TBL_T3

[top of page]

View: GMP_EAM_EQUIP_RESOURCES_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

OPM Resource to eAM equipment mapping view

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Database rtow identifier
ORGANIZATION_ID NUMBER
Y Organziation id of the ownr organization
INVENTORY_ITEM_ID NUMBER
Y Inventory Item Id for the equipment item associated with the resource instance
SERIAL_NUMBER VARCHAR2 (30)
Serial Number of the resource instance
RESOURCE_ID NUMBER (10) Y Unique identifier of the resource
RESOURCE_CODE VARCHAR2 (16) Y Code of the resource or its name
DESCRIPTION VARCHAR2 (40) Y Description of the resource
INSTANCE_ID NUMBER
Y Unique identifier of the instance of the resource
DEPARTMENT_ID NUMBER
Y Unique identifier of the owner department
DEPARTMENT_CODE VARCHAR2 (3)
Code of the owner department
SHARE_FROM_DEPT_ID NUMBER

Unique identifier of the department shared from
SHARE_FROM_DEPT_CODE VARCHAR2 (0)
Unique identifier of the department shared from
OWNING_DEPARTMENT_CODE VARCHAR2 (3)
Code of the owner department
CAPACITY_UNITS NUMBER
Y Number of the resource instances.
AVAILABLE_24_HOURS_FLAG NUMBER

Indicator if the resource is available all 24 hours of the day
RESOURCE_GROUP_NAME VARCHAR2 (16) Y Group to which the resource belongs
SHARE_CAPACITY_FLAG NUMBER

Indicator if the resouce could share capacity
UNIT_OF_MEASURE VARCHAR2 (3)
UOM for resource use measurement
AUTOCHARGE_TYPE NUMBER

Indicator for auto-recharge
CTP_FLAG NUMBER

Indicator to indicate whether to include in CTP calculations
SCHEDULE_TO_INSTANCE NUMBER

Indicator showing if the resource is scheduled to instance level by scheduler

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View for data of OPM batches/FPOs schduled on resources

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
RESOURCE_ID NUMBER (10) Y
DEPARTMENT_ID NUMBER

WIP_ENTITY_ID NUMBER (10) Y
WIP_ENTITY_NAME VARCHAR2 (32) Y
DESCRIPTION VARCHAR2 (32) Y
SCHEDULED_START_DATE DATE
Y
SCHEDULED_COMPLETION_DATE DATE
Y
STATUS_TYPE NUMBER (5) Y
STATUS_TYPE_MEANING VARCHAR2 (80) Y
JOB_TYPE NUMBER (5) Y
JOB_TYPE_MEANING VARCHAR2 (5)
CLASS_CODE VARCHAR2 (0)
REBUILD_ITEM_ID NUMBER

ENTITY_TYPE NUMBER

ENTITY_TYPE_CODE VARCHAR2 (0)

[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

Comments
Columns
Name Datatype Length Mandatory Comments
CALENDAR_ID NUMBER (10) Y
WEEK_NO NUMBER

WEEK_START_DATE DATE

WEEK_END_DATE DATE

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View for On Hand Inventory balances that are nettable

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

INVENTORY_ITEM_ID NUMBER

SUBINVENTORY_CODE VARCHAR2 (10)
LOT_NUMBER VARCHAR2 (80)
QUANTITY NUMBER

PLANNING_ORGANIZATION_ID NUMBER

PLANNING_TP_TYPE NUMBER

OWNING_ORGANIZATION_ID NUMBER

OWNING_TP_TYPE NUMBER

EXPIRATION_DATE DATE

PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
PLANNING_GROUP VARCHAR2 (30)
END_ITEM_UNIT_NUMBER VARCHAR2 (4000)

[top of page]

APPS.GMP_NETTABLE_ONHANDS_V references the following:

APPS
SYNONYM - MTL_ITEM_LOCATIONS
SYNONYM - MTL_LOT_NUMBERS
SYNONYM - MTL_MATERIAL_STATUSES
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
APPS.GMP_NETTABLE_ONHANDS_V is referenced by following:

APPS
PACKAGE BODY - GMP_WPS_WRITER

[top of page]

View: GMP_PARAMETER_VALUES_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Parameter value view

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
PARAMETER_ID NUMBER (15) Y
PARAMETER_VALUE VARCHAR2 (16) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER
Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER
Y
LAST_UPDATE_LOGIN NUMBER

PARAMETER_VALUE_DESCRIPTION VARCHAR2 (240) Y

[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 referenced by following:

APPS
SYNONYM - GMP_PARAMETER_VALUES

[top of page]

View: GMP_PDR_BUYER_V

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Unique list of buyers from msc_system_items in each organization for an instance and plan

Columns
Name Datatype Length Mandatory Comments
BUYER_NAME VARCHAR2 (240)
Buyer Name.
BUYER_ID NUMBER (9)
Buyer ID.
ORGANIZATION_ID NUMBER
Y Organization ID.
SR_INSTANCE_ID NUMBER
Y Instance ID.
PLAN_ID NUMBER
Y Plan ID.

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Unique list of categories from msc_item_categories in each organization for an instance.

Columns
Name Datatype Length Mandatory Comments
CATEGORY_NAME VARCHAR2 (250) Y Category Name.
DESCRIPTION VARCHAR2 (240)
Category Description.
ORGANIZATION_ID NUMBER
Y Organization ID.
SR_INSTANCE_ID NUMBER
Y Instance ID.
CATEGORY_SET_ID NUMBER
Y Category Set ID.

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

List of all Organizations from plan along with additional entry for All as organization.

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Organization ID.
ORGANIZATION_CODE VARCHAR2 (80)
Organization Code.
SR_INSTANCE_ID NUMBER

Instance ID.
PLAN_ID NUMBER

Plan ID.

[top of page]

APPS.GMP_PLAN_ORGANIZATION_V references the following:

APPS
VIEW - MFG_LOOKUPS
SYNONYM - MSC_PLAN_ORGANIZATIONS
APPS.GMP_PLAN_ORGANIZATION_V is referenced by following:

APPS
PACKAGE BODY - GMP_PLNG_DTL_REPORT_PKG

[top of page]

View: GMP_PROCESS_PARAMETERS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Process parameter view

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
PARAMETER_ID NUMBER (15) Y
PARAMETER_NAME VARCHAR2 (40) Y
PARAMETER_DESCRIPTION VARCHAR2 (240) Y
PARAMETER_TYPE NUMBER
Y
MINIMUM_VALUE NUMBER

MAXIMUM_VALUE NUMBER

UNITS VARCHAR2 (25)
DELETE_MARK NUMBER
Y
TEXT_CODE NUMBER (10)
CREATION_DATE DATE
Y
CREATED_BY NUMBER
Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER
Y
LAST_UPDATE_LOGIN NUMBER

ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE2 VARCHAR2 (240)
ATTRIBUTE3 VARCHAR2 (240)
ATTRIBUTE4 VARCHAR2 (240)
ATTRIBUTE5 VARCHAR2 (240)
ATTRIBUTE6 VARCHAR2 (240)
ATTRIBUTE7 VARCHAR2 (240)
ATTRIBUTE8 VARCHAR2 (240)
ATTRIBUTE9 VARCHAR2 (240)
ATTRIBUTE10 VARCHAR2 (240)
ATTRIBUTE11 VARCHAR2 (240)
ATTRIBUTE12 VARCHAR2 (240)
ATTRIBUTE13 VARCHAR2 (240)
ATTRIBUTE14 VARCHAR2 (240)
ATTRIBUTE15 VARCHAR2 (240)
ATTRIBUTE16 VARCHAR2 (240)
ATTRIBUTE17 VARCHAR2 (240)
ATTRIBUTE18 VARCHAR2 (240)
ATTRIBUTE19 VARCHAR2 (240)
ATTRIBUTE20 VARCHAR2 (240)
ATTRIBUTE21 VARCHAR2 (240)
ATTRIBUTE22 VARCHAR2 (240)
ATTRIBUTE23 VARCHAR2 (240)
ATTRIBUTE24 VARCHAR2 (240)
ATTRIBUTE25 VARCHAR2 (240)
ATTRIBUTE26 VARCHAR2 (240)
ATTRIBUTE27 VARCHAR2 (240)
ATTRIBUTE28 VARCHAR2 (240)
ATTRIBUTE29 VARCHAR2 (240)
ATTRIBUTE30 VARCHAR2 (240)
ATTRIBUTE_CATEGORY VARCHAR2 (30)

[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 referenced by following:

APPS
VIEW - GME_PROCESS_PARAMETERS_V
SYNONYM - GMP_PROCESS_PARAMETERS

[top of page]

View: GMP_PROCESS_PARAMETER_SET_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Process parameter set view

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
PARAMETER_SET_ID NUMBER (15) Y
PARAMETER_SET VARCHAR2 (40) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER
Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER
Y
LAST_UPDATE_LOGIN NUMBER

SET_DESCRIPTION VARCHAR2 (240) Y

[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 referenced by following:

APPS
SYNONYM - GMP_PROCESS_PARAMETER_SET

[top of page]

View: GMP_RESOURCE_AVAIL_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

Resource availability per calendar and downtime

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Unique identifier of the owner organization
CALENDAR_CODE VARCHAR2 (10)
Code of the calendar used in calculating this availability
RESOURCE_ID NUMBER
Y Unique identifier of the resource
RESOURCE_INSTANCE_ID NUMBER

Unique identifier of the specific instance of resource

[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

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

Resource calendar view

Columns
Name Datatype Length Mandatory Comments
CAL_ID NUMBER (10) Y Unique identifier of the calendar used with the resource
CDATE DATE
Y Calendar date
SHIFT_NO NUMBER (5) Y Shift Number
FTIME DATE

Start time
TTIME DATE

End Time

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Resource Unavailable Detail view

Columns
Name Datatype Length Mandatory Comments
EXCEPTION_ID NUMBER

Surrogate Key
EXCEPTION_CODE VARCHAR2 (6)
Code,User generated Description
RESOURCE_ID NUMBER

Internal Id for resource FK to CR_RSRC_DTL
INSTANCE_ID NUMBER

Surrogate key which uniquely indentifies the instance of a resource. This comes from the sequence GMP_RESOURCE_INSTANCES_S.
RESOURCE_UNITS NUMBER

Number of Resources that are Not Available
FROM_DATE DATE

Start Date-time of Unavailable time
TO_DATE DATE

End Date-time of Unavailable time
WIP_ENTITY_ID NUMBER

OP_SEQ NUMBER

MAINT_ORG_ID NUMBER

REASON_CODE VARCHAR2 (30)
DESCRIPTION VARCHAR2 (240)

[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 referenced by following:

APPS
PACKAGE BODY - GMP_RSRC_AVL_PKG

[top of page]

View: GMP_SCHEDULING_EXCEPTIONS_V

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Exception generated by Manufacturing Scheduler during scheduling run

Columns
Name Datatype Length Mandatory Comments
JOB_NAME VARCHAR2 (32) Y
ORGANIZATION_CODE VARCHAR2 (3)
ASSEMBLY VARCHAR2 (40)
ASSEMBLY_DESC VARCHAR2 (240)
PRIMARY_ITEM_ID NUMBER
Y
SCHEDULING_SOURCE VARCHAR2 (30)
SCHEDULING_SOURCE_ID NUMBER

MESG_SEQUENCE NUMBER
Y
MESSAGE_TYPE NUMBER

REPORTED_DATE DATE
Y
BATCH_STATUS NUMBER (5) Y
PLANNED_START DATE
Y
PLANNED_COMPLETION DATE
Y
REQUIRED_COMPLETION DATE
Y
SCHEDULING_PRIORITY NUMBER
Y
WIP_ENTITY_ID NUMBER

ORGANIZATION_ID NUMBER
Y
RECIPE_VALIDITY_RULE_ID NUMBER (10)
ROUTING_ID NUMBER (10)
FORMULA_ID NUMBER (10)

[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 - MTL_SYSTEM_ITEMS_KFV
SYNONYM - WIP_SCHEDULING_EXCEPTIONS

APPS.GMP_SCHEDULING_EXCEPTIONS_V is not referenced by any database object

[top of page]

View: GMP_SR_BG_ALL_V

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View for generating Business Group to ALL mapping (for Demand Planner with OPM)

Columns
Name Datatype Length Mandatory Comments
LEVEL_VALUE_PK NUMBER

LEVEL_VALUE VARCHAR2 (0)
PARENT_VALUE_PK NUMBER

PARENT_VALUE VARCHAR2 (0)
ATTRIBUTE1 VARCHAR2 (0)
ATTRIBUTE2 VARCHAR2 (0)
ATTRIBUTE3 VARCHAR2 (0)
ATTRIBUTE4 VARCHAR2 (0)
ATTRIBUTE5 VARCHAR2 (0)

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View for booking data - for data collection into Demand Planner from OPM

Columns
Name Datatype Length Mandatory Comments
SR_INV_ORG_PK NUMBER

INV_ORG VARCHAR2 (0)
SR_ITEM_PK NUMBER

ITEM VARCHAR2 (0)
SR_CUSTOMER_PK NUMBER

CUSTOMER VARCHAR2 (0)
SR_SALES_CHANNEL_PK VARCHAR2 (0)
SALES_CHANNEL VARCHAR2 (0)
SR_SALES_REP_PK NUMBER

SALES_REP VARCHAR2 (0)
SR_SHIP_TO_LOC_PK NUMBER

SHIP_TO_LOC VARCHAR2 (0)
BOOKED_DATE DATE

REQUESTED_DATE DATE

PROMISED_DATE DATE

SCHEDULED_DATE DATE

AMOUNT NUMBER

QTY_ORDERED NUMBER

SR_USER_DEFINED1_PK NUMBER

USER_DEFINED1 VARCHAR2 (0)
SR_USER_DEFINED2_PK NUMBER

USER_DEFINED2 VARCHAR2 (0)
SR_ORIGINAL_ITEM_PK NUMBER

SR_PARENT_ITEM_PK VARCHAR2 (0)

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View for Legal Entity to Business Group mapping using OPM organizations (for Demand Planner)

Columns
Name Datatype Length Mandatory Comments
LEVEL_VALUE_PK NUMBER

LEVEL_VALUE VARCHAR2 (0)
PARENT_VALUE_PK NUMBER

PARENT_VALUE VARCHAR2 (0)
ATTRIBUTE1 VARCHAR2 (0)
ATTRIBUTE2 VARCHAR2 (0)
ATTRIBUTE3 VARCHAR2 (0)
ATTRIBUTE4 VARCHAR2 (0)
ATTRIBUTE5 VARCHAR2 (0)

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View for providing forecast data in OPM as Manufacturing Forecast to Demand Planner

Columns
Name Datatype Length Mandatory Comments
FORECAST_DESIGNATOR VARCHAR2 (0)
SR_INV_ORG_PK NUMBER

INV_ORG VARCHAR2 (0)
SR_ITEM_PK NUMBER

ITEM VARCHAR2 (0)
SR_CUSTOMER_PK NUMBER

CUSTOMER VARCHAR2 (0)
SR_SALES_CHANNEL_PK NUMBER

SALES_CHANNEL VARCHAR2 (0)
SR_SHIP_TO_LOC_PK NUMBER

SHIP_TO_LOC VARCHAR2 (0)
BUCKET_TYPE NUMBER

FORECAST_DATE DATE

RATE_END_DATE DATE

ORIGINAL_QUANTITY NUMBER

CURRENT_QUANTITY NUMBER

SR_USER_DEFINED1_PK VARCHAR2 (0)
USER_DEFINED1 VARCHAR2 (0)
SR_USER_DEFINED2_PK VARCHAR2 (0)
USER_DEFINED2 VARCHAR2 (0)
PRD_LEVEL_ID NUMBER

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

VIew to provide data from OPM calendars to Demand Planner as Manufacturing Calendar

Columns
Name Datatype Length Mandatory Comments
CALENDAR_CODE VARCHAR2 (0)
SEQ_NUM NUMBER

YEAR VARCHAR2 (0)
YEAR_DESCRIPTION VARCHAR2 (0)
YEAR_START_DATE VARCHAR2 (0)
YEAR_END_DATE VARCHAR2 (0)
QUARTER VARCHAR2 (0)
QUARTER_DESCRIPTION VARCHAR2 (0)
QUARTER_START_DATE VARCHAR2 (0)
QUARTER_END_DATE VARCHAR2 (0)
MONTH VARCHAR2 (0)
MONTH_DESCRIPTION VARCHAR2 (0)
MONTH_START_DATE DATE

MONTH_END_DATE DATE

WEEK VARCHAR2 (0)
WEEK_DESCRIPTION VARCHAR2 (0)
WEEK_START_DATE DATE

WEEK_END_DATE DATE

DAY DATE

DAY_DESCRIPTION DATE

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

VIew to map OPM organizations as Organization to Operating Units (for Demand Planner)

Columns
Name Datatype Length Mandatory Comments
LEVEL_VALUE_PK NUMBER

LEVEL_VALUE VARCHAR2 (0)
PARENT_VALUE_PK NUMBER

PARENT_VALUE VARCHAR2 (0)
ATTRIBUTE1 VARCHAR2 (0)
ATTRIBUTE2 VARCHAR2 (0)
ATTRIBUTE3 VARCHAR2 (0)
ATTRIBUTE4 VARCHAR2 (0)
ATTRIBUTE5 VARCHAR2 (0)

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

VIew to map OPM organizations in Operating Unit and Legal Entity relationship (for Demand Planner)

Columns
Name Datatype Length Mandatory Comments
LEVEL_VALUE_PK NUMBER

LEVEL_VALUE VARCHAR2 (0)
PARENT_VALUE_PK NUMBER

PARENT_VALUE VARCHAR2 (0)
ATTRIBUTE1 VARCHAR2 (0)
ATTRIBUTE2 VARCHAR2 (0)
ATTRIBUTE3 VARCHAR2 (0)
ATTRIBUTE4 VARCHAR2 (0)
ATTRIBUTE5 VARCHAR2 (0)

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View for Shipment data from OPM schema (for collecting into Demand Planner)

Columns
Name Datatype Length Mandatory Comments
SR_INV_ORG_PK NUMBER

INV_ORG VARCHAR2 (0)
SR_ITEM_PK NUMBER

ITEM VARCHAR2 (0)
SR_CUSTOMER_PK NUMBER

CUSTOMER VARCHAR2 (0)
SR_SALES_CHANNEL_PK VARCHAR2 (0)
SALES_CHANNEL VARCHAR2 (0)
SR_SALES_REP_PK NUMBER

SALES_REP VARCHAR2 (0)
SR_SHIP_TO_LOC_PK NUMBER

SHIP_TO_LOC VARCHAR2 (0)
BOOKED_DATE DATE

REQUESTED_DATE DATE

PROMISED_DATE DATE

SCHEDULED_DATE DATE

SHIPPED_DATE DATE

AMOUNT NUMBER

QTY_SHIPPED NUMBER

SR_USER_DEFINED1_PK NUMBER

USER_DEFINED1 VARCHAR2 (0)
SR_USER_DEFINED2_PK NUMBER

USER_DEFINED2 VARCHAR2 (0)
SR_ORIGINAL_ITEM_PK NUMBER

SR_PARENT_ITEM_PK VARCHAR2 (0)

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

MR text table view

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
TEXT_CODE NUMBER (10) Y ID which joins any rows of text in this table to the Text Table for this Module
LANG_CODE VARCHAR2 (4) Y
PARAGRAPH_CODE VARCHAR2 (4) Y
SUB_PARACODE NUMBER (5) Y
LINE_NO NUMBER (5) Y
TEXT VARCHAR2 (70)
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y
CREATION_DATE DATE
Y

[top of page]

APPS.MR_TEXT_TBL_VL references the following:

APPS
SYNONYM - MR_TEXT_TBL_TL
APPS.MR_TEXT_TBL_VL is referenced by following:

APPS
TRIGGER - GMA_MR_TEXT_TBL_T1
TRIGGER - GMA_MR_TEXT_TBL_T2
TRIGGER - GMA_MR_TEXT_TBL_T3
SYNONYM - MR_TEXT_TBL

[top of page]

View: PS_PLNG_CLS_VW

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

Planning Class view

Columns
Name Datatype Length Mandatory Comments
PLANNING_CLASS VARCHAR2 (8)
Name / code of the planning class/category
PLANNING_CATEGORY_ID NUMBER
Y Unique identifier of the planning category
PLANNING_CLASS_DESC VARCHAR2 (70)
Description of the Planning category
TEXT_CODE NUMBER

Code of the text associated with the planning category/class
TRANS_CNT NUMBER

No Longer Used
DELETE_MARK NUMBER

Indicator to show if the planning class has been marked for purge
CREATED_BY NUMBER
Y Standard "Who" column
CREATION_DATE DATE
Y Standard "Who" column
LAST_UPDATED_BY NUMBER
Y Standard "Who" column
LAST_UPDATE_DATE DATE
Y Standard "Who" column
LAST_UPDATE_LOGIN NUMBER

Standard "Who" column
ATTRIBUTE1 VARCHAR2 (150)
Stadard FlexField column
ATTRIBUTE2 VARCHAR2 (150)
Stadard FlexField column
ATTRIBUTE3 VARCHAR2 (150)
Stadard FlexField column
ATTRIBUTE4 VARCHAR2 (150)
Stadard FlexField column
ATTRIBUTE5 VARCHAR2 (150)
Stadard FlexField column
ATTRIBUTE6 VARCHAR2 (150)
Stadard FlexField column
ATTRIBUTE7 VARCHAR2 (150)
Stadard FlexField column
ATTRIBUTE8 VARCHAR2 (150)
Stadard FlexField column
ATTRIBUTE9 VARCHAR2 (150)
Stadard FlexField column
ATTRIBUTE10 VARCHAR2 (150)
Stadard FlexField column
ATTRIBUTE11 VARCHAR2 (150)
Stadard FlexField column
ATTRIBUTE12 VARCHAR2 (150)
Stadard FlexField column
ATTRIBUTE13 VARCHAR2 (150)
Stadard FlexField column
ATTRIBUTE14 VARCHAR2 (150)
Stadard FlexField column
ATTRIBUTE15 VARCHAR2 (150)
Stadard FlexField column
ATTRIBUTE16 VARCHAR2 (0)
Stadard FlexField column
ATTRIBUTE17 VARCHAR2 (0)
Stadard FlexField column
ATTRIBUTE18 VARCHAR2 (0)
Stadard FlexField column
ATTRIBUTE19 VARCHAR2 (0)
Stadard FlexField column
ATTRIBUTE20 VARCHAR2 (0)
Stadard FlexField column
ATTRIBUTE21 VARCHAR2 (0)
Stadard FlexField column
ATTRIBUTE22 VARCHAR2 (0)
Stadard FlexField column
ATTRIBUTE23 VARCHAR2 (0)
Stadard FlexField column
ATTRIBUTE24 VARCHAR2 (0)
Stadard FlexField column
ATTRIBUTE25 VARCHAR2 (0)
Stadard FlexField column
ATTRIBUTE26 VARCHAR2 (0)
Stadard FlexField column
ATTRIBUTE27 VARCHAR2 (0)
Stadard FlexField column
ATTRIBUTE28 VARCHAR2 (0)
Stadard FlexField column
ATTRIBUTE29 VARCHAR2 (0)
Stadard FlexField column
ATTRIBUTE30 VARCHAR2 (0)
Stadard FlexField column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Stadard FlexField column
REPORTING_UOM VARCHAR2 (0)
UOM for reporting

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

PS text table view

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
TEXT_CODE NUMBER (10) Y ID which joins any rows of text in this table to the Text Table for this Module
LANG_CODE VARCHAR2 (4) Y
PARAGRAPH_CODE VARCHAR2 (4) Y
SUB_PARACODE NUMBER (5) Y
LINE_NO NUMBER (5) Y
LAST_UPDATED_BY NUMBER (15) Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
CREATION_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
TEXT VARCHAR2 (70)

[top of page]

APPS.PS_TEXT_TBL_VL references the following:

APPS
SYNONYM - PS_TEXT_TBL_TL
APPS.PS_TEXT_TBL_VL is referenced by following:

APPS
TRIGGER - GMA_PS_TEXT_TBL_T1
TRIGGER - GMA_PS_TEXT_TBL_T2
TRIGGER - GMA_PS_TEXT_TBL_T3
SYNONYM - PS_TEXT_TBL

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