Search Results mtl_param

Overview

PMITS_WAREHOUSE_MASTER_V is a view owned by the APPS schema in Oracle E-Business Suite, defined for the Process Manufacturing Intelligence (PMI) product family. In ETRM 12.2.2 the object is registered with a VALID status, while the PMI module itself is documented as obsolete. The view functions as a consolidated warehouse master reference for PMI reporting and integration, presenting physical warehouse attributes from Process Manufacturing alongside decoded lookup meanings and the associated inventory organization code.

Because it joins base records to GEM_LOOKUPS translations and applies a row-level security predicate, the view is not a simple projection. It is intended primarily as a read-only reporting and data-extraction interface, exposing the same warehouse identity that downstream PMI analytics, dashboards, and interfaces expect, without requiring the consumer to re-implement lookup decoding or organization resolution.

Underlying Base Objects

The view is defined over four documented base objects:

• IC_WHSE_MST (synonym) — the warehouse master source, aliased as WHSE, supplying all primary warehouse attributes.
• MTL_PARAMETERS (synonym) — aliased as MTL_PARAM, joined on MTL_ORGANIZATION_ID = ORGANIZATION_ID to derive the organization code.
• GEM_LOOKUPS (view) — used twice, as LOCT_CTL_LKUP and CONSIGN_IND_LKUP, to decode the LOCT_CTL and CONSIGN_IND coded values.
• PMI_SECURITY_PKG (package) — invoked in the WHERE clause through PMI_SECURITY_PKG.SHOW_RECORD(WHSE.ORGN_CODE), which must return 'TRUE' for a warehouse row to be visible.

The joins are inner joins on lookup type and code, and the security function is evaluated per organization code, so a warehouse is returned only when it has a matching organization, valid lookup codes for both decoded fields, and passes the PMI security check.

Key Columns

The view exposes identifiers, decoded values, warehouse characteristics, audit columns, staging flags, and organization references:

• WHSE_CODE, WHSE_NAME, ORGN_CODE — warehouse code, descriptive name, and the operating organization code used by the security predicate.
• LOCT_CTL, LOCT_CTL_DISP — the stored location-control code and its decoded meaning from the LOCATION_CONTROL lookup type. CONSIGN_IND, CONSIGN_IND_DISP similarly pair the consignment code with its CONSIGNMENT lookup meaning.
• ADDR_ID, REGION_CODE, WHSE_CLASS, WHSE_CONTACT, WHSE_PHONE, TAXLOC_CODE — address reference, region, classification, contact, telephone, and tax location.
• INGREDIENT_STAGE, PRODUCT_STAGE, RECV_STAGE, SHIP_STAGE — warehouse staging designations for ingredient, product, receiving, and shipping operations.
• MTL_ORGANIZATION_ID, MTL_ORGANIZATION_CODE — the inventory organization identifier and its code as resolved through MTL_PARAMETERS.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, DELETE_MARK, TEXT_CODE — standard audit and soft-delete tracking columns inherited from IC_WHSE_MST.

Note that the view text selects WHSE.LOCT_CTL and WHSE.CONSIGN_IND (not LOCT_CTL_DISP directly); the displayed meanings arrive through the aliased lookup meanings, which the documented column list labels LOCT_CTL_DISP and CONSIGN_IND_DISP.

Common Use Cases and Queries

Typical uses include validating warehouse setup, reporting decoded location-control and consignment attributes, and mapping warehouses to inventory organizations for PMI extracts. Because of the security predicate, results are automatically filtered to the organizations visible to the executing user.

List active warehouses with decoded attributes:

SELECT whse_code, whse_name, orgn_code, loct_ctl_disp, consign_ind_disp, mtl_organization_code
FROM apps.pmits_warehouse_master_v
WHERE delete_mark = 0
ORDER BY orgn_code, whse_code;

Find staging-configured warehouses in a given organization:

SELECT whse_code, whse_name, ingredient_stage, product_stage, recv_stage, ship_stage
FROM apps.pmits_warehouse_master_v
WHERE mtl_organization_code = :org_code
AND delete_mark = 0;

Join to inventory organizations for reconciliation:

SELECT v.whse_code, v.whse_name, v.mtl_organization_code, v.whse_class, v.taxloc_code
FROM apps.pmits_warehouse_master_v v
WHERE v.loct_ctl_disp = :location_control
ORDER BY v.mtl_organization_code;

Given the obsolete PMI classification, integrations should confirm continued object availability on the target release before embedding this view in long-term interfaces.