[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 |