Home » SQL & PL/SQL » SQL & PL/SQL » Does anyone have a query for the Journal Entry Reserve Ledger Report?
Does anyone have a query for the Journal Entry Reserve Ledger Report? [message #290133] Thu, 27 December 2007 10:43 Go to next message
pweill
Messages: 11
Registered: December 2007
Junior Member
Is there any way to get the Journal Entry Reserve Ledger Report into an SQL? Thanks for any help!!

[Updated on: Thu, 27 December 2007 10:46]

Report message to a moderator

Re: Does anyone have a TOAD query for the Journal Entry Reserve Ledger Report? [message #290135 is a reply to message #290133] Thu, 27 December 2007 10:47 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>Is there any way to get the Journal Entry Reserve Ledger Report into an SQL?
What make you think it is not already SQL?


Alternatively
ALTER SESSION SET SQL_TRACE=TRUE before running the report.
Re: Does anyone have a TOAD query for the Journal Entry Reserve Ledger Report? [message #290141 is a reply to message #290135] Thu, 27 December 2007 11:30 Go to previous messageGo to next message
pweill
Messages: 11
Registered: December 2007
Junior Member
I've never done that before. What do I need to know in order to run that trace in a develpment instance...like...does it trace for everything? Where does the trace go? Thanks for the help.
Re: Does anyone have a TOAD query for the Journal Entry Reserve Ledger Report? [message #290165 is a reply to message #290133] Thu, 27 December 2007 20:58 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
It appears that BOTH the search button on this forum & GOOGLE are broken for you.
Therefore I suggest that you upgrade your browser with one that supports either facility mentioned above.

Until you obtain additional capability, You're On Your Own (YOYO)!

[Updated on: Thu, 27 December 2007 20:59] by Moderator

Report message to a moderator

Help with obtaining the sql for Oracle's Journal Entry Reserve Ledger Report [message #291297 is a reply to message #290133] Thu, 03 January 2008 13:29 Go to previous messageGo to next message
pweill
Messages: 11
Registered: December 2007
Junior Member
Does anyone have an SQL that I could run in TOAD that would generate the same output as the Journal Entry Reserve Ledger Report? Thanks!!
Re: Does anyone have a query for the Journal Entry Reserve Ledger Report? [message #291298 is a reply to message #290133] Thu, 03 January 2008 13:43 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
SIlly question, why can't you find the SQL from the report,
cut & paste it into Toad,replacing the variables with the data you are trying to analyze / Debug ?
Re: Does anyone have a query for the Journal Entry Reserve Ledger Report? [message #291299 is a reply to message #291298] Thu, 03 January 2008 13:45 Go to previous message
pweill
Messages: 11
Registered: December 2007
Junior Member
I just don't know how to get to the sql.
Previous Topic: dynamic column alias using sysdate
Next Topic: Query problem.
Goto Forum:
  


Current Time: Fri Dec 02 18:22:12 CST 2016

Total time taken to generate the page: 0.23755 seconds