Results for “child_of”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.OE_INLINE_TWO_LEVEL_V is an Oracle E-Business Suite dictionary view that exposes a self-parenting, two-level hierarchy of geography-based location segments. It is an inline-view construct used by Oracle Order Management and related modules to resolve parent-child relationships between geography records that participate in a key flexfield structure. The view returns each child geography together with its immediate parent, simultaneously surfacing both the LOCATION_STRUCTURE_ID (the flexfield structure identifier) and the individual LOCATION_SEGMENT_ID values for the child and parent nodes.

From a reporting and integration standpoint the view behaves as a denormalised flattening of the hierarchical geographic model. Rather than requiring a caller to walk HZ_RELATIONSHIPS recursively, a single query returns child and parent attributes side by side, including segment values, user values, qualifiers, and country codes. This makes it useful for validation, address hierarchy presentation, and downstream order-entry processing in both 12.1.1 and 12.2.2.

Underlying Base Objects

The view is defined over four documented base objects, all accessed through APPS synonyms:

• HZ_GEOGRAPHIES (synonym) — supplies the child geography record, aliased GEO, providing GEOGRAPHY_ID, GEOGRAPHY_NAME, GEOGRAPHY_TYPE, and COUNTRY_CODE.
• HZ_RELATIONSHIPS (synonym) — supplies the hierarchy linkage, aliased REL, joining on GEO.GEOGRAPHY_ID = REL.SUBJECT_ID with RELATIONSHIP_CODE = 'CHILD_OF'.
• FND_SEGMENT_ATTRIBUTE_VALUES (synonym) — aliased twice (ATTR_CHILD, ATTR_PARENT) to associate each geography with its key flexfield structure via ID_FLEX_NUM, yielding LOCATION_STRUCTURE_ID.
• FND_ID_FLEX_SEGMENTS (synonym) — aliased twice (SEG_CHILD, SEG_PARENT) to constrain the segment definitions relevant to the location flexfield.

The join pattern correlates the child geography to its segment attributes and the parent geography to the mirrored parent attributes, producing the paired-column output that characterises the view.

Key Columns

The projection is organised into child-side and parent-side column groups:

• LOCATION_STRUCTURE_ID — the key flexfield structure identifier for the child segment; this is the column most frequently used to filter the view to a specific location structure definition.
• CHILD_ID, CHILD_VALUE, CHILD_USER_VALUE, CHILD_QUALIFIER, CHILD_COUNTRY_CODE — identify and describe the child geography segment.
• PARENT_ID, PARENT_VALUE, PARENT_USER_VALUE, PARENT_QUALIFIER — identify the immediate parent segment in the hierarchy.
• PARENT_LOC_STRUCT_ID — the flexfield structure identifier carried on the parent segment, allowing comparison where structures differ across levels.

Because LOCATION_SEGMENT_USER_VALUE and LOCATION_SEGMENT_VALUE both map to GEOGRAPHY_NAME in the inline block, the _USER_VALUE columns typically present the display value while the _VALUE columns present the stored segment value.

Common Use Cases and Queries

Typical usages include resolving the parent location for a given child, validating that a geography participates in an expected flexfield structure, and populating order or shipping address hierarchies in custom reports and interfaces.

Filter by structure identifier to return all child-parent pairs in a location hierarchy:

• SELECT LOCATION_STRUCTURE_ID, CHILD_VALUE, PARENT_VALUE FROM APPS.OE_INLINE_TWO_LEVEL_V;
• SELECT CHILD_ID, CHILD_VALUE, PARENT_ID, PARENT_VALUE FROM APPS.OE_INLINE_TWO_LEVEL_V WHERE LOCATION_STRUCTURE_ID = :structure_id;
• SELECT CHILD_VALUE, CHILD_COUNTRY_CODE, PARENT_VALUE FROM APPS.OE_INLINE_TWO_LEVEL_V WHERE CHILD_QUALIFIER = 'COUNTRY';

In Oracle EBS 12.1.1 and 12.2.2 these queries remain structurally identical, as the view definition and its HZ geography dependencies are consistent across both releases. Consumers should treat the view as read-only and be mindful of the CHILD_OF relationship restriction, which limits output to two-level hierarchies only.