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_L_V

Line 20992: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'

20988: FROM (
20989: SELECT xet.event_id event_id
20990: , l3.line_number line_number
20991: , CASE r
20992: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
20993: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
20994: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
20995: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
20996: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

Line 20993: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'

20989: SELECT xet.event_id event_id
20990: , l3.line_number line_number
20991: , CASE r
20992: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
20993: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
20994: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_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'

Line 20994: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'

20990: , l3.line_number line_number
20991: , CASE r
20992: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
20993: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
20994: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_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'

Line 20995: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'

20991: , CASE r
20992: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
20993: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
20994: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_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'

Line 20996: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

20992: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
20993: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
20994: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_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'

Line 20997: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

20993: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
20994: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_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'

Line 20998: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'

20994: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_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'

Line 21070: , AR_DISTRIBUTIONS_L_V l3

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
21074: AND l2.event_id = xet.event_id

Line 21215: TYPE t_array_source_1 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

21211: TYPE t_array_source_38 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
21212: TYPE t_array_source_39 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
21213: TYPE t_array_source_41 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
21214:
21215: TYPE t_array_source_1 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
21216: TYPE t_array_source_7 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
21217: TYPE t_array_source_8 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%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;

Line 21216: TYPE t_array_source_7 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

21212: TYPE t_array_source_39 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
21213: TYPE t_array_source_41 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
21214:
21215: TYPE t_array_source_1 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
21216: TYPE t_array_source_7 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
21217: TYPE t_array_source_8 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%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;

Line 21217: TYPE t_array_source_8 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;

21213: TYPE t_array_source_41 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
21214:
21215: TYPE t_array_source_1 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
21216: TYPE t_array_source_7 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
21217: TYPE t_array_source_8 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%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;

Line 21218: TYPE t_array_source_9 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

21214:
21215: TYPE t_array_source_1 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
21216: TYPE t_array_source_7 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
21217: TYPE t_array_source_8 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%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;

Line 21219: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

21215: TYPE t_array_source_1 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
21216: TYPE t_array_source_7 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
21217: TYPE t_array_source_8 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%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;

Line 21220: TYPE t_array_source_11 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

21216: TYPE t_array_source_7 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
21217: TYPE t_array_source_8 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%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;

Line 21221: TYPE t_array_source_12 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

21217: TYPE t_array_source_8 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%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;

Line 21330: , AR_DISTRIBUTIONS_L_V l3

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
21334: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 22431: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'

22427: FROM (
22428: SELECT xet.event_id event_id
22429: , l4.line_number line_number
22430: , CASE r
22431: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
22432: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
22433: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
22434: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
22435: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

Line 22433: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'

22429: , l4.line_number line_number
22430: , CASE r
22431: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
22432: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
22433: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
22434: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
22435: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
22436: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
22437: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'

Line 22434: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'

22430: , CASE r
22431: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
22432: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
22433: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
22434: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
22435: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_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'

Line 22435: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

22431: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
22432: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
22433: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
22434: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
22435: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_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'

Line 22436: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

22432: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
22433: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
22434: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
22435: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_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'

Line 22437: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'

22433: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
22434: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
22435: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_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'

Line 22438: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'

22434: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
22435: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_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'

Line 22439: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'

22435: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_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'

Line 22448: WHEN 18 THEN 'AR_DISTRIBUTIONS_L_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'
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'

Line 22449: WHEN 19 THEN 'AR_DISTRIBUTIONS_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'
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'

Line 22452: WHEN 22 THEN 'AR_DISTRIBUTIONS_L_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'
22456: WHEN 26 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 22453: WHEN 23 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'
22456: WHEN 26 THEN 'AR_DISTRIBUTIONS_BASE_V'
22457: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 22454: WHEN 24 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'
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'

Line 22459: WHEN 29 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
22462: END object_name
22463: , CASE r

Line 22600: , AR_DISTRIBUTIONS_L_V l4

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)
22604: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 22760: TYPE t_array_source_1 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

22756: TYPE t_array_source_38 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
22757: TYPE t_array_source_39 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
22758: TYPE t_array_source_41 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
22759:
22760: TYPE t_array_source_1 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
22761: TYPE t_array_source_5 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
22762: TYPE t_array_source_6 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_REF_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
22763: TYPE t_array_source_7 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
22764: TYPE t_array_source_8 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;

Line 22762: TYPE t_array_source_6 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_REF_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

22758: TYPE t_array_source_41 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
22759:
22760: TYPE t_array_source_1 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
22761: TYPE t_array_source_5 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
22762: TYPE t_array_source_6 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_REF_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
22763: TYPE t_array_source_7 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
22764: TYPE t_array_source_8 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%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;

Line 22763: TYPE t_array_source_7 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

22759:
22760: TYPE t_array_source_1 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
22761: TYPE t_array_source_5 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
22762: TYPE t_array_source_6 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_REF_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
22763: TYPE t_array_source_7 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
22764: TYPE t_array_source_8 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%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;

Line 22764: TYPE t_array_source_8 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;

22760: TYPE t_array_source_1 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
22761: TYPE t_array_source_5 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
22762: TYPE t_array_source_6 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_REF_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
22763: TYPE t_array_source_7 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
22764: TYPE t_array_source_8 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%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;

Line 22765: TYPE t_array_source_9 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

22761: TYPE t_array_source_5 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
22762: TYPE t_array_source_6 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_REF_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
22763: TYPE t_array_source_7 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
22764: TYPE t_array_source_8 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%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;

Line 22766: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

22762: TYPE t_array_source_6 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_REF_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
22763: TYPE t_array_source_7 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
22764: TYPE t_array_source_8 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%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;

Line 22767: TYPE t_array_source_11 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

22763: TYPE t_array_source_7 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
22764: TYPE t_array_source_8 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%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;

Line 22768: TYPE t_array_source_12 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

22764: TYPE t_array_source_8 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%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;

Line 22777: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%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;
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;

Line 22778: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%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;
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;

Line 22781: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_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;
22785: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 22782: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%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;
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;

Line 22783: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%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;
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;

Line 22788: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%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;
22791: l_array_source_3 t_array_source_3;
22792: l_array_source_4 t_array_source_4;

Line 22950: , AR_DISTRIBUTIONS_L_V l4

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
22954: and xet.event_date between p_pad_start_date and p_pad_end_date