APPS.MSC_GET_BIS_VALUES dependencies on MSC_ITEM_CATEGORIES

Line 2076: ' from msc_item_categories mit ' ||

2072: else
2073: where_stat := where_stat ||
2074: ' AND EXISTS '||
2075: ' (select 1 '||
2076: ' from msc_item_categories mit ' ||
2077: ' where mit.organization_id = mbis.organization_id '||
2078: ' and mit.sr_instance_id = mbis.sr_instance_id '||
2079: ' and mit.inventory_item_id = mbis.inventory_item_id '||
2080: ' and -1 = :9 '||

Line 2100: ' from msc_item_categories mit ' ||

2096: else
2097: where_stat := where_stat ||
2098: ' AND EXISTS '||
2099: ' (select 1 '||
2100: ' from msc_item_categories mit ' ||
2101: ' where mit.organization_id = mbis.organization_id '||
2102: ' and mit.sr_instance_id = mbis.sr_instance_id '||
2103: ' and mit.inventory_item_id = mbis.inventory_item_id '||
2104: ' and mit.sr_category_id = :9 '||

Line 2260: ' msc_item_categories mic ' ||

2256: if v_plan_type <> 4 then
2257: sql_stat := 'SELECT sum(nvl(md.quantity_by_due_date,0)*nvl(md.probability,1)), '||
2258: ' sum(md.USING_REQUIREMENT_QUANTITY*nvl(md.probability,1)) ' ||
2259: ' FROM msc_demands md, ' ||
2260: ' msc_item_categories mic ' ||
2261: where_stat;
2262: --elsif (p_use_old_demand_qty = -1) then
2263: elsif v_plan_type = 4 then
2264: sql_stat := 'SELECT sum(nvl(md.old_demand_quantity,0)*nvl(md.probability,1)), '||

Line 2267: ' msc_item_categories mic ' ||

2263: elsif v_plan_type = 4 then
2264: sql_stat := 'SELECT sum(nvl(md.old_demand_quantity,0)*nvl(md.probability,1)), '||
2265: ' sum(md.USING_REQUIREMENT_QUANTITY*nvl(md.probability,1)) ' ||
2266: ' FROM msc_demands md, ' ||
2267: ' msc_item_categories mic ' ||
2268: where_stat;
2269: end if;
2270:
2271: if ( not(from_plan_node) ) then

Line 2411: ' msc_item_categories mic, '||

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

Line 2521: ' msc_item_categories mic ' ||

2517: end if;
2518:
2519: sql_stat := 'SELECT avg(md.service_level), count(*) '||
2520: ' FROM msc_demands md, ' ||
2521: ' msc_item_categories mic ' ||
2522: where_stat;
2523: if ( not(from_plan_node) ) then
2524: OPEN the_cursor FOR sql_stat USING p_plan_id,v_org_id,
2525: v_instance_id, v_item_id,

Line 3045: msc_item_categories mit

3041: mit.category_name,
3042: mit.category_set_id,
3043: mbis.detail_date
3044: from msc_bis_inv_detail mbis,
3045: msc_item_categories mit
3046: where mbis.plan_id = p_plan_id
3047: and mit.organization_id = mbis.organization_id
3048: and mit.sr_instance_id = mbis.sr_instance_id
3049: and mit.inventory_item_id = mbis.inventory_item_id