SELECT mp.compile_designator as plan_name, msc.plan_id, msi.organization_id, msc.sr_inventory_item_id, msi.inventory_item_id, msi.segment1, msi.description FROM msc_system_items msc, mtl_system_items_b msi, msc_plans mp where 1 = 1 and msi.inventory_item_id = msc.sr_inventory_item_id and msi.organization_id = msc.organization_id -- plan and mp.plan_id = msc.plan_id order by mp.compile_designator, msc.plan_id, msi.organization_id, msi.inventory_item_id
Комментарии (0)
Уведомления (0)
Написать комментарий
Уведомление
Последние комментарии