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

Line 102113: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

102109: FROM (
102110: SELECT xet.event_id event_id
102111: , 0 line_number
102112: , CASE r
102113: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102114: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102115: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102116: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102117: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 102114: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

102110: SELECT xet.event_id event_id
102111: , 0 line_number
102112: , CASE r
102113: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102114: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102115: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102116: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102117: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102118: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 102115: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

102111: , 0 line_number
102112: , CASE r
102113: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102114: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102115: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102116: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102117: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102118: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102119: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 102116: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

102112: , CASE r
102113: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102114: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102115: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102116: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102117: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102118: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102119: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102120: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 102117: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

102113: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102114: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102115: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102116: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102117: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102118: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102119: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102120: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102121: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 102118: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

102114: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102115: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102116: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102117: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102118: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102119: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102120: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102121: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102122: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 102126: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

102122: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102123: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102124: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102125: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102126: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102127: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102128: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102129: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102130: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 102127: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

102123: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102124: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102125: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102126: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102127: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102128: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102129: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102130: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102131: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 102128: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

102124: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102125: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102126: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102127: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102128: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102129: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102130: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102131: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102132: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 102129: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

102125: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
102126: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102127: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102128: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102129: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102130: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102131: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102132: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102133: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 102130: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

102126: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102127: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102128: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102129: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102130: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102131: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102132: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102133: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102134: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 102131: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

102127: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102128: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102129: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102130: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102131: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102132: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102133: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102134: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102135:

Line 102132: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

102128: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102129: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102130: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102131: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102132: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102133: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102134: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102135:
102136: ELSE null

Line 102133: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

102129: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102130: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102131: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102132: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102133: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102134: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102135:
102136: ELSE null
102137: END object_name

Line 102134: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

102130: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102131: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102132: WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102133: WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102134: WHEN 22 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
102135:
102136: ELSE null
102137: END object_name
102138: , CASE r

Line 102250: , AP_INVOICE_EXTRACT_HEADER_V h1

102246:
102247: ELSE null
102248: END source_meaning
102249: FROM xla_events_gt xet
102250: , AP_INVOICE_EXTRACT_HEADER_V h1
102251: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
102252: , fnd_lookup_values fvl16
102253: , fnd_lookup_values fvl42
102254: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)

Line 102833: TYPE t_array_source_2 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;

102829: --
102830: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
102831: --
102832:
102833: TYPE t_array_source_2 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
102834: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
102835: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
102836: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
102837: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 102834: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;

102830: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
102831: --
102832:
102833: TYPE t_array_source_2 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
102834: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
102835: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
102836: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
102837: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
102838: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 102835: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

102831: --
102832:
102833: TYPE t_array_source_2 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
102834: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
102835: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
102836: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
102837: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
102838: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
102839: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 102836: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;

102832:
102833: TYPE t_array_source_2 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
102834: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
102835: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
102836: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
102837: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
102838: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
102839: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
102840: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 102837: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

102833: TYPE t_array_source_2 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
102834: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
102835: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
102836: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
102837: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
102838: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
102839: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
102840: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
102841: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 102838: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

102834: TYPE t_array_source_3 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
102835: TYPE t_array_source_4 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
102836: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
102837: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
102838: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
102839: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
102840: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
102841: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
102842: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 102846: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

102842: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
102843: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
102844: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
102845: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
102846: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
102847: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
102848: TYPE t_array_source_91 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
102849: TYPE t_array_source_104 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
102850: TYPE t_array_source_105 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 102847: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

102843: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
102844: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
102845: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
102846: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
102847: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
102848: TYPE t_array_source_91 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
102849: TYPE t_array_source_104 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
102850: TYPE t_array_source_105 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
102851: TYPE t_array_source_131 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 102848: TYPE t_array_source_91 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

102844: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
102845: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
102846: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
102847: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
102848: TYPE t_array_source_91 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
102849: TYPE t_array_source_104 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
102850: TYPE t_array_source_105 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
102851: TYPE t_array_source_131 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
102852: TYPE t_array_source_132 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 102849: TYPE t_array_source_104 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

102845: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
102846: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
102847: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
102848: TYPE t_array_source_91 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
102849: TYPE t_array_source_104 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
102850: TYPE t_array_source_105 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
102851: TYPE t_array_source_131 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
102852: TYPE t_array_source_132 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
102853: TYPE t_array_source_133 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 102850: TYPE t_array_source_105 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

102846: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
102847: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
102848: TYPE t_array_source_91 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
102849: TYPE t_array_source_104 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
102850: TYPE t_array_source_105 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
102851: TYPE t_array_source_131 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
102852: TYPE t_array_source_132 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
102853: TYPE t_array_source_133 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
102854: TYPE t_array_source_160 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 102851: TYPE t_array_source_131 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

102847: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
102848: TYPE t_array_source_91 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
102849: TYPE t_array_source_104 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
102850: TYPE t_array_source_105 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
102851: TYPE t_array_source_131 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
102852: TYPE t_array_source_132 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
102853: TYPE t_array_source_133 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
102854: TYPE t_array_source_160 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
102855:

Line 102852: TYPE t_array_source_132 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

102848: TYPE t_array_source_91 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
102849: TYPE t_array_source_104 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
102850: TYPE t_array_source_105 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
102851: TYPE t_array_source_131 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
102852: TYPE t_array_source_132 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
102853: TYPE t_array_source_133 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
102854: TYPE t_array_source_160 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
102855:
102856: TYPE t_array_source_18 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 102853: TYPE t_array_source_133 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

102849: TYPE t_array_source_104 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
102850: TYPE t_array_source_105 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
102851: TYPE t_array_source_131 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
102852: TYPE t_array_source_132 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
102853: TYPE t_array_source_133 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
102854: TYPE t_array_source_160 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
102855:
102856: TYPE t_array_source_18 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
102857: TYPE t_array_source_19 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 102854: TYPE t_array_source_160 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

102850: TYPE t_array_source_105 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
102851: TYPE t_array_source_131 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
102852: TYPE t_array_source_132 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
102853: TYPE t_array_source_133 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
102854: TYPE t_array_source_160 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
102855:
102856: TYPE t_array_source_18 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
102857: TYPE t_array_source_19 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;
102858: TYPE t_array_source_29 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 103064: , AP_INVOICE_EXTRACT_HEADER_V h1

103060: , h1.INV_EXCHANGE_RATE source_132
103061: , h1.INV_EXCHANGE_RATE_TYPE source_133
103062: , h1.INV_DOC_SEQUENCE_IDENTIFIER source_160
103063: FROM xla_events_gt xet
103064: , AP_INVOICE_EXTRACT_HEADER_V h1
103065: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
103066: , fnd_lookup_values fvl16
103067: , fnd_lookup_values fvl42
103068: WHERE xet.event_date between p_pad_start_date and p_pad_end_date