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_CONDITIONS

Object Details

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

This table stores information about conditions used by a distribution
plan structure or distribution header. It contains a row for each
condition.
Each row includes the logical operator (AND or OR), the table and the
column involved as left operand, the type of the right operand and
its value.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: AX_CONDITIONS_PK

CONDITION_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
AX_CONDITIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CONDITION_ID
AX_CONDITIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID APPLICATION_ID TRANSLATION_SCHEME PLAN_NAME STRUCTURE_TYPE STRUCTURE_NUMBER
AX_CONDITIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID APPLICATION_ID TRANSLATION_SCHEME HEADER_NUMBER
AX_CONDITIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID APPLICATION_ID LEFT_TABLE LEFT_COLUMN
AX_CONDITIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID APPLICATION_ID RIGHT_OP_COLUMN_VALUE RIGHT_OP_TABLE

Foreign Keys

Table		Foreign Table	Foreign Key Column
AX_CONDITIONS		AX_DISTRIB_HEADERS	AX_CONDITIONS SET_OF_BOOKS_ID AX_CONDITIONS APPLICATION_ID AX_CONDITIONS TRANSLATION_SCHEME AX_CONDITIONS HEADER_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
CONDITION_ID	NUMBER		Yes	Condition identifier
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
CONDITION_NUMBER	NUMBER		Yes	Condition number within the distribution header or distribution plan structure
SET_OF_BOOKS_ID	NUMBER		Yes	Set of books identifier
APPLICATION_ID	NUMBER		Yes	Application identifier
TRANSLATION_SCHEME	VARCHAR2	(30)	Yes	Translation scheme name
HEADER_NUMBER	NUMBER			Distribution header number
PLAN_NAME	VARCHAR2	(30)		Distribution plan name
STRUCTURE_TYPE	VARCHAR2	(30)		Type of structure
STRUCTURE_NUMBER	NUMBER			Number of structure within the plan and the structure type
LOGIC_OPERATOR	VARCHAR2	(30)		Logical operator
LEFT_TABLE	VARCHAR2	(30)	Yes	Left table name
LEFT_COLUMN	VARCHAR2	(30)	Yes	Left table column name
COMPARISON_OPERATOR	VARCHAR2	(30)	Yes	Comparison operator
RIGHT_OPERAND_TYPE	VARCHAR2	(30)		Right operand type
RIGHT_OP_COLUMN_VALUE	VARCHAR2	(255)		Value of the right operand or the column name of the right operand.
RIGHT_OP_TABLE	VARCHAR2	(30)		Right operand table name

Query Text

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


SELECT CONDITION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CONDITION_NUMBER
,      SET_OF_BOOKS_ID
,      APPLICATION_ID
,      TRANSLATION_SCHEME
,      HEADER_NUMBER
,      PLAN_NAME
,      STRUCTURE_TYPE
,      STRUCTURE_NUMBER
,      LOGIC_OPERATOR
,      LEFT_TABLE
,      LEFT_COLUMN
,      COMPARISON_OPERATOR
,      RIGHT_OPERAND_TYPE
,      RIGHT_OP_COLUMN_VALUE
,      RIGHT_OP_TABLE
FROM AX.AX_CONDITIONS;

Dependencies

[top of page]

AX.AX_CONDITIONS does not reference any database object

AX.AX_CONDITIONS is referenced by following:

APPS: AX_CONDITIONS