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

Line 63191: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'

63187: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
63188: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
63189: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
63190: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
63191: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
63192: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
63193: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
63194: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
63195:

Line 63192: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'

63188: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
63189: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
63190: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
63191: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
63192: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
63193: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
63194: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
63195:
63196: ELSE null

Line 63193: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'

63189: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
63190: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
63191: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
63192: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
63193: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
63194: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
63195:
63196: ELSE null
63197: END object_name

Line 63194: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'

63190: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
63191: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
63192: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
63193: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
63194: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
63195:
63196: ELSE null
63197: END object_name
63198: , CASE r

Line 63257: , AR_DISTRIBUTIONS_BASE_V l4

63253: ELSE null
63254: END source_value
63255: , null source_meaning
63256: FROM xla_events_gt xet
63257: , AR_DISTRIBUTIONS_BASE_V l4
63258: , AR_DISTRIBUTIONS_L_V l5
63259: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
63260: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
63261: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 63412: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

63408: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
63409: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
63410: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
63411: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
63412: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
63413: TYPE t_array_source_34 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
63414: TYPE t_array_source_35 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
63415: TYPE t_array_source_36 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
63416:

Line 63413: TYPE t_array_source_34 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

63409: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
63410: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
63411: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
63412: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
63413: TYPE t_array_source_34 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
63414: TYPE t_array_source_35 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
63415: TYPE t_array_source_36 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
63416:
63417: l_array_source_28 t_array_source_28;

Line 63414: TYPE t_array_source_35 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

63410: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
63411: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
63412: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
63413: TYPE t_array_source_34 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
63414: TYPE t_array_source_35 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
63415: TYPE t_array_source_36 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
63416:
63417: l_array_source_28 t_array_source_28;
63418: l_array_source_37 t_array_source_37;

Line 63415: TYPE t_array_source_36 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

63411: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
63412: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
63413: TYPE t_array_source_34 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
63414: TYPE t_array_source_35 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
63415: TYPE t_array_source_36 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
63416:
63417: l_array_source_28 t_array_source_28;
63418: l_array_source_37 t_array_source_37;
63419: l_array_source_38 t_array_source_38;

Line 63531: , AR_DISTRIBUTIONS_BASE_V l4

63527: , l4.DIST_CUR_CONVERSION_RATE source_34
63528: , l4.DIST_CUR_CONVERSION_TYPE source_35
63529: , l4.DIST_TO_ACCTD_AMT source_36
63530: FROM xla_events_gt xet
63531: , AR_DISTRIBUTIONS_BASE_V l4
63532: , AR_DISTRIBUTIONS_L_V l5
63533: WHERE xet.event_id between x_first_event_id and x_last_event_id
63534: and xet.event_date between p_pad_start_date and p_pad_end_date
63535: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 64630: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'

64626: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
64627: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
64628: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
64629: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
64630: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
64631: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
64632: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
64633: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
64634:

Line 64631: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'

64627: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
64628: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
64629: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
64630: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
64631: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
64632: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
64633: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
64634:
64635: ELSE null

Line 64632: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'

64628: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
64629: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
64630: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
64631: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
64632: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
64633: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
64634:
64635: ELSE null
64636: END object_name

Line 64633: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'

64629: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
64630: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
64631: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
64632: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
64633: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
64634:
64635: ELSE null
64636: END object_name
64637: , CASE r

Line 64696: , AR_DISTRIBUTIONS_BASE_V l1

64692: ELSE null
64693: END source_value
64694: , null source_meaning
64695: FROM xla_events_gt xet
64696: , AR_DISTRIBUTIONS_BASE_V l1
64697: , AR_DISTRIBUTIONS_L_V l2
64698: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
64699: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64700: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 64849: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

64845: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
64846: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64847: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
64848: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
64849: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
64850: TYPE t_array_source_34 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
64851: TYPE t_array_source_35 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64852: TYPE t_array_source_40 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
64853:

Line 64850: TYPE t_array_source_34 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

64846: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64847: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
64848: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
64849: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
64850: TYPE t_array_source_34 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
64851: TYPE t_array_source_35 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64852: TYPE t_array_source_40 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
64853:
64854: l_array_source_24 t_array_source_24;

Line 64851: TYPE t_array_source_35 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

64847: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
64848: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
64849: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
64850: TYPE t_array_source_34 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
64851: TYPE t_array_source_35 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64852: TYPE t_array_source_40 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
64853:
64854: l_array_source_24 t_array_source_24;
64855: l_array_source_25 t_array_source_25;

Line 64852: TYPE t_array_source_40 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

64848: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
64849: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
64850: TYPE t_array_source_34 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
64851: TYPE t_array_source_35 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64852: TYPE t_array_source_40 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
64853:
64854: l_array_source_24 t_array_source_24;
64855: l_array_source_25 t_array_source_25;
64856: l_array_source_39 t_array_source_39;

Line 64962: , AR_DISTRIBUTIONS_BASE_V l1

64958: , l1.DIST_CUR_CONVERSION_RATE source_34
64959: , l1.DIST_CUR_CONVERSION_TYPE source_35
64960: , l1.DIST_ACCTD_AMT source_40
64961: FROM xla_events_gt xet
64962: , AR_DISTRIBUTIONS_BASE_V l1
64963: , AR_DISTRIBUTIONS_L_V l2
64964: WHERE xet.event_id between x_first_event_id and x_last_event_id
64965: and xet.event_date between p_pad_start_date and p_pad_end_date
64966: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 77926: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'

77922: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
77923: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
77924: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
77925: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
77926: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
77927: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
77928: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
77929: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
77930: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 77927: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'

77923: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
77924: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
77925: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
77926: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
77927: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
77928: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
77929: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
77930: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
77931:

Line 77928: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'

77924: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
77925: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
77926: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
77927: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
77928: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
77929: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
77930: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
77931:
77932: ELSE null

Line 77930: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'

77926: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
77927: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
77928: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
77929: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
77930: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
77931:
77932: ELSE null
77933: END object_name
77934: , CASE r

Line 77997: , AR_DISTRIBUTIONS_BASE_V l2

77993: ELSE null
77994: END source_value
77995: , null source_meaning
77996: FROM xla_events_gt xet
77997: , AR_DISTRIBUTIONS_BASE_V l2
77998: , AR_DISTRIBUTIONS_L_V l3
77999: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
78000: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
78001: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 78156: TYPE t_array_source_34 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

78152: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
78153: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
78154: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
78155: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
78156: TYPE t_array_source_34 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
78157: TYPE t_array_source_35 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
78158: TYPE t_array_source_36 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
78159: TYPE t_array_source_88 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
78160: TYPE t_array_source_89 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 78157: TYPE t_array_source_35 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

78153: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
78154: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
78155: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
78156: TYPE t_array_source_34 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
78157: TYPE t_array_source_35 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
78158: TYPE t_array_source_36 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
78159: TYPE t_array_source_88 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
78160: TYPE t_array_source_89 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
78161:

Line 78158: TYPE t_array_source_36 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

78154: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
78155: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
78156: TYPE t_array_source_34 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
78157: TYPE t_array_source_35 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
78158: TYPE t_array_source_36 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
78159: TYPE t_array_source_88 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
78160: TYPE t_array_source_89 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
78161:
78162: l_array_source_8 t_array_source_8;

Line 78160: TYPE t_array_source_89 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

78156: TYPE t_array_source_34 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
78157: TYPE t_array_source_35 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
78158: TYPE t_array_source_36 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
78159: TYPE t_array_source_88 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
78160: TYPE t_array_source_89 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
78161:
78162: l_array_source_8 t_array_source_8;
78163: l_array_source_9 t_array_source_9;
78164: l_array_source_10 t_array_source_10;

Line 78284: , AR_DISTRIBUTIONS_BASE_V l2

78280: , l2.DIST_TO_ACCTD_AMT source_36
78281: , l3.DIST_MFAR_ADDITIONAL_ENTRY source_88
78282: , l2.DIST_TO_CUR_CONVERSION_DATE source_89
78283: FROM xla_events_gt xet
78284: , AR_DISTRIBUTIONS_BASE_V l2
78285: , AR_DISTRIBUTIONS_L_V l3
78286: WHERE xet.event_id between x_first_event_id and x_last_event_id
78287: and xet.event_date between p_pad_start_date and p_pad_end_date
78288: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 79465: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'

79461: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
79462: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
79463: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
79464: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
79465: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
79466: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
79467: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
79468: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'
79469: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 79466: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'

79462: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
79463: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
79464: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
79465: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
79466: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
79467: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
79468: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'
79469: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'
79470: WHEN 16 THEN 'AR_CUST_TRX_LINES_L_V'

Line 79467: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'

79463: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
79464: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
79465: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
79466: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
79467: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
79468: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'
79469: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'
79470: WHEN 16 THEN 'AR_CUST_TRX_LINES_L_V'
79471: WHEN 17 THEN 'AR_CUST_TRX_LINES_L_V'

Line 79468: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'

79464: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
79465: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
79466: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
79467: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
79468: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'
79469: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'
79470: WHEN 16 THEN 'AR_CUST_TRX_LINES_L_V'
79471: WHEN 17 THEN 'AR_CUST_TRX_LINES_L_V'
79472: WHEN 18 THEN 'AR_DISTRIBUTIONS_L_V'

Line 79469: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'

79465: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
79466: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
79467: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
79468: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'
79469: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'
79470: WHEN 16 THEN 'AR_CUST_TRX_LINES_L_V'
79471: WHEN 17 THEN 'AR_CUST_TRX_LINES_L_V'
79472: WHEN 18 THEN 'AR_DISTRIBUTIONS_L_V'
79473: WHEN 19 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 79473: WHEN 19 THEN 'AR_DISTRIBUTIONS_BASE_V'

79469: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'
79470: WHEN 16 THEN 'AR_CUST_TRX_LINES_L_V'
79471: WHEN 17 THEN 'AR_CUST_TRX_LINES_L_V'
79472: WHEN 18 THEN 'AR_DISTRIBUTIONS_L_V'
79473: WHEN 19 THEN 'AR_DISTRIBUTIONS_BASE_V'
79474: WHEN 20 THEN 'AR_TRANSACTIONS_S_V'
79475: WHEN 21 THEN 'AR_TRANSACTIONS_S_V'
79476: WHEN 22 THEN 'AR_DISTRIBUTIONS_L_V'
79477: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'

Line 79481: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'

79477: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'
79478: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'
79479: WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V'
79480: WHEN 26 THEN 'AR_DISTRIBUTIONS_L_V'
79481: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'
79482: WHEN 28 THEN 'AR_DISTRIBUTIONS_BASE_V'
79483: WHEN 29 THEN 'AR_DISTRIBUTIONS_L_V'
79484: WHEN 30 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
79485:

Line 79482: WHEN 28 THEN 'AR_DISTRIBUTIONS_BASE_V'

79478: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'
79479: WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V'
79480: WHEN 26 THEN 'AR_DISTRIBUTIONS_L_V'
79481: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'
79482: WHEN 28 THEN 'AR_DISTRIBUTIONS_BASE_V'
79483: WHEN 29 THEN 'AR_DISTRIBUTIONS_L_V'
79484: WHEN 30 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
79485:
79486: ELSE null

Line 79628: , AR_DISTRIBUTIONS_BASE_V l3

79624: END source_value
79625: , null source_meaning
79626: FROM xla_events_gt xet
79627: , AR_CUST_TRX_LINES_L_V l2
79628: , AR_DISTRIBUTIONS_BASE_V l3
79629: , AR_DISTRIBUTIONS_L_V l4
79630: , AR_RECEIVABLES_TRX_ACT_S_V l7
79631: , AR_TRANSACTIONS_S_V l10
79632: , (select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)

Line 79805: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

79801: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
79802: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79803: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
79804: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
79805: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79806: TYPE t_array_source_34 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79807: TYPE t_array_source_35 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79808: TYPE t_array_source_36 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79809: TYPE t_array_source_40 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 79806: TYPE t_array_source_34 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

79802: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79803: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
79804: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
79805: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79806: TYPE t_array_source_34 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79807: TYPE t_array_source_35 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79808: TYPE t_array_source_36 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79809: TYPE t_array_source_40 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79810: TYPE t_array_source_44 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 79807: TYPE t_array_source_35 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

79803: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
79804: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
79805: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79806: TYPE t_array_source_34 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79807: TYPE t_array_source_35 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79808: TYPE t_array_source_36 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79809: TYPE t_array_source_40 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79810: TYPE t_array_source_44 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
79811: TYPE t_array_source_45 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 79808: TYPE t_array_source_36 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

79804: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
79805: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79806: TYPE t_array_source_34 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79807: TYPE t_array_source_35 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79808: TYPE t_array_source_36 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79809: TYPE t_array_source_40 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79810: TYPE t_array_source_44 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
79811: TYPE t_array_source_45 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79812: TYPE t_array_source_88 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;

Line 79809: TYPE t_array_source_40 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

79805: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79806: TYPE t_array_source_34 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79807: TYPE t_array_source_35 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79808: TYPE t_array_source_36 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79809: TYPE t_array_source_40 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79810: TYPE t_array_source_44 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
79811: TYPE t_array_source_45 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79812: TYPE t_array_source_88 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
79813: TYPE t_array_source_89 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 79813: TYPE t_array_source_89 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

79809: TYPE t_array_source_40 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79810: TYPE t_array_source_44 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
79811: TYPE t_array_source_45 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79812: TYPE t_array_source_88 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
79813: TYPE t_array_source_89 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79814: TYPE t_array_source_93 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
79815: TYPE t_array_source_94 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
79816: TYPE t_array_source_95 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
79817: TYPE t_array_source_96 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;

Line 79821: TYPE t_array_source_100 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

79817: TYPE t_array_source_96 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
79818: TYPE t_array_source_97 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
79819: TYPE t_array_source_98 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
79820: TYPE t_array_source_99 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
79821: TYPE t_array_source_100 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79822: TYPE t_array_source_101 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79823: TYPE t_array_source_102 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;
79824: TYPE t_array_source_103 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_NAME%TYPE INDEX BY BINARY_INTEGER;
79825:

Line 79822: TYPE t_array_source_101 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

79818: TYPE t_array_source_97 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
79819: TYPE t_array_source_98 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
79820: TYPE t_array_source_99 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
79821: TYPE t_array_source_100 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79822: TYPE t_array_source_101 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79823: TYPE t_array_source_102 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;
79824: TYPE t_array_source_103 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_NAME%TYPE INDEX BY BINARY_INTEGER;
79825:
79826: l_array_source_8 t_array_source_8;

Line 80001: , AR_DISTRIBUTIONS_BASE_V l3

79997: , l4.DIST_SOURCE_TABLE source_102
79998: , l7.REC_ACT_NAME source_103
79999: FROM xla_events_gt xet
80000: , AR_CUST_TRX_LINES_L_V l2
80001: , AR_DISTRIBUTIONS_BASE_V l3
80002: , AR_DISTRIBUTIONS_L_V l4
80003: , AR_RECEIVABLES_TRX_ACT_S_V l7
80004: , AR_TRANSACTIONS_S_V l10
80005: WHERE xet.event_id between x_first_event_id and x_last_event_id