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_000002_PKG dependencies on ZX_AP_DEF_TAX_EXTRACT_V

Line 144236: WHEN 36 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

144232: WHEN 32 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
144233: WHEN 33 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
144234: WHEN 34 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
144235: WHEN 35 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
144236: WHEN 36 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
144237: WHEN 37 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
144238: WHEN 38 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
144239: WHEN 39 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
144240: WHEN 40 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 144468: , ZX_AP_DEF_TAX_EXTRACT_V l5

144464: END source_meaning
144465: FROM xla_events_gt xet
144466: , AP_INVOICE_EXTRACT_DETAILS_V l1
144467: , AP_PO_HEADERS_EXTRACT_V l3
144468: , ZX_AP_DEF_TAX_EXTRACT_V l5
144469: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
144470: , fnd_lookup_values fvl22
144471: , fnd_lookup_values fvl33
144472: , fnd_lookup_values fvl80

Line 144690: TYPE t_array_source_86 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

144686: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DEFERRED_START_DATE%TYPE INDEX BY BINARY_INTEGER;
144687: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
144688: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
144689: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_STAT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
144690: TYPE t_array_source_86 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
144691: TYPE t_array_source_87 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
144692: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
144693: TYPE t_array_source_89 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
144694: TYPE t_array_source_90 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 144947: , ZX_AP_DEF_TAX_EXTRACT_V l5

144943: , fvl142.meaning source_142_meaning
144944: FROM xla_events_gt xet
144945: , AP_INVOICE_EXTRACT_DETAILS_V l1
144946: , AP_PO_HEADERS_EXTRACT_V l3
144947: , ZX_AP_DEF_TAX_EXTRACT_V l5
144948: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
144949: , fnd_lookup_values fvl22
144950: , fnd_lookup_values fvl33
144951: , fnd_lookup_values fvl80

Line 147524: WHEN 35 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

147520: WHEN 31 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
147521: WHEN 32 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
147522: WHEN 33 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
147523: WHEN 34 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
147524: WHEN 35 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
147525: WHEN 36 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
147526: WHEN 37 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
147527: WHEN 38 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
147528: WHEN 39 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 147752: , ZX_AP_DEF_TAX_EXTRACT_V l5

147748: END source_meaning
147749: FROM xla_events_gt xet
147750: , AP_INVOICE_EXTRACT_DETAILS_V l1
147751: , AP_PO_HEADERS_EXTRACT_V l3
147752: , ZX_AP_DEF_TAX_EXTRACT_V l5
147753: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
147754: , fnd_lookup_values fvl22
147755: , fnd_lookup_values fvl33
147756: , fnd_lookup_values fvl80

Line 147972: TYPE t_array_source_86 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

147968: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DEFERRED_OPTION%TYPE INDEX BY BINARY_INTEGER;
147969: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DEFERRED_START_DATE%TYPE INDEX BY BINARY_INTEGER;
147970: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
147971: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
147972: TYPE t_array_source_86 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
147973: TYPE t_array_source_87 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
147974: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
147975: TYPE t_array_source_89 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
147976: TYPE t_array_source_90 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 148218: , ZX_AP_DEF_TAX_EXTRACT_V l5

148214: , fvl142.meaning source_142_meaning
148215: FROM xla_events_gt xet
148216: , AP_INVOICE_EXTRACT_DETAILS_V l1
148217: , AP_PO_HEADERS_EXTRACT_V l3
148218: , ZX_AP_DEF_TAX_EXTRACT_V l5
148219: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
148220: , fnd_lookup_values fvl22
148221: , fnd_lookup_values fvl33
148222: , fnd_lookup_values fvl80

Line 150764: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

150760: , l1.line_number line_number
150761: , CASE r
150762: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
150763: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
150764: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
150765: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
150766: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
150767: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
150768: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 150784: WHEN 23 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

150780: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
150781: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
150782: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
150783: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
150784: WHEN 23 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
150785: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
150786: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
150787:
150788: ELSE null

Line 150917: , ZX_AP_DEF_TAX_EXTRACT_V l4

150913: ELSE null
150914: END source_meaning
150915: FROM xla_events_gt xet
150916: , AP_PAYMENT_EXTRACT_DETAILS_V l1
150917: , ZX_AP_DEF_TAX_EXTRACT_V l4
150918: , fnd_lookup_values fvl33
150919: , fnd_lookup_values fvl80
150920: , fnd_lookup_values fvl98
150921: , fnd_lookup_values fvl137

Line 151104: TYPE t_array_source_52 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;

151100: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
151101:
151102: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
151103: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
151104: TYPE t_array_source_52 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
151105: TYPE t_array_source_53 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
151106: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
151107: TYPE t_array_source_80 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
151108: TYPE t_array_source_91 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;

Line 151124: TYPE t_array_source_137 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;

151120: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
151121: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
151122: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_INVOICE_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
151123: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_MATURED_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
151124: TYPE t_array_source_137 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;
151125: TYPE t_array_source_154 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.PMT_MAT_BASE_AMT_DIFF%TYPE INDEX BY BINARY_INTEGER;
151126: TYPE t_array_source_161 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.PMT_MAT_GAIN_LOSS_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
151127:
151128: l_array_source_6 t_array_source_6;

Line 151333: , ZX_AP_DEF_TAX_EXTRACT_V l4

151329: , l1.PMT_MAT_BASE_AMT_DIFF source_154
151330: , l1.PMT_MAT_GAIN_LOSS_INDICATOR source_161
151331: FROM xla_events_gt xet
151332: , AP_PAYMENT_EXTRACT_DETAILS_V l1
151333: , ZX_AP_DEF_TAX_EXTRACT_V l4
151334: , fnd_lookup_values fvl33
151335: , fnd_lookup_values fvl80
151336: , fnd_lookup_values fvl98
151337: , fnd_lookup_values fvl137

Line 153151: WHEN 36 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

153147: WHEN 32 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
153148: WHEN 33 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
153149: WHEN 34 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
153150: WHEN 35 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
153151: WHEN 36 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
153152: WHEN 37 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
153153: WHEN 38 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
153154: WHEN 39 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
153155: WHEN 40 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 153393: , ZX_AP_DEF_TAX_EXTRACT_V l5

153389: END source_meaning
153390: FROM xla_events_gt xet
153391: , AP_INVOICE_EXTRACT_DETAILS_V l1
153392: , AP_PO_HEADERS_EXTRACT_V l3
153393: , ZX_AP_DEF_TAX_EXTRACT_V l5
153394: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153395: , fnd_lookup_values fvl22
153396: , fnd_lookup_values fvl33
153397: , fnd_lookup_values fvl80

Line 153615: TYPE t_array_source_86 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

153611: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DEFERRED_START_DATE%TYPE INDEX BY BINARY_INTEGER;
153612: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
153613: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
153614: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_STAT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
153615: TYPE t_array_source_86 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
153616: TYPE t_array_source_87 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
153617: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
153618: TYPE t_array_source_89 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
153619: TYPE t_array_source_90 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 153878: , ZX_AP_DEF_TAX_EXTRACT_V l5

153874: , l1.BUS_FLOW_RET_INV_ID source_167
153875: FROM xla_events_gt xet
153876: , AP_INVOICE_EXTRACT_DETAILS_V l1
153877: , AP_PO_HEADERS_EXTRACT_V l3
153878: , ZX_AP_DEF_TAX_EXTRACT_V l5
153879: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153880: , fnd_lookup_values fvl22
153881: , fnd_lookup_values fvl33
153882: , fnd_lookup_values fvl80

Line 156612: WHEN 6 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

156608: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156609: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156610: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156611: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156612: WHEN 6 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
156613: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156614: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156615: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156616: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 156617: WHEN 11 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

156613: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156614: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156615: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156616: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156617: WHEN 11 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
156618: WHEN 12 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
156619: WHEN 13 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
156620: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156621: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 156619: WHEN 13 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

156615: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156616: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156617: WHEN 11 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
156618: WHEN 12 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
156619: WHEN 13 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
156620: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156621: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156622: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156623: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 156632: WHEN 26 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

156628: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156629: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156630: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156631: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156632: WHEN 26 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
156633: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156634: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156635: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156636: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 156809: , ZX_AP_DEF_TAX_EXTRACT_V l4

156805: ELSE null
156806: END source_meaning
156807: FROM xla_events_gt xet
156808: , AP_PAYMENT_EXTRACT_DETAILS_V l1
156809: , ZX_AP_DEF_TAX_EXTRACT_V l4
156810: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
156811: , fnd_lookup_values fvl33
156812: , fnd_lookup_values fvl80
156813: , fnd_lookup_values fvl98

Line 157023: TYPE t_array_source_52 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;

157019: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
157020: TYPE t_array_source_43 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AWT_RELATED_DIST_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
157021: TYPE t_array_source_45 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.POD_CCID%TYPE INDEX BY BINARY_INTEGER;
157022: TYPE t_array_source_46 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.PO_VARIANCE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
157023: TYPE t_array_source_52 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
157024: TYPE t_array_source_53 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
157025: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
157026: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
157027: TYPE t_array_source_80 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 157028: TYPE t_array_source_86 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

157024: TYPE t_array_source_53 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
157025: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
157026: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
157027: TYPE t_array_source_80 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
157028: TYPE t_array_source_86 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
157029: TYPE t_array_source_87 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
157030: TYPE t_array_source_88 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
157031: TYPE t_array_source_91 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
157032: TYPE t_array_source_92 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 157030: TYPE t_array_source_88 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

157026: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
157027: TYPE t_array_source_80 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
157028: TYPE t_array_source_86 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
157029: TYPE t_array_source_87 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
157030: TYPE t_array_source_88 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
157031: TYPE t_array_source_91 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
157032: TYPE t_array_source_92 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
157033: TYPE t_array_source_93 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
157034: TYPE t_array_source_94 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 157043: TYPE t_array_source_137 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;

157039: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
157040: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
157041: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_INVOICE_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
157042: TYPE t_array_source_124 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_INVOICE_DIST_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
157043: TYPE t_array_source_137 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;
157044: TYPE t_array_source_138 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AWT_RELATED_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
157045: TYPE t_array_source_143 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
157046: TYPE t_array_source_144 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
157047: TYPE t_array_source_145 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 157334: , ZX_AP_DEF_TAX_EXTRACT_V l4

157330: , l1.AWT_AT_PMT_TIME source_164
157331: , fvl164.meaning source_164_meaning
157332: FROM xla_events_gt xet
157333: , AP_PAYMENT_EXTRACT_DETAILS_V l1
157334: , ZX_AP_DEF_TAX_EXTRACT_V l4
157335: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
157336: , fnd_lookup_values fvl33
157337: , fnd_lookup_values fvl80
157338: , fnd_lookup_values fvl98

Line 159637: WHEN 4 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

159633: , CASE r
159634: WHEN 1 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159635: WHEN 2 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159636: WHEN 3 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159637: WHEN 4 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
159638: WHEN 5 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159639: WHEN 6 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159640: WHEN 7 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159641: WHEN 8 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'

Line 159651: WHEN 18 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

159647: WHEN 14 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159648: WHEN 15 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159649: WHEN 16 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159650: WHEN 17 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159651: WHEN 18 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
159652: WHEN 19 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
159653: WHEN 20 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159654: WHEN 21 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159655: WHEN 22 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'

Line 159671: WHEN 38 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

159667: WHEN 34 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159668: WHEN 35 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159669: WHEN 36 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159670: WHEN 37 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159671: WHEN 38 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
159672: WHEN 39 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159673: WHEN 40 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159674: WHEN 41 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159675: WHEN 42 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'

Line 159904: , ZX_AP_DEF_TAX_EXTRACT_V l5

159900: END source_meaning
159901: FROM xla_events_gt xet
159902: , AP_PREPAYAPP_EXTRACT_DETAILS_V l2
159903: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
159904: , ZX_AP_DEF_TAX_EXTRACT_V l5
159905: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
159906: , fnd_lookup_values fvl80
159907: , fnd_lookup_values fvl126
159908: , fnd_lookup_values fvl137

Line 160082: TYPE t_array_source_52 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;

160078:
160079: TYPE t_array_source_30 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
160080: TYPE t_array_source_36 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
160081: TYPE t_array_source_38 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
160082: TYPE t_array_source_52 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
160083: TYPE t_array_source_53 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
160084: TYPE t_array_source_55 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
160085: TYPE t_array_source_65 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
160086: TYPE t_array_source_66 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 160096: TYPE t_array_source_86 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

160092: TYPE t_array_source_77 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.DEFERRED_END_DATE%TYPE INDEX BY BINARY_INTEGER;
160093: TYPE t_array_source_78 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.DEFERRED_OPTION%TYPE INDEX BY BINARY_INTEGER;
160094: TYPE t_array_source_79 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.DEFERRED_START_DATE%TYPE INDEX BY BINARY_INTEGER;
160095: TYPE t_array_source_80 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
160096: TYPE t_array_source_86 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
160097: TYPE t_array_source_87 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
160098: TYPE t_array_source_88 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
160099: TYPE t_array_source_89 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
160100: TYPE t_array_source_90 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 160116: TYPE t_array_source_137 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;

160112: TYPE t_array_source_133 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.UPG_ENC_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
160113: TYPE t_array_source_134 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.APAD_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
160114: TYPE t_array_source_135 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.BASE_AMT_AT_PP_XRATE%TYPE INDEX BY BINARY_INTEGER;
160115: TYPE t_array_source_136 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.REVERSED_PREPAY_APP_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
160116: TYPE t_array_source_137 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;
160117: TYPE t_array_source_139 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.BF_PREPAY_REC_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
160118: TYPE t_array_source_140 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.BF_PREPAY_REC_INV%TYPE INDEX BY BINARY_INTEGER;
160119: TYPE t_array_source_141 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.APAD_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
160120: TYPE t_array_source_146 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.BF_ACCRUAL_PREPAY_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 160352: , ZX_AP_DEF_TAX_EXTRACT_V l5

160348: , l2.INV_PREPMT_GAIN_LOSS_INDICATOR source_162
160349: FROM xla_events_gt xet
160350: , AP_PREPAYAPP_EXTRACT_DETAILS_V l2
160351: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
160352: , ZX_AP_DEF_TAX_EXTRACT_V l5
160353: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
160354: , fnd_lookup_values fvl80
160355: , fnd_lookup_values fvl126
160356: , fnd_lookup_values fvl137

Line 162103: WHEN 32 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

162099: WHEN 28 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
162100: WHEN 29 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
162101: WHEN 30 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
162102: WHEN 31 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
162103: WHEN 32 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
162104: WHEN 33 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
162105: WHEN 34 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
162106: WHEN 35 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
162107: WHEN 36 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 162114: WHEN 43 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

162110: WHEN 39 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
162111: WHEN 40 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
162112: WHEN 41 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
162113: WHEN 42 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
162114: WHEN 43 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
162115: WHEN 44 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
162116:
162117: ELSE null
162118: END object_name

Line 162325: , ZX_AP_DEF_TAX_EXTRACT_V l5

162321: END source_meaning
162322: FROM xla_events_gt xet
162323: , AP_INVOICE_EXTRACT_DETAILS_V l1
162324: , AP_PO_HEADERS_EXTRACT_V l3
162325: , ZX_AP_DEF_TAX_EXTRACT_V l5
162326: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
162327: , fnd_lookup_values fvl22
162328: , fnd_lookup_values fvl33
162329: , fnd_lookup_values fvl80

Line 162547: TYPE t_array_source_86 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

162543: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DEFERRED_START_DATE%TYPE INDEX BY BINARY_INTEGER;
162544: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
162545: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
162546: TYPE t_array_source_85 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_STAT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
162547: TYPE t_array_source_86 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
162548: TYPE t_array_source_87 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
162549: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
162550: TYPE t_array_source_89 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
162551: TYPE t_array_source_90 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 162558: TYPE t_array_source_137 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;

162554: TYPE t_array_source_93 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.BUS_FLOW_INV_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
162555: TYPE t_array_source_94 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
162556: TYPE t_array_source_95 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.BUS_FLOW_INV_ID%TYPE INDEX BY BINARY_INTEGER;
162557: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.POD_ACCRUE_ON_RECEIPT_FLAG%TYPE INDEX BY BINARY_INTEGER;
162558: TYPE t_array_source_137 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;
162559: TYPE t_array_source_142 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SELF_ASSESSED_TAX_FLAG%TYPE INDEX BY BINARY_INTEGER;
162560:
162561: l_array_source_3 t_array_source_3;
162562: l_array_source_4 t_array_source_4;

Line 162799: , ZX_AP_DEF_TAX_EXTRACT_V l5

162795: , fvl142.meaning source_142_meaning
162796: FROM xla_events_gt xet
162797: , AP_INVOICE_EXTRACT_DETAILS_V l1
162798: , AP_PO_HEADERS_EXTRACT_V l3
162799: , ZX_AP_DEF_TAX_EXTRACT_V l5
162800: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
162801: , fnd_lookup_values fvl22
162802: , fnd_lookup_values fvl33
162803: , fnd_lookup_values fvl80

Line 165450: WHEN 6 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

165446: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165447: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165448: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165449: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165450: WHEN 6 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
165451: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165452: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165453: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165454: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 165455: WHEN 11 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

165451: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165452: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165453: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165454: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165455: WHEN 11 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
165456: WHEN 12 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
165457: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165458: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165459: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 165456: WHEN 12 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

165452: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165453: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165454: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165455: WHEN 11 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
165456: WHEN 12 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
165457: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165458: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165459: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165460: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 165475: WHEN 31 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

165471: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165472: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165473: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165474: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165475: WHEN 31 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
165476: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165477: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165478: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165479: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 165687: , ZX_AP_DEF_TAX_EXTRACT_V l4

165683: ELSE null
165684: END source_meaning
165685: FROM xla_events_gt xet
165686: , AP_PAYMENT_EXTRACT_DETAILS_V l1
165687: , ZX_AP_DEF_TAX_EXTRACT_V l4
165688: , fnd_lookup_values fvl33
165689: , fnd_lookup_values fvl80
165690: , fnd_lookup_values fvl98
165691: , fnd_lookup_values fvl137

Line 165898: TYPE t_array_source_52 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;

165894: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
165895: TYPE t_array_source_43 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AWT_RELATED_DIST_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
165896: TYPE t_array_source_45 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.POD_CCID%TYPE INDEX BY BINARY_INTEGER;
165897: TYPE t_array_source_46 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.PO_VARIANCE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
165898: TYPE t_array_source_52 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
165899: TYPE t_array_source_53 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
165900: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
165901: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165902: TYPE t_array_source_80 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 165903: TYPE t_array_source_86 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

165899: TYPE t_array_source_53 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
165900: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
165901: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165902: TYPE t_array_source_80 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165903: TYPE t_array_source_86 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
165904: TYPE t_array_source_88 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
165905: TYPE t_array_source_91 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
165906: TYPE t_array_source_92 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
165907: TYPE t_array_source_93 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 165904: TYPE t_array_source_88 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

165900: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
165901: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165902: TYPE t_array_source_80 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165903: TYPE t_array_source_86 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
165904: TYPE t_array_source_88 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
165905: TYPE t_array_source_91 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
165906: TYPE t_array_source_92 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
165907: TYPE t_array_source_93 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
165908: TYPE t_array_source_94 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 165923: TYPE t_array_source_137 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;

165919: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
165920: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_INVOICE_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
165921: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_PAYMENT_MAT_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
165922: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_MATURED_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
165923: TYPE t_array_source_137 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;
165924: TYPE t_array_source_143 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
165925: TYPE t_array_source_144 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
165926: TYPE t_array_source_145 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
165927: TYPE t_array_source_151 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.INV_CLR_GAIN_LOSS_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 166215: , ZX_AP_DEF_TAX_EXTRACT_V l4

166211: , l1.AWT_AT_PMT_TIME source_164
166212: , fvl164.meaning source_164_meaning
166213: FROM xla_events_gt xet
166214: , AP_PAYMENT_EXTRACT_DETAILS_V l1
166215: , ZX_AP_DEF_TAX_EXTRACT_V l4
166216: , fnd_lookup_values fvl33
166217: , fnd_lookup_values fvl80
166218: , fnd_lookup_values fvl98
166219: , fnd_lookup_values fvl137

Line 168573: WHEN 9 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

168569: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
168570: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
168571: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
168572: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
168573: WHEN 9 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
168574: WHEN 10 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
168575: WHEN 11 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
168576: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
168577: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 168575: WHEN 11 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

168571: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
168572: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
168573: WHEN 9 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
168574: WHEN 10 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
168575: WHEN 11 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
168576: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
168577: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
168578: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
168579: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 168729: , ZX_AP_DEF_TAX_EXTRACT_V l4

168725: ELSE null
168726: END source_meaning
168727: FROM xla_events_gt xet
168728: , AP_PAYMENT_EXTRACT_DETAILS_V l1
168729: , ZX_AP_DEF_TAX_EXTRACT_V l4
168730: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
168731: , fnd_lookup_values fvl33
168732: , fnd_lookup_values fvl80
168733: , fnd_lookup_values fvl98

Line 168923: TYPE t_array_source_86 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

168919: TYPE t_array_source_53 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
168920: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
168921: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
168922: TYPE t_array_source_80 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
168923: TYPE t_array_source_86 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
168924: TYPE t_array_source_87 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
168925: TYPE t_array_source_88 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
168926: TYPE t_array_source_91 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
168927: TYPE t_array_source_92 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 168925: TYPE t_array_source_88 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

168921: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
168922: TYPE t_array_source_80 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
168923: TYPE t_array_source_86 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
168924: TYPE t_array_source_87 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
168925: TYPE t_array_source_88 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
168926: TYPE t_array_source_91 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
168927: TYPE t_array_source_92 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
168928: TYPE t_array_source_93 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
168929: TYPE t_array_source_94 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 169181: , ZX_AP_DEF_TAX_EXTRACT_V l4

169177: , l1.INV_PMT_BASE_AMT_DIFF source_153
169178: , l1.INV_PMT_GAIN_LOSS_INDICATOR source_158
169179: FROM xla_events_gt xet
169180: , AP_PAYMENT_EXTRACT_DETAILS_V l1
169181: , ZX_AP_DEF_TAX_EXTRACT_V l4
169182: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
169183: , fnd_lookup_values fvl33
169184: , fnd_lookup_values fvl80
169185: , fnd_lookup_values fvl98