OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Oracle Purchasing (11.5.10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Purchasing [message #328390]

Fri, 20 June 2008 00:55

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

Report message to a moderator

Re: Oracle Purchasing [message #329208 is a reply to message #328390]

Tue, 24 June 2008 09:08

Alien
Messages: 292
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

Report message to a moderator

Re: Oracle Purchasing [message #329287 is a reply to message #328390]

Tue, 24 June 2008 23:00

lakshminarayana.j
Messages: 9
Registered: May 2008
Location: Pune

Junior Member

Thanks Alien.

I got the solution.

Report message to a moderator

Previous Topic:	Asset_Key Value
Next Topic:	to learn Oracle Apps or Informatica?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 18:50:29 CDT 2024