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_000004_BC_PKG dependencies on FV_XLA_PO_REF_V

Line 47352: WHEN 2 THEN 'FV_XLA_PO_REF_V'

47348: SELECT xet.event_id event_id
47349: , l3.line_number line_number
47350: , CASE r
47351: WHEN 1 THEN 'PO_EXTRACT_DETAIL_V'
47352: WHEN 2 THEN 'FV_XLA_PO_REF_V'
47353: WHEN 3 THEN 'FV_XLA_PO_REF_V'
47354: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
47355: WHEN 5 THEN 'FV_XLA_PO_REF_V'
47356: WHEN 6 THEN 'FV_XLA_PO_REF_V'

Line 47353: WHEN 3 THEN 'FV_XLA_PO_REF_V'

47349: , l3.line_number line_number
47350: , CASE r
47351: WHEN 1 THEN 'PO_EXTRACT_DETAIL_V'
47352: WHEN 2 THEN 'FV_XLA_PO_REF_V'
47353: WHEN 3 THEN 'FV_XLA_PO_REF_V'
47354: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
47355: WHEN 5 THEN 'FV_XLA_PO_REF_V'
47356: WHEN 6 THEN 'FV_XLA_PO_REF_V'
47357: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'

Line 47355: WHEN 5 THEN 'FV_XLA_PO_REF_V'

47351: WHEN 1 THEN 'PO_EXTRACT_DETAIL_V'
47352: WHEN 2 THEN 'FV_XLA_PO_REF_V'
47353: WHEN 3 THEN 'FV_XLA_PO_REF_V'
47354: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
47355: WHEN 5 THEN 'FV_XLA_PO_REF_V'
47356: WHEN 6 THEN 'FV_XLA_PO_REF_V'
47357: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
47358: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
47359: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'

Line 47356: WHEN 6 THEN 'FV_XLA_PO_REF_V'

47352: WHEN 2 THEN 'FV_XLA_PO_REF_V'
47353: WHEN 3 THEN 'FV_XLA_PO_REF_V'
47354: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
47355: WHEN 5 THEN 'FV_XLA_PO_REF_V'
47356: WHEN 6 THEN 'FV_XLA_PO_REF_V'
47357: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
47358: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
47359: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
47360: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'

Line 47371: WHEN 21 THEN 'FV_XLA_PO_REF_V'

47367: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
47368: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
47369: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
47370: WHEN 20 THEN 'PO_EXTRACT_DETAIL_V'
47371: WHEN 21 THEN 'FV_XLA_PO_REF_V'
47372: WHEN 22 THEN 'PO_EXTRACT_DETAIL_V'
47373: WHEN 23 THEN 'PO_EXTRACT_DETAIL_V'
47374: WHEN 24 THEN 'PO_EXTRACT_DETAIL_V'
47375: WHEN 25 THEN 'PO_EXTRACT_DETAIL_V'

Line 47379: WHEN 29 THEN 'FV_XLA_PO_REF_V'

47375: WHEN 25 THEN 'PO_EXTRACT_DETAIL_V'
47376: WHEN 26 THEN 'PO_DISTS_REF_V'
47377: WHEN 27 THEN 'PO_DISTS_REF_V'
47378: WHEN 28 THEN 'PO_DISTS_REF_V'
47379: WHEN 29 THEN 'FV_XLA_PO_REF_V'
47380: WHEN 30 THEN 'FV_XLA_PO_REF_V'
47381: WHEN 31 THEN 'FV_XLA_PO_REF_V'
47382:
47383: ELSE null

Line 47380: WHEN 30 THEN 'FV_XLA_PO_REF_V'

47376: WHEN 26 THEN 'PO_DISTS_REF_V'
47377: WHEN 27 THEN 'PO_DISTS_REF_V'
47378: WHEN 28 THEN 'PO_DISTS_REF_V'
47379: WHEN 29 THEN 'FV_XLA_PO_REF_V'
47380: WHEN 30 THEN 'FV_XLA_PO_REF_V'
47381: WHEN 31 THEN 'FV_XLA_PO_REF_V'
47382:
47383: ELSE null
47384: END object_name

Line 47381: WHEN 31 THEN 'FV_XLA_PO_REF_V'

47377: WHEN 27 THEN 'PO_DISTS_REF_V'
47378: WHEN 28 THEN 'PO_DISTS_REF_V'
47379: WHEN 29 THEN 'FV_XLA_PO_REF_V'
47380: WHEN 30 THEN 'FV_XLA_PO_REF_V'
47381: WHEN 31 THEN 'FV_XLA_PO_REF_V'
47382:
47383: ELSE null
47384: END object_name
47385: , CASE r

Line 47528: , FV_XLA_PO_REF_V l1

47524: ELSE null
47525: END source_value
47526: , null source_meaning
47527: FROM xla_events_gt xet
47528: , FV_XLA_PO_REF_V l1
47529: , PO_DISTS_REF_V l2
47530: , PO_EXTRACT_DETAIL_V l3
47531: , (select rownum r from all_objects where rownum <= 31 and owner = p_apps_owner)
47532: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 47673: TYPE t_array_source_7 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

47669: TYPE t_array_source_48 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
47670: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
47671:
47672: TYPE t_array_source_3 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
47673: TYPE t_array_source_7 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
47674: TYPE t_array_source_8 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
47675: TYPE t_array_source_9 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
47676: TYPE t_array_source_10 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
47677: TYPE t_array_source_11 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 47674: TYPE t_array_source_8 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;

47670: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
47671:
47672: TYPE t_array_source_3 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
47673: TYPE t_array_source_7 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
47674: TYPE t_array_source_8 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
47675: TYPE t_array_source_9 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
47676: TYPE t_array_source_10 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
47677: TYPE t_array_source_11 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
47678: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 47676: TYPE t_array_source_10 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;

47672: TYPE t_array_source_3 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
47673: TYPE t_array_source_7 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
47674: TYPE t_array_source_8 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
47675: TYPE t_array_source_9 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
47676: TYPE t_array_source_10 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
47677: TYPE t_array_source_11 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
47678: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
47679: TYPE t_array_source_14 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
47680: TYPE t_array_source_15 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 47677: TYPE t_array_source_11 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;

47673: TYPE t_array_source_7 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
47674: TYPE t_array_source_8 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
47675: TYPE t_array_source_9 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
47676: TYPE t_array_source_10 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
47677: TYPE t_array_source_11 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
47678: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
47679: TYPE t_array_source_14 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
47680: TYPE t_array_source_15 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
47681: TYPE t_array_source_17 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 47692: TYPE t_array_source_30 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;

47688: TYPE t_array_source_26 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
47689: TYPE t_array_source_27 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
47690: TYPE t_array_source_28 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
47691: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
47692: TYPE t_array_source_30 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
47693: TYPE t_array_source_31 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
47694: TYPE t_array_source_32 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
47695: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
47696: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;

Line 47700: TYPE t_array_source_38 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PYA_DIFF_AMT%TYPE INDEX BY BINARY_INTEGER;

47696: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
47697: TYPE t_array_source_35 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
47698: TYPE t_array_source_36 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
47699: TYPE t_array_source_37 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
47700: TYPE t_array_source_38 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PYA_DIFF_AMT%TYPE INDEX BY BINARY_INTEGER;
47701: TYPE t_array_source_39 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
47702: TYPE t_array_source_40 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PYA_AMT%TYPE INDEX BY BINARY_INTEGER;
47703:
47704: l_array_source_1 t_array_source_1;

Line 47701: TYPE t_array_source_39 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;

47697: TYPE t_array_source_35 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
47698: TYPE t_array_source_36 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
47699: TYPE t_array_source_37 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
47700: TYPE t_array_source_38 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PYA_DIFF_AMT%TYPE INDEX BY BINARY_INTEGER;
47701: TYPE t_array_source_39 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
47702: TYPE t_array_source_40 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PYA_AMT%TYPE INDEX BY BINARY_INTEGER;
47703:
47704: l_array_source_1 t_array_source_1;
47705: l_array_source_2 t_array_source_2;

Line 47702: TYPE t_array_source_40 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PYA_AMT%TYPE INDEX BY BINARY_INTEGER;

47698: TYPE t_array_source_36 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
47699: TYPE t_array_source_37 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
47700: TYPE t_array_source_38 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PYA_DIFF_AMT%TYPE INDEX BY BINARY_INTEGER;
47701: TYPE t_array_source_39 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
47702: TYPE t_array_source_40 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PYA_AMT%TYPE INDEX BY BINARY_INTEGER;
47703:
47704: l_array_source_1 t_array_source_1;
47705: l_array_source_2 t_array_source_2;
47706: l_array_source_20 t_array_source_20;

Line 47848: , FV_XLA_PO_REF_V l1

47844: , l1.FEDERAL_PYA_DIFF_AMT source_38
47845: , l1.FEDERAL_ANTICIPATED_AMT source_39
47846: , l1.FEDERAL_PYA_AMT source_40
47847: FROM xla_events_gt xet
47848: , FV_XLA_PO_REF_V l1
47849: , PO_DISTS_REF_V l2
47850: , PO_EXTRACT_DETAIL_V l3
47851: WHERE xet.event_id between x_first_event_id and x_last_event_id
47852: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 50157: WHEN 2 THEN 'FV_XLA_PO_REF_V'

50153: SELECT xet.event_id event_id
50154: , l3.line_number line_number
50155: , CASE r
50156: WHEN 1 THEN 'PO_EXTRACT_DETAIL_V'
50157: WHEN 2 THEN 'FV_XLA_PO_REF_V'
50158: WHEN 3 THEN 'FV_XLA_PO_REF_V'
50159: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
50160: WHEN 5 THEN 'FV_XLA_PO_REF_V'
50161: WHEN 6 THEN 'FV_XLA_PO_REF_V'

Line 50158: WHEN 3 THEN 'FV_XLA_PO_REF_V'

50154: , l3.line_number line_number
50155: , CASE r
50156: WHEN 1 THEN 'PO_EXTRACT_DETAIL_V'
50157: WHEN 2 THEN 'FV_XLA_PO_REF_V'
50158: WHEN 3 THEN 'FV_XLA_PO_REF_V'
50159: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
50160: WHEN 5 THEN 'FV_XLA_PO_REF_V'
50161: WHEN 6 THEN 'FV_XLA_PO_REF_V'
50162: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'

Line 50160: WHEN 5 THEN 'FV_XLA_PO_REF_V'

50156: WHEN 1 THEN 'PO_EXTRACT_DETAIL_V'
50157: WHEN 2 THEN 'FV_XLA_PO_REF_V'
50158: WHEN 3 THEN 'FV_XLA_PO_REF_V'
50159: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
50160: WHEN 5 THEN 'FV_XLA_PO_REF_V'
50161: WHEN 6 THEN 'FV_XLA_PO_REF_V'
50162: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
50163: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
50164: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'

Line 50161: WHEN 6 THEN 'FV_XLA_PO_REF_V'

50157: WHEN 2 THEN 'FV_XLA_PO_REF_V'
50158: WHEN 3 THEN 'FV_XLA_PO_REF_V'
50159: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
50160: WHEN 5 THEN 'FV_XLA_PO_REF_V'
50161: WHEN 6 THEN 'FV_XLA_PO_REF_V'
50162: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
50163: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
50164: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
50165: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'

Line 50175: WHEN 20 THEN 'FV_XLA_PO_REF_V'

50171: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
50172: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
50173: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
50174: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
50175: WHEN 20 THEN 'FV_XLA_PO_REF_V'
50176: WHEN 21 THEN 'PO_EXTRACT_DETAIL_V'
50177: WHEN 22 THEN 'PO_EXTRACT_DETAIL_V'
50178: WHEN 23 THEN 'PO_EXTRACT_DETAIL_V'
50179: WHEN 24 THEN 'PO_EXTRACT_DETAIL_V'

Line 50183: WHEN 28 THEN 'FV_XLA_PO_REF_V'

50179: WHEN 24 THEN 'PO_EXTRACT_DETAIL_V'
50180: WHEN 25 THEN 'PO_DISTS_REF_V'
50181: WHEN 26 THEN 'PO_DISTS_REF_V'
50182: WHEN 27 THEN 'PO_DISTS_REF_V'
50183: WHEN 28 THEN 'FV_XLA_PO_REF_V'
50184: WHEN 29 THEN 'FV_XLA_PO_REF_V'
50185: WHEN 30 THEN 'FV_XLA_PO_REF_V'
50186:
50187: ELSE null

Line 50184: WHEN 29 THEN 'FV_XLA_PO_REF_V'

50180: WHEN 25 THEN 'PO_DISTS_REF_V'
50181: WHEN 26 THEN 'PO_DISTS_REF_V'
50182: WHEN 27 THEN 'PO_DISTS_REF_V'
50183: WHEN 28 THEN 'FV_XLA_PO_REF_V'
50184: WHEN 29 THEN 'FV_XLA_PO_REF_V'
50185: WHEN 30 THEN 'FV_XLA_PO_REF_V'
50186:
50187: ELSE null
50188: END object_name

Line 50185: WHEN 30 THEN 'FV_XLA_PO_REF_V'

50181: WHEN 26 THEN 'PO_DISTS_REF_V'
50182: WHEN 27 THEN 'PO_DISTS_REF_V'
50183: WHEN 28 THEN 'FV_XLA_PO_REF_V'
50184: WHEN 29 THEN 'FV_XLA_PO_REF_V'
50185: WHEN 30 THEN 'FV_XLA_PO_REF_V'
50186:
50187: ELSE null
50188: END object_name
50189: , CASE r

Line 50328: , FV_XLA_PO_REF_V l1

50324: ELSE null
50325: END source_value
50326: , null source_meaning
50327: FROM xla_events_gt xet
50328: , FV_XLA_PO_REF_V l1
50329: , PO_DISTS_REF_V l2
50330: , PO_EXTRACT_DETAIL_V l3
50331: , (select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)
50332: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 50474: TYPE t_array_source_7 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

50470: TYPE t_array_source_48 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
50471: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
50472:
50473: TYPE t_array_source_3 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
50474: TYPE t_array_source_7 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
50475: TYPE t_array_source_8 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
50476: TYPE t_array_source_9 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
50477: TYPE t_array_source_10 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
50478: TYPE t_array_source_11 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 50475: TYPE t_array_source_8 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;

50471: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
50472:
50473: TYPE t_array_source_3 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
50474: TYPE t_array_source_7 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
50475: TYPE t_array_source_8 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
50476: TYPE t_array_source_9 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
50477: TYPE t_array_source_10 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
50478: TYPE t_array_source_11 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
50479: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 50477: TYPE t_array_source_10 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;

50473: TYPE t_array_source_3 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
50474: TYPE t_array_source_7 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
50475: TYPE t_array_source_8 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
50476: TYPE t_array_source_9 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
50477: TYPE t_array_source_10 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
50478: TYPE t_array_source_11 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
50479: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
50480: TYPE t_array_source_15 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
50481: TYPE t_array_source_17 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 50478: TYPE t_array_source_11 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;

50474: TYPE t_array_source_7 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
50475: TYPE t_array_source_8 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
50476: TYPE t_array_source_9 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
50477: TYPE t_array_source_10 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
50478: TYPE t_array_source_11 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
50479: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
50480: TYPE t_array_source_15 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
50481: TYPE t_array_source_17 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
50482: TYPE t_array_source_19 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 50492: TYPE t_array_source_30 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;

50488: TYPE t_array_source_26 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
50489: TYPE t_array_source_27 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
50490: TYPE t_array_source_28 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
50491: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
50492: TYPE t_array_source_30 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
50493: TYPE t_array_source_31 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
50494: TYPE t_array_source_32 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
50495: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
50496: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;

Line 50500: TYPE t_array_source_38 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PYA_DIFF_AMT%TYPE INDEX BY BINARY_INTEGER;

50496: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
50497: TYPE t_array_source_35 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
50498: TYPE t_array_source_36 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
50499: TYPE t_array_source_37 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
50500: TYPE t_array_source_38 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PYA_DIFF_AMT%TYPE INDEX BY BINARY_INTEGER;
50501: TYPE t_array_source_39 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
50502: TYPE t_array_source_40 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PYA_AMT%TYPE INDEX BY BINARY_INTEGER;
50503:
50504: l_array_source_1 t_array_source_1;

Line 50501: TYPE t_array_source_39 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;

50497: TYPE t_array_source_35 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
50498: TYPE t_array_source_36 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
50499: TYPE t_array_source_37 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
50500: TYPE t_array_source_38 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PYA_DIFF_AMT%TYPE INDEX BY BINARY_INTEGER;
50501: TYPE t_array_source_39 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
50502: TYPE t_array_source_40 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PYA_AMT%TYPE INDEX BY BINARY_INTEGER;
50503:
50504: l_array_source_1 t_array_source_1;
50505: l_array_source_2 t_array_source_2;

Line 50502: TYPE t_array_source_40 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PYA_AMT%TYPE INDEX BY BINARY_INTEGER;

50498: TYPE t_array_source_36 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
50499: TYPE t_array_source_37 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
50500: TYPE t_array_source_38 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PYA_DIFF_AMT%TYPE INDEX BY BINARY_INTEGER;
50501: TYPE t_array_source_39 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
50502: TYPE t_array_source_40 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PYA_AMT%TYPE INDEX BY BINARY_INTEGER;
50503:
50504: l_array_source_1 t_array_source_1;
50505: l_array_source_2 t_array_source_2;
50506: l_array_source_4 t_array_source_4;

Line 50649: , FV_XLA_PO_REF_V l1

50645: , l1.FEDERAL_PYA_DIFF_AMT source_38
50646: , l1.FEDERAL_ANTICIPATED_AMT source_39
50647: , l1.FEDERAL_PYA_AMT source_40
50648: FROM xla_events_gt xet
50649: , FV_XLA_PO_REF_V l1
50650: , PO_DISTS_REF_V l2
50651: , PO_EXTRACT_DETAIL_V l3
50652: WHERE xet.event_id between x_first_event_id and x_last_event_id
50653: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 52660: WHEN 2 THEN 'FV_XLA_PO_REF_V'

52656: SELECT xet.event_id event_id
52657: , l2.line_number line_number
52658: , CASE r
52659: WHEN 1 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52660: WHEN 2 THEN 'FV_XLA_PO_REF_V'
52661: WHEN 3 THEN 'FV_XLA_PO_REF_V'
52662: WHEN 4 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52663: WHEN 5 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52664: WHEN 6 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 52661: WHEN 3 THEN 'FV_XLA_PO_REF_V'

52657: , l2.line_number line_number
52658: , CASE r
52659: WHEN 1 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52660: WHEN 2 THEN 'FV_XLA_PO_REF_V'
52661: WHEN 3 THEN 'FV_XLA_PO_REF_V'
52662: WHEN 4 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52663: WHEN 5 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52664: WHEN 6 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52665: WHEN 7 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 52796: , FV_XLA_PO_REF_V l1

52792: ELSE null
52793: END source_value
52794: , null source_meaning
52795: FROM xla_events_gt xet
52796: , FV_XLA_PO_REF_V l1
52797: , PO_REQ_EXTRACT_DETAIL_V l2
52798: , PO_REQ_LINES_REF_V l4
52799: , (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
52800: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 52941: TYPE t_array_source_7 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

52937: TYPE t_array_source_48 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
52938: TYPE t_array_source_49 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
52939:
52940: TYPE t_array_source_3 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
52941: TYPE t_array_source_7 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
52942: TYPE t_array_source_8 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
52943: TYPE t_array_source_9 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
52944: TYPE t_array_source_13 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
52945: TYPE t_array_source_15 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 52942: TYPE t_array_source_8 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;

52938: TYPE t_array_source_49 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
52939:
52940: TYPE t_array_source_3 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
52941: TYPE t_array_source_7 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
52942: TYPE t_array_source_8 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
52943: TYPE t_array_source_9 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
52944: TYPE t_array_source_13 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
52945: TYPE t_array_source_15 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
52946: TYPE t_array_source_17 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 53092: , FV_XLA_PO_REF_V l1

53088: , l2.REQ_ENCUM_UPG_OPTION source_45
53089: , l2.REQ_UPG_ENC_TYPE_ID source_46
53090: , l2.ADJUSTMENT_STATUS source_47
53091: FROM xla_events_gt xet
53092: , FV_XLA_PO_REF_V l1
53093: , PO_REQ_EXTRACT_DETAIL_V l2
53094: , PO_REQ_LINES_REF_V l4
53095: WHERE xet.event_id between x_first_event_id and x_last_event_id
53096: and xet.event_date between p_pad_start_date and p_pad_end_date