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_RCT_SITE_USES_H_V

Line 22282: WHEN 6 THEN 'AR_RCT_SITE_USES_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'
22284: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
22285: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
22286: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'

Line 22355: , AR_RCT_SITE_USES_H_V h5

22351: END source_value
22352: , null source_meaning
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

Line 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;

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;
22755: TYPE t_array_source_37 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
22756: TYPE t_array_source_38 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
22757: TYPE t_array_source_39 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 22874: , AR_RCT_SITE_USES_H_V h5

22870: , h1.RCT_DOC_SEQUENCE_VALUE source_39
22871: , h1.RCT_TRX_ACCT_REVERSAL source_41
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