65239: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65240: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65241: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65242: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65243: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65244: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65245: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65246: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65247: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65240: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65241: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65242: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65243: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65244: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65245: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65246: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65247: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65248: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65241: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65242: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65243: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65244: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65245: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65246: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65247: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65248: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65249: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65242: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65243: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65244: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65245: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65246: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65247: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65248: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65249: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65250: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65243: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65244: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65245: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65246: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65247: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65248: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65249: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65250: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65251: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65244: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65245: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65246: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65247: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65248: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65249: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65250: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65251: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65252: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65245: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65246: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65247: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65248: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65249: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65250: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65251: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65252: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65253: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65246: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65247: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65248: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65249: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65250: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65251: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65252: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65253: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65254:
65247: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65248: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65249: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65250: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65251: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65252: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65253: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65254:
65255: ELSE null
65248: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65249: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65250: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65251: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65252: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65253: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65254:
65255: ELSE null
65256: END object_name
65249: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65250: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65251: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65252: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65253: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65254:
65255: ELSE null
65256: END object_name
65257: , CASE r
65342:
65343: ELSE null
65344: END source_meaning
65345: FROM xla_events_gt xet
65346: , AP_INVOICE_EXTRACT_HEADER_V h2
65347: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
65348: , fnd_lookup_values fvl7
65349: , fnd_lookup_values fvl12
65350: , fnd_lookup_values fvl17
65864: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
65865: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
65866: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
65867: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
65868: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
65869: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
65870: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
65871: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
65872: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
65865: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
65866: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
65867: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
65868: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
65869: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
65870: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
65871: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
65872: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
65873: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
65866: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
65867: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
65868: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
65869: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
65870: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
65871: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
65872: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
65873: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
65874: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
65867: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
65868: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
65869: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
65870: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
65871: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
65872: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
65873: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
65874: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
65875: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
65868: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
65869: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
65870: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
65871: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
65872: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
65873: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
65874: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
65875: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
65876: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
65869: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
65870: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
65871: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
65872: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
65873: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
65874: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
65875: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
65876: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
65877: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
65870: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
65871: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
65872: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
65873: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
65874: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
65875: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
65876: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
65877: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
65878: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
65871: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
65872: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
65873: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
65874: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
65875: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
65876: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
65877: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
65878: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
65879:
65872: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
65873: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
65874: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
65875: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
65876: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
65877: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
65878: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
65879:
65880: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
65873: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
65874: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
65875: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
65876: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
65877: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
65878: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
65879:
65880: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
65881: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
65874: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
65875: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
65876: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
65877: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
65878: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
65879:
65880: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
65881: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
65882: TYPE t_array_source_9 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;
66046: , h2.INV_DOC_SEQUENCE_CATEGORY source_122
66047: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_123
66048: , h2.INV_DOC_SEQUENCE_VALUE source_124
66049: FROM xla_events_gt xet
66050: , AP_INVOICE_EXTRACT_HEADER_V h2
66051: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
66052: , fnd_lookup_values fvl7
66053: , fnd_lookup_values fvl12
66054: , fnd_lookup_values fvl17
68097: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68098: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68099: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68100: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68101: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68102: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68103: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68104: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68105: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68098: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68099: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68100: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68101: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68102: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68103: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68104: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68105: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68106: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68099: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68100: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68101: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68102: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68103: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68104: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68105: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68106: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68107: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68100: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68101: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68102: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68103: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68104: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68105: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68106: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68107: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68108: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68101: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68102: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68103: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68104: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68105: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68106: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68107: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68108: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68109: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68102: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68103: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68104: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68105: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68106: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68107: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68108: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68109: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68110: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68103: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68104: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68105: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68106: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68107: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68108: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68109: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68110: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68111: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68104: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68105: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68106: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68107: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68108: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68109: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68110: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68111: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68112:
68105: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68106: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68107: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68108: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68109: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68110: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68111: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68112:
68113: ELSE null
68106: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68107: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68108: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68109: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68110: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68111: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68112:
68113: ELSE null
68114: END object_name
68107: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68108: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68109: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68110: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68111: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68112:
68113: ELSE null
68114: END object_name
68115: , CASE r
68200:
68201: ELSE null
68202: END source_meaning
68203: FROM xla_events_gt xet
68204: , AP_INVOICE_EXTRACT_HEADER_V h2
68205: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
68206: , fnd_lookup_values fvl7
68207: , fnd_lookup_values fvl12
68208: , fnd_lookup_values fvl17
68717: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
68718: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
68719: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
68720: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
68721: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
68722: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68723: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
68724: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
68725: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
68718: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
68719: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
68720: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
68721: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
68722: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68723: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
68724: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
68725: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
68726: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
68719: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
68720: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
68721: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
68722: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68723: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
68724: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
68725: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
68726: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
68727: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
68720: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
68721: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
68722: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68723: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
68724: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
68725: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
68726: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
68727: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
68728: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68721: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
68722: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68723: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
68724: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
68725: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
68726: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
68727: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
68728: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68729: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
68722: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68723: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
68724: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
68725: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
68726: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
68727: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
68728: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68729: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
68730: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
68723: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
68724: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
68725: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
68726: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
68727: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
68728: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68729: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
68730: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
68731: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
68724: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
68725: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
68726: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
68727: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
68728: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68729: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
68730: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
68731: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
68732:
68725: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
68726: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
68727: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
68728: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68729: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
68730: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
68731: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
68732:
68733: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
68726: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
68727: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
68728: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68729: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
68730: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
68731: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
68732:
68733: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
68734: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
68727: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
68728: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68729: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
68730: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
68731: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
68732:
68733: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
68734: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
68735: TYPE t_array_source_9 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;
68897: , h2.INV_DOC_SEQUENCE_CATEGORY source_122
68898: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_123
68899: , h2.INV_DOC_SEQUENCE_VALUE source_124
68900: FROM xla_events_gt xet
68901: , AP_INVOICE_EXTRACT_HEADER_V h2
68902: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
68903: , fnd_lookup_values fvl7
68904: , fnd_lookup_values fvl12
68905: , fnd_lookup_values fvl17
70929: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70930: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70931: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70932: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70933: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70934: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70935: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70936: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70937: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70930: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70931: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70932: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70933: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70934: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70935: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70936: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70937: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70938: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70931: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70932: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70933: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70934: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70935: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70936: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70937: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70938: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70939: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70932: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70933: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70934: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70935: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70936: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70937: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70938: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70939: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70940: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70933: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70934: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70935: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70936: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70937: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70938: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70939: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70940: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70941: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70934: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70935: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70936: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70937: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70938: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70939: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70940: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70941: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70942: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70935: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70936: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70937: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70938: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70939: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70940: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70941: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70942: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70943: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70936: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70937: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70938: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70939: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70940: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70941: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70942: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70943: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70944: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70937: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70938: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70939: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70940: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70941: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70942: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70943: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70944: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70945:
70938: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70939: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70940: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70941: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70942: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70943: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70944: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70945:
70946: ELSE null
70939: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70940: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70941: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70942: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70943: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70944: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70945:
70946: ELSE null
70947: END object_name
70940: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70941: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70942: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70943: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70944: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70945:
70946: ELSE null
70947: END object_name
70948: , CASE r
71038:
71039: ELSE null
71040: END source_meaning
71041: FROM xla_events_gt xet
71042: , AP_INVOICE_EXTRACT_HEADER_V h2
71043: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
71044: , fnd_lookup_values fvl7
71045: , fnd_lookup_values fvl12
71046: , fnd_lookup_values fvl17
71570: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
71571: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
71572: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
71573: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
71574: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
71575: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
71576: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
71577: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
71578: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
71571: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
71572: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
71573: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
71574: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
71575: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
71576: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
71577: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
71578: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
71579: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
71572: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
71573: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
71574: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
71575: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
71576: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
71577: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
71578: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
71579: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
71580: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
71573: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
71574: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
71575: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
71576: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
71577: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
71578: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
71579: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
71580: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
71581: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71574: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
71575: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
71576: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
71577: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
71578: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
71579: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
71580: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
71581: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71582: TYPE t_array_source_68 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
71575: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
71576: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
71577: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
71578: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
71579: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
71580: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
71581: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71582: TYPE t_array_source_68 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
71583: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
71576: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
71577: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
71578: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
71579: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
71580: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
71581: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71582: TYPE t_array_source_68 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
71583: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
71584: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
71577: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
71578: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
71579: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
71580: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
71581: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71582: TYPE t_array_source_68 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
71583: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
71584: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
71585: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
71578: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
71579: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
71580: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
71581: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71582: TYPE t_array_source_68 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
71583: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
71584: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
71585: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
71586:
71579: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
71580: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
71581: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71582: TYPE t_array_source_68 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
71583: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
71584: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
71585: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
71586:
71587: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
71580: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
71581: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71582: TYPE t_array_source_68 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
71583: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
71584: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
71585: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
71586:
71587: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
71588: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
71581: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71582: TYPE t_array_source_68 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
71583: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
71584: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
71585: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
71586:
71587: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
71588: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
71589: TYPE t_array_source_9 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;
71759: , h2.INV_DOC_SEQUENCE_CATEGORY source_122
71760: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_123
71761: , h2.INV_DOC_SEQUENCE_VALUE source_124
71762: FROM xla_events_gt xet
71763: , AP_INVOICE_EXTRACT_HEADER_V h2
71764: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
71765: , fnd_lookup_values fvl7
71766: , fnd_lookup_values fvl12
71767: , fnd_lookup_values fvl17
75770: SELECT xet.event_id event_id
75771: , 0 line_number
75772: , CASE r
75773: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
75774: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75775: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75776: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75777: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75778: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75771: , 0 line_number
75772: , CASE r
75773: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
75774: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75775: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75776: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75777: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75778: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75779: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75772: , CASE r
75773: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
75774: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75775: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75776: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75777: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75778: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75779: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75780:
75773: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
75774: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75775: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75776: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75777: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75778: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75779: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75780:
75781: ELSE null
75774: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75775: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75776: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75777: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75778: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75779: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75780:
75781: ELSE null
75782: END object_name
75775: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75776: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75777: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75778: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75779: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75780:
75781: ELSE null
75782: END object_name
75783: , CASE r
75830:
75831: ELSE null
75832: END source_meaning
75833: FROM xla_events_gt xet
75834: , AP_INVOICE_EXTRACT_HEADER_V h1
75835: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
75836: , fnd_lookup_values fvl17
75837: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
75838: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76254: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
76255: --
76256:
76257: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
76258: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
76259: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76260: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76261: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76262: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
76255: --
76256:
76257: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
76258: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
76259: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76260: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76261: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76262: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
76263: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76256:
76257: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
76258: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
76259: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76260: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76261: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76262: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
76263: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76264:
76257: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
76258: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
76259: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76260: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76261: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76262: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
76263: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76264:
76265: TYPE t_array_source_19 IS TABLE OF AP_PREPAYAPP_EXTRACT_DTLS_BC_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
76258: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
76259: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76260: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76261: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76262: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
76263: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76264:
76265: TYPE t_array_source_19 IS TABLE OF AP_PREPAYAPP_EXTRACT_DTLS_BC_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
76266: TYPE t_array_source_21 IS TABLE OF AP_PREPAYAPP_EXTRACT_DTLS_BC_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
76259: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76260: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76261: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76262: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
76263: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76264:
76265: TYPE t_array_source_19 IS TABLE OF AP_PREPAYAPP_EXTRACT_DTLS_BC_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
76266: TYPE t_array_source_21 IS TABLE OF AP_PREPAYAPP_EXTRACT_DTLS_BC_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
76267: TYPE t_array_source_25 IS TABLE OF AP_PREPAYAPP_EXTRACT_DTLS_BC_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
76381: , h1.INV_DOC_SEQUENCE_CATEGORY source_122
76382: , h1.INV_DOC_SEQUENCE_IDENTIFIER source_123
76383: , h1.INV_DOC_SEQUENCE_VALUE source_124
76384: FROM xla_events_gt xet
76385: , AP_INVOICE_EXTRACT_HEADER_V h1
76386: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
76387: , fnd_lookup_values fvl17
76388: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
76389: and xet.event_class_code = C_EVENT_CLASS_CODE
77369: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77370: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77371: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77372: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77373: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77374: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77375: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77376: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77377: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77370: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77371: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77372: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77373: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77374: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77375: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77376: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77377: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77378: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77371: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77372: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77373: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77374: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77375: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77376: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77377: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77378: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77379: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77372: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77373: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77374: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77375: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77376: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77377: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77378: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77379: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77380: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77373: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77374: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77375: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77376: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77377: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77378: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77379: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77380: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77381: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77374: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77375: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77376: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77377: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77378: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77379: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77380: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77381: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77382: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77375: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77376: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77377: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77378: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77379: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77380: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77381: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77382: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77383: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77376: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77377: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77378: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77379: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77380: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77381: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77382: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77383: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77384:
77377: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77378: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77379: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77380: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77381: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77382: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77383: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77384:
77385: ELSE null
77378: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77379: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77380: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77381: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77382: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77383: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77384:
77385: ELSE null
77386: END object_name
77379: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77380: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77381: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77382: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77383: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77384:
77385: ELSE null
77386: END object_name
77387: , CASE r
77472:
77473: ELSE null
77474: END source_meaning
77475: FROM xla_events_gt xet
77476: , AP_INVOICE_EXTRACT_HEADER_V h2
77477: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
77478: , fnd_lookup_values fvl7
77479: , fnd_lookup_values fvl12
77480: , fnd_lookup_values fvl17
77994: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
77995: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
77996: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
77997: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
77998: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
77999: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
78000: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
78001: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
78002: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77995: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
77996: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
77997: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
77998: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
77999: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
78000: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
78001: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
78002: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
78003: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
77996: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
77997: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
77998: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
77999: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
78000: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
78001: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
78002: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
78003: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
78004: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
77997: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
77998: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
77999: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
78000: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
78001: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
78002: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
78003: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
78004: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
78005: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
77998: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
77999: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
78000: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
78001: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
78002: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
78003: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
78004: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
78005: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
78006: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77999: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
78000: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
78001: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
78002: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
78003: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
78004: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
78005: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
78006: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
78007: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
78000: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
78001: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
78002: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
78003: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
78004: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
78005: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
78006: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
78007: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
78008: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
78001: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
78002: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
78003: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
78004: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
78005: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
78006: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
78007: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
78008: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
78009:
78002: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
78003: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
78004: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
78005: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
78006: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
78007: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
78008: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
78009:
78010: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
78003: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
78004: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
78005: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
78006: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
78007: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
78008: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
78009:
78010: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
78011: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
78004: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
78005: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
78006: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
78007: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
78008: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
78009:
78010: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
78011: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
78012: TYPE t_array_source_9 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;
78176: , h2.INV_DOC_SEQUENCE_CATEGORY source_122
78177: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_123
78178: , h2.INV_DOC_SEQUENCE_VALUE source_124
78179: FROM xla_events_gt xet
78180: , AP_INVOICE_EXTRACT_HEADER_V h2
78181: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
78182: , fnd_lookup_values fvl7
78183: , fnd_lookup_values fvl12
78184: , fnd_lookup_values fvl17