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_000004_PKG dependencies on AR_DISTRIBUTIONS_BASE_V

Line 20999: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'

20995: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
20996: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
20997: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
20998: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
20999: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
21000: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
21001: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
21002: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
21003:

Line 21000: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'

20996: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
20997: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
20998: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
20999: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
21000: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
21001: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
21002: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
21003:
21004: ELSE null

Line 21001: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'

20997: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
20998: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
20999: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
21000: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
21001: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
21002: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
21003:
21004: ELSE null
21005: END object_name

Line 21002: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'

20998: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
20999: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
21000: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
21001: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
21002: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
21003:
21004: ELSE null
21005: END object_name
21006: , CASE r

Line 21069: , AR_DISTRIBUTIONS_BASE_V l2

21065: ELSE null
21066: END source_value
21067: , null source_meaning
21068: FROM xla_events_gt xet
21069: , AR_DISTRIBUTIONS_BASE_V l2
21070: , AR_DISTRIBUTIONS_L_V l3
21071: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
21072: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
21073: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 21222: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

21218: TYPE t_array_source_9 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
21219: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
21220: TYPE t_array_source_11 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
21221: TYPE t_array_source_12 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
21222: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
21223: TYPE t_array_source_14 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
21224: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
21225: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
21226:

Line 21223: TYPE t_array_source_14 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

21219: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
21220: TYPE t_array_source_11 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
21221: TYPE t_array_source_12 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
21222: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
21223: TYPE t_array_source_14 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
21224: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
21225: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
21226:
21227: l_array_source_37 t_array_source_37;

Line 21224: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

21220: TYPE t_array_source_11 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
21221: TYPE t_array_source_12 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
21222: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
21223: TYPE t_array_source_14 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
21224: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
21225: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
21226:
21227: l_array_source_37 t_array_source_37;
21228: l_array_source_38 t_array_source_38;

Line 21225: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

21221: TYPE t_array_source_12 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
21222: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
21223: TYPE t_array_source_14 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
21224: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
21225: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
21226:
21227: l_array_source_37 t_array_source_37;
21228: l_array_source_38 t_array_source_38;
21229: l_array_source_39 t_array_source_39;

Line 21329: , AR_DISTRIBUTIONS_BASE_V l2

21325: , l2.DIST_CUR_CONVERSION_RATE source_14
21326: , l2.DIST_CUR_CONVERSION_TYPE source_15
21327: , l2.DIST_TO_ACCTD_AMT source_16
21328: FROM xla_events_gt xet
21329: , AR_DISTRIBUTIONS_BASE_V l2
21330: , AR_DISTRIBUTIONS_L_V l3
21331: WHERE xet.event_id between x_first_event_id and x_last_event_id
21332: and xet.event_date between p_pad_start_date and p_pad_end_date
21333: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 22440: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'

22436: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
22437: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
22438: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
22439: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
22440: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
22441: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
22442: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
22443: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
22444: WHEN 14 THEN 'AR_CUST_TRX_LINES_L_V'

Line 22441: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'

22437: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
22438: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
22439: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
22440: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
22441: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
22442: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
22443: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
22444: WHEN 14 THEN 'AR_CUST_TRX_LINES_L_V'
22445: WHEN 15 THEN 'AR_TRANSACTIONS_S_V'

Line 22442: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'

22438: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
22439: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
22440: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
22441: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
22442: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
22443: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
22444: WHEN 14 THEN 'AR_CUST_TRX_LINES_L_V'
22445: WHEN 15 THEN 'AR_TRANSACTIONS_S_V'
22446: WHEN 16 THEN 'AR_CUST_TRX_LINES_L_V'

Line 22443: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'

22439: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
22440: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
22441: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
22442: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
22443: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
22444: WHEN 14 THEN 'AR_CUST_TRX_LINES_L_V'
22445: WHEN 15 THEN 'AR_TRANSACTIONS_S_V'
22446: WHEN 16 THEN 'AR_CUST_TRX_LINES_L_V'
22447: WHEN 17 THEN 'AR_TRANSACTIONS_S_V'

Line 22450: WHEN 20 THEN 'AR_DISTRIBUTIONS_BASE_V'

22446: WHEN 16 THEN 'AR_CUST_TRX_LINES_L_V'
22447: WHEN 17 THEN 'AR_TRANSACTIONS_S_V'
22448: WHEN 18 THEN 'AR_DISTRIBUTIONS_L_V'
22449: WHEN 19 THEN 'AR_DISTRIBUTIONS_L_V'
22450: WHEN 20 THEN 'AR_DISTRIBUTIONS_BASE_V'
22451: WHEN 21 THEN 'AR_DISTRIBUTIONS_BASE_V'
22452: WHEN 22 THEN 'AR_DISTRIBUTIONS_L_V'
22453: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'
22454: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'

Line 22451: WHEN 21 THEN 'AR_DISTRIBUTIONS_BASE_V'

22447: WHEN 17 THEN 'AR_TRANSACTIONS_S_V'
22448: WHEN 18 THEN 'AR_DISTRIBUTIONS_L_V'
22449: WHEN 19 THEN 'AR_DISTRIBUTIONS_L_V'
22450: WHEN 20 THEN 'AR_DISTRIBUTIONS_BASE_V'
22451: WHEN 21 THEN 'AR_DISTRIBUTIONS_BASE_V'
22452: WHEN 22 THEN 'AR_DISTRIBUTIONS_L_V'
22453: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'
22454: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'
22455: WHEN 25 THEN 'AR_CUST_TRX_LINES_L_V'

Line 22456: WHEN 26 THEN 'AR_DISTRIBUTIONS_BASE_V'

22452: WHEN 22 THEN 'AR_DISTRIBUTIONS_L_V'
22453: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'
22454: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'
22455: WHEN 25 THEN 'AR_CUST_TRX_LINES_L_V'
22456: WHEN 26 THEN 'AR_DISTRIBUTIONS_BASE_V'
22457: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'
22458: WHEN 28 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
22459: WHEN 29 THEN 'AR_DISTRIBUTIONS_L_V'
22460:

Line 22457: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'

22453: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'
22454: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'
22455: WHEN 25 THEN 'AR_CUST_TRX_LINES_L_V'
22456: WHEN 26 THEN 'AR_DISTRIBUTIONS_BASE_V'
22457: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'
22458: WHEN 28 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
22459: WHEN 29 THEN 'AR_DISTRIBUTIONS_L_V'
22460:
22461: ELSE null

Line 22599: , AR_DISTRIBUTIONS_BASE_V l3

22595: END source_value
22596: , null source_meaning
22597: FROM xla_events_gt xet
22598: , AR_CUST_TRX_LINES_L_V l2
22599: , AR_DISTRIBUTIONS_BASE_V l3
22600: , AR_DISTRIBUTIONS_L_V l4
22601: , AR_RECEIVABLES_TRX_ACT_S_V l6
22602: , AR_TRANSACTIONS_S_V l9
22603: , (select rownum r from all_objects where rownum <= 29 and owner = p_apps_owner)

Line 22769: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

22765: TYPE t_array_source_9 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
22766: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
22767: TYPE t_array_source_11 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
22768: TYPE t_array_source_12 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
22769: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
22770: TYPE t_array_source_14 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
22771: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
22772: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
22773: TYPE t_array_source_18 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 22770: TYPE t_array_source_14 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

22766: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
22767: TYPE t_array_source_11 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
22768: TYPE t_array_source_12 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
22769: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
22770: TYPE t_array_source_14 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
22771: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
22772: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
22773: TYPE t_array_source_18 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
22774: TYPE t_array_source_19 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 22771: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

22767: TYPE t_array_source_11 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
22768: TYPE t_array_source_12 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
22769: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
22770: TYPE t_array_source_14 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
22771: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
22772: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
22773: TYPE t_array_source_18 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
22774: TYPE t_array_source_19 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
22775: TYPE t_array_source_20 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 22772: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

22768: TYPE t_array_source_12 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
22769: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
22770: TYPE t_array_source_14 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
22771: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
22772: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
22773: TYPE t_array_source_18 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
22774: TYPE t_array_source_19 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
22775: TYPE t_array_source_20 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
22776: TYPE t_array_source_21 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;

Line 22779: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

22775: TYPE t_array_source_20 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
22776: TYPE t_array_source_21 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
22777: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
22778: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
22779: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
22780: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
22781: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
22782: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
22783: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 22780: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

22776: TYPE t_array_source_21 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
22777: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
22778: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
22779: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
22780: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
22781: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
22782: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
22783: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
22784: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 22785: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

22781: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
22782: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
22783: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
22784: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
22785: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
22786: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
22787: TYPE t_array_source_32 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
22788: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;
22789:

Line 22786: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

22782: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
22783: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
22784: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
22785: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
22786: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
22787: TYPE t_array_source_32 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
22788: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;
22789:
22790: l_array_source_2 t_array_source_2;

Line 22949: , AR_DISTRIBUTIONS_BASE_V l3

22945: , l6.REC_ACT_TYPE source_32
22946: , l4.DIST_SOURCE_TABLE source_33
22947: FROM xla_events_gt xet
22948: , AR_CUST_TRX_LINES_L_V l2
22949: , AR_DISTRIBUTIONS_BASE_V l3
22950: , AR_DISTRIBUTIONS_L_V l4
22951: , AR_RECEIVABLES_TRX_ACT_S_V l6
22952: , AR_TRANSACTIONS_S_V l9
22953: WHERE xet.event_id between x_first_event_id and x_last_event_id