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

Line 142241: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'

142237: FROM (
142238: SELECT xet.event_id event_id
142239: , l2.line_number line_number
142240: , CASE r
142241: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
142242: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
142243: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
142244: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
142245: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

Line 142242: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'

142238: SELECT xet.event_id event_id
142239: , l2.line_number line_number
142240: , CASE r
142241: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
142242: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
142243: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
142244: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
142245: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
142246:

Line 142243: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'

142239: , l2.line_number line_number
142240: , CASE r
142241: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
142242: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
142243: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
142244: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
142245: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
142246:
142247: ELSE null

Line 142244: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'

142240: , CASE r
142241: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
142242: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
142243: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
142244: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
142245: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
142246:
142247: ELSE null
142248: END object_name

Line 142245: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

142241: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
142242: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
142243: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
142244: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
142245: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
142246:
142247: ELSE null
142248: END object_name
142249: , CASE r

Line 142288: , CST_XLA_RCV_LINES_V l2

142284: ELSE null
142285: END source_value
142286: , null source_meaning
142287: FROM xla_events_gt xet
142288: , CST_XLA_RCV_LINES_V l2
142289: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
142290: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
142291: AND xet.event_class_code = C_EVENT_CLASS_CODE
142292: AND l2.event_id = xet.event_id

Line 142443: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

142439: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
142440: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
142441: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
142442:
142443: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
142444: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
142445: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
142446: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
142447: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 142444: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

142440: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
142441: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
142442:
142443: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
142444: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
142445: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
142446: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
142447: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
142448:

Line 142445: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

142441: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
142442:
142443: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
142444: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
142445: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
142446: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
142447: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
142448:
142449: l_array_source_6 t_array_source_6;

Line 142446: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

142442:
142443: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
142444: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
142445: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
142446: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
142447: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
142448:
142449: l_array_source_6 t_array_source_6;
142450: l_array_source_7 t_array_source_7;

Line 142447: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

142443: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
142444: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
142445: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
142446: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
142447: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
142448:
142449: l_array_source_6 t_array_source_6;
142450: l_array_source_7 t_array_source_7;
142451: l_array_source_8 t_array_source_8;

Line 142581: , CST_XLA_RCV_LINES_V l2

142577: , l2.DISTRIBUTION_IDENTIFIER source_11
142578: , l2.ENTERED_AMOUNT source_18
142579: , l2.ACCOUNTED_AMOUNT source_22
142580: FROM xla_events_gt xet
142581: , CST_XLA_RCV_LINES_V l2
142582: WHERE xet.event_id between x_first_event_id and x_last_event_id
142583: and xet.event_date between p_pad_start_date and p_pad_end_date
142584: and xet.event_class_code = C_EVENT_CLASS_CODE
142585: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 157343: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'

157339: FROM (
157340: SELECT xet.event_id event_id
157341: , l2.line_number line_number
157342: , CASE r
157343: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
157344: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
157345: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
157346: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
157347: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

Line 157344: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'

157340: SELECT xet.event_id event_id
157341: , l2.line_number line_number
157342: , CASE r
157343: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
157344: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
157345: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
157346: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
157347: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
157348:

Line 157345: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'

157341: , l2.line_number line_number
157342: , CASE r
157343: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
157344: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
157345: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
157346: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
157347: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
157348:
157349: ELSE null

Line 157346: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'

157342: , CASE r
157343: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
157344: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
157345: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
157346: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
157347: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
157348:
157349: ELSE null
157350: END object_name

Line 157347: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

157343: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
157344: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
157345: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
157346: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
157347: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
157348:
157349: ELSE null
157350: END object_name
157351: , CASE r

Line 157390: , CST_XLA_RCV_LINES_V l2

157386: ELSE null
157387: END source_value
157388: , null source_meaning
157389: FROM xla_events_gt xet
157390: , CST_XLA_RCV_LINES_V l2
157391: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
157392: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
157393: AND xet.event_class_code = C_EVENT_CLASS_CODE
157394: AND l2.event_id = xet.event_id

Line 157534: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

157530: TYPE t_array_source_33 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
157531: TYPE t_array_source_34 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
157532: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
157533:
157534: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
157535: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
157536: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
157537: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
157538: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 157535: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

157531: TYPE t_array_source_34 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
157532: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
157533:
157534: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
157535: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
157536: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
157537: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
157538: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
157539:

Line 157536: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

157532: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
157533:
157534: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
157535: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
157536: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
157537: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
157538: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
157539:
157540: l_array_source_12 t_array_source_12;

Line 157537: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

157533:
157534: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
157535: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
157536: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
157537: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
157538: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
157539:
157540: l_array_source_12 t_array_source_12;
157541: l_array_source_12_meaning t_array_lookup_meaning;

Line 157538: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

157534: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
157535: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
157536: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
157537: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
157538: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
157539:
157540: l_array_source_12 t_array_source_12;
157541: l_array_source_12_meaning t_array_lookup_meaning;
157542: l_array_source_32 t_array_source_32;

Line 157648: , CST_XLA_RCV_LINES_V l2

157644: , l2.DISTRIBUTION_IDENTIFIER source_11
157645: , l2.ENTERED_AMOUNT source_18
157646: , l2.ACCOUNTED_AMOUNT source_22
157647: FROM xla_events_gt xet
157648: , CST_XLA_RCV_LINES_V l2
157649: WHERE xet.event_id between x_first_event_id and x_last_event_id
157650: and xet.event_date between p_pad_start_date and p_pad_end_date
157651: and xet.event_class_code = C_EVENT_CLASS_CODE
157652: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 158607: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'

158603: FROM (
158604: SELECT xet.event_id event_id
158605: , l2.line_number line_number
158606: , CASE r
158607: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
158608: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
158609: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
158610: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
158611: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

Line 158608: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'

158604: SELECT xet.event_id event_id
158605: , l2.line_number line_number
158606: , CASE r
158607: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
158608: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
158609: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
158610: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
158611: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
158612:

Line 158609: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'

158605: , l2.line_number line_number
158606: , CASE r
158607: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
158608: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
158609: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
158610: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
158611: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
158612:
158613: ELSE null

Line 158610: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'

158606: , CASE r
158607: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
158608: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
158609: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
158610: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
158611: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
158612:
158613: ELSE null
158614: END object_name

Line 158611: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

158607: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
158608: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
158609: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
158610: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
158611: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
158612:
158613: ELSE null
158614: END object_name
158615: , CASE r

Line 158654: , CST_XLA_RCV_LINES_V l2

158650: ELSE null
158651: END source_value
158652: , null source_meaning
158653: FROM xla_events_gt xet
158654: , CST_XLA_RCV_LINES_V l2
158655: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
158656: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
158657: AND xet.event_class_code = C_EVENT_CLASS_CODE
158658: AND l2.event_id = xet.event_id

Line 158799: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

158795: TYPE t_array_source_34 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
158796: TYPE t_array_source_36 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
158797: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
158798:
158799: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
158800: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
158801: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
158802: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
158803: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 158800: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

158796: TYPE t_array_source_36 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
158797: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
158798:
158799: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
158800: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
158801: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
158802: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
158803: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
158804:

Line 158801: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

158797: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
158798:
158799: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
158800: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
158801: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
158802: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
158803: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
158804:
158805: l_array_source_12 t_array_source_12;

Line 158802: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

158798:
158799: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
158800: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
158801: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
158802: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
158803: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
158804:
158805: l_array_source_12 t_array_source_12;
158806: l_array_source_12_meaning t_array_lookup_meaning;

Line 158803: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

158799: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
158800: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
158801: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
158802: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
158803: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
158804:
158805: l_array_source_12 t_array_source_12;
158806: l_array_source_12_meaning t_array_lookup_meaning;
158807: l_array_source_32 t_array_source_32;

Line 158915: , CST_XLA_RCV_LINES_V l2

158911: , l2.DISTRIBUTION_IDENTIFIER source_11
158912: , l2.ENTERED_AMOUNT source_18
158913: , l2.ACCOUNTED_AMOUNT source_22
158914: FROM xla_events_gt xet
158915: , CST_XLA_RCV_LINES_V l2
158916: WHERE xet.event_id between x_first_event_id and x_last_event_id
158917: and xet.event_date between p_pad_start_date and p_pad_end_date
158918: and xet.event_class_code = C_EVENT_CLASS_CODE
158919: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 163744: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'

163740: FROM (
163741: SELECT xet.event_id event_id
163742: , l2.line_number line_number
163743: , CASE r
163744: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
163745: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
163746: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
163747: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
163748: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

Line 163745: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'

163741: SELECT xet.event_id event_id
163742: , l2.line_number line_number
163743: , CASE r
163744: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
163745: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
163746: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
163747: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
163748: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
163749:

Line 163746: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'

163742: , l2.line_number line_number
163743: , CASE r
163744: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
163745: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
163746: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
163747: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
163748: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
163749:
163750: ELSE null

Line 163747: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'

163743: , CASE r
163744: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
163745: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
163746: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
163747: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
163748: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
163749:
163750: ELSE null
163751: END object_name

Line 163748: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

163744: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
163745: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
163746: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
163747: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
163748: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
163749:
163750: ELSE null
163751: END object_name
163752: , CASE r

Line 163791: , CST_XLA_RCV_LINES_V l2

163787: ELSE null
163788: END source_value
163789: , null source_meaning
163790: FROM xla_events_gt xet
163791: , CST_XLA_RCV_LINES_V l2
163792: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
163793: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
163794: AND xet.event_class_code = C_EVENT_CLASS_CODE
163795: AND l2.event_id = xet.event_id

Line 163946: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

163942: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
163943: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
163944: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
163945:
163946: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
163947: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
163948: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
163949: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
163950: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 163947: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

163943: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
163944: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
163945:
163946: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
163947: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
163948: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
163949: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
163950: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
163951:

Line 163948: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

163944: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
163945:
163946: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
163947: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
163948: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
163949: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
163950: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
163951:
163952: l_array_source_6 t_array_source_6;

Line 163949: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

163945:
163946: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
163947: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
163948: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
163949: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
163950: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
163951:
163952: l_array_source_6 t_array_source_6;
163953: l_array_source_7 t_array_source_7;

Line 163950: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

163946: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
163947: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
163948: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
163949: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
163950: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
163951:
163952: l_array_source_6 t_array_source_6;
163953: l_array_source_7 t_array_source_7;
163954: l_array_source_8 t_array_source_8;

Line 164084: , CST_XLA_RCV_LINES_V l2

164080: , l2.DISTRIBUTION_IDENTIFIER source_11
164081: , l2.ENTERED_AMOUNT source_18
164082: , l2.ACCOUNTED_AMOUNT source_22
164083: FROM xla_events_gt xet
164084: , CST_XLA_RCV_LINES_V l2
164085: WHERE xet.event_id between x_first_event_id and x_last_event_id
164086: and xet.event_date between p_pad_start_date and p_pad_end_date
164087: and xet.event_class_code = C_EVENT_CLASS_CODE
164088: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 166648: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'

166644: FROM (
166645: SELECT xet.event_id event_id
166646: , l2.line_number line_number
166647: , CASE r
166648: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
166649: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
166650: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
166651: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
166652: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

Line 166649: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'

166645: SELECT xet.event_id event_id
166646: , l2.line_number line_number
166647: , CASE r
166648: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
166649: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
166650: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
166651: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
166652: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
166653:

Line 166650: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'

166646: , l2.line_number line_number
166647: , CASE r
166648: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
166649: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
166650: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
166651: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
166652: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
166653:
166654: ELSE null

Line 166651: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'

166647: , CASE r
166648: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
166649: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
166650: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
166651: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
166652: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
166653:
166654: ELSE null
166655: END object_name

Line 166652: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

166648: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
166649: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
166650: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
166651: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
166652: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
166653:
166654: ELSE null
166655: END object_name
166656: , CASE r

Line 166695: , CST_XLA_RCV_LINES_V l2

166691: ELSE null
166692: END source_value
166693: , null source_meaning
166694: FROM xla_events_gt xet
166695: , CST_XLA_RCV_LINES_V l2
166696: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
166697: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
166698: AND xet.event_class_code = C_EVENT_CLASS_CODE
166699: AND l2.event_id = xet.event_id

Line 166840: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

166836: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
166837: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
166838: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
166839:
166840: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
166841: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
166842: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
166843: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
166844: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 166841: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

166837: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
166838: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
166839:
166840: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
166841: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
166842: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
166843: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
166844: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
166845:

Line 166842: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

166838: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
166839:
166840: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
166841: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
166842: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
166843: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
166844: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
166845:
166846: l_array_source_12 t_array_source_12;

Line 166843: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

166839:
166840: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
166841: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
166842: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
166843: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
166844: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
166845:
166846: l_array_source_12 t_array_source_12;
166847: l_array_source_12_meaning t_array_lookup_meaning;

Line 166844: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

166840: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
166841: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
166842: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
166843: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
166844: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
166845:
166846: l_array_source_12 t_array_source_12;
166847: l_array_source_12_meaning t_array_lookup_meaning;
166848: l_array_source_15 t_array_source_15;

Line 166954: , CST_XLA_RCV_LINES_V l2

166950: , l2.DISTRIBUTION_IDENTIFIER source_11
166951: , l2.ENTERED_AMOUNT source_18
166952: , l2.ACCOUNTED_AMOUNT source_22
166953: FROM xla_events_gt xet
166954: , CST_XLA_RCV_LINES_V l2
166955: WHERE xet.event_id between x_first_event_id and x_last_event_id
166956: and xet.event_date between p_pad_start_date and p_pad_end_date
166957: and xet.event_class_code = C_EVENT_CLASS_CODE
166958: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 167970: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'

167966: FROM (
167967: SELECT xet.event_id event_id
167968: , l2.line_number line_number
167969: , CASE r
167970: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
167971: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
167972: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
167973: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
167974: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

Line 167971: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'

167967: SELECT xet.event_id event_id
167968: , l2.line_number line_number
167969: , CASE r
167970: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
167971: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
167972: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
167973: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
167974: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
167975:

Line 167972: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'

167968: , l2.line_number line_number
167969: , CASE r
167970: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
167971: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
167972: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
167973: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
167974: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
167975:
167976: ELSE null

Line 167973: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'

167969: , CASE r
167970: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
167971: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
167972: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
167973: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
167974: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
167975:
167976: ELSE null
167977: END object_name

Line 167974: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

167970: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
167971: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
167972: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
167973: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
167974: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
167975:
167976: ELSE null
167977: END object_name
167978: , CASE r

Line 168017: , CST_XLA_RCV_LINES_V l2

168013: ELSE null
168014: END source_value
168015: , null source_meaning
168016: FROM xla_events_gt xet
168017: , CST_XLA_RCV_LINES_V l2
168018: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
168019: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168020: AND xet.event_class_code = C_EVENT_CLASS_CODE
168021: AND l2.event_id = xet.event_id

Line 168161: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

168157: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
168158: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
168159: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
168160:
168161: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
168162: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
168163: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
168164: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
168165: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 168162: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

168158: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
168159: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
168160:
168161: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
168162: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
168163: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
168164: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
168165: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
168166:

Line 168163: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

168159: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
168160:
168161: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
168162: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
168163: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
168164: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
168165: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
168166:
168167: l_array_source_12 t_array_source_12;

Line 168164: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

168160:
168161: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
168162: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
168163: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
168164: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
168165: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
168166:
168167: l_array_source_12 t_array_source_12;
168168: l_array_source_12_meaning t_array_lookup_meaning;

Line 168165: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

168161: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
168162: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
168163: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
168164: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
168165: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
168166:
168167: l_array_source_12 t_array_source_12;
168168: l_array_source_12_meaning t_array_lookup_meaning;
168169: l_array_source_15 t_array_source_15;

Line 168273: , CST_XLA_RCV_LINES_V l2

168269: , l2.DISTRIBUTION_IDENTIFIER source_11
168270: , l2.ENTERED_AMOUNT source_18
168271: , l2.ACCOUNTED_AMOUNT source_22
168272: FROM xla_events_gt xet
168273: , CST_XLA_RCV_LINES_V l2
168274: WHERE xet.event_id between x_first_event_id and x_last_event_id
168275: and xet.event_date between p_pad_start_date and p_pad_end_date
168276: and xet.event_class_code = C_EVENT_CLASS_CODE
168277: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 169202: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'

169198: FROM (
169199: SELECT xet.event_id event_id
169200: , l2.line_number line_number
169201: , CASE r
169202: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
169203: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
169204: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
169205: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
169206: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

Line 169203: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'

169199: SELECT xet.event_id event_id
169200: , l2.line_number line_number
169201: , CASE r
169202: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
169203: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
169204: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
169205: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
169206: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
169207:

Line 169204: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'

169200: , l2.line_number line_number
169201: , CASE r
169202: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
169203: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
169204: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
169205: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
169206: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
169207:
169208: ELSE null

Line 169205: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'

169201: , CASE r
169202: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
169203: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
169204: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
169205: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
169206: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
169207:
169208: ELSE null
169209: END object_name

Line 169206: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

169202: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
169203: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
169204: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
169205: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
169206: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
169207:
169208: ELSE null
169209: END object_name
169210: , CASE r

Line 169249: , CST_XLA_RCV_LINES_V l2

169245: ELSE null
169246: END source_value
169247: , null source_meaning
169248: FROM xla_events_gt xet
169249: , CST_XLA_RCV_LINES_V l2
169250: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
169251: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
169252: AND xet.event_class_code = C_EVENT_CLASS_CODE
169253: AND l2.event_id = xet.event_id

Line 169394: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

169390: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
169391: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
169392: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
169393:
169394: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
169395: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
169396: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
169397: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
169398: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 169395: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

169391: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
169392: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
169393:
169394: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
169395: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
169396: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
169397: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
169398: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
169399:

Line 169396: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

169392: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
169393:
169394: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
169395: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
169396: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
169397: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
169398: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
169399:
169400: l_array_source_12 t_array_source_12;

Line 169397: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

169393:
169394: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
169395: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
169396: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
169397: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
169398: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
169399:
169400: l_array_source_12 t_array_source_12;
169401: l_array_source_12_meaning t_array_lookup_meaning;

Line 169398: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

169394: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
169395: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
169396: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
169397: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
169398: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
169399:
169400: l_array_source_12 t_array_source_12;
169401: l_array_source_12_meaning t_array_lookup_meaning;
169402: l_array_source_15 t_array_source_15;

Line 169508: , CST_XLA_RCV_LINES_V l2

169504: , l2.DISTRIBUTION_IDENTIFIER source_11
169505: , l2.ENTERED_AMOUNT source_18
169506: , l2.ACCOUNTED_AMOUNT source_22
169507: FROM xla_events_gt xet
169508: , CST_XLA_RCV_LINES_V l2
169509: WHERE xet.event_id between x_first_event_id and x_last_event_id
169510: and xet.event_date between p_pad_start_date and p_pad_end_date
169511: and xet.event_class_code = C_EVENT_CLASS_CODE
169512: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id