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

APPS.XLA_00200_AAD_S_000012_PKG dependencies on ZX_AP_TAX_JRNL_LINE_DESC_V

Line 152826: WHEN 38 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_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'
152830: WHEN 42 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 153057: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
153061: , fnd_lookup_values fvl85

Line 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;

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;
153280: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;

Line 153524: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
153528: , fnd_lookup_values fvl85

Line 156068: WHEN 37 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_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'
156072: WHEN 41 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 156295: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
156299: , fnd_lookup_values fvl85

Line 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;

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;
156516: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;

Line 156749: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
156753: , fnd_lookup_values fvl85

Line 161595: WHEN 38 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_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'
161599: WHEN 42 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 161836: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
161840: , fnd_lookup_values fvl85

Line 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;

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;
162059: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;

Line 162309: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
162313: , fnd_lookup_values fvl85

Line 165054: WHEN 21 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_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'
165058: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 165279: , ZX_AP_TAX_JRNL_LINE_DESC_V l7

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
165283: , fnd_lookup_values fvl85

Line 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;

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;
165519: TYPE t_array_source_98 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 165844: , ZX_AP_TAX_JRNL_LINE_DESC_V l7

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
165848: , fnd_lookup_values fvl85

Line 168684: WHEN 19 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_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'
168688: WHEN 23 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'

Line 168937: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
168941: , (select rownum r from all_objects where rownum <= 48 and owner = p_apps_owner)

Line 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;

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;
169129: TYPE t_array_source_96 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;

Line 169373: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
169377: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 171083: WHEN 34 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_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'
171087: WHEN 38 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 171304: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
171308: , fnd_lookup_values fvl85

Line 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;

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;
171527: TYPE t_array_source_96 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;

Line 171766: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
171770: , fnd_lookup_values fvl85

Line 177444: WHEN 10 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_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'
177448: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 177600: , ZX_AP_TAX_JRNL_LINE_DESC_V l5

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
177604: , (select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)

Line 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;

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;
177794: TYPE t_array_source_98 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 178040: , ZX_AP_TAX_JRNL_LINE_DESC_V l5

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
178044: WHERE xet.event_id between x_first_event_id and x_last_event_id