APPS.XLA_00201_AAD_S_000004_BC_PKG dependencies on PO_RELEASES_REF_V

Line 50034: WHEN 3 THEN 'PO_RELEASES_REF_V'

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

Line 50085: , PO_RELEASES_REF_V h5

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
50089: AND h4.event_id = xet.event_id

Line 50468: TYPE t_array_source_4 IS TABLE OF PO_RELEASES_REF_V.PO_RELEASE_NUMBER%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;
50472:

Line 50579: , PO_RELEASES_REF_V h5

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
50583: AND h4.po_release_id = h5.po_release_id