Search Results internal_address_line




Overview
Explore in AI Chat

Overview

The APPS.HR_FR_PENSION_PRV_GRP_V view is a French localizations (FR) reporting and integration object within Oracle E-Business Suite, available in both 12.1.1 and 12.2.2. It presents a consolidated, de-normalized listing of French pension providers and pension groups by unioning two distinct source views into a single result set. Its primary role is to supply downstream Oracle EBS components — particularly Oracle HRMS French statutory reporting, payroll processes, and external integrations — with a unified record set describing the organizations and groups involved in French pension arrangements.

The user search term internal_address_line maps directly to a column exposed by this view. INTERNAL_ADDRESS_LINE carries the internal (intra-organization) address information associated with the pension provider or group, and is projected from both branches of the UNION so that address detail is available regardless of whether a record originates as a provider or as a group.

Underlying Base Objects

Per the documented ETRM metadata for 12.2.2, the view is owned by APPS and is defined over the following referenced base objects:

The view text is a straight UNION (not UNION ALL) of two SELECT statements. The first selects from HR_FR_PENSION_PROVIDERS_V; the second from HR_FR_PENSION_GROUPS_V. Because the two branches are joined by UNION, duplicate rows across providers and groups are eliminated, and the column lists must be positionally aligned. In the group branch, CODE and TYPE are projected as literal NULL, since pension groups do not carry provider-specific code or type values.

Key Columns

  • ORGANIZATION_ID — organization identifier of the provider or group.
  • BUSINESS_GROUP_ID — the business group to which the record belongs, enabling multi-organization filtering.
  • NAME — name of the pension provider or pension group.
  • DATE_FROM / DATE_TO — effective start and end dates bounding the record's validity.
  • INTERNAL_ADDRESS_LINE — internal address line for the provider or group; the column matching the user search.
  • LOCATION_ID — identifier of the associated location.
  • LOCATION_CODE — code of the associated location.
  • CODE — provider code; NULL for group records.
  • TYPE — provider type; NULL for group records.
  • ENABLED — enabled flag indicating whether the record is currently active.

Common Use Cases and Queries

Typical usage includes French pension reporting, validation of pension provider/group assignment, and data extraction for interfaces requiring consolidated provider and group listings with address detail.

Retrieving all enabled pension entities for a business group:

  • SELECT organization_id, name, internal_address_line, location_code, code, type FROM apps.hr_fr_pension_prv_grp_v WHERE business_group_id = :p_bg_id AND enabled = 'Y' ORDER BY name;

Isolating provider-only records (non-null code):

  • SELECT organization_id, name, internal_address_line FROM apps.hr_fr_pension_prv_grp_v WHERE code IS NOT NULL;

Isolating group-only records (null code/type):

  • SELECT organization_id, name, internal_address_line FROM apps.hr_fr_pension_prv_grp_v WHERE code IS NULL;

Filtering by effective dates for a point-in-time view:

  • SELECT name, internal_address_line, date_from, date_to FROM apps.hr_fr_pension_prv_grp_v WHERE TRUNC(SYSDATE) BETWEEN date_from AND NVL(date_to, TRUNC(SYSDATE));

Because the view is owned by APPS, access should be granted through standard EBS security and, where required, a synonym or grant established for reporting schemas.