Home » Applications » Oracle Fusion Apps & E-Business Suite » SQL Query to retriew open GRNs for Purchasning in R12 (Purchasing R12.0.6)
icon5.gif  SQL Query to retriew open GRNs for Purchasning in R12 [message #569985] Sun, 04 November 2012 05:42 Go to next message
sadanand
Messages: 1
Registered: November 2012
Location: Hyderabad
Junior Member

Hi All,

Can anybody help me by providing an SQL Query to retrieve all open GRNs in purchasing. As a part of re-implementation we are loading open balance from the existing system. In order to validate the open GRNs standard report is not apt results.

Thanks & Regards,
Sadanand
Re: SQL Query to retriew open GRNs for Purchasning in R12 [message #569989 is a reply to message #569985] Sun, 04 November 2012 08:35 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Previous Topic: to find the profile option
Next Topic: PRE-FORM TRIGGER RAISED UNHANDLED EXCEPTION ORA-06502
Goto Forum:
  


Current Time: Mon Dec 23 04:48:10 CST 2024