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

Line 143976: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143972: FROM (
143973: SELECT xet.event_id event_id
143974: , 0 line_number
143975: , CASE r
143976: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143977: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143978: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143979: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143980: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 143977: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143973: SELECT xet.event_id event_id
143974: , 0 line_number
143975: , CASE r
143976: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143977: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143978: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143979: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143980: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143981: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 143978: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143974: , 0 line_number
143975: , CASE r
143976: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143977: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143978: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143979: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143980: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143981: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143982: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 143979: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143975: , CASE r
143976: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143977: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143978: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143979: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143980: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143981: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143982: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143983: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 143980: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143976: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143977: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143978: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143979: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143980: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143981: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143982: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143983: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143984: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 143981: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143977: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143978: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143979: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143980: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143981: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143982: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143983: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143984: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143985: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 143985: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143981: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143982: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143983: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143984: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143985: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143986: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143987: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143988: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143989: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 143988: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143984: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143985: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143986: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143987: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143988: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143989: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143990: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143991: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143992: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 143989: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143985: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143986: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143987: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143988: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143989: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143990: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143991: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143992: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143993: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 143990: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143986: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143987: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143988: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143989: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143990: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143991: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143992: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143993: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143994: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 143991: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143987: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143988: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143989: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143990: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143991: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143992: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143993: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143994: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143995: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 143992: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143988: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143989: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143990: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143991: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143992: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143993: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143994: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143995: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143996: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 143993: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143989: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143990: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143991: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143992: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143993: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143994: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143995: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143996: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143997: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 143994: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143990: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143991: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143992: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143993: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143994: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143995: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143996: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143997: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143998:

Line 143995: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143991: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143992: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143993: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143994: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143995: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143996: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143997: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143998:
143999: ELSE null

Line 143996: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143992: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143993: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143994: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143995: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143996: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143997: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143998:
143999: ELSE null
144000: END object_name

Line 143997: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143993: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143994: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143995: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143996: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143997: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143998:
143999: ELSE null
144000: END object_name
144001: , CASE r

Line 144114: , AP_INVOICE_EXTRACT_HEADER_V h2

144110:
144111: ELSE null
144112: END source_meaning
144113: FROM xla_events_gt xet
144114: , AP_INVOICE_EXTRACT_HEADER_V h2
144115: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
144116: , fnd_lookup_values fvl15
144117: , fnd_lookup_values fvl47
144118: , fnd_lookup_values fvl165

Line 144632: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;

144628: --
144629: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
144630: --
144631:
144632: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
144633: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
144634: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
144635: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
144636: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 144633: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;

144629: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
144630: --
144631:
144632: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
144633: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
144634: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
144635: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
144636: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
144637: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 144634: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

144630: --
144631:
144632: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
144633: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
144634: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
144635: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
144636: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
144637: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
144638: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 144635: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;

144631:
144632: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
144633: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
144634: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
144635: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
144636: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
144637: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
144638: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
144639: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 144636: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

144632: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
144633: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
144634: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
144635: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
144636: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
144637: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
144638: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
144639: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
144640: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 144637: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

144633: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
144634: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
144635: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
144636: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
144637: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
144638: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
144639: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
144640: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
144641: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 144641: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;

144637: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
144638: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
144639: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
144640: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
144641: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
144642: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
144643: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
144644: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
144645: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 144644: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

144640: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
144641: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
144642: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
144643: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
144644: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
144645: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
144646: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
144647: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
144648: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 144645: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

144641: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
144642: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
144643: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
144644: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
144645: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
144646: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
144647: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
144648: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
144649: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 144646: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

144642: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
144643: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
144644: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
144645: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
144646: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
144647: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
144648: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
144649: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
144650: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 144647: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

144643: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
144644: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
144645: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
144646: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
144647: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
144648: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
144649: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
144650: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
144651: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 144648: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

144644: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
144645: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
144646: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
144647: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
144648: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
144649: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
144650: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
144651: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
144652: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 144649: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

144645: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
144646: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
144647: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
144648: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
144649: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
144650: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
144651: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
144652: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
144653: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 144650: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

144646: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
144647: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
144648: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
144649: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
144650: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
144651: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
144652: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
144653: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
144654:

Line 144651: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

144647: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
144648: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
144649: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
144650: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
144651: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
144652: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
144653: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
144654:
144655: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 144652: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

144648: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
144649: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
144650: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
144651: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
144652: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
144653: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
144654:
144655: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
144656: TYPE t_array_source_21 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 144653: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

144649: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
144650: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
144651: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
144652: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
144653: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
144654:
144655: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
144656: TYPE t_array_source_21 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
144657: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 144837: , AP_INVOICE_EXTRACT_HEADER_V h2

144833: , h2.AI_INVOICE_TYPE_LOOKUP_CODE source_165
144834: , fvl165.meaning source_165_meaning
144835: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
144836: FROM xla_events_gt xet
144837: , AP_INVOICE_EXTRACT_HEADER_V h2
144838: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
144839: , fnd_lookup_values fvl15
144840: , fnd_lookup_values fvl47
144841: , fnd_lookup_values fvl165

Line 147276: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147272: FROM (
147273: SELECT xet.event_id event_id
147274: , 0 line_number
147275: , CASE r
147276: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147277: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147278: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147279: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147280: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 147277: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147273: SELECT xet.event_id event_id
147274: , 0 line_number
147275: , CASE r
147276: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147277: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147278: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147279: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147280: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147281: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 147278: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147274: , 0 line_number
147275: , CASE r
147276: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147277: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147278: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147279: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147280: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147281: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147282: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 147279: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147275: , CASE r
147276: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147277: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147278: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147279: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147280: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147281: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147282: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147283: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 147280: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147276: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147277: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147278: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147279: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147280: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147281: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147282: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147283: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147284: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 147281: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147277: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147278: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147279: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147280: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147281: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147282: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147283: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147284: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147285: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 147285: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147281: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147282: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147283: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147284: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147285: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147286: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147287: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147288: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147289: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 147288: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147284: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147285: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147286: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147287: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147288: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147289: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147290: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147291: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147292: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 147289: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147285: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147286: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147287: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147288: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147289: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147290: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147291: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147292: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147293: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 147290: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147286: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147287: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147288: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147289: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147290: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147291: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147292: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147293: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147294: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 147291: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147287: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147288: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147289: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147290: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147291: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147292: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147293: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147294: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147295: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 147292: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147288: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147289: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147290: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147291: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147292: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147293: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147294: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147295: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147296: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 147293: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147289: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147290: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147291: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147292: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147293: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147294: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147295: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147296: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147297:

Line 147294: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147290: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147291: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147292: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147293: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147294: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147295: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147296: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147297:
147298: ELSE null

Line 147295: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147291: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147292: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147293: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147294: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147295: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147296: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147297:
147298: ELSE null
147299: END object_name

Line 147296: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147292: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147293: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147294: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147295: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147296: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147297:
147298: ELSE null
147299: END object_name
147300: , CASE r

Line 147408: , AP_INVOICE_EXTRACT_HEADER_V h2

147404:
147405: ELSE null
147406: END source_meaning
147407: FROM xla_events_gt xet
147408: , AP_INVOICE_EXTRACT_HEADER_V h2
147409: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
147410: , fnd_lookup_values fvl15
147411: , fnd_lookup_values fvl47
147412: ,(select rownum r from all_objects where rownum <= 21 and owner = p_apps_owner)

Line 147916: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;

147912: --
147913: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
147914: --
147915:
147916: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
147917: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
147918: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
147919: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
147920: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 147917: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;

147913: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
147914: --
147915:
147916: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
147917: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
147918: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
147919: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
147920: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
147921: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 147918: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

147914: --
147915:
147916: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
147917: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
147918: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
147919: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
147920: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
147921: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
147922: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 147919: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;

147915:
147916: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
147917: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
147918: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
147919: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
147920: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
147921: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
147922: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
147923: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 147920: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

147916: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
147917: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
147918: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
147919: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
147920: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
147921: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
147922: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
147923: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
147924: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 147921: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

147917: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
147918: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
147919: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
147920: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
147921: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
147922: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
147923: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
147924: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
147925: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 147925: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;

147921: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
147922: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
147923: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
147924: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
147925: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
147926: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
147927: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
147928: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
147929: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 147928: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

147924: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
147925: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
147926: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
147927: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
147928: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
147929: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
147930: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
147931: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
147932: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 147929: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

147925: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
147926: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
147927: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
147928: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
147929: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
147930: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
147931: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
147932: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
147933: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 147930: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

147926: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
147927: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
147928: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
147929: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
147930: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
147931: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
147932: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
147933: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
147934: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 147931: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

147927: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
147928: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
147929: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
147930: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
147931: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
147932: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
147933: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
147934: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
147935: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 147932: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

147928: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
147929: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
147930: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
147931: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
147932: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
147933: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
147934: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
147935: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
147936: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 147933: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

147929: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
147930: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
147931: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
147932: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
147933: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
147934: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
147935: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
147936: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
147937:

Line 147934: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

147930: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
147931: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
147932: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
147933: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
147934: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
147935: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
147936: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
147937:
147938: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 147935: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

147931: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
147932: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
147933: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
147934: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
147935: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
147936: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
147937:
147938: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
147939: TYPE t_array_source_21 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 147936: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

147932: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
147933: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
147934: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
147935: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
147936: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
147937:
147938: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
147939: TYPE t_array_source_21 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
147940: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 148114: , AP_INVOICE_EXTRACT_HEADER_V h2

148110: , h2.INV_EXCHANGE_RATE source_144
148111: , h2.INV_EXCHANGE_RATE_TYPE source_145
148112: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
148113: FROM xla_events_gt xet
148114: , AP_INVOICE_EXTRACT_HEADER_V h2
148115: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
148116: , fnd_lookup_values fvl15
148117: , fnd_lookup_values fvl47
148118: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 152891: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152887: FROM (
152888: SELECT xet.event_id event_id
152889: , 0 line_number
152890: , CASE r
152891: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152892: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152893: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152894: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152895: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152892: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152888: SELECT xet.event_id event_id
152889: , 0 line_number
152890: , CASE r
152891: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152892: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152893: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152894: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152895: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152896: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152893: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152889: , 0 line_number
152890: , CASE r
152891: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152892: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152893: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152894: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152895: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152896: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152897: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 152894: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152890: , CASE r
152891: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152892: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152893: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152894: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152895: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152896: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152897: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152898: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 152895: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152891: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152892: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152893: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152894: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152895: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152896: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152897: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152898: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152899: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 152896: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152892: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152893: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152894: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152895: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152896: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152897: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152898: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152899: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152900: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152900: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152896: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152897: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152898: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152899: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152900: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152901: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152902: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152903: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152904: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152903: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152899: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152900: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152901: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152902: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152903: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152904: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152905: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152906: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152907: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152904: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152900: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152901: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152902: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152903: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152904: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152905: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152906: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152907: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152908: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152905: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152901: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152902: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152903: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152904: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152905: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152906: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152907: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152908: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152909: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152906: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152902: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152903: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152904: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152905: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152906: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152907: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152908: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152909: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152910: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152907: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152903: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152904: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152905: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152906: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152907: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152908: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152909: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152910: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152911: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152908: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152904: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152905: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152906: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152907: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152908: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152909: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152910: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152911: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152912: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152909: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152905: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152906: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152907: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152908: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152909: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152910: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152911: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152912: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152913:

Line 152910: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152906: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152907: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152908: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152909: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152910: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152911: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152912: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152913:
152914: ELSE null

Line 152911: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152907: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152908: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152909: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152910: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152911: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152912: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152913:
152914: ELSE null
152915: END object_name

Line 152912: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152908: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152909: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152910: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152911: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152912: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152913:
152914: ELSE null
152915: END object_name
152916: , CASE r

Line 153029: , AP_INVOICE_EXTRACT_HEADER_V h2

153025:
153026: ELSE null
153027: END source_meaning
153028: FROM xla_events_gt xet
153029: , AP_INVOICE_EXTRACT_HEADER_V h2
153030: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
153031: , fnd_lookup_values fvl15
153032: , fnd_lookup_values fvl47
153033: , fnd_lookup_values fvl165

Line 153557: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;

153553: --
153554: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
153555: --
153556:
153557: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
153558: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
153559: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
153560: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
153561: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 153558: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;

153554: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
153555: --
153556:
153557: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
153558: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
153559: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
153560: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
153561: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
153562: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 153559: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

153555: --
153556:
153557: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
153558: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
153559: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
153560: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
153561: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
153562: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
153563: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 153560: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;

153556:
153557: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
153558: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
153559: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
153560: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
153561: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
153562: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
153563: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
153564: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 153561: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

153557: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
153558: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
153559: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
153560: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
153561: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
153562: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
153563: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
153564: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
153565: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 153562: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

153558: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
153559: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
153560: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
153561: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
153562: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
153563: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
153564: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
153565: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
153566: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 153566: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;

153562: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
153563: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
153564: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
153565: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
153566: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
153567: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
153568: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
153569: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
153570: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 153569: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

153565: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
153566: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
153567: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
153568: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
153569: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
153570: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
153571: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
153572: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
153573: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 153570: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

153566: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
153567: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
153568: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
153569: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
153570: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
153571: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
153572: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
153573: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
153574: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 153571: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

153567: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
153568: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
153569: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
153570: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
153571: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
153572: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
153573: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
153574: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
153575: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 153572: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

153568: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
153569: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
153570: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
153571: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
153572: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
153573: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
153574: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
153575: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
153576: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 153573: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

153569: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
153570: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
153571: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
153572: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
153573: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
153574: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
153575: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
153576: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
153577: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 153574: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

153570: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
153571: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
153572: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
153573: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
153574: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
153575: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
153576: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
153577: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
153578: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 153575: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

153571: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
153572: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
153573: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
153574: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
153575: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
153576: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
153577: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
153578: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
153579:

Line 153576: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

153572: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
153573: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
153574: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
153575: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
153576: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
153577: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
153578: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
153579:
153580: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 153577: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

153573: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
153574: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
153575: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
153576: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
153577: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
153578: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
153579:
153580: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
153581: TYPE t_array_source_21 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 153578: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

153574: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
153575: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
153576: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
153577: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
153578: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
153579:
153580: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
153581: TYPE t_array_source_21 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
153582: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 153766: , AP_INVOICE_EXTRACT_HEADER_V h2

153762: , h2.AI_INVOICE_TYPE_LOOKUP_CODE source_165
153763: , fvl165.meaning source_165_meaning
153764: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
153765: FROM xla_events_gt xet
153766: , AP_INVOICE_EXTRACT_HEADER_V h2
153767: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
153768: , fnd_lookup_values fvl15
153769: , fnd_lookup_values fvl47
153770: , fnd_lookup_values fvl165

Line 159431: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

159427: FROM (
159428: SELECT xet.event_id event_id
159429: , 0 line_number
159430: , CASE r
159431: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159432: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159433: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159434: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159435: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 159432: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

159428: SELECT xet.event_id event_id
159429: , 0 line_number
159430: , CASE r
159431: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159432: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159433: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159434: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159435: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159436: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 159433: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

159429: , 0 line_number
159430: , CASE r
159431: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159432: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159433: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159434: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159435: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159436: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159437: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 159434: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

159430: , CASE r
159431: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159432: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159433: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159434: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159435: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159436: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159437: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159438: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 159435: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

159431: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159432: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159433: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159434: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159435: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159436: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159437: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159438: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159439: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 159436: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

159432: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159433: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159434: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159435: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159436: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159437: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159438: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159439: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159440: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 159442: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

159438: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159439: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159440: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159441: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159442: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159443: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159444: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159445: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159446: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 159443: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

159439: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159440: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159441: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159442: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159443: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159444: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159445: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159446: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159447: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 159444: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

159440: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159441: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159442: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159443: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159444: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159445: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159446: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159447: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159448: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 159445: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

159441: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159442: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159443: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159444: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159445: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159446: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159447: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159448: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159449: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 159446: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

159442: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159443: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159444: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159445: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159446: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159447: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159448: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159449: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159450: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 159447: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

159443: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159444: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159445: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159446: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159447: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159448: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159449: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159450: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159451:

Line 159448: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

159444: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159445: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159446: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159447: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159448: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159449: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159450: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159451:
159452: ELSE null

Line 159449: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

159445: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159446: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159447: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159448: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159449: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159450: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159451:
159452: ELSE null
159453: END object_name

Line 159450: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

159446: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159447: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159448: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159449: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159450: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159451:
159452: ELSE null
159453: END object_name
159454: , CASE r

Line 159557: , AP_INVOICE_EXTRACT_HEADER_V h1

159553:
159554: ELSE null
159555: END source_meaning
159556: FROM xla_events_gt xet
159557: , AP_INVOICE_EXTRACT_HEADER_V h1
159558: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
159559: , fnd_lookup_values fvl15
159560: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
159561: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 160058: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;

160054: --
160055: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
160056: --
160057:
160058: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
160059: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
160060: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
160061: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
160062: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 160059: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;

160055: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
160056: --
160057:
160058: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
160059: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
160060: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
160061: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
160062: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
160063: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 160060: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

160056: --
160057:
160058: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
160059: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
160060: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
160061: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
160062: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
160063: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
160064: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 160061: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;

160057:
160058: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
160059: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
160060: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
160061: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
160062: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
160063: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
160064: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
160065: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 160062: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

160058: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
160059: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
160060: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
160061: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
160062: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
160063: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
160064: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
160065: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
160066: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 160063: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

160059: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
160060: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
160061: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
160062: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
160063: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
160064: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
160065: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
160066: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
160067: TYPE t_array_source_41 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 160069: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

160065: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
160066: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
160067: TYPE t_array_source_41 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
160068: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
160069: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
160070: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
160071: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
160072: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
160073: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 160070: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

160066: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
160067: TYPE t_array_source_41 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
160068: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
160069: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
160070: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
160071: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
160072: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
160073: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
160074: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 160071: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

160067: TYPE t_array_source_41 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
160068: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
160069: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
160070: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
160071: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
160072: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
160073: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
160074: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
160075: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 160072: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

160068: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
160069: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
160070: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
160071: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
160072: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
160073: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
160074: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
160075: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
160076: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 160073: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

160069: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
160070: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
160071: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
160072: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
160073: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
160074: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
160075: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
160076: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
160077: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 160074: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

160070: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
160071: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
160072: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
160073: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
160074: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
160075: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
160076: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
160077: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
160078:

Line 160075: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

160071: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
160072: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
160073: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
160074: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
160075: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
160076: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
160077: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
160078:
160079: TYPE t_array_source_30 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 160076: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

160072: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
160073: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
160074: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
160075: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
160076: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
160077: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
160078:
160079: TYPE t_array_source_30 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
160080: TYPE t_array_source_36 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 160077: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

160073: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
160074: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
160075: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
160076: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
160077: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
160078:
160079: TYPE t_array_source_30 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
160080: TYPE t_array_source_36 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
160081: TYPE t_array_source_38 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 160253: , AP_INVOICE_EXTRACT_HEADER_V h1

160249: , h1.INV_EXCHANGE_RATE source_144
160250: , h1.INV_EXCHANGE_RATE_TYPE source_145
160251: , h1.INV_DOC_SEQUENCE_IDENTIFIER source_168
160252: FROM xla_events_gt xet
160253: , AP_INVOICE_EXTRACT_HEADER_V h1
160254: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
160255: , fnd_lookup_values fvl15
160256: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
160257: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 161852: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161848: FROM (
161849: SELECT xet.event_id event_id
161850: , 0 line_number
161851: , CASE r
161852: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161853: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161854: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161855: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161856: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161853: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161849: SELECT xet.event_id event_id
161850: , 0 line_number
161851: , CASE r
161852: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161853: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161854: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161855: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161856: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161857: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161854: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161850: , 0 line_number
161851: , CASE r
161852: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161853: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161854: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161855: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161856: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161857: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161858: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 161855: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161851: , CASE r
161852: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161853: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161854: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161855: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161856: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161857: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161858: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161859: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 161856: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161852: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161853: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161854: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161855: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161856: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161857: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161858: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161859: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161860: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 161857: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161853: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161854: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161855: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161856: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161857: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161858: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161859: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161860: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161861: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 161862: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161858: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161859: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161860: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161861: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161862: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161863: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161864: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161865: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161866: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161864: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161860: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161861: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161862: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161863: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161864: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161865: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161866: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161867: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161868: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161865: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161861: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161862: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161863: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161864: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161865: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161866: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161867: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161868: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161869: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161866: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161862: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161863: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161864: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161865: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161866: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161867: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161868: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161869: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161870: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161867: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161863: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161864: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161865: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161866: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161867: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161868: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161869: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161870: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161871: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161868: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161864: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161865: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161866: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161867: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161868: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161869: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161870: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161871: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161872: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161869: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161865: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161866: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161867: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161868: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161869: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161870: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161871: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161872: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161873:

Line 161870: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161866: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161867: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161868: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161869: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161870: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161871: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161872: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161873:
161874: ELSE null

Line 161871: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161867: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161868: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161869: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161870: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161871: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161872: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161873:
161874: ELSE null
161875: END object_name

Line 161872: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161868: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161869: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161870: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161871: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161872: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161873:
161874: ELSE null
161875: END object_name
161876: , CASE r

Line 161985: , AP_INVOICE_EXTRACT_HEADER_V h2

161981:
161982: ELSE null
161983: END source_meaning
161984: FROM xla_events_gt xet
161985: , AP_INVOICE_EXTRACT_HEADER_V h2
161986: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
161987: , fnd_lookup_values fvl15
161988: , fnd_lookup_values fvl31
161989: , fnd_lookup_values fvl47

Line 162494: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;

162490: --
162491: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
162492: --
162493:
162494: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
162495: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
162496: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
162497: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
162498: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 162495: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;

162491: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
162492: --
162493:
162494: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
162495: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
162496: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
162497: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
162498: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
162499: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 162496: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

162492: --
162493:
162494: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
162495: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
162496: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
162497: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
162498: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
162499: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
162500: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 162497: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;

162493:
162494: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
162495: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
162496: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
162497: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
162498: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
162499: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
162500: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
162501: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 162498: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

162494: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
162495: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
162496: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
162497: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
162498: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
162499: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
162500: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
162501: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
162502: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 162499: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

162495: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
162496: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
162497: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
162498: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
162499: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
162500: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
162501: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
162502: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
162503: TYPE t_array_source_31 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 162504: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;

162500: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
162501: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
162502: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
162503: TYPE t_array_source_31 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
162504: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
162505: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
162506: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
162507: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162508: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 162506: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

162502: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
162503: TYPE t_array_source_31 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
162504: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
162505: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
162506: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
162507: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162508: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
162509: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
162510: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 162507: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

162503: TYPE t_array_source_31 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
162504: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
162505: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
162506: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
162507: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162508: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
162509: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
162510: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
162511: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 162508: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

162504: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
162505: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
162506: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
162507: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162508: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
162509: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
162510: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
162511: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
162512: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 162509: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

162505: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
162506: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
162507: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162508: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
162509: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
162510: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
162511: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
162512: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
162513: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 162510: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

162506: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
162507: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162508: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
162509: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
162510: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
162511: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
162512: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
162513: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
162514: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 162511: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

162507: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162508: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
162509: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
162510: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
162511: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
162512: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
162513: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
162514: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
162515:

Line 162512: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

162508: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
162509: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
162510: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
162511: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
162512: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
162513: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
162514: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
162515:
162516: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 162513: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

162509: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
162510: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
162511: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
162512: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
162513: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
162514: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
162515:
162516: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
162517: TYPE t_array_source_21 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 162514: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

162510: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
162511: TYPE t_array_source_143 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
162512: TYPE t_array_source_144 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
162513: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
162514: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
162515:
162516: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
162517: TYPE t_array_source_21 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
162518: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 162691: , AP_INVOICE_EXTRACT_HEADER_V h2

162687: , h2.INV_EXCHANGE_RATE source_144
162688: , h2.INV_EXCHANGE_RATE_TYPE source_145
162689: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
162690: FROM xla_events_gt xet
162691: , AP_INVOICE_EXTRACT_HEADER_V h2
162692: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
162693: , fnd_lookup_values fvl15
162694: , fnd_lookup_values fvl31
162695: , fnd_lookup_values fvl47