Can someone please help me with the query to get this extract. I would to get these fields linking PA_PROJECTS_ALL and GL_BALANCES. ( I might be wrong).. but I need these fields.
Project | Account| Opening YTD | PTD Additions | PTD Capitalized | Closing YTD (Column C + Column D)
PTD Additions (Column D) would be the sum of transfer from Projects to GL + Pre-accounted expenditure batches that do not have to be transferred)
PTD Capitalized(Column F) : Capitalized during the Period (i.e. transferred to Fixed Assets).
Thanks for you time and help.