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

Line 77480: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'

77476: FROM (
77477: SELECT xet.event_id event_id
77478: , 0 line_number
77479: , CASE r
77480: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
77481: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
77482: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
77483: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
77484: WHEN 5 THEN 'AR_RCT_METHOD_H_V'

Line 77481: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'

77477: SELECT xet.event_id event_id
77478: , 0 line_number
77479: , CASE r
77480: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
77481: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
77482: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
77483: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
77484: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
77485: WHEN 6 THEN 'AR_RCT_METHOD_H_V'

Line 77482: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'

77478: , 0 line_number
77479: , CASE r
77480: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
77481: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
77482: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
77483: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
77484: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
77485: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
77486: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'

Line 77483: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'

77479: , CASE r
77480: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
77481: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
77482: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
77483: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
77484: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
77485: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
77486: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
77487: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'

Line 77554: , AR_REMIT_BANK_ACCT_H_V h5

77550: , null source_meaning
77551: FROM xla_events_gt xet
77552: , AR_CASH_RECEIPTS_H_V h1
77553: , AR_RCT_METHOD_H_V h4
77554: , AR_REMIT_BANK_ACCT_H_V h5
77555: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
77556: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77557: AND xet.event_class_code = C_EVENT_CLASS_CODE
77558:

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

77869: --
77870: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
77871: --
77872:
77873: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
77874: TYPE t_array_source_3 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
77875: TYPE t_array_source_5 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
77876: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
77877: TYPE t_array_source_72 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;

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

77870: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
77871: --
77872:
77873: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
77874: TYPE t_array_source_3 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
77875: TYPE t_array_source_5 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
77876: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
77877: TYPE t_array_source_72 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
77878: TYPE t_array_source_73 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;

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

77871: --
77872:
77873: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
77874: TYPE t_array_source_3 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
77875: TYPE t_array_source_5 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
77876: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
77877: TYPE t_array_source_72 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
77878: TYPE t_array_source_73 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
77879: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

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

77872:
77873: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
77874: TYPE t_array_source_3 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
77875: TYPE t_array_source_5 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
77876: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
77877: TYPE t_array_source_72 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
77878: TYPE t_array_source_73 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
77879: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77880: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 77973: , AR_REMIT_BANK_ACCT_H_V h5

77969: , h1.RCT_TRX_ACCT_REVERSAL source_91
77970: FROM xla_events_gt xet
77971: , AR_CASH_RECEIPTS_H_V h1
77972: , AR_RCT_METHOD_H_V h4
77973: , AR_REMIT_BANK_ACCT_H_V h5
77974: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
77975: and xet.event_class_code = C_EVENT_CLASS_CODE
77976: and xet.event_status_code <> 'N' AND h1.event_id (+) = xet.event_id
77977: AND h4.event_id (+) = xet.event_id

Line 79319: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'

79315: FROM (
79316: SELECT xet.event_id event_id
79317: , 0 line_number
79318: , CASE r
79319: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
79320: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
79321: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
79322: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
79323: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'

Line 79320: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'

79316: SELECT xet.event_id event_id
79317: , 0 line_number
79318: , CASE r
79319: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
79320: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
79321: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
79322: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
79323: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
79324: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'

Line 79321: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'

79317: , 0 line_number
79318: , CASE r
79319: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
79320: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
79321: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
79322: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
79323: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
79324: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
79325: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'

Line 79322: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'

79318: , CASE r
79319: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
79320: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
79321: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
79322: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
79323: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
79324: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
79325: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'
79326: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'

Line 79323: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'

79319: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
79320: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
79321: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
79322: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
79323: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
79324: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
79325: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'
79326: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
79327: WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'

Line 79324: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'

79320: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
79321: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
79322: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
79323: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
79324: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
79325: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'
79326: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
79327: WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'
79328: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'

Line 79325: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'

79321: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
79322: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
79323: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
79324: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
79325: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'
79326: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
79327: WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'
79328: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
79329: WHEN 11 THEN 'AR_RCT_METHOD_H_V'

Line 79439: , AR_REMIT_BANK_ACCT_H_V h9

79435: FROM xla_events_gt xet
79436: , AR_CASH_RECEIPTS_H_V h2
79437: , AR_RCT_METHOD_H_V h6
79438: , AR_RCT_SITE_USES_H_V h7
79439: , AR_REMIT_BANK_ACCT_H_V h9
79440: , AR_SYSTEM_PARAM_H_V h10
79441: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
79442: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79443: AND xet.event_class_code = C_EVENT_CLASS_CODE

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

79862: --
79863: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
79864: --
79865:
79866: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
79867: TYPE t_array_source_3 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
79868: TYPE t_array_source_4 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_EARNED_CCID%TYPE INDEX BY BINARY_INTEGER;
79869: TYPE t_array_source_5 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
79870: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;

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

79863: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
79864: --
79865:
79866: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
79867: TYPE t_array_source_3 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
79868: TYPE t_array_source_4 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_EARNED_CCID%TYPE INDEX BY BINARY_INTEGER;
79869: TYPE t_array_source_5 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
79870: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
79871: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNEARNED_CCID%TYPE INDEX BY BINARY_INTEGER;

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

79864: --
79865:
79866: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
79867: TYPE t_array_source_3 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
79868: TYPE t_array_source_4 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_EARNED_CCID%TYPE INDEX BY BINARY_INTEGER;
79869: TYPE t_array_source_5 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
79870: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
79871: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNEARNED_CCID%TYPE INDEX BY BINARY_INTEGER;
79872: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;

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

79865:
79866: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
79867: TYPE t_array_source_3 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
79868: TYPE t_array_source_4 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_EARNED_CCID%TYPE INDEX BY BINARY_INTEGER;
79869: TYPE t_array_source_5 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
79870: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
79871: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNEARNED_CCID%TYPE INDEX BY BINARY_INTEGER;
79872: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
79873: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;

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

79866: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
79867: TYPE t_array_source_3 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
79868: TYPE t_array_source_4 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_EARNED_CCID%TYPE INDEX BY BINARY_INTEGER;
79869: TYPE t_array_source_5 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
79870: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
79871: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNEARNED_CCID%TYPE INDEX BY BINARY_INTEGER;
79872: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
79873: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
79874: TYPE t_array_source_20 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;

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

79867: TYPE t_array_source_3 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
79868: TYPE t_array_source_4 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_EARNED_CCID%TYPE INDEX BY BINARY_INTEGER;
79869: TYPE t_array_source_5 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
79870: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
79871: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNEARNED_CCID%TYPE INDEX BY BINARY_INTEGER;
79872: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
79873: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
79874: TYPE t_array_source_20 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
79875: TYPE t_array_source_60 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;

Line 79872: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;

79868: TYPE t_array_source_4 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_EARNED_CCID%TYPE INDEX BY BINARY_INTEGER;
79869: TYPE t_array_source_5 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
79870: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
79871: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNEARNED_CCID%TYPE INDEX BY BINARY_INTEGER;
79872: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
79873: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
79874: TYPE t_array_source_20 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
79875: TYPE t_array_source_60 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
79876: TYPE t_array_source_72 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 80030: , AR_REMIT_BANK_ACCT_H_V h9

80026: FROM xla_events_gt xet
80027: , AR_CASH_RECEIPTS_H_V h2
80028: , AR_RCT_METHOD_H_V h6
80029: , AR_RCT_SITE_USES_H_V h7
80030: , AR_REMIT_BANK_ACCT_H_V h9
80031: , AR_SYSTEM_PARAM_H_V h10
80032: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
80033: and xet.event_class_code = C_EVENT_CLASS_CODE
80034: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id