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

APPS.XLA_00200_AAD_S_000006_PKG dependencies on AP_INVOICE_EXTRACT_HEADER_V

Line 182556: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

182552: , CASE r
182553: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182554: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182555: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182556: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182557: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182558: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182559: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182560: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 182559: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

182555: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182556: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182557: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182558: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182559: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182560: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182561: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182562: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182563: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 182560: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

182556: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182557: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182558: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182559: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182560: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182561: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182562: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182563: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182564: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 182561: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

182557: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182558: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182559: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182560: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182561: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182562: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182563: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182564: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182565: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 182562: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

182558: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182559: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182560: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182561: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182562: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182563: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182564: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182565: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182566: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 182563: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

182559: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182560: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182561: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182562: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182563: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182564: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182565: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182566: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182567: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 182565: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

182561: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182562: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182563: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182564: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182565: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182566: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182567: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182568: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182569: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 182566: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

182562: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182563: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182564: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182565: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182566: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182567: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182568: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182569: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182570: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 182567: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

182563: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182564: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182565: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182566: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182567: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182568: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182569: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182570: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182571: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 182568: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

182564: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182565: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182566: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182567: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182568: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182569: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182570: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182571: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182572:

Line 182569: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

182565: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182566: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182567: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182568: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182569: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182570: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182571: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182572:
182573: ELSE null

Line 182570: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

182566: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182567: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182568: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182569: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182570: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182571: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182572:
182573: ELSE null
182574: END object_name

Line 182571: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

182567: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182568: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182569: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182570: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182571: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182572:
182573: ELSE null
182574: END object_name
182575: , CASE r

Line 182677: , AP_INVOICE_EXTRACT_HEADER_V h2

182673:
182674: ELSE null
182675: END source_meaning
182676: FROM xla_events_gt xet
182677: , AP_INVOICE_EXTRACT_HEADER_V h2
182678: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
182679: , fnd_lookup_values fvl3
182680: , fnd_lookup_values fvl35
182681: , fnd_lookup_values fvl86

Line 183244: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;

183240:
183241: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
183242: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
183243: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
183244: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
183245: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
183246: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
183247: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
183248: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 183247: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

183243: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
183244: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
183245: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
183246: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
183247: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
183248: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
183249: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
183250: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
183251: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 183248: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

183244: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
183245: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
183246: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
183247: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
183248: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
183249: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
183250: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
183251: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
183252: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 183249: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

183245: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
183246: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
183247: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
183248: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
183249: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
183250: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
183251: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
183252: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
183253: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 183250: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

183246: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
183247: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
183248: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
183249: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
183250: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
183251: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
183252: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
183253: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
183254: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 183251: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

183247: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
183248: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
183249: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
183250: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
183251: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
183252: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
183253: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
183254: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
183255: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 183253: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

183249: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
183250: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
183251: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
183252: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
183253: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
183254: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
183255: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
183256: TYPE t_array_source_159 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
183257: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 183254: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

183250: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
183251: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
183252: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
183253: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
183254: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
183255: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
183256: TYPE t_array_source_159 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
183257: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
183258: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 183255: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

183251: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
183252: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
183253: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
183254: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
183255: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
183256: TYPE t_array_source_159 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
183257: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
183258: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
183259: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 183256: TYPE t_array_source_159 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

183252: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
183253: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
183254: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
183255: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
183256: TYPE t_array_source_159 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
183257: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
183258: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
183259: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
183260:

Line 183257: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

183253: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
183254: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
183255: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
183256: TYPE t_array_source_159 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
183257: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
183258: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
183259: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
183260:
183261: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 183258: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

183254: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
183255: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
183256: TYPE t_array_source_159 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
183257: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
183258: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
183259: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
183260:
183261: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
183262: TYPE t_array_source_9 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 183259: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

183255: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
183256: TYPE t_array_source_159 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
183257: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
183258: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
183259: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
183260:
183261: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
183262: TYPE t_array_source_9 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
183263: TYPE t_array_source_10 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 183454: , AP_INVOICE_EXTRACT_HEADER_V h2

183450: , h2.INV_DOC_SEQUENCE_CATEGORY source_165
183451: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_166
183452: , h2.INV_DOC_SEQUENCE_VALUE source_167
183453: FROM xla_events_gt xet
183454: , AP_INVOICE_EXTRACT_HEADER_V h2
183455: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
183456: , fnd_lookup_values fvl3
183457: , fnd_lookup_values fvl35
183458: , fnd_lookup_values fvl86

Line 186786: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

186782: , CASE r
186783: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186784: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186785: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186786: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186787: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186788: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186789: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186790: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 186789: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

186785: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186786: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186787: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186788: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186789: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186790: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186791: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186792: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186793: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 186790: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

186786: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186787: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186788: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186789: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186790: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186791: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186792: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186793: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186794: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 186791: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

186787: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186788: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186789: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186790: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186791: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186792: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186793: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186794: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186795: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 186792: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

186788: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186789: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186790: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186791: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186792: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186793: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186794: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186795: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186796: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 186793: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

186789: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186790: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186791: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186792: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186793: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186794: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186795: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186796: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186797: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 186795: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

186791: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186792: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186793: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186794: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186795: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186796: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186797: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186798: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186799: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 186796: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

186792: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186793: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186794: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186795: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186796: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186797: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186798: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186799: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186800: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 186797: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

186793: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186794: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186795: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186796: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186797: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186798: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186799: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186800: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186801:

Line 186798: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

186794: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186795: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186796: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186797: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186798: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186799: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186800: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186801:
186802: ELSE null

Line 186799: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

186795: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186796: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186797: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186798: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186799: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186800: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186801:
186802: ELSE null
186803: END object_name

Line 186800: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

186796: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186797: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186798: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186799: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186800: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186801:
186802: ELSE null
186803: END object_name
186804: , CASE r

Line 186901: , AP_INVOICE_EXTRACT_HEADER_V h2

186897:
186898: ELSE null
186899: END source_meaning
186900: FROM xla_events_gt xet
186901: , AP_INVOICE_EXTRACT_HEADER_V h2
186902: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
186903: , fnd_lookup_values fvl3
186904: , fnd_lookup_values fvl35
186905: , fnd_lookup_values fvl86

Line 187458: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;

187454:
187455: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
187456: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
187457: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
187458: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
187459: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
187460: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
187461: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
187462: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 187461: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

187457: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
187458: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
187459: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
187460: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
187461: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
187462: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
187463: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
187464: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
187465: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 187462: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

187458: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
187459: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
187460: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
187461: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
187462: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
187463: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
187464: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
187465: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
187466: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 187463: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

187459: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
187460: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
187461: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
187462: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
187463: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
187464: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
187465: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
187466: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
187467: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 187464: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

187460: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
187461: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
187462: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
187463: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
187464: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
187465: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
187466: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
187467: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
187468: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 187465: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

187461: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
187462: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
187463: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
187464: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
187465: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
187466: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
187467: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
187468: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
187469: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 187467: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

187463: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
187464: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
187465: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
187466: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
187467: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
187468: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
187469: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
187470: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
187471: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 187468: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

187464: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
187465: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
187466: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
187467: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
187468: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
187469: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
187470: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
187471: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
187472: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 187469: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

187465: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
187466: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
187467: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
187468: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
187469: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
187470: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
187471: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
187472: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
187473:

Line 187470: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

187466: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
187467: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
187468: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
187469: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
187470: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
187471: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
187472: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
187473:
187474: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 187471: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

187467: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
187468: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
187469: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
187470: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
187471: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
187472: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
187473:
187474: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
187475: TYPE t_array_source_9 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 187472: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

187468: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
187469: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
187470: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
187471: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
187472: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
187473:
187474: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
187475: TYPE t_array_source_9 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
187476: TYPE t_array_source_10 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 187661: , AP_INVOICE_EXTRACT_HEADER_V h2

187657: , h2.INV_DOC_SEQUENCE_CATEGORY source_165
187658: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_166
187659: , h2.INV_DOC_SEQUENCE_VALUE source_167
187660: FROM xla_events_gt xet
187661: , AP_INVOICE_EXTRACT_HEADER_V h2
187662: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
187663: , fnd_lookup_values fvl3
187664: , fnd_lookup_values fvl35
187665: , fnd_lookup_values fvl86

Line 193262: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

193258: , CASE r
193259: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193260: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193261: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193262: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193263: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193264: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193265: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193266: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 193265: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

193261: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193262: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193263: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193264: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193265: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193266: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193267: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193268: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193269: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 193266: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

193262: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193263: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193264: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193265: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193266: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193267: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193268: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193269: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193270: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 193267: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

193263: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193264: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193265: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193266: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193267: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193268: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193269: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193270: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193271: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 193268: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

193264: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193265: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193266: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193267: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193268: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193269: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193270: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193271: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193272: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 193269: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

193265: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193266: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193267: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193268: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193269: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193270: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193271: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193272: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193273: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 193271: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

193267: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193268: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193269: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193270: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193271: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193272: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193273: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193274: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193275: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 193272: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

193268: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193269: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193270: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193271: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193272: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193273: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193274: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193275: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193276: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 193273: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

193269: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193270: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193271: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193272: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193273: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193274: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193275: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193276: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193277: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 193274: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

193270: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193271: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193272: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193273: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193274: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193275: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193276: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193277: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193278:

Line 193275: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

193271: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193272: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193273: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193274: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193275: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193276: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193277: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193278:
193279: ELSE null

Line 193276: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

193272: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193273: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193274: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193275: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193276: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193277: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193278:
193279: ELSE null
193280: END object_name

Line 193277: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

193273: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193274: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193275: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193276: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193277: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193278:
193279: ELSE null
193280: END object_name
193281: , CASE r

Line 193383: , AP_INVOICE_EXTRACT_HEADER_V h2

193379:
193380: ELSE null
193381: END source_meaning
193382: FROM xla_events_gt xet
193383: , AP_INVOICE_EXTRACT_HEADER_V h2
193384: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
193385: , fnd_lookup_values fvl3
193386: , fnd_lookup_values fvl35
193387: , fnd_lookup_values fvl86

Line 193960: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;

193956:
193957: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
193958: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
193959: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
193960: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
193961: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
193962: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
193963: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
193964: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 193963: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

193959: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
193960: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
193961: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
193962: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
193963: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
193964: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
193965: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
193966: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
193967: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 193964: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

193960: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
193961: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
193962: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
193963: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
193964: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
193965: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
193966: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
193967: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
193968: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 193965: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

193961: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
193962: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
193963: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
193964: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
193965: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
193966: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
193967: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
193968: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
193969: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 193966: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

193962: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
193963: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
193964: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
193965: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
193966: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
193967: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
193968: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
193969: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
193970: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 193967: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

193963: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
193964: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
193965: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
193966: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
193967: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
193968: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
193969: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
193970: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
193971: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 193969: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

193965: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
193966: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
193967: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
193968: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
193969: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
193970: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
193971: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
193972: TYPE t_array_source_159 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
193973: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 193970: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

193966: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
193967: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
193968: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
193969: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
193970: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
193971: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
193972: TYPE t_array_source_159 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
193973: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
193974: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 193971: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

193967: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
193968: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
193969: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
193970: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
193971: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
193972: TYPE t_array_source_159 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
193973: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
193974: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
193975: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 193972: TYPE t_array_source_159 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

193968: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
193969: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
193970: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
193971: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
193972: TYPE t_array_source_159 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
193973: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
193974: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
193975: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
193976:

Line 193973: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

193969: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
193970: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
193971: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
193972: TYPE t_array_source_159 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
193973: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
193974: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
193975: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
193976:
193977: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 193974: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

193970: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
193971: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
193972: TYPE t_array_source_159 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
193973: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
193974: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
193975: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
193976:
193977: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
193978: TYPE t_array_source_9 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 193975: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

193971: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
193972: TYPE t_array_source_159 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
193973: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
193974: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
193975: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
193976:
193977: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
193978: TYPE t_array_source_9 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
193979: TYPE t_array_source_10 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 194174: , AP_INVOICE_EXTRACT_HEADER_V h2

194170: , h2.INV_DOC_SEQUENCE_CATEGORY source_165
194171: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_166
194172: , h2.INV_DOC_SEQUENCE_VALUE source_167
194173: FROM xla_events_gt xet
194174: , AP_INVOICE_EXTRACT_HEADER_V h2
194175: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
194176: , fnd_lookup_values fvl3
194177: , fnd_lookup_values fvl35
194178: , fnd_lookup_values fvl86

Line 201809: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

201805: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201806: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201807: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201808: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201809: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201810: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201811: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201812: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201813: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 201810: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

201806: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201807: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201808: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201809: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201810: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201811: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201812: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201813: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201814: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 201811: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

201807: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201808: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201809: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201810: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201811: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201812: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201813: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201814: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201815: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 201812: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

201808: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201809: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201810: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201811: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201812: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201813: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201814: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201815: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201816: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 201813: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

201809: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201810: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201811: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201812: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201813: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201814: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201815: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201816: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201817: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 201815: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

201811: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201812: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201813: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201814: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201815: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201816: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201817: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201818: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201819: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 201816: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

201812: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201813: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201814: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201815: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201816: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201817: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201818: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201819: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201820: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 201817: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

201813: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201814: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201815: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201816: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201817: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201818: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201819: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201820: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201821:

Line 201818: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

201814: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201815: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201816: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201817: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201818: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201819: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201820: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201821:
201822: ELSE null

Line 201819: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

201815: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201816: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201817: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201818: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201819: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201820: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201821:
201822: ELSE null
201823: END object_name

Line 201820: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

201816: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201817: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201818: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201819: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201820: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201821:
201822: ELSE null
201823: END object_name
201824: , CASE r

Line 201916: , AP_INVOICE_EXTRACT_HEADER_V h1

201912:
201913: ELSE null
201914: END source_meaning
201915: FROM xla_events_gt xet
201916: , AP_INVOICE_EXTRACT_HEADER_V h1
201917: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
201918: , fnd_lookup_values fvl3
201919: , fnd_lookup_values fvl86
201920: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)

Line 202438: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

202434: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
202435: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
202436: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
202437: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
202438: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
202439: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
202440: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
202441: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
202442: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 202439: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

202435: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
202436: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
202437: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
202438: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
202439: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
202440: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
202441: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
202442: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
202443: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 202440: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

202436: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
202437: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
202438: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
202439: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
202440: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
202441: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
202442: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
202443: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
202444: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 202441: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

202437: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
202438: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
202439: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
202440: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
202441: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
202442: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
202443: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
202444: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
202445: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 202442: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

202438: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
202439: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
202440: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
202441: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
202442: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
202443: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
202444: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
202445: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
202446: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 202444: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

202440: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
202441: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
202442: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
202443: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
202444: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
202445: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
202446: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
202447: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
202448: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 202445: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

202441: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
202442: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
202443: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
202444: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
202445: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
202446: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
202447: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
202448: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
202449: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 202446: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

202442: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
202443: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
202444: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
202445: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
202446: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
202447: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
202448: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
202449: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
202450:

Line 202447: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

202443: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
202444: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
202445: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
202446: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
202447: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
202448: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
202449: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
202450:
202451: TYPE t_array_source_18 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 202448: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

202444: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
202445: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
202446: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
202447: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
202448: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
202449: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
202450:
202451: TYPE t_array_source_18 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
202452: TYPE t_array_source_24 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 202449: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

202445: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
202446: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
202447: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
202448: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
202449: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
202450:
202451: TYPE t_array_source_18 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
202452: TYPE t_array_source_24 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
202453: TYPE t_array_source_26 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 202624: , AP_INVOICE_EXTRACT_HEADER_V h1

202620: , h1.INV_DOC_SEQUENCE_CATEGORY source_165
202621: , h1.INV_DOC_SEQUENCE_IDENTIFIER source_166
202622: , h1.INV_DOC_SEQUENCE_VALUE source_167
202623: FROM xla_events_gt xet
202624: , AP_INVOICE_EXTRACT_HEADER_V h1
202625: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
202626: , fnd_lookup_values fvl3
202627: , fnd_lookup_values fvl86
202628: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 204285: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

204281: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204282: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204283: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204284: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204285: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204286: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204287: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204288: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204289: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 204287: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

204283: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204284: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204285: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204286: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204287: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204288: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204289: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204290: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204291: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 204288: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

204284: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204285: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204286: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204287: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204288: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204289: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204290: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204291: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204292: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 204289: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

204285: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204286: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204287: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204288: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204289: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204290: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204291: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204292: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204293: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 204290: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

204286: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204287: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204288: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204289: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204290: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204291: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204292: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204293: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204294: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 204291: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

204287: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204288: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204289: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204290: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204291: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204292: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204293: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204294: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204295: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 204293: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

204289: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204290: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204291: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204292: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204293: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204294: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204295: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204296: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204297: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 204294: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

204290: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204291: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204292: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204293: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204294: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204295: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204296: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204297: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204298: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 204295: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

204291: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204292: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204293: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204294: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204295: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204296: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204297: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204298: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204299:

Line 204296: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

204292: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204293: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204294: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204295: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204296: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204297: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204298: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204299:
204300: ELSE null

Line 204297: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

204293: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204294: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204295: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204296: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204297: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204298: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204299:
204300: ELSE null
204301: END object_name

Line 204298: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

204294: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204295: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204296: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204297: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204298: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204299:
204300: ELSE null
204301: END object_name
204302: , CASE r

Line 204400: , AP_INVOICE_EXTRACT_HEADER_V h2

204396:
204397: ELSE null
204398: END source_meaning
204399: FROM xla_events_gt xet
204400: , AP_INVOICE_EXTRACT_HEADER_V h2
204401: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
204402: , fnd_lookup_values fvl3
204403: , fnd_lookup_values fvl19
204404: , fnd_lookup_values fvl35

Line 204959: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;

204955: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
204956: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
204957: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
204958: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
204959: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
204960: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
204961: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
204962: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
204963: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 204961: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

204957: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
204958: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
204959: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
204960: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
204961: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
204962: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
204963: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
204964: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
204965: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 204962: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

204958: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
204959: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
204960: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
204961: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
204962: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
204963: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
204964: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
204965: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
204966: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 204963: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

204959: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
204960: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
204961: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
204962: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
204963: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
204964: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
204965: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
204966: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
204967: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 204964: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

204960: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
204961: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
204962: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
204963: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
204964: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
204965: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
204966: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
204967: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
204968: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 204965: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

204961: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
204962: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
204963: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
204964: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
204965: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
204966: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
204967: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
204968: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
204969: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 204967: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

204963: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
204964: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
204965: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
204966: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
204967: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
204968: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
204969: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
204970: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
204971: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 204968: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

204964: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
204965: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
204966: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
204967: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
204968: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
204969: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
204970: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
204971: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
204972: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 204969: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

204965: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
204966: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
204967: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
204968: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
204969: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
204970: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
204971: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
204972: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
204973:

Line 204970: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

204966: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
204967: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
204968: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
204969: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
204970: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
204971: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
204972: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
204973:
204974: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 204971: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

204967: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
204968: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
204969: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
204970: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
204971: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
204972: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
204973:
204974: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
204975: TYPE t_array_source_9 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 204972: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

204968: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
204969: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
204970: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
204971: TYPE t_array_source_166 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
204972: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
204973:
204974: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
204975: TYPE t_array_source_9 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
204976: TYPE t_array_source_10 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 205160: , AP_INVOICE_EXTRACT_HEADER_V h2

205156: , h2.INV_DOC_SEQUENCE_CATEGORY source_165
205157: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_166
205158: , h2.INV_DOC_SEQUENCE_VALUE source_167
205159: FROM xla_events_gt xet
205160: , AP_INVOICE_EXTRACT_HEADER_V h2
205161: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
205162: , fnd_lookup_values fvl3
205163: , fnd_lookup_values fvl19
205164: , fnd_lookup_values fvl35