[Home] [Help]
143843: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143844: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143845: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143846: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143847: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143848: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143849: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143850: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143851: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143844: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143845: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143846: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143847: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143848: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143849: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143850: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143851: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143852: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143845: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143846: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143847: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143848: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143849: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143850: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143851: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143852: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143853: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143847: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143848: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143849: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143850: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143851: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143852: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143853: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143854: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143855: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143848: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143849: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143850: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143851: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143852: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143853: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143854: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143855: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143856: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143981: ELSE null
143982: END source_meaning
143983: FROM xla_events_gt xet
143984: , AP_INVOICE_EXTRACT_HEADER_V h2
143985: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
143986: , fnd_lookup_values fvl15
143987: , fnd_lookup_values fvl47
143988: , fnd_lookup_values fvl164
143989: ,(select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
144509: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
144510: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
144511: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
144512: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
144513: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
144514: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
144515: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
144516: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
144517: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
144510: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
144511: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
144512: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
144513: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
144514: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
144515: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
144516: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
144517: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
144518: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
144511: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
144512: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
144513: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
144514: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
144515: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
144516: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
144517: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
144518: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
144519: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
144513: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
144514: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
144515: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
144516: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
144517: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
144518: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
144519: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
144520: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
144521: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
144514: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
144515: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
144516: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
144517: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
144518: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
144519: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
144520: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
144521: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
144522: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
144714: , fvl164.meaning source_164_meaning
144715: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
144716: FROM xla_events_gt xet
144717: , AP_INVOICE_EXTRACT_HEADER_V h2
144718: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
144719: , fnd_lookup_values fvl15
144720: , fnd_lookup_values fvl47
144721: , fnd_lookup_values fvl164
144722: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
147168: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147169: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147170: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147171: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147172: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147173: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147174: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147175: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147176: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147169: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147170: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147171: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147172: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147173: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147174: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147175: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147176: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147177: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147170: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147171: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147172: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147173: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147174: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147175: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147176: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147177: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147178: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147172: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147173: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147174: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147175: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147176: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147177: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147178: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147179: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147180: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147173: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147174: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147175: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147176: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147177: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147178: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147179: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147180: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147181: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147300: ELSE null
147301: END source_meaning
147302: FROM xla_events_gt xet
147303: , AP_INVOICE_EXTRACT_HEADER_V h2
147304: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
147305: , fnd_lookup_values fvl15
147306: , fnd_lookup_values fvl47
147307: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
147308: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
147818: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
147819: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
147820: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
147821: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
147822: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
147823: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
147824: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
147825: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
147826: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
147819: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
147820: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
147821: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
147822: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
147823: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
147824: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
147825: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
147826: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
147827: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
147820: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
147821: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
147822: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
147823: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
147824: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
147825: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
147826: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
147827: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
147828: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
147822: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
147823: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
147824: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
147825: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
147826: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
147827: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
147828: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
147829: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
147830: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
147823: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
147824: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
147825: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
147826: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
147827: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
147828: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
147829: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
147830: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
147831: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
148016: , h2.AI_SOURCE source_163
148017: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
148018: FROM xla_events_gt xet
148019: , AP_INVOICE_EXTRACT_HEADER_V h2
148020: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
148021: , fnd_lookup_values fvl15
148022: , fnd_lookup_values fvl47
148023: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
148024: and xet.event_class_code = C_EVENT_CLASS_CODE
150434: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150435: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150436: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150437: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150438: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150439: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150440: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150441: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150442: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150438: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150439: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150440: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150441: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150442: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150443: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150444: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150445: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150446: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150440: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150441: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150442: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150443: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150444: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150445: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150446: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150447: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150448: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150441: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150442: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150443: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150444: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150445: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150446: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150447: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150448: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150449: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150442: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150443: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150444: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150445: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150446: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150447: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150448: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150449: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150450: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150444: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150445: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150446: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150447: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150448: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150449: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150450: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150451: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150452: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150592: ELSE null
150593: END source_meaning
150594: FROM xla_events_gt xet
150595: , AP_PAYMENT_EXTRACT_HEADER_V h2
150596: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
150597: , fnd_lookup_values fvl15
150598: , fnd_lookup_values fvl47
150599: , fnd_lookup_values fvl113
150600: ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
150997: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
150998: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
150999: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
151000: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
151001: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
151002: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
151003: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
151004: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
151005: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
151001: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
151002: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
151003: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
151004: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
151005: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
151006: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
151007: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
151008: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
151009: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
151003: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
151004: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
151005: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
151006: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
151007: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
151008: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
151009: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
151010: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
151011: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
151004: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
151005: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
151006: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
151007: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
151008: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
151009: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
151010: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
151011: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
151012: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
151005: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
151006: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
151007: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
151008: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
151009: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
151010: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
151011: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
151012: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
151013: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
151007: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
151008: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
151009: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
151010: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
151011: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
151012: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
151013: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
151014: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
151015: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
151167: , h2.AC_DOC_CATEGORY_CODE source_170
151168: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_171
151169: FROM xla_events_gt xet
151170: , AP_PAYMENT_EXTRACT_HEADER_V h2
151171: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
151172: , fnd_lookup_values fvl15
151173: , fnd_lookup_values fvl47
151174: , fnd_lookup_values fvl113
151175: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
152832: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152833: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152834: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152835: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152836: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152837: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152838: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152839: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152840: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152833: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152834: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152835: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152836: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152837: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152838: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152839: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152840: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152841: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152834: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152835: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152836: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152837: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152838: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152839: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152840: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152841: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152842: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152836: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152837: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152838: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152839: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152840: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152841: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152842: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152843: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152844: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152837: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152838: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152839: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152840: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152841: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152842: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152843: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152844: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152845: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152970: ELSE null
152971: END source_meaning
152972: FROM xla_events_gt xet
152973: , AP_INVOICE_EXTRACT_HEADER_V h2
152974: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
152975: , fnd_lookup_values fvl15
152976: , fnd_lookup_values fvl47
152977: , fnd_lookup_values fvl164
152978: ,(select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
153508: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
153509: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
153510: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
153511: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
153512: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
153513: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
153514: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
153515: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
153516: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
153509: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
153510: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
153511: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
153512: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
153513: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
153514: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
153515: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
153516: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
153517: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
153510: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
153511: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
153512: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
153513: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
153514: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
153515: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
153516: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
153517: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
153518: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
153512: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
153513: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
153514: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
153515: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
153516: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
153517: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
153518: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
153519: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
153520: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
153513: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
153514: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
153515: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
153516: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
153517: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
153518: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
153519: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
153520: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
153521: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
153717: , fvl164.meaning source_164_meaning
153718: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
153719: FROM xla_events_gt xet
153720: , AP_INVOICE_EXTRACT_HEADER_V h2
153721: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
153722: , fnd_lookup_values fvl15
153723: , fnd_lookup_values fvl47
153724: , fnd_lookup_values fvl164
153725: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
156239: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156240: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156241: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156242: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156243: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156244: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156245: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156246: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156247: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156241: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156242: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156243: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156244: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156245: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156246: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156247: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156248: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156249: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156242: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156243: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156244: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156245: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156246: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156247: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156248: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156249: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156250: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156244: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156245: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156246: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156247: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156248: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156249: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156250: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156251: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156252: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156245: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156246: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156247: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156248: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156249: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156250: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156251: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156252: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156253: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156247: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156248: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156249: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156250: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156251: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156252: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156253: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156254: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156255: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156248: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156249: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156250: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156251: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156252: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156253: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156254: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156255: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156256: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156251: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156252: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156253: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156254: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156255: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156256: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156257: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156258: WHEN 22 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156259: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156253: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156254: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156255: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156256: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156257: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156258: WHEN 22 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156259: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156260: WHEN 24 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156261: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156254: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156255: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156256: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156257: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156258: WHEN 22 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156259: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156260: WHEN 24 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156261: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156262: WHEN 26 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156255: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156256: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156257: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156258: WHEN 22 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156259: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156260: WHEN 24 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156261: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156262: WHEN 26 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156263: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156256: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156257: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156258: WHEN 22 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156259: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156260: WHEN 24 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156261: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156262: WHEN 26 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156263: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156264: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156258: WHEN 22 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156259: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156260: WHEN 24 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156261: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156262: WHEN 26 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156263: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156264: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156265: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156266: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156461: ELSE null
156462: END source_meaning
156463: FROM xla_events_gt xet
156464: , AP_PAYMENT_EXTRACT_HEADER_V h2
156465: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
156466: , fnd_lookup_values fvl15
156467: , fnd_lookup_values fvl19
156468: , fnd_lookup_values fvl25
156469: , fnd_lookup_values fvl47
156944: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
156945: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
156946: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
156947: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
156948: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
156949: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
156950: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
156951: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
156952: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
156946: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
156947: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
156948: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
156949: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
156950: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
156951: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
156952: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
156953: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
156954: TYPE t_array_source_26 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
156947: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
156948: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
156949: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
156950: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
156951: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
156952: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
156953: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
156954: TYPE t_array_source_26 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
156955: TYPE t_array_source_27 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
156949: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
156950: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
156951: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
156952: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
156953: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
156954: TYPE t_array_source_26 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
156955: TYPE t_array_source_27 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
156956: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
156957: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
156950: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
156951: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
156952: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
156953: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
156954: TYPE t_array_source_26 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
156955: TYPE t_array_source_27 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
156956: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
156957: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
156958: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
156952: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
156953: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
156954: TYPE t_array_source_26 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
156955: TYPE t_array_source_27 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
156956: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
156957: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
156958: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
156959: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156960: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156953: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
156954: TYPE t_array_source_26 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
156955: TYPE t_array_source_27 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
156956: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
156957: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
156958: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
156959: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156960: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156961: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156956: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
156957: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
156958: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
156959: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156960: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156961: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156962: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156963: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
156964: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
156958: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
156959: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156960: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156961: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156962: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156963: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
156964: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
156965: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
156966: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
156959: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156960: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156961: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156962: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156963: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
156964: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
156965: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
156966: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
156967: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
156960: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156961: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156962: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156963: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
156964: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
156965: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
156966: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
156967: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
156968: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
156961: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156962: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156963: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
156964: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
156965: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
156966: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
156967: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
156968: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
156969: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
156963: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
156964: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
156965: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
156966: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
156967: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
156968: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
156969: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
156970: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
156971: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
157178: , h2.TRANSAC_REVERSAL_FLAG source_172
157179: , fvl172.meaning source_172_meaning
157180: FROM xla_events_gt xet
157181: , AP_PAYMENT_EXTRACT_HEADER_V h2
157182: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
157183: , fnd_lookup_values fvl15
157184: , fnd_lookup_values fvl19
157185: , fnd_lookup_values fvl25
157186: , fnd_lookup_values fvl47
159368: , 0 line_number
159369: , CASE r
159370: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159371: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159372: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159373: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159374: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159375: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159376: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159369: , CASE r
159370: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159371: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159372: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159373: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159374: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159375: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159376: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159377: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159370: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159371: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159372: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159373: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159374: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159375: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159376: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159377: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159378: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159371: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159372: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159373: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159374: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159375: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159376: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159377: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159378: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159379: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159372: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159373: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159374: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159375: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159376: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159377: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159378: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159379: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159380: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159473: ELSE null
159474: END source_meaning
159475: FROM xla_events_gt xet
159476: , AP_INVOICE_EXTRACT_HEADER_V h1
159477: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
159478: , fnd_lookup_values fvl15
159479: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
159480: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159481: AND xet.event_class_code = C_EVENT_CLASS_CODE
159960: --
159961:
159962: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
159963: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
159964: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
159965: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
159966: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
159967: TYPE t_array_source_41 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
159968: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
159961:
159962: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
159963: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
159964: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
159965: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
159966: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
159967: TYPE t_array_source_41 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
159968: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
159969: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
159962: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
159963: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
159964: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
159965: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
159966: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
159967: TYPE t_array_source_41 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
159968: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
159969: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
159970: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
159963: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
159964: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
159965: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
159966: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
159967: TYPE t_array_source_41 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
159968: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
159969: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
159970: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
159971: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
159964: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
159965: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
159966: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
159967: TYPE t_array_source_41 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
159968: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
159969: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
159970: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
159971: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
159972: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
160136: , h1.INV_EXCHANGE_RATE_TYPE source_138
160137: , h1.INV_DOC_SEQUENCE_IDENTIFIER source_168
160138: FROM xla_events_gt xet
160139: , AP_INVOICE_EXTRACT_HEADER_V h1
160140: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
160141: , fnd_lookup_values fvl15
160142: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
160143: and xet.event_class_code = C_EVENT_CLASS_CODE
160144: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
161659: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161660: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161661: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161662: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161663: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161664: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161665: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161666: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161667: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161660: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161661: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161662: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161663: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161664: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161665: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161666: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161667: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161668: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161661: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161662: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161663: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161664: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161665: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161666: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161667: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161668: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161669: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161662: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161663: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161664: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161665: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161666: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161667: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161668: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161669: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161670: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161664: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161665: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161666: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161667: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161668: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161669: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161670: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161671: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161672: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161792: ELSE null
161793: END source_meaning
161794: FROM xla_events_gt xet
161795: , AP_INVOICE_EXTRACT_HEADER_V h2
161796: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
161797: , fnd_lookup_values fvl15
161798: , fnd_lookup_values fvl31
161799: , fnd_lookup_values fvl47
161800: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
162311: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
162312: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
162313: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
162314: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
162315: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
162316: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
162317: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
162318: TYPE t_array_source_31 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
162319: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
162312: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
162313: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
162314: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
162315: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
162316: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
162317: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
162318: TYPE t_array_source_31 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
162319: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
162320: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
162313: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
162314: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
162315: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
162316: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
162317: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
162318: TYPE t_array_source_31 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
162319: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
162320: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
162321: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
162314: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
162315: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
162316: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
162317: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
162318: TYPE t_array_source_31 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
162319: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
162320: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
162321: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
162322: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162316: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
162317: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
162318: TYPE t_array_source_31 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
162319: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
162320: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
162321: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
162322: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162323: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
162324: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
162508: , h2.AI_SOURCE source_163
162509: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
162510: FROM xla_events_gt xet
162511: , AP_INVOICE_EXTRACT_HEADER_V h2
162512: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
162513: , fnd_lookup_values fvl15
162514: , fnd_lookup_values fvl31
162515: , fnd_lookup_values fvl47
162516: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
164966: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164967: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164968: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164969: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164970: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164971: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164972: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164973: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164974: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164969: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164970: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164971: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164972: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164973: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164974: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164975: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164976: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164977: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164970: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164971: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164972: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164973: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164974: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164975: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164976: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164977: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164978: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164971: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164972: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164973: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164974: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164975: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164976: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164977: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164978: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164979: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164972: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164973: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164974: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164975: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164976: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164977: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164978: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164979: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164980: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164974: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164975: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164976: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164977: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164978: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164979: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164980: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164981: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164982: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164976: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164977: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164978: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164979: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164980: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164981: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164982: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164983: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164984: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164977: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164978: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164979: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164980: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164981: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164982: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164983: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164984: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164985: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164978: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164979: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164980: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164981: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164982: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164983: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164984: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164985: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164986: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164979: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164980: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164981: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164982: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164983: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164984: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164985: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164986: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164987: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164981: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164982: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164983: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164984: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164985: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164986: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164987: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164988: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164989: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165180: ELSE null
165181: END source_meaning
165182: FROM xla_events_gt xet
165183: , AP_PAYMENT_EXTRACT_HEADER_V h2
165184: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
165185: , fnd_lookup_values fvl15
165186: , fnd_lookup_values fvl19
165187: , fnd_lookup_values fvl47
165188: , fnd_lookup_values fvl113
165693: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
165694: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
165695: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165696: TYPE t_array_source_14 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
165697: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
165698: TYPE t_array_source_16 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
165699: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
165700: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165701: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
165696: TYPE t_array_source_14 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
165697: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
165698: TYPE t_array_source_16 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
165699: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
165700: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165701: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
165702: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
165703: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
165704: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165697: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
165698: TYPE t_array_source_16 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
165699: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
165700: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165701: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
165702: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
165703: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
165704: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165705: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165698: TYPE t_array_source_16 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
165699: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
165700: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165701: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
165702: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
165703: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
165704: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165705: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165706: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165699: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
165700: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165701: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
165702: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
165703: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
165704: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165705: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165706: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165707: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165701: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
165702: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
165703: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
165704: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165705: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165706: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165707: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165708: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165709: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
165703: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
165704: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165705: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165706: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165707: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165708: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165709: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
165710: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
165711: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
165704: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165705: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165706: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165707: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165708: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165709: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
165710: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
165711: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
165712: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
165705: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165706: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165707: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165708: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165709: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
165710: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
165711: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
165712: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
165713: TYPE t_array_source_104 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165706: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165707: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165708: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165709: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
165710: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
165711: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
165712: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
165713: TYPE t_array_source_104 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165714: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
165708: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165709: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
165710: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
165711: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
165712: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
165713: TYPE t_array_source_104 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165714: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
165715: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
165716: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
165935: , h2.AC_DOC_CATEGORY_CODE source_170
165936: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_171
165937: FROM xla_events_gt xet
165938: , AP_PAYMENT_EXTRACT_HEADER_V h2
165939: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
165940: , fnd_lookup_values fvl15
165941: , fnd_lookup_values fvl19
165942: , fnd_lookup_values fvl47
165943: , fnd_lookup_values fvl113
168089: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168090: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168091: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168092: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168093: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168094: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168095: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168096: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168097: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168091: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168092: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168093: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168094: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168095: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168096: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168097: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168098: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168099: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168092: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168093: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168094: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168095: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168096: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168097: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168098: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168099: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168100: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168095: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168096: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168097: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168098: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168099: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168100: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168101: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168102: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168103: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168097: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168098: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168099: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168100: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168101: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168102: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168103: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168104: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168105: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168098: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168099: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168100: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168101: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168102: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168103: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168104: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168105: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168106: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168099: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168100: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168101: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168102: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168103: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168104: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168105: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168106: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168107: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168100: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168101: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168102: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168103: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168104: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168105: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168106: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168107: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168108: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168102: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168103: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168104: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168105: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168106: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168107: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168108: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168109: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168110: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168275: ELSE null
168276: END source_meaning
168277: FROM xla_events_gt xet
168278: , AP_PAYMENT_EXTRACT_HEADER_V h2
168279: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
168280: , fnd_lookup_values fvl15
168281: , fnd_lookup_values fvl19
168282: , fnd_lookup_values fvl47
168283: , fnd_lookup_values fvl113
168700: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
168701: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
168702: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
168703: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
168704: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
168705: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
168706: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
168707: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
168708: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
168702: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
168703: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
168704: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
168705: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
168706: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
168707: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
168708: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
168709: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
168710: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
168703: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
168704: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
168705: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
168706: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
168707: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
168708: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
168709: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
168710: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
168711: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
168706: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
168707: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
168708: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
168709: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
168710: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
168711: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
168712: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
168713: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
168714: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
168708: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
168709: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
168710: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
168711: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
168712: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
168713: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
168714: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
168715: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
168716: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
168709: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
168710: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
168711: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
168712: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
168713: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
168714: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
168715: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
168716: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
168717: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
168710: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
168711: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
168712: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
168713: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
168714: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
168715: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
168716: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
168717: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
168718: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
168711: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
168712: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
168713: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
168714: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
168715: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
168716: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
168717: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
168718: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
168719: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
168713: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
168714: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
168715: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
168716: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
168717: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
168718: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
168719: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
168720: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
168721: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
168894: , h2.TRANSAC_REVERSAL_FLAG source_172
168895: , fvl172.meaning source_172_meaning
168896: FROM xla_events_gt xet
168897: , AP_PAYMENT_EXTRACT_HEADER_V h2
168898: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
168899: , fnd_lookup_values fvl15
168900: , fnd_lookup_values fvl19
168901: , fnd_lookup_values fvl47
168902: , fnd_lookup_values fvl113