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_DISTRIBUTION_LINKS

Object Details

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

The XLA_DISTRIBUTION_LINKS table stores the link between transactions and subledger journal entry lines.

Storage Details

Tablespace:
PCT Free:
PCT Used:

Indexes

Index	Type	Uniqueness	Column
XLA_DISTRIBUTION_LINKS_U1	NORMAL	UNIQUE	APPLICATION_ID REF_AE_HEADER_ID TEMP_LINE_NUM AE_HEADER_ID
XLA_DISTRIBUTION_LINKS_N1	FUNCTION-BASED NORMAL	NONUNIQUE	NVL("SOURCE_DISTRIBUTION_ID_NUM_2",(-99))
XLA_DISTRIBUTION_LINKS_N3	NORMAL	NONUNIQUE	AE_HEADER_ID AE_LINE_NUM

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_ID	NUMBER	(15)	Yes	Internal Id of the application
EVENT_ID	NUMBER	(15)	Yes	Event Id
AE_HEADER_ID	NUMBER	(15)	Yes	Subledger journal entry identifier
AE_LINE_NUM	NUMBER	(38)	Yes	Subledger journal entry line number
SOURCE_DISTRIBUTION_TYPE	VARCHAR2	(30)	Yes
SOURCE_DISTRIBUTION_ID_CHAR_1	VARCHAR2	(240)		Flexible source distribution id (Char)
SOURCE_DISTRIBUTION_ID_CHAR_2	VARCHAR2	(240)		Flexible source distribution id (Char)
SOURCE_DISTRIBUTION_ID_CHAR_3	VARCHAR2	(240)		Flexible source distribution id (Char)
SOURCE_DISTRIBUTION_ID_CHAR_4	VARCHAR2	(240)		Flexible source distribution id (Char)
SOURCE_DISTRIBUTION_ID_CHAR_5	VARCHAR2	(240)		Flexible source distribution id (Char)
SOURCE_DISTRIBUTION_ID_NUM_1	NUMBER	(38)		Transaction source distribution identifer (Number)
SOURCE_DISTRIBUTION_ID_NUM_2	NUMBER	(38)		Transaction source distribution identifer (Number)
SOURCE_DISTRIBUTION_ID_NUM_3	NUMBER	(38)		Transaction source distribution identifer (Number)
SOURCE_DISTRIBUTION_ID_NUM_4	NUMBER	(38)		Transaction source distribution identifer (Number)
SOURCE_DISTRIBUTION_ID_NUM_5	NUMBER	(38)		Transaction source distribution identifer (Number)
TAX_LINE_REF_ID	NUMBER	(15)		Detail Tax Line Reference
TAX_SUMMARY_LINE_REF_ID	NUMBER	(15)		Summary Tax Line Reference
TAX_REC_NREC_DIST_REF_ID	NUMBER	(15)		Detail Tax Distribution Reference
STATISTICAL_AMOUNT	NUMBER			Statistical amount
REF_AE_HEADER_ID	NUMBER	(15)	Yes	Reversed subledger journal entry header identifier.
REF_TEMP_LINE_NUM	NUMBER	(15)
ACCOUNTING_LINE_CODE	VARCHAR2	(30)		Accounting line type code
ACCOUNTING_LINE_TYPE_CODE	VARCHAR2	(1)
MERGE_DUPLICATE_CODE	VARCHAR2	(1)	Yes	Indicates how duplicate subledger journal lines are merged. The possible values are 'A' - Merge all lines 'W' - All matching debit lines will be merged and all matching credit lines will be merged to produce a single deb
TEMP_LINE_NUM	NUMBER	(15)	Yes	It is the intermediary line number generated by the accounting engine when the entries are in most detail form
REF_EVENT_ID	NUMBER	(15)		Reference EVENT_ID. For a reversal row it is the EVENT_ID from the actual AE line reversed otherwise it is NULL
LINE_DEFINITION_OWNER_CODE	VARCHAR2	(30)		Journal lines definition owner code
LINE_DEFINITION_CODE	VARCHAR2	(30)		Journal lines definition code
EVENT_CLASS_CODE	VARCHAR2	(30)		Event class code
EVENT_TYPE_CODE	VARCHAR2	(30)		Event type code
UPG_BATCH_ID	NUMBER	(15)		Upgrade batch identifier
CALCULATE_ACCTD_AMTS_FLAG	VARCHAR2	(1)		Indicates whether the accounted amounts are calculated by SLA or passed through transaction objects. Y - indicates that accounted amounts are calculated by the accounting program. N- indicates that accounted amounts were passed through the
CALCULATE_G_L_AMTS_FLAG	VARCHAR2	(1)		Indicates whether the gain/loss amounts is calculated by the accounting engine. Y - indicates that gain/loss amounts are calculated by the accounting program. N- indicates that gain/loss amounts were passed through the extract.
ROUNDING_CLASS_CODE	VARCHAR2	(30)		The accounting class associated to the journal line. It is used as the grouping criteria for rounding. Accounting Program uses this field and the document_rounding_level together to group lines together to perform rounding.
DOCUMENT_ROUNDING_LEVEL	VARCHAR2	(30)		Indicates the document identifier for which the accounting engine must perform the rounding. Accounting Program uses this field and the rounding_class_code together to group lines together to perform rounding.
UNROUNDED_ENTERED_DR	NUMBER			Unrounded Entered Debit Amount for the journal line
UNROUNDED_ENTERED_CR	NUMBER			Unrounded Entered Credit Amount for the journal line
DOC_ROUNDING_ENTERED_AMT	NUMBER			The rounding amount for entered amount calculated by the accounting engine for the document
DOC_ROUNDING_ACCTD_AMT	NUMBER			The rounding amount for accounted amount calculated by the accounting engine for the document
UNROUNDED_ACCOUNTED_CR	NUMBER
UNROUNDED_ACCOUNTED_DR	NUMBER
APPLIED_TO_APPLICATION_ID	NUMBER	(15)
APPLIED_TO_ENTITY_CODE	VARCHAR2	(30)
APPLIED_TO_ENTITY_ID	NUMBER	(15)
APPLIED_TO_SOURCE_ID_NUM_1	NUMBER	(15)
APPLIED_TO_SOURCE_ID_NUM_2	NUMBER	(15)
APPLIED_TO_SOURCE_ID_NUM_3	NUMBER	(15)
APPLIED_TO_SOURCE_ID_NUM_4	NUMBER	(15)
APPLIED_TO_SOURCE_ID_CHAR_1	VARCHAR2	(30)
APPLIED_TO_SOURCE_ID_CHAR_2	VARCHAR2	(30)
APPLIED_TO_SOURCE_ID_CHAR_3	VARCHAR2	(30)
APPLIED_TO_SOURCE_ID_CHAR_4	VARCHAR2	(30)
APPLIED_TO_DISTRIBUTION_TYPE	VARCHAR2	(30)
APPLIED_TO_DIST_ID_NUM_1	NUMBER	(15)
APPLIED_TO_DIST_ID_NUM_2	NUMBER	(15)
APPLIED_TO_DIST_ID_NUM_3	NUMBER	(15)
APPLIED_TO_DIST_ID_NUM_4	NUMBER	(15)
APPLIED_TO_DIST_ID_NUM_5	NUMBER	(15)
APPLIED_TO_DIST_ID_CHAR_1	VARCHAR2	(30)
APPLIED_TO_DIST_ID_CHAR_2	VARCHAR2	(30)
APPLIED_TO_DIST_ID_CHAR_3	VARCHAR2	(30)
APPLIED_TO_DIST_ID_CHAR_4	VARCHAR2	(30)
APPLIED_TO_DIST_ID_CHAR_5	VARCHAR2	(30)
ALLOC_TO_APPLICATION_ID	NUMBER	(15)
ALLOC_TO_ENTITY_CODE	VARCHAR2	(30)
ALLOC_TO_SOURCE_ID_NUM_1	NUMBER	(15)
ALLOC_TO_SOURCE_ID_NUM_2	NUMBER	(15)
ALLOC_TO_SOURCE_ID_NUM_3	NUMBER	(15)
ALLOC_TO_SOURCE_ID_NUM_4	NUMBER	(15)
ALLOC_TO_SOURCE_ID_CHAR_1	VARCHAR2	(30)
ALLOC_TO_SOURCE_ID_CHAR_2	VARCHAR2	(30)
ALLOC_TO_SOURCE_ID_CHAR_3	VARCHAR2	(30)
ALLOC_TO_SOURCE_ID_CHAR_4	VARCHAR2	(30)
ALLOC_TO_DISTRIBUTION_TYPE	VARCHAR2	(30)
ALLOC_TO_DIST_ID_NUM_1	NUMBER	(15)
ALLOC_TO_DIST_ID_NUM_2	NUMBER	(15)
ALLOC_TO_DIST_ID_NUM_3	NUMBER	(15)
ALLOC_TO_DIST_ID_NUM_4	NUMBER	(15)
ALLOC_TO_DIST_ID_NUM_5	NUMBER	(15)
ALLOC_TO_DIST_ID_CHAR_1	VARCHAR2	(30)
ALLOC_TO_DIST_ID_CHAR_2	VARCHAR2	(30)
ALLOC_TO_DIST_ID_CHAR_3	VARCHAR2	(30)
ALLOC_TO_DIST_ID_CHAR_4	VARCHAR2	(30)
ALLOC_TO_DIST_ID_CHAR_5	VARCHAR2	(30)
GAIN_OR_LOSS_REF	VARCHAR2	(30)		Used to group entry lines together when calculating gain/loss.

Query Text

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


SELECT APPLICATION_ID
,      EVENT_ID
,      AE_HEADER_ID
,      AE_LINE_NUM
,      SOURCE_DISTRIBUTION_TYPE
,      SOURCE_DISTRIBUTION_ID_CHAR_1
,      SOURCE_DISTRIBUTION_ID_CHAR_2
,      SOURCE_DISTRIBUTION_ID_CHAR_3
,      SOURCE_DISTRIBUTION_ID_CHAR_4
,      SOURCE_DISTRIBUTION_ID_CHAR_5
,      SOURCE_DISTRIBUTION_ID_NUM_1
,      SOURCE_DISTRIBUTION_ID_NUM_2
,      SOURCE_DISTRIBUTION_ID_NUM_3
,      SOURCE_DISTRIBUTION_ID_NUM_4
,      SOURCE_DISTRIBUTION_ID_NUM_5
,      TAX_LINE_REF_ID
,      TAX_SUMMARY_LINE_REF_ID
,      TAX_REC_NREC_DIST_REF_ID
,      STATISTICAL_AMOUNT
,      REF_AE_HEADER_ID
,      REF_TEMP_LINE_NUM
,      ACCOUNTING_LINE_CODE
,      ACCOUNTING_LINE_TYPE_CODE
,      MERGE_DUPLICATE_CODE
,      TEMP_LINE_NUM
,      REF_EVENT_ID
,      LINE_DEFINITION_OWNER_CODE
,      LINE_DEFINITION_CODE
,      EVENT_CLASS_CODE
,      EVENT_TYPE_CODE
,      UPG_BATCH_ID
,      CALCULATE_ACCTD_AMTS_FLAG
,      CALCULATE_G_L_AMTS_FLAG
,      ROUNDING_CLASS_CODE
,      DOCUMENT_ROUNDING_LEVEL
,      UNROUNDED_ENTERED_DR
,      UNROUNDED_ENTERED_CR
,      DOC_ROUNDING_ENTERED_AMT
,      DOC_ROUNDING_ACCTD_AMT
,      UNROUNDED_ACCOUNTED_CR
,      UNROUNDED_ACCOUNTED_DR
,      APPLIED_TO_APPLICATION_ID
,      APPLIED_TO_ENTITY_CODE
,      APPLIED_TO_ENTITY_ID
,      APPLIED_TO_SOURCE_ID_NUM_1
,      APPLIED_TO_SOURCE_ID_NUM_2
,      APPLIED_TO_SOURCE_ID_NUM_3
,      APPLIED_TO_SOURCE_ID_NUM_4
,      APPLIED_TO_SOURCE_ID_CHAR_1
,      APPLIED_TO_SOURCE_ID_CHAR_2
,      APPLIED_TO_SOURCE_ID_CHAR_3
,      APPLIED_TO_SOURCE_ID_CHAR_4
,      APPLIED_TO_DISTRIBUTION_TYPE
,      APPLIED_TO_DIST_ID_NUM_1
,      APPLIED_TO_DIST_ID_NUM_2
,      APPLIED_TO_DIST_ID_NUM_3
,      APPLIED_TO_DIST_ID_NUM_4
,      APPLIED_TO_DIST_ID_NUM_5
,      APPLIED_TO_DIST_ID_CHAR_1
,      APPLIED_TO_DIST_ID_CHAR_2
,      APPLIED_TO_DIST_ID_CHAR_3
,      APPLIED_TO_DIST_ID_CHAR_4
,      APPLIED_TO_DIST_ID_CHAR_5
,      ALLOC_TO_APPLICATION_ID
,      ALLOC_TO_ENTITY_CODE
,      ALLOC_TO_SOURCE_ID_NUM_1
,      ALLOC_TO_SOURCE_ID_NUM_2
,      ALLOC_TO_SOURCE_ID_NUM_3
,      ALLOC_TO_SOURCE_ID_NUM_4
,      ALLOC_TO_SOURCE_ID_CHAR_1
,      ALLOC_TO_SOURCE_ID_CHAR_2
,      ALLOC_TO_SOURCE_ID_CHAR_3
,      ALLOC_TO_SOURCE_ID_CHAR_4
,      ALLOC_TO_DISTRIBUTION_TYPE
,      ALLOC_TO_DIST_ID_NUM_1
,      ALLOC_TO_DIST_ID_NUM_2
,      ALLOC_TO_DIST_ID_NUM_3
,      ALLOC_TO_DIST_ID_NUM_4
,      ALLOC_TO_DIST_ID_NUM_5
,      ALLOC_TO_DIST_ID_CHAR_1
,      ALLOC_TO_DIST_ID_CHAR_2
,      ALLOC_TO_DIST_ID_CHAR_3
,      ALLOC_TO_DIST_ID_CHAR_4
,      ALLOC_TO_DIST_ID_CHAR_5
,      GAIN_OR_LOSS_REF
FROM XLA.XLA_DISTRIBUTION_LINKS;

Dependencies

[top of page]

XLA.XLA_DISTRIBUTION_LINKS does not reference any database object

XLA.XLA_DISTRIBUTION_LINKS is referenced by following:

XLA: XLA_DISTRIBUTION_LINKS#