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.

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

TABLE: AX.AX_STRUCTURES

Object Details

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

This table stores structures used by a distribution plan to retrieve
the information it needs. It contains a row for every structure.
Each row includes the structure type (ACCOUNT, ACCOUNTED AMOUNT,
COMMENT, DESCRIPTION, ENTERED_AMOUNT or THIRD PARTY), the source
type (depending on the structure type), the query chain used, and
the source of the information.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: AX_STRUCTURES_PK

SET_OF_BOOKS_ID
APPLICATION_ID
TRANSLATION_SCHEME
PLAN_NAME
STRUCTURE_TYPE
STRUCTURE_NUMBER

Indexes

Index	Type	Uniqueness	Tablespace	Column
AX_STRUCTURES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID APPLICATION_ID TRANSLATION_SCHEME PLAN_NAME STRUCTURE_TYPE STRUCTURE_NUMBER
AX_STRUCTURES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPLICATION_ID QUERY_CHAIN_NAME
AX_STRUCTURES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPLICATION_ID SET_OF_BOOKS_ID TRANSLATION_SCHEME QUERY_CHAIN_NAME
AX_STRUCTURES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPLICATION_ID SET_OF_BOOKS_ID SOURCE_COLUMN_VALUE SOURCE_TABLE

Foreign Keys

Table	Foreign Table	Foreign Key Column
AX_STRUCTURES	AX_DISTRIB_PLANS	AX_STRUCTURES SET_OF_BOOKS_ID AX_STRUCTURES APPLICATION_ID AX_STRUCTURES TRANSLATION_SCHEME AX_STRUCTURES PLAN_NAME
AX_ARITHMETIC_EXPR	AX_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
AX_CONDITIONS	AX_STRUCTURES	AX_CONDITIONS SET_OF_BOOKS_ID AX_CONDITIONS APPLICATION_ID AX_CONDITIONS TRANSLATION_SCHEME AX_CONDITIONS PLAN_NAME AX_CONDITIONS STRUCTURE_TYPE AX_CONDITIONS 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	Distribution plan name
STRUCTURE_TYPE	VARCHAR2	(30)	Yes	Type of structure
STRUCTURE_NUMBER	NUMBER		Yes	Order number of the structure within a plan and structure type
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
SOURCE_TYPE	VARCHAR2	(30)		Type of source
QUERY_CHAIN_NAME	VARCHAR2	(30)		Query chain name
SOURCE_TABLE	VARCHAR2	(30)		Source table name
SOURCE_COLUMN_VALUE	VARCHAR2	(255)		Source column name or source value
SOURCE_SEGMENT	NUMBER			Source segment number for structure type ACCOUNT of source type SEGMENT
TARGET_SEGMENT	NUMBER			Target segment number for structure type ACCOUNT with source type of COLUMN, CONSTANT, or SEGMENT
START_POSITION	NUMBER			Start of the substring used for structure type COMMENT
END_POSITION	NUMBER			End of the substring used for structure type COMMENT
TARGET_COLUMN_NAME	VARCHAR2	(30)		Target column name

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
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SOURCE_TYPE
,      QUERY_CHAIN_NAME
,      SOURCE_TABLE
,      SOURCE_COLUMN_VALUE
,      SOURCE_SEGMENT
,      TARGET_SEGMENT
,      START_POSITION
,      END_POSITION
,      TARGET_COLUMN_NAME
FROM AX.AX_STRUCTURES;

Dependencies

[top of page]

AX.AX_STRUCTURES does not reference any database object

AX.AX_STRUCTURES is referenced by following:

APPS: AX_STRUCTURES