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_EXTRACT_HEADER_V

Line 47233: WHEN 1 THEN 'PO_EXTRACT_HEADER_V'

47229: FROM (
47230: SELECT xet.event_id event_id
47231: , 0 line_number
47232: , CASE r
47233: WHEN 1 THEN 'PO_EXTRACT_HEADER_V'
47234: WHEN 2 THEN 'PO_EXTRACT_HEADER_V'
47235: WHEN 3 THEN 'PO_EXTRACT_HEADER_V'
47236: WHEN 4 THEN 'PO_EXTRACT_HEADER_V'
47237: WHEN 5 THEN 'PO_EXTRACT_HEADER_V'

Line 47234: WHEN 2 THEN 'PO_EXTRACT_HEADER_V'

47230: SELECT xet.event_id event_id
47231: , 0 line_number
47232: , CASE r
47233: WHEN 1 THEN 'PO_EXTRACT_HEADER_V'
47234: WHEN 2 THEN 'PO_EXTRACT_HEADER_V'
47235: WHEN 3 THEN 'PO_EXTRACT_HEADER_V'
47236: WHEN 4 THEN 'PO_EXTRACT_HEADER_V'
47237: WHEN 5 THEN 'PO_EXTRACT_HEADER_V'
47238:

Line 47235: WHEN 3 THEN 'PO_EXTRACT_HEADER_V'

47231: , 0 line_number
47232: , CASE r
47233: WHEN 1 THEN 'PO_EXTRACT_HEADER_V'
47234: WHEN 2 THEN 'PO_EXTRACT_HEADER_V'
47235: WHEN 3 THEN 'PO_EXTRACT_HEADER_V'
47236: WHEN 4 THEN 'PO_EXTRACT_HEADER_V'
47237: WHEN 5 THEN 'PO_EXTRACT_HEADER_V'
47238:
47239: ELSE null

Line 47236: WHEN 4 THEN 'PO_EXTRACT_HEADER_V'

47232: , CASE r
47233: WHEN 1 THEN 'PO_EXTRACT_HEADER_V'
47234: WHEN 2 THEN 'PO_EXTRACT_HEADER_V'
47235: WHEN 3 THEN 'PO_EXTRACT_HEADER_V'
47236: WHEN 4 THEN 'PO_EXTRACT_HEADER_V'
47237: WHEN 5 THEN 'PO_EXTRACT_HEADER_V'
47238:
47239: ELSE null
47240: END object_name

Line 47237: WHEN 5 THEN 'PO_EXTRACT_HEADER_V'

47233: WHEN 1 THEN 'PO_EXTRACT_HEADER_V'
47234: WHEN 2 THEN 'PO_EXTRACT_HEADER_V'
47235: WHEN 3 THEN 'PO_EXTRACT_HEADER_V'
47236: WHEN 4 THEN 'PO_EXTRACT_HEADER_V'
47237: WHEN 5 THEN 'PO_EXTRACT_HEADER_V'
47238:
47239: ELSE null
47240: END object_name
47241: , CASE r

Line 47280: , PO_EXTRACT_HEADER_V h4

47276: ELSE null
47277: END source_value
47278: , null source_meaning
47279: FROM xla_events_gt xet
47280: , PO_EXTRACT_HEADER_V h4
47281: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
47282: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
47283: AND xet.event_class_code = C_EVENT_CLASS_CODE
47284: AND h4.event_id = xet.event_id

Line 47666: TYPE t_array_source_1 IS TABLE OF PO_EXTRACT_HEADER_V.PO_TYPE%TYPE INDEX BY BINARY_INTEGER;

47662: --
47663: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
47664: --
47665:
47666: TYPE t_array_source_1 IS TABLE OF PO_EXTRACT_HEADER_V.PO_TYPE%TYPE INDEX BY BINARY_INTEGER;
47667: TYPE t_array_source_2 IS TABLE OF PO_EXTRACT_HEADER_V.PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;
47668: TYPE t_array_source_20 IS TABLE OF PO_EXTRACT_HEADER_V.PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
47669: TYPE t_array_source_48 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
47670: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 47667: TYPE t_array_source_2 IS TABLE OF PO_EXTRACT_HEADER_V.PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;

47663: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
47664: --
47665:
47666: TYPE t_array_source_1 IS TABLE OF PO_EXTRACT_HEADER_V.PO_TYPE%TYPE INDEX BY BINARY_INTEGER;
47667: TYPE t_array_source_2 IS TABLE OF PO_EXTRACT_HEADER_V.PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;
47668: TYPE t_array_source_20 IS TABLE OF PO_EXTRACT_HEADER_V.PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
47669: TYPE t_array_source_48 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
47670: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
47671:

Line 47668: TYPE t_array_source_20 IS TABLE OF PO_EXTRACT_HEADER_V.PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;

47664: --
47665:
47666: TYPE t_array_source_1 IS TABLE OF PO_EXTRACT_HEADER_V.PO_TYPE%TYPE INDEX BY BINARY_INTEGER;
47667: TYPE t_array_source_2 IS TABLE OF PO_EXTRACT_HEADER_V.PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;
47668: TYPE t_array_source_20 IS TABLE OF PO_EXTRACT_HEADER_V.PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
47669: TYPE t_array_source_48 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
47670: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
47671:
47672: TYPE t_array_source_3 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 47669: TYPE t_array_source_48 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

47665:
47666: TYPE t_array_source_1 IS TABLE OF PO_EXTRACT_HEADER_V.PO_TYPE%TYPE INDEX BY BINARY_INTEGER;
47667: TYPE t_array_source_2 IS TABLE OF PO_EXTRACT_HEADER_V.PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;
47668: TYPE t_array_source_20 IS TABLE OF PO_EXTRACT_HEADER_V.PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
47669: TYPE t_array_source_48 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
47670: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
47671:
47672: TYPE t_array_source_3 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
47673: TYPE t_array_source_7 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 47670: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

47666: TYPE t_array_source_1 IS TABLE OF PO_EXTRACT_HEADER_V.PO_TYPE%TYPE INDEX BY BINARY_INTEGER;
47667: TYPE t_array_source_2 IS TABLE OF PO_EXTRACT_HEADER_V.PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;
47668: TYPE t_array_source_20 IS TABLE OF PO_EXTRACT_HEADER_V.PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
47669: TYPE t_array_source_48 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
47670: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
47671:
47672: TYPE t_array_source_3 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
47673: TYPE t_array_source_7 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
47674: TYPE t_array_source_8 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;

Line 47777: , PO_EXTRACT_HEADER_V h4

47773: , h4.PO_HEADER_ID source_20
47774: , h4.ENCUMBRANCE_TYPE_ID source_48
47775: , h4.GL_DATE source_49
47776: FROM xla_events_gt xet
47777: , PO_EXTRACT_HEADER_V h4
47778: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
47779: and xet.event_class_code = C_EVENT_CLASS_CODE
47780: and xet.event_status_code <> 'N' AND h4.event_id = xet.event_id
47781:

Line 50032: WHEN 1 THEN 'PO_EXTRACT_HEADER_V'

50028: FROM (
50029: SELECT xet.event_id event_id
50030: , 0 line_number
50031: , CASE r
50032: WHEN 1 THEN 'PO_EXTRACT_HEADER_V'
50033: WHEN 2 THEN 'PO_EXTRACT_HEADER_V'
50034: WHEN 3 THEN 'PO_RELEASES_REF_V'
50035: WHEN 4 THEN 'PO_EXTRACT_HEADER_V'
50036: WHEN 5 THEN 'PO_EXTRACT_HEADER_V'

Line 50033: WHEN 2 THEN 'PO_EXTRACT_HEADER_V'

50029: SELECT xet.event_id event_id
50030: , 0 line_number
50031: , CASE r
50032: WHEN 1 THEN 'PO_EXTRACT_HEADER_V'
50033: WHEN 2 THEN 'PO_EXTRACT_HEADER_V'
50034: WHEN 3 THEN 'PO_RELEASES_REF_V'
50035: WHEN 4 THEN 'PO_EXTRACT_HEADER_V'
50036: WHEN 5 THEN 'PO_EXTRACT_HEADER_V'
50037: WHEN 6 THEN 'PO_EXTRACT_HEADER_V'

Line 50035: WHEN 4 THEN 'PO_EXTRACT_HEADER_V'

50031: , CASE r
50032: WHEN 1 THEN 'PO_EXTRACT_HEADER_V'
50033: WHEN 2 THEN 'PO_EXTRACT_HEADER_V'
50034: WHEN 3 THEN 'PO_RELEASES_REF_V'
50035: WHEN 4 THEN 'PO_EXTRACT_HEADER_V'
50036: WHEN 5 THEN 'PO_EXTRACT_HEADER_V'
50037: WHEN 6 THEN 'PO_EXTRACT_HEADER_V'
50038:
50039: ELSE null

Line 50036: WHEN 5 THEN 'PO_EXTRACT_HEADER_V'

50032: WHEN 1 THEN 'PO_EXTRACT_HEADER_V'
50033: WHEN 2 THEN 'PO_EXTRACT_HEADER_V'
50034: WHEN 3 THEN 'PO_RELEASES_REF_V'
50035: WHEN 4 THEN 'PO_EXTRACT_HEADER_V'
50036: WHEN 5 THEN 'PO_EXTRACT_HEADER_V'
50037: WHEN 6 THEN 'PO_EXTRACT_HEADER_V'
50038:
50039: ELSE null
50040: END object_name

Line 50037: WHEN 6 THEN 'PO_EXTRACT_HEADER_V'

50033: WHEN 2 THEN 'PO_EXTRACT_HEADER_V'
50034: WHEN 3 THEN 'PO_RELEASES_REF_V'
50035: WHEN 4 THEN 'PO_EXTRACT_HEADER_V'
50036: WHEN 5 THEN 'PO_EXTRACT_HEADER_V'
50037: WHEN 6 THEN 'PO_EXTRACT_HEADER_V'
50038:
50039: ELSE null
50040: END object_name
50041: , CASE r

Line 50084: , PO_EXTRACT_HEADER_V h4

50080: ELSE null
50081: END source_value
50082: , null source_meaning
50083: FROM xla_events_gt xet
50084: , PO_EXTRACT_HEADER_V h4
50085: , PO_RELEASES_REF_V h5
50086: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
50087: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
50088: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 50466: TYPE t_array_source_1 IS TABLE OF PO_EXTRACT_HEADER_V.PO_TYPE%TYPE INDEX BY BINARY_INTEGER;

50462: --
50463: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
50464: --
50465:
50466: TYPE t_array_source_1 IS TABLE OF PO_EXTRACT_HEADER_V.PO_TYPE%TYPE INDEX BY BINARY_INTEGER;
50467: TYPE t_array_source_2 IS TABLE OF PO_EXTRACT_HEADER_V.PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;
50468: TYPE t_array_source_4 IS TABLE OF PO_RELEASES_REF_V.PO_RELEASE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
50469: TYPE t_array_source_41 IS TABLE OF PO_EXTRACT_HEADER_V.PO_RELEASE_ID%TYPE INDEX BY BINARY_INTEGER;
50470: TYPE t_array_source_48 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 50467: TYPE t_array_source_2 IS TABLE OF PO_EXTRACT_HEADER_V.PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;

50463: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
50464: --
50465:
50466: TYPE t_array_source_1 IS TABLE OF PO_EXTRACT_HEADER_V.PO_TYPE%TYPE INDEX BY BINARY_INTEGER;
50467: TYPE t_array_source_2 IS TABLE OF PO_EXTRACT_HEADER_V.PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;
50468: TYPE t_array_source_4 IS TABLE OF PO_RELEASES_REF_V.PO_RELEASE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
50469: TYPE t_array_source_41 IS TABLE OF PO_EXTRACT_HEADER_V.PO_RELEASE_ID%TYPE INDEX BY BINARY_INTEGER;
50470: TYPE t_array_source_48 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
50471: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 50469: TYPE t_array_source_41 IS TABLE OF PO_EXTRACT_HEADER_V.PO_RELEASE_ID%TYPE INDEX BY BINARY_INTEGER;

50465:
50466: TYPE t_array_source_1 IS TABLE OF PO_EXTRACT_HEADER_V.PO_TYPE%TYPE INDEX BY BINARY_INTEGER;
50467: TYPE t_array_source_2 IS TABLE OF PO_EXTRACT_HEADER_V.PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;
50468: TYPE t_array_source_4 IS TABLE OF PO_RELEASES_REF_V.PO_RELEASE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
50469: TYPE t_array_source_41 IS TABLE OF PO_EXTRACT_HEADER_V.PO_RELEASE_ID%TYPE INDEX BY BINARY_INTEGER;
50470: TYPE t_array_source_48 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
50471: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
50472:
50473: TYPE t_array_source_3 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 50470: TYPE t_array_source_48 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

50466: TYPE t_array_source_1 IS TABLE OF PO_EXTRACT_HEADER_V.PO_TYPE%TYPE INDEX BY BINARY_INTEGER;
50467: TYPE t_array_source_2 IS TABLE OF PO_EXTRACT_HEADER_V.PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;
50468: TYPE t_array_source_4 IS TABLE OF PO_RELEASES_REF_V.PO_RELEASE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
50469: TYPE t_array_source_41 IS TABLE OF PO_EXTRACT_HEADER_V.PO_RELEASE_ID%TYPE INDEX BY BINARY_INTEGER;
50470: TYPE t_array_source_48 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
50471: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
50472:
50473: TYPE t_array_source_3 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
50474: TYPE t_array_source_7 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 50471: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

50467: TYPE t_array_source_2 IS TABLE OF PO_EXTRACT_HEADER_V.PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;
50468: TYPE t_array_source_4 IS TABLE OF PO_RELEASES_REF_V.PO_RELEASE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
50469: TYPE t_array_source_41 IS TABLE OF PO_EXTRACT_HEADER_V.PO_RELEASE_ID%TYPE INDEX BY BINARY_INTEGER;
50470: TYPE t_array_source_48 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
50471: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
50472:
50473: TYPE t_array_source_3 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
50474: TYPE t_array_source_7 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
50475: TYPE t_array_source_8 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;

Line 50578: , PO_EXTRACT_HEADER_V h4

50574: , h4.PO_RELEASE_ID source_41
50575: , h4.ENCUMBRANCE_TYPE_ID source_48
50576: , h4.GL_DATE source_49
50577: FROM xla_events_gt xet
50578: , PO_EXTRACT_HEADER_V h4
50579: , PO_RELEASES_REF_V h5
50580: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
50581: and xet.event_class_code = C_EVENT_CLASS_CODE
50582: and xet.event_status_code <> 'N' AND h4.event_id = xet.event_id