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

Line 65243: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

65239: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65240: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65241: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65242: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65243: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65244: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65245: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65246: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65247: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 65244: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

65240: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65241: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65242: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65243: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65244: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65245: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65246: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65247: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65248: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 65245: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

65241: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65242: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65243: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65244: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65245: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65246: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65247: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65248: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65249: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 65246: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

65242: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65243: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65244: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65245: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65246: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65247: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65248: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65249: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65250: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 65247: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

65243: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65244: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65245: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65246: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65247: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65248: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65249: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65250: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65251: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 65248: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

65244: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65245: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65246: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65247: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65248: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65249: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65250: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65251: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65252: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 65249: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

65245: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65246: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65247: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65248: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65249: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65250: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65251: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65252: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65253: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 65250: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

65246: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65247: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65248: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65249: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65250: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65251: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65252: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65253: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65254:

Line 65251: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

65247: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65248: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65249: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65250: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65251: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65252: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65253: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65254:
65255: ELSE null

Line 65252: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

65248: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65249: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65250: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65251: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65252: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65253: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65254:
65255: ELSE null
65256: END object_name

Line 65253: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

65249: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65250: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65251: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65252: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65253: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65254:
65255: ELSE null
65256: END object_name
65257: , CASE r

Line 65346: , AP_INVOICE_EXTRACT_HEADER_V h2

65342:
65343: ELSE null
65344: END source_meaning
65345: FROM xla_events_gt xet
65346: , AP_INVOICE_EXTRACT_HEADER_V h2
65347: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
65348: , fnd_lookup_values fvl7
65349: , fnd_lookup_values fvl12
65350: , fnd_lookup_values fvl17

Line 65868: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

65864: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
65865: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
65866: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
65867: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
65868: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
65869: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
65870: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
65871: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
65872: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 65869: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

65865: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
65866: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
65867: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
65868: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
65869: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
65870: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
65871: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
65872: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
65873: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 65870: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

65866: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
65867: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
65868: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
65869: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
65870: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
65871: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
65872: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
65873: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
65874: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 65871: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

65867: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
65868: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
65869: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
65870: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
65871: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
65872: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
65873: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
65874: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
65875: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 65872: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

65868: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
65869: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
65870: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
65871: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
65872: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
65873: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
65874: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
65875: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
65876: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 65873: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

65869: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
65870: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
65871: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
65872: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
65873: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
65874: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
65875: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
65876: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
65877: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 65874: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

65870: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
65871: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
65872: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
65873: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
65874: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
65875: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
65876: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
65877: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
65878: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 65875: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

65871: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
65872: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
65873: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
65874: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
65875: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
65876: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
65877: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
65878: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
65879:

Line 65876: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

65872: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
65873: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
65874: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
65875: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
65876: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
65877: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
65878: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
65879:
65880: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 65877: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

65873: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
65874: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
65875: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
65876: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
65877: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
65878: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
65879:
65880: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
65881: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 65878: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

65874: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
65875: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
65876: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
65877: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
65878: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
65879:
65880: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
65881: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
65882: TYPE t_array_source_9 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 66050: , AP_INVOICE_EXTRACT_HEADER_V h2

66046: , h2.INV_DOC_SEQUENCE_CATEGORY source_122
66047: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_123
66048: , h2.INV_DOC_SEQUENCE_VALUE source_124
66049: FROM xla_events_gt xet
66050: , AP_INVOICE_EXTRACT_HEADER_V h2
66051: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
66052: , fnd_lookup_values fvl7
66053: , fnd_lookup_values fvl12
66054: , fnd_lookup_values fvl17

Line 68101: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

68097: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68098: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68099: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68100: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68101: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68102: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68103: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68104: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68105: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 68102: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

68098: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68099: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68100: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68101: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68102: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68103: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68104: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68105: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68106: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 68103: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

68099: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68100: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68101: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68102: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68103: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68104: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68105: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68106: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68107: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 68104: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

68100: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68101: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68102: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68103: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68104: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68105: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68106: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68107: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68108: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 68105: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

68101: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68102: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68103: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68104: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68105: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68106: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68107: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68108: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68109: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 68106: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

68102: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68103: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68104: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68105: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68106: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68107: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68108: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68109: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68110: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 68107: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

68103: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68104: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68105: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68106: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68107: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68108: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68109: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68110: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68111: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 68108: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

68104: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68105: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68106: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68107: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68108: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68109: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68110: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68111: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68112:

Line 68109: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

68105: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68106: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68107: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68108: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68109: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68110: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68111: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68112:
68113: ELSE null

Line 68110: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

68106: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68107: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68108: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68109: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68110: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68111: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68112:
68113: ELSE null
68114: END object_name

Line 68111: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

68107: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68108: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68109: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68110: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68111: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68112:
68113: ELSE null
68114: END object_name
68115: , CASE r

Line 68204: , AP_INVOICE_EXTRACT_HEADER_V h2

68200:
68201: ELSE null
68202: END source_meaning
68203: FROM xla_events_gt xet
68204: , AP_INVOICE_EXTRACT_HEADER_V h2
68205: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
68206: , fnd_lookup_values fvl7
68207: , fnd_lookup_values fvl12
68208: , fnd_lookup_values fvl17

Line 68721: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

68717: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
68718: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
68719: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
68720: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
68721: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
68722: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68723: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
68724: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
68725: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 68722: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

68718: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
68719: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
68720: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
68721: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
68722: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68723: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
68724: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
68725: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
68726: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 68723: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

68719: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
68720: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
68721: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
68722: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68723: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
68724: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
68725: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
68726: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
68727: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 68724: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

68720: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
68721: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
68722: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68723: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
68724: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
68725: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
68726: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
68727: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
68728: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 68725: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

68721: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
68722: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68723: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
68724: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
68725: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
68726: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
68727: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
68728: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68729: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 68726: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

68722: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68723: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
68724: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
68725: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
68726: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
68727: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
68728: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68729: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
68730: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 68727: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

68723: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
68724: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
68725: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
68726: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
68727: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
68728: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68729: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
68730: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
68731: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 68728: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

68724: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
68725: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
68726: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
68727: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
68728: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68729: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
68730: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
68731: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
68732:

Line 68729: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

68725: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
68726: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
68727: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
68728: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68729: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
68730: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
68731: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
68732:
68733: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 68730: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

68726: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
68727: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
68728: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68729: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
68730: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
68731: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
68732:
68733: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
68734: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 68731: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

68727: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
68728: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68729: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
68730: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
68731: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
68732:
68733: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
68734: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
68735: TYPE t_array_source_9 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 68901: , AP_INVOICE_EXTRACT_HEADER_V h2

68897: , h2.INV_DOC_SEQUENCE_CATEGORY source_122
68898: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_123
68899: , h2.INV_DOC_SEQUENCE_VALUE source_124
68900: FROM xla_events_gt xet
68901: , AP_INVOICE_EXTRACT_HEADER_V h2
68902: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
68903: , fnd_lookup_values fvl7
68904: , fnd_lookup_values fvl12
68905: , fnd_lookup_values fvl17

Line 70933: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

70929: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70930: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70931: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70932: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70933: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70934: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70935: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70936: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70937: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 70934: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

70930: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70931: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70932: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70933: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70934: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70935: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70936: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70937: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70938: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 70935: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

70931: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70932: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70933: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70934: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70935: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70936: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70937: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70938: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70939: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 70936: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

70932: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70933: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70934: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70935: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70936: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70937: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70938: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70939: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70940: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 70937: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

70933: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70934: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70935: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70936: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70937: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70938: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70939: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70940: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70941: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 70938: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

70934: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70935: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70936: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70937: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70938: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70939: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70940: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70941: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70942: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 70939: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

70935: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70936: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70937: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70938: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70939: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70940: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70941: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70942: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70943: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 70940: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

70936: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70937: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70938: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70939: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70940: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70941: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70942: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70943: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70944: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 70941: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

70937: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70938: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70939: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70940: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70941: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70942: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70943: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70944: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70945:

Line 70942: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

70938: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70939: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70940: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70941: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70942: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70943: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70944: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70945:
70946: ELSE null

Line 70943: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

70939: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70940: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70941: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70942: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70943: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70944: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70945:
70946: ELSE null
70947: END object_name

Line 70944: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

70940: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70941: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70942: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70943: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70944: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70945:
70946: ELSE null
70947: END object_name
70948: , CASE r

Line 71042: , AP_INVOICE_EXTRACT_HEADER_V h2

71038:
71039: ELSE null
71040: END source_meaning
71041: FROM xla_events_gt xet
71042: , AP_INVOICE_EXTRACT_HEADER_V h2
71043: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
71044: , fnd_lookup_values fvl7
71045: , fnd_lookup_values fvl12
71046: , fnd_lookup_values fvl17

Line 71574: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

71570: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
71571: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
71572: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
71573: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
71574: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
71575: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
71576: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
71577: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
71578: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 71575: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

71571: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
71572: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
71573: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
71574: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
71575: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
71576: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
71577: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
71578: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
71579: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 71576: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

71572: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
71573: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
71574: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
71575: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
71576: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
71577: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
71578: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
71579: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
71580: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 71577: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

71573: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
71574: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
71575: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
71576: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
71577: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
71578: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
71579: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
71580: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
71581: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 71578: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

71574: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
71575: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
71576: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
71577: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
71578: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
71579: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
71580: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
71581: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71582: TYPE t_array_source_68 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 71579: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

71575: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
71576: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
71577: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
71578: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
71579: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
71580: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
71581: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71582: TYPE t_array_source_68 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
71583: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 71580: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

71576: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
71577: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
71578: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
71579: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
71580: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
71581: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71582: TYPE t_array_source_68 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
71583: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
71584: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 71581: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

71577: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
71578: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
71579: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
71580: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
71581: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71582: TYPE t_array_source_68 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
71583: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
71584: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
71585: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 71582: TYPE t_array_source_68 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

71578: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
71579: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
71580: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
71581: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71582: TYPE t_array_source_68 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
71583: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
71584: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
71585: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
71586:

Line 71583: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

71579: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
71580: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
71581: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71582: TYPE t_array_source_68 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
71583: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
71584: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
71585: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
71586:
71587: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 71584: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

71580: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
71581: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71582: TYPE t_array_source_68 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
71583: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
71584: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
71585: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
71586:
71587: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
71588: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 71585: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

71581: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71582: TYPE t_array_source_68 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
71583: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
71584: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
71585: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
71586:
71587: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
71588: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
71589: TYPE t_array_source_9 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 71763: , AP_INVOICE_EXTRACT_HEADER_V h2

71759: , h2.INV_DOC_SEQUENCE_CATEGORY source_122
71760: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_123
71761: , h2.INV_DOC_SEQUENCE_VALUE source_124
71762: FROM xla_events_gt xet
71763: , AP_INVOICE_EXTRACT_HEADER_V h2
71764: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
71765: , fnd_lookup_values fvl7
71766: , fnd_lookup_values fvl12
71767: , fnd_lookup_values fvl17

Line 75774: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

75770: SELECT xet.event_id event_id
75771: , 0 line_number
75772: , CASE r
75773: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
75774: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75775: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75776: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75777: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75778: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 75775: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

75771: , 0 line_number
75772: , CASE r
75773: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
75774: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75775: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75776: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75777: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75778: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75779: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 75776: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

75772: , CASE r
75773: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
75774: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75775: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75776: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75777: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75778: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75779: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75780:

Line 75777: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

75773: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
75774: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75775: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75776: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75777: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75778: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75779: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75780:
75781: ELSE null

Line 75778: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

75774: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75775: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75776: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75777: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75778: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75779: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75780:
75781: ELSE null
75782: END object_name

Line 75779: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

75775: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75776: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75777: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75778: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75779: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75780:
75781: ELSE null
75782: END object_name
75783: , CASE r

Line 75834: , AP_INVOICE_EXTRACT_HEADER_V h1

75830:
75831: ELSE null
75832: END source_meaning
75833: FROM xla_events_gt xet
75834: , AP_INVOICE_EXTRACT_HEADER_V h1
75835: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
75836: , fnd_lookup_values fvl17
75837: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
75838: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 76258: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

76254: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
76255: --
76256:
76257: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
76258: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
76259: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76260: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76261: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76262: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 76259: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

76255: --
76256:
76257: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
76258: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
76259: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76260: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76261: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76262: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
76263: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 76260: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

76256:
76257: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
76258: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
76259: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76260: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76261: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76262: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
76263: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76264:

Line 76261: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

76257: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
76258: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
76259: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76260: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76261: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76262: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
76263: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76264:
76265: TYPE t_array_source_19 IS TABLE OF AP_PREPAYAPP_EXTRACT_DTLS_BC_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;

Line 76262: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

76258: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
76259: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76260: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76261: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76262: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
76263: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76264:
76265: TYPE t_array_source_19 IS TABLE OF AP_PREPAYAPP_EXTRACT_DTLS_BC_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
76266: TYPE t_array_source_21 IS TABLE OF AP_PREPAYAPP_EXTRACT_DTLS_BC_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 76263: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

76259: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76260: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76261: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76262: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
76263: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76264:
76265: TYPE t_array_source_19 IS TABLE OF AP_PREPAYAPP_EXTRACT_DTLS_BC_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
76266: TYPE t_array_source_21 IS TABLE OF AP_PREPAYAPP_EXTRACT_DTLS_BC_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
76267: TYPE t_array_source_25 IS TABLE OF AP_PREPAYAPP_EXTRACT_DTLS_BC_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;

Line 76385: , AP_INVOICE_EXTRACT_HEADER_V h1

76381: , h1.INV_DOC_SEQUENCE_CATEGORY source_122
76382: , h1.INV_DOC_SEQUENCE_IDENTIFIER source_123
76383: , h1.INV_DOC_SEQUENCE_VALUE source_124
76384: FROM xla_events_gt xet
76385: , AP_INVOICE_EXTRACT_HEADER_V h1
76386: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
76387: , fnd_lookup_values fvl17
76388: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
76389: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 77373: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

77369: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77370: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77371: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77372: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77373: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77374: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77375: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77376: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77377: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 77374: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

77370: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77371: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77372: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77373: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77374: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77375: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77376: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77377: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77378: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 77375: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

77371: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77372: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77373: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77374: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77375: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77376: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77377: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77378: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77379: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 77376: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

77372: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77373: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77374: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77375: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77376: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77377: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77378: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77379: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77380: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 77377: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

77373: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77374: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77375: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77376: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77377: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77378: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77379: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77380: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77381: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 77378: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

77374: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77375: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77376: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77377: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77378: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77379: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77380: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77381: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77382: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 77379: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

77375: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77376: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77377: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77378: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77379: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77380: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77381: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77382: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77383: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 77380: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

77376: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77377: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77378: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77379: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77380: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77381: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77382: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77383: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77384:

Line 77381: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

77377: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77378: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77379: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77380: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77381: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77382: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77383: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77384:
77385: ELSE null

Line 77382: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

77378: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77379: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77380: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77381: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77382: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77383: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77384:
77385: ELSE null
77386: END object_name

Line 77383: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

77379: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77380: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77381: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77382: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77383: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77384:
77385: ELSE null
77386: END object_name
77387: , CASE r

Line 77476: , AP_INVOICE_EXTRACT_HEADER_V h2

77472:
77473: ELSE null
77474: END source_meaning
77475: FROM xla_events_gt xet
77476: , AP_INVOICE_EXTRACT_HEADER_V h2
77477: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
77478: , fnd_lookup_values fvl7
77479: , fnd_lookup_values fvl12
77480: , fnd_lookup_values fvl17

Line 77998: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

77994: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
77995: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
77996: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
77997: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
77998: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
77999: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
78000: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
78001: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
78002: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 77999: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

77995: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
77996: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
77997: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
77998: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
77999: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
78000: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
78001: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
78002: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
78003: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 78000: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

77996: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
77997: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
77998: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
77999: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
78000: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
78001: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
78002: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
78003: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
78004: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 78001: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

77997: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
77998: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
77999: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
78000: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
78001: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
78002: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
78003: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
78004: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
78005: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 78002: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

77998: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
77999: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
78000: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
78001: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
78002: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
78003: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
78004: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
78005: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
78006: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 78003: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

77999: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
78000: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
78001: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
78002: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
78003: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
78004: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
78005: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
78006: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
78007: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 78004: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

78000: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
78001: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
78002: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
78003: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
78004: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
78005: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
78006: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
78007: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
78008: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 78005: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

78001: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
78002: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
78003: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
78004: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
78005: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
78006: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
78007: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
78008: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
78009:

Line 78006: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

78002: TYPE t_array_source_41 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
78003: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
78004: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
78005: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
78006: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
78007: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
78008: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
78009:
78010: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 78007: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

78003: TYPE t_array_source_47 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
78004: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
78005: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
78006: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
78007: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
78008: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
78009:
78010: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
78011: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 78008: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

78004: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
78005: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
78006: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
78007: TYPE t_array_source_123 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
78008: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
78009:
78010: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
78011: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
78012: TYPE t_array_source_9 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 78180: , AP_INVOICE_EXTRACT_HEADER_V h2

78176: , h2.INV_DOC_SEQUENCE_CATEGORY source_122
78177: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_123
78178: , h2.INV_DOC_SEQUENCE_VALUE source_124
78179: FROM xla_events_gt xet
78180: , AP_INVOICE_EXTRACT_HEADER_V h2
78181: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
78182: , fnd_lookup_values fvl7
78183: , fnd_lookup_values fvl12
78184: , fnd_lookup_values fvl17