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_LINE_ASSGNS_T

Object Details

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

Interface table to load the assignments between ADR rules and journal
line types.

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.
EVENT_CLASS_CODE	VARCHAR2	(30)	Yes	This is the code of the event class associated to the journal line definition.
EVENT_TYPE_CODE	VARCHAR2	(30)	Yes	This is the code of the event type associated to the journal line definition.
LINE_DEFINITION_OWNER_CODE	VARCHAR2	(30)	Yes	This is the code of the owner of the journal line definition.
LINE_DEFINITION_CODE	VARCHAR2	(30)	Yes	This is the code of the journal line definition.
ACCOUNTING_LINE_TYPE_CODE	VARCHAR2	(30)	Yes	This is the code of the owner of the journal line type.
ACCOUNTING_LINE_CODE	VARCHAR2	(30)	Yes	This is the code of the journal line type.
FLEXFIELD_SEGMENT_CODE	VARCHAR2	(30)	Yes	This is the type of 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.
ERROR_VALUE	NUMBER	(15)	Yes	This indicates the error status of the row after processed by the ADR interface program.
DESCRIPTION_TYPE_CODE	VARCHAR2	(30)
DESCRIPTION_CODE	VARCHAR2	(30)
INHERIT_DESC_FLAG	VARCHAR2	(1)
MPA_HEADER_DESC_CODE	VARCHAR2	(30)
MPA_HEADER_DESC_TYPE_CODE	VARCHAR2	(30)
MPA_NUM_JE_CODE	VARCHAR2	(30)
MPA_GL_DATES_CODE	VARCHAR2	(30)
MPA_PRORATION_CODE	VARCHAR2	(30)

Query Text

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


SELECT APPLICATION_ID
,      AMB_CONTEXT_CODE
,      EVENT_CLASS_CODE
,      EVENT_TYPE_CODE
,      LINE_DEFINITION_OWNER_CODE
,      LINE_DEFINITION_CODE
,      ACCOUNTING_LINE_TYPE_CODE
,      ACCOUNTING_LINE_CODE
,      FLEXFIELD_SEGMENT_CODE
,      SEGMENT_RULE_TYPE_CODE
,      SEGMENT_RULE_CODE
,      ERROR_VALUE
,      DESCRIPTION_TYPE_CODE
,      DESCRIPTION_CODE
,      INHERIT_DESC_FLAG
,      MPA_HEADER_DESC_CODE
,      MPA_HEADER_DESC_TYPE_CODE
,      MPA_NUM_JE_CODE
,      MPA_GL_DATES_CODE
,      MPA_PRORATION_CODE
FROM XLA.XLA_LINE_ASSGNS_T;

Dependencies

[top of page]

XLA.XLA_LINE_ASSGNS_T does not reference any database object

XLA.XLA_LINE_ASSGNS_T is referenced by following:

APPS: XLA_LINE_ASSGNS_T