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

Line 54590: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

54586: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
54587: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
54588: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
54589: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
54590: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
54591: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
54592: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
54593: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
54594:

Line 54591: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

54587: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
54588: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
54589: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
54590: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
54591: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
54592: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
54593: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
54594:
54595: ELSE null

Line 54592: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

54588: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
54589: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
54590: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
54591: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
54592: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
54593: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
54594:
54595: ELSE null
54596: END object_name

Line 54593: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

54589: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
54590: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
54591: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
54592: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
54593: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
54594:
54595: ELSE null
54596: END object_name
54597: , CASE r

Line 54652: , AR_CUST_TRX_LINES_BASE_V l3

54648: ELSE null
54649: END source_value
54650: , null source_meaning
54651: FROM xla_events_gt xet
54652: , AR_CUST_TRX_LINES_BASE_V l3
54653: , AR_CUST_TRX_LINES_L_V l4
54654: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
54655: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
54656: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 54806: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

54802: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
54803: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
54804: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
54805: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
54806: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
54807: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
54808: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
54809: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
54810:

Line 54807: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

54803: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
54804: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
54805: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
54806: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
54807: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
54808: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
54809: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
54810:
54811: l_array_source_25 t_array_source_25;

Line 54808: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

54804: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
54805: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
54806: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
54807: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
54808: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
54809: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
54810:
54811: l_array_source_25 t_array_source_25;
54812: l_array_source_26 t_array_source_26;

Line 54809: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

54805: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
54806: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
54807: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
54808: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
54809: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
54810:
54811: l_array_source_25 t_array_source_25;
54812: l_array_source_26 t_array_source_26;
54813: l_array_source_27 t_array_source_27;

Line 54919: , AR_CUST_TRX_LINES_BASE_V l3

54915: , l3.TRX_LINE_CUR_CONVERSION_RATE source_34
54916: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_35
54917: , l3.TRX_LINE_ACCTD_AMT source_36
54918: FROM xla_events_gt xet
54919: , AR_CUST_TRX_LINES_BASE_V l3
54920: , AR_CUST_TRX_LINES_L_V l4
54921: WHERE xet.event_id between x_first_event_id and x_last_event_id
54922: and xet.event_date between p_pad_start_date and p_pad_end_date
54923: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 57465: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

57461: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
57462: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
57463: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
57464: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
57465: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
57466: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
57467: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
57468: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
57469: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'

Line 57466: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

57462: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
57463: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
57464: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
57465: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
57466: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
57467: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
57468: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
57469: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
57470:

Line 57467: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

57463: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
57464: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
57465: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
57466: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
57467: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
57468: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
57469: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
57470:
57471: ELSE null

Line 57468: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

57464: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
57465: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
57466: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
57467: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
57468: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
57469: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
57470:
57471: ELSE null
57472: END object_name

Line 57532: , AR_CUST_TRX_LINES_BASE_V l3

57528: ELSE null
57529: END source_value
57530: , null source_meaning
57531: FROM xla_events_gt xet
57532: , AR_CUST_TRX_LINES_BASE_V l3
57533: , AR_CUST_TRX_LINES_L_V l4
57534: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
57535: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
57536: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 57688: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

57684: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57685: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
57686: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57687: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
57688: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
57689: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
57690: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57691: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
57692: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 57689: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

57685: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
57686: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57687: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
57688: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
57689: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
57690: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57691: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
57692: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
57693:

Line 57690: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

57686: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57687: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
57688: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
57689: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
57690: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57691: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
57692: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
57693:
57694: l_array_source_8 t_array_source_8;

Line 57691: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

57687: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
57688: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
57689: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
57690: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57691: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
57692: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
57693:
57694: l_array_source_8 t_array_source_8;
57695: l_array_source_25 t_array_source_25;

Line 57808: , AR_CUST_TRX_LINES_BASE_V l3

57804: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_35
57805: , l3.TRX_LINE_ACCTD_AMT source_36
57806: , l4.TRX_TAX_LINE_ID source_50
57807: FROM xla_events_gt xet
57808: , AR_CUST_TRX_LINES_BASE_V l3
57809: , AR_CUST_TRX_LINES_L_V l4
57810: WHERE xet.event_id between x_first_event_id and x_last_event_id
57811: and xet.event_date between p_pad_start_date and p_pad_end_date
57812: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 58926: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

58922: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
58923: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
58924: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
58925: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
58926: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
58927: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
58928: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
58929: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
58930:

Line 58927: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

58923: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
58924: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
58925: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
58926: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
58927: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
58928: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
58929: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
58930:
58931: ELSE null

Line 58928: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

58924: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
58925: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
58926: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
58927: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
58928: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
58929: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
58930:
58931: ELSE null
58932: END object_name

Line 58929: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

58925: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
58926: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
58927: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
58928: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
58929: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
58930:
58931: ELSE null
58932: END object_name
58933: , CASE r

Line 58988: , AR_CUST_TRX_LINES_BASE_V l3

58984: ELSE null
58985: END source_value
58986: , null source_meaning
58987: FROM xla_events_gt xet
58988: , AR_CUST_TRX_LINES_BASE_V l3
58989: , AR_CUST_TRX_LINES_L_V l4
58990: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
58991: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
58992: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 59142: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

59138: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
59139: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
59140: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
59141: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
59142: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
59143: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
59144: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
59145: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
59146:

Line 59143: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

59139: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
59140: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
59141: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
59142: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
59143: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
59144: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
59145: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
59146:
59147: l_array_source_25 t_array_source_25;

Line 59144: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

59140: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
59141: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
59142: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
59143: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
59144: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
59145: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
59146:
59147: l_array_source_25 t_array_source_25;
59148: l_array_source_26 t_array_source_26;

Line 59145: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

59141: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
59142: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
59143: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
59144: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
59145: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
59146:
59147: l_array_source_25 t_array_source_25;
59148: l_array_source_26 t_array_source_26;
59149: l_array_source_27 t_array_source_27;

Line 59255: , AR_CUST_TRX_LINES_BASE_V l3

59251: , l3.TRX_LINE_CUR_CONVERSION_RATE source_34
59252: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_35
59253: , l3.TRX_LINE_ACCTD_AMT source_36
59254: FROM xla_events_gt xet
59255: , AR_CUST_TRX_LINES_BASE_V l3
59256: , AR_CUST_TRX_LINES_L_V l4
59257: WHERE xet.event_id between x_first_event_id and x_last_event_id
59258: and xet.event_date between p_pad_start_date and p_pad_end_date
59259: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 60172: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

60168: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
60169: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
60170: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
60171: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
60172: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
60173: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
60174: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
60175: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
60176:

Line 60173: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

60169: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
60170: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
60171: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
60172: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
60173: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
60174: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
60175: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
60176:
60177: ELSE null

Line 60174: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

60170: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
60171: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
60172: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
60173: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
60174: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
60175: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
60176:
60177: ELSE null
60178: END object_name

Line 60175: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

60171: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
60172: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
60173: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
60174: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
60175: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
60176:
60177: ELSE null
60178: END object_name
60179: , CASE r

Line 60234: , AR_CUST_TRX_LINES_BASE_V l3

60230: ELSE null
60231: END source_value
60232: , null source_meaning
60233: FROM xla_events_gt xet
60234: , AR_CUST_TRX_LINES_BASE_V l3
60235: , AR_CUST_TRX_LINES_L_V l4
60236: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
60237: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
60238: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 60388: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

60384: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
60385: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
60386: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
60387: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
60388: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
60389: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
60390: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
60391: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
60392:

Line 60389: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

60385: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
60386: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
60387: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
60388: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
60389: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
60390: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
60391: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
60392:
60393: l_array_source_25 t_array_source_25;

Line 60390: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

60386: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
60387: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
60388: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
60389: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
60390: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
60391: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
60392:
60393: l_array_source_25 t_array_source_25;
60394: l_array_source_26 t_array_source_26;

Line 60391: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

60387: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
60388: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
60389: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
60390: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
60391: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
60392:
60393: l_array_source_25 t_array_source_25;
60394: l_array_source_26 t_array_source_26;
60395: l_array_source_27 t_array_source_27;

Line 60501: , AR_CUST_TRX_LINES_BASE_V l3

60497: , l3.TRX_LINE_CUR_CONVERSION_RATE source_34
60498: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_35
60499: , l3.TRX_LINE_ACCTD_AMT source_36
60500: FROM xla_events_gt xet
60501: , AR_CUST_TRX_LINES_BASE_V l3
60502: , AR_CUST_TRX_LINES_L_V l4
60503: WHERE xet.event_id between x_first_event_id and x_last_event_id
60504: and xet.event_date between p_pad_start_date and p_pad_end_date
60505: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 61428: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

61424: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
61425: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
61426: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
61427: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
61428: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
61429: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
61430: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
61431: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
61432: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'

Line 61429: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

61425: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
61426: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
61427: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
61428: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
61429: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
61430: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
61431: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
61432: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
61433: WHEN 11 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 61430: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

61426: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
61427: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
61428: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
61429: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
61430: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
61431: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
61432: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
61433: WHEN 11 THEN 'AR_CUST_TRX_LINES_BASE_V'
61434:

Line 61431: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

61427: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
61428: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
61429: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
61430: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
61431: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
61432: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
61433: WHEN 11 THEN 'AR_CUST_TRX_LINES_BASE_V'
61434:
61435: ELSE null

Line 61433: WHEN 11 THEN 'AR_CUST_TRX_LINES_BASE_V'

61429: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
61430: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
61431: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
61432: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
61433: WHEN 11 THEN 'AR_CUST_TRX_LINES_BASE_V'
61434:
61435: ELSE null
61436: END object_name
61437: , CASE r

Line 61500: , AR_CUST_TRX_LINES_BASE_V l3

61496: ELSE null
61497: END source_value
61498: , null source_meaning
61499: FROM xla_events_gt xet
61500: , AR_CUST_TRX_LINES_BASE_V l3
61501: , AR_CUST_TRX_LINES_L_V l4
61502: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
61503: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
61504: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 61656: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

61652: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
61653: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
61654: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61655: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
61656: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
61657: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
61658: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61659: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
61660: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 61657: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

61653: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
61654: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61655: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
61656: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
61657: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
61658: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61659: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
61660: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
61661: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 61658: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

61654: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61655: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
61656: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
61657: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
61658: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61659: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
61660: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
61661: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;
61662:

Line 61659: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

61655: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
61656: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
61657: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
61658: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61659: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
61660: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
61661: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;
61662:
61663: l_array_source_8 t_array_source_8;

Line 61661: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;

61657: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
61658: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61659: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
61660: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
61661: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;
61662:
61663: l_array_source_8 t_array_source_8;
61664: l_array_source_25 t_array_source_25;
61665: l_array_source_26 t_array_source_26;

Line 61779: , AR_CUST_TRX_LINES_BASE_V l3

61775: , l3.TRX_LINE_ACCTD_AMT source_36
61776: , l4.TRX_TAX_LINE_ID source_50
61777: , l3.ROUNDING_CORRECTION_FLAG source_51
61778: FROM xla_events_gt xet
61779: , AR_CUST_TRX_LINES_BASE_V l3
61780: , AR_CUST_TRX_LINES_L_V l4
61781: WHERE xet.event_id between x_first_event_id and x_last_event_id
61782: and xet.event_date between p_pad_start_date and p_pad_end_date
61783: and xet.event_class_code = C_EVENT_CLASS_CODE