GMO Tables (56)
GMO - Manufacturing Execution System for Process Manufacturing — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
GMO_AREA_OPERATOR_MAPPING |
8 | Dispense Area Operator Mapping Table |
GMO_BATCH_PROGRESSION |
31 | This table maintains Batch Progression |
GMO_BATCH_STEP_LOCK_DETAILS |
9 | GMO Batch Step Lock Details |
GMO_BATCH_STEP_LOCK_HIST |
12 | GMO Batch Step Lock History |
GMO_CBR_XML |
2 | This table is to store consolidated Control Batch Record XML |
GMO_DEVICE_REQUESTS_T |
11 | GMO Device Request |
GMO_DEVICE_RESPONSES_T |
9 | GMO Device Response |
GMO_DISPENSE_AREA_B |
11 | Dispense Area Table |
GMO_DISPENSE_AREA_TL |
9 | |
GMO_DISPENSE_BOOTH_B |
9 | |
GMO_DISPENSE_BOOTH_TL |
9 | |
GMO_DISPENSE_CONFIG |
20 | GMO Dispense Configuration |
GMO_DISPENSE_CONFIG_INST |
9 | Holds the instantiated dispense setup configurations. |
GMO_DISPENSE_STORAGE_SUBINVS |
8 | |
GMO_DISPENSING_PLANNING |
14 | Dispense Planning Table |
GMO_DOCUMENT_NUMBERS |
17 | Holds generated document numbers for a given organization and transaction type |
GMO_INSTR_APPR_DEFN |
9 | Instruction Approvers Functional Temp Table |
GMO_INSTR_APPR_DEFN_T |
10 | |
GMO_INSTR_APPR_INSTANCE |
9 | Instruction Approvers Table |
GMO_INSTR_ATTRIBUTES_T |
14 | Functional temporary table to store session related attributes |
GMO_INSTR_DEFN_B |
13 | Instruction definition time base table |
GMO_INSTR_DEFN_T |
16 | Functional Temporary table for Instructions at Definition Time |
GMO_INSTR_DEFN_TL |
10 | Instruction Definitioin Transalatable Table |
GMO_INSTR_EREC_INSTANCE |
9 | The table stores the relationship between Instruction Id and Instruction E-record Id |
GMO_INSTR_EREC_INSTANCE_T |
10 | The table stores the relationship between Instruction Id and Instruction E-record Id |
GMO_INSTR_INSTANCE_B |
17 | Instruction base table at execution time |
GMO_INSTR_INSTANCE_T |
17 | Functional Temporary table to store the Operator Response and Task Related details at execution time for an Instruction |
GMO_INSTR_INSTANCE_TL |
11 | Instruction Translation Table for instructions at execution time |
GMO_INSTR_SET_DEFN_B |
13 | Instruction Set Definition Time Base Table |
GMO_INSTR_SET_DEFN_T |
15 | |
GMO_INSTR_SET_DEFN_TL |
9 | Instruction Set Definition Time Translation Table |
GMO_INSTR_SET_INSTANCE_B |
14 | Instruction Set base table at execution time |
GMO_INSTR_SET_INSTANCE_T |
8 | Instruction Set Temp Table to maintain Instruction Set Ackn Status |
GMO_INSTR_SET_INSTANCE_TL |
9 | |
GMO_INSTR_TASK_ATTR_COLS_B |
10 | |
GMO_INSTR_TASK_ATTR_COLS_TL |
10 | Task Columns Translation Table for Column Heading |
GMO_INSTR_TASK_DEFN_B |
16 | Task Definition Table to store all possible tasks to be executed using PI Framework |
GMO_INSTR_TASK_DEFN_TL |
10 | Task Definition Translation Table |
GMO_INSTR_TASK_INSTANCE |
11 | Task (task erecord id, task identifier, task value ) related data for given instruction |
GMO_INSTR_TASK_INSTANCE_T |
12 | Task (task erecord id, task identifier, task value ) related data for given instruction in given exectution session |
GMO_KIOSK_DISP_PREFERENCES |
20 | Dispensing Preferences Table |
GMO_KIOSK_LOV_T |
5 | |
GMO_KIOSK_OWB_PREFERENCES |
11 | Operator Workbench Preferences |
GMO_KIOSK_PREFERENCES |
10 | Main Preferences Table |
GMO_KIOSK_REV_DISP_PREFERENCES |
19 | Reverse Dispense Preferences |
GMO_LABEL_CONTEXT_T |
10 | This is a temporary table whihc stores the context of transaction to be used in UI rendering |
GMO_LABEL_HISTORY |
15 | |
GMO_LABEL_HISTORY_DTL |
10 | Stores the Label types printed for a transaction |
GMO_MATERIAL_DISPENSES |
39 | GMO Material Dispenses |
GMO_MATERIAL_UNDISPENSES |
40 | GMO Material UNDispenses |
GMO_NONCONFORMANCE |
10 | Stores the non conformance logged against Batches |
GMO_OPERATOR_CERT_TRANS |
19 | GMO_OPERATOR_CERT_TRANS |
GMO_OPERATOR_TRANS_DETAIL |
6 | GMO_OPERATOR_TRANS_DETAIL |
GMO_OPERT_CERT_DETAIL |
12 | GMO_OPERT_CERT_DETAIL |
GMO_OPERT_CERT_GTMP |
4 | |
GMO_OPERT_CERT_HEADER |
10 | GMO Operator cert header |