This content has been marked as final. Show 6 replies
Kranthi,1 person found this helpful
You need to use the following tables. But is the requirement is to write a single query??
po_headers_all, po_lines_all, po_line_locations_all, po_distributions_all
rcv_shipment_headers, rcv_shipment_lines, rcv_transactions,
ap_invoices_all, ap_invoice_distributions_all, ap_checks_all, ap_invoice_payments_all.
Thanx for the reply jyoti
i know the tables.I got the link but the problem arising for me is.
iam facing problem when joining the tables from receipt tables to invoice tables im getting duplicate data.
Any ideas will be greatly appreciated!!
Edited by: Kranthi.K on Jun 10, 2009 5:00 AM
I got all join conditions correct and getting the result,but getting some ambiguity.
The problem iam facing is i needed tax invoice lines also to be captured,these tax invoice lines come from the purchase order i.e purchasing line tax assigned to the concerned invoice.
Can anyone build me the query for purchase order-->receipts-->invoices
columns required:- po_number,po_line_number,po_quantity,po_unit_price,receipt_num,transaction_type,
take conditions like transaction_type='deliver'
Any answers will be greatly appreciated.
Edited by: Kranthi.K on Jun 10, 2009 4:58 AM
Hi,1 person found this helpful
Please look at the following query. This is in R12. Please modify the query as per your requirement.
and rt.po_header_id = pha.po_header_id
and pha.po_header_id = pla.po_header_id
and pla.po_line_id = plla.po_line_id
and plla.line_location_id = pda.line_location_id
and rt.po_line_location_id = plla.line_location_id
and pla.item_id = msi.inventory_item_id (+)
and rt.po_line_id = pla.po_line_id (+)
and rt.organization_id = msi.organization_id
and rsh.shipment_header_id (+) = rt. shipment_header_id
and aip.check_id = ac.check_id (+)
and aia.invoice_id = aip.invoice_id
and aia.invoice_id (+) = ail.invoice_id
and aia.invoice_id = aid.invoice_id
and pda.po_distribution_id(+) = aid.po_distribution_id
and rt.transaction_type = 'DELIVER'
and ail.line_type_lookup_code = 'ITEM'
and aid.line_type_lookup_code = 'ACCRUAL'
and pha.segment1 = '&PO_Number'
Thanx for your prompt reply.Its very nice of you to provide me query
Hi All ,
I payment againts multile invoices and one invoice has multiple lines and eached lines has diffrent wh tax and wheld tax rates,
Now i want to get the detail of information like
3W SYSTEMS (PVT) LTD
date of payment
Value/ Amount on which tax collectabl or deductable
Rate of Tax (%)
Amount of Tax Collected or Deducted
Amount of Tax Deposited
date Tax Deposited
Now I applied partial payment angainst multiple invoices , How can i get the partial payment and wheld tax, above give detail
Please Solve my issue