Home » Applications » Oracle Fusion Apps & E-Business Suite » How to get the invoice number which dont have PO Number? (Oracle EBS(11.5.10.2), XP)
icon7.gif  How to get the invoice number which dont have PO Number? [message #295748] Wed, 23 January 2008 04:58 Go to next message
amritaseema
Messages: 47
Registered: January 2008
Member
Hi,
Any one can pleasez help me...
i need the query by which i can retrive the invoice number which dont have po number.means if i 'll query it by passing invoice number(means if i'll pass two invoice number one which is having po number and one which doesnt have po number )then it'll give the out put for the invoice number which dont have the po number.
Plzz Urgently....I need it

Thanks in advance
Seema
Re: How to get the invoice number which dont have PO Number? [message #295813 is a reply to message #295748] Wed, 23 January 2008 09:37 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
I think the answer is in your previous post.

http://www.orafaq.com/forum/t/95969/45399/

Check ap_invoices_all and ap_invoice_distributions_all.

By
Vamsi
icon7.gif  Re: How to get the invoice number which dont have PO Number? [message #295925 is a reply to message #295813] Wed, 23 January 2008 23:14 Go to previous message
amritaseema
Messages: 47
Registered: January 2008
Member
hi,
yes i got the answer...
Thanks
Seema
Previous Topic: DRILL DOWN FROM GL INTO AP, AR, PO & INV SUBLEDGERS FROM ORACLE DISCOVERER
Next Topic: what is the formscape printer
Goto Forum:
  


Current Time: Sat Dec 10 04:44:53 CST 2016

Total time taken to generate the page: 0.08740 seconds