DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000007_PKG dependencies on AR_CASH_RECEIPTS_H_V

Line 62770: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'

62766: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
62767: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
62768: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
62769: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
62770: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
62771: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
62772: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
62773: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
62774:

Line 62771: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'

62767: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
62768: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
62769: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
62770: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
62771: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
62772: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
62773: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
62774:
62775: ELSE null

Line 62772: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'

62768: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
62769: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
62770: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
62771: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
62772: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
62773: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
62774:
62775: ELSE null
62776: END object_name

Line 62773: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'

62769: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
62770: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
62771: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
62772: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
62773: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
62774:
62775: ELSE null
62776: END object_name
62777: , CASE r

Line 62836: , AR_CASH_RECEIPTS_H_V h1

62832: ELSE null
62833: END source_value
62834: , null source_meaning
62835: FROM xla_events_gt xet
62836: , AR_CASH_RECEIPTS_H_V h1
62837: , AR_RCT_METHOD_H_V h4
62838: , AR_REMIT_BANK_ACCT_H_V h5
62839: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
62840: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 63132: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

63128: TYPE t_array_source_5 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
63129: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
63130: TYPE t_array_source_56 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
63131: TYPE t_array_source_57 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
63132: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
63133: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
63134: TYPE t_array_source_82 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
63135: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
63136:

Line 63133: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

63129: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
63130: TYPE t_array_source_56 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
63131: TYPE t_array_source_57 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
63132: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
63133: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
63134: TYPE t_array_source_82 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
63135: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
63136:
63137: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 63134: TYPE t_array_source_82 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

63130: TYPE t_array_source_56 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
63131: TYPE t_array_source_57 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
63132: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
63133: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
63134: TYPE t_array_source_82 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
63135: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
63136:
63137: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
63138: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 63135: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

63131: TYPE t_array_source_57 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
63132: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
63133: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
63134: TYPE t_array_source_82 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
63135: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
63136:
63137: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
63138: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
63139: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 63212: , AR_CASH_RECEIPTS_H_V h1

63208: , h1.RCT_DOC_SEQUENCE_ID source_81
63209: , h1.RCT_DOC_SEQUENCE_VALUE source_82
63210: , h1.RCT_TRX_ACCT_REVERSAL source_83
63211: FROM xla_events_gt xet
63212: , AR_CASH_RECEIPTS_H_V h1
63213: , AR_RCT_METHOD_H_V h4
63214: , AR_REMIT_BANK_ACCT_H_V h5
63215: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
63216: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 64304: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'

64300: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
64301: WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'
64302: WHEN 10 THEN 'AR_RCT_METHOD_H_V'
64303: WHEN 11 THEN 'AR_RCT_METHOD_H_V'
64304: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
64305: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
64306: WHEN 14 THEN 'AR_RCT_SITE_USES_H_V'
64307: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
64308: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'

Line 64305: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'

64301: WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'
64302: WHEN 10 THEN 'AR_RCT_METHOD_H_V'
64303: WHEN 11 THEN 'AR_RCT_METHOD_H_V'
64304: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
64305: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
64306: WHEN 14 THEN 'AR_RCT_SITE_USES_H_V'
64307: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
64308: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
64309: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'

Line 64307: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'

64303: WHEN 11 THEN 'AR_RCT_METHOD_H_V'
64304: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
64305: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
64306: WHEN 14 THEN 'AR_RCT_SITE_USES_H_V'
64307: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
64308: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
64309: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
64310: WHEN 18 THEN 'AR_CASH_RECEIPTS_H_V'
64311: WHEN 19 THEN 'AR_CASH_RECEIPTS_H_V'

Line 64308: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'

64304: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
64305: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
64306: WHEN 14 THEN 'AR_RCT_SITE_USES_H_V'
64307: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
64308: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
64309: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
64310: WHEN 18 THEN 'AR_CASH_RECEIPTS_H_V'
64311: WHEN 19 THEN 'AR_CASH_RECEIPTS_H_V'
64312:

Line 64309: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'

64305: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
64306: WHEN 14 THEN 'AR_RCT_SITE_USES_H_V'
64307: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
64308: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
64309: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
64310: WHEN 18 THEN 'AR_CASH_RECEIPTS_H_V'
64311: WHEN 19 THEN 'AR_CASH_RECEIPTS_H_V'
64312:
64313: ELSE null

Line 64310: WHEN 18 THEN 'AR_CASH_RECEIPTS_H_V'

64306: WHEN 14 THEN 'AR_RCT_SITE_USES_H_V'
64307: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
64308: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
64309: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
64310: WHEN 18 THEN 'AR_CASH_RECEIPTS_H_V'
64311: WHEN 19 THEN 'AR_CASH_RECEIPTS_H_V'
64312:
64313: ELSE null
64314: END object_name

Line 64311: WHEN 19 THEN 'AR_CASH_RECEIPTS_H_V'

64307: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
64308: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
64309: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
64310: WHEN 18 THEN 'AR_CASH_RECEIPTS_H_V'
64311: WHEN 19 THEN 'AR_CASH_RECEIPTS_H_V'
64312:
64313: ELSE null
64314: END object_name
64315: , CASE r

Line 64410: , AR_CASH_RECEIPTS_H_V h1

64406: ELSE null
64407: END source_value
64408: , null source_meaning
64409: FROM xla_events_gt xet
64410: , AR_CASH_RECEIPTS_H_V h1
64411: , AR_RCT_METHOD_H_V h5
64412: , AR_RCT_SITE_USES_H_V h6
64413: , AR_REMIT_BANK_ACCT_H_V h8
64414: , AR_SYSTEM_PARAM_H_V h9

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

64808: TYPE t_array_source_12 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
64809: TYPE t_array_source_13 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
64810: TYPE t_array_source_56 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
64811: TYPE t_array_source_57 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
64812: TYPE t_array_source_58 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
64813: TYPE t_array_source_70 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
64814: TYPE t_array_source_71 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
64815: TYPE t_array_source_72 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
64816: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 64813: TYPE t_array_source_70 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;

64809: TYPE t_array_source_13 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
64810: TYPE t_array_source_56 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
64811: TYPE t_array_source_57 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
64812: TYPE t_array_source_58 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
64813: TYPE t_array_source_70 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
64814: TYPE t_array_source_71 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
64815: TYPE t_array_source_72 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
64816: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
64817: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 64815: TYPE t_array_source_72 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;

64811: TYPE t_array_source_57 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
64812: TYPE t_array_source_58 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
64813: TYPE t_array_source_70 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
64814: TYPE t_array_source_71 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
64815: TYPE t_array_source_72 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
64816: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
64817: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
64818: TYPE t_array_source_82 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
64819: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

Line 64816: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

64812: TYPE t_array_source_58 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
64813: TYPE t_array_source_70 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
64814: TYPE t_array_source_71 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
64815: TYPE t_array_source_72 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
64816: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
64817: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
64818: TYPE t_array_source_82 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
64819: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
64820:

Line 64817: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

64813: TYPE t_array_source_70 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
64814: TYPE t_array_source_71 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
64815: TYPE t_array_source_72 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
64816: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
64817: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
64818: TYPE t_array_source_82 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
64819: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
64820:
64821: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 64818: TYPE t_array_source_82 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

64814: TYPE t_array_source_71 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
64815: TYPE t_array_source_72 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
64816: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
64817: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
64818: TYPE t_array_source_82 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
64819: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
64820:
64821: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
64822: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 64819: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

64815: TYPE t_array_source_72 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
64816: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
64817: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
64818: TYPE t_array_source_82 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
64819: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
64820:
64821: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
64822: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
64823: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 64948: , AR_CASH_RECEIPTS_H_V h1

64944: , h1.RCT_DOC_SEQUENCE_ID source_81
64945: , h1.RCT_DOC_SEQUENCE_VALUE source_82
64946: , h1.RCT_TRX_ACCT_REVERSAL source_83
64947: FROM xla_events_gt xet
64948: , AR_CASH_RECEIPTS_H_V h1
64949: , AR_RCT_METHOD_H_V h5
64950: , AR_RCT_SITE_USES_H_V h6
64951: , AR_REMIT_BANK_ACCT_H_V h8
64952: , AR_SYSTEM_PARAM_H_V h9