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

Line 80581: WHEN 12 THEN 'AR_RCT_SITE_USES_H_V'

80577: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
80578: WHEN 9 THEN 'AR_RCT_METHOD_H_V'
80579: WHEN 10 THEN 'AR_RCT_METHOD_H_V'
80580: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
80581: WHEN 12 THEN 'AR_RCT_SITE_USES_H_V'
80582: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
80583: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
80584: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
80585: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'

Line 80679: , AR_RCT_SITE_USES_H_V h7

80675: , null source_meaning
80676: FROM xla_events_gt xet
80677: , AR_CASH_RECEIPTS_H_V h2
80678: , AR_RCT_METHOD_H_V h6
80679: , AR_RCT_SITE_USES_H_V h7
80680: , AR_REMIT_BANK_ACCT_H_V h9
80681: , AR_SYSTEM_PARAM_H_V h10
80682: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
80683: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 81118: TYPE t_array_source_77 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

81114: TYPE t_array_source_58 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
81115: TYPE t_array_source_70 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
81116: TYPE t_array_source_71 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
81117: TYPE t_array_source_76 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
81118: TYPE t_array_source_77 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
81119: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
81120: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
81121: TYPE t_array_source_87 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
81122: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 81264: , AR_RCT_SITE_USES_H_V h7

81260: , h2.RCT_TRX_ACCT_REVERSAL source_89
81261: FROM xla_events_gt xet
81262: , AR_CASH_RECEIPTS_H_V h2
81263: , AR_RCT_METHOD_H_V h6
81264: , AR_RCT_SITE_USES_H_V h7
81265: , AR_REMIT_BANK_ACCT_H_V h9
81266: , AR_SYSTEM_PARAM_H_V h10
81267: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
81268: and xet.event_class_code = C_EVENT_CLASS_CODE