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_000002_PKG dependencies on AR_RCT_METHOD_H_V

Line 81739: WHEN 5 THEN 'AR_RCT_METHOD_H_V'

81735: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
81736: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
81737: WHEN 3 THEN 'AR_CASH_RECEIPTS_H_V'
81738: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
81739: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
81740: WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V'
81741: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
81742: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
81743: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'

Line 81803: , AR_RCT_METHOD_H_V h4

81799: END source_value
81800: , null source_meaning
81801: FROM xla_events_gt xet
81802: , AR_CASH_RECEIPTS_H_V h1
81803: , AR_RCT_METHOD_H_V h4
81804: , AR_REMIT_BANK_ACCT_H_V h5
81805: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
81806: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
81807: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 82096: TYPE t_array_source_22 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;

82092: TYPE t_array_source_16 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
82093: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
82094: TYPE t_array_source_20 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
82095: TYPE t_array_source_21 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
82096: TYPE t_array_source_22 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
82097: TYPE t_array_source_23 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
82098: TYPE t_array_source_125 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
82099: TYPE t_array_source_126 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
82100: TYPE t_array_source_127 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

Line 82176: , AR_RCT_METHOD_H_V h4

82172: , h1.RCT_DOC_SEQUENCE_ID source_126
82173: , h1.RCT_TRX_ACCT_REVERSAL source_127
82174: FROM xla_events_gt xet
82175: , AR_CASH_RECEIPTS_H_V h1
82176: , AR_RCT_METHOD_H_V h4
82177: , AR_REMIT_BANK_ACCT_H_V h5
82178: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
82179: and xet.event_class_code = C_EVENT_CLASS_CODE
82180: and xet.event_status_code <> 'N' AND h1.event_id (+) = xet.event_id

Line 83206: WHEN 5 THEN 'AR_RCT_METHOD_H_V'

83202: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
83203: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
83204: WHEN 3 THEN 'AR_CASH_RECEIPTS_H_V'
83205: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
83206: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
83207: WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V'
83208: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'
83209: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
83210: WHEN 9 THEN 'AR_REMIT_BANK_ACCT_H_V'

Line 83320: , AR_RCT_METHOD_H_V h5

83316: END source_value
83317: , null source_meaning
83318: FROM xla_events_gt xet
83319: , AR_CASH_RECEIPTS_H_V h1
83320: , AR_RCT_METHOD_H_V h5
83321: , AR_RCT_SITE_USES_H_V h6
83322: , AR_REMIT_BANK_ACCT_H_V h8
83323: , AR_SYSTEM_PARAM_H_V h9
83324: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)

Line 83724: TYPE t_array_source_22 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;

83720: TYPE t_array_source_16 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
83721: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
83722: TYPE t_array_source_20 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
83723: TYPE t_array_source_21 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
83724: TYPE t_array_source_22 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
83725: TYPE t_array_source_23 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
83726: TYPE t_array_source_34 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
83727: TYPE t_array_source_35 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
83728: TYPE t_array_source_36 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 83872: , AR_RCT_METHOD_H_V h5

83868: , h1.RCT_DOC_SEQUENCE_ID source_126
83869: , h1.RCT_TRX_ACCT_REVERSAL source_127
83870: FROM xla_events_gt xet
83871: , AR_CASH_RECEIPTS_H_V h1
83872: , AR_RCT_METHOD_H_V h5
83873: , AR_RCT_SITE_USES_H_V h6
83874: , AR_REMIT_BANK_ACCT_H_V h8
83875: , AR_SYSTEM_PARAM_H_V h9
83876: WHERE xet.event_date between p_pad_start_date and p_pad_end_date