Search Results ship_to_location




Overview
Explore in AI Chat

Overview

HRFV_GB_LOCATIONS is an Oracle E-Business Suite business view template owned by the APPS schema and defined within the PER (Human Resources) product module. It is the flexfield view template from which the runtime flexfield view for United Kingdom (GB) locations is generated. The view consolidates location, address, and site-usage attributes from the HR locations data model, presenting a denormalized business view suitable for reporting, integration, and inquiry via Oracle EBS Forms, Oracle Discoverer, OBIEE, and other reporting tools. All objects are standard Oracle Applications synonyms and views, and the object is VALID in the dictionary under both 12.1.1 and 12.2.2.

The view is especially significant to users who search for "ship_to_location." The column SHIP_TO_LOCATION is exposed directly from the location record via the aliased table HR_LOCATIONS_ALL_TL (LOC2T), in addition to the surrogate key SHIP_TO_LOCATION_ID. The related descriptive flexfield, SHIP_TO_LOCATION_FLAG, is derived from LOC.SHIP_TO_SITE_FLAG translated through HR_LOOKUPS using the YES_NO lookup type, providing the human-readable Yes/No value for whether the location is enabled as a ship-to site.

Underlying Base Objects

The documented base objects referenced by HRFV_GB_LOCATIONS are:

  • HR_LOCATIONS_ALL (SYNONYM) — master location record, supplying address, telephone, inactive date, tax name, and site flags.
  • HR_LOCATIONS_ALL_TL (SYNONYM) — translation table providing the location code/name and description; joined twice (LOCT for the primary location and LOC2T for the ship-to location).
  • HR_ALL_ORGANIZATION_UNITS_TL (SYNONYM) — business group and inventory organization descriptions (BGRT, ORGT).
  • PER_PEOPLE_X (VIEW) — provides the designated receiver's full name through PEO.FULL_NAME.
  • HR_BIS, HR_GENERAL, HR_PERSON_NAME, HR_SECURITY (PACKAGES) — supporting packages for business group security, person name formatting, and the "_LA:" lookup translation placeholders used by flexfield view generation.

The joins anchor on LOCATION_ID between HR_LOCATIONS_ALL and HR_LOCATIONS_ALL_TL, foreign-keyed with the (+) outer-join operator to the business group and organization translation rows, and filtered by USERENV('LANG') to return the appropriate language.

Key Columns

Common Use Cases and Queries

A frequent requirement is identifying all locations configured as ship-to sites, for example when populating or validating a ship-to list in an order-to-cash or procurement integration.

SELECT location_name,
       ship_to_location,
       ship_to_location_flag,
       city,
       country,
       postal_code
FROM   apps.hrfv_gb_locations
WHERE  ship_to_location_flag = 'Yes'
AND    inactive_date IS NULL;

Users may also join the view to HR_OPERATING_UNITS or inventory organizations to reconcile ship-to locations with inventory setups, or filter by business group to respect HR_SECURITY access. All queries must be executed against the APPS schema or through a synonym with appropriate privileges, since the view relies on HR security packages and language environment settings.