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_000012_PKG dependencies on AP_INVOICE_EXTRACT_HEADER_V

Line 152587: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152583: , CASE r
152584: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152585: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152586: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152587: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152588: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152589: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152590: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152591: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152590: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152586: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152587: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152588: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152589: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152590: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152591: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152592: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152593: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152594: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152591: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152587: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152588: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152589: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152590: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152591: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152592: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152593: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152594: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152595: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152592: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152588: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152589: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152590: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152591: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152592: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152593: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152594: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152595: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152596: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152593: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152589: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152590: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152591: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152592: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152593: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152594: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152595: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152596: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152597: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152594: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152590: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152591: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152592: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152593: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152594: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152595: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152596: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152597: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152598: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152595: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152591: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152592: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152593: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152594: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152595: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152596: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152597: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152598: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152599: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152596: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152592: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152593: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152594: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152595: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152596: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152597: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152598: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152599: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152600: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152597: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152593: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152594: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152595: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152596: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152597: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152598: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152599: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152600: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152601: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152598: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152594: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152595: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152596: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152597: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152598: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152599: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152600: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152601: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152602:

Line 152599: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152595: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152596: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152597: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152598: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152599: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152600: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152601: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152602:
152603: ELSE null

Line 152600: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152596: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152597: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152598: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152599: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152600: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152601: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152602:
152603: ELSE null
152604: END object_name

Line 152601: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152597: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152598: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152599: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152600: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152601: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152602:
152603: ELSE null
152604: END object_name
152605: , CASE r

Line 152702: , AP_INVOICE_EXTRACT_HEADER_V h2

152698:
152699: ELSE null
152700: END source_meaning
152701: FROM xla_events_gt xet
152702: , AP_INVOICE_EXTRACT_HEADER_V h2
152703: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
152704: , fnd_lookup_values fvl10
152705: , fnd_lookup_values fvl43
152706: , fnd_lookup_values fvl167

Line 153223: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;

153219:
153220: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
153221: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
153222: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
153223: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
153224: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
153225: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
153226: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
153227: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 153226: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

153222: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
153223: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
153224: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
153225: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
153226: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
153227: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
153228: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
153229: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
153230: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 153227: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

153223: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
153224: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
153225: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
153226: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
153227: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
153228: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
153229: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
153230: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
153231: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 153228: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

153224: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
153225: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
153226: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
153227: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
153228: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
153229: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
153230: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
153231: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
153232: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 153229: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

153225: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
153226: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
153227: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
153228: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
153229: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
153230: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
153231: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
153232: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
153233: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 153230: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

153226: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
153227: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
153228: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
153229: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
153230: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
153231: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
153232: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
153233: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
153234: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 153231: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

153227: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
153228: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
153229: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
153230: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
153231: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
153232: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
153233: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
153234: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
153235: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 153232: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

153228: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
153229: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
153230: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
153231: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
153232: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
153233: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
153234: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
153235: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
153236: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 153233: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

153229: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
153230: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
153231: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
153232: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
153233: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
153234: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
153235: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
153236: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
153237: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 153234: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

153230: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
153231: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
153232: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
153233: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
153234: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
153235: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
153236: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
153237: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
153238:

Line 153235: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

153231: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
153232: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
153233: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
153234: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
153235: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
153236: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
153237: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
153238:
153239: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 153236: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

153232: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
153233: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
153234: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
153235: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
153236: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
153237: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
153238:
153239: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
153240: TYPE t_array_source_16 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 153237: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

153233: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
153234: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
153235: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
153236: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
153237: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
153238:
153239: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
153240: TYPE t_array_source_16 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
153241: TYPE t_array_source_17 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 153413: , AP_INVOICE_EXTRACT_HEADER_V h2

153409: , h2.INV_DOC_SEQUENCE_CATEGORY source_171
153410: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_172
153411: , h2.INV_DOC_SEQUENCE_VALUE source_173
153412: FROM xla_events_gt xet
153413: , AP_INVOICE_EXTRACT_HEADER_V h2
153414: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
153415: , fnd_lookup_values fvl10
153416: , fnd_lookup_values fvl43
153417: , fnd_lookup_values fvl167

Line 155841: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

155837: , CASE r
155838: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155839: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155840: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155841: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155842: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155843: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155844: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155845: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 155844: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

155840: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155841: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155842: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155843: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155844: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155845: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155846: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155847: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155848: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 155845: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

155841: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155842: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155843: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155844: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155845: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155846: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155847: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155848: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155849: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 155846: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

155842: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155843: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155844: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155845: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155846: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155847: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155848: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155849: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155850: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 155847: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

155843: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
155844: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155845: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155846: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155847: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155848: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155849: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155850: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155851: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 155848: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

155844: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155845: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155846: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155847: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155848: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155849: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155850: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155851: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155852: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 155849: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

155845: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155846: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155847: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155848: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155849: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155850: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155851: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155852: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155853: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 155850: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

155846: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155847: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155848: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155849: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155850: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155851: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155852: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155853: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155854: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 155851: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

155847: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155848: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155849: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155850: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155851: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155852: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155853: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155854: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155855:

Line 155852: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

155848: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155849: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155850: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155851: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155852: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155853: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155854: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155855:
155856: ELSE null

Line 155853: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

155849: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155850: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155851: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155852: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155853: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155854: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155855:
155856: ELSE null
155857: END object_name

Line 155854: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

155850: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155851: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155852: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155853: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155854: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
155855:
155856: ELSE null
155857: END object_name
155858: , CASE r

Line 155950: , AP_INVOICE_EXTRACT_HEADER_V h2

155946:
155947: ELSE null
155948: END source_meaning
155949: FROM xla_events_gt xet
155950: , AP_INVOICE_EXTRACT_HEADER_V h2
155951: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
155952: , fnd_lookup_values fvl10
155953: , fnd_lookup_values fvl43
155954: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)

Line 156461: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;

156457:
156458: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
156459: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156460: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156461: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
156462: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
156463: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
156464: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
156465: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 156464: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

156460: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156461: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
156462: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
156463: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
156464: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
156465: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
156466: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
156467: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
156468: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 156465: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

156461: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
156462: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
156463: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
156464: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
156465: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
156466: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
156467: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
156468: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
156469: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 156466: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

156462: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
156463: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
156464: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
156465: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
156466: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
156467: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
156468: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
156469: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
156470: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 156467: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

156463: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
156464: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
156465: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
156466: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
156467: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
156468: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
156469: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
156470: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
156471: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 156468: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

156464: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
156465: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
156466: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
156467: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
156468: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
156469: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
156470: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
156471: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
156472: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 156469: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

156465: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
156466: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
156467: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
156468: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
156469: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
156470: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
156471: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
156472: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
156473: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 156470: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

156466: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
156467: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
156468: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
156469: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
156470: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
156471: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
156472: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
156473: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
156474: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 156471: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

156467: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
156468: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
156469: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
156470: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
156471: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
156472: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
156473: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
156474: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
156475:

Line 156472: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

156468: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
156469: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
156470: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
156471: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
156472: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
156473: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
156474: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
156475:
156476: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 156473: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

156469: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
156470: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
156471: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
156472: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
156473: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
156474: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
156475:
156476: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
156477: TYPE t_array_source_16 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 156474: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

156470: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
156471: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
156472: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
156473: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
156474: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
156475:
156476: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
156477: TYPE t_array_source_16 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
156478: TYPE t_array_source_17 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 156644: , AP_INVOICE_EXTRACT_HEADER_V h2

156640: , h2.INV_DOC_SEQUENCE_CATEGORY source_171
156641: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_172
156642: , h2.INV_DOC_SEQUENCE_VALUE source_173
156643: FROM xla_events_gt xet
156644: , AP_INVOICE_EXTRACT_HEADER_V h2
156645: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
156646: , fnd_lookup_values fvl10
156647: , fnd_lookup_values fvl43
156648: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 161356: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161352: , CASE r
161353: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161354: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161355: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161356: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161357: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161358: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161359: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161360: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161359: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161355: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161356: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161357: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161358: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161359: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161360: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161361: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161362: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161363: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161360: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161356: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161357: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161358: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161359: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161360: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161361: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161362: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161363: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161364: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161361: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161357: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161358: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161359: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161360: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161361: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161362: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161363: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161364: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161365: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161362: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161358: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161359: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161360: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161361: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161362: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161363: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161364: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161365: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161366: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161363: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161359: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161360: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161361: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161362: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161363: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161364: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161365: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161366: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161367: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161364: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161360: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161361: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161362: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161363: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161364: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161365: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161366: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161367: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161368: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161365: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161361: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161362: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161363: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161364: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161365: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161366: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161367: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161368: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161369: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161366: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161362: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161363: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161364: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161365: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161366: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161367: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161368: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161369: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161370: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161367: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161363: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161364: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161365: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161366: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161367: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161368: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161369: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161370: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161371:

Line 161368: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161364: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161365: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161366: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161367: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161368: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161369: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161370: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161371:
161372: ELSE null

Line 161369: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161365: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161366: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161367: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161368: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161369: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161370: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161371:
161372: ELSE null
161373: END object_name

Line 161370: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161366: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161367: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161368: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161369: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161370: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161371:
161372: ELSE null
161373: END object_name
161374: , CASE r

Line 161471: , AP_INVOICE_EXTRACT_HEADER_V h2

161467:
161468: ELSE null
161469: END source_meaning
161470: FROM xla_events_gt xet
161471: , AP_INVOICE_EXTRACT_HEADER_V h2
161472: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
161473: , fnd_lookup_values fvl10
161474: , fnd_lookup_values fvl43
161475: , fnd_lookup_values fvl167

Line 162002: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;

161998:
161999: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
162000: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
162001: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
162002: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
162003: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
162004: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
162005: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
162006: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 162005: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

162001: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
162002: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
162003: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
162004: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
162005: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
162006: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162007: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
162008: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
162009: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 162006: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

162002: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
162003: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
162004: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
162005: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
162006: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162007: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
162008: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
162009: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
162010: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 162007: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

162003: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
162004: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
162005: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
162006: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162007: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
162008: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
162009: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
162010: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
162011: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 162008: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

162004: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
162005: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
162006: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162007: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
162008: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
162009: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
162010: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
162011: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
162012: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 162009: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

162005: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
162006: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162007: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
162008: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
162009: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
162010: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
162011: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
162012: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
162013: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 162010: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

162006: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162007: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
162008: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
162009: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
162010: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
162011: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
162012: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
162013: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
162014: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 162011: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

162007: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
162008: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
162009: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
162010: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
162011: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
162012: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
162013: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
162014: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
162015: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 162012: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

162008: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
162009: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
162010: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
162011: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
162012: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
162013: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
162014: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
162015: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
162016: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 162013: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

162009: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
162010: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
162011: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
162012: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
162013: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
162014: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
162015: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
162016: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
162017:

Line 162014: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

162010: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
162011: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
162012: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
162013: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
162014: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
162015: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
162016: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
162017:
162018: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 162015: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

162011: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
162012: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
162013: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
162014: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
162015: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
162016: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
162017:
162018: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
162019: TYPE t_array_source_16 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 162016: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

162012: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
162013: TYPE t_array_source_167 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
162014: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
162015: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
162016: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
162017:
162018: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
162019: TYPE t_array_source_16 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
162020: TYPE t_array_source_17 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 162196: , AP_INVOICE_EXTRACT_HEADER_V h2

162192: , h2.INV_DOC_SEQUENCE_CATEGORY source_171
162193: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_172
162194: , h2.INV_DOC_SEQUENCE_VALUE source_173
162195: FROM xla_events_gt xet
162196: , AP_INVOICE_EXTRACT_HEADER_V h2
162197: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
162198: , fnd_lookup_values fvl10
162199: , fnd_lookup_values fvl43
162200: , fnd_lookup_values fvl167

Line 168488: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

168484: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168485: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168486: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168487: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168488: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168489: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168490: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168491: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168492: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 168489: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

168485: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168486: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168487: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168488: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168489: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168490: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168491: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168492: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168493: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 168490: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

168486: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168487: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168488: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168489: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168490: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168491: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168492: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168493: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168494: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 168491: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

168487: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168488: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168489: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168490: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168491: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168492: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168493: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168494: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168495: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 168492: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

168488: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168489: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168490: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168491: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168492: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168493: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168494: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168495: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168496: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 168493: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

168489: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168490: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168491: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168492: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168493: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168494: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168495: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168496: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168497: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 168494: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

168490: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168491: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168492: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168493: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168494: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168495: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168496: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168497: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168498: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 168495: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

168491: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168492: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168493: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168494: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168495: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168496: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168497: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168498: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168499:

Line 168496: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

168492: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168493: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168494: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168495: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168496: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168497: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168498: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168499:
168500: ELSE null

Line 168497: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

168493: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168494: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168495: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168496: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168497: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168498: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168499:
168500: ELSE null
168501: END object_name

Line 168498: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

168494: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168495: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168496: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168497: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168498: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
168499:
168500: ELSE null
168501: END object_name
168502: , CASE r

Line 168589: , AP_INVOICE_EXTRACT_HEADER_V h1

168585:
168586: ELSE null
168587: END source_meaning
168588: FROM xla_events_gt xet
168589: , AP_INVOICE_EXTRACT_HEADER_V h1
168590: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
168591: , fnd_lookup_values fvl10
168592: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
168593: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 169095: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

169091: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
169092: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
169093: TYPE t_array_source_36 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
169094: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
169095: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
169096: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
169097: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
169098: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
169099: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 169096: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

169092: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
169093: TYPE t_array_source_36 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
169094: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
169095: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
169096: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
169097: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
169098: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
169099: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
169100: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 169097: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

169093: TYPE t_array_source_36 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
169094: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
169095: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
169096: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
169097: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
169098: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
169099: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
169100: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
169101: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 169098: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

169094: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
169095: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
169096: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
169097: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
169098: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
169099: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
169100: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
169101: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
169102: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 169099: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

169095: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
169096: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
169097: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
169098: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
169099: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
169100: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
169101: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
169102: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
169103: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 169100: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

169096: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
169097: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
169098: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
169099: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
169100: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
169101: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
169102: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
169103: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
169104: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 169101: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

169097: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
169098: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
169099: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
169100: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
169101: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
169102: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
169103: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
169104: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
169105: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 169102: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

169098: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
169099: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
169100: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
169101: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
169102: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
169103: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
169104: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
169105: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
169106:

Line 169103: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

169099: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
169100: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
169101: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
169102: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
169103: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
169104: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
169105: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
169106:
169107: TYPE t_array_source_25 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 169104: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

169100: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
169101: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
169102: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
169103: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
169104: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
169105: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
169106:
169107: TYPE t_array_source_25 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
169108: TYPE t_array_source_31 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 169105: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

169101: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
169102: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
169103: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
169104: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
169105: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
169106:
169107: TYPE t_array_source_25 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
169108: TYPE t_array_source_31 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
169109: TYPE t_array_source_33 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 169273: , AP_INVOICE_EXTRACT_HEADER_V h1

169269: , h1.INV_DOC_SEQUENCE_CATEGORY source_171
169270: , h1.INV_DOC_SEQUENCE_IDENTIFIER source_172
169271: , h1.INV_DOC_SEQUENCE_VALUE source_173
169272: FROM xla_events_gt xet
169273: , AP_INVOICE_EXTRACT_HEADER_V h1
169274: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
169275: , fnd_lookup_values fvl10
169276: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
169277: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 170854: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

170850: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170851: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170852: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170853: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170854: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170855: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170856: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170857: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170858: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 170856: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

170852: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170853: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170854: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170855: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170856: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170857: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170858: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170859: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170860: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 170857: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

170853: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170854: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170855: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170856: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170857: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170858: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170859: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170860: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170861: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 170858: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

170854: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170855: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170856: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170857: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170858: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170859: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170860: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170861: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170862: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 170859: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

170855: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
170856: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170857: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170858: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170859: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170860: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170861: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170862: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170863: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 170860: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

170856: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170857: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170858: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170859: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170860: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170861: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170862: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170863: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170864: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 170861: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

170857: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170858: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170859: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170860: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170861: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170862: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170863: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170864: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170865: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 170862: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

170858: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170859: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170860: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170861: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170862: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170863: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170864: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170865: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170866: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 170863: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

170859: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170860: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170861: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170862: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170863: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170864: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170865: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170866: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170867:

Line 170864: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

170860: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170861: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170862: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170863: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170864: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170865: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170866: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170867:
170868: ELSE null

Line 170865: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

170861: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170862: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170863: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170864: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170865: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170866: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170867:
170868: ELSE null
170869: END object_name

Line 170866: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

170862: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170863: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170864: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170865: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170866: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
170867:
170868: ELSE null
170869: END object_name
170870: , CASE r

Line 170963: , AP_INVOICE_EXTRACT_HEADER_V h2

170959:
170960: ELSE null
170961: END source_meaning
170962: FROM xla_events_gt xet
170963: , AP_INVOICE_EXTRACT_HEADER_V h2
170964: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
170965: , fnd_lookup_values fvl10
170966: , fnd_lookup_values fvl26
170967: , fnd_lookup_values fvl43

Line 171476: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;

171472: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
171473: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
171474: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
171475: TYPE t_array_source_26 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
171476: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
171477: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
171478: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
171479: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
171480: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 171478: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

171474: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
171475: TYPE t_array_source_26 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
171476: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
171477: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
171478: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
171479: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
171480: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
171481: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
171482: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 171479: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

171475: TYPE t_array_source_26 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
171476: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
171477: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
171478: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
171479: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
171480: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
171481: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
171482: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
171483: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 171480: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

171476: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
171477: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
171478: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
171479: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
171480: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
171481: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
171482: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
171483: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
171484: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 171481: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

171477: TYPE t_array_source_43 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
171478: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
171479: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
171480: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
171481: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
171482: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
171483: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
171484: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
171485: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 171482: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

171478: TYPE t_array_source_63 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
171479: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
171480: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
171481: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
171482: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
171483: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
171484: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
171485: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
171486: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 171483: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

171479: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
171480: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
171481: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
171482: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
171483: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
171484: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
171485: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
171486: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
171487: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 171484: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

171480: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
171481: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
171482: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
171483: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
171484: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
171485: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
171486: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
171487: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
171488: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 171485: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

171481: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
171482: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
171483: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
171484: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
171485: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
171486: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
171487: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
171488: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
171489:

Line 171486: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

171482: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
171483: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
171484: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
171485: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
171486: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
171487: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
171488: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
171489:
171490: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 171487: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

171483: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
171484: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
171485: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
171486: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
171487: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
171488: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
171489:
171490: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
171491: TYPE t_array_source_16 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 171488: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

171484: TYPE t_array_source_147 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
171485: TYPE t_array_source_148 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
171486: TYPE t_array_source_171 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
171487: TYPE t_array_source_172 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
171488: TYPE t_array_source_173 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
171489:
171490: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
171491: TYPE t_array_source_16 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
171492: TYPE t_array_source_17 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 171657: , AP_INVOICE_EXTRACT_HEADER_V h2

171653: , h2.INV_DOC_SEQUENCE_CATEGORY source_171
171654: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_172
171655: , h2.INV_DOC_SEQUENCE_VALUE source_173
171656: FROM xla_events_gt xet
171657: , AP_INVOICE_EXTRACT_HEADER_V h2
171658: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
171659: , fnd_lookup_values fvl10
171660: , fnd_lookup_values fvl26
171661: , fnd_lookup_values fvl43