Home » Applications » Oracle Fusion Apps & E-Business Suite » How to get the PO number for the respective invoice number?
icon7.gif  How to get the PO number for the respective invoice number? [message #295069] Mon, 21 January 2008 04:36 Go to next message
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 Go to previous messageGo to next message
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
icon7.gif  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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

hi

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

wbr

kanish
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 Go to previous messageGo to next message
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
icon7.gif  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 Go to previous message
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:
  


Current Time: Sat Dec 03 03:47:07 CST 2016

Total time taken to generate the page: 0.18277 seconds