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

Line 64033: WHEN 12 THEN 'AR_RCT_SITE_USES_H_V'

64029: WHEN 8 THEN 'AR_RCT_METHOD_H_V'
64030: WHEN 9 THEN 'AR_RCT_METHOD_H_V'
64031: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
64032: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
64033: WHEN 12 THEN 'AR_RCT_SITE_USES_H_V'
64034: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
64035: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
64036: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
64037: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'

Line 64131: , AR_RCT_SITE_USES_H_V h6

64127: , null source_meaning
64128: FROM xla_events_gt xet
64129: , AR_CASH_RECEIPTS_H_V h1
64130: , AR_RCT_METHOD_H_V h5
64131: , AR_RCT_SITE_USES_H_V h6
64132: , AR_REMIT_BANK_ACCT_H_V h8
64133: , AR_SYSTEM_PARAM_H_V h9
64134: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
64135: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 64531: TYPE t_array_source_69 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

64527: TYPE t_array_source_54 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
64528: TYPE t_array_source_55 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
64529: TYPE t_array_source_56 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
64530: TYPE t_array_source_68 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
64531: TYPE t_array_source_69 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
64532: TYPE t_array_source_70 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
64533: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
64534: TYPE t_array_source_79 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
64535: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 64663: , AR_RCT_SITE_USES_H_V h6

64659: , h1.RCT_TRX_ACCT_REVERSAL source_81
64660: FROM xla_events_gt xet
64661: , AR_CASH_RECEIPTS_H_V h1
64662: , AR_RCT_METHOD_H_V h5
64663: , AR_RCT_SITE_USES_H_V h6
64664: , AR_REMIT_BANK_ACCT_H_V h8
64665: , AR_SYSTEM_PARAM_H_V h9
64666: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
64667: and xet.event_class_code = C_EVENT_CLASS_CODE