Results for “gmd_formula_use”
36 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.PMIFV_FORMULA_SUMMARY_V is a read-only security-aware view in the Oracle E-Business Suite Process Manufacturing (OPM) module. It presents a consolidated, denormalized summary of formula master records joined to their effectivity definitions, associated products, customers, and routings. The "PMIFV" prefix identifies it as part of the Process Manufacturing Inventory/Formula family of views, while the "_SUMMARY_V" suffix indicates it is intended as a reporting and integration surface rather than a base transaction entity.
Because the view is defined with a WITH READ ONLY clause, it cannot be used for DML. It is consumed by forms, concurrent programs, BI Publisher reports, and inbound/outbound interfaces that need a single flattened row per formula effectivity without manually reconstructing the multi-table join. The view is particularly notable for resolving code lookups inline via PMI_COST_ANALZ_PACK.GMCA_GET_MEANING, so consumers receive human-readable meanings for the GMD_FORMULA_USE lookup rather than raw codes. Row-level organization security is enforced through PMI_SECURITY_PKG.SHOW_RECORD.
Underlying Base Objects
The view is defined over five synonyms that resolve to OPM base tables, joined through outer joins so that a formula master row survives even when no effectivity, product, customer, or routing match exists:
- FM_FORM_MST (fmaster) — formula master. Filtered by
INACTIVE_IND = 0andDELETE_MARK = 0. - FM_FORM_EFF (effectivity) — formula effectivity/use records, joined on
FORMULA_ID. Filtered byDELETE_MARK = 0. - IC_ITEM_MST (product) — inventory item master, joined on
ITEM_ID. - OP_CUST_MST (customer) — customer master, joined on
CUST_ID. - FM_ROUT_HDR (routing) — routing header, joined on
ROUTING_ID. - SY_ORGN_MST (secorg) — organization master, used in the security subquery.
- PMI_COST_ANALZ_PACK — package supplying
GMCA_GET_MEANINGfor lookup translation. - PMI_SECURITY_PKG — package supplying
SHOW_RECORDfor organization-level row filtering. - FND_PROFILE — referenced by the security package, listed as a documented base object via its profile dependencies.
Key Columns
The view exposes formula-level, effectivity-level, and resolved descriptive attributes:
- FORMULA_NO, FORMULA_VERS, FORMULA_TYPE, FORMULA_ID — formula identifier, version, type, and surrogate key.
- Resolved FORMULA_TYPE meaning — the
SUBSTR(...GMCA_GET_MEANING('GMD_FORMULA_USE', ...),1,80)value that translates the formula use code into a display string. - FORMULA_CLASS, FMCONTROL_CLASS, SCALE_TYPE — classification and scaling attributes.
- FORMULA_DESC1, FORMULA_DESC2 — descriptive text.
- FMEFF_ID, ORGN_CODE, ITEM_ID, ROUTING_ID, CUST_ID, FORMULA_USE — effectivity context, including the organization and its resolved
FORMULA_USEmeaning. - START_DATE, END_DATE — effectivity window.
- INV_MIN_QTY, INV_MAX_QTY, MIN_QTY, MAX_QTY, STD_QTY, ITEM_UM, PREFERENCE — quantity ranges, unit of measure, and preference ranking.
- ITEM_NO, ITEM_DESC1, ITEM_DESC2, CUST_NO, CUST_NAME, ROUTING_NO, ROUTING_VERS, ROUTING_DESC, ROUTING_CLASS, ROUTING_QTY — resolved descriptive columns from product, customer, and routing.
- CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY — audit columns from the formula master.
Common Use Cases and Queries
The view is typically queried when a user searches for gmd_formula_use, because the FORMULA_USE code and its translated meaning are the primary lookup dimension for formula applicability (for example, production, costing, or quality usage). A standard query lists active formulas with their effectivity and product context:
SELECT FORMULA_NO, FORMULA_VERS, FORMULA_DESC1, ORGN_CODE, ITEM_NO, FORMULA_USE, START_DATE, END_DATE FROM APPS.PMIFV_FORMULA_SUMMARY_V WHERE ORGN_CODE = :org AND SYSDATE BETWEEN START_DATE AND NVL(END_DATE, SYSDATE);SELECT FORMULA_ID, FORMULA_NO, CUST_NO, ROUTING_NO, STD_QTY, ITEM_UM FROM APPS.PMIFV_FORMULA_SUMMARY_V WHERE FORMULA_NO = :formula;- Reporting formula effectivity by customer or routing, since those combinations drive plant scheduling and cost rollups.
- Feeding interface or migration extracts where the resolved meanings are required inline rather than through a secondary lookup query.
Because organization security is applied via PMI_SECURITY_PKG.SHOW_RECORD, results are automatically constrained to the organizations the connected user is authorized to see, making the view suitable for direct exposure in self-service reports without additional security predicates.
-
Lookup Type: GMD_FORMULA_USE 12.2.2
Formula Use Lookup Values
-
Lookup Type: GMD_FORMULA_USE 12.1.1
Formula Use Lookup Values
-
The product and effectivity information for a formula including routing information. This does not contain ingredient information.
APPS.PMIFV_FORMULA_SUMMARY_V·↳ FM_FORM_EFF·↳ FM_FORM_MST·↳ FM_ROUT_HDR·Explore PMI module →
-
The product and effectivity information for a formula including routing information. This does not contain ingredient information.
APPS.PMIFV_FORMULA_SUMMARY_V·↳ FM_FORM_EFF·↳ FM_FORM_MST·↳ FM_ROUT_HDR·Explore PMI module →
-
View: PMIBV_FORMULA_COST_V 12.2.2
Costing Information for product by formula
APPS.PMIBV_FORMULA_COST_V·↳ CM_CLDR_DTL·↳ CM_CLDR_HDR·↳ CM_CMPT_DTL·Explore PMI module →
-
View: PMIFV_FORMULA_COST_V 12.2.2
Costing Information for product by formula
APPS.PMIFV_FORMULA_COST_V·↳ CM_CLDR_DTL·↳ CM_CLDR_HDR·↳ CM_CMPT_DTL·Explore PMI module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
Recipe Validity Rules
APPS.PMITS_RECIPE_VALIDITY_RULE_V·↳ FM_FORM_MST·↳ FM_ROUT_HDR·↳ GEM_LOOKUPS·Explore PMI module →
-
View: PMIBV_FORMULA_COST_V 12.1.1
Costing Information for product by formula
APPS.PMIBV_FORMULA_COST_V·↳ CM_CLDR_DTL·↳ CM_CLDR_HDR·↳ CM_CMPT_DTL·Explore PMI module →
-
View: PMIFV_FORMULA_COST_V 12.1.1
Costing Information for product by formula
APPS.PMIFV_FORMULA_COST_V·↳ CM_CLDR_DTL·↳ CM_CLDR_HDR·↳ CM_CMPT_DTL·Explore PMI module →
-
Recipe Validity Rules
APPS.PMITS_RECIPE_VALIDITY_RULE_V·↳ FM_FORM_MST·↳ FM_ROUT_HDR·↳ GEM_LOOKUPS·Explore PMI module →
-
View: PMIFV_PRODUCTFORMULA_V 12.1.1
The product and ingredient information for a formula. This does not contain information on effectivity, routing or coproducts.
APPS.PMIFV_PRODUCTFORMULA_V·↳ FM_FORM_EFF·↳ FM_FORM_MST·↳ FM_MATL_DTL·Explore PMI module →
-
View: PMIFV_PRODUCTFORMULA_V 12.2.2
The product and ingredient information for a formula. This does not contain information on effectivity, routing or coproducts.
APPS.PMIFV_PRODUCTFORMULA_V·↳ FM_FORM_EFF·↳ FM_FORM_MST·↳ FM_MATL_DTL·Explore PMI module →
-
Formula detail with Onhanad inventory of the Ingredients
APPS.PMIFV_PRODUCTFORMULA_INV_V·↳ FM_FORM_EFF·↳ FM_FORM_MST·↳ FM_MATL_DTL·Explore PMI module →
-
Formula detail with Onhanad inventory of the Ingredients
APPS.PMIFV_PRODUCTFORMULA_INV_V·↳ FM_FORM_EFF·↳ FM_FORM_MST·↳ FM_MATL_DTL·Explore PMI module →