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_000017_PKG dependencies on AR_REMIT_BANK_ACCT_H_V

Line 77770: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'

77766: WHEN 1 THEN 'AR_CASH_RECEIPTS_H_V'
77767: WHEN 2 THEN 'AR_CASH_RECEIPTS_H_V'
77768: WHEN 3 THEN 'AR_RCT_METHOD_H_V'
77769: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
77770: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
77771: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
77772: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
77773: WHEN 8 THEN 'AR_RECEIVABLES_TRX_MISC_H_V'
77774: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'

Line 77771: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'

77767: WHEN 2 THEN 'AR_CASH_RECEIPTS_H_V'
77768: WHEN 3 THEN 'AR_RCT_METHOD_H_V'
77769: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
77770: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
77771: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
77772: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
77773: WHEN 8 THEN 'AR_RECEIVABLES_TRX_MISC_H_V'
77774: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
77775: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'

Line 77846: , AR_REMIT_BANK_ACCT_H_V h6

77842: FROM xla_events_gt xet
77843: , AR_CASH_RECEIPTS_H_V h1
77844: , AR_RCT_METHOD_H_V h4
77845: , AR_RECEIVABLES_TRX_MISC_H_V h5
77846: , AR_REMIT_BANK_ACCT_H_V h6
77847: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
77848: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77849: AND xet.event_class_code = C_EVENT_CLASS_CODE
77850: AND h5.event_id = xet.event_id

Line 78142: TYPE t_array_source_12 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;

78138: TYPE t_array_source_8 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
78139: TYPE t_array_source_9 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
78140: TYPE t_array_source_10 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
78141: TYPE t_array_source_11 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
78142: TYPE t_array_source_12 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
78143: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
78144: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_CASH_RECEIPT_ID%TYPE INDEX BY BINARY_INTEGER;
78145: TYPE t_array_source_91 IS TABLE OF AR_RECEIVABLES_TRX_MISC_H_V.MC_ACT_NAME%TYPE INDEX BY BINARY_INTEGER;
78146: TYPE t_array_source_117 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 78143: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;

78139: TYPE t_array_source_9 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
78140: TYPE t_array_source_10 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
78141: TYPE t_array_source_11 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
78142: TYPE t_array_source_12 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
78143: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
78144: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_CASH_RECEIPT_ID%TYPE INDEX BY BINARY_INTEGER;
78145: TYPE t_array_source_91 IS TABLE OF AR_RECEIVABLES_TRX_MISC_H_V.MC_ACT_NAME%TYPE INDEX BY BINARY_INTEGER;
78146: TYPE t_array_source_117 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
78147: TYPE t_array_source_118 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 78230: , AR_REMIT_BANK_ACCT_H_V h6

78226: FROM xla_events_gt xet
78227: , AR_CASH_RECEIPTS_H_V h1
78228: , AR_RCT_METHOD_H_V h4
78229: , AR_RECEIVABLES_TRX_MISC_H_V h5
78230: , AR_REMIT_BANK_ACCT_H_V h6
78231: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
78232: and xet.event_class_code = C_EVENT_CLASS_CODE
78233: and xet.event_status_code <> 'N' AND h5.event_id = xet.event_id
78234: AND h1.event_id (+) = h5.event_id

Line 79273: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'

79269: WHEN 1 THEN 'AR_CASH_RECEIPTS_H_V'
79270: WHEN 2 THEN 'AR_CASH_RECEIPTS_H_V'
79271: WHEN 3 THEN 'AR_RCT_METHOD_H_V'
79272: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
79273: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
79274: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
79275: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'
79276: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
79277: WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'

Line 79274: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'

79270: WHEN 2 THEN 'AR_CASH_RECEIPTS_H_V'
79271: WHEN 3 THEN 'AR_RCT_METHOD_H_V'
79272: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
79273: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
79274: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
79275: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'
79276: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
79277: WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'
79278: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'

Line 79275: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'

79271: WHEN 3 THEN 'AR_RCT_METHOD_H_V'
79272: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
79273: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
79274: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
79275: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'
79276: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
79277: WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'
79278: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
79279: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'

Line 79379: , AR_REMIT_BANK_ACCT_H_V h8

79375: FROM xla_events_gt xet
79376: , AR_CASH_RECEIPTS_H_V h1
79377: , AR_RCT_METHOD_H_V h5
79378: , AR_RCT_SITE_USES_H_V h6
79379: , AR_REMIT_BANK_ACCT_H_V h8
79380: , AR_SYSTEM_PARAM_H_V h9
79381: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
79382: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79383: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 79781: TYPE t_array_source_12 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;

79777: TYPE t_array_source_8 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
79778: TYPE t_array_source_9 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79779: TYPE t_array_source_10 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
79780: TYPE t_array_source_11 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
79781: TYPE t_array_source_12 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
79782: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
79783: TYPE t_array_source_23 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
79784: TYPE t_array_source_24 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
79785: TYPE t_array_source_25 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;

Line 79782: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;

79778: TYPE t_array_source_9 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79779: TYPE t_array_source_10 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
79780: TYPE t_array_source_11 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
79781: TYPE t_array_source_12 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
79782: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
79783: TYPE t_array_source_23 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
79784: TYPE t_array_source_24 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
79785: TYPE t_array_source_25 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
79786: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_CASH_RECEIPT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 79783: TYPE t_array_source_23 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;

79779: TYPE t_array_source_10 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
79780: TYPE t_array_source_11 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
79781: TYPE t_array_source_12 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
79782: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
79783: TYPE t_array_source_23 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
79784: TYPE t_array_source_24 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
79785: TYPE t_array_source_25 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
79786: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_CASH_RECEIPT_ID%TYPE INDEX BY BINARY_INTEGER;
79787: TYPE t_array_source_92 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;

Line 79925: , AR_REMIT_BANK_ACCT_H_V h8

79921: FROM xla_events_gt xet
79922: , AR_CASH_RECEIPTS_H_V h1
79923: , AR_RCT_METHOD_H_V h5
79924: , AR_RCT_SITE_USES_H_V h6
79925: , AR_REMIT_BANK_ACCT_H_V h8
79926: , AR_SYSTEM_PARAM_H_V h9
79927: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
79928: and xet.event_class_code = C_EVENT_CLASS_CODE
79929: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id