| Invoice Query..!! [message #166007] |
Tue, 04 April 2006 00:41  |
deepayan
Messages: 51
Registered: December 2005
|
Member |
|
|
|
I need a query that will output the invoice number,invoice date, supplier name,supplier site name,total amount & amount paid of a particular OU. please help...I am new to oracle apps.!!
|
|
|
|
|
|
| Re: Invoice Query..!! [message #166015 is a reply to message #166010] |
Tue, 04 April 2006 01:12  |
deepayan
Messages: 51
Registered: December 2005
|
Member |
|
|
Hi basant,
thanks for your prompt response.Instead of paying the whole amount ,we can pay an invoice partly. amount paid means the partially paid amount.OU means operating unit. I need all these informations of a particular OU. --deepayan
|
|
|
|
|
|
| Re: Invoice Query..!! [message #166032 is a reply to message #166019] |
Tue, 04 April 2006 02:43 |
manwadkar
Messages: 104
Registered: September 2005
Location: Washington DC
|
Senior Member |
|
|
You may need to modify this query. You can use this query as base for you.
select d.name OU, b.VENDOR_NAME, c.VENDOR_SITE_CODE, a.invoice_date, a.invoice_num , sum(a.invoice_amount) INV_AMOUNT,
sum(nvl(a.amount_paid,0)) AMOUNT_PAID
from ap_invoices_all a, po_vendors b, po_vendor_sites_all c , hr_all_organization_units d
where
a.VENDOR_ID = b.VENDOR_ID
and a.VENDOR_SITE_ID = c.VENDOR_SITE_ID
and a.ORG_ID = d.ORGANIZATION_ID
group by d.name, b.VENDOR_NAME, c.VENDOR_SITE_CODE, a.invoice_date, a.invoice_num
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
