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_000017_PKG dependencies on AR_CUST_TRX_LINES_BASE_V

Line 65994: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

65990: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
65991: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
65992: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
65993: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
65994: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
65995: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
65996: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
65997: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
65998:

Line 65995: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

65991: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
65992: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
65993: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
65994: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
65995: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
65996: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
65997: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
65998:
65999: ELSE null

Line 65996: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

65992: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
65993: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
65994: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
65995: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
65996: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
65997: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
65998:
65999: ELSE null
66000: END object_name

Line 65997: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

65993: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
65994: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
65995: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
65996: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
65997: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
65998:
65999: ELSE null
66000: END object_name
66001: , CASE r

Line 66056: , AR_CUST_TRX_LINES_BASE_V l3

66052: ELSE null
66053: END source_value
66054: , null source_meaning
66055: FROM xla_events_gt xet
66056: , AR_CUST_TRX_LINES_BASE_V l3
66057: , AR_CUST_TRX_LINES_L_V l4
66058: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
66059: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
66060: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 66210: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

66206: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
66207: TYPE t_array_source_44 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
66208: TYPE t_array_source_45 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
66209: TYPE t_array_source_46 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
66210: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
66211: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
66212: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
66213: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
66214:

Line 66211: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

66207: TYPE t_array_source_44 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
66208: TYPE t_array_source_45 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
66209: TYPE t_array_source_46 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
66210: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
66211: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
66212: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
66213: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
66214:
66215: l_array_source_3 t_array_source_3;

Line 66212: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

66208: TYPE t_array_source_45 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
66209: TYPE t_array_source_46 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
66210: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
66211: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
66212: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
66213: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
66214:
66215: l_array_source_3 t_array_source_3;
66216: l_array_source_37 t_array_source_37;

Line 66213: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

66209: TYPE t_array_source_46 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
66210: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
66211: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
66212: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
66213: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
66214:
66215: l_array_source_3 t_array_source_3;
66216: l_array_source_37 t_array_source_37;
66217: l_array_source_38 t_array_source_38;

Line 66323: , AR_CUST_TRX_LINES_BASE_V l3

66319: , l3.TRX_LINE_CUR_CONVERSION_RATE source_49
66320: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_50
66321: , l3.TRX_LINE_ACCTD_AMT source_51
66322: FROM xla_events_gt xet
66323: , AR_CUST_TRX_LINES_BASE_V l3
66324: , AR_CUST_TRX_LINES_L_V l4
66325: WHERE xet.event_id between x_first_event_id and x_last_event_id
66326: and xet.event_date between p_pad_start_date and p_pad_end_date
66327: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 70641: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

70637: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
70638: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
70639: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
70640: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
70641: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
70642: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
70643: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
70644: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
70645: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'

Line 70642: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

70638: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
70639: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
70640: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
70641: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
70642: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
70643: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
70644: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
70645: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
70646: WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V'

Line 70643: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

70639: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
70640: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
70641: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
70642: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
70643: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
70644: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
70645: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
70646: WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V'
70647:

Line 70644: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

70640: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
70641: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
70642: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
70643: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
70644: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
70645: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
70646: WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V'
70647:
70648: ELSE null

Line 70713: , AR_CUST_TRX_LINES_BASE_V l3

70709: ELSE null
70710: END source_value
70711: , null source_meaning
70712: FROM xla_events_gt xet
70713: , AR_CUST_TRX_LINES_BASE_V l3
70714: , AR_CUST_TRX_LINES_L_V l4
70715: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
70716: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70717: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 70867: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

70863: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70864: TYPE t_array_source_44 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
70865: TYPE t_array_source_45 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
70866: TYPE t_array_source_46 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
70867: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
70868: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
70869: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
70870: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
70871: TYPE t_array_source_65 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_INTERFACE_LINE_ATTR1%TYPE INDEX BY BINARY_INTEGER;

Line 70868: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

70864: TYPE t_array_source_44 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
70865: TYPE t_array_source_45 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
70866: TYPE t_array_source_46 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
70867: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
70868: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
70869: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
70870: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
70871: TYPE t_array_source_65 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_INTERFACE_LINE_ATTR1%TYPE INDEX BY BINARY_INTEGER;
70872: TYPE t_array_source_86 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 70869: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

70865: TYPE t_array_source_45 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
70866: TYPE t_array_source_46 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
70867: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
70868: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
70869: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
70870: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
70871: TYPE t_array_source_65 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_INTERFACE_LINE_ATTR1%TYPE INDEX BY BINARY_INTEGER;
70872: TYPE t_array_source_86 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
70873:

Line 70870: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

70866: TYPE t_array_source_46 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
70867: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
70868: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
70869: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
70870: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
70871: TYPE t_array_source_65 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_INTERFACE_LINE_ATTR1%TYPE INDEX BY BINARY_INTEGER;
70872: TYPE t_array_source_86 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
70873:
70874: l_array_source_3 t_array_source_3;

Line 70986: , AR_CUST_TRX_LINES_BASE_V l3

70982: , l3.TRX_LINE_ACCTD_AMT source_51
70983: , l4.TRX_LINE_INTERFACE_LINE_ATTR1 source_65
70984: , l4.TRX_TAX_LINE_ID source_86
70985: FROM xla_events_gt xet
70986: , AR_CUST_TRX_LINES_BASE_V l3
70987: , AR_CUST_TRX_LINES_L_V l4
70988: WHERE xet.event_id between x_first_event_id and x_last_event_id
70989: and xet.event_date between p_pad_start_date and p_pad_end_date
70990: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 72101: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

72097: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
72098: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
72099: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
72100: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
72101: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
72102: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
72103: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
72104: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
72105:

Line 72102: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

72098: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
72099: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
72100: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
72101: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
72102: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
72103: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
72104: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
72105:
72106: ELSE null

Line 72103: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

72099: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
72100: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
72101: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
72102: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
72103: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
72104: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
72105:
72106: ELSE null
72107: END object_name

Line 72104: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

72100: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
72101: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
72102: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
72103: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
72104: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
72105:
72106: ELSE null
72107: END object_name
72108: , CASE r

Line 72163: , AR_CUST_TRX_LINES_BASE_V l3

72159: ELSE null
72160: END source_value
72161: , null source_meaning
72162: FROM xla_events_gt xet
72163: , AR_CUST_TRX_LINES_BASE_V l3
72164: , AR_CUST_TRX_LINES_L_V l4
72165: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
72166: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72167: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 72317: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

72313: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72314: TYPE t_array_source_44 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
72315: TYPE t_array_source_45 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
72316: TYPE t_array_source_46 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
72317: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
72318: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
72319: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
72320: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
72321:

Line 72318: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

72314: TYPE t_array_source_44 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
72315: TYPE t_array_source_45 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
72316: TYPE t_array_source_46 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
72317: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
72318: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
72319: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
72320: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
72321:
72322: l_array_source_3 t_array_source_3;

Line 72319: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

72315: TYPE t_array_source_45 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
72316: TYPE t_array_source_46 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
72317: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
72318: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
72319: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
72320: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
72321:
72322: l_array_source_3 t_array_source_3;
72323: l_array_source_37 t_array_source_37;

Line 72320: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

72316: TYPE t_array_source_46 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
72317: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
72318: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
72319: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
72320: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
72321:
72322: l_array_source_3 t_array_source_3;
72323: l_array_source_37 t_array_source_37;
72324: l_array_source_38 t_array_source_38;

Line 72430: , AR_CUST_TRX_LINES_BASE_V l3

72426: , l3.TRX_LINE_CUR_CONVERSION_RATE source_49
72427: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_50
72428: , l3.TRX_LINE_ACCTD_AMT source_51
72429: FROM xla_events_gt xet
72430: , AR_CUST_TRX_LINES_BASE_V l3
72431: , AR_CUST_TRX_LINES_L_V l4
72432: WHERE xet.event_id between x_first_event_id and x_last_event_id
72433: and xet.event_date between p_pad_start_date and p_pad_end_date
72434: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 75087: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

75083: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
75084: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
75085: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
75086: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
75087: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
75088: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
75089: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
75090: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
75091:

Line 75088: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

75084: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
75085: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
75086: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
75087: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
75088: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
75089: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
75090: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
75091:
75092: ELSE null

Line 75089: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

75085: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
75086: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
75087: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
75088: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
75089: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
75090: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
75091:
75092: ELSE null
75093: END object_name

Line 75090: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

75086: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
75087: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
75088: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
75089: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
75090: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
75091:
75092: ELSE null
75093: END object_name
75094: , CASE r

Line 75149: , AR_CUST_TRX_LINES_BASE_V l3

75145: ELSE null
75146: END source_value
75147: , null source_meaning
75148: FROM xla_events_gt xet
75149: , AR_CUST_TRX_LINES_BASE_V l3
75150: , AR_CUST_TRX_LINES_L_V l4
75151: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
75152: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75153: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 75303: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

75299: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75300: TYPE t_array_source_44 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75301: TYPE t_array_source_45 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75302: TYPE t_array_source_46 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
75303: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
75304: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
75305: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75306: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
75307:

Line 75304: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

75300: TYPE t_array_source_44 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75301: TYPE t_array_source_45 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75302: TYPE t_array_source_46 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
75303: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
75304: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
75305: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75306: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
75307:
75308: l_array_source_3 t_array_source_3;

Line 75305: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

75301: TYPE t_array_source_45 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75302: TYPE t_array_source_46 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
75303: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
75304: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
75305: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75306: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
75307:
75308: l_array_source_3 t_array_source_3;
75309: l_array_source_37 t_array_source_37;

Line 75306: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

75302: TYPE t_array_source_46 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
75303: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
75304: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
75305: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75306: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
75307:
75308: l_array_source_3 t_array_source_3;
75309: l_array_source_37 t_array_source_37;
75310: l_array_source_38 t_array_source_38;

Line 75416: , AR_CUST_TRX_LINES_BASE_V l3

75412: , l3.TRX_LINE_CUR_CONVERSION_RATE source_49
75413: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_50
75414: , l3.TRX_LINE_ACCTD_AMT source_51
75415: FROM xla_events_gt xet
75416: , AR_CUST_TRX_LINES_BASE_V l3
75417: , AR_CUST_TRX_LINES_L_V l4
75418: WHERE xet.event_id between x_first_event_id and x_last_event_id
75419: and xet.event_date between p_pad_start_date and p_pad_end_date
75420: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 76333: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

76329: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
76330: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
76331: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
76332: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
76333: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
76334: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
76335: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
76336: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
76337: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'

Line 76334: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

76330: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
76331: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
76332: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
76333: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
76334: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
76335: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
76336: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
76337: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
76338: WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V'

Line 76335: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

76331: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
76332: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
76333: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
76334: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
76335: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
76336: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
76337: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
76338: WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V'
76339: WHEN 12 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 76336: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

76332: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
76333: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
76334: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
76335: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
76336: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
76337: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
76338: WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V'
76339: WHEN 12 THEN 'AR_CUST_TRX_LINES_BASE_V'
76340:

Line 76339: WHEN 12 THEN 'AR_CUST_TRX_LINES_BASE_V'

76335: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
76336: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
76337: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
76338: WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V'
76339: WHEN 12 THEN 'AR_CUST_TRX_LINES_BASE_V'
76340:
76341: ELSE null
76342: END object_name
76343: , CASE r

Line 76410: , AR_CUST_TRX_LINES_BASE_V l3

76406: ELSE null
76407: END source_value
76408: , null source_meaning
76409: FROM xla_events_gt xet
76410: , AR_CUST_TRX_LINES_BASE_V l3
76411: , AR_CUST_TRX_LINES_L_V l4
76412: , (select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
76413: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76414: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 76564: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

76560: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
76561: TYPE t_array_source_44 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
76562: TYPE t_array_source_45 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76563: TYPE t_array_source_46 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
76564: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
76565: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
76566: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76567: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
76568: TYPE t_array_source_65 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_INTERFACE_LINE_ATTR1%TYPE INDEX BY BINARY_INTEGER;

Line 76565: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

76561: TYPE t_array_source_44 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
76562: TYPE t_array_source_45 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76563: TYPE t_array_source_46 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
76564: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
76565: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
76566: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76567: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
76568: TYPE t_array_source_65 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_INTERFACE_LINE_ATTR1%TYPE INDEX BY BINARY_INTEGER;
76569: TYPE t_array_source_86 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 76566: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

76562: TYPE t_array_source_45 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76563: TYPE t_array_source_46 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
76564: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
76565: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
76566: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76567: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
76568: TYPE t_array_source_65 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_INTERFACE_LINE_ATTR1%TYPE INDEX BY BINARY_INTEGER;
76569: TYPE t_array_source_86 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
76570: TYPE t_array_source_87 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 76567: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

76563: TYPE t_array_source_46 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
76564: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
76565: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
76566: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76567: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
76568: TYPE t_array_source_65 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_INTERFACE_LINE_ATTR1%TYPE INDEX BY BINARY_INTEGER;
76569: TYPE t_array_source_86 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
76570: TYPE t_array_source_87 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;
76571:

Line 76570: TYPE t_array_source_87 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;

76566: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76567: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
76568: TYPE t_array_source_65 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_INTERFACE_LINE_ATTR1%TYPE INDEX BY BINARY_INTEGER;
76569: TYPE t_array_source_86 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
76570: TYPE t_array_source_87 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;
76571:
76572: l_array_source_3 t_array_source_3;
76573: l_array_source_37 t_array_source_37;
76574: l_array_source_38 t_array_source_38;

Line 76686: , AR_CUST_TRX_LINES_BASE_V l3

76682: , l4.TRX_LINE_INTERFACE_LINE_ATTR1 source_65
76683: , l4.TRX_TAX_LINE_ID source_86
76684: , l3.ROUNDING_CORRECTION_FLAG source_87
76685: FROM xla_events_gt xet
76686: , AR_CUST_TRX_LINES_BASE_V l3
76687: , AR_CUST_TRX_LINES_L_V l4
76688: WHERE xet.event_id between x_first_event_id and x_last_event_id
76689: and xet.event_date between p_pad_start_date and p_pad_end_date
76690: and xet.event_class_code = C_EVENT_CLASS_CODE