Results for “recipe_no”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
GR_INV_RECIPE_V1 is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the GR (Process Manufacturing Regulatory Management) product family. Its documented purpose is to return a distinct list of recipe numbers, joined to their corresponding formula numbers and formula versions. The view is defined as VALID in the ETRM 12.2.2 metadata, confirming that it is a supported, compiled database object available for querying in both 12.1.1 and 12.2.2 environments.
Because the view resolves recipe, formula, and status relationships through a single DISTINCT projection, it serves as a lightweight integration and reporting surface for downstream processes that need a clean, de-duplicated inventory of recipes and their associated formulas. It is typically consumed by custom reports, concurrent programs, interfaces, and analytics that must enumerate recipes without traversing the full GMD_RECIPES and FM_FORM_MST relationship structures directly.
Underlying Base Objects
The view is defined over three documented base objects, each accessed through a synonym:
- GMD_RECIPES (SYNONYM) — aliased as R in the view text; supplies the recipe number and recipe status, and is the primary driver of the DISTINCT projection.
- FM_FORM_MST (SYNONYM) — aliased as F; supplies the formula number and formula version through the formula identifier.
- GMD_STATUS (SYNONYM) — aliased as S; provides the status lookup that is joined to the recipe status. This is the object most closely associated with the user's search term gmd_status.
The view joins these objects on the following conditions as documented in the view text:
S.STATUS_CODE = R.RECIPE_STATUS— links the recipe to its status code.R.DELETE_MARK = 0— filters out logically deleted recipes.R.FORMULA_ID = F.FORMULA_ID— links each recipe to its governing formula.
Note that although GMD_STATUS is included in the FROM clause and joined on STATUS_CODE, no column from GMD_STATUS is projected in the SELECT list. Its role is therefore a validation/reference join rather than a source of output columns.
Key Columns
- RECIPE_NO — the recipe number from GMD_RECIPES. This is the primary identifier returned and the column around which the DISTINCT clause operates.
- FORMULA_NO — the formula number from FM_FORM_MST, identifying the formula associated with the recipe.
- FORMULA_VERS — the formula version from FM_FORM_MST, distinguishing revisions of the same formula.
Because only these three columns are exposed, the view presents a compact, three-attribute result set suitable for lookup and validation use cases.
Common Use Cases and Queries
The view is most commonly used to retrieve a clean list of recipes and their formulas for reporting, LOV (List of Values) population, and interface validation. A basic query returns all active, non-deleted recipes:
SELECT RECIPE_NO, FORMULA_NO, FORMULA_VERS FROM APPS.GR_INV_RECIPE_V1;
To restrict results to a specific formula, a WHERE clause on FORMULA_NO is typical:
SELECT RECIPE_NO, FORMULA_NO, FORMULA_VERS FROM APPS.GR_INV_RECIPE_V1 WHERE FORMULA_NO = :p_formula_no;
For integrations that need to confirm recipe-to-formula mappings before posting regulatory or inventory data, the view provides an efficient validation source without requiring direct joins across GMD_RECIPES, FM_FORM_MST, and GMD_STATUS. Purely as a reference point, the inclusion of GMD_STATUS in the view definition reflects the standard practice of validating recipe status against the status master, ensuring that only recipes with a defined status are surfaced.
-
View: GR_INV_RECIPE_V1 12.1.1
View for Getting a distinct Recipe No
APPS.GR_INV_RECIPE_V1·↳ FM_FORM_MST·↳ GMD_RECIPES·↳ GMD_STATUS·Explore GR module →
-
View: GR_INV_RECIPE_V1 12.2.2
View for Getting a distinct Recipe No
APPS.GR_INV_RECIPE_V1·↳ FM_FORM_MST·↳ GMD_RECIPES·↳ GMD_STATUS·Explore GR module →
-
APPS.GMD_QC_E_WIP_SMPEVT_DTLS_V·↳ FM_FORM_MST_B·↳ GMD_OPERATIONS·↳ GMD_RECIPES_B·Explore GMD module →
-
View: GMF_XLA_BATCH_HDR_V 12.2.2
SLA batch header view
APPS.GMF_XLA_BATCH_HDR_V·↳ FM_FORM_MST_B·↳ GMD_RECIPES_B·↳ GMD_RECIPE_VALIDITY_RULES·Explore GMF module →
-
APPS.GMD_QC_E_WIP_SMPEVT_DTLS_V·↳ FM_FORM_MST_B·↳ GMD_OPERATIONS·↳ GMD_RECIPES_B·Explore GMD module →
-
APPS.GMD_QC_E_WIP_SAMPLE_DTLS_V·↳ FM_FORM_MST_B·↳ GMD_OPERATIONS·↳ GMD_RECIPES_B·Explore GMD module →
-
APPS.GMD_QC_E_WIP_SAMPLE_DTLS_V·↳ FM_FORM_MST_B·↳ GMD_OPERATIONS·↳ GMD_RECIPES_B·Explore GMD module →
-
Recipe Validity Rules
APPS.PMITS_RECIPE_VALIDITY_RULE_V·↳ FM_FORM_MST·↳ FM_ROUT_HDR·↳ GEM_LOOKUPS·Explore PMI module →
-
APPS.GMD_QM_E_MATERIAL_SOURCES_V·↳ FM_FORM_MST_B·↳ GMD_RECIPES_B·↳ GMD_SPECIFICATIONS_B·Explore GMD module →
-
View: PMITS_RECIPE_MASTER_V 12.1.1
Recipe Master
-
Recipe Validity Rules
APPS.PMITS_RECIPE_VALIDITY_RULE_V·↳ FM_FORM_MST·↳ FM_ROUT_HDR·↳ GEM_LOOKUPS·Explore PMI module →
-
View: GMF_XLA_BATCH_RSRC_V 12.2.2
SLA batch resources view
APPS.GMF_XLA_BATCH_RSRC_V·↳ CR_RSRC_MST·↳ FM_FORM_MST_B·↳ GMD_RECIPES_B·Explore GMF module →
-
View: GMF_XLA_PM_RSRC_TXNS_V 12.2.2
View for SLA ADR sources from Resource Transactions
APPS.GMF_XLA_PM_RSRC_TXNS_V·↳ CM_CMPT_MST·↳ FND_DATE·↳ FND_MESSAGE·Explore GMF module →
-
View: GMD_COM_SPEC_VRS_VL 12.2.2
View of base columns of all Specification Validity Rules tables
APPS.GMD_COM_SPEC_VRS_VL·↳ GMD_CUSTOMER_SPEC_VRS·↳ GMD_INVENTORY_SPEC_VRS·↳ GMD_MONITORING_SPEC_VRS·Explore GMD module →
-
View for SLA ADR sources from Batch Details
APPS.GMF_XLA_BATCH_DETAILS_V·↳ FM_FORM_MST_B·↳ GMD_RECIPES_B·↳ GMD_RECIPE_VALIDITY_RULES·Explore GMF module →
-
View: GMF_XLA_PM_TXNS_V 12.2.2
View for SLA ADR sources from Batch Transactions
APPS.GMF_XLA_PM_TXNS_V·↳ FND_DATE·↳ FND_MESSAGE·↳ GME_BATCH_HEADER_VW·Explore GMF module →
-
This view is used to generate XML for Recipe Header information in Master Batch Record Generation
APPS.GMD_MBR_RECIPE_HEADER_V1·↳ FM_FORM_MST_VL·↳ FND_DATE·↳ FND_TIMEZONES·Explore GMD module →
-
View: PMITS_RECIPE_MASTER_V 12.2.2
Recipe Master
-
View: GMD_ALL_SPEC_VRS_VL 12.1.1
APPS.GMD_ALL_SPEC_VRS_VL·↳ GMD_CUSTOMER_SPEC_VRS·↳ GMD_INVENTORY_SPEC_VRS·↳ GMD_MONITORING_SPEC_VRS·Explore GMD module →
-
View: GMD_ALL_SPEC_VRS_VL 12.2.2
APPS.GMD_ALL_SPEC_VRS_VL·↳ GMD_CUSTOMER_SPEC_VRS·↳ GMD_INVENTORY_SPEC_VRS·↳ GMD_MONITORING_SPEC_VRS·Explore GMD module →
-
This view gives Information about Spec Validity Rules defined in OPM QC Module
-
View: GMD_COM_SPEC_VRS_VL 12.1.1
View of base columns of all Specification Validity Rules tables
APPS.GMD_COM_SPEC_VRS_VL·↳ GMD_CUSTOMER_SPEC_VRS·↳ GMD_INVENTORY_SPEC_VRS·↳ GMD_MONITORING_SPEC_VRS·Explore GMD module →
-
This view gives Information about Spec Validity Rules defined in OPM QC Module
-
APPS.GMD_QM_E_MATERIAL_SOURCES_V·↳ FM_FORM_MST_B·↳ GMD_RECIPES_B·↳ GMD_SPECIFICATIONS_B·Explore GMD module →
-
View: GMF_XLA_PM_TXNS_V 12.1.1
APPS.GMF_XLA_PM_TXNS_V·↳ FND_DATE·↳ FND_MESSAGE·↳ GME_BATCH_HEADER_VW·Explore GMF module →
-
APPS.GMD_QC_E_ALL_SPEC_VRS_DISP_V·↳ FND_LOOKUP_VALUES_VL·↳ GMD_ALL_SPEC_VRS·Explore GMD module →
-
View: GMF_XLA_PM_RSRC_TXNS_V 12.1.1
APPS.GMF_XLA_PM_RSRC_TXNS_V·↳ CM_CMPT_MST·↳ FND_DATE·↳ FND_MESSAGE·Explore GMF module →
-
APPS.GMD_QC_E_ALL_SPEC_VRS_DISP_V·↳ FND_LOOKUP_VALUES_VL·↳ GMD_ALL_SPEC_VRS·Explore GMD module →
-
This view is used to generate XML for Recipe Header information in Master Batch Record Generation
APPS.GMD_MBR_RECIPE_HEADER_V1·↳ FM_FORM_MST_VL·↳ FND_DATE·↳ FND_TIMEZONES·Explore GMD module →
-
OPM Work-in-Process Specification validity rules
-
OPM Work-in-Process Specification validity rules
-
View: PMITS_QC_SAMPLES_V 12.1.1
This view Provide Sample information
APPS.PMITS_QC_SAMPLES_V·↳ FM_FORM_MST_B·↳ GEM_LOOKUPS·↳ GMD_ALL_SPEC_VRS·Explore PMI module →
-
View: GMD_ERES_RECIPES_VW 12.2.2
APPS.GMD_ERES_RECIPES_VW·↳ FM_FORM_MST·↳ GMD_RECIPES·↳ GMD_ROUTINGS·Explore GMD module →
-
View: GMD_RECIPES_VL 12.2.2
APPS.GMD_RECIPES_VL·↳ GMD_RECIPES_B·↳ GMD_RECIPES_TL·Explore GMD module →
-
View: GMD_ERES_RECIPES_VW 12.1.1
APPS.GMD_ERES_RECIPES_VW·↳ FM_FORM_MST·↳ GMD_RECIPES·↳ GMD_ROUTINGS·Explore GMD module →
-
Stability Study Material Sources
-
Stability Study Material Sources
-
View: GMD_RECIPES_VL 12.1.1
APPS.GMD_RECIPES_VL·↳ GMD_RECIPES_B·↳ GMD_RECIPES_TL·Explore GMD module →
-
Recipe header base table.
-
Recipe header base table.
-
View: PMITS_QC_SAMPLES_V 12.2.2
This view Provide Sample information
APPS.PMITS_QC_SAMPLES_V·↳ FM_FORM_MST_B·↳ FND_GLOBAL·↳ GEM_LOOKUPS·Explore PMI module →
-
View: GME_BATCH_HEADER_VW 12.2.2
Batch Header view
APPS.GME_BATCH_HEADER_VW·↳ FM_FORM_MST·↳ FM_ROUT_HDR·↳ FND_DATE·Explore GME module →
-
View: GME_BATCH_HEADER_VW 12.1.1
Batch Header view
APPS.GME_BATCH_HEADER_VW·↳ FM_FORM_MST·↳ FM_ROUT_HDR·↳ FND_DATE·Explore GME module →
-
VIEW: APPS.GR_INV_RECIPE_V1 12.2.2
-
VIEW: GMD.GMD_RECIPES_B# 12.2.2
-
VIEW: APPS.GR_INV_RECIPE_V1 12.1.1