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 PO_DISTS_REF_V

Line 47376: WHEN 26 THEN 'PO_DISTS_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'
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'

Line 47377: WHEN 27 THEN 'PO_DISTS_REF_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'
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'

Line 47378: WHEN 28 THEN 'PO_DISTS_REF_V'

47374: WHEN 24 THEN 'PO_EXTRACT_DETAIL_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:

Line 47529: , PO_DISTS_REF_V l2

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
47533: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 47697: TYPE t_array_source_35 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%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;
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;

Line 47698: TYPE t_array_source_36 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%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;
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;

Line 47699: TYPE t_array_source_37 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%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;
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:

Line 47849: , PO_DISTS_REF_V l2

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
47853: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 50180: WHEN 25 THEN 'PO_DISTS_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'
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'

Line 50181: WHEN 26 THEN 'PO_DISTS_REF_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'
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'

Line 50182: WHEN 27 THEN 'PO_DISTS_REF_V'

50178: WHEN 23 THEN 'PO_EXTRACT_DETAIL_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:

Line 50329: , PO_DISTS_REF_V l2

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
50333: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 50497: TYPE t_array_source_35 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%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;
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;

Line 50498: TYPE t_array_source_36 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%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;
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;

Line 50499: TYPE t_array_source_37 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%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;
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:

Line 50650: , PO_DISTS_REF_V l2

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
50654: and xet.event_class_code = C_EVENT_CLASS_CODE