APPS.MSC_GET_BIS_VALUES dependencies on MSC_BIS_INV_CAT_MV_TAB

Line 991: ' FROM msc_bis_inv_cat_mv_tab mbis' ||

987: v_cat_name := null;
988: end if;
989: sql_statement := ' SELECT '||
990: ' SUM(nvl(mbis.mds_cost,0)) '||
991: ' FROM msc_bis_inv_cat_mv_tab mbis' ||
992: ' WHERE mbis.plan_id = :1 ';
993: sql_statement := sql_statement ||
994: construct_bis_where(false,p_organization_id, p_instance_id,
995: p_inventory_item_id, p_project_id, p_task_id,

Line 1045: ' FROM msc_bis_inv_cat_mv_tab mbis ' ||

1041: p_product_family_id);
1042: else
1043: sql_statement := ' SELECT '||
1044: ' SUM(nvl(mbis.inventory_cost,0)) '||
1045: ' FROM msc_bis_inv_cat_mv_tab mbis ' ||
1046: ' WHERE mbis.plan_id = :1 '||
1047: ' AND mbis.detail_date = :7 ';
1048: if p_category_name is not null then
1049: v_cat_name := '-1:'||p_category_name;

Line 2065: -- come from msc_bis_inv_cat_mv_tab

2061: end if;
2062:
2063: if p_category_name is not null then
2064: if subStr(p_category_name,1,3) = '-1:' then
2065: -- come from msc_bis_inv_cat_mv_tab
2066: where_stat := where_stat ||
2067: ' and -1 = :9 '||
2068: ' and mbis.category_set_id = :10 ' ||
2069: ' and mbis.category_name = :11 ';

Line 2089: if p_category_id < 0 then -- come from msc_bis_inv_cat_mv_tab

2085: end if;
2086: g_category_set_id := p_category_set_id;
2087:
2088: elsif p_category_id is not null then
2089: if p_category_id < 0 then -- come from msc_bis_inv_cat_mv_tab
2090: where_stat := where_stat ||
2091: ' and mbis.sr_category_id = :9 '||
2092: ' and mbis.category_set_id = :10 '||
2093: ' and ''-1'' = :11 ';

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

2995: sr_instance_id,
2996: detail_date;
2997: end if; -- if p_plan_type =
2998: elsif p_kpi_table =2 then
2999: MSC_UTIL.MSC_DEBUG('refreshing MSC_BIS_INV_CAT_MV_TAB table for plan id '||p_plan_id);
3000: delete from msc_bis_inv_cat_mv_tab
3001: where plan_id = p_plan_id;
3002:
3003: insert into msc_bis_inv_cat_mv_tab(

Line 3000: delete from msc_bis_inv_cat_mv_tab

2996: detail_date;
2997: end if; -- if p_plan_type =
2998: elsif p_kpi_table =2 then
2999: MSC_UTIL.MSC_DEBUG('refreshing MSC_BIS_INV_CAT_MV_TAB table for plan id '||p_plan_id);
3000: delete from msc_bis_inv_cat_mv_tab
3001: where plan_id = p_plan_id;
3002:
3003: insert into msc_bis_inv_cat_mv_tab(
3004: LAST_UPDATE_DATE,

Line 3003: insert into msc_bis_inv_cat_mv_tab(

2999: MSC_UTIL.MSC_DEBUG('refreshing MSC_BIS_INV_CAT_MV_TAB table for plan id '||p_plan_id);
3000: delete from msc_bis_inv_cat_mv_tab
3001: where plan_id = p_plan_id;
3002:
3003: insert into msc_bis_inv_cat_mv_tab(
3004: LAST_UPDATE_DATE,
3005: LAST_UPDATED_BY,
3006: CREATION_DATE,
3007: CREATED_BY,