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

Line 144106: WHEN 36 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

144102: WHEN 32 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
144103: WHEN 33 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
144104: WHEN 34 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
144105: WHEN 35 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
144106: WHEN 36 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
144107: WHEN 37 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
144108: WHEN 38 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
144109: WHEN 39 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
144110: WHEN 40 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 144343: , ZX_AP_DEF_TAX_EXTRACT_V l5

144339: END source_meaning
144340: FROM xla_events_gt xet
144341: , AP_INVOICE_EXTRACT_DETAILS_V l1
144342: , AP_PO_HEADERS_EXTRACT_V l3
144343: , ZX_AP_DEF_TAX_EXTRACT_V l5
144344: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
144345: , fnd_lookup_values fvl22
144346: , fnd_lookup_values fvl33
144347: , fnd_lookup_values fvl79

Line 144566: TYPE t_array_source_85 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

144562: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DEFERRED_START_DATE%TYPE INDEX BY BINARY_INTEGER;
144563: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
144564: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
144565: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_STAT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
144566: TYPE t_array_source_85 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
144567: TYPE t_array_source_86 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
144568: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
144569: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
144570: TYPE t_array_source_89 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 144828: , ZX_AP_DEF_TAX_EXTRACT_V l5

144824: , l1.AID_PROJECT_ID source_146
144825: FROM xla_events_gt xet
144826: , AP_INVOICE_EXTRACT_DETAILS_V l1
144827: , AP_PO_HEADERS_EXTRACT_V l3
144828: , ZX_AP_DEF_TAX_EXTRACT_V l5
144829: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
144830: , fnd_lookup_values fvl22
144831: , fnd_lookup_values fvl33
144832: , fnd_lookup_values fvl79

Line 147419: WHEN 35 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

147415: WHEN 31 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
147416: WHEN 32 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
147417: WHEN 33 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
147418: WHEN 34 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
147419: WHEN 35 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
147420: WHEN 36 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
147421: WHEN 37 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
147422: WHEN 38 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
147423: WHEN 39 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 147652: , ZX_AP_DEF_TAX_EXTRACT_V l5

147648: END source_meaning
147649: FROM xla_events_gt xet
147650: , AP_INVOICE_EXTRACT_DETAILS_V l1
147651: , AP_PO_HEADERS_EXTRACT_V l3
147652: , ZX_AP_DEF_TAX_EXTRACT_V l5
147653: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
147654: , fnd_lookup_values fvl22
147655: , fnd_lookup_values fvl33
147656: , fnd_lookup_values fvl79

Line 147873: TYPE t_array_source_85 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

147869: TYPE t_array_source_77 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DEFERRED_OPTION%TYPE INDEX BY BINARY_INTEGER;
147870: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DEFERRED_START_DATE%TYPE INDEX BY BINARY_INTEGER;
147871: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
147872: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
147873: TYPE t_array_source_85 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
147874: TYPE t_array_source_86 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
147875: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
147876: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
147877: TYPE t_array_source_89 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 148124: , ZX_AP_DEF_TAX_EXTRACT_V l5

148120: , l1.AID_PROJECT_ID source_146
148121: FROM xla_events_gt xet
148122: , AP_INVOICE_EXTRACT_DETAILS_V l1
148123: , AP_PO_HEADERS_EXTRACT_V l3
148124: , ZX_AP_DEF_TAX_EXTRACT_V l5
148125: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
148126: , fnd_lookup_values fvl22
148127: , fnd_lookup_values fvl33
148128: , fnd_lookup_values fvl79

Line 150684: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

150680: , l1.line_number line_number
150681: , CASE r
150682: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
150683: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
150684: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
150685: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
150686: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
150687: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
150688: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 150704: WHEN 23 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

150700: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
150701: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
150702: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
150703: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
150704: WHEN 23 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
150705: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
150706: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
150707:
150708: ELSE null

Line 150837: , ZX_AP_DEF_TAX_EXTRACT_V l4

150833: ELSE null
150834: END source_meaning
150835: FROM xla_events_gt xet
150836: , AP_PAYMENT_EXTRACT_DETAILS_V l1
150837: , ZX_AP_DEF_TAX_EXTRACT_V l4
150838: , fnd_lookup_values fvl33
150839: , fnd_lookup_values fvl79
150840: , fnd_lookup_values fvl97
150841: , fnd_lookup_values fvl125

Line 151025: TYPE t_array_source_51 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;

151021: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
151022:
151023: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
151024: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
151025: TYPE t_array_source_51 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
151026: TYPE t_array_source_52 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
151027: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
151028: TYPE t_array_source_79 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
151029: TYPE t_array_source_90 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;

Line 151045: TYPE t_array_source_125 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;

151041: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
151042: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
151043: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_INVOICE_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
151044: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_MATURED_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
151045: TYPE t_array_source_125 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;
151046: TYPE t_array_source_151 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.PMT_MAT_BASE_AMT_DIFF%TYPE INDEX BY BINARY_INTEGER;
151047: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.PMT_MAT_GAIN_LOSS_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
151048:
151049: l_array_source_6 t_array_source_6;

Line 151256: , ZX_AP_DEF_TAX_EXTRACT_V l4

151252: , l1.PMT_MAT_BASE_AMT_DIFF source_151
151253: , l1.PMT_MAT_GAIN_LOSS_INDICATOR source_158
151254: FROM xla_events_gt xet
151255: , AP_PAYMENT_EXTRACT_DETAILS_V l1
151256: , ZX_AP_DEF_TAX_EXTRACT_V l4
151257: , fnd_lookup_values fvl33
151258: , fnd_lookup_values fvl79
151259: , fnd_lookup_values fvl97
151260: , fnd_lookup_values fvl125

Line 153095: WHEN 36 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

153091: WHEN 32 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
153092: WHEN 33 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
153093: WHEN 34 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
153094: WHEN 35 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
153095: WHEN 36 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
153096: WHEN 37 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
153097: WHEN 38 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
153098: WHEN 39 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
153099: WHEN 40 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 153342: , ZX_AP_DEF_TAX_EXTRACT_V l5

153338: END source_meaning
153339: FROM xla_events_gt xet
153340: , AP_INVOICE_EXTRACT_DETAILS_V l1
153341: , AP_PO_HEADERS_EXTRACT_V l3
153342: , ZX_AP_DEF_TAX_EXTRACT_V l5
153343: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153344: , fnd_lookup_values fvl22
153345: , fnd_lookup_values fvl33
153346: , fnd_lookup_values fvl79

Line 153565: TYPE t_array_source_85 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

153561: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DEFERRED_START_DATE%TYPE INDEX BY BINARY_INTEGER;
153562: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
153563: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
153564: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_STAT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
153565: TYPE t_array_source_85 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
153566: TYPE t_array_source_86 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
153567: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
153568: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
153569: TYPE t_array_source_89 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 153833: , ZX_AP_DEF_TAX_EXTRACT_V l5

153829: , l1.BUS_FLOW_RET_INV_ID source_167
153830: FROM xla_events_gt xet
153831: , AP_INVOICE_EXTRACT_DETAILS_V l1
153832: , AP_PO_HEADERS_EXTRACT_V l3
153833: , ZX_AP_DEF_TAX_EXTRACT_V l5
153834: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153835: , fnd_lookup_values fvl22
153836: , fnd_lookup_values fvl33
153837: , fnd_lookup_values fvl79

Line 156576: WHEN 6 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

156572: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156573: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156574: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156575: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156576: WHEN 6 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
156577: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156578: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156579: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156580: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 156581: WHEN 11 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

156577: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156578: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156579: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156580: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156581: WHEN 11 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
156582: WHEN 12 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
156583: WHEN 13 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
156584: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156585: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 156583: WHEN 13 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

156579: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156580: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156581: WHEN 11 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
156582: WHEN 12 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
156583: WHEN 13 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
156584: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156585: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156586: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156587: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 156596: WHEN 26 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

156592: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156593: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156594: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156595: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156596: WHEN 26 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
156597: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156598: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156599: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
156600: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 156773: , ZX_AP_DEF_TAX_EXTRACT_V l4

156769: ELSE null
156770: END source_meaning
156771: FROM xla_events_gt xet
156772: , AP_PAYMENT_EXTRACT_DETAILS_V l1
156773: , ZX_AP_DEF_TAX_EXTRACT_V l4
156774: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
156775: , fnd_lookup_values fvl33
156776: , fnd_lookup_values fvl79
156777: , fnd_lookup_values fvl97

Line 156987: TYPE t_array_source_51 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;

156983: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
156984: TYPE t_array_source_43 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AWT_RELATED_DIST_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
156985: TYPE t_array_source_45 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.POD_CCID%TYPE INDEX BY BINARY_INTEGER;
156986: TYPE t_array_source_46 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.PO_VARIANCE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
156987: TYPE t_array_source_51 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
156988: TYPE t_array_source_52 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
156989: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
156990: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
156991: TYPE t_array_source_79 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 156992: TYPE t_array_source_85 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

156988: TYPE t_array_source_52 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
156989: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
156990: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
156991: TYPE t_array_source_79 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
156992: TYPE t_array_source_85 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
156993: TYPE t_array_source_86 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
156994: TYPE t_array_source_87 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
156995: TYPE t_array_source_90 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
156996: TYPE t_array_source_91 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 156994: TYPE t_array_source_87 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

156990: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
156991: TYPE t_array_source_79 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
156992: TYPE t_array_source_85 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
156993: TYPE t_array_source_86 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
156994: TYPE t_array_source_87 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
156995: TYPE t_array_source_90 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
156996: TYPE t_array_source_91 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
156997: TYPE t_array_source_92 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
156998: TYPE t_array_source_93 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 157007: TYPE t_array_source_125 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;

157003: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
157004: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
157005: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_INVOICE_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
157006: TYPE t_array_source_124 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_INVOICE_DIST_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
157007: TYPE t_array_source_125 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;
157008: TYPE t_array_source_126 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AWT_RELATED_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
157009: TYPE t_array_source_136 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
157010: TYPE t_array_source_137 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
157011: TYPE t_array_source_138 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 157298: , ZX_AP_DEF_TAX_EXTRACT_V l4

157294: , l1.AWT_AT_PMT_TIME source_161
157295: , fvl161.meaning source_161_meaning
157296: FROM xla_events_gt xet
157297: , AP_PAYMENT_EXTRACT_DETAILS_V l1
157298: , ZX_AP_DEF_TAX_EXTRACT_V l4
157299: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
157300: , fnd_lookup_values fvl33
157301: , fnd_lookup_values fvl79
157302: , fnd_lookup_values fvl97

Line 159556: WHEN 4 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

159552: , CASE r
159553: WHEN 1 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159554: WHEN 2 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159555: WHEN 3 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159556: WHEN 4 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
159557: WHEN 5 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159558: WHEN 6 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159559: WHEN 7 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159560: WHEN 8 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'

Line 159570: WHEN 18 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

159566: WHEN 14 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159567: WHEN 15 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159568: WHEN 16 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159569: WHEN 17 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159570: WHEN 18 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
159571: WHEN 19 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
159572: WHEN 20 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159573: WHEN 21 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159574: WHEN 22 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'

Line 159578: WHEN 26 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

159574: WHEN 22 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159575: WHEN 23 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159576: WHEN 24 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159577: WHEN 25 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159578: WHEN 26 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
159579: WHEN 27 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159580: WHEN 28 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159581: WHEN 29 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
159582: WHEN 30 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'

Line 159808: , ZX_AP_DEF_TAX_EXTRACT_V l5

159804: END source_meaning
159805: FROM xla_events_gt xet
159806: , AP_PREPAYAPP_EXTRACT_DETAILS_V l2
159807: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
159808: , ZX_AP_DEF_TAX_EXTRACT_V l5
159809: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
159810: , fnd_lookup_values fvl79
159811: , fnd_lookup_values fvl125
159812: , fnd_lookup_values fvl165

Line 159982: TYPE t_array_source_51 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;

159978:
159979: TYPE t_array_source_30 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
159980: TYPE t_array_source_36 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
159981: TYPE t_array_source_38 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
159982: TYPE t_array_source_51 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
159983: TYPE t_array_source_52 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
159984: TYPE t_array_source_54 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
159985: TYPE t_array_source_64 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
159986: TYPE t_array_source_65 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 159996: TYPE t_array_source_85 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

159992: TYPE t_array_source_76 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.DEFERRED_END_DATE%TYPE INDEX BY BINARY_INTEGER;
159993: TYPE t_array_source_77 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.DEFERRED_OPTION%TYPE INDEX BY BINARY_INTEGER;
159994: TYPE t_array_source_78 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.DEFERRED_START_DATE%TYPE INDEX BY BINARY_INTEGER;
159995: TYPE t_array_source_79 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
159996: TYPE t_array_source_85 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
159997: TYPE t_array_source_86 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
159998: TYPE t_array_source_87 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
159999: TYPE t_array_source_88 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
160000: TYPE t_array_source_89 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 160004: TYPE t_array_source_125 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;

160000: TYPE t_array_source_89 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
160001: TYPE t_array_source_90 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
160002: TYPE t_array_source_91 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
160003: TYPE t_array_source_92 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.BUS_FLOW_INV_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
160004: TYPE t_array_source_125 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;
160005: TYPE t_array_source_127 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.APAD_DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
160006: TYPE t_array_source_128 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.BF_PREPAY_REC_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
160007: TYPE t_array_source_129 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.BF_PREPAY_REC_INV%TYPE INDEX BY BINARY_INTEGER;
160008: TYPE t_array_source_130 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.UPG_ENC_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 160235: , ZX_AP_DEF_TAX_EXTRACT_V l5

160231: , fvl165.meaning source_165_meaning
160232: FROM xla_events_gt xet
160233: , AP_PREPAYAPP_EXTRACT_DETAILS_V l2
160234: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
160235: , ZX_AP_DEF_TAX_EXTRACT_V l5
160236: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
160237: , fnd_lookup_values fvl79
160238: , fnd_lookup_values fvl125
160239: , fnd_lookup_values fvl165

Line 161913: WHEN 32 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

161909: WHEN 28 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
161910: WHEN 29 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
161911: WHEN 30 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
161912: WHEN 31 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
161913: WHEN 32 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
161914: WHEN 33 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
161915: WHEN 34 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
161916: WHEN 35 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
161917: WHEN 36 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 161924: WHEN 43 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

161920: WHEN 39 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
161921: WHEN 40 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
161922: WHEN 41 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
161923: WHEN 42 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
161924: WHEN 43 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
161925: WHEN 44 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
161926: WHEN 45 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
161927:
161928: ELSE null

Line 162140: , ZX_AP_DEF_TAX_EXTRACT_V l5

162136: END source_meaning
162137: FROM xla_events_gt xet
162138: , AP_INVOICE_EXTRACT_DETAILS_V l1
162139: , AP_PO_HEADERS_EXTRACT_V l3
162140: , ZX_AP_DEF_TAX_EXTRACT_V l5
162141: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
162142: , fnd_lookup_values fvl22
162143: , fnd_lookup_values fvl33
162144: , fnd_lookup_values fvl79

Line 162363: TYPE t_array_source_85 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

162359: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DEFERRED_START_DATE%TYPE INDEX BY BINARY_INTEGER;
162360: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
162361: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
162362: TYPE t_array_source_84 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_STAT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
162363: TYPE t_array_source_85 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
162364: TYPE t_array_source_86 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
162365: TYPE t_array_source_87 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
162366: TYPE t_array_source_88 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
162367: TYPE t_array_source_89 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 162374: TYPE t_array_source_125 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;

162370: TYPE t_array_source_92 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.BUS_FLOW_INV_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
162371: TYPE t_array_source_93 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
162372: TYPE t_array_source_94 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.BUS_FLOW_INV_ID%TYPE INDEX BY BINARY_INTEGER;
162373: TYPE t_array_source_95 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.POD_ACCRUE_ON_RECEIPT_FLAG%TYPE INDEX BY BINARY_INTEGER;
162374: TYPE t_array_source_125 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;
162375: TYPE t_array_source_135 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SELF_ASSESSED_TAX_FLAG%TYPE INDEX BY BINARY_INTEGER;
162376: TYPE t_array_source_146 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.AID_PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
162377:
162378: l_array_source_3 t_array_source_3;

Line 162620: , ZX_AP_DEF_TAX_EXTRACT_V l5

162616: , l1.AID_PROJECT_ID source_146
162617: FROM xla_events_gt xet
162618: , AP_INVOICE_EXTRACT_DETAILS_V l1
162619: , AP_PO_HEADERS_EXTRACT_V l3
162620: , ZX_AP_DEF_TAX_EXTRACT_V l5
162621: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
162622: , fnd_lookup_values fvl22
162623: , fnd_lookup_values fvl33
162624: , fnd_lookup_values fvl79

Line 165285: WHEN 6 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

165281: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165282: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165283: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165284: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165285: WHEN 6 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
165286: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165287: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165288: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165289: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 165290: WHEN 11 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

165286: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165287: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165288: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165289: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165290: WHEN 11 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
165291: WHEN 12 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
165292: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165293: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165294: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 165291: WHEN 12 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

165287: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165288: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165289: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165290: WHEN 11 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
165291: WHEN 12 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
165292: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165293: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165294: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165295: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 165310: WHEN 31 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

165306: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165307: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165308: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165309: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165310: WHEN 31 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
165311: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165312: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165313: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
165314: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 165522: , ZX_AP_DEF_TAX_EXTRACT_V l4

165518: ELSE null
165519: END source_meaning
165520: FROM xla_events_gt xet
165521: , AP_PAYMENT_EXTRACT_DETAILS_V l1
165522: , ZX_AP_DEF_TAX_EXTRACT_V l4
165523: , fnd_lookup_values fvl33
165524: , fnd_lookup_values fvl79
165525: , fnd_lookup_values fvl97
165526: , fnd_lookup_values fvl125

Line 165734: TYPE t_array_source_51 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;

165730: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
165731: TYPE t_array_source_43 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AWT_RELATED_DIST_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
165732: TYPE t_array_source_45 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.POD_CCID%TYPE INDEX BY BINARY_INTEGER;
165733: TYPE t_array_source_46 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.PO_VARIANCE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
165734: TYPE t_array_source_51 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
165735: TYPE t_array_source_52 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
165736: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
165737: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165738: TYPE t_array_source_79 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 165739: TYPE t_array_source_85 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

165735: TYPE t_array_source_52 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
165736: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
165737: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165738: TYPE t_array_source_79 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165739: TYPE t_array_source_85 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
165740: TYPE t_array_source_87 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
165741: TYPE t_array_source_90 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
165742: TYPE t_array_source_91 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
165743: TYPE t_array_source_92 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 165740: TYPE t_array_source_87 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

165736: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
165737: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165738: TYPE t_array_source_79 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165739: TYPE t_array_source_85 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
165740: TYPE t_array_source_87 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
165741: TYPE t_array_source_90 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
165742: TYPE t_array_source_91 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
165743: TYPE t_array_source_92 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
165744: TYPE t_array_source_93 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 165759: TYPE t_array_source_125 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;

165755: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
165756: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_INVOICE_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
165757: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_PAYMENT_MAT_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
165758: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_MATURED_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
165759: TYPE t_array_source_125 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;
165760: TYPE t_array_source_136 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
165761: TYPE t_array_source_137 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
165762: TYPE t_array_source_138 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
165763: TYPE t_array_source_148 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.INV_CLR_GAIN_LOSS_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 166053: , ZX_AP_DEF_TAX_EXTRACT_V l4

166049: , l1.AWT_AT_PMT_TIME source_161
166050: , fvl161.meaning source_161_meaning
166051: FROM xla_events_gt xet
166052: , AP_PAYMENT_EXTRACT_DETAILS_V l1
166053: , ZX_AP_DEF_TAX_EXTRACT_V l4
166054: , fnd_lookup_values fvl33
166055: , fnd_lookup_values fvl79
166056: , fnd_lookup_values fvl97
166057: , fnd_lookup_values fvl125

Line 168388: WHEN 9 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

168384: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
168385: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
168386: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
168387: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
168388: WHEN 9 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
168389: WHEN 10 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
168390: WHEN 11 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
168391: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
168392: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 168390: WHEN 11 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

168386: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
168387: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
168388: WHEN 9 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
168389: WHEN 10 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
168390: WHEN 11 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
168391: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
168392: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
168393: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
168394: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 168544: , ZX_AP_DEF_TAX_EXTRACT_V l4

168540: ELSE null
168541: END source_meaning
168542: FROM xla_events_gt xet
168543: , AP_PAYMENT_EXTRACT_DETAILS_V l1
168544: , ZX_AP_DEF_TAX_EXTRACT_V l4
168545: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
168546: , fnd_lookup_values fvl33
168547: , fnd_lookup_values fvl79
168548: , fnd_lookup_values fvl97

Line 168739: TYPE t_array_source_85 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

168735: TYPE t_array_source_52 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
168736: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
168737: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
168738: TYPE t_array_source_79 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
168739: TYPE t_array_source_85 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
168740: TYPE t_array_source_86 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
168741: TYPE t_array_source_87 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
168742: TYPE t_array_source_90 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
168743: TYPE t_array_source_91 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 168741: TYPE t_array_source_87 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

168737: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
168738: TYPE t_array_source_79 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
168739: TYPE t_array_source_85 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
168740: TYPE t_array_source_86 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
168741: TYPE t_array_source_87 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
168742: TYPE t_array_source_90 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
168743: TYPE t_array_source_91 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
168744: TYPE t_array_source_92 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
168745: TYPE t_array_source_93 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 168999: , ZX_AP_DEF_TAX_EXTRACT_V l4

168995: , l1.INV_PMT_BASE_AMT_DIFF source_150
168996: , l1.INV_PMT_GAIN_LOSS_INDICATOR source_155
168997: FROM xla_events_gt xet
168998: , AP_PAYMENT_EXTRACT_DETAILS_V l1
168999: , ZX_AP_DEF_TAX_EXTRACT_V l4
169000: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
169001: , fnd_lookup_values fvl33
169002: , fnd_lookup_values fvl79
169003: , fnd_lookup_values fvl97