Search Results structure_desc

Overview

AZ_STRUCTURES_VL is a multilingual (VL) view owned by the APPS schema in Oracle E-Business Suite, belonging to the AZ – Application Implementation product. It exposes the definition of "structures" used by Oracle Application Implementation and related configuration utilities, presenting both the base attributes of each structure and its language-dependent translated name and description. The view is classified as VALID and is available in both EBS 12.1.1 and 12.2.2.

The "_VL" suffix indicates that the view joins a base table (_B) holding language-independent columns with a translation table (_TL) holding language-dependent columns, filtered to the session language through USERENV('LANG'). This design allows reports, concurrent programs, and integrations to retrieve a structure with its name and description already resolved to the user's current language, without requiring the calling code to perform the join or language filter itself. It is therefore the preferred access point for read-only retrieval of structure metadata.

Underlying Base Objects

The view is defined over two documented base objects, both referenced in the ETRM metadata as synonyms:

• AZ_STRUCTURES_B — the base table storing language-independent structure attributes, including STRUCTURE_CODE, HIERARCHICAL_FLAG, ACTIVE, and the standard WHO audit columns.
• AZ_STRUCTURES_TL — the translation table storing STRUCTURE_NAME and STRUCTURE_DESC for each language.

The join condition is B.STRUCTURE_CODE = T.STRUCTURE_CODE, combined with the restriction T.LANGUAGE = USERENV('LANG'), which limits rows to the current session language. The view text selects B.ROWID as ROW_ID, the audit columns, STRUCTURE_CODE, HIERARCHICAL_FLAG, ACTIVE, and CREATED_BY from the base table, and STRUCTURE_NAME and STRUCTURE_DESC from the translation table. Because it is a view, no physical storage is associated with it; it is a query-time projection over the two tables.

Key Columns

• ROW_ID — the ROWID of the underlying AZ_STRUCTURES_B row, useful for row identification.
• STRUCTURE_CODE — the unique business key identifying the structure; it is the join key between the base and translation tables.
• HIERARCHICAL_FLAG — indicates whether the structure is hierarchical. This is the column referenced by the search term "hierarchical_flag" and is a primary differentiator among structure definitions.
• ACTIVE — the enabled/disabled status of the structure.
• STRUCTURE_NAME and STRUCTURE_DESC — the translated name and description of the structure in the session language.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS WHO audit columns inherited from AZ_STRUCTURES_B.

Common Use Cases and Queries

The view is typically queried to list available structures, to filter for hierarchical structures, or to feed structure metadata into configuration or reporting processes. A representative query filtering on the hierarchical flag is:

• SELECT structure_code, structure_name, hierarchical_flag, active FROM az_structures_vl WHERE hierarchical_flag = 'Y' AND active = 'Y';
• SELECT structure_code, structure_name, structure_desc FROM az_structures_vl ORDER BY structure_name;

Because the view already applies the USERENV('LANG') filter, callers should not add their own language predicate; the returned STRUCTURE_NAME and STRUCTURE_DESC will match the session language where a translation exists. For troubleshooting missing rows, compare the view result against AZ_STRUCTURES_B to confirm whether the discrepancy is due to an absent translation rather than missing base data. All access should be granted through the APPS schema, consistent with standard EBS view-based reporting practice.