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_EXTRACT_HEADER_V

Line 50967: WHEN 1 THEN 'PO_EXTRACT_HEADER_V'

50963: FROM (
50964: SELECT xet.event_id event_id
50965: , 0 line_number
50966: , CASE r
50967: WHEN 1 THEN 'PO_EXTRACT_HEADER_V'
50968: WHEN 2 THEN 'PO_EXTRACT_HEADER_V'
50969: WHEN 3 THEN 'PO_EXTRACT_HEADER_V'
50970: WHEN 4 THEN 'PO_EXTRACT_HEADER_V'
50971: WHEN 5 THEN 'PO_EXTRACT_HEADER_V'

Line 50968: WHEN 2 THEN 'PO_EXTRACT_HEADER_V'

50964: SELECT xet.event_id event_id
50965: , 0 line_number
50966: , CASE r
50967: WHEN 1 THEN 'PO_EXTRACT_HEADER_V'
50968: WHEN 2 THEN 'PO_EXTRACT_HEADER_V'
50969: WHEN 3 THEN 'PO_EXTRACT_HEADER_V'
50970: WHEN 4 THEN 'PO_EXTRACT_HEADER_V'
50971: WHEN 5 THEN 'PO_EXTRACT_HEADER_V'
50972:

Line 50969: WHEN 3 THEN 'PO_EXTRACT_HEADER_V'

50965: , 0 line_number
50966: , CASE r
50967: WHEN 1 THEN 'PO_EXTRACT_HEADER_V'
50968: WHEN 2 THEN 'PO_EXTRACT_HEADER_V'
50969: WHEN 3 THEN 'PO_EXTRACT_HEADER_V'
50970: WHEN 4 THEN 'PO_EXTRACT_HEADER_V'
50971: WHEN 5 THEN 'PO_EXTRACT_HEADER_V'
50972:
50973: ELSE null

Line 50970: WHEN 4 THEN 'PO_EXTRACT_HEADER_V'

50966: , CASE r
50967: WHEN 1 THEN 'PO_EXTRACT_HEADER_V'
50968: WHEN 2 THEN 'PO_EXTRACT_HEADER_V'
50969: WHEN 3 THEN 'PO_EXTRACT_HEADER_V'
50970: WHEN 4 THEN 'PO_EXTRACT_HEADER_V'
50971: WHEN 5 THEN 'PO_EXTRACT_HEADER_V'
50972:
50973: ELSE null
50974: END object_name

Line 50971: WHEN 5 THEN 'PO_EXTRACT_HEADER_V'

50967: WHEN 1 THEN 'PO_EXTRACT_HEADER_V'
50968: WHEN 2 THEN 'PO_EXTRACT_HEADER_V'
50969: WHEN 3 THEN 'PO_EXTRACT_HEADER_V'
50970: WHEN 4 THEN 'PO_EXTRACT_HEADER_V'
50971: WHEN 5 THEN 'PO_EXTRACT_HEADER_V'
50972:
50973: ELSE null
50974: END object_name
50975: , CASE r

Line 51014: , PO_EXTRACT_HEADER_V h3

51010: ELSE null
51011: END source_value
51012: , null source_meaning
51013: FROM xla_events_gt xet
51014: , PO_EXTRACT_HEADER_V h3
51015: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
51016: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
51017: AND xet.event_class_code = C_EVENT_CLASS_CODE
51018: AND h3.event_id = xet.event_id

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

51365: --
51366: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
51367: --
51368:
51369: TYPE t_array_source_1 IS TABLE OF PO_EXTRACT_HEADER_V.PO_TYPE%TYPE INDEX BY BINARY_INTEGER;
51370: TYPE t_array_source_2 IS TABLE OF PO_EXTRACT_HEADER_V.PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;
51371: TYPE t_array_source_52 IS TABLE OF PO_EXTRACT_HEADER_V.PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
51372: TYPE t_array_source_79 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
51373: TYPE t_array_source_80 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

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

51366: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
51367: --
51368:
51369: TYPE t_array_source_1 IS TABLE OF PO_EXTRACT_HEADER_V.PO_TYPE%TYPE INDEX BY BINARY_INTEGER;
51370: TYPE t_array_source_2 IS TABLE OF PO_EXTRACT_HEADER_V.PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;
51371: TYPE t_array_source_52 IS TABLE OF PO_EXTRACT_HEADER_V.PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
51372: TYPE t_array_source_79 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
51373: TYPE t_array_source_80 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
51374:

Line 51371: TYPE t_array_source_52 IS TABLE OF PO_EXTRACT_HEADER_V.PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;

51367: --
51368:
51369: TYPE t_array_source_1 IS TABLE OF PO_EXTRACT_HEADER_V.PO_TYPE%TYPE INDEX BY BINARY_INTEGER;
51370: TYPE t_array_source_2 IS TABLE OF PO_EXTRACT_HEADER_V.PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;
51371: TYPE t_array_source_52 IS TABLE OF PO_EXTRACT_HEADER_V.PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
51372: TYPE t_array_source_79 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
51373: TYPE t_array_source_80 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
51374:
51375: TYPE t_array_source_7 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 51372: TYPE t_array_source_79 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

51368:
51369: TYPE t_array_source_1 IS TABLE OF PO_EXTRACT_HEADER_V.PO_TYPE%TYPE INDEX BY BINARY_INTEGER;
51370: TYPE t_array_source_2 IS TABLE OF PO_EXTRACT_HEADER_V.PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;
51371: TYPE t_array_source_52 IS TABLE OF PO_EXTRACT_HEADER_V.PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
51372: TYPE t_array_source_79 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
51373: TYPE t_array_source_80 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
51374:
51375: TYPE t_array_source_7 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
51376: TYPE t_array_source_11 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 51373: TYPE t_array_source_80 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

51369: TYPE t_array_source_1 IS TABLE OF PO_EXTRACT_HEADER_V.PO_TYPE%TYPE INDEX BY BINARY_INTEGER;
51370: TYPE t_array_source_2 IS TABLE OF PO_EXTRACT_HEADER_V.PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;
51371: TYPE t_array_source_52 IS TABLE OF PO_EXTRACT_HEADER_V.PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
51372: TYPE t_array_source_79 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
51373: TYPE t_array_source_80 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
51374:
51375: TYPE t_array_source_7 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
51376: TYPE t_array_source_11 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
51377: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 51468: , PO_EXTRACT_HEADER_V h3

51464: , h3.PO_HEADER_ID source_52
51465: , h3.GL_DATE source_79
51466: , h3.ENCUMBRANCE_TYPE_ID source_80
51467: FROM xla_events_gt xet
51468: , PO_EXTRACT_HEADER_V h3
51469: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
51470: and xet.event_class_code = C_EVENT_CLASS_CODE
51471: and xet.event_status_code <> 'N' AND h3.event_id = xet.event_id
51472:

Line 52760: WHEN 1 THEN 'PO_EXTRACT_HEADER_V'

52756: FROM (
52757: SELECT xet.event_id event_id
52758: , 0 line_number
52759: , CASE r
52760: WHEN 1 THEN 'PO_EXTRACT_HEADER_V'
52761: WHEN 2 THEN 'PO_EXTRACT_HEADER_V'
52762: WHEN 3 THEN 'PO_RELEASES_REF_V'
52763: WHEN 4 THEN 'PO_EXTRACT_HEADER_V'
52764: WHEN 5 THEN 'PO_EXTRACT_HEADER_V'

Line 52761: WHEN 2 THEN 'PO_EXTRACT_HEADER_V'

52757: SELECT xet.event_id event_id
52758: , 0 line_number
52759: , CASE r
52760: WHEN 1 THEN 'PO_EXTRACT_HEADER_V'
52761: WHEN 2 THEN 'PO_EXTRACT_HEADER_V'
52762: WHEN 3 THEN 'PO_RELEASES_REF_V'
52763: WHEN 4 THEN 'PO_EXTRACT_HEADER_V'
52764: WHEN 5 THEN 'PO_EXTRACT_HEADER_V'
52765: WHEN 6 THEN 'PO_EXTRACT_HEADER_V'

Line 52763: WHEN 4 THEN 'PO_EXTRACT_HEADER_V'

52759: , CASE r
52760: WHEN 1 THEN 'PO_EXTRACT_HEADER_V'
52761: WHEN 2 THEN 'PO_EXTRACT_HEADER_V'
52762: WHEN 3 THEN 'PO_RELEASES_REF_V'
52763: WHEN 4 THEN 'PO_EXTRACT_HEADER_V'
52764: WHEN 5 THEN 'PO_EXTRACT_HEADER_V'
52765: WHEN 6 THEN 'PO_EXTRACT_HEADER_V'
52766:
52767: ELSE null

Line 52764: WHEN 5 THEN 'PO_EXTRACT_HEADER_V'

52760: WHEN 1 THEN 'PO_EXTRACT_HEADER_V'
52761: WHEN 2 THEN 'PO_EXTRACT_HEADER_V'
52762: WHEN 3 THEN 'PO_RELEASES_REF_V'
52763: WHEN 4 THEN 'PO_EXTRACT_HEADER_V'
52764: WHEN 5 THEN 'PO_EXTRACT_HEADER_V'
52765: WHEN 6 THEN 'PO_EXTRACT_HEADER_V'
52766:
52767: ELSE null
52768: END object_name

Line 52765: WHEN 6 THEN 'PO_EXTRACT_HEADER_V'

52761: WHEN 2 THEN 'PO_EXTRACT_HEADER_V'
52762: WHEN 3 THEN 'PO_RELEASES_REF_V'
52763: WHEN 4 THEN 'PO_EXTRACT_HEADER_V'
52764: WHEN 5 THEN 'PO_EXTRACT_HEADER_V'
52765: WHEN 6 THEN 'PO_EXTRACT_HEADER_V'
52766:
52767: ELSE null
52768: END object_name
52769: , CASE r

Line 52812: , PO_EXTRACT_HEADER_V h3

52808: ELSE null
52809: END source_value
52810: , null source_meaning
52811: FROM xla_events_gt xet
52812: , PO_EXTRACT_HEADER_V h3
52813: , PO_RELEASES_REF_V h4
52814: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
52815: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
52816: AND xet.event_class_code = C_EVENT_CLASS_CODE

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

53154: --
53155: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
53156: --
53157:
53158: TYPE t_array_source_1 IS TABLE OF PO_EXTRACT_HEADER_V.PO_TYPE%TYPE INDEX BY BINARY_INTEGER;
53159: TYPE t_array_source_2 IS TABLE OF PO_EXTRACT_HEADER_V.PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;
53160: TYPE t_array_source_8 IS TABLE OF PO_RELEASES_REF_V.PO_RELEASE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
53161: TYPE t_array_source_66 IS TABLE OF PO_EXTRACT_HEADER_V.PO_RELEASE_ID%TYPE INDEX BY BINARY_INTEGER;
53162: TYPE t_array_source_79 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

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

53155: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
53156: --
53157:
53158: TYPE t_array_source_1 IS TABLE OF PO_EXTRACT_HEADER_V.PO_TYPE%TYPE INDEX BY BINARY_INTEGER;
53159: TYPE t_array_source_2 IS TABLE OF PO_EXTRACT_HEADER_V.PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;
53160: TYPE t_array_source_8 IS TABLE OF PO_RELEASES_REF_V.PO_RELEASE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
53161: TYPE t_array_source_66 IS TABLE OF PO_EXTRACT_HEADER_V.PO_RELEASE_ID%TYPE INDEX BY BINARY_INTEGER;
53162: TYPE t_array_source_79 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
53163: TYPE t_array_source_80 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 53161: TYPE t_array_source_66 IS TABLE OF PO_EXTRACT_HEADER_V.PO_RELEASE_ID%TYPE INDEX BY BINARY_INTEGER;

53157:
53158: TYPE t_array_source_1 IS TABLE OF PO_EXTRACT_HEADER_V.PO_TYPE%TYPE INDEX BY BINARY_INTEGER;
53159: TYPE t_array_source_2 IS TABLE OF PO_EXTRACT_HEADER_V.PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;
53160: TYPE t_array_source_8 IS TABLE OF PO_RELEASES_REF_V.PO_RELEASE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
53161: TYPE t_array_source_66 IS TABLE OF PO_EXTRACT_HEADER_V.PO_RELEASE_ID%TYPE INDEX BY BINARY_INTEGER;
53162: TYPE t_array_source_79 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
53163: TYPE t_array_source_80 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
53164:
53165: TYPE t_array_source_7 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 53162: TYPE t_array_source_79 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

53158: TYPE t_array_source_1 IS TABLE OF PO_EXTRACT_HEADER_V.PO_TYPE%TYPE INDEX BY BINARY_INTEGER;
53159: TYPE t_array_source_2 IS TABLE OF PO_EXTRACT_HEADER_V.PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;
53160: TYPE t_array_source_8 IS TABLE OF PO_RELEASES_REF_V.PO_RELEASE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
53161: TYPE t_array_source_66 IS TABLE OF PO_EXTRACT_HEADER_V.PO_RELEASE_ID%TYPE INDEX BY BINARY_INTEGER;
53162: TYPE t_array_source_79 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
53163: TYPE t_array_source_80 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
53164:
53165: TYPE t_array_source_7 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
53166: TYPE t_array_source_11 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 53163: TYPE t_array_source_80 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

53159: TYPE t_array_source_2 IS TABLE OF PO_EXTRACT_HEADER_V.PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;
53160: TYPE t_array_source_8 IS TABLE OF PO_RELEASES_REF_V.PO_RELEASE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
53161: TYPE t_array_source_66 IS TABLE OF PO_EXTRACT_HEADER_V.PO_RELEASE_ID%TYPE INDEX BY BINARY_INTEGER;
53162: TYPE t_array_source_79 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
53163: TYPE t_array_source_80 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
53164:
53165: TYPE t_array_source_7 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
53166: TYPE t_array_source_11 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
53167: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 53256: , PO_EXTRACT_HEADER_V h3

53252: , h3.PO_RELEASE_ID source_66
53253: , h3.GL_DATE source_79
53254: , h3.ENCUMBRANCE_TYPE_ID source_80
53255: FROM xla_events_gt xet
53256: , PO_EXTRACT_HEADER_V h3
53257: , PO_RELEASES_REF_V h4
53258: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
53259: and xet.event_class_code = C_EVENT_CLASS_CODE
53260: and xet.event_status_code <> 'N' AND h3.event_id = xet.event_id