Home » Applications » Oracle Fusion Apps & E-Business Suite » Oracle Purchasing (11.5.10)
Oracle Purchasing [message #328390] Fri, 20 June 2008 00:55 Go to next message
lakshminarayana.j
Messages: 9
Registered: May 2008
Location: Pune
Junior Member
Hi,

Any one can provide me the query which says the PO'S created without requisitions in Oracle Purchasing.


Thanks
Lakshmi Narayana

Re: Oracle Purchasing [message #329208 is a reply to message #328390] Tue, 24 June 2008 09:08 Go to previous messageGo to next message
Alien
Messages: 252
Registered: June 1999
Senior Member
Hi,

I don't have the query with me. But I'll give you a hint. The link is on the distribution level.
So go from po_headers to po_lines, to po_line_locations to po_distributions and find req_distribution_id is null.

Regards,

Arian
Re: Oracle Purchasing [message #329287 is a reply to message #328390] Tue, 24 June 2008 23:00 Go to previous message
lakshminarayana.j
Messages: 9
Registered: May 2008
Location: Pune
Junior Member
Thanks Alien.

I got the solution.
Previous Topic: Report to be accesses by particular person
Next Topic: how to unapply AR Receipt partially ( Which API to use)
Goto Forum:
  


Current Time: Mon Aug 21 09:09:35 CDT 2017

Total time taken to generate the page: 0.09388 seconds