Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
FROM E_ORD_D5D1 D5D1, E_Ord_D7 D7, E_ORD_D5 D5, M_LOC L WHERE D5.COMP_CODE = :p_comp_code AND D5.ORD_NUM = :p_ord_num AND D7.Comp_Code = D5.Comp_Code AND D7.Ord_Num = D5.Ord_Num AND D5D1.Comp_Code (+) = D5.Comp_Code AND D5D1.Ord_Num (+) = D5.Ord_Num AND D5D1.Ord_Line_Num (+) = D5.Ord_Line_Num AND D5D1.Ord_Loc_Line_Num (+) > 0 --AND D5D1.Ord_Loc_Qty > 0 --AND D5D1.Whse_Code <> '*' --AND D5D1.Loc_Code <> '*' AND L.COMP_CODE = D5.COMP_CODE AND L.LOC_CODE = D5D1.LOC_CODE AND L.WHSE_CODE = D5D1.WHSE_CODE
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.