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_QUERY_CHAINS_V

Product:	AX - Global Accounting Engine
Description:	Query chains available in a translation scheme
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT QC.APPLICATION_ID
, QC.QUERY_CHAIN_NAME
, 1+SUM(DECODE(QT.JOIN_TYPE
, 'MANY'
, 1
, 0))
, QC.ENABLED_FLAG
, 'N'
, QC.DESCRIPTION
, QC.STARTING_TABLE
FROM AX_QUERY_TABLES QT
, AX_QUERY_CHAINS QC
WHERE QT.APPLICATION_ID = QC.APPLICATION_ID
AND QT.QUERY_CHAIN_NAME = QC.QUERY_CHAIN_NAME GROUP BY QC.APPLICATION_ID
, QC.QUERY_CHAIN_NAME
, QC.ENABLED_FLAG
, 'N'
, QC.DESCRIPTION
, QC.STARTING_TABLE UNION SELECT 999
, LOOKUP_CODE
, 1
, 'Y'
, 'Y'
, ''
, ''
FROM AX_LOOKUPS
WHERE LOOKUP_TYPE = 'AX_EVENT_TABLE_NAME'

Columns

Name
APPLICATION_ID
QUERY_CHAIN_NAME
FREQUENCY
ENABLED_FLAG
BASE_TABLE_EVENT_FLAG
DESCRIPTION
STARTING_TABLE