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

TABLE - GMO.GMO_AREA_OPERATOR_MAPPING
TABLE - GMO.GMO_BATCH_PROGRESSION
TABLE - GMO.GMO_BATCH_STEP_LOCK_DETAILS
TABLE - GMO.GMO_BATCH_STEP_LOCK_HIST
TABLE - GMO.GMO_CBR_XML
TABLE - GMO.GMO_DEVICE_REQUESTS_T
TABLE - GMO.GMO_DEVICE_RESPONSES_T
TABLE - GMO.GMO_DISPENSE_AREA_B
TABLE - GMO.GMO_DISPENSE_AREA_TL
TABLE - GMO.GMO_DISPENSE_BOOTH_B
TABLE - GMO.GMO_DISPENSE_BOOTH_TL
TABLE - GMO.GMO_DISPENSE_CONFIG
TABLE - GMO.GMO_DISPENSE_CONFIG_INST
TABLE - GMO.GMO_DISPENSE_STORAGE_SUBINVS
TABLE - GMO.GMO_DISPENSING_PLANNING
TABLE - GMO.GMO_DOCUMENT_NUMBERS
TABLE - GMO.GMO_INSTR_APPR_DEFN
TABLE - GMO.GMO_INSTR_APPR_DEFN_T
TABLE - GMO.GMO_INSTR_APPR_INSTANCE
TABLE - GMO.GMO_INSTR_ATTRIBUTES_T
TABLE - GMO.GMO_INSTR_DEFN_B
TABLE - GMO.GMO_INSTR_DEFN_T
TABLE - GMO.GMO_INSTR_DEFN_TL
TABLE - GMO.GMO_INSTR_EREC_INSTANCE
TABLE - GMO.GMO_INSTR_EREC_INSTANCE_T
TABLE - GMO.GMO_INSTR_INSTANCE_B
TABLE - GMO.GMO_INSTR_INSTANCE_T
TABLE - GMO.GMO_INSTR_INSTANCE_TL
TABLE - GMO.GMO_INSTR_SET_DEFN_B
TABLE - GMO.GMO_INSTR_SET_DEFN_T
TABLE - GMO.GMO_INSTR_SET_DEFN_TL
TABLE - GMO.GMO_INSTR_SET_INSTANCE_B
TABLE - GMO.GMO_INSTR_SET_INSTANCE_T
TABLE - GMO.GMO_INSTR_SET_INSTANCE_TL
TABLE - GMO.GMO_INSTR_TASK_ATTR_COLS_B
TABLE - GMO.GMO_INSTR_TASK_ATTR_COLS_TL
TABLE - GMO.GMO_INSTR_TASK_DEFN_B
TABLE - GMO.GMO_INSTR_TASK_DEFN_TL
TABLE - GMO.GMO_INSTR_TASK_INSTANCE
TABLE - GMO.GMO_INSTR_TASK_INSTANCE_T
TABLE - GMO.GMO_KIOSK_DISP_PREFERENCES
TABLE - GMO.GMO_KIOSK_LOV_T
TABLE - GMO.GMO_KIOSK_OWB_PREFERENCES
TABLE - GMO.GMO_KIOSK_PREFERENCES
TABLE - GMO.GMO_KIOSK_REV_DISP_PREFERENCES
TABLE - GMO.GMO_LABEL_CONTEXT_T
TABLE - GMO.GMO_LABEL_HISTORY
TABLE - GMO.GMO_LABEL_HISTORY_DTL
TABLE - GMO.GMO_MATERIAL_DISPENSES
TABLE - GMO.GMO_MATERIAL_UNDISPENSES
TABLE - GMO.GMO_NONCONFORMANCE
TABLE - GMO.GMO_OPERATOR_CERT_TRANS
TABLE - GMO.GMO_OPERATOR_TRANS_DETAIL
TABLE - GMO.GMO_OPERT_CERT_DETAIL
TABLE - GMO.GMO_OPERT_CERT_GTMP
TABLE - GMO.GMO_OPERT_CERT_HEADER
VIEW - APPS.GMO_BATCH_STEPS_V
VIEW - APPS.GMO_INSTR_DEFN_VL
VIEW - APPS.GMO_INSTR_INSTANCE_VL
VIEW - APPS.GMO_INSTR_SET_DEFN_VL
VIEW - APPS.GMO_INSTR_SET_INSTANCE_VL
VIEW - APPS.GMO_INSTR_TASK_ATTR_COLS_VL
VIEW - APPS.GMO_INSTR_TASK_DEFN_VL

Table: GMO_AREA_OPERATOR_MAPPING

Description: Dispense Area Operator Mapping Table
Primary Key: GMO_AREA_OPERATOR_MAPPING_PK
  1. DISPENSE_AREA_ID
  2. OPER_ID
Comments

Dispense Area Operator Mapping Table

Indexes
Index Type Tablespace Column
GMO_AREA_OPERATOR_MAPPING_PK UNIQUE APPS_TS_TX_IDX DISPENSE_AREA_ID
OPER_ID
Columns
Name Datatype Length Mandatory Comments
DISPENSE_AREA_ID NUMBER
Y Dispense Area ID
OPER_ID NUMBER
Y HR person ID
NUMBER_OF_TASKS_PER_DAY NUMBER

Max No of tasks operator can handle in a day
CREATED_BY NUMBER
Y Row who Columns
CREATION_DATE DATE
Y Row who Columns
LAST_UPDATED_BY NUMBER
Y Row who Columns
LAST_UPDATE_DATE DATE
Y Row who Columns
LAST_UPDATE_LOGIN NUMBER

Row who Columns

[top of page]

GMO.GMO_AREA_OPERATOR_MAPPING does not reference any database object

GMO.GMO_AREA_OPERATOR_MAPPING is referenced by following:

GMO
VIEW - GMO_AREA_OPERATOR_MAPPING#

[top of page]

Table: GMO_BATCH_PROGRESSION

Description: This table maintains Batch Progression
Primary Key: GMO_BATCH_PROGRESSION_PK
  1. PROGRESSION_ID
Comments

This table maintains Batch Progression

Indexes
Index Type Tablespace Column
GMO_BATCH_PROGRESSION_U1 UNIQUE APPS_TS_TX_IDX PROGRESSION_ID
SYS_IL0000400887C00027$$ UNIQUE APPS_TS_TX_DATA
GMO_BATCH_PROGRESSION_N1 NONUNIQUE APPS_TS_TX_IDX BATCH_ID
Columns
Name Datatype Length Mandatory Comments
PROGRESSION_ID NUMBER (22) Y Unique Identifier
BATCH_ID NUMBER (22)
Batch ID
BATCHSTEP_ID NUMBER (22)
Batch Step Identifier
MATERIAL_LINE_ID NUMBER (22)
Material Line Identifier
BATCHACTIVITY_ID NUMBER (22)
Batch Activity Identifier
BATCHRSRC_ID NUMBER (22)
Batch Activity Resource Identifier
DISPENSE_ID NUMBER (22)
Dispense Identifier
SAMPLE_ID NUMBER (22)
Sample Identifier
DEVIATION_ID NUMBER (22)
Deviation Identifier
TRANSACTION_ID NUMBER (22)
Transaction Identifier
PARENT_NODE VARCHAR2 (200)
Parent Node under which current XML or text output need to be placed
PARENT_KEY_NODE VARCHAR2 (200)
Parent XML record Identifier Node
PARENT_KEY_VAL VARCHAR2 (200)
Parent Node Identifier Value
CURR_NODE_KEY VARCHAR2 (200)
Current XML record Identifier Node
CURR_KEY_VAL VARCHAR2 (200)
Current Node Identifier Value
USER_KEY_LABEL_PROD VARCHAR2 (10)
User Key Label Message Token Owner Product Code
USER_KEY_LABEL_TOKEN VARCHAR2 (200)
User Key Label Message Token
USER_KEY_LABEL VARCHAR2 (2000)
User key Label from eRecord
USER_KEY_VALUE VARCHAR2 (2000)
User Visual record Identifier
EXTERNAL_EVENT VARCHAR2 (2000)
External Event Flag It will contain value of Y or N
INCLUDE_IN_CBR VARCHAR2 (100)
This identifies CLOB Column value is XML or Text
EVENT VARCHAR2 (200)
Event occured in batch progression
EVENT_KEY VARCHAR2 (200)
ERES event Key
EVENT_DATE DATE

Event Date
PLANED_START_DATE DATE

Planed Start Date of the Event
ERECORD_ID NUMBER (22)
Evidence Store Document ID
XML_EREC CLOB (4000)
CLOB this will hold XML or Text Output
STATUS VARCHAR2 (200)
Evnet Status
INCLUDED_IN_CBR VARCHAR2 (1)
This contains value Y or N. N means not included. Y means included
XML_MAP_CODE VARCHAR2 (40)
If XML need to be transformed further
COMPARE_XML VARCHAR2 (1)
This column holds whether to compare XML or Not

[top of page]

GMO.GMO_BATCH_PROGRESSION does not reference any database object

GMO.GMO_BATCH_PROGRESSION is referenced by following:

GMO
VIEW - GMO_BATCH_PROGRESSION#

[top of page]

Table: GMO_BATCH_STEP_LOCK_DETAILS

Description: GMO Batch Step Lock Details
Primary Key: GMO_BATCH_STEP_LOCK_DETAILS_PK
  1. BATCHSTEP_ID
Comments

GMO Batch Step Lock Details

Indexes
Index Type Tablespace Column
GMO_BATCH_STEP_LOCK_DETAILS_U1 UNIQUE APPS_TS_TX_IDX BATCHSTEP_ID
GMO_BATCH_STEP_LOCK_DETAILS_N1 NONUNIQUE APPS_TS_TX_IDX BATCH_ID
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER
Y Batch Id
BATCHSTEP_ID NUMBER
Y Batchstep Id
LOCK_REQUESTER NUMBER
Y Lock requester User Id
LOCK_DATE DATE
Y Lock request date
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

[top of page]

GMO.GMO_BATCH_STEP_LOCK_DETAILS does not reference any database object

GMO.GMO_BATCH_STEP_LOCK_DETAILS is referenced by following:

GMO
VIEW - GMO_BATCH_STEP_LOCK_DETAILS#

[top of page]

Table: GMO_BATCH_STEP_LOCK_HIST

Description: GMO Batch Step Lock History
Primary Key: GMO_BATCH_STEP_LOCK_HIST_PK
  1. LOCK_HIST_SEQ
Comments

GMO Batch Step Lock History

Indexes
Index Type Tablespace Column
GMO_BATCH_STEP_LOCK_HIST_U1 UNIQUE APPS_TS_TX_IDX LOCK_HIST_SEQ
Columns
Name Datatype Length Mandatory Comments
LOCK_HIST_SEQ NUMBER
Y Sequence for Lock History
BATCH_ID NUMBER
Y Batch Id
BATCHSTEP_ID NUMBER
Y Batchstep Id
LOCK_REQUESTER NUMBER
Y Lock requester User Id
LOCK_DATE DATE
Y Lock request date
UNLOCK_REQUESTER NUMBER
Y Unlock requester User Id
UNLOCK_DATE DATE
Y Unlock request date
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

[top of page]

GMO.GMO_BATCH_STEP_LOCK_HIST does not reference any database object

GMO.GMO_BATCH_STEP_LOCK_HIST is referenced by following:

GMO
VIEW - GMO_BATCH_STEP_LOCK_HIST#

[top of page]

Table: GMO_CBR_XML

Description: This table is to store consolidated Control Batch Record XML
Primary Key: GMO_CBR_XML_PK
  1. BATCH_ID
Comments

This table is to store consolidated Control Batch Record XML

Indexes
Index Type Tablespace Column
GMO_CBR_XML_U1 UNIQUE APPS_TS_TX_IDX BATCH_ID
SYS_IL0000400894C00002$$ UNIQUE APPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER
Y Batch ID
CBR_XML CLOB (4000)
Generated Control Batch XML

[top of page]

GMO.GMO_CBR_XML does not reference any database object

GMO.GMO_CBR_XML is referenced by following:

GMO
VIEW - GMO_CBR_XML#

[top of page]

Table: GMO_DEVICE_REQUESTS_T

Description: GMO Device Request
Primary Key: GMO_DEVICE_REQUESTS_T_PK
  1. REQUEST_ID
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
GMO_DEVICE_REQUESTS_T_U1 UNIQUE APPS_TS_INTERFACE REQUEST_ID
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER
Y Request Id
DEVICE_ID NUMBER
Y Device Id
REQUESTER NUMBER
Y Requester User Id
RESPONSE_STATUS VARCHAR2 (300)
Response Status
DEVICE_STATUS VARCHAR2 (300)
Device Status
REQUEST_DATE DATE

Request Date
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

[top of page]

GMO.GMO_DEVICE_REQUESTS_T does not reference any database object

GMO.GMO_DEVICE_REQUESTS_T is referenced by following:

GMO
VIEW - GMO_DEVICE_REQUESTS_T#

[top of page]

Table: GMO_DEVICE_RESPONSES_T

Description: GMO Device Response
Primary Key: GMO_DEVICE_RESPONSES_T_PK
  1. RESPONSE_ID
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
GMO_DEVICE_RESPONSES_T_U1 UNIQUE APPS_TS_INTERFACE RESPONSE_ID
GMO_DEVICE_RESPONSES_T_N1 NONUNIQUE APPS_TS_INTERFACE REQUEST_ID
Columns
Name Datatype Length Mandatory Comments
RESPONSE_ID NUMBER
Y Response Id
REQUEST_ID NUMBER
Y Request Id
RESP_COMP_CODE VARCHAR2 (300)
Response Component Code
RESP_COMP_CODE_VALUE VARCHAR2 (4000)
Response Value
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

[top of page]

GMO.GMO_DEVICE_RESPONSES_T does not reference any database object

GMO.GMO_DEVICE_RESPONSES_T is referenced by following:

GMO
VIEW - GMO_DEVICE_RESPONSES_T#

[top of page]

Table: GMO_DISPENSE_AREA_B

Description: Dispense Area Table
Primary Key: GMO_DISPENSE_AREA_B_PK
  1. DISPENSE_AREA_ID
Comments

Dispense Area Table

Indexes
Index Type Tablespace Column
GMO_DISPENSE_AREA_B_PK UNIQUE APPS_TS_TX_IDX DISPENSE_AREA_ID
Columns
Name Datatype Length Mandatory Comments
DISPENSE_AREA_ID NUMBER
Y Dispense Area ID
ORGANIZATION_ID NUMBER

Organization ID
DISPENSE_AREA_NAME VARCHAR2 (30)
Name for Dispense Area
DEFAULT_AREA_IND VARCHAR2 (1)
Identifies default dispense area for the organization
SUBINVENTORY_CODE VARCHAR2 (10)
Subinventory associated to the dispense area
NUMBER_OF_TASKS_PER_DAY NUMBER

No of Tasks which can be handled by the dispense area
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

[top of page]

GMO.GMO_DISPENSE_AREA_B does not reference any database object

GMO.GMO_DISPENSE_AREA_B is referenced by following:

GMO
VIEW - GMO_DISPENSE_AREA_B#

[top of page]

Table: GMO_DISPENSE_AREA_TL

Description:
Comments

Dispense Area Translation Table

Indexes
Index Type Tablespace Column
GMO_DISPENSE_AREA_TL_PK UNIQUE APPS_TS_TX_IDX DISPENSE_AREA_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
DISPENSE_AREA_ID NUMBER
Y Dispense Area Unique Identifier
DISPENSE_AREA_DESC VARCHAR2 (240) Y Dispense Area Discription
SOURCE_LANG VARCHAR2 (4) Y Source Language
LANGUAGE VARCHAR2 (4) Y Current row in Language
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]

GMO.GMO_DISPENSE_AREA_TL does not reference any database object

GMO.GMO_DISPENSE_AREA_TL is referenced by following:

GMO
VIEW - GMO_DISPENSE_AREA_TL#

[top of page]

Table: GMO_DISPENSE_BOOTH_B

Description:
Comments

This table stores dispese booth definition

Indexes
Index Type Tablespace Column
GMO_DISPENSE_BOOTH_B_PK UNIQUE APPS_TS_TX_IDX DISPENSE_BOOTH_ID
Columns
Name Datatype Length Mandatory Comments
DISPENSE_BOOTH_ID NUMBER
Y Unique Identifier
DISPENSE_BOOTH_NAME VARCHAR2 (30) Y Booth Name
DISPENSE_AREA_ID NUMBER
Y Dispense Area ID
LOCATOR_ID NUMBER
Y Locator is mapping for Dispense Booth to Inventory Locator to collect and manage Qulity
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]

GMO.GMO_DISPENSE_BOOTH_B does not reference any database object

GMO.GMO_DISPENSE_BOOTH_B is referenced by following:

GMO
VIEW - GMO_DISPENSE_BOOTH_B#

[top of page]

Table: GMO_DISPENSE_BOOTH_TL

Description:
Comments

Dispese booth translation table

Indexes
Index Type Tablespace Column
GMO_DISPENSE_BOOTH_TL_PK UNIQUE APPS_TS_TX_IDX DISPENSE_BOOTH_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
DISPENSE_BOOTH_ID NUMBER
Y Dispense Booth ID
DISPENSE_BOOTH_DESC VARCHAR2 (240) Y Description
SOURCE_LANG VARCHAR2 (4) Y Source Language
LANGUAGE VARCHAR2 (4) Y Current row in Language
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]

GMO.GMO_DISPENSE_BOOTH_TL does not reference any database object

GMO.GMO_DISPENSE_BOOTH_TL is referenced by following:

GMO
VIEW - GMO_DISPENSE_BOOTH_TL#

[top of page]

Table: GMO_DISPENSE_CONFIG

Description: GMO Dispense Configuration
Primary Key: GMO_DISPENSE_CONFIG_PK
  1. CONFIG_ID
Comments

GMO Dispense Configuration

Indexes
Index Type Tablespace Column
GMO_DISPENSE_CONFIG_PK UNIQUE APPS_TS_TX_IDX CONFIG_ID
GMO_DISPENSE_CONFIG_U1 UNIQUE APPS_TS_TX_IDX INVENTORY_ITEM_ID
ORGANIZATION_ID
RECIPE_ID
START_DATE
END_DATE
Columns
Name Datatype Length Mandatory Comments
CONFIG_ID NUMBER (15) Y Configuration ID
INVENTORY_ITEM_ID NUMBER (10) Y Inventory Item ID
ORGANIZATION_ID NUMBER

Organization ID
RECIPE_ID NUMBER

Recipe ID
DISPENSE_UOM VARCHAR2 (4) Y Dispense UOM
TOLERANCE_TYPE VARCHAR2 (7)
Tolerance Type
HIGH_TOLERANCE NUMBER (15)
Higher Tolerance
LOW_TOLERANCE NUMBER (15)
Low Tolerance
DISPENSE_REQUIRED_FLAG VARCHAR2 (1)
Dispense Required Flag
ERECORD_ID NUMBER

E-record ID
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
END_DATE DATE

'This is the start date when the dispense setup configuration becomes active.'
START_DATE DATE
Y 'This is the end date when the dispense setup configuration becomes inactive.'
SECURECODE_REQUIRED_FLAG VARCHAR2 (1)
This flag is to identify Security Tag information Required or Not
DISPENSE_EXPIRATION_FENCE VARCHAR2 (10)
Dispense Expiration Time Fence
LEAD_TIME VARCHAR2 (10)
Leadtime Required to Dispense the Item (Not Used)

[top of page]

GMO.GMO_DISPENSE_CONFIG does not reference any database object

GMO.GMO_DISPENSE_CONFIG is referenced by following:

GMO
VIEW - GMO_DISPENSE_CONFIG#

[top of page]

Table: GMO_DISPENSE_CONFIG_INST

Description: Holds the instantiated dispense setup configurations.
Primary Key: GMO_DISPENSE_CONFIG_INST_PK
  1. INSTANCE_ID
Comments

Holds the instantiated dispense setup configurations.

Indexes
Index Type Tablespace Column
GMO_DISPENSE_CONFIG_INST_PK UNIQUE APPS_TS_TX_IDX INSTANCE_ID
GMO_DISPENSE_CONFIG_INST_U1 UNIQUE APPS_TS_TX_IDX ENTITY_NAME
ENTITY_KEY
GMO_DISPENSE_CONFIG_INST_N1 NONUNIQUE APPS_TS_TX_IDX DISPENSE_CONFIG_ID
Columns
Name Datatype Length Mandatory Comments
INSTANCE_ID NUMBER (15) Y The primary key of the table.
DISPENSE_CONFIG_ID NUMBER (15) Y The config ID of the Dispense Setup that has been instantiated.
ENTITY_NAME VARCHAR2 (500) Y The entity name.
ENTITY_KEY VARCHAR2 (4000) Y The entity key.
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

[top of page]

GMO.GMO_DISPENSE_CONFIG_INST does not reference any database object

GMO.GMO_DISPENSE_CONFIG_INST is referenced by following:

GMO
VIEW - GMO_DISPENSE_CONFIG_INST#

[top of page]

Table: GMO_DISPENSE_STORAGE_SUBINVS

Description:
Comments

Stores Inbound and Outbound storage location

Indexes
Index Type Tablespace Column
GMO_DISP_STORAGE_SUBINVS_PK UNIQUE APPS_TS_TX_IDX DISPENSE_AREA_ID
SUBINVENTORY_CODE
Columns
Name Datatype Length Mandatory Comments
DISPENSE_AREA_ID NUMBER
Y Dispense Area ID
STORAGE_TYPE VARCHAR2 (4) Y This identifies whenther this sub inventory is inbound or outbound
SUBINVENTORY_CODE VARCHAR2 (10) Y Sub Inventory Code
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]

GMO.GMO_DISPENSE_STORAGE_SUBINVS does not reference any database object

GMO.GMO_DISPENSE_STORAGE_SUBINVS is referenced by following:

GMO
VIEW - GMO_DISPENSE_STORAGE_SUBINVS#

[top of page]

Table: GMO_DISPENSING_PLANNING

Description: Dispense Planning Table
Primary Key: GMO_DISPENSING_PLANNING_PK
  1. PLANNED_TASK_ID
Comments

Dispense Planning Table

Indexes
Index Type Tablespace Column
GMO_DISPENSING_PLANNING_PK UNIQUE APPS_TS_TX_IDX PLANNED_TASK_ID
GMO_DISPENSING_PLANNING_N1 NONUNIQUE APPS_TS_TX_IDX DISPENSE_ID
DISPENSED_DATE
Columns
Name Datatype Length Mandatory Comments
PLANNED_TASK_ID NUMBER
Y Primary key storing the planned id
RESERVATION_ID NUMBER
Y Reservation id
DISPENSE_AREA_ID NUMBER

Id for Dispense Area
PRIORITY VARCHAR2 (15)
Priority : High,Medium,Low
PLANNED_DISPENSING_DATE DATE

Planned Dispense Date
STATUS VARCHAR2 (15)
Status : PLANNED,DISPENSD,REVRDISP
DISPENSE_ID NUMBER

Dispensing id if dispensed
DISPENSED_DATE DATE

Dispensed_date if dispensed
OPER_ID NUMBER

Person 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_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column

[top of page]

GMO.GMO_DISPENSING_PLANNING does not reference any database object

GMO.GMO_DISPENSING_PLANNING is referenced by following:

GMO
VIEW - GMO_DISPENSING_PLANNING#

[top of page]

Table: GMO_DOCUMENT_NUMBERS

Description: Holds generated document numbers for a given organization and transaction type
Primary Key: GMO_DOCUMENT_NUMBERS_PK
  1. DOC_ID
Comments

Holds generated document numbers for a given organization and transaction type

Indexes
Index Type Tablespace Column
GMO_DOCUMENT_NUMBERS_PK UNIQUE APPS_TS_TX_IDX DOC_ID
GMO_DOCUMENT_NUMBERS_U1 UNIQUE APPS_TS_TX_IDX ORGANIZATION_ID
TRANSACTION_TYPE
GMO_DOCUMENT_NUMBERS_N2 NONUNIQUE APPS_TS_TX_IDX TRANSACTION_TYPE
Columns
Name Datatype Length Mandatory Comments
DOC_ID NUMBER
Y The primary key of the table
ORGANIZATION_ID NUMBER

The organization ID
TRANSACTION_TYPE VARCHAR2 (240) Y The transaction type
DOC_TYPE VARCHAR2 (1) Y The document number type
DOC_PREFIX VARCHAR2 (10)
The document number prefix
DOC_SUFFIX VARCHAR2 (10)
The document number suffix
DOC_SEPARATOR VARCHAR2 (1)
The separator symbol
DOC_START NUMBER

The starting sequence of the document number
DOC_LENGTH NUMBER

The maximum allowed length of the sequence
DOC_INCREMENT NUMBER

The value by which sequence is to be incremented each time.
DOC_CURRENTVAL NUMBER

The current value of the sequence
DOC_ZERO_PAD VARCHAR2 (1)
Whether zero padding is required
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

[top of page]

GMO.GMO_DOCUMENT_NUMBERS does not reference any database object

GMO.GMO_DOCUMENT_NUMBERS is referenced by following:

GMO
VIEW - GMO_DOCUMENT_NUMBERS#

[top of page]

Table: GMO_INSTR_APPR_DEFN

Description: Instruction Approvers Functional Temp Table
Primary Key: GMO_INSTR_APPR_DEFN_PK
  1. INSTRUCTION_ID
  2. APPROVER_SEQ
Comments

Instruction Approvers

Indexes
Index Type Tablespace Column
GMO_INSTR_APPR_DEFN_PK UNIQUE APPS_TS_TX_IDX INSTRUCTION_ID
APPROVER_SEQ
Columns
Name Datatype Length Mandatory Comments
INSTRUCTION_ID NUMBER
Y Foriegn Key from GMO_INSTR_DEFN_B Instruction Id
APPROVER_SEQ NUMBER
Y Unique Approver Seq to identify instruction approver
ROLE_NAME VARCHAR2 (300)
Approver Role Name , can be null
ROLE_COUNT NUMBER
Y Number of Signatures for given role
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]

GMO.GMO_INSTR_APPR_DEFN does not reference any database object

GMO.GMO_INSTR_APPR_DEFN is referenced by following:

GMO
VIEW - GMO_INSTR_APPR_DEFN#

[top of page]

Table: GMO_INSTR_APPR_DEFN_T

Description:
Primary Key: GMO_INSTR_APPR_DEFN_T_PK
  1. INSTRUCTION_PROCESS_ID
  2. INSTRUCTION_ID
  3. APPROVER_SEQ
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
GMO_INSTR_APPR_DEFN_T_PK UNIQUE APPS_TS_INTERFACE INSTRUCTION_PROCESS_ID
INSTRUCTION_ID
APPROVER_SEQ
Columns
Name Datatype Length Mandatory Comments
INSTRUCTION_ID NUMBER
Y Instruction Id, part of primary key
INSTRUCTION_PROCESS_ID NUMBER
Y Instruction Process Id for particular user session, part of PK
APPROVER_SEQ NUMBER
Y Approver Sequence part of PK
ROLE_NAME VARCHAR2 (300)
Approver Role Name , can be null
ROLE_COUNT NUMBER
Y Number of Signatures for given role
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]

GMO.GMO_INSTR_APPR_DEFN_T does not reference any database object

GMO.GMO_INSTR_APPR_DEFN_T is referenced by following:

GMO
VIEW - GMO_INSTR_APPR_DEFN_T#

[top of page]

Table: GMO_INSTR_APPR_INSTANCE

Description: Instruction Approvers Table
Primary Key: GMO_INSTR_APPR_INSTANCE_PK
  1. INSTRUCTION_ID
  2. APPROVER_SEQ
Comments

Instruction Approvers Table

Indexes
Index Type Tablespace Column
GMO_INSTR_APPR_INSTANCE_PK UNIQUE APPS_TS_TX_IDX INSTRUCTION_ID
APPROVER_SEQ
Columns
Name Datatype Length Mandatory Comments
INSTRUCTION_ID NUMBER
Y Instruction Id, referenced from GMO_INSTR_INSTANCE_B, part of primary key
APPROVER_SEQ NUMBER
Y Approver Sequence, part of primary key
ROLE_NAME VARCHAR2 (300)
WF Internal Role Name of approvers
ROLE_COUNT NUMBER
Y Number of Signatures for given Role Name
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]

GMO.GMO_INSTR_APPR_INSTANCE does not reference any database object

GMO.GMO_INSTR_APPR_INSTANCE is referenced by following:

GMO
VIEW - GMO_INSTR_APPR_INSTANCE#

[top of page]

Table: GMO_INSTR_ATTRIBUTES_T

Description: Functional temporary table to store session related attributes
Primary Key: GMO_INSTR_ATTRIBUTES_T_PK
  1. INSTRUCTION_PROCESS_ID
  2. ATTRIBUTE_SEQ
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
GMO_INSTR_ATTRIBUTES_T_PK UNIQUE APPS_TS_INTERFACE INSTRUCTION_PROCESS_ID
ATTRIBUTE_SEQ
Columns
Name Datatype Length Mandatory Comments
INSTRUCTION_PROCESS_ID NUMBER
Y Instruction Process id for particular user session, part of PK
ATTRIBUTE_SEQ NUMBER
Y Unique attribute sequence for all attributes created, part of PK
ATTRIBUTE_NAME VARCHAR2 (100) Y Attribute name
ATTRIBUTE_VALUE VARCHAR2 (500)
Attribute value
ENTITY_NAME VARCHAR2 (200)
Entity Name
ENTITY_KEY VARCHAR2 (500)
Entity Key
ENTITY_DISPLAY_NAME VARCHAR2 (500)
Entity Display Name
INSTRUCTION_TYPE VARCHAR2 (500)
Instruction Type
ATTRIBUTE_TYPE VARCHAR2 (100)
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]

GMO.GMO_INSTR_ATTRIBUTES_T does not reference any database object

GMO.GMO_INSTR_ATTRIBUTES_T is referenced by following:

GMO
VIEW - GMO_INSTR_ATTRIBUTES_T#

[top of page]

Table: GMO_INSTR_DEFN_B

Description: Instruction definition time base table
Primary Key: GMO_INSTR_DEFN_B_PK
  1. INSTRUCTION_ID
Comments

Instruction definition time base table

Indexes
Index Type Tablespace Column
GMO_INSTR_DEFN_B_PK UNIQUE APPS_TS_TX_IDX INSTRUCTION_ID
GMO_INSTR_DEFN_B_N1 NONUNIQUE APPS_TS_TX_IDX INSTRUCTION_SET_ID
Columns
Name Datatype Length Mandatory Comments
INSTRUCTION_ID NUMBER
Y Instruction Id, primary key
INSTRUCTION_SET_ID NUMBER
Y Instruction Set Id, Foriegn Key, referenced from GMO_INSTR_SET_DEFN_B
INSTR_SEQ NUMBER
Y Instruction sequence for ordering instructions in definition and runtime
TASK_ID NUMBER

Task Id referencing GMO_INSTR_TASK_DEFN_B, for task associated with instruction
TASK_ATTRIBUTE_ID VARCHAR2 (4000)
Task Attribute Id for task associated
TASK_ATTRIBUTE VARCHAR2 (4000)
Task Attribute for task associated
INSTR_ACKN_TYPE VARCHAR2 (40)
Instruction Ackn Type Code reference from GMO_INSTR_ACKN_TYPES lookup
INSTR_NUMBER VARCHAR2 (200)
Instruction Number displayed to user
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]

GMO.GMO_INSTR_DEFN_B does not reference any database object

GMO.GMO_INSTR_DEFN_B is referenced by following:

GMO
VIEW - GMO_INSTR_DEFN_B#

[top of page]

Table: GMO_INSTR_DEFN_T

Description: Functional Temporary table for Instructions at Definition Time
Primary Key: GMO_INSTR_DEFN_T_PK
  1. INSTRUCTION_PROCESS_ID
  2. INSTRUCTION_ID
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
GMO_INSTR_DEFN_T_PK UNIQUE APPS_TS_INTERFACE INSTRUCTION_PROCESS_ID
INSTRUCTION_ID
GMO_INSTR_DEFN_T_N1 NONUNIQUE APPS_TS_INTERFACE INSTRUCTION_SET_ID
Columns
Name Datatype Length Mandatory Comments
INSTRUCTION_PROCESS_ID NUMBER
Y The instruction process id for one particular user session, part of PK
INSTRUCTION_ID NUMBER
Y The instruction id , Primary Key
INSTRUCTION_SET_ID NUMBER
Y Instruction Set Id, Foriegn Key, referenced from GMO_INSTR_SET_DEFN_B
INSTR_SEQ NUMBER
Y Instruction sequence for ordering instructions in definition and runtime
TASK_ID NUMBER

Task Id referencing GMO_INSTR_TASK_DEFN_B, for task associated with instruction
TASK_ATTRIBUTE_ID VARCHAR2 (4000)
Task Attribute Id for task associated
TASK_ATTRIBUTE VARCHAR2 (4000)
Task Attribute for task associated
INSTR_ACKN_TYPE VARCHAR2 (40)
Instruction Ackn Type Code reference from GMO_INSTR_ACKN_TYPES lookup
INSTR_NUMBER VARCHAR2 (200)
Instruction Number displayed to user
INSTRUCTION_TEXT VARCHAR2 (4000)
Instruction Text
TASK_LABEL VARCHAR2 (30)
Task Label
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]

GMO.GMO_INSTR_DEFN_T does not reference any database object

GMO.GMO_INSTR_DEFN_T is referenced by following:

GMO
VIEW - GMO_INSTR_DEFN_T#

[top of page]

Table: GMO_INSTR_DEFN_TL

Description: Instruction Definitioin Transalatable Table
Primary Key: GMO_INSTR_DEFN_TL_PK
  1. INSTRUCTION_ID
  2. LANGUAGE
Comments

Instruction Definitioin Transalatable Table

Indexes
Index Type Tablespace Column
GMO_INSTR_DEFN_TL_PK UNIQUE APPS_TS_TX_IDX INSTRUCTION_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
INSTRUCTION_ID NUMBER
Y Instruction Id, Primary Key
INSTRUCTION_TEXT VARCHAR2 (4000)
Instruction Text
TASK_LABEL VARCHAR2 (30)
Task Label
SOURCE_LANG VARCHAR2 (4)
Source Language
LANGUAGE VARCHAR2 (4) Y Translated Language
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]

GMO.GMO_INSTR_DEFN_TL does not reference any database object

GMO.GMO_INSTR_DEFN_TL is referenced by following:

GMO
VIEW - GMO_INSTR_DEFN_TL#

[top of page]

Table: GMO_INSTR_EREC_INSTANCE

Description: The table stores the relationship between Instruction Id and Instruction E-record Id
Primary Key: GMO_INSTR_EREC_INSTANCE_PK
  1. INSTRUCTION_ID
  2. INSTR_EREC_SEQ
Comments

The table stores the relationship between Instruction Id and Instruction E-record Id

Indexes
Index Type Tablespace Column
GMO_INSTR_EREC_INSTANCE_PK UNIQUE APPS_TS_TX_IDX INSTRUCTION_ID
INSTR_EREC_SEQ
Columns
Name Datatype Length Mandatory Comments
INSTRUCTION_ID NUMBER
Y Instruction id referenced from GMO_INSTR_INSTANCE_B , part of primary key
INSTR_EREC_SEQ NUMBER
Y Instruction e-record sequence
INSTR_EREC_ID NUMBER
Y Instructioon e-record id
TASK_EREC_ID NUMBER

Task E-record Id, if any task is associated
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]

GMO.GMO_INSTR_EREC_INSTANCE does not reference any database object

GMO.GMO_INSTR_EREC_INSTANCE is referenced by following:

GMO
VIEW - GMO_INSTR_EREC_INSTANCE#

[top of page]

Table: GMO_INSTR_EREC_INSTANCE_T

Description: The table stores the relationship between Instruction Id and Instruction E-record Id
Primary Key: GMO_INSTR_EREC_INSTANCE_T_PK
  1. INSTRUCTION_PROCESS_ID
  2. INSTRUCTION_ID
  3. INSTR_EREC_SEQ
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
GMO_INSTR_EREC_INSTANCE_T_PK UNIQUE APPS_TS_INTERFACE INSTRUCTION_PROCESS_ID
INSTRUCTION_ID
INSTR_EREC_SEQ
Columns
Name Datatype Length Mandatory Comments
INSTRUCTION_ID NUMBER
Y Instruction id referenced from GMO_INSTR_INSTANCE_B , part of primary key
INSTRUCTION_PROCESS_ID NUMBER
Y
INSTR_EREC_SEQ NUMBER
Y Instruction e-record sequence
INSTR_EREC_ID NUMBER
Y Instructioon e-record id
TASK_EREC_ID NUMBER

Task E-record Id, if any task is associated
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]

GMO.GMO_INSTR_EREC_INSTANCE_T does not reference any database object

GMO.GMO_INSTR_EREC_INSTANCE_T is referenced by following:

GMO
VIEW - GMO_INSTR_EREC_INSTANCE_T#

[top of page]

Table: GMO_INSTR_INSTANCE_B

Description: Instruction base table at execution time
Primary Key: GMO_INSTR_INSTANCE_B_PK
  1. INSTRUCTION_ID
Comments

Instruction base table at execution time

Indexes
Index Type Tablespace Column
GMO_INSTR_INSTANCE_B_PK UNIQUE APPS_TS_TX_IDX INSTRUCTION_ID
GMO_INSTR_INSTANCE_B_N1 NONUNIQUE APPS_TS_TX_IDX INSTRUCTION_SET_ID
Columns
Name Datatype Length Mandatory Comments
INSTRUCTION_ID NUMBER
Y Instruction Id, Primary Key
INSTRUCTION_SET_ID NUMBER
Y Instruction Set Id, Foriegn Key from GMO_INSTR_SET_INSTANCE_B
INSTR_SEQ NUMBER
Y Instruction Seq, used to order the instructions in runtime region
INSTR_NUMBER VARCHAR2 (200)
Instruction Number, user entered number to display to the user
INSTR_STATUS VARCHAR2 (40) Y Instruction Status - PENDING, WORKING, DONE, COMPLETE, CANCEL
INSTR_ACKN_TYPE VARCHAR2 (40)
Instruction Acknowledgement Type
OPERATOR_ACKN VARCHAR2 (40)
Operator Acknowledgement
TASK_ID NUMBER

Task Id
TASK_ATTRIBUTE VARCHAR2 (500)
Task Attribute
TASK_ATTRIBUTE_ID VARCHAR2 (500)
Task Attribute Id
TASK_ACKN_DATE DATE

Task Acknowledgement Date
TASK_ACKN_STATUS VARCHAR2 (40)
Task Acknowledgement Status
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]

GMO.GMO_INSTR_INSTANCE_B does not reference any database object

GMO.GMO_INSTR_INSTANCE_B is referenced by following:

GMO
VIEW - GMO_INSTR_INSTANCE_B#

[top of page]

Table: GMO_INSTR_INSTANCE_T

Description: Functional Temporary table to store the Operator Response and Task Related details at execution time for an Instruction
Primary Key: GMO_INSTR_INSTANCE_T_PK
  1. INSTRUCTION_PROCESS_ID
  2. INSTRUCTION_ID
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
GMO_INSTR_INSTANCE_T_PK UNIQUE APPS_TS_INTERFACE INSTRUCTION_PROCESS_ID
INSTRUCTION_ID
Columns
Name Datatype Length Mandatory Comments
INSTRUCTION_ID NUMBER
Y Instruction Id
INSTRUCTION_PROCESS_ID NUMBER
Y Instruction Process Id
INSTR_STATUS VARCHAR2 (40) Y Instruction Status
OPERATOR_ACKN VARCHAR2 (40)
Operator Acknowledgement
COMMENTS VARCHAR2 (4000)
Instruction Comments
TASK_LABEL VARCHAR2 (30)
Task Label
TASK_ID NUMBER

Task Id
TASK_ATTRIBUTE VARCHAR2 (500)
Task Attribute
TASK_ATTRIBUTE_ID VARCHAR2 (500)
Task Attribute Id
TASK_ACKN_STATUS VARCHAR2 (40)
Task Ackn Status
TASK_ACKN_DATE DATE

Task Ackn Date
DISABLE_TASK VARCHAR2 (1)
Disable Task Flag for given Instruction Y or N
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]

GMO.GMO_INSTR_INSTANCE_T does not reference any database object

GMO.GMO_INSTR_INSTANCE_T is referenced by following:

GMO
VIEW - GMO_INSTR_INSTANCE_T#

[top of page]

Table: GMO_INSTR_INSTANCE_TL

Description: Instruction Translation Table for instructions at execution time
Primary Key: GMO_INSTR_INSTANCE_TL_PK
  1. INSTRUCTION_ID
  2. LANGUAGE
Comments

Instruction Translation Table for instructions at execution time

Indexes
Index Type Tablespace Column
GMO_INSTR_INSTANCE_TL_PK UNIQUE APPS_TS_TX_IDX INSTRUCTION_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
INSTRUCTION_ID NUMBER
Y Instruction Id, Primary Key
INSTRUCTION_TEXT VARCHAR2 (4000)
Instruction Text
COMMENTS VARCHAR2 (4000)
Instruction Comments
TASK_LABEL VARCHAR2 (30)
Instruction Task Label
SOURCE_LANG VARCHAR2 (4)
Source Language
LANGUAGE VARCHAR2 (4) Y Translated Language
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]

GMO.GMO_INSTR_INSTANCE_TL does not reference any database object

GMO.GMO_INSTR_INSTANCE_TL is referenced by following:

GMO
VIEW - GMO_INSTR_INSTANCE_TL#

[top of page]

Table: GMO_INSTR_SET_DEFN_B

Description: Instruction Set Definition Time Base Table
Primary Key: GMO_INSTR_SET_DEFN_B_PK
  1. INSTRUCTION_SET_ID
Comments

Instruction Set Definition Time Base Table

Indexes
Index Type Tablespace Column
GMO_INSTR_SET_DEFN_B_PK UNIQUE APPS_TS_TX_IDX INSTRUCTION_SET_ID
GMO_INSTR_SET_DEFN_B_N1 NONUNIQUE APPS_TS_TX_IDX ENTITY_NAME
ENTITY_KEY
INSTRUCTION_TYPE
Columns
Name Datatype Length Mandatory Comments
INSTRUCTION_SET_ID NUMBER
Y Instruction Set Id, Primary Key
INSTRUCTION_TYPE VARCHAR2 (40) Y Instruction Set type code eg. PROCESS, DISPENSE, REVERSE_DISPENSE
INSTR_SET_NAME VARCHAR2 (240) Y Instruction Set Name used to identify Instruction Set
ENTITY_NAME VARCHAR2 (200) Y Entity Name for Instruction Set
ENTITY_KEY VARCHAR2 (500) Y Entity Key for Instruction Set
ACKN_STATUS VARCHAR2 (40)
Acknowledgement status used for handshake purposes
ORIG_SOURCE VARCHAR2 (40)
ORIG Source = DEFINITION
ORIG_SOURCE_ID NUMBER

Originial Instruction Set Id, if this instruction set is a copy of existing
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]

GMO.GMO_INSTR_SET_DEFN_B does not reference any database object

GMO.GMO_INSTR_SET_DEFN_B is referenced by following:

GMO
VIEW - GMO_INSTR_SET_DEFN_B#

[top of page]

Table: GMO_INSTR_SET_DEFN_T

Description:
Primary Key: GMO_INSTR_SET_DEFN_T_PK
  1. INSTRUCTION_PROCESS_ID
  2. INSTRUCTION_SET_ID
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
GMO_INSTR_SET_DEFN_T_PK UNIQUE APPS_TS_INTERFACE INSTRUCTION_PROCESS_ID
INSTRUCTION_SET_ID
Columns
Name Datatype Length Mandatory Comments
INSTRUCTION_SET_ID NUMBER
Y The instruction set id , Primary Key
INSTRUCTION_PROCESS_ID NUMBER
Y The instruction process id for one particular user session, part of PK
INSTRUCTION_TYPE VARCHAR2 (40)
Instruction Set type code eg. PROCESS, DISPENSE, REVERSE_DISPENSE
INSTR_SET_NAME VARCHAR2 (240)
Instruction Set Name used to identify Instruction Set
INSTR_SET_DESC VARCHAR2 (500)
Instruction Set Description (MLS)
ENTITY_NAME VARCHAR2 (200)
Entity Name for Instruction Set
ENTITY_KEY VARCHAR2 (500)
Entity Key for Instruction Set
ACKN_STATUS VARCHAR2 (40)
Acknowledgement status used for handshake purposes
ORIG_SOURCE VARCHAR2 (40)
ORIG Source = DEFINITION
ORIG_SOURCE_ID NUMBER

Originial Instruction Set Id, if this instruction set is a copy of existing
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]

GMO.GMO_INSTR_SET_DEFN_T does not reference any database object

GMO.GMO_INSTR_SET_DEFN_T is referenced by following:

GMO
VIEW - GMO_INSTR_SET_DEFN_T#

[top of page]

Table: GMO_INSTR_SET_DEFN_TL

Description: Instruction Set Definition Time Translation Table
Primary Key: GMO_INSTR_SET_DEFN_TL_PK
  1. INSTRUCTION_SET_ID
  2. LANGUAGE
Comments

Instruction Set Definition Time Translation Table

Indexes
Index Type Tablespace Column
GMO_INSTR_SET_DEFN_TL_PK UNIQUE APPS_TS_TX_IDX INSTRUCTION_SET_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
INSTRUCTION_SET_ID NUMBER
Y Instruction Set Id, Primary Key
INSTR_SET_DESC VARCHAR2 (500)
Instruction Set Description (MLS)
SOURCE_LANG VARCHAR2 (4)
Source Language
LANGUAGE VARCHAR2 (4) Y Translated Language
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]

GMO.GMO_INSTR_SET_DEFN_TL does not reference any database object

GMO.GMO_INSTR_SET_DEFN_TL is referenced by following:

GMO
VIEW - GMO_INSTR_SET_DEFN_TL#

[top of page]

Table: GMO_INSTR_SET_INSTANCE_B

Description: Instruction Set base table at execution time
Primary Key: GMO_INSTR_SET_INSTANCE_B_PK
  1. INSTRUCTION_SET_ID
Comments

Instruction Set base table at execution time

Indexes
Index Type Tablespace Column
GMO_INSTR_SET_INSTANCE_B_PK UNIQUE APPS_TS_TX_IDX INSTRUCTION_SET_ID
GMO_INSTR_SET_INSTANCE_B_N1 NONUNIQUE APPS_TS_TX_IDX ENTITY_NAME
ENTITY_KEY
INSTRUCTION_TYPE
Columns
Name Datatype Length Mandatory Comments
INSTRUCTION_SET_ID NUMBER
Y Instruction set id, primary key
INSTRUCTION_TYPE VARCHAR2 (40)
Instruction Type
INSTR_SET_NAME VARCHAR2 (240)
Instruction Set Name used to identify Instruction Set
ENTITY_NAME VARCHAR2 (200)
Entity Name for Instruction Set
ENTITY_KEY VARCHAR2 (500)
Entity Key for Instruction Set
ACKN_STATUS VARCHAR2 (40)
Acknowledgement status used for handshake purposes
INSTR_SET_STATUS VARCHAR2 (40)
Instruction set status used to identify nullified instructions -can be ACTIVE or CANCEL
ORIG_SOURCE VARCHAR2 (40)
ORIG Source = DEFINITION in case of CREATE_INSTANCE_FROM_DEFINITION or INSTANCE in case of CREATE_INSTANCE_FROM_INSTANCE
ORIG_SOURCE_ID NUMBER

Originial Instruction Set Id, if this instruction set is a copy of existing
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]

GMO.GMO_INSTR_SET_INSTANCE_B does not reference any database object

GMO.GMO_INSTR_SET_INSTANCE_B is referenced by following:

GMO
VIEW - GMO_INSTR_SET_INSTANCE_B#

[top of page]

Table: GMO_INSTR_SET_INSTANCE_T

Description: Instruction Set Temp Table to maintain Instruction Set Ackn Status
Primary Key: GMO_INSTR_SET_INSTANCE_T_PK
  1. INSTRUCTION_SET_ID
  2. INSTRUCTION_PROCESS_ID
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
GMO_INSTR_SET_INSTANCE_T_PK UNIQUE APPS_TS_INTERFACE INSTRUCTION_PROCESS_ID
INSTRUCTION_SET_ID
Columns
Name Datatype Length Mandatory Comments
INSTRUCTION_SET_ID NUMBER
Y Instruction Set Id , Primary Key
INSTRUCTION_PROCESS_ID NUMBER
Y Instruction Process Id
ACKN_STATUS VARCHAR2 (40)
Instruction Set Ackn Status
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]

GMO.GMO_INSTR_SET_INSTANCE_T does not reference any database object

GMO.GMO_INSTR_SET_INSTANCE_T is referenced by following:

GMO
VIEW - GMO_INSTR_SET_INSTANCE_T#

[top of page]

Table: GMO_INSTR_SET_INSTANCE_TL

Description:
Primary Key: GMO_INSTR_SET_INSTANCE_TL_PK
  1. INSTRUCTION_SET_ID
  2. LANGUAGE
Comments

Instruction Set Translation table at execution time

Indexes
Index Type Tablespace Column
GMO_INSTR_SET_INSTANCE_TL_PK UNIQUE APPS_TS_TX_IDX INSTRUCTION_SET_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
INSTRUCTION_SET_ID NUMBER
Y Instruction Set ID
INSTR_SET_DESC VARCHAR2 (500)
Description
SOURCE_LANG VARCHAR2 (4)
Source Language
LANGUAGE VARCHAR2 (4) Y Current Row Language
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]

GMO.GMO_INSTR_SET_INSTANCE_TL does not reference any database object

GMO.GMO_INSTR_SET_INSTANCE_TL is referenced by following:

GMO
VIEW - GMO_INSTR_SET_INSTANCE_TL#

[top of page]

Table: GMO_INSTR_TASK_ATTR_COLS_B

Description:
Primary Key: GMO_INSTR_TASK_ATTR_COLS_B_PK
  1. ATTR_COL_SEQ
Comments

Task Columns Base Table for Column Heading

Indexes
Index Type Tablespace Column
GMO_INSTR_TASK_ATTR_COLS_B_PK UNIQUE APPS_TS_TX_IDX ATTR_COL_SEQ
ZD_EDITION_NAME
GMO_INSTR_TASK_ATTR_COLS_B_N1 NONUNIQUE APPS_TS_TX_IDX TASK_NAME
GMO_INSTR_TASK_ATTR_COLS_B_N2 NONUNIQUE APPS_TS_TX_IDX ENTITY_NAME
Columns
Name Datatype Length Mandatory Comments
ATTR_COL_SEQ NUMBER
Y Attribute Column Sequence
ENTITY_NAME VARCHAR2 (500) Y Entity Name
TASK_NAME VARCHAR2 (500) Y Task
COLUMN_NO NUMBER
Y Column
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
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

GMO.GMO_INSTR_TASK_ATTR_COLS_B does not reference any database object

GMO.GMO_INSTR_TASK_ATTR_COLS_B is referenced by following:

GMO
VIEW - GMO_INSTR_TASK_ATTR_COLS_B#

[top of page]

Table: GMO_INSTR_TASK_ATTR_COLS_TL

Description: Task Columns Translation Table for Column Heading
Primary Key: GMO_INSTR_TASK_ATTR_COLS_TL_PK
  1. ATTR_COL_SEQ
  2. LANGUAGE
Comments

Task Columns Translation Table for Column Heading

Indexes
Index Type Tablespace Column
GMO_INSTR_TASK_ATTR_COLS_TL_PK UNIQUE APPS_TS_TX_IDX ATTR_COL_SEQ
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
ATTR_COL_SEQ NUMBER
Y Attribute Column Sequence, Primary Key
COLUMN_HEADING VARCHAR2 (500) Y Column Heading Displayed in Task LOV
SOURCE_LANG VARCHAR2 (4)
Source Language
LANGUAGE VARCHAR2 (4) Y Translated Language
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
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

GMO.GMO_INSTR_TASK_ATTR_COLS_TL does not reference any database object

GMO.GMO_INSTR_TASK_ATTR_COLS_TL is referenced by following:

GMO
VIEW - GMO_INSTR_TASK_ATTR_COLS_TL#

[top of page]

Table: GMO_INSTR_TASK_DEFN_B

Description: Task Definition Table to store all possible tasks to be executed using PI Framework
Primary Key: GMO_INSTR_TASK_DEFN_B_PK
  1. TASK_ID
Comments

Task Definition Table to store all possible tasks to be executed using PI Framework

Indexes
Index Type Tablespace Column
GMO_INSTR_TASK_DEFN_B_PK UNIQUE APPS_TS_TX_IDX TASK_ID
ZD_EDITION_NAME
GMO_INSTR_TASK_DEFN_B_N1 NONUNIQUE APPS_TS_TX_IDX TASK_NAME
Columns
Name Datatype Length Mandatory Comments
TASK_ID NUMBER
Y Task Id, primary key
ENTITY_NAME VARCHAR2 (500) Y Entity Name for the Task
INSTRUCTION_TYPE VARCHAR2 (40) Y Instruction Type for the task
TASK_NAME VARCHAR2 (500) Y Internal Name of task
TASK_TYPE VARCHAR2 (40) Y Type of Task
TARGET VARCHAR2 (4000) Y Target URL or OA Function Name for the task
ATTRIBUTE_SQL VARCHAR2 (4000)
Attribute SQL for the Task to be used at definition time
ATTRIBUTE_DISPLAY_COL_COUNT NUMBER

Attribute Display Column Count
ENTITY_KEY_PATTERN VARCHAR2 (4000)
String pattern used to for entity key
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
MAX_ALLOWED_TASK NUMBER (22)
Maximum Number of task repetition allowed in a Instruction Set
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

GMO.GMO_INSTR_TASK_DEFN_B does not reference any database object

GMO.GMO_INSTR_TASK_DEFN_B is referenced by following:

GMO
VIEW - GMO_INSTR_TASK_DEFN_B#

[top of page]

Table: GMO_INSTR_TASK_DEFN_TL

Description: Task Definition Translation Table
Primary Key: GMO_INSTR_TASK_DEFN_TL_PK
  1. TASK_ID
  2. LANGUAGE
Comments

Task Definition Translation Table

Indexes
Index Type Tablespace Column
GMO_INSTR_TASK_DEFN_TL_PK UNIQUE APPS_TS_TX_IDX TASK_ID
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
TASK_ID NUMBER
Y Task Id, Primary Key
DISPLAY_NAME VARCHAR2 (500) Y Task Display Name
SOURCE_LANG VARCHAR2 (4)
Source Language
LANGUAGE VARCHAR2 (4) Y Translated Language
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
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

GMO.GMO_INSTR_TASK_DEFN_TL does not reference any database object

GMO.GMO_INSTR_TASK_DEFN_TL is referenced by following:

GMO
VIEW - GMO_INSTR_TASK_DEFN_TL#

[top of page]

Table: GMO_INSTR_TASK_INSTANCE

Description: Task (task erecord id, task identifier, task value ) related data for given instruction
Primary Key: GMO_INSTR_TASK_INSTANCE_PK
  1. INSTRUCTION_ID
  2. INSTR_TASK_SEQ
Comments

Task (task erecord id, task identifier, task value ) related data for given instruction

Indexes
Index Type Tablespace Column
GMO_INSTR_TASK_INSTANCE_PK UNIQUE APPS_TS_TX_IDX INSTRUCTION_ID
INSTR_TASK_SEQ
Columns
Name Datatype Length Mandatory Comments
INSTRUCTION_ID NUMBER
Y Instruction Id, referenced from GMO_INSTR_INSTANCE_B, part of primary key
INSTR_TASK_SEQ NUMBER
Y Unique task sequence used to form primary key
TASK_EREC_ID NUMBER

Task E-record Id
TASK_IDENTIFIER VARCHAR2 (400)
Task Identifier
TASK_VALUE VARCHAR2 (4000)
Task Value
MANUAL_ENTRY VARCHAR2 (10)
Whether task is acknowledged from application or manually entered = Y or N
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]

GMO.GMO_INSTR_TASK_INSTANCE does not reference any database object

GMO.GMO_INSTR_TASK_INSTANCE is referenced by following:

GMO
VIEW - GMO_INSTR_TASK_INSTANCE#

[top of page]

Table: GMO_INSTR_TASK_INSTANCE_T

Description: Task (task erecord id, task identifier, task value ) related data for given instruction in given exectution session
Primary Key: GMO_INSTR_TASK_INSTANCE_T_PK
  1. INSTRUCTION_PROCESS_ID
  2. INSTRUCTION_ID
  3. INSTR_TASK_SEQ
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
GMO_INSTR_TASK_INSTANCE_T_PK UNIQUE APPS_TS_INTERFACE INSTRUCTION_PROCESS_ID
INSTRUCTION_ID
INSTR_TASK_SEQ
Columns
Name Datatype Length Mandatory Comments
INSTRUCTION_ID NUMBER
Y Instruction Id, referenced from GMO_INSTR_INSTANCE_B, part of primary key
INSTRUCTION_PROCESS_ID NUMBER
Y Instruction Process Id
INSTR_TASK_SEQ NUMBER
Y Unique task sequence used to form primary key
TASK_EREC_ID NUMBER

Task E-record Id
TASK_IDENTIFIER VARCHAR2 (400)
Task Identifier
TASK_VALUE VARCHAR2 (4000)
Task Value
MANUAL_ENTRY VARCHAR2 (10)
Whether task is acknowledged from application or manually entered = Y or N
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]

GMO.GMO_INSTR_TASK_INSTANCE_T does not reference any database object

GMO.GMO_INSTR_TASK_INSTANCE_T is referenced by following:

GMO
VIEW - GMO_INSTR_TASK_INSTANCE_T#

[top of page]

Table: GMO_KIOSK_DISP_PREFERENCES

Description: Dispensing Preferences Table
Primary Key: GMO_KIOSK_DISP_PREFERENCES_PK
  1. PREFERENCES_ID
Comments

Dispensing Preferences Table

Indexes
Index Type Tablespace Column
GMO_KIOSK_DISP_PREFERENCES_PK UNIQUE APPS_TS_TX_IDX PREFERENCES_ID
Columns
Name Datatype Length Mandatory Comments
PREFERENCES_ID NUMBER
Y Unique Preference ID
DISPENSE_AREA VARCHAR2 (500)
Dispense Area ID
TIME_RANGE VARCHAR2 (20)
Dispense Time Range
NO_OF_DAYS NUMBER

Number Of Days Setting
ROLLING_FLAG VARCHAR2 (1)
Flag Indicating Whether Rolling is enabled
DISPENSE_MODE VARCHAR2 (50)
Dispense Mode
PALLET_LABEL_FLAG VARCHAR2 (1)
Cage Label Flag
DISPENSE_LABEL_FLAG VARCHAR2 (1)
Dispense Label Flag
MATERIAL_LABEL_FLAG VARCHAR2 (1)
Material Label Flag
DEFAULT_DEVICE_ID NUMBER

ID for Default Device
DEFAULT_SOURCE_DEVICE_ID NUMBER

Default Source Device ID
DEFAULT_TARGET_DEVICE_ID NUMBER

Default Target Device ID
OPERATOR_CERTIFICATE_FLAG VARCHAR2 (1)
Flag To Enforce Operator Certification
DISPENSE_BOOTH VARCHAR2 (200)
Dispensing Booth
DISPENSE_ORGANIZATION VARCHAR2 (200)
Dispensing Organization
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

[top of page]

GMO.GMO_KIOSK_DISP_PREFERENCES does not reference any database object

GMO.GMO_KIOSK_DISP_PREFERENCES is referenced by following:

GMO
VIEW - GMO_KIOSK_DISP_PREFERENCES#

[top of page]

Table: GMO_KIOSK_LOV_T

Description:
Primary Key: GMO_KIOSK_LOV_T_PK
  1. PROCESS_ID
  2. ATTRIBUTE_ID
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
GMO_KIOSK_LOV_T_PK UNIQUE APPS_TS_TX_IDX PROCESS_ID
ATTRIBUTE_ID
Columns
Name Datatype Length Mandatory Comments
PROCESS_ID NUMBER
Y
ATTRIBUTE_ID NUMBER
Y
ATTRIBUTE_TYPE VARCHAR2 (500)
ATTRIBUTE_NAME VARCHAR2 (500)
ATTRIBUTE_VALUE VARCHAR2 (4000)

[top of page]

GMO.GMO_KIOSK_LOV_T does not reference any database object

GMO.GMO_KIOSK_LOV_T is referenced by following:

GMO
VIEW - GMO_KIOSK_LOV_T#

[top of page]

Table: GMO_KIOSK_OWB_PREFERENCES

Description: Operator Workbench Preferences
Primary Key: GMO_KIOSK_OWB_PREFERENCES_PK
  1. PREFERENCES_ID
Comments

Operator Workbench Preferences

Indexes
Index Type Tablespace Column
GMO_KIOSK_OWB_PREFERENCES_PK UNIQUE APPS_TS_TX_IDX PREFERENCES_ID
Columns
Name Datatype Length Mandatory Comments
PREFERENCES_ID NUMBER
Y Unique Preference ID
TIME_RANGE VARCHAR2 (20)
Time Range
NO_OF_DAYS NUMBER

Number Of Days
ROLLING_FLAG VARCHAR2 (10)
Flag Indicating Rolling
DEFAULT_RESOURCE VARCHAR2 (200)
Default Resource
OPERATOR_CERTIFICATE_FLAG VARCHAR2 (1)
Flag to Enforce Operator Certification
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

[top of page]

GMO.GMO_KIOSK_OWB_PREFERENCES does not reference any database object

GMO.GMO_KIOSK_OWB_PREFERENCES is referenced by following:

GMO
VIEW - GMO_KIOSK_OWB_PREFERENCES#

[top of page]

Table: GMO_KIOSK_PREFERENCES

Description: Main Preferences Table
Primary Key: GMO_KIOSK_PREFERENCES_PK
  1. PREFERENCES_ID
Comments

Main Preferences Table

Indexes
Index Type Tablespace Column
GMO_KIOSK_PREFERENCES_PK UNIQUE APPS_TS_TX_IDX PREFERENCES_ID
Columns
Name Datatype Length Mandatory Comments
PREFERENCES_ID NUMBER
Y Unique Preference ID
ORGANIZATION_ID NUMBER

Unique Organization ID
LEVEL_CODE VARCHAR2 (50)
Indicates Preferences Level SITE,USER,RESPONSIBILITY for a given ORGANIZATION
LEVEL_VALUE VARCHAR2 (100)
Value Applicable to the Preference Level
ENFORCE_CERTIFICATE_FLAG VARCHAR2 (1)
Enforce Operator Certification Flag
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

[top of page]

GMO.GMO_KIOSK_PREFERENCES does not reference any database object

GMO.GMO_KIOSK_PREFERENCES is referenced by following:

GMO
VIEW - GMO_KIOSK_PREFERENCES#

[top of page]

Table: GMO_KIOSK_REV_DISP_PREFERENCES

Description: Reverse Dispense Preferences
Primary Key: GMO_KIOSK_RDISP_PREFERENCES_PK
  1. PREFERENCES_ID
Comments

Reverse Dispense Preferences

Indexes
Index Type Tablespace Column
GMO_KIOSK_RDISP_PREFERENCES_PK UNIQUE APPS_TS_TX_IDX PREFERENCES_ID
Columns
Name Datatype Length Mandatory Comments
PREFERENCES_ID NUMBER
Y Unique Preference ID
DISPENSE_AREA VARCHAR2 (500)
Dispense Area ID
TIME_RANGE VARCHAR2 (20)
Dispense Time Range
NO_OF_DAYS NUMBER

Number Of Days Setting
ROLLING_FLAG VARCHAR2 (1)
Flag Indicating Whether Rolling is enabled
DISPENSE_MODE VARCHAR2 (50)
Dispense Mode
DISPENSE_LABEL_FLAG VARCHAR2 (1)
Dispense Label Flag
MATERIAL_LABEL_FLAG VARCHAR2 (1)
Material Label Flag
DEFAULT_DEVICE_ID NUMBER

ID for Default Device
DEFAULT_SOURCE_DEVICE_ID NUMBER

Default Source device ID. This is used to default Source Device in Touch Screen UI
DEFAULT_TARGET_DEVICE_ID NUMBER

Default Source device ID. This is used to default Source Device in Touch Screen UI
OPERATOR_CERTIFICATE_FLAG VARCHAR2 (1)
Operator Certificate Flag
DISPENSE_BOOTH VARCHAR2 (200)
Dispense Booth
DISPENSE_ORGANIZATION VARCHAR2 (200)
Dispense Organization
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

[top of page]

GMO.GMO_KIOSK_REV_DISP_PREFERENCES does not reference any database object

GMO.GMO_KIOSK_REV_DISP_PREFERENCES is referenced by following:

GMO
VIEW - GMO_KIOSK_REV_DISP_PREFERENCE#

[top of page]

Table: GMO_LABEL_CONTEXT_T

Description: This is a temporary table whihc stores the context of transaction to be used in UI rendering
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
LABEL_ID NUMBER
Y Label identifier refers GMO_LABEL_HISTORY
DISPLAY_SEQUENCE NUMBER
Y Display sequnece of the context in UI
APPLICATION_SHORT_NAME VARCHAR2 (3) Y Application short name to derive the message token
CONTEXT_MESSAGE_TOKEN VARCHAR2 (32) Y FND message token to be used as display name
CONTEXT_VALUE VARCHAR2 (240)
Value to be displayed next to the display name
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]

GMO.GMO_LABEL_CONTEXT_T does not reference any database object

GMO.GMO_LABEL_CONTEXT_T is referenced by following:

GMO
VIEW - GMO_LABEL_CONTEXT_T#

[top of page]

Table: GMO_LABEL_HISTORY

Description:
Primary Key: GMO_LABEL_HISTORY_PK
  1. LABEL_ID
Comments

Stores Label Printing History

Indexes
Index Type Tablespace Column
GMO_LABEL_HISTORY_PK UNIQUE APPS_TS_TX_IDX LABEL_ID
Columns
Name Datatype Length Mandatory Comments
LABEL_ID NUMBER
Y Label ID
ENTITY_NAME VARCHAR2 (32) Y Event Name
ENTITY_KEY VARCHAR2 (32) Y Event Key
WMS_BUSINESSFLOW_CODE NUMBER
Y Label Business Flow Code
WMS_BUSINESSFLOW_TRANS_ID VARCHAR2 (32) Y Business Flow Transaction ID
TRANSACTION_TYPE VARCHAR2 (32)
Transaction Type
REQUESTER NUMBER
Y Requester
REQUESTED_DATE DATE
Y Requested Date
ERECORD_ID NUMBER

eRecord ID
STATUS VARCHAR2 (32) Y Status
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]

GMO.GMO_LABEL_HISTORY does not reference any database object

GMO.GMO_LABEL_HISTORY is referenced by following:

GMO
VIEW - GMO_LABEL_HISTORY#

[top of page]

Table: GMO_LABEL_HISTORY_DTL

Description: Stores the Label types printed for a transaction
Primary Key: GMO_LABEL_HISTORY_DTL_PK
  1. LABEL_DTL_ID
Comments

Stores the Label types printed for a transaction

Indexes
Index Type Tablespace Column
GMO_LABEL_HISTORY_DTL_PK UNIQUE APPS_TS_TX_IDX LABEL_DTL_ID
Columns
Name Datatype Length Mandatory Comments
LABEL_DTL_ID NUMBER
Y Unique row identifier and Primary Key
LABEL_ID NUMBER
Y Unique Label identifier and references GMO_LABEL_HISTORY
LABEL_TYPE NUMBER
Y WMS label type being printed. Derived from WMS_LABEL_TYPE lookups
WMS_LABEL_ID NUMBER

Label ID returned by WMS interface
WMS_PRINT_STATUS VARCHAR2 (32)
Print Status from WMS interface
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]

GMO.GMO_LABEL_HISTORY_DTL does not reference any database object

GMO.GMO_LABEL_HISTORY_DTL is referenced by following:

GMO
VIEW - GMO_LABEL_HISTORY_DTL#

[top of page]

Table: GMO_MATERIAL_DISPENSES

Description: GMO Material Dispenses
Primary Key: GMO_MATERIAL_DISPENSES_PK
  1. DISPENSE_ID
Comments

GMO Material Dispenses

Indexes
Index Type Tablespace Column
GMO_MATERIAL_DISPENSES_PK UNIQUE APPS_TS_TX_IDX DISPENSE_ID
GMO_MATERIAL_DISPENSES_U1 UNIQUE APPS_TS_TX_IDX ORGANIZATION_ID
DISPENSE_ID
BATCH_ID
GMO_MATERIAL_DISPENSES_N1 NONUNIQUE APPS_TS_TX_IDX BATCH_ID
INVENTORY_ITEM_ID
GMO_MATERIAL_DISPENSES_N2 NONUNIQUE APPS_TS_TX_IDX RESERVATION_ID
MATERIAL_STATUS
GMO_MATERIAL_DISPENSES_N3 NONUNIQUE APPS_TS_TX_IDX MATERIAL_DETAIL_ID
MATERIAL_STATUS
Columns
Name Datatype Length Mandatory Comments
DISPENSE_ID NUMBER (15) Y Dispense ID
DISPENSE_SOURCE VARCHAR2 (30) Y Dispense Source e.g. BATCH
DISPENSE_NUMBER VARCHAR2 (30) Y Dispense Number
DISPENSE_SOURCE_TRANSACTION_ID NUMBER (15)
ID of the source transaction e.g. Batch ID
DISPENSE_TYPE VARCHAR2 (10) Y Dispense Type : Production or Ad hoc
MATERIAL_DETAIL_ID NUMBER (10)
Material detail ID
BATCH_ID NUMBER (10)
Batch ID
BATCH_STEP_ID NUMBER (10)
Batch Step ID
INVENTORY_ITEM_ID NUMBER (10) Y Inventory Item ID
ORGANIZATION_ID NUMBER
Y Organization ID
SUBINVENTORY_CODE VARCHAR2 (10)
Sub inventory or booth Code
SECURITY_CODE VARCHAR2 (240)
Security code to be used in label printing
DISPENSE_UOM VARCHAR2 (4) Y Dispense UOM
SOURCE_CONTAINER_DEVICE_ID NUMBER

Source Container Item ID
TARGET_CONTAINER_DEVICE_ID NUMBER

Target Container Item ID
DISPENSED_DATE DATE
Y Dispensed Date
DISPENSING_MODE VARCHAR2 (20) Y Dispensing Mode
REQUIRED_QTY NUMBER (15) Y Pending Dispense Quantity
DISPENSED_QTY NUMBER (15)
Dispensed Quantity
GROSS_REQUIRED_WEIGHT NUMBER (15)
Required Weight of the dispensed container
SOURCE_CONTAINER_TARE NUMBER (15)
Source Container tare
SOURCE_CONTAINER_WEIGHT NUMBER (15)
Source Container weight
SOURCE_CONTAINER_REWEIGHT NUMBER (15)
Source Container Re-weight
ACTUAL_GROSS_WEIGHT NUMBER (15)
Target Container Weight
TARGET_CONTAINER_TARE NUMBER (15)
Target Container Tare
SOURCE_CONTAINER_ITEM_ID NUMBER

Source Container Item ID
TARGET_CONTAINER_ITEM_ID NUMBER

Target Container Item ID
RESERVATION_ID NUMBER

Material Reservation ID
MATERIAL_STATUS VARCHAR2 (8)
Material Status
LOT_NUMBER VARCHAR2 (80)
Lot Number
ERECORD_ID NUMBER

E-record ID
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
INCLUDE_TARE_FLAG VARCHAR2 (1)
Tare is included or not
DISPENSE_AREA_ID NUMBER
Y Dispese Area where dispense is performed
DISPENSE_BOOTH_ID NUMBER
Y Dispense Booth where dispense is performed

[top of page]

GMO.GMO_MATERIAL_DISPENSES does not reference any database object

GMO.GMO_MATERIAL_DISPENSES is referenced by following:

GMO
VIEW - GMO_MATERIAL_DISPENSES#

[top of page]

Table: GMO_MATERIAL_UNDISPENSES

Description: GMO Material UNDispenses
Primary Key: GMO_MATERIAL_UNDISPENSES_PK
  1. UNDISPENSE_ID
Comments

GMO Material Reverse Dispenses

Indexes
Index Type Tablespace Column
GMO_MATERIAL_UNDISPENSES_U1 UNIQUE APPS_TS_TX_IDX UNDISPENSE_ID
DISPENSE_ID
GMO_MATERIAL_UNDISPENSES_N1 NONUNIQUE APPS_TS_TX_IDX DISPENSE_ID
INVENTORY_ITEM_ID
Columns
Name Datatype Length Mandatory Comments
UNDISPENSE_ID NUMBER (15) Y Reverse Dispense ID
DISPENSE_ID NUMBER (15) Y Dispense ID
UNDISPENSE_NUMBER VARCHAR2 (30) Y Reverse Dispense Number
SOURCE_TRANSACTION_ID NUMBER (15)
ID of the source transaction e.g. Batch ID
UNDISPENSE_TYPE VARCHAR2 (10) Y Reverse Dispense Type : Production or Ad hoc
MATERIAL_DETAIL_ID NUMBER (10)
Material detail ID
BATCH_ID NUMBER (10)
Batch ID
BATCH_STEP_ID NUMBER (10)
Batch Step ID
INVENTORY_ITEM_ID NUMBER (10) Y Inventory Item ID
ORGANIZATION_ID NUMBER
Y Organization ID
SUBINVENTORY_CODE VARCHAR2 (10)
Sub inventory or booth Code
SECURITY_CODE VARCHAR2 (240)
Security code to be used in label printing
DISPENSE_UOM VARCHAR2 (4) Y Dispense UOM
SOURCE_CONTAINER_DEVICE_ID NUMBER

Source Container Item ID
TARGET_CONTAINER_DEVICE_ID NUMBER

Target Container Item ID
UNDISPENSED_DATE DATE
Y Reverse Dispensed Date
UNDISPENSING_MODE VARCHAR2 (20) Y Reverse Dispensing Mode
DISPENSED_QTY NUMBER (15) Y Pending Reverse Dispense Quantity
UNDISPENSED_QTY NUMBER (15)
Reverse Dispensed Quantity
GROSS_REQUIRED_WEIGHT NUMBER (15)
Required Weight of the reverse dispensed container
SOURCE_CONTAINER_TARE NUMBER (15)
Source Container tare
SOURCE_CONTAINER_WEIGHT NUMBER (15)
Source Container weight
SOURCE_CONTAINER_REWEIGHT NUMBER (15)
Source Container Re-weight
ACTUAL_GROSS_WEIGHT NUMBER (15)
Target Container Weight
TARGET_CONTAINER_TARE NUMBER (15)
Target Container Tare
SOURCE_CONTAINER_ITEM_ID NUMBER

Source Container Item ID
TARGET_CONTAINER_ITEM_ID NUMBER

Target Container Item ID
RESERVATION_ID NUMBER

Material Reservation ID
MATERIAL_STATUS VARCHAR2 (20)
Material Status
LOT_NUMBER VARCHAR2 (80)
Lot Number
ERECORD_ID NUMBER

E-record ID
MATERIAL_LOSS NUMBER

Material Loss
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
INCLUDE_TARE_FLAG VARCHAR2 (1)
Tare is Included or not
DISPENSE_AREA_ID NUMBER
Y Dispense Area
DISPENSE_BOOTH_ID NUMBER
Y Dispense Booth Identifier

[top of page]

GMO.GMO_MATERIAL_UNDISPENSES does not reference any database object

GMO.GMO_MATERIAL_UNDISPENSES is referenced by following:

GMO
VIEW - GMO_MATERIAL_UNDISPENSES#

[top of page]

Table: GMO_NONCONFORMANCE

Description: Stores the non conformance logged against Batches
Primary Key: GMO_NONCONFORMANCE_PK
  1. NONCONFORMANCE_ID
Comments

Stores the non conformance logged against Batches

Indexes
Index Type Tablespace Column
GMO_NONCONFORMANCE_PK UNIQUE APPS_TS_TX_IDX NONCONFORMANCE_ID
Columns
Name Datatype Length Mandatory Comments
NONCONFORMANCE_ID NUMBER
Y Unique nonconformance identifier and primary key
ENTITY_NAME VARCHAR2 (32) Y Calling Entity name which has non conformance
ENTITY_KEY VARCHAR2 (32) Y Calling Entity key which has non conformance
COLLECTION_ID NUMBER

Collection id returned by Oracle Quality Nonconformacne module
COLLECTION_STATUS VARCHAR2 (32) Y STATUS of the Print request NEW,COMPLETE
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]

GMO.GMO_NONCONFORMANCE does not reference any database object

GMO.GMO_NONCONFORMANCE is referenced by following:

GMO
VIEW - GMO_NONCONFORMANCE#

[top of page]

Table: GMO_OPERATOR_CERT_TRANS

Description: GMO_OPERATOR_CERT_TRANS
Comments

Operator Certification Transaction Instances

Indexes
Index Type Tablespace Column
GMO_OPERATOR_CERT_TRANS_PK UNIQUE APPS_TS_TX_IDX OPERATOR_CERTIFICATE_ID
GMO_OPERATOR_CERT_TRANS_N1 NONUNIQUE APPS_TS_TX_IDX OPERATOR_CERTIFICATE_ID
USER_ID
Columns
Name Datatype Length Mandatory Comments
OPERATOR_CERTIFICATE_ID NUMBER
Y OPERATOR_CERTIFICATE_ID
HEADER_ID NUMBER
Y header_id from GMO_OPERT_CERT_HEADER
TRANSACTION_ID VARCHAR2 (240)
TRANSACTION_ID is TRANSACTION which it is applicable
USER_ID NUMBER
Y User_id of the Operator
COMMENTS VARCHAR2 (240)
COMMENTS for this override
OVERRIDER_ID NUMBER

OVERRIDER_ID for this qualification
USER_KEY_LABEL_PRODUCT VARCHAR2 (30)
PRODUCT for this transaction
USER_KEY_LABEL_TOKEN VARCHAR2 (240)
TOKEN for this transaction
USER_KEY_VALUE VARCHAR2 (240)
Value for this transaction
ERECORD_ID NUMBER

ERECORD_ID for this transaction
TRANS_OBJECT_ID NUMBER

Object for this transaction
STATUS VARCHAR2 (1)
STATUS for this transaction
EVENT_KEY VARCHAR2 (30)
EVENT_KEY for this transaction
EVENT_NAME VARCHAR2 (240)
EVENT_NAME for this transaction
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]

GMO.GMO_OPERATOR_CERT_TRANS does not reference any database object

GMO.GMO_OPERATOR_CERT_TRANS is referenced by following:

GMO
VIEW - GMO_OPERATOR_CERT_TRANS#

[top of page]

Table: GMO_OPERATOR_TRANS_DETAIL

Description: GMO_OPERATOR_TRANS_DETAIL
Comments

Operator Certification Transaction Instances Details

Indexes
Index Type Tablespace Column
GMO_OPERATOR_TRANS_DETAIL_PK UNIQUE APPS_TS_TX_IDX TRANS_DETAIL_ID
GMO_OPERATOR_TRANS_DETAIL_N1 NONUNIQUE APPS_TS_TX_IDX TRANS_DETAIL_ID
OPERATOR_CERTIFICATE_ID
Columns
Name Datatype Length Mandatory Comments
OPERATOR_CERTIFICATE_ID NUMBER
Y Unique Identifier
TRANS_DETAIL_ID NUMBER
Y Transaction Detail ID
HEADER_ID NUMBER
Y Header ID
QUALIFICATION_ID NUMBER
Y Qulalification for which Override is Given
QUALIFICATION_TYPE NUMBER
Y Cerificate or Competency
PROFICIENCY_LEVEL_ID NUMBER

Proficiency Level for this Qualification

[top of page]

GMO.GMO_OPERATOR_TRANS_DETAIL does not reference any database object

GMO.GMO_OPERATOR_TRANS_DETAIL is referenced by following:

GMO
VIEW - GMO_OPERATOR_TRANS_DETAIL#

[top of page]

Table: GMO_OPERT_CERT_DETAIL

Description: GMO_OPERT_CERT_DETAIL
Comments

Operator Certification Details

Indexes
Index Type Tablespace Column
GMO_OPERT_CERT_DETAIL_PK UNIQUE APPS_TS_TX_IDX DETAIL_ID
GMO_OPERT_CERT_DETAIL_N1 NONUNIQUE APPS_TS_TX_IDX DETAIL_ID
HEADER_ID
QUALIFICATION_ID
QUALIFICATION_TYPE
Columns
Name Datatype Length Mandatory Comments
DETAIL_ID NUMBER
Y Unique Identifier
HEADER_ID NUMBER
Y Parent Identifier
QUALIFICATION_ID NUMBER
Y Qualifiaction ID is Qualifiaction which it is applicable
QUALIFICATION_TYPE NUMBER
Y Identifies Qualification is Certificate or Competecy
PROFICIENCY_LEVEL_ID NUMBER

Proficiency Level for this Qualification
FROM_DATE DATE
Y From date for this qualification
TO_DATE DATE

To date for this qualification
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]

GMO.GMO_OPERT_CERT_DETAIL does not reference any database object

GMO.GMO_OPERT_CERT_DETAIL is referenced by following:

GMO
VIEW - GMO_OPERT_CERT_DETAIL#

[top of page]

Table: GMO_OPERT_CERT_GTMP

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
ERECORD_ID NUMBER

OPERATOR_CERTIFICATE_ID NUMBER

EVENT_KEY VARCHAR2 (30)
EVENT_NAME VARCHAR2 (240)

[top of page]

GMO.GMO_OPERT_CERT_GTMP does not reference any database object

GMO.GMO_OPERT_CERT_GTMP is referenced by following:

APPS
SYNONYM - GMO_OPERT_CERT_GTMP

[top of page]

Table: GMO_OPERT_CERT_HEADER

Description: GMO Operator cert header
Comments

Operator Certification Header

Indexes
Index Type Tablespace Column
GMO_OPERT_CERT_HEADER_PK UNIQUE APPS_TS_TX_IDX HEADER_ID
GMO_OPERT_CERT_HEADER_N1 NONUNIQUE APPS_TS_TX_IDX HEADER_ID
ORGANIZATION_ID
OBJECT_ID
OBJECT_TYPE
Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER
Y header_id
ORGANIZATION_ID NUMBER
Y Organization_id is organization which it is applicable
OBJECT_ID NUMBER
Y Object_id is the Id for which it is applicable
OBJECT_TYPE NUMBER
Y Name of the Object_type
OVERRIDE NUMBER

Override is allowed for this object
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]

GMO.GMO_OPERT_CERT_HEADER does not reference any database object

GMO.GMO_OPERT_CERT_HEADER is referenced by following:

GMO
VIEW - GMO_OPERT_CERT_HEADER#

[top of page]

View: GMO_BATCH_STEPS_V

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.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (10) Y
BATCH_NO VARCHAR2 (32) Y BAtch No
BATCHSTEP_ID NUMBER (15) Y Step ID
BATCHSTEP_NO NUMBER (10) Y Step No
OPRN_ID NUMBER (10) Y Operation Id
PLAN_STEP_QTY NUMBER
Y Planned Qty
ACTUAL_STEP_QTY NUMBER

Actual Step Quantity
STEP_QTY_UM VARCHAR2 (0)
Actual Step UOM
PLAN_START_DATE DATE

Planned Start Date
ACTUAL_START_DATE DATE

ACtual Start Date
DUE_DATE DATE
Y Due date
PLAN_CMPLT_DATE DATE

Planned Completion Date
ACTUAL_CMPLT_DATE DATE

Step Atual Completion date
STEP_CLOSE_DATE DATE

Step Closure Date
STEP_STATUS NUMBER (5) Y Step STatus
STEPRELEASE_TYPE NUMBER (5) Y Step Release Type
MAX_STEP_CAPACITY NUMBER

Maximun Step Capacity
MAX_STEP_CAPACITY_UM VARCHAR2 (0)
Maximum Step capacity UOM
PLAN_CHARGES NUMBER

Planned changes for the step
ACTUAL_CHARGES NUMBER

Actual Chanrges for the step
QUALITY_STATUS NUMBER (1)
Quality Status of the step
MINIMUM_TRANSFER_QTY NUMBER

Minimum Transfer Quantoty
TERMINATED_IND NUMBER (1)
Batch step TErminations indicator
OPRN_NO VARCHAR2 (16) Y Operation number
OPRN_VERS NUMBER (5) Y Operation Version
OPRN_DESC VARCHAR2 (240) Y Operation Description
OPERATION VARCHAR2 (57)
Conconated segment of Operation and version

[top of page]

APPS.GMO_BATCH_STEPS_V references the following:

APPS
VIEW - GMD_OPERATIONS_VL
SYNONYM - GME_BATCH_HEADER
SYNONYM - GME_BATCH_STEPS

APPS.GMO_BATCH_STEPS_V is not referenced by any database object

[top of page]

View: GMO_INSTR_DEFN_VL

Comments
View Type

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

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
INSTRUCTION_ID NUMBER
Y Instruction Id, primary key
INSTRUCTION_SET_ID NUMBER
Y Instruction Set Id, Foriegn Key, referenced from GMO_INSTR_SET_DEFN_B
INSTR_SEQ NUMBER
Y Instruction sequence for ordering instructions in definition and runtime
TASK_ID NUMBER

Task Id referencing GMO_INSTR_TASK_DEFN_B, for task associated with instruction
TASK_ATTRIBUTE_ID VARCHAR2 (4000)
Task Attribute Id for task associated
TASK_ATTRIBUTE VARCHAR2 (4000)
Task Attribute for task associated
INSTR_ACKN_TYPE VARCHAR2 (40)
Instruction Ackn Type Code reference from GMO_INSTR_ACKN_TYPES lookup
INSTR_NUMBER VARCHAR2 (200)
Instruction Number displayed to user
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
INSTRUCTION_TEXT VARCHAR2 (4000)
Instruction Text
TASK_LABEL VARCHAR2 (30)
Task Label

[top of page]

APPS.GMO_INSTR_DEFN_VL references the following:

APPS
SYNONYM - GMO_INSTR_DEFN_B
SYNONYM - GMO_INSTR_DEFN_TL

APPS.GMO_INSTR_DEFN_VL is not referenced by any database object

[top of page]

View: GMO_INSTR_INSTANCE_VL

Comments
View Type

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

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
OPERATOR_ACKN VARCHAR2 (40)
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)
TASK_ATTRIBUTE VARCHAR2 (500)
TASK_ATTRIBUTE_ID VARCHAR2 (500)
INSTRUCTION_ID NUMBER
Y
INSTRUCTION_SET_ID NUMBER
Y
INSTR_NUMBER VARCHAR2 (200)
INSTR_STATUS VARCHAR2 (40) Y
TASK_ID NUMBER

TASK_ACKN_DATE DATE

TASK_ACKN_STATUS VARCHAR2 (40)
INSTR_SEQ NUMBER
Y
INSTR_ACKN_TYPE VARCHAR2 (40)
INSTRUCTION_TEXT VARCHAR2 (4000)
COMMENTS VARCHAR2 (4000)
TASK_LABEL VARCHAR2 (30)

[top of page]

APPS.GMO_INSTR_INSTANCE_VL references the following:

APPS
SYNONYM - GMO_INSTR_INSTANCE_B
SYNONYM - GMO_INSTR_INSTANCE_TL

APPS.GMO_INSTR_INSTANCE_VL is not referenced by any database object

[top of page]

View: GMO_INSTR_SET_DEFN_VL

Comments
View Type

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

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
INSTRUCTION_SET_ID NUMBER
Y Instruction Set Id, Primary Key
INSTRUCTION_TYPE VARCHAR2 (40) Y Instruction Set type code eg. PROCESS, DISPENSE, REVERSE_DISPENSE
INSTR_SET_NAME VARCHAR2 (240) Y Instruction Set Name used to identify Instruction Set
ENTITY_NAME VARCHAR2 (200) Y Entity Name for Instruction Set
ENTITY_KEY VARCHAR2 (500) Y Entity Key for Instruction Set
ACKN_STATUS VARCHAR2 (40)
Acknowledgement status used for handshake purposes
ORIG_SOURCE VARCHAR2 (40)
ORIG Source = DEFINITION
ORIG_SOURCE_ID NUMBER

Originial Instruction Set Id, if this instruction set is a copy of existing
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
INSTR_SET_DESC VARCHAR2 (500)
Instruction Set Description (MLS)

[top of page]

APPS.GMO_INSTR_SET_DEFN_VL references the following:

APPS
SYNONYM - GMO_INSTR_SET_DEFN_B
SYNONYM - GMO_INSTR_SET_DEFN_TL

APPS.GMO_INSTR_SET_DEFN_VL is not referenced by any database object

[top of page]

View: GMO_INSTR_SET_INSTANCE_VL

Comments
View Type

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

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
INSTR_SET_STATUS VARCHAR2 (40)
Instruction set status used to identify nullified instructions -can be ACTIVE or CANCEL
INSTRUCTION_SET_ID NUMBER
Y Instruction set id, primary key
INSTRUCTION_TYPE VARCHAR2 (40)
Instruction Type
INSTR_SET_NAME VARCHAR2 (240)
Instruction Set Name used to identify Instruction Set
ENTITY_NAME VARCHAR2 (200)
Entity Name for Instruction Set
ENTITY_KEY VARCHAR2 (500)
Entity Key for Instruction Set
ACKN_STATUS VARCHAR2 (40)
Acknowledgement status used for handshake purposes
ORIG_SOURCE VARCHAR2 (40)
ORIG Source = DEFINITION in case of CREATE_INSTANCE_FROM_DEFINITION or INSTANCE in case of CREATE_INSTANCE_FROM_INSTANCE
ORIG_SOURCE_ID NUMBER

Originial Instruction Set Id, if this instruction set is a copy of existing
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
INSTR_SET_DESC VARCHAR2 (500)
Instruction Set Description

[top of page]

APPS.GMO_INSTR_SET_INSTANCE_VL references the following:

APPS
SYNONYM - GMO_INSTR_SET_INSTANCE_B
SYNONYM - GMO_INSTR_SET_INSTANCE_TL

APPS.GMO_INSTR_SET_INSTANCE_VL is not referenced by any database object

[top of page]

View: GMO_INSTR_TASK_ATTR_COLS_VL

Comments
View Type

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

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
TASK_NAME VARCHAR2 (500) Y Task Name from the Task Table
COLUMN_NO NUMBER
Y Column Number
ATTR_COL_SEQ NUMBER
Y Attribute Column Sequence, Primary Key
ENTITY_NAME VARCHAR2 (500) Y Entity Name from the Task table
COLUMN_HEADING VARCHAR2 (500) Y Column Heading Displayed in Task LOV
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

[top of page]

APPS.GMO_INSTR_TASK_ATTR_COLS_VL references the following:

APPS
SYNONYM - GMO_INSTR_TASK_ATTR_COLS_B
SYNONYM - GMO_INSTR_TASK_ATTR_COLS_TL

APPS.GMO_INSTR_TASK_ATTR_COLS_VL is not referenced by any database object

[top of page]

View: GMO_INSTR_TASK_DEFN_VL

Comments
View Type

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

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
TASK_ID NUMBER
Y Task Id, primary key
ENTITY_NAME VARCHAR2 (500) Y Entity Name for the Task
INSTRUCTION_TYPE VARCHAR2 (40) Y Instruction Type for the task
TASK_NAME VARCHAR2 (500) Y Internal Name of task
TASK_TYPE VARCHAR2 (40) Y Type of Task
TARGET VARCHAR2 (4000) Y Target URL or OA Function Name for the task
ATTRIBUTE_SQL VARCHAR2 (4000)
Attribute SQL for the Task to be used at definition time
ATTRIBUTE_DISPLAY_COL_COUNT NUMBER

Attribute Display Column Count
ENTITY_KEY_PATTERN VARCHAR2 (4000)
String pattern used to for entity key
MAX_ALLOWED_TASK NUMBER (22)
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
DISPLAY_NAME VARCHAR2 (500) Y Task Display Name

[top of page]

APPS.GMO_INSTR_TASK_DEFN_VL references the following:

APPS
SYNONYM - GMO_INSTR_TASK_DEFN_B
SYNONYM - GMO_INSTR_TASK_DEFN_TL

APPS.GMO_INSTR_TASK_DEFN_VL is not referenced by any database object

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