Search Results hr_organization_units_v

Overview

ICX_HR_ORGS_LOV_V is a database view owned by the APPS schema in Oracle E-Business Suite. It is delivered as part of the ICX product family, which corresponds to Oracle iProcurement. The view is documented with the status VALID in ETRM metadata and is explicitly described as Obsolete. This designation indicates that Oracle no longer recommends the view for new development, and that functional coverage has been superseded by other, supported organization list-of-values mechanisms within iProcurement and the broader Human Resources (HR) security framework.

Despite its obsolete status, the view remains present in many 12.1.1 and 12.2.2 environments, largely because legacy customizations, personalizations, and third-party integrations may still reference it. It presents a simplified, flattened projection of organization unit data intended for list-of-values (LOV) display within iProcurement requisitioning flows, where users select a shipping or delivering organization. The view exposes a small, denormalized set of attributes suited to LOV presentation rather than to transactional update. The user query term "organization_type" maps directly to one of the columns exposed by this view, confirming its relevance to organization classification lookups.

Underlying Base Objects

The documented view text defines ICX_HR_ORGS_LOV_V as a simple projection over HR_ORGANIZATION_UNITS_V, selecting NAME, TOWN_OR_CITY, COUNTRY, ORGANIZATION_ID, and ORGANIZATION_TYPE. In the documented 12.2.2 metadata, the referenced base objects are HR_ORGANIZATION_UNITS_V (VIEW), HR_API (PACKAGE), HR_GENERAL (PACKAGE), and HR_SECURITY (PACKAGE).

• HR_ORGANIZATION_UNITS_V — the immediate source view supplying all projected columns. It is the primary dependency.
• HR_API — the HR public API package, referenced because HR_ORGANIZATION_UNITS_V resolves organization attributes through API-driven logic.
• HR_GENERAL — supplies general HR utility functions used in resolving the base view's row set and attribute derivation.
• HR_SECURITY — enforces organization-level security, ensuring that the rows visible through the LOV respect the operating unit and security profile of the session.

Because ICX_HR_ORGS_LOV_V contains no joins or filters of its own, its behavior and performance profile are effectively those of HR_ORGANIZATION_UNITS_V, including HR security enforcement.

Key Columns

• ORGANIZATION_ID — the unique surrogate key for the organization unit. This is the value typically returned to a calling form or concurrent program.
• NAME — the descriptive name of the organization unit, used as the primary LOV display field.
• ORGANIZATION_TYPE — the classification of the organization (for example, inventory organization, internal requisition organization, or operating unit), relevant to filtering which organizations appear for selection.
• TOWN_OR_CITY — the location city associated with the organization, exposed in the view text as TOWN_OR_CITY.
• CITY — documented in the view column listing; corresponds to the town/city attribute surfaced through the base view.
• COUNTRY — the country of the organization address, supporting display and filtering by geography.

Common Use Cases and Queries

The principal use case is populating an organization LOV in iProcurement requisitioning or related ICX flows. A typical query returns organizations and their types for a given name pattern:

SELECT organization_id, name, organization_type, town_or_city, country
FROM apps.icx_hr_orgs_lov_v
WHERE UPPER(name) LIKE UPPER(:p_name)||'%';

An organization-type-specific lookup, matching the user's search term, filters directly on the ORGANIZATION_TYPE column:

SELECT organization_id, name
FROM apps.icx_hr_orgs_lov_v
WHERE organization_type = :p_org_type
ORDER BY name;

Because the view is obsolete, new development should reference supported alternatives such as HR_ORGANIZATION_UNITS_V directly, or the current iProcurement LOV views. Existing queries should be reviewed before upgrades to 12.2.2, where the obsolete view may be retained only for backward compatibility.