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

Line 62497: WHEN 5 THEN 'AR_RCT_METHOD_H_V'

62493: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
62494: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
62495: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
62496: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
62497: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
62498: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
62499: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
62500: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
62501: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'

Line 62498: WHEN 6 THEN 'AR_RCT_METHOD_H_V'

62494: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
62495: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
62496: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
62497: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
62498: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
62499: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
62500: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
62501: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
62502: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'

Line 62566: , AR_RCT_METHOD_H_V h4

62562: END source_value
62563: , null source_meaning
62564: FROM xla_events_gt xet
62565: , AR_CASH_RECEIPTS_H_V h1
62566: , AR_RCT_METHOD_H_V h4
62567: , AR_REMIT_BANK_ACCT_H_V h5
62568: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
62569: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
62570: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 62859: TYPE t_array_source_54 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;

62855: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
62856: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
62857: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
62858: TYPE t_array_source_8 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
62859: TYPE t_array_source_54 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
62860: TYPE t_array_source_55 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
62861: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
62862: TYPE t_array_source_79 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
62863: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 62860: TYPE t_array_source_55 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;

62856: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
62857: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
62858: TYPE t_array_source_8 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
62859: TYPE t_array_source_54 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
62860: TYPE t_array_source_55 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
62861: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
62862: TYPE t_array_source_79 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
62863: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
62864: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

Line 62942: , AR_RCT_METHOD_H_V h4

62938: , h1.RCT_DOC_SEQUENCE_VALUE source_80
62939: , h1.RCT_TRX_ACCT_REVERSAL source_81
62940: FROM xla_events_gt xet
62941: , AR_CASH_RECEIPTS_H_V h1
62942: , AR_RCT_METHOD_H_V h4
62943: , AR_REMIT_BANK_ACCT_H_V h5
62944: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
62945: and xet.event_class_code = C_EVENT_CLASS_CODE
62946: and xet.event_status_code <> 'N' AND h1.event_id (+) = xet.event_id

Line 64029: WHEN 8 THEN 'AR_RCT_METHOD_H_V'

64025: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
64026: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
64027: WHEN 6 THEN 'AR_SYSTEM_PARAM_H_V'
64028: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'
64029: WHEN 8 THEN 'AR_RCT_METHOD_H_V'
64030: WHEN 9 THEN 'AR_RCT_METHOD_H_V'
64031: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
64032: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
64033: WHEN 12 THEN 'AR_RCT_SITE_USES_H_V'

Line 64030: WHEN 9 THEN 'AR_RCT_METHOD_H_V'

64026: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
64027: WHEN 6 THEN 'AR_SYSTEM_PARAM_H_V'
64028: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'
64029: WHEN 8 THEN 'AR_RCT_METHOD_H_V'
64030: WHEN 9 THEN 'AR_RCT_METHOD_H_V'
64031: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
64032: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
64033: WHEN 12 THEN 'AR_RCT_SITE_USES_H_V'
64034: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'

Line 64130: , AR_RCT_METHOD_H_V h5

64126: END source_value
64127: , null source_meaning
64128: FROM xla_events_gt xet
64129: , AR_CASH_RECEIPTS_H_V h1
64130: , AR_RCT_METHOD_H_V h5
64131: , AR_RCT_SITE_USES_H_V h6
64132: , AR_REMIT_BANK_ACCT_H_V h8
64133: , AR_SYSTEM_PARAM_H_V h9
64134: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)

Line 64527: TYPE t_array_source_54 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;

64523: TYPE t_array_source_8 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
64524: TYPE t_array_source_10 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
64525: TYPE t_array_source_11 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
64526: TYPE t_array_source_12 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
64527: TYPE t_array_source_54 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
64528: TYPE t_array_source_55 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
64529: TYPE t_array_source_56 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
64530: TYPE t_array_source_68 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
64531: TYPE t_array_source_69 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 64528: TYPE t_array_source_55 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;

64524: TYPE t_array_source_10 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
64525: TYPE t_array_source_11 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
64526: TYPE t_array_source_12 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
64527: TYPE t_array_source_54 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
64528: TYPE t_array_source_55 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
64529: TYPE t_array_source_56 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
64530: TYPE t_array_source_68 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
64531: TYPE t_array_source_69 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
64532: TYPE t_array_source_70 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;

Line 64662: , AR_RCT_METHOD_H_V h5

64658: , h1.RCT_DOC_SEQUENCE_VALUE source_80
64659: , h1.RCT_TRX_ACCT_REVERSAL source_81
64660: FROM xla_events_gt xet
64661: , AR_CASH_RECEIPTS_H_V h1
64662: , AR_RCT_METHOD_H_V h5
64663: , AR_RCT_SITE_USES_H_V h6
64664: , AR_REMIT_BANK_ACCT_H_V h8
64665: , AR_SYSTEM_PARAM_H_V h9
64666: WHERE xet.event_date between p_pad_start_date and p_pad_end_date