Financial Management - PSFT (MOSC)

MOSC Banner

How to create a Query to see who an when an Account Reconciliation was Approved

edited Apr 18, 2017 5:00AM in Financial Management - PSFT (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center