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

Line 41107: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

41103: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41104: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41105: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41106: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41107: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
41108: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41109: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41110: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41111:

Line 41195: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

41191: ELSE null
41192: END source_meaning
41193: FROM xla_events_gt xet
41194: , AP_INVOICE_EXTRACT_HEADER_V h2
41195: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
41196: , fnd_lookup_values fvl13
41197: , fnd_lookup_values fvl60
41198: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
41199: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 41746: TYPE t_array_source_60 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

41742: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
41743: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
41744: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
41745: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
41746: TYPE t_array_source_60 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
41747: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
41748: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
41749: TYPE t_array_source_73 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
41750:

Line 41930: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

41926: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_72
41927: , h2.INV_DOC_SEQUENCE_VALUE source_73
41928: FROM xla_events_gt xet
41929: , AP_INVOICE_EXTRACT_HEADER_V h2
41930: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
41931: , fnd_lookup_values fvl13
41932: , fnd_lookup_values fvl60
41933: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
41934: and xet.event_class_code = C_EVENT_CLASS_CODE