DBA Data[Home] [Help]

APPS.JTY_TAE_INDEX_CREATION_PVT dependencies on DBA_TAB_COLUMNS

Line 188: FROM dba_tab_columns dtc

184: IF flag(i) = 1 THEN
185: BEGIN
186: SELECT 100 - (NVL(dtc.num_distinct,1)*100/v_cardinality)
187: INTO o_sel(i)
188: FROM dba_tab_columns dtc
189: WHERE dtc.owner = l_jtf_schema
190: AND dtc.table_name = UPPER(p_table_name)
191: AND dtc.column_name = UPPER(v_colname(i));
192: EXCEPTION