Search Results table_application_id

Overview

The view AX_QUERY_TABLES_V belongs to the Global Accounting Engine (AX) product family within Oracle E-Business Suite. Its documented description is "Tables belonging to a query chain." In the context of Oracle EBS 12.1.1 and 12.2.2, this view exposes the mapping between a named query chain and the database tables that participate in that chain, together with the application context in which the chain and its tables reside.

The Global Accounting Engine is the accounting engine that supports subledger transfer and posting to the General Ledger in a multi-application environment. Query chains in this context describe ordered sequences of tables used to move, derive, or validate accounting data. The view functions as a reference or metadata dictionary: rather than storing transactional accounting data, it exposes configuration-level information about which tables belong to which query chain, allowing administrators and integration developers to trace how data flows through the accounting engine. Because a query chain can be defined across multiple applications, the view also surfaces both the application that owns the chain and the application that owns each individual table.

Underlying Base Objects

According to the ETRM metadata, no base objects are separately documented for this view. The documented view text, however, clearly shows that AX_QUERY_TABLES_V is a UNION of two underlying sources:

• AX_QUERY_TABLES — supplies rows of the form APPLICATION_ID, QUERY_CHAIN_NAME, TABLE_NAME, TABLE_APPLICATION_ID for tables explicitly registered as members of a chain.
• AX_QUERY_CHAINS — contributes the chain's STARTING_TABLE projected as TABLE_NAME, ensuring the entry-point table of each chain is included in the same result set.

The UNION (not UNION ALL) implies that duplicate rows — for example, where a starting table is also listed as a member table — are collapsed into a single row. This design presents a complete, de-duplicated inventory of tables reachable within each query chain. Note that the ETRM excerpt states the object is "Not implemented in this database" for the documented instance, so availability depends on whether the Global Accounting Engine schema objects have been created in a given environment.

Key Columns

• APPLICATION_ID — The identifier of the application that owns or defines the query chain.
• QUERY_CHAIN_NAME — The name of the query chain, used to group tables that participate in the same processing sequence.
• TABLE_NAME — The name of a table belonging to the chain. For rows originating from AX_QUERY_CHAINS, this is the chain's starting table.
• TABLE_APPLICATION_ID — The application identifier that owns the individual table. This is the column a user searching for "table_application_id" would target when determining which application a given chain table belongs to, which can differ from the chain's owning application in cross-application setups.

Common Use Cases and Queries

A frequent use case is enumerating every table in a given query chain, or identifying which application owns those tables. The following query lists all tables for a specified chain:

• SELECT query_chain_name, table_name, table_application_id, application_id FROM ax_query_tables_v WHERE query_chain_name = :chain_name ORDER BY table_name;

To trace all chains that reference a particular table, or to audit cross-application table ownership:

• SELECT query_chain_name, table_name FROM ax_query_tables_v WHERE table_name = :table_name;
• SELECT DISTINCT application_id, table_application_id FROM ax_query_tables_v;

These queries support impact analysis, troubleshooting of subledger accounting data flow, and documentation of the Global Accounting Engine configuration in EBS 12.1.1 and 12.2.2.