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_TAX_PROCESSING_PKG dependencies on JAI_AP_MATCH_INV_TAXES

Line 1510: from JAI_AP_MATCH_INV_TAXES

1506:
1507:
1508: Cursor check_loc_tax(ln_invoice_id number) is
1509: select 'Y'
1510: from JAI_AP_MATCH_INV_TAXES
1511: where invoice_id = ln_invoice_id ;
1512:
1513: lv_exists varchar2(1) := 'N' ;
1514:

Line 1548: FROM jai_ap_match_inv_taxes jamt

1544: AND jrd.regime_code = jai_constants.service_regime;
1545:
1546: CURSOR get_matched_tax_cur IS
1547: SELECT jamt.tax_amount,jcta.tax_type
1548: FROM jai_ap_match_inv_taxes jamt
1549: , jai_cmn_taxes_all jcta
1550: , jai_rgm_registrations jrr
1551: , jai_rgm_definitions jrd
1552: WHERE jamt.invoice_id = pr_rec.invoice_id

Line 1563: FROM ap_invoice_lines_all line, jai_ap_match_inv_taxes jamt

1559: AND jrd.regime_code = jai_constants.service_regime;
1560:
1561: CURSOR get_match_item_cur IS
1562: SELECT line.match_type,line.line_number
1563: FROM ap_invoice_lines_all line, jai_ap_match_inv_taxes jamt
1564: WHERE line.invoice_id = pr_rec.invoice_id
1565: and jamt.invoice_id=line.invoice_id
1566: and jamt.invoice_distribution_id=pr_rec.invoice_distribution_id
1567: and jamt.po_distribution_id=pr_rec.po_distribution_id