Search Results internal_external_meaning




Overview
Explore in AI Chat

Overview

APPS.PER_ORGANIZATION_UNITS_V is a supplementary view owned by the APPS schema and registered in FND Design Data as PER.PER_ORGANIZATION_UNITS_V. It exposes organization unit records maintained by Oracle Human Resources and presents them in a denormalized, form-friendly structure that simplifies coding against the underlying HR tables. Because it is documented as a "supplementary view used to simplify forms coding," Oracle explicitly warns that it should not be used to query or alter data directly; its definition may change dramatically across minor or major releases. In Oracle EBS 12.1.1 and 12.2.2 the view remains VALID and is typically consumed by Oracle Forms, concurrent programs, and reporting layers that need a single-row-per-organization-unit projection without joining the base HR tables manually.

Underlying Base Objects

According to the documented 12.2.2 metadata, PER_ORGANIZATION_UNITS_V is defined over the following objects:

  • HR_ALL_ORGANIZATION_UNITS (synonym) — the primary table holding organization unit rows and their effective-dated attributes.
  • HR_ALL_ORGANIZATION_UNITS_TL (synonym) — the translation table supplying language-specific NAME values.
  • HR_ORGANIZATION_INFORMATION (synonym) — stores additional descriptive information, including internal address line values, keyed by organization and information type.
  • HR_LOOKUPS (view) — resolves lookup codes such as INTERNAL_EXTERNAL_FLAG into their displayed meanings.
  • HR_API (package) — the HR API package that governs validation and access logic for organization unit data.

The view therefore joins the base organization unit record with its translated name, organization information segments, and lookup-derived meanings to deliver a single flattened result set. This design means the view is not a simple table synonym; it depends on multiple synonyms, one view, and one PL/SQL package.

Key Columns

The view exposes roughly 45 columns. Principal identifiers include ORGANIZATION_ID (the primary key of the organization unit), BUSINESS_GROUP_ID, ROW_ID, LOCATION_ID, COST_ALLOCATION_KEYFLEX_ID, and SOFT_CODING_KEYFLEX_ID. Effective dating is handled by DATE_FROM and DATE_TO. Descriptive columns include NAME (VARCHAR2 240), COMMENTS (CLOB), INTERNAL_ADDRESS_LINE (VARCHAR2 80), TYPE, and ORGANIZATION_TYPE.

The columns most relevant to the search term internal_external_meaning are:

  • INTERNAL_EXTERNAL_FLAG (VARCHAR2 30) — the stored lookup code indicating whether the organization unit is classified as internal or external.
  • INTERNAL_EXTERNAL_MEANING (VARCHAR2 80) — the translated display value for that flag, derived from HR_LOOKUPS. This is the "meaning" counterpart to the code, which is why it is frequently referenced in forms and reports.

Standard WHO columns are also present: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, plus REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, ATTRIBUTE_CATEGORY, and ATTRIBUTE1 through ATTRIBUTE20 (each VARCHAR2 150).

Common Use Cases and Queries

Typical scenarios include organization hierarchy reports, HR forms personalizations, and integrations that require the human-readable internal/external designation rather than the raw lookup code. A representative query retrieves current organization units with their meanings:

  • SELECT organization_id, name, internal_external_flag, internal_external_meaning, organization_type, date_from, date_to FROM apps.per_organization_units_v WHERE business_group_id = :p_bg_id AND TRUNC(SYSDATE) BETWEEN date_from AND NVL(date_to, TRUNC(SYSDATE));
  • SELECT organization_id, name, internal_address_line FROM apps.per_organization_units_v WHERE internal_external_meaning = 'Internal' ORDER BY name;

Because the object is a forms-supporting view, Oracle recommends that production reporting and integration code query the documented base tables (HR_ALL_ORGANIZATION_UNITS and HR_ALL_ORGANIZATION_UNITS_TL) plus HR_LOOKUPS instead, reserving the view for reference and diagnostic purposes only.