Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.
SELECT distinct ma.manufacturer_id, ma.manufacturer_name , e.organization_id organization_id , mlu.meaning eco_status, mlu.meaning approval_status FROM eng_engineering_changes e, mfg_lookups mlu, mtl_mfg_part_numbers map , mtl_manufacturers ma WHERE e.organization_id =1 and e.status_type = mlu.lookup_code AND mlu.lookup_type IN ( 'ECG_ECN_STATUS','ENG_ECN_APPROVAL_STATUS' ) AND e.organization_id = map.organization_id AND ma.manufacturer_id = map.manufacturer_id;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.