Search Results from_organization_name




Overview
Explore in AI Chat

Overview

APPS.INVFV_INTERORG_LEAD_TIMES is a Business Intelligence System (BIS) view in the Oracle E-Business Suite Applications schema (APPS). Registered under FND Design Data reference INV.INVFV_INTERORG_LEAD_TIMES, the object is a database view rather than a base table, and its status is VALID. Its purpose in the Oracle Inventory (INV) module is to expose the lead time required to ship goods from one inventory organization to another for a given shipping method. In practical terms, it presents the in-transit time dimension of inter-organization transfers in a denormalized, human-readable form suitable for reporting and integration.

Because the view resolves organization identifiers into codes and names and resolves shipping method codes into descriptive names, it is particularly useful for BI Publisher reports, Oracle Discoverer workbooks, OBIEE extracts, and custom concurrent programs that must display inter-org transfer lead times without requiring the calling program to perform its own joins to HR and Inventory tables. The user search term "from_organization_name" corresponds directly to a column of this view, indicating that the view is frequently queried to obtain the name of the shipping (source) organization.

Underlying Base Objects

According to the documented dependency metadata (ETRM 12.2.2), APPS.INVFV_INTERORG_LEAD_TIMES references the following objects:

  • MTL_INTERORG_SHIP_METHODS (SYNONYM) — the primary Inventory table that stores inter-organization shipping methods and the associated in-transit lead times.
  • MTL_PARAMETERS (SYNONYM) — provides organization-level inventory parameters, used to resolve the organization identifiers.
  • HR_ALL_ORGANIZATION_UNITS (SYNONYM) — the Human Resources organization definition table, supplying organization names.
  • HR_LOCATIONS (VIEW) — supplies location codes used for the from/to location columns.
  • FND_COMMON_LOOKUPS (VIEW) — provides lookup meaning values, notably for time unit of measure and shipping method descriptions.
  • FND_GLOBAL (PACKAGE) and HR_GENERAL (PACKAGE) — supplied functions, typically used to resolve the current organization context or to return organization/location name values.

The view is not referenced by any other database object, confirming it is a terminal reporting object rather than a dependency for further application logic.

Key Columns

The view exposes organization, shipping method, time, and location attributes. The most significant columns are:

Common Use Cases and Queries

Typical scenarios include reporting on inter-organization transfer lead times for supply chain planning, validating shipping method configuration across organizations, and feeding planning engines or data warehouses with transit time data. A simple query retrieving the source organization name and its transit time is:

  • SELECT from_organization_name, to_organization_name, ship_method, intransit_time, time_uom_code FROM apps.invfv_interorg_lead_times;
  • SELECT from_organization_code, from_organization_name, ship_method_code, intransit_time FROM apps.invfv_interorg_lead_times WHERE from_organization_name = 'Vision Operations';
  • SELECT to_organization_name, ship_method, intransit_time FROM apps.invfv_interorg_lead_times WHERE time_uom_code = 'DAY' ORDER BY to_organization_name;

Filters on FROM_ORGANIZATION_NAME or FROM_ORGANIZATION_CODE are the most common entry point, since users often begin with the source organization when analyzing transfer lead times. Because the view is owned by APPS, both custom and standard reports can query it directly without requiring additional joins to resolve organization or shipping method descriptions.