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_RULE_DETAILS_T

Object Details

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

Interface table to load ADR rule details into SLA.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
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_TYPE_CODE	VARCHAR2	(1)	Yes	This is the owner of the account derivation rule.
SEGMENT_RULE_CODE	VARCHAR2	(30)	Yes	This is the code of the account derivation rule.
SEGMENT_RULE_DETAIL_ID	NUMBER	(15)	Yes	This is the identifier of the detail. It must be unique for a given application.
USER_SEQUENCE	NUMBER	(15)	Yes	This is the user sequence (also called priority) of the detail.
VALUE_TYPE_CODE	VARCHAR2	(1)	Yes	This is the type of the value of the detail.
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 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.
VALUE_CODE_COMBINATION_ID	NUMBER	(15)		This is the code combination id used as a value.
VALUE_MAPPING_SET_CODE	VARCHAR2	(30)		This is the mapping set code used as a value.
VALUE_FLEXFIELD_SEGMENT_CODE	VARCHAR2	(30)		This is the flexfield segment code used as a value.
INPUT_SOURCE_APPLICATION_ID	NUMBER	(15)		This is the application id of the source used as an input value.
INPUT_SOURCE_TYPE_CODE	VARCHAR2	(1)		This is the type code of the source used as an input value.
INPUT_SOURCE_CODE	VARCHAR2	(30)		This is the code of the source used as an input value.
VALUE_SEGMENT_RULE_APPL_ID	NUMBER	(15)		This is the application id of the associated segment rule.
VALUE_SEGMENT_RULE_TYPE_CODE	VARCHAR2	(1)		This is the type code of the associated segment rule used as a value.
VALUE_SEGMENT_RULE_CODE	VARCHAR2	(30)		This is the code of the associated segment rule used as a value.
VALUE_ADR_VERSION_NUM	NUMBER	(15)		This is the version number of the associated segment rule used as a 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 APPLICATION_ID
,      AMB_CONTEXT_CODE
,      SEGMENT_RULE_TYPE_CODE
,      SEGMENT_RULE_CODE
,      SEGMENT_RULE_DETAIL_ID
,      USER_SEQUENCE
,      VALUE_TYPE_CODE
,      VALUE_SOURCE_APPLICATION_ID
,      VALUE_SOURCE_TYPE_CODE
,      VALUE_SOURCE_CODE
,      VALUE_CONSTANT
,      VALUE_CODE_COMBINATION_ID
,      VALUE_MAPPING_SET_CODE
,      VALUE_FLEXFIELD_SEGMENT_CODE
,      INPUT_SOURCE_APPLICATION_ID
,      INPUT_SOURCE_TYPE_CODE
,      INPUT_SOURCE_CODE
,      VALUE_SEGMENT_RULE_APPL_ID
,      VALUE_SEGMENT_RULE_TYPE_CODE
,      VALUE_SEGMENT_RULE_CODE
,      VALUE_ADR_VERSION_NUM
,      ERROR_VALUE
FROM XLA.XLA_RULE_DETAILS_T;

Dependencies

[top of page]

XLA.XLA_RULE_DETAILS_T does not reference any database object

XLA.XLA_RULE_DETAILS_T is referenced by following:

XLA: XLA_RULE_DETAILS_T#