oracle project subledger query

Summary:

I am trying to construct a query to subledger detail for Projects source, but find that the sql below does not return any detail for revenue, no data is returned for many of the GL JE LINES, can anyone tell me what I need to add to pull the revenue subledger data?

Content (please ensure you mask any confidential information):

See code snippet.

Essentially when joining to Projects subledger detail from General Ledger tables I find I lose the revenue lines, and looking at recent notes relating to this I do not find anything that works for the missing revenue - appreciate any pointers on this.