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

Line 143841: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143837: FROM (
143838: SELECT xet.event_id event_id
143839: , 0 line_number
143840: , CASE r
143841: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143842: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143843: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143844: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143845: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 143842: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143838: SELECT xet.event_id event_id
143839: , 0 line_number
143840: , CASE r
143841: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143842: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143843: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143844: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143845: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143846: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 143843: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143839: , 0 line_number
143840: , CASE r
143841: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143842: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143843: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143844: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143845: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143846: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143847: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 143844: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143840: , CASE r
143841: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143842: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143843: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143844: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143845: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143846: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143847: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143848: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 143845: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143841: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143842: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143843: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143844: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143845: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143846: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143847: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143848: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143849: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 143846: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143842: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143843: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143844: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143845: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143846: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143847: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143848: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143849: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143850: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 143850: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143846: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143847: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143848: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143849: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143850: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143851: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143852: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143853: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143854: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 143853: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143849: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143850: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143851: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143852: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143853: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143854: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143855: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143856: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143857: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 143854: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143850: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143851: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143852: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143853: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143854: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143855: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143856: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143857: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143858: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 143855: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143851: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143852: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143853: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143854: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143855: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143856: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143857: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143858: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143859: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 143856: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143852: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143853: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143854: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143855: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143856: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143857: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143858: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143859: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143860: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 143857: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143853: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143854: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143855: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143856: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143857: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143858: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143859: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143860: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143861: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 143858: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143854: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143855: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143856: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143857: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143858: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143859: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143860: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143861: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143862: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 143859: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143855: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143856: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143857: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143858: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143859: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143860: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143861: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143862: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143863: WHEN 23 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 143860: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143856: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143857: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143858: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143859: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143860: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143861: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143862: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143863: WHEN 23 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143864:

Line 143861: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143857: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143858: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143859: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143860: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143861: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143862: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143863: WHEN 23 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143864:
143865: ELSE null

Line 143862: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143858: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143859: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143860: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143861: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143862: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143863: WHEN 23 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143864:
143865: ELSE null
143866: END object_name

Line 143863: WHEN 23 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

143859: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143860: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143861: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143862: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143863: WHEN 23 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143864:
143865: ELSE null
143866: END object_name
143867: , CASE r

Line 143984: , AP_INVOICE_EXTRACT_HEADER_V h2

143980:
143981: ELSE null
143982: END source_meaning
143983: FROM xla_events_gt xet
143984: , AP_INVOICE_EXTRACT_HEADER_V h2
143985: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
143986: , fnd_lookup_values fvl15
143987: , fnd_lookup_values fvl47
143988: , fnd_lookup_values fvl164

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

144503: --
144504: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
144505: --
144506:
144507: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
144508: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
144509: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
144510: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
144511: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

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

144504: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
144505: --
144506:
144507: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
144508: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
144509: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
144510: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
144511: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
144512: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

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

144505: --
144506:
144507: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
144508: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
144509: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
144510: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
144511: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
144512: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
144513: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

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

144506:
144507: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
144508: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
144509: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
144510: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
144511: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
144512: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
144513: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
144514: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

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

144507: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
144508: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
144509: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
144510: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
144511: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
144512: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
144513: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
144514: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
144515: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

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

144508: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
144509: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
144510: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
144511: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
144512: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
144513: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
144514: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
144515: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
144516: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;

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

144512: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
144513: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
144514: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
144515: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
144516: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
144517: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
144518: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
144519: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
144520: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 144519: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

144515: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
144516: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
144517: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
144518: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
144519: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
144520: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
144521: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
144522: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
144523: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 144520: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

144516: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
144517: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
144518: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
144519: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
144520: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
144521: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
144522: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
144523: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
144524: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 144521: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

144517: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
144518: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
144519: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
144520: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
144521: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
144522: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
144523: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
144524: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
144525: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 144522: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

144518: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
144519: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
144520: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
144521: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
144522: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
144523: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
144524: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
144525: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
144526: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 144523: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

144519: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
144520: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
144521: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
144522: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
144523: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
144524: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
144525: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
144526: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
144527: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;

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

144520: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
144521: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
144522: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
144523: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
144524: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
144525: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
144526: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
144527: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;
144528: TYPE t_array_source_164 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

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

144521: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
144522: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
144523: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
144524: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
144525: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
144526: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
144527: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;
144528: TYPE t_array_source_164 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
144529: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

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

144522: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
144523: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
144524: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
144525: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
144526: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
144527: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;
144528: TYPE t_array_source_164 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
144529: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
144530:

Line 144527: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;

144523: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
144524: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
144525: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
144526: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
144527: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;
144528: TYPE t_array_source_164 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
144529: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
144530:
144531: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 144528: TYPE t_array_source_164 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

144524: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
144525: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
144526: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
144527: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;
144528: TYPE t_array_source_164 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
144529: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
144530:
144531: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
144532: TYPE t_array_source_21 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

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

144525: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
144526: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
144527: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;
144528: TYPE t_array_source_164 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
144529: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
144530:
144531: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
144532: TYPE t_array_source_21 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
144533: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 144717: , AP_INVOICE_EXTRACT_HEADER_V h2

144713: , h2.AI_INVOICE_TYPE_LOOKUP_CODE source_164
144714: , fvl164.meaning source_164_meaning
144715: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
144716: FROM xla_events_gt xet
144717: , AP_INVOICE_EXTRACT_HEADER_V h2
144718: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
144719: , fnd_lookup_values fvl15
144720: , fnd_lookup_values fvl47
144721: , fnd_lookup_values fvl164

Line 147166: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147162: FROM (
147163: SELECT xet.event_id event_id
147164: , 0 line_number
147165: , CASE r
147166: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147167: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147168: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147169: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147170: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 147167: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147163: SELECT xet.event_id event_id
147164: , 0 line_number
147165: , CASE r
147166: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147167: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147168: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147169: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147170: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147171: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 147168: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147164: , 0 line_number
147165: , CASE r
147166: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147167: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147168: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147169: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147170: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147171: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147172: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 147169: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147165: , CASE r
147166: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147167: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147168: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147169: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147170: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147171: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147172: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147173: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 147170: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147166: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147167: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147168: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147169: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147170: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147171: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147172: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147173: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147174: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 147171: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147167: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147168: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147169: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147170: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147171: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147172: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147173: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147174: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147175: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 147175: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147171: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147172: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147173: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147174: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147175: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147176: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147177: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147178: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147179: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 147178: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147174: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147175: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147176: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147177: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147178: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147179: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147180: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147181: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147182: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 147179: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147175: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147176: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147177: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147178: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147179: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147180: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147181: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147182: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147183: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 147180: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147176: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147177: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147178: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147179: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147180: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147181: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147182: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147183: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147184: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 147181: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147177: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147178: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147179: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147180: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147181: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147182: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147183: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147184: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147185: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 147182: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147178: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147179: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147180: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147181: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147182: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147183: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147184: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147185: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147186: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 147183: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147179: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147180: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147181: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147182: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147183: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147184: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147185: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147186: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147187: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 147184: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147180: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147181: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147182: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147183: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147184: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147185: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147186: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147187: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147188:

Line 147185: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147181: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147182: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147183: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147184: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147185: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147186: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147187: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147188:
147189: ELSE null

Line 147186: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147182: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147183: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147184: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147185: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147186: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147187: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147188:
147189: ELSE null
147190: END object_name

Line 147187: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

147183: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147184: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147185: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147186: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147187: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147188:
147189: ELSE null
147190: END object_name
147191: , CASE r

Line 147303: , AP_INVOICE_EXTRACT_HEADER_V h2

147299:
147300: ELSE null
147301: END source_meaning
147302: FROM xla_events_gt xet
147303: , AP_INVOICE_EXTRACT_HEADER_V h2
147304: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
147305: , fnd_lookup_values fvl15
147306: , fnd_lookup_values fvl47
147307: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)

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

147812: --
147813: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
147814: --
147815:
147816: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
147817: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
147818: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
147819: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
147820: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

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

147813: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
147814: --
147815:
147816: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
147817: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
147818: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
147819: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
147820: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
147821: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

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

147814: --
147815:
147816: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
147817: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
147818: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
147819: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
147820: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
147821: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
147822: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

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

147815:
147816: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
147817: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
147818: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
147819: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
147820: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
147821: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
147822: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
147823: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

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

147816: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
147817: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
147818: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
147819: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
147820: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
147821: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
147822: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
147823: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
147824: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

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

147817: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
147818: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
147819: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
147820: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
147821: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
147822: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
147823: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
147824: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
147825: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;

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

147821: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
147822: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
147823: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
147824: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
147825: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
147826: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
147827: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
147828: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
147829: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 147828: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

147824: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
147825: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
147826: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
147827: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
147828: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
147829: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
147830: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
147831: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
147832: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 147829: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

147825: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
147826: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
147827: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
147828: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
147829: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
147830: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
147831: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
147832: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
147833: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 147830: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

147826: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
147827: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
147828: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
147829: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
147830: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
147831: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
147832: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
147833: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
147834: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 147831: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

147827: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
147828: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
147829: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
147830: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
147831: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
147832: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
147833: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
147834: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
147835: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 147832: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

147828: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
147829: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
147830: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
147831: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
147832: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
147833: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
147834: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
147835: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
147836: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;

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

147829: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
147830: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
147831: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
147832: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
147833: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
147834: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
147835: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
147836: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;
147837: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

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

147830: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
147831: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
147832: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
147833: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
147834: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
147835: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
147836: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;
147837: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
147838:

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

147831: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
147832: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
147833: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
147834: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
147835: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
147836: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;
147837: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
147838:
147839: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 147836: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;

147832: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
147833: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
147834: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
147835: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
147836: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;
147837: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
147838:
147839: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
147840: TYPE t_array_source_21 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

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

147833: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
147834: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
147835: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
147836: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;
147837: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
147838:
147839: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
147840: TYPE t_array_source_21 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
147841: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 148019: , AP_INVOICE_EXTRACT_HEADER_V h2

148015: , h2.INV_EXCHANGE_RATE_TYPE source_138
148016: , h2.AI_SOURCE source_163
148017: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
148018: FROM xla_events_gt xet
148019: , AP_INVOICE_EXTRACT_HEADER_V h2
148020: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
148021: , fnd_lookup_values fvl15
148022: , fnd_lookup_values fvl47
148023: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 152830: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152826: FROM (
152827: SELECT xet.event_id event_id
152828: , 0 line_number
152829: , CASE r
152830: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152831: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152832: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152833: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152834: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152831: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152827: SELECT xet.event_id event_id
152828: , 0 line_number
152829: , CASE r
152830: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152831: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152832: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152833: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152834: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152835: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152832: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152828: , 0 line_number
152829: , CASE r
152830: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152831: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152832: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152833: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152834: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152835: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152836: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 152833: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152829: , CASE r
152830: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152831: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152832: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152833: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152834: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152835: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152836: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152837: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 152834: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152830: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152831: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152832: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152833: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152834: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152835: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152836: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152837: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152838: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 152835: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152831: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152832: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152833: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152834: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152835: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152836: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152837: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152838: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152839: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152839: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152835: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152836: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152837: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152838: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152839: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152840: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152841: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152842: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152843: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152842: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152838: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152839: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152840: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152841: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152842: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152843: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152844: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152845: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152846: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152843: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152839: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152840: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152841: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152842: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152843: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152844: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152845: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152846: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152847: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152844: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152840: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152841: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152842: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152843: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152844: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152845: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152846: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152847: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152848: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152845: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152841: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152842: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152843: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152844: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152845: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152846: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152847: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152848: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152849: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152846: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152842: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152843: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152844: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152845: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152846: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152847: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152848: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152849: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152850: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152847: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152843: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152844: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152845: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152846: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152847: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152848: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152849: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152850: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152851: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152848: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152844: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152845: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152846: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152847: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152848: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152849: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152850: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152851: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152852: WHEN 23 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152849: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152845: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152846: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152847: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152848: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152849: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152850: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152851: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152852: WHEN 23 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152853:

Line 152850: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152846: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152847: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152848: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152849: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152850: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152851: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152852: WHEN 23 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152853:
152854: ELSE null

Line 152851: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152847: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152848: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152849: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152850: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152851: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152852: WHEN 23 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152853:
152854: ELSE null
152855: END object_name

Line 152852: WHEN 23 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

152848: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152849: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152850: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152851: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152852: WHEN 23 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152853:
152854: ELSE null
152855: END object_name
152856: , CASE r

Line 152973: , AP_INVOICE_EXTRACT_HEADER_V h2

152969:
152970: ELSE null
152971: END source_meaning
152972: FROM xla_events_gt xet
152973: , AP_INVOICE_EXTRACT_HEADER_V h2
152974: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
152975: , fnd_lookup_values fvl15
152976: , fnd_lookup_values fvl47
152977: , fnd_lookup_values fvl164

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

153502: --
153503: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
153504: --
153505:
153506: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
153507: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
153508: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
153509: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
153510: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

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

153503: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
153504: --
153505:
153506: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
153507: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
153508: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
153509: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
153510: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
153511: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

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

153504: --
153505:
153506: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
153507: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
153508: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
153509: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
153510: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
153511: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
153512: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

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

153505:
153506: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
153507: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
153508: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
153509: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
153510: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
153511: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
153512: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
153513: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

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

153506: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
153507: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
153508: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
153509: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
153510: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
153511: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
153512: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
153513: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
153514: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

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

153507: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
153508: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
153509: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
153510: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
153511: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
153512: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
153513: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
153514: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
153515: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;

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

153511: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
153512: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
153513: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
153514: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
153515: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
153516: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
153517: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
153518: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
153519: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 153518: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

153514: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
153515: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
153516: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
153517: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
153518: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
153519: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
153520: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
153521: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
153522: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 153519: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

153515: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
153516: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
153517: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
153518: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
153519: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
153520: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
153521: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
153522: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
153523: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 153520: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

153516: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
153517: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
153518: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
153519: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
153520: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
153521: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
153522: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
153523: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
153524: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 153521: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

153517: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
153518: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
153519: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
153520: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
153521: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
153522: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
153523: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
153524: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
153525: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 153522: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

153518: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
153519: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
153520: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
153521: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
153522: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
153523: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
153524: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
153525: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
153526: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;

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

153519: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
153520: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
153521: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
153522: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
153523: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
153524: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
153525: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
153526: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;
153527: TYPE t_array_source_164 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

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

153520: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
153521: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
153522: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
153523: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
153524: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
153525: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
153526: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;
153527: TYPE t_array_source_164 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
153528: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

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

153521: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
153522: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
153523: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
153524: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
153525: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
153526: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;
153527: TYPE t_array_source_164 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
153528: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
153529:

Line 153526: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;

153522: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
153523: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
153524: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
153525: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
153526: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;
153527: TYPE t_array_source_164 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
153528: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
153529:
153530: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 153527: TYPE t_array_source_164 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

153523: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
153524: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
153525: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
153526: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;
153527: TYPE t_array_source_164 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
153528: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
153529:
153530: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
153531: TYPE t_array_source_21 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

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

153524: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
153525: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
153526: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;
153527: TYPE t_array_source_164 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
153528: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
153529:
153530: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
153531: TYPE t_array_source_21 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
153532: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 153720: , AP_INVOICE_EXTRACT_HEADER_V h2

153716: , h2.AI_INVOICE_TYPE_LOOKUP_CODE source_164
153717: , fvl164.meaning source_164_meaning
153718: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
153719: FROM xla_events_gt xet
153720: , AP_INVOICE_EXTRACT_HEADER_V h2
153721: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
153722: , fnd_lookup_values fvl15
153723: , fnd_lookup_values fvl47
153724: , fnd_lookup_values fvl164

Line 159370: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

159366: FROM (
159367: SELECT xet.event_id event_id
159368: , 0 line_number
159369: , CASE r
159370: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159371: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159372: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159373: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159374: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 159371: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

159367: SELECT xet.event_id event_id
159368: , 0 line_number
159369: , CASE r
159370: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159371: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159372: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159373: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159374: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159375: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 159377: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

159373: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159374: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159375: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159376: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159377: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159378: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159379: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159380: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159381: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 159378: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

159374: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159375: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159376: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159377: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159378: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159379: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159380: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159381: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159382: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 159379: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

159375: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159376: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159377: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159378: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159379: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159380: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159381: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159382: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159383: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 159380: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

159376: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159377: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159378: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159379: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159380: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159381: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159382: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159383: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159384: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 159381: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

159377: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159378: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159379: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159380: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159381: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159382: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159383: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159384: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159385: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 159382: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

159378: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159379: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159380: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159381: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159382: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159383: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159384: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159385: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159386:

Line 159383: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

159379: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159380: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159381: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159382: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159383: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159384: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159385: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159386:
159387: ELSE null

Line 159384: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

159380: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159381: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159382: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159383: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159384: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159385: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159386:
159387: ELSE null
159388: END object_name

Line 159385: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

159381: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159382: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159383: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159384: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159385: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159386:
159387: ELSE null
159388: END object_name
159389: , CASE r

Line 159476: , AP_INVOICE_EXTRACT_HEADER_V h1

159472:
159473: ELSE null
159474: END source_meaning
159475: FROM xla_events_gt xet
159476: , AP_INVOICE_EXTRACT_HEADER_V h1
159477: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
159478: , fnd_lookup_values fvl15
159479: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
159480: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

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

159958: --
159959: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
159960: --
159961:
159962: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
159963: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
159964: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
159965: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
159966: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

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

159959: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
159960: --
159961:
159962: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
159963: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
159964: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
159965: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
159966: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
159967: TYPE t_array_source_41 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 159969: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

159965: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
159966: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
159967: TYPE t_array_source_41 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
159968: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
159969: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
159970: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
159971: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
159972: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
159973: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 159970: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

159966: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
159967: TYPE t_array_source_41 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
159968: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
159969: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
159970: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
159971: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
159972: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
159973: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
159974: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 159971: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

159967: TYPE t_array_source_41 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
159968: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
159969: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
159970: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
159971: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
159972: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
159973: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
159974: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
159975: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 159972: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

159968: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
159969: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
159970: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
159971: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
159972: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
159973: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
159974: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
159975: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
159976: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 159973: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

159969: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
159970: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
159971: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
159972: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
159973: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
159974: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
159975: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
159976: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
159977: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

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

159970: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
159971: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
159972: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
159973: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
159974: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
159975: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
159976: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
159977: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
159978:

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

159971: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
159972: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
159973: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
159974: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
159975: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
159976: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
159977: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
159978:
159979: TYPE t_array_source_30 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

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

159972: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
159973: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
159974: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
159975: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
159976: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
159977: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
159978:
159979: TYPE t_array_source_30 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
159980: TYPE t_array_source_36 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

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

159973: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
159974: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
159975: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
159976: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
159977: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
159978:
159979: TYPE t_array_source_30 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
159980: TYPE t_array_source_36 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
159981: TYPE t_array_source_38 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 160139: , AP_INVOICE_EXTRACT_HEADER_V h1

160135: , h1.INV_EXCHANGE_RATE source_137
160136: , h1.INV_EXCHANGE_RATE_TYPE source_138
160137: , h1.INV_DOC_SEQUENCE_IDENTIFIER source_168
160138: FROM xla_events_gt xet
160139: , AP_INVOICE_EXTRACT_HEADER_V h1
160140: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
160141: , fnd_lookup_values fvl15
160142: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
160143: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 161657: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161653: FROM (
161654: SELECT xet.event_id event_id
161655: , 0 line_number
161656: , CASE r
161657: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161658: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161659: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161660: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161661: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161658: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161654: SELECT xet.event_id event_id
161655: , 0 line_number
161656: , CASE r
161657: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161658: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161659: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161660: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161661: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161662: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161659: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161655: , 0 line_number
161656: , CASE r
161657: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161658: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161659: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161660: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161661: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161662: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161663: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 161660: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161656: , CASE r
161657: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161658: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161659: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161660: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161661: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161662: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161663: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161664: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 161661: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161657: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161658: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161659: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161660: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161661: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161662: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161663: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161664: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161665: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 161662: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161658: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161659: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161660: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161661: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161662: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161663: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161664: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161665: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161666: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 161667: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161663: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161664: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161665: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161666: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161667: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161668: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161669: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161670: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161671: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161669: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161665: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161666: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161667: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161668: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161669: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161670: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161671: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161672: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161673: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161670: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161666: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161667: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161668: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161669: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161670: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161671: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161672: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161673: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161674: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161671: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161667: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161668: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161669: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161670: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161671: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161672: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161673: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161674: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161675: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161672: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161668: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161669: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161670: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161671: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161672: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161673: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161674: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161675: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161676: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161673: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161669: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161670: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161671: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161672: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161673: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161674: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161675: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161676: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161677: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161674: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161670: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161671: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161672: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161673: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161674: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161675: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161676: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161677: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161678: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161675: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161671: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161672: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161673: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161674: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161675: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161676: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161677: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161678: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161679:

Line 161676: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161672: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161673: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161674: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161675: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161676: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161677: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161678: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161679:
161680: ELSE null

Line 161677: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161673: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161674: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161675: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161676: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161677: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161678: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161679:
161680: ELSE null
161681: END object_name

Line 161678: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

161674: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161675: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161676: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161677: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161678: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161679:
161680: ELSE null
161681: END object_name
161682: , CASE r

Line 161795: , AP_INVOICE_EXTRACT_HEADER_V h2

161791:
161792: ELSE null
161793: END source_meaning
161794: FROM xla_events_gt xet
161795: , AP_INVOICE_EXTRACT_HEADER_V h2
161796: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
161797: , fnd_lookup_values fvl15
161798: , fnd_lookup_values fvl31
161799: , fnd_lookup_values fvl47

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

162305: --
162306: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
162307: --
162308:
162309: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
162310: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
162311: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
162312: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
162313: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

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

162306: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
162307: --
162308:
162309: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
162310: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
162311: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
162312: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
162313: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
162314: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

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

162307: --
162308:
162309: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
162310: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
162311: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
162312: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
162313: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
162314: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
162315: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

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

162308:
162309: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
162310: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
162311: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
162312: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
162313: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
162314: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
162315: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
162316: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

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

162309: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
162310: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
162311: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
162312: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
162313: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
162314: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
162315: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
162316: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
162317: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

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

162310: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
162311: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
162312: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
162313: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
162314: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
162315: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
162316: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
162317: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
162318: TYPE t_array_source_31 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;

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

162315: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
162316: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
162317: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
162318: TYPE t_array_source_31 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
162319: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
162320: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
162321: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
162322: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162323: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 162321: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

162317: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
162318: TYPE t_array_source_31 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
162319: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
162320: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
162321: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
162322: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162323: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
162324: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
162325: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 162322: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

162318: TYPE t_array_source_31 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
162319: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
162320: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
162321: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
162322: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162323: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
162324: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
162325: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
162326: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 162323: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

162319: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
162320: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
162321: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
162322: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162323: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
162324: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
162325: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
162326: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
162327: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 162324: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

162320: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
162321: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
162322: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162323: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
162324: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
162325: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
162326: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
162327: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
162328: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 162325: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

162321: TYPE t_array_source_57 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
162322: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162323: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
162324: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
162325: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
162326: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
162327: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
162328: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
162329: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;

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

162322: TYPE t_array_source_66 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162323: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
162324: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
162325: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
162326: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
162327: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
162328: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
162329: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;
162330: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

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

162323: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
162324: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
162325: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
162326: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
162327: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
162328: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
162329: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;
162330: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
162331:

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

162324: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
162325: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
162326: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
162327: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
162328: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
162329: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;
162330: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
162331:
162332: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 162329: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;

162325: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
162326: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
162327: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
162328: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
162329: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;
162330: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
162331:
162332: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
162333: TYPE t_array_source_21 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

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

162326: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
162327: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
162328: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
162329: TYPE t_array_source_163 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_SOURCE%TYPE INDEX BY BINARY_INTEGER;
162330: TYPE t_array_source_168 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
162331:
162332: TYPE t_array_source_1 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
162333: TYPE t_array_source_21 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
162334: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 162511: , AP_INVOICE_EXTRACT_HEADER_V h2

162507: , h2.INV_EXCHANGE_RATE_TYPE source_138
162508: , h2.AI_SOURCE source_163
162509: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
162510: FROM xla_events_gt xet
162511: , AP_INVOICE_EXTRACT_HEADER_V h2
162512: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
162513: , fnd_lookup_values fvl15
162514: , fnd_lookup_values fvl31
162515: , fnd_lookup_values fvl47