OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » How to get the PO number for the respective invoice number?

Home » Applications » Oracle Fusion Apps & E-Business Suite » How to get the PO number for the respective invoice number?

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

How to get the PO number for the respective invoice number? [message #295069]

Mon, 21 January 2008 04:36

amritaseema
Messages: 47
Registered: January 2008

Member

Hi Gurus,
I m new to this forum
can anyone help me out..
i want to get the po number for the respective invoice number...
i didnt get the link between them.
Thanks
Seema

EDITED by LF: renamed the topic; the original title was "Junior".

@amritaseema, please, stop naming your topics "Junior". These are not descriptive at all.

[Updated on: Mon, 21 January 2008 04:39] by Moderator

Report message to a moderator

Re: How to get the PO number for the respective invoice number? [message #295110 is a reply to message #295069]

Mon, 21 January 2008 06:25

mihaiv
Messages: 6
Registered: May 2007
Location: Bucharest

Junior Member

amritaseema,

What is exactly that you're searching for? Link between invoice and PO (purchase order, or what)?

What is your data model? Supply some data sample.

All the best,
Michael

Report message to a moderator

Re: How to get the PO number for the respective invoice number? [message #295270 is a reply to message #295110]

Mon, 21 January 2008 23:26

amritaseema
Messages: 47
Registered: January 2008

Member

Hi ,
i m searching for the link between invoice and purchase order.
i want the query ,by which i can retrive the purchase order of a particular invoice.means if i 'll query it by passing invoice number it'll give the purchase order of that invoice number.

pl help me....its urgent...
thanks in advance
Seema

Report message to a moderator

Re: How to get the PO number for the respective invoice number? [message #295292 is a reply to message #295069]

Tue, 22 January 2008 00:53

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

hi

I feel u have to give ur sample of data model.

wbr

kanish

Report message to a moderator

Re: How to get the PO number for the respective invoice number? [message #295372 is a reply to message #295292]

Tue, 22 January 2008 03:52

kkinapps
Messages: 29
Registered: November 2006
Location: Hyderabad

Junior Member

HI Amritaseema,

I guess your question is related to Oracle EBS(11.5.10.2), with that...
You can get PO for an invoice in the following way..

SELECT ap_inv.invoice_num, po_hdr.segment1
  FROM ap_invoices_all ap_inv,
       ap_invoice_distributions_all ap_dis,
       po_distributions_all po_dis,
       po_headers_all po_hdr
 WHERE ap_inv.invoice_id = ap_dis.invoice_id
   AND ap_dis.po_distribution_id = po_dis.po_distribution_id
   AND po_dis.po_header_id = po_hdr.po_header_id
   AND ap_inv.invoice_num = &p_inv_num

Let me know if you still have problem.

Regards
KK

Report message to a moderator

Re: How to get the PO number for the respective invoice number? [message #295633 is a reply to message #295372]

Tue, 22 January 2008 23:16

amritaseema
Messages: 47
Registered: January 2008

Member

Hi,

Thanks a lot.
i got the po number by passing the invoice number ...
with yourgiven query...thanks

Thanks
Seema. Smile

[Updated on: Tue, 22 January 2008 23:17]

Report message to a moderator

Previous Topic:	fixed asset prorate convention
Next Topic:	Bill-to/Ship-to Customer id

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 20:42:31 CDT 2024