eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_00200_AAD_S_000012_BC_PKG dependencies on AP_INVOICE_EXTRACT_HEADER_V

Line 36419: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

36415: FROM (
36416: SELECT xet.event_id event_id
36417: , 0 line_number
36418: , CASE r
36419: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36420: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36421: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36422: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36423: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 36420: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

36416: SELECT xet.event_id event_id
36417: , 0 line_number
36418: , CASE r
36419: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36420: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36421: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36422: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36423: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36424: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 36421: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

36417: , 0 line_number
36418: , CASE r
36419: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36420: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36421: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36422: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36423: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36424: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36425: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 36422: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

36418: , CASE r
36419: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36420: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36421: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36422: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36423: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36424: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36425: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36426: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 36423: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

36419: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36420: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36421: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36422: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36423: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36424: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36425: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36426: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36427: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 36424: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

36420: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36421: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36422: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36423: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36424: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36425: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36426: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36427: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36428: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 36425: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

36421: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36422: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36423: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36424: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36425: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36426: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36427: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36428: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36429: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 36426: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

36422: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36423: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36424: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36425: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36426: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36427: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36428: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36429: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36430: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 36427: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

36423: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36424: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36425: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36426: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36427: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36428: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36429: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36430: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36431: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 36428: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

36424: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36425: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36426: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36427: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36428: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36429: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36430: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36431: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36432:

Line 36429: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

36425: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36426: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36427: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36428: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36429: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36430: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36431: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36432:
36433: ELSE null

Line 36430: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

36426: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36427: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36428: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36429: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36430: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36431: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36432:
36433: ELSE null
36434: END object_name

Line 36431: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

36427: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36428: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36429: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36430: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36431: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
36432:
36433: ELSE null
36434: END object_name
36435: , CASE r

Line 36510: , AP_INVOICE_EXTRACT_HEADER_V h2

36506:
36507: ELSE null
36508: END source_meaning
36509: FROM xla_events_gt xet
36510: , AP_INVOICE_EXTRACT_HEADER_V h2
36511: , fnd_lookup_values fvl13
36512: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
36513: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
36514: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 36991: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_PAYMENT_STATUS_FLAG%TYPE INDEX BY BINARY_INTEGER;

36987: --
36988: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
36989: --
36990:
36991: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_PAYMENT_STATUS_FLAG%TYPE INDEX BY BINARY_INTEGER;
36992: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
36993: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
36994: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
36995: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 36992: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

36988: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
36989: --
36990:
36991: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_PAYMENT_STATUS_FLAG%TYPE INDEX BY BINARY_INTEGER;
36992: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
36993: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
36994: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
36995: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
36996: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 36993: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

36989: --
36990:
36991: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_PAYMENT_STATUS_FLAG%TYPE INDEX BY BINARY_INTEGER;
36992: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
36993: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
36994: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
36995: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
36996: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
36997: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 36994: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

36990:
36991: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_PAYMENT_STATUS_FLAG%TYPE INDEX BY BINARY_INTEGER;
36992: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
36993: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
36994: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
36995: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
36996: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
36997: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
36998: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 36995: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

36991: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_PAYMENT_STATUS_FLAG%TYPE INDEX BY BINARY_INTEGER;
36992: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
36993: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
36994: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
36995: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
36996: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
36997: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
36998: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
36999: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 36996: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

36992: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
36993: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
36994: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
36995: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
36996: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
36997: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
36998: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
36999: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
37000: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 36997: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

36993: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
36994: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
36995: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
36996: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
36997: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
36998: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
36999: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
37000: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
37001: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 36998: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

36994: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
36995: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
36996: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
36997: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
36998: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
36999: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
37000: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
37001: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
37002: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 36999: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

36995: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
36996: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
36997: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
36998: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
36999: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
37000: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
37001: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
37002: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
37003: TYPE t_array_source_73 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 37000: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

36996: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
36997: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
36998: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
36999: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
37000: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
37001: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
37002: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
37003: TYPE t_array_source_73 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
37004:

Line 37001: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

36997: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
36998: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
36999: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
37000: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
37001: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
37002: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
37003: TYPE t_array_source_73 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
37004:
37005: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 37002: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

36998: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
36999: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
37000: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
37001: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
37002: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
37003: TYPE t_array_source_73 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
37004:
37005: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
37006: TYPE t_array_source_2 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 37003: TYPE t_array_source_73 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

36999: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
37000: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
37001: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
37002: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
37003: TYPE t_array_source_73 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
37004:
37005: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
37006: TYPE t_array_source_2 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
37007: TYPE t_array_source_3 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ANTICIPATION%TYPE INDEX BY BINARY_INTEGER;

Line 37157: , AP_INVOICE_EXTRACT_HEADER_V h2

37153: , h2.INV_DOC_SEQUENCE_CATEGORY source_71
37154: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_72
37155: , h2.INV_DOC_SEQUENCE_VALUE source_73
37156: FROM xla_events_gt xet
37157: , AP_INVOICE_EXTRACT_HEADER_V h2
37158: , fnd_lookup_values fvl13
37159: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
37160: and xet.event_class_code = C_EVENT_CLASS_CODE
37161: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 38764: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

38760: FROM (
38761: SELECT xet.event_id event_id
38762: , 0 line_number
38763: , CASE r
38764: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38765: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38766: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38767: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38768: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 38765: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

38761: SELECT xet.event_id event_id
38762: , 0 line_number
38763: , CASE r
38764: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38765: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38766: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38767: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38768: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38769: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 38766: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

38762: , 0 line_number
38763: , CASE r
38764: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38765: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38766: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38767: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38768: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38769: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38770: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 38767: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

38763: , CASE r
38764: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38765: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38766: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38767: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38768: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38769: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38770: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38771: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 38768: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

38764: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38765: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38766: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38767: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38768: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38769: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38770: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38771: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38772: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 38769: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

38765: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38766: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38767: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38768: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38769: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38770: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38771: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38772: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38773: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 38770: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

38766: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38767: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38768: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38769: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38770: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38771: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38772: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38773: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38774: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 38771: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

38767: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38768: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38769: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38770: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38771: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38772: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38773: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38774: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38775: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 38772: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

38768: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38769: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38770: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38771: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38772: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38773: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38774: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38775: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38776: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 38773: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

38769: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38770: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38771: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38772: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38773: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38774: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38775: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38776: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38777:

Line 38774: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

38770: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38771: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38772: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38773: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38774: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38775: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38776: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38777:
38778: ELSE null

Line 38775: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

38771: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38772: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38773: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38774: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38775: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38776: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38777:
38778: ELSE null
38779: END object_name

Line 38776: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

38772: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38773: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38774: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38775: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38776: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
38777:
38778: ELSE null
38779: END object_name
38780: , CASE r

Line 38855: , AP_INVOICE_EXTRACT_HEADER_V h2

38851:
38852: ELSE null
38853: END source_meaning
38854: FROM xla_events_gt xet
38855: , AP_INVOICE_EXTRACT_HEADER_V h2
38856: , fnd_lookup_values fvl13
38857: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
38858: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
38859: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 39336: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_PAYMENT_STATUS_FLAG%TYPE INDEX BY BINARY_INTEGER;

39332: --
39333: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
39334: --
39335:
39336: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_PAYMENT_STATUS_FLAG%TYPE INDEX BY BINARY_INTEGER;
39337: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
39338: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
39339: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
39340: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 39337: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

39333: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
39334: --
39335:
39336: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_PAYMENT_STATUS_FLAG%TYPE INDEX BY BINARY_INTEGER;
39337: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
39338: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
39339: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
39340: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
39341: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 39338: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

39334: --
39335:
39336: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_PAYMENT_STATUS_FLAG%TYPE INDEX BY BINARY_INTEGER;
39337: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
39338: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
39339: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
39340: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
39341: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
39342: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 39339: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

39335:
39336: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_PAYMENT_STATUS_FLAG%TYPE INDEX BY BINARY_INTEGER;
39337: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
39338: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
39339: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
39340: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
39341: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
39342: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
39343: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 39340: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

39336: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_PAYMENT_STATUS_FLAG%TYPE INDEX BY BINARY_INTEGER;
39337: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
39338: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
39339: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
39340: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
39341: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
39342: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
39343: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
39344: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 39341: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

39337: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
39338: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
39339: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
39340: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
39341: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
39342: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
39343: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
39344: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
39345: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 39342: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

39338: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
39339: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
39340: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
39341: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
39342: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
39343: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
39344: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
39345: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
39346: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 39343: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

39339: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
39340: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
39341: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
39342: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
39343: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
39344: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
39345: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
39346: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
39347: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 39344: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

39340: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
39341: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
39342: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
39343: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
39344: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
39345: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
39346: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
39347: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
39348: TYPE t_array_source_73 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 39345: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

39341: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
39342: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
39343: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
39344: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
39345: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
39346: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
39347: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
39348: TYPE t_array_source_73 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
39349:

Line 39346: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

39342: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
39343: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
39344: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
39345: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
39346: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
39347: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
39348: TYPE t_array_source_73 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
39349:
39350: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 39347: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

39343: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
39344: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
39345: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
39346: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
39347: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
39348: TYPE t_array_source_73 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
39349:
39350: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
39351: TYPE t_array_source_2 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 39348: TYPE t_array_source_73 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

39344: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
39345: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
39346: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
39347: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
39348: TYPE t_array_source_73 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
39349:
39350: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
39351: TYPE t_array_source_2 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
39352: TYPE t_array_source_3 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ANTICIPATION%TYPE INDEX BY BINARY_INTEGER;

Line 39502: , AP_INVOICE_EXTRACT_HEADER_V h2

39498: , h2.INV_DOC_SEQUENCE_CATEGORY source_71
39499: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_72
39500: , h2.INV_DOC_SEQUENCE_VALUE source_73
39501: FROM xla_events_gt xet
39502: , AP_INVOICE_EXTRACT_HEADER_V h2
39503: , fnd_lookup_values fvl13
39504: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
39505: and xet.event_class_code = C_EVENT_CLASS_CODE
39506: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 41097: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

41093: FROM (
41094: SELECT xet.event_id event_id
41095: , 0 line_number
41096: , CASE r
41097: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41098: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41099: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41100: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41101: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 41098: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

41094: SELECT xet.event_id event_id
41095: , 0 line_number
41096: , CASE r
41097: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41098: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41099: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41100: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41101: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41102: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 41099: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

41095: , 0 line_number
41096: , CASE r
41097: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41098: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41099: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41100: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41101: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41102: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41103: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 41100: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

41096: , CASE r
41097: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41098: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41099: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41100: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41101: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41102: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41103: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41104: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 41101: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

41097: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41098: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41099: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41100: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41101: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41102: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41103: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41104: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41105: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 41102: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

41098: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41099: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41100: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41101: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41102: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41103: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41104: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41105: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41106: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 41103: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

41099: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41100: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41101: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41102: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41103: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41104: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41105: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41106: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41107: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 41104: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

41100: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41101: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41102: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41103: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41104: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41105: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41106: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41107: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
41108: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 41105: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

41101: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41102: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41103: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41104: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41105: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41106: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41107: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
41108: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41109: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 41106: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

41102: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41103: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41104: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41105: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41106: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41107: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
41108: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41109: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41110: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 41108: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

41104: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41105: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41106: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41107: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
41108: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41109: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41110: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41111:
41112: ELSE null

Line 41109: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

41105: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41106: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41107: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
41108: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41109: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41110: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41111:
41112: ELSE null
41113: END object_name

Line 41110: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

41106: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41107: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
41108: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41109: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41110: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
41111:
41112: ELSE null
41113: END object_name
41114: , CASE r

Line 41194: , AP_INVOICE_EXTRACT_HEADER_V h2

41190:
41191: ELSE null
41192: END source_meaning
41193: FROM xla_events_gt xet
41194: , AP_INVOICE_EXTRACT_HEADER_V h2
41195: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
41196: , fnd_lookup_values fvl13
41197: , fnd_lookup_values fvl60
41198: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)

Line 41736: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_PAYMENT_STATUS_FLAG%TYPE INDEX BY BINARY_INTEGER;

41732: --
41733: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
41734: --
41735:
41736: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_PAYMENT_STATUS_FLAG%TYPE INDEX BY BINARY_INTEGER;
41737: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
41738: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
41739: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
41740: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 41737: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

41733: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
41734: --
41735:
41736: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_PAYMENT_STATUS_FLAG%TYPE INDEX BY BINARY_INTEGER;
41737: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
41738: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
41739: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
41740: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
41741: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 41738: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

41734: --
41735:
41736: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_PAYMENT_STATUS_FLAG%TYPE INDEX BY BINARY_INTEGER;
41737: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
41738: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
41739: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
41740: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
41741: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
41742: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 41739: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

41735:
41736: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_PAYMENT_STATUS_FLAG%TYPE INDEX BY BINARY_INTEGER;
41737: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
41738: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
41739: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
41740: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
41741: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
41742: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
41743: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 41740: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

41736: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_PAYMENT_STATUS_FLAG%TYPE INDEX BY BINARY_INTEGER;
41737: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
41738: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
41739: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
41740: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
41741: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
41742: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
41743: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
41744: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 41741: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

41737: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
41738: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
41739: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
41740: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
41741: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
41742: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
41743: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
41744: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
41745: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 41742: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

41738: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
41739: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
41740: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
41741: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
41742: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
41743: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
41744: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
41745: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
41746: TYPE t_array_source_60 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 41743: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

41739: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
41740: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
41741: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
41742: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
41743: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
41744: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
41745: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
41746: TYPE t_array_source_60 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
41747: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 41744: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

41740: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
41741: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
41742: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
41743: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
41744: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
41745: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
41746: TYPE t_array_source_60 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
41747: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
41748: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 41745: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

41741: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
41742: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
41743: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
41744: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
41745: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
41746: TYPE t_array_source_60 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
41747: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
41748: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
41749: TYPE t_array_source_73 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 41747: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

41743: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
41744: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
41745: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
41746: TYPE t_array_source_60 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
41747: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
41748: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
41749: TYPE t_array_source_73 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
41750:
41751: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 41748: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

41744: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
41745: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
41746: TYPE t_array_source_60 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
41747: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
41748: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
41749: TYPE t_array_source_73 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
41750:
41751: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
41752: TYPE t_array_source_2 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 41749: TYPE t_array_source_73 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

41745: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
41746: TYPE t_array_source_60 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
41747: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
41748: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
41749: TYPE t_array_source_73 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
41750:
41751: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
41752: TYPE t_array_source_2 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
41753: TYPE t_array_source_3 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ANTICIPATION%TYPE INDEX BY BINARY_INTEGER;

Line 41929: , AP_INVOICE_EXTRACT_HEADER_V h2

41925: , h2.INV_DOC_SEQUENCE_CATEGORY source_71
41926: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_72
41927: , h2.INV_DOC_SEQUENCE_VALUE source_73
41928: FROM xla_events_gt xet
41929: , AP_INVOICE_EXTRACT_HEADER_V h2
41930: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
41931: , fnd_lookup_values fvl13
41932: , fnd_lookup_values fvl60
41933: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 44132: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

44128: FROM (
44129: SELECT xet.event_id event_id
44130: , 0 line_number
44131: , CASE r
44132: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44133: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44134: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44135: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44136: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 44133: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

44129: SELECT xet.event_id event_id
44130: , 0 line_number
44131: , CASE r
44132: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44133: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44134: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44135: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44136: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44137: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 44134: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

44130: , 0 line_number
44131: , CASE r
44132: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44133: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44134: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44135: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44136: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44137: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44138: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 44135: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

44131: , CASE r
44132: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44133: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44134: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44135: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44136: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44137: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44138: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44139: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 44136: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

44132: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44133: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44134: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44135: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44136: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44137: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44138: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44139: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44140: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 44137: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

44133: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44134: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44135: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44136: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44137: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44138: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44139: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44140: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44141: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 44138: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

44134: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44135: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44136: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44137: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44138: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44139: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44140: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44141: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44142: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 44139: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

44135: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44136: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44137: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44138: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44139: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44140: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44141: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44142: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44143: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 44140: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

44136: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44137: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44138: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44139: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44140: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44141: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44142: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44143: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44144:

Line 44141: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

44137: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44138: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44139: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44140: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44141: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44142: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44143: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44144:
44145: ELSE null

Line 44142: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

44138: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44139: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44140: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44141: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44142: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44143: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44144:
44145: ELSE null
44146: END object_name

Line 44143: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

44139: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44140: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44141: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44142: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44143: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
44144:
44145: ELSE null
44146: END object_name
44147: , CASE r

Line 44218: , AP_INVOICE_EXTRACT_HEADER_V h2

44214:
44215: ELSE null
44216: END source_meaning
44217: FROM xla_events_gt xet
44218: , AP_INVOICE_EXTRACT_HEADER_V h2
44219: , fnd_lookup_values fvl13
44220: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
44221: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
44222: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 44641: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

44637: --
44638: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
44639: --
44640:
44641: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
44642: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
44643: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
44644: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
44645: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 44642: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

44638: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
44639: --
44640:
44641: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
44642: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
44643: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
44644: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
44645: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
44646: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 44643: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

44639: --
44640:
44641: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
44642: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
44643: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
44644: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
44645: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
44646: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
44647: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 44644: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

44640:
44641: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
44642: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
44643: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
44644: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
44645: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
44646: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
44647: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
44648: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 44645: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

44641: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
44642: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
44643: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
44644: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
44645: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
44646: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
44647: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
44648: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
44649: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 44646: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

44642: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
44643: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
44644: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
44645: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
44646: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
44647: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
44648: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
44649: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
44650: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 44647: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

44643: TYPE t_array_source_29 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
44644: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
44645: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
44646: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
44647: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
44648: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
44649: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
44650: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
44651: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 44648: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

44644: TYPE t_array_source_36 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
44645: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
44646: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
44647: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
44648: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
44649: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
44650: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
44651: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
44652: TYPE t_array_source_73 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 44649: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

44645: TYPE t_array_source_37 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
44646: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
44647: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
44648: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
44649: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
44650: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
44651: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
44652: TYPE t_array_source_73 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
44653:

Line 44650: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

44646: TYPE t_array_source_38 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
44647: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
44648: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
44649: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
44650: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
44651: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
44652: TYPE t_array_source_73 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
44653:
44654: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 44651: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

44647: TYPE t_array_source_43 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
44648: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
44649: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
44650: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
44651: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
44652: TYPE t_array_source_73 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
44653:
44654: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
44655: TYPE t_array_source_2 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 44652: TYPE t_array_source_73 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

44648: TYPE t_array_source_44 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
44649: TYPE t_array_source_45 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
44650: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
44651: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
44652: TYPE t_array_source_73 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
44653:
44654: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
44655: TYPE t_array_source_2 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
44656: TYPE t_array_source_4 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 44784: , AP_INVOICE_EXTRACT_HEADER_V h2

44780: , h2.INV_DOC_SEQUENCE_CATEGORY source_71
44781: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_72
44782: , h2.INV_DOC_SEQUENCE_VALUE source_73
44783: FROM xla_events_gt xet
44784: , AP_INVOICE_EXTRACT_HEADER_V h2
44785: , fnd_lookup_values fvl13
44786: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
44787: and xet.event_class_code = C_EVENT_CLASS_CODE
44788: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id