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_08901_AAD_S_000002_PKG dependencies on AP_SYSTEM_PARAMETERS_EXTRACT_V

Line 7638: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

7634: FROM (
7635: SELECT xet.event_id event_id
7636: , 0 line_number
7637: , CASE r
7638: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
7639: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
7640: WHEN 3 THEN 'FV_TREASURY_EXTRACT_HEADER_V'
7641:
7642: ELSE null

Line 7639: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

7635: SELECT xet.event_id event_id
7636: , 0 line_number
7637: , CASE r
7638: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
7639: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
7640: WHEN 3 THEN 'FV_TREASURY_EXTRACT_HEADER_V'
7641:
7642: ELSE null
7643: END object_name

Line 7679: , AP_SYSTEM_PARAMETERS_EXTRACT_V h1

7675:
7676: ELSE null
7677: END source_meaning
7678: FROM xla_events_gt xet
7679: , AP_SYSTEM_PARAMETERS_EXTRACT_V h1
7680: , FV_TREASURY_EXTRACT_HEADER_V h3
7681: , fnd_lookup_values fvl9
7682: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
7683: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 8014: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;

8010: --
8011: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
8012: --
8013:
8014: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
8015: TYPE t_array_source_9 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
8016: TYPE t_array_source_13 IS TABLE OF FV_TREASURY_EXTRACT_HEADER_V.TREASURY_CONFIRMATION_ID%TYPE INDEX BY BINARY_INTEGER;
8017:
8018: TYPE t_array_source_1 IS TABLE OF FV_TREASURY_EXTRACT_DETAILS_V.FV_CHECK_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 8015: TYPE t_array_source_9 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

8011: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
8012: --
8013:
8014: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
8015: TYPE t_array_source_9 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
8016: TYPE t_array_source_13 IS TABLE OF FV_TREASURY_EXTRACT_HEADER_V.TREASURY_CONFIRMATION_ID%TYPE INDEX BY BINARY_INTEGER;
8017:
8018: TYPE t_array_source_1 IS TABLE OF FV_TREASURY_EXTRACT_DETAILS_V.FV_CHECK_NUMBER%TYPE INDEX BY BINARY_INTEGER;
8019: TYPE t_array_source_2 IS TABLE OF FV_TREASURY_EXTRACT_DETAILS_V.FV_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 8099: , AP_SYSTEM_PARAMETERS_EXTRACT_V h1

8095: , h1.ASP_AUTOMATIC_OFFSETS_VALUE source_9
8096: , fvl9.meaning source_9_meaning
8097: , h3.TREASURY_CONFIRMATION_ID source_13
8098: FROM xla_events_gt xet
8099: , AP_SYSTEM_PARAMETERS_EXTRACT_V h1
8100: , FV_TREASURY_EXTRACT_HEADER_V h3
8101: , fnd_lookup_values fvl9
8102: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
8103: and xet.event_class_code = C_EVENT_CLASS_CODE