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

Line 94048: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_V'

94044: FROM (
94045: SELECT xet.event_id event_id
94046: , l3.line_number line_number
94047: , CASE r
94048: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_V'
94049: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_V'
94050: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_V'
94051: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_V'
94052: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'

Line 94049: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_V'

94045: SELECT xet.event_id event_id
94046: , l3.line_number line_number
94047: , CASE r
94048: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_V'
94049: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_V'
94050: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_V'
94051: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_V'
94052: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'
94053: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'

Line 94050: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_V'

94046: , l3.line_number line_number
94047: , CASE r
94048: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_V'
94049: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_V'
94050: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_V'
94051: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_V'
94052: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'
94053: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'
94054: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'

Line 94051: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_V'

94047: , CASE r
94048: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_V'
94049: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_V'
94050: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_V'
94051: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_V'
94052: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'
94053: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'
94054: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'
94055: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'

Line 94052: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'

94048: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_V'
94049: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_V'
94050: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_V'
94051: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_V'
94052: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'
94053: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'
94054: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'
94055: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'
94056: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'

Line 94053: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'

94049: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_V'
94050: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_V'
94051: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_V'
94052: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'
94053: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'
94054: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'
94055: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'
94056: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'
94057: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'

Line 94054: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'

94050: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_V'
94051: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_V'
94052: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'
94053: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'
94054: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'
94055: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'
94056: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'
94057: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'
94058: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'

Line 94055: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'

94051: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_V'
94052: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'
94053: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'
94054: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'
94055: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'
94056: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'
94057: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'
94058: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'
94059: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'

Line 94056: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'

94052: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_V'
94053: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'
94054: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'
94055: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'
94056: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'
94057: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'
94058: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'
94059: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'
94060: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'

Line 94057: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'

94053: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_V'
94054: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'
94055: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'
94056: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'
94057: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'
94058: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'
94059: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'
94060: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'
94061: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_V'

Line 94058: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'

94054: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_V'
94055: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'
94056: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'
94057: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'
94058: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'
94059: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'
94060: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'
94061: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_V'
94062: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_V'

Line 94059: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'

94055: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_V'
94056: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'
94057: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'
94058: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'
94059: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'
94060: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'
94061: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_V'
94062: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_V'
94063: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_V'

Line 94060: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'

94056: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_V'
94057: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'
94058: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'
94059: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'
94060: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'
94061: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_V'
94062: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_V'
94063: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_V'
94064: WHEN 17 THEN 'PA_XLA_EVENT_TYPE_REF_V'

Line 94061: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_V'

94057: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_V'
94058: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'
94059: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'
94060: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'
94061: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_V'
94062: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_V'
94063: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_V'
94064: WHEN 17 THEN 'PA_XLA_EVENT_TYPE_REF_V'
94065:

Line 94062: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_V'

94058: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_V'
94059: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'
94060: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'
94061: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_V'
94062: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_V'
94063: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_V'
94064: WHEN 17 THEN 'PA_XLA_EVENT_TYPE_REF_V'
94065:
94066: ELSE null

Line 94063: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_V'

94059: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_V'
94060: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'
94061: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_V'
94062: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_V'
94063: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_V'
94064: WHEN 17 THEN 'PA_XLA_EVENT_TYPE_REF_V'
94065:
94066: ELSE null
94067: END object_name

Line 94160: , PA_XLA_REVENUE_LINES_V l3

94156: ELSE null
94157: END source_meaning
94158: FROM xla_events_gt xet
94159: , PA_XLA_EVENT_TYPE_REF_V l1
94160: , PA_XLA_REVENUE_LINES_V l3
94161: , fnd_lookup_values fvl72
94162: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
94163: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
94164: AND xet.event_class_code = C_EVENT_CLASS_CODE

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

94303: TYPE t_array_source_75 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
94304: TYPE t_array_source_77 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
94305: TYPE t_array_source_78 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
94306:
94307: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
94308: TYPE t_array_source_17 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_GAINS_CCID%TYPE INDEX BY BINARY_INTEGER;
94309: TYPE t_array_source_18 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_LOSSES_CCID%TYPE INDEX BY BINARY_INTEGER;
94310: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
94311: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 94308: TYPE t_array_source_17 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_GAINS_CCID%TYPE INDEX BY BINARY_INTEGER;

94304: TYPE t_array_source_77 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
94305: TYPE t_array_source_78 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
94306:
94307: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
94308: TYPE t_array_source_17 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_GAINS_CCID%TYPE INDEX BY BINARY_INTEGER;
94309: TYPE t_array_source_18 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_LOSSES_CCID%TYPE INDEX BY BINARY_INTEGER;
94310: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
94311: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
94312: TYPE t_array_source_21 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 94309: TYPE t_array_source_18 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_LOSSES_CCID%TYPE INDEX BY BINARY_INTEGER;

94305: TYPE t_array_source_78 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
94306:
94307: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
94308: TYPE t_array_source_17 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_GAINS_CCID%TYPE INDEX BY BINARY_INTEGER;
94309: TYPE t_array_source_18 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_LOSSES_CCID%TYPE INDEX BY BINARY_INTEGER;
94310: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
94311: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
94312: TYPE t_array_source_21 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
94313: TYPE t_array_source_26 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 94310: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

94306:
94307: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
94308: TYPE t_array_source_17 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_GAINS_CCID%TYPE INDEX BY BINARY_INTEGER;
94309: TYPE t_array_source_18 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_LOSSES_CCID%TYPE INDEX BY BINARY_INTEGER;
94310: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
94311: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
94312: TYPE t_array_source_21 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
94313: TYPE t_array_source_26 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
94314: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 94311: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;

94307: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
94308: TYPE t_array_source_17 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_GAINS_CCID%TYPE INDEX BY BINARY_INTEGER;
94309: TYPE t_array_source_18 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_LOSSES_CCID%TYPE INDEX BY BINARY_INTEGER;
94310: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
94311: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
94312: TYPE t_array_source_21 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
94313: TYPE t_array_source_26 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
94314: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
94315: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 94312: TYPE t_array_source_21 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;

94308: TYPE t_array_source_17 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_GAINS_CCID%TYPE INDEX BY BINARY_INTEGER;
94309: TYPE t_array_source_18 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_LOSSES_CCID%TYPE INDEX BY BINARY_INTEGER;
94310: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
94311: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
94312: TYPE t_array_source_21 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
94313: TYPE t_array_source_26 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
94314: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
94315: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
94316: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 94313: TYPE t_array_source_26 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

94309: TYPE t_array_source_18 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_LOSSES_CCID%TYPE INDEX BY BINARY_INTEGER;
94310: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
94311: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
94312: TYPE t_array_source_21 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
94313: TYPE t_array_source_26 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
94314: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
94315: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
94316: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
94317: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 94314: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

94310: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
94311: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
94312: TYPE t_array_source_21 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
94313: TYPE t_array_source_26 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
94314: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
94315: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
94316: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
94317: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
94318: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 94315: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

94311: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
94312: TYPE t_array_source_21 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
94313: TYPE t_array_source_26 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
94314: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
94315: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
94316: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
94317: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
94318: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
94319: TYPE t_array_source_46 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 94316: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

94312: TYPE t_array_source_21 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
94313: TYPE t_array_source_26 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
94314: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
94315: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
94316: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
94317: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
94318: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
94319: TYPE t_array_source_46 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
94320: TYPE t_array_source_47 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;

Line 94317: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

94313: TYPE t_array_source_26 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
94314: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
94315: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
94316: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
94317: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
94318: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
94319: TYPE t_array_source_46 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
94320: TYPE t_array_source_47 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
94321: TYPE t_array_source_49 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

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

94314: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
94315: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
94316: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
94317: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
94318: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
94319: TYPE t_array_source_46 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
94320: TYPE t_array_source_47 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
94321: TYPE t_array_source_49 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
94322: TYPE t_array_source_50 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 94319: TYPE t_array_source_46 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

94315: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
94316: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
94317: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
94318: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
94319: TYPE t_array_source_46 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
94320: TYPE t_array_source_47 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
94321: TYPE t_array_source_49 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
94322: TYPE t_array_source_50 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
94323: TYPE t_array_source_72 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;

Line 94320: TYPE t_array_source_47 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;

94316: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
94317: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
94318: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
94319: TYPE t_array_source_46 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
94320: TYPE t_array_source_47 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
94321: TYPE t_array_source_49 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
94322: TYPE t_array_source_50 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
94323: TYPE t_array_source_72 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
94324:

Line 94321: TYPE t_array_source_49 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

94317: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
94318: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
94319: TYPE t_array_source_46 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
94320: TYPE t_array_source_47 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
94321: TYPE t_array_source_49 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
94322: TYPE t_array_source_50 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
94323: TYPE t_array_source_72 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
94324:
94325: l_array_source_48 t_array_source_48;

Line 94322: TYPE t_array_source_50 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

94318: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
94319: TYPE t_array_source_46 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
94320: TYPE t_array_source_47 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
94321: TYPE t_array_source_49 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
94322: TYPE t_array_source_50 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
94323: TYPE t_array_source_72 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
94324:
94325: l_array_source_48 t_array_source_48;
94326: l_array_source_51 t_array_source_51;

Line 94444: , PA_XLA_REVENUE_LINES_V l3

94440: , l1.REV_EVENT_TYPE_CLASSIFICATION source_72
94441: , fvl72.meaning source_72_meaning
94442: FROM xla_events_gt xet
94443: , PA_XLA_EVENT_TYPE_REF_V l1
94444: , PA_XLA_REVENUE_LINES_V l3
94445: , fnd_lookup_values fvl72
94446: WHERE xet.event_id between x_first_event_id and x_last_event_id
94447: and xet.event_date between p_pad_start_date and p_pad_end_date
94448: and xet.event_class_code = C_EVENT_CLASS_CODE