[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'
147: a.distribution_line_number, a.prepay_distribution_id,
148: a.amount, a.reversal_flag, a.parent_reversal_id, a.accounting_event_id, a.posted_flag, a.org_id,
149: a.accounting_date, b.invoice_amount, b.amount_paid, b.cancelled_date, b.invoice_type_lookup_code invoice_type,
150: a.creation_date, a.po_distribution_id
151: FROM ap_invoice_distributions_all a, ap_invoices_all b
152: WHERE a.invoice_id = b.invoice_id
153: AND invoice_distribution_id = cp_invoice_distribution_id;
154:
155: CURSOR c_invoice_payment(cp_invoice_payment_id IN NUMBER) IS
868: aid.exchange_rate, aid.exchange_rate_type, aid.exchange_date,
869: ai.source
870: FROM xla_ae_headers xah ,
871: xla_transaction_entities xte,
872: ap_invoices_all ai,
873: ap_invoice_distributions_all aid
874: WHERE xah.je_category_name = cp_ae_category
875: AND xah.ledger_id = cp_sob_id
876: AND xah.application_id =200