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

Line 99017: WHEN 5 THEN 'AP_PO_HEADERS_EXTRACT_V'

99013: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
99014: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
99015: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
99016: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
99017: WHEN 5 THEN 'AP_PO_HEADERS_EXTRACT_V'
99018: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
99019: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
99020: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
99021: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 99029: WHEN 17 THEN 'AP_PO_HEADERS_EXTRACT_V'

99025: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
99026: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
99027: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
99028: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
99029: WHEN 17 THEN 'AP_PO_HEADERS_EXTRACT_V'
99030: WHEN 18 THEN 'AP_PO_HEADERS_EXTRACT_V'
99031: WHEN 19 THEN 'AP_PO_HEADERS_EXTRACT_V'
99032: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
99033: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 99030: WHEN 18 THEN 'AP_PO_HEADERS_EXTRACT_V'

99026: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
99027: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
99028: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
99029: WHEN 17 THEN 'AP_PO_HEADERS_EXTRACT_V'
99030: WHEN 18 THEN 'AP_PO_HEADERS_EXTRACT_V'
99031: WHEN 19 THEN 'AP_PO_HEADERS_EXTRACT_V'
99032: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
99033: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
99034: WHEN 22 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

Line 99031: WHEN 19 THEN 'AP_PO_HEADERS_EXTRACT_V'

99027: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
99028: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
99029: WHEN 17 THEN 'AP_PO_HEADERS_EXTRACT_V'
99030: WHEN 18 THEN 'AP_PO_HEADERS_EXTRACT_V'
99031: WHEN 19 THEN 'AP_PO_HEADERS_EXTRACT_V'
99032: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
99033: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
99034: WHEN 22 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
99035: WHEN 23 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

Line 99210: , AP_PO_HEADERS_EXTRACT_V l3

99206: ELSE null
99207: END source_meaning
99208: FROM xla_events_gt xet
99209: , AP_PAYMENT_EXTRACT_DETAILS_V l1
99210: , AP_PO_HEADERS_EXTRACT_V l3
99211: , ZX_AP_DEF_TAX_EXTRACT_V l5
99212: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
99213: , fnd_lookup_values fvl19
99214: , fnd_lookup_values fvl32

Line 99423: TYPE t_array_source_31 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;

99419: TYPE t_array_source_19 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;
99420: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
99421: TYPE t_array_source_22 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_CLEARING_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
99422: TYPE t_array_source_29 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
99423: TYPE t_array_source_31 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;
99424: TYPE t_array_source_32 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
99425: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_RET_RELATED_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
99426: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AWT_RELATED_DIST_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
99427: TYPE t_array_source_40 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.POD_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 99435: TYPE t_array_source_61 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

99431: TYPE t_array_source_53 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
99432: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
99433: TYPE t_array_source_59 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
99434: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
99435: TYPE t_array_source_61 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
99436: TYPE t_array_source_62 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;
99437: TYPE t_array_source_63 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
99438: TYPE t_array_source_64 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
99439: TYPE t_array_source_68 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 99436: TYPE t_array_source_62 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;

99432: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
99433: TYPE t_array_source_59 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
99434: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
99435: TYPE t_array_source_61 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
99436: TYPE t_array_source_62 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;
99437: TYPE t_array_source_63 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
99438: TYPE t_array_source_64 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
99439: TYPE t_array_source_68 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
99440: TYPE t_array_source_69 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 99437: TYPE t_array_source_63 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

99433: TYPE t_array_source_59 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
99434: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
99435: TYPE t_array_source_61 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
99436: TYPE t_array_source_62 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;
99437: TYPE t_array_source_63 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
99438: TYPE t_array_source_64 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
99439: TYPE t_array_source_68 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
99440: TYPE t_array_source_69 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
99441: TYPE t_array_source_70 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 99737: , AP_PO_HEADERS_EXTRACT_V l3

99733: , l1.BF_RETAINED_INV_DIST_ID_PMT source_153
99734: , l1.BF_RETAINED_INV_ID_PMT source_154
99735: FROM xla_events_gt xet
99736: , AP_PAYMENT_EXTRACT_DETAILS_V l1
99737: , AP_PO_HEADERS_EXTRACT_V l3
99738: , ZX_AP_DEF_TAX_EXTRACT_V l5
99739: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
99740: , fnd_lookup_values fvl19
99741: , fnd_lookup_values fvl32

Line 102340: WHEN 9 THEN 'AP_PO_HEADERS_EXTRACT_V'

102336: WHEN 5 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
102337: WHEN 6 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
102338: WHEN 7 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
102339: WHEN 8 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
102340: WHEN 9 THEN 'AP_PO_HEADERS_EXTRACT_V'
102341: WHEN 10 THEN 'AP_PO_HEADERS_EXTRACT_V'
102342: WHEN 11 THEN 'AP_PO_HEADERS_EXTRACT_V'
102343: WHEN 12 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
102344: WHEN 13 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

Line 102341: WHEN 10 THEN 'AP_PO_HEADERS_EXTRACT_V'

102337: WHEN 6 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
102338: WHEN 7 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
102339: WHEN 8 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
102340: WHEN 9 THEN 'AP_PO_HEADERS_EXTRACT_V'
102341: WHEN 10 THEN 'AP_PO_HEADERS_EXTRACT_V'
102342: WHEN 11 THEN 'AP_PO_HEADERS_EXTRACT_V'
102343: WHEN 12 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
102344: WHEN 13 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
102345: WHEN 14 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'

Line 102342: WHEN 11 THEN 'AP_PO_HEADERS_EXTRACT_V'

102338: WHEN 7 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
102339: WHEN 8 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
102340: WHEN 9 THEN 'AP_PO_HEADERS_EXTRACT_V'
102341: WHEN 10 THEN 'AP_PO_HEADERS_EXTRACT_V'
102342: WHEN 11 THEN 'AP_PO_HEADERS_EXTRACT_V'
102343: WHEN 12 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
102344: WHEN 13 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
102345: WHEN 14 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
102346: WHEN 15 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'

Line 102667: , AP_PO_HEADERS_EXTRACT_V l2

102663:
102664: ELSE null
102665: END source_meaning
102666: FROM xla_events_gt xet
102667: , AP_PO_HEADERS_EXTRACT_V l2
102668: , AP_PREPAYAPP_EXTRACT_DETAILS_V l3
102669: , ZX_AP_DEF_TAX_EXTRACT_V l5
102670: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
102671: , fnd_lookup_values fvl19

Line 102864: TYPE t_array_source_61 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

102860: TYPE t_array_source_48 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.RECP_INV_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
102861: TYPE t_array_source_52 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
102862: TYPE t_array_source_54 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
102863: TYPE t_array_source_60 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
102864: TYPE t_array_source_61 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
102865: TYPE t_array_source_62 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;
102866: TYPE t_array_source_63 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
102867: TYPE t_array_source_64 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
102868: TYPE t_array_source_69 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 102865: TYPE t_array_source_62 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;

102861: TYPE t_array_source_52 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
102862: TYPE t_array_source_54 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
102863: TYPE t_array_source_60 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
102864: TYPE t_array_source_61 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
102865: TYPE t_array_source_62 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;
102866: TYPE t_array_source_63 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
102867: TYPE t_array_source_64 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
102868: TYPE t_array_source_69 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
102869: TYPE t_array_source_70 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 102866: TYPE t_array_source_63 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

102862: TYPE t_array_source_54 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
102863: TYPE t_array_source_60 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
102864: TYPE t_array_source_61 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
102865: TYPE t_array_source_62 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;
102866: TYPE t_array_source_63 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
102867: TYPE t_array_source_64 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
102868: TYPE t_array_source_69 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
102869: TYPE t_array_source_70 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
102870: TYPE t_array_source_73 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 103181: , AP_PO_HEADERS_EXTRACT_V l2

103177: , fvl148.meaning source_148_meaning
103178: , l3.BF_RET_DIST_ASSOC_TO_PP_RECIP source_149
103179: , l3.BF_RET_INV_ASSOC_TO_PP_RECIP source_150
103180: FROM xla_events_gt xet
103181: , AP_PO_HEADERS_EXTRACT_V l2
103182: , AP_PREPAYAPP_EXTRACT_DETAILS_V l3
103183: , ZX_AP_DEF_TAX_EXTRACT_V l5
103184: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
103185: , fnd_lookup_values fvl19

Line 106585: WHEN 20 THEN 'AP_PO_HEADERS_EXTRACT_V'

106581: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
106582: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
106583: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
106584: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
106585: WHEN 20 THEN 'AP_PO_HEADERS_EXTRACT_V'
106586: WHEN 21 THEN 'AP_PO_HEADERS_EXTRACT_V'
106587: WHEN 22 THEN 'AP_PO_HEADERS_EXTRACT_V'
106588: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
106589: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 106586: WHEN 21 THEN 'AP_PO_HEADERS_EXTRACT_V'

106582: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
106583: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
106584: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
106585: WHEN 20 THEN 'AP_PO_HEADERS_EXTRACT_V'
106586: WHEN 21 THEN 'AP_PO_HEADERS_EXTRACT_V'
106587: WHEN 22 THEN 'AP_PO_HEADERS_EXTRACT_V'
106588: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
106589: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
106590: WHEN 25 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

Line 106587: WHEN 22 THEN 'AP_PO_HEADERS_EXTRACT_V'

106583: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
106584: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
106585: WHEN 20 THEN 'AP_PO_HEADERS_EXTRACT_V'
106586: WHEN 21 THEN 'AP_PO_HEADERS_EXTRACT_V'
106587: WHEN 22 THEN 'AP_PO_HEADERS_EXTRACT_V'
106588: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
106589: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
106590: WHEN 25 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
106591: WHEN 26 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

Line 106784: , AP_PO_HEADERS_EXTRACT_V l3

106780: ELSE null
106781: END source_meaning
106782: FROM xla_events_gt xet
106783: , AP_PAYMENT_EXTRACT_DETAILS_V l1
106784: , AP_PO_HEADERS_EXTRACT_V l3
106785: , ZX_AP_DEF_TAX_EXTRACT_V l5
106786: , fnd_lookup_values fvl19
106787: , fnd_lookup_values fvl32
106788: , fnd_lookup_values fvl51

Line 107018: TYPE t_array_source_61 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

107014: TYPE t_array_source_57 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_PAYMENT_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
107015: TYPE t_array_source_58 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_PAYMENT_ID%TYPE INDEX BY BINARY_INTEGER;
107016: TYPE t_array_source_59 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
107017: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
107018: TYPE t_array_source_61 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
107019: TYPE t_array_source_62 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;
107020: TYPE t_array_source_63 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
107021: TYPE t_array_source_64 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
107022: TYPE t_array_source_68 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 107019: TYPE t_array_source_62 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;

107015: TYPE t_array_source_58 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_PAYMENT_ID%TYPE INDEX BY BINARY_INTEGER;
107016: TYPE t_array_source_59 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
107017: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
107018: TYPE t_array_source_61 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
107019: TYPE t_array_source_62 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;
107020: TYPE t_array_source_63 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
107021: TYPE t_array_source_64 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
107022: TYPE t_array_source_68 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
107023: TYPE t_array_source_69 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 107020: TYPE t_array_source_63 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

107016: TYPE t_array_source_59 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
107017: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
107018: TYPE t_array_source_61 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
107019: TYPE t_array_source_62 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;
107020: TYPE t_array_source_63 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
107021: TYPE t_array_source_64 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
107022: TYPE t_array_source_68 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
107023: TYPE t_array_source_69 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
107024: TYPE t_array_source_70 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 107314: , AP_PO_HEADERS_EXTRACT_V l3

107310: , l1.AWT_AT_PMT_TIME source_155
107311: , fvl155.meaning source_155_meaning
107312: FROM xla_events_gt xet
107313: , AP_PAYMENT_EXTRACT_DETAILS_V l1
107314: , AP_PO_HEADERS_EXTRACT_V l3
107315: , ZX_AP_DEF_TAX_EXTRACT_V l5
107316: , fnd_lookup_values fvl19
107317: , fnd_lookup_values fvl32
107318: , fnd_lookup_values fvl51

Line 110088: WHEN 14 THEN 'AP_PO_HEADERS_EXTRACT_V'

110084: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
110085: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
110086: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
110087: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
110088: WHEN 14 THEN 'AP_PO_HEADERS_EXTRACT_V'
110089: WHEN 15 THEN 'AP_PO_HEADERS_EXTRACT_V'
110090: WHEN 16 THEN 'AP_PO_HEADERS_EXTRACT_V'
110091: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
110092: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 110089: WHEN 15 THEN 'AP_PO_HEADERS_EXTRACT_V'

110085: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
110086: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
110087: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
110088: WHEN 14 THEN 'AP_PO_HEADERS_EXTRACT_V'
110089: WHEN 15 THEN 'AP_PO_HEADERS_EXTRACT_V'
110090: WHEN 16 THEN 'AP_PO_HEADERS_EXTRACT_V'
110091: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
110092: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
110093: WHEN 19 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

Line 110090: WHEN 16 THEN 'AP_PO_HEADERS_EXTRACT_V'

110086: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
110087: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
110088: WHEN 14 THEN 'AP_PO_HEADERS_EXTRACT_V'
110089: WHEN 15 THEN 'AP_PO_HEADERS_EXTRACT_V'
110090: WHEN 16 THEN 'AP_PO_HEADERS_EXTRACT_V'
110091: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
110092: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
110093: WHEN 19 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
110094: WHEN 20 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

Line 110236: , AP_PO_HEADERS_EXTRACT_V l3

110232: ELSE null
110233: END source_meaning
110234: FROM xla_events_gt xet
110235: , AP_PAYMENT_EXTRACT_DETAILS_V l1
110236: , AP_PO_HEADERS_EXTRACT_V l3
110237: , ZX_AP_DEF_TAX_EXTRACT_V l5
110238: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
110239: , fnd_lookup_values fvl19
110240: , fnd_lookup_values fvl32

Line 110443: TYPE t_array_source_61 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

110439: TYPE t_array_source_53 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
110440: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
110441: TYPE t_array_source_59 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
110442: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
110443: TYPE t_array_source_61 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
110444: TYPE t_array_source_62 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;
110445: TYPE t_array_source_63 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
110446: TYPE t_array_source_64 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
110447: TYPE t_array_source_68 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 110444: TYPE t_array_source_62 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;

110440: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_AP_APP_ID%TYPE INDEX BY BINARY_INTEGER;
110441: TYPE t_array_source_59 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
110442: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
110443: TYPE t_array_source_61 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
110444: TYPE t_array_source_62 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;
110445: TYPE t_array_source_63 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
110446: TYPE t_array_source_64 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
110447: TYPE t_array_source_68 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
110448: TYPE t_array_source_69 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 110445: TYPE t_array_source_63 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

110441: TYPE t_array_source_59 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
110442: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
110443: TYPE t_array_source_61 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
110444: TYPE t_array_source_62 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;
110445: TYPE t_array_source_63 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
110446: TYPE t_array_source_64 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
110447: TYPE t_array_source_68 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
110448: TYPE t_array_source_69 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
110449: TYPE t_array_source_70 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 110691: , AP_PO_HEADERS_EXTRACT_V l3

110687: , l1.POD_ACCRUE_ON_RECEIPT_FLAG source_111
110688: , fvl111.meaning source_111_meaning
110689: FROM xla_events_gt xet
110690: , AP_PAYMENT_EXTRACT_DETAILS_V l1
110691: , AP_PO_HEADERS_EXTRACT_V l3
110692: , ZX_AP_DEF_TAX_EXTRACT_V l5
110693: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
110694: , fnd_lookup_values fvl19
110695: , fnd_lookup_values fvl32