APPS.MSC_GET_BIS_VALUES dependencies on MSC_LATE_ORDER_MV_TAB

Line 820: ' FROM msc_late_order_mv_tab mbis' ||

816: arg_category_name is null and
817: arg_product_family_id is null then
818:
819: sql_statement := ' SELECT sum(mbis.late_order_count) ' ||
820: ' FROM msc_late_order_mv_tab mbis' ||
821: ' WHERE mbis.plan_id = :1 ';
822: else
823: sql_statement := ' SELECT count(distinct mbis.number1) ' ||
824: ' FROM msc_exception_details mbis' ||

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

3099: organization_id,
3100: sr_instance_id;
3101:
3102: elsif p_kpi_table = 4 then
3103: MSC_UTIL.MSC_DEBUG('refreshing MSC_LATE_ORDER_MV_TAB table for plan id '||p_plan_id);
3104: delete from msc_late_order_mv_tab
3105: where plan_id = p_plan_id;
3106:
3107: insert into msc_late_order_mv_tab(

Line 3104: delete from msc_late_order_mv_tab

3100: sr_instance_id;
3101:
3102: elsif p_kpi_table = 4 then
3103: MSC_UTIL.MSC_DEBUG('refreshing MSC_LATE_ORDER_MV_TAB table for plan id '||p_plan_id);
3104: delete from msc_late_order_mv_tab
3105: where plan_id = p_plan_id;
3106:
3107: insert into msc_late_order_mv_tab(
3108: LAST_UPDATE_DATE,

Line 3107: insert into msc_late_order_mv_tab(

3103: MSC_UTIL.MSC_DEBUG('refreshing MSC_LATE_ORDER_MV_TAB table for plan id '||p_plan_id);
3104: delete from msc_late_order_mv_tab
3105: where plan_id = p_plan_id;
3106:
3107: insert into msc_late_order_mv_tab(
3108: LAST_UPDATE_DATE,
3109: LAST_UPDATED_BY,
3110: CREATION_DATE,
3111: CREATED_BY,