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.

[Home] [Help]

APPS.XLA_00222_AAD_S_000008_PKG dependencies on AR_DISTRIBUTIONS_L_V

Line 52922: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'

52918: FROM (
52919: SELECT xet.event_id event_id
52920: , l5.line_number line_number
52921: , CASE r
52922: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
52923: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
52924: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
52925: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
52926: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

Line 52923: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'

52919: SELECT xet.event_id event_id
52920: , l5.line_number line_number
52921: , CASE r
52922: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
52923: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
52924: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
52925: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
52926: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
52927: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

Line 52924: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'

52920: , l5.line_number line_number
52921: , CASE r
52922: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
52923: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
52924: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
52925: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
52926: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
52927: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
52928: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 52925: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'

52921: , CASE r
52922: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
52923: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
52924: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
52925: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
52926: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
52927: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
52928: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
52929: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 52926: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

52922: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
52923: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
52924: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
52925: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
52926: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
52927: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
52928: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
52929: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
52930: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 52927: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

52923: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
52924: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
52925: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
52926: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
52927: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
52928: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
52929: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
52930: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
52931: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 52995: , AR_DISTRIBUTIONS_L_V l5

52991: END source_value
52992: , null source_meaning
52993: FROM xla_events_gt xet
52994: , AR_DISTRIBUTIONS_BASE_V l4
52995: , AR_DISTRIBUTIONS_L_V l5
52996: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
52997: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
52998: AND xet.event_class_code = C_EVENT_CLASS_CODE
52999: AND l4.event_id = xet.event_id

Line 53144: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

53140: TYPE t_array_source_71 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
53141: TYPE t_array_source_72 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
53142: TYPE t_array_source_73 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
53143:
53144: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
53145: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
53146: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
53147: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
53148: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 53145: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

53141: TYPE t_array_source_72 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
53142: TYPE t_array_source_73 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
53143:
53144: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
53145: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
53146: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
53147: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
53148: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
53149: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 53146: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

53142: TYPE t_array_source_73 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
53143:
53144: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
53145: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
53146: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
53147: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
53148: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
53149: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
53150: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 53147: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

53143:
53144: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
53145: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
53146: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
53147: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
53148: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
53149: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
53150: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
53151: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 53148: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

53144: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
53145: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
53146: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
53147: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
53148: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
53149: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
53150: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
53151: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
53152: TYPE t_array_source_21 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 53149: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

53145: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
53146: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
53147: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
53148: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
53149: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
53150: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
53151: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
53152: TYPE t_array_source_21 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
53153: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 53272: , AR_DISTRIBUTIONS_L_V l5

53268: , l4.DIST_CUR_CONVERSION_TYPE source_21
53269: , l4.DIST_TO_ACCTD_AMT source_22
53270: FROM xla_events_gt xet
53271: , AR_DISTRIBUTIONS_BASE_V l4
53272: , AR_DISTRIBUTIONS_L_V l5
53273: WHERE xet.event_id between x_first_event_id and x_last_event_id
53274: and xet.event_date between p_pad_start_date and p_pad_end_date
53275: and xet.event_class_code = C_EVENT_CLASS_CODE
53276: and xet.event_status_code <> 'N' AND l4.event_id = xet.event_id

Line 55568: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'

55564: SELECT xet.event_id event_id
55565: , l3.line_number line_number
55566: , CASE r
55567: WHEN 1 THEN 'AR_CM_LINES_L_V'
55568: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
55569: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
55570: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
55571: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
55572: WHEN 6 THEN 'AR_CM_LINES_BASE_V'

Line 55569: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'

55565: , l3.line_number line_number
55566: , CASE r
55567: WHEN 1 THEN 'AR_CM_LINES_L_V'
55568: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
55569: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
55570: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
55571: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
55572: WHEN 6 THEN 'AR_CM_LINES_BASE_V'
55573: WHEN 7 THEN 'AR_CM_LINES_BASE_V'

Line 55571: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

55567: WHEN 1 THEN 'AR_CM_LINES_L_V'
55568: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
55569: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
55570: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
55571: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
55572: WHEN 6 THEN 'AR_CM_LINES_BASE_V'
55573: WHEN 7 THEN 'AR_CM_LINES_BASE_V'
55574: WHEN 8 THEN 'AR_CM_LINES_BASE_V'
55575: WHEN 9 THEN 'AR_CM_LINES_BASE_V'

Line 55666: , AR_DISTRIBUTIONS_L_V l6

55662: , null source_meaning
55663: FROM xla_events_gt xet
55664: , AR_CM_LINES_BASE_V l3
55665: , AR_CM_LINES_L_V l4
55666: , AR_DISTRIBUTIONS_L_V l6
55667: , AR_RECEIVABLES_TRX_ACT_S_V l7
55668: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
55669: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
55670: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 55821: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

55817: TYPE t_array_source_44 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
55818: TYPE t_array_source_50 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
55819:
55820: TYPE t_array_source_2 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
55821: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
55822: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55823: TYPE t_array_source_14 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
55824: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
55825: TYPE t_array_source_35 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;

Line 55822: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

55818: TYPE t_array_source_50 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
55819:
55820: TYPE t_array_source_2 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
55821: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
55822: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55823: TYPE t_array_source_14 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
55824: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
55825: TYPE t_array_source_35 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
55826: TYPE t_array_source_36 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 55824: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

55820: TYPE t_array_source_2 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
55821: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
55822: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55823: TYPE t_array_source_14 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
55824: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
55825: TYPE t_array_source_35 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
55826: TYPE t_array_source_36 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
55827: TYPE t_array_source_38 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
55828: TYPE t_array_source_39 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 55962: , AR_DISTRIBUTIONS_L_V l6

55958: , l4.CM_LINE_DIST_AMT source_47
55959: FROM xla_events_gt xet
55960: , AR_CM_LINES_BASE_V l3
55961: , AR_CM_LINES_L_V l4
55962: , AR_DISTRIBUTIONS_L_V l6
55963: , AR_RECEIVABLES_TRX_ACT_S_V l7
55964: WHERE xet.event_id between x_first_event_id and x_last_event_id
55965: and xet.event_date between p_pad_start_date and p_pad_end_date
55966: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 62637: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'

62633: FROM (
62634: SELECT xet.event_id event_id
62635: , l3.line_number line_number
62636: , CASE r
62637: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
62638: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
62639: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
62640: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
62641: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

Line 62638: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'

62634: SELECT xet.event_id event_id
62635: , l3.line_number line_number
62636: , CASE r
62637: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
62638: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
62639: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
62640: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
62641: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
62642: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

Line 62639: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'

62635: , l3.line_number line_number
62636: , CASE r
62637: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
62638: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
62639: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
62640: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
62641: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
62642: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
62643: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 62640: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'

62636: , CASE r
62637: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
62638: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
62639: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
62640: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
62641: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
62642: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
62643: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
62644: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 62641: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

62637: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
62638: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
62639: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
62640: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
62641: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
62642: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
62643: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
62644: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
62645: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 62642: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

62638: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
62639: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
62640: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
62641: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
62642: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
62643: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
62644: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
62645: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
62646: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'

Line 62646: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'

62642: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
62643: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
62644: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
62645: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
62646: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
62647: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
62648:
62649: ELSE null
62650: END object_name

Line 62715: , AR_DISTRIBUTIONS_L_V l3

62711: END source_value
62712: , null source_meaning
62713: FROM xla_events_gt xet
62714: , AR_DISTRIBUTIONS_BASE_V l2
62715: , AR_DISTRIBUTIONS_L_V l3
62716: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
62717: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
62718: AND xet.event_class_code = C_EVENT_CLASS_CODE
62719: AND l2.event_id = xet.event_id

Line 62866: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

62862: TYPE t_array_source_79 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
62863: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
62864: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
62865:
62866: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
62867: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
62868: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
62869: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
62870: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 62867: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

62863: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
62864: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
62865:
62866: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
62867: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
62868: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
62869: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
62870: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
62871: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 62868: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

62864: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
62865:
62866: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
62867: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
62868: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
62869: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
62870: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
62871: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
62872: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 62869: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

62865:
62866: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
62867: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
62868: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
62869: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
62870: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
62871: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
62872: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
62873: TYPE t_array_source_21 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 62870: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

62866: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
62867: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
62868: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
62869: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
62870: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
62871: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
62872: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
62873: TYPE t_array_source_21 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
62874: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 62871: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

62867: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
62868: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
62869: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
62870: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
62871: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
62872: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
62873: TYPE t_array_source_21 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
62874: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
62875: TYPE t_array_source_52 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;

Line 62875: TYPE t_array_source_52 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;

62871: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
62872: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
62873: TYPE t_array_source_21 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
62874: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
62875: TYPE t_array_source_52 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
62876: TYPE t_array_source_53 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
62877:
62878: l_array_source_1 t_array_source_1;
62879: l_array_source_6 t_array_source_6;

Line 62997: , AR_DISTRIBUTIONS_L_V l3

62993: , l3.DIST_MFAR_ADDITIONAL_ENTRY source_52
62994: , l2.DIST_TO_CUR_CONVERSION_DATE source_53
62995: FROM xla_events_gt xet
62996: , AR_DISTRIBUTIONS_BASE_V l2
62997: , AR_DISTRIBUTIONS_L_V l3
62998: WHERE xet.event_id between x_first_event_id and x_last_event_id
62999: and xet.event_date between p_pad_start_date and p_pad_end_date
63000: and xet.event_class_code = C_EVENT_CLASS_CODE
63001: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 64208: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'

64204: FROM (
64205: SELECT xet.event_id event_id
64206: , l4.line_number line_number
64207: , CASE r
64208: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
64209: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
64210: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
64211: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
64212: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

Line 64210: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'

64206: , l4.line_number line_number
64207: , CASE r
64208: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
64209: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
64210: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
64211: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
64212: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
64213: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
64214: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'

Line 64212: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

64208: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
64209: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
64210: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
64211: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
64212: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
64213: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
64214: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
64215: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
64216: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 64213: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

64209: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
64210: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
64211: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
64212: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
64213: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
64214: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
64215: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
64216: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
64217: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 64214: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'

64210: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
64211: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
64212: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
64213: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
64214: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
64215: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
64216: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
64217: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
64218: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 64215: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'

64211: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
64212: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
64213: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
64214: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
64215: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
64216: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
64217: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
64218: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
64219: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 64223: WHEN 16 THEN 'AR_DISTRIBUTIONS_L_V'

64219: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
64220: WHEN 13 THEN 'AR_CUST_TRX_LINES_L_V'
64221: WHEN 14 THEN 'AR_CUST_TRX_LINES_L_V'
64222: WHEN 15 THEN 'AR_CUST_TRX_LINES_L_V'
64223: WHEN 16 THEN 'AR_DISTRIBUTIONS_L_V'
64224: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'
64225: WHEN 18 THEN 'AR_TRANSACTIONS_S_V'
64226: WHEN 19 THEN 'AR_TRANSACTIONS_S_V'
64227: WHEN 20 THEN 'AR_DISTRIBUTIONS_L_V'

Line 64227: WHEN 20 THEN 'AR_DISTRIBUTIONS_L_V'

64223: WHEN 16 THEN 'AR_DISTRIBUTIONS_L_V'
64224: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'
64225: WHEN 18 THEN 'AR_TRANSACTIONS_S_V'
64226: WHEN 19 THEN 'AR_TRANSACTIONS_S_V'
64227: WHEN 20 THEN 'AR_DISTRIBUTIONS_L_V'
64228: WHEN 21 THEN 'AR_DISTRIBUTIONS_L_V'
64229: WHEN 22 THEN 'AR_DISTRIBUTIONS_BASE_V'
64230: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'
64231: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'

Line 64228: WHEN 21 THEN 'AR_DISTRIBUTIONS_L_V'

64224: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'
64225: WHEN 18 THEN 'AR_TRANSACTIONS_S_V'
64226: WHEN 19 THEN 'AR_TRANSACTIONS_S_V'
64227: WHEN 20 THEN 'AR_DISTRIBUTIONS_L_V'
64228: WHEN 21 THEN 'AR_DISTRIBUTIONS_L_V'
64229: WHEN 22 THEN 'AR_DISTRIBUTIONS_BASE_V'
64230: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'
64231: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'
64232: WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V'

Line 64230: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'

64226: WHEN 19 THEN 'AR_TRANSACTIONS_S_V'
64227: WHEN 20 THEN 'AR_DISTRIBUTIONS_L_V'
64228: WHEN 21 THEN 'AR_DISTRIBUTIONS_L_V'
64229: WHEN 22 THEN 'AR_DISTRIBUTIONS_BASE_V'
64230: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'
64231: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'
64232: WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V'
64233: WHEN 26 THEN 'AR_DISTRIBUTIONS_BASE_V'
64234: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 64231: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'

64227: WHEN 20 THEN 'AR_DISTRIBUTIONS_L_V'
64228: WHEN 21 THEN 'AR_DISTRIBUTIONS_L_V'
64229: WHEN 22 THEN 'AR_DISTRIBUTIONS_BASE_V'
64230: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'
64231: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'
64232: WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V'
64233: WHEN 26 THEN 'AR_DISTRIBUTIONS_BASE_V'
64234: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'
64235: WHEN 28 THEN 'AR_DISTRIBUTIONS_L_V'

Line 64232: WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V'

64228: WHEN 21 THEN 'AR_DISTRIBUTIONS_L_V'
64229: WHEN 22 THEN 'AR_DISTRIBUTIONS_BASE_V'
64230: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'
64231: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'
64232: WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V'
64233: WHEN 26 THEN 'AR_DISTRIBUTIONS_BASE_V'
64234: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'
64235: WHEN 28 THEN 'AR_DISTRIBUTIONS_L_V'
64236:

Line 64235: WHEN 28 THEN 'AR_DISTRIBUTIONS_L_V'

64231: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'
64232: WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V'
64233: WHEN 26 THEN 'AR_DISTRIBUTIONS_BASE_V'
64234: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'
64235: WHEN 28 THEN 'AR_DISTRIBUTIONS_L_V'
64236:
64237: ELSE null
64238: END object_name
64239: , CASE r

Line 64372: , AR_DISTRIBUTIONS_L_V l4

64368: , null source_meaning
64369: FROM xla_events_gt xet
64370: , AR_CUST_TRX_LINES_L_V l2
64371: , AR_DISTRIBUTIONS_BASE_V l3
64372: , AR_DISTRIBUTIONS_L_V l4
64373: , AR_RECEIVABLES_TRX_ACT_S_V l7
64374: , AR_TRANSACTIONS_S_V l10
64375: , (select rownum r from all_objects where rownum <= 28 and owner = p_apps_owner)
64376: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 64538: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

64534: TYPE t_array_source_79 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
64535: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
64536: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
64537:
64538: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
64539: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
64540: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
64541: TYPE t_array_source_14 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
64542: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 64540: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

64536: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
64537:
64538: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
64539: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
64540: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
64541: TYPE t_array_source_14 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
64542: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
64543: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64544: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 64542: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

64538: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
64539: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
64540: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
64541: TYPE t_array_source_14 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
64542: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
64543: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64544: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
64545: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
64546: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 64543: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

64539: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
64540: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
64541: TYPE t_array_source_14 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
64542: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
64543: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64544: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
64545: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
64546: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
64547: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 64544: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

64540: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
64541: TYPE t_array_source_14 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
64542: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
64543: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64544: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
64545: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
64546: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
64547: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
64548: TYPE t_array_source_21 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 64545: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

64541: TYPE t_array_source_14 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
64542: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
64543: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64544: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
64545: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
64546: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
64547: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
64548: TYPE t_array_source_21 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64549: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 64553: TYPE t_array_source_52 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;

64549: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
64550: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
64551: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
64552: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64553: TYPE t_array_source_52 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
64554: TYPE t_array_source_53 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
64555: TYPE t_array_source_57 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
64556: TYPE t_array_source_58 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
64557: TYPE t_array_source_59 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;

Line 64557: TYPE t_array_source_59 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;

64553: TYPE t_array_source_52 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
64554: TYPE t_array_source_53 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
64555: TYPE t_array_source_57 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
64556: TYPE t_array_source_58 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
64557: TYPE t_array_source_59 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
64558: TYPE t_array_source_60 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
64559: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
64560: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
64561: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 64558: TYPE t_array_source_60 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;

64554: TYPE t_array_source_53 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
64555: TYPE t_array_source_57 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
64556: TYPE t_array_source_58 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
64557: TYPE t_array_source_59 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
64558: TYPE t_array_source_60 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
64559: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
64560: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
64561: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
64562: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 64560: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;

64556: TYPE t_array_source_58 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
64557: TYPE t_array_source_59 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
64558: TYPE t_array_source_60 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
64559: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
64560: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
64561: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
64562: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
64563: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64564: TYPE t_array_source_66 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 64561: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

64557: TYPE t_array_source_59 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
64558: TYPE t_array_source_60 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
64559: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
64560: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
64561: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
64562: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
64563: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64564: TYPE t_array_source_66 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
64565: TYPE t_array_source_67 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;

Line 64562: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

64558: TYPE t_array_source_60 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
64559: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
64560: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
64561: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
64562: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
64563: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64564: TYPE t_array_source_66 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
64565: TYPE t_array_source_67 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;
64566:

Line 64565: TYPE t_array_source_67 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;

64561: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
64562: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
64563: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64564: TYPE t_array_source_66 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
64565: TYPE t_array_source_67 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;
64566:
64567: l_array_source_1 t_array_source_1;
64568: l_array_source_6 t_array_source_6;
64569: l_array_source_7 t_array_source_7;

Line 64739: , AR_DISTRIBUTIONS_L_V l4

64735: , l4.DIST_SOURCE_TABLE source_67
64736: FROM xla_events_gt xet
64737: , AR_CUST_TRX_LINES_L_V l2
64738: , AR_DISTRIBUTIONS_BASE_V l3
64739: , AR_DISTRIBUTIONS_L_V l4
64740: , AR_RECEIVABLES_TRX_ACT_S_V l7
64741: , AR_TRANSACTIONS_S_V l10
64742: WHERE xet.event_id between x_first_event_id and x_last_event_id
64743: and xet.event_date between p_pad_start_date and p_pad_end_date