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_PKG dependencies on CST_XLA_RCV_LINES_V

Line 313834: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'

313830: FROM (
313831: SELECT xet.event_id event_id
313832: , l2.line_number line_number
313833: , CASE r
313834: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
313835: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
313836: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
313837: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
313838: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

Line 313835: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'

313831: SELECT xet.event_id event_id
313832: , l2.line_number line_number
313833: , CASE r
313834: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
313835: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
313836: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
313837: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
313838: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
313839:

Line 313836: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'

313832: , l2.line_number line_number
313833: , CASE r
313834: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
313835: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
313836: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
313837: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
313838: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
313839:
313840: ELSE null

Line 313837: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'

313833: , CASE r
313834: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
313835: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
313836: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
313837: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
313838: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
313839:
313840: ELSE null
313841: END object_name

Line 313838: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

313834: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
313835: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
313836: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
313837: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
313838: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
313839:
313840: ELSE null
313841: END object_name
313842: , CASE r

Line 313881: , CST_XLA_RCV_LINES_V l2

313877: ELSE null
313878: END source_value
313879: , null source_meaning
313880: FROM xla_events_gt xet
313881: , CST_XLA_RCV_LINES_V l2
313882: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
313883: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
313884: AND xet.event_class_code = C_EVENT_CLASS_CODE
313885: AND l2.event_id = xet.event_id

Line 314036: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

314032: TYPE t_array_source_96 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
314033: TYPE t_array_source_100 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
314034: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
314035:
314036: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
314037: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
314038: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
314039: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
314040: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 314037: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

314033: TYPE t_array_source_100 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
314034: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
314035:
314036: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
314037: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
314038: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
314039: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
314040: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
314041:

Line 314038: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

314034: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
314035:
314036: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
314037: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
314038: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
314039: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
314040: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
314041:
314042: l_array_source_79 t_array_source_79;

Line 314039: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

314035:
314036: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
314037: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
314038: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
314039: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
314040: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
314041:
314042: l_array_source_79 t_array_source_79;
314043: l_array_source_80 t_array_source_80;

Line 314040: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

314036: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
314037: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
314038: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
314039: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
314040: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
314041:
314042: l_array_source_79 t_array_source_79;
314043: l_array_source_80 t_array_source_80;
314044: l_array_source_81 t_array_source_81;

Line 314174: , CST_XLA_RCV_LINES_V l2

314170: , l2.DISTRIBUTION_IDENTIFIER source_84
314171: , l2.ENTERED_AMOUNT source_91
314172: , l2.ACCOUNTED_AMOUNT source_95
314173: FROM xla_events_gt xet
314174: , CST_XLA_RCV_LINES_V l2
314175: WHERE xet.event_id between x_first_event_id and x_last_event_id
314176: and xet.event_date between p_pad_start_date and p_pad_end_date
314177: and xet.event_class_code = C_EVENT_CLASS_CODE
314178: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 349368: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'

349364: FROM (
349365: SELECT xet.event_id event_id
349366: , l2.line_number line_number
349367: , CASE r
349368: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
349369: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
349370: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
349371: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
349372: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

Line 349369: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'

349365: SELECT xet.event_id event_id
349366: , l2.line_number line_number
349367: , CASE r
349368: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
349369: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
349370: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
349371: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
349372: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
349373:

Line 349370: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'

349366: , l2.line_number line_number
349367: , CASE r
349368: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
349369: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
349370: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
349371: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
349372: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
349373:
349374: ELSE null

Line 349371: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'

349367: , CASE r
349368: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
349369: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
349370: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
349371: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
349372: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
349373:
349374: ELSE null
349375: END object_name

Line 349372: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

349368: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
349369: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
349370: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
349371: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
349372: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
349373:
349374: ELSE null
349375: END object_name
349376: , CASE r

Line 349415: , CST_XLA_RCV_LINES_V l2

349411: ELSE null
349412: END source_value
349413: , null source_meaning
349414: FROM xla_events_gt xet
349415: , CST_XLA_RCV_LINES_V l2
349416: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
349417: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
349418: AND xet.event_class_code = C_EVENT_CLASS_CODE
349419: AND l2.event_id = xet.event_id

Line 349559: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

349555: TYPE t_array_source_106 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
349556: TYPE t_array_source_107 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
349557: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
349558:
349559: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
349560: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
349561: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
349562: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
349563: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 349560: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

349556: TYPE t_array_source_107 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
349557: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
349558:
349559: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
349560: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
349561: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
349562: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
349563: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
349564:

Line 349561: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

349557: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
349558:
349559: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
349560: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
349561: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
349562: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
349563: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
349564:
349565: l_array_source_85 t_array_source_85;

Line 349562: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

349558:
349559: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
349560: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
349561: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
349562: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
349563: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
349564:
349565: l_array_source_85 t_array_source_85;
349566: l_array_source_85_meaning t_array_lookup_meaning;

Line 349563: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

349559: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
349560: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
349561: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
349562: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
349563: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
349564:
349565: l_array_source_85 t_array_source_85;
349566: l_array_source_85_meaning t_array_lookup_meaning;
349567: l_array_source_105 t_array_source_105;

Line 349673: , CST_XLA_RCV_LINES_V l2

349669: , l2.DISTRIBUTION_IDENTIFIER source_84
349670: , l2.ENTERED_AMOUNT source_91
349671: , l2.ACCOUNTED_AMOUNT source_95
349672: FROM xla_events_gt xet
349673: , CST_XLA_RCV_LINES_V l2
349674: WHERE xet.event_id between x_first_event_id and x_last_event_id
349675: and xet.event_date between p_pad_start_date and p_pad_end_date
349676: and xet.event_class_code = C_EVENT_CLASS_CODE
349677: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 350632: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'

350628: FROM (
350629: SELECT xet.event_id event_id
350630: , l2.line_number line_number
350631: , CASE r
350632: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
350633: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
350634: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
350635: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
350636: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

Line 350633: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'

350629: SELECT xet.event_id event_id
350630: , l2.line_number line_number
350631: , CASE r
350632: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
350633: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
350634: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
350635: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
350636: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
350637:

Line 350634: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'

350630: , l2.line_number line_number
350631: , CASE r
350632: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
350633: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
350634: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
350635: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
350636: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
350637:
350638: ELSE null

Line 350635: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'

350631: , CASE r
350632: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
350633: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
350634: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
350635: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
350636: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
350637:
350638: ELSE null
350639: END object_name

Line 350636: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

350632: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
350633: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
350634: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
350635: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
350636: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
350637:
350638: ELSE null
350639: END object_name
350640: , CASE r

Line 350679: , CST_XLA_RCV_LINES_V l2

350675: ELSE null
350676: END source_value
350677: , null source_meaning
350678: FROM xla_events_gt xet
350679: , CST_XLA_RCV_LINES_V l2
350680: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
350681: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
350682: AND xet.event_class_code = C_EVENT_CLASS_CODE
350683: AND l2.event_id = xet.event_id

Line 350824: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

350820: TYPE t_array_source_107 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
350821: TYPE t_array_source_109 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
350822: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
350823:
350824: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
350825: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
350826: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
350827: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
350828: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 350825: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

350821: TYPE t_array_source_109 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
350822: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
350823:
350824: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
350825: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
350826: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
350827: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
350828: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
350829:

Line 350826: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

350822: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
350823:
350824: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
350825: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
350826: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
350827: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
350828: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
350829:
350830: l_array_source_85 t_array_source_85;

Line 350827: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

350823:
350824: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
350825: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
350826: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
350827: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
350828: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
350829:
350830: l_array_source_85 t_array_source_85;
350831: l_array_source_85_meaning t_array_lookup_meaning;

Line 350828: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

350824: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
350825: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
350826: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
350827: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
350828: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
350829:
350830: l_array_source_85 t_array_source_85;
350831: l_array_source_85_meaning t_array_lookup_meaning;
350832: l_array_source_105 t_array_source_105;

Line 350940: , CST_XLA_RCV_LINES_V l2

350936: , l2.DISTRIBUTION_IDENTIFIER source_84
350937: , l2.ENTERED_AMOUNT source_91
350938: , l2.ACCOUNTED_AMOUNT source_95
350939: FROM xla_events_gt xet
350940: , CST_XLA_RCV_LINES_V l2
350941: WHERE xet.event_id between x_first_event_id and x_last_event_id
350942: and xet.event_date between p_pad_start_date and p_pad_end_date
350943: and xet.event_class_code = C_EVENT_CLASS_CODE
350944: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 370605: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'

370601: FROM (
370602: SELECT xet.event_id event_id
370603: , l2.line_number line_number
370604: , CASE r
370605: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
370606: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
370607: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
370608: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
370609: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

Line 370606: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'

370602: SELECT xet.event_id event_id
370603: , l2.line_number line_number
370604: , CASE r
370605: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
370606: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
370607: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
370608: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
370609: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
370610:

Line 370607: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'

370603: , l2.line_number line_number
370604: , CASE r
370605: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
370606: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
370607: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
370608: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
370609: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
370610:
370611: ELSE null

Line 370608: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'

370604: , CASE r
370605: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
370606: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
370607: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
370608: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
370609: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
370610:
370611: ELSE null
370612: END object_name

Line 370609: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

370605: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
370606: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
370607: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
370608: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
370609: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
370610:
370611: ELSE null
370612: END object_name
370613: , CASE r

Line 370652: , CST_XLA_RCV_LINES_V l2

370648: ELSE null
370649: END source_value
370650: , null source_meaning
370651: FROM xla_events_gt xet
370652: , CST_XLA_RCV_LINES_V l2
370653: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
370654: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
370655: AND xet.event_class_code = C_EVENT_CLASS_CODE
370656: AND l2.event_id = xet.event_id

Line 370807: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

370803: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
370804: TYPE t_array_source_96 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
370805: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
370806:
370807: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
370808: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
370809: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
370810: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
370811: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 370808: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

370804: TYPE t_array_source_96 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
370805: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
370806:
370807: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
370808: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
370809: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
370810: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
370811: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
370812:

Line 370809: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

370805: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
370806:
370807: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
370808: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
370809: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
370810: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
370811: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
370812:
370813: l_array_source_79 t_array_source_79;

Line 370810: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

370806:
370807: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
370808: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
370809: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
370810: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
370811: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
370812:
370813: l_array_source_79 t_array_source_79;
370814: l_array_source_80 t_array_source_80;

Line 370811: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

370807: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
370808: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
370809: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
370810: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
370811: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
370812:
370813: l_array_source_79 t_array_source_79;
370814: l_array_source_80 t_array_source_80;
370815: l_array_source_81 t_array_source_81;

Line 370945: , CST_XLA_RCV_LINES_V l2

370941: , l2.DISTRIBUTION_IDENTIFIER source_84
370942: , l2.ENTERED_AMOUNT source_91
370943: , l2.ACCOUNTED_AMOUNT source_95
370944: FROM xla_events_gt xet
370945: , CST_XLA_RCV_LINES_V l2
370946: WHERE xet.event_id between x_first_event_id and x_last_event_id
370947: and xet.event_date between p_pad_start_date and p_pad_end_date
370948: and xet.event_class_code = C_EVENT_CLASS_CODE
370949: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 375780: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'

375776: FROM (
375777: SELECT xet.event_id event_id
375778: , l2.line_number line_number
375779: , CASE r
375780: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
375781: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
375782: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
375783: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
375784: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

Line 375781: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'

375777: SELECT xet.event_id event_id
375778: , l2.line_number line_number
375779: , CASE r
375780: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
375781: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
375782: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
375783: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
375784: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
375785:

Line 375782: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'

375778: , l2.line_number line_number
375779: , CASE r
375780: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
375781: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
375782: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
375783: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
375784: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
375785:
375786: ELSE null

Line 375783: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'

375779: , CASE r
375780: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
375781: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
375782: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
375783: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
375784: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
375785:
375786: ELSE null
375787: END object_name

Line 375784: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

375780: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
375781: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
375782: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
375783: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
375784: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
375785:
375786: ELSE null
375787: END object_name
375788: , CASE r

Line 375827: , CST_XLA_RCV_LINES_V l2

375823: ELSE null
375824: END source_value
375825: , null source_meaning
375826: FROM xla_events_gt xet
375827: , CST_XLA_RCV_LINES_V l2
375828: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
375829: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
375830: AND xet.event_class_code = C_EVENT_CLASS_CODE
375831: AND l2.event_id = xet.event_id

Line 375972: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

375968: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
375969: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
375970: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
375971:
375972: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
375973: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
375974: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
375975: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
375976: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 375973: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

375969: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
375970: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
375971:
375972: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
375973: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
375974: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
375975: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
375976: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
375977:

Line 375974: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

375970: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
375971:
375972: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
375973: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
375974: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
375975: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
375976: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
375977:
375978: l_array_source_85 t_array_source_85;

Line 375975: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

375971:
375972: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
375973: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
375974: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
375975: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
375976: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
375977:
375978: l_array_source_85 t_array_source_85;
375979: l_array_source_85_meaning t_array_lookup_meaning;

Line 375976: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

375972: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
375973: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
375974: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
375975: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
375976: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
375977:
375978: l_array_source_85 t_array_source_85;
375979: l_array_source_85_meaning t_array_lookup_meaning;
375980: l_array_source_88 t_array_source_88;

Line 376086: , CST_XLA_RCV_LINES_V l2

376082: , l2.DISTRIBUTION_IDENTIFIER source_84
376083: , l2.ENTERED_AMOUNT source_91
376084: , l2.ACCOUNTED_AMOUNT source_95
376085: FROM xla_events_gt xet
376086: , CST_XLA_RCV_LINES_V l2
376087: WHERE xet.event_id between x_first_event_id and x_last_event_id
376088: and xet.event_date between p_pad_start_date and p_pad_end_date
376089: and xet.event_class_code = C_EVENT_CLASS_CODE
376090: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 378380: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'

378376: FROM (
378377: SELECT xet.event_id event_id
378378: , l2.line_number line_number
378379: , CASE r
378380: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
378381: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
378382: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
378383: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
378384: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

Line 378381: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'

378377: SELECT xet.event_id event_id
378378: , l2.line_number line_number
378379: , CASE r
378380: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
378381: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
378382: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
378383: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
378384: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
378385:

Line 378382: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'

378378: , l2.line_number line_number
378379: , CASE r
378380: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
378381: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
378382: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
378383: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
378384: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
378385:
378386: ELSE null

Line 378383: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'

378379: , CASE r
378380: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
378381: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
378382: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
378383: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
378384: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
378385:
378386: ELSE null
378387: END object_name

Line 378384: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

378380: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
378381: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
378382: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
378383: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
378384: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
378385:
378386: ELSE null
378387: END object_name
378388: , CASE r

Line 378427: , CST_XLA_RCV_LINES_V l2

378423: ELSE null
378424: END source_value
378425: , null source_meaning
378426: FROM xla_events_gt xet
378427: , CST_XLA_RCV_LINES_V l2
378428: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
378429: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
378430: AND xet.event_class_code = C_EVENT_CLASS_CODE
378431: AND l2.event_id = xet.event_id

Line 378571: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

378567: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
378568: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
378569: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
378570:
378571: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
378572: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
378573: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
378574: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
378575: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 378572: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

378568: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
378569: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
378570:
378571: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
378572: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
378573: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
378574: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
378575: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
378576:

Line 378573: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

378569: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
378570:
378571: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
378572: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
378573: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
378574: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
378575: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
378576:
378577: l_array_source_85 t_array_source_85;

Line 378574: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

378570:
378571: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
378572: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
378573: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
378574: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
378575: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
378576:
378577: l_array_source_85 t_array_source_85;
378578: l_array_source_85_meaning t_array_lookup_meaning;

Line 378575: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

378571: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
378572: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
378573: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
378574: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
378575: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
378576:
378577: l_array_source_85 t_array_source_85;
378578: l_array_source_85_meaning t_array_lookup_meaning;
378579: l_array_source_88 t_array_source_88;

Line 378683: , CST_XLA_RCV_LINES_V l2

378679: , l2.DISTRIBUTION_IDENTIFIER source_84
378680: , l2.ENTERED_AMOUNT source_91
378681: , l2.ACCOUNTED_AMOUNT source_95
378682: FROM xla_events_gt xet
378683: , CST_XLA_RCV_LINES_V l2
378684: WHERE xet.event_id between x_first_event_id and x_last_event_id
378685: and xet.event_date between p_pad_start_date and p_pad_end_date
378686: and xet.event_class_code = C_EVENT_CLASS_CODE
378687: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 379612: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'

379608: FROM (
379609: SELECT xet.event_id event_id
379610: , l2.line_number line_number
379611: , CASE r
379612: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
379613: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
379614: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
379615: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
379616: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

Line 379613: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'

379609: SELECT xet.event_id event_id
379610: , l2.line_number line_number
379611: , CASE r
379612: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
379613: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
379614: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
379615: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
379616: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
379617:

Line 379614: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'

379610: , l2.line_number line_number
379611: , CASE r
379612: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
379613: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
379614: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
379615: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
379616: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
379617:
379618: ELSE null

Line 379615: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'

379611: , CASE r
379612: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
379613: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
379614: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
379615: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
379616: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
379617:
379618: ELSE null
379619: END object_name

Line 379616: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

379612: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
379613: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
379614: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
379615: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
379616: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
379617:
379618: ELSE null
379619: END object_name
379620: , CASE r

Line 379659: , CST_XLA_RCV_LINES_V l2

379655: ELSE null
379656: END source_value
379657: , null source_meaning
379658: FROM xla_events_gt xet
379659: , CST_XLA_RCV_LINES_V l2
379660: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
379661: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
379662: AND xet.event_class_code = C_EVENT_CLASS_CODE
379663: AND l2.event_id = xet.event_id

Line 379804: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

379800: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
379801: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
379802: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
379803:
379804: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
379805: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
379806: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
379807: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
379808: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 379805: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

379801: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
379802: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
379803:
379804: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
379805: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
379806: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
379807: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
379808: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
379809:

Line 379806: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

379802: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
379803:
379804: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
379805: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
379806: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
379807: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
379808: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
379809:
379810: l_array_source_85 t_array_source_85;

Line 379807: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

379803:
379804: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
379805: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
379806: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
379807: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
379808: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
379809:
379810: l_array_source_85 t_array_source_85;
379811: l_array_source_85_meaning t_array_lookup_meaning;

Line 379808: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

379804: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
379805: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
379806: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
379807: TYPE t_array_source_91 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
379808: TYPE t_array_source_95 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
379809:
379810: l_array_source_85 t_array_source_85;
379811: l_array_source_85_meaning t_array_lookup_meaning;
379812: l_array_source_88 t_array_source_88;

Line 379918: , CST_XLA_RCV_LINES_V l2

379914: , l2.DISTRIBUTION_IDENTIFIER source_84
379915: , l2.ENTERED_AMOUNT source_91
379916: , l2.ACCOUNTED_AMOUNT source_95
379917: FROM xla_events_gt xet
379918: , CST_XLA_RCV_LINES_V l2
379919: WHERE xet.event_id between x_first_event_id and x_last_event_id
379920: and xet.event_date between p_pad_start_date and p_pad_end_date
379921: and xet.event_class_code = C_EVENT_CLASS_CODE
379922: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id