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_00201_AAD_S_000005_BC_PKG dependencies on PO_EXTRACT_DETAIL_V

Line 51085: WHEN 1 THEN 'PO_EXTRACT_DETAIL_V'

51081: FROM (
51082: SELECT xet.event_id event_id
51083: , l2.line_number line_number
51084: , CASE r
51085: WHEN 1 THEN 'PO_EXTRACT_DETAIL_V'
51086: WHEN 2 THEN 'PO_EXTRACT_DETAIL_V'
51087: WHEN 3 THEN 'PO_EXTRACT_DETAIL_V'
51088: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
51089: WHEN 5 THEN 'PO_EXTRACT_DETAIL_V'

Line 51086: WHEN 2 THEN 'PO_EXTRACT_DETAIL_V'

51082: SELECT xet.event_id event_id
51083: , l2.line_number line_number
51084: , CASE r
51085: WHEN 1 THEN 'PO_EXTRACT_DETAIL_V'
51086: WHEN 2 THEN 'PO_EXTRACT_DETAIL_V'
51087: WHEN 3 THEN 'PO_EXTRACT_DETAIL_V'
51088: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
51089: WHEN 5 THEN 'PO_EXTRACT_DETAIL_V'
51090: WHEN 6 THEN 'PO_EXTRACT_DETAIL_V'

Line 51087: WHEN 3 THEN 'PO_EXTRACT_DETAIL_V'

51083: , l2.line_number line_number
51084: , CASE r
51085: WHEN 1 THEN 'PO_EXTRACT_DETAIL_V'
51086: WHEN 2 THEN 'PO_EXTRACT_DETAIL_V'
51087: WHEN 3 THEN 'PO_EXTRACT_DETAIL_V'
51088: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
51089: WHEN 5 THEN 'PO_EXTRACT_DETAIL_V'
51090: WHEN 6 THEN 'PO_EXTRACT_DETAIL_V'
51091: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'

Line 51088: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'

51084: , CASE r
51085: WHEN 1 THEN 'PO_EXTRACT_DETAIL_V'
51086: WHEN 2 THEN 'PO_EXTRACT_DETAIL_V'
51087: WHEN 3 THEN 'PO_EXTRACT_DETAIL_V'
51088: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
51089: WHEN 5 THEN 'PO_EXTRACT_DETAIL_V'
51090: WHEN 6 THEN 'PO_EXTRACT_DETAIL_V'
51091: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
51092: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'

Line 51089: WHEN 5 THEN 'PO_EXTRACT_DETAIL_V'

51085: WHEN 1 THEN 'PO_EXTRACT_DETAIL_V'
51086: WHEN 2 THEN 'PO_EXTRACT_DETAIL_V'
51087: WHEN 3 THEN 'PO_EXTRACT_DETAIL_V'
51088: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
51089: WHEN 5 THEN 'PO_EXTRACT_DETAIL_V'
51090: WHEN 6 THEN 'PO_EXTRACT_DETAIL_V'
51091: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
51092: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
51093: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'

Line 51090: WHEN 6 THEN 'PO_EXTRACT_DETAIL_V'

51086: WHEN 2 THEN 'PO_EXTRACT_DETAIL_V'
51087: WHEN 3 THEN 'PO_EXTRACT_DETAIL_V'
51088: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
51089: WHEN 5 THEN 'PO_EXTRACT_DETAIL_V'
51090: WHEN 6 THEN 'PO_EXTRACT_DETAIL_V'
51091: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
51092: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
51093: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
51094: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'

Line 51091: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'

51087: WHEN 3 THEN 'PO_EXTRACT_DETAIL_V'
51088: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
51089: WHEN 5 THEN 'PO_EXTRACT_DETAIL_V'
51090: WHEN 6 THEN 'PO_EXTRACT_DETAIL_V'
51091: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
51092: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
51093: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
51094: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
51095: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'

Line 51092: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'

51088: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
51089: WHEN 5 THEN 'PO_EXTRACT_DETAIL_V'
51090: WHEN 6 THEN 'PO_EXTRACT_DETAIL_V'
51091: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
51092: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
51093: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
51094: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
51095: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
51096: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'

Line 51093: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'

51089: WHEN 5 THEN 'PO_EXTRACT_DETAIL_V'
51090: WHEN 6 THEN 'PO_EXTRACT_DETAIL_V'
51091: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
51092: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
51093: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
51094: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
51095: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
51096: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
51097: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'

Line 51094: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'

51090: WHEN 6 THEN 'PO_EXTRACT_DETAIL_V'
51091: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
51092: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
51093: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
51094: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
51095: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
51096: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
51097: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
51098: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'

Line 51095: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'

51091: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
51092: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
51093: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
51094: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
51095: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
51096: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
51097: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
51098: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
51099: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'

Line 51096: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'

51092: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
51093: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
51094: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
51095: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
51096: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
51097: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
51098: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
51099: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
51100: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'

Line 51097: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'

51093: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
51094: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
51095: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
51096: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
51097: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
51098: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
51099: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
51100: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
51101: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'

Line 51098: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'

51094: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
51095: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
51096: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
51097: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
51098: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
51099: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
51100: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
51101: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
51102: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'

Line 51099: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'

51095: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
51096: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
51097: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
51098: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
51099: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
51100: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
51101: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
51102: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
51103: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'

Line 51100: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'

51096: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
51097: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
51098: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
51099: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
51100: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
51101: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
51102: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
51103: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
51104: WHEN 20 THEN 'PO_EXTRACT_DETAIL_V'

Line 51101: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'

51097: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
51098: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
51099: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
51100: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
51101: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
51102: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
51103: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
51104: WHEN 20 THEN 'PO_EXTRACT_DETAIL_V'
51105: WHEN 21 THEN 'PO_DISTS_REF_V'

Line 51102: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'

51098: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
51099: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
51100: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
51101: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
51102: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
51103: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
51104: WHEN 20 THEN 'PO_EXTRACT_DETAIL_V'
51105: WHEN 21 THEN 'PO_DISTS_REF_V'
51106: WHEN 22 THEN 'PO_DISTS_REF_V'

Line 51103: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'

51099: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
51100: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
51101: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
51102: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
51103: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
51104: WHEN 20 THEN 'PO_EXTRACT_DETAIL_V'
51105: WHEN 21 THEN 'PO_DISTS_REF_V'
51106: WHEN 22 THEN 'PO_DISTS_REF_V'
51107: WHEN 23 THEN 'PO_DISTS_REF_V'

Line 51104: WHEN 20 THEN 'PO_EXTRACT_DETAIL_V'

51100: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
51101: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
51102: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
51103: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
51104: WHEN 20 THEN 'PO_EXTRACT_DETAIL_V'
51105: WHEN 21 THEN 'PO_DISTS_REF_V'
51106: WHEN 22 THEN 'PO_DISTS_REF_V'
51107: WHEN 23 THEN 'PO_DISTS_REF_V'
51108: WHEN 24 THEN 'PO_EXTRACT_DETAIL_V'

Line 51108: WHEN 24 THEN 'PO_EXTRACT_DETAIL_V'

51104: WHEN 20 THEN 'PO_EXTRACT_DETAIL_V'
51105: WHEN 21 THEN 'PO_DISTS_REF_V'
51106: WHEN 22 THEN 'PO_DISTS_REF_V'
51107: WHEN 23 THEN 'PO_DISTS_REF_V'
51108: WHEN 24 THEN 'PO_EXTRACT_DETAIL_V'
51109: WHEN 25 THEN 'PO_EXTRACT_DETAIL_V'
51110:
51111: ELSE null
51112: END object_name

Line 51109: WHEN 25 THEN 'PO_EXTRACT_DETAIL_V'

51105: WHEN 21 THEN 'PO_DISTS_REF_V'
51106: WHEN 22 THEN 'PO_DISTS_REF_V'
51107: WHEN 23 THEN 'PO_DISTS_REF_V'
51108: WHEN 24 THEN 'PO_EXTRACT_DETAIL_V'
51109: WHEN 25 THEN 'PO_EXTRACT_DETAIL_V'
51110:
51111: ELSE null
51112: END object_name
51113: , CASE r

Line 51233: , PO_EXTRACT_DETAIL_V l2

51229: END source_value
51230: , null source_meaning
51231: FROM xla_events_gt xet
51232: , PO_DISTS_REF_V l1
51233: , PO_EXTRACT_DETAIL_V l2
51234: , (select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
51235: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
51236: AND xet.event_class_code = C_EVENT_CLASS_CODE
51237: AND l2.event_id = xet.event_id

Line 51375: TYPE t_array_source_7 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

51371: TYPE t_array_source_52 IS TABLE OF PO_EXTRACT_HEADER_V.PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
51372: TYPE t_array_source_79 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
51373: TYPE t_array_source_80 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
51374:
51375: TYPE t_array_source_7 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
51376: TYPE t_array_source_11 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
51377: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
51378: TYPE t_array_source_16 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
51379: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 51376: TYPE t_array_source_11 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

51372: TYPE t_array_source_79 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
51373: TYPE t_array_source_80 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
51374:
51375: TYPE t_array_source_7 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
51376: TYPE t_array_source_11 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
51377: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
51378: TYPE t_array_source_16 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
51379: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
51380: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 51377: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;

51373: TYPE t_array_source_80 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
51374:
51375: TYPE t_array_source_7 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
51376: TYPE t_array_source_11 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
51377: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
51378: TYPE t_array_source_16 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
51379: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
51380: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
51381: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 51378: TYPE t_array_source_16 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

51374:
51375: TYPE t_array_source_7 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
51376: TYPE t_array_source_11 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
51377: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
51378: TYPE t_array_source_16 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
51379: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
51380: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
51381: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
51382: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 51379: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

51375: TYPE t_array_source_7 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
51376: TYPE t_array_source_11 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
51377: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
51378: TYPE t_array_source_16 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
51379: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
51380: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
51381: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
51382: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
51383: TYPE t_array_source_35 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 51380: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

51376: TYPE t_array_source_11 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
51377: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
51378: TYPE t_array_source_16 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
51379: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
51380: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
51381: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
51382: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
51383: TYPE t_array_source_35 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
51384: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 51381: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;

51377: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
51378: TYPE t_array_source_16 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
51379: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
51380: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
51381: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
51382: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
51383: TYPE t_array_source_35 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
51384: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
51385: TYPE t_array_source_51 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;

Line 51382: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

51378: TYPE t_array_source_16 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
51379: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
51380: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
51381: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
51382: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
51383: TYPE t_array_source_35 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
51384: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
51385: TYPE t_array_source_51 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
51386: TYPE t_array_source_53 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

Line 51383: TYPE t_array_source_35 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;

51379: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
51380: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
51381: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
51382: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
51383: TYPE t_array_source_35 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
51384: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
51385: TYPE t_array_source_51 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
51386: TYPE t_array_source_53 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
51387: TYPE t_array_source_54 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 51384: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

51380: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
51381: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
51382: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
51383: TYPE t_array_source_35 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
51384: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
51385: TYPE t_array_source_51 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
51386: TYPE t_array_source_53 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
51387: TYPE t_array_source_54 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
51388: TYPE t_array_source_55 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 51385: TYPE t_array_source_51 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;

51381: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
51382: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
51383: TYPE t_array_source_35 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
51384: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
51385: TYPE t_array_source_51 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
51386: TYPE t_array_source_53 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
51387: TYPE t_array_source_54 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
51388: TYPE t_array_source_55 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
51389: TYPE t_array_source_56 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;

Line 51386: TYPE t_array_source_53 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

51382: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
51383: TYPE t_array_source_35 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
51384: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
51385: TYPE t_array_source_51 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
51386: TYPE t_array_source_53 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
51387: TYPE t_array_source_54 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
51388: TYPE t_array_source_55 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
51389: TYPE t_array_source_56 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
51390: TYPE t_array_source_57 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;

Line 51387: TYPE t_array_source_54 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

51383: TYPE t_array_source_35 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
51384: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
51385: TYPE t_array_source_51 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
51386: TYPE t_array_source_53 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
51387: TYPE t_array_source_54 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
51388: TYPE t_array_source_55 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
51389: TYPE t_array_source_56 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
51390: TYPE t_array_source_57 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
51391: TYPE t_array_source_58 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 51388: TYPE t_array_source_55 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

51384: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
51385: TYPE t_array_source_51 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
51386: TYPE t_array_source_53 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
51387: TYPE t_array_source_54 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
51388: TYPE t_array_source_55 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
51389: TYPE t_array_source_56 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
51390: TYPE t_array_source_57 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
51391: TYPE t_array_source_58 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
51392: TYPE t_array_source_59 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

Line 51389: TYPE t_array_source_56 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;

51385: TYPE t_array_source_51 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
51386: TYPE t_array_source_53 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
51387: TYPE t_array_source_54 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
51388: TYPE t_array_source_55 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
51389: TYPE t_array_source_56 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
51390: TYPE t_array_source_57 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
51391: TYPE t_array_source_58 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
51392: TYPE t_array_source_59 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
51393: TYPE t_array_source_60 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;

Line 51390: TYPE t_array_source_57 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;

51386: TYPE t_array_source_53 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
51387: TYPE t_array_source_54 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
51388: TYPE t_array_source_55 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
51389: TYPE t_array_source_56 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
51390: TYPE t_array_source_57 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
51391: TYPE t_array_source_58 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
51392: TYPE t_array_source_59 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
51393: TYPE t_array_source_60 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
51394: TYPE t_array_source_61 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 51391: TYPE t_array_source_58 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

51387: TYPE t_array_source_54 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
51388: TYPE t_array_source_55 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
51389: TYPE t_array_source_56 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
51390: TYPE t_array_source_57 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
51391: TYPE t_array_source_58 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
51392: TYPE t_array_source_59 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
51393: TYPE t_array_source_60 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
51394: TYPE t_array_source_61 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
51395: TYPE t_array_source_62 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 51392: TYPE t_array_source_59 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

51388: TYPE t_array_source_55 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
51389: TYPE t_array_source_56 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
51390: TYPE t_array_source_57 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
51391: TYPE t_array_source_58 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
51392: TYPE t_array_source_59 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
51393: TYPE t_array_source_60 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
51394: TYPE t_array_source_61 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
51395: TYPE t_array_source_62 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
51396: TYPE t_array_source_63 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 51393: TYPE t_array_source_60 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;

51389: TYPE t_array_source_56 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
51390: TYPE t_array_source_57 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
51391: TYPE t_array_source_58 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
51392: TYPE t_array_source_59 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
51393: TYPE t_array_source_60 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
51394: TYPE t_array_source_61 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
51395: TYPE t_array_source_62 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
51396: TYPE t_array_source_63 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
51397: TYPE t_array_source_64 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 51394: TYPE t_array_source_61 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

51390: TYPE t_array_source_57 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
51391: TYPE t_array_source_58 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
51392: TYPE t_array_source_59 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
51393: TYPE t_array_source_60 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
51394: TYPE t_array_source_61 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
51395: TYPE t_array_source_62 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
51396: TYPE t_array_source_63 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
51397: TYPE t_array_source_64 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
51398: TYPE t_array_source_65 IS TABLE OF PO_EXTRACT_DETAIL_V.BACKING_REQ_ENC_CHANGED%TYPE INDEX BY BINARY_INTEGER;

Line 51398: TYPE t_array_source_65 IS TABLE OF PO_EXTRACT_DETAIL_V.BACKING_REQ_ENC_CHANGED%TYPE INDEX BY BINARY_INTEGER;

51394: TYPE t_array_source_61 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
51395: TYPE t_array_source_62 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
51396: TYPE t_array_source_63 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
51397: TYPE t_array_source_64 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
51398: TYPE t_array_source_65 IS TABLE OF PO_EXTRACT_DETAIL_V.BACKING_REQ_ENC_CHANGED%TYPE INDEX BY BINARY_INTEGER;
51399: TYPE t_array_source_75 IS TABLE OF PO_EXTRACT_DETAIL_V.ADJUSTMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
51400:
51401: l_array_source_1 t_array_source_1;
51402: l_array_source_2 t_array_source_2;

Line 51399: TYPE t_array_source_75 IS TABLE OF PO_EXTRACT_DETAIL_V.ADJUSTMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;

51395: TYPE t_array_source_62 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
51396: TYPE t_array_source_63 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
51397: TYPE t_array_source_64 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
51398: TYPE t_array_source_65 IS TABLE OF PO_EXTRACT_DETAIL_V.BACKING_REQ_ENC_CHANGED%TYPE INDEX BY BINARY_INTEGER;
51399: TYPE t_array_source_75 IS TABLE OF PO_EXTRACT_DETAIL_V.ADJUSTMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
51400:
51401: l_array_source_1 t_array_source_1;
51402: l_array_source_2 t_array_source_2;
51403: l_array_source_52 t_array_source_52;

Line 51534: , PO_EXTRACT_DETAIL_V l2

51530: , l2.BACKING_REQ_ENC_CHANGED source_65
51531: , l2.ADJUSTMENT_STATUS source_75
51532: FROM xla_events_gt xet
51533: , PO_DISTS_REF_V l1
51534: , PO_EXTRACT_DETAIL_V l2
51535: WHERE xet.event_id between x_first_event_id and x_last_event_id
51536: and xet.event_date between p_pad_start_date and p_pad_end_date
51537: and xet.event_class_code = C_EVENT_CLASS_CODE
51538: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 52884: WHEN 1 THEN 'PO_EXTRACT_DETAIL_V'

52880: FROM (
52881: SELECT xet.event_id event_id
52882: , l2.line_number line_number
52883: , CASE r
52884: WHEN 1 THEN 'PO_EXTRACT_DETAIL_V'
52885: WHEN 2 THEN 'PO_EXTRACT_DETAIL_V'
52886: WHEN 3 THEN 'PO_EXTRACT_DETAIL_V'
52887: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
52888: WHEN 5 THEN 'PO_EXTRACT_DETAIL_V'

Line 52885: WHEN 2 THEN 'PO_EXTRACT_DETAIL_V'

52881: SELECT xet.event_id event_id
52882: , l2.line_number line_number
52883: , CASE r
52884: WHEN 1 THEN 'PO_EXTRACT_DETAIL_V'
52885: WHEN 2 THEN 'PO_EXTRACT_DETAIL_V'
52886: WHEN 3 THEN 'PO_EXTRACT_DETAIL_V'
52887: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
52888: WHEN 5 THEN 'PO_EXTRACT_DETAIL_V'
52889: WHEN 6 THEN 'PO_EXTRACT_DETAIL_V'

Line 52886: WHEN 3 THEN 'PO_EXTRACT_DETAIL_V'

52882: , l2.line_number line_number
52883: , CASE r
52884: WHEN 1 THEN 'PO_EXTRACT_DETAIL_V'
52885: WHEN 2 THEN 'PO_EXTRACT_DETAIL_V'
52886: WHEN 3 THEN 'PO_EXTRACT_DETAIL_V'
52887: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
52888: WHEN 5 THEN 'PO_EXTRACT_DETAIL_V'
52889: WHEN 6 THEN 'PO_EXTRACT_DETAIL_V'
52890: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'

Line 52887: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'

52883: , CASE r
52884: WHEN 1 THEN 'PO_EXTRACT_DETAIL_V'
52885: WHEN 2 THEN 'PO_EXTRACT_DETAIL_V'
52886: WHEN 3 THEN 'PO_EXTRACT_DETAIL_V'
52887: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
52888: WHEN 5 THEN 'PO_EXTRACT_DETAIL_V'
52889: WHEN 6 THEN 'PO_EXTRACT_DETAIL_V'
52890: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
52891: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'

Line 52888: WHEN 5 THEN 'PO_EXTRACT_DETAIL_V'

52884: WHEN 1 THEN 'PO_EXTRACT_DETAIL_V'
52885: WHEN 2 THEN 'PO_EXTRACT_DETAIL_V'
52886: WHEN 3 THEN 'PO_EXTRACT_DETAIL_V'
52887: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
52888: WHEN 5 THEN 'PO_EXTRACT_DETAIL_V'
52889: WHEN 6 THEN 'PO_EXTRACT_DETAIL_V'
52890: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
52891: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
52892: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'

Line 52889: WHEN 6 THEN 'PO_EXTRACT_DETAIL_V'

52885: WHEN 2 THEN 'PO_EXTRACT_DETAIL_V'
52886: WHEN 3 THEN 'PO_EXTRACT_DETAIL_V'
52887: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
52888: WHEN 5 THEN 'PO_EXTRACT_DETAIL_V'
52889: WHEN 6 THEN 'PO_EXTRACT_DETAIL_V'
52890: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
52891: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
52892: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
52893: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'

Line 52890: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'

52886: WHEN 3 THEN 'PO_EXTRACT_DETAIL_V'
52887: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
52888: WHEN 5 THEN 'PO_EXTRACT_DETAIL_V'
52889: WHEN 6 THEN 'PO_EXTRACT_DETAIL_V'
52890: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
52891: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
52892: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
52893: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
52894: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'

Line 52891: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'

52887: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
52888: WHEN 5 THEN 'PO_EXTRACT_DETAIL_V'
52889: WHEN 6 THEN 'PO_EXTRACT_DETAIL_V'
52890: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
52891: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
52892: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
52893: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
52894: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
52895: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'

Line 52892: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'

52888: WHEN 5 THEN 'PO_EXTRACT_DETAIL_V'
52889: WHEN 6 THEN 'PO_EXTRACT_DETAIL_V'
52890: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
52891: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
52892: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
52893: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
52894: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
52895: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
52896: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'

Line 52893: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'

52889: WHEN 6 THEN 'PO_EXTRACT_DETAIL_V'
52890: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
52891: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
52892: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
52893: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
52894: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
52895: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
52896: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
52897: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'

Line 52894: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'

52890: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
52891: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
52892: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
52893: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
52894: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
52895: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
52896: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
52897: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
52898: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'

Line 52895: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'

52891: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
52892: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
52893: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
52894: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
52895: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
52896: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
52897: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
52898: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
52899: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'

Line 52896: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'

52892: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
52893: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
52894: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
52895: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
52896: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
52897: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
52898: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
52899: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
52900: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'

Line 52897: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'

52893: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
52894: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
52895: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
52896: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
52897: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
52898: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
52899: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
52900: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
52901: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'

Line 52898: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'

52894: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
52895: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
52896: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
52897: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
52898: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
52899: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
52900: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
52901: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
52902: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'

Line 52899: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'

52895: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
52896: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
52897: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
52898: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
52899: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
52900: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
52901: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
52902: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
52903: WHEN 20 THEN 'PO_DISTS_REF_V'

Line 52900: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'

52896: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
52897: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
52898: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
52899: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
52900: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
52901: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
52902: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
52903: WHEN 20 THEN 'PO_DISTS_REF_V'
52904: WHEN 21 THEN 'PO_DISTS_REF_V'

Line 52901: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'

52897: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
52898: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
52899: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
52900: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
52901: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
52902: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
52903: WHEN 20 THEN 'PO_DISTS_REF_V'
52904: WHEN 21 THEN 'PO_DISTS_REF_V'
52905: WHEN 22 THEN 'PO_DISTS_REF_V'

Line 52902: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'

52898: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
52899: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
52900: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
52901: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
52902: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
52903: WHEN 20 THEN 'PO_DISTS_REF_V'
52904: WHEN 21 THEN 'PO_DISTS_REF_V'
52905: WHEN 22 THEN 'PO_DISTS_REF_V'
52906: WHEN 23 THEN 'PO_EXTRACT_DETAIL_V'

Line 52906: WHEN 23 THEN 'PO_EXTRACT_DETAIL_V'

52902: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
52903: WHEN 20 THEN 'PO_DISTS_REF_V'
52904: WHEN 21 THEN 'PO_DISTS_REF_V'
52905: WHEN 22 THEN 'PO_DISTS_REF_V'
52906: WHEN 23 THEN 'PO_EXTRACT_DETAIL_V'
52907:
52908: ELSE null
52909: END object_name
52910: , CASE r

Line 53022: , PO_EXTRACT_DETAIL_V l2

53018: END source_value
53019: , null source_meaning
53020: FROM xla_events_gt xet
53021: , PO_DISTS_REF_V l1
53022: , PO_EXTRACT_DETAIL_V l2
53023: , (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
53024: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
53025: AND xet.event_class_code = C_EVENT_CLASS_CODE
53026: AND l2.event_id = xet.event_id

Line 53165: TYPE t_array_source_7 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

53161: TYPE t_array_source_66 IS TABLE OF PO_EXTRACT_HEADER_V.PO_RELEASE_ID%TYPE INDEX BY BINARY_INTEGER;
53162: TYPE t_array_source_79 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
53163: TYPE t_array_source_80 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
53164:
53165: TYPE t_array_source_7 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
53166: TYPE t_array_source_11 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
53167: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
53168: TYPE t_array_source_16 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
53169: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 53166: TYPE t_array_source_11 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

53162: TYPE t_array_source_79 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
53163: TYPE t_array_source_80 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
53164:
53165: TYPE t_array_source_7 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
53166: TYPE t_array_source_11 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
53167: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
53168: TYPE t_array_source_16 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
53169: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
53170: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 53167: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;

53163: TYPE t_array_source_80 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
53164:
53165: TYPE t_array_source_7 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
53166: TYPE t_array_source_11 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
53167: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
53168: TYPE t_array_source_16 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
53169: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
53170: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
53171: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 53168: TYPE t_array_source_16 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

53164:
53165: TYPE t_array_source_7 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
53166: TYPE t_array_source_11 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
53167: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
53168: TYPE t_array_source_16 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
53169: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
53170: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
53171: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
53172: TYPE t_array_source_35 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 53169: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

53165: TYPE t_array_source_7 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
53166: TYPE t_array_source_11 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
53167: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
53168: TYPE t_array_source_16 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
53169: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
53170: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
53171: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
53172: TYPE t_array_source_35 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
53173: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 53170: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;

53166: TYPE t_array_source_11 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
53167: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
53168: TYPE t_array_source_16 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
53169: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
53170: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
53171: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
53172: TYPE t_array_source_35 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
53173: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
53174: TYPE t_array_source_51 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;

Line 53171: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

53167: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
53168: TYPE t_array_source_16 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
53169: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
53170: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
53171: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
53172: TYPE t_array_source_35 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
53173: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
53174: TYPE t_array_source_51 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
53175: TYPE t_array_source_53 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

Line 53172: TYPE t_array_source_35 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;

53168: TYPE t_array_source_16 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
53169: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
53170: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
53171: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
53172: TYPE t_array_source_35 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
53173: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
53174: TYPE t_array_source_51 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
53175: TYPE t_array_source_53 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
53176: TYPE t_array_source_54 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 53173: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

53169: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
53170: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
53171: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
53172: TYPE t_array_source_35 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
53173: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
53174: TYPE t_array_source_51 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
53175: TYPE t_array_source_53 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
53176: TYPE t_array_source_54 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
53177: TYPE t_array_source_55 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 53174: TYPE t_array_source_51 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;

53170: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
53171: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
53172: TYPE t_array_source_35 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
53173: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
53174: TYPE t_array_source_51 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
53175: TYPE t_array_source_53 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
53176: TYPE t_array_source_54 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
53177: TYPE t_array_source_55 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
53178: TYPE t_array_source_56 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;

Line 53175: TYPE t_array_source_53 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

53171: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
53172: TYPE t_array_source_35 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
53173: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
53174: TYPE t_array_source_51 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
53175: TYPE t_array_source_53 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
53176: TYPE t_array_source_54 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
53177: TYPE t_array_source_55 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
53178: TYPE t_array_source_56 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
53179: TYPE t_array_source_57 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;

Line 53176: TYPE t_array_source_54 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

53172: TYPE t_array_source_35 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
53173: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
53174: TYPE t_array_source_51 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
53175: TYPE t_array_source_53 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
53176: TYPE t_array_source_54 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
53177: TYPE t_array_source_55 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
53178: TYPE t_array_source_56 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
53179: TYPE t_array_source_57 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
53180: TYPE t_array_source_58 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 53177: TYPE t_array_source_55 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

53173: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
53174: TYPE t_array_source_51 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
53175: TYPE t_array_source_53 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
53176: TYPE t_array_source_54 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
53177: TYPE t_array_source_55 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
53178: TYPE t_array_source_56 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
53179: TYPE t_array_source_57 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
53180: TYPE t_array_source_58 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
53181: TYPE t_array_source_59 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

Line 53178: TYPE t_array_source_56 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;

53174: TYPE t_array_source_51 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
53175: TYPE t_array_source_53 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
53176: TYPE t_array_source_54 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
53177: TYPE t_array_source_55 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
53178: TYPE t_array_source_56 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
53179: TYPE t_array_source_57 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
53180: TYPE t_array_source_58 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
53181: TYPE t_array_source_59 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
53182: TYPE t_array_source_60 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;

Line 53179: TYPE t_array_source_57 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;

53175: TYPE t_array_source_53 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
53176: TYPE t_array_source_54 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
53177: TYPE t_array_source_55 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
53178: TYPE t_array_source_56 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
53179: TYPE t_array_source_57 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
53180: TYPE t_array_source_58 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
53181: TYPE t_array_source_59 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
53182: TYPE t_array_source_60 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
53183: TYPE t_array_source_61 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 53180: TYPE t_array_source_58 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

53176: TYPE t_array_source_54 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
53177: TYPE t_array_source_55 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
53178: TYPE t_array_source_56 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
53179: TYPE t_array_source_57 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
53180: TYPE t_array_source_58 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
53181: TYPE t_array_source_59 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
53182: TYPE t_array_source_60 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
53183: TYPE t_array_source_61 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
53184: TYPE t_array_source_62 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 53181: TYPE t_array_source_59 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

53177: TYPE t_array_source_55 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
53178: TYPE t_array_source_56 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
53179: TYPE t_array_source_57 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
53180: TYPE t_array_source_58 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
53181: TYPE t_array_source_59 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
53182: TYPE t_array_source_60 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
53183: TYPE t_array_source_61 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
53184: TYPE t_array_source_62 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
53185: TYPE t_array_source_63 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 53182: TYPE t_array_source_60 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;

53178: TYPE t_array_source_56 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
53179: TYPE t_array_source_57 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
53180: TYPE t_array_source_58 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
53181: TYPE t_array_source_59 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
53182: TYPE t_array_source_60 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
53183: TYPE t_array_source_61 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
53184: TYPE t_array_source_62 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
53185: TYPE t_array_source_63 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
53186: TYPE t_array_source_64 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 53183: TYPE t_array_source_61 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

53179: TYPE t_array_source_57 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
53180: TYPE t_array_source_58 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
53181: TYPE t_array_source_59 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
53182: TYPE t_array_source_60 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
53183: TYPE t_array_source_61 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
53184: TYPE t_array_source_62 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
53185: TYPE t_array_source_63 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
53186: TYPE t_array_source_64 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
53187: TYPE t_array_source_75 IS TABLE OF PO_EXTRACT_DETAIL_V.ADJUSTMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;

Line 53187: TYPE t_array_source_75 IS TABLE OF PO_EXTRACT_DETAIL_V.ADJUSTMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;

53183: TYPE t_array_source_61 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
53184: TYPE t_array_source_62 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
53185: TYPE t_array_source_63 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
53186: TYPE t_array_source_64 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
53187: TYPE t_array_source_75 IS TABLE OF PO_EXTRACT_DETAIL_V.ADJUSTMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
53188:
53189: l_array_source_1 t_array_source_1;
53190: l_array_source_2 t_array_source_2;
53191: l_array_source_8 t_array_source_8;

Line 53321: , PO_EXTRACT_DETAIL_V l2

53317: , l1.CURRENCY_CONVERSION_TYPE source_64
53318: , l2.ADJUSTMENT_STATUS source_75
53319: FROM xla_events_gt xet
53320: , PO_DISTS_REF_V l1
53321: , PO_EXTRACT_DETAIL_V l2
53322: WHERE xet.event_id between x_first_event_id and x_last_event_id
53323: and xet.event_date between p_pad_start_date and p_pad_end_date
53324: and xet.event_class_code = C_EVENT_CLASS_CODE
53325: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id