Search Results ar_ai_org_v




Overview
Explore in AI Chat

Overview

AR_AI_ORG_V is a documented Oracle E-Business Suite view owned by the APPS schema and classified under the Receivables (AR) product family. Its stated purpose, per the ETRM metadata, is to select organizations from AR_SYSTEM_PARAMETERS. In practical terms, the view presents a consolidated list of Receivables operating unit organizations together with a special "ALL" pseudo-organization entry, exposing this information through two columns: ORGANIZATION and ORG_ID. Because Receivables is operating-unit enabled in Release 12, the operating unit an AR transaction belongs to is governed by the ORG_ID held against AR_SYSTEM_PARAMETERS. This view provides a simple, query-ready projection of that relationship, making it useful for reports, value sets, list-of-values definitions, and lightweight integration queries where a human-readable organization name must be paired with its numeric operating unit identifier.

Underlying Base Objects

The documented view text defines AR_AI_ORG_V as a UNION of two queries. The first query selects from AR_LOOKUPS, filtered on LOOKUP_TYPE = 'ALL', returning the lookup MEANING as ORGANIZATION and a literal -99 as ORG_ID. AR_LOOKUPS itself is exposed as a view. The second query joins HR_OPERATING_UNITS (also a view) to AR_SYSTEM_PARAMETERS (referenced in the metadata as a synonym), matching AR.ORG_ID = HR.ORGANIZATION_ID and returning HR.NAME as ORGANIZATION and AR.ORG_ID as ORG_ID. The combined result set is ordered by ORGANIZATION. The view therefore depends on three documented base objects: AR_LOOKUPS, HR_OPERATING_UNITS, and AR_SYSTEM_PARAMETERS. It inherits the operating unit context established by AR_SYSTEM_PARAMETERS and the descriptive organization names maintained in HR_OPERATING_UNITS.

Key Columns

  • ORG_ID — The numeric operating unit identifier. Real Receivables operating units are sourced from AR_SYSTEM_PARAMETERS.ORG_ID. The synthetic first branch of the UNION contributes the fixed sentinel value -99, conventionally used to represent an "ALL" or "no specific organization" selection.
  • ORGANIZATION — The descriptive organization name. For the HR-based branch this is HR_OPERATING_UNITS.NAME; for the lookup-based branch it is the AR_LOOKUPS.MEANING for LOOKUP_TYPE = 'ALL'. This column supplies the display text that accompanies each ORG_ID.

The view exposes no other columns; it is a deliberately narrow two-column projection intended for organizational identification rather than transactional reporting.

Common Use Cases and Queries

Typical scenarios include driving organization list-of-values, restricting report parameters by operating unit, and resolving an ORG_ID to a readable organization name in ad hoc extracts. The sentinel -99 row supports "all organizations" filtering logic in custom reports. A simple query lists all available organizations:

  • SELECT organization, org_id FROM apps.ar_ai_org_v ORDER BY organization;
  • SELECT org_id FROM apps.ar_ai_org_v WHERE organization = :org_name;
  • SELECT organization FROM apps.ar_ai_org_v WHERE org_id = :org_id;

Because results are ordered by ORGANIZATION, the view is convenient for value sets and pickers. Note that it reflects organizations configured in AR_SYSTEM_PARAMETERS; organizations without a Receivables system-parameters row do not appear in the second UNION branch.