APPS.CSF_SPATIAL_DATALOAD_PVT dependencies on CSF_SPATIAL_INDEX_STAT_M

Line 185: FROM CSF_SPATIAL_INDEX_STAT_M

181: CURSOR CSF_GET_SPATIAL_INDEXES (p_index_type in VARCHAR2)
182: IS
183: SELECT INDEX_NAME,
184: table_name
185: FROM CSF_SPATIAL_INDEX_STAT_M
186: WHERE index_type = p_index_type AND index_type<>'MAT';
187:
188: l_index_name VARCHAR2(100);
189: l_applsys_schema VARCHAR2(10);

Line 657: FROM CSF_SPATIAL_INDEX_STAT_M

653:
654: CURSOR CSF_GET_SPATIAL_INDEXES (p_index_type in VARCHAR2)
655: IS
656: SELECT INDEX_NAME
657: FROM CSF_SPATIAL_INDEX_STAT_M
658: WHERE index_type = p_index_type AND index_type<>'MAT';
659:
660: l_index_name VARCHAR2(100);
661: l_status VARCHAR2(20);

Line 761: FROM CSF_SPATIAL_INDEX_STAT_M

757:
758: CURSOR CSF_GET_SPATIAL_INDEXES (p_index_type in VARCHAR2)
759: IS
760: SELECT INDEX_NAME
761: FROM CSF_SPATIAL_INDEX_STAT_M
762: WHERE index_type = p_index_type AND index_type<>'MAT';
763:
764: l_index_name VARCHAR2(100);
765: l_index_name_temp VARCHAR2(100);

Line 865: FROM CSF_SPATIAL_INDEX_STAT_M

861: SELECT INDEX_NAME,
862: table_name ,
863: index_columns,
864: index_create_sql
865: FROM CSF_SPATIAL_INDEX_STAT_M
866: WHERE index_type = p_index_type AND index_type<>'MAT';
867:
868: l_index_name VARCHAR2(100);
869: l_applsys_schema VARCHAR2(10);

Line 1006: FROM CSF_SPATIAL_INDEX_STAT_M where INDEX_NAME = p_index_name;

1002: INTO l_table,
1003: l_columns_str,
1004: l_create_sql,
1005: l_index_type
1006: FROM CSF_SPATIAL_INDEX_STAT_M where INDEX_NAME = p_index_name;
1007:
1008: -- Checking indexes in APPS schema as the Materialized views
1009: -- are created as part of APPS schema.
1010: IF l_index_type = 'MAT' THEN