[Home] [Help]
22273: FROM (
22274: SELECT xet.event_id event_id
22275: , 0 line_number
22276: , CASE r
22277: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
22278: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
22279: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'
22280: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
22281: WHEN 5 THEN 'AR_CASH_RECEIPTS_H_V'
22352: , null source_meaning
22353: FROM xla_events_gt xet
22354: , AR_CASH_RECEIPTS_H_V h1
22355: , AR_RCT_SITE_USES_H_V h5
22356: , AR_REMIT_BANK_ACCT_H_V h7
22357: , AR_SYSTEM_PARAM_H_V h8
22358: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
22359: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
22360: AND xet.event_class_code = C_EVENT_CLASS_CODE
22744: --
22745: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
22746: --
22747:
22748: TYPE t_array_source_2 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
22749: TYPE t_array_source_3 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
22750: TYPE t_array_source_4 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
22751: TYPE t_array_source_17 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
22752: TYPE t_array_source_34 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
22871: , h1.RCT_TRX_ACCT_REVERSAL source_41
22872: FROM xla_events_gt xet
22873: , AR_CASH_RECEIPTS_H_V h1
22874: , AR_RCT_SITE_USES_H_V h5
22875: , AR_REMIT_BANK_ACCT_H_V h7
22876: , AR_SYSTEM_PARAM_H_V h8
22877: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
22878: and xet.event_class_code = C_EVENT_CLASS_CODE
22879: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id