[Home] [Help]
159029: FROM (
159030: SELECT xet.event_id event_id
159031: , 0 line_number
159032: , CASE r
159033: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159034: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159035: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159036: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159037: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159030: SELECT xet.event_id event_id
159031: , 0 line_number
159032: , CASE r
159033: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159034: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159035: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159036: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159037: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159038: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159032: , CASE r
159033: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159034: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159035: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159036: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159037: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159038: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159039: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159040: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159033: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159034: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159035: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159036: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159037: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159038: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159039: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159040: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159041: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159034: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159035: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159036: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159037: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159038: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159039: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159040: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159041: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159042: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159036: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159037: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159038: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159039: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159040: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159041: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159042: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159043: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159044: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159041: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159042: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159043: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159044: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159045: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159046: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159047: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159048: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159049: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159042: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159043: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159044: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159045: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159046: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159047: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159048: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159049: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159050: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159043: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159044: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159045: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159046: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159047: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159048: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159049: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159050: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159051: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159044: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159045: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159046: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159047: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159048: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159049: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159050: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159051: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159052: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159045: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159046: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159047: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159048: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159049: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159050: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159051: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159052: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159053: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159046: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159047: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159048: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159049: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159050: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159051: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159052: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159053: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159054: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159047: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159048: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159049: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159050: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159051: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159052: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159053: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159054: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159055:
159048: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159049: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159050: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159051: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159052: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159053: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159054: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159055:
159056: ELSE null
159049: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159050: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159051: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159052: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159053: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159054: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159055:
159056: ELSE null
159057: END object_name
159050: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159051: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159052: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159053: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159054: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159055:
159056: ELSE null
159057: END object_name
159058: , CASE r
159167:
159168: ELSE null
159169: END source_meaning
159170: FROM xla_events_gt xet
159171: , AP_PAYMENT_EXTRACT_HEADER_V h2
159172: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
159173: , fnd_lookup_values fvl10
159174: , fnd_lookup_values fvl43
159175: , fnd_lookup_values fvl116
159567: --
159568: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
159569: --
159570:
159571: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
159572: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
159573: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
159574: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
159575: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
159568: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
159569: --
159570:
159571: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
159572: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
159573: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
159574: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
159575: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
159576: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
159570:
159571: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
159572: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
159573: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
159574: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
159575: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
159576: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
159577: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
159578: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
159571: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
159572: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
159573: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
159574: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
159575: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
159576: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
159577: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
159578: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
159579: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
159572: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
159573: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
159574: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
159575: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
159576: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
159577: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
159578: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
159579: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
159580: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
159574: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
159575: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
159576: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
159577: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
159578: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
159579: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
159580: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
159581: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
159582: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
159579: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
159580: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
159581: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
159582: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
159583: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
159584: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
159585: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
159586: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
159587: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
159580: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
159581: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
159582: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
159583: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
159584: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
159585: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
159586: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
159587: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
159588: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
159581: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
159582: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
159583: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
159584: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
159585: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
159586: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
159587: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
159588: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
159589: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
159582: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
159583: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
159584: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
159585: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
159586: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
159587: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
159588: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
159589: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
159590: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
159583: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
159584: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
159585: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
159586: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
159587: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
159588: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
159589: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
159590: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
159591: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
159584: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
159585: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
159586: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
159587: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
159588: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
159589: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
159590: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
159591: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
159592: TYPE t_array_source_176 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
159585: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
159586: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
159587: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
159588: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
159589: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
159590: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
159591: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
159592: TYPE t_array_source_176 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
159593:
159586: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
159587: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
159588: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
159589: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
159590: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
159591: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
159592: TYPE t_array_source_176 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
159593:
159594: TYPE t_array_source_25 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
159587: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
159588: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
159589: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
159590: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
159591: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
159592: TYPE t_array_source_176 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
159593:
159594: TYPE t_array_source_25 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
159595: TYPE t_array_source_28 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
159588: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
159589: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
159590: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
159591: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
159592: TYPE t_array_source_176 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
159593:
159594: TYPE t_array_source_25 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
159595: TYPE t_array_source_28 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
159596: TYPE t_array_source_48 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
159727: , h2.AC_EXCHANGE_RATE_TYPE source_122
159728: , h2.AC_DOC_CATEGORY_CODE source_175
159729: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_176
159730: FROM xla_events_gt xet
159731: , AP_PAYMENT_EXTRACT_HEADER_V h2
159732: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
159733: , fnd_lookup_values fvl10
159734: , fnd_lookup_values fvl43
159735: , fnd_lookup_values fvl116
164685: FROM (
164686: SELECT xet.event_id event_id
164687: , 0 line_number
164688: , CASE r
164689: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164690: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164691: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164692: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164693: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164686: SELECT xet.event_id event_id
164687: , 0 line_number
164688: , CASE r
164689: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164690: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164691: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164692: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164693: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164694: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164687: , 0 line_number
164688: , CASE r
164689: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164690: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164691: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164692: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164693: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164694: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164695: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164688: , CASE r
164689: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164690: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164691: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164692: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164693: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164694: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164695: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164696: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164689: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164690: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164691: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164692: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164693: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164694: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164695: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164696: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164697: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164690: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164691: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164692: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164693: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164694: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164695: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164696: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164697: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164698: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164692: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164693: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164694: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164695: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164696: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164697: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164698: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164699: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164700: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164695: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164696: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164697: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164698: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164699: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164700: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164701: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164702: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164703: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164698: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164699: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164700: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164701: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164702: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164703: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164704: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164705: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164706: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164701: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164702: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164703: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164704: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164705: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164706: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164707: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164708: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164709: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164702: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164703: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164704: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164705: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164706: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164707: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164708: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164709: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164710: WHEN 22 THEN 'FV_XLA_PAYMENTS_V'
164704: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164705: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164706: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164707: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164708: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164709: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164710: WHEN 22 THEN 'FV_XLA_PAYMENTS_V'
164711: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164712: WHEN 24 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164709: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164710: WHEN 22 THEN 'FV_XLA_PAYMENTS_V'
164711: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164712: WHEN 24 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164713: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164714: WHEN 26 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164715: WHEN 27 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164716: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164717: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164712: WHEN 24 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164713: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164714: WHEN 26 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164715: WHEN 27 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164716: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164717: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164718: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164719: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164720: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164713: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164714: WHEN 26 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164715: WHEN 27 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164716: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164717: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164718: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164719: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164720: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164721: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164714: WHEN 26 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164715: WHEN 27 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164716: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164717: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164718: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164719: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164720: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164721: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164722: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164715: WHEN 27 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164716: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164717: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164718: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164719: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164720: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164721: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164722: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164723: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164716: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164717: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164718: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164719: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164720: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164721: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164722: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164723: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164724: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164717: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164718: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164719: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164720: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164721: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164722: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164723: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164724: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164725: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164718: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164719: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164720: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164721: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164722: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164723: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164724: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164725: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164726: WHEN 38 THEN 'FV_XLA_PAYMENTS_V'
164719: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164720: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164721: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164722: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164723: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164724: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164725: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164726: WHEN 38 THEN 'FV_XLA_PAYMENTS_V'
164727: WHEN 39 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164720: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164721: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164722: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164723: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164724: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164725: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164726: WHEN 38 THEN 'FV_XLA_PAYMENTS_V'
164727: WHEN 39 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164728: WHEN 40 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164721: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164722: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164723: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164724: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164725: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164726: WHEN 38 THEN 'FV_XLA_PAYMENTS_V'
164727: WHEN 39 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164728: WHEN 40 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164729: WHEN 41 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164723: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164724: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164725: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164726: WHEN 38 THEN 'FV_XLA_PAYMENTS_V'
164727: WHEN 39 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164728: WHEN 40 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164729: WHEN 41 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164730:
164731: ELSE null
164724: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164725: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164726: WHEN 38 THEN 'FV_XLA_PAYMENTS_V'
164727: WHEN 39 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164728: WHEN 40 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164729: WHEN 41 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164730:
164731: ELSE null
164732: END object_name
164725: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164726: WHEN 38 THEN 'FV_XLA_PAYMENTS_V'
164727: WHEN 39 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164728: WHEN 40 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164729: WHEN 41 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164730:
164731: ELSE null
164732: END object_name
164733: , CASE r
164922:
164923: ELSE null
164924: END source_meaning
164925: FROM xla_events_gt xet
164926: , AP_PAYMENT_EXTRACT_HEADER_V h2
164927: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
164928: , FV_XLA_PAYMENTS_V h5
164929: , fnd_lookup_values fvl10
164930: , fnd_lookup_values fvl14
165449: --
165450: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
165451: --
165452:
165453: TYPE t_array_source_3 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
165454: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
165455: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
165456: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
165457: TYPE t_array_source_7 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
165450: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
165451: --
165452:
165453: TYPE t_array_source_3 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
165454: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
165455: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
165456: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
165457: TYPE t_array_source_7 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
165458: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165451: --
165452:
165453: TYPE t_array_source_3 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
165454: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
165455: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
165456: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
165457: TYPE t_array_source_7 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
165458: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165459: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
165452:
165453: TYPE t_array_source_3 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
165454: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
165455: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
165456: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
165457: TYPE t_array_source_7 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
165458: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165459: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
165460: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
165453: TYPE t_array_source_3 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
165454: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
165455: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
165456: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
165457: TYPE t_array_source_7 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
165458: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165459: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
165460: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
165461: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165454: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
165455: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
165456: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
165457: TYPE t_array_source_7 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
165458: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165459: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
165460: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
165461: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165462: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
165456: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
165457: TYPE t_array_source_7 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
165458: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165459: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
165460: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
165461: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165462: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
165463: TYPE t_array_source_19 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
165464: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
165459: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
165460: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
165461: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165462: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
165463: TYPE t_array_source_19 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
165464: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
165465: TYPE t_array_source_21 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
165466: TYPE t_array_source_22 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
165467: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
165462: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
165463: TYPE t_array_source_19 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
165464: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
165465: TYPE t_array_source_21 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
165466: TYPE t_array_source_22 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
165467: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
165468: TYPE t_array_source_24 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
165469: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
165470: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165465: TYPE t_array_source_21 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
165466: TYPE t_array_source_22 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
165467: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
165468: TYPE t_array_source_24 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
165469: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
165470: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165471: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165472: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165473: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165466: TYPE t_array_source_22 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
165467: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
165468: TYPE t_array_source_24 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
165469: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
165470: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165471: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165472: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165473: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165474: TYPE t_array_source_37 IS TABLE OF FV_XLA_PAYMENTS_V.FEDERAL_DIT_CONFIRM_ACCT%TYPE INDEX BY BINARY_INTEGER;
165468: TYPE t_array_source_24 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
165469: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
165470: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165471: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165472: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165473: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165474: TYPE t_array_source_37 IS TABLE OF FV_XLA_PAYMENTS_V.FEDERAL_DIT_CONFIRM_ACCT%TYPE INDEX BY BINARY_INTEGER;
165475: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165476: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
165473: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165474: TYPE t_array_source_37 IS TABLE OF FV_XLA_PAYMENTS_V.FEDERAL_DIT_CONFIRM_ACCT%TYPE INDEX BY BINARY_INTEGER;
165475: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165476: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
165477: TYPE t_array_source_44 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
165478: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
165479: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
165480: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
165481: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
165476: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
165477: TYPE t_array_source_44 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
165478: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
165479: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
165480: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
165481: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
165482: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
165483: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165484: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
165477: TYPE t_array_source_44 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
165478: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
165479: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
165480: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
165481: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
165482: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
165483: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165484: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
165485: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
165478: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
165479: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
165480: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
165481: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
165482: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
165483: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165484: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
165485: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
165486: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
165479: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
165480: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
165481: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
165482: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
165483: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165484: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
165485: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
165486: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
165487: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
165480: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
165481: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
165482: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
165483: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165484: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
165485: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
165486: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
165487: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
165488: TYPE t_array_source_125 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
165481: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
165482: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
165483: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165484: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
165485: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
165486: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
165487: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
165488: TYPE t_array_source_125 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
165489: TYPE t_array_source_126 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
165482: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
165483: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165484: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
165485: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
165486: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
165487: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
165488: TYPE t_array_source_125 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
165489: TYPE t_array_source_126 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
165490: TYPE t_array_source_170 IS TABLE OF FV_XLA_PAYMENTS_V.FEDERAL_DIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165483: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165484: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
165485: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
165486: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
165487: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
165488: TYPE t_array_source_125 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
165489: TYPE t_array_source_126 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
165490: TYPE t_array_source_170 IS TABLE OF FV_XLA_PAYMENTS_V.FEDERAL_DIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165491: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
165484: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
165485: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
165486: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
165487: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
165488: TYPE t_array_source_125 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
165489: TYPE t_array_source_126 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
165490: TYPE t_array_source_170 IS TABLE OF FV_XLA_PAYMENTS_V.FEDERAL_DIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165491: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
165492: TYPE t_array_source_176 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
165485: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
165486: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
165487: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
165488: TYPE t_array_source_125 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
165489: TYPE t_array_source_126 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
165490: TYPE t_array_source_170 IS TABLE OF FV_XLA_PAYMENTS_V.FEDERAL_DIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165491: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
165492: TYPE t_array_source_176 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
165493: TYPE t_array_source_177 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
165487: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
165488: TYPE t_array_source_125 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
165489: TYPE t_array_source_126 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
165490: TYPE t_array_source_170 IS TABLE OF FV_XLA_PAYMENTS_V.FEDERAL_DIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165491: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
165492: TYPE t_array_source_176 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
165493: TYPE t_array_source_177 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
165494:
165495: TYPE t_array_source_25 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
165488: TYPE t_array_source_125 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
165489: TYPE t_array_source_126 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
165490: TYPE t_array_source_170 IS TABLE OF FV_XLA_PAYMENTS_V.FEDERAL_DIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165491: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
165492: TYPE t_array_source_176 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
165493: TYPE t_array_source_177 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
165494:
165495: TYPE t_array_source_25 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
165496: TYPE t_array_source_28 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
165489: TYPE t_array_source_126 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
165490: TYPE t_array_source_170 IS TABLE OF FV_XLA_PAYMENTS_V.FEDERAL_DIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165491: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
165492: TYPE t_array_source_176 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
165493: TYPE t_array_source_177 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
165494:
165495: TYPE t_array_source_25 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
165496: TYPE t_array_source_28 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
165497: TYPE t_array_source_29 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
165711: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_176
165712: , h2.TRANSAC_REVERSAL_FLAG source_177
165713: , fvl177.meaning source_177_meaning
165714: FROM xla_events_gt xet
165715: , AP_PAYMENT_EXTRACT_HEADER_V h2
165716: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
165717: , FV_XLA_PAYMENTS_V h5
165718: , fnd_lookup_values fvl10
165719: , fnd_lookup_values fvl14
174073: FROM (
174074: SELECT xet.event_id event_id
174075: , 0 line_number
174076: , CASE r
174077: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174078: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174079: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174080: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174081: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174074: SELECT xet.event_id event_id
174075: , 0 line_number
174076: , CASE r
174077: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174078: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174079: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174080: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174081: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174082: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174075: , 0 line_number
174076: , CASE r
174077: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174078: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174079: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174080: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174081: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174082: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174083: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174077: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174078: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174079: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174080: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174081: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174082: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174083: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174084: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174085: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174078: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174079: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174080: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174081: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174082: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174083: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174084: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174085: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174086: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174083: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174084: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174085: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174086: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174087: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174088: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174089: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174090: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174091: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174085: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174086: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174087: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174088: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174089: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174090: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174091: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174092: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174093: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174091: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174092: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174093: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174094: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174095: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174096: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174097: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174098: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174099: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174092: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174093: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174094: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174095: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174096: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174097: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174098: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174099: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174100: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174093: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174094: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174095: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174096: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174097: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174098: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174099: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174100: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174101: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174094: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174095: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174096: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174097: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174098: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174099: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174100: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174101: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174102: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174095: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174096: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174097: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174098: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174099: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174100: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174101: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174102: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174103: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174096: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174097: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174098: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174099: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174100: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174101: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174102: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174103: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174104: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174097: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174098: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174099: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174100: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174101: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174102: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174103: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174104: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174105: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174098: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174099: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174100: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174101: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174102: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174103: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174104: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174105: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174106: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174099: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174100: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174101: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174102: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174103: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174104: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174105: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174106: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174107: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174100: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174101: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174102: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174103: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174104: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174105: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174106: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174107: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174108: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174101: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174102: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174103: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174104: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174105: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174106: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174107: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174108: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174109: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174102: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174103: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174104: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174105: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174106: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174107: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174108: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174109: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174110:
174103: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174104: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174105: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174106: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174107: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174108: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174109: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174110:
174111: ELSE null
174104: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174105: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174106: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174107: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174108: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174109: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174110:
174111: ELSE null
174112: END object_name
174105: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174106: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174107: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174108: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174109: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174110:
174111: ELSE null
174112: END object_name
174113: , CASE r
174268:
174269: ELSE null
174270: END source_meaning
174271: FROM xla_events_gt xet
174272: , AP_PAYMENT_EXTRACT_HEADER_V h2
174273: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
174274: , fnd_lookup_values fvl10
174275: , fnd_lookup_values fvl14
174276: , fnd_lookup_values fvl43
174775: --
174776: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
174777: --
174778:
174779: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
174780: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
174781: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
174782: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
174783: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
174776: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
174777: --
174778:
174779: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
174780: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
174781: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
174782: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
174783: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
174784: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
174777: --
174778:
174779: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
174780: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
174781: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
174782: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
174783: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
174784: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
174785: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
174779: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
174780: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
174781: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
174782: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
174783: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
174784: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
174785: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
174786: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
174787: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
174780: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
174781: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
174782: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
174783: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
174784: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
174785: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
174786: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
174787: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
174788: TYPE t_array_source_24 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
174785: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
174786: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
174787: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
174788: TYPE t_array_source_24 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
174789: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
174790: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
174791: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
174792: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
174793: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
174787: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
174788: TYPE t_array_source_24 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
174789: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
174790: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
174791: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
174792: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
174793: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
174794: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
174795: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
174793: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
174794: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
174795: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
174796: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
174797: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
174798: TYPE t_array_source_108 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
174799: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
174800: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
174801: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
174794: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
174795: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
174796: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
174797: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
174798: TYPE t_array_source_108 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
174799: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
174800: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
174801: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
174802: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
174795: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
174796: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
174797: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
174798: TYPE t_array_source_108 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
174799: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
174800: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
174801: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
174802: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
174803: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
174796: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
174797: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
174798: TYPE t_array_source_108 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
174799: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
174800: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
174801: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
174802: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
174803: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
174804: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
174797: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
174798: TYPE t_array_source_108 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
174799: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
174800: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
174801: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
174802: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
174803: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
174804: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
174805: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
174798: TYPE t_array_source_108 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
174799: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
174800: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
174801: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
174802: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
174803: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
174804: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
174805: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
174806: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
174799: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
174800: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
174801: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
174802: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
174803: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
174804: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
174805: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
174806: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
174807: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
174800: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
174801: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
174802: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
174803: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
174804: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
174805: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
174806: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
174807: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
174808: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
174801: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
174802: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
174803: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
174804: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
174805: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
174806: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
174807: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
174808: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
174809: TYPE t_array_source_125 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
174802: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
174803: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
174804: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
174805: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
174806: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
174807: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
174808: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
174809: TYPE t_array_source_125 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
174810: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
174803: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
174804: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
174805: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
174806: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
174807: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
174808: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
174809: TYPE t_array_source_125 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
174810: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
174811: TYPE t_array_source_176 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
174804: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
174805: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
174806: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
174807: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
174808: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
174809: TYPE t_array_source_125 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
174810: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
174811: TYPE t_array_source_176 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
174812:
174805: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
174806: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
174807: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
174808: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
174809: TYPE t_array_source_125 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
174810: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
174811: TYPE t_array_source_176 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
174812:
174813: TYPE t_array_source_25 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
174806: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
174807: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
174808: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
174809: TYPE t_array_source_125 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
174810: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
174811: TYPE t_array_source_176 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
174812:
174813: TYPE t_array_source_25 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
174814: TYPE t_array_source_28 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
174807: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
174808: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
174809: TYPE t_array_source_125 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
174810: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
174811: TYPE t_array_source_176 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
174812:
174813: TYPE t_array_source_25 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
174814: TYPE t_array_source_28 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
174815: TYPE t_array_source_39 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AWT_RELATED_DIST_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
175008: , fvl125.meaning source_125_meaning
175009: , h2.AC_DOC_CATEGORY_CODE source_175
175010: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_176
175011: FROM xla_events_gt xet
175012: , AP_PAYMENT_EXTRACT_HEADER_V h2
175013: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
175014: , fnd_lookup_values fvl10
175015: , fnd_lookup_values fvl14
175016: , fnd_lookup_values fvl43
177163: FROM (
177164: SELECT xet.event_id event_id
177165: , 0 line_number
177166: , CASE r
177167: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177168: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177169: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177170: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177171: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177164: SELECT xet.event_id event_id
177165: , 0 line_number
177166: , CASE r
177167: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177168: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177169: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177170: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177171: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177172: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177166: , CASE r
177167: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177168: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177169: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177170: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177171: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177172: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177173: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177174: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177169: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177170: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177171: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177172: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177173: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177174: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177175: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177176: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177177: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177170: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177171: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177172: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177173: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177174: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177175: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177176: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177177: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177178: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177172: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177173: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177174: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177175: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177176: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177177: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177178: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177179: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177180: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177178: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177179: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177180: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177181: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177182: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177183: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177184: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177185: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177186: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177179: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177180: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177181: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177182: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177183: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177184: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177185: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177186: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177187: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177180: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177181: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177182: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177183: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177184: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177185: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177186: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177187: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177188: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177181: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177182: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177183: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177184: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177185: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177186: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177187: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177188: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177189: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177182: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177183: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177184: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177185: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177186: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177187: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177188: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177189: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177190: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177183: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177184: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177185: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177186: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177187: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177188: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177189: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177190: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177191: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177184: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177185: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177186: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177187: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177188: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177189: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177190: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177191: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177192: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177185: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177186: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177187: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177188: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177189: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177190: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177191: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177192: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177193: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177186: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177187: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177188: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177189: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177190: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177191: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177192: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177193: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177194:
177187: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177188: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177189: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177190: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177191: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177192: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177193: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177194:
177195: ELSE null
177188: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177189: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177190: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177191: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177192: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177193: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177194:
177195: ELSE null
177196: END object_name
177189: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177190: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177191: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177192: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177193: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177194:
177195: ELSE null
177196: END object_name
177197: , CASE r
177329:
177330: ELSE null
177331: END source_meaning
177332: FROM xla_events_gt xet
177333: , AP_PAYMENT_EXTRACT_HEADER_V h2
177334: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
177335: , fnd_lookup_values fvl10
177336: , fnd_lookup_values fvl14
177337: , fnd_lookup_values fvl43
177749: --
177750: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
177751: --
177752:
177753: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
177754: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
177755: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
177756: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
177757: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
177750: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
177751: --
177752:
177753: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
177754: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
177755: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
177756: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
177757: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
177758: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
177752:
177753: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
177754: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
177755: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
177756: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
177757: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
177758: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
177759: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
177760: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
177755: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
177756: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
177757: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
177758: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
177759: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
177760: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
177761: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
177762: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
177763: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
177756: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
177757: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
177758: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
177759: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
177760: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
177761: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
177762: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
177763: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
177764: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
177758: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
177759: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
177760: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
177761: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
177762: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
177763: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
177764: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
177765: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
177766: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
177764: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
177765: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
177766: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
177767: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
177768: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
177769: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
177770: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
177771: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
177772: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
177765: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
177766: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
177767: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
177768: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
177769: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
177770: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
177771: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
177772: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
177773: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
177766: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
177767: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
177768: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
177769: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
177770: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
177771: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
177772: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
177773: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
177774: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
177767: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
177768: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
177769: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
177770: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
177771: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
177772: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
177773: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
177774: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
177775: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
177768: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
177769: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
177770: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
177771: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
177772: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
177773: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
177774: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
177775: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
177776: TYPE t_array_source_125 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
177769: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
177770: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
177771: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
177772: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
177773: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
177774: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
177775: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
177776: TYPE t_array_source_125 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
177777: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
177770: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
177771: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
177772: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
177773: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
177774: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
177775: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
177776: TYPE t_array_source_125 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
177777: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
177778: TYPE t_array_source_176 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
177771: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
177772: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
177773: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
177774: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
177775: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
177776: TYPE t_array_source_125 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
177777: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
177778: TYPE t_array_source_176 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
177779: TYPE t_array_source_177 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
177772: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
177773: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
177774: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
177775: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
177776: TYPE t_array_source_125 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
177777: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
177778: TYPE t_array_source_176 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
177779: TYPE t_array_source_177 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
177780:
177773: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
177774: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
177775: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
177776: TYPE t_array_source_125 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
177777: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
177778: TYPE t_array_source_176 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
177779: TYPE t_array_source_177 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
177780:
177781: TYPE t_array_source_25 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
177774: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
177775: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
177776: TYPE t_array_source_125 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
177777: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
177778: TYPE t_array_source_176 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
177779: TYPE t_array_source_177 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
177780:
177781: TYPE t_array_source_25 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
177782: TYPE t_array_source_28 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
177775: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
177776: TYPE t_array_source_125 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
177777: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
177778: TYPE t_array_source_176 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
177779: TYPE t_array_source_177 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
177780:
177781: TYPE t_array_source_25 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
177782: TYPE t_array_source_28 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
177783: TYPE t_array_source_41 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.POD_CCID%TYPE INDEX BY BINARY_INTEGER;
177933: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_176
177934: , h2.TRANSAC_REVERSAL_FLAG source_177
177935: , fvl177.meaning source_177_meaning
177936: FROM xla_events_gt xet
177937: , AP_PAYMENT_EXTRACT_HEADER_V h2
177938: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
177939: , fnd_lookup_values fvl10
177940: , fnd_lookup_values fvl14
177941: , fnd_lookup_values fvl43