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_TAX_JRNL_LINE_DESC_V

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

Line 144344: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
144348: , fnd_lookup_values fvl95

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

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

Line 144829: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
144833: , fnd_lookup_values fvl95

Line 147420: WHEN 36 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_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'
147424: WHEN 40 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 147653: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
147657: , fnd_lookup_values fvl95

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

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

Line 148125: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
148129: , fnd_lookup_values fvl95

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

Line 153343: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
153347: , fnd_lookup_values fvl95

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

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

Line 153834: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
153838: , fnd_lookup_values fvl95

Line 156582: WHEN 12 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_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'
156586: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 156774: , ZX_AP_TAX_JRNL_LINE_DESC_V l5

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
156778: , fnd_lookup_values fvl125

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

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

Line 157299: , ZX_AP_TAX_JRNL_LINE_DESC_V l5

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
157303: , fnd_lookup_values fvl125

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

Line 159809: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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

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

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

Line 160236: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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

Line 161914: WHEN 33 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_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'
161918: WHEN 37 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 162141: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
162145: , fnd_lookup_values fvl95

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

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

Line 162621: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
162625: , fnd_lookup_values fvl95

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

Line 168545: , ZX_AP_TAX_JRNL_LINE_DESC_V l5

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

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

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

Line 169000: , ZX_AP_TAX_JRNL_LINE_DESC_V l5

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