Home » SQL & PL/SQL » SQL & PL/SQL » SQL for linking Oracle GL accounts to Oracle Projects
SQL for linking Oracle GL accounts to Oracle Projects [message #323867] Thu, 29 May 2008 21:54 Go to next message
djp1976
Messages: 15
Registered: September 2007
Junior Member
Hello:

I am trying to write a script that would allow me to link Oracle GL T-Accounts to Oracle Projects. In Oracle. You can go into the GL Inquiry module and input a GL period and GL Account. It then grings up the Batch's associated with that GL Account. Then you can select the Journal entry details and from there drill down to Oracle Projects to see the Expenditure Type that was tied to that account with Project Number and Associated Task. I would like to know if someone has a script that would work in TOAD to pull and query thhis.Any help is appreciated. Please send response to djp1976@bis.midco.net. Regards.
Re: SQL for linking Oracle GL accounts to Oracle Projects [message #324018 is a reply to message #323867] Fri, 30 May 2008 05:05 Go to previous message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
hi,
even if you get replies through pm please make it available to
forum members

yours
dr.s.raghunathan
Previous Topic: How can i display array values in PL/SQL prorgam
Next Topic: while insert data into the table by using fuction
Goto Forum:
  


Current Time: Wed Dec 07 20:30:32 CST 2016

Total time taken to generate the page: 0.12185 seconds