DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000008_PKG dependencies on AR_CASH_RECEIPTS_H_V

Line 62499: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'

62495: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
62496: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
62497: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
62498: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
62499: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
62500: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
62501: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
62502: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
62503:

Line 62500: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'

62496: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
62497: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
62498: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
62499: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
62500: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
62501: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
62502: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
62503:
62504: ELSE null

Line 62501: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'

62497: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
62498: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
62499: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
62500: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
62501: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
62502: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
62503:
62504: ELSE null
62505: END object_name

Line 62502: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'

62498: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
62499: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
62500: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
62501: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
62502: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
62503:
62504: ELSE null
62505: END object_name
62506: , CASE r

Line 62565: , AR_CASH_RECEIPTS_H_V h1

62561: ELSE null
62562: END source_value
62563: , null source_meaning
62564: FROM xla_events_gt xet
62565: , AR_CASH_RECEIPTS_H_V h1
62566: , AR_RCT_METHOD_H_V h4
62567: , AR_REMIT_BANK_ACCT_H_V h5
62568: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
62569: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 62861: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

62857: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
62858: TYPE t_array_source_8 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
62859: TYPE t_array_source_54 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
62860: TYPE t_array_source_55 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
62861: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
62862: TYPE t_array_source_79 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
62863: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
62864: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
62865:

Line 62862: TYPE t_array_source_79 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

62858: TYPE t_array_source_8 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
62859: TYPE t_array_source_54 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
62860: TYPE t_array_source_55 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
62861: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
62862: TYPE t_array_source_79 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
62863: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
62864: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
62865:
62866: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 62863: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

62859: TYPE t_array_source_54 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
62860: TYPE t_array_source_55 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
62861: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
62862: TYPE t_array_source_79 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
62863: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
62864: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
62865:
62866: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
62867: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 62864: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

62860: TYPE t_array_source_55 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
62861: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
62862: TYPE t_array_source_79 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
62863: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
62864: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
62865:
62866: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
62867: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
62868: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 62941: , AR_CASH_RECEIPTS_H_V h1

62937: , h1.RCT_DOC_SEQUENCE_ID source_79
62938: , h1.RCT_DOC_SEQUENCE_VALUE source_80
62939: , h1.RCT_TRX_ACCT_REVERSAL source_81
62940: FROM xla_events_gt xet
62941: , AR_CASH_RECEIPTS_H_V h1
62942: , AR_RCT_METHOD_H_V h4
62943: , AR_REMIT_BANK_ACCT_H_V h5
62944: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
62945: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 64031: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'

64027: WHEN 6 THEN 'AR_SYSTEM_PARAM_H_V'
64028: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'
64029: WHEN 8 THEN 'AR_RCT_METHOD_H_V'
64030: WHEN 9 THEN 'AR_RCT_METHOD_H_V'
64031: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
64032: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
64033: WHEN 12 THEN 'AR_RCT_SITE_USES_H_V'
64034: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
64035: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'

Line 64032: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'

64028: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'
64029: WHEN 8 THEN 'AR_RCT_METHOD_H_V'
64030: WHEN 9 THEN 'AR_RCT_METHOD_H_V'
64031: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
64032: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
64033: WHEN 12 THEN 'AR_RCT_SITE_USES_H_V'
64034: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
64035: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
64036: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'

Line 64034: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'

64030: WHEN 9 THEN 'AR_RCT_METHOD_H_V'
64031: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
64032: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
64033: WHEN 12 THEN 'AR_RCT_SITE_USES_H_V'
64034: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
64035: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
64036: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
64037: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
64038: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'

Line 64035: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'

64031: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
64032: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
64033: WHEN 12 THEN 'AR_RCT_SITE_USES_H_V'
64034: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
64035: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
64036: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
64037: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
64038: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
64039:

Line 64036: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'

64032: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
64033: WHEN 12 THEN 'AR_RCT_SITE_USES_H_V'
64034: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
64035: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
64036: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
64037: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
64038: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
64039:
64040: ELSE null

Line 64037: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'

64033: WHEN 12 THEN 'AR_RCT_SITE_USES_H_V'
64034: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
64035: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
64036: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
64037: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
64038: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
64039:
64040: ELSE null
64041: END object_name

Line 64038: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'

64034: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
64035: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
64036: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
64037: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
64038: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
64039:
64040: ELSE null
64041: END object_name
64042: , CASE r

Line 64129: , AR_CASH_RECEIPTS_H_V h1

64125: ELSE null
64126: END source_value
64127: , null source_meaning
64128: FROM xla_events_gt xet
64129: , AR_CASH_RECEIPTS_H_V h1
64130: , AR_RCT_METHOD_H_V h5
64131: , AR_RCT_SITE_USES_H_V h6
64132: , AR_REMIT_BANK_ACCT_H_V h8
64133: , AR_SYSTEM_PARAM_H_V h9

Line 64529: TYPE t_array_source_56 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;

64525: TYPE t_array_source_11 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
64526: TYPE t_array_source_12 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
64527: TYPE t_array_source_54 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
64528: TYPE t_array_source_55 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
64529: TYPE t_array_source_56 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
64530: TYPE t_array_source_68 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
64531: TYPE t_array_source_69 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
64532: TYPE t_array_source_70 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
64533: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 64530: TYPE t_array_source_68 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;

64526: TYPE t_array_source_12 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
64527: TYPE t_array_source_54 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
64528: TYPE t_array_source_55 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
64529: TYPE t_array_source_56 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
64530: TYPE t_array_source_68 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
64531: TYPE t_array_source_69 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
64532: TYPE t_array_source_70 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
64533: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
64534: TYPE t_array_source_79 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 64532: TYPE t_array_source_70 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;

64528: TYPE t_array_source_55 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
64529: TYPE t_array_source_56 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
64530: TYPE t_array_source_68 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
64531: TYPE t_array_source_69 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
64532: TYPE t_array_source_70 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
64533: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
64534: TYPE t_array_source_79 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
64535: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
64536: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

Line 64533: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

64529: TYPE t_array_source_56 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
64530: TYPE t_array_source_68 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
64531: TYPE t_array_source_69 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
64532: TYPE t_array_source_70 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
64533: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
64534: TYPE t_array_source_79 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
64535: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
64536: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
64537:

Line 64534: TYPE t_array_source_79 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

64530: TYPE t_array_source_68 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
64531: TYPE t_array_source_69 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
64532: TYPE t_array_source_70 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
64533: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
64534: TYPE t_array_source_79 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
64535: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
64536: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
64537:
64538: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 64535: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

64531: TYPE t_array_source_69 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
64532: TYPE t_array_source_70 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
64533: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
64534: TYPE t_array_source_79 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
64535: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
64536: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
64537:
64538: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
64539: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 64536: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

64532: TYPE t_array_source_70 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
64533: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
64534: TYPE t_array_source_79 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
64535: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
64536: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
64537:
64538: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
64539: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
64540: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 64661: , AR_CASH_RECEIPTS_H_V h1

64657: , h1.RCT_DOC_SEQUENCE_ID source_79
64658: , h1.RCT_DOC_SEQUENCE_VALUE source_80
64659: , h1.RCT_TRX_ACCT_REVERSAL source_81
64660: FROM xla_events_gt xet
64661: , AR_CASH_RECEIPTS_H_V h1
64662: , AR_RCT_METHOD_H_V h5
64663: , AR_RCT_SITE_USES_H_V h6
64664: , AR_REMIT_BANK_ACCT_H_V h8
64665: , AR_SYSTEM_PARAM_H_V h9