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_AP_MATCH_INV_TAXES

Line 942: FROM JAI_AP_MATCH_INV_TAXES a, JAI_CMN_TAXES_ALL b, JAI_RGM_REGISTRATIONS c

938: CURSOR c_tax_dist_dtl(cp_regime_id IN NUMBER, cp_invoice_id IN NUMBER, cp_inv_distribution_id IN NUMBER) IS -- cp_dist_line_no IN NUMBER) IS
939: SELECT 1 chk, a.tax_id, b.tax_rate, a.tax_amount, a.parent_invoice_distribution_id, b.tax_type,
940: a.invoice_line_number, /* INVOICE LINES UPTAKE */
941: nvl(b.mod_cr_percentage,0) recoverable_ptg, a.base_amount
942: FROM JAI_AP_MATCH_INV_TAXES a, JAI_CMN_TAXES_ALL b, JAI_RGM_REGISTRATIONS c
943: WHERE a.invoice_id = cp_invoice_id
944: -- AND a.distribution_line_number = cp_dist_line_no Modified as part of AP INVOICE Lines Uptake project
945: AND a.invoice_distribution_id = cp_inv_distribution_id
946: AND a.tax_id = b.tax_id

Line 1198: || nvl(r_tax_dist_dtl.chk, 0) = 0 means that no records were found in the JAI_AP_MATCH_INV_TAXES table.

1194: /*
1195: || above elsif added by ssumaith - bug# 4284505
1196: || NVL(ap_acc_dist.source,'$$$') = 'INDIA TAX INVOICE' --'RECEIPT' - It means a third party invoice.is being processed. ----Ramanand for bug#4388958
1197:
1198: || nvl(r_tax_dist_dtl.chk, 0) = 0 means that no records were found in the JAI_AP_MATCH_INV_TAXES table.
1199: || For third party invoices , there will be no records in the JAI_AP_MATCH_INV_TAXES table
1200: || For third party invoices , the tax details need to be picked up from the jai_rcv_tp_inv_details table.
1201: || It should be joined to the jai_rcv_tp_.invoices table based on the batch_invoice_id column and
1202: || we arrive at the correct batch_invoice_id based on the invoice_id link between the third party

Line 1199: || For third party invoices , there will be no records in the JAI_AP_MATCH_INV_TAXES table

1195: || above elsif added by ssumaith - bug# 4284505
1196: || NVL(ap_acc_dist.source,'$$$') = 'INDIA TAX INVOICE' --'RECEIPT' - It means a third party invoice.is being processed. ----Ramanand for bug#4388958
1197:
1198: || nvl(r_tax_dist_dtl.chk, 0) = 0 means that no records were found in the JAI_AP_MATCH_INV_TAXES table.
1199: || For third party invoices , there will be no records in the JAI_AP_MATCH_INV_TAXES table
1200: || For third party invoices , the tax details need to be picked up from the jai_rcv_tp_inv_details table.
1201: || It should be joined to the jai_rcv_tp_.invoices table based on the batch_invoice_id column and
1202: || we arrive at the correct batch_invoice_id based on the invoice_id link between the third party
1203: || invoice and jai_rcv_tp_invoices table.