VIEW: XLA.XLA_DISTRIBUTION_LINKS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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