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

Line 20880: WHEN 1 THEN 'AR_CASH_RECEIPTS_H_V'

20876: FROM (
20877: SELECT xet.event_id event_id
20878: , 0 line_number
20879: , CASE r
20880: WHEN 1 THEN 'AR_CASH_RECEIPTS_H_V'
20881: WHEN 2 THEN 'AR_CASH_RECEIPTS_H_V'
20882: WHEN 3 THEN 'AR_CASH_RECEIPTS_H_V'
20883: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
20884:

Line 20881: WHEN 2 THEN 'AR_CASH_RECEIPTS_H_V'

20877: SELECT xet.event_id event_id
20878: , 0 line_number
20879: , CASE r
20880: WHEN 1 THEN 'AR_CASH_RECEIPTS_H_V'
20881: WHEN 2 THEN 'AR_CASH_RECEIPTS_H_V'
20882: WHEN 3 THEN 'AR_CASH_RECEIPTS_H_V'
20883: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
20884:
20885: ELSE null

Line 20882: WHEN 3 THEN 'AR_CASH_RECEIPTS_H_V'

20878: , 0 line_number
20879: , CASE r
20880: WHEN 1 THEN 'AR_CASH_RECEIPTS_H_V'
20881: WHEN 2 THEN 'AR_CASH_RECEIPTS_H_V'
20882: WHEN 3 THEN 'AR_CASH_RECEIPTS_H_V'
20883: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
20884:
20885: ELSE null
20886: END object_name

Line 20883: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'

20879: , CASE r
20880: WHEN 1 THEN 'AR_CASH_RECEIPTS_H_V'
20881: WHEN 2 THEN 'AR_CASH_RECEIPTS_H_V'
20882: WHEN 3 THEN 'AR_CASH_RECEIPTS_H_V'
20883: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
20884:
20885: ELSE null
20886: END object_name
20887: , CASE r

Line 20922: , AR_CASH_RECEIPTS_H_V h1

20918: ELSE null
20919: END source_value
20920: , null source_meaning
20921: FROM xla_events_gt xet
20922: , AR_CASH_RECEIPTS_H_V h1
20923: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
20924: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
20925: AND xet.event_class_code = C_EVENT_CLASS_CODE
20926:

Line 21210: TYPE t_array_source_37 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

21206: --
21207: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
21208: --
21209:
21210: TYPE t_array_source_37 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
21211: TYPE t_array_source_38 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
21212: TYPE t_array_source_39 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
21213: TYPE t_array_source_41 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
21214:

Line 21211: TYPE t_array_source_38 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

21207: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
21208: --
21209:
21210: TYPE t_array_source_37 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
21211: TYPE t_array_source_38 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
21212: TYPE t_array_source_39 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
21213: TYPE t_array_source_41 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
21214:
21215: TYPE t_array_source_1 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 21212: TYPE t_array_source_39 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

21208: --
21209:
21210: TYPE t_array_source_37 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
21211: TYPE t_array_source_38 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
21212: TYPE t_array_source_39 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
21213: TYPE t_array_source_41 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
21214:
21215: TYPE t_array_source_1 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
21216: TYPE t_array_source_7 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 21213: TYPE t_array_source_41 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

21209:
21210: TYPE t_array_source_37 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
21211: TYPE t_array_source_38 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
21212: TYPE t_array_source_39 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
21213: TYPE t_array_source_41 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
21214:
21215: TYPE t_array_source_1 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
21216: TYPE t_array_source_7 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
21217: TYPE t_array_source_8 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;

Line 21278: , AR_CASH_RECEIPTS_H_V h1

21274: , h1.RCT_DOC_SEQUENCE_ID source_38
21275: , h1.RCT_DOC_SEQUENCE_VALUE source_39
21276: , h1.RCT_TRX_ACCT_REVERSAL source_41
21277: FROM xla_events_gt xet
21278: , AR_CASH_RECEIPTS_H_V h1
21279: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
21280: and xet.event_class_code = C_EVENT_CLASS_CODE
21281: and xet.event_status_code <> 'N' AND h1.event_id (+) = xet.event_id
21282:

Line 22280: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'

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'
22282: WHEN 6 THEN 'AR_RCT_SITE_USES_H_V'
22283: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
22284: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'

Line 22281: WHEN 5 THEN 'AR_CASH_RECEIPTS_H_V'

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'
22282: WHEN 6 THEN 'AR_RCT_SITE_USES_H_V'
22283: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
22284: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
22285: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'

Line 22283: WHEN 7 THEN 'AR_CASH_RECEIPTS_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'
22282: WHEN 6 THEN 'AR_RCT_SITE_USES_H_V'
22283: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
22284: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
22285: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
22286: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
22287: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'

Line 22284: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'

22280: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
22281: WHEN 5 THEN 'AR_CASH_RECEIPTS_H_V'
22282: WHEN 6 THEN 'AR_RCT_SITE_USES_H_V'
22283: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
22284: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
22285: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
22286: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
22287: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
22288:

Line 22285: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'

22281: WHEN 5 THEN 'AR_CASH_RECEIPTS_H_V'
22282: WHEN 6 THEN 'AR_RCT_SITE_USES_H_V'
22283: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
22284: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
22285: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
22286: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
22287: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
22288:
22289: ELSE null

Line 22286: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'

22282: WHEN 6 THEN 'AR_RCT_SITE_USES_H_V'
22283: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
22284: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
22285: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
22286: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
22287: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
22288:
22289: ELSE null
22290: END object_name

Line 22287: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'

22283: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
22284: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
22285: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
22286: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
22287: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
22288:
22289: ELSE null
22290: END object_name
22291: , CASE r

Line 22354: , AR_CASH_RECEIPTS_H_V h1

22350: ELSE null
22351: END source_value
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)

Line 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;

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;
22753: TYPE t_array_source_35 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
22754: TYPE t_array_source_36 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
22755: TYPE t_array_source_37 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 22752: TYPE t_array_source_34 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;

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;
22753: TYPE t_array_source_35 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
22754: TYPE t_array_source_36 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
22755: TYPE t_array_source_37 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
22756: TYPE t_array_source_38 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 22754: TYPE t_array_source_36 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%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;
22753: TYPE t_array_source_35 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
22754: TYPE t_array_source_36 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
22755: TYPE t_array_source_37 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
22756: TYPE t_array_source_38 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
22757: TYPE t_array_source_39 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
22758: TYPE t_array_source_41 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

Line 22755: TYPE t_array_source_37 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%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;
22753: TYPE t_array_source_35 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
22754: TYPE t_array_source_36 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
22755: TYPE t_array_source_37 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
22756: TYPE t_array_source_38 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
22757: TYPE t_array_source_39 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
22758: TYPE t_array_source_41 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
22759:

Line 22756: TYPE t_array_source_38 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_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;
22753: TYPE t_array_source_35 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
22754: TYPE t_array_source_36 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
22755: TYPE t_array_source_37 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
22756: TYPE t_array_source_38 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
22757: TYPE t_array_source_39 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
22758: TYPE t_array_source_41 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
22759:
22760: TYPE t_array_source_1 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 22757: TYPE t_array_source_39 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

22753: TYPE t_array_source_35 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
22754: TYPE t_array_source_36 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
22755: TYPE t_array_source_37 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
22756: TYPE t_array_source_38 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
22757: TYPE t_array_source_39 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
22758: TYPE t_array_source_41 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
22759:
22760: TYPE t_array_source_1 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
22761: TYPE t_array_source_5 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 22758: TYPE t_array_source_41 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

22754: TYPE t_array_source_36 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
22755: TYPE t_array_source_37 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
22756: TYPE t_array_source_38 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
22757: TYPE t_array_source_39 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
22758: TYPE t_array_source_41 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
22759:
22760: TYPE t_array_source_1 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
22761: TYPE t_array_source_5 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
22762: TYPE t_array_source_6 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_REF_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 22873: , AR_CASH_RECEIPTS_H_V h1

22869: , h1.RCT_DOC_SEQUENCE_ID source_38
22870: , h1.RCT_DOC_SEQUENCE_VALUE source_39
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