Search Results pn_location_name




Overview
Explore in AI Chat

Overview

APPS.MTL_EAM_ASSET_NUM_INTERFACE_V is a reporting and validation view over the Enterprise Asset Management (EAM) asset numbering interface in Oracle E-Business Suite 12.1.1 and 12.2.2. The underlying interface table MTL_EAM_ASSET_NUM_INTERFACE stores staged asset records before they are processed into EAM asset definitions. The view decorates that staging data with descriptive values drawn from master and reference tables, so that pending rows can be reviewed, corrected, and diagnosed without manual joins.

The view resolves lookup codes to their meanings (process flag, import mode, import scope, asset criticality), derives the organization code where it is not supplied on the interface row, and — most relevant to the search term "pn_location_name" — exposes the physical location alias and code associated with the staged asset. It is read by concurrent processing, by correction forms, and by diagnostic reports that monitor import batches.

Underlying Base Objects

The view is defined over MTL_EAM_ASSET_NUM_INTERFACE (the driving staging table) joined to PN_LOCATIONS_ALL, BOM_DEPARTMENTS, MFG_LOOKUPS (aliased four times), MTL_PARAMETERS, and MTL_EAM_LOCATIONS. Documented base objects also include the EAM_COMMON_UTILITIES_PVT package, which supplies resolution logic used by the view's decoding expressions.

  • MTL_EAM_ASSET_NUM_INTERFACE (MEANI) — the primary source; the WHERE clause restricts rows to those with process_flag 'P' or equivalent pending-state indicators.
  • PN_LOCATIONS_ALL (PL) — joined on pn_location_id to return location_alias as pn_location_name and location_code as pn_location_code.
  • MFG_LOOKUPS (ML, ML2, ML3, ML4) — translate process_flag, asset_criticality_code, import_mode, and import_scope into their display meanings.
  • BOM_DEPARTMENTS (BD) — resolves owning_department_id into owning_department_code.
  • MTL_PARAMETERS (MP) — supplies organization_code when the interface row carries none.
  • MTL_EAM_LOCATIONS (MEL) — supplies the concatenated location_codes for the EAM location when eam_location_id is present.

Key Columns

  • pn_location_name — the location alias from PN_LOCATIONS_ALL, presented as the human-readable name of the physical location tied to pn_location_id.
  • pn_location_code and pn_location_id — the code and surrogate key for the same physical location.
  • eam_location_id and location_codes — the EAM location and its concatenated code path, with the decode preferring interface-supplied codes when present.
  • interface_group_id, interface_header_id, batch_id, batch_name — batch and grouping identifiers used to track a load run.
  • inventory_item_id, serial_number, instance_number — the asset's item and serial identity.
  • parent_inventory_item_id, parent_serial_number, parent_instance_number — parent/component hierarchy for the staged asset.
  • process_flag / process_flag_code — raw flag and its lookup meaning, governing whether the row is processed.
  • asset_criticality_code, owning_department_code, organization_code — resolved descriptive values, each falling back to the raw code where the foreign key is null.
  • import_mode_code, import_scope_code — decoded import behavior attributes.
  • error_code, error_message — validation diagnostics written back after a loading attempt.
  • Audit columns — creation_date, created_by, last_update_date, last_updated_by, request_id, program_id.

Common Use Cases and Queries

Typical usage includes confirming that staged rows reference valid physical locations before processing, and generating correction reports for failed batches.

  • Locate assets staged against a given physical location by name or code.
  • Review unprocessed rows and their validation errors for a batch.
  • Reconcile organization and department values against master data.

Sample query:

  • SELECT interface_header_id, batch_name, serial_number, pn_location_name, pn_location_code, organization_code, process_flag_code, error_message FROM apps.mtl_eam_asset_num_interface_v WHERE pn_location_name LIKE 'PLANT%' ORDER BY batch_name, serial_number;