Friday, August 19, 2011

Account hierarchy JD edwards - F0901

select

GMMCU,GMOBJ,GMSUB,GMLDA , GMPEC , GMDL01 from testdta.f0901

where

gmobj>40000

group

by GMLDA , GMPEC , GMDL01,GMMCU,GMOBJ,GMSUB

No comments: