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_000002_PKG dependencies on AR_RCT_SITE_USES_H_V

Line 83214: WHEN 13 THEN 'AR_RCT_SITE_USES_H_V'

83210: WHEN 9 THEN 'AR_REMIT_BANK_ACCT_H_V'
83211: WHEN 10 THEN 'AR_REMIT_BANK_ACCT_H_V'
83212: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
83213: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
83214: WHEN 13 THEN 'AR_RCT_SITE_USES_H_V'
83215: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
83216: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
83217: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
83218: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'

Line 83321: , AR_RCT_SITE_USES_H_V h6

83317: , null source_meaning
83318: FROM xla_events_gt xet
83319: , AR_CASH_RECEIPTS_H_V h1
83320: , AR_RCT_METHOD_H_V h5
83321: , AR_RCT_SITE_USES_H_V h6
83322: , AR_REMIT_BANK_ACCT_H_V h8
83323: , AR_SYSTEM_PARAM_H_V h9
83324: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
83325: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 83732: TYPE t_array_source_113 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

83728: TYPE t_array_source_36 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
83729: TYPE t_array_source_37 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNIDENTIFIED_CCID%TYPE INDEX BY BINARY_INTEGER;
83730: TYPE t_array_source_101 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
83731: TYPE t_array_source_112 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
83732: TYPE t_array_source_113 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
83733: TYPE t_array_source_114 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
83734: TYPE t_array_source_115 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
83735: TYPE t_array_source_116 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_CUSTOMER_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
83736: TYPE t_array_source_125 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 83873: , AR_RCT_SITE_USES_H_V h6

83869: , h1.RCT_TRX_ACCT_REVERSAL source_127
83870: FROM xla_events_gt xet
83871: , AR_CASH_RECEIPTS_H_V h1
83872: , AR_RCT_METHOD_H_V h5
83873: , AR_RCT_SITE_USES_H_V h6
83874: , AR_REMIT_BANK_ACCT_H_V h8
83875: , AR_SYSTEM_PARAM_H_V h9
83876: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
83877: and xet.event_class_code = C_EVENT_CLASS_CODE