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_000005_PKG dependencies on AR_CASH_RECEIPTS_H_V

Line 76842: WHEN 1 THEN 'AR_CASH_RECEIPTS_H_V'

76838: FROM (
76839: SELECT xet.event_id event_id
76840: , 0 line_number
76841: , CASE r
76842: WHEN 1 THEN 'AR_CASH_RECEIPTS_H_V'
76843: WHEN 2 THEN 'AR_CASH_RECEIPTS_H_V'
76844: WHEN 3 THEN 'AR_CASH_RECEIPTS_H_V'
76845: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
76846:

Line 76843: WHEN 2 THEN 'AR_CASH_RECEIPTS_H_V'

76839: SELECT xet.event_id event_id
76840: , 0 line_number
76841: , CASE r
76842: WHEN 1 THEN 'AR_CASH_RECEIPTS_H_V'
76843: WHEN 2 THEN 'AR_CASH_RECEIPTS_H_V'
76844: WHEN 3 THEN 'AR_CASH_RECEIPTS_H_V'
76845: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
76846:
76847: ELSE null

Line 76844: WHEN 3 THEN 'AR_CASH_RECEIPTS_H_V'

76840: , 0 line_number
76841: , CASE r
76842: WHEN 1 THEN 'AR_CASH_RECEIPTS_H_V'
76843: WHEN 2 THEN 'AR_CASH_RECEIPTS_H_V'
76844: WHEN 3 THEN 'AR_CASH_RECEIPTS_H_V'
76845: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
76846:
76847: ELSE null
76848: END object_name

Line 76845: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'

76841: , CASE r
76842: WHEN 1 THEN 'AR_CASH_RECEIPTS_H_V'
76843: WHEN 2 THEN 'AR_CASH_RECEIPTS_H_V'
76844: WHEN 3 THEN 'AR_CASH_RECEIPTS_H_V'
76845: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
76846:
76847: ELSE null
76848: END object_name
76849: , CASE r

Line 76884: , AR_CASH_RECEIPTS_H_V h1

76880: ELSE null
76881: END source_value
76882: , null source_meaning
76883: FROM xla_events_gt xet
76884: , AR_CASH_RECEIPTS_H_V h1
76885: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
76886: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76887: AND xet.event_class_code = C_EVENT_CLASS_CODE
76888:

Line 77203: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

77199: --
77200: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
77201: --
77202:
77203: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77204: TYPE t_array_source_84 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
77205: TYPE t_array_source_85 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
77206: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
77207:

Line 77204: TYPE t_array_source_84 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

77200: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
77201: --
77202:
77203: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77204: TYPE t_array_source_84 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
77205: TYPE t_array_source_85 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
77206: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
77207:
77208: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 77205: TYPE t_array_source_85 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

77201: --
77202:
77203: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77204: TYPE t_array_source_84 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
77205: TYPE t_array_source_85 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
77206: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
77207:
77208: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
77209: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 77206: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

77202:
77203: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77204: TYPE t_array_source_84 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
77205: TYPE t_array_source_85 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
77206: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
77207:
77208: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
77209: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77210: TYPE t_array_source_12 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;

Line 77283: , AR_CASH_RECEIPTS_H_V h1

77279: , h1.RCT_DOC_SEQUENCE_ID source_84
77280: , h1.RCT_DOC_SEQUENCE_VALUE source_85
77281: , h1.RCT_TRX_ACCT_REVERSAL source_86
77282: FROM xla_events_gt xet
77283: , AR_CASH_RECEIPTS_H_V h1
77284: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
77285: and xet.event_class_code = C_EVENT_CLASS_CODE
77286: and xet.event_status_code <> 'N' AND h1.event_id (+) = xet.event_id
77287:

Line 78553: WHEN 5 THEN 'AR_CASH_RECEIPTS_H_V'

78549: WHEN 1 THEN 'AR_SYSTEM_PARAM_H_V'
78550: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
78551: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
78552: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
78553: WHEN 5 THEN 'AR_CASH_RECEIPTS_H_V'
78554: WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V'
78555: WHEN 7 THEN 'AR_RCT_SITE_USES_H_V'
78556: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
78557: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'

Line 78554: WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V'

78550: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
78551: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
78552: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
78553: WHEN 5 THEN 'AR_CASH_RECEIPTS_H_V'
78554: WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V'
78555: WHEN 7 THEN 'AR_RCT_SITE_USES_H_V'
78556: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
78557: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
78558: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'

Line 78556: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'

78552: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
78553: WHEN 5 THEN 'AR_CASH_RECEIPTS_H_V'
78554: WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V'
78555: WHEN 7 THEN 'AR_RCT_SITE_USES_H_V'
78556: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
78557: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
78558: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
78559: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
78560: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'

Line 78557: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'

78553: WHEN 5 THEN 'AR_CASH_RECEIPTS_H_V'
78554: WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V'
78555: WHEN 7 THEN 'AR_RCT_SITE_USES_H_V'
78556: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
78557: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
78558: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
78559: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
78560: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
78561: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'

Line 78558: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'

78554: WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V'
78555: WHEN 7 THEN 'AR_RCT_SITE_USES_H_V'
78556: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
78557: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
78558: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
78559: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
78560: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
78561: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
78562: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'

Line 78559: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'

78555: WHEN 7 THEN 'AR_RCT_SITE_USES_H_V'
78556: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
78557: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
78558: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
78559: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
78560: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
78561: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
78562: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
78563:

Line 78560: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'

78556: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
78557: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
78558: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
78559: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
78560: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
78561: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
78562: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
78563:
78564: ELSE null

Line 78561: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'

78557: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
78558: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
78559: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
78560: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
78561: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
78562: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
78563:
78564: ELSE null
78565: END object_name

Line 78562: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'

78558: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
78559: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
78560: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
78561: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
78562: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
78563:
78564: ELSE null
78565: END object_name
78566: , CASE r

Line 78641: , AR_CASH_RECEIPTS_H_V h2

78637: ELSE null
78638: END source_value
78639: , null source_meaning
78640: FROM xla_events_gt xet
78641: , AR_CASH_RECEIPTS_H_V h2
78642: , AR_RCT_SITE_USES_H_V h6
78643: , AR_REMIT_BANK_ACCT_H_V h8
78644: , AR_SYSTEM_PARAM_H_V h9
78645: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)

Line 79088: TYPE t_array_source_58 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;

79084: TYPE t_array_source_7 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
79085: TYPE t_array_source_8 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
79086: TYPE t_array_source_17 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
79087: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNIDENTIFIED_CCID%TYPE INDEX BY BINARY_INTEGER;
79088: TYPE t_array_source_58 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
79089: TYPE t_array_source_72 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79090: TYPE t_array_source_73 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79091: TYPE t_array_source_74 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
79092: TYPE t_array_source_75 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;

Line 79089: TYPE t_array_source_72 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;

79085: TYPE t_array_source_8 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
79086: TYPE t_array_source_17 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
79087: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNIDENTIFIED_CCID%TYPE INDEX BY BINARY_INTEGER;
79088: TYPE t_array_source_58 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
79089: TYPE t_array_source_72 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79090: TYPE t_array_source_73 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79091: TYPE t_array_source_74 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
79092: TYPE t_array_source_75 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79093: TYPE t_array_source_76 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_CUSTOMER_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 79091: TYPE t_array_source_74 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;

79087: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNIDENTIFIED_CCID%TYPE INDEX BY BINARY_INTEGER;
79088: TYPE t_array_source_58 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
79089: TYPE t_array_source_72 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79090: TYPE t_array_source_73 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79091: TYPE t_array_source_74 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
79092: TYPE t_array_source_75 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79093: TYPE t_array_source_76 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_CUSTOMER_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79094: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79095: TYPE t_array_source_84 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 79092: TYPE t_array_source_75 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;

79088: TYPE t_array_source_58 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
79089: TYPE t_array_source_72 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79090: TYPE t_array_source_73 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79091: TYPE t_array_source_74 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
79092: TYPE t_array_source_75 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79093: TYPE t_array_source_76 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_CUSTOMER_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79094: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79095: TYPE t_array_source_84 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79096: TYPE t_array_source_85 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 79093: TYPE t_array_source_76 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_CUSTOMER_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

79089: TYPE t_array_source_72 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79090: TYPE t_array_source_73 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79091: TYPE t_array_source_74 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
79092: TYPE t_array_source_75 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79093: TYPE t_array_source_76 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_CUSTOMER_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79094: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79095: TYPE t_array_source_84 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79096: TYPE t_array_source_85 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79097: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

Line 79094: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

79090: TYPE t_array_source_73 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79091: TYPE t_array_source_74 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
79092: TYPE t_array_source_75 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79093: TYPE t_array_source_76 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_CUSTOMER_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79094: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79095: TYPE t_array_source_84 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79096: TYPE t_array_source_85 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79097: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
79098:

Line 79095: TYPE t_array_source_84 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

79091: TYPE t_array_source_74 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
79092: TYPE t_array_source_75 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79093: TYPE t_array_source_76 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_CUSTOMER_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79094: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79095: TYPE t_array_source_84 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79096: TYPE t_array_source_85 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79097: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
79098:
79099: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 79096: TYPE t_array_source_85 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

79092: TYPE t_array_source_75 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79093: TYPE t_array_source_76 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_CUSTOMER_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79094: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79095: TYPE t_array_source_84 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79096: TYPE t_array_source_85 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79097: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
79098:
79099: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
79100: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 79097: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

79093: TYPE t_array_source_76 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_CUSTOMER_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79094: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79095: TYPE t_array_source_84 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79096: TYPE t_array_source_85 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79097: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
79098:
79099: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
79100: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
79101: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 79236: , AR_CASH_RECEIPTS_H_V h2

79232: , h2.RCT_DOC_SEQUENCE_ID source_84
79233: , h2.RCT_DOC_SEQUENCE_VALUE source_85
79234: , h2.RCT_TRX_ACCT_REVERSAL source_86
79235: FROM xla_events_gt xet
79236: , AR_CASH_RECEIPTS_H_V h2
79237: , AR_RCT_SITE_USES_H_V h6
79238: , AR_REMIT_BANK_ACCT_H_V h8
79239: , AR_SYSTEM_PARAM_H_V h9
79240: WHERE xet.event_date between p_pad_start_date and p_pad_end_date