APPS.MSC_GET_BIS_VALUES dependencies on MSC_SYSTEM_ITEMS

Line 2421: ' msc_system_items msi, '||

2417: sql_stat := ' select round(sum(nvl(((ms.new_order_quantity * '||
2418: ' msi.unit_weight) '||
2419: ' * mism.cost_per_weight_unit),0)),6) '||
2420: ' from msc_supplies ms, '||
2421: ' msc_system_items msi, '||
2422: ' msc_item_categories mic, '||
2423: ' msc_interorg_ship_methods mism '|| where_stat;
2424: if ( not(from_plan_node) ) then
2425: OPEN the_cursor FOR sql_stat USING p_plan_id,v_org_id,

Line 2642: FROM msc_system_items

2638: AND sr_tp_id=p_org_id;
2639:
2640: CURSOR item_target IS
2641: SELECT service_level
2642: FROM msc_system_items
2643: WHERE plan_id = p_plan
2644: AND sr_instance_id = p_instance_id
2645: AND organization_id= p_org_id
2646: AND inventory_item_id = p_item_id;

Line 2952: msc_system_items msi

2948: mbid.detail_date,
2949: sum(nvl(mbid.inventory_value,0)),
2950: msi.planner_code
2951: from msc_bis_inv_detail mbid,
2952: msc_system_items msi
2953: where mbid.plan_id = p_plan_id
2954: and nvl(mbid.period_type,0) = 0
2955: and mbid.organization_id = msi.organization_id
2956: and mbid.sr_instance_id = msi.sr_instance_id