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

Line 70447: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

70443: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
70444: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
70445: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
70446: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
70447: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
70448: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
70449: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
70450: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
70451:

Line 70448: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

70444: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
70445: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
70446: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
70447: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
70448: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
70449: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
70450: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
70451:
70452: ELSE null

Line 70449: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

70445: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
70446: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
70447: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
70448: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
70449: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
70450: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
70451:
70452: ELSE null
70453: END object_name

Line 70450: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

70446: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
70447: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
70448: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
70449: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
70450: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
70451:
70452: ELSE null
70453: END object_name
70454: , CASE r

Line 70509: , AR_CUST_TRX_LINES_BASE_V l3

70505: ELSE null
70506: END source_value
70507: , null source_meaning
70508: FROM xla_events_gt xet
70509: , AR_CUST_TRX_LINES_BASE_V l3
70510: , AR_CUST_TRX_LINES_L_V l4
70511: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
70512: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70513: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 70663: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

70659: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70660: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
70661: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
70662: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
70663: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
70664: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
70665: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
70666: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
70667:

Line 70664: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

70660: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
70661: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
70662: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
70663: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
70664: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
70665: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
70666: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
70667:
70668: l_array_source_30 t_array_source_30;

Line 70665: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

70661: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
70662: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
70663: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
70664: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
70665: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
70666: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
70667:
70668: l_array_source_30 t_array_source_30;
70669: l_array_source_31 t_array_source_31;

Line 70666: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

70662: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
70663: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
70664: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
70665: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
70666: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
70667:
70668: l_array_source_30 t_array_source_30;
70669: l_array_source_31 t_array_source_31;
70670: l_array_source_32 t_array_source_32;

Line 70776: , AR_CUST_TRX_LINES_BASE_V l3

70772: , l3.TRX_LINE_CUR_CONVERSION_RATE source_39
70773: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_40
70774: , l3.TRX_LINE_ACCTD_AMT source_41
70775: FROM xla_events_gt xet
70776: , AR_CUST_TRX_LINES_BASE_V l3
70777: , AR_CUST_TRX_LINES_L_V l4
70778: WHERE xet.event_id between x_first_event_id and x_last_event_id
70779: and xet.event_date between p_pad_start_date and p_pad_end_date
70780: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 73322: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

73318: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
73319: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
73320: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
73321: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
73322: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
73323: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
73324: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
73325: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
73326: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'

Line 73323: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

73319: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
73320: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
73321: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
73322: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
73323: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
73324: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
73325: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
73326: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
73327:

Line 73324: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

73320: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
73321: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
73322: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
73323: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
73324: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
73325: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
73326: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
73327:
73328: ELSE null

Line 73325: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

73321: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
73322: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
73323: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
73324: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
73325: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
73326: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
73327:
73328: ELSE null
73329: END object_name

Line 73389: , AR_CUST_TRX_LINES_BASE_V l3

73385: ELSE null
73386: END source_value
73387: , null source_meaning
73388: FROM xla_events_gt xet
73389: , AR_CUST_TRX_LINES_BASE_V l3
73390: , AR_CUST_TRX_LINES_L_V l4
73391: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
73392: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73393: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 73545: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

73541: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73542: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73543: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73544: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
73545: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73546: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
73547: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73548: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
73549: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 73546: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

73542: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73543: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73544: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
73545: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73546: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
73547: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73548: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
73549: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
73550:

Line 73547: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

73543: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73544: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
73545: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73546: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
73547: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73548: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
73549: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
73550:
73551: l_array_source_16 t_array_source_16;

Line 73548: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

73544: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
73545: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73546: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
73547: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73548: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
73549: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
73550:
73551: l_array_source_16 t_array_source_16;
73552: l_array_source_30 t_array_source_30;

Line 73665: , AR_CUST_TRX_LINES_BASE_V l3

73661: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_40
73662: , l3.TRX_LINE_ACCTD_AMT source_41
73663: , l4.TRX_TAX_LINE_ID source_55
73664: FROM xla_events_gt xet
73665: , AR_CUST_TRX_LINES_BASE_V l3
73666: , AR_CUST_TRX_LINES_L_V l4
73667: WHERE xet.event_id between x_first_event_id and x_last_event_id
73668: and xet.event_date between p_pad_start_date and p_pad_end_date
73669: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 74783: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

74779: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
74780: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
74781: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74782: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74783: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
74784: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
74785: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
74786: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
74787:

Line 74784: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

74780: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
74781: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74782: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74783: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
74784: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
74785: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
74786: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
74787:
74788: ELSE null

Line 74785: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

74781: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74782: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74783: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
74784: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
74785: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
74786: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
74787:
74788: ELSE null
74789: END object_name

Line 74786: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

74782: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74783: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
74784: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
74785: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
74786: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
74787:
74788: ELSE null
74789: END object_name
74790: , CASE r

Line 74845: , AR_CUST_TRX_LINES_BASE_V l3

74841: ELSE null
74842: END source_value
74843: , null source_meaning
74844: FROM xla_events_gt xet
74845: , AR_CUST_TRX_LINES_BASE_V l3
74846: , AR_CUST_TRX_LINES_L_V l4
74847: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
74848: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74849: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 74999: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

74995: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74996: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
74997: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74998: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
74999: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
75000: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
75001: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75002: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
75003:

Line 75000: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

74996: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
74997: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74998: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
74999: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
75000: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
75001: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75002: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
75003:
75004: l_array_source_30 t_array_source_30;

Line 75001: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

74997: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74998: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
74999: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
75000: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
75001: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75002: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
75003:
75004: l_array_source_30 t_array_source_30;
75005: l_array_source_31 t_array_source_31;

Line 75002: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

74998: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
74999: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
75000: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
75001: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75002: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
75003:
75004: l_array_source_30 t_array_source_30;
75005: l_array_source_31 t_array_source_31;
75006: l_array_source_32 t_array_source_32;

Line 75112: , AR_CUST_TRX_LINES_BASE_V l3

75108: , l3.TRX_LINE_CUR_CONVERSION_RATE source_39
75109: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_40
75110: , l3.TRX_LINE_ACCTD_AMT source_41
75111: FROM xla_events_gt xet
75112: , AR_CUST_TRX_LINES_BASE_V l3
75113: , AR_CUST_TRX_LINES_L_V l4
75114: WHERE xet.event_id between x_first_event_id and x_last_event_id
75115: and xet.event_date between p_pad_start_date and p_pad_end_date
75116: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 76029: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

76025: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
76026: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
76027: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
76028: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
76029: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
76030: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
76031: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
76032: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
76033:

Line 76030: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

76026: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
76027: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
76028: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
76029: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
76030: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
76031: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
76032: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
76033:
76034: ELSE null

Line 76031: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

76027: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
76028: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
76029: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
76030: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
76031: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
76032: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
76033:
76034: ELSE null
76035: END object_name

Line 76032: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

76028: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
76029: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
76030: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
76031: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
76032: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
76033:
76034: ELSE null
76035: END object_name
76036: , CASE r

Line 76091: , AR_CUST_TRX_LINES_BASE_V l3

76087: ELSE null
76088: END source_value
76089: , null source_meaning
76090: FROM xla_events_gt xet
76091: , AR_CUST_TRX_LINES_BASE_V l3
76092: , AR_CUST_TRX_LINES_L_V l4
76093: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
76094: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76095: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 76245: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

76241: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
76242: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
76243: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76244: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
76245: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
76246: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
76247: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76248: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
76249:

Line 76246: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

76242: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
76243: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76244: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
76245: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
76246: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
76247: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76248: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
76249:
76250: l_array_source_30 t_array_source_30;

Line 76247: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

76243: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76244: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
76245: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
76246: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
76247: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76248: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
76249:
76250: l_array_source_30 t_array_source_30;
76251: l_array_source_31 t_array_source_31;

Line 76248: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

76244: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
76245: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
76246: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
76247: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76248: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
76249:
76250: l_array_source_30 t_array_source_30;
76251: l_array_source_31 t_array_source_31;
76252: l_array_source_32 t_array_source_32;

Line 76358: , AR_CUST_TRX_LINES_BASE_V l3

76354: , l3.TRX_LINE_CUR_CONVERSION_RATE source_39
76355: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_40
76356: , l3.TRX_LINE_ACCTD_AMT source_41
76357: FROM xla_events_gt xet
76358: , AR_CUST_TRX_LINES_BASE_V l3
76359: , AR_CUST_TRX_LINES_L_V l4
76360: WHERE xet.event_id between x_first_event_id and x_last_event_id
76361: and xet.event_date between p_pad_start_date and p_pad_end_date
76362: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 77291: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

77287: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
77288: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
77289: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
77290: WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V'
77291: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
77292: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
77293: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
77294: WHEN 10 THEN 'AR_CUST_TRX_LINES_BASE_V'
77295: WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V'

Line 77292: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

77288: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
77289: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
77290: WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V'
77291: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
77292: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
77293: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
77294: WHEN 10 THEN 'AR_CUST_TRX_LINES_BASE_V'
77295: WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V'
77296: WHEN 12 THEN 'FV_XLA_AR_REF_V'

Line 77293: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

77289: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
77290: WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V'
77291: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
77292: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
77293: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
77294: WHEN 10 THEN 'AR_CUST_TRX_LINES_BASE_V'
77295: WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V'
77296: WHEN 12 THEN 'FV_XLA_AR_REF_V'
77297: WHEN 13 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 77294: WHEN 10 THEN 'AR_CUST_TRX_LINES_BASE_V'

77290: WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V'
77291: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
77292: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
77293: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
77294: WHEN 10 THEN 'AR_CUST_TRX_LINES_BASE_V'
77295: WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V'
77296: WHEN 12 THEN 'FV_XLA_AR_REF_V'
77297: WHEN 13 THEN 'AR_CUST_TRX_LINES_BASE_V'
77298:

Line 77297: WHEN 13 THEN 'AR_CUST_TRX_LINES_BASE_V'

77293: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
77294: WHEN 10 THEN 'AR_CUST_TRX_LINES_BASE_V'
77295: WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V'
77296: WHEN 12 THEN 'FV_XLA_AR_REF_V'
77297: WHEN 13 THEN 'AR_CUST_TRX_LINES_BASE_V'
77298:
77299: ELSE null
77300: END object_name
77301: , CASE r

Line 77372: , AR_CUST_TRX_LINES_BASE_V l3

77368: ELSE null
77369: END source_value
77370: , null source_meaning
77371: FROM xla_events_gt xet
77372: , AR_CUST_TRX_LINES_BASE_V l3
77373: , AR_CUST_TRX_LINES_L_V l4
77374: , FV_XLA_AR_REF_V l6
77375: , (select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
77376: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 77531: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

77527: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
77528: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
77529: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77530: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
77531: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
77532: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
77533: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77534: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
77535: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 77532: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

77528: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
77529: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77530: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
77531: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
77532: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
77533: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77534: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
77535: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
77536: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 77533: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

77529: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77530: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
77531: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
77532: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
77533: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77534: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
77535: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
77536: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
77537: TYPE t_array_source_66 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 77534: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

77530: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
77531: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
77532: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
77533: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77534: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
77535: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
77536: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
77537: TYPE t_array_source_66 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;
77538:

Line 77537: TYPE t_array_source_66 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;

77533: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77534: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
77535: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
77536: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
77537: TYPE t_array_source_66 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;
77538:
77539: l_array_source_6 t_array_source_6;
77540: l_array_source_16 t_array_source_16;
77541: l_array_source_30 t_array_source_30;

Line 77661: , AR_CUST_TRX_LINES_BASE_V l3

77657: , l4.TRX_TAX_LINE_ID source_55
77658: , l6.FEDERAL_ACCOUNT_VALID_FLAG source_56
77659: , l3.ROUNDING_CORRECTION_FLAG source_66
77660: FROM xla_events_gt xet
77661: , AR_CUST_TRX_LINES_BASE_V l3
77662: , AR_CUST_TRX_LINES_L_V l4
77663: , FV_XLA_AR_REF_V l6
77664: WHERE xet.event_id between x_first_event_id and x_last_event_id
77665: and xet.event_date between p_pad_start_date and p_pad_end_date