Skip to content

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 Comments
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:

SchemaXLA
TableXLA_DISTRIBUTION_LINKS
XLA.XLA_DISTRIBUTION_LINKS# is referenced by following:

SchemaAPPS
SynonymXLA_DISTRIBUTION_LINKS