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_DISTS_REF_V

Line 51105: WHEN 21 THEN 'PO_DISTS_REF_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'
51109: WHEN 25 THEN 'PO_EXTRACT_DETAIL_V'

Line 51106: WHEN 22 THEN 'PO_DISTS_REF_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'
51109: WHEN 25 THEN 'PO_EXTRACT_DETAIL_V'
51110:

Line 51107: WHEN 23 THEN 'PO_DISTS_REF_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'
51109: WHEN 25 THEN 'PO_EXTRACT_DETAIL_V'
51110:
51111: ELSE null

Line 51232: , PO_DISTS_REF_V l1

51228: ELSE null
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

Line 51395: TYPE t_array_source_62 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%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;
51399: TYPE t_array_source_75 IS TABLE OF PO_EXTRACT_DETAIL_V.ADJUSTMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;

Line 51396: TYPE t_array_source_63 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%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;
51399: TYPE t_array_source_75 IS TABLE OF PO_EXTRACT_DETAIL_V.ADJUSTMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
51400:

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

Line 51533: , PO_DISTS_REF_V l1

51529: , l1.CURRENCY_CONVERSION_TYPE source_64
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

Line 52903: WHEN 20 THEN 'PO_DISTS_REF_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'
52907:

Line 52904: WHEN 21 THEN 'PO_DISTS_REF_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'
52907:
52908: ELSE null

Line 52905: WHEN 22 THEN 'PO_DISTS_REF_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'
52907:
52908: ELSE null
52909: END object_name

Line 53021: , PO_DISTS_REF_V l1

53017: ELSE null
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

Line 53184: TYPE t_array_source_62 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%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;
53188:

Line 53185: TYPE t_array_source_63 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%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;
53188:
53189: l_array_source_1 t_array_source_1;

Line 53186: TYPE t_array_source_64 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%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;
53188:
53189: l_array_source_1 t_array_source_1;
53190: l_array_source_2 t_array_source_2;

Line 53320: , PO_DISTS_REF_V l1

53316: , l1.CURRENCY_CONVERSION_RATE source_63
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