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]

VIEW: XLA.XLA_DISTRIBUTION_LINKS#

Object Details

Object Name:	XLA_DISTRIBUTION_LINKS#
Object Type:	VIEW
Owner:	XLA
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
APPLICATION_ID	NUMBER	(15)	Yes
EVENT_ID	NUMBER	(15)	Yes
AE_HEADER_ID	NUMBER	(15)	Yes
AE_LINE_NUM	NUMBER	(38)	Yes
SOURCE_DISTRIBUTION_TYPE	VARCHAR2	(30)	Yes
SOURCE_DISTRIBUTION_ID_CHAR_1	VARCHAR2	(240)
SOURCE_DISTRIBUTION_ID_CHAR_2	VARCHAR2	(240)
SOURCE_DISTRIBUTION_ID_CHAR_3	VARCHAR2	(240)
SOURCE_DISTRIBUTION_ID_CHAR_4	VARCHAR2	(240)
SOURCE_DISTRIBUTION_ID_CHAR_5	VARCHAR2	(240)
SOURCE_DISTRIBUTION_ID_NUM_1	NUMBER	(38)
SOURCE_DISTRIBUTION_ID_NUM_2	NUMBER	(38)
SOURCE_DISTRIBUTION_ID_NUM_3	NUMBER	(38)
SOURCE_DISTRIBUTION_ID_NUM_4	NUMBER	(38)
SOURCE_DISTRIBUTION_ID_NUM_5	NUMBER	(38)
TAX_LINE_REF_ID	NUMBER	(15)
TAX_SUMMARY_LINE_REF_ID	NUMBER	(15)
TAX_REC_NREC_DIST_REF_ID	NUMBER	(15)
STATISTICAL_AMOUNT	NUMBER
REF_AE_HEADER_ID	NUMBER	(15)	Yes
REF_TEMP_LINE_NUM	NUMBER	(15)
ACCOUNTING_LINE_CODE	VARCHAR2	(30)
ACCOUNTING_LINE_TYPE_CODE	VARCHAR2	(1)
MERGE_DUPLICATE_CODE	VARCHAR2	(1)	Yes
TEMP_LINE_NUM	NUMBER	(15)	Yes
REF_EVENT_ID	NUMBER	(15)
LINE_DEFINITION_OWNER_CODE	VARCHAR2	(30)
LINE_DEFINITION_CODE	VARCHAR2	(30)
EVENT_CLASS_CODE	VARCHAR2	(30)
EVENT_TYPE_CODE	VARCHAR2	(30)
UPG_BATCH_ID	NUMBER	(15)
CALCULATE_ACCTD_AMTS_FLAG	VARCHAR2	(1)
CALCULATE_G_L_AMTS_FLAG	VARCHAR2	(1)
ROUNDING_CLASS_CODE	VARCHAR2	(30)
DOCUMENT_ROUNDING_LEVEL	VARCHAR2	(30)
UNROUNDED_ENTERED_DR	NUMBER
UNROUNDED_ENTERED_CR	NUMBER
DOC_ROUNDING_ENTERED_AMT	NUMBER
DOC_ROUNDING_ACCTD_AMT	NUMBER
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)

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# references the following:

XLA: XLA_DISTRIBUTION_LINKS

XLA.XLA_DISTRIBUTION_LINKS# is referenced by following:

APPS: XLA_DISTRIBUTION_LINKS