eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AX_CONTEXT_TABLES_V

Product:	AX - Global Accounting Engine
Description:	Use by the Setup Query Chains form
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ATS.APPLICATION_ID
, ATS.TRANSLATION_SCHEME
, AQC.QUERY_CHAIN_NAME
, AQT.TABLE_NAME
, AQT.TABLE_APPLICATION_ID
FROM AX_QUERY_TABLES AQT
, AX_QUERY_CHAINS AQC
, AX_TRANS_SCHEMES ATS
WHERE AQT.APPLICATION_ID = AQC.APPLICATION_ID
AND AQT.QUERY_CHAIN_NAME = AQC.QUERY_CHAIN_NAME
AND AQC.APPLICATION_ID = ATS.APPLICATION_ID
AND AQC.STARTING_TABLE = ATS.BASE_EVENT_TABLE
AND AQC.TABLE_APPLICATION_ID = ATS.BASE_APPLICATION_ID UNION SELECT ATS.APPLICATION_ID
, ATS.TRANSLATION_SCHEME
, AQC.QUERY_CHAIN_NAME
, ATS.BASE_EVENT_TABLE
, ATS.BASE_APPLICATION_ID
FROM AX_QUERY_CHAINS AQC
, AX_TRANS_SCHEMES ATS
WHERE AQC.STARTING_TABLE = ATS.BASE_EVENT_TABLE
AND AQC.APPLICATION_ID = ATS.APPLICATION_ID UNION SELECT ATS.APPLICATION_ID
, ATS.TRANSLATION_SCHEME
, AQC.QUERY_CHAIN_NAME
, 'AX_EVENTS'
, 600
FROM AX_QUERY_CHAINS AQC
, AX_TRANS_SCHEMES ATS
WHERE AQC.STARTING_TABLE = ATS.BASE_EVENT_TABLE
AND AQC.APPLICATION_ID = ATS.APPLICATION_ID UNION SELECT ATS.APPLICATION_ID
, ATS.TRANSLATION_SCHEME
, AL.LOOKUP_CODE
, ATS.BASE_EVENT_TABLE
, ATS.BASE_APPLICATION_ID
FROM AX_LOOKUPS AL
, AX_TRANS_SCHEMES ATS
WHERE AL.LOOKUP_TYPE = 'AX_FIXED_CONTEXT'
AND AL.LOOKUP_CODE = '(BASE_EVENT_TABLE)' UNION SELECT ATS.APPLICATION_ID
, ATS.TRANSLATION_SCHEME
, AL.LOOKUP_CODE
, 'AX_EVENTS'
, 600
FROM AX_LOOKUPS AL
, AX_TRANS_SCHEMES ATS
WHERE AL.LOOKUP_TYPE = 'AX_FIXED_CONTEXT'

Columns

Name
APPLICATION_ID
TRANSLATION_SCHEME
QUERY_CHAIN_NAME
TABLE_NAME
TABLE_APPLICATION_ID