APPS.MSC_CL_DEMAND_ODS_LOAD dependencies on MSC_ANALYSE_TABLES_PK

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

425: ||' PARALLEL ' || MSC_CL_COLLECTION.G_DEG_PARALLEL
426: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
427: object_name => 'SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code);
428:
429: msc_analyse_tables_pk.analyse_table( 'SALES_ORDERS_'||MSC_CL_COLLECTION.v_instance_code, MSC_CL_COLLECTION.v_instance_id, -1);
430:
431: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code||' created.');
432: ELSE
433: lv_tbl:= 'MSC_SALES_ORDERS';

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

539: ||' PARALLEL ' || MSC_CL_COLLECTION.G_DEG_PARALLEL
540: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
541: object_name => 'demands_nx_'||MSC_CL_COLLECTION.v_instance_code);
542:
543: msc_analyse_tables_pk.analyse_table( 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code, MSC_CL_COLLECTION.v_instance_id, -1);
544:
545: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index DEMANDS_NX_'||MSC_CL_COLLECTION.v_instance_code||' created.');
546: ELSE
547: lv_tbl:= 'MSC_DEMANDS';