HI ALL,
I want help for a SQL query in which i can find the following relation
SUPPLIER NAME---SITE CODE----DATE----INVOICE NO.----DESCRIPTION-----GL CODE COMBINATION
Basiclly i want to the GL -- Subledger Report --- from where i can find the all invoices in a particular GL like Professional Charges.
Thanks,
Sanjay Khandelwal
SQL QUERY FOR AP INVOICES
Hello.
Here's the query (APPS 11.5)
You may need to enter more segments from the code combinations.
Hope this helps.
Octavio
Here's the query (APPS 11.5)
You may need to enter more segments from the code combinations.
Code: Select all
select v.vendor_name Vendor,
vs.vendor_site_code Site,
i.invoice_date InvDate,
i.invoice_num Nr,
d.description Descripiton,
cc.segment1||'.'||cc.segment2||'.'||cc.segment3 CC
from ap_invoices_all i,
ap_invoice_distributions_all d,
po_vendors v,
po_vendor_sites_all vs,
gl_code_combinations cc
where d.invoice_id = i.invoice_id
and v.vendor_id = vs.vendor_id
and vs.vendor_site_id = i.vendor_site_id
and cc.code_combination_id = d.dist_code_combination_id
and i.org_id = <your org_id>
and d.accounting_date >= 'start date'
and d.accounting_date <= 'end date'
Octavio
-
- Posts: 6
- Joined: Tue Jun 23, 2009 8:37 am
- Location: India
Who is online
Users browsing this forum: No registered users and 8 guests