How to create a Query to see who an when an Account Reconciliation was Approved
I am trying to create a query that will show when an Account Reconciliation was Approved and by whom. I have looked into linking GLRN tables with the EOAW tables but cannot find a way to link. Has anyone created queries for the Account Reconciliation feature in PSoft?
select *
from PS_GLRN_RECON_TBL A
, PS_GLRN_RECON_ASGN B
, PS_GLRN_STATUS_TBL C
WHERE A.GLRN_SET = B.GLRN_SET
AND A.GLRN_RULE = B.GLRN_RULE
AND A.BUSINESS_UNIT = B.BUSINESS_UNIT
AND A.AS_OF_DATE = B.AS_OF_DATE
AND A.SEQUENCE_NBR_9 = B.SEQUENCE_NBR_9