APPS.FND_TS_SIZE dependencies on FND_TS_MIG_UTIL

Line 83: l_version := fnd_ts_mig_util.get_db_version;

79: */
80: l_object_type := cur_rec.object_type;
81:
82: if cur_rec.object_type = 'LOB PARTITION' then
83: l_version := fnd_ts_mig_util.get_db_version;
84: end if;
85:
86: if cur_rec.object_type = 'LOB PARTITION' AND l_version < 10 then
87: OPEN lob_part_siz_csr;

Line 240: fnd_ts_mig_util.l_unclass_tsp object_class,

236: -- MINUS IOT and IOT OVERFLOW TABLES
237: SELECT /*+ rule */ d.owner,
238: d.table_name,
239: d.tablespace_name,
240: fnd_ts_mig_util.l_unclass_tsp object_class,
241: 'table' parent,
242: 'TABLE' object_type,
243: 'TABLE' subobject_type,
244: 'NO' classified,

Line 282: fnd_ts_mig_util.l_def_mv_tsp object_class,

278: -- MVIEW LOGS
279: SELECT /*+ rule */ distinct dsl.log_owner,
280: dsl.log_table table_name,
281: dt.tablespace_name,
282: fnd_ts_mig_util.l_def_mv_tsp object_class,
283: dt.table_name parent,
284: 'TABLE' object_type,
285: 'MV_LOG' subobject_type,
286: 'NO' classified,

Line 301: fnd_ts_mig_util.l_def_mv_tsp object_class,

297: -- MVIEWS
298: SELECT /*+ rule */ d.owner,
299: d.name table_name,
300: dt.tablespace_name,
301: fnd_ts_mig_util.l_def_mv_tsp object_class,
302: dt.table_name parent,
303: 'TABLE' object_type,
304: 'MVIEW' subobject_type,
305: 'NO' classified,

Line 322: fnd_ts_mig_util.l_def_tab_tsp object_class,

318: -- MINUS IOT START WITH 'DR$%' (Domain Index Tables IOT OVERFLOW)
319: SELECT /*+ rule */ dt.owner,
320: dt.table_name table_name,
321: dt.tablespace_name,
322: fnd_ts_mig_util.l_def_tab_tsp object_class,
323: dt.iot_name parent,
324: 'TABLE' object_type,
325: 'IOT' subobject_type,
326: 'NO' classified,

Line 340: fnd_ts_mig_util.l_aq_tab_tsp object_class,

336: -- IOT OVERFLOW FOR AQ TABLES
337: SELECT /*+ rule */ dt.owner,
338: dt.table_name table_name,
339: dt.tablespace_name,
340: fnd_ts_mig_util.l_aq_tab_tsp object_class,
341: --fnd_ts_mig_util.l_def_tab_tsp object_class,
342: dt.iot_name parent,
343: 'TABLE' object_type,
344: 'AQ' subobject_type,

Line 341: --fnd_ts_mig_util.l_def_tab_tsp object_class,

337: SELECT /*+ rule */ dt.owner,
338: dt.table_name table_name,
339: dt.tablespace_name,
340: fnd_ts_mig_util.l_aq_tab_tsp object_class,
341: --fnd_ts_mig_util.l_def_tab_tsp object_class,
342: dt.iot_name parent,
343: 'TABLE' object_type,
344: 'AQ' subobject_type,
345: 'NO' classified,

Line 358: fnd_ts_mig_util.l_def_ind_tsp object_class,

354: -- IOT OVERFLOW for Domain Indexes IOTs
355: SELECT /*+ rule */ dt.owner,
356: dt.table_name table_name,
357: dt.tablespace_name,
358: fnd_ts_mig_util.l_def_ind_tsp object_class,
359: dt.iot_name parent,
360: 'TABLE' object_type,
361: 'DOMAIN' subobject_type,
362: 'NO' classified,

Line 404: fnd_ts_mig_util.l_unclass_tsp object_class,

400: -- (no IOT, MVs, AQs, Domain Indexes)
401: select /*+ rule */ d.owner,
402: d.segment_name table_name,
403: dt.tablespace_name,
404: fnd_ts_mig_util.l_unclass_tsp object_class,
405: d.table_name parent,
406: 'LOB' object_type,
407: 'TABLE' subobject_type,
408: 'NO' classified,

Line 451: fnd_ts_mig_util.l_def_tab_tsp object_class,

447: -- Minus AQ and Domain Index
448: select /*+ rule */ d.owner,
449: d.segment_name table_name,
450: dt.tablespace_name,
451: fnd_ts_mig_util.l_def_tab_tsp object_class,
452: d.table_name parent,
453: 'LOB' object_type,
454: 'IOT' subobject_type,
455: 'NO' classified,

Line 482: fnd_ts_mig_util.l_def_mv_tsp object_class,

478: -- LOBs in MVs
479: select /*+ rule */ d.owner,
480: d.segment_name table_name,
481: dt.tablespace_name,
482: fnd_ts_mig_util.l_def_mv_tsp object_class,
483: d.table_name parent,
484: 'LOB' object_type,
485: 'MVIEW' subobject_type,
486: 'NO' classified,

Line 506: fnd_ts_mig_util.l_aq_tab_tsp object_class,

502: -- LOBS in AQs
503: select /*+ rule */ d.owner,
504: d.segment_name table_name,
505: dt.tablespace_name,
506: fnd_ts_mig_util.l_aq_tab_tsp object_class,
507: --fnd_ts_mig_util.l_def_tab_tsp object_class,
508: d.table_name parent,
509: 'LOB' object_type,
510: 'AQ' subobject_type,

Line 507: --fnd_ts_mig_util.l_def_tab_tsp object_class,

503: select /*+ rule */ d.owner,
504: d.segment_name table_name,
505: dt.tablespace_name,
506: fnd_ts_mig_util.l_aq_tab_tsp object_class,
507: --fnd_ts_mig_util.l_def_tab_tsp object_class,
508: d.table_name parent,
509: 'LOB' object_type,
510: 'AQ' subobject_type,
511: 'NO' classified,

Line 532: fnd_ts_mig_util.l_def_ind_tsp object_class,

528: -- LOBS in Domain Index Objects
529: select /*+ rule */ d.owner,
530: d.segment_name table_name,
531: dt.tablespace_name,
532: fnd_ts_mig_util.l_def_ind_tsp object_class,
533: d.table_name parent,
534: 'LOB' object_type,
535: 'DOMAIN' subobject_type,
536: 'NO' classified,

Line 552: fnd_ts_mig_util.l_aq_tab_tsp object_class,

548: -- Parent AQ tables
549: SELECT /*+ rule */ dt.owner,
550: dqt.queue_table table_name,
551: dt.tablespace_name,
552: fnd_ts_mig_util.l_aq_tab_tsp object_class,
553: --fnd_ts_mig_util.l_def_tab_tsp object_class,
554: 'table' parent,
555: 'TABLE' object_type,
556: 'AQ' subobject_type,

Line 553: --fnd_ts_mig_util.l_def_tab_tsp object_class,

549: SELECT /*+ rule */ dt.owner,
550: dqt.queue_table table_name,
551: dt.tablespace_name,
552: fnd_ts_mig_util.l_aq_tab_tsp object_class,
553: --fnd_ts_mig_util.l_def_tab_tsp object_class,
554: 'table' parent,
555: 'TABLE' object_type,
556: 'AQ' subobject_type,
557: 'NO' classified,

Line 572: fnd_ts_mig_util.l_aq_tab_tsp object_class,

568: -- Child AQ tables not IOTs
569: SELECT /*+ rule */ dt.owner,
570: dt.table_name table_name,
571: dt.tablespace_name,
572: fnd_ts_mig_util.l_aq_tab_tsp object_class,
573: --fnd_ts_mig_util.l_def_tab_tsp object_class,
574: SUBSTR(dt.table_name, 5, LENGTH(dt.table_name)-6) parent,
575: 'TABLE' object_type,
576: 'AQ' subobject_type,

Line 573: --fnd_ts_mig_util.l_def_tab_tsp object_class,

569: SELECT /*+ rule */ dt.owner,
570: dt.table_name table_name,
571: dt.tablespace_name,
572: fnd_ts_mig_util.l_aq_tab_tsp object_class,
573: --fnd_ts_mig_util.l_def_tab_tsp object_class,
574: SUBSTR(dt.table_name, 5, LENGTH(dt.table_name)-6) parent,
575: 'TABLE' object_type,
576: 'AQ' subobject_type,
577: 'NO' classified,

Line 590: fnd_ts_mig_util.l_def_ind_tsp object_class,

586: -- Domain Indexes tables not IOTs
587: SELECT /*+ rule */ dt.owner,
588: dt.table_name table_name,
589: dt.tablespace_name,
590: fnd_ts_mig_util.l_def_ind_tsp object_class,
591: SUBSTR(dt.table_name, 4, LENGTH(dt.table_name)-5) parent,
592: 'TABLE' object_type,
593: 'DOMAIN' subobject_type,
594: 'NO' classified,

Line 694: decode(nvl(o.custom_tablespace_type, o.tablespace_type), fnd_ts_mig_util.l_def_tab_tsp, fnd_ts_mig_util.l_def_ind_tsp, o.tablespace_type) object_class,

690: -- Indexes on Classified Tables
691: select /*+ rule */ i.owner,
692: i.index_name table_name,
693: i.tablespace_name,
694: decode(nvl(o.custom_tablespace_type, o.tablespace_type), fnd_ts_mig_util.l_def_tab_tsp, fnd_ts_mig_util.l_def_ind_tsp, o.tablespace_type) object_class,
695: i.table_name parent,
696: 'INDEX' object_type,
697: 'INDEX' subobject_type,
698: 'YES' classified,

Line 713: decode(nvl(o.custom_tablespace_type, o.tablespace_type), fnd_ts_mig_util.l_def_tab_tsp, fnd_ts_mig_util.l_def_tab_tsp, o.tablespace_type) object_class,

709: -- LOB Indexes on Classified Tables
710: select /*+ rule */ i.owner,
711: i.index_name table_name,
712: i.tablespace_name,
713: decode(nvl(o.custom_tablespace_type, o.tablespace_type), fnd_ts_mig_util.l_def_tab_tsp, fnd_ts_mig_util.l_def_tab_tsp, o.tablespace_type) object_class,
714: i.table_name parent,
715: 'INDEX' object_type,
716: 'INDEX' subobject_type,
717: 'YES' classified,

Line 733: fnd_ts_mig_util.l_unclass_ind_tsp object_class,

729: -- (no IOTs, MVs, MV Logs, AQs, Domain Indexes)
730: SELECT /*+ rule */ i.owner,
731: i.index_name table_name,
732: i.tablespace_name,
733: fnd_ts_mig_util.l_unclass_ind_tsp object_class,
734: i.table_name parent,
735: 'INDEX' object_type,
736: 'INDEX' subobject_type,
737: 'NO' classified,

Line 777: fnd_ts_mig_util.l_unclass_tsp object_class,

773: -- (no IOTs, MVs, MV Logs, AQs, Domain Indexes)
774: SELECT /*+ rule */ i.owner,
775: i.index_name table_name,
776: i.tablespace_name,
777: fnd_ts_mig_util.l_unclass_tsp object_class,
778: i.table_name parent,
779: 'INDEX' object_type,
780: 'INDEX' subobject_type,
781: 'NO' classified,

Line 823: fnd_ts_mig_util.l_aq_tab_tsp object_class,

819: -- Minus Domain Indexes IOTs
820: SELECT /*+ rule */ d.owner,
821: d.index_name table_name,
822: d.tablespace_name,
823: fnd_ts_mig_util.l_aq_tab_tsp object_class,
824: --fnd_ts_mig_util.l_def_tab_tsp object_class,
825: d.table_name parent,
826: 'INDEX' object_type,
827: 'IOT' subobject_type,

Line 824: --fnd_ts_mig_util.l_def_tab_tsp object_class,

820: SELECT /*+ rule */ d.owner,
821: d.index_name table_name,
822: d.tablespace_name,
823: fnd_ts_mig_util.l_aq_tab_tsp object_class,
824: --fnd_ts_mig_util.l_def_tab_tsp object_class,
825: d.table_name parent,
826: 'INDEX' object_type,
827: 'IOT' subobject_type,
828: 'NO' classified,

Line 843: fnd_ts_mig_util.l_def_ind_tsp object_class,

839: -- Minus Indexes on AQ IOTs and Domain Index IOTs
840: SELECT /*+ rule */ i.owner,
841: i.index_name table_name,
842: i.tablespace_name,
843: fnd_ts_mig_util.l_def_ind_tsp object_class,
844: i.table_name parent,
845: 'INDEX' object_type,
846: 'IOT' subobject_type,
847: 'NO' classified,

Line 872: fnd_ts_mig_util.l_def_tab_tsp object_class,

868: -- Minus Indexes on AQ IOTs and Domain Index IOTs
869: SELECT /*+ rule */ i.owner,
870: i.index_name table_name,
871: i.tablespace_name,
872: fnd_ts_mig_util.l_def_tab_tsp object_class,
873: i.table_name parent,
874: 'INDEX' object_type,
875: 'IOT' subobject_type,
876: 'NO' classified,

Line 900: fnd_ts_mig_util.l_def_mv_tsp object_class,

896: -- Indexes on MVs
897: select /*+ rule */ i.owner,
898: i.index_name table_name,
899: i.tablespace_name,
900: fnd_ts_mig_util.l_def_mv_tsp object_class,
901: i.table_name parent,
902: 'INDEX' object_type,
903: 'MVIEW' subobject_type,
904: 'NO' classified,

Line 921: fnd_ts_mig_util.l_def_mv_tsp object_class,

917: -- Indexes on MVs
918: select /*+ rule */ i.owner,
919: i.index_name table_name,
920: i.tablespace_name,
921: fnd_ts_mig_util.l_def_mv_tsp object_class,
922: i.table_name parent,
923: 'INDEX' object_type,
924: 'MVIEW' subobject_type,
925: 'NO' classified,

Line 943: fnd_ts_mig_util.l_def_mv_tsp object_class,

939: -- Indexes on MV Logs
940: select /*+ rule */ i.owner,
941: i.index_name table_name,
942: i.tablespace_name,
943: fnd_ts_mig_util.l_def_mv_tsp object_class,
944: i.table_name parent,
945: 'INDEX' object_type,
946: 'MV_LOG' subobject_type,
947: 'NO' classified,

Line 964: fnd_ts_mig_util.l_def_mv_tsp object_class,

960: -- Indexes on MV Logs with lobs
961: select /*+ rule */ i.owner,
962: i.index_name table_name,
963: i.tablespace_name,
964: fnd_ts_mig_util.l_def_mv_tsp object_class,
965: i.table_name parent,
966: 'INDEX' object_type,
967: 'MV_LOG' subobject_type,
968: 'NO' classified,

Line 985: fnd_ts_mig_util.l_aq_tab_tsp object_class,

981: -- Child AQ IOTs
982: SELECT /*+ rule */ d.owner,
983: d.index_name table_name,
984: d.tablespace_name,
985: fnd_ts_mig_util.l_aq_tab_tsp object_class,
986: -- fnd_ts_mig_util.l_def_tab_tsp object_class,
987: SUBSTR(d.table_name, 5, LENGTH(d.table_name)-6) parent,
988: 'INDEX' object_type,
989: 'AQ' subobject_type,

Line 986: -- fnd_ts_mig_util.l_def_tab_tsp object_class,

982: SELECT /*+ rule */ d.owner,
983: d.index_name table_name,
984: d.tablespace_name,
985: fnd_ts_mig_util.l_aq_tab_tsp object_class,
986: -- fnd_ts_mig_util.l_def_tab_tsp object_class,
987: SUBSTR(d.table_name, 5, LENGTH(d.table_name)-6) parent,
988: 'INDEX' object_type,
989: 'AQ' subobject_type,
990: 'NO' classified,

Line 1003: fnd_ts_mig_util.l_aq_tab_tsp object_class,

999: -- Indexes on Parent and Child AQ tables (including indexes on child IOTs)
1000: SELECT /*+ rule */ di.owner,
1001: di.index_name table_name,
1002: di.tablespace_name,
1003: fnd_ts_mig_util.l_aq_tab_tsp object_class,
1004: --fnd_ts_mig_util.l_def_ind_tsp object_class,
1005: di.table_name parent,
1006: 'INDEX' object_type,
1007: 'AQ' subobject_type,

Line 1004: --fnd_ts_mig_util.l_def_ind_tsp object_class,

1000: SELECT /*+ rule */ di.owner,
1001: di.index_name table_name,
1002: di.tablespace_name,
1003: fnd_ts_mig_util.l_aq_tab_tsp object_class,
1004: --fnd_ts_mig_util.l_def_ind_tsp object_class,
1005: di.table_name parent,
1006: 'INDEX' object_type,
1007: 'AQ' subobject_type,
1008: 'NO' classified,

Line 1026: fnd_ts_mig_util.l_aq_tab_tsp object_class,

1022: -- Indexes on Parent and Child AQ tables (including indexes on child IOTs with lob)
1023: SELECT /*+ rule */ di.owner,
1024: di.index_name table_name,
1025: di.tablespace_name,
1026: fnd_ts_mig_util.l_aq_tab_tsp object_class,
1027: --fnd_ts_mig_util.l_def_ind_tsp object_class,
1028: di.table_name parent,
1029: 'INDEX' object_type,
1030: 'AQ' subobject_type,

Line 1027: --fnd_ts_mig_util.l_def_ind_tsp object_class,

1023: SELECT /*+ rule */ di.owner,
1024: di.index_name table_name,
1025: di.tablespace_name,
1026: fnd_ts_mig_util.l_aq_tab_tsp object_class,
1027: --fnd_ts_mig_util.l_def_ind_tsp object_class,
1028: di.table_name parent,
1029: 'INDEX' object_type,
1030: 'AQ' subobject_type,
1031: 'NO' classified,

Line 1050: fnd_ts_mig_util.l_def_ind_tsp object_class,

1046: -- Child Domain Indexes IOTs
1047: SELECT /*+ rule */ d.owner,
1048: d.index_name table_name,
1049: d.tablespace_name,
1050: fnd_ts_mig_util.l_def_ind_tsp object_class,
1051: SUBSTR(d.table_name, 4, LENGTH(d.table_name)-5) parent,
1052: 'INDEX' object_type,
1053: 'DOMAIN' subobject_type,
1054: 'NO' classified,

Line 1067: fnd_ts_mig_util.l_def_ind_tsp object_class,

1063: -- Indexes on Child Domain Indexes tables including IOTs
1064: SELECT /*+ rule */ di.owner,
1065: di.index_name table_name,
1066: di.tablespace_name,
1067: fnd_ts_mig_util.l_def_ind_tsp object_class,
1068: di.table_name parent,
1069: 'INDEX' object_type,
1070: 'DOMAIN' subobject_type,
1071: 'NO' classified,

Line 1085: fnd_ts_mig_util.l_def_tab_tsp object_class,

1081: -- Indexes on Child Domain Indexes tables including IOTs with lob
1082: SELECT /*+ rule */ di.owner,
1083: di.index_name table_name,
1084: di.tablespace_name,
1085: fnd_ts_mig_util.l_def_tab_tsp object_class,
1086: di.table_name parent,
1087: 'INDEX' object_type,
1088: 'DOMAIN' subobject_type,
1089: 'NO' classified,

Line 1190: fnd_ts_mig_util.l_unclass_tsp object_class,

1186: -- MINUS IOT and IOT OVERFLOW TABLES
1187: SELECT /*+ rule */ dt.owner,
1188: dt.table_name,
1189: dt.tablespace_name,
1190: fnd_ts_mig_util.l_unclass_tsp object_class,
1191: 'table' parent,
1192: 'TABLE' object_type,
1193: 'TABLE' subobject_type,
1194: 'NO' classified,

Line 1236: fnd_ts_mig_util.l_def_mv_tsp object_class,

1232: -- MVIEW LOGS
1233: SELECT /*+ rule */ distinct dsl.log_owner,
1234: dsl.log_table table_name,
1235: dt.tablespace_name,
1236: fnd_ts_mig_util.l_def_mv_tsp object_class,
1237: dt.table_name parent,
1238: 'TABLE' object_type,
1239: 'MV_LOG' subobject_type,
1240: 'NO' classified,

Line 1256: fnd_ts_mig_util.l_def_mv_tsp object_class,

1252: -- MVIEWS
1253: SELECT /*+ rule */ ds.owner,
1254: ds.name table_name,
1255: dt.tablespace_name,
1256: fnd_ts_mig_util.l_def_mv_tsp object_class,
1257: dt.table_name parent,
1258: 'TABLE' object_type,
1259: 'MVIEW' subobject_type,
1260: 'NO' classified,

Line 1278: fnd_ts_mig_util.l_def_tab_tsp object_class,

1274: -- MINUS IOT START WITH 'DR$%' (Domain Index Tables IOT OVERFLOW)
1275: SELECT /*+ rule */ dt.owner,
1276: dt.table_name table_name,
1277: dt.tablespace_name,
1278: fnd_ts_mig_util.l_def_tab_tsp object_class,
1279: dt.iot_name parent,
1280: 'TABLE' object_type,
1281: 'IOT' subobject_type,
1282: 'NO' classified,

Line 1300: fnd_ts_mig_util.l_aq_tab_tsp object_class,

1296: -- IOT OVERFLOW FOR AQ TABLES
1297: SELECT /*+ rule */ dt.owner,
1298: dt.table_name table_name,
1299: dt.tablespace_name,
1300: fnd_ts_mig_util.l_aq_tab_tsp object_class,
1301: --fnd_ts_mig_util.l_def_tab_tsp object_class,
1302: dt.iot_name parent,
1303: 'TABLE' object_type,
1304: 'AQ' subobject_type,

Line 1301: --fnd_ts_mig_util.l_def_tab_tsp object_class,

1297: SELECT /*+ rule */ dt.owner,
1298: dt.table_name table_name,
1299: dt.tablespace_name,
1300: fnd_ts_mig_util.l_aq_tab_tsp object_class,
1301: --fnd_ts_mig_util.l_def_tab_tsp object_class,
1302: dt.iot_name parent,
1303: 'TABLE' object_type,
1304: 'AQ' subobject_type,
1305: 'NO' classified,

Line 1320: fnd_ts_mig_util.l_def_ind_tsp object_class,

1316: -- IOT OVERFLOW for Domain Indexes IOTs
1317: SELECT /*+ rule */ dt.owner,
1318: dt.table_name table_name,
1319: dt.tablespace_name,
1320: fnd_ts_mig_util.l_def_ind_tsp object_class,
1321: dt.iot_name parent,
1322: 'TABLE' object_type,
1323: 'DOMAIN' subobject_type,
1324: 'NO' classified,

Line 1369: fnd_ts_mig_util.l_unclass_tsp object_class,

1365: -- (no IOT, MVs, AQs, Domain Indexes)
1366: SELECT /*+ rule */ dl.owner,
1367: dl.segment_name table_name,
1368: dt.tablespace_name,
1369: fnd_ts_mig_util.l_unclass_tsp object_class,
1370: dl.table_name parent,
1371: 'LOB' object_type,
1372: 'TABLE' subobject_type,
1373: 'NO' classified,

Line 1418: fnd_ts_mig_util.l_def_tab_tsp object_class,

1414: -- Minus AQ and Domain Index
1415: SELECT /*+ rule */ dl.owner,
1416: dl.segment_name table_name,
1417: dt.tablespace_name,
1418: fnd_ts_mig_util.l_def_tab_tsp object_class,
1419: dl.table_name parent,
1420: 'LOB' object_type,
1421: 'IOT' subobject_type,
1422: 'NO' classified,

Line 1450: fnd_ts_mig_util.l_def_mv_tsp object_class,

1446: -- LOBs in MVs
1447: SELECT /*+ rule */ dl.owner,
1448: dl.segment_name table_name,
1449: dt.tablespace_name,
1450: fnd_ts_mig_util.l_def_mv_tsp object_class,
1451: dl.table_name parent,
1452: 'LOB' object_type,
1453: 'MVIEW' subobject_type,
1454: 'NO' classified,

Line 1475: fnd_ts_mig_util.l_aq_tab_tsp object_class,

1471: -- LOBS in AQs
1472: SELECT /*+ rule */ dl.owner,
1473: dl.segment_name table_name,
1474: dt.tablespace_name,
1475: fnd_ts_mig_util.l_aq_tab_tsp object_class,
1476: --fnd_ts_mig_util.l_def_tab_tsp object_class,
1477: dl.table_name parent,
1478: 'LOB' object_type,
1479: 'AQ' subobject_type,

Line 1476: --fnd_ts_mig_util.l_def_tab_tsp object_class,

1472: SELECT /*+ rule */ dl.owner,
1473: dl.segment_name table_name,
1474: dt.tablespace_name,
1475: fnd_ts_mig_util.l_aq_tab_tsp object_class,
1476: --fnd_ts_mig_util.l_def_tab_tsp object_class,
1477: dl.table_name parent,
1478: 'LOB' object_type,
1479: 'AQ' subobject_type,
1480: 'NO' classified,

Line 1502: fnd_ts_mig_util.l_def_ind_tsp object_class,

1498: -- LOBS in Domain Index Objects
1499: SELECT /*+ rule */ dl.owner,
1500: dl.segment_name table_name,
1501: dt.tablespace_name,
1502: fnd_ts_mig_util.l_def_ind_tsp object_class,
1503: dl.table_name parent,
1504: 'LOB' object_type,
1505: 'DOMAIN' subobject_type,
1506: 'NO' classified,

Line 1523: fnd_ts_mig_util.l_aq_tab_tsp object_class,

1519: -- Parent AQ tables
1520: SELECT /*+ rule */ dt.owner,
1521: dqt.queue_table table_name,
1522: dt.tablespace_name,
1523: fnd_ts_mig_util.l_aq_tab_tsp object_class,
1524: --fnd_ts_mig_util.l_def_tab_tsp object_class,
1525: 'table' parent,
1526: 'TABLE' object_type,
1527: 'AQ' subobject_type,

Line 1524: --fnd_ts_mig_util.l_def_tab_tsp object_class,

1520: SELECT /*+ rule */ dt.owner,
1521: dqt.queue_table table_name,
1522: dt.tablespace_name,
1523: fnd_ts_mig_util.l_aq_tab_tsp object_class,
1524: --fnd_ts_mig_util.l_def_tab_tsp object_class,
1525: 'table' parent,
1526: 'TABLE' object_type,
1527: 'AQ' subobject_type,
1528: 'NO' classified,

Line 1544: fnd_ts_mig_util.l_aq_tab_tsp object_class,

1540: -- Child AQ tables not IOTs
1541: SELECT /*+ rule */ dt.owner,
1542: dt.table_name table_name,
1543: dt.tablespace_name,
1544: fnd_ts_mig_util.l_aq_tab_tsp object_class,
1545: --fnd_ts_mig_util.l_def_tab_tsp object_class,
1546: SUBSTR(dt.table_name, 5, LENGTH(dt.table_name)-6) parent,
1547: 'TABLE' object_type,
1548: 'AQ' subobject_type,

Line 1545: --fnd_ts_mig_util.l_def_tab_tsp object_class,

1541: SELECT /*+ rule */ dt.owner,
1542: dt.table_name table_name,
1543: dt.tablespace_name,
1544: fnd_ts_mig_util.l_aq_tab_tsp object_class,
1545: --fnd_ts_mig_util.l_def_tab_tsp object_class,
1546: SUBSTR(dt.table_name, 5, LENGTH(dt.table_name)-6) parent,
1547: 'TABLE' object_type,
1548: 'AQ' subobject_type,
1549: 'NO' classified,

Line 1563: fnd_ts_mig_util.l_def_ind_tsp object_class,

1559: -- Domain Indexes tables not IOTs
1560: SELECT /*+ rule */ dt.owner owner,
1561: dt.table_name table_name,
1562: dt.tablespace_name,
1563: fnd_ts_mig_util.l_def_ind_tsp object_class,
1564: SUBSTR(dt.table_name, 4, LENGTH(dt.table_name)-5) parent,
1565: 'TABLE' object_type,
1566: 'DOMAIN' subobject_type,
1567: 'NO' classified,

Line 1665: decode(nvl(o.custom_tablespace_type, o.tablespace_type), fnd_ts_mig_util.l_def_tab_tsp, fnd_ts_mig_util.l_def_ind_tsp, o.tablespace_type) object_class,

1661: -- Indexes on Classified Tables
1662: SELECT /*+ rule */ i.owner,
1663: i.index_name table_name,
1664: i.tablespace_name,
1665: decode(nvl(o.custom_tablespace_type, o.tablespace_type), fnd_ts_mig_util.l_def_tab_tsp, fnd_ts_mig_util.l_def_ind_tsp, o.tablespace_type) object_class,
1666: i.table_name parent,
1667: 'INDEX' object_type,
1668: 'INDEX' subobject_type,
1669: 'YES' classified,

Line 1687: decode(nvl(o.custom_tablespace_type, o.tablespace_type), fnd_ts_mig_util.l_def_tab_tsp, fnd_ts_mig_util.l_def_tab_tsp, o.tablespace_type) object_class,

1683: -- Indexes on Classified Tables with lob
1684: SELECT /*+ rule */ i.owner,
1685: i.index_name table_name,
1686: i.tablespace_name,
1687: decode(nvl(o.custom_tablespace_type, o.tablespace_type), fnd_ts_mig_util.l_def_tab_tsp, fnd_ts_mig_util.l_def_tab_tsp, o.tablespace_type) object_class,
1688: i.table_name parent,
1689: 'INDEX' object_type,
1690: 'INDEX' subobject_type,
1691: 'YES' classified,

Line 1710: fnd_ts_mig_util.l_unclass_ind_tsp object_class,

1706: -- (no IOTs, MVs, MV Logs, AQs, Domain Indexes)
1707: SELECT /*+ rule */ i.owner,
1708: i.index_name table_name,
1709: i.tablespace_name,
1710: fnd_ts_mig_util.l_unclass_ind_tsp object_class,
1711: i.table_name parent,
1712: 'INDEX' object_type,
1713: 'INDEX' subobject_type,
1714: 'NO' classified,

Line 1757: fnd_ts_mig_util.l_unclass_tsp object_class,

1753: -- (no IOTs, MVs, MV Logs, AQs, Domain Indexes)
1754: SELECT /*+ rule */ i.owner,
1755: i.index_name table_name,
1756: i.tablespace_name,
1757: fnd_ts_mig_util.l_unclass_tsp object_class,
1758: i.table_name parent,
1759: 'INDEX' object_type,
1760: 'INDEX' subobject_type,
1761: 'NO' classified,

Line 1804: fnd_ts_mig_util.l_def_tab_tsp object_class,

1800: -- Minus Domain Indexes IOTs
1801: SELECT /*+ rule */ d.owner,
1802: d.index_name table_name,
1803: d.tablespace_name,
1804: fnd_ts_mig_util.l_def_tab_tsp object_class,
1805: d.table_name parent,
1806: 'INDEX' object_type,
1807: 'IOT' subobject_type,
1808: 'NO' classified,

Line 1825: fnd_ts_mig_util.l_def_ind_tsp object_class,

1821: -- Minus Indexes on AQ IOTs and Domain Index IOTs
1822: SELECT /*+ rule */ i.owner,
1823: i.index_name table_name,
1824: i.tablespace_name,
1825: fnd_ts_mig_util.l_def_ind_tsp object_class,
1826: i.table_name parent,
1827: 'INDEX' object_type,
1828: 'IOT' subobject_type,
1829: 'NO' classified,

Line 1857: fnd_ts_mig_util.l_def_tab_tsp object_class,

1853: -- Minus Indexes on AQ IOTs and Domain Index IOTs
1854: SELECT /*+ rule */ i.owner,
1855: i.index_name table_name,
1856: i.tablespace_name,
1857: fnd_ts_mig_util.l_def_tab_tsp object_class,
1858: i.table_name parent,
1859: 'INDEX' object_type,
1860: 'IOT' subobject_type,
1861: 'NO' classified,

Line 1887: fnd_ts_mig_util.l_def_mv_tsp object_class,

1883: -- Indexes on MVs
1884: select /*+ rule */ i.owner,
1885: i.index_name table_name,
1886: i.tablespace_name,
1887: fnd_ts_mig_util.l_def_mv_tsp object_class,
1888: i.table_name parent,
1889: 'INDEX' object_type,
1890: 'MVIEW' subobject_type,
1891: 'NO' classified,

Line 1910: fnd_ts_mig_util.l_def_mv_tsp object_class,

1906: -- Indexes on MVs with lob
1907: select /*+ rule */ i.owner,
1908: i.index_name table_name,
1909: i.tablespace_name,
1910: fnd_ts_mig_util.l_def_mv_tsp object_class,
1911: i.table_name parent,
1912: 'INDEX' object_type,
1913: 'MVIEW' subobject_type,
1914: 'NO' classified,

Line 1934: fnd_ts_mig_util.l_def_mv_tsp object_class,

1930: -- Indexes on MV Logs
1931: select /*+ rule */ i.owner,
1932: i.index_name table_name,
1933: i.tablespace_name,
1934: fnd_ts_mig_util.l_def_mv_tsp object_class,
1935: i.table_name parent,
1936: 'INDEX' object_type,
1937: 'MV_LOG' subobject_type,
1938: 'NO' classified,

Line 1958: fnd_ts_mig_util.l_def_mv_tsp object_class,

1954: -- Indexes on MV Logs with lob
1955: select /*+ rule */ i.owner,
1956: i.index_name table_name,
1957: i.tablespace_name,
1958: fnd_ts_mig_util.l_def_mv_tsp object_class,
1959: i.table_name parent,
1960: 'INDEX' object_type,
1961: 'MV_LOG' subobject_type,
1962: 'NO' classified,

Line 1981: fnd_ts_mig_util.l_aq_tab_tsp object_class,

1977: -- Child AQ IOTs
1978: SELECT /*+ rule */ d.owner,
1979: d.index_name table_name,
1980: d.tablespace_name,
1981: fnd_ts_mig_util.l_aq_tab_tsp object_class,
1982: -- fnd_ts_mig_util.l_def_tab_tsp object_class,
1983: SUBSTR(d.table_name, 5, LENGTH(d.table_name)-6) parent,
1984: 'INDEX' object_type,
1985: 'AQ' subobject_type,

Line 1982: -- fnd_ts_mig_util.l_def_tab_tsp object_class,

1978: SELECT /*+ rule */ d.owner,
1979: d.index_name table_name,
1980: d.tablespace_name,
1981: fnd_ts_mig_util.l_aq_tab_tsp object_class,
1982: -- fnd_ts_mig_util.l_def_tab_tsp object_class,
1983: SUBSTR(d.table_name, 5, LENGTH(d.table_name)-6) parent,
1984: 'INDEX' object_type,
1985: 'AQ' subobject_type,
1986: 'NO' classified,

Line 2000: fnd_ts_mig_util.l_aq_tab_tsp object_class,

1996: -- Indexes on Parent and Child AQ tables (including indexes on child IOTs)
1997: SELECT /*+ rule */ di.owner,
1998: di.index_name table_name,
1999: di.tablespace_name,
2000: fnd_ts_mig_util.l_aq_tab_tsp object_class,
2001: --fnd_ts_mig_util.l_def_ind_tsp object_class,
2002: di.table_name parent,
2003: 'INDEX' object_type,
2004: 'AQ' subobject_type,

Line 2001: --fnd_ts_mig_util.l_def_ind_tsp object_class,

1997: SELECT /*+ rule */ di.owner,
1998: di.index_name table_name,
1999: di.tablespace_name,
2000: fnd_ts_mig_util.l_aq_tab_tsp object_class,
2001: --fnd_ts_mig_util.l_def_ind_tsp object_class,
2002: di.table_name parent,
2003: 'INDEX' object_type,
2004: 'AQ' subobject_type,
2005: 'NO' classified,

Line 2026: fnd_ts_mig_util.l_aq_tab_tsp object_class,

2022: -- Indexes on Parent and Child AQ tables (including indexes on child IOTs with lob)
2023: SELECT /*+ rule */ di.owner,
2024: di.index_name table_name,
2025: di.tablespace_name,
2026: fnd_ts_mig_util.l_aq_tab_tsp object_class,
2027: --fnd_ts_mig_util.l_def_ind_tsp object_class,
2028: di.table_name parent,
2029: 'INDEX' object_type,
2030: 'AQ' subobject_type,

Line 2027: --fnd_ts_mig_util.l_def_ind_tsp object_class,

2023: SELECT /*+ rule */ di.owner,
2024: di.index_name table_name,
2025: di.tablespace_name,
2026: fnd_ts_mig_util.l_aq_tab_tsp object_class,
2027: --fnd_ts_mig_util.l_def_ind_tsp object_class,
2028: di.table_name parent,
2029: 'INDEX' object_type,
2030: 'AQ' subobject_type,
2031: 'NO' classified,

Line 2051: fnd_ts_mig_util.l_def_ind_tsp object_class,

2047: -- Child Domain Indexes IOTs
2048: SELECT /*+ rule */ d.owner,
2049: d.index_name table_name,
2050: d.tablespace_name,
2051: fnd_ts_mig_util.l_def_ind_tsp object_class,
2052: SUBSTR(d.table_name, 4, LENGTH(d.table_name)-5) parent,
2053: 'INDEX' object_type,
2054: 'DOMAIN' subobject_type,
2055: 'NO' classified,

Line 2070: fnd_ts_mig_util.l_def_ind_tsp object_class,

2066: -- Indexes on Child Domain Indexes tables including IOTs
2067: SELECT /*+ rule */ di.owner,
2068: di.index_name table_name,
2069: di.tablespace_name,
2070: fnd_ts_mig_util.l_def_ind_tsp object_class,
2071: di.table_name parent,
2072: 'INDEX' object_type,
2073: 'DOMAIN' subobject_type,
2074: 'NO' classified,

Line 2089: fnd_ts_mig_util.l_def_tab_tsp object_class,

2085: -- Indexes on Child Domain Indexes tables including IOTs wit lob
2086: SELECT /*+ rule */ di.owner,
2087: di.index_name table_name,
2088: di.tablespace_name,
2089: fnd_ts_mig_util.l_def_tab_tsp object_class,
2090: di.table_name parent,
2091: 'INDEX' object_type,
2092: 'DOMAIN' subobject_type,
2093: 'NO' classified,