FND Design Data [Home] [Help]

Table: AX_QUERY_TABLES

Product: AX - Global Accounting Engine
Description: Tables used by a query chain
Implementation/DBA Data: TableAX.AX_QUERY_TABLES
Primary Key: AX_QUERY_TABLES_PK
  1. ColumnAPPLICATION_ID
  2. ColumnQUERY_CHAIN_NAME
  3. ColumnTABLE_NUMBER
Primary Key: AX_QUERY_TABLES_UK
  1. ColumnAPPLICATION_ID
  2. ColumnQUERY_CHAIN_NAME
  3. ColumnTABLE_NAME
Foreign Keys
Table
Foreign Table Foreign Key Column
AX_QUERY_TABLES FK Joins to TableAX_QUERY_CHAINS AX_QUERY_TABLES.APPLICATION_ID
AX_QUERY_TABLES.QUERY_CHAIN_NAME
TableAX_CLAUSES FK Joins to AX_QUERY_TABLES AX_CLAUSES.APPLICATION_ID
AX_CLAUSES.QUERY_CHAIN_NAME
AX_CLAUSES.TABLE_NUMBER