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_SCHEME_CONTEXTS_V

Product:	AX - Global Accounting Engine
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ATS.APPLICATION_ID
, ATS.TRANSLATION_SCHEME
, AQC.QUERY_CHAIN_NAME
, AQC.ENABLED_FLAG
, AQC.DESCRIPTION
, 1+SUM(DECODE(AQT.JOIN_TYPE
, 'MANY'
, 1
, 0))
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 GROUP BY ATS.APPLICATION_ID
, ATS.TRANSLATION_SCHEME
, AQC.QUERY_CHAIN_NAME
, AQC.ENABLED_FLAG
, AQC.DESCRIPTION UNION SELECT ATS.APPLICATION_ID
, ATS.TRANSLATION_SCHEME
, AL.LOOKUP_CODE
, 'Y'
, AL.DESCRIPTION
, 1
FROM AX_LOOKUPS AL
, AX_TRANS_SCHEMES ATS
WHERE AL.LOOKUP_TYPE = 'AX_FIXED_CONTEXT'

Columns

Name
APPLICATION_ID
TRANSLATION_SCHEME
QUERY_CHAIN_NAME
ENABLED_FLAG
DESCRIPTION
FREQUENCY