Search Results ship_to_location_flag




Overview
Explore in AI Chat

Overview

APPS.HRFV_US_LOCATIONS is a reporting view in Oracle E-Business Suite that presents HR location records in a format suited to United States address conventions. It joins the core HR locations tables to business group and organization information, decodes several site-purpose flags through the HR lookups mechanism, and resolves the state code to its lookup meaning. The view is not an operational entity; it is a read-only presentation layer used by forms, concurrent programs, and external integrations that need a flattened, US-centric view of the enterprise's location master.

The name searched, internal_site_flag, corresponds to one of the site-purpose indicators exposed by the view. It reflects whether a location functions as an internal (inventory-owning) site, and it is rendered by decoding the values-YES_NO lookup applied to the underlying flag on HR_LOCATIONS_ALL. This makes the view particularly relevant when reporting which locations participate in internal inventory and shipping operations.

Underlying Base Objects

The view is defined over the following documented objects:

  • HR_ALL_ORGANIZATION_UNITS (synonym) — supplies the business group and inventory organization context.
  • HR_ALL_ORGANIZATION_UNITS_TL (synonym) — supplies translated business group and organization names.
  • HR_LOCATIONS_ALL (synonym) — the base location records, including address, flags, and identifiers.
  • HR_LOCATIONS_ALL_TL (synonym) — translated location names and descriptions, joined on language = userenv('LANG').
  • PER_PEOPLE_X (view) — resolves the designated receiver's full name.
  • HR_BIS (package), HR_GENERAL (package), HR_PERSON_NAME (package), HR_SECURITY (package) — supporting packages used for lookup decoding, security, and name formatting.

Because several of these are synonyms to the underlying _ALL and _TL tables, the view reads directly from the HR location and organization master data, applying outer joins so that locations without a business group or organization relationship are still returned.

Key Columns

  • location_id — primary identifier of the location record.
  • location_name / location_description — translated location code and description.
  • address_line_1 through address_line_3, city, county, state_name, state_code, country, zip_code — the US-formatted address components; the state code is decoded via HR_BIS.BIS_DECODE_LOOKUP against the US_STATE lookup.
  • telephone_number_1 to telephone_number_3 — contact numbers for the location.
  • bill_to_site_flag, internal_site_flag, receiving_site_flag, office_site_flag, ship_to_location_flag — site-purpose indicators decoded through the YES_NO HR lookup, exposing localized meanings rather than raw codes.
  • inventory_organization — name of the inventory organization associated with the location.
  • designated_receiver — full name of the person assigned to receive goods.
  • ship_to_location — location code of the ship-to site, if defined.
  • timezone_code, inactive_date, address_style, default_tax_code — ancillary attributes for scheduling, validity, formatting, and tax defaults.

Common Use Cases and Queries

Typical usage includes reporting the enterprise's internal sites, validating ship-to and receiving configurations, and feeding address data into interfaces. A common query filters on the decoded flag, for example:

SELECT location_name, city, state_code, zip_code, internal_site_flag FROM apps.hrfv_us_locations WHERE internal_site_flag = 'Yes';

Other scenarios include listing active locations for a business group, extracting ship-to locations with their designated receivers, or joining to purchasing and inventory tables by location_id or inventory_organization. Because the view relies on userenv('LANG') for translation, results honor the session language, and access is further constrained by HR security applied through the referenced packages.