[Home] [Help]
View: AX_QUERY_TABLES_V
| Product: | AX - Global Accounting Engine |
| Description: | Tables belonging to a query chain |
| Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT APPLICATION_ID
, QUERY_CHAIN_NAME
, TABLE_NAME
, TABLE_APPLICATION_ID
FROM AX_QUERY_TABLES UNION SELECT APPLICATION_ID
, QUERY_CHAIN_NAME
, STARTING_TABLE
, TABLE_APPLICATION_ID
FROM AX_QUERY_CHAINS
Columns
| Name |
| APPLICATION_ID |
| QUERY_CHAIN_NAME |
| TABLE_NAME |
| TABLE_APPLICATION_ID |