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

Line 74742: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_V'

74738: FROM (
74739: SELECT xet.event_id event_id
74740: , l3.line_number line_number
74741: , CASE r
74742: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_V'
74743: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_V'
74744: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_V'
74745: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_V'
74746: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'

Line 74743: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_V'

74739: SELECT xet.event_id event_id
74740: , l3.line_number line_number
74741: , CASE r
74742: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_V'
74743: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_V'
74744: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_V'
74745: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_V'
74746: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'
74747: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'

Line 74744: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_V'

74740: , l3.line_number line_number
74741: , CASE r
74742: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_V'
74743: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_V'
74744: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_V'
74745: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_V'
74746: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'
74747: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'
74748: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'

Line 74745: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_V'

74741: , CASE r
74742: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_V'
74743: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_V'
74744: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_V'
74745: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_V'
74746: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'
74747: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'
74748: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'
74749: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'

Line 74746: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'

74742: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_V'
74743: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_V'
74744: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_V'
74745: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_V'
74746: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'
74747: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'
74748: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'
74749: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'
74750: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'

Line 74747: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'

74743: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_V'
74744: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_V'
74745: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_V'
74746: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'
74747: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'
74748: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'
74749: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'
74750: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'
74751: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'

Line 74748: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'

74744: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_V'
74745: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_V'
74746: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'
74747: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'
74748: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'
74749: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'
74750: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'
74751: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'
74752: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'

Line 74749: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'

74745: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_V'
74746: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'
74747: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'
74748: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'
74749: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'
74750: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'
74751: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'
74752: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'
74753: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'

Line 74750: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'

74746: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'
74747: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'
74748: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'
74749: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'
74750: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'
74751: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'
74752: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'
74753: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'
74754: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'

Line 74751: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'

74747: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'
74748: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'
74749: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'
74750: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'
74751: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'
74752: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'
74753: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'
74754: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'
74755: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_V'

Line 74752: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'

74748: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'
74749: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'
74750: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'
74751: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'
74752: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'
74753: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'
74754: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'
74755: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_V'
74756: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_V'

Line 74753: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'

74749: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'
74750: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'
74751: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'
74752: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'
74753: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'
74754: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'
74755: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_V'
74756: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_V'
74757: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_V'

Line 74754: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'

74750: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'
74751: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'
74752: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'
74753: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'
74754: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'
74755: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_V'
74756: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_V'
74757: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_V'
74758: WHEN 17 THEN 'PA_XLA_EVENT_TYPE_REF_V'

Line 74755: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_V'

74751: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'
74752: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'
74753: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'
74754: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'
74755: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_V'
74756: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_V'
74757: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_V'
74758: WHEN 17 THEN 'PA_XLA_EVENT_TYPE_REF_V'
74759:

Line 74756: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_V'

74752: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'
74753: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'
74754: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'
74755: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_V'
74756: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_V'
74757: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_V'
74758: WHEN 17 THEN 'PA_XLA_EVENT_TYPE_REF_V'
74759:
74760: ELSE null

Line 74757: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_V'

74753: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'
74754: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'
74755: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_V'
74756: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_V'
74757: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_V'
74758: WHEN 17 THEN 'PA_XLA_EVENT_TYPE_REF_V'
74759:
74760: ELSE null
74761: END object_name

Line 74854: , PA_XLA_REVENUE_LINES_V l3

74850: ELSE null
74851: END source_meaning
74852: FROM xla_events_gt xet
74853: , PA_XLA_EVENT_TYPE_REF_V l1
74854: , PA_XLA_REVENUE_LINES_V l3
74855: , fnd_lookup_values fvl58
74856: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
74857: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74858: AND xet.event_class_code = C_EVENT_CLASS_CODE

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

74997: TYPE t_array_source_87 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
74998: TYPE t_array_source_91 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
74999: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75000:
75001: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75002: TYPE t_array_source_16 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_GAINS_CCID%TYPE INDEX BY BINARY_INTEGER;
75003: TYPE t_array_source_17 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_LOSSES_CCID%TYPE INDEX BY BINARY_INTEGER;
75004: TYPE t_array_source_18 IS TABLE OF PA_XLA_REVENUE_LINES_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75005: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 75002: TYPE t_array_source_16 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_GAINS_CCID%TYPE INDEX BY BINARY_INTEGER;

74998: TYPE t_array_source_91 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
74999: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75000:
75001: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75002: TYPE t_array_source_16 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_GAINS_CCID%TYPE INDEX BY BINARY_INTEGER;
75003: TYPE t_array_source_17 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_LOSSES_CCID%TYPE INDEX BY BINARY_INTEGER;
75004: TYPE t_array_source_18 IS TABLE OF PA_XLA_REVENUE_LINES_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75005: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75006: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 75003: TYPE t_array_source_17 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_LOSSES_CCID%TYPE INDEX BY BINARY_INTEGER;

74999: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75000:
75001: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75002: TYPE t_array_source_16 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_GAINS_CCID%TYPE INDEX BY BINARY_INTEGER;
75003: TYPE t_array_source_17 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_LOSSES_CCID%TYPE INDEX BY BINARY_INTEGER;
75004: TYPE t_array_source_18 IS TABLE OF PA_XLA_REVENUE_LINES_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75005: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75006: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
75007: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 75004: TYPE t_array_source_18 IS TABLE OF PA_XLA_REVENUE_LINES_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

75000:
75001: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75002: TYPE t_array_source_16 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_GAINS_CCID%TYPE INDEX BY BINARY_INTEGER;
75003: TYPE t_array_source_17 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_LOSSES_CCID%TYPE INDEX BY BINARY_INTEGER;
75004: TYPE t_array_source_18 IS TABLE OF PA_XLA_REVENUE_LINES_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75005: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75006: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
75007: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75008: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 75005: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;

75001: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75002: TYPE t_array_source_16 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_GAINS_CCID%TYPE INDEX BY BINARY_INTEGER;
75003: TYPE t_array_source_17 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_LOSSES_CCID%TYPE INDEX BY BINARY_INTEGER;
75004: TYPE t_array_source_18 IS TABLE OF PA_XLA_REVENUE_LINES_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75005: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75006: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
75007: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75008: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75009: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 75006: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;

75002: TYPE t_array_source_16 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_GAINS_CCID%TYPE INDEX BY BINARY_INTEGER;
75003: TYPE t_array_source_17 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_LOSSES_CCID%TYPE INDEX BY BINARY_INTEGER;
75004: TYPE t_array_source_18 IS TABLE OF PA_XLA_REVENUE_LINES_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75005: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75006: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
75007: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75008: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75009: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75010: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 75007: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

75003: TYPE t_array_source_17 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_LOSSES_CCID%TYPE INDEX BY BINARY_INTEGER;
75004: TYPE t_array_source_18 IS TABLE OF PA_XLA_REVENUE_LINES_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75005: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75006: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
75007: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75008: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75009: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75010: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75011: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 75008: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

75004: TYPE t_array_source_18 IS TABLE OF PA_XLA_REVENUE_LINES_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75005: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75006: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
75007: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75008: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75009: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75010: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75011: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75012: TYPE t_array_source_37 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;

Line 75009: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

75005: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75006: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
75007: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75008: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75009: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75010: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75011: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75012: TYPE t_array_source_37 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
75013: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 75010: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

75006: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
75007: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75008: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75009: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75010: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75011: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75012: TYPE t_array_source_37 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
75013: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75014: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 75011: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

75007: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75008: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75009: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75010: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75011: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75012: TYPE t_array_source_37 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
75013: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75014: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75015: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 75012: TYPE t_array_source_37 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;

75008: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75009: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75010: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75011: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75012: TYPE t_array_source_37 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
75013: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75014: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75015: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75016: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 75013: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

75009: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75010: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75011: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75012: TYPE t_array_source_37 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
75013: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75014: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75015: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75016: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75017: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;

Line 75014: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

75010: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75011: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75012: TYPE t_array_source_37 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
75013: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75014: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75015: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75016: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75017: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
75018:

Line 75015: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

75011: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75012: TYPE t_array_source_37 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
75013: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75014: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75015: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75016: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75017: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
75018:
75019: l_array_source_38 t_array_source_38;

Line 75016: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

75012: TYPE t_array_source_37 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
75013: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75014: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75015: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75016: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75017: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
75018:
75019: l_array_source_38 t_array_source_38;
75020: l_array_source_42 t_array_source_42;

Line 75138: , PA_XLA_REVENUE_LINES_V l3

75134: , l1.REV_EVENT_TYPE_CLASSIFICATION source_58
75135: , fvl58.meaning source_58_meaning
75136: FROM xla_events_gt xet
75137: , PA_XLA_EVENT_TYPE_REF_V l1
75138: , PA_XLA_REVENUE_LINES_V l3
75139: , fnd_lookup_values fvl58
75140: WHERE xet.event_id between x_first_event_id and x_last_event_id
75141: and xet.event_date between p_pad_start_date and p_pad_end_date
75142: and xet.event_class_code = C_EVENT_CLASS_CODE