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

TABLE: AX.AX_ARITHMETIC_EXPR

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


This table stores information about arithmetic expressions used by
amount structures.
Each row corresponds to an elementary expression and includes the
operator (+, -, * or /), the type of the right operand (COLUMN,
CONSTANT or EVENT_DATA) and its value.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: AX_ARITHMETIC_EXPR_PK
  1. ColumnSET_OF_BOOKS_ID
  2. ColumnAPPLICATION_ID
  3. ColumnTRANSLATION_SCHEME
  4. ColumnPLAN_NAME
  5. ColumnSTRUCTURE_NUMBER
  6. ColumnSTRUCTURE_TYPE
  7. ColumnEXPRESSION_NUMBER
Indexes
Index Type Uniqueness Tablespace Column
AX_ARITHMETIC_EXPR_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSET_OF_BOOKS_ID
ColumnAPPLICATION_ID
ColumnTRANSLATION_SCHEME
ColumnPLAN_NAME
ColumnSTRUCTURE_NUMBER
ColumnSTRUCTURE_TYPE
ColumnEXPRESSION_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
AX_ARITHMETIC_EXPR AX_ARITHMETIC_EXPR_FK1 TableAX_STRUCTURES AX_ARITHMETIC_EXPR SET_OF_BOOKS_ID
AX_ARITHMETIC_EXPR APPLICATION_ID
AX_ARITHMETIC_EXPR TRANSLATION_SCHEME
AX_ARITHMETIC_EXPR PLAN_NAME
AX_ARITHMETIC_EXPR STRUCTURE_TYPE
AX_ARITHMETIC_EXPR STRUCTURE_NUMBER
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER
Yes Set of books identifier
APPLICATION_ID NUMBER
Yes Application identifier
TRANSLATION_SCHEME VARCHAR2 (30) Yes Translation scheme name
PLAN_NAME VARCHAR2 (30) Yes Plan name
STRUCTURE_TYPE VARCHAR2 (30) Yes Type of structure
STRUCTURE_NUMBER NUMBER
Yes Number of structure within its type per distribution plan
EXPRESSION_NUMBER NUMBER
Yes Number of the expression within the structure
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
OPERATOR VARCHAR2 (1) Yes Arithmetic operator
OPERAND_TYPE VARCHAR2 (30) Yes Operand type
SOURCE_TABLE VARCHAR2 (30)
Source table name for the operand
SOURCE_COLUMN_VALUE VARCHAR2 (30) Yes Source column name or constant for the operand
Query Text

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


SELECT SET_OF_BOOKS_ID
,      APPLICATION_ID
,      TRANSLATION_SCHEME
,      PLAN_NAME
,      STRUCTURE_TYPE
,      STRUCTURE_NUMBER
,      EXPRESSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OPERATOR
,      OPERAND_TYPE
,      SOURCE_TABLE
,      SOURCE_COLUMN_VALUE
FROM AX.AX_ARITHMETIC_EXPR;

Dependencies

[top of page]

AX.AX_ARITHMETIC_EXPR does not reference any database object

AX.AX_ARITHMETIC_EXPR is referenced by following:

SchemaAPPS
SynonymAX_ARITHMETIC_EXPR