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

Line 62768: WHEN 5 THEN 'AR_RCT_METHOD_H_V'

62764: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
62765: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
62766: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
62767: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
62768: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
62769: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
62770: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
62771: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
62772: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'

Line 62769: WHEN 6 THEN 'AR_RCT_METHOD_H_V'

62765: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
62766: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
62767: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
62768: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
62769: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
62770: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
62771: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
62772: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
62773: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'

Line 62837: , AR_RCT_METHOD_H_V h4

62833: END source_value
62834: , null source_meaning
62835: FROM xla_events_gt xet
62836: , AR_CASH_RECEIPTS_H_V h1
62837: , AR_RCT_METHOD_H_V h4
62838: , AR_REMIT_BANK_ACCT_H_V h5
62839: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
62840: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
62841: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 63130: TYPE t_array_source_56 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;

63126: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
63127: TYPE t_array_source_3 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
63128: TYPE t_array_source_5 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
63129: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
63130: TYPE t_array_source_56 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
63131: TYPE t_array_source_57 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
63132: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
63133: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
63134: TYPE t_array_source_82 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 63131: TYPE t_array_source_57 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;

63127: TYPE t_array_source_3 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
63128: TYPE t_array_source_5 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
63129: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
63130: TYPE t_array_source_56 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
63131: TYPE t_array_source_57 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
63132: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
63133: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
63134: TYPE t_array_source_82 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
63135: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

Line 63213: , AR_RCT_METHOD_H_V h4

63209: , h1.RCT_DOC_SEQUENCE_VALUE source_82
63210: , h1.RCT_TRX_ACCT_REVERSAL source_83
63211: FROM xla_events_gt xet
63212: , AR_CASH_RECEIPTS_H_V h1
63213: , AR_RCT_METHOD_H_V h4
63214: , AR_REMIT_BANK_ACCT_H_V h5
63215: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
63216: and xet.event_class_code = C_EVENT_CLASS_CODE
63217: and xet.event_status_code <> 'N' AND h1.event_id (+) = xet.event_id

Line 64302: WHEN 10 THEN 'AR_RCT_METHOD_H_V'

64298: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
64299: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'
64300: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
64301: WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'
64302: WHEN 10 THEN 'AR_RCT_METHOD_H_V'
64303: WHEN 11 THEN 'AR_RCT_METHOD_H_V'
64304: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
64305: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
64306: WHEN 14 THEN 'AR_RCT_SITE_USES_H_V'

Line 64303: WHEN 11 THEN 'AR_RCT_METHOD_H_V'

64299: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'
64300: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
64301: WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'
64302: WHEN 10 THEN 'AR_RCT_METHOD_H_V'
64303: WHEN 11 THEN 'AR_RCT_METHOD_H_V'
64304: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
64305: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
64306: WHEN 14 THEN 'AR_RCT_SITE_USES_H_V'
64307: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'

Line 64411: , AR_RCT_METHOD_H_V h5

64407: END source_value
64408: , null source_meaning
64409: FROM xla_events_gt xet
64410: , AR_CASH_RECEIPTS_H_V h1
64411: , AR_RCT_METHOD_H_V h5
64412: , AR_RCT_SITE_USES_H_V h6
64413: , AR_REMIT_BANK_ACCT_H_V h8
64414: , AR_SYSTEM_PARAM_H_V h9
64415: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)

Line 64810: TYPE t_array_source_56 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;

64806: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNEARNED_CCID%TYPE INDEX BY BINARY_INTEGER;
64807: TYPE t_array_source_11 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
64808: TYPE t_array_source_12 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
64809: TYPE t_array_source_13 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
64810: TYPE t_array_source_56 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
64811: TYPE t_array_source_57 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
64812: TYPE t_array_source_58 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
64813: TYPE t_array_source_70 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
64814: TYPE t_array_source_71 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 64811: TYPE t_array_source_57 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;

64807: TYPE t_array_source_11 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
64808: TYPE t_array_source_12 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
64809: TYPE t_array_source_13 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
64810: TYPE t_array_source_56 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
64811: TYPE t_array_source_57 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
64812: TYPE t_array_source_58 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
64813: TYPE t_array_source_70 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
64814: TYPE t_array_source_71 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
64815: TYPE t_array_source_72 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;

Line 64949: , AR_RCT_METHOD_H_V h5

64945: , h1.RCT_DOC_SEQUENCE_VALUE source_82
64946: , h1.RCT_TRX_ACCT_REVERSAL source_83
64947: FROM xla_events_gt xet
64948: , AR_CASH_RECEIPTS_H_V h1
64949: , AR_RCT_METHOD_H_V h5
64950: , AR_RCT_SITE_USES_H_V h6
64951: , AR_REMIT_BANK_ACCT_H_V h8
64952: , AR_SYSTEM_PARAM_H_V h9
64953: WHERE xet.event_date between p_pad_start_date and p_pad_end_date