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_00222_AAD_S_000004_PKG dependencies on AR_SYSTEM_PARAM_H_V

Line 22278: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'

22274: SELECT xet.event_id event_id
22275: , 0 line_number
22276: , CASE r
22277: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
22278: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
22279: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'
22280: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
22281: WHEN 5 THEN 'AR_CASH_RECEIPTS_H_V'
22282: WHEN 6 THEN 'AR_RCT_SITE_USES_H_V'

Line 22279: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'

22275: , 0 line_number
22276: , CASE r
22277: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
22278: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
22279: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'
22280: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
22281: WHEN 5 THEN 'AR_CASH_RECEIPTS_H_V'
22282: WHEN 6 THEN 'AR_RCT_SITE_USES_H_V'
22283: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'

Line 22357: , AR_SYSTEM_PARAM_H_V h8

22353: FROM xla_events_gt xet
22354: , AR_CASH_RECEIPTS_H_V h1
22355: , AR_RCT_SITE_USES_H_V h5
22356: , AR_REMIT_BANK_ACCT_H_V h7
22357: , AR_SYSTEM_PARAM_H_V h8
22358: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
22359: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
22360: AND xet.event_class_code = C_EVENT_CLASS_CODE
22361: AND h1.event_id = xet.event_id

Line 22749: TYPE t_array_source_3 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;

22745: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
22746: --
22747:
22748: TYPE t_array_source_2 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
22749: TYPE t_array_source_3 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
22750: TYPE t_array_source_4 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
22751: TYPE t_array_source_17 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
22752: TYPE t_array_source_34 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
22753: TYPE t_array_source_35 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 22750: TYPE t_array_source_4 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;

22746: --
22747:
22748: TYPE t_array_source_2 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
22749: TYPE t_array_source_3 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
22750: TYPE t_array_source_4 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
22751: TYPE t_array_source_17 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
22752: TYPE t_array_source_34 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
22753: TYPE t_array_source_35 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
22754: TYPE t_array_source_36 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;

Line 22876: , AR_SYSTEM_PARAM_H_V h8

22872: FROM xla_events_gt xet
22873: , AR_CASH_RECEIPTS_H_V h1
22874: , AR_RCT_SITE_USES_H_V h5
22875: , AR_REMIT_BANK_ACCT_H_V h7
22876: , AR_SYSTEM_PARAM_H_V h8
22877: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
22878: and xet.event_class_code = C_EVENT_CLASS_CODE
22879: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
22880: AND h5.event_id (+) = h1.event_id