Search Results inv_organization_name_v




Overview
Explore in AI Chat

Overview

INV_ORGANIZATION_NAME_V is a seeded, read-only database view owned by the APPS schema and shipped as part of the Oracle Inventory (INV) product family. In Oracle E-Business Suite 12.1.1 and 12.2.2, the view status is documented as VALID, confirming that it compiles cleanly against the EBS data model and can be referenced reliably by concurrent programs, reports, personalizations, and integration interfaces.

The view presents a single, denormalized row per inventory organization, joining organization-units data from Oracle HRMS with inventory configuration data from the Inventory module. Its principal purpose is to expose the organization name, organization code, and the enable/disable dates of the organization in a form that is directly consumable by Inventory-related reporting and interfaces without requiring callers to reconstruct the underlying HRMS classification joins themselves.

The column that most directly answers the user's search term is USER_DEFINITION_ENABLE_DATE. This is an alias, not a stored column: the view text maps it to HOU.DATE_FROM on HR_ORGANIZATION_UNITS. Search engines and SQL tools frequently index this alias because it appears in the view definition, which is why queries for "user_definition_enable_date" surface this object. Consequently, the value returned reflects the organization unit's effective start date in HRMS, not any attribute literally named "user definition enable date" in a base table.

Underlying Base Objects

The documented ETRM 12.2.2 metadata lists the following referenced base objects: HR_GENERAL (PACKAGE), HR_ORGANIZATION_INFORMATION (SYNONYM), HR_ORGANIZATION_UNITS (VIEW), HR_SECURITY (PACKAGE), and MTL_PARAMETERS (SYNONYM). The view text itself joins HR_ORGANIZATION_UNITS HOU, HR_ORGANIZATION_INFORMATION HOI1, and MTL_PARAMETERS MP.

  • HR_ORGANIZATION_UNITS supplies the organization identity, name, business group, and the DATE_FROM and DATE_TO values aliased as USER_DEFINITION_ENABLE_DATE and DISABLE_DATE.
  • HR_ORGANIZATION_INFORMATION provides the classification rows that determine whether the organization is an inventory organization, constrained by ORG_INFORMATION_CONTEXT = 'CLASS' together with ORG_INFORMATION1 = 'INV' and ORG_INFORMATION2 = 'Y'.
  • MTL_PARAMETERS supplies the inventory organization code (ORGANIZATION_CODE) and ties the HRMS organization to an Inventory-parameterized organization.
  • HR_GENERAL and HR_SECURITY are HRMS packages referenced through the underlying HR_ORGANIZATION_UNITS view, supplying business-group derivation and security predicates.

Because the view depends on HRMS security packages, the rows visible to a session may be filtered by the HR security profile of the connected user.

Key Columns

  • ORGANIZATION_ID — The inventory organization identifier, derived from HR_ORGANIZATION_UNITS.ORGANIZATION_ID. This is the primary join key to MTL_PARAMETERS, MTL_SYSTEM_ITEMS, and most Inventory and Order Management tables.
  • BUSINESS_GROUP_ID — The HR business group to which the organization belongs, used for multi-organization and legal-entity scoping.
  • ORGANIZATION_CODE — The short organization code from MTL_PARAMETERS, commonly used in reports, labels, and interfaces in preference to the numeric ID.
  • ORGANIZATION_NAME — The descriptive name of the organization unit as maintained in HRMS.
  • USER_DEFINITION_ENABLE_DATE — Aliased from HOU.DATE_FROM; the date on which the organization becomes effective in HRMS. This is the column returned when the alias is queried directly.
  • DISABLE_DATE — Aliased from HOU.DATE_TO; the date on which the organization ceases to be effective, or NULL if still active.

Common Use Cases and Queries

The view supports organization validation, LOV lookups, and cross-module reporting that requires both the inventory organization code and the effective dating of the organization. A typical query retrieving all active inventory organizations is:

SELECT organization_id, organization_code, organization_name, user_definition_enable_date, disable_date FROM apps.inv_organization_name_v WHERE disable_date IS NULL OR disable_date > SYSDATE ORDER BY organization_code;

A targeted lookup for a single organization by code or by the enable date alias is equally common:

SELECT organization_id, organization_code, user_definition_enable_date FROM apps.inv_organization_name_v WHERE organization_code = 'M1';

Integration scenarios frequently use the view as the master list of inventory organizations when staging data into external planning, warehouse, or WMS systems, using ORGANIZATION_CODE as the natural key and the enable/disable dates to determine effective periods. Because the view is not keyed solely on MTL_PARAMETERS, organizations present in HRMS but not classified as inventory organizations are excluded by the 'INV'/'Y' classification predicates.