APPS.MSC_GET_BIS_VALUES dependencies on MSC_DEMAND_MV_TAB

Line 1125: ' FROM msc_demand_mv_tab mbis'||

1121: p_product_family_id is null then
1122:
1123: -- refer to the materialized view directly
1124: sql_statement := ' SELECT sum(demand_count) '||
1125: ' FROM msc_demand_mv_tab mbis'||
1126: ' WHERE mbis.plan_id = :1 ';
1127: else
1128: sql_statement := ' SELECT count(*) '||
1129: ' FROM msc_demands_mv_v mbis'||

Line 3071: MSC_UTIL.MSC_DEBUG('refreshing MSC_DEMAND_MV_TAB table for plan id '||p_plan_id);

3067: mit.category_set_id,
3068: mbis.detail_date;
3069:
3070: elsif p_kpi_table = 3 then
3071: MSC_UTIL.MSC_DEBUG('refreshing MSC_DEMAND_MV_TAB table for plan id '||p_plan_id);
3072: delete from msc_demand_mv_tab
3073: where plan_id = p_plan_id;
3074:
3075: insert into msc_demand_mv_tab(

Line 3072: delete from msc_demand_mv_tab

3068: mbis.detail_date;
3069:
3070: elsif p_kpi_table = 3 then
3071: MSC_UTIL.MSC_DEBUG('refreshing MSC_DEMAND_MV_TAB table for plan id '||p_plan_id);
3072: delete from msc_demand_mv_tab
3073: where plan_id = p_plan_id;
3074:
3075: insert into msc_demand_mv_tab(
3076: LAST_UPDATE_DATE,

Line 3075: insert into msc_demand_mv_tab(

3071: MSC_UTIL.MSC_DEBUG('refreshing MSC_DEMAND_MV_TAB table for plan id '||p_plan_id);
3072: delete from msc_demand_mv_tab
3073: where plan_id = p_plan_id;
3074:
3075: insert into msc_demand_mv_tab(
3076: LAST_UPDATE_DATE,
3077: LAST_UPDATED_BY,
3078: CREATION_DATE,
3079: CREATED_BY,