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

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

Line 144469: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
144473: , fnd_lookup_values fvl96

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

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

Line 144948: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
144952: , fnd_lookup_values fvl96

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

Line 147753: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
147757: , fnd_lookup_values fvl96

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

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

Line 148219: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
148223: , fnd_lookup_values fvl96

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

Line 153394: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
153398: , fnd_lookup_values fvl96

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

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

Line 153879: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
153883: , fnd_lookup_values fvl96

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

Line 156810: , ZX_AP_TAX_JRNL_LINE_DESC_V l5

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
156814: , fnd_lookup_values fvl137

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

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

Line 157335: , ZX_AP_TAX_JRNL_LINE_DESC_V l5

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
157339: , fnd_lookup_values fvl137

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

Line 159905: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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

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

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

Line 160353: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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

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

Line 162326: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
162330: , fnd_lookup_values fvl96

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

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

Line 162800: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
162804: , fnd_lookup_values fvl96

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

Line 168730: , ZX_AP_TAX_JRNL_LINE_DESC_V l5

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

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

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

Line 169182: , ZX_AP_TAX_JRNL_LINE_DESC_V l5

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