Search Results mtl_param

Overview

APPS.PMITS_WAREHOUSE_MASTER_V is a reporting view in the Oracle E-Business Suite Process Manufacturing (OPM) module. It presents a denormalized, security-filtered list of warehouse master records, combining attributes stored in the OPM warehouse master table with descriptive meaning text resolved from the Process Manufacturing lookups. In Oracle EBS 12.1.1 and 12.2.2 the view is owned by the APPS schema and is intended primarily for reporting, inquiry, and integration extracts rather than for transactional data entry.

The view exposes both the raw lookup codes and their human-readable meanings for the location control and consignment indicators, and it augments each warehouse row with the inventory organization code from Oracle Inventory. It also applies row-level security through PMI_SECURITY_PKG.SHOW_RECORD, so a user querying the view sees only warehouses whose operating organization code is authorized for that user's security profile. The term "location_control" in the user's search maps directly to the LOCT_CTL column and its associated LOCATION_CONTROL lookup type, which is the mechanism the view uses to classify how warehouse locations are controlled.

Underlying Base Objects

The view is defined over four documented objects:

• IC_WHSE_MST (synonym) — the OPM warehouse master, aliased WHSE, which supplies the core warehouse attributes such as WHSE_CODE, WHSE_NAME, ORGN_CODE, LOCT_CTL, CONSIGN_IND, addresses, stages, and audit columns.
• MTL_PARAMETERS (synonym) — Oracle Inventory organization parameters, aliased MTL_PARAM, joined on MTL_ORGANIZATION_ID to provide the ORGANIZATION_CODE.
• GEM_LOOKUPS (view) — the Process Manufacturing lookup source, used twice: LOCT_CTL_LKUP for lookup type LOCATION_CONTROL and CONSIGN_IND_LKUP for lookup type CONSIGNMENT, to return the MEANING values.
• PMI_SECURITY_PKG (package) — supplies the SHOW_RECORD function called in the WHERE clause to enforce organization-level security.

Joins are equijoins on MTL_ORGANIZATION_ID, LOCT_CTL, and CONSIGN_IND. Because IC_WHSE_MST and MTL_PARAMETERS are accessed via synonyms, the view resolves to the underlying OPM and Inventory base tables at runtime.

Key Columns

• WHSE_CODE, WHSE_NAME — warehouse identifier and description.
• ORGN_CODE — the OPM operating organization used by the security filter and the key join to the location control lookup.
• LOCT_CTL and its MEANING — the location control code and its translated description derived from lookup type LOCATION_CONTROL; this is the column most relevant to location control reporting.
• CONSIGN_IND and its MEANING — consignment indicator code and description from lookup type CONSIGNMENT.
• MTL_ORGANIZATION_ID, ORGANIZATION_CODE — Inventory organization identifier and code.
• ADDR_ID, REGION_CODE, WHSE_CLASS, WHSE_CONTACT, WHSE_PHONE, TAXLOC_CODE — warehouse address and classification attributes.
• INGREDIENT_STAGE, PRODUCT_STAGE, RECV_STAGE, SHIP_STAGE — warehouse staging designations.
• DELETE_MARK, TEXT_CODE, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — audit and lifecycle columns.

Common Use Cases and Queries

Typical uses include warehouse master listings, location control analysis, consignment warehouse reporting, and feeds into downstream systems. The following query lists warehouses by location control meaning:

• SELECT whse_code, whse_name, orgn_code, loct_ctl, meaning FROM apps.pmits_warehouse_master_v WHERE meaning = 'Warehouse' ORDER BY whse_code;

To identify consignment warehouses for a specific inventory organization:

• SELECT w.whse_code, w.whse_name, w.organization_code FROM apps.pmits_warehouse_master_v w WHERE w.consign_ind = 'Y' AND w.organization_code = 'M1';

Because security is applied inside the view definition, no additional organization predicate is required for authorized users; however, for performance in high-volume extracts, filtering on ORGN_CODE or MTL_ORGANIZATION_ID is recommended.