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

Line 64306: WHEN 14 THEN 'AR_RCT_SITE_USES_H_V'

64302: WHEN 10 THEN 'AR_RCT_METHOD_H_V'
64303: WHEN 11 THEN 'AR_RCT_METHOD_H_V'
64304: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
64305: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
64306: WHEN 14 THEN 'AR_RCT_SITE_USES_H_V'
64307: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
64308: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
64309: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
64310: WHEN 18 THEN 'AR_CASH_RECEIPTS_H_V'

Line 64412: , AR_RCT_SITE_USES_H_V h6

64408: , null source_meaning
64409: FROM xla_events_gt xet
64410: , AR_CASH_RECEIPTS_H_V h1
64411: , AR_RCT_METHOD_H_V h5
64412: , AR_RCT_SITE_USES_H_V h6
64413: , AR_REMIT_BANK_ACCT_H_V h8
64414: , AR_SYSTEM_PARAM_H_V h9
64415: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
64416: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 64814: TYPE t_array_source_71 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

64810: TYPE t_array_source_56 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
64811: TYPE t_array_source_57 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
64812: TYPE t_array_source_58 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
64813: TYPE t_array_source_70 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
64814: TYPE t_array_source_71 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
64815: TYPE t_array_source_72 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
64816: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
64817: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
64818: TYPE t_array_source_82 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 64950: , AR_RCT_SITE_USES_H_V h6

64946: , h1.RCT_TRX_ACCT_REVERSAL source_83
64947: FROM xla_events_gt xet
64948: , AR_CASH_RECEIPTS_H_V h1
64949: , AR_RCT_METHOD_H_V h5
64950: , AR_RCT_SITE_USES_H_V h6
64951: , AR_REMIT_BANK_ACCT_H_V h8
64952: , AR_SYSTEM_PARAM_H_V h9
64953: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
64954: and xet.event_class_code = C_EVENT_CLASS_CODE