DBA Data[Home] [Help] [Dependency Information]

TABLE: AX.AX_QUERY_TABLES

Object Details
Object Name: AX_QUERY_TABLES
Object Type: TABLE
Owner: AX
FND Design Data: TableAX.AX_QUERY_TABLES
Subobject Name:
Status: VALID


This table stores the tables used by a query chain. There is a row
for every table used by a query chain.
Every row includes the table name and the type of join that is used
(ONE, MANY or ONE AMONG MANY).


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: AX_QUERY_TABLES_PK
  1. ColumnAPPLICATION_ID
  2. ColumnQUERY_CHAIN_NAME
  3. ColumnTABLE_NUMBER
Unique Key: AX_QUERY_TABLES_UK
  1. ColumnAPPLICATION_ID
  2. ColumnQUERY_CHAIN_NAME
  3. ColumnTABLE_NAME
Indexes
Index Type Uniqueness Tablespace Column
AX_QUERY_TABLES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPLICATION_ID
ColumnQUERY_CHAIN_NAME
ColumnTABLE_NUMBER
AX_QUERY_TABLES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPLICATION_ID
ColumnQUERY_CHAIN_NAME
ColumnTABLE_NAME
Foreign Keys
Table
Foreign Table Foreign Key Column
AX_QUERY_TABLES AX_QUERY_TABLES_FK1 TableAX_QUERY_CHAINS AX_QUERY_TABLES APPLICATION_ID
AX_QUERY_TABLES QUERY_CHAIN_NAME
TableAX_CLAUSES AX_CLAUSES_FK1 AX_QUERY_TABLES AX_CLAUSES APPLICATION_ID
AX_CLAUSES QUERY_CHAIN_NAME
AX_CLAUSES TABLE_NUMBER
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER
Yes Application identifier
QUERY_CHAIN_NAME VARCHAR2 (30) Yes Query chain name
TABLE_NUMBER NUMBER
Yes Table number within the query chain
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
TABLE_APPLICATION_ID NUMBER
Yes Application owning the table
TABLE_NAME VARCHAR2 (30) Yes Table name
JOIN_TYPE VARCHAR2 (30) Yes Type of join
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT APPLICATION_ID
,      QUERY_CHAIN_NAME
,      TABLE_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      TABLE_APPLICATION_ID
,      TABLE_NAME
,      JOIN_TYPE
FROM AX.AX_QUERY_TABLES;

Dependencies

[top of page]

AX.AX_QUERY_TABLES does not reference any database object

AX.AX_QUERY_TABLES is referenced by following:

SchemaAX
ViewAX_QUERY_TABLES#