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

Line 69551: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

69547: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
69548: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
69549: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
69550: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
69551: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
69552: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
69553: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
69554: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
69555:

Line 69552: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

69548: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
69549: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
69550: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
69551: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
69552: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
69553: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
69554: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
69555:
69556: ELSE null

Line 69553: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

69549: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
69550: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
69551: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
69552: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
69553: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
69554: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
69555:
69556: ELSE null
69557: END object_name

Line 69554: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

69550: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
69551: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
69552: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
69553: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
69554: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
69555:
69556: ELSE null
69557: END object_name
69558: , CASE r

Line 69613: , AR_CUST_TRX_LINES_BASE_V l3

69609: ELSE null
69610: END source_value
69611: , null source_meaning
69612: FROM xla_events_gt xet
69613: , AR_CUST_TRX_LINES_BASE_V l3
69614: , AR_CUST_TRX_LINES_L_V l4
69615: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
69616: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69617: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 69769: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

69765: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
69766: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
69767: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69768: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
69769: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
69770: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
69771: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69772: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
69773:

Line 69770: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

69766: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
69767: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69768: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
69769: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
69770: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
69771: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69772: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
69773:
69774: l_array_source_3 t_array_source_3;

Line 69771: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

69767: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69768: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
69769: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
69770: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
69771: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69772: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
69773:
69774: l_array_source_3 t_array_source_3;
69775: l_array_source_4 t_array_source_4;

Line 69772: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

69768: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
69769: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
69770: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
69771: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69772: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
69773:
69774: l_array_source_3 t_array_source_3;
69775: l_array_source_4 t_array_source_4;
69776: l_array_source_5 t_array_source_5;

Line 69886: , AR_CUST_TRX_LINES_BASE_V l3

69882: , l3.TRX_LINE_CUR_CONVERSION_RATE source_61
69883: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_62
69884: , l3.TRX_LINE_ACCTD_AMT source_63
69885: FROM xla_events_gt xet
69886: , AR_CUST_TRX_LINES_BASE_V l3
69887: , AR_CUST_TRX_LINES_L_V l4
69888: WHERE xet.event_id between x_first_event_id and x_last_event_id
69889: and xet.event_date between p_pad_start_date and p_pad_end_date
69890: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 74368: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

74364: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
74365: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
74366: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74367: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74368: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
74369: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
74370: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
74371: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
74372: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'

Line 74369: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

74365: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
74366: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74367: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74368: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
74369: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
74370: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
74371: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
74372: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
74373:

Line 74370: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

74366: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74367: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74368: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
74369: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
74370: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
74371: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
74372: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
74373:
74374: ELSE null

Line 74371: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

74367: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74368: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
74369: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
74370: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
74371: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
74372: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
74373:
74374: ELSE null
74375: END object_name

Line 74435: , AR_CUST_TRX_LINES_BASE_V l3

74431: ELSE null
74432: END source_value
74433: , null source_meaning
74434: FROM xla_events_gt xet
74435: , AR_CUST_TRX_LINES_BASE_V l3
74436: , AR_CUST_TRX_LINES_L_V l4
74437: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
74438: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74439: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 74591: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

74587: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74588: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
74589: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74590: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
74591: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
74592: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
74593: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74594: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
74595: TYPE t_array_source_97 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 74592: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

74588: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
74589: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74590: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
74591: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
74592: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
74593: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74594: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
74595: TYPE t_array_source_97 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
74596:

Line 74593: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

74589: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74590: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
74591: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
74592: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
74593: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74594: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
74595: TYPE t_array_source_97 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
74596:
74597: l_array_source_3 t_array_source_3;

Line 74594: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

74590: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
74591: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
74592: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
74593: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74594: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
74595: TYPE t_array_source_97 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
74596:
74597: l_array_source_3 t_array_source_3;
74598: l_array_source_4 t_array_source_4;

Line 74711: , AR_CUST_TRX_LINES_BASE_V l3

74707: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_62
74708: , l3.TRX_LINE_ACCTD_AMT source_63
74709: , l4.TRX_TAX_LINE_ID source_97
74710: FROM xla_events_gt xet
74711: , AR_CUST_TRX_LINES_BASE_V l3
74712: , AR_CUST_TRX_LINES_L_V l4
74713: WHERE xet.event_id between x_first_event_id and x_last_event_id
74714: and xet.event_date between p_pad_start_date and p_pad_end_date
74715: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 75881: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

75877: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
75878: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
75879: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
75880: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
75881: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
75882: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
75883: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
75884: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
75885:

Line 75882: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

75878: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
75879: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
75880: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
75881: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
75882: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
75883: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
75884: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
75885:
75886: ELSE null

Line 75883: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

75879: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
75880: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
75881: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
75882: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
75883: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
75884: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
75885:
75886: ELSE null
75887: END object_name

Line 75884: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

75880: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
75881: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
75882: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
75883: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
75884: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
75885:
75886: ELSE null
75887: END object_name
75888: , CASE r

Line 75943: , AR_CUST_TRX_LINES_BASE_V l3

75939: ELSE null
75940: END source_value
75941: , null source_meaning
75942: FROM xla_events_gt xet
75943: , AR_CUST_TRX_LINES_BASE_V l3
75944: , AR_CUST_TRX_LINES_L_V l4
75945: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
75946: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75947: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 76099: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

76095: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
76096: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
76097: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76098: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
76099: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
76100: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
76101: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76102: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
76103:

Line 76100: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

76096: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
76097: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76098: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
76099: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
76100: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
76101: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76102: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
76103:
76104: l_array_source_3 t_array_source_3;

Line 76101: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

76097: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76098: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
76099: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
76100: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
76101: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76102: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
76103:
76104: l_array_source_3 t_array_source_3;
76105: l_array_source_4 t_array_source_4;

Line 76102: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

76098: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
76099: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
76100: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
76101: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76102: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
76103:
76104: l_array_source_3 t_array_source_3;
76105: l_array_source_4 t_array_source_4;
76106: l_array_source_5 t_array_source_5;

Line 76216: , AR_CUST_TRX_LINES_BASE_V l3

76212: , l3.TRX_LINE_CUR_CONVERSION_RATE source_61
76213: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_62
76214: , l3.TRX_LINE_ACCTD_AMT source_63
76215: FROM xla_events_gt xet
76216: , AR_CUST_TRX_LINES_BASE_V l3
76217: , AR_CUST_TRX_LINES_L_V l4
76218: WHERE xet.event_id between x_first_event_id and x_last_event_id
76219: and xet.event_date between p_pad_start_date and p_pad_end_date
76220: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 78980: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

78976: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
78977: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
78978: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
78979: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
78980: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
78981: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
78982: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
78983: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
78984:

Line 78981: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

78977: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
78978: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
78979: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
78980: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
78981: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
78982: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
78983: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
78984:
78985: ELSE null

Line 78982: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

78978: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
78979: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
78980: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
78981: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
78982: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
78983: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
78984:
78985: ELSE null
78986: END object_name

Line 78983: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

78979: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
78980: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
78981: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
78982: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
78983: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
78984:
78985: ELSE null
78986: END object_name
78987: , CASE r

Line 79042: , AR_CUST_TRX_LINES_BASE_V l3

79038: ELSE null
79039: END source_value
79040: , null source_meaning
79041: FROM xla_events_gt xet
79042: , AR_CUST_TRX_LINES_BASE_V l3
79043: , AR_CUST_TRX_LINES_L_V l4
79044: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
79045: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79046: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 79198: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

79194: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
79195: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
79196: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79197: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
79198: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79199: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79200: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79201: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79202:

Line 79199: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

79195: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
79196: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79197: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
79198: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79199: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79200: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79201: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79202:
79203: l_array_source_3 t_array_source_3;

Line 79200: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

79196: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79197: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
79198: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79199: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79200: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79201: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79202:
79203: l_array_source_3 t_array_source_3;
79204: l_array_source_4 t_array_source_4;

Line 79201: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

79197: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
79198: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79199: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79200: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79201: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79202:
79203: l_array_source_3 t_array_source_3;
79204: l_array_source_4 t_array_source_4;
79205: l_array_source_5 t_array_source_5;

Line 79315: , AR_CUST_TRX_LINES_BASE_V l3

79311: , l3.TRX_LINE_CUR_CONVERSION_RATE source_61
79312: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_62
79313: , l3.TRX_LINE_ACCTD_AMT source_63
79314: FROM xla_events_gt xet
79315: , AR_CUST_TRX_LINES_BASE_V l3
79316: , AR_CUST_TRX_LINES_L_V l4
79317: WHERE xet.event_id between x_first_event_id and x_last_event_id
79318: and xet.event_date between p_pad_start_date and p_pad_end_date
79319: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 80258: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

80254: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
80255: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
80256: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
80257: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
80258: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
80259: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
80260: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
80261: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
80262: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'

Line 80259: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

80255: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
80256: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
80257: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
80258: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
80259: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
80260: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
80261: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
80262: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
80263: WHEN 11 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 80260: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

80256: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
80257: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
80258: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
80259: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
80260: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
80261: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
80262: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
80263: WHEN 11 THEN 'AR_CUST_TRX_LINES_BASE_V'
80264:

Line 80261: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

80257: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
80258: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
80259: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
80260: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
80261: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
80262: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
80263: WHEN 11 THEN 'AR_CUST_TRX_LINES_BASE_V'
80264:
80265: ELSE null

Line 80263: WHEN 11 THEN 'AR_CUST_TRX_LINES_BASE_V'

80259: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
80260: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
80261: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
80262: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
80263: WHEN 11 THEN 'AR_CUST_TRX_LINES_BASE_V'
80264:
80265: ELSE null
80266: END object_name
80267: , CASE r

Line 80330: , AR_CUST_TRX_LINES_BASE_V l3

80326: ELSE null
80327: END source_value
80328: , null source_meaning
80329: FROM xla_events_gt xet
80330: , AR_CUST_TRX_LINES_BASE_V l3
80331: , AR_CUST_TRX_LINES_L_V l4
80332: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
80333: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
80334: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 80486: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

80482: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
80483: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
80484: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
80485: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
80486: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
80487: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
80488: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
80489: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
80490: TYPE t_array_source_97 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 80487: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

80483: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
80484: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
80485: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
80486: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
80487: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
80488: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
80489: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
80490: TYPE t_array_source_97 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
80491: TYPE t_array_source_98 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 80488: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

80484: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
80485: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
80486: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
80487: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
80488: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
80489: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
80490: TYPE t_array_source_97 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
80491: TYPE t_array_source_98 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;
80492:

Line 80489: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

80485: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
80486: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
80487: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
80488: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
80489: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
80490: TYPE t_array_source_97 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
80491: TYPE t_array_source_98 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;
80492:
80493: l_array_source_3 t_array_source_3;

Line 80491: TYPE t_array_source_98 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;

80487: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
80488: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
80489: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
80490: TYPE t_array_source_97 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
80491: TYPE t_array_source_98 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;
80492:
80493: l_array_source_3 t_array_source_3;
80494: l_array_source_4 t_array_source_4;
80495: l_array_source_5 t_array_source_5;

Line 80609: , AR_CUST_TRX_LINES_BASE_V l3

80605: , l3.TRX_LINE_ACCTD_AMT source_63
80606: , l4.TRX_TAX_LINE_ID source_97
80607: , l3.ROUNDING_CORRECTION_FLAG source_98
80608: FROM xla_events_gt xet
80609: , AR_CUST_TRX_LINES_BASE_V l3
80610: , AR_CUST_TRX_LINES_L_V l4
80611: WHERE xet.event_id between x_first_event_id and x_last_event_id
80612: and xet.event_date between p_pad_start_date and p_pad_end_date
80613: and xet.event_class_code = C_EVENT_CLASS_CODE