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_L_V

Line 63185: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'

63181: FROM (
63182: SELECT xet.event_id event_id
63183: , l5.line_number line_number
63184: , CASE r
63185: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
63186: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_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'

Line 63186: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'

63182: SELECT xet.event_id event_id
63183: , l5.line_number line_number
63184: , CASE r
63185: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
63186: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_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'

Line 63187: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'

63183: , l5.line_number line_number
63184: , CASE r
63185: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
63186: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_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'

Line 63188: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'

63184: , CASE r
63185: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
63186: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_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'

Line 63189: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

63185: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
63186: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_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'

Line 63190: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

63186: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_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'

Line 63258: , AR_DISTRIBUTIONS_L_V l5

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
63262: AND l4.event_id = xet.event_id

Line 63406: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

63402: TYPE t_array_source_107 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
63403: TYPE t_array_source_108 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
63404: TYPE t_array_source_109 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
63405:
63406: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
63407: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 63407: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

63403: TYPE t_array_source_108 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
63404: TYPE t_array_source_109 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
63405:
63406: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
63407: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 63408: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

63404: TYPE t_array_source_109 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
63405:
63406: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
63407: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 63409: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

63405:
63406: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
63407: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 63410: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

63406: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
63407: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 63411: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

63407: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 63532: , AR_DISTRIBUTIONS_L_V l5

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

Line 64624: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'

64620: FROM (
64621: SELECT xet.event_id event_id
64622: , l2.line_number line_number
64623: , CASE r
64624: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
64625: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_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'

Line 64625: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'

64621: SELECT xet.event_id event_id
64622: , l2.line_number line_number
64623: , CASE r
64624: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
64625: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_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'

Line 64626: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'

64622: , l2.line_number line_number
64623: , CASE r
64624: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
64625: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_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'

Line 64627: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'

64623: , CASE r
64624: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
64625: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_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'

Line 64628: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

64624: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
64625: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_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'

Line 64629: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

64625: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_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'

Line 64697: , AR_DISTRIBUTIONS_L_V l2

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
64701: AND l1.event_id = xet.event_id

Line 64843: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

64839: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
64840: TYPE t_array_source_41 IS TABLE OF AR_DRAWEE_CUSTOMERS_H_V.DRAW_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
64841: TYPE t_array_source_42 IS TABLE OF AR_DRAWEE_SITE_USES_H_V.DRAW_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
64842:
64843: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
64844: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 64844: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

64840: TYPE t_array_source_41 IS TABLE OF AR_DRAWEE_CUSTOMERS_H_V.DRAW_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
64841: TYPE t_array_source_42 IS TABLE OF AR_DRAWEE_SITE_USES_H_V.DRAW_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
64842:
64843: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
64844: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 64845: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

64841: TYPE t_array_source_42 IS TABLE OF AR_DRAWEE_SITE_USES_H_V.DRAW_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
64842:
64843: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
64844: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 64846: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

64842:
64843: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
64844: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 64847: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

64843: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
64844: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 64848: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

64844: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 64963: , AR_DISTRIBUTIONS_L_V l2

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

Line 68921: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

68917: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
68918: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
68919: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
68920: WHEN 4 THEN 'AR_CM_LINES_L_V'
68921: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
68922: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
68923: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
68924: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
68925: WHEN 9 THEN 'AR_CM_LINES_BASE_V'

Line 68922: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

68918: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
68919: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
68920: WHEN 4 THEN 'AR_CM_LINES_L_V'
68921: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
68922: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
68923: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
68924: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
68925: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
68926: WHEN 10 THEN 'AR_CM_LINES_BASE_V'

Line 68924: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'

68920: WHEN 4 THEN 'AR_CM_LINES_L_V'
68921: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
68922: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
68923: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
68924: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
68925: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
68926: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
68927: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
68928: WHEN 12 THEN 'AR_CM_LINES_BASE_V'

Line 69037: , AR_DISTRIBUTIONS_L_V l7

69033: FROM xla_events_gt xet
69034: , AR_CM_LINES_BASE_V l3
69035: , AR_CM_LINES_L_V l4
69036: , AR_CUST_TRX_LINES_L_V l6
69037: , AR_DISTRIBUTIONS_L_V l7
69038: , AR_RECEIVABLES_TRX_ACT_S_V l8
69039: , AR_TRANSACTIONS_S_V l10
69040: , (select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
69041: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 69198: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

69194: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
69195: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
69196: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69197: TYPE t_array_source_14 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
69198: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
69199: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
69200: TYPE t_array_source_28 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
69201: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
69202: TYPE t_array_source_52 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;

Line 69199: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

69195: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
69196: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69197: TYPE t_array_source_14 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
69198: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
69199: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
69200: TYPE t_array_source_28 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
69201: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
69202: TYPE t_array_source_52 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
69203: TYPE t_array_source_53 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 69201: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

69197: TYPE t_array_source_14 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
69198: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
69199: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
69200: TYPE t_array_source_28 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
69201: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
69202: TYPE t_array_source_52 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
69203: TYPE t_array_source_53 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
69204: TYPE t_array_source_55 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
69205: TYPE t_array_source_56 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 69345: , AR_DISTRIBUTIONS_L_V l7

69341: FROM xla_events_gt xet
69342: , AR_CM_LINES_BASE_V l3
69343: , AR_CM_LINES_L_V l4
69344: , AR_CUST_TRX_LINES_L_V l6
69345: , AR_DISTRIBUTIONS_L_V l7
69346: , AR_RECEIVABLES_TRX_ACT_S_V l8
69347: , AR_TRANSACTIONS_S_V l10
69348: WHERE xet.event_id between x_first_event_id and x_last_event_id
69349: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 77920: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'

77916: FROM (
77917: SELECT xet.event_id event_id
77918: , l3.line_number line_number
77919: , CASE r
77920: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
77921: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_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'

Line 77921: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'

77917: SELECT xet.event_id event_id
77918: , l3.line_number line_number
77919: , CASE r
77920: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
77921: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_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'

Line 77922: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'

77918: , l3.line_number line_number
77919: , CASE r
77920: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
77921: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_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'

Line 77923: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'

77919: , CASE r
77920: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
77921: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_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'

Line 77924: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

77920: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
77921: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_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'

Line 77925: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

77921: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_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'

Line 77929: WHEN 10 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
77933: END object_name

Line 77998: , AR_DISTRIBUTIONS_L_V l3

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

Line 78150: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

78146: TYPE t_array_source_117 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
78147: TYPE t_array_source_118 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
78148: TYPE t_array_source_119 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
78149:
78150: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
78151: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 78151: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

78147: TYPE t_array_source_118 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
78148: TYPE t_array_source_119 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
78149:
78150: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
78151: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 78152: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

78148: TYPE t_array_source_119 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
78149:
78150: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
78151: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 78153: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

78149:
78150: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
78151: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 78154: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

78150: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
78151: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 78155: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

78151: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 78159: TYPE t_array_source_88 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%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;
78163: l_array_source_9 t_array_source_9;

Line 78285: , AR_DISTRIBUTIONS_L_V l3

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

Line 79458: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'

79454: , CASE r
79455: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
79456: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
79457: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
79458: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
79459: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
79460: WHEN 6 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
79461: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
79462: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'

Line 79459: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

79455: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
79456: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
79457: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
79458: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
79459: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
79460: WHEN 6 THEN 'AR_RECEIVABLES_TRX_ACT_S_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'

Line 79461: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'

79457: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
79458: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
79459: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
79460: WHEN 6 THEN 'AR_RECEIVABLES_TRX_ACT_S_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'

Line 79462: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'

79458: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
79459: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
79460: WHEN 6 THEN 'AR_RECEIVABLES_TRX_ACT_S_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'

Line 79463: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'

79459: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
79460: WHEN 6 THEN 'AR_RECEIVABLES_TRX_ACT_S_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'

Line 79464: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'

79460: WHEN 6 THEN 'AR_RECEIVABLES_TRX_ACT_S_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'

Line 79472: WHEN 18 THEN 'AR_DISTRIBUTIONS_L_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'
79474: WHEN 20 THEN 'AR_TRANSACTIONS_S_V'
79475: WHEN 21 THEN 'AR_TRANSACTIONS_S_V'
79476: WHEN 22 THEN 'AR_DISTRIBUTIONS_L_V'

Line 79476: WHEN 22 THEN 'AR_DISTRIBUTIONS_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'
79478: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'
79479: WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V'
79480: WHEN 26 THEN 'AR_DISTRIBUTIONS_L_V'

Line 79477: WHEN 23 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'
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'

Line 79478: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_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'
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'

Line 79479: WHEN 25 THEN 'AR_DISTRIBUTIONS_L_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'
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'

Line 79480: WHEN 26 THEN 'AR_DISTRIBUTIONS_L_V'

79476: WHEN 22 THEN 'AR_DISTRIBUTIONS_L_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'

Line 79483: WHEN 29 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
79487: END object_name

Line 79629: , AR_DISTRIBUTIONS_L_V l4

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

Line 79798: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

79794:
79795: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
79796: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
79797: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79798: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79799: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79800: TYPE t_array_source_28 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%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;

Line 79799: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

79795: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
79796: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
79797: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79798: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79799: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79800: TYPE t_array_source_28 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%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;

Line 79801: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

79797: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79798: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79799: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79800: TYPE t_array_source_28 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%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;

Line 79802: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

79798: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79799: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79800: TYPE t_array_source_28 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%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;

Line 79803: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

79799: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79800: TYPE t_array_source_28 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%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;

Line 79804: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

79800: TYPE t_array_source_28 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%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;

Line 79812: TYPE t_array_source_88 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%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;
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;

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

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

Line 79818: TYPE t_array_source_97 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%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;
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;

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

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

Line 79823: TYPE t_array_source_102 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%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;
79827: l_array_source_9 t_array_source_9;

Line 80002: , AR_DISTRIBUTIONS_L_V l4

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