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

Line 77486: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'

77482: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
77483: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
77484: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
77485: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
77486: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
77487: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
77488: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
77489: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
77490:

Line 77487: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'

77483: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
77484: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
77485: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
77486: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
77487: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
77488: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
77489: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
77490:
77491: ELSE null

Line 77488: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'

77484: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
77485: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
77486: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
77487: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
77488: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
77489: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
77490:
77491: ELSE null
77492: END object_name

Line 77489: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'

77485: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
77486: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
77487: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
77488: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
77489: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
77490:
77491: ELSE null
77492: END object_name
77493: , CASE r

Line 77552: , AR_CASH_RECEIPTS_H_V h1

77548: ELSE null
77549: END source_value
77550: , null source_meaning
77551: FROM xla_events_gt xet
77552: , AR_CASH_RECEIPTS_H_V h1
77553: , AR_RCT_METHOD_H_V h4
77554: , AR_REMIT_BANK_ACCT_H_V h5
77555: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
77556: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 77879: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

77875: TYPE t_array_source_5 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
77876: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
77877: TYPE t_array_source_72 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
77878: TYPE t_array_source_73 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
77879: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77880: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
77881: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
77882: TYPE t_array_source_91 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
77883:

Line 77880: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

77876: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
77877: TYPE t_array_source_72 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
77878: TYPE t_array_source_73 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
77879: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77880: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
77881: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
77882: TYPE t_array_source_91 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
77883:
77884: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 77881: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

77877: TYPE t_array_source_72 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
77878: TYPE t_array_source_73 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
77879: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77880: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
77881: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
77882: TYPE t_array_source_91 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
77883:
77884: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
77885: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 77882: TYPE t_array_source_91 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

77878: TYPE t_array_source_73 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
77879: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77880: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
77881: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
77882: TYPE t_array_source_91 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
77883:
77884: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
77885: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77886: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;

Line 77971: , AR_CASH_RECEIPTS_H_V h1

77967: , h1.RCT_DOC_SEQUENCE_ID source_89
77968: , h1.RCT_DOC_SEQUENCE_VALUE source_90
77969: , h1.RCT_TRX_ACCT_REVERSAL source_91
77970: FROM xla_events_gt xet
77971: , AR_CASH_RECEIPTS_H_V h1
77972: , AR_RCT_METHOD_H_V h4
77973: , AR_REMIT_BANK_ACCT_H_V h5
77974: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
77975: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 79328: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'

79324: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
79325: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'
79326: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
79327: WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'
79328: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
79329: WHEN 11 THEN 'AR_RCT_METHOD_H_V'
79330: WHEN 12 THEN 'AR_RCT_METHOD_H_V'
79331: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
79332: WHEN 14 THEN 'AR_RCT_SITE_USES_H_V'

Line 79331: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'

79327: WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'
79328: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
79329: WHEN 11 THEN 'AR_RCT_METHOD_H_V'
79330: WHEN 12 THEN 'AR_RCT_METHOD_H_V'
79331: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
79332: WHEN 14 THEN 'AR_RCT_SITE_USES_H_V'
79333: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
79334: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
79335: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'

Line 79333: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'

79329: WHEN 11 THEN 'AR_RCT_METHOD_H_V'
79330: WHEN 12 THEN 'AR_RCT_METHOD_H_V'
79331: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
79332: WHEN 14 THEN 'AR_RCT_SITE_USES_H_V'
79333: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
79334: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
79335: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
79336: WHEN 18 THEN 'AR_CASH_RECEIPTS_H_V'
79337: WHEN 19 THEN 'AR_CASH_RECEIPTS_H_V'

Line 79334: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'

79330: WHEN 12 THEN 'AR_RCT_METHOD_H_V'
79331: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
79332: WHEN 14 THEN 'AR_RCT_SITE_USES_H_V'
79333: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
79334: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
79335: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
79336: WHEN 18 THEN 'AR_CASH_RECEIPTS_H_V'
79337: WHEN 19 THEN 'AR_CASH_RECEIPTS_H_V'
79338:

Line 79335: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'

79331: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
79332: WHEN 14 THEN 'AR_RCT_SITE_USES_H_V'
79333: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
79334: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
79335: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
79336: WHEN 18 THEN 'AR_CASH_RECEIPTS_H_V'
79337: WHEN 19 THEN 'AR_CASH_RECEIPTS_H_V'
79338:
79339: ELSE null

Line 79336: WHEN 18 THEN 'AR_CASH_RECEIPTS_H_V'

79332: WHEN 14 THEN 'AR_RCT_SITE_USES_H_V'
79333: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
79334: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
79335: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
79336: WHEN 18 THEN 'AR_CASH_RECEIPTS_H_V'
79337: WHEN 19 THEN 'AR_CASH_RECEIPTS_H_V'
79338:
79339: ELSE null
79340: END object_name

Line 79337: WHEN 19 THEN 'AR_CASH_RECEIPTS_H_V'

79333: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
79334: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
79335: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
79336: WHEN 18 THEN 'AR_CASH_RECEIPTS_H_V'
79337: WHEN 19 THEN 'AR_CASH_RECEIPTS_H_V'
79338:
79339: ELSE null
79340: END object_name
79341: , CASE r

Line 79436: , AR_CASH_RECEIPTS_H_V h2

79432: ELSE null
79433: END source_value
79434: , null source_meaning
79435: FROM xla_events_gt xet
79436: , AR_CASH_RECEIPTS_H_V h2
79437: , AR_RCT_METHOD_H_V h6
79438: , AR_RCT_SITE_USES_H_V h7
79439: , AR_REMIT_BANK_ACCT_H_V h9
79440: , AR_SYSTEM_PARAM_H_V h10

Line 79875: TYPE t_array_source_60 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;

79871: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNEARNED_CCID%TYPE INDEX BY BINARY_INTEGER;
79872: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
79873: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
79874: TYPE t_array_source_20 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
79875: TYPE t_array_source_60 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
79876: TYPE t_array_source_72 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
79877: TYPE t_array_source_73 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
79878: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79879: TYPE t_array_source_79 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 79878: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;

79874: TYPE t_array_source_20 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
79875: TYPE t_array_source_60 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
79876: TYPE t_array_source_72 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
79877: TYPE t_array_source_73 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
79878: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79879: TYPE t_array_source_79 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79880: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
79881: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79882: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 79880: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;

79876: TYPE t_array_source_72 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
79877: TYPE t_array_source_73 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
79878: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79879: TYPE t_array_source_79 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79880: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
79881: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79882: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79883: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79884: TYPE t_array_source_91 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

Line 79881: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

79877: TYPE t_array_source_73 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
79878: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79879: TYPE t_array_source_79 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79880: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
79881: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79882: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79883: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79884: TYPE t_array_source_91 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
79885:

Line 79882: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

79878: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79879: TYPE t_array_source_79 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79880: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
79881: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79882: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79883: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79884: TYPE t_array_source_91 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
79885:
79886: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 79883: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

79879: TYPE t_array_source_79 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79880: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
79881: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79882: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79883: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79884: TYPE t_array_source_91 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
79885:
79886: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79887: TYPE t_array_source_12 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 79884: TYPE t_array_source_91 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

79880: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
79881: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79882: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79883: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79884: TYPE t_array_source_91 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
79885:
79886: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79887: TYPE t_array_source_12 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
79888: TYPE t_array_source_13 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_RULE%TYPE INDEX BY BINARY_INTEGER;

Line 80027: , AR_CASH_RECEIPTS_H_V h2

80023: , h2.RCT_DOC_SEQUENCE_ID source_89
80024: , h2.RCT_DOC_SEQUENCE_VALUE source_90
80025: , h2.RCT_TRX_ACCT_REVERSAL source_91
80026: FROM xla_events_gt xet
80027: , AR_CASH_RECEIPTS_H_V h2
80028: , AR_RCT_METHOD_H_V h6
80029: , AR_RCT_SITE_USES_H_V h7
80030: , AR_REMIT_BANK_ACCT_H_V h9
80031: , AR_SYSTEM_PARAM_H_V h10