Results for “routing_qty”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The PMITS_ROUTING_MASTER_V view is an Oracle E-Business Suite database object owned by the APPS schema and classified under the PMI – Process Manufacturing Intelligence product family. It exposes a consolidated, security-filtered presentation of Process Manufacturing routing master data drawn from the GMD (Process Manufacturing) tables. In EBS 12.1.1 and 12.2.2 the view serves as the reporting and integration layer through which routing definitions, their class assignments, ownership, status, and effective dating are surfaced to downstream analytics, concurrent programs, and custom extensions.
The view is documented as VALID and is described in ETRM metadata as the GMD Routing Master View. It is commonly referenced in the context of searches for routing class descriptors (for example, the fm_rout_cls code, which corresponds to the FM_ROUT_CLS base table joined within the view). The view is not a base table; it is a denormalized read-only construct intended for query, not for DML.
Underlying Base Objects
The view text joins several Process Manufacturing and EBS foundation objects:
- GMD_ROUTINGS_VL – the primary routing source, supplying routing identifiers, numbers, versions, quantities, status, description, unit of measure, effective dates, owner, and project.
- FND_USER – resolves
OWNER_IDto a user name and description. - FM_ROUT_CLS – provides the routing class description (this is the object referenced by the search term
fm_rout_cls). - SY_ORGN_MST – validates the owning organization code.
- GMD_STATUS – supplies the routing status meaning.
- GEM_LOOKUPS – resolves the
INACTIVE_INDflag via theGME_YES_NOlookup type.
Access is further constrained by PMI_SECURITY_PKG.SHOW_RECORD(RV.OWNER_ORGN_CODE), which enforces organization-level security so that users only see routings for organizations they are authorized to view. The ETRM 12.2.2 metadata lists DUAL as a referenced synonym, reflecting the view's evaluation context rather than a data source.
Key Columns
- ROUTING_ID / ROUTING_NO / ROUTING_VERS – primary routing identity, number, and version.
- ROUTING_CLASS / ROUTING_CLASS_DESC – class code and its descriptive text from FM_ROUT_CLS.
- ROUTING_QTY / ITEM_UM – routing quantity and unit of measure.
- ROUTING_STATUS / STATUS – status code and translated meaning.
- ROUTING_DESC – routing description.
- INACTIVE_IND – lookup meaning indicating inactive routing.
- EFFECTIVE_START_DATE / EFFECTIVE_END_DATE – validity window.
- OWNER_ID / OWNER / OWNER_ORGN_CODE – owning user and organization.
- PROJECT_ID / PROCESS_LOSS – project association and expected process loss.
- DELETE_MARK / TEXT_CODE – soft-delete flag and descriptive text reference.
Common Use Cases and Queries
Typical uses include routing master extracts for BI Publisher reports, integration feeds to MES or planning systems, and ad hoc analysis of routing classes. A representative query filtering by routing class is:
SELECT routing_no, routing_vers, routing_class,
routing_class_desc, status, owner_orgn_code
FROM apps.pmits_routing_master_v
WHERE routing_class = :p_class
AND inactive_ind = 'No'
AND SYSDATE BETWEEN effective_start_date AND NVL(effective_end_date, SYSDATE);
Because the view enforces PMI security internally, queries automatically respect organizational access without additional WHERE clauses. It should be treated as read-only; DML must target the underlying GMD and FM tables.
-
View: PMITS_ROUTING_MASTER_V 12.2.2
GMD Routing Master View
-
Ledger of OPM Costing detail information produced during Cost Rollup processing.
APPS.PMIBV_STANDARD_COST_LEDGER_V·↳ CM_SCST_LED·Explore PMI module →
-
Standard Costs Ledger. Rows are created during the cost rollup process. It serves the purpose of a ledger on the performed cost calculations of each product. Formula and routing information is maintained within this table. Has a detailed
-
The prod and effectivity info for a formula incl. routing info. This does'nt contain ingredient info.
APPS.PMIBV_FORMULA_SUMMARY_V·↳ FM_FORM_EFF·↳ FM_FORM_MST·↳ FM_ROUT_HDR·Explore PMI module →
-
View: GMD_ROUTINGS_VL 12.1.1
View for Routing header Base and translation tables
APPS.GMD_ROUTINGS_VL·↳ GMD_ROUTINGS_B·↳ GMD_ROUTINGS_TL·Explore GMD module →
-
Ledger of OPM Costing detail information produced during Cost Rollup processing.
APPS.PMIBV_STANDARD_COST_LEDGER_V·↳ CM_SCST_LED·Explore PMI module →
-
View: PMITS_ROUTING_MASTER_V 12.1.1
GMD Routing Master View
-
Ledger of Process Manufacturing Costing detail information produced during Cost Rollup processing.
APPS.PMIFV_STANDARD_COST_LEDGER_V·↳ CM_SCST_LED·↳ IC_ITEM_MST·↳ IC_WHSE_MST·Explore PMI module →
-
The prod and effectivity info for a formula incl. routing info. This does'nt contain ingredient info.
APPS.PMIBV_FORMULA_SUMMARY_V·↳ FM_FORM_EFF·↳ FM_FORM_MST·↳ FM_ROUT_HDR·Explore PMI module →
-
Ledger of Process Manufacturing Costing detail information produced during Cost Rollup processing.
APPS.PMIFV_STANDARD_COST_LEDGER_V·↳ CM_SCST_LED·↳ IC_ITEM_MST·↳ IC_WHSE_MST·Explore PMI module →
-
Standard Costs Ledger. Rows are created during the cost rollup process. It serves the purpose of a ledger on the performed cost calculations of each product. Formula and routing information is maintained within this table. Has a detailed
-
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 →
-
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 →
-
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 →
-
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: GMD_ROUTINGS_VL 12.2.2
View for Routing header Base and translation tables
APPS.GMD_ROUTINGS_VL·↳ GMD_ROUTINGS_B·↳ GMD_ROUTINGS_TL·Explore GMD module →
-
Routing header base table.
-
Routing header base table.
-
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 →
-
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: 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 →
-
VIEW: GMF.CM_SCST_LED# 12.2.2
-
VIEW: GMD.GMD_ROUTINGS_B# 12.2.2
-
VIEW: GMF.CM_SCST_LED# 12.2.2
-
VIEW: GMD.GMD_ROUTINGS_B# 12.2.2
-
TABLE: GMF.CM_SCST_LED 12.2.2
-
VIEW: APPS.GMD_ROUTINGS_VL 12.2.2
-
TABLE: GMF.CM_SCST_LED 12.1.1
-
VIEW: APPS.GMD_ROUTINGS_VL 12.1.1
-
TABLE: GMD.GMD_ROUTINGS_B 12.2.2
-
TABLE: GMD.GMD_ROUTINGS_B 12.1.1