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

APPS.XLA_00200_AAD_S_000012_BC_PKG dependencies on FV_XLA_AP_REF_V

Line 36588: WHEN 3 THEN 'FV_XLA_AP_REF_V'

36584: , l1.line_number line_number
36585: , CASE r
36586: WHEN 1 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36587: WHEN 2 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36588: WHEN 3 THEN 'FV_XLA_AP_REF_V'
36589: WHEN 4 THEN 'FV_XLA_AP_REF_V'
36590: WHEN 5 THEN 'FV_XLA_AP_REF_V'
36591: WHEN 6 THEN 'FV_XLA_AP_REF_V'
36592: WHEN 7 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 36589: WHEN 4 THEN 'FV_XLA_AP_REF_V'

36585: , CASE r
36586: WHEN 1 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36587: WHEN 2 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36588: WHEN 3 THEN 'FV_XLA_AP_REF_V'
36589: WHEN 4 THEN 'FV_XLA_AP_REF_V'
36590: WHEN 5 THEN 'FV_XLA_AP_REF_V'
36591: WHEN 6 THEN 'FV_XLA_AP_REF_V'
36592: WHEN 7 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36593: WHEN 8 THEN 'FV_XLA_AP_REF_V'

Line 36590: WHEN 5 THEN 'FV_XLA_AP_REF_V'

36586: WHEN 1 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36587: WHEN 2 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36588: WHEN 3 THEN 'FV_XLA_AP_REF_V'
36589: WHEN 4 THEN 'FV_XLA_AP_REF_V'
36590: WHEN 5 THEN 'FV_XLA_AP_REF_V'
36591: WHEN 6 THEN 'FV_XLA_AP_REF_V'
36592: WHEN 7 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36593: WHEN 8 THEN 'FV_XLA_AP_REF_V'
36594: WHEN 9 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 36591: WHEN 6 THEN 'FV_XLA_AP_REF_V'

36587: WHEN 2 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36588: WHEN 3 THEN 'FV_XLA_AP_REF_V'
36589: WHEN 4 THEN 'FV_XLA_AP_REF_V'
36590: WHEN 5 THEN 'FV_XLA_AP_REF_V'
36591: WHEN 6 THEN 'FV_XLA_AP_REF_V'
36592: WHEN 7 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36593: WHEN 8 THEN 'FV_XLA_AP_REF_V'
36594: WHEN 9 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36595: WHEN 10 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 36593: WHEN 8 THEN 'FV_XLA_AP_REF_V'

36589: WHEN 4 THEN 'FV_XLA_AP_REF_V'
36590: WHEN 5 THEN 'FV_XLA_AP_REF_V'
36591: WHEN 6 THEN 'FV_XLA_AP_REF_V'
36592: WHEN 7 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36593: WHEN 8 THEN 'FV_XLA_AP_REF_V'
36594: WHEN 9 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36595: WHEN 10 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36596: WHEN 11 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36597: WHEN 12 THEN 'FV_XLA_AP_REF_V'

Line 36597: WHEN 12 THEN 'FV_XLA_AP_REF_V'

36593: WHEN 8 THEN 'FV_XLA_AP_REF_V'
36594: WHEN 9 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36595: WHEN 10 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36596: WHEN 11 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36597: WHEN 12 THEN 'FV_XLA_AP_REF_V'
36598: WHEN 13 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36599: WHEN 14 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36600: WHEN 15 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36601: WHEN 16 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 36614: WHEN 29 THEN 'FV_XLA_AP_REF_V'

36610: WHEN 25 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36611: WHEN 26 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36612: WHEN 27 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36613: WHEN 28 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36614: WHEN 29 THEN 'FV_XLA_AP_REF_V'
36615: WHEN 30 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36616: WHEN 31 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36617: WHEN 32 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36618: WHEN 33 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 36627: WHEN 42 THEN 'FV_XLA_AP_REF_V'

36623: WHEN 38 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36624: WHEN 39 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36625: WHEN 40 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36626: WHEN 41 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36627: WHEN 42 THEN 'FV_XLA_AP_REF_V'
36628: WHEN 43 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36629: WHEN 44 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36630:
36631: ELSE null

Line 36835: , FV_XLA_AP_REF_V l3

36831: ELSE null
36832: END source_meaning
36833: FROM xla_events_gt xet
36834: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
36835: , FV_XLA_AP_REF_V l3
36836: , ZX_AP_DEF_TAX_EXTRACT_V l4
36837: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
36838: , fnd_lookup_values fvl8
36839: , fnd_lookup_values fvl11

Line 37007: TYPE t_array_source_3 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ANTICIPATION%TYPE INDEX BY BINARY_INTEGER;

37003: TYPE t_array_source_73 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
37004:
37005: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
37006: TYPE t_array_source_2 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
37007: TYPE t_array_source_3 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ANTICIPATION%TYPE INDEX BY BINARY_INTEGER;
37008: TYPE t_array_source_4 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
37009: TYPE t_array_source_5 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
37010: TYPE t_array_source_6 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CAT_DESC%TYPE INDEX BY BINARY_INTEGER;
37011: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 37008: TYPE t_array_source_4 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

37004:
37005: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
37006: TYPE t_array_source_2 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
37007: TYPE t_array_source_3 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ANTICIPATION%TYPE INDEX BY BINARY_INTEGER;
37008: TYPE t_array_source_4 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
37009: TYPE t_array_source_5 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
37010: TYPE t_array_source_6 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CAT_DESC%TYPE INDEX BY BINARY_INTEGER;
37011: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
37012: TYPE t_array_source_9 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 37009: TYPE t_array_source_5 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;

37005: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
37006: TYPE t_array_source_2 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
37007: TYPE t_array_source_3 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ANTICIPATION%TYPE INDEX BY BINARY_INTEGER;
37008: TYPE t_array_source_4 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
37009: TYPE t_array_source_5 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
37010: TYPE t_array_source_6 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CAT_DESC%TYPE INDEX BY BINARY_INTEGER;
37011: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
37012: TYPE t_array_source_9 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
37013: TYPE t_array_source_10 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.ENCUMBRANCE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 37010: TYPE t_array_source_6 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CAT_DESC%TYPE INDEX BY BINARY_INTEGER;

37006: TYPE t_array_source_2 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
37007: TYPE t_array_source_3 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ANTICIPATION%TYPE INDEX BY BINARY_INTEGER;
37008: TYPE t_array_source_4 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
37009: TYPE t_array_source_5 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
37010: TYPE t_array_source_6 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CAT_DESC%TYPE INDEX BY BINARY_INTEGER;
37011: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
37012: TYPE t_array_source_9 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
37013: TYPE t_array_source_10 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.ENCUMBRANCE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
37014: TYPE t_array_source_11 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.POD_ACCRUE_ON_RECEIPT_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 37012: TYPE t_array_source_9 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;

37008: TYPE t_array_source_4 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
37009: TYPE t_array_source_5 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
37010: TYPE t_array_source_6 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CAT_DESC%TYPE INDEX BY BINARY_INTEGER;
37011: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
37012: TYPE t_array_source_9 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
37013: TYPE t_array_source_10 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.ENCUMBRANCE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
37014: TYPE t_array_source_11 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.POD_ACCRUE_ON_RECEIPT_FLAG%TYPE INDEX BY BINARY_INTEGER;
37015: TYPE t_array_source_12 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
37016: TYPE t_array_source_14 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 37016: TYPE t_array_source_14 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

37012: TYPE t_array_source_9 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
37013: TYPE t_array_source_10 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.ENCUMBRANCE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
37014: TYPE t_array_source_11 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.POD_ACCRUE_ON_RECEIPT_FLAG%TYPE INDEX BY BINARY_INTEGER;
37015: TYPE t_array_source_12 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
37016: TYPE t_array_source_14 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
37017: TYPE t_array_source_15 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
37018: TYPE t_array_source_17 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
37019: TYPE t_array_source_19 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.ALLOC_TO_MAIN_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
37020: TYPE t_array_source_21 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;

Line 37033: TYPE t_array_source_35 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;

37029: TYPE t_array_source_31 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
37030: TYPE t_array_source_32 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
37031: TYPE t_array_source_33 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
37032: TYPE t_array_source_34 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
37033: TYPE t_array_source_35 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
37034: TYPE t_array_source_39 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.DEFERRED_END_DATE%TYPE INDEX BY BINARY_INTEGER;
37035: TYPE t_array_source_40 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.DEFERRED_OPTION%TYPE INDEX BY BINARY_INTEGER;
37036: TYPE t_array_source_41 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.DEFERRED_START_DATE%TYPE INDEX BY BINARY_INTEGER;
37037: TYPE t_array_source_42 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 37046: TYPE t_array_source_54 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;

37042: TYPE t_array_source_50 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
37043: TYPE t_array_source_51 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
37044: TYPE t_array_source_52 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
37045: TYPE t_array_source_53 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.ENCUMBRANCE_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
37046: TYPE t_array_source_54 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
37047: TYPE t_array_source_55 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
37048: TYPE t_array_source_56 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
37049:
37050: l_array_source_7 t_array_source_7;

Line 37250: , FV_XLA_AP_REF_V l3

37246: , l1.AID_AMOUNT source_55
37247: , l1.INV_DIST_BASE_AMOUNT source_56
37248: FROM xla_events_gt xet
37249: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
37250: , FV_XLA_AP_REF_V l3
37251: , ZX_AP_DEF_TAX_EXTRACT_V l4
37252: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
37253: , fnd_lookup_values fvl8
37254: , fnd_lookup_values fvl11

Line 38933: WHEN 3 THEN 'FV_XLA_AP_REF_V'

38929: , l1.line_number line_number
38930: , CASE r
38931: WHEN 1 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38932: WHEN 2 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38933: WHEN 3 THEN 'FV_XLA_AP_REF_V'
38934: WHEN 4 THEN 'FV_XLA_AP_REF_V'
38935: WHEN 5 THEN 'FV_XLA_AP_REF_V'
38936: WHEN 6 THEN 'FV_XLA_AP_REF_V'
38937: WHEN 7 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 38934: WHEN 4 THEN 'FV_XLA_AP_REF_V'

38930: , CASE r
38931: WHEN 1 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38932: WHEN 2 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38933: WHEN 3 THEN 'FV_XLA_AP_REF_V'
38934: WHEN 4 THEN 'FV_XLA_AP_REF_V'
38935: WHEN 5 THEN 'FV_XLA_AP_REF_V'
38936: WHEN 6 THEN 'FV_XLA_AP_REF_V'
38937: WHEN 7 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38938: WHEN 8 THEN 'FV_XLA_AP_REF_V'

Line 38935: WHEN 5 THEN 'FV_XLA_AP_REF_V'

38931: WHEN 1 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38932: WHEN 2 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38933: WHEN 3 THEN 'FV_XLA_AP_REF_V'
38934: WHEN 4 THEN 'FV_XLA_AP_REF_V'
38935: WHEN 5 THEN 'FV_XLA_AP_REF_V'
38936: WHEN 6 THEN 'FV_XLA_AP_REF_V'
38937: WHEN 7 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38938: WHEN 8 THEN 'FV_XLA_AP_REF_V'
38939: WHEN 9 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 38936: WHEN 6 THEN 'FV_XLA_AP_REF_V'

38932: WHEN 2 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38933: WHEN 3 THEN 'FV_XLA_AP_REF_V'
38934: WHEN 4 THEN 'FV_XLA_AP_REF_V'
38935: WHEN 5 THEN 'FV_XLA_AP_REF_V'
38936: WHEN 6 THEN 'FV_XLA_AP_REF_V'
38937: WHEN 7 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38938: WHEN 8 THEN 'FV_XLA_AP_REF_V'
38939: WHEN 9 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38940: WHEN 10 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 38938: WHEN 8 THEN 'FV_XLA_AP_REF_V'

38934: WHEN 4 THEN 'FV_XLA_AP_REF_V'
38935: WHEN 5 THEN 'FV_XLA_AP_REF_V'
38936: WHEN 6 THEN 'FV_XLA_AP_REF_V'
38937: WHEN 7 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38938: WHEN 8 THEN 'FV_XLA_AP_REF_V'
38939: WHEN 9 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38940: WHEN 10 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38941: WHEN 11 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38942: WHEN 12 THEN 'FV_XLA_AP_REF_V'

Line 38942: WHEN 12 THEN 'FV_XLA_AP_REF_V'

38938: WHEN 8 THEN 'FV_XLA_AP_REF_V'
38939: WHEN 9 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38940: WHEN 10 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38941: WHEN 11 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38942: WHEN 12 THEN 'FV_XLA_AP_REF_V'
38943: WHEN 13 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38944: WHEN 14 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38945: WHEN 15 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38946: WHEN 16 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 38959: WHEN 29 THEN 'FV_XLA_AP_REF_V'

38955: WHEN 25 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38956: WHEN 26 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38957: WHEN 27 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38958: WHEN 28 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38959: WHEN 29 THEN 'FV_XLA_AP_REF_V'
38960: WHEN 30 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38961: WHEN 31 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38962: WHEN 32 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38963: WHEN 33 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 38971: WHEN 41 THEN 'FV_XLA_AP_REF_V'

38967: WHEN 37 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38968: WHEN 38 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38969: WHEN 39 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38970: WHEN 40 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38971: WHEN 41 THEN 'FV_XLA_AP_REF_V'
38972: WHEN 42 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38973: WHEN 43 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38974: WHEN 44 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38975:

Line 39180: , FV_XLA_AP_REF_V l3

39176: ELSE null
39177: END source_meaning
39178: FROM xla_events_gt xet
39179: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
39180: , FV_XLA_AP_REF_V l3
39181: , ZX_AP_DEF_TAX_EXTRACT_V l4
39182: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
39183: , fnd_lookup_values fvl8
39184: , fnd_lookup_values fvl11

Line 39352: TYPE t_array_source_3 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ANTICIPATION%TYPE INDEX BY BINARY_INTEGER;

39348: TYPE t_array_source_73 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
39349:
39350: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
39351: TYPE t_array_source_2 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
39352: TYPE t_array_source_3 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ANTICIPATION%TYPE INDEX BY BINARY_INTEGER;
39353: TYPE t_array_source_4 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
39354: TYPE t_array_source_5 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
39355: TYPE t_array_source_6 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CAT_DESC%TYPE INDEX BY BINARY_INTEGER;
39356: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 39353: TYPE t_array_source_4 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

39349:
39350: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
39351: TYPE t_array_source_2 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
39352: TYPE t_array_source_3 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ANTICIPATION%TYPE INDEX BY BINARY_INTEGER;
39353: TYPE t_array_source_4 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
39354: TYPE t_array_source_5 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
39355: TYPE t_array_source_6 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CAT_DESC%TYPE INDEX BY BINARY_INTEGER;
39356: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
39357: TYPE t_array_source_9 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 39354: TYPE t_array_source_5 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;

39350: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
39351: TYPE t_array_source_2 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
39352: TYPE t_array_source_3 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ANTICIPATION%TYPE INDEX BY BINARY_INTEGER;
39353: TYPE t_array_source_4 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
39354: TYPE t_array_source_5 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
39355: TYPE t_array_source_6 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CAT_DESC%TYPE INDEX BY BINARY_INTEGER;
39356: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
39357: TYPE t_array_source_9 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
39358: TYPE t_array_source_10 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.ENCUMBRANCE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 39355: TYPE t_array_source_6 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CAT_DESC%TYPE INDEX BY BINARY_INTEGER;

39351: TYPE t_array_source_2 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
39352: TYPE t_array_source_3 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ANTICIPATION%TYPE INDEX BY BINARY_INTEGER;
39353: TYPE t_array_source_4 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
39354: TYPE t_array_source_5 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
39355: TYPE t_array_source_6 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CAT_DESC%TYPE INDEX BY BINARY_INTEGER;
39356: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
39357: TYPE t_array_source_9 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
39358: TYPE t_array_source_10 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.ENCUMBRANCE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
39359: TYPE t_array_source_11 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.POD_ACCRUE_ON_RECEIPT_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 39357: TYPE t_array_source_9 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;

39353: TYPE t_array_source_4 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
39354: TYPE t_array_source_5 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
39355: TYPE t_array_source_6 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CAT_DESC%TYPE INDEX BY BINARY_INTEGER;
39356: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
39357: TYPE t_array_source_9 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
39358: TYPE t_array_source_10 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.ENCUMBRANCE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
39359: TYPE t_array_source_11 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.POD_ACCRUE_ON_RECEIPT_FLAG%TYPE INDEX BY BINARY_INTEGER;
39360: TYPE t_array_source_12 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
39361: TYPE t_array_source_14 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 39361: TYPE t_array_source_14 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

39357: TYPE t_array_source_9 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
39358: TYPE t_array_source_10 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.ENCUMBRANCE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
39359: TYPE t_array_source_11 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.POD_ACCRUE_ON_RECEIPT_FLAG%TYPE INDEX BY BINARY_INTEGER;
39360: TYPE t_array_source_12 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
39361: TYPE t_array_source_14 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
39362: TYPE t_array_source_15 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
39363: TYPE t_array_source_17 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
39364: TYPE t_array_source_19 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.ALLOC_TO_MAIN_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
39365: TYPE t_array_source_21 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;

Line 39378: TYPE t_array_source_35 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;

39374: TYPE t_array_source_31 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
39375: TYPE t_array_source_32 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
39376: TYPE t_array_source_33 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
39377: TYPE t_array_source_34 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
39378: TYPE t_array_source_35 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
39379: TYPE t_array_source_39 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.DEFERRED_END_DATE%TYPE INDEX BY BINARY_INTEGER;
39380: TYPE t_array_source_40 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.DEFERRED_OPTION%TYPE INDEX BY BINARY_INTEGER;
39381: TYPE t_array_source_41 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.DEFERRED_START_DATE%TYPE INDEX BY BINARY_INTEGER;
39382: TYPE t_array_source_42 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 39390: TYPE t_array_source_54 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;

39386: TYPE t_array_source_50 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
39387: TYPE t_array_source_51 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
39388: TYPE t_array_source_52 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
39389: TYPE t_array_source_53 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.ENCUMBRANCE_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
39390: TYPE t_array_source_54 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
39391: TYPE t_array_source_55 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
39392: TYPE t_array_source_56 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
39393: TYPE t_array_source_58 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
39394:

Line 39595: , FV_XLA_AP_REF_V l3

39591: , l1.INV_DIST_BASE_AMOUNT source_56
39592: , l1.AID_BASE_AMT_NO_ROUND source_58
39593: FROM xla_events_gt xet
39594: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
39595: , FV_XLA_AP_REF_V l3
39596: , ZX_AP_DEF_TAX_EXTRACT_V l4
39597: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
39598: , fnd_lookup_values fvl8
39599: , fnd_lookup_values fvl11

Line 41278: WHEN 3 THEN 'FV_XLA_AP_REF_V'

41274: , l1.line_number line_number
41275: , CASE r
41276: WHEN 1 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41277: WHEN 2 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41278: WHEN 3 THEN 'FV_XLA_AP_REF_V'
41279: WHEN 4 THEN 'FV_XLA_AP_REF_V'
41280: WHEN 5 THEN 'FV_XLA_AP_REF_V'
41281: WHEN 6 THEN 'FV_XLA_AP_REF_V'
41282: WHEN 7 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 41279: WHEN 4 THEN 'FV_XLA_AP_REF_V'

41275: , CASE r
41276: WHEN 1 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41277: WHEN 2 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41278: WHEN 3 THEN 'FV_XLA_AP_REF_V'
41279: WHEN 4 THEN 'FV_XLA_AP_REF_V'
41280: WHEN 5 THEN 'FV_XLA_AP_REF_V'
41281: WHEN 6 THEN 'FV_XLA_AP_REF_V'
41282: WHEN 7 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41283: WHEN 8 THEN 'FV_XLA_AP_REF_V'

Line 41280: WHEN 5 THEN 'FV_XLA_AP_REF_V'

41276: WHEN 1 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41277: WHEN 2 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41278: WHEN 3 THEN 'FV_XLA_AP_REF_V'
41279: WHEN 4 THEN 'FV_XLA_AP_REF_V'
41280: WHEN 5 THEN 'FV_XLA_AP_REF_V'
41281: WHEN 6 THEN 'FV_XLA_AP_REF_V'
41282: WHEN 7 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41283: WHEN 8 THEN 'FV_XLA_AP_REF_V'
41284: WHEN 9 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 41281: WHEN 6 THEN 'FV_XLA_AP_REF_V'

41277: WHEN 2 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41278: WHEN 3 THEN 'FV_XLA_AP_REF_V'
41279: WHEN 4 THEN 'FV_XLA_AP_REF_V'
41280: WHEN 5 THEN 'FV_XLA_AP_REF_V'
41281: WHEN 6 THEN 'FV_XLA_AP_REF_V'
41282: WHEN 7 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41283: WHEN 8 THEN 'FV_XLA_AP_REF_V'
41284: WHEN 9 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41285: WHEN 10 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 41283: WHEN 8 THEN 'FV_XLA_AP_REF_V'

41279: WHEN 4 THEN 'FV_XLA_AP_REF_V'
41280: WHEN 5 THEN 'FV_XLA_AP_REF_V'
41281: WHEN 6 THEN 'FV_XLA_AP_REF_V'
41282: WHEN 7 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41283: WHEN 8 THEN 'FV_XLA_AP_REF_V'
41284: WHEN 9 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41285: WHEN 10 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41286: WHEN 11 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41287: WHEN 12 THEN 'FV_XLA_AP_REF_V'

Line 41287: WHEN 12 THEN 'FV_XLA_AP_REF_V'

41283: WHEN 8 THEN 'FV_XLA_AP_REF_V'
41284: WHEN 9 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41285: WHEN 10 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41286: WHEN 11 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41287: WHEN 12 THEN 'FV_XLA_AP_REF_V'
41288: WHEN 13 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41289: WHEN 14 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41290: WHEN 15 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41291: WHEN 16 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 41304: WHEN 29 THEN 'FV_XLA_AP_REF_V'

41300: WHEN 25 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41301: WHEN 26 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41302: WHEN 27 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41303: WHEN 28 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41304: WHEN 29 THEN 'FV_XLA_AP_REF_V'
41305: WHEN 30 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41306: WHEN 31 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41307: WHEN 32 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41308: WHEN 33 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 41317: WHEN 42 THEN 'FV_XLA_AP_REF_V'

41313: WHEN 38 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41314: WHEN 39 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41315: WHEN 40 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41316: WHEN 41 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41317: WHEN 42 THEN 'FV_XLA_AP_REF_V'
41318: WHEN 43 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41319: WHEN 44 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41320: WHEN 45 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41321: WHEN 46 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 41330: WHEN 55 THEN 'FV_XLA_AP_REF_V'

41326: WHEN 51 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41327: WHEN 52 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41328: WHEN 53 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41329: WHEN 54 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41330: WHEN 55 THEN 'FV_XLA_AP_REF_V'
41331:
41332: ELSE null
41333: END object_name
41334: , CASE r

Line 41580: , FV_XLA_AP_REF_V l4

41576: ELSE null
41577: END source_meaning
41578: FROM xla_events_gt xet
41579: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
41580: , FV_XLA_AP_REF_V l4
41581: , ZX_AP_DEF_TAX_EXTRACT_V l5
41582: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
41583: , fnd_lookup_values fvl8
41584: , fnd_lookup_values fvl11

Line 41753: TYPE t_array_source_3 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ANTICIPATION%TYPE INDEX BY BINARY_INTEGER;

41749: TYPE t_array_source_73 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
41750:
41751: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
41752: TYPE t_array_source_2 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
41753: TYPE t_array_source_3 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ANTICIPATION%TYPE INDEX BY BINARY_INTEGER;
41754: TYPE t_array_source_4 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
41755: TYPE t_array_source_5 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
41756: TYPE t_array_source_6 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CAT_DESC%TYPE INDEX BY BINARY_INTEGER;
41757: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 41754: TYPE t_array_source_4 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

41750:
41751: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
41752: TYPE t_array_source_2 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
41753: TYPE t_array_source_3 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ANTICIPATION%TYPE INDEX BY BINARY_INTEGER;
41754: TYPE t_array_source_4 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
41755: TYPE t_array_source_5 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
41756: TYPE t_array_source_6 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CAT_DESC%TYPE INDEX BY BINARY_INTEGER;
41757: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
41758: TYPE t_array_source_9 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 41755: TYPE t_array_source_5 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;

41751: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
41752: TYPE t_array_source_2 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
41753: TYPE t_array_source_3 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ANTICIPATION%TYPE INDEX BY BINARY_INTEGER;
41754: TYPE t_array_source_4 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
41755: TYPE t_array_source_5 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
41756: TYPE t_array_source_6 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CAT_DESC%TYPE INDEX BY BINARY_INTEGER;
41757: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
41758: TYPE t_array_source_9 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
41759: TYPE t_array_source_10 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.ENCUMBRANCE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 41756: TYPE t_array_source_6 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CAT_DESC%TYPE INDEX BY BINARY_INTEGER;

41752: TYPE t_array_source_2 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
41753: TYPE t_array_source_3 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ANTICIPATION%TYPE INDEX BY BINARY_INTEGER;
41754: TYPE t_array_source_4 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
41755: TYPE t_array_source_5 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
41756: TYPE t_array_source_6 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CAT_DESC%TYPE INDEX BY BINARY_INTEGER;
41757: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
41758: TYPE t_array_source_9 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
41759: TYPE t_array_source_10 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.ENCUMBRANCE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
41760: TYPE t_array_source_11 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.POD_ACCRUE_ON_RECEIPT_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 41758: TYPE t_array_source_9 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;

41754: TYPE t_array_source_4 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
41755: TYPE t_array_source_5 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
41756: TYPE t_array_source_6 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CAT_DESC%TYPE INDEX BY BINARY_INTEGER;
41757: TYPE t_array_source_8 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
41758: TYPE t_array_source_9 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
41759: TYPE t_array_source_10 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.ENCUMBRANCE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
41760: TYPE t_array_source_11 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.POD_ACCRUE_ON_RECEIPT_FLAG%TYPE INDEX BY BINARY_INTEGER;
41761: TYPE t_array_source_12 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
41762: TYPE t_array_source_14 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 41762: TYPE t_array_source_14 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

41758: TYPE t_array_source_9 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
41759: TYPE t_array_source_10 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.ENCUMBRANCE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
41760: TYPE t_array_source_11 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.POD_ACCRUE_ON_RECEIPT_FLAG%TYPE INDEX BY BINARY_INTEGER;
41761: TYPE t_array_source_12 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
41762: TYPE t_array_source_14 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
41763: TYPE t_array_source_15 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
41764: TYPE t_array_source_17 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
41765: TYPE t_array_source_19 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.ALLOC_TO_MAIN_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
41766: TYPE t_array_source_21 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;

Line 41779: TYPE t_array_source_35 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;

41775: TYPE t_array_source_31 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
41776: TYPE t_array_source_32 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_ENC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
41777: TYPE t_array_source_33 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_ENC_DR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
41778: TYPE t_array_source_34 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_AP_ENCUM_OPTION%TYPE INDEX BY BINARY_INTEGER;
41779: TYPE t_array_source_35 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
41780: TYPE t_array_source_39 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.DEFERRED_END_DATE%TYPE INDEX BY BINARY_INTEGER;
41781: TYPE t_array_source_40 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.DEFERRED_OPTION%TYPE INDEX BY BINARY_INTEGER;
41782: TYPE t_array_source_41 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.DEFERRED_START_DATE%TYPE INDEX BY BINARY_INTEGER;
41783: TYPE t_array_source_42 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 41792: TYPE t_array_source_54 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;

41788: TYPE t_array_source_50 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
41789: TYPE t_array_source_51 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
41790: TYPE t_array_source_52 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
41791: TYPE t_array_source_53 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.ENCUMBRANCE_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
41792: TYPE t_array_source_54 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
41793: TYPE t_array_source_55 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
41794: TYPE t_array_source_56 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
41795: TYPE t_array_source_58 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
41796: TYPE t_array_source_59 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_AMOUNT_VARIANCE%TYPE INDEX BY BINARY_INTEGER;

Line 41805: TYPE t_array_source_69 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_PAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;

41801: TYPE t_array_source_65 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.BUS_FLOW_PO_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
41802: TYPE t_array_source_66 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.BUS_FLOW_PO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
41803: TYPE t_array_source_67 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.BUS_FLOW_PO_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
41804: TYPE t_array_source_68 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.BUS_FLOW_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
41805: TYPE t_array_source_69 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_PAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
41806:
41807: l_array_source_7 t_array_source_7;
41808: l_array_source_13 t_array_source_13;
41809: l_array_source_13_meaning t_array_lookup_meaning;

Line 42039: , FV_XLA_AP_REF_V l4

42035: , l1.BUS_FLOW_PO_DOC_ID source_68
42036: , l4.FEDERAL_PAID_UNEXP_OBG_AMT source_69
42037: FROM xla_events_gt xet
42038: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
42039: , FV_XLA_AP_REF_V l4
42040: , ZX_AP_DEF_TAX_EXTRACT_V l5
42041: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
42042: , fnd_lookup_values fvl8
42043: , fnd_lookup_values fvl11

Line 44296: WHEN 3 THEN 'FV_XLA_AP_REF_V'

44292: , l1.line_number line_number
44293: , CASE r
44294: WHEN 1 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
44295: WHEN 2 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
44296: WHEN 3 THEN 'FV_XLA_AP_REF_V'
44297: WHEN 4 THEN 'FV_XLA_AP_REF_V'
44298: WHEN 5 THEN 'FV_XLA_AP_REF_V'
44299: WHEN 6 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
44300: WHEN 7 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 44297: WHEN 4 THEN 'FV_XLA_AP_REF_V'

44293: , CASE r
44294: WHEN 1 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
44295: WHEN 2 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
44296: WHEN 3 THEN 'FV_XLA_AP_REF_V'
44297: WHEN 4 THEN 'FV_XLA_AP_REF_V'
44298: WHEN 5 THEN 'FV_XLA_AP_REF_V'
44299: WHEN 6 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
44300: WHEN 7 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
44301: WHEN 8 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 44298: WHEN 5 THEN 'FV_XLA_AP_REF_V'

44294: WHEN 1 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
44295: WHEN 2 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
44296: WHEN 3 THEN 'FV_XLA_AP_REF_V'
44297: WHEN 4 THEN 'FV_XLA_AP_REF_V'
44298: WHEN 5 THEN 'FV_XLA_AP_REF_V'
44299: WHEN 6 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
44300: WHEN 7 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
44301: WHEN 8 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
44302: WHEN 9 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 44496: , FV_XLA_AP_REF_V l3

44492: ELSE null
44493: END source_meaning
44494: FROM xla_events_gt xet
44495: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
44496: , FV_XLA_AP_REF_V l3
44497: , ZX_AP_DEF_TAX_EXTRACT_V l4
44498: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
44499: , fnd_lookup_values fvl42
44500: , (select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)

Line 44656: TYPE t_array_source_4 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

44652: TYPE t_array_source_73 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
44653:
44654: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
44655: TYPE t_array_source_2 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
44656: TYPE t_array_source_4 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
44657: TYPE t_array_source_5 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
44658: TYPE t_array_source_6 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CAT_DESC%TYPE INDEX BY BINARY_INTEGER;
44659: TYPE t_array_source_15 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
44660: TYPE t_array_source_17 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 44657: TYPE t_array_source_5 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;

44653:
44654: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
44655: TYPE t_array_source_2 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
44656: TYPE t_array_source_4 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
44657: TYPE t_array_source_5 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
44658: TYPE t_array_source_6 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CAT_DESC%TYPE INDEX BY BINARY_INTEGER;
44659: TYPE t_array_source_15 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
44660: TYPE t_array_source_17 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
44661: TYPE t_array_source_19 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.ALLOC_TO_MAIN_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 44658: TYPE t_array_source_6 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CAT_DESC%TYPE INDEX BY BINARY_INTEGER;

44654: TYPE t_array_source_1 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
44655: TYPE t_array_source_2 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
44656: TYPE t_array_source_4 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
44657: TYPE t_array_source_5 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
44658: TYPE t_array_source_6 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CAT_DESC%TYPE INDEX BY BINARY_INTEGER;
44659: TYPE t_array_source_15 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
44660: TYPE t_array_source_17 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
44661: TYPE t_array_source_19 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.ALLOC_TO_MAIN_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
44662: TYPE t_array_source_21 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;

Line 44866: , FV_XLA_AP_REF_V l3

44862: , l1.INV_DIST_BASE_AMOUNT source_56
44863: , l1.POD_PO_DISTRIBUTION_ID source_70
44864: FROM xla_events_gt xet
44865: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
44866: , FV_XLA_AP_REF_V l3
44867: , ZX_AP_DEF_TAX_EXTRACT_V l4
44868: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
44869: , fnd_lookup_values fvl42
44870: WHERE xet.event_id between x_first_event_id and x_last_event_id