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_CMN_TAXES_ALL

Line 351: lv_excise_cess JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;

347: lv_organization_type VARCHAR2(2);
348: ln_organization_id NUMBER;
349:
350: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%TYPE;
351: lv_excise_cess JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
352: ln_regime_id JAI_RGM_DEFINITIONS.regime_id%TYPE;
353:
354: BEGIN
355:

Line 526: jai_cmn_taxes_all jcta

522:
523: CURSOR get_total_rec_amt_cur IS
524: SELECT SUM(tax_amt)
525: FROM jai_cmn_document_taxes jcdt,
526: jai_cmn_taxes_all jcta
527: WHERE jcdt.source_doc_id = pn_invoice_id
528: --Add by Chong for bug#13358557 08-NOV-2011, begin
529: -----------------------------------------------------------------------------------------------
530: AND jcdt.source_doc_parent_line_no = pn_line_number

Line 541: , jai_cmn_taxes_all jcta

537: CURSOR get_total_arrec_amt_cur IS
538: SELECT SUM(jattl.tax_amount * nvl(jcta.mod_cr_percentage,0)/100) tax_amt
539: FROM jai_ar_trx_tax_lines jattl
540: , jai_ar_trx_lines jatl
541: , jai_cmn_taxes_all jcta
542: WHERE jatl.customer_trx_id = pn_invoice_id
543: AND jattl.link_to_cust_trx_line_id = jatl.customer_trx_line_id
544: AND jattl.tax_id = jcta.tax_id
545: AND nvl(jcta.mod_cr_percentage,0) > 0

Line 562: , jai_cmn_taxes_all jcta

558: AND jcdt.tax_type IN ('Service', 'SERVICE_EDUCATION_CESS', 'SERVICE_SH_EDU_CESS')
559: UNION ALL
560: SELECT 'MATCH' match_type, jamt.invoice_distribution_id, jamt.tax_amount tax_amt,jcta.tax_type
561: FROM jai_ap_match_inv_taxes jamt
562: , jai_cmn_taxes_all jcta
563: WHERE jamt.invoice_id = pn_invoice_id
564: --AND jamt.invoice_line_number <> pn_line_number
565: AND jamt.parent_invoice_line_number = pn_line_number
566: AND jamt.tax_id = jcta.tax_id

Line 573: , jai_cmn_taxes_all jcta

569:
570: CURSOR get_matched_tax_rec_tot_cur IS
571: SELECT sum(jamt.tax_amount)
572: FROM jai_ap_match_inv_taxes jamt
573: , jai_cmn_taxes_all jcta
574: WHERE jamt.invoice_id = pn_invoice_id
575: --Add by Chong for bug#13358557 08-NOV-2011, begin
576: -----------------------------------------------------------------------------------------------
577: AND jamt.parent_invoice_line_number = pn_line_number

Line 600: , jai_cmn_taxes_all jcta

596: SELECT jcta.tax_type, jattl.tax_amount * nvl(jcta.mod_cr_percentage,0)/100 tax_amt,
597: jattl.customer_trx_line_id
598: FROM jai_ar_trx_tax_lines jattl
599: , ra_customer_trx_lines_all trxl
600: , jai_cmn_taxes_all jcta
601: WHERE jattl.link_to_cust_trx_line_id = pn_line_number
602: AND trxl.customer_trx_id = pn_invoice_id
603: AND trxl.customer_trx_line_id = pn_line_number
604: AND jattl.tax_id = jcta.tax_id

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

1982: 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
1983: SELECT 1 chk, a.tax_id, b.tax_rate, a.tax_amount, a.parent_invoice_distribution_id, b.tax_type,
1984: a.invoice_line_number invoice_line_number, /* INVOICE LINES UPTAKE */
1985: nvl(b.mod_cr_percentage,0) recoverable_ptg, a.base_amount
1986: FROM JAI_AP_MATCH_INV_TAXES a, JAI_CMN_TAXES_ALL b, JAI_RGM_REGISTRATIONS c
1987: WHERE a.invoice_id = cp_invoice_id
1988: -- AND a.distribution_line_number = cp_dist_line_no Modified as part of AP INVOICE Lines Uptake project
1989: AND a.invoice_distribution_id = cp_inv_distribution_id
1990: AND a.tax_id = b.tax_id

Line 2003: JAI_CMN_TAXES_ALL tax, JAI_RGM_REGISTRATIONS rgm

1999: ap_line.line_number invoice_line_number,
2000: 100 recoverable_ptg, match_tax.base_amount
2001: FROM AP_INVOICE_LINES_ALL ap_line,
2002: AP_INVOICE_DISTRIBUTIONS_ALL ap_dist, JAI_AP_MATCH_INV_TAXES match_tax,
2003: JAI_CMN_TAXES_ALL tax, JAI_RGM_REGISTRATIONS rgm
2004: WHERE ap_dist.invoice_id = cp_invoice_id
2005: AND ap_dist.invoice_distribution_id = cp_inv_distribution_id
2006: AND ap_line.invoice_id = ap_dist.invoice_id
2007: AND ap_dist.invoice_line_number = ap_line.line_number

Line 2028: FROM JAI_CMN_DOCUMENT_TAXES a, JAI_CMN_TAXES_ALL b, JAI_RGM_REGISTRATIONS c,

2024: /*Bug 9854974 - Item Line ID in JAI_RGM_TRX_REFS should refer to the Item Line to which Service Tax is attached
2025: and not the Line Number of the Service Tax*/
2026: a.source_doc_parent_line_no invoice_line_number, /* INVOICE LINES UPTAKE */
2027: nvl(b.mod_cr_percentage,0) recoverable_ptg, d.base_amount
2028: FROM JAI_CMN_DOCUMENT_TAXES a, JAI_CMN_TAXES_ALL b, JAI_RGM_REGISTRATIONS c,
2029: AP_INVOICE_DISTRIBUTIONS_ALL d
2030: WHERE a.source_doc_id = cp_invoice_id
2031: AND d.invoice_distribution_id = cp_inv_distribution_id
2032: AND d.invoice_id = a.source_doc_id

Line 2050: JAI_CMN_TAXES_ALL b

2046: 100 recoverable_ptg,
2047: ap_dist.base_amount
2048: FROM
2049: AP_INVOICE_LINES_ALL ap_line,AP_INVOICE_DISTRIBUTIONS_ALL ap_dist,JAI_CMN_DOCUMENT_TAXES a, JAI_RGM_REGISTRATIONS c,
2050: JAI_CMN_TAXES_ALL b
2051: WHERE ap_dist.invoice_id = cp_invoice_id
2052: AND ap_dist.invoice_distribution_id = cp_inv_distribution_id
2053: AND ap_line.invoice_id = ap_dist.invoice_id
2054: AND ap_dist.invoice_line_number = ap_line.line_number

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 2093: FROM JAI_CMN_DOCUMENT_TAXES a, JAI_CMN_TAXES_ALL b, JAI_RGM_REGISTRATIONS c,

2089: UNION
2090: SELECT 2 chk, a.tax_id, b.tax_rate, a.tax_amt,null, b.tax_type,
2091: a.source_doc_parent_line_no invoice_line_number,
2092: nvl(b.mod_cr_percentage,0) recoverable_ptg, d.base_amount
2093: FROM JAI_CMN_DOCUMENT_TAXES a, JAI_CMN_TAXES_ALL b, JAI_RGM_REGISTRATIONS c,
2094: AP_INVOICE_DISTRIBUTIONS_ALL d
2095: WHERE a.source_doc_id = cp_invoice_id
2096: AND d.invoice_distribution_id = cp_inv_distribution_id
2097: AND d.invoice_id = a.source_doc_id

Line 2115: JAI_CMN_TAXES_ALL b

2111: 100 recoverable_ptg,
2112: ap_dist.base_amount
2113: FROM
2114: AP_INVOICE_LINES_ALL ap_line,AP_INVOICE_DISTRIBUTIONS_ALL ap_dist,JAI_CMN_DOCUMENT_TAXES a, JAI_RGM_REGISTRATIONS c,
2115: JAI_CMN_TAXES_ALL b
2116: WHERE ap_dist.invoice_id = cp_invoice_id
2117: AND ap_dist.invoice_distribution_id = cp_inv_distribution_id
2118: AND ap_line.invoice_id = ap_dist.invoice_id
2119: AND ap_dist.invoice_line_number = ap_line.line_number

Line 4642: jai_cmn_taxes_all jcta

4638: ----------------------------------------------------------------------------------------------
4639: --Modified by Chong for bug#13358557 08-NOV-2011, end
4640: SELECT SUM(tax_amt)
4641: FROM jai_cmn_document_taxes jcdt,
4642: jai_cmn_taxes_all jcta
4643: WHERE jcdt.source_doc_id = pn_invoice_id
4644: --Add by Chong for bug#13358557 08-NOV-2011, begin
4645: ----------------------------------------------------------------------------------------------
4646: AND jcdt.source_doc_parent_line_no = pn_line_number

Line 4661: jai_cmn_taxes_all jcta

4657: ----------------------------------------------------------------------------------------------
4658: --Modified by Chong for bug#13358557 08-NOV-2011, end
4659: SELECT sum(jamt.tax_amount)
4660: FROM jai_ap_match_inv_taxes jamt,
4661: jai_cmn_taxes_all jcta
4662: WHERE jamt.invoice_id = pn_invoice_id
4663: --Add by Chong for bug#13358557 08-NOV-2011, begin
4664: ----------------------------------------------------------------------------------------------
4665: AND jamt.parent_invoice_line_number = pn_line_number

Line 4676: , jai_cmn_taxes_all jcta

4672: CURSOR get_reversal_entries_cur(pn_invoice_id IN NUMBER, pn_line_number IN NUMBER) IS
4673: SELECT jcta.tax_type, jcdt.tax_amt, aida.invoice_distribution_id,
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

Line 4702: , jai_cmn_taxes_all jcta

4698: UNION ALL
4699: SELECT jcta.tax_type, jamt.tax_amount tax_amt, aida.invoice_distribution_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

Line 4730: , jai_cmn_taxes_all jcta

4726: CURSOR get_claim_entries_cur(pn_invoice_id IN NUMBER, pn_line_number IN NUMBER, pn_invoice_payment_id IN NUMBER) IS
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

Line 4764: , jai_cmn_taxes_all jcta

4760: UNION ALL
4761: SELECT jcta.tax_type, jamt.tax_amount tax_amt, aida.invoice_distribution_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