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_REMIT_BANK_ACCT_H_V

Line 62764: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'

62760: FROM (
62761: SELECT xet.event_id event_id
62762: , 0 line_number
62763: , CASE r
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'

Line 62765: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'

62761: SELECT xet.event_id event_id
62762: , 0 line_number
62763: , CASE r
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'

Line 62766: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'

62762: , 0 line_number
62763: , CASE r
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'

Line 62767: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'

62763: , CASE r
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'

Line 62838: , AR_REMIT_BANK_ACCT_H_V h5

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
62842:

Line 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;

63122: --
63123: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
63124: --
63125:
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;

Line 63127: TYPE t_array_source_3 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;

63123: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
63124: --
63125:
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;

Line 63128: TYPE t_array_source_5 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;

63124: --
63125:
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;

Line 63129: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;

63125:
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;

Line 63214: , AR_REMIT_BANK_ACCT_H_V h5

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
63218: AND h4.event_id (+) = xet.event_id

Line 64293: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'

64289: FROM (
64290: SELECT xet.event_id event_id
64291: , 0 line_number
64292: , CASE r
64293: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
64294: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
64295: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
64296: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
64297: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'

Line 64294: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'

64290: SELECT xet.event_id event_id
64291: , 0 line_number
64292: , CASE r
64293: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
64294: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
64295: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
64296: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
64297: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
64298: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'

Line 64295: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'

64291: , 0 line_number
64292: , CASE r
64293: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
64294: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
64295: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
64296: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
64297: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
64298: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
64299: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'

Line 64296: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'

64292: , CASE r
64293: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
64294: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
64295: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
64296: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
64297: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_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'

Line 64297: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'

64293: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
64294: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
64295: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
64296: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
64297: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_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'

Line 64298: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'

64294: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
64295: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
64296: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
64297: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_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'

Line 64299: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'

64295: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
64296: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
64297: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_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'

Line 64413: , AR_REMIT_BANK_ACCT_H_V h8

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)
64416: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64417: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 64801: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;

64797: --
64798: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
64799: --
64800:
64801: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
64802: TYPE t_array_source_3 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
64803: TYPE t_array_source_4 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_EARNED_CCID%TYPE INDEX BY BINARY_INTEGER;
64804: TYPE t_array_source_5 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
64805: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 64802: TYPE t_array_source_3 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;

64798: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
64799: --
64800:
64801: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
64802: TYPE t_array_source_3 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
64803: TYPE t_array_source_4 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_EARNED_CCID%TYPE INDEX BY BINARY_INTEGER;
64804: TYPE t_array_source_5 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
64805: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%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;

Line 64803: TYPE t_array_source_4 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_EARNED_CCID%TYPE INDEX BY BINARY_INTEGER;

64799: --
64800:
64801: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
64802: TYPE t_array_source_3 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
64803: TYPE t_array_source_4 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_EARNED_CCID%TYPE INDEX BY BINARY_INTEGER;
64804: TYPE t_array_source_5 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
64805: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%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;

Line 64804: TYPE t_array_source_5 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;

64800:
64801: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
64802: TYPE t_array_source_3 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
64803: TYPE t_array_source_4 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_EARNED_CCID%TYPE INDEX BY BINARY_INTEGER;
64804: TYPE t_array_source_5 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
64805: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%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;

Line 64805: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;

64801: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
64802: TYPE t_array_source_3 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
64803: TYPE t_array_source_4 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_EARNED_CCID%TYPE INDEX BY BINARY_INTEGER;
64804: TYPE t_array_source_5 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
64805: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%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;

Line 64806: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNEARNED_CCID%TYPE INDEX BY BINARY_INTEGER;

64802: TYPE t_array_source_3 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
64803: TYPE t_array_source_4 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_EARNED_CCID%TYPE INDEX BY BINARY_INTEGER;
64804: TYPE t_array_source_5 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
64805: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%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;

Line 64807: TYPE t_array_source_11 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;

64803: TYPE t_array_source_4 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_EARNED_CCID%TYPE INDEX BY BINARY_INTEGER;
64804: TYPE t_array_source_5 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
64805: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%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;

Line 64951: , AR_REMIT_BANK_ACCT_H_V h8

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
64954: and xet.event_class_code = C_EVENT_CLASS_CODE
64955: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id