74846: FROM (
74847: SELECT xet.event_id event_id
74848: , l3.line_number line_number
74849: , CASE r
74850: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_V'
74851: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_V'
74852: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_V'
74853: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_V'
74854: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'
74847: SELECT xet.event_id event_id
74848: , l3.line_number line_number
74849: , CASE r
74850: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_V'
74851: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_V'
74852: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_V'
74853: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_V'
74854: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'
74855: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'
74848: , l3.line_number line_number
74849: , CASE r
74850: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_V'
74851: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_V'
74852: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_V'
74853: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_V'
74854: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'
74855: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'
74856: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'
74849: , CASE r
74850: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_V'
74851: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_V'
74852: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_V'
74853: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_V'
74854: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'
74855: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'
74856: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'
74857: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'
74850: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_V'
74851: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_V'
74852: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_V'
74853: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_V'
74854: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'
74855: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'
74856: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'
74857: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'
74858: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'
74851: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_V'
74852: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_V'
74853: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_V'
74854: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'
74855: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'
74856: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'
74857: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'
74858: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'
74859: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'
74852: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_V'
74853: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_V'
74854: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'
74855: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'
74856: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'
74857: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'
74858: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'
74859: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'
74860: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'
74853: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_V'
74854: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'
74855: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'
74856: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'
74857: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'
74858: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'
74859: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'
74860: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'
74861: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'
74854: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'
74855: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'
74856: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'
74857: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'
74858: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'
74859: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'
74860: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'
74861: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'
74862: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'
74855: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'
74856: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'
74857: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'
74858: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'
74859: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'
74860: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'
74861: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'
74862: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'
74863: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_V'
74856: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'
74857: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'
74858: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'
74859: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'
74860: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'
74861: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'
74862: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'
74863: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_V'
74864: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_V'
74857: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'
74858: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'
74859: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'
74860: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'
74861: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'
74862: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'
74863: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_V'
74864: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_V'
74865: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_V'
74858: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'
74859: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'
74860: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'
74861: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'
74862: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'
74863: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_V'
74864: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_V'
74865: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_V'
74866: WHEN 17 THEN 'PA_XLA_EVENT_TYPE_REF_V'
74859: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'
74860: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'
74861: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'
74862: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'
74863: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_V'
74864: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_V'
74865: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_V'
74866: WHEN 17 THEN 'PA_XLA_EVENT_TYPE_REF_V'
74867:
74860: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'
74861: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'
74862: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'
74863: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_V'
74864: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_V'
74865: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_V'
74866: WHEN 17 THEN 'PA_XLA_EVENT_TYPE_REF_V'
74867:
74868: ELSE null
74861: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'
74862: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'
74863: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_V'
74864: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_V'
74865: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_V'
74866: WHEN 17 THEN 'PA_XLA_EVENT_TYPE_REF_V'
74867:
74868: ELSE null
74869: END object_name
74958: ELSE null
74959: END source_meaning
74960: FROM xla_events_gt xet
74961: , PA_XLA_EVENT_TYPE_REF_V l1
74962: , PA_XLA_REVENUE_LINES_V l3
74963: , fnd_lookup_values fvl58
74964: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
74965: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74966: AND xet.event_class_code = C_EVENT_CLASS_CODE
75105: TYPE t_array_source_88 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
75106: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
75107: TYPE t_array_source_93 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75108:
75109: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75110: TYPE t_array_source_16 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_GAINS_CCID%TYPE INDEX BY BINARY_INTEGER;
75111: TYPE t_array_source_17 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_LOSSES_CCID%TYPE INDEX BY BINARY_INTEGER;
75112: TYPE t_array_source_18 IS TABLE OF PA_XLA_REVENUE_LINES_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75113: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75106: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
75107: TYPE t_array_source_93 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75108:
75109: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75110: TYPE t_array_source_16 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_GAINS_CCID%TYPE INDEX BY BINARY_INTEGER;
75111: TYPE t_array_source_17 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_LOSSES_CCID%TYPE INDEX BY BINARY_INTEGER;
75112: TYPE t_array_source_18 IS TABLE OF PA_XLA_REVENUE_LINES_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75113: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75114: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
75107: TYPE t_array_source_93 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75108:
75109: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75110: TYPE t_array_source_16 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_GAINS_CCID%TYPE INDEX BY BINARY_INTEGER;
75111: TYPE t_array_source_17 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_LOSSES_CCID%TYPE INDEX BY BINARY_INTEGER;
75112: TYPE t_array_source_18 IS TABLE OF PA_XLA_REVENUE_LINES_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75113: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75114: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
75115: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75108:
75109: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75110: TYPE t_array_source_16 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_GAINS_CCID%TYPE INDEX BY BINARY_INTEGER;
75111: TYPE t_array_source_17 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_LOSSES_CCID%TYPE INDEX BY BINARY_INTEGER;
75112: TYPE t_array_source_18 IS TABLE OF PA_XLA_REVENUE_LINES_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75113: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75114: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
75115: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75116: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75109: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75110: TYPE t_array_source_16 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_GAINS_CCID%TYPE INDEX BY BINARY_INTEGER;
75111: TYPE t_array_source_17 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_LOSSES_CCID%TYPE INDEX BY BINARY_INTEGER;
75112: TYPE t_array_source_18 IS TABLE OF PA_XLA_REVENUE_LINES_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75113: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75114: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
75115: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75116: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75117: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75110: TYPE t_array_source_16 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_GAINS_CCID%TYPE INDEX BY BINARY_INTEGER;
75111: TYPE t_array_source_17 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_LOSSES_CCID%TYPE INDEX BY BINARY_INTEGER;
75112: TYPE t_array_source_18 IS TABLE OF PA_XLA_REVENUE_LINES_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75113: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75114: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
75115: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75116: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75117: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75118: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75111: TYPE t_array_source_17 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_LOSSES_CCID%TYPE INDEX BY BINARY_INTEGER;
75112: TYPE t_array_source_18 IS TABLE OF PA_XLA_REVENUE_LINES_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75113: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75114: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
75115: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75116: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75117: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75118: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75119: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75112: TYPE t_array_source_18 IS TABLE OF PA_XLA_REVENUE_LINES_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75113: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75114: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
75115: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75116: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75117: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75118: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75119: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75120: TYPE t_array_source_37 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
75113: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75114: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
75115: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75116: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75117: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75118: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75119: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75120: TYPE t_array_source_37 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
75121: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75114: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
75115: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75116: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75117: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75118: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75119: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75120: TYPE t_array_source_37 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
75121: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75122: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75115: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75116: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75117: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75118: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75119: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75120: TYPE t_array_source_37 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
75121: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75122: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75123: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75116: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75117: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75118: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75119: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75120: TYPE t_array_source_37 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
75121: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75122: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75123: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75124: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75117: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75118: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75119: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75120: TYPE t_array_source_37 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
75121: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75122: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75123: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75124: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75125: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
75118: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75119: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75120: TYPE t_array_source_37 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
75121: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75122: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75123: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75124: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75125: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
75126:
75119: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75120: TYPE t_array_source_37 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
75121: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75122: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75123: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75124: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75125: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
75126:
75127: l_array_source_38 t_array_source_38;
75120: TYPE t_array_source_37 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
75121: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75122: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75123: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75124: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75125: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
75126:
75127: l_array_source_38 t_array_source_38;
75128: l_array_source_42 t_array_source_42;
75242: , l1.REV_EVENT_TYPE_CLASSIFICATION source_58
75243: , fvl58.meaning source_58_meaning
75244: FROM xla_events_gt xet
75245: , PA_XLA_EVENT_TYPE_REF_V l1
75246: , PA_XLA_REVENUE_LINES_V l3
75247: , fnd_lookup_values fvl58
75248: WHERE xet.event_id between x_first_event_id and x_last_event_id
75249: and xet.event_date between p_pad_start_date and p_pad_end_date
75250: and xet.event_class_code = C_EVENT_CLASS_CODE