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_EXTRACT_HEADER_V

Line 57021: WHEN 1 THEN 'PO_REQ_EXTRACT_HEADER_V'

57017: FROM (
57018: SELECT xet.event_id event_id
57019: , 0 line_number
57020: , CASE r
57021: WHEN 1 THEN 'PO_REQ_EXTRACT_HEADER_V'
57022: WHEN 2 THEN 'PO_REQ_EXTRACT_HEADER_V'
57023: WHEN 3 THEN 'PO_REQ_EXTRACT_HEADER_V'
57024: WHEN 4 THEN 'PO_REQ_EXTRACT_HEADER_V'
57025: WHEN 5 THEN 'PO_REQ_EXTRACT_HEADER_V'

Line 57022: WHEN 2 THEN 'PO_REQ_EXTRACT_HEADER_V'

57018: SELECT xet.event_id event_id
57019: , 0 line_number
57020: , CASE r
57021: WHEN 1 THEN 'PO_REQ_EXTRACT_HEADER_V'
57022: WHEN 2 THEN 'PO_REQ_EXTRACT_HEADER_V'
57023: WHEN 3 THEN 'PO_REQ_EXTRACT_HEADER_V'
57024: WHEN 4 THEN 'PO_REQ_EXTRACT_HEADER_V'
57025: WHEN 5 THEN 'PO_REQ_EXTRACT_HEADER_V'
57026:

Line 57023: WHEN 3 THEN 'PO_REQ_EXTRACT_HEADER_V'

57019: , 0 line_number
57020: , CASE r
57021: WHEN 1 THEN 'PO_REQ_EXTRACT_HEADER_V'
57022: WHEN 2 THEN 'PO_REQ_EXTRACT_HEADER_V'
57023: WHEN 3 THEN 'PO_REQ_EXTRACT_HEADER_V'
57024: WHEN 4 THEN 'PO_REQ_EXTRACT_HEADER_V'
57025: WHEN 5 THEN 'PO_REQ_EXTRACT_HEADER_V'
57026:
57027: ELSE null

Line 57024: WHEN 4 THEN 'PO_REQ_EXTRACT_HEADER_V'

57020: , CASE r
57021: WHEN 1 THEN 'PO_REQ_EXTRACT_HEADER_V'
57022: WHEN 2 THEN 'PO_REQ_EXTRACT_HEADER_V'
57023: WHEN 3 THEN 'PO_REQ_EXTRACT_HEADER_V'
57024: WHEN 4 THEN 'PO_REQ_EXTRACT_HEADER_V'
57025: WHEN 5 THEN 'PO_REQ_EXTRACT_HEADER_V'
57026:
57027: ELSE null
57028: END object_name

Line 57025: WHEN 5 THEN 'PO_REQ_EXTRACT_HEADER_V'

57021: WHEN 1 THEN 'PO_REQ_EXTRACT_HEADER_V'
57022: WHEN 2 THEN 'PO_REQ_EXTRACT_HEADER_V'
57023: WHEN 3 THEN 'PO_REQ_EXTRACT_HEADER_V'
57024: WHEN 4 THEN 'PO_REQ_EXTRACT_HEADER_V'
57025: WHEN 5 THEN 'PO_REQ_EXTRACT_HEADER_V'
57026:
57027: ELSE null
57028: END object_name
57029: , CASE r

Line 57068: , PO_REQ_EXTRACT_HEADER_V h2

57064: ELSE null
57065: END source_value
57066: , null source_meaning
57067: FROM xla_events_gt xet
57068: , PO_REQ_EXTRACT_HEADER_V h2
57069: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
57070: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
57071: AND xet.event_class_code = C_EVENT_CLASS_CODE
57072: AND h2.event_id = xet.event_id

Line 57403: TYPE t_array_source_9 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

57399: --
57400: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
57401: --
57402:
57403: TYPE t_array_source_9 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
57404: TYPE t_array_source_10 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.REQ_NUMBER%TYPE INDEX BY BINARY_INTEGER;
57405: TYPE t_array_source_76 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.REQ_ID%TYPE INDEX BY BINARY_INTEGER;
57406: TYPE t_array_source_79 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
57407: TYPE t_array_source_80 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 57404: TYPE t_array_source_10 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.REQ_NUMBER%TYPE INDEX BY BINARY_INTEGER;

57400: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
57401: --
57402:
57403: TYPE t_array_source_9 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
57404: TYPE t_array_source_10 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.REQ_NUMBER%TYPE INDEX BY BINARY_INTEGER;
57405: TYPE t_array_source_76 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.REQ_ID%TYPE INDEX BY BINARY_INTEGER;
57406: TYPE t_array_source_79 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
57407: TYPE t_array_source_80 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
57408:

Line 57405: TYPE t_array_source_76 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.REQ_ID%TYPE INDEX BY BINARY_INTEGER;

57401: --
57402:
57403: TYPE t_array_source_9 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
57404: TYPE t_array_source_10 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.REQ_NUMBER%TYPE INDEX BY BINARY_INTEGER;
57405: TYPE t_array_source_76 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.REQ_ID%TYPE INDEX BY BINARY_INTEGER;
57406: TYPE t_array_source_79 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
57407: TYPE t_array_source_80 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
57408:
57409: TYPE t_array_source_7 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 57406: TYPE t_array_source_79 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

57402:
57403: TYPE t_array_source_9 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
57404: TYPE t_array_source_10 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.REQ_NUMBER%TYPE INDEX BY BINARY_INTEGER;
57405: TYPE t_array_source_76 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.REQ_ID%TYPE INDEX BY BINARY_INTEGER;
57406: TYPE t_array_source_79 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
57407: TYPE t_array_source_80 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
57408:
57409: TYPE t_array_source_7 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
57410: TYPE t_array_source_11 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 57407: TYPE t_array_source_80 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

57403: TYPE t_array_source_9 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
57404: TYPE t_array_source_10 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.REQ_NUMBER%TYPE INDEX BY BINARY_INTEGER;
57405: TYPE t_array_source_76 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.REQ_ID%TYPE INDEX BY BINARY_INTEGER;
57406: TYPE t_array_source_79 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
57407: TYPE t_array_source_80 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
57408:
57409: TYPE t_array_source_7 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
57410: TYPE t_array_source_11 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
57411: TYPE t_array_source_13 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 57494: , PO_REQ_EXTRACT_HEADER_V h2

57490: , h2.REQ_ID source_76
57491: , h2.GL_DATE source_79
57492: , h2.ENCUMBRANCE_TYPE_ID source_80
57493: FROM xla_events_gt xet
57494: , PO_REQ_EXTRACT_HEADER_V h2
57495: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
57496: and xet.event_class_code = C_EVENT_CLASS_CODE
57497: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
57498: