General Ledger - EBS (MOSC)

MOSC Banner

Need to create SQL script from Gl that will provide AP and AR details in the same script

edited Apr 6, 2013 4:51PM in General Ledger - EBS (MOSC) 3 commentsAnswered
Have created a sql script from the gl_je_lines table that joins to AP table to pull invoice and supplier detail. I also have a similar script that joins the gl_je_lines table to Ar tables and pulls ar details info. I need to create a script that can pull both AP and AR detail within the same SQL script. Could this be accomplished by using a union of the two scripts or is there another solution?

Thanks

Dennis

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