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

APPS.XLA_00200_AAD_S_000010_PKG dependencies on AP_INVOICE_EXTRACT_DETAILS_V

Line 118684: WHEN 1 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

118680: FROM (
118681: SELECT xet.event_id event_id
118682: , l1.line_number line_number
118683: , CASE r
118684: WHEN 1 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118685: WHEN 2 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118686: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
118687: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118688: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'

Line 118685: WHEN 2 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

118681: SELECT xet.event_id event_id
118682: , l1.line_number line_number
118683: , CASE r
118684: WHEN 1 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118685: WHEN 2 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118686: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
118687: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118688: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
118689: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 118687: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

118683: , CASE r
118684: WHEN 1 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118685: WHEN 2 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118686: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
118687: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118688: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
118689: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118690: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118691: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 118689: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

118685: WHEN 2 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118686: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
118687: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118688: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
118689: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118690: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118691: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118692: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118693: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 118690: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

118686: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
118687: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118688: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
118689: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118690: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118691: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118692: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118693: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118694: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 118691: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

118687: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118688: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
118689: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118690: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118691: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118692: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118693: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118694: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118695: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 118692: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

118688: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
118689: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118690: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118691: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118692: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118693: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118694: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118695: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118696: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 118693: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

118689: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118690: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118691: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118692: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118693: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118694: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118695: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118696: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118697: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 118694: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

118690: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118691: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118692: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118693: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118694: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118695: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118696: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118697: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118698: WHEN 15 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 118695: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

118691: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118692: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118693: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118694: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118695: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118696: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118697: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118698: WHEN 15 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118699: WHEN 16 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 118696: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

118692: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118693: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118694: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118695: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118696: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118697: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118698: WHEN 15 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118699: WHEN 16 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118700:

Line 118697: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

118693: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118694: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118695: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118696: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118697: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118698: WHEN 15 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118699: WHEN 16 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118700:
118701: ELSE null

Line 118698: WHEN 15 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

118694: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118695: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118696: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118697: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118698: WHEN 15 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118699: WHEN 16 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118700:
118701: ELSE null
118702: END object_name

Line 118699: WHEN 16 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

118695: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118696: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118697: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118698: WHEN 15 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118699: WHEN 16 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118700:
118701: ELSE null
118702: END object_name
118703: , CASE r

Line 118786: , AP_INVOICE_EXTRACT_DETAILS_V l1

118782: ELSE null
118783: END source_value
118784: , null source_meaning
118785: FROM xla_events_gt xet
118786: , AP_INVOICE_EXTRACT_DETAILS_V l1
118787: , ZX_AP_DEF_TAX_EXTRACT_V l3
118788: , ZX_AP_TAX_JRNL_LINE_DESC_V l4
118789: , (select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
118790: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 118932: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;

118928: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
118929: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
118930: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
118931:
118932: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
118933: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
118934: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
118935: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
118936: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 118933: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

118929: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
118930: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
118931:
118932: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
118933: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
118934: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
118935: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
118936: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
118937: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 118935: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

118931:
118932: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
118933: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
118934: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
118935: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
118936: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
118937: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
118938: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;
118939: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 118937: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;

118933: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
118934: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
118935: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
118936: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
118937: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
118938: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;
118939: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
118940: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
118941: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 118938: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;

118934: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
118935: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
118936: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
118937: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
118938: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;
118939: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
118940: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
118941: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
118942: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 118939: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

118935: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
118936: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
118937: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
118938: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;
118939: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
118940: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
118941: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
118942: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
118943: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;

Line 118940: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;

118936: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
118937: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
118938: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;
118939: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
118940: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
118941: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
118942: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
118943: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
118944: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 118941: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;

118937: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
118938: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;
118939: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
118940: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
118941: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
118942: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
118943: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
118944: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
118945: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 118942: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

118938: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;
118939: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
118940: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
118941: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
118942: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
118943: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
118944: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
118945: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
118946: TYPE t_array_source_156 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 118943: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;

118939: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
118940: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
118941: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
118942: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
118943: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
118944: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
118945: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
118946: TYPE t_array_source_156 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
118947: TYPE t_array_source_157 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;

Line 118944: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

118940: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
118941: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
118942: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
118943: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
118944: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
118945: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
118946: TYPE t_array_source_156 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
118947: TYPE t_array_source_157 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
118948:

Line 118945: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

118941: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
118942: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
118943: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
118944: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
118945: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
118946: TYPE t_array_source_156 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
118947: TYPE t_array_source_157 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
118948:
118949: l_array_source_56 t_array_source_56;

Line 118946: TYPE t_array_source_156 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

118942: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
118943: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
118944: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
118945: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
118946: TYPE t_array_source_156 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
118947: TYPE t_array_source_157 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
118948:
118949: l_array_source_56 t_array_source_56;
118950: l_array_source_80 t_array_source_80;

Line 118947: TYPE t_array_source_157 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;

118943: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
118944: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
118945: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
118946: TYPE t_array_source_156 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
118947: TYPE t_array_source_157 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
118948:
118949: l_array_source_56 t_array_source_56;
118950: l_array_source_80 t_array_source_80;
118951: l_array_source_152 t_array_source_152;

Line 119063: , AP_INVOICE_EXTRACT_DETAILS_V l1

119059: , l1.UPG_DR_ENC_TYPE_ID source_97
119060: , l1.AID_INVOICE_DIST_ID source_156
119061: , l1.AID_PARENT_REVERSAL_ID source_157
119062: FROM xla_events_gt xet
119063: , AP_INVOICE_EXTRACT_DETAILS_V l1
119064: , ZX_AP_DEF_TAX_EXTRACT_V l3
119065: , ZX_AP_TAX_JRNL_LINE_DESC_V l4
119066: WHERE xet.event_id between x_first_event_id and x_last_event_id
119067: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 119941: WHEN 1 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

119937: FROM (
119938: SELECT xet.event_id event_id
119939: , l1.line_number line_number
119940: , CASE r
119941: WHEN 1 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119942: WHEN 2 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119943: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
119944: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119945: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'

Line 119942: WHEN 2 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

119938: SELECT xet.event_id event_id
119939: , l1.line_number line_number
119940: , CASE r
119941: WHEN 1 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119942: WHEN 2 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119943: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
119944: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119945: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
119946: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 119944: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

119940: , CASE r
119941: WHEN 1 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119942: WHEN 2 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119943: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
119944: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119945: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
119946: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119947: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119948: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 119946: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

119942: WHEN 2 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119943: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
119944: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119945: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
119946: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119947: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119948: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119949: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119950: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 119947: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

119943: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
119944: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119945: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
119946: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119947: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119948: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119949: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119950: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119951: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 119948: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

119944: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119945: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
119946: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119947: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119948: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119949: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119950: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119951: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119952: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 119949: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

119945: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
119946: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119947: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119948: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119949: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119950: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119951: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119952: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119953: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 119950: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

119946: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119947: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119948: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119949: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119950: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119951: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119952: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119953: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119954: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 119951: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

119947: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119948: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119949: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119950: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119951: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119952: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119953: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119954: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119955: WHEN 15 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 119952: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

119948: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119949: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119950: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119951: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119952: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119953: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119954: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119955: WHEN 15 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119956: WHEN 16 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 119953: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

119949: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119950: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119951: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119952: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119953: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119954: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119955: WHEN 15 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119956: WHEN 16 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119957:

Line 119954: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

119950: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119951: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119952: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119953: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119954: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119955: WHEN 15 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119956: WHEN 16 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119957:
119958: ELSE null

Line 119955: WHEN 15 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

119951: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119952: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119953: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119954: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119955: WHEN 15 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119956: WHEN 16 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119957:
119958: ELSE null
119959: END object_name

Line 119956: WHEN 16 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

119952: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119953: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119954: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119955: WHEN 15 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119956: WHEN 16 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119957:
119958: ELSE null
119959: END object_name
119960: , CASE r

Line 120043: , AP_INVOICE_EXTRACT_DETAILS_V l1

120039: ELSE null
120040: END source_value
120041: , null source_meaning
120042: FROM xla_events_gt xet
120043: , AP_INVOICE_EXTRACT_DETAILS_V l1
120044: , ZX_AP_DEF_TAX_EXTRACT_V l3
120045: , ZX_AP_TAX_JRNL_LINE_DESC_V l4
120046: , (select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
120047: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 120189: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;

120185: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
120186: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
120187: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
120188:
120189: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
120190: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
120191: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
120192: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
120193: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 120190: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

120186: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
120187: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
120188:
120189: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
120190: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
120191: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
120192: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
120193: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
120194: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 120192: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

120188:
120189: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
120190: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
120191: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
120192: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
120193: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
120194: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
120195: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;
120196: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 120194: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;

120190: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
120191: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
120192: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
120193: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
120194: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
120195: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;
120196: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
120197: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
120198: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 120195: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;

120191: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
120192: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
120193: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
120194: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
120195: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;
120196: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
120197: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
120198: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
120199: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 120196: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

120192: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
120193: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
120194: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
120195: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;
120196: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
120197: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
120198: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
120199: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
120200: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;

Line 120197: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;

120193: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
120194: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
120195: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;
120196: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
120197: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
120198: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
120199: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
120200: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
120201: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 120198: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;

120194: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
120195: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;
120196: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
120197: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
120198: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
120199: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
120200: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
120201: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
120202: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 120199: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

120195: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;
120196: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
120197: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
120198: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
120199: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
120200: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
120201: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
120202: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
120203: TYPE t_array_source_156 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 120200: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;

120196: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
120197: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
120198: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
120199: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
120200: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
120201: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
120202: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
120203: TYPE t_array_source_156 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
120204: TYPE t_array_source_157 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;

Line 120201: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

120197: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
120198: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
120199: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
120200: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
120201: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
120202: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
120203: TYPE t_array_source_156 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
120204: TYPE t_array_source_157 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
120205:

Line 120202: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

120198: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
120199: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
120200: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
120201: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
120202: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
120203: TYPE t_array_source_156 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
120204: TYPE t_array_source_157 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
120205:
120206: l_array_source_56 t_array_source_56;

Line 120203: TYPE t_array_source_156 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

120199: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
120200: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
120201: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
120202: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
120203: TYPE t_array_source_156 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
120204: TYPE t_array_source_157 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
120205:
120206: l_array_source_56 t_array_source_56;
120207: l_array_source_80 t_array_source_80;

Line 120204: TYPE t_array_source_157 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;

120200: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
120201: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
120202: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
120203: TYPE t_array_source_156 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
120204: TYPE t_array_source_157 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
120205:
120206: l_array_source_56 t_array_source_56;
120207: l_array_source_80 t_array_source_80;
120208: l_array_source_152 t_array_source_152;

Line 120320: , AP_INVOICE_EXTRACT_DETAILS_V l1

120316: , l1.UPG_DR_ENC_TYPE_ID source_97
120317: , l1.AID_INVOICE_DIST_ID source_156
120318: , l1.AID_PARENT_REVERSAL_ID source_157
120319: FROM xla_events_gt xet
120320: , AP_INVOICE_EXTRACT_DETAILS_V l1
120321: , ZX_AP_DEF_TAX_EXTRACT_V l3
120322: , ZX_AP_TAX_JRNL_LINE_DESC_V l4
120323: WHERE xet.event_id between x_first_event_id and x_last_event_id
120324: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 123187: WHEN 1 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

123183: FROM (
123184: SELECT xet.event_id event_id
123185: , l1.line_number line_number
123186: , CASE r
123187: WHEN 1 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123188: WHEN 2 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123189: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
123190: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123191: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'

Line 123188: WHEN 2 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

123184: SELECT xet.event_id event_id
123185: , l1.line_number line_number
123186: , CASE r
123187: WHEN 1 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123188: WHEN 2 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123189: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
123190: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123191: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
123192: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 123190: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

123186: , CASE r
123187: WHEN 1 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123188: WHEN 2 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123189: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
123190: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123191: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
123192: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123193: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123194: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 123192: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

123188: WHEN 2 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123189: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
123190: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123191: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
123192: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123193: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123194: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123195: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123196: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 123193: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

123189: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
123190: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123191: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
123192: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123193: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123194: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123195: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123196: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123197: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 123194: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

123190: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123191: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
123192: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123193: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123194: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123195: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123196: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123197: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123198: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 123195: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

123191: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
123192: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123193: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123194: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123195: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123196: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123197: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123198: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123199: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 123196: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

123192: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123193: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123194: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123195: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123196: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123197: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123198: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123199: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123200: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 123197: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

123193: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123194: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123195: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123196: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123197: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123198: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123199: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123200: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123201: WHEN 15 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 123198: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

123194: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123195: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123196: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123197: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123198: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123199: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123200: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123201: WHEN 15 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123202: WHEN 16 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 123199: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

123195: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123196: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123197: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123198: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123199: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123200: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123201: WHEN 15 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123202: WHEN 16 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123203:

Line 123200: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

123196: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123197: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123198: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123199: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123200: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123201: WHEN 15 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123202: WHEN 16 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123203:
123204: ELSE null

Line 123201: WHEN 15 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

123197: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123198: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123199: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123200: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123201: WHEN 15 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123202: WHEN 16 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123203:
123204: ELSE null
123205: END object_name

Line 123202: WHEN 16 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

123198: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123199: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123200: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123201: WHEN 15 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123202: WHEN 16 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123203:
123204: ELSE null
123205: END object_name
123206: , CASE r

Line 123289: , AP_INVOICE_EXTRACT_DETAILS_V l1

123285: ELSE null
123286: END source_value
123287: , null source_meaning
123288: FROM xla_events_gt xet
123289: , AP_INVOICE_EXTRACT_DETAILS_V l1
123290: , ZX_AP_DEF_TAX_EXTRACT_V l3
123291: , ZX_AP_TAX_JRNL_LINE_DESC_V l4
123292: , (select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
123293: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 123435: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;

123431: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
123432: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
123433: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
123434:
123435: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
123436: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
123437: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
123438: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
123439: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 123436: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

123432: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
123433: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
123434:
123435: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
123436: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
123437: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
123438: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
123439: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
123440: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 123438: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

123434:
123435: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
123436: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
123437: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
123438: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
123439: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
123440: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
123441: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;
123442: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 123440: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;

123436: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
123437: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
123438: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
123439: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
123440: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
123441: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;
123442: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
123443: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
123444: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 123441: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;

123437: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
123438: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
123439: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
123440: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
123441: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;
123442: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
123443: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
123444: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
123445: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 123442: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

123438: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
123439: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
123440: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
123441: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;
123442: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
123443: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
123444: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
123445: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
123446: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;

Line 123443: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;

123439: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
123440: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
123441: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;
123442: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
123443: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
123444: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
123445: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
123446: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
123447: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 123444: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;

123440: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
123441: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;
123442: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
123443: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
123444: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
123445: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
123446: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
123447: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
123448: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 123445: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

123441: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;
123442: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
123443: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
123444: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
123445: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
123446: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
123447: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
123448: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
123449: TYPE t_array_source_156 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 123446: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;

123442: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
123443: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
123444: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
123445: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
123446: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
123447: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
123448: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
123449: TYPE t_array_source_156 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
123450: TYPE t_array_source_157 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;

Line 123447: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

123443: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
123444: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
123445: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
123446: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
123447: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
123448: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
123449: TYPE t_array_source_156 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
123450: TYPE t_array_source_157 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
123451:

Line 123448: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

123444: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
123445: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
123446: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
123447: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
123448: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
123449: TYPE t_array_source_156 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
123450: TYPE t_array_source_157 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
123451:
123452: l_array_source_56 t_array_source_56;

Line 123449: TYPE t_array_source_156 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

123445: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
123446: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
123447: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
123448: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
123449: TYPE t_array_source_156 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
123450: TYPE t_array_source_157 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
123451:
123452: l_array_source_56 t_array_source_56;
123453: l_array_source_80 t_array_source_80;

Line 123450: TYPE t_array_source_157 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;

123446: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
123447: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
123448: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
123449: TYPE t_array_source_156 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
123450: TYPE t_array_source_157 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
123451:
123452: l_array_source_56 t_array_source_56;
123453: l_array_source_80 t_array_source_80;
123454: l_array_source_152 t_array_source_152;

Line 123566: , AP_INVOICE_EXTRACT_DETAILS_V l1

123562: , l1.UPG_DR_ENC_TYPE_ID source_97
123563: , l1.AID_INVOICE_DIST_ID source_156
123564: , l1.AID_PARENT_REVERSAL_ID source_157
123565: FROM xla_events_gt xet
123566: , AP_INVOICE_EXTRACT_DETAILS_V l1
123567: , ZX_AP_DEF_TAX_EXTRACT_V l3
123568: , ZX_AP_TAX_JRNL_LINE_DESC_V l4
123569: WHERE xet.event_id between x_first_event_id and x_last_event_id
123570: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 133842: WHEN 1 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

133838: FROM (
133839: SELECT xet.event_id event_id
133840: , l1.line_number line_number
133841: , CASE r
133842: WHEN 1 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133843: WHEN 2 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133844: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
133845: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133846: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'

Line 133843: WHEN 2 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

133839: SELECT xet.event_id event_id
133840: , l1.line_number line_number
133841: , CASE r
133842: WHEN 1 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133843: WHEN 2 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133844: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
133845: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133846: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
133847: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 133845: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

133841: , CASE r
133842: WHEN 1 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133843: WHEN 2 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133844: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
133845: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133846: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
133847: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133848: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133849: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 133847: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

133843: WHEN 2 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133844: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
133845: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133846: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
133847: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133848: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133849: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133850: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133851: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 133848: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

133844: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
133845: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133846: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
133847: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133848: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133849: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133850: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133851: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133852: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 133849: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

133845: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133846: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
133847: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133848: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133849: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133850: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133851: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133852: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133853: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 133850: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

133846: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
133847: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133848: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133849: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133850: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133851: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133852: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133853: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133854: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 133851: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

133847: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133848: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133849: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133850: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133851: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133852: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133853: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133854: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133855: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 133852: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

133848: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133849: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133850: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133851: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133852: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133853: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133854: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133855: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133856: WHEN 15 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 133853: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

133849: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133850: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133851: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133852: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133853: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133854: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133855: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133856: WHEN 15 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133857: WHEN 16 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 133854: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

133850: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133851: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133852: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133853: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133854: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133855: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133856: WHEN 15 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133857: WHEN 16 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133858:

Line 133855: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

133851: WHEN 10 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133852: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133853: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133854: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133855: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133856: WHEN 15 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133857: WHEN 16 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133858:
133859: ELSE null

Line 133856: WHEN 15 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

133852: WHEN 11 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133853: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133854: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133855: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133856: WHEN 15 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133857: WHEN 16 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133858:
133859: ELSE null
133860: END object_name

Line 133857: WHEN 16 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

133853: WHEN 12 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133854: WHEN 13 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133855: WHEN 14 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133856: WHEN 15 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133857: WHEN 16 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133858:
133859: ELSE null
133860: END object_name
133861: , CASE r

Line 133944: , AP_INVOICE_EXTRACT_DETAILS_V l1

133940: ELSE null
133941: END source_value
133942: , null source_meaning
133943: FROM xla_events_gt xet
133944: , AP_INVOICE_EXTRACT_DETAILS_V l1
133945: , ZX_AP_DEF_TAX_EXTRACT_V l3
133946: , ZX_AP_TAX_JRNL_LINE_DESC_V l4
133947: , (select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
133948: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 134090: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;

134086: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
134087: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
134088: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
134089:
134090: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
134091: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
134092: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
134093: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
134094: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 134091: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

134087: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
134088: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
134089:
134090: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
134091: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
134092: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
134093: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
134094: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
134095: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 134093: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

134089:
134090: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
134091: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
134092: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
134093: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
134094: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
134095: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
134096: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;
134097: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 134095: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;

134091: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
134092: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
134093: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
134094: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
134095: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
134096: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;
134097: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
134098: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
134099: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 134096: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;

134092: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
134093: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
134094: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
134095: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
134096: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;
134097: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
134098: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
134099: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
134100: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 134097: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

134093: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
134094: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
134095: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
134096: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;
134097: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
134098: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
134099: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
134100: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
134101: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;

Line 134098: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;

134094: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
134095: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
134096: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;
134097: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
134098: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
134099: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
134100: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
134101: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
134102: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 134099: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;

134095: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
134096: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;
134097: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
134098: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
134099: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
134100: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
134101: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
134102: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
134103: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 134100: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

134096: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;
134097: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
134098: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
134099: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
134100: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
134101: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
134102: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
134103: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
134104: TYPE t_array_source_156 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 134101: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;

134097: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
134098: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
134099: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
134100: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
134101: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
134102: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
134103: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
134104: TYPE t_array_source_156 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
134105: TYPE t_array_source_157 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;

Line 134102: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

134098: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
134099: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
134100: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
134101: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
134102: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
134103: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
134104: TYPE t_array_source_156 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
134105: TYPE t_array_source_157 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
134106:

Line 134103: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

134099: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
134100: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
134101: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
134102: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
134103: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
134104: TYPE t_array_source_156 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
134105: TYPE t_array_source_157 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
134106:
134107: l_array_source_56 t_array_source_56;

Line 134104: TYPE t_array_source_156 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

134100: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
134101: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
134102: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
134103: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
134104: TYPE t_array_source_156 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
134105: TYPE t_array_source_157 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
134106:
134107: l_array_source_56 t_array_source_56;
134108: l_array_source_80 t_array_source_80;

Line 134105: TYPE t_array_source_157 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;

134101: TYPE t_array_source_86 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
134102: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
134103: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
134104: TYPE t_array_source_156 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
134105: TYPE t_array_source_157 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
134106:
134107: l_array_source_56 t_array_source_56;
134108: l_array_source_80 t_array_source_80;
134109: l_array_source_152 t_array_source_152;

Line 134221: , AP_INVOICE_EXTRACT_DETAILS_V l1

134217: , l1.UPG_DR_ENC_TYPE_ID source_97
134218: , l1.AID_INVOICE_DIST_ID source_156
134219: , l1.AID_PARENT_REVERSAL_ID source_157
134220: FROM xla_events_gt xet
134221: , AP_INVOICE_EXTRACT_DETAILS_V l1
134222: , ZX_AP_DEF_TAX_EXTRACT_V l3
134223: , ZX_AP_TAX_JRNL_LINE_DESC_V l4
134224: WHERE xet.event_id between x_first_event_id and x_last_event_id
134225: and xet.event_date between p_pad_start_date and p_pad_end_date