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

Line 69206: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

69202: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
69203: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
69204: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
69205: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
69206: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
69207: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
69208: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
69209: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
69210:

Line 69207: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

69203: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
69204: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
69205: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
69206: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
69207: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
69208: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
69209: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
69210:
69211: ELSE null

Line 69208: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

69204: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
69205: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
69206: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
69207: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
69208: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
69209: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
69210:
69211: ELSE null
69212: END object_name

Line 69209: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

69205: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
69206: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
69207: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
69208: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
69209: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
69210:
69211: ELSE null
69212: END object_name
69213: , CASE r

Line 69268: , AR_CUST_TRX_LINES_BASE_V l3

69264: ELSE null
69265: END source_value
69266: , null source_meaning
69267: FROM xla_events_gt xet
69268: , AR_CUST_TRX_LINES_BASE_V l3
69269: , AR_CUST_TRX_LINES_L_V l4
69270: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
69271: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69272: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 69422: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

69418: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
69419: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
69420: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69421: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
69422: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
69423: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
69424: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69425: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
69426:

Line 69423: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

69419: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
69420: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69421: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
69422: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
69423: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
69424: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69425: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
69426:
69427: l_array_source_32 t_array_source_32;

Line 69424: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

69420: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69421: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
69422: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
69423: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
69424: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69425: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
69426:
69427: l_array_source_32 t_array_source_32;
69428: l_array_source_33 t_array_source_33;

Line 69425: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

69421: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
69422: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
69423: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
69424: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69425: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
69426:
69427: l_array_source_32 t_array_source_32;
69428: l_array_source_33 t_array_source_33;
69429: l_array_source_34 t_array_source_34;

Line 69535: , AR_CUST_TRX_LINES_BASE_V l3

69531: , l3.TRX_LINE_CUR_CONVERSION_RATE source_41
69532: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_42
69533: , l3.TRX_LINE_ACCTD_AMT source_43
69534: FROM xla_events_gt xet
69535: , AR_CUST_TRX_LINES_BASE_V l3
69536: , AR_CUST_TRX_LINES_L_V l4
69537: WHERE xet.event_id between x_first_event_id and x_last_event_id
69538: and xet.event_date between p_pad_start_date and p_pad_end_date
69539: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 72081: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

72077: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
72078: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
72079: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
72080: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
72081: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
72082: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
72083: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
72084: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
72085: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'

Line 72082: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

72078: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
72079: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
72080: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
72081: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
72082: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
72083: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
72084: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
72085: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
72086:

Line 72083: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

72079: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
72080: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
72081: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
72082: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
72083: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
72084: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
72085: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
72086:
72087: ELSE null

Line 72084: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

72080: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
72081: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
72082: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
72083: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
72084: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
72085: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
72086:
72087: ELSE null
72088: END object_name

Line 72148: , AR_CUST_TRX_LINES_BASE_V l3

72144: ELSE null
72145: END source_value
72146: , null source_meaning
72147: FROM xla_events_gt xet
72148: , AR_CUST_TRX_LINES_BASE_V l3
72149: , AR_CUST_TRX_LINES_L_V l4
72150: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
72151: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72152: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 72304: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

72300: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72301: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
72302: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
72303: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
72304: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
72305: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
72306: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
72307: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
72308: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 72305: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

72301: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
72302: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
72303: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
72304: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
72305: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
72306: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
72307: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
72308: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
72309:

Line 72306: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

72302: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
72303: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
72304: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
72305: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
72306: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
72307: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
72308: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
72309:
72310: l_array_source_8 t_array_source_8;

Line 72307: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

72303: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
72304: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
72305: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
72306: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
72307: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
72308: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
72309:
72310: l_array_source_8 t_array_source_8;
72311: l_array_source_32 t_array_source_32;

Line 72424: , AR_CUST_TRX_LINES_BASE_V l3

72420: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_42
72421: , l3.TRX_LINE_ACCTD_AMT source_43
72422: , l4.TRX_TAX_LINE_ID source_57
72423: FROM xla_events_gt xet
72424: , AR_CUST_TRX_LINES_BASE_V l3
72425: , AR_CUST_TRX_LINES_L_V l4
72426: WHERE xet.event_id between x_first_event_id and x_last_event_id
72427: and xet.event_date between p_pad_start_date and p_pad_end_date
72428: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 73542: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

73538: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
73539: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
73540: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
73541: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
73542: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
73543: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
73544: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
73545: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
73546:

Line 73543: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

73539: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
73540: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
73541: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
73542: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
73543: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
73544: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
73545: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
73546:
73547: ELSE null

Line 73544: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

73540: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
73541: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
73542: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
73543: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
73544: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
73545: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
73546:
73547: ELSE null
73548: END object_name

Line 73545: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

73541: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
73542: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
73543: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
73544: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
73545: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
73546:
73547: ELSE null
73548: END object_name
73549: , CASE r

Line 73604: , AR_CUST_TRX_LINES_BASE_V l3

73600: ELSE null
73601: END source_value
73602: , null source_meaning
73603: FROM xla_events_gt xet
73604: , AR_CUST_TRX_LINES_BASE_V l3
73605: , AR_CUST_TRX_LINES_L_V l4
73606: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
73607: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73608: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 73758: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

73754: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73755: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73756: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73757: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
73758: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73759: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
73760: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73761: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
73762:

Line 73759: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

73755: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73756: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73757: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
73758: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73759: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
73760: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73761: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
73762:
73763: l_array_source_32 t_array_source_32;

Line 73760: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

73756: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73757: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
73758: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73759: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
73760: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73761: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
73762:
73763: l_array_source_32 t_array_source_32;
73764: l_array_source_33 t_array_source_33;

Line 73761: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

73757: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
73758: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73759: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
73760: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73761: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
73762:
73763: l_array_source_32 t_array_source_32;
73764: l_array_source_33 t_array_source_33;
73765: l_array_source_34 t_array_source_34;

Line 73871: , AR_CUST_TRX_LINES_BASE_V l3

73867: , l3.TRX_LINE_CUR_CONVERSION_RATE source_41
73868: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_42
73869: , l3.TRX_LINE_ACCTD_AMT source_43
73870: FROM xla_events_gt xet
73871: , AR_CUST_TRX_LINES_BASE_V l3
73872: , AR_CUST_TRX_LINES_L_V l4
73873: WHERE xet.event_id between x_first_event_id and x_last_event_id
73874: and xet.event_date between p_pad_start_date and p_pad_end_date
73875: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 74788: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

74784: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
74785: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
74786: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74787: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74788: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
74789: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
74790: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
74791: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
74792:

Line 74789: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

74785: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
74786: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74787: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74788: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
74789: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
74790: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
74791: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
74792:
74793: ELSE null

Line 74790: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

74786: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74787: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74788: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
74789: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
74790: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
74791: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
74792:
74793: ELSE null
74794: END object_name

Line 74791: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

74787: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74788: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
74789: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
74790: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
74791: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
74792:
74793: ELSE null
74794: END object_name
74795: , CASE r

Line 74850: , AR_CUST_TRX_LINES_BASE_V l3

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

Line 75004: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

75000: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75001: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75002: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75003: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
75004: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
75005: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
75006: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75007: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
75008:

Line 75005: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

75001: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75002: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75003: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
75004: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
75005: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
75006: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75007: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
75008:
75009: l_array_source_32 t_array_source_32;

Line 75006: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

75002: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75003: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
75004: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
75005: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
75006: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75007: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
75008:
75009: l_array_source_32 t_array_source_32;
75010: l_array_source_33 t_array_source_33;

Line 75007: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

75003: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
75004: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
75005: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
75006: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75007: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
75008:
75009: l_array_source_32 t_array_source_32;
75010: l_array_source_33 t_array_source_33;
75011: l_array_source_34 t_array_source_34;

Line 75117: , AR_CUST_TRX_LINES_BASE_V l3

75113: , l3.TRX_LINE_CUR_CONVERSION_RATE source_41
75114: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_42
75115: , l3.TRX_LINE_ACCTD_AMT source_43
75116: FROM xla_events_gt xet
75117: , AR_CUST_TRX_LINES_BASE_V l3
75118: , AR_CUST_TRX_LINES_L_V l4
75119: WHERE xet.event_id between x_first_event_id and x_last_event_id
75120: and xet.event_date between p_pad_start_date and p_pad_end_date
75121: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 76050: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

76046: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
76047: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
76048: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
76049: WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V'
76050: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
76051: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
76052: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
76053: WHEN 10 THEN 'AR_CUST_TRX_LINES_BASE_V'
76054: WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V'

Line 76051: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

76047: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
76048: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
76049: WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V'
76050: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
76051: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
76052: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
76053: WHEN 10 THEN 'AR_CUST_TRX_LINES_BASE_V'
76054: WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V'
76055: WHEN 12 THEN 'FV_XLA_AR_REF_V'

Line 76052: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

76048: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
76049: WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V'
76050: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
76051: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
76052: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
76053: WHEN 10 THEN 'AR_CUST_TRX_LINES_BASE_V'
76054: WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V'
76055: WHEN 12 THEN 'FV_XLA_AR_REF_V'
76056: WHEN 13 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 76053: WHEN 10 THEN 'AR_CUST_TRX_LINES_BASE_V'

76049: WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V'
76050: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
76051: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
76052: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
76053: WHEN 10 THEN 'AR_CUST_TRX_LINES_BASE_V'
76054: WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V'
76055: WHEN 12 THEN 'FV_XLA_AR_REF_V'
76056: WHEN 13 THEN 'AR_CUST_TRX_LINES_BASE_V'
76057:

Line 76056: WHEN 13 THEN 'AR_CUST_TRX_LINES_BASE_V'

76052: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
76053: WHEN 10 THEN 'AR_CUST_TRX_LINES_BASE_V'
76054: WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V'
76055: WHEN 12 THEN 'FV_XLA_AR_REF_V'
76056: WHEN 13 THEN 'AR_CUST_TRX_LINES_BASE_V'
76057:
76058: ELSE null
76059: END object_name
76060: , CASE r

Line 76131: , AR_CUST_TRX_LINES_BASE_V l3

76127: ELSE null
76128: END source_value
76129: , null source_meaning
76130: FROM xla_events_gt xet
76131: , AR_CUST_TRX_LINES_BASE_V l3
76132: , AR_CUST_TRX_LINES_L_V l4
76133: , FV_XLA_AR_REF_V l6
76134: , (select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
76135: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 76290: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

76286: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
76287: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
76288: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76289: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
76290: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
76291: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
76292: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76293: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
76294: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 76291: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

76287: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
76288: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76289: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
76290: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
76291: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
76292: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76293: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
76294: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
76295: TYPE t_array_source_58 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 76292: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

76288: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76289: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
76290: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
76291: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
76292: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76293: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
76294: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
76295: TYPE t_array_source_58 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
76296: TYPE t_array_source_68 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 76293: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

76289: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
76290: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
76291: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
76292: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76293: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
76294: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
76295: TYPE t_array_source_58 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
76296: TYPE t_array_source_68 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;
76297:

Line 76296: TYPE t_array_source_68 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;

76292: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76293: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
76294: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
76295: TYPE t_array_source_58 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
76296: TYPE t_array_source_68 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;
76297:
76298: l_array_source_8 t_array_source_8;
76299: l_array_source_12 t_array_source_12;
76300: l_array_source_32 t_array_source_32;

Line 76420: , AR_CUST_TRX_LINES_BASE_V l3

76416: , l4.TRX_TAX_LINE_ID source_57
76417: , l6.FEDERAL_ACCOUNT_VALID_FLAG source_58
76418: , l3.ROUNDING_CORRECTION_FLAG source_68
76419: FROM xla_events_gt xet
76420: , AR_CUST_TRX_LINES_BASE_V l3
76421: , AR_CUST_TRX_LINES_L_V l4
76422: , FV_XLA_AR_REF_V l6
76423: WHERE xet.event_id between x_first_event_id and x_last_event_id
76424: and xet.event_date between p_pad_start_date and p_pad_end_date