APPS.MSC_CL_ITEM_ODS_LOAD dependencies on DBA_TAB_STATISTICS

Line 1537: from dba_TAB_STATISTICS

1533:
1534: begin
1535: select num_rows,decode (stale_stats,'NO', MSC_UTIL.SYS_NO, MSC_UTIL.SYS_YES )
1536: into lv_item_id_count, lv_items_stat_stale
1537: from dba_TAB_STATISTICS
1538: where table_name = 'MSC_ITEM_ID_LID';
1539: exception when no_data_found then
1540: lv_items_stat_stale := MSC_UTIL.SYS_YES ;
1541: end;

Line 1546: from dba_TAB_STATISTICS

1542:
1543: begin
1544: select num_rows,decode (stale_stats,'NO', MSC_UTIL.SYS_NO, MSC_UTIL.SYS_YES )
1545: into lv_cat_id_count, lv_cat_stat_stale
1546: from dba_TAB_STATISTICS
1547: where table_name ='MSC_CATEGORY_SET_ID_LID';
1548: exception when no_data_found then
1549: lv_cat_stat_stale := MSC_UTIL.SYS_YES ;
1550: end;