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

Line 81737: WHEN 3 THEN 'AR_CASH_RECEIPTS_H_V'

81733: , 0 line_number
81734: , CASE r
81735: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
81736: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
81737: WHEN 3 THEN 'AR_CASH_RECEIPTS_H_V'
81738: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
81739: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
81740: WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V'
81741: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'

Line 81738: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'

81734: , CASE r
81735: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
81736: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
81737: WHEN 3 THEN 'AR_CASH_RECEIPTS_H_V'
81738: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
81739: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
81740: WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V'
81741: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
81742: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'

Line 81740: WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V'

81736: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
81737: WHEN 3 THEN 'AR_CASH_RECEIPTS_H_V'
81738: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
81739: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
81740: WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V'
81741: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
81742: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
81743: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
81744:

Line 81741: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'

81737: WHEN 3 THEN 'AR_CASH_RECEIPTS_H_V'
81738: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
81739: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
81740: WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V'
81741: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
81742: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
81743: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
81744:
81745: ELSE null

Line 81742: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'

81738: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
81739: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
81740: WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V'
81741: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
81742: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
81743: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
81744:
81745: ELSE null
81746: END object_name

Line 81743: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'

81739: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
81740: WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V'
81741: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
81742: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
81743: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
81744:
81745: ELSE null
81746: END object_name
81747: , CASE r

Line 81802: , AR_CASH_RECEIPTS_H_V h1

81798: ELSE null
81799: END source_value
81800: , null source_meaning
81801: FROM xla_events_gt xet
81802: , AR_CASH_RECEIPTS_H_V h1
81803: , AR_RCT_METHOD_H_V h4
81804: , AR_REMIT_BANK_ACCT_H_V h5
81805: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
81806: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 82094: TYPE t_array_source_20 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

82090: --
82091:
82092: TYPE t_array_source_16 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
82093: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
82094: TYPE t_array_source_20 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
82095: TYPE t_array_source_21 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
82096: TYPE t_array_source_22 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
82097: TYPE t_array_source_23 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
82098: TYPE t_array_source_125 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 82095: TYPE t_array_source_21 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

82091:
82092: TYPE t_array_source_16 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
82093: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
82094: TYPE t_array_source_20 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
82095: TYPE t_array_source_21 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
82096: TYPE t_array_source_22 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
82097: TYPE t_array_source_23 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
82098: TYPE t_array_source_125 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
82099: TYPE t_array_source_126 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 82097: TYPE t_array_source_23 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;

82093: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
82094: TYPE t_array_source_20 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
82095: TYPE t_array_source_21 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
82096: TYPE t_array_source_22 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
82097: TYPE t_array_source_23 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
82098: TYPE t_array_source_125 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
82099: TYPE t_array_source_126 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
82100: TYPE t_array_source_127 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
82101:

Line 82098: TYPE t_array_source_125 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

82094: TYPE t_array_source_20 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
82095: TYPE t_array_source_21 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
82096: TYPE t_array_source_22 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
82097: TYPE t_array_source_23 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
82098: TYPE t_array_source_125 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
82099: TYPE t_array_source_126 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
82100: TYPE t_array_source_127 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
82101:
82102: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 82099: TYPE t_array_source_126 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

82095: TYPE t_array_source_21 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
82096: TYPE t_array_source_22 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
82097: TYPE t_array_source_23 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
82098: TYPE t_array_source_125 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
82099: TYPE t_array_source_126 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
82100: TYPE t_array_source_127 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
82101:
82102: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
82103: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 82100: TYPE t_array_source_127 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

82096: TYPE t_array_source_22 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
82097: TYPE t_array_source_23 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
82098: TYPE t_array_source_125 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
82099: TYPE t_array_source_126 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
82100: TYPE t_array_source_127 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
82101:
82102: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
82103: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
82104: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 82175: , AR_CASH_RECEIPTS_H_V h1

82171: , h1.RCT_DOC_SEQUENCE_CATEGORY source_125
82172: , h1.RCT_DOC_SEQUENCE_ID source_126
82173: , h1.RCT_TRX_ACCT_REVERSAL source_127
82174: FROM xla_events_gt xet
82175: , AR_CASH_RECEIPTS_H_V h1
82176: , AR_RCT_METHOD_H_V h4
82177: , AR_REMIT_BANK_ACCT_H_V h5
82178: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
82179: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 83204: WHEN 3 THEN 'AR_CASH_RECEIPTS_H_V'

83200: , 0 line_number
83201: , CASE r
83202: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
83203: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
83204: WHEN 3 THEN 'AR_CASH_RECEIPTS_H_V'
83205: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
83206: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
83207: WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V'
83208: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'

Line 83205: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'

83201: , CASE r
83202: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
83203: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
83204: WHEN 3 THEN 'AR_CASH_RECEIPTS_H_V'
83205: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
83206: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
83207: WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V'
83208: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'
83209: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'

Line 83207: WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V'

83203: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
83204: WHEN 3 THEN 'AR_CASH_RECEIPTS_H_V'
83205: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
83206: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
83207: WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V'
83208: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'
83209: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
83210: WHEN 9 THEN 'AR_REMIT_BANK_ACCT_H_V'
83211: WHEN 10 THEN 'AR_REMIT_BANK_ACCT_H_V'

Line 83212: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'

83208: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'
83209: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
83210: WHEN 9 THEN 'AR_REMIT_BANK_ACCT_H_V'
83211: WHEN 10 THEN 'AR_REMIT_BANK_ACCT_H_V'
83212: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
83213: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
83214: WHEN 13 THEN 'AR_RCT_SITE_USES_H_V'
83215: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
83216: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'

Line 83213: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'

83209: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
83210: WHEN 9 THEN 'AR_REMIT_BANK_ACCT_H_V'
83211: WHEN 10 THEN 'AR_REMIT_BANK_ACCT_H_V'
83212: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
83213: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
83214: WHEN 13 THEN 'AR_RCT_SITE_USES_H_V'
83215: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
83216: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
83217: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'

Line 83215: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'

83211: WHEN 10 THEN 'AR_REMIT_BANK_ACCT_H_V'
83212: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
83213: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
83214: WHEN 13 THEN 'AR_RCT_SITE_USES_H_V'
83215: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
83216: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
83217: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
83218: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
83219: WHEN 18 THEN 'AR_CASH_RECEIPTS_H_V'

Line 83216: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'

83212: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
83213: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
83214: WHEN 13 THEN 'AR_RCT_SITE_USES_H_V'
83215: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
83216: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
83217: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
83218: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
83219: WHEN 18 THEN 'AR_CASH_RECEIPTS_H_V'
83220: WHEN 19 THEN 'AR_CASH_RECEIPTS_H_V'

Line 83217: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'

83213: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
83214: WHEN 13 THEN 'AR_RCT_SITE_USES_H_V'
83215: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
83216: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
83217: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
83218: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
83219: WHEN 18 THEN 'AR_CASH_RECEIPTS_H_V'
83220: WHEN 19 THEN 'AR_CASH_RECEIPTS_H_V'
83221:

Line 83218: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'

83214: WHEN 13 THEN 'AR_RCT_SITE_USES_H_V'
83215: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
83216: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
83217: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
83218: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
83219: WHEN 18 THEN 'AR_CASH_RECEIPTS_H_V'
83220: WHEN 19 THEN 'AR_CASH_RECEIPTS_H_V'
83221:
83222: ELSE null

Line 83219: WHEN 18 THEN 'AR_CASH_RECEIPTS_H_V'

83215: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
83216: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
83217: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
83218: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
83219: WHEN 18 THEN 'AR_CASH_RECEIPTS_H_V'
83220: WHEN 19 THEN 'AR_CASH_RECEIPTS_H_V'
83221:
83222: ELSE null
83223: END object_name

Line 83220: WHEN 19 THEN 'AR_CASH_RECEIPTS_H_V'

83216: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
83217: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
83218: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
83219: WHEN 18 THEN 'AR_CASH_RECEIPTS_H_V'
83220: WHEN 19 THEN 'AR_CASH_RECEIPTS_H_V'
83221:
83222: ELSE null
83223: END object_name
83224: , CASE r

Line 83319: , AR_CASH_RECEIPTS_H_V h1

83315: ELSE null
83316: END source_value
83317: , null source_meaning
83318: FROM xla_events_gt xet
83319: , AR_CASH_RECEIPTS_H_V h1
83320: , AR_RCT_METHOD_H_V h5
83321: , AR_RCT_SITE_USES_H_V h6
83322: , AR_REMIT_BANK_ACCT_H_V h8
83323: , AR_SYSTEM_PARAM_H_V h9

Line 83722: TYPE t_array_source_20 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

83718: --
83719:
83720: TYPE t_array_source_16 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
83721: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
83722: TYPE t_array_source_20 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
83723: TYPE t_array_source_21 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
83724: TYPE t_array_source_22 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
83725: TYPE t_array_source_23 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
83726: TYPE t_array_source_34 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;

Line 83723: TYPE t_array_source_21 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

83719:
83720: TYPE t_array_source_16 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
83721: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
83722: TYPE t_array_source_20 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
83723: TYPE t_array_source_21 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
83724: TYPE t_array_source_22 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
83725: TYPE t_array_source_23 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
83726: TYPE t_array_source_34 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
83727: TYPE t_array_source_35 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;

Line 83725: TYPE t_array_source_23 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;

83721: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
83722: TYPE t_array_source_20 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
83723: TYPE t_array_source_21 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
83724: TYPE t_array_source_22 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
83725: TYPE t_array_source_23 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
83726: TYPE t_array_source_34 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
83727: TYPE t_array_source_35 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
83728: TYPE t_array_source_36 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
83729: TYPE t_array_source_37 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNIDENTIFIED_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 83730: TYPE t_array_source_101 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;

83726: TYPE t_array_source_34 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
83727: TYPE t_array_source_35 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
83728: TYPE t_array_source_36 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
83729: TYPE t_array_source_37 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNIDENTIFIED_CCID%TYPE INDEX BY BINARY_INTEGER;
83730: TYPE t_array_source_101 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
83731: TYPE t_array_source_112 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
83732: TYPE t_array_source_113 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
83733: TYPE t_array_source_114 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
83734: TYPE t_array_source_115 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;

Line 83731: TYPE t_array_source_112 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;

83727: TYPE t_array_source_35 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
83728: TYPE t_array_source_36 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
83729: TYPE t_array_source_37 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNIDENTIFIED_CCID%TYPE INDEX BY BINARY_INTEGER;
83730: TYPE t_array_source_101 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
83731: TYPE t_array_source_112 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
83732: TYPE t_array_source_113 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
83733: TYPE t_array_source_114 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
83734: TYPE t_array_source_115 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
83735: TYPE t_array_source_116 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_CUSTOMER_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 83733: TYPE t_array_source_114 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;

83729: TYPE t_array_source_37 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNIDENTIFIED_CCID%TYPE INDEX BY BINARY_INTEGER;
83730: TYPE t_array_source_101 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
83731: TYPE t_array_source_112 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
83732: TYPE t_array_source_113 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
83733: TYPE t_array_source_114 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
83734: TYPE t_array_source_115 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
83735: TYPE t_array_source_116 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_CUSTOMER_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
83736: TYPE t_array_source_125 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
83737: TYPE t_array_source_126 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 83734: TYPE t_array_source_115 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;

83730: TYPE t_array_source_101 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
83731: TYPE t_array_source_112 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
83732: TYPE t_array_source_113 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
83733: TYPE t_array_source_114 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
83734: TYPE t_array_source_115 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
83735: TYPE t_array_source_116 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_CUSTOMER_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
83736: TYPE t_array_source_125 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
83737: TYPE t_array_source_126 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
83738: TYPE t_array_source_127 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

Line 83735: TYPE t_array_source_116 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_CUSTOMER_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

83731: TYPE t_array_source_112 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
83732: TYPE t_array_source_113 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
83733: TYPE t_array_source_114 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
83734: TYPE t_array_source_115 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
83735: TYPE t_array_source_116 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_CUSTOMER_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
83736: TYPE t_array_source_125 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
83737: TYPE t_array_source_126 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
83738: TYPE t_array_source_127 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
83739:

Line 83736: TYPE t_array_source_125 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

83732: TYPE t_array_source_113 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
83733: TYPE t_array_source_114 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
83734: TYPE t_array_source_115 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
83735: TYPE t_array_source_116 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_CUSTOMER_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
83736: TYPE t_array_source_125 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
83737: TYPE t_array_source_126 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
83738: TYPE t_array_source_127 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
83739:
83740: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 83737: TYPE t_array_source_126 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

83733: TYPE t_array_source_114 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
83734: TYPE t_array_source_115 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
83735: TYPE t_array_source_116 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_CUSTOMER_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
83736: TYPE t_array_source_125 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
83737: TYPE t_array_source_126 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
83738: TYPE t_array_source_127 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
83739:
83740: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
83741: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 83738: TYPE t_array_source_127 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

83734: TYPE t_array_source_115 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
83735: TYPE t_array_source_116 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PREV_CUSTOMER_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
83736: TYPE t_array_source_125 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
83737: TYPE t_array_source_126 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
83738: TYPE t_array_source_127 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
83739:
83740: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
83741: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
83742: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 83871: , AR_CASH_RECEIPTS_H_V h1

83867: , h1.RCT_DOC_SEQUENCE_CATEGORY source_125
83868: , h1.RCT_DOC_SEQUENCE_ID source_126
83869: , h1.RCT_TRX_ACCT_REVERSAL source_127
83870: FROM xla_events_gt xet
83871: , AR_CASH_RECEIPTS_H_V h1
83872: , AR_RCT_METHOD_H_V h5
83873: , AR_RCT_SITE_USES_H_V h6
83874: , AR_REMIT_BANK_ACCT_H_V h8
83875: , AR_SYSTEM_PARAM_H_V h9