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

TABLE: AX.AX_MC_TABLES

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


This table contains information about the tables used by Multiple
Reporting Currency. It contains a row for each column in each
relevant table.
This information is used to automatically generate the accounting
rules for Multiple Reporting Currency when loading a new set of rules
for the main set of books.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Primary Key: AX_MC_TABLES_PK
  1. ColumnMC_TABLE_NAME
  2. ColumnCOLUMN_NAME
Indexes
Index Type Uniqueness Tablespace Column
AX_MC_TABLES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnMC_TABLE_NAME
ColumnCOLUMN_NAME
Columns
Name Datatype Length Mandatory Comments
MC_TABLE_NAME VARCHAR2 (30) Yes MRC renamed table
COLUMN_NAME VARCHAR2 (30) Yes Column name; 0 if table is fully replicated
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
PRIMARY_TABLE_NAME VARCHAR2 (30) Yes Base table name of the primary set of books
FULL_REPLICATE VARCHAR2 (1)
Fully replicated table flag
MC_REPLACES VARCHAR2 (1)
N if part of foreign key, Y if used for accounting
Query Text

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


SELECT MC_TABLE_NAME
,      COLUMN_NAME
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PRIMARY_TABLE_NAME
,      FULL_REPLICATE
,      MC_REPLACES
FROM AX.AX_MC_TABLES;

Dependencies

[top of page]

AX.AX_MC_TABLES does not reference any database object

AX.AX_MC_TABLES is referenced by following:

SchemaAPPS
SynonymAX_MC_TABLES