[Home] [Help]
121077: SELECT xet.event_id event_id
121078: , 0 line_number
121079: , CASE r
121080: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121081: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121082: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121083: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121084: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121085: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121079: , CASE r
121080: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121081: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121082: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121083: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121084: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121085: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121086: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121087: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121081: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121082: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121083: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121084: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121085: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121086: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121087: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121088: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121089: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121083: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121084: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121085: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121086: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121087: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121088: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121089: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121090: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121091: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121084: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121085: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121086: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121087: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121088: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121089: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121090: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121091: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121092: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121085: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121086: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121087: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121088: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121089: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121090: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121091: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121092: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121093: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121215: ELSE null
121216: END source_meaning
121217: FROM xla_events_gt xet
121218: , AP_PAYMENT_EXTRACT_HEADER_V h2
121219: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
121220: , fnd_lookup_values fvl4
121221: , fnd_lookup_values fvl30
121222: , fnd_lookup_values fvl110
121223: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
121562: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
121563: --
121564:
121565: TYPE t_array_source_1 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
121566: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
121567: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
121568: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
121569: TYPE t_array_source_32 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
121570: TYPE t_array_source_33 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
121564:
121565: TYPE t_array_source_1 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
121566: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
121567: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
121568: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
121569: TYPE t_array_source_32 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
121570: TYPE t_array_source_33 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
121571: TYPE t_array_source_34 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
121572: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
121566: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
121567: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
121568: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
121569: TYPE t_array_source_32 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
121570: TYPE t_array_source_33 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
121571: TYPE t_array_source_34 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
121572: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
121573: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
121574: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
121568: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
121569: TYPE t_array_source_32 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
121570: TYPE t_array_source_33 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
121571: TYPE t_array_source_34 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
121572: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
121573: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
121574: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
121575: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
121576: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
121569: TYPE t_array_source_32 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
121570: TYPE t_array_source_33 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
121571: TYPE t_array_source_34 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
121572: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
121573: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
121574: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
121575: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
121576: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
121577: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
121570: TYPE t_array_source_33 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
121571: TYPE t_array_source_34 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
121572: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
121573: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
121574: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
121575: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
121576: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
121577: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
121578: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
121704: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_159
121705: , h2.AC_DOC_SEQUENCE_VALUE source_160
121706: FROM xla_events_gt xet
121707: , AP_PAYMENT_EXTRACT_HEADER_V h2
121708: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
121709: , fnd_lookup_values fvl4
121710: , fnd_lookup_values fvl30
121711: , fnd_lookup_values fvl110
121712: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
125435: SELECT xet.event_id event_id
125436: , 0 line_number
125437: , CASE r
125438: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125439: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125440: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125441: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125442: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125443: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125436: , 0 line_number
125437: , CASE r
125438: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125439: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125440: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125441: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125442: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125443: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125444: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125437: , CASE r
125438: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125439: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125440: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125441: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125442: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125443: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125444: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125445: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125438: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125439: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125440: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125441: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125442: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125443: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125444: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125445: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125446: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125439: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125440: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125441: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125442: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125443: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125444: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125445: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125446: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125447: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125441: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125442: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125443: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125444: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125445: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125446: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125447: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125448: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125449: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125442: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125443: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125444: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125445: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125446: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125447: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125448: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125449: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125450: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125444: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125445: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125446: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125447: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125448: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125449: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125450: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125451: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125452: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125445: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125446: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125447: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125448: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125449: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125450: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125451: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125452: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125453: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125446: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125447: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125448: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125449: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125450: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125451: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125452: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125453: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125454: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125448: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125449: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125450: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125451: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125452: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125453: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125454: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125455: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125456: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125449: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125450: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125451: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125452: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125453: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125454: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125455: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125456: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125457: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125450: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125451: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125452: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125453: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125454: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125455: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125456: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125457: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125458: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125452: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125453: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125454: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125455: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125456: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125457: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125458: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125459: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125460: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125458: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125459: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125460: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125461: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125462: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125463: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125464: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125465: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125466: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125644: ELSE null
125645: END source_meaning
125646: FROM xla_events_gt xet
125647: , AP_PAYMENT_EXTRACT_HEADER_V h2
125648: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
125649: , fnd_lookup_values fvl3
125650: , fnd_lookup_values fvl4
125651: , fnd_lookup_values fvl12
125652: , fnd_lookup_values fvl18
126159: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
126160: --
126161:
126162: TYPE t_array_source_1 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
126163: TYPE t_array_source_2 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
126164: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
126165: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
126166: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
126167: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
126160: --
126161:
126162: TYPE t_array_source_1 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
126163: TYPE t_array_source_2 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
126164: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
126165: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
126166: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
126167: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
126168: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
126161:
126162: TYPE t_array_source_1 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
126163: TYPE t_array_source_2 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
126164: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
126165: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
126166: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
126167: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
126168: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
126169: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
126162: TYPE t_array_source_1 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
126163: TYPE t_array_source_2 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
126164: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
126165: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
126166: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
126167: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
126168: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
126169: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
126170: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
126163: TYPE t_array_source_2 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
126164: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
126165: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
126166: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
126167: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
126168: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
126169: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
126170: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
126171: TYPE t_array_source_14 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
126165: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
126166: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
126167: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
126168: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
126169: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
126170: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
126171: TYPE t_array_source_14 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
126172: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
126173: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
126166: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
126167: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
126168: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
126169: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
126170: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
126171: TYPE t_array_source_14 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
126172: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
126173: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
126174: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
126168: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
126169: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
126170: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
126171: TYPE t_array_source_14 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
126172: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
126173: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
126174: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
126175: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
126176: TYPE t_array_source_22 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
126169: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
126170: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
126171: TYPE t_array_source_14 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
126172: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
126173: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
126174: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
126175: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
126176: TYPE t_array_source_22 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
126177: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
126170: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
126171: TYPE t_array_source_14 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
126172: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
126173: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
126174: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
126175: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
126176: TYPE t_array_source_22 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
126177: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
126178: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
126172: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
126173: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
126174: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
126175: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
126176: TYPE t_array_source_22 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
126177: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
126178: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
126179: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
126180: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
126173: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
126174: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
126175: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
126176: TYPE t_array_source_22 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
126177: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
126178: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
126179: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
126180: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
126181: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
126174: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
126175: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
126176: TYPE t_array_source_22 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
126177: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
126178: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
126179: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
126180: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
126181: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
126182: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
126176: TYPE t_array_source_22 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
126177: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
126178: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
126179: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
126180: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
126181: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
126182: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
126183: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
126184: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
126182: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
126183: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
126184: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
126185: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
126186: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
126187: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
126188: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
126189: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
126190: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
126399: , h2.TRANSAC_REVERSAL_FLAG source_175
126400: , fvl175.meaning source_175_meaning
126401: FROM xla_events_gt xet
126402: , AP_PAYMENT_EXTRACT_HEADER_V h2
126403: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
126404: , fnd_lookup_values fvl3
126405: , fnd_lookup_values fvl4
126406: , fnd_lookup_values fvl12
126407: , fnd_lookup_values fvl18
129529: FROM (
129530: SELECT xet.event_id event_id
129531: , 0 line_number
129532: , CASE r
129533: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129534: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129535: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129536: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129537: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129530: SELECT xet.event_id event_id
129531: , 0 line_number
129532: , CASE r
129533: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129534: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129535: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129536: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129537: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129538: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129531: , 0 line_number
129532: , CASE r
129533: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129534: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129535: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129536: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129537: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129538: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129539: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129532: , CASE r
129533: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129534: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129535: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129536: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129537: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129538: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129539: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129540: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129533: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129534: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129535: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129536: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129537: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129538: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129539: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129540: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129541: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129534: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129535: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129536: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129537: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129538: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129539: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129540: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129541: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129542: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129535: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129536: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129537: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129538: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129539: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129540: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129541: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129542: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129543: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129541: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129542: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129543: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129544: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129545: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129546: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129547: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129548: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129549: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129653: ELSE null
129654: END source_meaning
129655: FROM xla_events_gt xet
129656: , AP_INVOICE_EXTRACT_HEADER_V h1
129657: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
129658: , fnd_lookup_values fvl4
129659: , fnd_lookup_values fvl30
129660: , fnd_lookup_values fvl102
129661: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
130256: --
130257: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
130258: --
130259:
130260: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
130261: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
130262: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
130263: TYPE t_array_source_22 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
130264: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
130257: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
130258: --
130259:
130260: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
130261: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
130262: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
130263: TYPE t_array_source_22 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
130264: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
130265: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
130258: --
130259:
130260: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
130261: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
130262: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
130263: TYPE t_array_source_22 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
130264: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
130265: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
130266: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
130259:
130260: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
130261: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
130262: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
130263: TYPE t_array_source_22 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
130264: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
130265: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
130266: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
130267: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
130260: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
130261: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
130262: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
130263: TYPE t_array_source_22 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
130264: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
130265: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
130266: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
130267: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
130268: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
130261: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
130262: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
130263: TYPE t_array_source_22 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
130264: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
130265: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
130266: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
130267: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
130268: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
130269: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
130262: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
130263: TYPE t_array_source_22 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
130264: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
130265: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
130266: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
130267: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
130268: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
130269: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
130270: TYPE t_array_source_93 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
130268: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
130269: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
130270: TYPE t_array_source_93 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
130271: TYPE t_array_source_94 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
130272: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
130273: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
130274: TYPE t_array_source_125 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
130275: TYPE t_array_source_126 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
130276: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
130486: , h1.INV_DOC_SEQUENCE_IDENTIFIER source_153
130487: , h1.INV_DOC_SEQUENCE_VALUE source_154
130488: FROM xla_events_gt xet
130489: , AP_INVOICE_EXTRACT_HEADER_V h1
130490: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
130491: , fnd_lookup_values fvl4
130492: , fnd_lookup_values fvl30
130493: , fnd_lookup_values fvl102
130494: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
137202: SELECT xet.event_id event_id
137203: , 0 line_number
137204: , CASE r
137205: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137206: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137207: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137208: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137209: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137210: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137203: , 0 line_number
137204: , CASE r
137205: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137206: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137207: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137208: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137209: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137210: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137211: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137204: , CASE r
137205: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137206: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137207: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137208: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137209: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137210: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137211: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137212: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137205: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137206: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137207: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137208: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137209: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137210: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137211: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137212: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137213: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137206: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137207: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137208: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137209: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137210: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137211: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137212: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137213: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137214: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137207: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137208: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137209: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137210: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137211: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137212: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137213: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137214: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137215: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137208: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137209: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137210: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137211: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137212: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137213: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137214: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137215: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137216: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137209: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137210: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137211: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137212: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137213: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137214: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137215: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137216: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137217: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137212: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137213: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137214: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137215: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137216: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137217: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137218: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137219: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137220: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137213: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137214: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137215: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137216: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137217: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137218: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137219: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137220: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137221: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137215: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137216: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137217: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137218: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137219: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137220: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137221: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137222: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137223: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137217: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137218: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137219: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137220: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137221: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137222: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137223: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137224: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137225: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137218: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137219: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137220: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137221: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137222: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137223: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137224: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137225: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137226: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137219: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137220: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137221: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137222: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137223: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137224: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137225: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137226: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137227: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137225: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137226: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137227: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137228: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137229: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137230: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137231: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137232: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137233: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137418: ELSE null
137419: END source_meaning
137420: FROM xla_events_gt xet
137421: , AP_PAYMENT_EXTRACT_HEADER_V h2
137422: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
137423: , fnd_lookup_values fvl3
137424: , fnd_lookup_values fvl4
137425: , fnd_lookup_values fvl30
137426: , fnd_lookup_values fvl60
137963: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
137964: --
137965:
137966: TYPE t_array_source_1 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
137967: TYPE t_array_source_2 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
137968: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
137969: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
137970: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
137971: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
137964: --
137965:
137966: TYPE t_array_source_1 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
137967: TYPE t_array_source_2 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
137968: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
137969: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
137970: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
137971: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
137972: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
137965:
137966: TYPE t_array_source_1 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
137967: TYPE t_array_source_2 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
137968: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
137969: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
137970: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
137971: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
137972: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
137973: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
137966: TYPE t_array_source_1 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
137967: TYPE t_array_source_2 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
137968: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
137969: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
137970: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
137971: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
137972: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
137973: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
137974: TYPE t_array_source_22 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
137967: TYPE t_array_source_2 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
137968: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
137969: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
137970: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
137971: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
137972: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
137973: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
137974: TYPE t_array_source_22 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
137975: TYPE t_array_source_25 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
137968: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
137969: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
137970: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
137971: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
137972: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
137973: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
137974: TYPE t_array_source_22 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
137975: TYPE t_array_source_25 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
137976: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
137969: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
137970: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
137971: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
137972: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
137973: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
137974: TYPE t_array_source_22 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
137975: TYPE t_array_source_25 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
137976: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
137977: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
137970: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
137971: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
137972: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
137973: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
137974: TYPE t_array_source_22 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
137975: TYPE t_array_source_25 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
137976: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
137977: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
137978: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
137973: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
137974: TYPE t_array_source_22 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
137975: TYPE t_array_source_25 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
137976: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
137977: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
137978: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
137979: TYPE t_array_source_32 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
137980: TYPE t_array_source_33 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
137981: TYPE t_array_source_34 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
137974: TYPE t_array_source_22 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
137975: TYPE t_array_source_25 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
137976: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
137977: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
137978: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
137979: TYPE t_array_source_32 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
137980: TYPE t_array_source_33 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
137981: TYPE t_array_source_34 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
137982: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
137976: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
137977: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
137978: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
137979: TYPE t_array_source_32 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
137980: TYPE t_array_source_33 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
137981: TYPE t_array_source_34 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
137982: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
137983: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
137984: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
137978: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
137979: TYPE t_array_source_32 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
137980: TYPE t_array_source_33 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
137981: TYPE t_array_source_34 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
137982: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
137983: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
137984: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
137985: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
137986: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
137979: TYPE t_array_source_32 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
137980: TYPE t_array_source_33 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
137981: TYPE t_array_source_34 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
137982: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
137983: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
137984: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
137985: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
137986: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
137987: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
137980: TYPE t_array_source_33 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
137981: TYPE t_array_source_34 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
137982: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
137983: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
137984: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
137985: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
137986: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
137987: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
137988: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
137986: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
137987: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
137988: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
137989: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
137990: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
137991: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
137992: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
137993: TYPE t_array_source_108 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
137994: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
138220: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_159
138221: , h2.AC_DOC_SEQUENCE_VALUE source_160
138222: FROM xla_events_gt xet
138223: , AP_PAYMENT_EXTRACT_HEADER_V h2
138224: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
138225: , fnd_lookup_values fvl3
138226: , fnd_lookup_values fvl4
138227: , fnd_lookup_values fvl30
138228: , fnd_lookup_values fvl60
141409: SELECT xet.event_id event_id
141410: , 0 line_number
141411: , CASE r
141412: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141413: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141414: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141415: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141416: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141417: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141410: , 0 line_number
141411: , CASE r
141412: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141413: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141414: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141415: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141416: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141417: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141418: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141411: , CASE r
141412: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141413: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141414: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141415: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141416: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141417: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141418: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141419: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141412: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141413: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141414: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141415: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141416: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141417: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141418: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141419: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141420: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141413: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141414: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141415: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141416: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141417: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141418: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141419: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141420: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141421: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141415: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141416: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141417: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141418: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141419: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141420: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141421: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141422: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141423: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141416: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141417: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141418: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141419: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141420: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141421: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141422: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141423: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141424: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141417: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141418: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141419: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141420: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141421: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141422: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141423: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141424: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141425: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141423: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141424: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141425: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141426: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141427: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141428: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141429: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141430: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141431: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141566: ELSE null
141567: END source_meaning
141568: FROM xla_events_gt xet
141569: , AP_PAYMENT_EXTRACT_HEADER_V h2
141570: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
141571: , fnd_lookup_values fvl3
141572: , fnd_lookup_values fvl4
141573: , fnd_lookup_values fvl30
141574: , fnd_lookup_values fvl60
142021: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
142022: --
142023:
142024: TYPE t_array_source_1 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
142025: TYPE t_array_source_2 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
142026: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
142027: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
142028: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
142029: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
142022: --
142023:
142024: TYPE t_array_source_1 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
142025: TYPE t_array_source_2 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
142026: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
142027: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
142028: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
142029: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
142030: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
142023:
142024: TYPE t_array_source_1 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
142025: TYPE t_array_source_2 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
142026: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
142027: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
142028: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
142029: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
142030: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
142031: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
142024: TYPE t_array_source_1 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
142025: TYPE t_array_source_2 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
142026: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
142027: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
142028: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
142029: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
142030: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
142031: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
142032: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
142025: TYPE t_array_source_2 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
142026: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
142027: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
142028: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
142029: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
142030: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
142031: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
142032: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
142033: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
142027: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
142028: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
142029: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
142030: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
142031: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
142032: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
142033: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
142034: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
142035: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
142028: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
142029: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
142030: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
142031: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
142032: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
142033: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
142034: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
142035: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
142036: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
142029: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
142030: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
142031: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
142032: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
142033: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
142034: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
142035: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
142036: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
142037: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
142035: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
142036: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
142037: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
142038: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
142039: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
142040: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
142041: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
142042: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
142043: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
142207: , h2.TRANSAC_REVERSAL_FLAG source_175
142208: , fvl175.meaning source_175_meaning
142209: FROM xla_events_gt xet
142210: , AP_PAYMENT_EXTRACT_HEADER_V h2
142211: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
142212: , fnd_lookup_values fvl3
142213: , fnd_lookup_values fvl4
142214: , fnd_lookup_values fvl30
142215: , fnd_lookup_values fvl60