[Home] [Help] [Dependency Information]
Object Name: | XLA_DISTRIBUTION_LINKS# |
---|---|
Object Type: | VIEW |
Owner: | XLA |
Subobject Name: | |
Status: | VALID |
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) |
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#;
|
|
|