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_REQ_LINES_REF_V

Line 52675: WHEN 17 THEN 'PO_REQ_LINES_REF_V'

52671: WHEN 13 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52672: WHEN 14 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52673: WHEN 15 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52674: WHEN 16 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52675: WHEN 17 THEN 'PO_REQ_LINES_REF_V'
52676: WHEN 18 THEN 'PO_REQ_LINES_REF_V'
52677: WHEN 19 THEN 'PO_REQ_LINES_REF_V'
52678: WHEN 20 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52679: WHEN 21 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 52676: WHEN 18 THEN 'PO_REQ_LINES_REF_V'

52672: WHEN 14 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52673: WHEN 15 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52674: WHEN 16 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52675: WHEN 17 THEN 'PO_REQ_LINES_REF_V'
52676: WHEN 18 THEN 'PO_REQ_LINES_REF_V'
52677: WHEN 19 THEN 'PO_REQ_LINES_REF_V'
52678: WHEN 20 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52679: WHEN 21 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52680: WHEN 22 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 52677: WHEN 19 THEN 'PO_REQ_LINES_REF_V'

52673: WHEN 15 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52674: WHEN 16 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52675: WHEN 17 THEN 'PO_REQ_LINES_REF_V'
52676: WHEN 18 THEN 'PO_REQ_LINES_REF_V'
52677: WHEN 19 THEN 'PO_REQ_LINES_REF_V'
52678: WHEN 20 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52679: WHEN 21 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52680: WHEN 22 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52681: WHEN 23 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 52798: , PO_REQ_LINES_REF_V l4

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
52801: AND xet.event_class_code = C_EVENT_CLASS_CODE
52802: AND l2.event_id = xet.event_id

Line 52956: TYPE t_array_source_35 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

52952: TYPE t_array_source_26 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
52953: TYPE t_array_source_27 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
52954: TYPE t_array_source_28 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
52955: TYPE t_array_source_31 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
52956: TYPE t_array_source_35 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
52957: TYPE t_array_source_36 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
52958: TYPE t_array_source_37 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
52959: TYPE t_array_source_43 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
52960: TYPE t_array_source_45 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

Line 52957: TYPE t_array_source_36 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

52953: TYPE t_array_source_27 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
52954: TYPE t_array_source_28 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
52955: TYPE t_array_source_31 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
52956: TYPE t_array_source_35 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
52957: TYPE t_array_source_36 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
52958: TYPE t_array_source_37 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
52959: TYPE t_array_source_43 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
52960: TYPE t_array_source_45 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
52961: TYPE t_array_source_46 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 52958: TYPE t_array_source_37 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

52954: TYPE t_array_source_28 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
52955: TYPE t_array_source_31 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
52956: TYPE t_array_source_35 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
52957: TYPE t_array_source_36 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
52958: TYPE t_array_source_37 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
52959: TYPE t_array_source_43 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
52960: TYPE t_array_source_45 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
52961: TYPE t_array_source_46 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
52962: TYPE t_array_source_47 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ADJUSTMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;

Line 53094: , PO_REQ_LINES_REF_V l4

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
53097: and xet.event_class_code = C_EVENT_CLASS_CODE
53098: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id