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

Line 78555: WHEN 7 THEN 'AR_RCT_SITE_USES_H_V'

78551: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
78552: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
78553: WHEN 5 THEN 'AR_CASH_RECEIPTS_H_V'
78554: WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V'
78555: WHEN 7 THEN 'AR_RCT_SITE_USES_H_V'
78556: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
78557: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
78558: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
78559: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'

Line 78642: , AR_RCT_SITE_USES_H_V h6

78638: END source_value
78639: , null source_meaning
78640: FROM xla_events_gt xet
78641: , AR_CASH_RECEIPTS_H_V h2
78642: , AR_RCT_SITE_USES_H_V h6
78643: , AR_REMIT_BANK_ACCT_H_V h8
78644: , AR_SYSTEM_PARAM_H_V h9
78645: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
78646: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 79090: TYPE t_array_source_73 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

79086: TYPE t_array_source_17 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
79087: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNIDENTIFIED_CCID%TYPE INDEX BY BINARY_INTEGER;
79088: TYPE t_array_source_58 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
79089: TYPE t_array_source_72 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79090: TYPE t_array_source_73 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79091: TYPE t_array_source_74 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
79092: TYPE t_array_source_75 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79093: TYPE t_array_source_76 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_CUSTOMER_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79094: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 79237: , AR_RCT_SITE_USES_H_V h6

79233: , h2.RCT_DOC_SEQUENCE_VALUE source_85
79234: , h2.RCT_TRX_ACCT_REVERSAL source_86
79235: FROM xla_events_gt xet
79236: , AR_CASH_RECEIPTS_H_V h2
79237: , AR_RCT_SITE_USES_H_V h6
79238: , AR_REMIT_BANK_ACCT_H_V h8
79239: , AR_SYSTEM_PARAM_H_V h9
79240: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
79241: and xet.event_class_code = C_EVENT_CLASS_CODE