Search Results structure_desc




Overview
Explore in AI Chat

Overview

AZ_STRUCTURES_VL is a public view owned by the APPS schema in Oracle E-Business Suite, documented as VALID under FND Design Data AZ.AZ_STRUCTURES_VL. The "_VL" suffix denotes a "view with language," a standard EBS convention indicating that translatable descriptive columns are resolved through a translation table joined to the underlying base entity. The view is classified in the ETRM metadata as a public view that "may be useful for custom reporting or other data requirements," which identifies it as a supported reporting surface rather than an internal implementation object.

The view exposes the definition of structures in the Oracle Enterprise Asset Management / Asset Tracking (EAM) functional area associated with the AZ product schema. Each row represents a structure record, carrying its identifying code and name together with descriptive and status information. The presence of STRUCTURE_DESC, a VARCHAR2(1800) column, is the attribute most frequently targeted by ad hoc reporting and integration queries, and it is the column referenced by the user search term "structure_desc."

Because the view is not referenced by any other database object, it functions purely as a read interface for external consumers — reports, extracts, interfaces, and custom code — rather than as an intermediate dependency inside the AZ schema.

Underlying Base Objects

The view is defined over two base objects, both referenced through APPS synonyms:

The view joins these two objects on the primary key of the structure entity and restricts the translation row to the current runtime language. This join is what allows STRUCTURE_NAME and STRUCTURE_DESC to be returned in the session language without the caller writing language-aware SQL. The ROW_ID column is a ROWID from the base row, and the view is presented as a simple projection of the joined result set.

Key Columns

  • ROW_ID (ROWID) — the base row identifier, useful for building direct-row navigation but not stable across reorganizations.
  • STRUCTURE_CODE (VARCHAR2(30)) — the unique, language-independent code for the structure; the correct join key for interfaces.
  • STRUCTURE_NAME (VARCHAR2(150)) — the translated display name of the structure.
  • STRUCTURE_DESC (VARCHAR2(1800)) — the translated long description of the structure, frequently used in reporting and validation output.
  • HIERARCHICAL_FLAG (VARCHAR2) — indicates whether the structure is hierarchical in nature, distinguishing flat structures from tree-structured ones.
  • ACTIVE (VARCHAR2) — the enabled/disabled indicator; filter on this to exclude obsolete definitions.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS WHO audit columns for change tracking and data lineage.

Common Use Cases and Queries

Typical uses include reporting on structure definitions for business users, loading reference data into downstream systems, validating structure codes against ACTIVE definitions, and joining structure metadata to transactional EAM tables. Because the view is language-resolved, it is the preferred source when a single-language extract is required; consumers needing all installed languages must query AZ_STRUCTURES_TL directly.

Retrieve active structures with their descriptions:

SELECT structure_code, structure_name, structure_desc
FROM apps.az_structures_vl
WHERE active = 'Y';

Search by description text:

SELECT structure_code, structure_name
FROM apps.az_structures_vl
WHERE UPPER(structure_desc) LIKE '%' || UPPER(:p_search) || '%';

List only hierarchical structures for a tree-building report:

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

Audit recently modified definitions:

SELECT structure_code, structure_name, last_updated_by, last_update_date
FROM apps.az_structures_vl
WHERE last_update_date >= :p_since_date;

All queries should be issued from an APPS-enabled session or with the fully qualified APPS.AZ_STRUCTURES_VL name so that the required synonyms and privileges resolve correctly.