GMD — Process Manufacturing Product Development
182 documented tables · 79 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
FM_TEXT_HDR |
Table used to store text types for Formula Model | hub-leaning |
QC_TEXT_HDR |
Holds text types defined for QC module | hub-leaning |
LM_TEXT_HDR |
Holds text types defined for Lab module | hub-leaning |
QC_GRAD_MST |
QC grade code master. | hub-leaning |
LM_LTYP_MST |
Laboratory type master | hub-leaning |
QC_HRES_MST |
QC hold reason code master. | hub-leaning |
GMD_GRADES_B |
QC grade code master. | hub-leaning |
QC_ASSY_TYP |
QC assay master. | hub-leaning |
QC_ACTN_MST |
QC action codes. | hub-leaning |
LM_TECH_HDR |
Technical parameters header | hub-leaning |
FM_FMCT_CLS |
Formula control classes -NOT USED- | hub-leaning |
FM_OPRN_MST |
Operation master | hub-leaning |
FM_FORM_MST |
Formula header table | hub-leaning |
FM_ROUT_DTL |
Routing details | hub |
FM_FORM_CLS |
Formula classes - used to group formulas. | hub-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
GMD_API_PUB |
PUB | 4 | 51 packages |
GMD_API_GRP |
GRP | 26 | 50 packages |
GMD_RECIPE_FETCH_PUB |
PUB | 16 | 15 packages |
GMD_STATUS_PUB |
PUB | 1 | 10 packages |
GMD_SPEC_MATCH_GRP |
GRP | 11 | 9 packages |
GMD_RESULTS_GRP |
GRP | 38 | 8 packages |
GMD_SPEC_GRP |
GRP | 22 | 8 packages |
GMD_ROUTINGS_PUB |
PUB | 4 | 7 packages |
GMD_QUALITY_PARAMETERS_GRP |
GRP | 4 | 7 packages |
GMD_FORMULA_COMMON_PUB |
PUB | 0 | 6 packages |