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_EXTRACT_HEADER_V

Line 52541: WHEN 1 THEN 'PO_REQ_EXTRACT_HEADER_V'

52537: FROM (
52538: SELECT xet.event_id event_id
52539: , 0 line_number
52540: , CASE r
52541: WHEN 1 THEN 'PO_REQ_EXTRACT_HEADER_V'
52542: WHEN 2 THEN 'PO_REQ_EXTRACT_HEADER_V'
52543: WHEN 3 THEN 'PO_REQ_EXTRACT_HEADER_V'
52544: WHEN 4 THEN 'PO_REQ_EXTRACT_HEADER_V'
52545: WHEN 5 THEN 'PO_REQ_EXTRACT_HEADER_V'

Line 52542: WHEN 2 THEN 'PO_REQ_EXTRACT_HEADER_V'

52538: SELECT xet.event_id event_id
52539: , 0 line_number
52540: , CASE r
52541: WHEN 1 THEN 'PO_REQ_EXTRACT_HEADER_V'
52542: WHEN 2 THEN 'PO_REQ_EXTRACT_HEADER_V'
52543: WHEN 3 THEN 'PO_REQ_EXTRACT_HEADER_V'
52544: WHEN 4 THEN 'PO_REQ_EXTRACT_HEADER_V'
52545: WHEN 5 THEN 'PO_REQ_EXTRACT_HEADER_V'
52546:

Line 52543: WHEN 3 THEN 'PO_REQ_EXTRACT_HEADER_V'

52539: , 0 line_number
52540: , CASE r
52541: WHEN 1 THEN 'PO_REQ_EXTRACT_HEADER_V'
52542: WHEN 2 THEN 'PO_REQ_EXTRACT_HEADER_V'
52543: WHEN 3 THEN 'PO_REQ_EXTRACT_HEADER_V'
52544: WHEN 4 THEN 'PO_REQ_EXTRACT_HEADER_V'
52545: WHEN 5 THEN 'PO_REQ_EXTRACT_HEADER_V'
52546:
52547: ELSE null

Line 52544: WHEN 4 THEN 'PO_REQ_EXTRACT_HEADER_V'

52540: , CASE r
52541: WHEN 1 THEN 'PO_REQ_EXTRACT_HEADER_V'
52542: WHEN 2 THEN 'PO_REQ_EXTRACT_HEADER_V'
52543: WHEN 3 THEN 'PO_REQ_EXTRACT_HEADER_V'
52544: WHEN 4 THEN 'PO_REQ_EXTRACT_HEADER_V'
52545: WHEN 5 THEN 'PO_REQ_EXTRACT_HEADER_V'
52546:
52547: ELSE null
52548: END object_name

Line 52545: WHEN 5 THEN 'PO_REQ_EXTRACT_HEADER_V'

52541: WHEN 1 THEN 'PO_REQ_EXTRACT_HEADER_V'
52542: WHEN 2 THEN 'PO_REQ_EXTRACT_HEADER_V'
52543: WHEN 3 THEN 'PO_REQ_EXTRACT_HEADER_V'
52544: WHEN 4 THEN 'PO_REQ_EXTRACT_HEADER_V'
52545: WHEN 5 THEN 'PO_REQ_EXTRACT_HEADER_V'
52546:
52547: ELSE null
52548: END object_name
52549: , CASE r

Line 52588: , PO_REQ_EXTRACT_HEADER_V h3

52584: ELSE null
52585: END source_value
52586: , null source_meaning
52587: FROM xla_events_gt xet
52588: , PO_REQ_EXTRACT_HEADER_V h3
52589: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
52590: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
52591: AND xet.event_class_code = C_EVENT_CLASS_CODE
52592: AND h3.event_id = xet.event_id

Line 52934: TYPE t_array_source_5 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

52930: --
52931: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
52932: --
52933:
52934: TYPE t_array_source_5 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
52935: TYPE t_array_source_6 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.REQ_NUMBER%TYPE INDEX BY BINARY_INTEGER;
52936: TYPE t_array_source_44 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.REQ_ID%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;

Line 52935: TYPE t_array_source_6 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.REQ_NUMBER%TYPE INDEX BY BINARY_INTEGER;

52931: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
52932: --
52933:
52934: TYPE t_array_source_5 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
52935: TYPE t_array_source_6 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.REQ_NUMBER%TYPE INDEX BY BINARY_INTEGER;
52936: TYPE t_array_source_44 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.REQ_ID%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:

Line 52936: TYPE t_array_source_44 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.REQ_ID%TYPE INDEX BY BINARY_INTEGER;

52932: --
52933:
52934: TYPE t_array_source_5 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
52935: TYPE t_array_source_6 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.REQ_NUMBER%TYPE INDEX BY BINARY_INTEGER;
52936: TYPE t_array_source_44 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.REQ_ID%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;

Line 52937: TYPE t_array_source_48 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

52933:
52934: TYPE t_array_source_5 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
52935: TYPE t_array_source_6 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.REQ_NUMBER%TYPE INDEX BY BINARY_INTEGER;
52936: TYPE t_array_source_44 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.REQ_ID%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;

Line 52938: TYPE t_array_source_49 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

52934: TYPE t_array_source_5 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
52935: TYPE t_array_source_6 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.REQ_NUMBER%TYPE INDEX BY BINARY_INTEGER;
52936: TYPE t_array_source_44 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.REQ_ID%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;

Line 53029: , PO_REQ_EXTRACT_HEADER_V h3

53025: , h3.REQ_ID source_44
53026: , h3.ENCUMBRANCE_TYPE_ID source_48
53027: , h3.GL_DATE source_49
53028: FROM xla_events_gt xet
53029: , PO_REQ_EXTRACT_HEADER_V h3
53030: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
53031: and xet.event_class_code = C_EVENT_CLASS_CODE
53032: and xet.event_status_code <> 'N' AND h3.event_id = xet.event_id
53033: