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: XLA.XLA_CONDITIONS_T

Object Details

Object Name:	XLA_CONDITIONS_T
Object Type:	TABLE
Owner:	XLA
FND Design Data:	XLA.XLA_CONDITIONS_T
Subobject Name:
Status:	VALID

Interface table to load the conditions associated to the ADR rule details into SLA.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
CONDITION_ID	NUMBER	(15)	Yes	This is the identifier of the condition.
APPLICATION_ID	NUMBER	(15)	Yes	This is the application id.
AMB_CONTEXT_CODE	VARCHAR2	(30)	Yes	This is the context code associated to the account derivation rule.
SEGMENT_RULE_DETAIL_ID	NUMBER	(15)	Yes	This is the identifier of the detail.
USER_SEQUENCE	NUMBER	(15)	Yes	This is the user sequence of the condition.
BRACKET_LEFT_CODE	VARCHAR2	(1)		This is the left bracket of the condition.
BRACKET_RIGHT_CODE	VARCHAR2	(1)		This is the right bracket of the condition.
VALUE_TYPE_CODE	VARCHAR2	(1)	Yes	This is the type of the value of the condition.
SOURCE_APPLICATION_ID	NUMBER	(15)		This is the application id of the source.
SOURCE_TYPE_CODE	VARCHAR2	(1)		This is the type code of the source.
SOURCE_CODE	VARCHAR2	(30)		This is the code of the source.
FLEXFIELD_SEGMENT_CODE	VARCHAR2	(30)		This is the code of the flexfield segment.
VALUE_FLEXFIELD_SEGMENT_CODE	VARCHAR2	(30)		This is the code of the flexfield segment used as a value.
VALUE_SOURCE_APPLICATION_ID	NUMBER	(15)		This is the application id of the source used as a value.
VALUE_SOURCE_TYPE_CODE	VARCHAR2	(1)		This is the type code of the source used as a value.
VALUE_SOURCE_CODE	VARCHAR2	(30)		This is the code of the source used as a value.
VALUE_CONSTANT	VARCHAR2	(240)		This is the constant used as a value.
LINE_OPERATOR_CODE	VARCHAR2	(1)		This is the code of the line operator.
LOGICAL_OPERATOR_CODE	VARCHAR2	(1)		This is the code of the logical operator.
INDEPENDENT_VALUE_CONSTANT	VARCHAR2	(30)		This is the constant used as independent value.
ERROR_VALUE	NUMBER	(15)	Yes	This indicates the error status of the row after processed by the ADR interface program.

Query Text

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


SELECT CONDITION_ID
,      APPLICATION_ID
,      AMB_CONTEXT_CODE
,      SEGMENT_RULE_DETAIL_ID
,      USER_SEQUENCE
,      BRACKET_LEFT_CODE
,      BRACKET_RIGHT_CODE
,      VALUE_TYPE_CODE
,      SOURCE_APPLICATION_ID
,      SOURCE_TYPE_CODE
,      SOURCE_CODE
,      FLEXFIELD_SEGMENT_CODE
,      VALUE_FLEXFIELD_SEGMENT_CODE
,      VALUE_SOURCE_APPLICATION_ID
,      VALUE_SOURCE_TYPE_CODE
,      VALUE_SOURCE_CODE
,      VALUE_CONSTANT
,      LINE_OPERATOR_CODE
,      LOGICAL_OPERATOR_CODE
,      INDEPENDENT_VALUE_CONSTANT
,      ERROR_VALUE
FROM XLA.XLA_CONDITIONS_T;

Dependencies

[top of page]

XLA.XLA_CONDITIONS_T does not reference any database object

XLA.XLA_CONDITIONS_T is referenced by following:

APPS: XLA_CONDITIONS_T