Search Results location_control




Overview
Explore in AI Chat

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:

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

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.