APPS.MSC_GET_BIS_VALUES dependencies on MSC_ITEM_CATEGORIES

Line 2087: ' from msc_item_categories mit ' ||

2083: else
2084: where_stat := where_stat ||
2085: ' AND EXISTS '||
2086: ' (select 1 '||
2087: ' from msc_item_categories mit ' ||
2088: ' where mit.organization_id = mbis.organization_id '||
2089: ' and mit.sr_instance_id = mbis.sr_instance_id '||
2090: ' and mit.inventory_item_id = mbis.inventory_item_id '||
2091: ' and -1 = :9 '||

Line 2111: ' from msc_item_categories mit ' ||

2107: else
2108: where_stat := where_stat ||
2109: ' AND EXISTS '||
2110: ' (select 1 '||
2111: ' from msc_item_categories mit ' ||
2112: ' where mit.organization_id = mbis.organization_id '||
2113: ' and mit.sr_instance_id = mbis.sr_instance_id '||
2114: ' and mit.inventory_item_id = mbis.inventory_item_id '||
2115: ' and mit.sr_category_id = :9 '||

Line 2271: ' msc_item_categories mic ' ||

2267: if v_plan_type <> 4 then
2268: sql_stat := 'SELECT sum(nvl(md.quantity_by_due_date,0)*nvl(md.probability,1)), '||
2269: ' sum(md.USING_REQUIREMENT_QUANTITY*nvl(md.probability,1)) ' ||
2270: ' FROM msc_demands md, ' ||
2271: ' msc_item_categories mic ' ||
2272: where_stat;
2273: --elsif (p_use_old_demand_qty = -1) then
2274: elsif v_plan_type = 4 then
2275: sql_stat := 'SELECT sum(nvl(md.old_demand_quantity,0)*nvl(md.probability,1)), '||

Line 2278: ' msc_item_categories mic ' ||

2274: elsif v_plan_type = 4 then
2275: sql_stat := 'SELECT sum(nvl(md.old_demand_quantity,0)*nvl(md.probability,1)), '||
2276: ' sum(md.USING_REQUIREMENT_QUANTITY*nvl(md.probability,1)) ' ||
2277: ' FROM msc_demands md, ' ||
2278: ' msc_item_categories mic ' ||
2279: where_stat;
2280: end if;
2281:
2282: if ( not(from_plan_node) ) then

Line 2422: ' msc_item_categories mic, '||

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,
2426: v_instance_id, v_item_id,

Line 2532: ' msc_item_categories mic ' ||

2528: end if;
2529:
2530: sql_stat := 'SELECT avg(md.service_level), count(*) '||
2531: ' FROM msc_demands md, ' ||
2532: ' msc_item_categories mic ' ||
2533: where_stat;
2534: if ( not(from_plan_node) ) then
2535: OPEN the_cursor FOR sql_stat USING p_plan_id,v_org_id,
2536: v_instance_id, v_item_id,

Line 3056: msc_item_categories mit

3052: mit.category_name,
3053: mit.category_set_id,
3054: mbis.detail_date
3055: from msc_bis_inv_detail mbis,
3056: msc_item_categories mit
3057: where mbis.plan_id = p_plan_id
3058: and mit.organization_id = mbis.organization_id
3059: and mit.sr_instance_id = mbis.sr_instance_id
3060: and mit.inventory_item_id = mbis.inventory_item_id