OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » How to get the invoice number which dont have PO Number?

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)

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

How to get the invoice number which dont have PO Number? [message #295748]

Wed, 23 January 2008 04:58

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

Report message to a moderator

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

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

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

Report message to a moderator

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

amritaseema
Messages: 47
Registered: January 2008

Member

hi,
yes i got the answer...
Thanks
Seema

Report message to a moderator

Previous Topic:	DRILL DOWN FROM GL INTO AP, AR, PO & INV SUBLEDGERS FROM ORACLE DISCOVERER
Next Topic:	what is the formscape printer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 04 09:46:36 CDT 2024