69568: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
69569: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
69570: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
69571: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
69572: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
69573: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
69574: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
69575: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
69576: WHEN 13 THEN 'AR_CM_LINES_BASE_V'
69569: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
69570: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
69571: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
69572: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
69573: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
69574: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
69575: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
69576: WHEN 13 THEN 'AR_CM_LINES_BASE_V'
69577: WHEN 14 THEN 'AR_CM_LINES_BASE_V'
69570: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
69571: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
69572: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
69573: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
69574: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
69575: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
69576: WHEN 13 THEN 'AR_CM_LINES_BASE_V'
69577: WHEN 14 THEN 'AR_CM_LINES_BASE_V'
69578: WHEN 15 THEN 'AR_CM_LINES_BASE_V'
69571: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
69572: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
69573: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
69574: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
69575: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
69576: WHEN 13 THEN 'AR_CM_LINES_BASE_V'
69577: WHEN 14 THEN 'AR_CM_LINES_BASE_V'
69578: WHEN 15 THEN 'AR_CM_LINES_BASE_V'
69579: WHEN 16 THEN 'AR_CM_LINES_L_V'
69572: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
69573: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
69574: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
69575: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
69576: WHEN 13 THEN 'AR_CM_LINES_BASE_V'
69577: WHEN 14 THEN 'AR_CM_LINES_BASE_V'
69578: WHEN 15 THEN 'AR_CM_LINES_BASE_V'
69579: WHEN 16 THEN 'AR_CM_LINES_L_V'
69580: WHEN 17 THEN 'AR_CM_LINES_L_V'
69573: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
69574: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
69575: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
69576: WHEN 13 THEN 'AR_CM_LINES_BASE_V'
69577: WHEN 14 THEN 'AR_CM_LINES_BASE_V'
69578: WHEN 15 THEN 'AR_CM_LINES_BASE_V'
69579: WHEN 16 THEN 'AR_CM_LINES_L_V'
69580: WHEN 17 THEN 'AR_CM_LINES_L_V'
69581: WHEN 18 THEN 'AR_CM_LINES_L_V'
69574: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
69575: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
69576: WHEN 13 THEN 'AR_CM_LINES_BASE_V'
69577: WHEN 14 THEN 'AR_CM_LINES_BASE_V'
69578: WHEN 15 THEN 'AR_CM_LINES_BASE_V'
69579: WHEN 16 THEN 'AR_CM_LINES_L_V'
69580: WHEN 17 THEN 'AR_CM_LINES_L_V'
69581: WHEN 18 THEN 'AR_CM_LINES_L_V'
69582:
69672: ELSE null
69673: END source_value
69674: , null source_meaning
69675: FROM xla_events_gt xet
69676: , AR_CM_LINES_BASE_V l3
69677: , AR_CM_LINES_L_V l4
69678: , AR_DISTRIBUTIONS_L_V l6
69679: , AR_RECEIVABLES_TRX_ACT_S_V l7
69680: , AR_TRANSACTIONS_S_V l9
69837: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
69838: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
69839: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
69840: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
69841: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
69842: TYPE t_array_source_43 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
69843: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
69844: TYPE t_array_source_46 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
69845: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69838: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
69839: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
69840: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
69841: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
69842: TYPE t_array_source_43 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
69843: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
69844: TYPE t_array_source_46 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
69845: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69846: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
69839: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
69840: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
69841: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
69842: TYPE t_array_source_43 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
69843: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
69844: TYPE t_array_source_46 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
69845: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69846: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
69847: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
69840: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
69841: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
69842: TYPE t_array_source_43 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
69843: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
69844: TYPE t_array_source_46 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
69845: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69846: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
69847: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
69848: TYPE t_array_source_52 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
69841: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
69842: TYPE t_array_source_43 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
69843: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
69844: TYPE t_array_source_46 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
69845: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69846: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
69847: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
69848: TYPE t_array_source_52 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
69849: TYPE t_array_source_53 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
69842: TYPE t_array_source_43 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
69843: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
69844: TYPE t_array_source_46 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
69845: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69846: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
69847: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
69848: TYPE t_array_source_52 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
69849: TYPE t_array_source_53 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
69850: TYPE t_array_source_54 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
69843: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
69844: TYPE t_array_source_46 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
69845: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69846: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
69847: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
69848: TYPE t_array_source_52 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
69849: TYPE t_array_source_53 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
69850: TYPE t_array_source_54 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
69851:
69974: , l4.CM_TAX_LINE_ID source_52
69975: , l4.CM_LINE_DIST_ACCOUNT_CLASS source_53
69976: , l4.CM_LINE_DIST_AMT source_54
69977: FROM xla_events_gt xet
69978: , AR_CM_LINES_BASE_V l3
69979: , AR_CM_LINES_L_V l4
69980: , AR_DISTRIBUTIONS_L_V l6
69981: , AR_RECEIVABLES_TRX_ACT_S_V l7
69982: , AR_TRANSACTIONS_S_V l9