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_RULES_T

Object Details

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

Interface table to load ADR rules 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.
TRANSACTION_COA_ID	NUMBER	(15)		This is the identifier of the chart of accounts associated to the ledger in which the transaction has been created.
ACCOUNTING_COA_ID	NUMBER	(15)		This is the identifier of the chart of accounts associated to the ledger in which the journal entry will be created.
FLEXFIELD_ASSIGN_MODE_CODE	VARCHAR2	(1)	Yes	This is the output type of the account derivation rule.
FLEXFIELD_SEGMENT_CODE	VARCHAR2	(30)		This is the code of the segment.
ENABLED_FLAG	VARCHAR2	(1)	Yes	This indicates if the account derivation rule is enabled.
NAME	VARCHAR2	(80)	Yes	This is the name of the account derivation rule.
DESCRIPTION	VARCHAR2	(240)		This is the description of the account derivation rule.
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
,      TRANSACTION_COA_ID
,      ACCOUNTING_COA_ID
,      FLEXFIELD_ASSIGN_MODE_CODE
,      FLEXFIELD_SEGMENT_CODE
,      ENABLED_FLAG
,      NAME
,      DESCRIPTION
,      ERROR_VALUE
FROM XLA.XLA_RULES_T;

Dependencies

[top of page]

XLA.XLA_RULES_T does not reference any database object

XLA.XLA_RULES_T is referenced by following:

APPS: XLA_RULES_T