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_000002_PKG dependencies on AR_DISTRIBUTIONS_BASE_V

Line 66693: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'

66689: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
66690: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
66691: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
66692: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
66693: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
66694: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
66695: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
66696: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
66697:

Line 66694: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'

66690: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
66691: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
66692: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
66693: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
66694: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
66695: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
66696: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
66697:
66698: ELSE null

Line 66695: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'

66691: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
66692: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
66693: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
66694: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
66695: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
66696: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
66697:
66698: ELSE null
66699: END object_name

Line 66696: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'

66692: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
66693: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
66694: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
66695: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
66696: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
66697:
66698: ELSE null
66699: END object_name
66700: , CASE r

Line 66759: , AR_DISTRIBUTIONS_BASE_V l4

66755: ELSE null
66756: END source_value
66757: , null source_meaning
66758: FROM xla_events_gt xet
66759: , AR_DISTRIBUTIONS_BASE_V l4
66760: , AR_DISTRIBUTIONS_L_V l5
66761: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
66762: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
66763: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 66915: TYPE t_array_source_45 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

66911: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
66912: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
66913: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
66914: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
66915: TYPE t_array_source_45 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
66916: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
66917: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
66918: TYPE t_array_source_48 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
66919:

Line 66916: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

66912: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
66913: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
66914: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
66915: TYPE t_array_source_45 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
66916: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
66917: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
66918: TYPE t_array_source_48 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
66919:
66920: l_array_source_1 t_array_source_1;

Line 66917: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

66913: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
66914: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
66915: TYPE t_array_source_45 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
66916: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
66917: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
66918: TYPE t_array_source_48 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
66919:
66920: l_array_source_1 t_array_source_1;
66921: l_array_source_2 t_array_source_2;

Line 66918: TYPE t_array_source_48 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

66914: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
66915: TYPE t_array_source_45 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
66916: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
66917: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
66918: TYPE t_array_source_48 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
66919:
66920: l_array_source_1 t_array_source_1;
66921: l_array_source_2 t_array_source_2;
66922: l_array_source_40 t_array_source_40;

Line 67036: , AR_DISTRIBUTIONS_BASE_V l4

67032: , l4.DIST_CUR_CONVERSION_RATE source_46
67033: , l4.DIST_CUR_CONVERSION_TYPE source_47
67034: , l4.DIST_TO_ACCTD_AMT source_48
67035: FROM xla_events_gt xet
67036: , AR_DISTRIBUTIONS_BASE_V l4
67037: , AR_DISTRIBUTIONS_L_V l5
67038: WHERE xet.event_id between x_first_event_id and x_last_event_id
67039: and xet.event_date between p_pad_start_date and p_pad_end_date
67040: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 68157: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'

68153: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
68154: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
68155: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
68156: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
68157: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
68158: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
68159: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
68160: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
68161:

Line 68158: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'

68154: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
68155: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
68156: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
68157: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
68158: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
68159: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
68160: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
68161:
68162: ELSE null

Line 68159: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'

68155: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
68156: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
68157: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
68158: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
68159: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
68160: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
68161:
68162: ELSE null
68163: END object_name

Line 68160: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'

68156: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
68157: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
68158: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
68159: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
68160: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
68161:
68162: ELSE null
68163: END object_name
68164: , CASE r

Line 68223: , AR_DISTRIBUTIONS_BASE_V l1

68219: ELSE null
68220: END source_value
68221: , null source_meaning
68222: FROM xla_events_gt xet
68223: , AR_DISTRIBUTIONS_BASE_V l1
68224: , AR_DISTRIBUTIONS_L_V l2
68225: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
68226: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68227: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 68378: TYPE t_array_source_45 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

68374: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
68375: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68376: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
68377: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68378: TYPE t_array_source_45 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
68379: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
68380: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68381: TYPE t_array_source_52 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
68382:

Line 68379: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

68375: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68376: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
68377: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68378: TYPE t_array_source_45 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
68379: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
68380: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68381: TYPE t_array_source_52 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
68382:
68383: l_array_source_3 t_array_source_3;

Line 68380: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

68376: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
68377: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68378: TYPE t_array_source_45 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
68379: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
68380: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68381: TYPE t_array_source_52 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
68382:
68383: l_array_source_3 t_array_source_3;
68384: l_array_source_4 t_array_source_4;

Line 68381: TYPE t_array_source_52 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

68377: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68378: TYPE t_array_source_45 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
68379: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
68380: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68381: TYPE t_array_source_52 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
68382:
68383: l_array_source_3 t_array_source_3;
68384: l_array_source_4 t_array_source_4;
68385: l_array_source_34 t_array_source_34;

Line 68495: , AR_DISTRIBUTIONS_BASE_V l1

68491: , l1.DIST_CUR_CONVERSION_RATE source_46
68492: , l1.DIST_CUR_CONVERSION_TYPE source_47
68493: , l1.DIST_ACCTD_AMT source_52
68494: FROM xla_events_gt xet
68495: , AR_DISTRIBUTIONS_BASE_V l1
68496: , AR_DISTRIBUTIONS_L_V l2
68497: WHERE xet.event_id between x_first_event_id and x_last_event_id
68498: and xet.event_date between p_pad_start_date and p_pad_end_date
68499: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 81880: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'

81876: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
81877: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
81878: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
81879: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
81880: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
81881: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
81882: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
81883: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
81884: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 81881: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'

81877: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
81878: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
81879: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
81880: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
81881: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
81882: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
81883: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
81884: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
81885:

Line 81882: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'

81878: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
81879: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
81880: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
81881: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
81882: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
81883: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
81884: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
81885:
81886: ELSE null

Line 81884: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'

81880: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
81881: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
81882: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
81883: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
81884: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
81885:
81886: ELSE null
81887: END object_name
81888: , CASE r

Line 81951: , AR_DISTRIBUTIONS_BASE_V l2

81947: ELSE null
81948: END source_value
81949: , null source_meaning
81950: FROM xla_events_gt xet
81951: , AR_DISTRIBUTIONS_BASE_V l2
81952: , AR_DISTRIBUTIONS_L_V l3
81953: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
81954: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
81955: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 82108: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

82104: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
82105: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
82106: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
82107: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
82108: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
82109: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
82110: TYPE t_array_source_48 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
82111: TYPE t_array_source_99 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
82112: TYPE t_array_source_100 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 82109: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

82105: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
82106: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
82107: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
82108: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
82109: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
82110: TYPE t_array_source_48 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
82111: TYPE t_array_source_99 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
82112: TYPE t_array_source_100 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
82113:

Line 82110: TYPE t_array_source_48 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

82106: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
82107: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
82108: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
82109: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
82110: TYPE t_array_source_48 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
82111: TYPE t_array_source_99 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
82112: TYPE t_array_source_100 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
82113:
82114: l_array_source_16 t_array_source_16;

Line 82112: TYPE t_array_source_100 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

82108: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
82109: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
82110: TYPE t_array_source_48 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
82111: TYPE t_array_source_99 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
82112: TYPE t_array_source_100 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
82113:
82114: l_array_source_16 t_array_source_16;
82115: l_array_source_18 t_array_source_18;
82116: l_array_source_20 t_array_source_20;

Line 82230: , AR_DISTRIBUTIONS_BASE_V l2

82226: , l2.DIST_TO_ACCTD_AMT source_48
82227: , l3.DIST_MFAR_ADDITIONAL_ENTRY source_99
82228: , l2.DIST_TO_CUR_CONVERSION_DATE source_100
82229: FROM xla_events_gt xet
82230: , AR_DISTRIBUTIONS_BASE_V l2
82231: , AR_DISTRIBUTIONS_L_V l3
82232: WHERE xet.event_id between x_first_event_id and x_last_event_id
82233: and xet.event_date between p_pad_start_date and p_pad_end_date
82234: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 83409: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'

83405: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
83406: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
83407: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
83408: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
83409: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
83410: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
83411: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'
83412: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'
83413: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 83410: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'

83406: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
83407: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
83408: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
83409: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
83410: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
83411: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'
83412: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'
83413: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
83414: WHEN 17 THEN 'AR_CUST_TRX_LINES_L_V'

Line 83411: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'

83407: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
83408: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
83409: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
83410: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
83411: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'
83412: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'
83413: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
83414: WHEN 17 THEN 'AR_CUST_TRX_LINES_L_V'
83415: WHEN 18 THEN 'AR_CUST_TRX_LINES_L_V'

Line 83412: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'

83408: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
83409: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
83410: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
83411: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'
83412: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'
83413: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
83414: WHEN 17 THEN 'AR_CUST_TRX_LINES_L_V'
83415: WHEN 18 THEN 'AR_CUST_TRX_LINES_L_V'
83416: WHEN 19 THEN 'AR_DISTRIBUTIONS_L_V'

Line 83413: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'

83409: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
83410: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
83411: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'
83412: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'
83413: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
83414: WHEN 17 THEN 'AR_CUST_TRX_LINES_L_V'
83415: WHEN 18 THEN 'AR_CUST_TRX_LINES_L_V'
83416: WHEN 19 THEN 'AR_DISTRIBUTIONS_L_V'
83417: WHEN 20 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 83417: WHEN 20 THEN 'AR_DISTRIBUTIONS_BASE_V'

83413: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
83414: WHEN 17 THEN 'AR_CUST_TRX_LINES_L_V'
83415: WHEN 18 THEN 'AR_CUST_TRX_LINES_L_V'
83416: WHEN 19 THEN 'AR_DISTRIBUTIONS_L_V'
83417: WHEN 20 THEN 'AR_DISTRIBUTIONS_BASE_V'
83418: WHEN 21 THEN 'AR_TRANSACTIONS_S_V'
83419: WHEN 22 THEN 'AR_TRANSACTIONS_S_V'
83420: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'
83421: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'

Line 83425: WHEN 28 THEN 'AR_DISTRIBUTIONS_BASE_V'

83421: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'
83422: WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V'
83423: WHEN 26 THEN 'AR_DISTRIBUTIONS_L_V'
83424: WHEN 27 THEN 'AR_DISTRIBUTIONS_L_V'
83425: WHEN 28 THEN 'AR_DISTRIBUTIONS_BASE_V'
83426: WHEN 29 THEN 'AR_DISTRIBUTIONS_BASE_V'
83427: WHEN 30 THEN 'AR_DISTRIBUTIONS_L_V'
83428:
83429: ELSE null

Line 83426: WHEN 29 THEN 'AR_DISTRIBUTIONS_BASE_V'

83422: WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V'
83423: WHEN 26 THEN 'AR_DISTRIBUTIONS_L_V'
83424: WHEN 27 THEN 'AR_DISTRIBUTIONS_L_V'
83425: WHEN 28 THEN 'AR_DISTRIBUTIONS_BASE_V'
83426: WHEN 29 THEN 'AR_DISTRIBUTIONS_BASE_V'
83427: WHEN 30 THEN 'AR_DISTRIBUTIONS_L_V'
83428:
83429: ELSE null
83430: END object_name

Line 83571: , AR_DISTRIBUTIONS_BASE_V l3

83567: END source_value
83568: , null source_meaning
83569: FROM xla_events_gt xet
83570: , AR_CUST_TRX_LINES_L_V l2
83571: , AR_DISTRIBUTIONS_BASE_V l3
83572: , AR_DISTRIBUTIONS_L_V l4
83573: , AR_RECEIVABLES_TRX_ACT_S_V l7
83574: , AR_TRANSACTIONS_S_V l10
83575: , (select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)

Line 83751: TYPE t_array_source_45 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

83747: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
83748: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83749: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
83750: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
83751: TYPE t_array_source_45 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
83752: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
83753: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83754: TYPE t_array_source_48 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
83755: TYPE t_array_source_52 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 83752: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

83748: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83749: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
83750: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
83751: TYPE t_array_source_45 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
83752: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
83753: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83754: TYPE t_array_source_48 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
83755: TYPE t_array_source_52 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
83756: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 83753: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

83749: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
83750: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
83751: TYPE t_array_source_45 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
83752: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
83753: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83754: TYPE t_array_source_48 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
83755: TYPE t_array_source_52 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
83756: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
83757: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 83754: TYPE t_array_source_48 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

83750: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
83751: TYPE t_array_source_45 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
83752: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
83753: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83754: TYPE t_array_source_48 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
83755: TYPE t_array_source_52 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
83756: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
83757: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83758: TYPE t_array_source_99 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;

Line 83755: TYPE t_array_source_52 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

83751: TYPE t_array_source_45 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
83752: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
83753: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83754: TYPE t_array_source_48 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
83755: TYPE t_array_source_52 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
83756: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
83757: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83758: TYPE t_array_source_99 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
83759: TYPE t_array_source_100 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 83759: TYPE t_array_source_100 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

83755: TYPE t_array_source_52 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
83756: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
83757: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83758: TYPE t_array_source_99 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
83759: TYPE t_array_source_100 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
83760: TYPE t_array_source_102 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
83761: TYPE t_array_source_103 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
83762: TYPE t_array_source_104 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
83763: TYPE t_array_source_105 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;

Line 83767: TYPE t_array_source_109 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

83763: TYPE t_array_source_105 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
83764: TYPE t_array_source_106 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
83765: TYPE t_array_source_107 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
83766: TYPE t_array_source_108 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
83767: TYPE t_array_source_109 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83768: TYPE t_array_source_110 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
83769: TYPE t_array_source_111 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;
83770:
83771: l_array_source_16 t_array_source_16;

Line 83768: TYPE t_array_source_110 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

83764: TYPE t_array_source_106 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
83765: TYPE t_array_source_107 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
83766: TYPE t_array_source_108 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
83767: TYPE t_array_source_109 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83768: TYPE t_array_source_110 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
83769: TYPE t_array_source_111 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;
83770:
83771: l_array_source_16 t_array_source_16;
83772: l_array_source_18 t_array_source_18;

Line 83950: , AR_DISTRIBUTIONS_BASE_V l3

83946: , l3.DIST_TO_CUR_CONVERSION_RATE source_110
83947: , l4.DIST_SOURCE_TABLE source_111
83948: FROM xla_events_gt xet
83949: , AR_CUST_TRX_LINES_L_V l2
83950: , AR_DISTRIBUTIONS_BASE_V l3
83951: , AR_DISTRIBUTIONS_L_V l4
83952: , AR_RECEIVABLES_TRX_ACT_S_V l7
83953: , AR_TRANSACTIONS_S_V l10
83954: WHERE xet.event_id between x_first_event_id and x_last_event_id