APPS.MSC_GET_BIS_VALUES dependencies on MSC_BIS_INV_DATE_MV_TAB

Line 148: FROM msc_bis_inv_date_mv_tab

144: sum(nvl(production_cost,0)),
145: sum(nvl(purchasing_cost,0)),
146: sum(nvl(demand_penalty_cost,0)),
147: sum(nvl(carrying_cost,0))
148: FROM msc_bis_inv_date_mv_tab
149: WHERE organization_id = l_org_id
150: AND sr_instance_id = l_instance_id
151: AND plan_id = l_plan_id;
152:

Line 159: FROM msc_bis_inv_date_mv_tab

155: sum(nvl(production_cost,0)),
156: sum(nvl(purchasing_cost,0)),
157: sum(nvl(demand_penalty_cost,0)),
158: sum(nvl(carrying_cost,0))
159: FROM msc_bis_inv_date_mv_tab
160: WHERE plan_id = l_plan_id;
161:
162: CURSOR MARGIN_ORG_DATE_CURSOR(v_plan_id number,
163: v_org_id number,

Line 172: FROM msc_bis_inv_date_mv_tab

168: sum(nvl(production_cost,0)),
169: sum(nvl(purchasing_cost,0)),
170: sum(nvl(demand_penalty_cost,0)),
171: sum(nvl(carrying_cost,0))
172: FROM msc_bis_inv_date_mv_tab
173: WHERE organization_id = v_org_id
174: AND sr_instance_id = v_instance_id
175: and detail_date between v_start_date and v_end_date
176: AND plan_id = v_plan_id;

Line 186: FROM msc_bis_inv_date_mv_tab

182: sum(nvl(production_cost,0)),
183: sum(nvl(purchasing_cost,0)),
184: sum(nvl(demand_penalty_cost,0)),
185: sum(nvl(carrying_cost,0))
186: FROM msc_bis_inv_date_mv_tab
187: WHERE detail_date between v_start_date and v_end_date
188: AND plan_id = v_plan_id;
189:
190: CURSOR INV_VAL_CURSOR(v_plan_id number,

Line 976: ' FROM msc_bis_inv_date_mv_tab mbis' ||

972:
973: if p_category_id is null and p_category_name is null then
974: sql_statement := ' SELECT '||
975: ' SUM(nvl(mbis.mds_cost,0)) '||
976: ' FROM msc_bis_inv_date_mv_tab mbis' ||
977: ' WHERE mbis.plan_id = :1 ';
978: sql_statement := sql_statement ||
979: construct_bis_where(false,p_organization_id, p_instance_id,
980: p_inventory_item_id, p_project_id, p_task_id,

Line 1034: ' FROM msc_bis_inv_date_mv_tab mbis ' ||

1030:
1031: if p_category_id is null and p_category_name is null then
1032: sql_statement := ' SELECT '||
1033: ' SUM(nvl(mbis.inventory_cost,0)) '||
1034: ' FROM msc_bis_inv_date_mv_tab mbis ' ||
1035: ' WHERE mbis.plan_id = :1 '||
1036: ' AND mbis.detail_date = :7 ';
1037: sql_statement := sql_statement ||
1038: construct_bis_where(false,p_organization_id, p_instance_id,

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

2902: p_plan_type number) IS
2903: BEGIN
2904: if p_kpi_table =1 then
2905:
2906: MSC_UTIL.MSC_DEBUG('refreshing MSC_BIS_INV_DATE_MV_TAB table for plan id '||p_plan_id);
2907:
2908: delete from msc_bis_inv_date_mv_tab
2909: where plan_id = p_plan_id;
2910: if p_plan_type = 8 then -- should change to srp

Line 2908: delete from msc_bis_inv_date_mv_tab

2904: if p_kpi_table =1 then
2905:
2906: MSC_UTIL.MSC_DEBUG('refreshing MSC_BIS_INV_DATE_MV_TAB table for plan id '||p_plan_id);
2907:
2908: delete from msc_bis_inv_date_mv_tab
2909: where plan_id = p_plan_id;
2910: if p_plan_type = 8 then -- should change to srp
2911:
2912: insert into msc_bis_inv_date_mv_tab(

Line 2912: insert into msc_bis_inv_date_mv_tab(

2908: delete from msc_bis_inv_date_mv_tab
2909: where plan_id = p_plan_id;
2910: if p_plan_type = 8 then -- should change to srp
2911:
2912: insert into msc_bis_inv_date_mv_tab(
2913: LAST_UPDATE_DATE,
2914: LAST_UPDATED_BY,
2915: CREATION_DATE,
2916: CREATED_BY,

Line 2966: insert into msc_bis_inv_date_mv_tab(

2962: mbid.detail_date,
2963: msi.planner_code;
2964:
2965: else
2966: insert into msc_bis_inv_date_mv_tab(
2967: LAST_UPDATE_DATE,
2968: LAST_UPDATED_BY,
2969: CREATION_DATE,
2970: CREATED_BY,