eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_00200_AAD_S_000011_PKG dependencies on AP_SYSTEM_PARAMETERS_EXTRACT_V

Line 96642: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

96638: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96639: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96640: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96641: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96642: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96643: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96644: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96645: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96646: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 96644: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

96640: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96641: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96642: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96643: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96644: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96645: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96646: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96647: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96648: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 96646: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

96642: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96643: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96644: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96645: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96646: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96647: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96648: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96649: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96650: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 96648: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

96644: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96645: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96646: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96647: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96648: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96649: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96650: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96651: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96652: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 96649: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

96645: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96646: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96647: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96648: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96649: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96650: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96651: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96652: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96653: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 96650: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

96646: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96647: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96648: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96649: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96650: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96651: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96652: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96653: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96654: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 96794: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

96790: ELSE null
96791: END source_meaning
96792: FROM xla_events_gt xet
96793: , AP_PAYMENT_EXTRACT_HEADER_V h2
96794: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
96795: , fnd_lookup_values fvl16
96796: , fnd_lookup_values fvl42
96797: , fnd_lookup_values fvl117
96798: ,(select rownum r from all_objects where rownum <= 26 and owner = p_apps_owner)

Line 97147: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

97143: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
97144: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
97145: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
97146: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
97147: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
97148: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
97149: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
97150: TYPE t_array_source_44 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
97151: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 97149: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

97145: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
97146: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
97147: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
97148: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
97149: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
97150: TYPE t_array_source_44 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
97151: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
97152: TYPE t_array_source_46 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
97153: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 97151: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

97147: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
97148: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
97149: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
97150: TYPE t_array_source_44 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
97151: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
97152: TYPE t_array_source_46 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
97153: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
97154: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
97155: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;

Line 97153: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

97149: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
97150: TYPE t_array_source_44 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
97151: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
97152: TYPE t_array_source_46 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
97153: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
97154: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
97155: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
97156: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
97157: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 97154: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;

97150: TYPE t_array_source_44 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
97151: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
97152: TYPE t_array_source_46 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
97153: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
97154: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
97155: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
97156: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
97157: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
97158: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 97155: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;

97151: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
97152: TYPE t_array_source_46 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
97153: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
97154: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
97155: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
97156: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
97157: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
97158: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
97159: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 97295: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

97291: , h2.AC_DOC_CATEGORY_CODE source_156
97292: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_157
97293: FROM xla_events_gt xet
97294: , AP_PAYMENT_EXTRACT_HEADER_V h2
97295: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
97296: , fnd_lookup_values fvl16
97297: , fnd_lookup_values fvl42
97298: , fnd_lookup_values fvl117
97299: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 98685: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

98681: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98682: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98683: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98684: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98685: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98686: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98687: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98688: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98689: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 98686: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

98682: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98683: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98684: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98685: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98686: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98687: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98688: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98689: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98690: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 98687: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

98683: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98684: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98685: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98686: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98687: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98688: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98689: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98690: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98691: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 98688: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

98684: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98685: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98686: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98687: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98688: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98689: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98690: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98691: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98692: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 98689: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

98685: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98686: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98687: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98688: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98689: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98690: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98691: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98692: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98693: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 98691: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

98687: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98688: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98689: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98690: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98691: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98692: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98693: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98694: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98695: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 98692: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

98688: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98689: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98690: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98691: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98692: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98693: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98694: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98695: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98696: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 98694: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

98690: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98691: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98692: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98693: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98694: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98695: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98696: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98697: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98698: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 98695: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

98691: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98692: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98693: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98694: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98695: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98696: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98697: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98698: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98699: WHEN 22 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 98696: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

98692: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98693: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98694: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98695: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98696: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98697: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98698: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98699: WHEN 22 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98700: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 98698: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

98694: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98695: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98696: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98697: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98698: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98699: WHEN 22 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98700: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98701: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98702: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 98699: WHEN 22 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

98695: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98696: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98697: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98698: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98699: WHEN 22 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98700: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98701: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98702: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98703: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 98700: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

98696: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98697: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98698: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98699: WHEN 22 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98700: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98701: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98702: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98703: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98704: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 98702: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

98698: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98699: WHEN 22 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98700: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98701: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98702: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98703: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98704: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98705: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98706: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 98902: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4

98898: ELSE null
98899: END source_meaning
98900: FROM xla_events_gt xet
98901: , AP_PAYMENT_EXTRACT_HEADER_V h2
98902: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
98903: , fnd_lookup_values fvl15
98904: , fnd_lookup_values fvl16
98905: , fnd_lookup_values fvl24
98906: , fnd_lookup_values fvl30

Line 99387: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

99383: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
99384: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
99385: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
99386: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
99387: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
99388: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
99389: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
99390: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
99391: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 99388: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;

99384: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
99385: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
99386: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
99387: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
99388: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
99389: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
99390: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
99391: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
99392: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 99389: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

99385: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
99386: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
99387: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
99388: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
99389: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
99390: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
99391: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
99392: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
99393: TYPE t_array_source_24 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;

Line 99390: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

99386: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
99387: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
99388: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
99389: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
99390: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
99391: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
99392: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
99393: TYPE t_array_source_24 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
99394: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 99391: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

99387: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
99388: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
99389: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
99390: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
99391: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
99392: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
99393: TYPE t_array_source_24 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
99394: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
99395: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 99393: TYPE t_array_source_24 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;

99389: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
99390: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
99391: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
99392: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
99393: TYPE t_array_source_24 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
99394: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
99395: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
99396: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
99397: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;

Line 99394: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;

99390: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
99391: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
99392: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
99393: TYPE t_array_source_24 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
99394: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
99395: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
99396: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
99397: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
99398: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 99396: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;

99392: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
99393: TYPE t_array_source_24 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
99394: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
99395: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
99396: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
99397: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
99398: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
99399: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
99400: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 99397: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;

99393: TYPE t_array_source_24 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
99394: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
99395: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
99396: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
99397: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
99398: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
99399: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
99400: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
99401: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 99398: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;

99394: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
99395: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
99396: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
99397: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
99398: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
99399: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
99400: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
99401: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
99402: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 99400: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

99396: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
99397: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
99398: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
99399: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
99400: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
99401: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
99402: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
99403: TYPE t_array_source_43 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
99404: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;

Line 99401: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

99397: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
99398: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
99399: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
99400: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
99401: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
99402: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
99403: TYPE t_array_source_43 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
99404: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
99405: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 99402: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

99398: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
99399: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
99400: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
99401: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
99402: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
99403: TYPE t_array_source_43 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
99404: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
99405: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
99406: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 99404: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;

99400: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
99401: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
99402: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
99403: TYPE t_array_source_43 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
99404: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
99405: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
99406: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
99407: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
99408: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 99617: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4

99613: , h2.TRANSAC_REVERSAL_FLAG source_159
99614: , fvl159.meaning source_159_meaning
99615: FROM xla_events_gt xet
99616: , AP_PAYMENT_EXTRACT_HEADER_V h2
99617: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
99618: , fnd_lookup_values fvl15
99619: , fnd_lookup_values fvl16
99620: , fnd_lookup_values fvl24
99621: , fnd_lookup_values fvl30

Line 102119: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

102115: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102116: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102117: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102118: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102119: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102120: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102121: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102122: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102123: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 102120: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

102116: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102117: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102118: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102119: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102120: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102121: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102122: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102123: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102124: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 102121: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

102117: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102118: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102119: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102120: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102121: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102122: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102123: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102124: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102125: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 102122: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

102118: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102119: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102120: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102121: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102122: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102123: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102124: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102125: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102126: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 102123: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

102119: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102120: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102121: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102122: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102123: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102124: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102125: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102126: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102127: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 102124: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

102120: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102121: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102122: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102123: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102124: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102125: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102126: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102127: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102128: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 102125: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

102121: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102122: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102123: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102124: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102125: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102126: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102127: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102128: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102129: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 102251: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4

102247: ELSE null
102248: END source_meaning
102249: FROM xla_events_gt xet
102250: , AP_INVOICE_EXTRACT_HEADER_V h1
102251: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
102252: , fnd_lookup_values fvl16
102253: , fnd_lookup_values fvl42
102254: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
102255: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 102839: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

102835: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
102836: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
102837: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
102838: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
102839: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
102840: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
102841: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
102842: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
102843: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 102840: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

102836: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
102837: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
102838: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
102839: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
102840: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
102841: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
102842: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
102843: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
102844: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 102841: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

102837: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
102838: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
102839: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
102840: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
102841: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
102842: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
102843: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
102844: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
102845: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;

Line 102842: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

102838: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
102839: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
102840: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
102841: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
102842: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
102843: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
102844: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
102845: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
102846: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 102843: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

102839: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
102840: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
102841: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
102842: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
102843: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
102844: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
102845: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
102846: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
102847: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 102844: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;

102840: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
102841: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
102842: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
102843: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
102844: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
102845: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
102846: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
102847: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
102848: TYPE t_array_source_91 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 102845: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;

102841: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
102842: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
102843: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
102844: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
102845: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
102846: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
102847: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
102848: TYPE t_array_source_91 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
102849: TYPE t_array_source_104 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 103065: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4

103061: , h1.INV_EXCHANGE_RATE_TYPE source_133
103062: , h1.INV_DOC_SEQUENCE_IDENTIFIER source_160
103063: FROM xla_events_gt xet
103064: , AP_INVOICE_EXTRACT_HEADER_V h1
103065: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
103066: , fnd_lookup_values fvl16
103067: , fnd_lookup_values fvl42
103068: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
103069: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 106246: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

106242: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106243: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106244: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106245: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106246: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106247: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106248: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106249: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106250: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 106247: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

106243: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106244: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106245: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106246: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106247: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106248: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106249: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106250: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106251: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 106248: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

106244: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106245: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106246: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106247: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106248: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106249: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106250: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106251: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106252: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 106249: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

106245: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106246: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106247: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106248: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106249: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106250: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106251: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106252: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106253: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 106250: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

106246: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106247: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106248: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106249: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106250: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106251: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106252: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106253: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106254: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 106251: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

106247: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106248: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106249: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106250: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106251: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106252: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106253: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106254: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106255: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 106252: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

106248: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106249: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106250: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106251: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106252: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106253: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106254: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106255: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106256: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 106253: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

106249: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106250: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106251: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106252: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106253: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106254: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106255: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106256: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106257: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 106256: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

106252: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106253: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106254: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106255: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106256: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106257: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106258: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106259: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106260: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 106257: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

106253: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106254: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106255: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106256: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106257: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106258: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106259: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106260: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106261: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 106259: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

106255: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106256: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106257: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106258: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106259: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106260: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106261: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106262: WHEN 24 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106263: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 106261: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

106257: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106258: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106259: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106260: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106261: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106262: WHEN 24 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106263: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106264: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106265: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 106262: WHEN 24 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

106258: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106259: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106260: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106261: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106262: WHEN 24 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106263: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106264: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106265: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106266: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 106263: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

106259: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106260: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106261: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106262: WHEN 24 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106263: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106264: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106265: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106266: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106267: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 106470: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4

106466: ELSE null
106467: END source_meaning
106468: FROM xla_events_gt xet
106469: , AP_PAYMENT_EXTRACT_HEADER_V h2
106470: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
106471: , fnd_lookup_values fvl15
106472: , fnd_lookup_values fvl16
106473: , fnd_lookup_values fvl42
106474: , fnd_lookup_values fvl71

Line 106965: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

106961: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
106962: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
106963: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
106964: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
106965: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
106966: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
106967: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
106968: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
106969: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 106966: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;

106962: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
106963: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
106964: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
106965: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
106966: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
106967: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
106968: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
106969: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
106970: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 106967: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

106963: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
106964: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
106965: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
106966: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
106967: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
106968: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
106969: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
106970: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
106971: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;

Line 106968: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

106964: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
106965: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
106966: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
106967: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
106968: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
106969: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
106970: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
106971: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
106972: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 106969: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

106965: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
106966: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
106967: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
106968: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
106969: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
106970: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
106971: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
106972: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
106973: TYPE t_array_source_37 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 106970: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;

106966: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
106967: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
106968: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
106969: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
106970: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
106971: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
106972: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
106973: TYPE t_array_source_37 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
106974: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 106971: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;

106967: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
106968: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
106969: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
106970: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
106971: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
106972: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
106973: TYPE t_array_source_37 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
106974: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
106975: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 106972: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

106968: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
106969: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
106970: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
106971: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
106972: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
106973: TYPE t_array_source_37 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
106974: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
106975: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
106976: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 106975: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

106971: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
106972: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
106973: TYPE t_array_source_37 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
106974: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
106975: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
106976: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
106977: TYPE t_array_source_44 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
106978: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
106979: TYPE t_array_source_46 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 106976: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

106972: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
106973: TYPE t_array_source_37 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
106974: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
106975: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
106976: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
106977: TYPE t_array_source_44 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
106978: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
106979: TYPE t_array_source_46 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
106980: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 106978: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

106974: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
106975: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
106976: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
106977: TYPE t_array_source_44 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
106978: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
106979: TYPE t_array_source_46 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
106980: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
106981: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
106982: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;

Line 106980: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

106976: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
106977: TYPE t_array_source_44 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
106978: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
106979: TYPE t_array_source_46 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
106980: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
106981: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
106982: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
106983: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
106984: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 106981: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;

106977: TYPE t_array_source_44 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
106978: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
106979: TYPE t_array_source_46 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
106980: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
106981: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
106982: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
106983: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
106984: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
106985: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 106982: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;

106978: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
106979: TYPE t_array_source_46 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
106980: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
106981: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
106982: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
106983: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
106984: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
106985: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
106986: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 107204: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4

107200: , h2.AC_DOC_CATEGORY_CODE source_156
107201: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_157
107202: FROM xla_events_gt xet
107203: , AP_PAYMENT_EXTRACT_HEADER_V h2
107204: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
107205: , fnd_lookup_values fvl15
107206: , fnd_lookup_values fvl16
107207: , fnd_lookup_values fvl42
107208: , fnd_lookup_values fvl71

Line 109809: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

109805: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109806: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109807: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109808: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109809: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109810: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109811: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109812: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109813: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 109810: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

109806: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109807: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109808: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109809: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109810: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109811: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109812: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109813: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109814: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 109811: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

109807: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109808: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109809: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109810: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109811: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109812: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109813: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109814: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109815: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 109812: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

109808: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109809: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109810: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109811: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109812: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109813: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109814: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109815: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109816: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 109813: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

109809: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109810: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109811: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109812: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109813: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109814: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109815: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109816: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109817: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 109815: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

109811: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109812: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109813: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109814: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109815: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109816: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109817: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109818: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109819: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 109816: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

109812: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109813: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109814: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109815: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109816: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109817: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109818: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109819: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109820: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 109817: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

109813: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109814: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109815: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109816: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109817: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109818: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109819: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109820: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109821: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 109974: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4

109970: ELSE null
109971: END source_meaning
109972: FROM xla_events_gt xet
109973: , AP_PAYMENT_EXTRACT_HEADER_V h2
109974: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
109975: , fnd_lookup_values fvl15
109976: , fnd_lookup_values fvl16
109977: , fnd_lookup_values fvl42
109978: , fnd_lookup_values fvl71

Line 110408: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

110404: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
110405: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
110406: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
110407: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
110408: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
110409: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
110410: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
110411: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
110412: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 110409: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;

110405: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
110406: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
110407: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
110408: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
110409: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
110410: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
110411: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
110412: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
110413: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 110410: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

110406: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
110407: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
110408: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
110409: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
110410: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
110411: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
110412: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
110413: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
110414: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 110411: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

110407: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
110408: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
110409: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
110410: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
110411: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
110412: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
110413: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
110414: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
110415: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 110412: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

110408: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
110409: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
110410: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
110411: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
110412: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
110413: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
110414: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
110415: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
110416: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;

Line 110414: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

110410: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
110411: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
110412: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
110413: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
110414: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
110415: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
110416: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
110417: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
110418: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 110415: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

110411: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
110412: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
110413: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
110414: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
110415: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
110416: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
110417: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
110418: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
110419: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 110416: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;

110412: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
110413: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
110414: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
110415: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
110416: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
110417: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
110418: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
110419: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
110420: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 110589: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4

110585: , h2.TRANSAC_REVERSAL_FLAG source_159
110586: , fvl159.meaning source_159_meaning
110587: FROM xla_events_gt xet
110588: , AP_PAYMENT_EXTRACT_HEADER_V h2
110589: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
110590: , fnd_lookup_values fvl15
110591: , fnd_lookup_values fvl16
110592: , fnd_lookup_values fvl42
110593: , fnd_lookup_values fvl71