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_00707_AAD_S_000020_BC_PKG dependencies on CST_XLA_INV_LINES_V

Line 15371: WHEN 1 THEN 'CST_XLA_INV_LINES_V'

15367: FROM (
15368: SELECT xet.event_id event_id
15369: , l2.line_number line_number
15370: , CASE r
15371: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
15372: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
15373:
15374: ELSE null
15375: END object_name

Line 15372: WHEN 2 THEN 'CST_XLA_INV_LINES_V'

15368: SELECT xet.event_id event_id
15369: , l2.line_number line_number
15370: , CASE r
15371: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
15372: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
15373:
15374: ELSE null
15375: END object_name
15376: , CASE r

Line 15403: , CST_XLA_INV_LINES_V l2

15399: ELSE null
15400: END source_value
15401: , null source_meaning
15402: FROM xla_events_gt xet
15403: , CST_XLA_INV_LINES_V l2
15404: , (select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
15405: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
15406: AND xet.event_class_code = C_EVENT_CLASS_CODE
15407: AND l2.event_id = xet.event_id

Line 15562: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

15558: TYPE t_array_source_39 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
15559: TYPE t_array_source_40 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
15560: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
15561:
15562: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
15563: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
15564:
15565: l_array_source_1 t_array_source_1;
15566: l_array_source_2 t_array_source_2;

Line 15563: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

15559: TYPE t_array_source_40 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
15560: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
15561:
15562: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
15563: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
15564:
15565: l_array_source_1 t_array_source_1;
15566: l_array_source_2 t_array_source_2;
15567: l_array_source_3 t_array_source_3;

Line 15702: , CST_XLA_INV_LINES_V l2

15698: , l2.LINE_NUMBER
15699: , l2.DISTRIBUTION_IDENTIFIER source_8
15700: , l2.CURRENCY_CODE source_11
15701: FROM xla_events_gt xet
15702: , CST_XLA_INV_LINES_V l2
15703: WHERE xet.event_id between x_first_event_id and x_last_event_id
15704: and xet.event_date between p_pad_start_date and p_pad_end_date
15705: and xet.event_class_code = C_EVENT_CLASS_CODE
15706: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 16631: WHEN 1 THEN 'CST_XLA_INV_LINES_V'

16627: FROM (
16628: SELECT xet.event_id event_id
16629: , l2.line_number line_number
16630: , CASE r
16631: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
16632: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
16633: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
16634: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
16635: WHEN 5 THEN 'CST_XLA_INV_LINES_V'

Line 16632: WHEN 2 THEN 'CST_XLA_INV_LINES_V'

16628: SELECT xet.event_id event_id
16629: , l2.line_number line_number
16630: , CASE r
16631: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
16632: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
16633: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
16634: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
16635: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
16636: WHEN 6 THEN 'CST_XLA_INV_LINES_V'

Line 16633: WHEN 3 THEN 'CST_XLA_INV_LINES_V'

16629: , l2.line_number line_number
16630: , CASE r
16631: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
16632: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
16633: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
16634: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
16635: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
16636: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
16637: WHEN 7 THEN 'CST_XLA_INV_LINES_V'

Line 16634: WHEN 4 THEN 'CST_XLA_INV_LINES_V'

16630: , CASE r
16631: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
16632: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
16633: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
16634: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
16635: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
16636: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
16637: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
16638: WHEN 8 THEN 'CST_XLA_INV_LINES_V'

Line 16635: WHEN 5 THEN 'CST_XLA_INV_LINES_V'

16631: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
16632: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
16633: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
16634: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
16635: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
16636: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
16637: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
16638: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
16639: WHEN 9 THEN 'CST_XLA_INV_LINES_V'

Line 16636: WHEN 6 THEN 'CST_XLA_INV_LINES_V'

16632: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
16633: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
16634: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
16635: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
16636: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
16637: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
16638: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
16639: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
16640:

Line 16637: WHEN 7 THEN 'CST_XLA_INV_LINES_V'

16633: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
16634: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
16635: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
16636: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
16637: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
16638: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
16639: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
16640:
16641: ELSE null

Line 16638: WHEN 8 THEN 'CST_XLA_INV_LINES_V'

16634: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
16635: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
16636: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
16637: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
16638: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
16639: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
16640:
16641: ELSE null
16642: END object_name

Line 16639: WHEN 9 THEN 'CST_XLA_INV_LINES_V'

16635: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
16636: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
16637: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
16638: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
16639: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
16640:
16641: ELSE null
16642: END object_name
16643: , CASE r

Line 16698: , CST_XLA_INV_LINES_V l2

16694: ELSE null
16695: END source_value
16696: , null source_meaning
16697: FROM xla_events_gt xet
16698: , CST_XLA_INV_LINES_V l2
16699: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
16700: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
16701: AND xet.event_type_code = C_EVENT_TYPE_CODE
16702: AND l2.event_id = xet.event_id

Line 16844: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

16840: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
16841: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
16842: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
16843:
16844: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
16845: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
16846: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
16847: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
16848: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 16845: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

16841: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
16842: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
16843:
16844: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
16845: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
16846: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
16847: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
16848: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
16849: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 16846: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

16842: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
16843:
16844: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
16845: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
16846: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
16847: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
16848: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
16849: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
16850: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 16847: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

16843:
16844: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
16845: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
16846: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
16847: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
16848: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
16849: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
16850: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
16851: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 16848: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

16844: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
16845: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
16846: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
16847: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
16848: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
16849: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
16850: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
16851: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
16852: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 16849: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

16845: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
16846: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
16847: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
16848: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
16849: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
16850: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
16851: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
16852: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
16853:

Line 16850: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

16846: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
16847: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
16848: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
16849: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
16850: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
16851: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
16852: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
16853:
16854: l_array_source_1 t_array_source_1;

Line 16851: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

16847: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
16848: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
16849: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
16850: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
16851: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
16852: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
16853:
16854: l_array_source_1 t_array_source_1;
16855: l_array_source_2 t_array_source_2;

Line 16852: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

16848: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
16849: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
16850: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
16851: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
16852: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
16853:
16854: l_array_source_1 t_array_source_1;
16855: l_array_source_2 t_array_source_2;
16856: l_array_source_3 t_array_source_3;

Line 16976: , CST_XLA_INV_LINES_V l2

16972: , l2.CURRENCY_CONVERSION_RATE source_13
16973: , l2.CURRENCY_CONVERSION_TYPE source_14
16974: , l2.ACCOUNTED_AMOUNT source_15
16975: FROM xla_events_gt xet
16976: , CST_XLA_INV_LINES_V l2
16977: WHERE xet.event_id between x_first_event_id and x_last_event_id
16978: and xet.event_date between p_pad_start_date and p_pad_end_date
16979: and xet.event_type_code = C_EVENT_TYPE_CODE
16980: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 17878: WHEN 1 THEN 'CST_XLA_INV_LINES_V'

17874: FROM (
17875: SELECT xet.event_id event_id
17876: , l2.line_number line_number
17877: , CASE r
17878: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
17879: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
17880: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
17881: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
17882: WHEN 5 THEN 'CST_XLA_INV_LINES_V'

Line 17879: WHEN 2 THEN 'CST_XLA_INV_LINES_V'

17875: SELECT xet.event_id event_id
17876: , l2.line_number line_number
17877: , CASE r
17878: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
17879: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
17880: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
17881: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
17882: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
17883: WHEN 6 THEN 'CST_XLA_INV_LINES_V'

Line 17880: WHEN 3 THEN 'CST_XLA_INV_LINES_V'

17876: , l2.line_number line_number
17877: , CASE r
17878: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
17879: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
17880: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
17881: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
17882: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
17883: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
17884: WHEN 7 THEN 'CST_XLA_INV_LINES_V'

Line 17881: WHEN 4 THEN 'CST_XLA_INV_LINES_V'

17877: , CASE r
17878: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
17879: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
17880: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
17881: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
17882: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
17883: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
17884: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
17885: WHEN 8 THEN 'CST_XLA_INV_LINES_V'

Line 17882: WHEN 5 THEN 'CST_XLA_INV_LINES_V'

17878: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
17879: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
17880: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
17881: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
17882: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
17883: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
17884: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
17885: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
17886: WHEN 9 THEN 'CST_XLA_INV_LINES_V'

Line 17883: WHEN 6 THEN 'CST_XLA_INV_LINES_V'

17879: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
17880: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
17881: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
17882: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
17883: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
17884: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
17885: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
17886: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
17887:

Line 17884: WHEN 7 THEN 'CST_XLA_INV_LINES_V'

17880: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
17881: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
17882: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
17883: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
17884: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
17885: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
17886: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
17887:
17888: ELSE null

Line 17885: WHEN 8 THEN 'CST_XLA_INV_LINES_V'

17881: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
17882: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
17883: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
17884: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
17885: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
17886: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
17887:
17888: ELSE null
17889: END object_name

Line 17886: WHEN 9 THEN 'CST_XLA_INV_LINES_V'

17882: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
17883: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
17884: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
17885: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
17886: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
17887:
17888: ELSE null
17889: END object_name
17890: , CASE r

Line 17945: , CST_XLA_INV_LINES_V l2

17941: ELSE null
17942: END source_value
17943: , null source_meaning
17944: FROM xla_events_gt xet
17945: , CST_XLA_INV_LINES_V l2
17946: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
17947: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
17948: AND xet.event_type_code = C_EVENT_TYPE_CODE
17949: AND l2.event_id = xet.event_id

Line 18091: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

18087: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
18088: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
18089: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
18090:
18091: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
18092: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
18093: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
18094: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
18095: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 18092: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

18088: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
18089: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
18090:
18091: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
18092: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
18093: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
18094: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
18095: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
18096: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 18093: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

18089: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
18090:
18091: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
18092: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
18093: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
18094: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
18095: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
18096: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
18097: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 18094: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

18090:
18091: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
18092: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
18093: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
18094: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
18095: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
18096: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
18097: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
18098: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 18095: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

18091: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
18092: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
18093: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
18094: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
18095: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
18096: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
18097: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
18098: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
18099: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 18096: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

18092: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
18093: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
18094: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
18095: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
18096: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
18097: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
18098: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
18099: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
18100:

Line 18097: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

18093: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
18094: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
18095: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
18096: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
18097: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
18098: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
18099: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
18100:
18101: l_array_source_1 t_array_source_1;

Line 18098: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

18094: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
18095: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
18096: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
18097: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
18098: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
18099: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
18100:
18101: l_array_source_1 t_array_source_1;
18102: l_array_source_2 t_array_source_2;

Line 18099: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

18095: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
18096: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
18097: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
18098: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
18099: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
18100:
18101: l_array_source_1 t_array_source_1;
18102: l_array_source_2 t_array_source_2;
18103: l_array_source_3 t_array_source_3;

Line 18223: , CST_XLA_INV_LINES_V l2

18219: , l2.CURRENCY_CONVERSION_RATE source_13
18220: , l2.CURRENCY_CONVERSION_TYPE source_14
18221: , l2.ACCOUNTED_AMOUNT source_15
18222: FROM xla_events_gt xet
18223: , CST_XLA_INV_LINES_V l2
18224: WHERE xet.event_id between x_first_event_id and x_last_event_id
18225: and xet.event_date between p_pad_start_date and p_pad_end_date
18226: and xet.event_type_code = C_EVENT_TYPE_CODE
18227: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 19194: WHEN 1 THEN 'CST_XLA_INV_LINES_V'

19190: FROM (
19191: SELECT xet.event_id event_id
19192: , l2.line_number line_number
19193: , CASE r
19194: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
19195: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
19196: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
19197:
19198: ELSE null

Line 19195: WHEN 2 THEN 'CST_XLA_INV_LINES_V'

19191: SELECT xet.event_id event_id
19192: , l2.line_number line_number
19193: , CASE r
19194: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
19195: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
19196: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
19197:
19198: ELSE null
19199: END object_name

Line 19196: WHEN 3 THEN 'CST_XLA_INV_LINES_V'

19192: , l2.line_number line_number
19193: , CASE r
19194: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
19195: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
19196: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
19197:
19198: ELSE null
19199: END object_name
19200: , CASE r

Line 19231: , CST_XLA_INV_LINES_V l2

19227: ELSE null
19228: END source_value
19229: , null source_meaning
19230: FROM xla_events_gt xet
19231: , CST_XLA_INV_LINES_V l2
19232: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
19233: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
19234: AND xet.event_type_code = C_EVENT_TYPE_CODE
19235: AND l2.event_id = xet.event_id

Line 19390: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

19386: TYPE t_array_source_39 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
19387: TYPE t_array_source_40 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
19388: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
19389:
19390: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
19391: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
19392: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
19393:
19394: l_array_source_1 t_array_source_1;

Line 19391: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

19387: TYPE t_array_source_40 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
19388: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
19389:
19390: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
19391: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
19392: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
19393:
19394: l_array_source_1 t_array_source_1;
19395: l_array_source_2 t_array_source_2;

Line 19392: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

19388: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
19389:
19390: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
19391: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
19392: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
19393:
19394: l_array_source_1 t_array_source_1;
19395: l_array_source_2 t_array_source_2;
19396: l_array_source_3 t_array_source_3;

Line 19534: , CST_XLA_INV_LINES_V l2

19530: , l2.ACCOUNTING_LINE_TYPE_CODE source_7
19531: , l2.DISTRIBUTION_IDENTIFIER source_8
19532: , l2.CURRENCY_CODE source_11
19533: FROM xla_events_gt xet
19534: , CST_XLA_INV_LINES_V l2
19535: WHERE xet.event_id between x_first_event_id and x_last_event_id
19536: and xet.event_date between p_pad_start_date and p_pad_end_date
19537: and xet.event_type_code = C_EVENT_TYPE_CODE
19538: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 20534: WHEN 1 THEN 'CST_XLA_INV_LINES_V'

20530: FROM (
20531: SELECT xet.event_id event_id
20532: , l2.line_number line_number
20533: , CASE r
20534: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
20535: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
20536: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
20537:
20538: ELSE null

Line 20535: WHEN 2 THEN 'CST_XLA_INV_LINES_V'

20531: SELECT xet.event_id event_id
20532: , l2.line_number line_number
20533: , CASE r
20534: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
20535: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
20536: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
20537:
20538: ELSE null
20539: END object_name

Line 20536: WHEN 3 THEN 'CST_XLA_INV_LINES_V'

20532: , l2.line_number line_number
20533: , CASE r
20534: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
20535: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
20536: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
20537:
20538: ELSE null
20539: END object_name
20540: , CASE r

Line 20571: , CST_XLA_INV_LINES_V l2

20567: ELSE null
20568: END source_value
20569: , null source_meaning
20570: FROM xla_events_gt xet
20571: , CST_XLA_INV_LINES_V l2
20572: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
20573: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
20574: AND xet.event_type_code = C_EVENT_TYPE_CODE
20575: AND l2.event_id = xet.event_id

Line 20730: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

20726: TYPE t_array_source_39 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
20727: TYPE t_array_source_40 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
20728: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
20729:
20730: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
20731: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
20732: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
20733:
20734: l_array_source_1 t_array_source_1;

Line 20731: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

20727: TYPE t_array_source_40 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
20728: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
20729:
20730: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
20731: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
20732: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
20733:
20734: l_array_source_1 t_array_source_1;
20735: l_array_source_2 t_array_source_2;

Line 20732: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

20728: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
20729:
20730: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
20731: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
20732: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
20733:
20734: l_array_source_1 t_array_source_1;
20735: l_array_source_2 t_array_source_2;
20736: l_array_source_3 t_array_source_3;

Line 20874: , CST_XLA_INV_LINES_V l2

20870: , l2.ACCOUNTING_LINE_TYPE_CODE source_7
20871: , l2.DISTRIBUTION_IDENTIFIER source_8
20872: , l2.CURRENCY_CODE source_11
20873: FROM xla_events_gt xet
20874: , CST_XLA_INV_LINES_V l2
20875: WHERE xet.event_id between x_first_event_id and x_last_event_id
20876: and xet.event_date between p_pad_start_date and p_pad_end_date
20877: and xet.event_type_code = C_EVENT_TYPE_CODE
20878: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 21777: WHEN 1 THEN 'CST_XLA_INV_LINES_V'

21773: FROM (
21774: SELECT xet.event_id event_id
21775: , l2.line_number line_number
21776: , CASE r
21777: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
21778: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
21779: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
21780: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
21781: WHEN 5 THEN 'CST_XLA_INV_LINES_V'

Line 21778: WHEN 2 THEN 'CST_XLA_INV_LINES_V'

21774: SELECT xet.event_id event_id
21775: , l2.line_number line_number
21776: , CASE r
21777: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
21778: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
21779: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
21780: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
21781: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
21782: WHEN 6 THEN 'CST_XLA_INV_LINES_V'

Line 21779: WHEN 3 THEN 'CST_XLA_INV_LINES_V'

21775: , l2.line_number line_number
21776: , CASE r
21777: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
21778: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
21779: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
21780: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
21781: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
21782: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
21783: WHEN 7 THEN 'CST_XLA_INV_LINES_V'

Line 21780: WHEN 4 THEN 'CST_XLA_INV_LINES_V'

21776: , CASE r
21777: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
21778: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
21779: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
21780: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
21781: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
21782: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
21783: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
21784: WHEN 8 THEN 'CST_XLA_INV_LINES_V'

Line 21781: WHEN 5 THEN 'CST_XLA_INV_LINES_V'

21777: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
21778: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
21779: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
21780: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
21781: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
21782: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
21783: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
21784: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
21785: WHEN 9 THEN 'CST_XLA_INV_LINES_V'

Line 21782: WHEN 6 THEN 'CST_XLA_INV_LINES_V'

21778: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
21779: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
21780: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
21781: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
21782: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
21783: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
21784: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
21785: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
21786:

Line 21783: WHEN 7 THEN 'CST_XLA_INV_LINES_V'

21779: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
21780: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
21781: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
21782: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
21783: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
21784: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
21785: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
21786:
21787: ELSE null

Line 21784: WHEN 8 THEN 'CST_XLA_INV_LINES_V'

21780: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
21781: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
21782: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
21783: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
21784: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
21785: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
21786:
21787: ELSE null
21788: END object_name

Line 21785: WHEN 9 THEN 'CST_XLA_INV_LINES_V'

21781: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
21782: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
21783: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
21784: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
21785: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
21786:
21787: ELSE null
21788: END object_name
21789: , CASE r

Line 21844: , CST_XLA_INV_LINES_V l2

21840: ELSE null
21841: END source_value
21842: , null source_meaning
21843: FROM xla_events_gt xet
21844: , CST_XLA_INV_LINES_V l2
21845: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
21846: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
21847: AND xet.event_type_code = C_EVENT_TYPE_CODE
21848: AND l2.event_id = xet.event_id

Line 21985: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

21981:
21982: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
21983: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
21984:
21985: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
21986: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
21987: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
21988: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
21989: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 21986: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

21982: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
21983: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
21984:
21985: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
21986: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
21987: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
21988: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
21989: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
21990: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 21987: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

21983: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
21984:
21985: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
21986: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
21987: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
21988: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
21989: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
21990: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
21991: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 21988: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

21984:
21985: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
21986: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
21987: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
21988: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
21989: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
21990: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
21991: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
21992: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 21989: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

21985: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
21986: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
21987: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
21988: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
21989: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
21990: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
21991: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
21992: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
21993: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 21990: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

21986: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
21987: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
21988: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
21989: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
21990: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
21991: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
21992: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
21993: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
21994:

Line 21991: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

21987: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
21988: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
21989: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
21990: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
21991: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
21992: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
21993: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
21994:
21995: l_array_source_9 t_array_source_9;

Line 21992: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

21988: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
21989: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
21990: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
21991: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
21992: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
21993: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
21994:
21995: l_array_source_9 t_array_source_9;
21996: l_array_source_9_meaning t_array_lookup_meaning;

Line 21993: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

21989: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
21990: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
21991: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
21992: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
21993: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
21994:
21995: l_array_source_9 t_array_source_9;
21996: l_array_source_9_meaning t_array_lookup_meaning;
21997: l_array_source_42 t_array_source_42;

Line 22104: , CST_XLA_INV_LINES_V l2

22100: , l2.CURRENCY_CONVERSION_RATE source_13
22101: , l2.CURRENCY_CONVERSION_TYPE source_14
22102: , l2.ACCOUNTED_AMOUNT source_15
22103: FROM xla_events_gt xet
22104: , CST_XLA_INV_LINES_V l2
22105: WHERE xet.event_id between x_first_event_id and x_last_event_id
22106: and xet.event_date between p_pad_start_date and p_pad_end_date
22107: and xet.event_type_code = C_EVENT_TYPE_CODE
22108: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 22955: WHEN 1 THEN 'CST_XLA_INV_LINES_V'

22951: FROM (
22952: SELECT xet.event_id event_id
22953: , l2.line_number line_number
22954: , CASE r
22955: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
22956: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
22957: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
22958: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
22959: WHEN 5 THEN 'CST_XLA_INV_LINES_V'

Line 22956: WHEN 2 THEN 'CST_XLA_INV_LINES_V'

22952: SELECT xet.event_id event_id
22953: , l2.line_number line_number
22954: , CASE r
22955: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
22956: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
22957: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
22958: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
22959: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
22960: WHEN 6 THEN 'CST_XLA_INV_LINES_V'

Line 22957: WHEN 3 THEN 'CST_XLA_INV_LINES_V'

22953: , l2.line_number line_number
22954: , CASE r
22955: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
22956: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
22957: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
22958: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
22959: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
22960: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
22961: WHEN 7 THEN 'CST_XLA_INV_LINES_V'

Line 22958: WHEN 4 THEN 'CST_XLA_INV_LINES_V'

22954: , CASE r
22955: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
22956: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
22957: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
22958: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
22959: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
22960: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
22961: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
22962: WHEN 8 THEN 'CST_XLA_INV_LINES_V'

Line 22959: WHEN 5 THEN 'CST_XLA_INV_LINES_V'

22955: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
22956: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
22957: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
22958: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
22959: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
22960: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
22961: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
22962: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
22963: WHEN 9 THEN 'CST_XLA_INV_LINES_V'

Line 22960: WHEN 6 THEN 'CST_XLA_INV_LINES_V'

22956: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
22957: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
22958: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
22959: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
22960: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
22961: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
22962: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
22963: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
22964:

Line 22961: WHEN 7 THEN 'CST_XLA_INV_LINES_V'

22957: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
22958: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
22959: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
22960: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
22961: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
22962: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
22963: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
22964:
22965: ELSE null

Line 22962: WHEN 8 THEN 'CST_XLA_INV_LINES_V'

22958: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
22959: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
22960: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
22961: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
22962: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
22963: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
22964:
22965: ELSE null
22966: END object_name

Line 22963: WHEN 9 THEN 'CST_XLA_INV_LINES_V'

22959: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
22960: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
22961: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
22962: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
22963: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
22964:
22965: ELSE null
22966: END object_name
22967: , CASE r

Line 23022: , CST_XLA_INV_LINES_V l2

23018: ELSE null
23019: END source_value
23020: , null source_meaning
23021: FROM xla_events_gt xet
23022: , CST_XLA_INV_LINES_V l2
23023: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
23024: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
23025: AND xet.event_type_code = C_EVENT_TYPE_CODE
23026: AND l2.event_id = xet.event_id

Line 23163: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

23159:
23160: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
23161: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
23162:
23163: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
23164: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
23165: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
23166: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
23167: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 23164: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

23160: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
23161: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
23162:
23163: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
23164: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
23165: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
23166: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
23167: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
23168: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 23165: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

23161: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
23162:
23163: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
23164: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
23165: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
23166: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
23167: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
23168: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
23169: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 23166: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

23162:
23163: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
23164: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
23165: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
23166: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
23167: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
23168: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
23169: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
23170: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 23167: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

23163: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
23164: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
23165: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
23166: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
23167: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
23168: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
23169: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
23170: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
23171: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 23168: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

23164: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
23165: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
23166: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
23167: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
23168: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
23169: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
23170: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
23171: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
23172:

Line 23169: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

23165: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
23166: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
23167: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
23168: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
23169: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
23170: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
23171: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
23172:
23173: l_array_source_9 t_array_source_9;

Line 23170: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

23166: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
23167: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
23168: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
23169: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
23170: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
23171: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
23172:
23173: l_array_source_9 t_array_source_9;
23174: l_array_source_9_meaning t_array_lookup_meaning;

Line 23171: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

23167: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
23168: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
23169: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
23170: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
23171: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
23172:
23173: l_array_source_9 t_array_source_9;
23174: l_array_source_9_meaning t_array_lookup_meaning;
23175: l_array_source_42 t_array_source_42;

Line 23282: , CST_XLA_INV_LINES_V l2

23278: , l2.CURRENCY_CONVERSION_RATE source_13
23279: , l2.CURRENCY_CONVERSION_TYPE source_14
23280: , l2.ACCOUNTED_AMOUNT source_15
23281: FROM xla_events_gt xet
23282: , CST_XLA_INV_LINES_V l2
23283: WHERE xet.event_id between x_first_event_id and x_last_event_id
23284: and xet.event_date between p_pad_start_date and p_pad_end_date
23285: and xet.event_type_code = C_EVENT_TYPE_CODE
23286: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 24161: WHEN 1 THEN 'CST_XLA_INV_LINES_V'

24157: FROM (
24158: SELECT xet.event_id event_id
24159: , l2.line_number line_number
24160: , CASE r
24161: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
24162: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
24163: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
24164: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
24165: WHEN 5 THEN 'CST_XLA_INV_LINES_V'

Line 24162: WHEN 2 THEN 'CST_XLA_INV_LINES_V'

24158: SELECT xet.event_id event_id
24159: , l2.line_number line_number
24160: , CASE r
24161: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
24162: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
24163: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
24164: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
24165: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
24166: WHEN 6 THEN 'CST_XLA_INV_LINES_V'

Line 24163: WHEN 3 THEN 'CST_XLA_INV_LINES_V'

24159: , l2.line_number line_number
24160: , CASE r
24161: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
24162: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
24163: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
24164: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
24165: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
24166: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
24167: WHEN 7 THEN 'CST_XLA_INV_LINES_V'

Line 24164: WHEN 4 THEN 'CST_XLA_INV_LINES_V'

24160: , CASE r
24161: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
24162: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
24163: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
24164: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
24165: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
24166: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
24167: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
24168: WHEN 8 THEN 'CST_XLA_INV_LINES_V'

Line 24165: WHEN 5 THEN 'CST_XLA_INV_LINES_V'

24161: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
24162: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
24163: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
24164: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
24165: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
24166: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
24167: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
24168: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
24169: WHEN 9 THEN 'CST_XLA_INV_LINES_V'

Line 24166: WHEN 6 THEN 'CST_XLA_INV_LINES_V'

24162: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
24163: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
24164: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
24165: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
24166: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
24167: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
24168: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
24169: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
24170:

Line 24167: WHEN 7 THEN 'CST_XLA_INV_LINES_V'

24163: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
24164: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
24165: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
24166: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
24167: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
24168: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
24169: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
24170:
24171: ELSE null

Line 24168: WHEN 8 THEN 'CST_XLA_INV_LINES_V'

24164: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
24165: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
24166: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
24167: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
24168: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
24169: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
24170:
24171: ELSE null
24172: END object_name

Line 24169: WHEN 9 THEN 'CST_XLA_INV_LINES_V'

24165: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
24166: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
24167: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
24168: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
24169: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
24170:
24171: ELSE null
24172: END object_name
24173: , CASE r

Line 24228: , CST_XLA_INV_LINES_V l2

24224: ELSE null
24225: END source_value
24226: , null source_meaning
24227: FROM xla_events_gt xet
24228: , CST_XLA_INV_LINES_V l2
24229: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
24230: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
24231: AND xet.event_type_code = C_EVENT_TYPE_CODE
24232: AND l2.event_id = xet.event_id

Line 24374: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

24370: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
24371: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
24372: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
24373:
24374: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
24375: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
24376: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
24377: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
24378: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 24375: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

24371: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
24372: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
24373:
24374: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
24375: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
24376: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
24377: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
24378: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
24379: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 24376: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

24372: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
24373:
24374: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
24375: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
24376: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
24377: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
24378: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
24379: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
24380: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 24377: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

24373:
24374: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
24375: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
24376: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
24377: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
24378: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
24379: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
24380: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
24381: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 24378: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

24374: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
24375: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
24376: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
24377: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
24378: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
24379: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
24380: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
24381: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
24382: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 24379: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

24375: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
24376: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
24377: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
24378: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
24379: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
24380: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
24381: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
24382: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
24383:

Line 24380: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

24376: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
24377: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
24378: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
24379: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
24380: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
24381: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
24382: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
24383:
24384: l_array_source_1 t_array_source_1;

Line 24381: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

24377: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
24378: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
24379: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
24380: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
24381: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
24382: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
24383:
24384: l_array_source_1 t_array_source_1;
24385: l_array_source_2 t_array_source_2;

Line 24382: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

24378: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
24379: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
24380: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
24381: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
24382: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
24383:
24384: l_array_source_1 t_array_source_1;
24385: l_array_source_2 t_array_source_2;
24386: l_array_source_3 t_array_source_3;

Line 24506: , CST_XLA_INV_LINES_V l2

24502: , l2.CURRENCY_CONVERSION_RATE source_13
24503: , l2.CURRENCY_CONVERSION_TYPE source_14
24504: , l2.ACCOUNTED_AMOUNT source_15
24505: FROM xla_events_gt xet
24506: , CST_XLA_INV_LINES_V l2
24507: WHERE xet.event_id between x_first_event_id and x_last_event_id
24508: and xet.event_date between p_pad_start_date and p_pad_end_date
24509: and xet.event_type_code = C_EVENT_TYPE_CODE
24510: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 25408: WHEN 1 THEN 'CST_XLA_INV_LINES_V'

25404: FROM (
25405: SELECT xet.event_id event_id
25406: , l2.line_number line_number
25407: , CASE r
25408: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
25409: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
25410: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
25411: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
25412: WHEN 5 THEN 'CST_XLA_INV_LINES_V'

Line 25409: WHEN 2 THEN 'CST_XLA_INV_LINES_V'

25405: SELECT xet.event_id event_id
25406: , l2.line_number line_number
25407: , CASE r
25408: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
25409: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
25410: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
25411: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
25412: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
25413: WHEN 6 THEN 'CST_XLA_INV_LINES_V'

Line 25410: WHEN 3 THEN 'CST_XLA_INV_LINES_V'

25406: , l2.line_number line_number
25407: , CASE r
25408: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
25409: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
25410: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
25411: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
25412: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
25413: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
25414: WHEN 7 THEN 'CST_XLA_INV_LINES_V'

Line 25411: WHEN 4 THEN 'CST_XLA_INV_LINES_V'

25407: , CASE r
25408: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
25409: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
25410: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
25411: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
25412: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
25413: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
25414: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
25415: WHEN 8 THEN 'CST_XLA_INV_LINES_V'

Line 25412: WHEN 5 THEN 'CST_XLA_INV_LINES_V'

25408: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
25409: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
25410: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
25411: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
25412: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
25413: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
25414: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
25415: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
25416: WHEN 9 THEN 'CST_XLA_INV_LINES_V'

Line 25413: WHEN 6 THEN 'CST_XLA_INV_LINES_V'

25409: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
25410: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
25411: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
25412: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
25413: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
25414: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
25415: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
25416: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
25417:

Line 25414: WHEN 7 THEN 'CST_XLA_INV_LINES_V'

25410: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
25411: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
25412: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
25413: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
25414: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
25415: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
25416: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
25417:
25418: ELSE null

Line 25415: WHEN 8 THEN 'CST_XLA_INV_LINES_V'

25411: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
25412: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
25413: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
25414: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
25415: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
25416: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
25417:
25418: ELSE null
25419: END object_name

Line 25416: WHEN 9 THEN 'CST_XLA_INV_LINES_V'

25412: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
25413: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
25414: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
25415: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
25416: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
25417:
25418: ELSE null
25419: END object_name
25420: , CASE r

Line 25475: , CST_XLA_INV_LINES_V l2

25471: ELSE null
25472: END source_value
25473: , null source_meaning
25474: FROM xla_events_gt xet
25475: , CST_XLA_INV_LINES_V l2
25476: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
25477: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
25478: AND xet.event_type_code = C_EVENT_TYPE_CODE
25479: AND l2.event_id = xet.event_id

Line 25621: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

25617: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
25618: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
25619: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
25620:
25621: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
25622: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
25623: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
25624: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
25625: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 25622: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

25618: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
25619: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
25620:
25621: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
25622: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
25623: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
25624: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
25625: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
25626: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 25623: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

25619: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
25620:
25621: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
25622: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
25623: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
25624: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
25625: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
25626: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
25627: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 25624: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

25620:
25621: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
25622: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
25623: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
25624: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
25625: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
25626: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
25627: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
25628: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 25625: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

25621: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
25622: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
25623: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
25624: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
25625: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
25626: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
25627: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
25628: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
25629: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 25626: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

25622: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
25623: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
25624: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
25625: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
25626: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
25627: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
25628: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
25629: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
25630:

Line 25627: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

25623: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
25624: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
25625: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
25626: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
25627: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
25628: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
25629: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
25630:
25631: l_array_source_1 t_array_source_1;

Line 25628: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

25624: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
25625: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
25626: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
25627: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
25628: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
25629: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
25630:
25631: l_array_source_1 t_array_source_1;
25632: l_array_source_2 t_array_source_2;

Line 25629: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

25625: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
25626: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
25627: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
25628: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
25629: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
25630:
25631: l_array_source_1 t_array_source_1;
25632: l_array_source_2 t_array_source_2;
25633: l_array_source_3 t_array_source_3;

Line 25753: , CST_XLA_INV_LINES_V l2

25749: , l2.CURRENCY_CONVERSION_RATE source_13
25750: , l2.CURRENCY_CONVERSION_TYPE source_14
25751: , l2.ACCOUNTED_AMOUNT source_15
25752: FROM xla_events_gt xet
25753: , CST_XLA_INV_LINES_V l2
25754: WHERE xet.event_id between x_first_event_id and x_last_event_id
25755: and xet.event_date between p_pad_start_date and p_pad_end_date
25756: and xet.event_type_code = C_EVENT_TYPE_CODE
25757: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 26725: WHEN 1 THEN 'CST_XLA_INV_LINES_V'

26721: FROM (
26722: SELECT xet.event_id event_id
26723: , l2.line_number line_number
26724: , CASE r
26725: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
26726: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
26727: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
26728:
26729: ELSE null

Line 26726: WHEN 2 THEN 'CST_XLA_INV_LINES_V'

26722: SELECT xet.event_id event_id
26723: , l2.line_number line_number
26724: , CASE r
26725: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
26726: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
26727: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
26728:
26729: ELSE null
26730: END object_name

Line 26727: WHEN 3 THEN 'CST_XLA_INV_LINES_V'

26723: , l2.line_number line_number
26724: , CASE r
26725: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
26726: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
26727: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
26728:
26729: ELSE null
26730: END object_name
26731: , CASE r

Line 26762: , CST_XLA_INV_LINES_V l2

26758: ELSE null
26759: END source_value
26760: , null source_meaning
26761: FROM xla_events_gt xet
26762: , CST_XLA_INV_LINES_V l2
26763: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
26764: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
26765: AND xet.event_type_code = C_EVENT_TYPE_CODE
26766: AND l2.event_id = xet.event_id

Line 26921: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

26917: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
26918: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
26919: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
26920:
26921: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
26922: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
26923: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
26924:
26925: l_array_source_1 t_array_source_1;

Line 26922: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

26918: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
26919: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
26920:
26921: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
26922: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
26923: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
26924:
26925: l_array_source_1 t_array_source_1;
26926: l_array_source_2 t_array_source_2;

Line 26923: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

26919: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
26920:
26921: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
26922: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
26923: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
26924:
26925: l_array_source_1 t_array_source_1;
26926: l_array_source_2 t_array_source_2;
26927: l_array_source_3 t_array_source_3;

Line 27066: , CST_XLA_INV_LINES_V l2

27062: , l2.ACCOUNTING_LINE_TYPE_CODE source_7
27063: , l2.DISTRIBUTION_IDENTIFIER source_8
27064: , l2.CURRENCY_CODE source_11
27065: FROM xla_events_gt xet
27066: , CST_XLA_INV_LINES_V l2
27067: WHERE xet.event_id between x_first_event_id and x_last_event_id
27068: and xet.event_date between p_pad_start_date and p_pad_end_date
27069: and xet.event_type_code = C_EVENT_TYPE_CODE
27070: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 28101: WHEN 1 THEN 'CST_XLA_INV_LINES_V'

28097: FROM (
28098: SELECT xet.event_id event_id
28099: , l2.line_number line_number
28100: , CASE r
28101: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
28102: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
28103: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
28104:
28105: ELSE null

Line 28102: WHEN 2 THEN 'CST_XLA_INV_LINES_V'

28098: SELECT xet.event_id event_id
28099: , l2.line_number line_number
28100: , CASE r
28101: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
28102: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
28103: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
28104:
28105: ELSE null
28106: END object_name

Line 28103: WHEN 3 THEN 'CST_XLA_INV_LINES_V'

28099: , l2.line_number line_number
28100: , CASE r
28101: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
28102: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
28103: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
28104:
28105: ELSE null
28106: END object_name
28107: , CASE r

Line 28138: , CST_XLA_INV_LINES_V l2

28134: ELSE null
28135: END source_value
28136: , null source_meaning
28137: FROM xla_events_gt xet
28138: , CST_XLA_INV_LINES_V l2
28139: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
28140: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
28141: AND xet.event_type_code = C_EVENT_TYPE_CODE
28142: AND l2.event_id = xet.event_id

Line 28297: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

28293: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
28294: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
28295: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
28296:
28297: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
28298: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
28299: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
28300:
28301: l_array_source_1 t_array_source_1;

Line 28298: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

28294: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
28295: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
28296:
28297: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
28298: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
28299: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
28300:
28301: l_array_source_1 t_array_source_1;
28302: l_array_source_2 t_array_source_2;

Line 28299: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

28295: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
28296:
28297: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
28298: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
28299: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
28300:
28301: l_array_source_1 t_array_source_1;
28302: l_array_source_2 t_array_source_2;
28303: l_array_source_3 t_array_source_3;

Line 28442: , CST_XLA_INV_LINES_V l2

28438: , l2.ACCOUNTING_LINE_TYPE_CODE source_7
28439: , l2.DISTRIBUTION_IDENTIFIER source_8
28440: , l2.CURRENCY_CODE source_11
28441: FROM xla_events_gt xet
28442: , CST_XLA_INV_LINES_V l2
28443: WHERE xet.event_id between x_first_event_id and x_last_event_id
28444: and xet.event_date between p_pad_start_date and p_pad_end_date
28445: and xet.event_type_code = C_EVENT_TYPE_CODE
28446: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 29477: WHEN 1 THEN 'CST_XLA_INV_LINES_V'

29473: FROM (
29474: SELECT xet.event_id event_id
29475: , l2.line_number line_number
29476: , CASE r
29477: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
29478: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
29479: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
29480:
29481: ELSE null

Line 29478: WHEN 2 THEN 'CST_XLA_INV_LINES_V'

29474: SELECT xet.event_id event_id
29475: , l2.line_number line_number
29476: , CASE r
29477: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
29478: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
29479: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
29480:
29481: ELSE null
29482: END object_name

Line 29479: WHEN 3 THEN 'CST_XLA_INV_LINES_V'

29475: , l2.line_number line_number
29476: , CASE r
29477: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
29478: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
29479: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
29480:
29481: ELSE null
29482: END object_name
29483: , CASE r

Line 29514: , CST_XLA_INV_LINES_V l2

29510: ELSE null
29511: END source_value
29512: , null source_meaning
29513: FROM xla_events_gt xet
29514: , CST_XLA_INV_LINES_V l2
29515: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
29516: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
29517: AND xet.event_type_code = C_EVENT_TYPE_CODE
29518: AND l2.event_id = xet.event_id

Line 29673: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

29669: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
29670: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
29671: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
29672:
29673: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
29674: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
29675: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
29676:
29677: l_array_source_1 t_array_source_1;

Line 29674: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

29670: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
29671: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
29672:
29673: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
29674: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
29675: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
29676:
29677: l_array_source_1 t_array_source_1;
29678: l_array_source_2 t_array_source_2;

Line 29675: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

29671: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
29672:
29673: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
29674: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
29675: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
29676:
29677: l_array_source_1 t_array_source_1;
29678: l_array_source_2 t_array_source_2;
29679: l_array_source_3 t_array_source_3;

Line 29818: , CST_XLA_INV_LINES_V l2

29814: , l2.ACCOUNTING_LINE_TYPE_CODE source_7
29815: , l2.DISTRIBUTION_IDENTIFIER source_8
29816: , l2.CURRENCY_CODE source_11
29817: FROM xla_events_gt xet
29818: , CST_XLA_INV_LINES_V l2
29819: WHERE xet.event_id between x_first_event_id and x_last_event_id
29820: and xet.event_date between p_pad_start_date and p_pad_end_date
29821: and xet.event_type_code = C_EVENT_TYPE_CODE
29822: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 32149: WHEN 1 THEN 'CST_XLA_INV_LINES_V'

32145: FROM (
32146: SELECT xet.event_id event_id
32147: , l2.line_number line_number
32148: , CASE r
32149: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
32150: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
32151: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
32152:
32153: ELSE null

Line 32150: WHEN 2 THEN 'CST_XLA_INV_LINES_V'

32146: SELECT xet.event_id event_id
32147: , l2.line_number line_number
32148: , CASE r
32149: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
32150: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
32151: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
32152:
32153: ELSE null
32154: END object_name

Line 32151: WHEN 3 THEN 'CST_XLA_INV_LINES_V'

32147: , l2.line_number line_number
32148: , CASE r
32149: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
32150: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
32151: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
32152:
32153: ELSE null
32154: END object_name
32155: , CASE r

Line 32186: , CST_XLA_INV_LINES_V l2

32182: ELSE null
32183: END source_value
32184: , null source_meaning
32185: FROM xla_events_gt xet
32186: , CST_XLA_INV_LINES_V l2
32187: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
32188: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
32189: AND xet.event_type_code = C_EVENT_TYPE_CODE
32190: AND l2.event_id = xet.event_id

Line 32345: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

32341: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
32342: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
32343: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
32344:
32345: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
32346: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
32347: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
32348:
32349: l_array_source_1 t_array_source_1;

Line 32346: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

32342: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
32343: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
32344:
32345: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
32346: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
32347: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
32348:
32349: l_array_source_1 t_array_source_1;
32350: l_array_source_2 t_array_source_2;

Line 32347: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

32343: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
32344:
32345: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
32346: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
32347: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
32348:
32349: l_array_source_1 t_array_source_1;
32350: l_array_source_2 t_array_source_2;
32351: l_array_source_3 t_array_source_3;

Line 32490: , CST_XLA_INV_LINES_V l2

32486: , l2.ACCOUNTING_LINE_TYPE_CODE source_7
32487: , l2.DISTRIBUTION_IDENTIFIER source_8
32488: , l2.CURRENCY_CODE source_11
32489: FROM xla_events_gt xet
32490: , CST_XLA_INV_LINES_V l2
32491: WHERE xet.event_id between x_first_event_id and x_last_event_id
32492: and xet.event_date between p_pad_start_date and p_pad_end_date
32493: and xet.event_type_code = C_EVENT_TYPE_CODE
32494: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 33525: WHEN 1 THEN 'CST_XLA_INV_LINES_V'

33521: FROM (
33522: SELECT xet.event_id event_id
33523: , l2.line_number line_number
33524: , CASE r
33525: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
33526: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
33527: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
33528:
33529: ELSE null

Line 33526: WHEN 2 THEN 'CST_XLA_INV_LINES_V'

33522: SELECT xet.event_id event_id
33523: , l2.line_number line_number
33524: , CASE r
33525: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
33526: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
33527: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
33528:
33529: ELSE null
33530: END object_name

Line 33527: WHEN 3 THEN 'CST_XLA_INV_LINES_V'

33523: , l2.line_number line_number
33524: , CASE r
33525: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
33526: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
33527: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
33528:
33529: ELSE null
33530: END object_name
33531: , CASE r

Line 33562: , CST_XLA_INV_LINES_V l2

33558: ELSE null
33559: END source_value
33560: , null source_meaning
33561: FROM xla_events_gt xet
33562: , CST_XLA_INV_LINES_V l2
33563: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
33564: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
33565: AND xet.event_type_code = C_EVENT_TYPE_CODE
33566: AND l2.event_id = xet.event_id

Line 33721: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

33717: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
33718: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
33719: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
33720:
33721: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
33722: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
33723: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
33724:
33725: l_array_source_1 t_array_source_1;

Line 33722: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

33718: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
33719: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
33720:
33721: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
33722: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
33723: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
33724:
33725: l_array_source_1 t_array_source_1;
33726: l_array_source_2 t_array_source_2;

Line 33723: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

33719: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
33720:
33721: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
33722: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
33723: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
33724:
33725: l_array_source_1 t_array_source_1;
33726: l_array_source_2 t_array_source_2;
33727: l_array_source_3 t_array_source_3;

Line 33866: , CST_XLA_INV_LINES_V l2

33862: , l2.ACCOUNTING_LINE_TYPE_CODE source_7
33863: , l2.DISTRIBUTION_IDENTIFIER source_8
33864: , l2.CURRENCY_CODE source_11
33865: FROM xla_events_gt xet
33866: , CST_XLA_INV_LINES_V l2
33867: WHERE xet.event_id between x_first_event_id and x_last_event_id
33868: and xet.event_date between p_pad_start_date and p_pad_end_date
33869: and xet.event_type_code = C_EVENT_TYPE_CODE
33870: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 34901: WHEN 1 THEN 'CST_XLA_INV_LINES_V'

34897: FROM (
34898: SELECT xet.event_id event_id
34899: , l2.line_number line_number
34900: , CASE r
34901: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
34902: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
34903: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
34904:
34905: ELSE null

Line 34902: WHEN 2 THEN 'CST_XLA_INV_LINES_V'

34898: SELECT xet.event_id event_id
34899: , l2.line_number line_number
34900: , CASE r
34901: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
34902: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
34903: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
34904:
34905: ELSE null
34906: END object_name

Line 34903: WHEN 3 THEN 'CST_XLA_INV_LINES_V'

34899: , l2.line_number line_number
34900: , CASE r
34901: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
34902: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
34903: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
34904:
34905: ELSE null
34906: END object_name
34907: , CASE r

Line 34938: , CST_XLA_INV_LINES_V l2

34934: ELSE null
34935: END source_value
34936: , null source_meaning
34937: FROM xla_events_gt xet
34938: , CST_XLA_INV_LINES_V l2
34939: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
34940: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
34941: AND xet.event_type_code = C_EVENT_TYPE_CODE
34942: AND l2.event_id = xet.event_id

Line 35097: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

35093: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
35094: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
35095: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
35096:
35097: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
35098: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
35099: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
35100:
35101: l_array_source_1 t_array_source_1;

Line 35098: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

35094: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
35095: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
35096:
35097: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
35098: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
35099: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
35100:
35101: l_array_source_1 t_array_source_1;
35102: l_array_source_2 t_array_source_2;

Line 35099: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

35095: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
35096:
35097: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
35098: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
35099: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
35100:
35101: l_array_source_1 t_array_source_1;
35102: l_array_source_2 t_array_source_2;
35103: l_array_source_3 t_array_source_3;

Line 35242: , CST_XLA_INV_LINES_V l2

35238: , l2.ACCOUNTING_LINE_TYPE_CODE source_7
35239: , l2.DISTRIBUTION_IDENTIFIER source_8
35240: , l2.CURRENCY_CODE source_11
35241: FROM xla_events_gt xet
35242: , CST_XLA_INV_LINES_V l2
35243: WHERE xet.event_id between x_first_event_id and x_last_event_id
35244: and xet.event_date between p_pad_start_date and p_pad_end_date
35245: and xet.event_type_code = C_EVENT_TYPE_CODE
35246: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id