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

Line 77766: WHEN 1 THEN 'AR_CASH_RECEIPTS_H_V'

77762: FROM (
77763: SELECT xet.event_id event_id
77764: , 0 line_number
77765: , CASE r
77766: WHEN 1 THEN 'AR_CASH_RECEIPTS_H_V'
77767: WHEN 2 THEN 'AR_CASH_RECEIPTS_H_V'
77768: WHEN 3 THEN 'AR_RCT_METHOD_H_V'
77769: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
77770: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'

Line 77767: WHEN 2 THEN 'AR_CASH_RECEIPTS_H_V'

77763: SELECT xet.event_id event_id
77764: , 0 line_number
77765: , CASE r
77766: WHEN 1 THEN 'AR_CASH_RECEIPTS_H_V'
77767: WHEN 2 THEN 'AR_CASH_RECEIPTS_H_V'
77768: WHEN 3 THEN 'AR_RCT_METHOD_H_V'
77769: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
77770: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
77771: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'

Line 77769: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'

77765: , CASE r
77766: WHEN 1 THEN 'AR_CASH_RECEIPTS_H_V'
77767: WHEN 2 THEN 'AR_CASH_RECEIPTS_H_V'
77768: WHEN 3 THEN 'AR_RCT_METHOD_H_V'
77769: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
77770: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
77771: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
77772: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
77773: WHEN 8 THEN 'AR_RECEIVABLES_TRX_MISC_H_V'

Line 77772: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'

77768: WHEN 3 THEN 'AR_RCT_METHOD_H_V'
77769: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
77770: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
77771: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
77772: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
77773: WHEN 8 THEN 'AR_RECEIVABLES_TRX_MISC_H_V'
77774: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
77775: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
77776: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'

Line 77774: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'

77770: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
77771: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
77772: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
77773: WHEN 8 THEN 'AR_RECEIVABLES_TRX_MISC_H_V'
77774: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
77775: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
77776: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
77777:
77778: ELSE null

Line 77775: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'

77771: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
77772: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
77773: WHEN 8 THEN 'AR_RECEIVABLES_TRX_MISC_H_V'
77774: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
77775: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
77776: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
77777:
77778: ELSE null
77779: END object_name

Line 77776: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'

77772: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
77773: WHEN 8 THEN 'AR_RECEIVABLES_TRX_MISC_H_V'
77774: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
77775: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
77776: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
77777:
77778: ELSE null
77779: END object_name
77780: , CASE r

Line 77843: , AR_CASH_RECEIPTS_H_V h1

77839: ELSE null
77840: END source_value
77841: , null source_meaning
77842: FROM xla_events_gt xet
77843: , AR_CASH_RECEIPTS_H_V h1
77844: , AR_RCT_METHOD_H_V h4
77845: , AR_RECEIVABLES_TRX_MISC_H_V h5
77846: , AR_REMIT_BANK_ACCT_H_V h6
77847: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

Line 78138: TYPE t_array_source_8 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

78134: --
78135: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
78136: --
78137:
78138: TYPE t_array_source_8 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
78139: TYPE t_array_source_9 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
78140: TYPE t_array_source_10 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
78141: TYPE t_array_source_11 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
78142: TYPE t_array_source_12 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 78139: TYPE t_array_source_9 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

78135: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
78136: --
78137:
78138: TYPE t_array_source_8 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
78139: TYPE t_array_source_9 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
78140: TYPE t_array_source_10 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
78141: TYPE t_array_source_11 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
78142: TYPE t_array_source_12 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
78143: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 78141: TYPE t_array_source_11 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;

78137:
78138: TYPE t_array_source_8 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
78139: TYPE t_array_source_9 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
78140: TYPE t_array_source_10 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
78141: TYPE t_array_source_11 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
78142: TYPE t_array_source_12 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
78143: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
78144: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_CASH_RECEIPT_ID%TYPE INDEX BY BINARY_INTEGER;
78145: TYPE t_array_source_91 IS TABLE OF AR_RECEIVABLES_TRX_MISC_H_V.MC_ACT_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 78144: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_CASH_RECEIPT_ID%TYPE INDEX BY BINARY_INTEGER;

78140: TYPE t_array_source_10 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
78141: TYPE t_array_source_11 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
78142: TYPE t_array_source_12 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
78143: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
78144: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_CASH_RECEIPT_ID%TYPE INDEX BY BINARY_INTEGER;
78145: TYPE t_array_source_91 IS TABLE OF AR_RECEIVABLES_TRX_MISC_H_V.MC_ACT_NAME%TYPE INDEX BY BINARY_INTEGER;
78146: TYPE t_array_source_117 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
78147: TYPE t_array_source_118 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
78148: TYPE t_array_source_119 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

Line 78146: TYPE t_array_source_117 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

78142: TYPE t_array_source_12 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
78143: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
78144: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_CASH_RECEIPT_ID%TYPE INDEX BY BINARY_INTEGER;
78145: TYPE t_array_source_91 IS TABLE OF AR_RECEIVABLES_TRX_MISC_H_V.MC_ACT_NAME%TYPE INDEX BY BINARY_INTEGER;
78146: TYPE t_array_source_117 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
78147: TYPE t_array_source_118 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
78148: TYPE t_array_source_119 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
78149:
78150: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 78147: TYPE t_array_source_118 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

78143: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
78144: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_CASH_RECEIPT_ID%TYPE INDEX BY BINARY_INTEGER;
78145: TYPE t_array_source_91 IS TABLE OF AR_RECEIVABLES_TRX_MISC_H_V.MC_ACT_NAME%TYPE INDEX BY BINARY_INTEGER;
78146: TYPE t_array_source_117 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
78147: TYPE t_array_source_118 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
78148: TYPE t_array_source_119 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
78149:
78150: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
78151: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 78148: TYPE t_array_source_119 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

78144: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_CASH_RECEIPT_ID%TYPE INDEX BY BINARY_INTEGER;
78145: TYPE t_array_source_91 IS TABLE OF AR_RECEIVABLES_TRX_MISC_H_V.MC_ACT_NAME%TYPE INDEX BY BINARY_INTEGER;
78146: TYPE t_array_source_117 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
78147: TYPE t_array_source_118 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
78148: TYPE t_array_source_119 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
78149:
78150: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
78151: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
78152: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 78227: , AR_CASH_RECEIPTS_H_V h1

78223: , h1.RCT_DOC_SEQUENCE_CATEGORY source_117
78224: , h1.RCT_DOC_SEQUENCE_ID source_118
78225: , h1.RCT_TRX_ACCT_REVERSAL source_119
78226: FROM xla_events_gt xet
78227: , AR_CASH_RECEIPTS_H_V h1
78228: , AR_RCT_METHOD_H_V h4
78229: , AR_RECEIVABLES_TRX_MISC_H_V h5
78230: , AR_REMIT_BANK_ACCT_H_V h6
78231: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 79269: WHEN 1 THEN 'AR_CASH_RECEIPTS_H_V'

79265: FROM (
79266: SELECT xet.event_id event_id
79267: , 0 line_number
79268: , CASE r
79269: WHEN 1 THEN 'AR_CASH_RECEIPTS_H_V'
79270: WHEN 2 THEN 'AR_CASH_RECEIPTS_H_V'
79271: WHEN 3 THEN 'AR_RCT_METHOD_H_V'
79272: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
79273: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'

Line 79270: WHEN 2 THEN 'AR_CASH_RECEIPTS_H_V'

79266: SELECT xet.event_id event_id
79267: , 0 line_number
79268: , CASE r
79269: WHEN 1 THEN 'AR_CASH_RECEIPTS_H_V'
79270: WHEN 2 THEN 'AR_CASH_RECEIPTS_H_V'
79271: WHEN 3 THEN 'AR_RCT_METHOD_H_V'
79272: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
79273: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
79274: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'

Line 79272: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'

79268: , CASE r
79269: WHEN 1 THEN 'AR_CASH_RECEIPTS_H_V'
79270: WHEN 2 THEN 'AR_CASH_RECEIPTS_H_V'
79271: WHEN 3 THEN 'AR_RCT_METHOD_H_V'
79272: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
79273: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
79274: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
79275: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'
79276: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'

Line 79278: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'

79274: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
79275: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'
79276: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
79277: WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'
79278: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
79279: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
79280: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
79281: WHEN 13 THEN 'AR_RCT_SITE_USES_H_V'
79282: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'

Line 79279: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'

79275: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'
79276: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
79277: WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'
79278: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
79279: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
79280: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
79281: WHEN 13 THEN 'AR_RCT_SITE_USES_H_V'
79282: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
79283: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'

Line 79280: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'

79276: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
79277: WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'
79278: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
79279: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
79280: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
79281: WHEN 13 THEN 'AR_RCT_SITE_USES_H_V'
79282: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
79283: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
79284: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'

Line 79282: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'

79278: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
79279: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
79280: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
79281: WHEN 13 THEN 'AR_RCT_SITE_USES_H_V'
79282: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
79283: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
79284: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
79285: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
79286:

Line 79283: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'

79279: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
79280: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
79281: WHEN 13 THEN 'AR_RCT_SITE_USES_H_V'
79282: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
79283: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
79284: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
79285: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
79286:
79287: ELSE null

Line 79284: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'

79280: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
79281: WHEN 13 THEN 'AR_RCT_SITE_USES_H_V'
79282: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
79283: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
79284: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
79285: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
79286:
79287: ELSE null
79288: END object_name

Line 79285: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'

79281: WHEN 13 THEN 'AR_RCT_SITE_USES_H_V'
79282: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
79283: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
79284: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
79285: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
79286:
79287: ELSE null
79288: END object_name
79289: , CASE r

Line 79376: , AR_CASH_RECEIPTS_H_V h1

79372: ELSE null
79373: END source_value
79374: , null source_meaning
79375: FROM xla_events_gt xet
79376: , AR_CASH_RECEIPTS_H_V h1
79377: , AR_RCT_METHOD_H_V h5
79378: , AR_RCT_SITE_USES_H_V h6
79379: , AR_REMIT_BANK_ACCT_H_V h8
79380: , AR_SYSTEM_PARAM_H_V h9

Line 79777: TYPE t_array_source_8 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

79773: --
79774: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
79775: --
79776:
79777: TYPE t_array_source_8 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
79778: TYPE t_array_source_9 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79779: TYPE t_array_source_10 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
79780: TYPE t_array_source_11 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
79781: TYPE t_array_source_12 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 79778: TYPE t_array_source_9 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

79774: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
79775: --
79776:
79777: TYPE t_array_source_8 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
79778: TYPE t_array_source_9 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79779: TYPE t_array_source_10 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
79780: TYPE t_array_source_11 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
79781: TYPE t_array_source_12 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
79782: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 79780: TYPE t_array_source_11 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;

79776:
79777: TYPE t_array_source_8 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
79778: TYPE t_array_source_9 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79779: TYPE t_array_source_10 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
79780: TYPE t_array_source_11 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
79781: TYPE t_array_source_12 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
79782: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
79783: TYPE t_array_source_23 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
79784: TYPE t_array_source_24 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;

Line 79786: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_CASH_RECEIPT_ID%TYPE INDEX BY BINARY_INTEGER;

79782: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
79783: TYPE t_array_source_23 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
79784: TYPE t_array_source_24 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
79785: TYPE t_array_source_25 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
79786: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_CASH_RECEIPT_ID%TYPE INDEX BY BINARY_INTEGER;
79787: TYPE t_array_source_92 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
79788: TYPE t_array_source_104 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79789: TYPE t_array_source_105 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79790: TYPE t_array_source_106 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;

Line 79787: TYPE t_array_source_92 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;

79783: TYPE t_array_source_23 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
79784: TYPE t_array_source_24 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
79785: TYPE t_array_source_25 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
79786: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_CASH_RECEIPT_ID%TYPE INDEX BY BINARY_INTEGER;
79787: TYPE t_array_source_92 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
79788: TYPE t_array_source_104 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79789: TYPE t_array_source_105 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79790: TYPE t_array_source_106 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
79791: TYPE t_array_source_117 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 79788: TYPE t_array_source_104 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;

79784: TYPE t_array_source_24 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
79785: TYPE t_array_source_25 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
79786: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_CASH_RECEIPT_ID%TYPE INDEX BY BINARY_INTEGER;
79787: TYPE t_array_source_92 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
79788: TYPE t_array_source_104 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79789: TYPE t_array_source_105 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79790: TYPE t_array_source_106 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
79791: TYPE t_array_source_117 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79792: TYPE t_array_source_118 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 79790: TYPE t_array_source_106 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;

79786: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_CASH_RECEIPT_ID%TYPE INDEX BY BINARY_INTEGER;
79787: TYPE t_array_source_92 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
79788: TYPE t_array_source_104 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79789: TYPE t_array_source_105 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79790: TYPE t_array_source_106 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
79791: TYPE t_array_source_117 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79792: TYPE t_array_source_118 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79793: TYPE t_array_source_119 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
79794:

Line 79791: TYPE t_array_source_117 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

79787: TYPE t_array_source_92 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
79788: TYPE t_array_source_104 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79789: TYPE t_array_source_105 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79790: TYPE t_array_source_106 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
79791: TYPE t_array_source_117 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79792: TYPE t_array_source_118 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79793: TYPE t_array_source_119 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
79794:
79795: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 79792: TYPE t_array_source_118 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

79788: TYPE t_array_source_104 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79789: TYPE t_array_source_105 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79790: TYPE t_array_source_106 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
79791: TYPE t_array_source_117 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79792: TYPE t_array_source_118 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79793: TYPE t_array_source_119 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
79794:
79795: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
79796: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 79793: TYPE t_array_source_119 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

79789: TYPE t_array_source_105 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79790: TYPE t_array_source_106 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
79791: TYPE t_array_source_117 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79792: TYPE t_array_source_118 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79793: TYPE t_array_source_119 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
79794:
79795: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
79796: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
79797: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 79922: , AR_CASH_RECEIPTS_H_V h1

79918: , h1.RCT_DOC_SEQUENCE_CATEGORY source_117
79919: , h1.RCT_DOC_SEQUENCE_ID source_118
79920: , h1.RCT_TRX_ACCT_REVERSAL source_119
79921: FROM xla_events_gt xet
79922: , AR_CASH_RECEIPTS_H_V h1
79923: , AR_RCT_METHOD_H_V h5
79924: , AR_RCT_SITE_USES_H_V h6
79925: , AR_REMIT_BANK_ACCT_H_V h8
79926: , AR_SYSTEM_PARAM_H_V h9