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.

APPS.XLA_00222_AAD_S_000005_PKG dependencies on AR_DISTRIBUTIONS_L_V

Line 66874: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'

66870: FROM (
66871: SELECT xet.event_id event_id
66872: , l5.line_number line_number
66873: , CASE r
66874: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
66875: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
66876: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
66877: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
66878: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

Line 66875: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'

66871: SELECT xet.event_id event_id
66872: , l5.line_number line_number
66873: , CASE r
66874: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
66875: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
66876: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
66877: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
66878: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
66879: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

Line 66876: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'

66872: , l5.line_number line_number
66873: , CASE r
66874: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
66875: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
66876: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
66877: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
66878: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
66879: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
66880: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 66877: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'

66873: , CASE r
66874: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
66875: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
66876: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
66877: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
66878: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
66879: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
66880: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
66881: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 66878: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

66874: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
66875: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
66876: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
66877: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
66878: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
66879: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
66880: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
66881: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
66882: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 66879: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

66875: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
66876: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
66877: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
66878: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
66879: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
66880: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
66881: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
66882: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
66883: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 66947: , AR_DISTRIBUTIONS_L_V l5

66943: END source_value
66944: , null source_meaning
66945: FROM xla_events_gt xet
66946: , AR_DISTRIBUTIONS_BASE_V l4
66947: , AR_DISTRIBUTIONS_L_V l5
66948: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
66949: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
66950: AND xet.event_class_code = C_EVENT_CLASS_CODE
66951: AND l4.event_id = xet.event_id

Line 67095: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

67091: TYPE t_array_source_77 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
67092: TYPE t_array_source_78 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
67093: TYPE t_array_source_79 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
67094:
67095: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
67096: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
67097: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
67098: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
67099: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 67096: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

67092: TYPE t_array_source_78 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
67093: TYPE t_array_source_79 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
67094:
67095: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
67096: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
67097: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
67098: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
67099: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
67100: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 67097: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

67093: TYPE t_array_source_79 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
67094:
67095: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
67096: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
67097: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
67098: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
67099: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
67100: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
67101: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 67098: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

67094:
67095: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
67096: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
67097: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
67098: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
67099: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
67100: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
67101: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
67102: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 67099: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

67095: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
67096: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
67097: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
67098: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
67099: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
67100: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
67101: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
67102: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
67103: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 67100: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

67096: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
67097: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
67098: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
67099: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
67100: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
67101: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
67102: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
67103: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
67104: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 67221: , AR_DISTRIBUTIONS_L_V l5

67217: , l4.DIST_CUR_CONVERSION_TYPE source_28
67218: , l4.DIST_TO_ACCTD_AMT source_29
67219: FROM xla_events_gt xet
67220: , AR_DISTRIBUTIONS_BASE_V l4
67221: , AR_DISTRIBUTIONS_L_V l5
67222: WHERE xet.event_id between x_first_event_id and x_last_event_id
67223: and xet.event_date between p_pad_start_date and p_pad_end_date
67224: and xet.event_class_code = C_EVENT_CLASS_CODE
67225: and xet.event_status_code <> 'N' AND l4.event_id = xet.event_id

Line 69568: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

69564: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
69565: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
69566: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
69567: WHEN 4 THEN 'AR_CM_LINES_L_V'
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'

Line 69569: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

69565: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
69566: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
69567: WHEN 4 THEN 'AR_CM_LINES_L_V'
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'

Line 69571: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'

69567: WHEN 4 THEN 'AR_CM_LINES_L_V'
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'

Line 69678: , AR_DISTRIBUTIONS_L_V l6

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
69681: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
69682: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 69837: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

69833: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
69834: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
69835: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69836: TYPE t_array_source_4 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
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;

Line 69838: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

69834: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
69835: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69836: TYPE t_array_source_4 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
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;

Line 69840: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

69836: TYPE t_array_source_4 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
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;

Line 69980: , AR_DISTRIBUTIONS_L_V l6

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
69983: WHERE xet.event_id between x_first_event_id and x_last_event_id
69984: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 76954: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'

76950: FROM (
76951: SELECT xet.event_id event_id
76952: , l3.line_number line_number
76953: , CASE r
76954: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
76955: WHEN 2 THEN 'FV_XLA_AR_REF_V'
76956: WHEN 3 THEN 'FV_XLA_AR_REF_V'
76957: WHEN 4 THEN 'FV_XLA_AR_REF_V'
76958: WHEN 5 THEN 'FV_XLA_AR_REF_V'

Line 76960: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'

76956: WHEN 3 THEN 'FV_XLA_AR_REF_V'
76957: WHEN 4 THEN 'FV_XLA_AR_REF_V'
76958: WHEN 5 THEN 'FV_XLA_AR_REF_V'
76959: WHEN 6 THEN 'FV_XLA_AR_REF_V'
76960: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
76961: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
76962: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
76963: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
76964: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'

Line 76961: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'

76957: WHEN 4 THEN 'FV_XLA_AR_REF_V'
76958: WHEN 5 THEN 'FV_XLA_AR_REF_V'
76959: WHEN 6 THEN 'FV_XLA_AR_REF_V'
76960: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
76961: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
76962: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
76963: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
76964: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
76965: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 76962: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'

76958: WHEN 5 THEN 'FV_XLA_AR_REF_V'
76959: WHEN 6 THEN 'FV_XLA_AR_REF_V'
76960: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
76961: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
76962: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
76963: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
76964: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
76965: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
76966: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 76963: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'

76959: WHEN 6 THEN 'FV_XLA_AR_REF_V'
76960: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
76961: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
76962: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
76963: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
76964: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
76965: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
76966: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
76967: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 76964: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'

76960: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
76961: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
76962: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
76963: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
76964: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
76965: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
76966: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
76967: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'
76968: WHEN 15 THEN 'FV_XLA_AR_REF_V'

Line 76970: WHEN 17 THEN 'AR_DISTRIBUTIONS_L_V'

76966: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
76967: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'
76968: WHEN 15 THEN 'FV_XLA_AR_REF_V'
76969: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
76970: WHEN 17 THEN 'AR_DISTRIBUTIONS_L_V'
76971:
76972: ELSE null
76973: END object_name
76974: , CASE r

Line 77062: , AR_DISTRIBUTIONS_L_V l3

77058: END source_value
77059: , null source_meaning
77060: FROM xla_events_gt xet
77061: , AR_DISTRIBUTIONS_BASE_V l2
77062: , AR_DISTRIBUTIONS_L_V l3
77063: , FV_XLA_AR_REF_V l4
77064: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
77065: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77066: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 77208: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

77204: TYPE t_array_source_84 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
77205: TYPE t_array_source_85 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
77206: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
77207:
77208: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
77209: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77210: TYPE t_array_source_12 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
77211: TYPE t_array_source_13 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
77212: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;

Line 77214: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

77210: TYPE t_array_source_12 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
77211: TYPE t_array_source_13 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
77212: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
77213: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77214: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77215: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
77216: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77217: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
77218: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 77215: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

77211: TYPE t_array_source_13 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
77212: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
77213: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77214: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77215: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
77216: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77217: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
77218: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
77219: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 77216: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

77212: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
77213: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77214: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77215: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
77216: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77217: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
77218: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
77219: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
77220: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 77217: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

77213: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77214: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77215: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
77216: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77217: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
77218: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
77219: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
77220: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77221: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 77218: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

77214: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77215: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
77216: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77217: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
77218: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
77219: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
77220: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77221: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
77222: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 77224: TYPE t_array_source_67 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;

77220: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77221: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
77222: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
77223: TYPE t_array_source_57 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
77224: TYPE t_array_source_67 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
77225:
77226: l_array_source_83 t_array_source_83;
77227: l_array_source_84 t_array_source_84;
77228: l_array_source_85 t_array_source_85;

Line 77341: , AR_DISTRIBUTIONS_L_V l3

77337: , l2.DIST_TO_CUR_CONVERSION_DATE source_57
77338: , l3.DIST_MFAR_ADDITIONAL_ENTRY source_67
77339: FROM xla_events_gt xet
77340: , AR_DISTRIBUTIONS_BASE_V l2
77341: , AR_DISTRIBUTIONS_L_V l3
77342: , FV_XLA_AR_REF_V l4
77343: WHERE xet.event_id between x_first_event_id and x_last_event_id
77344: and xet.event_date between p_pad_start_date and p_pad_end_date
77345: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 78721: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'

78717: , CASE r
78718: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
78719: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
78720: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
78721: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
78722: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
78723: WHEN 6 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
78724: WHEN 7 THEN 'FV_XLA_AR_REF_V'
78725: WHEN 8 THEN 'FV_XLA_AR_REF_V'

Line 78722: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

78718: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
78719: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
78720: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
78721: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
78722: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
78723: WHEN 6 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
78724: WHEN 7 THEN 'FV_XLA_AR_REF_V'
78725: WHEN 8 THEN 'FV_XLA_AR_REF_V'
78726: WHEN 9 THEN 'FV_XLA_AR_REF_V'

Line 78729: WHEN 12 THEN 'AR_DISTRIBUTIONS_L_V'

78725: WHEN 8 THEN 'FV_XLA_AR_REF_V'
78726: WHEN 9 THEN 'FV_XLA_AR_REF_V'
78727: WHEN 10 THEN 'FV_XLA_AR_REF_V'
78728: WHEN 11 THEN 'FV_XLA_AR_REF_V'
78729: WHEN 12 THEN 'AR_DISTRIBUTIONS_L_V'
78730: WHEN 13 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
78731: WHEN 14 THEN 'AR_DISTRIBUTIONS_L_V'
78732: WHEN 15 THEN 'AR_DISTRIBUTIONS_L_V'
78733: WHEN 16 THEN 'AR_DISTRIBUTIONS_L_V'

Line 78731: WHEN 14 THEN 'AR_DISTRIBUTIONS_L_V'

78727: WHEN 10 THEN 'FV_XLA_AR_REF_V'
78728: WHEN 11 THEN 'FV_XLA_AR_REF_V'
78729: WHEN 12 THEN 'AR_DISTRIBUTIONS_L_V'
78730: WHEN 13 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
78731: WHEN 14 THEN 'AR_DISTRIBUTIONS_L_V'
78732: WHEN 15 THEN 'AR_DISTRIBUTIONS_L_V'
78733: WHEN 16 THEN 'AR_DISTRIBUTIONS_L_V'
78734: WHEN 17 THEN 'AR_DISTRIBUTIONS_L_V'
78735: WHEN 18 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 78732: WHEN 15 THEN 'AR_DISTRIBUTIONS_L_V'

78728: WHEN 11 THEN 'FV_XLA_AR_REF_V'
78729: WHEN 12 THEN 'AR_DISTRIBUTIONS_L_V'
78730: WHEN 13 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
78731: WHEN 14 THEN 'AR_DISTRIBUTIONS_L_V'
78732: WHEN 15 THEN 'AR_DISTRIBUTIONS_L_V'
78733: WHEN 16 THEN 'AR_DISTRIBUTIONS_L_V'
78734: WHEN 17 THEN 'AR_DISTRIBUTIONS_L_V'
78735: WHEN 18 THEN 'AR_DISTRIBUTIONS_BASE_V'
78736: WHEN 19 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 78733: WHEN 16 THEN 'AR_DISTRIBUTIONS_L_V'

78729: WHEN 12 THEN 'AR_DISTRIBUTIONS_L_V'
78730: WHEN 13 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
78731: WHEN 14 THEN 'AR_DISTRIBUTIONS_L_V'
78732: WHEN 15 THEN 'AR_DISTRIBUTIONS_L_V'
78733: WHEN 16 THEN 'AR_DISTRIBUTIONS_L_V'
78734: WHEN 17 THEN 'AR_DISTRIBUTIONS_L_V'
78735: WHEN 18 THEN 'AR_DISTRIBUTIONS_BASE_V'
78736: WHEN 19 THEN 'AR_DISTRIBUTIONS_BASE_V'
78737: WHEN 20 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 78734: WHEN 17 THEN 'AR_DISTRIBUTIONS_L_V'

78730: WHEN 13 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
78731: WHEN 14 THEN 'AR_DISTRIBUTIONS_L_V'
78732: WHEN 15 THEN 'AR_DISTRIBUTIONS_L_V'
78733: WHEN 16 THEN 'AR_DISTRIBUTIONS_L_V'
78734: WHEN 17 THEN 'AR_DISTRIBUTIONS_L_V'
78735: WHEN 18 THEN 'AR_DISTRIBUTIONS_BASE_V'
78736: WHEN 19 THEN 'AR_DISTRIBUTIONS_BASE_V'
78737: WHEN 20 THEN 'AR_DISTRIBUTIONS_BASE_V'
78738: WHEN 21 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 78746: WHEN 29 THEN 'AR_DISTRIBUTIONS_L_V'

78742: WHEN 25 THEN 'FV_XLA_AR_REF_V'
78743: WHEN 26 THEN 'AR_DISTRIBUTIONS_BASE_V'
78744: WHEN 27 THEN 'AR_TRANSACTIONS_S_V'
78745: WHEN 28 THEN 'AR_TRANSACTIONS_S_V'
78746: WHEN 29 THEN 'AR_DISTRIBUTIONS_L_V'
78747: WHEN 30 THEN 'AR_DISTRIBUTIONS_BASE_V'
78748: WHEN 31 THEN 'AR_DISTRIBUTIONS_L_V'
78749: WHEN 32 THEN 'AR_DISTRIBUTIONS_L_V'
78750: WHEN 33 THEN 'AR_DISTRIBUTIONS_L_V'

Line 78748: WHEN 31 THEN 'AR_DISTRIBUTIONS_L_V'

78744: WHEN 27 THEN 'AR_TRANSACTIONS_S_V'
78745: WHEN 28 THEN 'AR_TRANSACTIONS_S_V'
78746: WHEN 29 THEN 'AR_DISTRIBUTIONS_L_V'
78747: WHEN 30 THEN 'AR_DISTRIBUTIONS_BASE_V'
78748: WHEN 31 THEN 'AR_DISTRIBUTIONS_L_V'
78749: WHEN 32 THEN 'AR_DISTRIBUTIONS_L_V'
78750: WHEN 33 THEN 'AR_DISTRIBUTIONS_L_V'
78751: WHEN 34 THEN 'AR_DISTRIBUTIONS_L_V'
78752: WHEN 35 THEN 'AR_DISTRIBUTIONS_L_V'

Line 78749: WHEN 32 THEN 'AR_DISTRIBUTIONS_L_V'

78745: WHEN 28 THEN 'AR_TRANSACTIONS_S_V'
78746: WHEN 29 THEN 'AR_DISTRIBUTIONS_L_V'
78747: WHEN 30 THEN 'AR_DISTRIBUTIONS_BASE_V'
78748: WHEN 31 THEN 'AR_DISTRIBUTIONS_L_V'
78749: WHEN 32 THEN 'AR_DISTRIBUTIONS_L_V'
78750: WHEN 33 THEN 'AR_DISTRIBUTIONS_L_V'
78751: WHEN 34 THEN 'AR_DISTRIBUTIONS_L_V'
78752: WHEN 35 THEN 'AR_DISTRIBUTIONS_L_V'
78753: WHEN 36 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 78750: WHEN 33 THEN 'AR_DISTRIBUTIONS_L_V'

78746: WHEN 29 THEN 'AR_DISTRIBUTIONS_L_V'
78747: WHEN 30 THEN 'AR_DISTRIBUTIONS_BASE_V'
78748: WHEN 31 THEN 'AR_DISTRIBUTIONS_L_V'
78749: WHEN 32 THEN 'AR_DISTRIBUTIONS_L_V'
78750: WHEN 33 THEN 'AR_DISTRIBUTIONS_L_V'
78751: WHEN 34 THEN 'AR_DISTRIBUTIONS_L_V'
78752: WHEN 35 THEN 'AR_DISTRIBUTIONS_L_V'
78753: WHEN 36 THEN 'AR_DISTRIBUTIONS_BASE_V'
78754: WHEN 37 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 78751: WHEN 34 THEN 'AR_DISTRIBUTIONS_L_V'

78747: WHEN 30 THEN 'AR_DISTRIBUTIONS_BASE_V'
78748: WHEN 31 THEN 'AR_DISTRIBUTIONS_L_V'
78749: WHEN 32 THEN 'AR_DISTRIBUTIONS_L_V'
78750: WHEN 33 THEN 'AR_DISTRIBUTIONS_L_V'
78751: WHEN 34 THEN 'AR_DISTRIBUTIONS_L_V'
78752: WHEN 35 THEN 'AR_DISTRIBUTIONS_L_V'
78753: WHEN 36 THEN 'AR_DISTRIBUTIONS_BASE_V'
78754: WHEN 37 THEN 'AR_DISTRIBUTIONS_BASE_V'
78755: WHEN 38 THEN 'AR_DISTRIBUTIONS_L_V'

Line 78752: WHEN 35 THEN 'AR_DISTRIBUTIONS_L_V'

78748: WHEN 31 THEN 'AR_DISTRIBUTIONS_L_V'
78749: WHEN 32 THEN 'AR_DISTRIBUTIONS_L_V'
78750: WHEN 33 THEN 'AR_DISTRIBUTIONS_L_V'
78751: WHEN 34 THEN 'AR_DISTRIBUTIONS_L_V'
78752: WHEN 35 THEN 'AR_DISTRIBUTIONS_L_V'
78753: WHEN 36 THEN 'AR_DISTRIBUTIONS_BASE_V'
78754: WHEN 37 THEN 'AR_DISTRIBUTIONS_BASE_V'
78755: WHEN 38 THEN 'AR_DISTRIBUTIONS_L_V'
78756:

Line 78755: WHEN 38 THEN 'AR_DISTRIBUTIONS_L_V'

78751: WHEN 34 THEN 'AR_DISTRIBUTIONS_L_V'
78752: WHEN 35 THEN 'AR_DISTRIBUTIONS_L_V'
78753: WHEN 36 THEN 'AR_DISTRIBUTIONS_BASE_V'
78754: WHEN 37 THEN 'AR_DISTRIBUTIONS_BASE_V'
78755: WHEN 38 THEN 'AR_DISTRIBUTIONS_L_V'
78756:
78757: ELSE null
78758: END object_name
78759: , CASE r

Line 78933: , AR_DISTRIBUTIONS_L_V l5

78929: FROM xla_events_gt xet
78930: , AR_BILL_TO_CUSTOMERS_S_V l1
78931: , AR_CUST_TRX_LINES_L_V l3
78932: , AR_DISTRIBUTIONS_BASE_V l4
78933: , AR_DISTRIBUTIONS_L_V l5
78934: , AR_RECEIVABLES_TRX_ACT_S_V l7
78935: , AR_TRANSACTIONS_S_V l10
78936: , FV_XLA_AR_REF_V l11
78937: , (select rownum r from all_objects where rownum <= 38 and owner = p_apps_owner)

Line 79102: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

79098:
79099: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
79100: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
79101: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79102: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79103: TYPE t_array_source_6 IS TABLE OF AR_DISTRIBUTIONS_L_V.GAIN_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
79104: TYPE t_array_source_10 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
79105: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_RULE%TYPE INDEX BY BINARY_INTEGER;
79106: TYPE t_array_source_12 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;

Line 79103: TYPE t_array_source_6 IS TABLE OF AR_DISTRIBUTIONS_L_V.GAIN_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

79099: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
79100: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
79101: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79102: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79103: TYPE t_array_source_6 IS TABLE OF AR_DISTRIBUTIONS_L_V.GAIN_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
79104: TYPE t_array_source_10 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
79105: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_RULE%TYPE INDEX BY BINARY_INTEGER;
79106: TYPE t_array_source_12 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
79107: TYPE t_array_source_13 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 79110: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

79106: TYPE t_array_source_12 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
79107: TYPE t_array_source_13 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
79108: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
79109: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79110: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79111: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
79112: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
79113: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79114: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 79112: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

79108: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
79109: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79110: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79111: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
79112: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
79113: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79114: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
79115: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
79116: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 79113: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

79109: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79110: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79111: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
79112: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
79113: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79114: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
79115: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
79116: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79117: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 79114: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

79110: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79111: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
79112: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
79113: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79114: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
79115: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
79116: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79117: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79118: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 79115: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

79111: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
79112: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
79113: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79114: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
79115: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
79116: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79117: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79118: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79119: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 79127: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;

79123: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
79124: TYPE t_array_source_57 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79125: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
79126: TYPE t_array_source_60 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
79127: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
79128: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79129: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
79130: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
79131: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 79129: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;

79125: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
79126: TYPE t_array_source_60 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
79127: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
79128: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79129: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
79130: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
79131: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
79132: TYPE t_array_source_67 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
79133: TYPE t_array_source_68 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;

Line 79130: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

79126: TYPE t_array_source_60 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
79127: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
79128: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79129: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
79130: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
79131: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
79132: TYPE t_array_source_67 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
79133: TYPE t_array_source_68 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
79134: TYPE t_array_source_69 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 79131: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

79127: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
79128: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79129: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
79130: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
79131: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
79132: TYPE t_array_source_67 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
79133: TYPE t_array_source_68 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
79134: TYPE t_array_source_69 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79135: TYPE t_array_source_70 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 79132: TYPE t_array_source_67 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;

79128: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79129: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
79130: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
79131: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
79132: TYPE t_array_source_67 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
79133: TYPE t_array_source_68 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
79134: TYPE t_array_source_69 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79135: TYPE t_array_source_70 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79136: TYPE t_array_source_71 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;

Line 79133: TYPE t_array_source_68 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;

79129: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
79130: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
79131: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
79132: TYPE t_array_source_67 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
79133: TYPE t_array_source_68 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
79134: TYPE t_array_source_69 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79135: TYPE t_array_source_70 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79136: TYPE t_array_source_71 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;
79137:

Line 79136: TYPE t_array_source_71 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;

79132: TYPE t_array_source_67 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
79133: TYPE t_array_source_68 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
79134: TYPE t_array_source_69 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79135: TYPE t_array_source_70 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79136: TYPE t_array_source_71 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;
79137:
79138: l_array_source_7 t_array_source_7;
79139: l_array_source_8 t_array_source_8;
79140: l_array_source_17 t_array_source_17;

Line 79323: , AR_DISTRIBUTIONS_L_V l5

79319: FROM xla_events_gt xet
79320: , AR_BILL_TO_CUSTOMERS_S_V l1
79321: , AR_CUST_TRX_LINES_L_V l3
79322: , AR_DISTRIBUTIONS_BASE_V l4
79323: , AR_DISTRIBUTIONS_L_V l5
79324: , AR_RECEIVABLES_TRX_ACT_S_V l7
79325: , AR_TRANSACTIONS_S_V l10
79326: , FV_XLA_AR_REF_V l11
79327: WHERE xet.event_id between x_first_event_id and x_last_event_id