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_000010_PKG dependencies on AP_PO_HEADERS_EXTRACT_V

Line 125768: WHEN 5 THEN 'AP_PO_HEADERS_EXTRACT_V'

125764: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125765: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125766: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125767: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125768: WHEN 5 THEN 'AP_PO_HEADERS_EXTRACT_V'
125769: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125770: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125771: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125772: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 125780: WHEN 17 THEN 'AP_PO_HEADERS_EXTRACT_V'

125776: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125777: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125778: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125779: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125780: WHEN 17 THEN 'AP_PO_HEADERS_EXTRACT_V'
125781: WHEN 18 THEN 'AP_PO_HEADERS_EXTRACT_V'
125782: WHEN 19 THEN 'AP_PO_HEADERS_EXTRACT_V'
125783: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125784: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 125781: WHEN 18 THEN 'AP_PO_HEADERS_EXTRACT_V'

125777: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125778: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125779: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125780: WHEN 17 THEN 'AP_PO_HEADERS_EXTRACT_V'
125781: WHEN 18 THEN 'AP_PO_HEADERS_EXTRACT_V'
125782: WHEN 19 THEN 'AP_PO_HEADERS_EXTRACT_V'
125783: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125784: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125785: WHEN 22 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

Line 125782: WHEN 19 THEN 'AP_PO_HEADERS_EXTRACT_V'

125778: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125779: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125780: WHEN 17 THEN 'AP_PO_HEADERS_EXTRACT_V'
125781: WHEN 18 THEN 'AP_PO_HEADERS_EXTRACT_V'
125782: WHEN 19 THEN 'AP_PO_HEADERS_EXTRACT_V'
125783: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125784: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125785: WHEN 22 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
125786: WHEN 23 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

Line 125987: , AP_PO_HEADERS_EXTRACT_V l3

125983: ELSE null
125984: END source_meaning
125985: FROM xla_events_gt xet
125986: , AP_PAYMENT_EXTRACT_DETAILS_V l1
125987: , AP_PO_HEADERS_EXTRACT_V l3
125988: , ZX_AP_DEF_TAX_EXTRACT_V l5
125989: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
125990: , fnd_lookup_values fvl7
125991: , fnd_lookup_values fvl20

Line 126202: TYPE t_array_source_19 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;

126198: TYPE t_array_source_7 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;
126199: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
126200: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_CLEARING_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
126201: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
126202: TYPE t_array_source_19 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;
126203: TYPE t_array_source_20 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
126204: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_RET_RELATED_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
126205: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AWT_RELATED_DIST_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
126206: TYPE t_array_source_28 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.POD_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 126214: TYPE t_array_source_50 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

126210: TYPE t_array_source_41 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
126211: TYPE t_array_source_42 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
126212: TYPE t_array_source_47 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
126213: TYPE t_array_source_48 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
126214: TYPE t_array_source_50 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
126215: TYPE t_array_source_51 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;
126216: TYPE t_array_source_52 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
126217: TYPE t_array_source_53 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
126218: TYPE t_array_source_57 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 126215: TYPE t_array_source_51 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;

126211: TYPE t_array_source_42 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
126212: TYPE t_array_source_47 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
126213: TYPE t_array_source_48 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
126214: TYPE t_array_source_50 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
126215: TYPE t_array_source_51 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;
126216: TYPE t_array_source_52 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
126217: TYPE t_array_source_53 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
126218: TYPE t_array_source_57 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
126219: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 126216: TYPE t_array_source_52 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

126212: TYPE t_array_source_47 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
126213: TYPE t_array_source_48 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
126214: TYPE t_array_source_50 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
126215: TYPE t_array_source_51 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;
126216: TYPE t_array_source_52 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
126217: TYPE t_array_source_53 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
126218: TYPE t_array_source_57 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
126219: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
126220: TYPE t_array_source_59 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 126534: , AP_PO_HEADERS_EXTRACT_V l3

126530: , l1.BF_RETAINED_INV_DIST_ID_PMT source_149
126531: , l1.BF_RETAINED_INV_ID_PMT source_150
126532: FROM xla_events_gt xet
126533: , AP_PAYMENT_EXTRACT_DETAILS_V l1
126534: , AP_PO_HEADERS_EXTRACT_V l3
126535: , ZX_AP_DEF_TAX_EXTRACT_V l5
126536: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
126537: , fnd_lookup_values fvl7
126538: , fnd_lookup_values fvl20

Line 129751: WHEN 9 THEN 'AP_PO_HEADERS_EXTRACT_V'

129747: WHEN 5 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
129748: WHEN 6 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
129749: WHEN 7 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
129750: WHEN 8 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
129751: WHEN 9 THEN 'AP_PO_HEADERS_EXTRACT_V'
129752: WHEN 10 THEN 'AP_PO_HEADERS_EXTRACT_V'
129753: WHEN 11 THEN 'AP_PO_HEADERS_EXTRACT_V'
129754: WHEN 12 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
129755: WHEN 13 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

Line 129752: WHEN 10 THEN 'AP_PO_HEADERS_EXTRACT_V'

129748: WHEN 6 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
129749: WHEN 7 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
129750: WHEN 8 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
129751: WHEN 9 THEN 'AP_PO_HEADERS_EXTRACT_V'
129752: WHEN 10 THEN 'AP_PO_HEADERS_EXTRACT_V'
129753: WHEN 11 THEN 'AP_PO_HEADERS_EXTRACT_V'
129754: WHEN 12 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
129755: WHEN 13 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
129756: WHEN 14 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'

Line 129753: WHEN 11 THEN 'AP_PO_HEADERS_EXTRACT_V'

129749: WHEN 7 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
129750: WHEN 8 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
129751: WHEN 9 THEN 'AP_PO_HEADERS_EXTRACT_V'
129752: WHEN 10 THEN 'AP_PO_HEADERS_EXTRACT_V'
129753: WHEN 11 THEN 'AP_PO_HEADERS_EXTRACT_V'
129754: WHEN 12 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
129755: WHEN 13 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
129756: WHEN 14 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
129757: WHEN 15 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'

Line 130089: , AP_PO_HEADERS_EXTRACT_V l2

130085:
130086: ELSE null
130087: END source_meaning
130088: FROM xla_events_gt xet
130089: , AP_PO_HEADERS_EXTRACT_V l2
130090: , AP_PREPAYAPP_EXTRACT_DETAILS_V l3
130091: , ZX_AP_DEF_TAX_EXTRACT_V l5
130092: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
130093: , fnd_lookup_values fvl7

Line 130288: TYPE t_array_source_50 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

130284: TYPE t_array_source_36 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.RECP_INV_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
130285: TYPE t_array_source_40 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
130286: TYPE t_array_source_42 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
130287: TYPE t_array_source_48 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
130288: TYPE t_array_source_50 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
130289: TYPE t_array_source_51 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;
130290: TYPE t_array_source_52 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
130291: TYPE t_array_source_53 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
130292: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 130289: TYPE t_array_source_51 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;

130285: TYPE t_array_source_40 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
130286: TYPE t_array_source_42 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
130287: TYPE t_array_source_48 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
130288: TYPE t_array_source_50 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
130289: TYPE t_array_source_51 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;
130290: TYPE t_array_source_52 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
130291: TYPE t_array_source_53 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
130292: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
130293: TYPE t_array_source_59 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 130290: TYPE t_array_source_52 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

130286: TYPE t_array_source_42 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
130287: TYPE t_array_source_48 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
130288: TYPE t_array_source_50 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
130289: TYPE t_array_source_51 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;
130290: TYPE t_array_source_52 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
130291: TYPE t_array_source_53 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
130292: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
130293: TYPE t_array_source_59 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
130294: TYPE t_array_source_62 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 130614: , AP_PO_HEADERS_EXTRACT_V l2

130610: , fvl144.meaning source_144_meaning
130611: , l3.BF_RET_DIST_ASSOC_TO_PP_RECIP source_145
130612: , l3.BF_RET_INV_ASSOC_TO_PP_RECIP source_146
130613: FROM xla_events_gt xet
130614: , AP_PO_HEADERS_EXTRACT_V l2
130615: , AP_PREPAYAPP_EXTRACT_DETAILS_V l3
130616: , ZX_AP_DEF_TAX_EXTRACT_V l5
130617: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
130618: , fnd_lookup_values fvl7

Line 137542: WHEN 20 THEN 'AP_PO_HEADERS_EXTRACT_V'

137538: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
137539: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
137540: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
137541: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
137542: WHEN 20 THEN 'AP_PO_HEADERS_EXTRACT_V'
137543: WHEN 21 THEN 'AP_PO_HEADERS_EXTRACT_V'
137544: WHEN 22 THEN 'AP_PO_HEADERS_EXTRACT_V'
137545: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
137546: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 137543: WHEN 21 THEN 'AP_PO_HEADERS_EXTRACT_V'

137539: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
137540: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
137541: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
137542: WHEN 20 THEN 'AP_PO_HEADERS_EXTRACT_V'
137543: WHEN 21 THEN 'AP_PO_HEADERS_EXTRACT_V'
137544: WHEN 22 THEN 'AP_PO_HEADERS_EXTRACT_V'
137545: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
137546: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
137547: WHEN 25 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

Line 137544: WHEN 22 THEN 'AP_PO_HEADERS_EXTRACT_V'

137540: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
137541: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
137542: WHEN 20 THEN 'AP_PO_HEADERS_EXTRACT_V'
137543: WHEN 21 THEN 'AP_PO_HEADERS_EXTRACT_V'
137544: WHEN 22 THEN 'AP_PO_HEADERS_EXTRACT_V'
137545: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
137546: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
137547: WHEN 25 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
137548: WHEN 26 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

Line 137787: , AP_PO_HEADERS_EXTRACT_V l3

137783: ELSE null
137784: END source_meaning
137785: FROM xla_events_gt xet
137786: , AP_PAYMENT_EXTRACT_DETAILS_V l1
137787: , AP_PO_HEADERS_EXTRACT_V l3
137788: , ZX_AP_DEF_TAX_EXTRACT_V l5
137789: , fnd_lookup_values fvl7
137790: , fnd_lookup_values fvl20
137791: , fnd_lookup_values fvl39

Line 138023: TYPE t_array_source_50 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

138019: TYPE t_array_source_45 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_PAYMENT_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
138020: TYPE t_array_source_46 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_PAYMENT_ID%TYPE INDEX BY BINARY_INTEGER;
138021: TYPE t_array_source_47 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
138022: TYPE t_array_source_48 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
138023: TYPE t_array_source_50 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
138024: TYPE t_array_source_51 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;
138025: TYPE t_array_source_52 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
138026: TYPE t_array_source_53 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
138027: TYPE t_array_source_57 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 138024: TYPE t_array_source_51 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;

138020: TYPE t_array_source_46 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_PAYMENT_ID%TYPE INDEX BY BINARY_INTEGER;
138021: TYPE t_array_source_47 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
138022: TYPE t_array_source_48 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
138023: TYPE t_array_source_50 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
138024: TYPE t_array_source_51 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;
138025: TYPE t_array_source_52 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
138026: TYPE t_array_source_53 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
138027: TYPE t_array_source_57 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
138028: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 138025: TYPE t_array_source_52 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

138021: TYPE t_array_source_47 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
138022: TYPE t_array_source_48 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
138023: TYPE t_array_source_50 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
138024: TYPE t_array_source_51 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;
138025: TYPE t_array_source_52 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
138026: TYPE t_array_source_53 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
138027: TYPE t_array_source_57 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
138028: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
138029: TYPE t_array_source_59 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 138349: , AP_PO_HEADERS_EXTRACT_V l3

138345: , l1.AWT_AT_PMT_TIME source_151
138346: , fvl151.meaning source_151_meaning
138347: FROM xla_events_gt xet
138348: , AP_PAYMENT_EXTRACT_DETAILS_V l1
138349: , AP_PO_HEADERS_EXTRACT_V l3
138350: , ZX_AP_DEF_TAX_EXTRACT_V l5
138351: , fnd_lookup_values fvl7
138352: , fnd_lookup_values fvl20
138353: , fnd_lookup_values fvl39

Line 141689: WHEN 14 THEN 'AP_PO_HEADERS_EXTRACT_V'

141685: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
141686: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
141687: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
141688: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
141689: WHEN 14 THEN 'AP_PO_HEADERS_EXTRACT_V'
141690: WHEN 15 THEN 'AP_PO_HEADERS_EXTRACT_V'
141691: WHEN 16 THEN 'AP_PO_HEADERS_EXTRACT_V'
141692: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
141693: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 141690: WHEN 15 THEN 'AP_PO_HEADERS_EXTRACT_V'

141686: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
141687: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
141688: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
141689: WHEN 14 THEN 'AP_PO_HEADERS_EXTRACT_V'
141690: WHEN 15 THEN 'AP_PO_HEADERS_EXTRACT_V'
141691: WHEN 16 THEN 'AP_PO_HEADERS_EXTRACT_V'
141692: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
141693: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
141694: WHEN 19 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

Line 141691: WHEN 16 THEN 'AP_PO_HEADERS_EXTRACT_V'

141687: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
141688: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
141689: WHEN 14 THEN 'AP_PO_HEADERS_EXTRACT_V'
141690: WHEN 15 THEN 'AP_PO_HEADERS_EXTRACT_V'
141691: WHEN 16 THEN 'AP_PO_HEADERS_EXTRACT_V'
141692: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
141693: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
141694: WHEN 19 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
141695: WHEN 20 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

Line 141849: , AP_PO_HEADERS_EXTRACT_V l3

141845: ELSE null
141846: END source_meaning
141847: FROM xla_events_gt xet
141848: , AP_PAYMENT_EXTRACT_DETAILS_V l1
141849: , AP_PO_HEADERS_EXTRACT_V l3
141850: , ZX_AP_DEF_TAX_EXTRACT_V l5
141851: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
141852: , fnd_lookup_values fvl7
141853: , fnd_lookup_values fvl20

Line 142063: TYPE t_array_source_50 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

142059: TYPE t_array_source_41 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
142060: TYPE t_array_source_42 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
142061: TYPE t_array_source_47 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
142062: TYPE t_array_source_48 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
142063: TYPE t_array_source_50 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
142064: TYPE t_array_source_51 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;
142065: TYPE t_array_source_52 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
142066: TYPE t_array_source_53 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
142067: TYPE t_array_source_57 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 142064: TYPE t_array_source_51 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;

142060: TYPE t_array_source_42 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
142061: TYPE t_array_source_47 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
142062: TYPE t_array_source_48 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
142063: TYPE t_array_source_50 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
142064: TYPE t_array_source_51 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;
142065: TYPE t_array_source_52 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
142066: TYPE t_array_source_53 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
142067: TYPE t_array_source_57 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
142068: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 142065: TYPE t_array_source_52 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

142061: TYPE t_array_source_47 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
142062: TYPE t_array_source_48 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
142063: TYPE t_array_source_50 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
142064: TYPE t_array_source_51 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;
142065: TYPE t_array_source_52 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
142066: TYPE t_array_source_53 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
142067: TYPE t_array_source_57 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
142068: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
142069: TYPE t_array_source_59 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 142322: , AP_PO_HEADERS_EXTRACT_V l3

142318: , l1.AID_ENCUMBERED_FLAG source_104
142319: , fvl104.meaning source_104_meaning
142320: FROM xla_events_gt xet
142321: , AP_PAYMENT_EXTRACT_DETAILS_V l1
142322: , AP_PO_HEADERS_EXTRACT_V l3
142323: , ZX_AP_DEF_TAX_EXTRACT_V l5
142324: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
142325: , fnd_lookup_values fvl7
142326: , fnd_lookup_values fvl20