APPS.XLA_00201_AAD_S_000005_BC_PKG dependencies on PO_RELEASES_REF_V

Line 52762: WHEN 3 THEN 'PO_RELEASES_REF_V'

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'
52766:

Line 52813: , PO_RELEASES_REF_V h4

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
52817: AND h3.event_id = xet.event_id

Line 53160: TYPE t_array_source_8 IS TABLE OF PO_RELEASES_REF_V.PO_RELEASE_NUMBER%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;
53164:

Line 53257: , PO_RELEASES_REF_V h4

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
53261: AND h3.po_release_id = h4.po_release_id