[Home] [Help]
152580: FROM (
152581: SELECT xet.event_id event_id
152582: , 0 line_number
152583: , CASE r
152584: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152585: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152586: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152587: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152588: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152581: SELECT xet.event_id event_id
152582: , 0 line_number
152583: , CASE r
152584: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152585: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152586: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152587: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152588: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152589: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152582: , 0 line_number
152583: , CASE r
152584: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152585: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152586: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152587: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152588: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152589: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152590: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152584: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152585: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152586: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152587: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152588: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152589: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152590: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152591: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152592: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152585: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152586: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152587: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152588: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152589: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152590: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152591: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152592: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152593: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152699: ELSE null
152700: END source_meaning
152701: FROM xla_events_gt xet
152702: , AP_INVOICE_EXTRACT_HEADER_V h2
152703: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
152704: , fnd_lookup_values fvl10
152705: , fnd_lookup_values fvl43
152706: , fnd_lookup_values fvl167
152707: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
153216: --
153217: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
153218: --
153219:
153220: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
153221: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
153222: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
153223: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
153224: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
153217: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
153218: --
153219:
153220: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
153221: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
153222: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
153223: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
153224: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
153225: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
153218: --
153219:
153220: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
153221: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
153222: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
153223: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
153224: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
153225: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
153226: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
153220: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
153221: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
153222: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
153223: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
153224: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
153225: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
153226: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
153227: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
153228: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
153221: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
153222: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
153223: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
153224: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
153225: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
153226: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
153227: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
153228: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
153229: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
153410: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_172
153411: , h2.INV_DOC_SEQUENCE_VALUE source_173
153412: FROM xla_events_gt xet
153413: , AP_INVOICE_EXTRACT_HEADER_V h2
153414: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
153415: , fnd_lookup_values fvl10
153416: , fnd_lookup_values fvl43
153417: , fnd_lookup_values fvl167
153418: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
155834: FROM (
155835: SELECT xet.event_id event_id
155836: , 0 line_number
155837: , CASE r
155838: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155839: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155840: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155841: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155842: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155835: SELECT xet.event_id event_id
155836: , 0 line_number
155837: , CASE r
155838: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155839: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155840: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155841: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155842: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155843: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155836: , 0 line_number
155837: , CASE r
155838: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155839: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155840: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155841: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155842: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155843: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155844: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155838: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155839: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155840: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155841: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155842: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155843: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155844: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155845: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155846: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155839: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155840: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155841: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155842: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155843: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155844: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155845: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155846: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155847: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155947: ELSE null
155948: END source_meaning
155949: FROM xla_events_gt xet
155950: , AP_INVOICE_EXTRACT_HEADER_V h2
155951: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
155952: , fnd_lookup_values fvl10
155953: , fnd_lookup_values fvl43
155954: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
155955: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
156454: --
156455: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
156456: --
156457:
156458: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
156459: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156460: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156461: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
156462: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
156455: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
156456: --
156457:
156458: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
156459: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156460: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156461: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
156462: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
156463: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
156456: --
156457:
156458: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
156459: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156460: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156461: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
156462: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
156463: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
156464: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
156458: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
156459: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156460: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156461: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
156462: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
156463: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
156464: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
156465: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
156466: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
156459: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156460: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156461: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
156462: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
156463: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
156464: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
156465: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
156466: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
156467: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
156641: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_172
156642: , h2.INV_DOC_SEQUENCE_VALUE source_173
156643: FROM xla_events_gt xet
156644: , AP_INVOICE_EXTRACT_HEADER_V h2
156645: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
156646: , fnd_lookup_values fvl10
156647: , fnd_lookup_values fvl43
156648: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
156649: and xet.event_class_code = C_EVENT_CLASS_CODE
159031: , 0 line_number
159032: , CASE r
159033: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159034: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159035: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159036: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159037: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159038: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159039: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159035: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159036: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159037: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159038: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159039: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159040: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159041: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159042: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159043: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159037: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159038: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159039: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159040: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159041: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159042: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159043: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159044: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159045: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159038: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159039: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159040: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159041: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159042: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159043: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159044: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159045: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159046: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159039: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159040: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159041: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159042: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159043: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159044: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159045: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159046: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159047: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159040: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159041: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159042: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159043: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159044: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159045: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159046: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159047: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159048: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
159168: ELSE null
159169: END source_meaning
159170: FROM xla_events_gt xet
159171: , AP_PAYMENT_EXTRACT_HEADER_V h2
159172: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
159173: , fnd_lookup_values fvl10
159174: , fnd_lookup_values fvl43
159175: , fnd_lookup_values fvl116
159176: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
159569: --
159570:
159571: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
159572: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
159573: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
159574: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
159575: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
159576: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
159577: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
159573: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
159574: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
159575: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
159576: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
159577: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
159578: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
159579: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
159580: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
159581: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
159575: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
159576: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
159577: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
159578: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
159579: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
159580: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
159581: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
159582: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
159583: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
159576: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
159577: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
159578: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
159579: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
159580: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
159581: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
159582: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
159583: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
159584: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
159577: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
159578: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
159579: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
159580: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
159581: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
159582: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
159583: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
159584: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
159585: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
159578: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
159579: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
159580: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
159581: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
159582: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
159583: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
159584: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
159585: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
159586: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
159728: , h2.AC_DOC_CATEGORY_CODE source_175
159729: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_176
159730: FROM xla_events_gt xet
159731: , AP_PAYMENT_EXTRACT_HEADER_V h2
159732: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
159733: , fnd_lookup_values fvl10
159734: , fnd_lookup_values fvl43
159735: , fnd_lookup_values fvl116
159736: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
161349: FROM (
161350: SELECT xet.event_id event_id
161351: , 0 line_number
161352: , CASE r
161353: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161354: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161355: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161356: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161357: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161350: SELECT xet.event_id event_id
161351: , 0 line_number
161352: , CASE r
161353: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161354: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161355: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161356: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161357: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161358: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161351: , 0 line_number
161352: , CASE r
161353: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161354: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161355: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161356: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161357: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161358: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161359: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161353: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161354: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161355: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161356: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161357: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161358: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161359: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161360: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161361: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161354: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161355: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161356: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161357: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161358: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161359: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161360: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161361: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161362: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161468: ELSE null
161469: END source_meaning
161470: FROM xla_events_gt xet
161471: , AP_INVOICE_EXTRACT_HEADER_V h2
161472: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
161473: , fnd_lookup_values fvl10
161474: , fnd_lookup_values fvl43
161475: , fnd_lookup_values fvl167
161476: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
161995: --
161996: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
161997: --
161998:
161999: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
162000: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
162001: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
162002: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
162003: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
161996: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
161997: --
161998:
161999: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
162000: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
162001: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
162002: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
162003: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
162004: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
161997: --
161998:
161999: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
162000: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
162001: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
162002: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
162003: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
162004: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
162005: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
161999: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
162000: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
162001: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
162002: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
162003: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
162004: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
162005: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
162006: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162007: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
162000: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
162001: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
162002: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
162003: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
162004: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
162005: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
162006: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162007: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
162008: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
162193: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_172
162194: , h2.INV_DOC_SEQUENCE_VALUE source_173
162195: FROM xla_events_gt xet
162196: , AP_INVOICE_EXTRACT_HEADER_V h2
162197: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
162198: , fnd_lookup_values fvl10
162199: , fnd_lookup_values fvl43
162200: , fnd_lookup_values fvl167
162201: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
164691: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164692: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164693: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164694: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164695: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164696: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164697: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164698: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164699: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164693: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164694: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164695: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164696: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164697: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164698: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164699: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164700: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164701: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164694: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164695: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164696: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164697: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164698: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164699: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164700: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164701: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164702: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164696: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164697: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164698: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164699: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164700: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164701: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164702: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164703: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164704: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164697: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164698: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164699: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164700: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164701: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164702: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164703: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164704: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164705: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164699: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164700: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164701: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164702: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164703: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164704: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164705: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164706: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164707: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164700: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164701: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164702: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164703: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164704: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164705: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164706: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164707: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164708: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164703: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164704: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164705: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164706: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164707: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164708: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164709: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164710: WHEN 22 THEN 'FV_XLA_PAYMENTS_V'
164711: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164705: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164706: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164707: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164708: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164709: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164710: WHEN 22 THEN 'FV_XLA_PAYMENTS_V'
164711: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164712: WHEN 24 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164713: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164707: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164708: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164709: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164710: WHEN 22 THEN 'FV_XLA_PAYMENTS_V'
164711: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164712: WHEN 24 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164713: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164714: WHEN 26 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164715: WHEN 27 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164708: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164709: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164710: WHEN 22 THEN 'FV_XLA_PAYMENTS_V'
164711: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164712: WHEN 24 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164713: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164714: WHEN 26 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164715: WHEN 27 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164716: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164710: WHEN 22 THEN 'FV_XLA_PAYMENTS_V'
164711: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164712: WHEN 24 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164713: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164714: WHEN 26 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164715: WHEN 27 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164716: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164717: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164718: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164711: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164712: WHEN 24 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164713: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164714: WHEN 26 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164715: WHEN 27 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164716: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164717: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164718: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164719: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164923: ELSE null
164924: END source_meaning
164925: FROM xla_events_gt xet
164926: , AP_PAYMENT_EXTRACT_HEADER_V h2
164927: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
164928: , FV_XLA_PAYMENTS_V h5
164929: , fnd_lookup_values fvl10
164930: , fnd_lookup_values fvl14
164931: , fnd_lookup_values fvl20
165455: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
165456: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
165457: TYPE t_array_source_7 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
165458: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165459: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
165460: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
165461: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165462: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
165463: TYPE t_array_source_19 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
165457: TYPE t_array_source_7 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
165458: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165459: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
165460: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
165461: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165462: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
165463: TYPE t_array_source_19 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
165464: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
165465: TYPE t_array_source_21 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
165458: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165459: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
165460: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
165461: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165462: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
165463: TYPE t_array_source_19 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
165464: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
165465: TYPE t_array_source_21 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
165466: TYPE t_array_source_22 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
165460: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
165461: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165462: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
165463: TYPE t_array_source_19 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
165464: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
165465: TYPE t_array_source_21 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
165466: TYPE t_array_source_22 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
165467: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
165468: TYPE t_array_source_24 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
165461: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165462: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
165463: TYPE t_array_source_19 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
165464: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
165465: TYPE t_array_source_21 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
165466: TYPE t_array_source_22 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
165467: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
165468: TYPE t_array_source_24 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
165469: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
165463: TYPE t_array_source_19 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
165464: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
165465: TYPE t_array_source_21 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
165466: TYPE t_array_source_22 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
165467: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
165468: TYPE t_array_source_24 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
165469: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
165470: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165471: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165464: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
165465: TYPE t_array_source_21 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
165466: TYPE t_array_source_22 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
165467: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
165468: TYPE t_array_source_24 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
165469: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
165470: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165471: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165472: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165467: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
165468: TYPE t_array_source_24 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
165469: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
165470: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165471: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165472: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165473: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165474: TYPE t_array_source_37 IS TABLE OF FV_XLA_PAYMENTS_V.FEDERAL_DIT_CONFIRM_ACCT%TYPE INDEX BY BINARY_INTEGER;
165475: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165469: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
165470: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165471: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165472: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165473: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165474: TYPE t_array_source_37 IS TABLE OF FV_XLA_PAYMENTS_V.FEDERAL_DIT_CONFIRM_ACCT%TYPE INDEX BY BINARY_INTEGER;
165475: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165476: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
165477: TYPE t_array_source_44 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
165471: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165472: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165473: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165474: TYPE t_array_source_37 IS TABLE OF FV_XLA_PAYMENTS_V.FEDERAL_DIT_CONFIRM_ACCT%TYPE INDEX BY BINARY_INTEGER;
165475: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165476: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
165477: TYPE t_array_source_44 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
165478: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
165479: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
165472: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165473: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165474: TYPE t_array_source_37 IS TABLE OF FV_XLA_PAYMENTS_V.FEDERAL_DIT_CONFIRM_ACCT%TYPE INDEX BY BINARY_INTEGER;
165475: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165476: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
165477: TYPE t_array_source_44 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
165478: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
165479: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
165480: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
165474: TYPE t_array_source_37 IS TABLE OF FV_XLA_PAYMENTS_V.FEDERAL_DIT_CONFIRM_ACCT%TYPE INDEX BY BINARY_INTEGER;
165475: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165476: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
165477: TYPE t_array_source_44 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
165478: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
165479: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
165480: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
165481: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
165482: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
165475: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165476: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
165477: TYPE t_array_source_44 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
165478: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
165479: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
165480: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
165481: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
165482: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
165483: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165712: , h2.TRANSAC_REVERSAL_FLAG source_177
165713: , fvl177.meaning source_177_meaning
165714: FROM xla_events_gt xet
165715: , AP_PAYMENT_EXTRACT_HEADER_V h2
165716: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
165717: , FV_XLA_PAYMENTS_V h5
165718: , fnd_lookup_values fvl10
165719: , fnd_lookup_values fvl14
165720: , fnd_lookup_values fvl20
168479: FROM (
168480: SELECT xet.event_id event_id
168481: , 0 line_number
168482: , CASE r
168483: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168484: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168485: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168486: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168487: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168480: SELECT xet.event_id event_id
168481: , 0 line_number
168482: , CASE r
168483: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168484: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168485: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168486: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168487: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168488: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168481: , 0 line_number
168482: , CASE r
168483: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168484: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168485: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168486: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168487: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168488: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168489: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168482: , CASE r
168483: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168484: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168485: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168486: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168487: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168488: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168489: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168490: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168483: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168484: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168485: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168486: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168487: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168488: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168489: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168490: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168491: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168586: ELSE null
168587: END source_meaning
168588: FROM xla_events_gt xet
168589: , AP_INVOICE_EXTRACT_HEADER_V h1
168590: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
168591: , fnd_lookup_values fvl10
168592: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
168593: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168594: AND xet.event_class_code = C_EVENT_CLASS_CODE
169086: --
169087: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
169088: --
169089:
169090: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
169091: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
169092: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
169093: TYPE t_array_source_36 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
169094: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
169087: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
169088: --
169089:
169090: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
169091: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
169092: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
169093: TYPE t_array_source_36 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
169094: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
169095: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
169088: --
169089:
169090: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
169091: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
169092: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
169093: TYPE t_array_source_36 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
169094: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
169095: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
169096: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
169089:
169090: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
169091: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
169092: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
169093: TYPE t_array_source_36 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
169094: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
169095: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
169096: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
169097: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
169090: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
169091: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
169092: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
169093: TYPE t_array_source_36 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
169094: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
169095: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
169096: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
169097: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
169098: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
169270: , h1.INV_DOC_SEQUENCE_IDENTIFIER source_172
169271: , h1.INV_DOC_SEQUENCE_VALUE source_173
169272: FROM xla_events_gt xet
169273: , AP_INVOICE_EXTRACT_HEADER_V h1
169274: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
169275: , fnd_lookup_values fvl10
169276: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
169277: and xet.event_class_code = C_EVENT_CLASS_CODE
169278: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
170846: FROM (
170847: SELECT xet.event_id event_id
170848: , 0 line_number
170849: , CASE r
170850: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170851: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170852: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170853: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170854: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170847: SELECT xet.event_id event_id
170848: , 0 line_number
170849: , CASE r
170850: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170851: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170852: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170853: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170854: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170855: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170848: , 0 line_number
170849: , CASE r
170850: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170851: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170852: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170853: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170854: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170855: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170856: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170849: , CASE r
170850: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170851: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170852: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170853: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170854: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170855: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170856: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170857: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170851: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170852: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170853: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170854: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170855: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170856: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170857: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170858: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170859: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170960: ELSE null
170961: END source_meaning
170962: FROM xla_events_gt xet
170963: , AP_INVOICE_EXTRACT_HEADER_V h2
170964: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
170965: , fnd_lookup_values fvl10
170966: , fnd_lookup_values fvl26
170967: , fnd_lookup_values fvl43
170968: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
171468: --
171469: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
171470: --
171471:
171472: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
171473: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
171474: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
171475: TYPE t_array_source_26 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
171476: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
171469: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
171470: --
171471:
171472: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
171473: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
171474: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
171475: TYPE t_array_source_26 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
171476: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
171477: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
171470: --
171471:
171472: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
171473: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
171474: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
171475: TYPE t_array_source_26 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
171476: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
171477: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
171478: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
171471:
171472: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
171473: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
171474: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
171475: TYPE t_array_source_26 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
171476: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
171477: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
171478: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
171479: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
171473: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
171474: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
171475: TYPE t_array_source_26 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
171476: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
171477: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
171478: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
171479: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
171480: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
171481: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
171654: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_172
171655: , h2.INV_DOC_SEQUENCE_VALUE source_173
171656: FROM xla_events_gt xet
171657: , AP_INVOICE_EXTRACT_HEADER_V h2
171658: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
171659: , fnd_lookup_values fvl10
171660: , fnd_lookup_values fvl26
171661: , fnd_lookup_values fvl43
171662: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
174076: , CASE r
174077: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174078: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174079: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174080: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174081: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174082: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174083: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174084: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174079: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174080: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174081: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174082: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174083: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174084: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174085: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174086: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174087: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174080: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174081: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174082: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174083: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174084: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174085: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174086: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174087: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174088: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174081: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174082: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174083: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174084: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174085: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174086: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174087: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174088: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174089: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174082: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174083: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174084: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174085: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174086: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174087: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174088: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174089: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174090: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174084: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174085: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174086: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174087: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174088: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174089: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174090: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174091: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174092: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174086: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174087: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174088: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174089: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174090: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174091: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174092: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174093: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174094: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174087: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174088: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174089: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174090: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174091: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174092: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174093: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174094: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174095: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174088: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174089: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174090: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174091: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174092: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174093: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174094: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174095: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174096: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174089: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174090: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174091: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174092: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174093: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174094: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174095: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174096: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174097: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174090: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174091: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174092: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174093: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174094: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
174095: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174096: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174097: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174098: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
174269: ELSE null
174270: END source_meaning
174271: FROM xla_events_gt xet
174272: , AP_PAYMENT_EXTRACT_HEADER_V h2
174273: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
174274: , fnd_lookup_values fvl10
174275: , fnd_lookup_values fvl14
174276: , fnd_lookup_values fvl43
174277: , fnd_lookup_values fvl116
174778:
174779: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
174780: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
174781: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
174782: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
174783: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
174784: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
174785: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
174786: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
174781: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
174782: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
174783: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
174784: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
174785: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
174786: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
174787: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
174788: TYPE t_array_source_24 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
174789: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
174782: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
174783: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
174784: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
174785: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
174786: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
174787: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
174788: TYPE t_array_source_24 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
174789: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
174790: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
174783: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
174784: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
174785: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
174786: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
174787: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
174788: TYPE t_array_source_24 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
174789: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
174790: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
174791: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
174784: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
174785: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
174786: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
174787: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
174788: TYPE t_array_source_24 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
174789: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
174790: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
174791: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
174792: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
174786: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
174787: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
174788: TYPE t_array_source_24 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
174789: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
174790: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
174791: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
174792: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
174793: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
174794: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
174788: TYPE t_array_source_24 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
174789: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
174790: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
174791: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
174792: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
174793: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
174794: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
174795: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
174796: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
174789: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
174790: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
174791: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
174792: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
174793: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
174794: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
174795: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
174796: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
174797: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
174790: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
174791: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
174792: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
174793: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
174794: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
174795: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
174796: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
174797: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
174798: TYPE t_array_source_108 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
174791: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
174792: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
174793: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
174794: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
174795: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
174796: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
174797: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
174798: TYPE t_array_source_108 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
174799: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
174792: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
174793: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
174794: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
174795: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
174796: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
174797: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
174798: TYPE t_array_source_108 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
174799: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
174800: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
175009: , h2.AC_DOC_CATEGORY_CODE source_175
175010: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_176
175011: FROM xla_events_gt xet
175012: , AP_PAYMENT_EXTRACT_HEADER_V h2
175013: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
175014: , fnd_lookup_values fvl10
175015: , fnd_lookup_values fvl14
175016: , fnd_lookup_values fvl43
175017: , fnd_lookup_values fvl116
177165: , 0 line_number
177166: , CASE r
177167: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177168: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177169: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177170: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177171: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177172: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177173: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177167: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177168: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177169: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177170: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177171: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177172: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177173: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177174: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177175: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177168: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177169: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177170: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177171: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177172: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177173: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177174: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177175: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177176: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177171: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177172: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177173: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177174: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177175: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177176: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177177: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177178: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177179: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177173: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177174: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177175: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177176: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177177: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177178: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177179: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177180: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177181: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177174: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177175: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177176: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177177: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177178: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177179: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177180: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177181: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177182: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177175: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177176: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177177: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177178: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177179: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177180: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177181: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177182: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177183: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177176: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177177: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177178: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177179: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177180: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177181: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177182: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177183: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177184: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177177: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177178: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177179: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177180: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177181: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
177182: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177183: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177184: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177185: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
177330: ELSE null
177331: END source_meaning
177332: FROM xla_events_gt xet
177333: , AP_PAYMENT_EXTRACT_HEADER_V h2
177334: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
177335: , fnd_lookup_values fvl10
177336: , fnd_lookup_values fvl14
177337: , fnd_lookup_values fvl43
177338: , fnd_lookup_values fvl116
177751: --
177752:
177753: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
177754: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
177755: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
177756: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
177757: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
177758: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
177759: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
177753: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
177754: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
177755: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
177756: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
177757: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
177758: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
177759: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
177760: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
177761: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
177754: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
177755: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
177756: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
177757: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
177758: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
177759: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
177760: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
177761: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
177762: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
177757: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
177758: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
177759: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
177760: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
177761: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
177762: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
177763: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
177764: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
177765: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
177759: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
177760: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
177761: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
177762: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
177763: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
177764: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
177765: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
177766: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
177767: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
177760: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
177761: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
177762: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
177763: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
177764: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
177765: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
177766: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
177767: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
177768: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
177761: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
177762: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
177763: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
177764: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
177765: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
177766: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
177767: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
177768: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
177769: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
177762: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
177763: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
177764: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
177765: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
177766: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
177767: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
177768: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
177769: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
177770: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
177763: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
177764: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
177765: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
177766: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
177767: TYPE t_array_source_57 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
177768: TYPE t_array_source_88 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
177769: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
177770: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
177771: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
177934: , h2.TRANSAC_REVERSAL_FLAG source_177
177935: , fvl177.meaning source_177_meaning
177936: FROM xla_events_gt xet
177937: , AP_PAYMENT_EXTRACT_HEADER_V h2
177938: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
177939: , fnd_lookup_values fvl10
177940: , fnd_lookup_values fvl14
177941: , fnd_lookup_values fvl43
177942: , fnd_lookup_values fvl116