Often times you want to replicate a form query with plain ol sql. In this little example ill show you how to do just this very thing with FRRIGITD. The sql is pretty straight foward. Let me remind you
that the grant ledger is inception to date. Continue reading “how to make FRIGITD with sql.”
FRRGRNL How to query periods as rows.Simple Hack
If you ever had to write a query against the grant ledger (FRRGRNL) or even the operating ledger(FGBOPAL) I’m sure you have come across this little challenge. You have to start writing a massive decode statement to make your query get the right column. This can be challenging to say the least or a bit of a pain.
Wouldn’t it be nice if you can just say something like?
Continue reading “FRRGRNL How to query periods as rows.Simple Hack”