[Home] [Help]
43:
44: Added code to pick the third party taxes from the jai_Rcv_tp_inv_details table in case of
45: third party invoices.
46:
47: This is done by adding code for checking - source in the ap_invoices_all table , if it
48: equals to 'RECEIPT' , getting the third party taxes from the jai_Rcv_tp_inv_Details table.
49:
50: 5. 24/05/2005 Ramananda for bug# 4388958 File Version: 116.1
51: Changed AP Lookup code from 'RECEIPT' to 'INDIA TAX INVOICE'
199: on which Prepayment is applied.\
200: 30. 06-may-2011 vkaranam for bug#12360337
201: Issue:ST processor concurrent is not processing the standalone AP invoices with source other than Manual Invoice entry.
202: Fix:
203: commented the ap_invoices_all.source='Manual Invoice entry' in cursors c_prepayment_applications,c_period_payments.
204: 30. 24-May-2011 Xiao for POT change, reg bug#12533434.
205: Description: ST Processor should process the the transaction on Cash Basis as well as Accrual Basis.
206: Fix: Compare the accounting date of invoice distribution with POT implementation date.
207: Add one more procedure populate_repository to populate the transactions on accrual basis.
286: a.distribution_line_number, a.prepay_distribution_id,
287: a.amount, a.reversal_flag, a.parent_reversal_id, a.accounting_event_id, a.posted_flag, a.org_id,
288: a.accounting_date, b.invoice_amount, b.amount_paid, b.cancelled_date, b.invoice_type_lookup_code invoice_type,
289: a.creation_date, a.po_distribution_id
290: FROM ap_invoice_distributions_all a, ap_invoices_all b
291: WHERE a.invoice_id = b.invoice_id
292: AND invoice_distribution_id = cp_invoice_distribution_id;
293:
294: CURSOR c_invoice_payment(cp_invoice_payment_id IN NUMBER) IS
516: SELECT exchange_date
517: , exchange_rate
518: , exchange_rate_type
519: , invoice_date
520: FROM ap_invoices_all
521: WHERE invoice_id = pn_invoice_id ;
522:
523: CURSOR get_total_rec_amt_cur IS
524: SELECT SUM(tax_amt)
1090: SELECT payment_currency_code,
1091: exchange_rate,
1092: exchange_date,
1093: exchange_rate_type
1094: FROM ap_invoices_all
1095: WHERE invoice_id = cp_invoice_id ;
1096:
1097: lv_service_type_code jai_po_line_locations.service_type_code%TYPE;
1098: ln_organization_id NUMBER;
1846: ai.source
1847: ,aid.accounting_date --Added by zhiwei for POT change Bug#13023443 on 20110930
1848: FROM xla_ae_headers xah ,
1849: xla_transaction_entities xte,
1850: ap_invoices_all ai,
1851: ap_invoice_distributions_all aid
1852: WHERE xah.je_category_name = cp_ae_category
1853: AND xah.ledger_id = cp_sob_id
1854: AND xah.application_id =200
1942: /*Bug 10630847 - Start*/
1943: /*Pick Prepayment applications on Standalone AP Invoice also*/
1944: UNION
1945: select aia.invoice_id
1946: from ap_invoices_all aia
1947: where --aia.source='Manual Invoice Entry' and/*commented by vkaranam for bug#12360337*/
1948: exists (select '1'
1949: from jai_ap_invoice_lines jail
1950: where aia.invoice_id = jail.invoice_id
2226: AND jrti.vendor_site_id = apc.vendor_site_id
2227: AND apc.org_id = p_org_id
2228: UNION --Added this union for bug#8943349 by JMEENA
2229: select aia.invoice_id
2230: from ap_invoices_all aia , jai_ap_invoice_lines jail
2231: where aia.invoice_id = jail.invoice_id
2232: -- and aia.source='Manual Invoice Entry' /*commented the condition by vkaranam for bug#12360337*/
2233: and jail.organization_id = p_organization_id
2234: )/*5694855*/
4443: , aid.accounting_date
4444: , ai.cancelled_date
4445: FROM xla_ae_headers xah
4446: , xla_transaction_entities xte
4447: , ap_invoices_all ai
4448: , ap_invoice_distributions_all aid
4449: WHERE xah.je_category_name = cp_ae_category
4450: AND xah.ledger_id = cp_sob_id
4451: AND xah.application_id = 200
4507: , ai.invoice_type_lookup_code
4508: , ai.invoice_date
4509: , aid.accounting_date
4510: , ai.cancelled_date
4511: FROM ap_invoices_all ai
4512: , ap_invoice_distributions_all aid
4513: WHERE aid.invoice_id = ai.invoice_id
4514: AND aid.set_of_books_id = cp_sob_id
4515: AND ai.invoice_type_lookup_code IN ('STANDARD', 'DEBIT', 'CREDIT')
4573: SELECT payment_currency_code,
4574: exchange_rate,
4575: exchange_date,
4576: exchange_rate_type
4577: FROM ap_invoices_all
4578: WHERE invoice_id = pn_invoice_id;
4579:
4580: /*Bug 12805386 - Fetch Effective Date of Point of Taxation only if Organization Type is either 'INDIVIDUALS' or 'PARTNERSHIP FIRM'
4581: or 'PROPRIETARY FIRM' and if the Service Type is one mentioned in Rule 7 of Point of Taxation Rules 2011 i.e
4674: aida.accounting_date, aia.invoice_date, aida.po_distribution_id
4675: FROM jai_cmn_document_taxes jcdt
4676: , jai_cmn_taxes_all jcta
4677: , ap_invoice_distributions_all aida
4678: , ap_invoices_all aia
4679: WHERE jcdt.source_doc_id = pn_invoice_id
4680: AND jcdt.source_doc_parent_line_no = pn_line_number
4681: AND aia.invoice_id = pn_invoice_id
4682: AND aida.invoice_id = pn_invoice_id
4700: aida.accounting_date, aia.invoice_date, aida.po_distribution_id
4701: FROM jai_ap_match_inv_taxes jamt
4702: , jai_cmn_taxes_all jcta
4703: , ap_invoice_distributions_all aida
4704: , ap_invoices_all aia
4705: WHERE jamt.invoice_id = pn_invoice_id
4706: --AND jamt.invoice_line_number <> pn_line_number
4707: AND jamt.parent_invoice_line_number = pn_line_number
4708: AND jamt.invoice_distribution_id = aida.invoice_distribution_id
4727: SELECT jcta.tax_type, jcdt.tax_amt, aida.invoice_distribution_id,
4728: aida.accounting_date, aia.invoice_date, aida.po_distribution_id
4729: FROM jai_cmn_document_taxes jcdt
4730: , jai_cmn_taxes_all jcta
4731: , ap_invoices_all aia
4732: , ap_invoice_distributions_all aida
4733: WHERE jcdt.source_doc_id = pn_invoice_id
4734: AND jcdt.source_doc_parent_line_no = pn_line_number
4735: AND aia.invoice_id = pn_invoice_id
4762: aida.accounting_date, aia.invoice_date, aida.po_distribution_id
4763: FROM jai_ap_match_inv_taxes jamt
4764: , jai_cmn_taxes_all jcta
4765: , ap_invoice_distributions_all aida
4766: , ap_invoices_all aia
4767: WHERE jamt.invoice_id = pn_invoice_id
4768: --AND jamt.invoice_line_number <> pn_line_number
4769: AND jamt.parent_invoice_line_number = pn_line_number
4770: AND jamt.invoice_distribution_id = aida.invoice_distribution_id