[Home] [Help] [Dependency Information]

TABLE: AX.AX_QUERY_CHAINS

Object Details

Object Name:	AX_QUERY_CHAINS
Object Type:	TABLE
Owner:	AX
FND Design Data:	AX.AX_QUERY_CHAINS
Subobject Name:
Status:	VALID

This table stores the query chains. There is a row for every
query chain defined.
Every row includes the application in which the query chain is
defined, its name and the table from which the chain starts.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: AX_QUERY_CHAINS_PK

1. APPLICATION_ID
2. QUERY_CHAIN_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
AX_QUERY_CHAINS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	APPLICATION_ID QUERY_CHAIN_NAME

Foreign Keys

Table		Foreign Table	Foreign Key Column
AX_QUERY_TABLES		AX_QUERY_CHAINS	AX_QUERY_TABLES APPLICATION_ID AX_QUERY_TABLES QUERY_CHAIN_NAME

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT APPLICATION_ID
,      QUERY_CHAIN_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ENABLED_FLAG
,      DESCRIPTION
,      TABLE_APPLICATION_ID
,      STARTING_TABLE
,      FREQUENCY
FROM AX.AX_QUERY_CHAINS;

Dependencies

[top of page]

AX.AX_QUERY_CHAINS does not reference any database object

AX.AX_QUERY_CHAINS is referenced by following:

APPS

AX_QUERY_CHAINS