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: 245
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: Asset_Key Value
Next Topic: to learn Oracle Apps or Informatica?
Goto Forum:
  


Current Time: Sat Dec 03 01:06:54 CST 2016

Total time taken to generate the page: 0.11598 seconds