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_REVERSE_CHARGE_PKG dependencies on JAI_CMN_TAXES_ALL

Line 680: jai_cmn_taxes_all tax

676: tax.tax_rate,
677: tax.tax_type
678: FROM ap_invoice_lines_all ap_line,
679: ap_invoice_distributions_all ap_dist,
680: jai_cmn_taxes_all tax
681: WHERE ap_line.invoice_id = ap_dist.invoice_id
682: AND ap_dist.invoice_distribution_id = pn_distribution_id
683: AND ap_dist.invoice_line_number = ap_line.line_number
684: AND ap_dist.line_type_lookup_code = 'MISCELLANEOUS'

Line 696: FROM jai_ap_match_inv_taxes jamt, jai_cmn_taxes_all jcta

692: jamt.invoice_id,
693: jamt.tax_amount tax_amt,
694: jcta.tax_rate,
695: jcta.tax_type
696: FROM jai_ap_match_inv_taxes jamt, jai_cmn_taxes_all jcta
697: WHERE jamt.invoice_id = pn_invoice_id
698: AND jamt.parent_invoice_line_number = pn_line_number
699: AND jamt.invoice_distribution_id = pn_distribution_id
700: AND jamt.tax_id = jcta.tax_id

Line 1235: JAI_CMN_TAXES_ALL tax

1231: CURSOR c_reverse_charge_flag IS
1232: SELECT 'Y'
1233: FROM AP_INVOICE_LINES_ALL ap_line,
1234: AP_INVOICE_DISTRIBUTIONS_ALL ap_dist,
1235: JAI_CMN_TAXES_ALL tax
1236: WHERE ap_line.invoice_id = ap_dist.invoice_id
1237: AND ap_dist.invoice_distribution_id = pn_distribution_id
1238: AND ap_dist.invoice_line_number = ap_line.line_number
1239: AND ap_dist.line_type_lookup_code = 'MISCELLANEOUS'

Line 1283: JAI_CMN_TAXES_ALL tax

1279: CURSOR c_reverse_charge_flag IS
1280: SELECT 'Y'
1281: FROM AP_INVOICE_LINES_ALL ap_line,
1282: AP_INVOICE_DISTRIBUTIONS_ALL ap_dist,
1283: JAI_CMN_TAXES_ALL tax
1284: WHERE ap_line.invoice_id = ap_dist.invoice_id
1285: AND ap_dist.invoice_distribution_id = pn_distribution_id
1286: AND ap_dist.invoice_line_number = ap_line.line_number
1287: AND ap_dist.line_type_lookup_code = 'MISCELLANEOUS'

Line 1503: JAI_CMN_TAXES_ALL jct

1499: sum(nvl(jrr.debit_amount, 0)) debit_amount,
1500: sum(nvl(jrr.trx_debit_amount, 0)) trx_debit_amount
1501: FROM jai_rgm_trx_records jrr,
1502: jai_rgm_trx_refs jrf,
1503: JAI_CMN_TAXES_ALL jct
1504: Where jrr.reference_id = jrf.reference_id
1505: AND jrr.settlement_id = pn_settlement_id
1506: AND jrf.source = jai_constants.source_ap
1507: AND jrr.source = jai_constants.source_ap

Line 1867: JAI_CMN_TAXES_ALL jct

1863: sum(nvl(jrr.debit_amount, 0)) debit_amount,
1864: sum(nvl(jrr.trx_debit_amount, 0)) trx_debit_amount
1865: FROM jai_rgm_trx_records jrr,
1866: jai_rgm_trx_refs jrf,
1867: JAI_CMN_TAXES_ALL jct
1868: Where jrr.reference_id = jrf.reference_id
1869: AND jrr.settlement_id = pn_settlement_id
1870: AND jrf.source = jai_constants.source_ap
1871: AND jrr.organization_id = nvl(p_organization_id,jrr.organization_id)