GL PS Query

Hello,

I have a requirement to get TRANSACTION_ID, TRANSACTION_LINE, GL_DISTRIB_STATUS from PS_HR_JGEN_ACT_CLN table which will join to PS_JRNL_HEADER D, PS_JRNL_LN E, PS_GL_ACCOUNT_TBL F so that it will fetch the data from PS_JRNL_LN and PS_HR_JGEN_ACT_CLN table.

I have a created a query using Union and i get the data but i don't see any data on TRANSACTION_ID, TRANSACTION_LINE, GL_DISTRIB_STATUS columns on the query.

Not sure what i am missing?

Thanks