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.

[Home] [Help]

APPS.XLA_00200_AAD_S_000012_PKG dependencies on ZX_AP_DEF_TAX_EXTRACT_V

Line 152825: WHEN 37 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

152821: WHEN 33 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
152822: WHEN 34 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
152823: WHEN 35 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
152824: WHEN 36 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
152825: WHEN 37 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
152826: WHEN 38 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
152827: WHEN 39 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
152828: WHEN 40 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
152829: WHEN 41 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 153056: , ZX_AP_DEF_TAX_EXTRACT_V l5

153052: END source_meaning
153053: FROM xla_events_gt xet
153054: , AP_INVOICE_EXTRACT_DETAILS_V l1
153055: , AP_PO_HEADERS_EXTRACT_V l3
153056: , ZX_AP_DEF_TAX_EXTRACT_V l5
153057: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153058: , fnd_lookup_values fvl17
153059: , fnd_lookup_values fvl28
153060: , fnd_lookup_values fvl54

Line 153275: TYPE t_array_source_91 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

153271: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DEFERRED_START_DATE%TYPE INDEX BY BINARY_INTEGER;
153272: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
153273: TYPE t_array_source_89 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
153274: TYPE t_array_source_90 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_STAT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
153275: TYPE t_array_source_91 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
153276: TYPE t_array_source_92 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
153277: TYPE t_array_source_93 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
153278: TYPE t_array_source_94 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
153279: TYPE t_array_source_95 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 153523: , ZX_AP_DEF_TAX_EXTRACT_V l5

153519: , fvl145.meaning source_145_meaning
153520: FROM xla_events_gt xet
153521: , AP_INVOICE_EXTRACT_DETAILS_V l1
153522: , AP_PO_HEADERS_EXTRACT_V l3
153523: , ZX_AP_DEF_TAX_EXTRACT_V l5
153524: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153525: , fnd_lookup_values fvl17
153526: , fnd_lookup_values fvl28
153527: , fnd_lookup_values fvl54

Line 156067: WHEN 36 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

156063: WHEN 32 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
156064: WHEN 33 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
156065: WHEN 34 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
156066: WHEN 35 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
156067: WHEN 36 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
156068: WHEN 37 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
156069: WHEN 38 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
156070: WHEN 39 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
156071: WHEN 40 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 156294: , ZX_AP_DEF_TAX_EXTRACT_V l5

156290: END source_meaning
156291: FROM xla_events_gt xet
156292: , AP_INVOICE_EXTRACT_DETAILS_V l1
156293: , AP_PO_HEADERS_EXTRACT_V l3
156294: , ZX_AP_DEF_TAX_EXTRACT_V l5
156295: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
156296: , fnd_lookup_values fvl17
156297: , fnd_lookup_values fvl28
156298: , fnd_lookup_values fvl54

Line 156511: TYPE t_array_source_91 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

156507: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DEFERRED_OPTION%TYPE INDEX BY BINARY_INTEGER;
156508: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DEFERRED_START_DATE%TYPE INDEX BY BINARY_INTEGER;
156509: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
156510: TYPE t_array_source_89 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
156511: TYPE t_array_source_91 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
156512: TYPE t_array_source_92 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
156513: TYPE t_array_source_93 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
156514: TYPE t_array_source_94 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
156515: TYPE t_array_source_95 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 156748: , ZX_AP_DEF_TAX_EXTRACT_V l5

156744: , fvl145.meaning source_145_meaning
156745: FROM xla_events_gt xet
156746: , AP_INVOICE_EXTRACT_DETAILS_V l1
156747: , AP_PO_HEADERS_EXTRACT_V l3
156748: , ZX_AP_DEF_TAX_EXTRACT_V l5
156749: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
156750: , fnd_lookup_values fvl17
156751: , fnd_lookup_values fvl28
156752: , fnd_lookup_values fvl54

Line 159260: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

159256: , l1.line_number line_number
159257: , CASE r
159258: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
159259: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
159260: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
159261: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
159262: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
159263: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
159264: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 159280: WHEN 23 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

159276: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
159277: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
159278: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
159279: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
159280: WHEN 23 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
159281: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
159282: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
159283:
159284: ELSE null

Line 159413: , ZX_AP_DEF_TAX_EXTRACT_V l4

159409: ELSE null
159410: END source_meaning
159411: FROM xla_events_gt xet
159412: , AP_PAYMENT_EXTRACT_DETAILS_V l1
159413: , ZX_AP_DEF_TAX_EXTRACT_V l4
159414: , fnd_lookup_values fvl28
159415: , fnd_lookup_values fvl85
159416: , fnd_lookup_values fvl101
159417: , fnd_lookup_values fvl140

Line 159596: TYPE t_array_source_48 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;

159592: TYPE t_array_source_176 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
159593:
159594: TYPE t_array_source_25 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
159595: TYPE t_array_source_28 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
159596: TYPE t_array_source_48 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
159597: TYPE t_array_source_58 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
159598: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
159599: TYPE t_array_source_85 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
159600: TYPE t_array_source_96 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;

Line 159616: TYPE t_array_source_140 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;

159612: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
159613: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
159614: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_INVOICE_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
159615: TYPE t_array_source_124 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_MATURED_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
159616: TYPE t_array_source_140 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;
159617: TYPE t_array_source_157 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.PMT_MAT_BASE_AMT_DIFF%TYPE INDEX BY BINARY_INTEGER;
159618: TYPE t_array_source_164 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.PMT_MAT_GAIN_LOSS_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
159619:
159620: l_array_source_4 t_array_source_4;

Line 159817: , ZX_AP_DEF_TAX_EXTRACT_V l4

159813: , l1.PMT_MAT_BASE_AMT_DIFF source_157
159814: , l1.PMT_MAT_GAIN_LOSS_INDICATOR source_164
159815: FROM xla_events_gt xet
159816: , AP_PAYMENT_EXTRACT_DETAILS_V l1
159817: , ZX_AP_DEF_TAX_EXTRACT_V l4
159818: , fnd_lookup_values fvl28
159819: , fnd_lookup_values fvl85
159820: , fnd_lookup_values fvl101
159821: , fnd_lookup_values fvl140

Line 161594: WHEN 37 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

161590: WHEN 33 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
161591: WHEN 34 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
161592: WHEN 35 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
161593: WHEN 36 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
161594: WHEN 37 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
161595: WHEN 38 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
161596: WHEN 39 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
161597: WHEN 40 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
161598: WHEN 41 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 161835: , ZX_AP_DEF_TAX_EXTRACT_V l5

161831: END source_meaning
161832: FROM xla_events_gt xet
161833: , AP_INVOICE_EXTRACT_DETAILS_V l1
161834: , AP_PO_HEADERS_EXTRACT_V l3
161835: , ZX_AP_DEF_TAX_EXTRACT_V l5
161836: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
161837: , fnd_lookup_values fvl17
161838: , fnd_lookup_values fvl28
161839: , fnd_lookup_values fvl54

Line 162054: TYPE t_array_source_91 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

162050: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DEFERRED_START_DATE%TYPE INDEX BY BINARY_INTEGER;
162051: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
162052: TYPE t_array_source_89 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
162053: TYPE t_array_source_90 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_STAT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
162054: TYPE t_array_source_91 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
162055: TYPE t_array_source_92 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
162056: TYPE t_array_source_93 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
162057: TYPE t_array_source_94 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
162058: TYPE t_array_source_95 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 162308: , ZX_AP_DEF_TAX_EXTRACT_V l5

162304: , l1.BUS_FLOW_RET_INV_ID source_169
162305: FROM xla_events_gt xet
162306: , AP_INVOICE_EXTRACT_DETAILS_V l1
162307: , AP_PO_HEADERS_EXTRACT_V l3
162308: , ZX_AP_DEF_TAX_EXTRACT_V l5
162309: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
162310: , fnd_lookup_values fvl17
162311: , fnd_lookup_values fvl28
162312: , fnd_lookup_values fvl54

Line 165040: WHEN 7 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

165036: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165037: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165038: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165039: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165040: WHEN 7 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
165041: WHEN 8 THEN 'FV_XLA_AP_REF_V'
165042: WHEN 9 THEN 'FV_XLA_AP_REF_V'
165043: WHEN 10 THEN 'FV_XLA_AP_REF_V'
165044: WHEN 11 THEN 'FV_XLA_AP_REF_V'

Line 165053: WHEN 20 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

165049: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165050: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165051: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165052: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165053: WHEN 20 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
165054: WHEN 21 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
165055: WHEN 22 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
165056: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165057: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 165055: WHEN 22 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

165051: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165052: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165053: WHEN 20 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
165054: WHEN 21 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
165055: WHEN 22 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
165056: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165057: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165058: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165059: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 165068: WHEN 35 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

165064: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165065: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165066: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165067: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165068: WHEN 35 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
165069: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165070: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165071: WHEN 38 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165072: WHEN 39 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 165278: , ZX_AP_DEF_TAX_EXTRACT_V l6

165274: END source_meaning
165275: FROM xla_events_gt xet
165276: , AP_PAYMENT_EXTRACT_DETAILS_V l1
165277: , FV_XLA_AP_REF_V l4
165278: , ZX_AP_DEF_TAX_EXTRACT_V l6
165279: , ZX_AP_TAX_JRNL_LINE_DESC_V l7
165280: , fnd_lookup_values fvl28
165281: , fnd_lookup_values fvl54
165282: , fnd_lookup_values fvl56

Line 165501: TYPE t_array_source_48 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;

165497: TYPE t_array_source_29 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
165498: TYPE t_array_source_39 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AWT_RELATED_DIST_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
165499: TYPE t_array_source_41 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.POD_CCID%TYPE INDEX BY BINARY_INTEGER;
165500: TYPE t_array_source_42 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.PO_VARIANCE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
165501: TYPE t_array_source_48 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
165502: TYPE t_array_source_49 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
165503: TYPE t_array_source_50 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
165504: TYPE t_array_source_51 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_FUND_CAT_DESC%TYPE INDEX BY BINARY_INTEGER;
165505: TYPE t_array_source_52 IS TABLE OF FV_XLA_AP_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 165514: TYPE t_array_source_91 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

165510: TYPE t_array_source_58 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
165511: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
165512: TYPE t_array_source_72 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165513: TYPE t_array_source_85 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165514: TYPE t_array_source_91 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
165515: TYPE t_array_source_92 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
165516: TYPE t_array_source_93 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
165517: TYPE t_array_source_96 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
165518: TYPE t_array_source_97 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 165516: TYPE t_array_source_93 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

165512: TYPE t_array_source_72 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165513: TYPE t_array_source_85 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165514: TYPE t_array_source_91 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
165515: TYPE t_array_source_92 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
165516: TYPE t_array_source_93 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
165517: TYPE t_array_source_96 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
165518: TYPE t_array_source_97 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
165519: TYPE t_array_source_98 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
165520: TYPE t_array_source_99 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 165529: TYPE t_array_source_140 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;

165525: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
165526: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
165527: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_INVOICE_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
165528: TYPE t_array_source_127 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_INVOICE_DIST_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
165529: TYPE t_array_source_140 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;
165530: TYPE t_array_source_141 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AWT_RELATED_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
165531: TYPE t_array_source_146 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
165532: TYPE t_array_source_147 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
165533: TYPE t_array_source_148 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 165843: , ZX_AP_DEF_TAX_EXTRACT_V l6

165839: , fvl166.meaning source_166_meaning
165840: FROM xla_events_gt xet
165841: , AP_PAYMENT_EXTRACT_DETAILS_V l1
165842: , FV_XLA_AP_REF_V l4
165843: , ZX_AP_DEF_TAX_EXTRACT_V l6
165844: , ZX_AP_TAX_JRNL_LINE_DESC_V l7
165845: , fnd_lookup_values fvl28
165846: , fnd_lookup_values fvl54
165847: , fnd_lookup_values fvl56

Line 168669: WHEN 4 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

168665: , CASE r
168666: WHEN 1 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
168667: WHEN 2 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
168668: WHEN 3 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
168669: WHEN 4 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
168670: WHEN 5 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
168671: WHEN 6 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
168672: WHEN 7 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
168673: WHEN 8 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'

Line 168683: WHEN 18 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

168679: WHEN 14 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
168680: WHEN 15 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
168681: WHEN 16 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
168682: WHEN 17 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
168683: WHEN 18 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
168684: WHEN 19 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
168685: WHEN 20 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
168686: WHEN 21 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
168687: WHEN 22 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'

Line 168703: WHEN 38 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

168699: WHEN 34 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
168700: WHEN 35 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
168701: WHEN 36 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
168702: WHEN 37 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
168703: WHEN 38 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
168704: WHEN 39 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
168705: WHEN 40 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
168706: WHEN 41 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
168707: WHEN 42 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'

Line 168936: , ZX_AP_DEF_TAX_EXTRACT_V l5

168932: END source_meaning
168933: FROM xla_events_gt xet
168934: , AP_PREPAYAPP_EXTRACT_DETAILS_V l2
168935: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
168936: , ZX_AP_DEF_TAX_EXTRACT_V l5
168937: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
168938: , fnd_lookup_values fvl85
168939: , fnd_lookup_values fvl129
168940: , fnd_lookup_values fvl140

Line 169110: TYPE t_array_source_48 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;

169106:
169107: TYPE t_array_source_25 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
169108: TYPE t_array_source_31 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
169109: TYPE t_array_source_33 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
169110: TYPE t_array_source_48 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
169111: TYPE t_array_source_58 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
169112: TYPE t_array_source_60 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
169113: TYPE t_array_source_70 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
169114: TYPE t_array_source_71 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 169124: TYPE t_array_source_91 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

169120: TYPE t_array_source_82 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.DEFERRED_END_DATE%TYPE INDEX BY BINARY_INTEGER;
169121: TYPE t_array_source_83 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.DEFERRED_OPTION%TYPE INDEX BY BINARY_INTEGER;
169122: TYPE t_array_source_84 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.DEFERRED_START_DATE%TYPE INDEX BY BINARY_INTEGER;
169123: TYPE t_array_source_85 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
169124: TYPE t_array_source_91 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
169125: TYPE t_array_source_92 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
169126: TYPE t_array_source_93 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
169127: TYPE t_array_source_94 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
169128: TYPE t_array_source_95 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 169144: TYPE t_array_source_140 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;

169140: TYPE t_array_source_136 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.UPG_ENC_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
169141: TYPE t_array_source_137 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.APAD_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
169142: TYPE t_array_source_138 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.BASE_AMT_AT_PP_XRATE%TYPE INDEX BY BINARY_INTEGER;
169143: TYPE t_array_source_139 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.REVERSED_PREPAY_APP_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
169144: TYPE t_array_source_140 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;
169145: TYPE t_array_source_142 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.BF_PREPAY_REC_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
169146: TYPE t_array_source_143 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.BF_PREPAY_REC_INV%TYPE INDEX BY BINARY_INTEGER;
169147: TYPE t_array_source_144 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.APAD_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
169148: TYPE t_array_source_149 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.BF_ACCRUAL_PREPAY_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 169372: , ZX_AP_DEF_TAX_EXTRACT_V l5

169368: , l2.INV_PREPMT_GAIN_LOSS_INDICATOR source_165
169369: FROM xla_events_gt xet
169370: , AP_PREPAYAPP_EXTRACT_DETAILS_V l2
169371: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
169372: , ZX_AP_DEF_TAX_EXTRACT_V l5
169373: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
169374: , fnd_lookup_values fvl85
169375: , fnd_lookup_values fvl129
169376: , fnd_lookup_values fvl140

Line 171082: WHEN 33 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

171078: WHEN 29 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
171079: WHEN 30 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
171080: WHEN 31 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
171081: WHEN 32 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
171082: WHEN 33 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
171083: WHEN 34 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
171084: WHEN 35 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
171085: WHEN 36 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
171086: WHEN 37 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 171092: WHEN 43 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

171088: WHEN 39 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
171089: WHEN 40 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
171090: WHEN 41 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
171091: WHEN 42 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
171092: WHEN 43 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
171093: WHEN 44 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
171094:
171095: ELSE null
171096: END object_name

Line 171303: , ZX_AP_DEF_TAX_EXTRACT_V l5

171299: END source_meaning
171300: FROM xla_events_gt xet
171301: , AP_INVOICE_EXTRACT_DETAILS_V l1
171302: , AP_PO_HEADERS_EXTRACT_V l3
171303: , ZX_AP_DEF_TAX_EXTRACT_V l5
171304: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
171305: , fnd_lookup_values fvl17
171306: , fnd_lookup_values fvl28
171307: , fnd_lookup_values fvl54

Line 171522: TYPE t_array_source_91 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

171518: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DEFERRED_START_DATE%TYPE INDEX BY BINARY_INTEGER;
171519: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
171520: TYPE t_array_source_89 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
171521: TYPE t_array_source_90 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_STAT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
171522: TYPE t_array_source_91 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
171523: TYPE t_array_source_92 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
171524: TYPE t_array_source_93 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
171525: TYPE t_array_source_94 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
171526: TYPE t_array_source_95 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 171532: TYPE t_array_source_140 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;

171528: TYPE t_array_source_97 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
171529: TYPE t_array_source_98 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.BUS_FLOW_INV_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
171530: TYPE t_array_source_99 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
171531: TYPE t_array_source_100 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.BUS_FLOW_INV_ID%TYPE INDEX BY BINARY_INTEGER;
171532: TYPE t_array_source_140 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;
171533: TYPE t_array_source_145 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SELF_ASSESSED_TAX_FLAG%TYPE INDEX BY BINARY_INTEGER;
171534:
171535: l_array_source_10 t_array_source_10;
171536: l_array_source_10_meaning t_array_lookup_meaning;

Line 171765: , ZX_AP_DEF_TAX_EXTRACT_V l5

171761: , fvl145.meaning source_145_meaning
171762: FROM xla_events_gt xet
171763: , AP_INVOICE_EXTRACT_DETAILS_V l1
171764: , AP_PO_HEADERS_EXTRACT_V l3
171765: , ZX_AP_DEF_TAX_EXTRACT_V l5
171766: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
171767: , fnd_lookup_values fvl17
171768: , fnd_lookup_values fvl28
171769: , fnd_lookup_values fvl54

Line 174374: WHEN 6 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

174370: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
174371: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
174372: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
174373: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
174374: WHEN 6 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
174375: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
174376: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
174377: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
174378: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 174380: WHEN 12 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

174376: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
174377: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
174378: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
174379: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
174380: WHEN 12 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
174381: WHEN 13 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
174382: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
174383: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
174384: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 174381: WHEN 13 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

174377: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
174378: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
174379: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
174380: WHEN 12 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
174381: WHEN 13 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
174382: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
174383: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
174384: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
174385: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 174400: WHEN 32 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

174396: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
174397: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
174398: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
174399: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
174400: WHEN 32 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
174401: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
174402: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
174403: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
174404: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 174611: , ZX_AP_DEF_TAX_EXTRACT_V l4

174607: ELSE null
174608: END source_meaning
174609: FROM xla_events_gt xet
174610: , AP_PAYMENT_EXTRACT_DETAILS_V l1
174611: , ZX_AP_DEF_TAX_EXTRACT_V l4
174612: , fnd_lookup_values fvl28
174613: , fnd_lookup_values fvl56
174614: , fnd_lookup_values fvl85
174615: , fnd_lookup_values fvl101

Line 174818: TYPE t_array_source_48 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;

174814: TYPE t_array_source_28 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
174815: TYPE t_array_source_39 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AWT_RELATED_DIST_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
174816: TYPE t_array_source_41 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.POD_CCID%TYPE INDEX BY BINARY_INTEGER;
174817: TYPE t_array_source_42 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.PO_VARIANCE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
174818: TYPE t_array_source_48 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
174819: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AI_INVOICE_TYPE_PAID%TYPE INDEX BY BINARY_INTEGER;
174820: TYPE t_array_source_58 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
174821: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
174822: TYPE t_array_source_72 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 174824: TYPE t_array_source_91 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

174820: TYPE t_array_source_58 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
174821: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
174822: TYPE t_array_source_72 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
174823: TYPE t_array_source_85 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
174824: TYPE t_array_source_91 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
174825: TYPE t_array_source_93 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
174826: TYPE t_array_source_96 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
174827: TYPE t_array_source_97 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
174828: TYPE t_array_source_98 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 174825: TYPE t_array_source_93 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

174821: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
174822: TYPE t_array_source_72 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
174823: TYPE t_array_source_85 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
174824: TYPE t_array_source_91 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
174825: TYPE t_array_source_93 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
174826: TYPE t_array_source_96 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
174827: TYPE t_array_source_97 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
174828: TYPE t_array_source_98 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
174829: TYPE t_array_source_99 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 174844: TYPE t_array_source_140 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;

174840: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
174841: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_INVOICE_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
174842: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_PAYMENT_MAT_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
174843: TYPE t_array_source_124 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_MATURED_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
174844: TYPE t_array_source_140 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;
174845: TYPE t_array_source_146 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
174846: TYPE t_array_source_147 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
174847: TYPE t_array_source_148 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
174848: TYPE t_array_source_154 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.INV_CLR_GAIN_LOSS_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 175127: , ZX_AP_DEF_TAX_EXTRACT_V l4

175123: , l1.AWT_AT_PMT_TIME source_166
175124: , fvl166.meaning source_166_meaning
175125: FROM xla_events_gt xet
175126: , AP_PAYMENT_EXTRACT_DETAILS_V l1
175127: , ZX_AP_DEF_TAX_EXTRACT_V l4
175128: , fnd_lookup_values fvl28
175129: , fnd_lookup_values fvl56
175130: , fnd_lookup_values fvl85
175131: , fnd_lookup_values fvl101

Line 177443: WHEN 9 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

177439: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
177440: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
177441: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
177442: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
177443: WHEN 9 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
177444: WHEN 10 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
177445: WHEN 11 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
177446: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
177447: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 177445: WHEN 11 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

177441: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
177442: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
177443: WHEN 9 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
177444: WHEN 10 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
177445: WHEN 11 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
177446: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
177447: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
177448: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
177449: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 177599: , ZX_AP_DEF_TAX_EXTRACT_V l4

177595: ELSE null
177596: END source_meaning
177597: FROM xla_events_gt xet
177598: , AP_PAYMENT_EXTRACT_DETAILS_V l1
177599: , ZX_AP_DEF_TAX_EXTRACT_V l4
177600: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
177601: , fnd_lookup_values fvl28
177602: , fnd_lookup_values fvl85
177603: , fnd_lookup_values fvl101

Line 177789: TYPE t_array_source_91 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

177785: TYPE t_array_source_58 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
177786: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
177787: TYPE t_array_source_72 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
177788: TYPE t_array_source_85 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
177789: TYPE t_array_source_91 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
177790: TYPE t_array_source_92 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
177791: TYPE t_array_source_93 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
177792: TYPE t_array_source_96 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
177793: TYPE t_array_source_97 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 177791: TYPE t_array_source_93 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

177787: TYPE t_array_source_72 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
177788: TYPE t_array_source_85 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
177789: TYPE t_array_source_91 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
177790: TYPE t_array_source_92 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
177791: TYPE t_array_source_93 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
177792: TYPE t_array_source_96 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
177793: TYPE t_array_source_97 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
177794: TYPE t_array_source_98 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
177795: TYPE t_array_source_99 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 178039: , ZX_AP_DEF_TAX_EXTRACT_V l4

178035: , l1.INV_PMT_BASE_AMT_DIFF source_156
178036: , l1.INV_PMT_GAIN_LOSS_INDICATOR source_161
178037: FROM xla_events_gt xet
178038: , AP_PAYMENT_EXTRACT_DETAILS_V l1
178039: , ZX_AP_DEF_TAX_EXTRACT_V l4
178040: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
178041: , fnd_lookup_values fvl28
178042: , fnd_lookup_values fvl85
178043: , fnd_lookup_values fvl101