APPS.MSC_CL_DEMAND_ODS_LOAD dependencies on MSC_ANALYSE_TABLES_PK

Line 477: msc_analyse_tables_pk.analyse_table( 'SALES_ORDERS_'||MSC_CL_COLLECTION.v_instance_code, MSC_CL_COLLECTION.v_instance_id, -1);

473: ||' PARALLEL ' || MSC_CL_COLLECTION.G_DEG_PARALLEL
474: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
475: object_name => 'SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code);
476:
477: msc_analyse_tables_pk.analyse_table( 'SALES_ORDERS_'||MSC_CL_COLLECTION.v_instance_code, MSC_CL_COLLECTION.v_instance_id, -1);
478:
479: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code||' created.');
480: ELSE
481: lv_tbl:= 'MSC_SALES_ORDERS';

Line 591: msc_analyse_tables_pk.analyse_table( 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code, MSC_CL_COLLECTION.v_instance_id, -1);

587: ||' PARALLEL ' || MSC_CL_COLLECTION.G_DEG_PARALLEL
588: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
589: object_name => 'demands_nx_'||MSC_CL_COLLECTION.v_instance_code);
590:
591: msc_analyse_tables_pk.analyse_table( 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code, MSC_CL_COLLECTION.v_instance_id, -1);
592:
593: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index DEMANDS_NX_'||MSC_CL_COLLECTION.v_instance_code||' created.');
594: ELSE
595: lv_tbl:= 'MSC_DEMANDS';