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

Line 79332: WHEN 14 THEN 'AR_RCT_SITE_USES_H_V'

79328: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
79329: WHEN 11 THEN 'AR_RCT_METHOD_H_V'
79330: WHEN 12 THEN 'AR_RCT_METHOD_H_V'
79331: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
79332: WHEN 14 THEN 'AR_RCT_SITE_USES_H_V'
79333: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
79334: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
79335: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
79336: WHEN 18 THEN 'AR_CASH_RECEIPTS_H_V'

Line 79438: , AR_RCT_SITE_USES_H_V h7

79434: , null source_meaning
79435: FROM xla_events_gt xet
79436: , AR_CASH_RECEIPTS_H_V h2
79437: , AR_RCT_METHOD_H_V h6
79438: , AR_RCT_SITE_USES_H_V h7
79439: , AR_REMIT_BANK_ACCT_H_V h9
79440: , AR_SYSTEM_PARAM_H_V h10
79441: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
79442: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 79879: TYPE t_array_source_79 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

79875: TYPE t_array_source_60 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
79876: TYPE t_array_source_72 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
79877: TYPE t_array_source_73 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
79878: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79879: TYPE t_array_source_79 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79880: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
79881: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79882: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79883: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 80029: , AR_RCT_SITE_USES_H_V h7

80025: , h2.RCT_TRX_ACCT_REVERSAL source_91
80026: FROM xla_events_gt xet
80027: , AR_CASH_RECEIPTS_H_V h2
80028: , AR_RCT_METHOD_H_V h6
80029: , AR_RCT_SITE_USES_H_V h7
80030: , AR_REMIT_BANK_ACCT_H_V h9
80031: , AR_SYSTEM_PARAM_H_V h10
80032: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
80033: and xet.event_class_code = C_EVENT_CLASS_CODE