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_REQ_LINES_REF_V

Line 57154: WHEN 16 THEN 'PO_REQ_LINES_REF_V'

57150: WHEN 12 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57151: WHEN 13 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57152: WHEN 14 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57153: WHEN 15 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57154: WHEN 16 THEN 'PO_REQ_LINES_REF_V'
57155: WHEN 17 THEN 'PO_REQ_LINES_REF_V'
57156: WHEN 18 THEN 'PO_REQ_LINES_REF_V'
57157: WHEN 19 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57158: WHEN 20 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 57155: WHEN 17 THEN 'PO_REQ_LINES_REF_V'

57151: WHEN 13 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57152: WHEN 14 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57153: WHEN 15 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57154: WHEN 16 THEN 'PO_REQ_LINES_REF_V'
57155: WHEN 17 THEN 'PO_REQ_LINES_REF_V'
57156: WHEN 18 THEN 'PO_REQ_LINES_REF_V'
57157: WHEN 19 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57158: WHEN 20 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57159: WHEN 21 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 57156: WHEN 18 THEN 'PO_REQ_LINES_REF_V'

57152: WHEN 14 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57153: WHEN 15 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57154: WHEN 16 THEN 'PO_REQ_LINES_REF_V'
57155: WHEN 17 THEN 'PO_REQ_LINES_REF_V'
57156: WHEN 18 THEN 'PO_REQ_LINES_REF_V'
57157: WHEN 19 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57158: WHEN 20 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57159: WHEN 21 THEN 'PO_REQ_EXTRACT_DETAIL_V'
57160:

Line 57267: , PO_REQ_LINES_REF_V l3

57263: END source_value
57264: , null source_meaning
57265: FROM xla_events_gt xet
57266: , PO_REQ_EXTRACT_DETAIL_V l1
57267: , PO_REQ_LINES_REF_V l3
57268: , (select rownum r from all_objects where rownum <= 21 and owner = p_apps_owner)
57269: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
57270: AND xet.event_class_code = C_EVENT_CLASS_CODE
57271: AND l1.event_id = xet.event_id

Line 57424: TYPE t_array_source_62 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

57420: TYPE t_array_source_56 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
57421: TYPE t_array_source_57 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
57422: TYPE t_array_source_58 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
57423: TYPE t_array_source_60 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
57424: TYPE t_array_source_62 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
57425: TYPE t_array_source_63 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
57426: TYPE t_array_source_64 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57427: TYPE t_array_source_75 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ADJUSTMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
57428: TYPE t_array_source_77 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

Line 57425: TYPE t_array_source_63 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

57421: TYPE t_array_source_57 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
57422: TYPE t_array_source_58 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
57423: TYPE t_array_source_60 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
57424: TYPE t_array_source_62 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
57425: TYPE t_array_source_63 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
57426: TYPE t_array_source_64 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57427: TYPE t_array_source_75 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ADJUSTMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
57428: TYPE t_array_source_77 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
57429: TYPE t_array_source_78 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 57426: TYPE t_array_source_64 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

57422: TYPE t_array_source_58 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
57423: TYPE t_array_source_60 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
57424: TYPE t_array_source_62 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
57425: TYPE t_array_source_63 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
57426: TYPE t_array_source_64 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57427: TYPE t_array_source_75 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ADJUSTMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
57428: TYPE t_array_source_77 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
57429: TYPE t_array_source_78 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
57430:

Line 57556: , PO_REQ_LINES_REF_V l3

57552: , l1.REQ_ENCUM_UPG_OPTION source_77
57553: , l1.REQ_UPG_ENC_TYPE_ID source_78
57554: FROM xla_events_gt xet
57555: , PO_REQ_EXTRACT_DETAIL_V l1
57556: , PO_REQ_LINES_REF_V l3
57557: WHERE xet.event_id between x_first_event_id and x_last_event_id
57558: and xet.event_date between p_pad_start_date and p_pad_end_date
57559: and xet.event_class_code = C_EVENT_CLASS_CODE
57560: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id