437: to_char(null) as suggested_vendor_site,
438: to_char(null) as suggested_vendor_phone,
439: to_char(null) as suggested_vendor_item_num
440: FROM wip_requirement_operations wro,
441: mtl_system_items_kfv msi,
442: mtl_item_categories mic ,
443: mtl_default_category_sets mdcs
444: WHERE msi.inventory_item_id = wro.inventory_item_id
445: AND msi.organization_id = wro.organization_id
747: to_char(null) as suggested_vendor_site,
748: to_char(null) as suggested_vendor_phone,
749: to_char(null) as suggested_vendor_item_num
750: FROM wip_requirement_operations wro,
751: mtl_system_items_kfv msi,
752: mtl_item_categories mic ,
753: mtl_default_category_sets mdcs
754: WHERE msi.inventory_item_id = wro.inventory_item_id
755: AND msi.organization_id = wro.organization_id