General Ledger Delete GLTFSDEF Records for Missing Groups

From KeystoneIntranet
Revision as of 00:01, 10 January 2017 by Intra>User (1 revision imported)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
delete from gltfsdef fs
 WHERE CMDNO IN (1,3) AND PARAM1_TYPE=3 AND NOT EXISTS ( SELECT GROUP_ID FROM  gltacgrp  g WHERE g.group_id=fs.param1)