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_000007_PKG dependencies on AR_DISTRIBUTIONS_L_V

Line 53224: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'

53220: FROM (
53221: SELECT xet.event_id event_id
53222: , l5.line_number line_number
53223: , CASE r
53224: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
53225: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
53226: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
53227: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
53228: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

Line 53225: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'

53221: SELECT xet.event_id event_id
53222: , l5.line_number line_number
53223: , CASE r
53224: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
53225: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
53226: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
53227: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
53228: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
53229: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

Line 53226: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'

53222: , l5.line_number line_number
53223: , CASE r
53224: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
53225: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
53226: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
53227: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
53228: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
53229: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
53230: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 53227: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'

53223: , CASE r
53224: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
53225: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
53226: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
53227: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
53228: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
53229: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
53230: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
53231: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 53228: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

53224: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
53225: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
53226: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
53227: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
53228: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
53229: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
53230: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
53231: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
53232: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 53229: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

53225: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
53226: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
53227: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
53228: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
53229: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
53230: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
53231: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
53232: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
53233: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 53297: , AR_DISTRIBUTIONS_L_V l5

53293: END source_value
53294: , null source_meaning
53295: FROM xla_events_gt xet
53296: , AR_DISTRIBUTIONS_BASE_V l4
53297: , AR_DISTRIBUTIONS_L_V l5
53298: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
53299: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
53300: AND xet.event_class_code = C_EVENT_CLASS_CODE
53301: AND l4.event_id = xet.event_id

Line 53446: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

53442: TYPE t_array_source_73 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
53443: TYPE t_array_source_74 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
53444: TYPE t_array_source_75 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
53445:
53446: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
53447: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
53448: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
53449: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
53450: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 53447: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

53443: TYPE t_array_source_74 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
53444: TYPE t_array_source_75 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
53445:
53446: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
53447: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
53448: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
53449: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
53450: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
53451: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 53448: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

53444: TYPE t_array_source_75 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
53445:
53446: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
53447: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
53448: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
53449: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
53450: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
53451: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
53452: TYPE t_array_source_21 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 53449: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

53445:
53446: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
53447: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
53448: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
53449: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
53450: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
53451: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
53452: TYPE t_array_source_21 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
53453: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 53450: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

53446: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
53447: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
53448: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
53449: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
53450: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
53451: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
53452: TYPE t_array_source_21 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
53453: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
53454: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 53451: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

53447: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
53448: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
53449: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
53450: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
53451: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
53452: TYPE t_array_source_21 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
53453: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
53454: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
53455: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 53574: , AR_DISTRIBUTIONS_L_V l5

53570: , l4.DIST_CUR_CONVERSION_TYPE source_23
53571: , l4.DIST_TO_ACCTD_AMT source_24
53572: FROM xla_events_gt xet
53573: , AR_DISTRIBUTIONS_BASE_V l4
53574: , AR_DISTRIBUTIONS_L_V l5
53575: WHERE xet.event_id between x_first_event_id and x_last_event_id
53576: and xet.event_date between p_pad_start_date and p_pad_end_date
53577: and xet.event_class_code = C_EVENT_CLASS_CODE
53578: and xet.event_status_code <> 'N' AND l4.event_id = xet.event_id

Line 55839: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'

55835: SELECT xet.event_id event_id
55836: , l3.line_number line_number
55837: , CASE r
55838: WHEN 1 THEN 'AR_CM_LINES_L_V'
55839: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
55840: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
55841: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
55842: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
55843: WHEN 6 THEN 'AR_CM_LINES_BASE_V'

Line 55840: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'

55836: , l3.line_number line_number
55837: , CASE r
55838: WHEN 1 THEN 'AR_CM_LINES_L_V'
55839: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
55840: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
55841: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
55842: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
55843: WHEN 6 THEN 'AR_CM_LINES_BASE_V'
55844: WHEN 7 THEN 'AR_CM_LINES_BASE_V'

Line 55842: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

55838: WHEN 1 THEN 'AR_CM_LINES_L_V'
55839: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
55840: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
55841: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
55842: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
55843: WHEN 6 THEN 'AR_CM_LINES_BASE_V'
55844: WHEN 7 THEN 'AR_CM_LINES_BASE_V'
55845: WHEN 8 THEN 'AR_CM_LINES_BASE_V'
55846: WHEN 9 THEN 'AR_CM_LINES_BASE_V'

Line 55937: , AR_DISTRIBUTIONS_L_V l6

55933: , null source_meaning
55934: FROM xla_events_gt xet
55935: , AR_CM_LINES_BASE_V l3
55936: , AR_CM_LINES_L_V l4
55937: , AR_DISTRIBUTIONS_L_V l6
55938: , AR_RECEIVABLES_TRX_ACT_S_V l7
55939: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
55940: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
55941: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 56092: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

56088: TYPE t_array_source_46 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
56089: TYPE t_array_source_52 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
56090:
56091: TYPE t_array_source_9 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
56092: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
56093: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
56094: TYPE t_array_source_16 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
56095: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
56096: TYPE t_array_source_37 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;

Line 56093: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

56089: TYPE t_array_source_52 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
56090:
56091: TYPE t_array_source_9 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
56092: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
56093: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
56094: TYPE t_array_source_16 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
56095: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
56096: TYPE t_array_source_37 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
56097: TYPE t_array_source_38 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 56095: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

56091: TYPE t_array_source_9 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
56092: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
56093: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
56094: TYPE t_array_source_16 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
56095: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
56096: TYPE t_array_source_37 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
56097: TYPE t_array_source_38 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
56098: TYPE t_array_source_40 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
56099: TYPE t_array_source_41 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 56233: , AR_DISTRIBUTIONS_L_V l6

56229: , l4.CM_LINE_DIST_AMT source_49
56230: FROM xla_events_gt xet
56231: , AR_CM_LINES_BASE_V l3
56232: , AR_CM_LINES_L_V l4
56233: , AR_DISTRIBUTIONS_L_V l6
56234: , AR_RECEIVABLES_TRX_ACT_S_V l7
56235: WHERE xet.event_id between x_first_event_id and x_last_event_id
56236: and xet.event_date between p_pad_start_date and p_pad_end_date
56237: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 62908: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'

62904: FROM (
62905: SELECT xet.event_id event_id
62906: , l3.line_number line_number
62907: , CASE r
62908: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
62909: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
62910: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
62911: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
62912: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

Line 62909: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'

62905: SELECT xet.event_id event_id
62906: , l3.line_number line_number
62907: , CASE r
62908: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
62909: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
62910: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
62911: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
62912: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
62913: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

Line 62910: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'

62906: , l3.line_number line_number
62907: , CASE r
62908: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
62909: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
62910: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
62911: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
62912: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
62913: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
62914: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 62911: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'

62907: , CASE r
62908: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
62909: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
62910: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
62911: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
62912: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
62913: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
62914: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
62915: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 62912: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

62908: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
62909: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
62910: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
62911: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
62912: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
62913: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
62914: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
62915: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
62916: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 62913: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

62909: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
62910: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
62911: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
62912: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
62913: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
62914: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
62915: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
62916: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
62917: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'

Line 62917: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'

62913: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
62914: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
62915: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
62916: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
62917: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
62918: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
62919:
62920: ELSE null
62921: END object_name

Line 62986: , AR_DISTRIBUTIONS_L_V l3

62982: END source_value
62983: , null source_meaning
62984: FROM xla_events_gt xet
62985: , AR_DISTRIBUTIONS_BASE_V l2
62986: , AR_DISTRIBUTIONS_L_V l3
62987: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
62988: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
62989: AND xet.event_class_code = C_EVENT_CLASS_CODE
62990: AND l2.event_id = xet.event_id

Line 63137: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

63133: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
63134: TYPE t_array_source_82 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
63135: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
63136:
63137: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
63138: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
63139: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
63140: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
63141: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 63138: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

63134: TYPE t_array_source_82 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
63135: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
63136:
63137: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
63138: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
63139: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
63140: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
63141: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
63142: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 63139: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

63135: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
63136:
63137: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
63138: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
63139: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
63140: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
63141: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
63142: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
63143: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 63140: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

63136:
63137: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
63138: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
63139: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
63140: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
63141: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
63142: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
63143: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
63144: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 63141: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

63137: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
63138: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
63139: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
63140: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
63141: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
63142: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
63143: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
63144: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
63145: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 63142: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

63138: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
63139: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
63140: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
63141: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
63142: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
63143: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
63144: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
63145: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
63146: TYPE t_array_source_54 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;

Line 63146: TYPE t_array_source_54 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;

63142: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
63143: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
63144: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
63145: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
63146: TYPE t_array_source_54 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
63147: TYPE t_array_source_55 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
63148:
63149: l_array_source_1 t_array_source_1;
63150: l_array_source_3 t_array_source_3;

Line 63268: , AR_DISTRIBUTIONS_L_V l3

63264: , l3.DIST_MFAR_ADDITIONAL_ENTRY source_54
63265: , l2.DIST_TO_CUR_CONVERSION_DATE source_55
63266: FROM xla_events_gt xet
63267: , AR_DISTRIBUTIONS_BASE_V l2
63268: , AR_DISTRIBUTIONS_L_V l3
63269: WHERE xet.event_id between x_first_event_id and x_last_event_id
63270: and xet.event_date between p_pad_start_date and p_pad_end_date
63271: and xet.event_class_code = C_EVENT_CLASS_CODE
63272: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 64489: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'

64485: FROM (
64486: SELECT xet.event_id event_id
64487: , l4.line_number line_number
64488: , CASE r
64489: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
64490: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
64491: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
64492: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
64493: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

Line 64491: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'

64487: , l4.line_number line_number
64488: , CASE r
64489: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
64490: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
64491: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
64492: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
64493: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
64494: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
64495: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'

Line 64493: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

64489: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
64490: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
64491: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
64492: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
64493: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
64494: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
64495: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
64496: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
64497: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 64494: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

64490: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
64491: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
64492: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
64493: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
64494: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
64495: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
64496: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
64497: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
64498: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 64495: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'

64491: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
64492: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
64493: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
64494: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
64495: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
64496: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
64497: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
64498: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
64499: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 64496: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'

64492: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
64493: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
64494: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
64495: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
64496: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
64497: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
64498: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
64499: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
64500: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 64504: WHEN 16 THEN 'AR_DISTRIBUTIONS_L_V'

64500: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
64501: WHEN 13 THEN 'AR_CUST_TRX_LINES_L_V'
64502: WHEN 14 THEN 'AR_CUST_TRX_LINES_L_V'
64503: WHEN 15 THEN 'AR_CUST_TRX_LINES_L_V'
64504: WHEN 16 THEN 'AR_DISTRIBUTIONS_L_V'
64505: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'
64506: WHEN 18 THEN 'AR_TRANSACTIONS_S_V'
64507: WHEN 19 THEN 'AR_TRANSACTIONS_S_V'
64508: WHEN 20 THEN 'AR_DISTRIBUTIONS_L_V'

Line 64508: WHEN 20 THEN 'AR_DISTRIBUTIONS_L_V'

64504: WHEN 16 THEN 'AR_DISTRIBUTIONS_L_V'
64505: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'
64506: WHEN 18 THEN 'AR_TRANSACTIONS_S_V'
64507: WHEN 19 THEN 'AR_TRANSACTIONS_S_V'
64508: WHEN 20 THEN 'AR_DISTRIBUTIONS_L_V'
64509: WHEN 21 THEN 'AR_DISTRIBUTIONS_L_V'
64510: WHEN 22 THEN 'AR_DISTRIBUTIONS_BASE_V'
64511: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'
64512: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'

Line 64509: WHEN 21 THEN 'AR_DISTRIBUTIONS_L_V'

64505: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'
64506: WHEN 18 THEN 'AR_TRANSACTIONS_S_V'
64507: WHEN 19 THEN 'AR_TRANSACTIONS_S_V'
64508: WHEN 20 THEN 'AR_DISTRIBUTIONS_L_V'
64509: WHEN 21 THEN 'AR_DISTRIBUTIONS_L_V'
64510: WHEN 22 THEN 'AR_DISTRIBUTIONS_BASE_V'
64511: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'
64512: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'
64513: WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V'

Line 64511: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'

64507: WHEN 19 THEN 'AR_TRANSACTIONS_S_V'
64508: WHEN 20 THEN 'AR_DISTRIBUTIONS_L_V'
64509: WHEN 21 THEN 'AR_DISTRIBUTIONS_L_V'
64510: WHEN 22 THEN 'AR_DISTRIBUTIONS_BASE_V'
64511: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'
64512: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'
64513: WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V'
64514: WHEN 26 THEN 'AR_DISTRIBUTIONS_BASE_V'
64515: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 64512: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'

64508: WHEN 20 THEN 'AR_DISTRIBUTIONS_L_V'
64509: WHEN 21 THEN 'AR_DISTRIBUTIONS_L_V'
64510: WHEN 22 THEN 'AR_DISTRIBUTIONS_BASE_V'
64511: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'
64512: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'
64513: WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V'
64514: WHEN 26 THEN 'AR_DISTRIBUTIONS_BASE_V'
64515: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'
64516: WHEN 28 THEN 'AR_DISTRIBUTIONS_L_V'

Line 64513: WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V'

64509: WHEN 21 THEN 'AR_DISTRIBUTIONS_L_V'
64510: WHEN 22 THEN 'AR_DISTRIBUTIONS_BASE_V'
64511: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'
64512: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'
64513: WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V'
64514: WHEN 26 THEN 'AR_DISTRIBUTIONS_BASE_V'
64515: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'
64516: WHEN 28 THEN 'AR_DISTRIBUTIONS_L_V'
64517:

Line 64516: WHEN 28 THEN 'AR_DISTRIBUTIONS_L_V'

64512: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'
64513: WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V'
64514: WHEN 26 THEN 'AR_DISTRIBUTIONS_BASE_V'
64515: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'
64516: WHEN 28 THEN 'AR_DISTRIBUTIONS_L_V'
64517:
64518: ELSE null
64519: END object_name
64520: , CASE r

Line 64653: , AR_DISTRIBUTIONS_L_V l4

64649: , null source_meaning
64650: FROM xla_events_gt xet
64651: , AR_CUST_TRX_LINES_L_V l2
64652: , AR_DISTRIBUTIONS_BASE_V l3
64653: , AR_DISTRIBUTIONS_L_V l4
64654: , AR_RECEIVABLES_TRX_ACT_S_V l7
64655: , AR_TRANSACTIONS_S_V l10
64656: , (select rownum r from all_objects where rownum <= 28 and owner = p_apps_owner)
64657: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 64821: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

64817: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
64818: TYPE t_array_source_82 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
64819: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
64820:
64821: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
64822: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
64823: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
64824: TYPE t_array_source_16 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
64825: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 64823: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

64819: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
64820:
64821: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
64822: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
64823: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
64824: TYPE t_array_source_16 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
64825: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
64826: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64827: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 64825: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

64821: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
64822: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
64823: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
64824: TYPE t_array_source_16 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
64825: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
64826: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64827: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
64828: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
64829: TYPE t_array_source_21 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 64826: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

64822: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
64823: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
64824: TYPE t_array_source_16 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
64825: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
64826: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64827: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
64828: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
64829: TYPE t_array_source_21 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
64830: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 64827: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

64823: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
64824: TYPE t_array_source_16 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
64825: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
64826: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64827: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
64828: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
64829: TYPE t_array_source_21 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
64830: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
64831: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 64828: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

64824: TYPE t_array_source_16 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
64825: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
64826: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64827: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
64828: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
64829: TYPE t_array_source_21 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
64830: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
64831: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64832: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 64836: TYPE t_array_source_54 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;

64832: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
64833: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
64834: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
64835: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64836: TYPE t_array_source_54 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
64837: TYPE t_array_source_55 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
64838: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
64839: TYPE t_array_source_60 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
64840: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;

Line 64840: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;

64836: TYPE t_array_source_54 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
64837: TYPE t_array_source_55 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
64838: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
64839: TYPE t_array_source_60 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
64840: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
64841: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
64842: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
64843: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
64844: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 64841: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;

64837: TYPE t_array_source_55 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
64838: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
64839: TYPE t_array_source_60 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
64840: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
64841: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
64842: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
64843: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
64844: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
64845: TYPE t_array_source_66 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 64843: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;

64839: TYPE t_array_source_60 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
64840: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
64841: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
64842: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
64843: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
64844: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
64845: TYPE t_array_source_66 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
64846: TYPE t_array_source_67 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64847: TYPE t_array_source_68 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 64844: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

64840: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
64841: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
64842: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
64843: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
64844: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
64845: TYPE t_array_source_66 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
64846: TYPE t_array_source_67 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64847: TYPE t_array_source_68 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
64848: TYPE t_array_source_69 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;

Line 64845: TYPE t_array_source_66 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

64841: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
64842: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
64843: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
64844: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
64845: TYPE t_array_source_66 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
64846: TYPE t_array_source_67 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64847: TYPE t_array_source_68 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
64848: TYPE t_array_source_69 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;
64849:

Line 64848: TYPE t_array_source_69 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;

64844: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
64845: TYPE t_array_source_66 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
64846: TYPE t_array_source_67 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64847: TYPE t_array_source_68 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
64848: TYPE t_array_source_69 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;
64849:
64850: l_array_source_1 t_array_source_1;
64851: l_array_source_3 t_array_source_3;
64852: l_array_source_4 t_array_source_4;

Line 65026: , AR_DISTRIBUTIONS_L_V l4

65022: , l4.DIST_SOURCE_TABLE source_69
65023: FROM xla_events_gt xet
65024: , AR_CUST_TRX_LINES_L_V l2
65025: , AR_DISTRIBUTIONS_BASE_V l3
65026: , AR_DISTRIBUTIONS_L_V l4
65027: , AR_RECEIVABLES_TRX_ACT_S_V l7
65028: , AR_TRANSACTIONS_S_V l10
65029: WHERE xet.event_id between x_first_event_id and x_last_event_id
65030: and xet.event_date between p_pad_start_date and p_pad_end_date