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 2076: -- come from msc_bis_inv_cat_mv_tab

2072: end if;
2073:
2074: if p_category_name is not null then
2075: if subStr(p_category_name,1,3) = '-1:' then
2076: -- come from msc_bis_inv_cat_mv_tab
2077: where_stat := where_stat ||
2078: ' and -1 = :9 '||
2079: ' and mbis.category_set_id = :10 ' ||
2080: ' and mbis.category_name = :11 ';

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

2096: end if;
2097: g_category_set_id := p_category_set_id;
2098:
2099: elsif p_category_id is not null then
2100: if p_category_id < 0 then -- come from msc_bis_inv_cat_mv_tab
2101: where_stat := where_stat ||
2102: ' and mbis.sr_category_id = :9 '||
2103: ' and mbis.category_set_id = :10 '||
2104: ' and ''-1'' = :11 ';

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

3006: sr_instance_id,
3007: detail_date;
3008: end if; -- if p_plan_type =
3009: elsif p_kpi_table =2 then
3010: MSC_UTIL.MSC_DEBUG('refreshing MSC_BIS_INV_CAT_MV_TAB table for plan id '||p_plan_id);
3011: delete from msc_bis_inv_cat_mv_tab
3012: where plan_id = p_plan_id;
3013:
3014: insert into msc_bis_inv_cat_mv_tab(

Line 3011: delete from msc_bis_inv_cat_mv_tab

3007: detail_date;
3008: end if; -- if p_plan_type =
3009: elsif p_kpi_table =2 then
3010: MSC_UTIL.MSC_DEBUG('refreshing MSC_BIS_INV_CAT_MV_TAB table for plan id '||p_plan_id);
3011: delete from msc_bis_inv_cat_mv_tab
3012: where plan_id = p_plan_id;
3013:
3014: insert into msc_bis_inv_cat_mv_tab(
3015: LAST_UPDATE_DATE,

Line 3014: insert into msc_bis_inv_cat_mv_tab(

3010: MSC_UTIL.MSC_DEBUG('refreshing MSC_BIS_INV_CAT_MV_TAB table for plan id '||p_plan_id);
3011: delete from msc_bis_inv_cat_mv_tab
3012: where plan_id = p_plan_id;
3013:
3014: insert into msc_bis_inv_cat_mv_tab(
3015: LAST_UPDATE_DATE,
3016: LAST_UPDATED_BY,
3017: CREATION_DATE,
3018: CREATED_BY,