DBA Data[Home] [Help] [Dependency Information]

TABLE: AX.AX_CLAUSES

Object Details
Object Name: AX_CLAUSES
Object Type: TABLE
Owner: AX
FND Design Data: TableAX.AX_CLAUSES
Subobject Name:
Status: VALID


This table stores information about the clauses used by a query chain
table. It contains a row for each clause.
Each row, except for the first row of each table, includes the
logical operator (AND or OR), the column of the table involved in the
clause, the type of the right operand and its value.
The column RIGHT_OP_COLUMN_VALUE contains either a column name or a
constant value depending on the type of operand.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: AX_CLAUSES_PK
  1. ColumnCLAUSE_NUMBER
  2. ColumnAPPLICATION_ID
  3. ColumnQUERY_CHAIN_NAME
  4. ColumnTABLE_NUMBER
Indexes
Index Type Uniqueness Tablespace Column
AX_CLAUSES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCLAUSE_NUMBER
ColumnAPPLICATION_ID
ColumnQUERY_CHAIN_NAME
ColumnTABLE_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
AX_CLAUSES AX_CLAUSES_FK1 TableAX_QUERY_TABLES AX_CLAUSES APPLICATION_ID
AX_CLAUSES QUERY_CHAIN_NAME
AX_CLAUSES TABLE_NUMBER
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER
Yes Application identifier
QUERY_CHAIN_NAME VARCHAR2 (30) Yes Query chain name
TABLE_NUMBER NUMBER
Yes Query chain table number
CLAUSE_NUMBER NUMBER
Yes Clause number within the query chain table
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
LOGIC_OPERATOR VARCHAR2 (30)
Logical operator
LEFT_COLUMN VARCHAR2 (30) Yes Query chain table column
COMPARISON_OPERATOR VARCHAR2 (30) Yes Comparison operator
RIGHT_OPERAND_TYPE VARCHAR2 (30)
Right operand type
RIGHT_OP_TABLE VARCHAR2 (30)
Right operand table name
RIGHT_OP_COLUMN_VALUE VARCHAR2 (255)
Right operand table name or value
Query Text

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


SELECT APPLICATION_ID
,      QUERY_CHAIN_NAME
,      TABLE_NUMBER
,      CLAUSE_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LOGIC_OPERATOR
,      LEFT_COLUMN
,      COMPARISON_OPERATOR
,      RIGHT_OPERAND_TYPE
,      RIGHT_OP_TABLE
,      RIGHT_OP_COLUMN_VALUE
FROM AX.AX_CLAUSES;

Dependencies

[top of page]

AX.AX_CLAUSES does not reference any database object

AX.AX_CLAUSES is referenced by following:

SchemaAPPS
SynonymAX_CLAUSES