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

Line 54319: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

54315: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
54316: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
54317: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
54318: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
54319: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
54320: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
54321: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
54322: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
54323:

Line 54320: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

54316: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
54317: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
54318: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
54319: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
54320: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
54321: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
54322: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
54323:
54324: ELSE null

Line 54321: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

54317: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
54318: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
54319: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
54320: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
54321: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
54322: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
54323:
54324: ELSE null
54325: END object_name

Line 54322: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

54318: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
54319: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
54320: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
54321: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
54322: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
54323:
54324: ELSE null
54325: END object_name
54326: , CASE r

Line 54381: , AR_CUST_TRX_LINES_BASE_V l3

54377: ELSE null
54378: END source_value
54379: , null source_meaning
54380: FROM xla_events_gt xet
54381: , AR_CUST_TRX_LINES_BASE_V l3
54382: , AR_CUST_TRX_LINES_L_V l4
54383: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
54384: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
54385: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 54535: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

54531: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
54532: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
54533: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
54534: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
54535: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
54536: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
54537: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
54538: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
54539:

Line 54536: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

54532: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
54533: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
54534: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
54535: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
54536: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
54537: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
54538: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
54539:
54540: l_array_source_23 t_array_source_23;

Line 54537: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

54533: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
54534: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
54535: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
54536: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
54537: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
54538: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
54539:
54540: l_array_source_23 t_array_source_23;
54541: l_array_source_24 t_array_source_24;

Line 54538: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

54534: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
54535: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
54536: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
54537: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
54538: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
54539:
54540: l_array_source_23 t_array_source_23;
54541: l_array_source_24 t_array_source_24;
54542: l_array_source_25 t_array_source_25;

Line 54648: , AR_CUST_TRX_LINES_BASE_V l3

54644: , l3.TRX_LINE_CUR_CONVERSION_RATE source_32
54645: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_33
54646: , l3.TRX_LINE_ACCTD_AMT source_34
54647: FROM xla_events_gt xet
54648: , AR_CUST_TRX_LINES_BASE_V l3
54649: , AR_CUST_TRX_LINES_L_V l4
54650: WHERE xet.event_id between x_first_event_id and x_last_event_id
54651: and xet.event_date between p_pad_start_date and p_pad_end_date
54652: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 57194: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

57190: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
57191: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
57192: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
57193: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
57194: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
57195: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
57196: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
57197: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
57198: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'

Line 57195: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

57191: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
57192: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
57193: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
57194: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
57195: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
57196: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
57197: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
57198: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
57199:

Line 57196: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

57192: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
57193: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
57194: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
57195: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
57196: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
57197: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
57198: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
57199:
57200: ELSE null

Line 57197: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

57193: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
57194: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
57195: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
57196: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
57197: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
57198: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
57199:
57200: ELSE null
57201: END object_name

Line 57261: , AR_CUST_TRX_LINES_BASE_V l3

57257: ELSE null
57258: END source_value
57259: , null source_meaning
57260: FROM xla_events_gt xet
57261: , AR_CUST_TRX_LINES_BASE_V l3
57262: , AR_CUST_TRX_LINES_L_V l4
57263: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
57264: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
57265: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 57417: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

57413: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57414: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
57415: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57416: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
57417: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
57418: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
57419: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57420: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
57421: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 57418: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

57414: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
57415: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57416: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
57417: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
57418: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
57419: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57420: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
57421: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
57422:

Line 57419: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

57415: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57416: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
57417: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
57418: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
57419: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57420: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
57421: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
57422:
57423: l_array_source_9 t_array_source_9;

Line 57420: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

57416: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
57417: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
57418: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
57419: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57420: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
57421: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
57422:
57423: l_array_source_9 t_array_source_9;
57424: l_array_source_23 t_array_source_23;

Line 57537: , AR_CUST_TRX_LINES_BASE_V l3

57533: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_33
57534: , l3.TRX_LINE_ACCTD_AMT source_34
57535: , l4.TRX_TAX_LINE_ID source_48
57536: FROM xla_events_gt xet
57537: , AR_CUST_TRX_LINES_BASE_V l3
57538: , AR_CUST_TRX_LINES_L_V l4
57539: WHERE xet.event_id between x_first_event_id and x_last_event_id
57540: and xet.event_date between p_pad_start_date and p_pad_end_date
57541: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 58655: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

58651: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
58652: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
58653: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
58654: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
58655: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
58656: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
58657: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
58658: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
58659:

Line 58656: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

58652: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
58653: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
58654: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
58655: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
58656: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
58657: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
58658: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
58659:
58660: ELSE null

Line 58657: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

58653: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
58654: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
58655: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
58656: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
58657: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
58658: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
58659:
58660: ELSE null
58661: END object_name

Line 58658: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

58654: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
58655: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
58656: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
58657: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
58658: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
58659:
58660: ELSE null
58661: END object_name
58662: , CASE r

Line 58717: , AR_CUST_TRX_LINES_BASE_V l3

58713: ELSE null
58714: END source_value
58715: , null source_meaning
58716: FROM xla_events_gt xet
58717: , AR_CUST_TRX_LINES_BASE_V l3
58718: , AR_CUST_TRX_LINES_L_V l4
58719: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
58720: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
58721: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 58871: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

58867: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
58868: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
58869: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
58870: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
58871: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
58872: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
58873: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
58874: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
58875:

Line 58872: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

58868: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
58869: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
58870: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
58871: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
58872: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
58873: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
58874: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
58875:
58876: l_array_source_23 t_array_source_23;

Line 58873: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

58869: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
58870: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
58871: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
58872: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
58873: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
58874: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
58875:
58876: l_array_source_23 t_array_source_23;
58877: l_array_source_24 t_array_source_24;

Line 58874: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

58870: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
58871: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
58872: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
58873: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
58874: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
58875:
58876: l_array_source_23 t_array_source_23;
58877: l_array_source_24 t_array_source_24;
58878: l_array_source_25 t_array_source_25;

Line 58984: , AR_CUST_TRX_LINES_BASE_V l3

58980: , l3.TRX_LINE_CUR_CONVERSION_RATE source_32
58981: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_33
58982: , l3.TRX_LINE_ACCTD_AMT source_34
58983: FROM xla_events_gt xet
58984: , AR_CUST_TRX_LINES_BASE_V l3
58985: , AR_CUST_TRX_LINES_L_V l4
58986: WHERE xet.event_id between x_first_event_id and x_last_event_id
58987: and xet.event_date between p_pad_start_date and p_pad_end_date
58988: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 59901: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

59897: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
59898: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
59899: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
59900: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
59901: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
59902: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
59903: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
59904: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
59905:

Line 59902: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

59898: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
59899: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
59900: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
59901: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
59902: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
59903: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
59904: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
59905:
59906: ELSE null

Line 59903: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

59899: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
59900: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
59901: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
59902: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
59903: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
59904: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
59905:
59906: ELSE null
59907: END object_name

Line 59904: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

59900: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
59901: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
59902: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
59903: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
59904: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
59905:
59906: ELSE null
59907: END object_name
59908: , CASE r

Line 59963: , AR_CUST_TRX_LINES_BASE_V l3

59959: ELSE null
59960: END source_value
59961: , null source_meaning
59962: FROM xla_events_gt xet
59963: , AR_CUST_TRX_LINES_BASE_V l3
59964: , AR_CUST_TRX_LINES_L_V l4
59965: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
59966: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
59967: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 60117: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

60113: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
60114: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
60115: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
60116: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
60117: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
60118: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
60119: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
60120: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
60121:

Line 60118: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

60114: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
60115: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
60116: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
60117: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
60118: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
60119: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
60120: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
60121:
60122: l_array_source_23 t_array_source_23;

Line 60119: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

60115: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
60116: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
60117: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
60118: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
60119: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
60120: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
60121:
60122: l_array_source_23 t_array_source_23;
60123: l_array_source_24 t_array_source_24;

Line 60120: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

60116: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
60117: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
60118: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
60119: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
60120: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
60121:
60122: l_array_source_23 t_array_source_23;
60123: l_array_source_24 t_array_source_24;
60124: l_array_source_25 t_array_source_25;

Line 60230: , AR_CUST_TRX_LINES_BASE_V l3

60226: , l3.TRX_LINE_CUR_CONVERSION_RATE source_32
60227: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_33
60228: , l3.TRX_LINE_ACCTD_AMT source_34
60229: FROM xla_events_gt xet
60230: , AR_CUST_TRX_LINES_BASE_V l3
60231: , AR_CUST_TRX_LINES_L_V l4
60232: WHERE xet.event_id between x_first_event_id and x_last_event_id
60233: and xet.event_date between p_pad_start_date and p_pad_end_date
60234: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 61157: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

61153: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
61154: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
61155: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
61156: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
61157: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
61158: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
61159: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
61160: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
61161: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'

Line 61158: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

61154: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
61155: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
61156: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
61157: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
61158: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
61159: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
61160: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
61161: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
61162: WHEN 11 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 61159: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

61155: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
61156: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
61157: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
61158: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
61159: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
61160: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
61161: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
61162: WHEN 11 THEN 'AR_CUST_TRX_LINES_BASE_V'
61163:

Line 61160: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

61156: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
61157: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
61158: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
61159: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
61160: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
61161: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
61162: WHEN 11 THEN 'AR_CUST_TRX_LINES_BASE_V'
61163:
61164: ELSE null

Line 61162: WHEN 11 THEN 'AR_CUST_TRX_LINES_BASE_V'

61158: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
61159: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
61160: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
61161: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
61162: WHEN 11 THEN 'AR_CUST_TRX_LINES_BASE_V'
61163:
61164: ELSE null
61165: END object_name
61166: , CASE r

Line 61229: , AR_CUST_TRX_LINES_BASE_V l3

61225: ELSE null
61226: END source_value
61227: , null source_meaning
61228: FROM xla_events_gt xet
61229: , AR_CUST_TRX_LINES_BASE_V l3
61230: , AR_CUST_TRX_LINES_L_V l4
61231: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
61232: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
61233: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 61385: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

61381: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
61382: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
61383: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61384: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
61385: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
61386: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
61387: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61388: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
61389: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 61386: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

61382: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
61383: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61384: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
61385: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
61386: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
61387: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61388: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
61389: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
61390: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 61387: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

61383: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61384: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
61385: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
61386: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
61387: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61388: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
61389: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
61390: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;
61391:

Line 61388: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

61384: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
61385: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
61386: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
61387: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61388: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
61389: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
61390: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;
61391:
61392: l_array_source_9 t_array_source_9;

Line 61390: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;

61386: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
61387: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61388: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
61389: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
61390: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;
61391:
61392: l_array_source_9 t_array_source_9;
61393: l_array_source_23 t_array_source_23;
61394: l_array_source_24 t_array_source_24;

Line 61508: , AR_CUST_TRX_LINES_BASE_V l3

61504: , l3.TRX_LINE_ACCTD_AMT source_34
61505: , l4.TRX_TAX_LINE_ID source_48
61506: , l3.ROUNDING_CORRECTION_FLAG source_49
61507: FROM xla_events_gt xet
61508: , AR_CUST_TRX_LINES_BASE_V l3
61509: , AR_CUST_TRX_LINES_L_V l4
61510: WHERE xet.event_id between x_first_event_id and x_last_event_id
61511: and xet.event_date between p_pad_start_date and p_pad_end_date
61512: and xet.event_class_code = C_EVENT_CLASS_CODE