eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on JAI_RCV_TP_INV_DETAILS

Line 44: Added code to pick the third party taxes from the jai_Rcv_tp_inv_details table in case of

40: to date fromat using fnd_date.canonical_to_date function.
41:
42: 4. 14/04/2005 ssumaith - bug# 4284505 - File version 115.3
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.

Line 48: equals to 'RECEIPT' , getting the third party taxes from the jai_Rcv_tp_inv_Details table.

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'
52:

Line 2078: FROM jai_rcv_tp_inv_details a , JAI_CMN_TAXES_ALL b , jai_rcv_tp_invoices c, JAI_RGM_REGISTRATIONS d

2074: CURSOR c_tp_inv_details (cp_regime_id IN NUMBER , cp_invoice_id IN NUMBER , cp_line_number IN NUMBER,cp_inv_distribution_id in number) IS
2075: SELECT 1 chk , a.tax_id , a.tax_rate , a.tax_amount , NULL ,a.tax_type ,
2076: a.line_number invoice_line_number, /* INVOICE LINES UPTAKE */
2077: NVL(b.mod_cr_percentage,0) recoverable_ptg, NULL
2078: FROM jai_rcv_tp_inv_details a , JAI_CMN_TAXES_ALL b , jai_rcv_tp_invoices c, JAI_RGM_REGISTRATIONS d
2079: WHERE c.invoice_id = cp_invoice_id
2080: AND a.batch_invoice_id = c.batch_invoice_id
2081: AND a.tax_id = b.tax_id
2082: AND a.line_number = cp_line_number /*INVOICE LINES UPTAKE cp_dist_line_number */

Line 2457: || For third party invoices , the tax details need to be picked up from the jai_rcv_tp_inv_details table.

2453: || NVL(ap_acc_dist.source,'$$$') = 'INDIA TAX INVOICE' --'RECEIPT' - It means a third party invoice.is being processed. ----Ramanand for bug#4388958
2454:
2455: || nvl(r_tax_dist_dtl.chk, 0) = 0 means that no records were found in the JAI_AP_MATCH_INV_TAXES table.
2456: || For third party invoices , there will be no records in the JAI_AP_MATCH_INV_TAXES table
2457: || For third party invoices , the tax details need to be picked up from the jai_rcv_tp_inv_details table.
2458: || It should be joined to the jai_rcv_tp_.invoices table based on the batch_invoice_id column and
2459: || we arrive at the correct batch_invoice_id based on the invoice_id link between the third party
2460: || invoice and jai_rcv_tp_invoices table.
2461: || Using this link, if the r_tax_dist_dtl is populated, it will take its normal course.