APPS.MSC_GET_BIS_VALUES dependencies on MSC_SYSTEM_ITEMS

Line 2410: ' msc_system_items msi, '||

2406: sql_stat := ' select round(sum(nvl(((ms.new_order_quantity * '||
2407: ' msi.unit_weight) '||
2408: ' * mism.cost_per_weight_unit),0)),6) '||
2409: ' from msc_supplies ms, '||
2410: ' msc_system_items msi, '||
2411: ' msc_item_categories mic, '||
2412: ' msc_interorg_ship_methods mism '|| where_stat;
2413: if ( not(from_plan_node) ) then
2414: OPEN the_cursor FOR sql_stat USING p_plan_id,v_org_id,

Line 2631: FROM msc_system_items

2627: AND sr_tp_id=p_org_id;
2628:
2629: CURSOR item_target IS
2630: SELECT service_level
2631: FROM msc_system_items
2632: WHERE plan_id = p_plan
2633: AND sr_instance_id = p_instance_id
2634: AND organization_id= p_org_id
2635: AND inventory_item_id = p_item_id;

Line 2941: msc_system_items msi

2937: mbid.detail_date,
2938: sum(nvl(mbid.inventory_value,0)),
2939: msi.planner_code
2940: from msc_bis_inv_detail mbid,
2941: msc_system_items msi
2942: where mbid.plan_id = p_plan_id
2943: and nvl(mbid.period_type,0) = 0
2944: and mbid.organization_id = msi.organization_id
2945: and mbid.sr_instance_id = msi.sr_instance_id