Search Results dba_indexes




Overview
Explore in AI Chat

Overview

APPS.ETRM_PNAV is a metadata-driven navigation and diagnostic utility package within the Oracle E-Business Suite ETRM (Electronic Technical Reference Manual) schema. In the context of Oracle EBS 12.1.1 and 12.2.2, ETRM_PNAV does not participate in a core transactional business process such as order capture, general ledger posting, or inventory movement. Instead, it provides the query, introspection, and HTML rendering infrastructure used by the ETRM repository to navigate the database object dictionary. The package enables the ETRM application to display details of database objects — including packages, views, indexes, tables, and materialized views — through a browser interface by querying Data Dictionary views and producing formatted output.

The package is classified as a Package Body owned by APPS with VALID status. The package specification contains nine documented procedures and functions: LS_APPS, LS_OBJECT, SHOW_OBJECT, SHOW_DETAILS, SHOW_SQL, SHOW_DEPENDENT_CODE, PRN_OBJECT_TYPE, and GET_OBJECT_NAME.

Key Procedures and Functions

The documented routines work together to resolve an object reference, retrieve its metadata, and render it for display.

  • LS_APPS — Lists schema-level or application-level objects, supporting the ETRM object listing view.
  • LS_OBJECT — Lists database objects, typically filtered by an owner, type, or context.
  • SHOW_OBJECT — Resolves and presents a specific database object, likely its headers and attributes.
  • SHOW_DETAILS — Renders detailed metadata for a selected object, including columns, constraints, and indexes.
  • SHOW_SQL — Displays the SQL or source text associated with a stored object.
  • SHOW_DEPENDENT_CODE — Displays dependent code objects, supporting the dependency drill-down used by EBS utilities.
  • PRN_OBJECT_TYPE — Prints or outputs the object type classification for a given object.
  • GET_OBJECT_NAME — Retrieves the object name from the supplied context or identifier.

Tables Accessed

ETRM_PNAV reads from a broad set of Data Dictionary views. These are referenced through APPS synonyms: DBA_OBJECTS, FND_APPLICATION, FND_PRODUCT_GROUPS, FND_TABLES, FND_VIEWS, DBA_COL_COMMENTS, DBA_CONSTRAINTS, DBA_CONS_COLUMNS, DBA_ERRORS, DBA_INDEXES, DBA_IND_COLUMNS, DBA_METHOD_PARAMS, DBA_MVIEWS, DBA_SOURCE, and DBA_TABLES. Additional underlying dependencies include SYS views such as DBA_INDEXES, DBA_IND_EXPRESSIONS, DBA_METHOD_RESULTS, DBA_QUEUES, DBA_SYNONYMS, DBA_TRIGGERS, DBA_TYPES, DBA_TYPE_ATTRS, and DBA_TYPE_METHODS.

These views provide object definitions (DBA_OBJECTS, DBA_SOURCE), structural details (DBA_TAB_COLUMNS, DBA_INDEXES, DBA_IND_COLUMNS, DBA_CONSTRAINTS), descriptive text (DBA_COL_COMMENTS, DBA_TAB_COMMENTS), and error information (DBA_ERRORS). Where the searched term "dba_indexes" is concerned, ETRM_PNAV uses DBA_INDEXES to enumerate index definitions and DBA_IND_COLUMNS for index column composition, which is central to the index detail display in ETRM.

Usage Notes

ETRM_PNAV is invoked primarily through the ETRM browser interface and related EBS diagnostic utilities rather than through standard Oracle Forms or concurrent programs. Because it renders HTML, it relies on HTP and OWA_UTIL and is intended for interactive, read-only display of database metadata. It is referenced by two other database objects noted in the dependency metadata. Custom code should treat ETRM_PNAV as an internal platform package; it is not a supported public API for application extensions, and its output is designed for the ETRM viewer rather than machine consumption.