Thursday, February 23, 2012

Check DMAAIs missing in Chart of Accounts F0901 & F4095


SELECT gm.gmco, gm.gmaid, ml.mlanum, gm.gmobj, gm.gmmcu, gm.gmsub, gm.gmdl01,
       ml.mlobj, ml.mlmcu, ml.mlsub, ml.mldct, ml.mldcto, ml.mlglpt,
       ml.mlcost, gm.gmlda, gm.gmpec
  FROM cnvdta.f0901 gm, cnvdta.f4095 ml
 WHERE ml.mlco = '00205'
   AND gm.gmmcu(+) = ml.mlmcu
   AND gm.gmobj(+) = ml.mlobj
   AND gm.gmsub(+) = ml.mlsub
   AND gm.gmco(+) = ml.mlco
   AND gmaid IS NULL

No comments:

Post a Comment