DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000006_PKG dependencies on AR_CASH_RECEIPTS_H_V

Line 78729: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'

78725: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
78726: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
78727: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
78728: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
78729: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
78730: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
78731: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
78732: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
78733:

Line 78730: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'

78726: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
78727: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
78728: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
78729: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
78730: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
78731: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
78732: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
78733:
78734: ELSE null

Line 78731: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'

78727: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
78728: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
78729: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
78730: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
78731: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
78732: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
78733:
78734: ELSE null
78735: END object_name

Line 78732: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'

78728: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
78729: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
78730: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
78731: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
78732: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
78733:
78734: ELSE null
78735: END object_name
78736: , CASE r

Line 78795: , AR_CASH_RECEIPTS_H_V h1

78791: ELSE null
78792: END source_value
78793: , null source_meaning
78794: FROM xla_events_gt xet
78795: , AR_CASH_RECEIPTS_H_V h1
78796: , AR_RCT_METHOD_H_V h4
78797: , AR_REMIT_BANK_ACCT_H_V h5
78798: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
78799: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 79122: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

79118: TYPE t_array_source_14 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
79119: TYPE t_array_source_15 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
79120: TYPE t_array_source_70 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
79121: TYPE t_array_source_71 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
79122: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79123: TYPE t_array_source_87 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79124: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79125: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
79126:

Line 79123: TYPE t_array_source_87 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

79119: TYPE t_array_source_15 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
79120: TYPE t_array_source_70 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
79121: TYPE t_array_source_71 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
79122: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79123: TYPE t_array_source_87 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79124: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79125: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
79126:
79127: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 79124: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

79120: TYPE t_array_source_70 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
79121: TYPE t_array_source_71 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
79122: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79123: TYPE t_array_source_87 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79124: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79125: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
79126:
79127: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79128: TYPE t_array_source_5 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 79125: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

79121: TYPE t_array_source_71 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
79122: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79123: TYPE t_array_source_87 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79124: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79125: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
79126:
79127: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79128: TYPE t_array_source_5 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79129: TYPE t_array_source_8 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;

Line 79214: , AR_CASH_RECEIPTS_H_V h1

79210: , h1.RCT_DOC_SEQUENCE_ID source_87
79211: , h1.RCT_DOC_SEQUENCE_VALUE source_88
79212: , h1.RCT_TRX_ACCT_REVERSAL source_89
79213: FROM xla_events_gt xet
79214: , AR_CASH_RECEIPTS_H_V h1
79215: , AR_RCT_METHOD_H_V h4
79216: , AR_REMIT_BANK_ACCT_H_V h5
79217: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
79218: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 80577: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'

80573: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
80574: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
80575: WHEN 6 THEN 'AR_SYSTEM_PARAM_H_V'
80576: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'
80577: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
80578: WHEN 9 THEN 'AR_RCT_METHOD_H_V'
80579: WHEN 10 THEN 'AR_RCT_METHOD_H_V'
80580: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
80581: WHEN 12 THEN 'AR_RCT_SITE_USES_H_V'

Line 80580: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'

80576: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'
80577: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
80578: WHEN 9 THEN 'AR_RCT_METHOD_H_V'
80579: WHEN 10 THEN 'AR_RCT_METHOD_H_V'
80580: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
80581: WHEN 12 THEN 'AR_RCT_SITE_USES_H_V'
80582: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
80583: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
80584: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'

Line 80582: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'

80578: WHEN 9 THEN 'AR_RCT_METHOD_H_V'
80579: WHEN 10 THEN 'AR_RCT_METHOD_H_V'
80580: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
80581: WHEN 12 THEN 'AR_RCT_SITE_USES_H_V'
80582: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
80583: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
80584: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
80585: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
80586: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'

Line 80583: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'

80579: WHEN 10 THEN 'AR_RCT_METHOD_H_V'
80580: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
80581: WHEN 12 THEN 'AR_RCT_SITE_USES_H_V'
80582: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
80583: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
80584: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
80585: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
80586: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
80587:

Line 80584: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'

80580: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
80581: WHEN 12 THEN 'AR_RCT_SITE_USES_H_V'
80582: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
80583: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
80584: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
80585: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
80586: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
80587:
80588: ELSE null

Line 80585: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'

80581: WHEN 12 THEN 'AR_RCT_SITE_USES_H_V'
80582: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
80583: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
80584: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
80585: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
80586: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
80587:
80588: ELSE null
80589: END object_name

Line 80586: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'

80582: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
80583: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
80584: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
80585: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
80586: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
80587:
80588: ELSE null
80589: END object_name
80590: , CASE r

Line 80677: , AR_CASH_RECEIPTS_H_V h2

80673: ELSE null
80674: END source_value
80675: , null source_meaning
80676: FROM xla_events_gt xet
80677: , AR_CASH_RECEIPTS_H_V h2
80678: , AR_RCT_METHOD_H_V h6
80679: , AR_RCT_SITE_USES_H_V h7
80680: , AR_REMIT_BANK_ACCT_H_V h9
80681: , AR_SYSTEM_PARAM_H_V h10

Line 81114: TYPE t_array_source_58 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;

81110: TYPE t_array_source_15 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
81111: TYPE t_array_source_17 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
81112: TYPE t_array_source_18 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
81113: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
81114: TYPE t_array_source_58 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
81115: TYPE t_array_source_70 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
81116: TYPE t_array_source_71 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
81117: TYPE t_array_source_76 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
81118: TYPE t_array_source_77 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 81117: TYPE t_array_source_76 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;

81113: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
81114: TYPE t_array_source_58 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
81115: TYPE t_array_source_70 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
81116: TYPE t_array_source_71 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
81117: TYPE t_array_source_76 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
81118: TYPE t_array_source_77 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
81119: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
81120: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
81121: TYPE t_array_source_87 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 81119: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;

81115: TYPE t_array_source_70 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
81116: TYPE t_array_source_71 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
81117: TYPE t_array_source_76 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
81118: TYPE t_array_source_77 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
81119: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
81120: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
81121: TYPE t_array_source_87 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
81122: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
81123: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

Line 81120: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

81116: TYPE t_array_source_71 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
81117: TYPE t_array_source_76 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
81118: TYPE t_array_source_77 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
81119: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
81120: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
81121: TYPE t_array_source_87 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
81122: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
81123: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
81124:

Line 81121: TYPE t_array_source_87 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

81117: TYPE t_array_source_76 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
81118: TYPE t_array_source_77 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
81119: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
81120: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
81121: TYPE t_array_source_87 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
81122: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
81123: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
81124:
81125: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 81122: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

81118: TYPE t_array_source_77 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
81119: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
81120: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
81121: TYPE t_array_source_87 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
81122: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
81123: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
81124:
81125: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
81126: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 81123: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

81119: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
81120: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
81121: TYPE t_array_source_87 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
81122: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
81123: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
81124:
81125: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
81126: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
81127: TYPE t_array_source_6 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 81262: , AR_CASH_RECEIPTS_H_V h2

81258: , h2.RCT_DOC_SEQUENCE_ID source_87
81259: , h2.RCT_DOC_SEQUENCE_VALUE source_88
81260: , h2.RCT_TRX_ACCT_REVERSAL source_89
81261: FROM xla_events_gt xet
81262: , AR_CASH_RECEIPTS_H_V h2
81263: , AR_RCT_METHOD_H_V h6
81264: , AR_RCT_SITE_USES_H_V h7
81265: , AR_REMIT_BANK_ACCT_H_V h9
81266: , AR_SYSTEM_PARAM_H_V h10