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

Line 78723: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'

78719: FROM (
78720: SELECT xet.event_id event_id
78721: , 0 line_number
78722: , CASE r
78723: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
78724: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
78725: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
78726: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
78727: WHEN 5 THEN 'AR_RCT_METHOD_H_V'

Line 78724: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'

78720: SELECT xet.event_id event_id
78721: , 0 line_number
78722: , CASE r
78723: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
78724: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
78725: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
78726: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
78727: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
78728: WHEN 6 THEN 'AR_RCT_METHOD_H_V'

Line 78725: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'

78721: , 0 line_number
78722: , CASE r
78723: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
78724: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
78725: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
78726: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
78727: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
78728: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
78729: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'

Line 78726: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'

78722: , CASE r
78723: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
78724: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
78725: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
78726: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
78727: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
78728: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
78729: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
78730: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'

Line 78797: , AR_REMIT_BANK_ACCT_H_V h5

78793: , null source_meaning
78794: FROM xla_events_gt xet
78795: , AR_CASH_RECEIPTS_H_V h1
78796: , AR_RCT_METHOD_H_V h4
78797: , AR_REMIT_BANK_ACCT_H_V h5
78798: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
78799: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
78800: AND xet.event_class_code = C_EVENT_CLASS_CODE
78801:

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

79112: --
79113: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
79114: --
79115:
79116: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
79117: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
79118: TYPE t_array_source_14 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
79119: TYPE t_array_source_15 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
79120: TYPE t_array_source_70 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 79117: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;

79113: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
79114: --
79115:
79116: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
79117: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
79118: TYPE t_array_source_14 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
79119: TYPE t_array_source_15 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
79120: TYPE t_array_source_70 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
79121: TYPE t_array_source_71 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 79118: TYPE t_array_source_14 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;

79114: --
79115:
79116: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
79117: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
79118: TYPE t_array_source_14 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
79119: TYPE t_array_source_15 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
79120: TYPE t_array_source_70 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
79121: TYPE t_array_source_71 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
79122: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 79119: TYPE t_array_source_15 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;

79115:
79116: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
79117: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
79118: TYPE t_array_source_14 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
79119: TYPE t_array_source_15 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
79120: TYPE t_array_source_70 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
79121: TYPE t_array_source_71 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
79122: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79123: TYPE t_array_source_87 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 79216: , AR_REMIT_BANK_ACCT_H_V h5

79212: , h1.RCT_TRX_ACCT_REVERSAL source_89
79213: FROM xla_events_gt xet
79214: , AR_CASH_RECEIPTS_H_V h1
79215: , AR_RCT_METHOD_H_V h4
79216: , AR_REMIT_BANK_ACCT_H_V h5
79217: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
79218: and xet.event_class_code = C_EVENT_CLASS_CODE
79219: and xet.event_status_code <> 'N' AND h1.event_id (+) = xet.event_id
79220: AND h4.event_id (+) = xet.event_id

Line 80570: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'

80566: FROM (
80567: SELECT xet.event_id event_id
80568: , 0 line_number
80569: , CASE r
80570: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
80571: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
80572: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
80573: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
80574: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'

Line 80571: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'

80567: SELECT xet.event_id event_id
80568: , 0 line_number
80569: , CASE r
80570: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
80571: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
80572: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
80573: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
80574: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
80575: WHEN 6 THEN 'AR_SYSTEM_PARAM_H_V'

Line 80572: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'

80568: , 0 line_number
80569: , CASE r
80570: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
80571: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
80572: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
80573: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
80574: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
80575: WHEN 6 THEN 'AR_SYSTEM_PARAM_H_V'
80576: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'

Line 80573: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'

80569: , CASE r
80570: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
80571: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
80572: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
80573: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
80574: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
80575: WHEN 6 THEN 'AR_SYSTEM_PARAM_H_V'
80576: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'
80577: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'

Line 80574: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'

80570: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
80571: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
80572: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
80573: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
80574: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
80575: WHEN 6 THEN 'AR_SYSTEM_PARAM_H_V'
80576: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'
80577: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
80578: WHEN 9 THEN 'AR_RCT_METHOD_H_V'

Line 80680: , AR_REMIT_BANK_ACCT_H_V h9

80676: FROM xla_events_gt xet
80677: , AR_CASH_RECEIPTS_H_V h2
80678: , AR_RCT_METHOD_H_V h6
80679: , AR_RCT_SITE_USES_H_V h7
80680: , AR_REMIT_BANK_ACCT_H_V h9
80681: , AR_SYSTEM_PARAM_H_V h10
80682: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
80683: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
80684: AND xet.event_class_code = C_EVENT_CLASS_CODE

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

81103: --
81104: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
81105: --
81106:
81107: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
81108: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
81109: TYPE t_array_source_14 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
81110: TYPE t_array_source_15 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
81111: TYPE t_array_source_17 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 81108: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;

81104: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
81105: --
81106:
81107: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
81108: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
81109: TYPE t_array_source_14 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
81110: TYPE t_array_source_15 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
81111: TYPE t_array_source_17 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
81112: TYPE t_array_source_18 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;

Line 81109: TYPE t_array_source_14 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;

81105: --
81106:
81107: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
81108: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
81109: TYPE t_array_source_14 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
81110: TYPE t_array_source_15 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
81111: TYPE t_array_source_17 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
81112: TYPE t_array_source_18 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
81113: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;

Line 81110: TYPE t_array_source_15 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;

81106:
81107: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
81108: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
81109: TYPE t_array_source_14 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
81110: TYPE t_array_source_15 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
81111: TYPE t_array_source_17 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
81112: TYPE t_array_source_18 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
81113: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
81114: TYPE t_array_source_58 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;

Line 81111: TYPE t_array_source_17 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;

81107: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
81108: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
81109: TYPE t_array_source_14 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
81110: TYPE t_array_source_15 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
81111: TYPE t_array_source_17 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
81112: TYPE t_array_source_18 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
81113: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
81114: TYPE t_array_source_58 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
81115: TYPE t_array_source_70 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 81265: , AR_REMIT_BANK_ACCT_H_V h9

81261: FROM xla_events_gt xet
81262: , AR_CASH_RECEIPTS_H_V h2
81263: , AR_RCT_METHOD_H_V h6
81264: , AR_RCT_SITE_USES_H_V h7
81265: , AR_REMIT_BANK_ACCT_H_V h9
81266: , AR_SYSTEM_PARAM_H_V h10
81267: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
81268: and xet.event_class_code = C_EVENT_CLASS_CODE
81269: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id