eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

Oracle eBusiness Suite Technical Reference

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

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

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

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

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

eTRM - GME Tables and Views

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

Table: GME_BATCH_GROUPS_ASSOCIATION

Description:	Batch to Group Association

Comments

Batch to Group Association

Indexes

Index	Type	Tablespace	Column
GME_BATCH_GROUPS_ASSOC_PK	UNIQUE	APPS_TS_TX_IDX	BATCH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
GROUP_ID	NUMBER	(10)	Y	ID of the group to which a specific batch is associated
BATCH_ID	NUMBER	(10)	Y	ID of the batch that is associated to a specific group
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

Index	Type	Tablespace	Column
GME_BATCH_GROUPS_B_PK	UNIQUE	APPS_TS_TX_IDX	GROUP_ID
GME_BATCH_GROUPS_B_U1	UNIQUE	APPS_TS_TX_IDX	GROUP_NAME ORGANIZATION_ID

Index	Type	Tablespace	Column
GME_BATCH_HEADER_PK	UNIQUE	APPS_TS_TX_IDX	BATCH_ID
GME_BATCH_HEADER_N1	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID BATCH_NO BATCH_STATUS
GME_BATCH_HEADER_N2	NONUNIQUE	APPS_TS_TX_IDX	SYS_NC00088$
GME_BATCH_HEADER_U1	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID BATCH_NO BATCH_TYPE

Name	Datatype	Length	Mandatory	Comments
ENHANCED_PI_IND	VARCHAR2	(1)		If enhanced PI framework is used in the recipe, N for migrated batches
WIP_WHSE_CODE	VARCHAR2	(4)		Warehouse used to cost production activity
ORGANIZATION_ID	NUMBER			To identify the organization (Plant /Lab)
LABORATORY_IND	NUMBER			0 = Production Batch 1 = Lab Batch
MOVE_ORDER_HEADER_ID	NUMBER			Identifier to the Invisible Move Order,NULL for migrated batches
TERMINATE_REASON_ID	NUMBER			Identifier to Terminate Reason name , NULL for migrated batches
MIGRATED_BATCH_IND	VARCHAR2	(1)		Indicates whether the batch was migrated; Y means migrated, N or NULL means not migrated
ENFORCE_STEP_DEPENDENCY	NUMBER	(5)		This denotes step dependency is enforced for the batch. We will be inherit this from the FM_ROUT_HDR. 0,NULL means No and 1 means Yes.
TERMINATED_IND	NUMBER	(1)		Indicates if the batch has been terminated. 1 - Yes 0 - No
BATCH_ID	NUMBER	(10)	Y	Unique Identifier for batches to FPO or batch
PLANT_CODE	VARCHAR2	(4)		Obsolete in R12. New column is organization_id
BATCH_NO	VARCHAR2	(32)	Y	Batch or FPO number.
BATCH_TYPE	NUMBER	(5)	Y	Differentiates between Firm Planned Order(10) and batches (0).
PROD_ID	NUMBER	(10)		Reserved for future use.
PROD_SEQUENCE	NUMBER	(5)	Y	Reserved for future use. Batch sequence in campaign/prod order.
RECIPE_VALIDITY_RULE_ID	NUMBER	(10)		Surrogate key to the Recipe Validity Rule Id the batch or FPO was based on.
FORMULA_ID	NUMBER	(10)		FK to formula on which batch or FPO is based. This value can be derived from the Recipe_Validity_Rule_Id
ROUTING_ID	NUMBER	(10)		FK to routing used.
PLAN_START_DATE	DATE		Y	Planned release date/time for batch.
ACTUAL_START_DATE	DATE			Actual start date/time for batch. Entered at the time the batch is released, can be entered by the user or current system date.
DUE_DATE	DATE		Y	Required batch completion date/time, national.
PLAN_CMPLT_DATE	DATE		Y	Planned batch completion date/time. POC data is used to derive this date, the length of time required for each step is added to the planned start date/time. This is updated at th
ACTUAL_CMPLT_DATE	DATE			Actual completion date. This is updated at the time the batch is certified. The user can enter the date or the current system date is used.
BATCH_STATUS	NUMBER	(5)	Y	Batch or FPO status. -3 = Converted FPO, -1 = Cancelled, 1 = Pending, 2 = WIP, 3 = Completed, 4 = Closed
PRIORITY_VALUE	NUMBER		Y	Not currently used.
PRIORITY_CODE	VARCHAR2	(4)		Not currently used.
PRINT_COUNT	NUMBER	(5)		Number of times batch ticket was printed.
FMCONTROL_CLASS	VARCHAR2	(8)		Not currently used.
BATCH_CLOSE_DATE	DATE			Date/time the batch was closed.
POC_IND	VARCHAR2	(1)		Indicates if POC data is associated with the batch.Y = Yes, POC is associated, POC must be activated before POC data is stored for the batch; i.e. steps created.N = No, not associa
ACTUAL_COST_IND	VARCHAR2	(1)		Indicates if actual costing has been run against the batch data. Y = Actual costing has been run using data from this batch. If a batch is reopened, and the actual_cost_ind = Y, a
UPDATE_INVENTORY_IND	VARCHAR2	(1)		This indicates if a Lab batch updates inventory with inventory consumed. This indicator can only be set to Y if the organization is a Lab organization.Y = Updates inventory with c
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	(15)	Y	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
DELETE_MARK	NUMBER	(5)		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
PARENTLINE_ID	NUMBER	(10)		For phantom batches. Surrogate key to the batch ingredient line for which this phantom batch produces product.
FPO_ID	NUMBER	(10)		Contains the FPO Id the batch was created for.
ATTRIBUTE1	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE2	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE3	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE4	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE5	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE6	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE7	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE8	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE9	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE10	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE11	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE12	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE13	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE14	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE15	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE16	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE17	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE18	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE19	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE20	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE21	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE22	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE23	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE24	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE25	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE26	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE27	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE28	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE29	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE30	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Cateogry
AUTOMATIC_STEP_CALCULATION	NUMBER	(5)	Y	The value is derived from the routing and stored here for efficiency and the value could change at the routing level.Y= YesN= No.
GL_POSTED_IND	NUMBER	(5)	Y	Indicates, if the batch has been posted to GL, 0 - Batch has not been posted, 1 - Batch has been posted
FIRMED_IND	NUMBER	(5)		To indicate that the batch should not be re-scheduled by WPS; Values 0 = No, 1 = Yes.
FINITE_SCHEDULED_IND	NUMBER	(5)		To indicate whether the batch has been scheduled by WPS or not; Values 0 = No, 1 =Yes. Updated by WPS interface
ORDER_PRIORITY	NUMBER	(10)		To indicate that the batch has a higher/lower priority; No validations; User enters the /value.
ATTRIBUTE31	VARCHAR2	(240)		This column holds the flexfield data
ATTRIBUTE32	VARCHAR2	(240)		This column holds the flexfield data
ATTRIBUTE33	VARCHAR2	(240)		This column holds the flexfield data
ATTRIBUTE34	VARCHAR2	(240)		This column holds the flexfield data
ATTRIBUTE35	VARCHAR2	(240)		This column holds the flexfield data
ATTRIBUTE36	VARCHAR2	(240)		This column holds the flexfield data
ATTRIBUTE37	VARCHAR2	(240)		This column holds the flexfield data
ATTRIBUTE38	VARCHAR2	(240)		This column holds the flexfield data
ATTRIBUTE39	VARCHAR2	(240)		This column holds the flexfield data
ATTRIBUTE40	VARCHAR2	(240)		This column holds the flexfield data

Name	Datatype	Length	Mandatory	Comments
EVENT_ID	NUMBER	(10)	Y	Event id used to identify the production event.
BATCH_ID	NUMBER	(10)	Y	Batch Identifier FK to the GME_BATCH_HEADER table.
ORIG_STATUS	NUMBER	(10)	Y	Batch status prior to the event represented by the event_id.
NEW_STATUS	NUMBER	(10)	Y	Batch status after the event.
ORIG_WIP_WHSE	VARCHAR2	(4)		Original WIP warehouse prior to the event rep-resented by event_id.
NEW_WIP_WHSE	VARCHAR2	(4)		New WIP warehouse after the event.
GL_POSTED_IND	NUMBER	(10)	Y	0 = Event has not been posted to GL, 1 = Event has been posted to GL.
LAST_UPDATED_BY	NUMBER	(15)	Y	Standard WHO Columns
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Columns
CREATED_BY	NUMBER	(15)	Y	Standard WHO Columns
CREATION_DATE	DATE		Y	Standard WHO Columns
LAST_UPDATE_DATE	DATE		Y	Standard WHO Columns
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent who column
PROGRAM_ID	NUMBER	(15)		Concurrent who column
REQUEST_ID	NUMBER	(15)		Concurrent who column
PROGRAM_UPDATE_DATE	DATE			Concurrent who column

Name	Datatype	Length	Mandatory
PLANT_CODE	VARCHAR2	(4)	Y
OLD_BATCH_ID	NUMBER		Y
OLD_BATCH_NO	VARCHAR2	(32)	Y
ORGANIZATION_ID	NUMBER		Y
NEW_BATCH_ID	NUMBER		Y
NEW_BATCH_NO	VARCHAR2	(32)	Y
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

Index	Type	Tablespace	Column
GME_BATCH_STEPS_PK	UNIQUE	APPS_TS_TX_IDX	BATCHSTEP_ID
GME_BATCH_STEPS_U1	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID BATCHSTEP_NO

Name	Datatype	Length	Mandatory	Comments
TERMINATED_IND	NUMBER	(1)		Indicates if the step has been terminated. 1 - Yes 0 - No
STEP_QTY_UM	VARCHAR2	(3)	Y	Step Quantity UOM
MASS_REF_UM	VARCHAR2	(3)		UOM in MASS
VOLUME_REF_UM	VARCHAR2	(3)		UOM in VOLUME
MAX_STEP_CAPACITY_UM	VARCHAR2	(3)		Capacity UOM
STEP_QTY_UOM	VARCHAR2	(4)		Obsolete in R12. New column is step_qty_um.
MAX_STEP_CAPACITY_UOM	VARCHAR2	(4)		Obsolete in R12. New column is max_step_capacity_um.
MASS_REF_UOM	VARCHAR2	(4)		Obsolete in R12. New column is mass_ref_um.
VOLUME_REF_UOM	VARCHAR2	(4)		Obsolete in R12. New column is volume_ref_um.
ATTRIBUTE16	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE17	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE18	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE19	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE20	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE21	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE22	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE23	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE24	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE25	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE26	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE27	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE28	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE29	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE30	VARCHAR2	(240)		Descriptive Flexfield
QUALITY_STATUS	NUMBER	(1)		This column is showing the requirement of sample for the step
MINIMUM_TRANSFER_QTY	NUMBER			Minimum amount of material that must be produced at a given production operation and resource, that will be transferred to the next operation and resource before it can begin proce
BATCH_ID	NUMBER	(10)	Y	Batch Identifier FK to the GME_BATCH_HEADER table.
BATCHSTEP_ID	NUMBER	(15)	Y	Unique Identifier for Batch Steps
ROUTINGSTEP_ID	NUMBER	(10)		Reference to standard routing step for variance calculations. FK to FM_ROUT_DTL.
BATCHSTEP_NO	NUMBER	(10)	Y	Batch step Identifier. Batch routing step number, defaults from fm_rout_dtl.
OPRN_ID	NUMBER	(10)	Y	FK to the operation GMD_OPERATIONS, defaults from fm_rout_dtl. Stored for all batch steps. If a routing step is added to batch not originally defined to the recipe, the oprn_id is
PLAN_STEP_QTY	NUMBER		Y	If scaling and auto-calculate step qty = On and formula is scalable, first scale materials next recalculate step qty using step material association if exist make GMD_ calculation
ACTUAL_STEP_QTY	NUMBER			The actual is not stored when the step is created. Either a Null or zero is stored; will store the value stored today.
BACKFLUSH_QTY	NUMBER			not currently used
PLAN_START_DATE	DATE			Based on batch start date and any DEP
ACTUAL_START_DATE	DATE			Updated at the time the step is released; defaults to system date but can be overridden; validates actual_start_date is batch start date; and after any step it is dependent on, pro
DUE_DATE	DATE		Y	no validations, Required step completion date/time.
PLAN_CMPLT_DATE	DATE			Based on the step planned start date and plus the time required for step to complete
ACTUAL_CMPLT_DATE	DATE			Updated at the time the system is certified. Defaults to system date/time and can be overridden.
STEP_CLOSE_DATE	DATE			Updated at the time the step is closed; Defaults to system date/time and can be overridden.
STEP_STATUS	NUMBER	(5)	Y	0 = New, 1 = Pending, 2 = WIP, 3 = Completed, 4 = Closed, 5 = Cancelled
PRIORITY_CODE	VARCHAR2	(4)		Not currently used
PRIORITY_VALUE	NUMBER			Not currently used
DELETE_MARK	NUMBER	(5)	Y	Standard: 0 = Active record (default)1 = Marked for (logical) deletion.
STEPRELEASE_TYPE	NUMBER	(5)	Y	1= Manual, 2 = Automatic
MAX_STEP_CAPACITY	NUMBER			Calculate from GME_RESOURCES_DTL
PLAN_CHARGES	NUMBER			Calculated at the time the step is created.
ACTUAL_CHARGES	NUMBER			Can change when a step is scaled
PLAN_MASS_QTY	NUMBER			Planned Step quantity converted to the mass reference uom.
PLAN_VOLUME_QTY	NUMBER			Planned Step quantity converted to the volume reference uom
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
ACTUAL_MASS_QTY	NUMBER			Actual Step quantity converted to the mass reference uom.
ACTUAL_VOLUME_QTY	NUMBER			Actual Step quantity converted to the volume reference uom
LAST_UPDATE_DATE	DATE		Y	Standard WHO Columns
CREATION_DATE	DATE		Y	Standard WHO Columns
CREATED_BY	NUMBER	(15)	Y	Standard WHO Columns
LAST_UPDATED_BY	NUMBER	(15)	Y	Standard WHO Columns
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Columns
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Category
ATTRIBUTE1	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE2	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE3	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE4	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE5	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE6	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE7	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE8	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE9	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE10	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE11	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE12	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE13	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE14	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE15	VARCHAR2	(240)		Descriptive Flexfield

Index	Type	Tablespace	Column
GME_BATCH_STEP_ACTIVITIES_PK	UNIQUE	APPS_TS_TX_IDX	BATCHSTEP_ACTIVITY_ID
GME_BATCH_STEP_ACTIVITIES_I1	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID BATCHSTEP_ID ACTIVITY

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER		Y	The foreign key to the batch header
BATCHSTEP_ID	NUMBER		Y	The foreign key to the batch step
RESOURCES	VARCHAR2	(16)	Y	The resources that contained the capacity constraint causing the charge to be generated
ACTIVITY_SEQUENCE_NUMBER	NUMBER			Used by APS to identitythe Charge,populated by GMP
CHARGE_NUMBER	NUMBER			The sequential number assigned to each row of the charge for a Batch step
CHARGE_QUANTITY	NUMBER			The quantity of material to be processed by the charge.The quantity will be based in the Batch Step quantity UOM
PLAN_START_DATE	DATE			The planned start date of the charge
PLAN_CMPLT_DATE	DATE			The planned completion date of the charge
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_LOGIN	NUMBER	(15)		Standard who column
LAST_UPDATE_DATE	DATE		Y	Standard who column

Index	Type	Tablespace	Column
GME_BATCH_STEP_ITEMS_PK	UNIQUE	APPS_TS_TX_IDX	MATERIAL_DETAIL_ID
GME_BATCH_STEP_ITEMS_N1	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID BATCHSTEP_ID MATERIAL_DETAIL_ID

Name	Datatype	Length	Mandatory	Comments
MAXIMUM_DELAY	NUMBER			The maximum delay in hours after the MTQ point
MINIMUM_DELAY	NUMBER			The minimum delay in hours after the MTQ point
MINIMUM_TRANSFER_QTY	NUMBER			The quantity based in the same UOM of the product that is being associated to the routing step
MATERIAL_DETAIL_ID	NUMBER	(10)	Y	Surrogate key to the batch line.
BATCH_ID	NUMBER	(10)	Y	Surrogate key to the batch
BATCHSTEP_ID	NUMBER	(15)	Y	Key to the batch step.
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 Columns
LAST_UPDATE_DATE	DATE		Y	Standard WHO Columns
LAST_UPDATED_BY	NUMBER	(15)	Y	Standard WHO Columns
CREATION_DATE	DATE		Y	Standard WHO Columns
CREATED_BY	NUMBER	(15)	Y	Standard WHO Columns

Index	Type	Tablespace	Column
GME_BATCH_STEP_RESOURCES_PK	UNIQUE	APPS_TS_TX_IDX	BATCHSTEP_RESOURCE_ID
GME_BATCH_STEP_RESOURCES_N1	NONUNIQUE	APPS_TS_TX_IDX	BATCHSTEP_ACTIVITY_ID RESOURCES
GME_BATCH_STEP_RESOURCES_N2	NONUNIQUE	APPS_TS_TX_IDX	BATCHSTEP_ID

Index	Type	Tablespace	Column
GME_BATCH_STEP_RSRC_SUMMARY_PK	UNIQUE	APPS_TS_TX_IDX	BATCHSTEP_RESOURCE_ID
GME_BATCH_STEP_RSRC_SUMMARY_N1	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID PLAN_START_DATE PLAN_CMPLT_DATE

Index	Type	Tablespace	Column
GME_BATCH_STEP_TRANSFERS_PK	UNIQUE	APPS_TS_TX_IDX	WIP_TRANS_ID
GME_BATCH_STEP_TRANSFERS_N1	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID BATCHSTEP_NO LINE_TYPE

Name	Datatype	Length	Mandatory	Comments
TRANS_QTY_UM	VARCHAR2	(3)
WIP_TRANS_ID	NUMBER	(10)	Y	Key to the WIP transaction.
BATCH_ID	NUMBER	(10)	Y	Batch Identifier FK to the GME_BATCH_HEADER table.
BATCHSTEP_NO	NUMBER	(5)	Y	Number of the batch step.
TRANSFER_STEP_NO	NUMBER	(5)	Y	Transfer step.
LINE_TYPE	NUMBER	(5)	Y	-1 = Ingredient1 = Product; The product on Line 1 is the primary product.2 = Byproduct
TRANS_QTY	NUMBER		Y	WIP transaction quantity.
TRANS_UM	VARCHAR2	(4)	Y	Unit of measure in which the trans_qty is expressed.
TRANS_DATE	DATE		Y	Date of the WIP transaction.
LAST_UPDATED_BY	NUMBER	(15)	Y	Standard WHO Columns
LAST_UPDATE_DATE	DATE		Y	Standard WHO Columns
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Columns
CREATION_DATE	DATE		Y	Standard WHO Columns
CREATED_BY	NUMBER	(15)	Y	Standard WHO Columns
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
ATTRIBUTE2	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE3	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE4	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE5	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE6	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE7	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE8	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE9	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE10	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE11	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE12	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE13	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE14	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE15	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE16	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE17	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE18	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE19	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE20	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE21	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE22	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE23	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE24	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE25	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE26	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE27	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE28	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE29	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE30	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Category

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER		Y
TRANS_ID	NUMBER		Y
MIGRATED_IND	NUMBER	(3)		This column indicates if a transaction has been migrated to R12 or not

Name	Datatype	Length	Comments
EVENT_NAME	VARCHAR2	(240)	Name of Event
EVENT_KEY	VARCHAR2	(30)	Identify key of the event
TASK	VARCHAR2	(32)	Task
ACTION_CODE	VARCHAR2	(10)	Action of the event
USER_KEY_LABEL	VARCHAR2	(240)	User defined key label of the event
USER_KEY_VALUE	VARCHAR2	(240)	User defined key value of the event
POST_OP_API	VARCHAR2	(4)	API to be executed after ERES
PARENT_EVENT	VARCHAR2	(30)	Related event of ERES
PARENT_EVENT_KEY	VARCHAR2	(30)	Related event Key
PARENT_ERECORD_ID	NUMBER	(32)	Related event ERES record key
ERECORD_ID	NUMBER	(32)	Task ERES record key
XML_GENERATION_API	VARCHAR2	(300)

Name	Datatype	Length	Comments
ORGANIZATION_ID	NUMBER		The organization for which the parameters are defined.
PENDING_MOVE_ORDER_IND	NUMBER	(1)	To indicate if Pending Move Orders exist 0 No move order exist 1 Move Order Exist
PENDING_RESERVATIONS_IND	NUMBER	(1)	To indicate Pending Reservations exist. 0 No reservations exist 1 reservations Exist
ONHAND_QTY	NUMBER		On hand quantity
ATT	NUMBER		Available to Transact
ATR	NUMBER		Available to Reserve
MATERIAL_DETAIL_ID	NUMBER		Identifier to Material Details
TRANSACTED_QTY	NUMBER		Quantity already transacted
EXCEPTION_QTY	NUMBER		Quantity not able to transact
BATCH_ID	NUMBER		Identifier to Batch Header

Name	Datatype	Length	Mandatory	Comments
USER_ID	NUMBER	(15)	Y	The user for which the filter criteria are defined
ORGN_CODE	VARCHAR2	(4)		The organization for the which the filter criteria are defined
FROM_DATE	DATE		Y	The date from which the product documents (batches/FPOs) are retrieved (the document start date must be greater or equal to this date)
TO_DATE	DATE			Production documents that start after this date are ignored
RESOURCE_CONSUMED	VARCHAR2	(16)	Y	Resource code to be used in the selection
RESOURCE_IND	NUMBER	(5)	Y	Indicates the types of resources to be selected 0=Primary Resource1=Secondary Resources2=Auxiliary resource3=Primary and Secondary Resource4=Primary and Auxiliary Resource5=Secondary and Auxiliary Resource6=All Resources
DOCUMENT_NO	VARCHAR2	(32)		Document number to be selected
DOCUMENT_TYPE	NUMBER	(5)	Y	Indicate the document type to be selected1=Batch2=FPO3=Batch and FPO
PRODUCT_YIELDED	VARCHAR2	(32)	Y	Product Number to be used in the selection
INGREDIENT_CONSUMED	VARCHAR2	(32)	Y	Ingredient number to be used in the selection
BATCH_STATUS	NUMBER	(5)	Y	Indicate the statuses of the batch to be selected0=Pending1=WIP2=Certified3=Pending and WIP4=Pending and Certiied5=WIP and Certified6=All statuses
FROM_DOC_NO	VARCHAR2	(32)		Filter criteria
ORGANIZATION_ID	NUMBER			To identify the organization (Plant /Lab)
TO_DOC_NO	VARCHAR2	(32)		Filter criteria

Index	Type	Tablespace	Column
GME_MATERIAL_DETAILS_PK	UNIQUE	APPS_TS_TX_IDX	MATERIAL_DETAIL_ID
GME_MATERIAL_DETAILS_U1	UNIQUE	APPS_TS_TX_IDX	BATCH_ID LINE_NO LINE_TYPE
GME_MATERIAL_DETAILS_N1	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID INVENTORY_ITEM_ID LINE_TYPE BATCH_ID
GME_MATERIAL_DETAILS_N2	NONUNIQUE	APPS_TS_TX_IDX	PHANTOM_ID

Oracle eBusiness Suite Technical Reference

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

eTRM - GME Tables and Views

Table: GME_BATCH_GROUPS_ASSOCIATION

Comments

Indexes

Columns

Table: GME_BATCH_GROUPS_B

Comments

Indexes

Columns

Table: GME_BATCH_GROUPS_TL

Comments

Indexes

Columns

Table: GME_BATCH_HEADER

Primary Key: GME_BATCH_HEADER_PK

Comments

Indexes

Columns

Table: GME_BATCH_HEADER_MIG

Comments

***** Warning: Oracle Internal Use Only *****

Indexes

Columns

Table: GME_BATCH_HISTORY

Primary Key: GME_BATCH_HISTORY_PK

Comments

Indexes

Columns

Table: GME_BATCH_MAPPING_MIG

Comments

***** Warning: Oracle Internal Use Only *****

Indexes

Columns

Table: GME_BATCH_SALES_ORDERS

Primary Key: GME_BATCH_SALES_ORDERS_PK

Comments

Indexes

Columns

Table: GME_BATCH_STEPS

Primary Key: GME_BATCH_STEPS_PK

Primary Key: GME_BATCH_STEPS_U1

Comments

Indexes

Columns

Table: GME_BATCH_STEPS_MIG

Comments

***** Warning: Oracle Internal Use Only *****

Indexes

Columns

Table: GME_BATCH_STEP_ACTIVITIES

Primary Key: GME_BATCH_STEP_ACTIVITIES_PK

Comments

Indexes

Columns

Table: GME_BATCH_STEP_ACTIV_MIG

Comments

***** Warning: Oracle Internal Use Only *****

Indexes

Columns

Table: GME_BATCH_STEP_CHARGES

Comments

Indexes

Columns

Table: GME_BATCH_STEP_CHARGES_MIG

Comments

***** Warning: Oracle Internal Use Only *****

Indexes

Columns

Table: GME_BATCH_STEP_DEPENDENCIES

Primary Key: GME_BATCH_STEP_DEPENDENCIES_PK

Comments

Indexes

Columns

Table: GME_BATCH_STEP_DEP_MIG

Comments

***** Warning: Oracle Internal Use Only *****

Indexes

Columns

* Warning: Oracle Internal Use Only *

* Warning: Oracle Internal Use Only *

* Warning: Oracle Internal Use Only *

* Warning: Oracle Internal Use Only *

* Warning: Oracle Internal Use Only *

* Warning: Oracle Internal Use Only *

* Warning: Oracle Internal Use Only *

* Warning: Oracle Internal Use Only *

* Warning: Oracle Internal Use Only *

* Warning: Oracle Internal Use Only *

* Warning: Oracle Internal Use Only *

Name	Datatype	Length	Mandatory
ITEM_ID	NUMBER	(10)
ITEM_UM	VARCHAR2	(4)
MATERIAL_DETAIL_ID	NUMBER	(10)	Y
BATCH_ID	NUMBER	(10)	Y
FORMULALINE_ID	NUMBER	(10)
LINE_NO	NUMBER	(5)	Y
LINE_TYPE	NUMBER	(5)	Y
PLAN_QTY	NUMBER		Y
ITEM_UM2	VARCHAR2	(4)
ACTUAL_QTY	NUMBER		Y
RELEASE_TYPE	NUMBER	(5)	Y
SCRAP_FACTOR	NUMBER		Y
SCALE_TYPE	NUMBER	(5)	Y
PHANTOM_TYPE	NUMBER	(5)	Y
COST_ALLOC	NUMBER
ALLOC_IND	NUMBER	(5)
COST	NUMBER
TEXT_CODE	NUMBER	(10)
PHANTOM_ID	NUMBER	(10)
ROUNDING_DIRECTION	NUMBER	(5)
CREATION_DATE	DATE		Y
CREATED_BY	NUMBER	(15)	Y
LAST_UPDATE_DATE	DATE		Y
LAST_UPDATED_BY	NUMBER	(15)	Y
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)
DTL_UM	VARCHAR2	(3)
DISPENSE_IND	VARCHAR2	(1)
ORGANIZATION_ID	NUMBER
INVENTORY_ITEM_ID	NUMBER
SUBINVENTORY	VARCHAR2	(10)
LOCATOR_ID	NUMBER
REVISION	VARCHAR2	(3)
BACKORDERED_QTY	NUMBER
ORIGINAL_PRIMARY_QTY	NUMBER
MATERIAL_REQUIREMENT_DATE	DATE
PHANTOM_LINE_ID	NUMBER
MOVE_ORDER_LINE_ID	NUMBER
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)
LAST_UPDATE_LOGIN	NUMBER	(15)
SCALE_ROUNDING_VARIANCE	NUMBER
SCALE_MULTIPLE	NUMBER
CONTRIBUTE_YIELD_IND	VARCHAR2	(1)
CONTRIBUTE_STEP_QTY_IND	VARCHAR2	(1)
WIP_PLAN_QTY	NUMBER
ORIGINAL_QTY	NUMBER
BY_PRODUCT_TYPE	VARCHAR2	(1)

Name	Datatype	Length	Mandatory	Comments
DISPENSE_ID	NUMBER	(15)	Y	Surrogate to GMO_MATERIAL_DISPENSES
SUBINVENTORY_CODE	VARCHAR2	(10)		Subinventory where material is dispensed
LOCATOR_ID	NUMBER			Locator where material is dispensed
LOT_NUMBER	VARCHAR2	(80)		Lot dispensed
DISPENSE_UOM	VARCHAR2	(4)	Y	Dispense UOM
DISPENSED_QTY	NUMBER	(15)	Y	Quantity dispenseed in dispense UOM
SECONDARY_DISPENSED_QTY	NUMBER	(15)		Quantity dispensed in secondary UOM
REVISION	VARCHAR2	(3)		Item Revision for the dispensed record

Name	Datatype	Length	Mandatory	Comments
TABLE_NAME	VARCHAR2	(80)	Y	Migrated Table Name
MIGRATED_IND	VARCHAR2	(1)	Y	Indicator of whether table was migrated, values are Y and N
LAST_UPDATE_DATE	DATE		Y	Migration run date
COMMENT1	VARCHAR2	(240)		For future use
COMMENT2	VARCHAR2	(240)		For future use
COMMENT3	VARCHAR2	(240)		For future use
COMMENT4	VARCHAR2	(240)		For future use
COMMENT5	VARCHAR2	(240)		For future use

Index	Type	Tablespace	Column
GME_MTO_RULES_PK	UNIQUE	APPS_TS_TX_IDX	RULE_ID
GME_MTO_RULES_U1	UNIQUE	APPS_TS_TX_IDX	RULE_NAME

Name	Datatype	Length	Mandatory	Comments
RULE_ID	NUMBER		Y	Rule ID. Unique Identifier
RULE_NAME	VARCHAR2	(30)	Y	Rule Name
BATCH_TYPE_TO_CREATE	NUMBER			Batch Type: Batch or Firm Plan Order
BATCH_CREATION_USER	NUMBER			Batch Creation User to populate Batch Creation user
CHECK_AVAILABILITY	VARCHAR2	(1)		This flag is used to verify the inventory present or not
AUTO_LOT_GENERATION	VARCHAR2	(1)		This flag is whether auto generate pending product lots for the batch
FIRMED_IND	VARCHAR2	(1)		Firmed Indicator
COPY_ATTACHMENTS	VARCHAR2	(1)		This flag is to determine whether to copy attachments from Sales Order Line to Batch Header or not
SALES_ORDER_ATTACHMENT	NUMBER			Sales Order Line Attachment Category
BATCH_ATTACHMENT	NUMBER			Batch Header Attachment Category
CREATION_DATE	DATE		Y	Standard Who Column
CREATED_BY	NUMBER		Y	Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who Column
PROGRAM_ID	NUMBER			Standard Who Column
LAST_UPDATED_BY	NUMBER		Y	Standard Who Column
LAST_UPDATE_DATE	DATE		Y	Standard Who Column

Index	Type	Tablespace	Column
GME_MTO_RULE_ASSIGNMENTS_PK	UNIQUE	APPS_TS_TX_IDX	RULE_ASSIGN_ID
GME_MTO_RULE_ASSIGNMENTS_U1	UNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID SITE_USE_ID INVENTORY_ITEM_ID ITEM_TYPE

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER		Y	Organization ID
RULE_ASSIGN_ID	NUMBER		Y	unique Identifier
RULE_ID	NUMBER		Y	Rule ID
CUSTOMER_ID	NUMBER			Customer ID
SITE_USE_ID	NUMBER			Customer Site ID
INVENTORY_ITEM_ID	NUMBER			Item ID
ITEM_TYPE	VARCHAR2	(30)		Item Type
CREATION_DATE	DATE		Y	Standard Who Column
CREATED_BY	NUMBER		Y	Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who Column
PROGRAM_ID	NUMBER			Standard Who Column
LAST_UPDATED_BY	NUMBER		Y	Standard Who Column
LAST_UPDATE_DATE	DATE		Y	Standard Who Column

Name	Datatype	Length	Mandatory	Comments
IB_FACTOR_IND	NUMBER	(1)		IB Factor Calculation indicator 1 - Total Products0 - Single Material
ORGANIZATION_ID	NUMBER		Y	The organization for which the parameters are defined.
AUTO_CONSUME_SUPPLY_SUB_ONLY	NUMBER	(1)	Y	For Automatic consumption ingredients. Indicates whether consumption can be done only from Supply subinv. Or any subinv.1=Auto Consume from Supply Subinv. only.0 = Can consume from other subinv.
SUPPLY_SUBINVENTORY	VARCHAR2	(10)		Default Supply subinv for ingredients.
SUPPLY_LOCATOR_ID	NUMBER			Default Supply locator for the default Supply subinv.
YIELD_SUBINVENTORY	VARCHAR2	(10)		Default Yield subinv. For products, byproducts
YIELD_LOCATOR_ID	NUMBER			Default Yield locator for the default Yield subinv.
DELETE_MATERIAL_IND	NUMBER	(1)	Y	Indicates the stages of a production batch which will allow material deletion.1 = Pending, 2 = Pending and Wip
VALIDATE_PLAN_DATES_IND	NUMBER	(1)	Y	Determines whether to validate the planned start/completion dates against the validity rule.1 = Validate both planned dates. 2 = Validate planned start date only.
DISPLAY_UNCONSUMED_MATERIAL	NUMBER	(1)	Y	Determines whether unconsumed ingredients,unyielded products will be displayed during release/complete of batch.1 = Display unconsumed,unyielded items.0 = Don't display unconsumed,unyielded items.
STEP_CONTROLS_BATCH_STS_IND	NUMBER	(1)	Y	Determines if batch status is set per as the step status. 1= Batch status is appropriately based on step status. Eg. If batch is pending and a step is released then the batch status is also changed to wip.0= Batch status is independent of step status and is not controlled by it. Eg. User will not be able to release step unless batch is released.
BACKFLUSH_RSRC_USG_IND	NUMBER	(1)	Y	Indicates whether resource usage will be backflushed during incremental backflushing.1=Resource usage will be backflushed.0=Resource usage will not be backflushed
DEF_ACTUAL_RSRC_USG_IND	NUMBER	(1)	Y	Determines whether the planned resource usage is copied to the actual resource usage.1=Actual usage will be defaulted to the Planned usage.0=Actual usage will not default to the Planned usage.
CALC_INTERIM_RSRC_USG_IND	NUMBER	(1)	Y	Indicates whether the actual step quantity and resource usages will be calculated when the step is in WIP stage.1=Resource usage will be calculated.0=Resource usage will not be calculated.
ALLOW_QTY_BELOW_MIN_IND	NUMBER	(1)	Y	Determines if the user can enter a resource process quantity that is less than the resource capacity.1=Allow process quantity less than resource capacity.0=Don't allow.
DISPLAY_NON_WORK_DAYS_IND	NUMBER	(1)	Y	Determines whether the non working days will be indicated in the production scheduler.1=Indicate non working days.0=Don't indicate non working days.
CHECK_SHORTAGES_IND	NUMBER	(1)	Y	Determines whether the inventory shortage check will be performed during the batch create process.1=Check shortages during batch creation.0=Don't check for shortages
COPY_FORMULA_TEXT_IND	NUMBER	(1)	Y	Indicates whether the formula text will be copied to the batch.1=Formula text will be copied.0=Formula text will not be copied.
COPY_ROUTING_TEXT_IND	NUMBER	(1)	Y	Indicates whether the routing text will be copied to the batch1=Routing text will be copied.0=Routing text will not be copied.
CREATE_HIGH_LEVEL_RESV_IND	NUMBER	(1)	Y	Indicates whether creation of high-level Reservations is allowed during the batch create process.1=Allow creation of High Level Reservations during batch creation.0=No High Level Reservations will be created during batch creation.
CREATE_MOVE_ORDERS_IND	NUMBER	(1)	Y	Indicates whether creation of move orders is allowed during the batch create process. 1=Allow creation of Move Orders during batch creation.0=No Move Orders will be created during batch creation.
RESERVATION_TIMEFENCE	NUMBER	(5)		Used to determine if the material plan dates are within the time fence to create High level Reservations during batch create.
MOVE_ORDER_TIMEFENCE	NUMBER	(5)		Used to determine if the material plan dates are within the time fence to create Move Orders during batch create
BATCH_DOC_NUMBERING	NUMBER	(1)		Indicates the Document Ordering type for Production batches.1=Manual.2=Automatic
BATCH_NO_LAST_ASSIGNED	NUMBER	(10)		Indicates the last batch number that was assigned using Automatic numbering.
FPO_DOC_NUMBERING	NUMBER	(1)		Indicates the Document Ordering type for Firm Planned Orders (FPO). 1=Manual.2=Automatic.
FPO_NO_LAST_ASSIGNED	NUMBER	(10)		Indicates the last FPO number that was assigned using Automatic numbering.
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
RULE_BASED_RESV_HORIZON	NUMBER			This is the horizon used for rule based reservations
INGR_SUB_DATE	NUMBER	(1)		Indicates which date to use for ingredient substitution.
SUBINV_LOC_IND	NUMBER	(1)		Indicates whether to show only subinventories/locators with onhand
GROUP_DOC_NUMBERING	NUMBER	(1)		This is the column for group numbering type
GROUP_LAST_ASSIGNED	NUMBER	(10)		This is the column for the last assigned group number for automatic group numbering
FIXED_PROCESS_LOSS_IND	NUMBER	(1)		The column specifies if fixed process loss will be applied manually or to set of batches when creating a batch

Index	Type	Tablespace	Column
GME_PENDING_PRODUCT_LOTS_U1	UNIQUE	APPS_TS_TX_IDX	PENDING_PRODUCT_LOT_ID
GME_PENDING_PRODUCT_LOTS_N1	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID MATERIAL_DETAIL_ID

Index	Type	Tablespace	Column
GME_PROCESS_PARAMETERS_PK	UNIQUE	APPS_TS_TX_IDX	PROCESS_PARAM_ID
GME_PROCESS_PARAMETERS_N1	NONUNIQUE	APPS_TS_TX_IDX	BATCHSTEP_RESOURCE_ID