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_00275_AAD_S_000016_PKG dependencies on PA_XLA_REVENUE_LINES_V

Line 74850: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_V'

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'

Line 74851: WHEN 2 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'

Line 74852: WHEN 3 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'

Line 74853: WHEN 4 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'

Line 74854: WHEN 5 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'

Line 74855: WHEN 6 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'

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

Line 74857: WHEN 8 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'

Line 74858: WHEN 9 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'

Line 74859: WHEN 10 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'

Line 74860: WHEN 11 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'

Line 74861: WHEN 12 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'

Line 74862: WHEN 13 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'

Line 74863: WHEN 14 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'
74867:

Line 74864: WHEN 15 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:
74868: ELSE null

Line 74865: WHEN 16 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
74869: END object_name

Line 74962: , PA_XLA_REVENUE_LINES_V l3

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

Line 75109: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

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;

Line 75110: TYPE t_array_source_16 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_GAINS_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;

Line 75111: TYPE t_array_source_17 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_LOSSES_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;

Line 75112: TYPE t_array_source_18 IS TABLE OF PA_XLA_REVENUE_LINES_V.PRDL_CODE_COMBINATION_ID%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;

Line 75113: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%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;

Line 75114: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%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;

Line 75115: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%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;

Line 75116: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%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;

Line 75117: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%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;

Line 75118: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%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;

Line 75119: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%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;

Line 75120: TYPE t_array_source_37 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%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;

Line 75121: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_FIRST_DIST_ID%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;

Line 75122: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_SECOND_DIST_ID%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:

Line 75123: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_AMOUNT%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:
75127: l_array_source_38 t_array_source_38;

Line 75124: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_V.ACCT_AMOUNT%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;
75128: l_array_source_42 t_array_source_42;

Line 75246: , PA_XLA_REVENUE_LINES_V l3

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